JPH1185856A - Client/server type financial accounting system - Google Patents

Abstract

PROBLEM TO BE SOLVED: To provide a client/server type financial accounting system which is capable of updating a master file by a single processing by improve the throughput of the whole system. SOLUTION: A client 1-1 mounts a local data base managing system 14-1 to file-transfer to the company table 15a-1 of one company per client device within a local data base 15-1 from the company table 24b-1 of a server 2 to update/retrieve the local data base 15-1 in the inside of the client 1-1. The updated company table 15a-1 file-transfers to a company table 24a-1 of the server 2, after finishing financial processing to return to under the control of the database managing system 23 of the server 2.

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

The present invention relates to a client / server financial accounting system, and more particularly to a client / server financial accounting system in which a server computer manages a database of financial data of a plurality of companies.

[0002]

2. Description of the Related Art Conventionally, in a client / server financial accounting system, a server computer manages a database for storing financial data of a plurality of companies, such as journal data, a beginning balance, and a monthly balance.

A client computer executes financial processes such as journal entry, ledger output, trial balance output, and settlement report output, and instructs a database of a server computer to inquire and update financial data required for these processes. .

As a database management method of this kind, there has been proposed a technique for reducing the load on the server side by processing and modifying the data table of the server on the client side in a table format. This technique is disclosed in JP-A-6-68032.

That is, the above-mentioned database system comprises a server computer which manages a relational database and a client computer which uses the relational database of the server computer.

The client computer has means for extracting desired table data from the relational database of the server computer, means for converting the table data into a spreadsheet on a spreadsheet and displaying the spreadsheet on a display, and processing the spreadsheet data. Spreadsheet means to
SQL (Structured) based on the contents of data processing
And a means for generating a Query Language sentence and transmitting it to the server computer.

In this client computer, the table data in the database is converted into a spreadsheet format that can be handled by a spreadsheet processing program, displayed on a screen, and edited using interactive spreadsheet processing. Process. Also, by automatically generating an SQL sentence according to the processing content and sending it to the server computer,
The processed data content is reflected in the relational database of the server computer.

[0008]

In the above-described conventional database system, since the client computer processes and corrects the table data of the server computer, the load on the server computer can be reduced.

However, since it is necessary to convert the data to be processed into a table format once, the conversion process of the client computer to the spreadsheet causes a reduction in the throughput of the entire system. Further, since the master file is updated by SQL, the update process is required twice for the spreadsheet and for the master file.

In general data control in the client / server type financial system as described above, as shown in FIG. 5, a financial application 17 of the client computer 1 sends a request to the database management system 23 of the server computer 2. To search / update the database 24 and retrieve the search result. This financial system is suitable for a case where financial data of a single company is used by a plurality of clients at the same time as in corporate accounting.

However, in a financial system of an accounting firm in which a plurality of clients are required to use data from a plurality of different companies simultaneously and at high speed, the load on the database management system 23 of the server computer 2 increases, and LAN (LocalA) connecting computer 1 and server computer 2
area (not shown) increases, and the throughput of the entire system decreases.

As means for reducing the load on the server computer 2, there has been proposed a method in which a program on the client computer 1 is devised, as in the technique described in the above-mentioned publication, but a method for processing the maximum data is proposed. Measures have not been reached.

Accordingly, an object of the present invention is to solve the above-mentioned problems, improve the throughput of the entire system, and complete the update of the master file by a single process. To provide an accounting system.

[0014]

SUMMARY OF THE INVENTION A client / server financial accounting system according to the present invention is a client / server financial system configured to transfer financial data managed by a server computer to a client computer executing financial processing. An accounting system, wherein a database for storing a plurality of company tables in which the financial data is stored independently for each company, and a company table corresponding to a company specified by the client computer are read from the database; A transfer means for transferring to the client computer; a local database for storing the company table transferred from the transfer means; and updating of the financial data for the company table stored in the local database. And updating and retrieval means for fine search, and execution means for executing the financial transactions based on the update and retrieval means for processing results are provided to the client computer.

That is, in the client / server type financial accounting system of the present invention, a database of financial data managed by a server computer is constructed in an independent configuration for each company, and a client computer for executing financial processing in a financial database for each company. Transfer to

Each client executes a database management system having an update / query function equivalent to that of the server computer, and performs processing such as query / update of the database inside the client.

That is, in order to distribute the load of the server computer, a database engine having an update / query function equivalent to the database engine of the server computer is prepared in the client computer as a local database.

The financial data table is created as an independent file for each company, and a control table for controlling the security of the financial data for each company is created in the database of the server computer.

When the client computer selects a company that performs financial processing, the database management system of the server computer checks the processing status of the other client computers related to the company using the control table. As a result, if the table of the company can be used, the table of the company is transferred to the requesting client computer using the file transfer function.

In the client computer, a financial processing application program instructs a local database through a database management system to inquire, update, etc., according to an operator's instruction, and the local database executes these inquiries, updates, etc.

When the financial processing is completed, the file of the company table is transferred from the client computer to the server computer, and the server computer releases the security of the company in the control table.

This makes it possible to distribute the load on the server computer and improve the throughput of the entire system. In this case, the application of the client computer is limited to the financial application, a local database is arranged on the client computer, and the configuration of the database is constructed independently for each company.

Therefore, since no special conversion is required, the throughput of the entire system is not reduced, and the update of the master file is completed in one process, so that the processes from a plurality of client computers to the same company are stabilized. It becomes feasible.

[0024]

Next, an embodiment of the present invention will be described with reference to the drawings. FIG. 1 is a block diagram showing the configuration of a client / server financial accounting system according to one embodiment of the present invention. In the figure, client computers 1-1 to 1-n are L
AN (Local Area Network) cards 11-1 to 11-n (LAN cards 11-2 to 11-n)
Are not shown) and the LAN OS (Operating
System) 12-1 to 12-n (LAN OS12
-2-12-n are not shown), and the file transfer means 12
a-1 to 12a-n (file transfer means 12a-2 to 12a-1)
2a-n are not shown) and OSs 13-1 to 13-n (O
S13-2 to 13-n are not shown), database management systems 14-1 to 14-n (database management systems 14-2 to 14-n are not shown), and local database 15-1 ~ 15-n (local database 1
5-2 to 15-n are not shown) and local disk devices 16-1 to 16-n (local disk device 16-2).
16-n are not shown) and the financial application 17
-1 to 17-n (financial application 17-2 to 17
−n is not shown), and has basic functions of a general computer such as a control CPU, a memory, a console, and a keyboard.

The LAN cards 11-1 to 11-n are LAN
100, the LAN OSs 12-1 to 12-n control connection to a network. File transfer means 1
2a-1 to 12a-n are LAN OSs 12-1 to 12-
n, and controls file transfer with a server computer (hereinafter, referred to as a server) 2.

The OSs 13-1 to 13-n are clients 1.
Each part in -1 to 1-n is controlled. The database management systems 14-1 to 14-n are connected to the local disk device 16
Local database 15 stored in -1 to 16-n
-1 to 15-n are managed. Finance Application 17
-1 to 17-n operate on the above environment.

The server 2 is an LA connected to the LAN 100
An N card 21, a network OS 22 for controlling a network, a database management system 23, a database 24, and a disk device 25 for storing the database 24 are provided. A general computer such as a control CPU, a memory, and a maintenance console is provided. It has the basic functions of

In the above system, a plurality of clients 1
Servers 1 to 1-n are connected to each other by a LAN 100, and resources such as files, printers, and databases are shared by a plurality of clients 1-1 to 1-n by various service functions of the server 2.

FIG. 2 shows a client / client according to an embodiment of the present invention.
It is a figure showing the data flow of a server type financial accounting system. The operation of the client / server financial accounting system according to one embodiment of the present invention will be described with reference to FIG.

The client 1-1 is equipped with a local database management system 14-1, and the file of the company table 24b-1 of the server 2 is transferred to the company table 15a-1 of one company for each client.
Local database 15 inside client 1-1
-1 update / search is being executed.

The updated company table 15a-1 is transferred to the company table 24a-1 of the server 2 by a file after the financial processing is completed, and returns to the management of the database management system 23 of the server 2.

In this financial system, one client can basically perform financial processing for one company. In actual operation, journal data is input from a plurality of clients 1-1 to 1-n at the same time,
There is a case where forms of the same company are simultaneously output from -1 to 1-n. Therefore, means for these operations will be described below.

FIG. 3 shows a client / client according to an embodiment of the present invention.
Client 1-1 in server type financial accounting system
FIG. 4 is a diagram showing the flow of additional journal entry from .about.1-n to the same company, and FIG. 4 is a diagram showing the configuration of the control table 24a of FIG.

In FIG. 4, the control table 24
a is composed of a client ID field A1, a company ID field A2, and a use state field A3. An ID number uniquely assigned to each of the clients 1-1 to 1-n is stored in the client ID field A1, and an ID number uniquely assigned to each company is stored in the company ID field A2. The status field A3 indicates whether or not the financial data of the company selected by each of the clients 1-1 to 1-n has been updated.

In FIG. 4, a client having an ID number of 001 and 003 is executing a process for a company having an ID number of 1000. In this case, since the client with the ID number = 003 is being updated, other clients including the client with the ID number = 001 have the ID number = 1000.
Cannot be updated for another company.

However, the processing of only reference without updating, for example, form printing and graph display, does not impair the consistency of the database of the entire system.
It is possible to give permission to -1 to 1-n.
Note that the client 1-1 that performs only referencing discards the company table 15a-1 transferred to the local database 15-1 at the end of the financial processing and does not return it to the server 2. In this manner, the financial reports of the same company can be simultaneously printed or displayed from the plurality of clients 1-1 to 1-n.

Next, the simultaneous journal entry from a plurality of clients 1-1 to 1-n for the same company will be described with reference to FIG. Although the client with the ID number = 001 in FIG. 4 is given only authority for reference, the client does not update the company table 15a-1 itself in FIG.
It is possible to newly create the additional journal table 15b-1 and temporarily add the journal data so as not to impair the consistency of the entire system.

After the financial processing is completed, the additional journal table 15b
-1 to the server 2 and waits until the update process of the client 1-3 (not shown) having the ID number = 003 is completed. Server 2 is client 1-3 with ID number = 003
When the update end instruction is received from, the additional journal table 2
4c is added to the company table 24b-1. In this way, the client 1 with ID number = 001, 003
Updates and additions to company data with ID numbers of 1000 from 1, 1-3 can be simultaneously realized.

As described above, the same update / update as the database engine (database management system 23) of the server 2 is performed.
The client 1 sends a database engine (database management systems 14-1 to 14-n) having an inquiry function
-1 to 1-n, a table of financial data is stored in an independent file for each company (company tables 24b-1 to 24b).
-M), a control table 24a for controlling the security of financial data on a company basis is created in the database 24 of the server 2, and when the client 1-1 to 1-n selects a company that performs financial processing. The database management system 23 of the server 2 checks the processing status of another client computer relating to the company by the control table 24a, and according to the result, the company tables 24b-1 to 24b-
M is transferred to the requesting clients 1-1 to 1-n by the file transfer function, and the company tables 24b-1 to 24b are transmitted.
-M is stored in the local databases 15-1 to 15-n of the clients 1-1 to 1-n, and the database management systems 14-1 to 14-n are searched for the company tables 24b-1 to 24b-M. The financial applications 17-1 to 17-n execute financial processing based on the result, and the database management system 1 according to the processing result.
4-1 to 14-n are company tables 15a-1 to 15a-
n after updating the company tables 15a-1 to 15a
By transferring -n to the server 2, the load on the server 2 can be distributed, and the throughput of the entire system can be improved.

In this case, the local databases 15-1 to 15-n are arranged in the clients 1-1 to 1-n, and the database is constructed independently for each company, so that special conversion is not required. Therefore, since the update of the master file can be completed in one process without lowering the throughput of the entire system, the processes from a plurality of clients 1-1 to 1-n to the same company can be stably performed. Can be realized.

[0041]

As described above, according to the present invention, in a client / server type financial accounting system configured to transfer financial data managed by a server computer to a client computer executing financial processing, A server computer that stores a plurality of company tables independently constructed for each company, and a transfer unit that reads a company table corresponding to a company specified by a client computer from the database and transfers the table to the client computer. A local database for storing the company table transferred from the transfer means, an update / search means for updating and searching for financial data for the company table stored in the local database, and processing of the update / search means Goods based on the results By providing an execution unit for executing the processing to the client computers, it is possible to improve the throughput of the whole system, there is an effect that it is possible to terminate the updating of master file 1 degree of processing.

[Brief description of the drawings]

FIG. 1 is a block diagram showing a configuration of a client / server financial accounting system according to an embodiment of the present invention.

FIG. 2 is a diagram showing a data flow of a client / server financial accounting system according to an embodiment of the present invention.

FIG. 3 is a diagram showing a flow of a journal addition input from a client to the same company in a client / server financial accounting system according to an embodiment of the present invention.

FIG. 4 is a diagram showing a configuration of a control table in FIG. 2;

FIG. 5 is a diagram showing a data flow of a conventional client / server financial accounting system.

[Explanation of symbols]

 1-1 to 1-n Client computer 2 Server computer 11-1 and 21 LAN card 12-1 LAN OS 13-1 OS 14-1 and 23 Database management system 15-1 Local database 15a-1 Company table 15b -1, 24c Additional journal table 16-1 Local disk unit 17 Financial application 22 Network OS 24 Database 24a Control table 24b-1 to 24b-M Company table 25 Disk unit

Claims (5)

[Claims] 1. A client / server type financial accounting system configured to transfer financial data managed by a server computer to a client computer executing financial processing, wherein the financial data is independent for each company. The server computer having a database for storing a plurality of company tables stored therein, and transfer means for reading a company table corresponding to a company specified by the client computer from the database and transferring the table to the client computer; A local database that stores the company table transferred from the transfer unit, an update / search unit that updates and searches the financial data with respect to the company table stored in the local database, and the update / search unit Based on the processing result of Client / server financial accounting system characterized by having an execution unit for executing the financial transactions to the client computer. 2. The control means according to claim 2, wherein said transfer means stores identification information for identifying a client computer that uses said company table in correspondence with each of said plurality of company tables, and a status of use by said client computer; Determining means for determining whether or not the company table is usable based on the held contents of the file, and transferring the company table to the requesting client computer by a file transfer function when the determining means determines that the table is usable. 2. The client / server financial accounting system according to claim 1, further comprising means. 3. The client / server type financial accounting system according to claim 1, wherein the update / retrieval means has an update / query function equivalent to a database engine of the server computer. 4. The execution means transfers a file of the company table updated in the financial process to the server computer when the financial process is completed, and executes the company table when the company table is used only for reference. 4. The client / server financial accounting system according to claim 1, wherein the client / server financial accounting system is configured to discard the account. 5. An additional journal table for temporarily storing journal data to be added to the company table when referring to the company table, and journal data for the additional journal table at the end of the financial processing based on the reference to the company table. Means for transferring to the server computer, the client computer includes: a temporary holding means for temporarily holding journal data of the additional journal table transferred from the client computer; and 2. The server computer further comprising means for adding the journal data to the company table.
The client / server type financial accounting system according to any one of claims 1 to 4.