JP2006059135A - Database management system - Google Patents

Abstract

<P>PROBLEM TO BE SOLVED: To provide a database management system capable of improving the convenience of users in a database having the function of accepting external data, and easily managing original data accepted in the database. <P>SOLUTION: This database management system for managing a database stored in a storage means by use of a computer comprises an external file acceptance means accepting the content of an external file in the database; and an external file storage means storing the external file in the storage means after accepting the content of the external file in the database by the external file acceptance means. <P>COPYRIGHT: (C)2006,JPO&NCIPI

Description

  The present invention relates to a database management system, and more particularly to a database management system that stores and uses various data using a database in a computer and a storage device.

  Conventionally, there has been provided a database management system for storing various data in a database and for easily using such various data later, for example, update and reference.

  Such a database management system provides a function (hereinafter referred to as “data reception”) for importing data in a format different from that of a database such as a CSV format file. It can be used effectively by importing it into the database.

  For example, the invention described in Patent Document 1 discloses a server system that can register a material file from a personal folder in a database included in the server system.

JP 2003-316788 A

  By the way, a system using a conventional database such as the invention described in Patent Document 1 has the following problems.

  That is, in the conventional system, when data is accepted in the database, the accepted data is registered and stored in the database as necessary. In general, the received data is combined, and the original data received (for example, a CSV (Comma Separated Value) file) is not kept.

  This is because the accepted data is already reflected in the database, so the original data (eg CSV file) of the accepted data is unnecessary and the storage device is used for the unnecessary data. Because it is considered useless.

  However, when data is accepted into the database, it is often possible to discover database fraud, such as data inconsistencies occurring later. In such a case, the fraud of the database must be corrected. For that purpose, the original data (for example, CSV file) that caused the fraud among the original data received in the database is corrected, and the original It is necessary to accept the database again before accepting the data.

  However, since the original data that has been accepted cannot be stored in the past, the above-described method cannot be corrected, and there is a problem that the correction is very troublesome.

  Further, it is very difficult for the user to manage the original data (for example, CSV file) of the data received in the database, and it is also difficult to manage the relation between the original data and the database.

  The present invention has been made in view of the above points, and in a database having a function of accepting external data, a database management system capable of improving user convenience and easily managing original data received in the database. The purpose is to provide.

  In order to achieve the above object, the present invention provides a database management system for managing a database stored in a storage means using a computer, an external file receiving means for receiving the contents of an external file into the database, and the external file receiving means. And the external file storage means for storing the external file in the storage means after receiving the contents of the external file in the database.

  Further, the present invention provides the operation history file storage according to claim 1, wherein an operation history file in which an external file acceptance history is recorded by the external file acceptance unit is created, and the operation history file is stored in the storage unit. The database management system according to claim 1, further comprising means.

  In the invention according to claim 1 or 2, the external file is a CSV file.

  ADVANTAGE OF THE INVENTION According to this invention, in the database which has a function which accepts external data, the usability of a user can be improved and the database management system which can manage easily the original data received in the database can be provided.

  That is, according to the present invention, the situation when the external file is received in the database can be recorded in detail in the operation history file, and the operation history file is referred to even when a problem is later found. As a result, the cause of the failure can be easily investigated and corrected.

  Further, according to the present invention, the received external file can be stored as it is in the database, so that the operation history file can be referred to even when the received external file becomes necessary later. The external file can be obtained immediately, and it is possible to respond immediately when the external file needs to be corrected.

  Embodiments of the present invention will be described below with reference to the drawings.

  FIG. 1 is a block diagram showing a configuration of an embodiment of a database management system according to the present invention.

  In the present embodiment, a database management system that manages a database that stores personnel data of company employees will be described as an example.

  As shown in FIG. 1, the database management system of the present embodiment is configured by connecting a server computer 1, a printer 2, a personal computer 3, and a personal computer 4 via a network 5.

  In the server computer 1, a database is stored in a storage unit 13 described later, and a server-side program in a database management system software program (herein referred to as “database management program”) that manages the database is controlled by a control unit. 11 to operate.

  The personal computer 3 and the personal computer 4 are operated by the user, and the terminal side program of the database management program is operated by the control means 31 to input operations on the database of the server computer 1 or input external data to be accepted into the database. It is possible to

  The database management system according to the present embodiment employs a network configuration as shown in FIG. 1, but the present invention is not limited to this, and a stand-alone computer (for example, a display or a display on the server computer 1). A user interface such as a keyboard and an external data input means such as an FD, a CD, and a DVD drive for inputting external data may be provided to be executed by the server computer 1 alone. Absent.

  In FIG. 1, the network 5 may be any network, for example, a LAN such as Ethernet (registered trademark) or token ring, the Internet, or the like, regardless of wired or wireless, and regardless of the communication protocol. Each device connected to the network 5 is preset with an address on the network, and each device is identified by this address and communicates with other devices connected to the network 5.

  The printer 2 is a device capable of printing a form output of data stored in a database in accordance with instructions from each device connected to the network 5.

  FIG. 2 is a block diagram showing the configuration of the server computer 1 shown in FIG.

  The server computer 1 includes a network connection unit 14 that is an interface with the network 5 shown in FIG. 1, a control unit 11 such as a CPU or MPU that controls the operation of the entire server computer 1, and a user operation on the server computer 1. In addition to the input / output means 12 for inputting instructions and the like, the server computer 1 displays and outputs various information to the user, programs and parameters necessary for the operation of the server computer 1, database management programs, Each table included in the database managed by the database management system, and a storage means 13 for storing an operation history file described later are configured. As the input / output means 12, for example, a keyboard or a mouse is used for input, and a display device or the like is used for output.

  FIG. 3 is a block diagram showing a configuration of the personal computer 3 shown in FIG.

  Since the personal computers 3 and 4 shown in FIG. 1 have the same basic configuration relating to the present embodiment, the personal computer 3 will be described as a representative here.

  The personal computer 3 includes a network connection means 34 that is an interface with the network 5 shown in FIG. 1, a control means 31 such as a CPU or MPU that controls the operation of the whole personal computer 3, and a user performs operations, instructions, etc. In addition to the input / output means 32 for inputting or displaying various information to the user or the computer 3 and the programs and parameters necessary for the operation of the personal computer 3, the database management program and the database of the server computer 1 And storage means 33 for storing external data (CSV data in the present embodiment) and the like to be received at. As the input / output means 32, for example, a keyboard or a mouse is used for input, and a display device or the like is used for output.

  Next, the operation of the database management system of this embodiment will be described.

  The database management system of the present embodiment starts a program for the server computer 1 (server-side program) in the database management program by the control means 11 of the server computer 1, and a program for the personal computer 3 in the database management program. (Terminal-side program) is activated by the control means 31 of the personal computer 3 and realized.

  FIG. 4 is a diagram showing a flowchart of the operation of the database management system shown in FIG. 1, and is a diagram showing a flowchart of processing for accepting CSV data in the database.

  The personal computers 3 and 4 are personal computers operated by a person in charge of managing personnel data of the company.

  First, the person in charge operates the personal computer 3 or 4 (in the following description, it is assumed that the personal computer 3 is operated), and specifies a CSV file to be accepted in the database (A-1).

  By the way, when an external file (CSV file in this embodiment) is received, information relating to a new employee is added to the database that records company personnel data, or information is changed based on personnel changes. Is required.

  Such a database update can be performed by directly manipulating each table of the database by an SQL statement each time there is a change, but in advance, for example, information to be updated by spreadsheet software etc. It is efficient to convert the database into a CSV file and update the database based on the table operation classification such as record addition and record deletion.

  The CSV file accepted by the database may be stored in the storage unit 33 of the personal computer 3 or may be stored in any storage unit connected to the network 5.

  The designation of the CSV file in step (A-1) is performed by the person in charge using the input / output means 32 of the personal computer 3 to input the location and name of the CSV file.

  The control means 31 of the personal computer 3 transmits the location and name of the input CSV file to the server computer 1. In response to this, the control means 11 of the server computer 1 acquires the designated CSV file via the network 5 (A-2). As a protocol for uploading the CSV file to the server computer 1, any conventionally known protocol such as HTTP or FTP may be used.

  When the control means 11 of the server computer 1 acquires the CSV file to be accepted in this way, the corresponding table in the database of the storage means 33 is updated based on the CSV file (for example, record addition, record deletion). (A-3). This is external file receiving means for receiving the contents of the external file into the database.

  At this time, the control means 11 of the server computer 1 stores the CSV file accepted this time in the storage means 33 as it is. It goes without saying that the CSV file stored in the storage means 33 may be subjected to some processing such as addition or deletion of items, file compression, or file encryption. This is external file storage means for storing the external file in the storage means after the contents of the external file are received in the database by the external file receiving means.

  By the way, in the database management system of the present embodiment, an operation history file is provided, and when a CSV file is accepted in the database, an outline of the accepted CSV file and an acceptance history are stored in the operation history file. Yes. This is an operation history file storage unit that creates an operation history file that records the history of external file acceptance by the external file reception unit and stores the operation history file in the storage unit.

  This operation history file may be provided in a database managed by the database management system or may be provided in another location. The structure of this operation history file is shown in FIG.

  FIG. 6 is a diagram showing the structure of an operation history file provided in the database management system shown in FIG.

  As shown in FIG. 6, the operation history file in the database management system of the present embodiment includes a “company code” indicating a code assigned to the company when the personnel data of the company is converted into a database, and a CSV received in the database. “Accept file name” indicating the file name of the file, “File upload path” indicating the location where the accepted CSV file itself is stored, “File update date” indicating the date of update of the accepted CSV file, in the database “Receiving execution job name” indicating the name of the job that has received the CSV file, “Table name to be received” indicating the table name in the database that has received the CSV file, and processing when the CSV file is received (table in the database Adding records to or data "Acceptance process category" indicating the category of whether the record is deleted from the table in the database, "acceptance execution date" indicating the date and time when the CSV file was received, and the user name of the user who executed the CSV file acceptance “Acceptance execution user”, “acceptance execution terminal” indicating the terminal that has received the CSV file, for example, by the terminal name, and “acceptance execution comment” indicating some comment when the CSV file is received Each time a CSV file is received in the database, a record is added to the operation history file (step A-4 in FIG. 4). A specific example of this operation history file is shown in FIG.

  FIG. 7 is a diagram showing a specific example of an operation history file provided in the database management system shown in FIG.

  In the example of FIG. 7, the record on the first line is acceptance of a CSV file for a company whose company code is “777”, the accepted file name is “employee.CSV”, and the accepted CSV file itself Is stored in “¥¥ SERVER ¥ UPLOAD ¥ CSV ¥”, the update date of the CSV file is “2004/04/01 12:00:00”, and the name of the job received is “employee basic” The table name that received the CSV file is “D1RRSKIHON”, the date and time when the acceptance was executed is “2004/04/05 10:30”, and the user who executed the acceptance is “User” 01 ”, the terminal that executed the acceptance is“ PC01 ”, and the comment at the time of acceptance is“ accept new employee ”. is doing.

  According to the present embodiment, the situation when the CSV file is accepted can be recorded in detail in the operation history file as described above. By referencing, the cause of the failure can be easily investigated and corrected.

  Further, according to the present embodiment, the accepted CSV file can be stored in the database as it is, so that the operation history file can be referred to even when the accepted CSV file is needed later. Thus, the CSV file can be obtained immediately, and the CSV file can be immediately dealt with even when the CSV file needs to be corrected.

  Next, a description will be given of processing for checking a situation at the time of acceptance after receiving a CSV file in the database.

  FIG. 5 is a diagram showing a flowchart of the operation of the database management system shown in FIG. 1, and is a diagram showing a flowchart of processing for inquiring about a situation in which CSV data has been accepted in the past.

  First, the person in charge operates the input / output means 32 of the personal computer 3 to instruct the inquiry of the operation history file (B-1). Upon receiving this instruction, the control means 31 of the personal computer 3 sends a message to that effect to the server computer 1, acquires the operation history file stored in the storage means 13 of the server computer 1, and enters this operation history file. Displayed by the output means 32 and presented to the user.

  The presentation of the operation history file may be a display of the operation history file in a tabular format or a format processed so that the person in charge can easily see it. The items to be displayed may be all items in the operation history file or only some items.

  The person in charge refers to the operation history file to determine which CSV file is the target CSV file, and if it is found, designates the CSV file with the input / output means 32 of the personal computer 3. (B-2).

  For specifying the CSV file in step (B-1), the input / output means 32 of the personal computer 3 displays a list of CSV files based on the contents of the operation history file, and the person in charge selects the target file from the list. You may do it.

  The control means 31 of the personal computer 3 transmits information indicating which CSV file is designated to the server computer 1. In response to this, the control means 11 of the server computer 1 transmits the designated CSV file to the personal computer 3 via the network 5 (B-3). As a protocol for downloading the CSV file from the server computer 1, any conventionally known protocol such as HTTP or FTP may be used as in the above-described upload.

  In this way, the control means 31 of the personal computer 3 acquires the CSV file selected by the person in charge, and provides this CSV file to the person in charge by the input / output means 32, for example. The person in charge confirms the contents of the CSV file (B-4) and performs necessary processing from time to time.

It is a block diagram which shows the structure of one Embodiment of the database management system by this invention. It is a block diagram which shows the structure of the server computer 1 shown in FIG. It is a block diagram which shows the structure of the personal computer 3 shown in FIG. It is a figure which shows the flowchart of operation | movement of the database management system shown in FIG. 1, and is a figure which shows the flowchart of the process which receives CSV data in a database. It is a figure which shows the flowchart of operation | movement of the database management system shown in FIG. 1, and is a figure which shows the flowchart of the process which inquires the condition which received CSV data in the past. It is a figure which shows the structure of the operation history file provided with the database management system shown in FIG. It is a figure which shows the specific example of the operation history file provided with the database management system shown in FIG.

Explanation of symbols

DESCRIPTION OF SYMBOLS 1 Server computer 2 Printer 3 Personal computer 4 Personal computer 5 Network 11 Control means 12 Input / output means 13 Storage means 14 Network connection means 31 Control means 32 Input / output means 33 Storage means 34 Network connection means

Claims (5)

In a database management system for managing a database stored in a storage means using a computer,
An external file receiving means for receiving the contents of the external file into the database;
A database management system comprising: external file storage means for storing the external file in the storage means after receiving the contents of the external file in the database by the external file receiving means.   2. An operation history file storage unit that creates an operation history file in which an external file reception history is recorded by the external file reception unit and stores the operation history file in the storage unit. The database management system described in 1.   The database management system according to claim 1 or 2, wherein the external file is a CSV file. In a database management program that operates on a computer to manage a database stored in a storage means,
External file receiving means for receiving the contents of the external file in the database, and external file storage for storing the external file in the storage means after receiving the contents of the external file in the database by the external file receiving means. A database management program characterized by functioning as a means. The computer is further made to function as an operation history file storage unit that creates an operation history file in which an external file acceptance history is recorded by the external file acceptance unit and stores the operation history file in the storage unit. The database management program according to claim 4.

Images