Method and system for developing extract transform load...

Details Method and system for developing extract transform load... Method and system for developing extract transform load...

2006-11-21

2006-11-21

Ali, Mohammad (Department: 2166)

Data processing: database and file management or data structures

Database design

Data structure types

C707S793000

Reexamination Certificate

active

07139779

ABSTRACT:
Developing an ETL system for transforming data prior to loading the data into a data warehouse. An embodiment of the invention automatically generates configuration files from an input data flow diagram defining the ETL system. The configuration files or other metafiles control execution of the processes illustrated in the data flow diagram. The invention includes a notation for use in the data flow diagram.

REFERENCES:
patent: 5926818 (1999-07-01), Malloy
patent: 6122628 (2000-09-01), Castelli et al.
patent: 6871228 (2005-03-01), Shah et al.
patent: 2002/0070953 (2002-06-01), Barg et al.
patent: 2002/0099563 (2002-07-01), Adendorff et al.
patent: 2003/0014335 (2003-01-01), Lecheler-Moore et al.
patent: 2003/0023413 (2003-01-01), Srinivasa
Larson, Diane, Data Transformation Services (DTS) in SQL Server 2000, Sep. 2000.
Beauchemin, Bob, The XML Files: Investigate the diffrences between SQL Server 2000's XML integration and Microsoft's XML technology preview, 2000, SQL Server Magizine.
Vassiliadis, et al., “Conceptual Modeling for ETL Processes,” Proceedings of the 5th ACM International Workshop on Data Warehousing and OLAP, 2002, pp. 14-21, ACM Press, New York, U.S.A.
Loshin, David, “Rule-Based Data Quality,” Proceedings of the 11th International Conference on Information and Knowledge Management, 2002, pp. 614-616, ACM Press, New York, U.S.A.
Pietriga, et al., “VXT: A Visual Approach to XML Transformations,” Proceedings of the 2001 ACM Symposium on Document Engineering, 2001, pp. 1-10, ACM Press, New York, U.S.A.
Pokorny, Jaroslav, “Modelling Stars Using XML,” Proceedings of the 4th ACM International Workshop on Data Warehousing and OLAP, 2001, pp. 24-31, ACM Press, New York, U.S.A.
Golfarelli, et al., “Data Warehouse Design from XML Sources,” Proceedings of the 4th ACM International Workshop on Data Warehousing and OLAP, 2001, pp. 40-47, ACM Press, New York, U.S.A.
Vaduva, et al., “M4—A Metamodel for Data Preprocessing,” Proceedings of the 4th ACM International Workshop on Data Warehousing and OLAP, 2001, pp. 85-92, ACM Press, New York, U.S.A.
Hahn, et al., “Automatically Generating OLAP Schemata from Conceptual Graphical Models,” Proceedings of the 3rd ACM International Workshop on Data Warehousing and OLAP, 2000, pp. 9-16, ACM Press, New York, U.S.A.
Golfarelli, et al., “A Methodological Framework for Data Warehouse Design,” Proceedings of the 1st ACM International Workshop on Data Warehousing and OLAP, 1998, pp. 3-9, ACM Press, New York, U.S.A.
Chaudhuri, et al., “An Overview of Data Warehousing and OLAP Technology,” ACM SIGMOD Record, vol. 26, Issue 1, Mar. 1997, pp. 65-74, ACM Press, New York, U.S.A.

Affiliated with

Also associated with

Rating

Method and system for developing extract transform load... 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 system for developing extract transform load..., we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Method and system for developing extract transform load... will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-3640126