System and method for developing a star schema
First Claim
Patent Images
1. 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.
8 Assignments
0 Petitions
Accused Products
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.
-
Citations
25 Claims
-
1. 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. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17)
-
-
18. 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. - View Dependent Claims (19, 20, 21)
-
-
22. 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. - View Dependent Claims (23, 24, 25)
-
Specification