CPC G06F 16/2455 (2019.01) [G06F 16/221 (2019.01); G06F 16/2379 (2019.01); G06F 16/27 (2019.01); G06F 16/283 (2019.01); G06F 16/284 (2019.01); G06F 16/278 (2019.01)] | 20 Claims |
1. A computer-implemented method of processing database information for both transacting and reporting, comprising the steps of:
storing, by a computer system that includes a processor and a memory, said database information in a row format;
storing, by said computer system, said database information in a column format using vertical fragmentation;
in response to a database update request, updating said database information stored in said row format;
in response to said database update request, updating said database information stored in said column format, wherein said database information stored in said row format and said database information stored in said column format are updated concurrently and share a consistent view of said database information; and
in response to a query request to retrieve data, generating a query response based on said database information stored in said column format, wherein generating said query response accesses only one or more columns needed directly for generating said query response.
|