Analytical database system that models data to speed up and simplify data analysis
First Claim
1. A method for providing analytical business reports that are based on relational databases that include tables each with a plurality of data fields, comprising the steps of:
- denormalizing said relational database;
inverting said relational database such that said data fields of said tables in said relational database are stored in separate files that contain a row number field and a single data field; and
compressing at least one of said files.
1 Assignment
0 Petitions
Accused Products
Abstract
An analytical database system provides access to all of the data collected by an entity in interactive time. The analytical database system transforms relational database data. The relational database is denormalized and inverted such that the data fields of tables in the relational database are stored in separate files that contain a row number field and a single data field. At least one of the files, that contains repeating data values that are stored in successive rows, is compressed. The files include files with partition values and files with analytical data. Processing of the files is distributed by creating sub-rowsets of the files and by assigning the sub-rowsets to servers. The partial result sets are merged into a complete result set.
-
Citations
34 Claims
-
1. A method for providing analytical business reports that are based on relational databases that include tables each with a plurality of data fields, comprising the steps of:
-
denormalizing said relational database;
inverting said relational database such that said data fields of said tables in said relational database are stored in separate files that contain a row number field and a single data field; and
compressing at least one of said files. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 28, 29, 30, 31, 32, 33, 34)
-
-
13. A system for providing analytical business reports, comprising:
-
a data storage device that stores denormalized and inverted data in separate files that contain a row number and a single data field, wherein a first file contains partition values and a second file contains analytical values;
a client computer that requests a business report that requires a calculation involving said first and second files;
an application controller that is responsive to said request from said client computer; and
a plurality of servers connected to said data storage device and said application controller, wherein said application controller distributes portions of said calculation to said servers, merges partial result sets that are generated by said servers and transmits said merged result sets to said client computer.
-
-
27. A method for providing analytical business reports that are based on relational databases that include tables each with a plurality of data fields, comprising the steps of:
-
denormalizing said relational database;
inverting said relational database such that said data fields of said tables in said relational database are stored in files that contain a row number and a data field;
compressing at least one of said files; and
distributing processing of said business report using a first set of severs.
-
Specification