The Nielsen Comapny (US), LLC

Nielsen Media Research, Inc.

Doug McDowell

Steve Lavdas

Methods and apparatus for improving data warehouse performance are disclosed. An example method to transform a first database into a second database includes generating a first mapping file associated with a fact table of the first database, the first mapping file referenced by a first hierarchical directory file path, generating a second mapping file associated with a dimension table, the second mapping file referenced by a second hierarchical directory file path, and retrieving data from the second database using the first and second mapping files via sequential navigation of the first and second hierarchical directory file paths.

Methods and apparatus for improving data warehouse performance

Methods and apparatus for improving data warehouse performance are disclosed. An example method to transform a first database into a second database includes analyzing a structure of the first database, generating a hierarchical file path structure reflecting the structure of the first database, and associating a mapping file with a fact table, the mapping file stored in a first hierarchical directory file path of the hierarchical file path structure. The example method also includes copying data from the first database to form the second database, the copied data being accessible from the second database via the mapping file and the fact table, receiving a request to access data in the first database, using the mapping file and the fact table to retrieve the data responsive to the analysis instruction from the second database, and outputting the retrieved data.

Methods and apparatus for improving data warehouse performance are disclosed. An example method to format data received from a data warehouse includes receiving an analysis instruction, retrieving data from the data warehouse based on the analysis instruction, and associating a mapping file with a fact table, the mapping file stored in a first hierarchical directory file path.

Growing community of inventors

Odessa, FL, United States of America

Doug McDowell