System and method for developing a star schema
AssigneeHewlett-Packard Development Company, L.P.
InventorsMehmet Sayal, Fabio Casati, Ming-Chien Shan
Life of this patent
Estimating the term…
Abstract
Disclosed embodiments of the present invention relate to a system and method for automatic generation of a star schema. The system and method may comprise categorizing a data field into one of a plurality of data field types, one of the data field types being an enumeration type data field. The system and method may further comprise developing dimensions for a table that represents an initial star schema design using the categorization of the data, detecting functional dependencies between the data field and other data fields, and refining the initial star schema design by modifying the table based on detected functional dependencies.
Claims25
A method, comprising:
- categorizing a data field into one of a plurality of data field types, one of the data field types being an enumeration type data field;
- developing dimensions for a table that represents an initial star schema design using the categorization of the data field;
- detecting functional dependencies between the data field and other data fields;
- and
- refining the initial star schema design by modifying the table based on detected functional dependencies.
A system, comprising:
- a categorizing hardware module adapted to categorize a data field into one of a plurality of data field types, one of the data field types being an enumeration type data field;
- a star schema hardware module adapted to develop dimensions for a table that represents an initial star schema design using the categorization of the data field;
- a dependency hardware module adapted to detect functional dependencies between the data field and other data fields;
- and
- a refinement hardware module adapted to refine the initial star schema design by modifying the table based on detected functional dependencies.
A non-transitory computer readable medium, comprising:
- a categorizing module stored on the non-transitory computer readable medium, the categorizing module adapted to categorize a data field into one of a plurality of data field types, one of the data field types being an enumeration type data field;
- a star schema module stored on the non-transitory computer readable medium, the star schema module adapted to develop dimensions for a table that represents an initial star schema design using the categorization of the data field;
- a dependency module stored on the non-transitory computer readable medium, the dependency module adapted to detect functional dependencies between the data field and other data fields;
- and
- a refinement module stored on the non-transitory computer readable medium, the refinement module adapted to refine the initial star schema design by modifying the table based on detected functional dependencies.
Dependencies are inferred from the claim text.