Distributed data integration method and system
First Claim
1. A distributed data storage system, comprising:
- a plurality of source systems, each including;
a source database, at least two of the source systems having source databases operable to store data in disparate formats and file structures;
an extraction engine operable to extract data from the source database; and
a transformation engine operable to transform data extracted from the source database into a common format and a common file structure; and
a common database server including;
a common database;
a common database controller operable to receive data transformed by the transformation engine; and
a load engine operable to load the data received by the common database controller into the common database.
4 Assignments
0 Petitions
Accused Products
Abstract
A data storage system (12) may include a plurality of source systems (14) and a common database server (16). Each source system (14) may include a source database (20), an extraction engine (24) and a transformation engine(26). At least two of the source systems (14) may have source databases (20) that store data in disparate formats and file structures. The extraction engine (24) may extract data from the source database (20). The transformation engine (26) may transform data extracted from the source database (20) into a common format and file structure. The common database server (16) may include a common database (32), a common database controller (34) and a load engine (48). The common database controller (34) may receive data transformed by the transformation engine (26). The load engine (48) may load the data received by the common database controller (34) into the common database (32).
114 Citations
19 Claims
-
1. A distributed data storage system, comprising:
a plurality of source systems, each including; a source database, at least two of the source systems having source databases operable to store data in disparate formats and file structures; an extraction engine operable to extract data from the source database; and a transformation engine operable to transform data extracted from the source database into a common format and a common file structure; and a common database server including; a common database; a common database controller operable to receive data transformed by the transformation engine; and a load engine operable to load the data received by the common database controller into the common database. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13)
-
14. A method of storing data from a plurality of source databases, comprising the steps of:
-
extracting data from a first source database; transforming the data of the first source database into a common format and a common file structure; loading the transformed data of the first source database into a common database; extracting data from a second source database, the first and second source databases storing data in disparate formats; transforming the data of the second source database into the common format and the common file structure; and loading the transformed data of the second source database into the common database. - View Dependent Claims (15, 16, 17, 18)
-
-
19. A method of storing data in a database table comprising the steps of:
-
storing in a first column of a data record an identifier uniquely identifying a subject of the data record; storing in a second column a category name for the data record; and storing in a third column a category value associated with the category name in the second column; wherein modifying the table to include a new category for the subject of the data record comprises the steps of; adding to the table a second data record for the subject; storing in the first column of the second data record, the identifier uniquely identifying the subject of the second data record; storing in the second column of the second data record, a name of the new category; and storing in the third column of the second data record, a category value associated with the new category name in the second column of the second data record.
-
Specification