Method for database consolidation and database separation
원문보기
IPC분류정보
국가/구분
United States(US) Patent
등록
국제특허분류(IPC7판)
G06F-007/20
G06F-007/04
출원번호
US-0831574
(2007-07-31)
등록번호
US-8103704
(2012-01-24)
발명자
/ 주소
Abrams, Helene
출원인 / 주소
ePrentise, LLC
인용정보
피인용 횟수 :
8인용 특허 :
51
초록
Methods for consolidating databases while maintaining data integrity are disclosed. A source database and target database are compared, and consolidated, and the consolidated databases are used. In other examples, a database is split to support divested entities.
대표청구항▼
1. A method for consolidating at least one source database and one target database into a consolidated database using a computer, the method comprising: identifying one or more source databases, the source databases including source metadata, source data values, source business processes, and source
1. A method for consolidating at least one source database and one target database into a consolidated database using a computer, the method comprising: identifying one or more source databases, the source databases including source metadata, source data values, source business processes, and source business rules;identifying a target database, the target database including target metadata, target data values, target business processes, and target business rules;discovering the source metadata to be included in the consolidated database;identifying differences between at least one source metadata and the target metadata;resolving any conflicts between at least one source metadata and the target metadata based on the identified differences;defining a metadata of the consolidated database based on at the least one source metadata, the target metadata, and the resolved conflicts between the source metadata and the target metadata;identifying the source data values of at least one source to be included in the consolidated database;identifying differences between the source data values and the target data values;resolving any conflicts between the source data values and the target data values based on the identified differences;defining data values of the consolidated database based on the source data values, the target data values and the resolved conflicts between the source data values and the target data values;discovering the source business processes and source business rules of at least one source;identifying the target business processes and target business rules;comparing differences in source business processes and source business rules and the target business processes and target business rules;resolving any conflicts between the source business processes and source business rules and the target business processes and target business rules based on the comparison;defining consolidated business processes and consolidated business rules of the consolidated database based on the source business processes, source business rules, the target business processes, and the target business rules, and the resolved conflicts between the source business processes and source business rules and the target business processes and target business rules;wherein resolving conflicts between the source metadata and target metadata, source data values and target data values, further comprises mining every property of the source database and target database; and wherein the mining of database objects is based on a rule set automatically derived from the analysis of the source database and of the target database; andwherein mining the databases further comprises dynamically and automatically analyzing and comparing each of the one or more source database objects and values with the corresponding target database objects and values, and for each comparison determining which source database objects and target database objects are identical; and wherein at least one source and target database object are determined to be duplicates because the one or more source database objects and values and target database objects and values are identical; and automatically reconciling duplicate database objects by merging the duplicates into a single consolidated database object with corresponding metadata based on the consolidated business rules; andwherein at least one source and target database object are determined to be non-duplicates because the one or more source database objects and values and target database objects and values are not identical; and automatically reconciling non-duplicate database objects by creating an instance of a consolidated database object with associated metadata based on the consolidated business rules; andwhen at least one conflict between the source database object and target database object is not resolved a request for conflict resolution is automatically posted to a user for reconciliation; andconsolidating the at least one source database and target database into the consolidated database based on the consolidated metadata, consolidated data values, and consolidated business processes and consolidated business rules; wherein consolidating the at least one source database and target database into a consolidated database comprises applying at least one rule selected from the group consisting of an entity in a given layer never references an entity in a lower level, and all references from an entity are on the same or higher levels; and further comprising determining the sequence of consolidating data and wherein consolidating data initiates with at least one of the group consisting of seed data, codes data, configuration data, master data, and transaction data; andstoring the consolidated, database in a memory. 2. The method of claim 1 wherein the metadata objects to be included in the consolidated database are automatically compared using a series of rules to compare database objects. 3. The method of claim 1 wherein the metadata objects to be included in the consolidated database are automatically created or changed using a series of metadata rules to create database objects. 4. The method of claim 1 wherein when the source data value is exactly identical to the target data value, the method further comprises; mapping the data values of the at least one source database to the data values of the target database, and wherein when the source data values and the target data values are not identical, the method further comprises defining the data values to be included in the consolidated database. 5. The method of claim 1 further comprising: standardizing non-identical data values that have the same contextual meaning or are synonyms wherein standardizing comprises eliminating punctuation or capitalization and standardizing abbreviations, codes, and nomenclature for data values. 6. The method of claim 1 further comprising: comparing at least one data value to another data value to identify candidate duplicate data values wherein a duplicate data value represents the same real-world entity and a set of two or more data records that represent a single real-world entity is called a duplicate set;identifying candidate duplicate data values by a series of duplicate criteria or user-defined rules;merging duplicate records; andpopulating the resolved duplicate data records into the consolidated database. 7. The method of claim 1 further comprising conflicts are resolved using at least one rule using Boolean logic. 8. The method of claim 1 further comprising receiving at least one user input, and wherein at least one candidate duplicate conflict is resolved responsive to the user input. 9. The method of claim 8 wherein receiving the user input comprises: presenting the conflict to at least one user; requesting conflict resolution based on the presenting;and receiving a conflict resolution input from the user. 10. The method of claim 1 further comprising: populating the consolidated destination database with the data values from the at least one source database and the target database with resolved duplicates, consistent data value formats, and unique data values. 11. The method of claim 1 further comprising: identifying the database objects that enforce at least one of a business process and a business rule in the at least one source database;identifying the database objects that enforce at least one of a business process and a business rule in the at least one source database in the target database;determining which at least one of the business process and business rule creates, reads, updates, and deletes each database object in the at least one source database and the target database. 12. The method of claim 11 whereby business processes or business rules that create, read, update, or delete (CRUD) each database object are considered similar business processes or rules. 13. The method of claim 11 wherein similar business processes or business rules are one or more of the group comprising: (a) business processes or business rules that have the same input and output data and work flows, or(b) business processes or business rules that have the same predecessor, successor, and parent processes, or(c) business processes or business rules that have the same control constructs, or(d) business processes or business rules that have the same triggering controls, or(e) business processes or business rules that have the same conditional controls, or(g) business processes or business rules that have the same sequencing controls, or(h) business processes or business rules that have the same concurrence controls, or(i) business processes or business rules that have the same repetition controls, or(j) business processes or business rules that have the same pausing controls, or(k) business processes or business rules that have the same resuming controls. 14. The method of claim 1 wherein the target database is associated with at least one of the group consisting of an acquired company and an acquiring company, and wherein the source database is associated with at least one of the group consisting of an acquired company and an acquiring company.
연구과제 타임라인
LOADING...
LOADING...
LOADING...
LOADING...
LOADING...
이 특허에 인용된 특허 (51)
Henrickson, David L.; Eisen, Eiko, Apparatus and method for transferring information between platforms.
Deran Roger L. (1958 Menalto Ave. Menlo Park CA 94025), Entity-attribute value database system with inverse attribute for selectively relating two different entities.
Shigekazu Inohara JP; Toyohiko Kagimasa JP; Fumio Noda JP; Yoshimasa Masuoka JP; Jinghua Min JP, File format conversion method, and file system, information processing system, electronic commerce system using the method.
Adair John G. (Austin TX) Coyle ; Jr. Daniel J. (San Jose CA) Grafe Robert J. (Austin TX) Lindsay Bruce G. (San Jose CA) Reinsch Roger A. (Cupertino CA) Resch Robert P. (Byron MN) Selinger Patricia G, Heterogenous database communication system in which communicating systems identify themselves and convert any requests/r.
Budhiraja,Navin; Skeen,Marion Dale; Wang,Haiying; Rubin,Elisa Jill; Banerjee,Deb, Integrated business process modeling environment and models created thereby.
Havrda, Robert D.; Tacker, Bryan P.; Berry, Todd A.; McBride, Steven; Shaw, Neil R., Method and apparatus for automatically synchronizing data to destination media.
Stolfo Salvatore J. (80 Kenilworth Rd. Ridgewood NJ 07450), Method and apparatus for imaging, image processing and data compression merge/purge techniques for document image databa.
Adair John G. (Austin TX) Coyle ; Jr. Daniel J. (Los Gatos CA) Grafe Robert J. (Austin TX) Lindsay Bruce G. (San Jose CA) Reinsch Roger A. (Cupertino CA) Resch Robert P. (Byron MN) Selinger Patricia , Method and combination for minimizing data conversions when data is transferred between a first database storing data in.
Demers Richard A. (Rochester MN) Lindsay Bruce G. (San Jose CA) Reinsch Roger A. (Cupertino CA) Zimowski Melvin R. (San Jose CA), Method and system for describing and exchanging data between heterogeneous database systems with data converted by the r.
Knutson, James I.; Truty, Gregory L.; Van Oosten, James L., Method and system for implementing collection program interface for accessing a collection of data associated with a legacy enumeration application interface.
Kukura, Robert Allen; Salamone, Julie Ann; Witham, Jr., Ronald Clarke, Method and system for providing object references in a distributed object environment supporting object migration.
Johnson Gary Duane (Lewisville TX) Campbell Kelly Scott (Richardson TX), Method for extracting pre-defined data items from medical service records generated by health care providers.
Shen Hwa N. (Scotia NY) Premerlani William J. (Scotia NY) Blaha Michael R. (Niskayuna NY), Method for transforming relational data base schemas into object models using ideal table meta models.
Heffernan John S. (Acton MA) Savage Peter L. (Mont Vernon NH) Pittman Steven J. (Arlington MA) Sunkara Ramu V. (Nashua NH), Methods and apparatus for accesssing non-relational data files using relational queries.
Furegati Rene Anton,CHX ; Schneider Heinrich,CHX ; Streckeisen Heinrich Adolf Anandan,CHX, Storage plane organization and storage systems based thereon using queries and subqueries for data searching.
Nagy Michael E., System for translating native data structures and specific message structures by using template represented data structures on communication media and host machines.
Kamireddy, Nagaraja R.; Soundarapandian, Dhinakaran; Konduri, Sai Ramesh J. Rao; Kochuthresia, Prince V.; Nair, Divya Gopalakrishnan, Methods and systems for staging and propagating data.
※ AI-Helper는 부적절한 답변을 할 수 있습니다.