SYSTEM AND METHOD FOR ASSIGNING DATA TO COLUMNAR STORAGE IN AN ONLINE TRANSACTIONAL SYSTEM

摘要

A method, apparatus, and computer program product for assigning data to columnar storage is disclosed. In one aspect of the invention, a computer implemented method is provided comprising analyzing, on one or more computers, a database stored in a storage system accessible from the one or more computers. The method also comprises determining, on one or more computers, one or more database elements from the database to be assigned to a columnar storage in the database and assigning, on one or more computers, the one or more database elements to the columnar storage in the database. The one or more database elements to be assigned to the columnar storage is determined based on at least one of a table dimension, entity relationship, compatibility with a specified schema structure, relational data structure of the database, access statistics of the database element or incoming query workload of the database element.

主权项

1. A computer implemented method for assigning data to columnar storage, comprising:
analyzing, on one or more computers, a database stored in a storage system accessible from the one or more computers; determining, on one or more computers, one or more database elements from the database to be assigned to a columnar storage in the database; and assigning, on one or more computers, the one or more database elements to the columnar storage in the database.