Data processing: database and file management or data structures – Database design – Data structure types
Reexamination Certificate
2000-03-14
2003-09-02
Metjahic, Safet (Department: 2171)
Data processing: database and file management or data structures
Database design
Data structure types
Reexamination Certificate
active
06615220
ABSTRACT:
BACKGROUND OF THE INVENTION
1. Field of the Invention
The invention relates to computer systems, and more particularly, to a method and mechanism for consolidating data.
2. Background
Many companies that utilize database systems face the issue of data fragmentation in their database application environments. Fragmentation may occur because of separate installations of the same database products. This data fragmentation presents difficulties for a company that needs to access its data for business intelligence to make global strategic decisions.
For example, as businesses evolve and grow across geographic and logistical boundaries, each new business location may implement its own local database system to 1) support unique business requirements, 2) minimize WAN (wide area network) connectivity costs, or 3) address character set constraints. Because such installations of localized database systems are often driven by immediate needs rather than coordinated efforts, the overall set of data maintained by the company may become fragmented. The greater the number of locations at which separate data is maintained, the greater the possible fragmentation problems with respect to the company's data.
Additionally, data maintained by a company can become fragmented if the data is physically partitioned in multiple product installations in the same database. Such partitioning may occur, for example, using the Multiple Sets of Books Architecture (MSOBA) as utilized by Oracle Applications.
SUMMARY OF THE INVENTION
The present invention is directed to a method and mechanism for consolidating data. According to an embodiment of the invention, consolidation is performed based upon transformation rules established for data to be consolidated. An aspect of an embodiment of the invention relates to performing data transformations to resolve potential consolidation conflict issues. Another aspect of an embodiment of the invention relates to validation procedures performed after transformation.
REFERENCES:
patent: 5278978 (1994-01-01), Demers et al.
patent: 5838965 (1998-11-01), Kavanagh et al.
patent: 6151608 (2000-11-01), Abrams
patent: 6324498 (2001-11-01), Wajda
patent: 6523172 (2003-02-01), Martinez-Guerra et al.
Austin Dawn
Chadalavada Subash
Lotero Richard J.
Noble Kenton E.
Al-hashemi Sana
Bingham & McCutchen LLP
Metjahic Safet
Oracle International Corporation
LandOfFree
Method and mechanism for data consolidation does not yet have a rating. At this time, there are no reviews or comments for this patent.
If you have personal experience with Method and mechanism for data consolidation, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Method and mechanism for data consolidation will most certainly appreciate the feedback.
Profile ID: LFUS-PAI-O-3007750