Methods and apparatus for improving data warehouse performance
View Patent ↗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.
1. A method to transform a first database into a second database, comprising:
generating, with a processor, 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, with the processor, a second mapping file associated with a dimension table, the second mapping file referenced by a second hierarchical directory file path;
appending, with the processor, 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, with the processor, 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.
2. A method as defined in claim 1 , wherein the sequential navigation comprises traversing a plurality of nested hierarchical directory file paths referenced by the first hierarchical directory file path.
3. A method as defined in claim 2 , wherein executing the sequential navigation further comprises revealing a plurality of database dimensions, each one of the plurality of database dimensions defined by an associated dimension mapping file.
4. A method as defined in claim 1 , wherein the dimension table comprises a dimension key, the dimension key associated with a data file stored in a third hierarchical file path, the third hierarchical file path nested under the second hierarchical file path.
5. A method as defined in claim 1 , further comprising identifying at least one nested hierarchical file path in response to receiving at least one of the first or second mapping files, the at least one nested hierarchical file path comprising a subsequent level of the first or second hierarchical file path.
6. A method as defined in claim 1 , wherein generating the hierarchical path further comprises generating a star schema structure.
7. An apparatus to transform a first database into a second database, comprising:
an organizer to:
generate 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;
generate a second mapping file associated with a dimension table;
append the second mapping file associated with the dimension table, the second mapping file referenced by a second hierarchical directory file path; and
append 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;
a compression engine to copy data from the fact table of the first database to the first mapping file, and to copy data from the dimension table of the first database to the second mapping file to form the second database; and
a data retriever to retrieve 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.
8. An apparatus to transform a first database into a second database as defined in claim 7 , further comprising a data formatter to execute a sequential navigation by traversing a plurality of nested hierarchical directory file paths referenced by the first hierarchical directory file path.
9. An apparatus to transform a first database into a second database as defined in claim 7 , wherein the organizer is to associate a dimension key with a data file stored in a third hierarchical file path, the third hierarchical file path nested under the second hierarchical file path.
10. An apparatus to transform a first database into a second database as defined in claim 7 , wherein the data retriever is to identify at least one nested hierarchical file path in response to receiving at least one of the first or second mapping files, the at least one nested hierarchical file path comprising a subsequent level of the first or second hierarchical file path.
11. A machine accessible storage device or storage disk having instructions stored thereon which, when executed, cause a machine to, at least:
generate 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;
generate a second mapping file associated with a dimension table, the second mapping file referenced by a second hierarchical directory file path;
append 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;
copy data from the fact table of the first database to the first mapping file, and copy data from the dimension table of the first database to the second mapping file to form the second database; and
retrieve 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.
12. A machine accessible storage device or storage disk as defined in claim 11 , wherein the instructions further cause the machine to traverse a plurality of nested hierarchical directory file paths referenced by the first hierarchical directory file path.
13. A machine accessible storage device or storage disk as defined in claim 12 , wherein the instructions further cause the machine to revealing a plurality of database dimensions, each one of the plurality of database dimensions defined by an associated dimension mapping file.
14. A machine accessible storage device or storage disk as defined in claim 11 , wherein the instructions further cause the machine to identify at least one nested hierarchical file path in response to receiving at least one of the first or second mapping files, the at least one nested hierarchical file path comprising a subsequent level of the first or second hierarchical file path.
15. A machine accessible storage device or storage disk as defined in claim 11 , wherein the instructions further cause the machine to generate a star schema structure when generating the hierarchical path.