Patent ID: 8219521
Filing Date: 2012-07-10
Classification: G06F,Y10S

Abstract:
1. A computer implemented method to transform a first database into a second database, comprising: 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; appending the second hierarchical directory file path to the first hierarchical directory file path to facilitate access to the first and the second mapping files, respectively; copying data from the fact table of the first database to the first mapping file, and copying data from the dimension table of the first database to the second mapping file to form the second database; 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 in response to receiving a request to access data in the first database.