Data processing system

A data processing method for a data processing system including a first storage device and a second storage device, wherein the data processing system is configured to execute a data processing method comprising:

• storing one or more tables each including a plurality of columns holding data of one or more records in the first storage device;
• periodically executing an archive process to extract one or more of the records corresponding to a predetermined condition from the table, and, when an amount of the extracted records exceeds a predetermined threshold value, separately store the extracted records in a plurality of archive files in the second storage device, and, when the amount of the extracted records does not exceed the predetermined threshold value, store the extracted records in a respective archive file in the second storage device;
• and
• receiving a search request, and
• wherein processing the search request includes:
• generating a first partial query to search for a record from the one or more tables corresponding to a condition specified by the search request;
• generating a second partial query to identify one or more of the archive files including a record specified as a search target in the search request and search the identified archive files for the record corresponding to the condition specified by the search request;
• generating a query to derive a union of output results of the first partial query and the second partial query;
• analyzing the generated query;
• and
• executing processing related to the query in parallel.

A non-transitory, computer readable storage medium storing a program for a processor configured to manage one or more tables including a plurality of columns and a plurality of archive files including one or more records extracted from the table, wherein the program causes the processor to execute a method comprising:

• storing one or more tables each including a plurality of columns holding data of one or more records in the first storage device;
• periodically executing an archive process to extract one or more of the records corresponding to a predetermined condition from the table, and, when an amount of the extracted records exceeds a predetermined threshold value, separately store the extracted records in a plurality of archive files in the second storage device, and, when the amount of the extracted records does not exceed the predetermined threshold value, store the extracted records in a respective archive file in the second storage device;
• and
• receiving a search request,
• wherein processing the search request includes:
• generating a first partial query to search for a record from the one or more tables corresponding to a condition specified by the search request;
• generating a second partial query to identify one or more of the archive files including a record specified as a search target in the search request and search the identified archive files for the record corresponding to the condition specified by the search request;
• generating a query to derive a union of output results of the first partial query and the second partial query;
• analyzing the generated query;
• and
• executing processing related to the query in parallel.