JP4820841B2 - Data management system - Google Patents

Description

  The present invention relates to a base management system that includes a plurality of devices, at least one of which has a database, and shares operation data for the database among these devices.

  There is a business system in which at least one device includes a plurality of devices having a database, and data for operating the database is transmitted and received between these devices (for example, Patent Document 1).

In such a business system, when data for operating the database is shared by each device, the data format in the device that sends the data may not match the data format in the device that receives the data. is there. In this case, it is necessary to create a processing program such as an EXE file that converts the format of the data to be sent in accordance with the format of the receiving side, and store it in the sending side device.
Japanese Patent Laid-Open No. 11-66164

  However, the creation of a processing program such as an EXE file has a problem that it takes a lot of cost and labor.

  The present invention has been made in consideration of the above circumstances, and an object of the present invention is to provide a data management system capable of easily sharing data for operation with respect to a database between devices at low cost. It is in.

The data management system of the invention according to claim 1 is composed of a center server having a database and a plurality of store servers connected to the center server via a network, and is provided in the center server for operating the database. An SQL data file folder in which an SQL data file is stored and an SQL data file provided in the center server for converting the SQL data file in the SQL data file folder into a format suitable for the host server of the headquarters and each store server An SP folder in which stored procedures are stored and a control unit provided in the center server. The control unit is configured to read a SQL data file in the SQL data file folder when the host server or each store server requests the SQL data file, and the request source is the host server. Means for converting the read SQL data file into a data file in a format suitable for the host server by a stored procedure in the SP folder, and storing the read data when the request source is the store server Means for converting an SQL data file into a data file in a format suitable for each store server by a stored procedure in the SP folder, and means for providing the held data file to the requesting server; including.

  According to this data management system, operation data for a database can be easily shared between devices at low cost.

Hereinafter, an embodiment of the present invention will be described with reference to the drawings.
As shown in FIG. 1, a plurality of devices such as a center server 1 and a store server 20 are connected to each other via a communication network 10 to constitute a so-called client server system type data management system.

  This data management system is applied to a merchandise sales processing apparatus such as a POS, for example. The center server 1 is installed in a sales center, and the store servers 20 are installed in a plurality of stores managed by the sales center. .

  The center server 1 includes a control unit 2, a ROM 3 for storing control programs, a RAM 4 for data storage, a hard disk drive (HDD) 5, which is a large-capacity storage means, a display unit 6, an operation unit 7, and a network interface (I / F) 8 and a printer 9 or the like.

  The ROM 3 stores an SP processing application program for executing a stored procedure described later.

  The hard disk drive 5 includes a database (DB) 5a in which a plurality of data tables A1, A2, B,... C shown in FIG. 2 are stored, and operations for the database 5a (search operation, update operation, delete operation, etc.) ) SQL data file folder (first storage means) 5b in which a plurality of SQL (Structured Query Language) data files are stored, and each SQL data file in the SQL data file folder 5b is stored in a host server (not shown) of the headquarters or An SP folder (second storage means) 5c in which stored procedures (SP) for conversion into a format suitable for each store server 20 are stored is stored.

  Of the data tables A1, A2, B,... C in the database 5a, A1 is a parent data table, and A2 is a child data table generated using the parent data table A1 as a basic master. The parent data table A1 has a predetermined item as a primary key, and the child data table A2 has a foreign key having the same contents as the primary key. By the relation between the primary key and the foreign key, the parent data table A1 and the child data are stored. Table A2 is linked to each other.

  Each store server 20 includes a control unit 21, a ROM 22 for storing a control program, a RAM 23 for data storage, a hard disk drive (HDD) 24 for data storage, a display unit 25, an operation unit 26, and a network interface (I / F) 27 and the like.

In the data management system having such a configuration, the control unit 2 in the center server 1 has the following (1) and (2) as main functions related to database management.
(1) The SP processing application program in the ROM 3 is started and the stored procedure in the SP folder 5c is executed, whereby each SQL data file in the SQL data file folder 5b is formatted suitable for the host server or each store server 20. Control means to convert to format. The contents of each SQL data file include, for example, argument 1 (file name), argument 2 (target date),.

  (2) Providing means for providing the converted data file to the server in response to a request from the host server or each store server 20. Specifically, the converted data file is temporarily held in the file folder 5d, and the held data file is provided in accordance with the reception format of the requesting server.

Next, the operation will be described with reference to FIGS.
When the center server 1 receives a SQL data file request from another server, one of the SQL data files in the SQL data file folder 5b of the center server 1 is read (step 101). Then, it is determined whether the read SQL data file is a comma separated values (CSV) separated by commas or a BCP (Bridge Control Protocol) with table data as it is (step 102).

  If the read SQL data file is CSV, the store-specific creation flag is “1” (“1” in step 103), and if the SQL data file is requested from the head office to the sales center, the stored procedure is executed. Thus, the SQL data file is converted into a data file in a format suitable for the headquarters host server (step 104). The converted data file is held in the file folder 5d.

  When the store-specific creation flag is “0” (“0” in step 103) and an SQL data file is requested from each store to the sales center, the SQL data file is stored in each store server by executing the stored procedure. Each data file is converted into a data file having a format suitable for the file 20 (step 105). The converted data file is held in the file folder 5d.

  If the store header addition flag is “0” (“0” in step 106), a store header is created and added to the stored data file (step 107). When the store header addition flag is “1” (“1” in step 106), the store header is not created.

Subsequently, if the HDS (Hierarchy Data Set) file addition flag is “0” (“0” in step 108), an HDS header is created and added to the held data file (step 109). . That is, if the store- specific creation flag is “0”, an HDS header in which the actual store code is set as a store code is added, and if the store- specific creation flag is “1”, the store code is An HDS header in which the host code is set is added. When the HDS file addition flag is “1” (“1” in step 108), the HDS file header is not added.

  Further, if the date / time addition flag is “0” (“0” in step 110), the current date and time data are added to the held data file (step 111). When the date / time addition flag is “1” (“1” in step 110), date and time data are not added.

  Then, it is determined whether the receiving format of the server that receives the held data file is FTP (File Transfer Protocol) or a designated folder (step 112). If the receiving format is FTP, the held data file is transmitted to the receiving server in FTP format. If the receiving format is a designated folder, the stored data file is copied to the designated folder in the server by access from the receiving server.

  On the other hand, if the read SQL data file is a BCP (BCP in step 102), it is determined whether the output format of the BCP is all or part (step 115). If there are all cases, all cases of the read SQL data file are extracted and temporarily held in the file folder 5d (step 116). If it is a part, only a part of the read SQL data file is extracted and temporarily held in the file folder 5d (step 117).

If the HDS (Hierarchy Data Set) file addition flag is “0” (“0” in step 108), an HDS header is created and added to the stored SQL data file (step 109). ). That is, if the store- specific creation flag is “0”, an HDS header in which an actual store code is set as a store code is added. If the store- specific creation flag is “1”, an HDS header in which a host code is set as a store code is added. When the HDS file addition flag is “1” (“1” in step 108), the HDS file header is not added.

  Further, if the date / time addition flag is “0” (“0” in step 110), the current date and time data are added to the held SQL data file (step 111). When the date / time addition flag is “1” (“1” in step 110), date and time data are not added.

  Then, it is determined whether the reception format of the server on the side of receiving the held SQL data file is FTP (File Transfer Protocol) or a designated folder (step 112). If the receiving format is FTP, the held SQL data file is transmitted to the receiving server in FTP format. If the receiving format is a designated folder, the held SQL data file is copied to the designated folder in the server by access from the receiving server.

  As described above, an SQL data file for operation with respect to the database 5a of the center server 1 is stored in the center server 1, and a stored procedure for converting the SQL data file into a format suitable for another server is stored. Are stored in the center server 1, and when there is a request for an SQL data file from another server to the center server 1, the SQL data file is converted into a data file in a format suitable for the requesting server. Since it is configured to be provided to the requester, a data file for operation on the database 5a can be easily and inexpensively exchanged between the servers without requiring a processing program such as an EXE file that requires a lot of cost and labor. It becomes possible to share.

  In the above embodiment, the client server system type data management system including the center server 1 and the plurality of store servers 20 has been described as an example. However, as long as it has a database, the same applies to other systems. Applicable. In addition, the present invention is not limited to the above embodiment, and various modifications can be made without departing from the scope of the invention.

The figure which shows the whole structure of one Embodiment. The figure which shows the memory content of the database in one Embodiment. The figure for demonstrating the main processes of the center server in one Embodiment. The flowchart for demonstrating the effect | action of one Embodiment.

Explanation of symbols

  DESCRIPTION OF SYMBOLS 1 ... Center server, 2 ... Control part, 4 ... RAM, 5 ... Hard disk drive, 5a ... Database, 5b ... SQL data file folder, 5c ... SP folder, 5d ... File folder, 10 ... Communication network, 20 ... Store server ( Client), 21 ... control unit

Claims (3)

In a data management system comprising a center server having a database and a plurality of store servers network-connected to the center server ,
An SQL data file folder provided in the center server and storing an SQL data file for operating the database;
An SP folder that is provided in the center server and stores a stored procedure for converting an SQL data file in the SQL data file folder into a format suitable for a host server of the headquarters and each store server;
A control unit provided in the center server;
With
The controller is
Means for reading a SQL data file in the SQL data file folder when the host server or each store server requests the SQL data file;
When the request source is the host server, the read SQL data file is converted into a data file in a format suitable for the host server by a stored procedure in the SP folder, and stored,
When the request source is the store server, means for converting the read SQL data file into a data file in a format suitable for each store server by a stored procedure in the SP folder,
Means for providing the retained data file to the requesting server;
Data management system, which comprises a. The controller is
Means for reading a SQL data file in the SQL data file folder when the host server or each store server requests the SQL data file;
Means for determining whether the read SQL data file is CSV or BCP;
If the determination result is CSV and the request source is the host server, the read SQL data file is converted into a data file in a format suitable for the host server by a stored procedure in the SP folder. Means for holding;
When the determination result is CSV and the request source is the store server, the read SQL data file is converted into a data file in a format suitable for each store server by the stored procedure in the SP folder. Means to hold and
Means for creating a store header as needed and adding it to the retained data file;
Means for creating an HDS header in which a store code or a host code is set as necessary and adding it to the held data file;
If the result of the determination is BCP, means for determining whether the output format of the BCP is all cases or a part thereof;
If the determination result is all cases, means for extracting and holding all cases of the read SQL data file;
Means for extracting and holding only a part of the read SQL data file if the result of the determination is a part;
Means for creating an HDS header in which a store code or a host code is set as needed and adding it to the held SQL data file;
Means for providing the retained data file or SQL data file to the requesting server;
including,
The data management system according to claim 1, wherein: The providing means provides the held data file or the SQL data file to the requesting server in accordance with the receiving format of the requesting server.
The data management system according to claim 1 or 2, characterized by the above.

Images