ORGANIZATION OF DATA WITHIN A DATABASE

摘要

A computer implemented method is provided for processing data representing a data entity having sub entities. The method includes analyzing queries to the data entity for deriving information about sets of the sub entities frequently queried together, and grouping the sub entities to a number of banks, each bank having a maximum width, based on the information about sets of sub entities frequently queried together, in order to reduce an average number of banks to be accessed for data retrieval.

主权项

1. A computer implemented method for processing data of a data table comprising columns, said method comprising:
analyzing queries to said data table for deriving access frequency information about sets of columns, each set comprising two or more of the columns accessed together by a same corresponding query; and grouping said columns to a number of banks, with each bank having a maximum width and at least one of the sets of columns, wherein said grouping is based on said access frequency information to place columns accessed together in a same bank and reduce an average number of banks to be accessed for data retrieval.