Data processing: database and file management or data structures – Database design – Data structure types
Reexamination Certificate
2007-11-20
2007-11-20
Alam, Shahid (Department: 2162)
Data processing: database and file management or data structures
Database design
Data structure types
C707S793000, C707S793000, C707S793000, C707S793000, C707S793000
Reexamination Certificate
active
10266409
ABSTRACT:
A method and apparatus that catalogs the characteristics and scheduling of multiple ETL procedures or processes as the multiple ETL procedures extract, transform data from a first database to load the data to a second database. The method and apparatus catalogs the progress and success of execution of multiple ETL procedures. The method and apparatus determines the necessary scheduling for cleansing operations of the first database, then initiates the cleansing operation of the first database, and then catalogs the progress of a cleansing process performed on a database to eliminate inconsistencies, redundancies, and corruptions of the database. The method and apparatus determines any errors in the execution of the ETL procedures and transmits an error message describing the errors to a person.
REFERENCES:
patent: 5781911 (1998-07-01), Young et al.
patent: 6032158 (2000-02-01), Mukhopadhyay et al.
patent: 6070190 (2000-05-01), Reps et al.
patent: 6151608 (2000-11-01), Abrams
patent: 6189004 (2001-02-01), Rassen et al.
patent: 6208990 (2001-03-01), Suresh et al.
patent: 6604110 (2003-08-01), Savage et al.
patent: 6721749 (2004-04-01), Najm et al.
patent: 6757689 (2004-06-01), Battas et al.
patent: 6789096 (2004-09-01), Sankaran et al.
patent: 6839724 (2005-01-01), Manchanda et al.
patent: 6850947 (2005-02-01), Chung et al.
patent: 6915286 (2005-07-01), Policastro et al.
patent: 2002/0138316 (2002-09-01), Katz et al.
patent: 2002/0143733 (2002-10-01), Mukkamalla et al.
patent: 2002/0161778 (2002-10-01), Linstedt
patent: 2002/0198902 (2002-12-01), Sankaran et al.
patent: 2003/0115080 (2003-06-01), Kasravi et al.
patent: 2003/0120477 (2003-06-01), Kruk et al.
patent: 2003/0120593 (2003-06-01), Bansal et al.
patent: 2003/0187716 (2003-10-01), Lee
patent: 2003/0220860 (2003-11-01), Heytens et al.
patent: 2003/0220901 (2003-11-01), Carr et al.
patent: 2004/0015381 (2004-01-01), Johnson et al.
patent: 2004/0064443 (2004-04-01), Taniguchi et al.
patent: 2004/0133551 (2004-07-01), Linstedt
patent: 2005/0091156 (2005-04-01), Hailwood et al.
patent: WO99/24922 (1999-05-01), None
Lou Agosta—“Market Overview Upate: ETL”—Giga Information Group, Inc. Mar. 19, 2002 (pp. 1-8).
Erhard Rahm & Hong Hai Do—“Data Cleaning: Problems and Current Approaches”—IEEE Technical Commitee on Data Engineering—Dec. 2000 (pp. 1-11).
Peter J. Weyman, “The Case for a process-Driven Approach to Data Warehousing”—Database and Network Journal, vol. 27, No. 1, Feb. 1, 1997, (pp. 3-6).
Vassiliadis et al. “Conceptual Modeling for ETL Processes”—ACM Nov. 8, 2002 (pp. 14-21).
Michael Stonebraker “Too Much Middleware” SIGMOD Record, Vo.. 31, No. 1, Mar. 2002 (pp. 97-106).
Search Database.com Definitions, Powered by whatis.com [online]. http://searchdatabase.techtarget.com/s Definition/O., sid13—gci51 9447, on html, [Retrieved on Jul. 3, 2002].
“How to Select an Extraction/Transformation/Loading (ETL) Tool”, Mimno, 101 Communications LLC, Chatsworth, CA 91311, Found Jun. 27, 2002 www.101dataintelligencesolutions.com.
Taiwan Patent TW 4 39028 to Reps et al., “Client-Based Application Availability and Response Monitoring and Reporting for Distributed Computing Environments”.
Chien Chiu-Fang
Liang Shih-Tsung
Alam Shahid
Haynes and Boone LLP
Ly Anh
Taiwan Semiconductor Manufacturing Company , Ltd.
LandOfFree
Method and apparatus for supervising... 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 supervising..., we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Method and apparatus for supervising... will most certainly appreciate the feedback.
Profile ID: LFUS-PAI-O-3848904