Method and Apparatus for Querying Service Data, and Database System

An apparatus for querying service data, wherein a database memory comprises a column buffer and a row buffer, wherein a column of the column buffer is used to load column data of a database, wherein a row of the row buffer is used to load column data of the column buffer or the column data of the database, and wherein the apparatus comprises:

• a memory storing executable instructions;
• and
• a processor coupled to the memory and configured to:
• detect whether a row index corresponding to a target column identifier exists when receiving a transactional service data query request that is sent by a transactional service system and that comprises the target column identifier and a first query condition;
• query, based on the first query condition, column data that corresponds to the target column identifier, and that is in a row that is in the row buffer and corresponds to the row index, to obtain a query result when the row index corresponding to the target column identifier exists;
• output the result;
• and
• return the query result to the transactional service system.

A database system, comprising:

• a database;
• a database memory comprising a column buffer and a row buffer, wherein a column of the column buffer is used to load column data of the database, and wherein a row of the row buffer is used to load column data of the column buffer or the column data of the database;
• and
• an apparatus for querying service data, comprising:
• a memory storing executable instructions;
• and
• a processor coupled to the memory and configured to:
• detect whether a row index corresponding to a target column identifier exists when receiving a transactional service data query request that is sent by a transactional service system and that comprises the target column identifier and a first query condition;
• query, based on the first query condition, column data that corresponds to the target column identifier, and that is in a row that is in the row buffer and corresponds to the row index, to obtain a query result when the row index corresponding to the target column identifier exists;
• output the result;
• and
• return the query result to the transactional service system.