ETL-less zero-redundancy system and method for reporting OLTP data

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, said computer system comprising:

• a processor;
• and
• a memory storing said computer program, wherein said computer program, when executed by said processor, controls said computer system to perform a method including:
• storing said database information in a row format,
• storing 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.

A computer program embodied on a non-transitory computer-readable medium and implemented by a computer system for processing database information for both transacting and reporting, wherein said computer system includes a processor and a memory, said computer program being executed by said processor and controlling said computer system to perform a method comprising:

• storing, by said computer system, 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.