System and Methods for Efficiently Storing Heterogeneous Data Records Having Low Cardinality

摘要

A method for organizing data records stored in a database having one or more row values and one or more row columns. The method includes determining at least one column from the one or more columns having high cardinality. A table is then created for the column having high cardinality, the created table including row values of the column having high cardinality. The method further includes determining a column having low cardinality and creating a second table for the column having low cardinality. The second table may include a descriptor of the column having low cardinality paired with a row value. The method may further include creating a third table that links the first and second tables.

主权项

1. A method for organizing data records stored in a database, the database having one or more row values and one or more row columns, the method comprising:
determining, from the one or more columns, at least one column having high cardinality; creating a first table for the at least one column having high cardinality, the table including one or more row values of the at least one column determined to have high cardinality; determining, from the one or more columns, at least one column having low cardinality; to creating a second table for the at least one column having low cardinality, the second table including a descriptor of the at least one column having low cardinality paired with a row value; and creating a third table that links the first table and the second table.