BATCH UPDATE SYSTEM FOR DATABASE BASED ON SPREADSHEET INTERFACE USING QUERY TEMPLATE

摘要

PROBLEM TO BE SOLVED: To provide a database batch update system for easily performing update.;SOLUTION: An update server 30 comprises: a worksheet update part for providing a spreadsheet interface, and for generating a worksheet to display the structure and record data of a dataset on the worksheet, and for updating the record data in response to the input of a user using the spreadsheet interface, and for displaying the update state of each record data; an update definition part for defining the structure and record data of the dataset of records updated on the worksheet; a query generation part for generating a query template by using the structure of the dataset of the defined records, and for mapping the record data on mapping variables of the query template for each of the updated records to generate an actual query sentence; and a database update part for transferring the generated query sentence to a DB to update an object table.;SELECTED DRAWING: Figure 3;COPYRIGHT: (C)2017,JPO&INPIT