Patent ID: 9626421
Date: 2017-04-18
CPC Classifications: G06F

Claim:
1. A computer system storing a computer program for processing database information for both transacting and reporting, said computer program being executed by said computer system, the computer system comprising: a processor; a memory; a relational database management system component, implemented by the computer system, wherein said relational database management component stores said database information in a row format; and a column-oriented data processing component, implemented by the computer system, wherein said column-oriented data processing component stores said database information in a column format using vertical fragmentation, in response to a database update request, said relational database management system component updates said database information stored in said row format, said relational database management system component notifies said column-oriented data processing component of said database update request, and said column-oriented data processing component updates said database information stored in said column format, whereby said relational database management system component and said column-oriented data processing component share a consistent view of said database information, and in response to a query request to retrieve data, said column-oriented data processing component generates a query response based on said database information stored in said column format, wherein generating the query response accesses only one or more columns needed directly for generating the query response.