Data processing: database and file management or data structures – Database design – Data structure types
Reexamination Certificate
2004-10-01
2009-06-02
Alam, Shahid A (Department: 2162)
Data processing: database and file management or data structures
Database design
Data structure types
C715S212000
Reexamination Certificate
active
07542979
ABSTRACT:
The present invention includes an apparatus, method and system for loading data into a database. The invention includes a spreadsheet dataset, having data in the form of one or more records, a control file containing a set of rules, each rule having a condition and a spreadsheet loader. The spreadsheet dataset and the control file are inputs to the spreadsheet loader. Each rule in the control file is evaluated for each record to determine if the condition is true for the record, and the records are parsed if the condition is true. The spreadsheet loader sends the parsed data to the database. The invention includes a user interface to facilitate creation of the control file.
REFERENCES:
patent: 4815029 (1989-03-01), Barker et al.
patent: 5287447 (1994-02-01), Miller et al.
patent: 5657460 (1997-08-01), Egan et al.
patent: 5745901 (1998-04-01), Entner et al.
patent: 6034676 (2000-03-01), Egan et al.
patent: 6188403 (2001-02-01), Sacerdoti et al.
patent: 6222540 (2001-04-01), Sacerdoti
patent: 2002/0046248 (2002-04-01), Drexler
patent: 2004/0193646 (2004-09-01), Cuckson et al.
Chamberlain, D: “A complete guide to DB2 universal database” Complete Guide to DB2 Universal Database, XX, XX, 1998, pp. 1-35, 643-658, XP002239913.
Anonymous: “Oracle Warehouse Builder: A Technical Overview” Oracle Technical White Paper, XX, XX, 2000, pp. 1-21, XP002249154.
Office Action In European Patent Application No. 04 793 918.6-2201 mailed Jun. 13, 2007, 5 pages.
Durbin J. et al., Oracle 8 Utilities, Release 8.0; Chapters Dec. 3-5, 1997, 138 pages.
Office Action in European Patent Application No. 04 793 918.6-2201 mailed Mar. 13, 2008, 8 pages.
Gupta Atul
Singh Amar
Alam Shahid A
Bullock Joshua
Galloway Bryan P.
Osha & Liang LLP
Schlumberger Technology Corporation
LandOfFree
System, method and apparatus for loading text data in 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 System, method and apparatus for loading text data in a..., we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and System, method and apparatus for loading text data in a... will most certainly appreciate the feedback.
Profile ID: LFUS-PAI-O-4081706