System and method for transaction log cleansing and aggregation
US8239244B2 · kind B2 · utility
Assignee
Inventors
Key dates
| Filing date | Nov 30, 2007 |
| Grant date | Aug 7, 2012 |
| Priority date | — |
| Expiry date | Sep 29, 2030 |
Classification
- Technology area (CPC G)Physics
- CPC primaryG06Q30/0204
- WIPO fieldIT methods for management
- WIPO sectorElectrical engineering
Abstract
A computer-implemented method prepares data for modeling. The method comprises storing data from customer sales transactions in a database and retrieving a dataset of the data from the database. The dataset may include promotion and merchandizing entries. The method includes cleansing the dataset to remove erroneous and anomalous entries. Cleansing the dataset may include determining a threshold value from the dataset and determining whether a value of the dataset exceeds the threshold value, and determining an out-of-stock status for a product from the dataset. The method includes aggregating the dataset over a plurality of dimensions of the transactional space including store, product, and time dimensions, and analyzing the dataset following the cleansing and aggregating steps within a model to predict attributes of subsequent sales transactions.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.