Systems and methods for extracting data sets from an online...

Details Systems and methods for extracting data sets from an online... Systems and methods for extracting data sets from an online...

2004-07-15

2009-10-06

Rones, Charles (Department: 2164)

Data processing: database and file management or data structures

Database design

Data structure types

C707S793000, C707S793000, C707S793000, C709S224000

Reexamination Certificate

active

07599903

ABSTRACT:
Systems and methods are provided for extracting data sets from an online relational database into a data warehouse. A data query based on special timestamping technique is executed. Timestamping allows extraction of only these data sets that have changed since the last extraction point. The data sets that have been already imported stay unchanged and do not need to be deleted at the time of the new import. Extraction interval of data sets including a time window enclosed by lower and upper limits is defined. The extracted data sets that have been imported twice may be filtered out with the use of, for example, an operational data store (ODS) objects. The filtered out data sets may be available in the data warehouse for the drilldown reporting.

REFERENCES:
patent: 6125368 (2000-09-01), Bridge et al.
patent: 6895471 (2005-05-01), Tse et al.
patent: 7035922 (2006-04-01), Parham
patent: 2002/0140729 (2002-10-01), Price et al.
patent: 2004/0236746 (2004-11-01), Lomet
patent: 2007/0136330 (2007-06-01), Lecheler-Moore et al.
Prabhu Ram et al., “Extracting Delta for Incremental Data Warehouse Maintenance,” Data Engineering, 2000. Proceedings 16thInternational Conference, San Diego, CA, Feb. 29-Mar. 3, 2000, Los Alamitos, CA, IEEE Computer Soc. , Feb. 29, 2000, pp. 220-229.
David L. Mills, “Internet Time Synchronization: The Network Time Protocol,” IEEE Transactions on Communications, vol. 39, No. 10, Oct. 1, 1991, pp. 1482-1493.
PCT International Search Report and Written Opinion, dated Feb. 21, 2005, 14 pages.

Affiliated with

Also associated with

Rating

Systems and methods for extracting data sets from an online... does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Systems and methods for extracting data sets from an online..., we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Systems and methods for extracting data sets from an online... will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-4120147