| 摘要 |
PROBLEM TO BE SOLVED: To enable a database which handles data occurring in time series to more efficiently achieve a function similar to a time-series accumulation method (capable of referring to and updating current data; occasionally comparing table data at a certain time with table data at another time; occasionally referring to table data at a previous time). SOLUTION: A system for managing database table data includes an export setting file 72 including a method of obtaining the name of a user connected to a DB, a bus to which table data is outputted, and the name of a table to be exported; an export means 71 for exporting table data in a DB storage part 3 to an external file 4 according to the content of the file and outputs the table name of the table data exported and the date of export to a management file; an import setting file 82 including a method of obtaining the name of the user connected to the DB and a bus from which the table data was inputted, a method of obtaining the table name of interest, a method of designating the name of the user to be processed, and an adding method if the name of the user is of the type with the addition of date; and an import means 81 for determining the table data of interest according to the content of the file 82 and which, if the name of the user is of the type with the addition of date, imports the table data in the external file 4 into an area different from an area used for exporting to the DB storage part 3. This solves the problem with a conventional method of accumulating data in a database in time series that accumulating a large amount of data is very inefficient in terms of database maintenance and costs. COPYRIGHT: (C)2005,JPO&NCIPI
|
