DATABASE MANAGEMENT SYSTEM AND METHOD
A database management system and method are provided. In one example, the database management system may include a source database, a target database, and a replication system operable to identify a difference in structure between the source database and the target database and change the structure of the target database to correspond to the structure of the source database. In such an example, the structure of the target database may be alternatively changed manually. In another example, the source database may include structure and data, and the replication system may be operable to replicate at least one of the structure and the data to the target database without storing the at least one of the structure and the data in an intervening database as the at least one of the structure and the data is transmitted from the source database to the target database.
1 . A database management system, comprising:
a source database including source structure having a first configuration;
a target database including target structure having a second configuration; and
a replication system including a structural replication component adapted to identify a difference between the first configuration of the source structure and the second configuration of the target structure, wherein the difference is one of a plurality of types of differences, and wherein the structural replication component is adapted to create a structural element dependent on the one of the plurality of types of differences between the first and second configurations;
wherein the structural replication component applies the structural element to the target database to change the target structure of the target database from having the second configuration to having the first configuration.
2 . The database management system of claim 1 , wherein the source database is a first type of database and the target database is a second type of database different than the first type of database.
3 . The database management system of claim 1 , wherein the target database is one of a plurality of types of databases, and wherein the structural replication component is adapted to create the structural element dependent on the one of the plurality of types of target databases.
4 . The database management system of claim 1 , wherein the source database includes a source data dictionary and the target database includes a target data dictionary, and wherein the structural replication component communicates with both the source data dictionary and the target data dictionary to identify the difference between the first configuration of the source database and the second configuration of the target database.
5 . The database management system of claim 4 , wherein the source data dictionary includes source schema associated with the source structure having the first configuration and the target data dictionary includes target schema associated with the target structure having the second configuration, and wherein the structural replication component retrieves both the source schema and the target schema and compares the source schema and the target schema to identify the difference between the first configuration and the second configuration.
6 . The database management system of claim 1 , wherein the replication system further comprises a scheduler in communication with the structural replication component, and wherein the scheduler communicates with the structural replication component to initiate the structural replication component.
7 . The database management system of claim 1 , wherein the structural replication component is initiated by a user.
8 . The database management system of claim 1 , wherein the structural replication component is initiated by the database management system when a structural change occurs to the source database.
9 . The database management system of claim 1 , wherein after the structural replication component applies the structural element to the target database to change the target database from having the second configuration to having the first configuration, the structural replication component checks for any remaining differences between the source structure and the target structure.
10 . The database management system of claim 9 , wherein the replication system generates an activity report including the change to the target database performed by the structural replication component, and wherein the replication system sends the activity report to an output.
11 . The database management system of claim 1 , wherein the replication system further comprises a queue, and wherein the structural replication component generates queue structure for the queue, the queue structure having the first configuration.
12 . The database management system of claim 1 , wherein the replication system further comprises a queue including queue structure having the second configuration, and wherein the structural replication component changes the queue structure from having the second configuration to having the first configuration.
13 . The database management system of claim 1 , wherein the replication system further comprises a queue including queue structure having a third configuration at least different than the first configuration, and wherein the structural replication component changes the queue structure from having the third configuration to having the first configuration.
14 . The database management system of claim 1 , wherein the plurality of types of differences comprise new structure, modified structure, and deleted structure, and wherein the difference is one of new structure, modified structure, and deleted structure.
15 . The database management system of claim 14 , wherein
the structural element adds structure to the target structure to change the target database from having the second configuration to the first configuration when the difference comprises new structure,
the structural element modifies structure of the target structure to change the target database from having the second configuration to the first configuration when the difference comprises modified structure, and
the structural element deletes structure from the target structure to change the target database from having the second configuration to the first configuration when the difference comprises deleted structure.
16 . A database management system, comprising:
a source database including source structure having a first configuration;
a target database including target structure having a second configuration; and
a replication system including a structural replication component adapted to identify a difference between the first configuration of the source structure and the second configuration of the target structure, wherein the difference is one of a plurality of types of differences;
wherein the target structure of the target database can be changed from having the second configuration to having the first configuration either manually by manual interaction or automatically by the structural replication component.
17 . The database management system of claim 16 , wherein the source database is a first type of database and the target database is a second type of database different than the first type of database.
18 . The database management system of claim 16 , wherein, when the target structure is changed automatically, the structural replication component is adapted to create a structural element dependent on the one of the plurality of types of differences between the first and second configurations, and wherein the structural replication component applies the structural element to the target database to change the target database from having the second configuration to having the first configuration.
19 . The database management system of claim 18 , wherein the source database includes a source data dictionary and the target database includes a target data dictionary, and wherein the structural replication component communicates with both the source data dictionary and the target data dictionary to identify the difference between the first configuration of the source database and the second configuration of the target database.
20 . The database management system of claim 19 , wherein the source data dictionary includes source schema associated with the source structure having the first configuration and the target data dictionary includes target schema associated with the target structure having the second configuration, and wherein the structural replication component retrieves both the source schema and the target schema and compares the source schema and the target schema to identify the difference between the first configuration and the second configuration.
21 . The database management system of claim 18 , wherein the replication system further comprises a queue, and wherein the structural replication component generates queue structure for the queue, the queue structure having the first configuration.
22 . The database management system of claim 18 , wherein the replication system further comprises a queue including queue structure having the second configuration, and wherein the structural replication component changes the queue structure from having the second configuration to having the first configuration.
23 . The database management system of claim 18 , wherein the replication system further comprises a queue including queue structure having a third configuration at least different than the first configuration, and wherein the structural replication component changes the queue structure from having the third configuration to having the first configuration.
24 . The database management system of claim 18 , wherein the plurality of types of differences comprise new structure, modified structure, and deleted structure, and wherein the difference is one of new structure, modified structure, and deleted structure.
25 . The database management system of claim 24 , wherein
the structural element adds structure to the target structure to change the target database from having the second configuration to the first configuration when the difference comprises new structure,
the structural element modifies structure of the target structure to change the target database from having the second configuration to the first configuration when the difference comprises modified structure, and
the structural element deletes structure from the target structure to change the target database from having the second configuration to the first configuration when the difference comprises deleted structure.
26 . The database management system of claim 16 , wherein, when the target structure is changed manually, the replication system generates a reconciliation report including the difference identified by the structural replication component and the replication system sends the reconciliation report to an output such that a user is informed of the manual interaction to change the target structure from having the second configuration to having the first configuration.
27 . A database management system, comprising:
a source database including structure and data, the structure comprising a table and the data comprising a data record in the table;
a target database; and
a replication system including at least one of a structural replication component adapted to replicate structure and a data replication component adapted to replicate data;
wherein the replication system is operable to replicate at least one of the structure and the data from the source database to the target database without storing the at least one of the structure or the data in an intervening database as the at least one of the structure and the data is transmitted from the source database to the target database.
28 . The database management system of claim 27 , wherein the replication system further comprises a queue, and wherein the structural replication component generates queue structure for the queue, the queue structure having the first configuration.
29 . The database management system of claim 27 , wherein the replication system further comprises a queue including queue structure having the second configuration, and wherein the structural replication component changes the queue structure from having the second configuration to having the first configuration.
30 . The database management system of claim 27 , wherein the replication system further comprises a queue including queue structure having a third configuration at least different than the first configuration, and wherein the structural replication component changes the queue structure from having the third configuration to having the first configuration.