Method and apparatus with data partitioning and parallel processing for transporting data for data warehousing applications
US6850947B1 · kind B1 · utility
Assignee
Inventors
Key dates
| Filing date | Aug 10, 2000 |
| Grant date | Feb 1, 2005 |
| Priority date | — |
| Expiry date | May 31, 2021 |
Classification
- Technology area (CPC Y)Emerging Cross-Sectional Technologies
- CPC primaryY10S707/99942
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
A method and apparatus for transporting data for a data warehouse application is described. The data from an operational data store (the source database) is organized in non-overlapping data partitions. Separate execution threads read the data from the operational data store concurrently. This is followed by concurrent transformation of the data in multiple execution threads. Finally, the data is loaded into the target data warehouse concurrently using multiple execution threads. By using multiple execution threads, the data contention is reduced. Thereby the apparatus and method of the present invention achieves increased throughput.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.