System and method for warehousing and retrieving data
US6587857B1 · kind B1 · utility
Assignee
Inventors
Key dates
| Filing date | Jun 30, 1999 |
| Grant date | Jul 1, 2003 |
| Priority date | — |
| Expiry date | Jun 30, 2019 |
Classification
- Technology area (CPC Y)Emerging Cross-Sectional Technologies
- CPC primaryY10S707/99943
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
A system and method for preparing and integrating operational data received from nodes on a network prior to loading the data onto a data warehouse. Operational data received from nodes on a network is transformed to produce an output file of integrated data records which are audited to ensure data contained in the records has not already been loaded to the data warehouse in a previous operation. Data previously loaded onto the data warehouse is compared with current operational data to be loaded to determine whether the status of any nodes in the network has changed. The audited integrated operational data and data indicating which nodes, if any, have changed status since the previous upload of data are provided with unique identification numbers and uploaded to the data warehouse. In a preferred embodiment, the data concerns transactions occurring on, and the status of, components in customer activated terminals or transactions occurring on home banking servers. Once uploaded to the data warehouse, data may be viewed graphically by an end user querying the data warehouse.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.