Method and apparatus for loading data files into a...

Data processing: database and file management or data structures – File or database maintenance – Database backup

Reexamination Certificate

Rate now

  [ 0.00 ] – not rated yet Voters 0   Comments 0

Details

C707S641000, C707S649000

Reexamination Certificate

active

07984019

ABSTRACT:
Date-warehouse systems are populated using an enhanced Extraction-Load-Transform (ETL) process and system by employing three ideas: Out-of-order-fill ETL, relative-ordering index (ROI), and dependent queries. Out-of-order-fill ETL allows a data warehouse to accept the loading of data files in any order, and does not require the loading of any previous backup data files in order to provide some functionality to end users under the view that some functionality or data access is better than none at all. Dependent queries are processes that use defined data structures for use in constructing, extracting, and validating each record to be written in said data-warehouse system in order to ensure that referential integrity is maintained and that no orphaned data is pushed into the data warehouse. Finally, ROI is a process wherein a value is determined, based on the constraints of the source data, which indicates the relative newness of the data.

REFERENCES:
patent: 5864851 (1999-01-01), Breitbart et al.
patent: 6912549 (2005-06-01), Rotter et al.
patent: 2003/0195877 (2003-10-01), Ford et al.
patent: 2005/0080821 (2005-04-01), Breil et al.
patent: 2005/0147947 (2005-07-01), Cookson et al.
patent: 2005/0222989 (2005-10-01), Haveliwala et al.
patent: 2006/0031268 (2006-02-01), Shutt et al.
patent: 2006/0195461 (2006-08-01), Lo et al.
patent: 2006/0242205 (2006-10-01), Schmidt et al.
patent: 2009/0177647 (2009-07-01), Oliver et al.
patent: 2009/0307184 (2009-12-01), Inouye et al.
patent: 2010/0030750 (2010-02-01), Oliver
M. Kaczmarski; Beyond Backup Toward Storage Management; 2003; IBM Business Jourbal;pp. 322-337.
Heather McCallum-Bayliss, Identity Resolution in a Global Environment: Fishing for People in a Sea of Names, 2004 IEEE, pp. 21-26.
Hector Garcia-Molina, Entity Resolution: Overview and Challenges, 2004, pp. 1-2.
Hector Garcia-Molina, Pair-wise entity resolution: Overview and challenges, 2006 ACM, p. 1.
Lu et al, Query evaluation and optimization in deductive and object-oriented spatial databases, 1995IST, pp. 131-143.

LandOfFree

Say what you really think

Search LandOfFree.com for the USA inventors and patents. Rate them and share your experience with other people.

Rating

Method and apparatus for loading data files into a... 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 apparatus for loading data files into a..., we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Method and apparatus for loading data files into a... will most certainly appreciate the feedback.

Rate now

     

Profile ID: LFUS-PAI-O-2625390

  Search
All data on this website is collected from public sources. Our data reflects the most accurate information available at the time of publication.