Analytical database system that models data to speed up and simplify data analysis
US6879984B2 · kind B2 · utility
Assignee
Inventors
Key dates
| Filing date | Apr 12, 2001 |
| Grant date | Apr 12, 2005 |
| Priority date | — |
| Expiry date | Feb 23, 2022 |
Classification
- Technology area (CPC Y)Emerging Cross-Sectional Technologies
- CPC primaryY10S707/99942
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
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.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.