Method and apparatus for transporting data for data warehousing applications that incorporates analytic data interface

Abstract

A method and apparatus for transporting data for a data warehousing application. Data is extracted from one or more source containing data having a standard data structure and is translated into data that contains meaningful business terms. The translated data is then stored. In the present embodiment, an analytic business component is operable for extracting data from the source, translating the extracted data and for storing the translated data into a staging area. The translated data is then processed to obtain data having a common structure. In the present embodiment, a source adapter processes the translated data to obtain data having a common structure. The data having a common structure is then transformed into a format suitable for loading into a data mart. In the present embodiment, an analytic data interface receives the data having a common structure and transforms the data for loading into a data warehouse. The data is then stored in a data warehouse.

Description

FIELD OF THE INVENTION [0001] The present invention relates to database systems. More particularly, the present invention pertains to an apparatus and method for transporting data for a data warehousing application. BACKGROUND OF THE INVENTION [0002] Due to the increased amounts of data being stored and processed today, operational databases are constructed, categorized, and formatted in a manner conducive for maximum throughput, access time, and storage capacity. Unfortunately, the raw data found in these operational databases often exist as rows and columns of numbers and code which appears bewildering and incomprehensible to business analysts and decision makers. Furthermore, the scope and vastness of the raw data stored in modern databases renders it harder to analyze. Hence, applications were developed in an effort to help interpret, analyze, and compile the data so that a business analyst may readily and easily understand it. This is accomplished by mapping, sorting, and summa...

AI Technical Summary

Benefits of technology

The present invention introduces a method and apparatus for transporting data for a data warehousing application. It uses standardized structures of different types of source databases to achieve source-specific configuration for extraction, transformation, and loading in a data warehousing application. The invention simplifies the process of configuring and customizing how business data is loaded into an analytic applications system, reducing the time and expense required. It also takes advantage of the standardization of database components and reduces the time required to define and program data transport for data warehousing applications.

Problems solved by technology

Unfortunately, the raw data found in these operational databases often exist as rows and columns of numbers and code which appears bewildering and incomprehensible to business analysts and decision makers.

Furthermore, the scope and vastness of the raw data stored in modern databases renders it harder to analyze.

However, establishing a structure for transporting (extracting, transporting and loading) data from an operational database or databases into a structure that can be used for data warehousing applications is quite time consuming.

The complexities in designing a data model for transporting data from an operational database into target tables in a data warehouse are not simply technical problems.

They also involve complex business semantic problems.

This is expensive and time consuming.

In addition, these business application programming interfaces require extensive knowledge and programming to learn and use.

The time and cost for defining and programming such that the data is suitable for use as input to a data warehousing application is particularly problematic for companies that use multiple different operational databases.

Images