Data transformation to maintain detailed user information in a data warehouse
US7024431B1 · kind B1 · utility
31Cited by
6References
22Claims
0Family size
Assignee
Inventors
Key dates
| Filing date | May 5, 2003 |
| Grant date | Apr 4, 2006 |
| Priority date | — |
| Expiry date | Aug 20, 2024 |
Classification
- Technology area (CPC Y)Emerging Cross-Sectional Technologies
- CPC primaryY10S707/99953
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
Transforming data prior to loading the data into a data warehouse. Software of the invention partitions data records received from a plurality of servers and performs sequential file management operations and identifier management operations on each of the partitions prior to loading the data records into the data warehouse. Data records transformed according to the invention are easier to load into the data warehouse and easier to manipulate after loading. The invention enables analysis and data mining of tens of terabytes of user level detail data and summary data.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.