Database driven type extensibility

• US 7,370,051 B2
• Filed: 06/24/2003
• Issued: 05/06/2008
• Est. Priority Date: 06/24/2003
• Status: Expired due to Fees

• Current Assignee: Microsoft Technology Licensing LLC (Microsoft Corporation)
• Original Assignee: Microsoft Corporation
• Inventors: Don, Cliff M. R., Lemarchand, Remi A. J., Mayans, Jason C.
• Primary Examiner(s): Vo; Tim
• Assistant Examiner(s): Morrison; Jay A
• Application Number:
  US10/602,126
• Publication Number:
  US 20040267755A1
• Time in Patent Office: 1,778 Days
• Field of Search: 707 1-206, 707/10, 707/103.X, 709201-253, 711 1-221
• US Class Current: 707/690
• CPC Class Codes: G06F 16/25 Integrating or interfacing systems involving database management systems
• CPC Class Codes: Y10S 707/954 Relational
• CPC Class Codes: Y10S 707/955 Object-oriented
• CPC Class Codes: Y10S 707/99944 Object-oriented database structure
• CPC Class Codes: Y10S 707/99952 Coherency, e.g. same view to multiple users
• CPC Class Codes: Y10S 707/99953 Recoverability

Abstract

Data types can be created, modified and deployed in multi-tier database systems by using extended assemblies. The extended assemblies are created by a back end server using the data and code contained in special tables and object tables of the back end server. The back end server determines which data types are to be deployed in the system, based on push or pull conditions. Thereafter, the corresponding extended assemblies are to be obtained and sent to one or more middle tier servers that utilize the extended assemblies to use the data types. However, some of the middle tier servers may need to be configured with appropriate logic modules prior to utilizing the extended assemblies. A data type can be created or modified by creating or editing data and code contained in the special table and object tables prior to creating the extended assemblies.

Claims

1. In a multi-tier server system that includes a back end server at a first tier and a plurality of additional servers at a middle tier, each additional server using multiple types of data objects that must be defined on the plurality of additional servers before the data objects can be used by the plurality of middle tier servers, a method for deploying one or more data types from the back end server to the plurality of middle tier servers in a manner that maintains consistency and compatibility in the definitions of the data types and in code associated with each data type as stored on each middle tier server in the system, the method comprising:

an act of creating a special table in a database of the back end server, the special table including a plurality of data elements storing data identifying data types used by the plurality of middle tier servers, each data element including;

a data type identification field;

a code field containing any code necessary for enabling use of a corresponding data type; and

a link to one or more data type specific tables containing information further defining the corresponding data type,

wherein the database of the back end server acts as a repository for each data type used by any of the plurality of middle tier servers, and the back end server acts as a single and centralized source from which each of the plurality of middle tier servers obtains all data types used by any other of the plurality of middle tier servers and the corresponding code required to enable use of the data types by the plurality of middle tier servers, and such that the plurality of middle tier servers each obtain all data types from the single and centralized source which operates at a different tier than the plurality of middle tier servers;

an act of identifying a data type to be deployed from the back end server to one or more of the plurality of middle tier servers;

an act of obtaining an extended assembly that corresponds to the data type to be deployed, the extended assembly including data obtained using the special table, including data identifying the data type, one or more definitions of the data type, and the code for enabling processing of data corresponding to the data type, the extended assembly being generated after the act of identifying the data type to be deployed; and

an act of transmitting the extended assembly to the one or more middle tier servers of the plurality of middle tier servers in the multi-tier system such that the data type, as transmitted to and received by the one or more of the plurality of middle tier servers in the multi tier system, is consistent and compatible with a data type of the same kind stored on other middle tier servers in the system.

2. A method as recited in claim 1, further including an act of creating logic modules in one or more of the plurality of middle tier servers that enable the one or more of the plurality of middle tier servers to query for the extended assembly.

3. A method as recited in claim 1, wherein the back end server includes a relational database.

4. A method as recited in claim 3, wherein the back end server comprises an SQL server.

5. A method as recited in claim 1, wherein the one or more of the plurality of middle tier servers includes an email server.

6. A method as recited in claim 1, wherein the act of identifying the data type to be deployed includes determining that the one or more of the plurality of middle tier servers has requested the extended assembly, since the one or more of the plurality of middle tier servers are not yet enabled for the data type.

7. A method as recited in claim 6, further including an act of adding a new middle tier server to the multi-tier system, and wherein the new middle tier server comprises the one or more of the plurality of middle tier servers that has requested the extended assembly.

8. A method as recited in claim 1, further including an act of creating one or more object tables that are linked to the special table and that include additional information defining the data type to be deployed, such that the extended assembly also includes the additional information.

30. A method as recited in claim 1, wherein the extended assembly is a single data structure that includes all the data required to enable the one or more of the plurality of middle tier servers to use the data type.

31. A method as recited in claim 1, wherein the one or more of the plurality of middle tier servers have limited program code means to process data associated with less than all of the data types in the multi-tier system, and the back end server has all program code means to process any data associated with all of the data types in the multi-tier system.

32. A method as recited in claim 31, wherein the one or more of the plurality of middle tier servers are only equipped to recognize and process data objects associated with a particular data type when program code means comprising executable machine code of the extended assembly for the particular data type has been received from the back end server and installed at the one or more of the plurality of middle tier servers.

9. In a multi-tier server system that includes a back end server at a first tier and a plurality of additional servers at a middle tier, each additional server using multiple types of data objects that must be defined on the plurality of additional servers before the data objects can be used by the plurality of middle tier servers, a method for deploying one or more data types from the back end server to the plurality of middle tier servers in a manner that maintains consistency and compatibility in the definitions of the data types and in code associated with each data type as stored on each middle tier server in the system, the method comprising:

an act of modifying a special table in a database of the back end server, the special table including a plurality of data elements storing data that identifies data types used by the plurality of middle tier servers and includes;

a data type identification field;

a code field containing any code necessary for enabling use of a corresponding data type; and

a link to one or more data type specific tables containing information further defining the corresponding data type,

wherein the database of the backend server acts as a repository for each data type used by any of the plurality of middle tier servers, and the back end server acting as a single and centralized source from which all middle tier servers obtain all data types used by any other of the plurality of middle tier servers and the corresponding code required to enable use of the data types by the plurality of middle tier servers, and such that the plurality of middle tier servers each obtain all data types from the single and centralized source which operates at a different tier than the plurality of middle tier servers, the act of modifying including at least one of modifying the stored data within the one or more fields and adding new stored data to the one or more fields;

an act of identifying a data type to be deployed from the back end server to one or more of the plurality of middle tier servers;

an act of obtaining an extended assembly that corresponds to the data type to be deployed, the extended assembly including at least one of the modified stored data and the new stored data as obtained from the special table, including data identifying the data type, and the executable code that, when executed, enables the one or more middle tier servers to process the modified stored data or the new stored data associated with the data type; and

an act of transmitting the extended assembly to the one or more middle tier servers of the plurality of middle tier servers in the multi-tier system such that the data type as transmitted to and received by the one or more of the plurality of middle tier servers in the multi tier system is consistent and compatible with a data type of the same kind stored on other middle tier servers in the system.

10. A method as recited in claim 9, further including an act of determining which of the plurality of middle tier servers should be sent the extended assembly.

11. A method as recited in claim 10, wherein determining which of the plurality of middle tier servers should be sent the extended assembly comprises the acts of:

sending data associated with the data type to the one or more of the plurality of middle tier servers; and

receiving one or more requests for the extended assembly from the one or more of the plurality of middle tier servers upon the one or more of the plurality of middle tier servers identifying that the data associated with the data type cannot be processed at the one or more of the plurality of middle tier servers.

12. A method as recited in claim 9, wherein the back end server includes a relational database.

13. A method as recited in claim 9, wherein the back end server comprises an SQL server.

14. A method as recited in claim 9, wherein the one or more of the plurality of middle tier servers includes an email server.

15. A method as recited in claim 9, wherein the act of modifying includes adding new stored data corresponding to a new data type not previously enabled in the multi-tier system prior to adding the new stored data.

16. In a multi-tier server system that includes a back end server at a first tier and a plurality of additional servers at a middle tier, each additional server using multiple types of data objects that must be defined on the plurality of additional servers before the data objects can be used by the plurality of middle tier servers, a method for deploying one or more data types from the back end server to the plurality of middle tier servers in a manner that maintains consistency and compatibility in the definitions of the data types and in code associated with each data type as stored on each middle tier server in the system, the method comprising:

an act of adding a new middle tier server to the multi-tier system, the new middle tier server being configured to utilize extended assemblies that are obtained from the back end server, the back end server acting as a repository for storing each data type used by any of the plurality of middle tier servers, the back end server acting as a single and centralized source from which all middle tier servers obtain all data types used by any other of the plurality of middle tier servers and corresponding code required to enable use of the data types by the plurality of middle tier servers, and such that the plurality of middle tier servers each obtain all data types from the single and centralized source which operates at a different tier than the plurality of middle tier servers, the extended assemblies being configured to enable the use of one or more data types that are defined by data and enabled by executable code that is contained in the extended assemblies;

an act of determining which of the one or more data types are to be deployed from the back end server to the new middle tier server, wherein the act of determining is based at least in part on a request by the new middle tier server for data to enable use of one or more data types;

an act of obtaining one or more extended assemblies corresponding to the one or more data types that have been determined to be deployed, each of the one or more extended assemblies including data and executable code obtained from a special table stored in a database of the back end server, the special table including a plurality of data elements storing data identifying data types and corresponding code for processing data associated with the data types, each data element including;

a data type identification field;

a code field containing any code necessary for enabling use of a corresponding data type; and

a link to one or more data type specific tables containing information further defining the corresponding data type; and

an act of transmitting, to the new middle tier server, the one or more extended assemblies that correspond to the one or more data types that have been determined to be deployed, such that the one or more data types as transmitted to, and received by, the new middle tier server are consistent and compatible with one or more data types of the same kind on other middle tier servers in the system, and which were received by the other middle tier servers from the back end server.

17. A method as recited in claim 16, wherein the act of determining is further based at least in part on the new middle tier server identifying what other data types are supported, and identifying that the one or more data types to be deployed are not supported at the new middle tier server.

18. In a multi-tier server system that includes a back end server at a first tier and a plurality of additional servers at a middle tier, each additional server using multiple types of data objects that must be defined on the plurality of additional servers before the data objects can be used by the plurality of middle tier servers, a method for deploying one or more data types from the back end server to the plurality of middle tier servers in a manner that maintains consistency and compatibility in the definitions of the data types and in code associated with each data type as stored on each middle tier server in the system, the method comprising:

an act of creating a special table in a database of the back end server, the special table including a plurality of data elements for storing data identifying a data type used by the plurality of middle tier servers, each data element including;

data type identification field;

a code field containing any executable code necessary for enabling processing of data associated with the corresponding data type; and

a link to one or data type specific tables containing information further defining the corresponding data type,

wherein the database of the back end server acts as a repository for storing each data type used by any of the plurality of middle tier servers, and the back end server acting as a single and centralized source from which all middle tier servers obtain all data types used by any other of the plurality of middle tier servers and the corresponding code required to enable use of the data types by the plurality of middle tier servers, and such that the plurality of middle tier servers each obtain all data types from the single and centralized source which operates at a different tier than the plurality of middle tier servers;

a step for deploying the data type from the back end server to one or more of the plurality of middle tier servers, upon request, such that the data type as transmitted to and received by the one or more of the plurality of middle tier servers in the multi-tier server system is consistent and compatible with a data type of the same kind stored on other middle tier servers in the system.

19. A method as recited in claim 18, wherein the step for deploying the data type to the one or more middle tier servers upon request comprises corresponding acts that include:

an act of identifying the data type to be deployed based on receipt of the data type at the one or more of the plurality of middle-tier servers, and the one or more of the plurality of middle-tier servers requesting an extended assembly for the data type since the data type cannot be processed at the one or more of the plurality of middle tier servers;

an act of obtaining an extended assembly that corresponds to the data type to be deployed, the extended assembly including the data from the special table identifying the data type and the executable code for enabling processing of the data associated with the data type; and

an act of transmitting the extended assembly to the one or more of the plurality of middle tier servers in the multi-tier system that requested the extended assembly.

20. A method as recited in claim 19, further including an act of creating logic in the one or more of the plurality of middle tier servers that enables utilization of the extended assembly.

21. A method as recited in claim 19, further including an act of creating at least one object table in the database of the back end server that includes at least some information defining the data type, and wherein the extended assembly includes the at least some information.

22. A computer program product for use in a multi-tier server system that includes a back end server at a first tier and a plurality of additional servers at a middle tier, each additional server using multiple types of data objects that must be defined on the plurality of additional servers before the data objects can be used by the plurality of middle tier servers, the computer program product including one or more computer-readable storage media having stored thereon computer-executable instructions for implementing a method for deploying one or more data types from the back end server to the plurality of middle tier servers in a manner that maintains consistency and compatibility in the definitions of the data types and in code associated with each data type as stored on each middle tier server in the system, the method comprising:

an act of creating a special table in a database of the back end server, the special table including a plurality of data elements storing data identifying data types used by the plurality of middle tier servers, each data element including;

a data type identification field;

a code field containing any code necessary for enabling use of a corresponding data type; and

a link to one or more data type specific tables containing information further defining the corresponding data type,

wherein the database of the back end server acts as a repository storing each data type used by any of the plurality of middle tier servers, and the back end server acting as a single and centralized source from which each of the plurality of middle tier servers obtains all data types used by any other of the plurality of middle tier servers and the corresponding code required to enable use of the data types by the plurality of middle tier servers, and such that the plurality of middle tier servers each obtain all data types from the single and centralized source which operates at a different tier than the plurality of middle tier servers;

an act of identifying a data type to be deployed from the back end server to one or more of the plurality of middle tier servers;

an act of obtaining an extended assembly that corresponds to the data type to be deployed, the extended assembly including data obtained from the special table, including data identifying the data type, one or more definitions of the data type, and the code for enabling processing of data associated with the data type; and

an act of transmitting the extended assembly to one or more of the plurality of middle tier servers in the multi-tier system such that the data type as transmitted to and received by the one or more of the plurality of middle tier servers in the multi tier system is consistent and compatible with a data type of the same kind stored on other middle tier servers in the system.

23. A computer program product as recited in claim 22, wherein the method further includes an act of creating logic modules in the one or more of the plurality of middle tier servers that enable the one or more of the plurality of middle tier servers to query for the extended assembly.

24. A computer program product as recited in claim 22, wherein the back end server includes an SQL server.

25. A computer program product as recited in claim 22, wherein the one or more of the plurality of middle tier servers includes an email server.

26. A computer program product as recited in claim 22, wherein the act of identifying the data type to be deployed includes determining that the one or more of the plurality of middle tier servers has requested the extended assembly, since the one or more of the plurality of middle tier servers are not yet enabled for the data type.

27. A computer program product as recited in claim 22, wherein the method further includes an act of adding a new middle tier server to the multi-tier system, and wherein the new middle tier server comprises the one or more of the plurality of middle tier servers that has requested the extended assembly.

28. A computer program product as recited in claim 22, wherein the method further includes an act of creating one or more object tables that are linked to the special table and that include additional information defining the data type to be deployed, and wherein the extended assembly also includes the additional information.

29. A computer program product as recited in claim 28, wherein the method further includes modifying at least one of the special table and the one or more object tables.

33. At a middle tier server in a multi-tier database server system that includes a back end database server at a first tier and a plurality of additional database servers at a middle tier, wherein the plurality of middle tier servers are configured to process data corresponding to data types defined by the back end server at the first tier, a method for deploying one or more data types from the back end server to the plurality of middle tier servers in a manner that maintains consistency and compatibility in the definitions of the data types and in code associated with each data type in the multi-tier database server system, the method comprising:

an act of receiving at a middle tier email exchange server one or more data objects from a back end SQL server, the one or more received data objects being associated with at least one data type;

an act of initiating one or more processing functions for the one or more received data objects associated with the at least one data type;

an act of identifying that the at least one data type of the one or more data objects is not recognized, such that the initiated one or more initiated processing functions have failed at the middle tier email exchange server;

an act of pulling one or more extended assemblies corresponding to the at least one data type from the back end SQL server, wherein the one or more extended assemblies were generated by the back end SQL server after the SQL server received a request from the middle tier email exchange server to pull the one or more extended assemblies, and in response thereto, wherein the back end SQL server acts as a repository for each data type used by any of the plurality of middle tier servers, as a single and centralized source from which each of the plurality of middle tier servers obtains all extendable assemblies corresponding to all data types used by any other of the plurality of middle tier servers, and as a single and centralized location at which all data types for the middle tier servers are modified, and such that the plurality of middle tier servers each obtain all data types from, and modify all data types at, the single and centralized source which operates at a different tier than the plurality of middle tier servers, and wherein the back end SQL server generates the extended assembly by using a special table in a database of the back end server, the special table including a plurality of data elements storing data identifying data types usedly the plurality of middle tier servers, each data element being specific to a particular data type and including;

a data type identification field having a unique identification for the corresponding data type;

a data name field identifying a name of the corresponding data type;

a code field containing executable code necessary for enabling the middle tier email server to use the corresponding data type; and

a link to at least one data type specific table that contains information further defining the corresponding data type; and

an act of processing the one or more data objects associated with the at least one data type using the pulled one or more extended assemblies, wherein the middle tier email exchange server successfully recognizes the at least one data type, and successfully processes the one or more received data objects associated with the at least one data type.

34. A method as recited in claim 33, wherein the one or more pulled extended assemblies comprise computer-executable instructions that, when executed at the middle tier server, cause one or more processors at the middle tier server to format the one or more data objects so that the one or more data objects can be processed.