A database update system based on spreadsheet interface by finding out updated records automatically

摘要

The present invention is based on a spreadsheet-based system that automatically updates extracted records and their fields in comparison with the original data set, and updates the database by creating extracted update records in a query statement, A system for automatically updating a database, comprising: a data request unit for requesting and fetching a data set of a target table from the database and storing an initial data set; A worksheet display unit that provides a spreadsheet interface, creates a worksheet and displays the structure of the data set and record data on the worksheet; A worksheet update unit for updating record data of a record set on the worksheet according to a user's input through the spreadsheet interface; An update extraction unit for comparing the initial data set with the updated data set to extract an updated record; An update definition unit for defining a data set structure and record data of the updated record for the extracted updated record; A query generating unit for generating a query template by using a data set structure of a defined record and mapping actual record data to a mapping variable of the query template for each updated record to generate an actual query statement; And a DB updating unit for transmitting the generated query statement to the database to update the target table. With such a system, the user can update the database intuitively without updating the knowledge of the database processing method, such as the query statement, by updating the database using a spreadsheet, such as Excel, which is often used for office use.