JP2003091634A - Data hierarchy structure of management system and data hierarchy construction method - Google Patents

Abstract

(57) [Summary] [PROBLEMS] To build a management system based on a system architecture in a form that is easy to integrate into an integrated system, to make duplication functions common, to make data linkage highly reliable, and to make functions highly expandable. Be flexible. The present invention has a data hierarchical structure of a management system constructed in a client server system including a server computer and a client computer, and displays an interface screen for receiving an operation input.
Screen 6, an event handler 7 for controlling logic for displaying an interface screen, business logic 9 for controlling data processing based on operation input, and a database 11 for storing data for data processing. DB access 10 for controlling access to data;
It is constructed by six layers including a communication M / W 8 for performing data communication between the client computer 3 and the server computer 4.

Description

Detailed Description of the Invention

[0001]

TECHNICAL FIELD The present invention relates to accounting management,
A data hierarchy of a management system for building a management system used for sales management, salary management, etc. on the basis of a system architecture that is easy to integrate into an integrated system that centrally manages these management systems. It relates to a structure and a data hierarchy construction method.

[0002]

2. Description of the Related Art Management systems used for accounting management, sales management, salary management, etc. have been developed as independent software.

However, in recent years, in order to carry out more speedy financial accounting, management accounting, etc., and to further improve business efficiency, it is important to integrate and manage all of these accounting, sales, or salary. It has become to.

For this reason, an integrated system capable of integrating and processing financially related management systems such as an accounting management system, a sales management system, and a salary management system, which have been conventionally constructed independently, is drawing attention.

By introducing such an integrated system, individual processing in business such as ordering, sales, and production can be immediately reflected as accounting information at the time of input. In addition, not only the information of all departments is updated at one time by one slip process (transaction), but also the accounting information summarized from there can trace the details of the contents (drill down), It becomes possible to link each transaction (slip) of business information one by one.

As described above, by introducing the integrated system as described above, the work efficiency can be improved.

[0007]

However, when constructing such an integrated system, there are the following problems.

That is, as shown in the concept of FIG.
The management systems such as the accounting management system A, the sales management system B, and the payroll management system C, which have been independently built up to now, are different in system architecture because they are systems created by completely different methods. There are many.

Therefore, it is often difficult to link or expand the management systems. Further, depending on the platform difference, some management systems can operate in a certain environment, while others cannot. Alternatively, each management system often has an overlapping function D.

Therefore, it is extremely difficult to construct the integrated system E based on each of these existing management systems. Further, even when the integrated system E is constructed from a completely new one, a huge amount of program needs to be developed due to the nature of the integrated system E, so that there is also a problem that it takes a lot of time and effort.

The present invention has been made in view of such circumstances, and by integrating the management systems by constructing the management systems based on a system architecture of a type that can be easily integrated into the integrated system. A management system that not only facilitates integration into the system, but also enables the construction of an efficient integrated system with commonality of duplicate functions, high reliability for data linkage, and high flexibility for expandability of functions. An object of the present invention is to provide a data hierarchy structure and a data hierarchy construction method.

[0012]

In order to achieve the above object, the present invention takes the following means.

That is, the data hierarchical structure of the management system according to the invention of claim 1 is constructed in a client-server system consisting of a server computer and a client computer connected to the server computer, and the operation input is performed via the client computer. Based on the data hierarchical structure of the management system that performs data processing on the server computer based on
It is constructed by at least the following four layers. That is, a screen display control layer that is built in the client computer and controls the display of the interface screen for operation input. A processing control layer that is built on a server computer and controls data processing based on operation input. A data access / storage hierarchy that is built into a server computer and controls the storage of data for data processing and access to the stored data. A communication layer that is built on both the client computer and the server computer and performs data communication between the client computer and the server computer.

Therefore, in the data hierarchical structure of the management system according to the first aspect of the present invention, as described above, each management system is constructed by the unified hierarchical structure, thereby facilitating the integration into the integrated system. You can

A data hierarchical structure of a management system according to a second aspect of the present invention is constructed in a client server system including a server computer and a client computer connected to the server computer, and is based on an operation input made via the client computer. The data hierarchical structure of a management system that performs data processing on a server computer is constructed by the following six layers. That is, a screen display layer that is constructed on a client computer and displays an interface screen that receives an operation input. A logic control layer that is built in the client computer and controls the logic for displaying the interface screen. A processing control layer that is built on a server computer and controls data processing based on operation input. A data storage layer that is built on a server computer and stores data for data processing. A data access layer that is built on a server computer and controls access to the data stored in the data storage layer. A communication layer that is built on both the client computer and the server computer and performs data communication between the client computer and the server computer.

Therefore, in the data hierarchy structure of the management system according to the second aspect of the present invention, as described above, each management system is constructed by the structure having the unified six layers, thereby facilitating the integration into the integrated system. Can be done.

According to a third aspect of the present invention, in the data hierarchical structure of the management system according to the first or second aspect of the present invention, the hierarchies built in the server computer are provided with a plurality of programs each having a different created programming language. .

Therefore, in the data hierarchical structure of the management system according to the third aspect of the invention, by taking the above means, it is possible to support a multi-client which supports the client function in a plurality of languages.

A method for constructing a data hierarchy of a management system according to a fourth aspect of the invention is constructed in a client server system consisting of a server computer and a client computer connected to the server computer, and is based on an operation input made via the client computer. Then, in the construction method for constructing the data hierarchy of the management system for performing the data processing in the server computer, the data hierarchy is constructed by the following six hierarchies. That is, a screen display layer that is constructed on a client computer and displays an interface screen that receives an operation input.
A logic control layer that is built in the client computer and controls the logic for displaying the interface screen.
A processing control layer that is built on a server computer and controls data processing based on operation input. A data storage layer that is built on a server computer and stores data for data processing. A data access layer that is built on a server computer and controls access to the data stored in the data storage layer. A communication layer that is built on both the client computer and the server computer and performs data communication between the client computer and the server computer.

Therefore, in the data hierarchy construction method for the management system according to the fourth aspect of the present invention, as described above, the management system is constructed by the unified structure of six hierarchies to facilitate integration into the integrated system. Can be done.

[0021]

BEST MODE FOR CARRYING OUT THE INVENTION Embodiments of the present invention will be described below with reference to the drawings.

An embodiment of the present invention will be described with reference to FIGS. 1 to 5.

FIG. 1 is a data structure diagram showing an example of a data hierarchical structure of the management system according to the embodiment of the present invention.

That is, the management system 1 according to the embodiment of the present invention comprises a client computer 3 and a server computer 4 which are connected to each other via a communication network 2. As shown in FIG. 1, the data hierarchy structure applied to such a management system 1 has a data hierarchy structure consisting of six hierarchies from the first hierarchy to the sixth hierarchy straddling the client computer 3 and the server computer 4. ing.

The client computer 3 is constructed from the first layer to the third layer, and the server computer 4 is constructed from the third layer to the sixth layer.

The first layer is Graphical Use
r Interface screen (hereinafter referred to as “GUI screen”) 6. The GUI screen 6 controls text boxes, buttons and the like.

The second layer is an event handler 7 composed of a logic group for controlling the appearance of the screen.

The third layer is communication middleware (hereinafter referred to as "communication M / W") 8 that controls data communication between the client computer 3 and the server computer 4. Therefore, this communication M / W 8 extends over the client computer 3 and the server computer 4.

The fourth layer is a business logic 9 consisting of a logic group closely related to the processing business of data processing and calculation.
Is.

The fifth layer is a database access (hereinafter referred to as "DB access") 10 including a logic group for performing database operations.

The sixth layer is a database 11 that holds data.

For example, the existing management systems to be integrated, such as the accounting management system A, the sales management system B, and the salary management system C, are applied to the data hierarchy structure of 6 layers as shown in FIG. Thus, each of these systems A to C is constructed into a unified system architecture. This not only facilitates integration with another management system, but also makes it possible to create a function overlapping with another management system to be integrated, as a common component group.

In this way, the existing management system is shown in FIG.
An example of the case of applying to a data hierarchical structure consisting of 6 layers as shown in FIG. 2 will be described with reference to FIG.

FIG. 2 is a specific division mode when the data input function 13 which is the existing management system is applied to the data hierarchical structure of the management system according to the present embodiment.

First, based on the function of the data input function 13, image information of the screen is arranged on the client computer 3 side as the GUI screen 6 of the first layer. Then the second
As the event handler 7 of the hierarchy, screen control information for controlling the GUI screen 6 of the first hierarchy is arranged.

Next, the third-level communication M / W 8 is divided and arranged in the client computer 3 and the server computer 4. The communication M / W 8 has a data transmission / reception function between the client computer 3 and the server computer 4.

Furthermore, on the server computer 4 side, the fourth hierarchy, the fifth hierarchy, and the sixth hierarchy, which are the third hierarchy and below, are arranged. In the example shown in FIG. 2, the business logic 9 of the fourth layer is separately arranged into a data registration business logic 9 (# 1) for performing data registration and a master search business logic 9 (# 2) for performing master search. is doing. The master search is a function used in data registration, but corresponds to a processing logic called “common component” that can be commonly used in other functions. In this way, each layer may be subdivided specifically for its function.

Next, an SQL statement issuing unit is arranged as the DB access 10 of the fifth layer, and a database table (hereinafter referred to as "DB table") is arranged as the database 11 of the sixth layer. S as DB access 10
The QL statement issuing unit further includes an SQL issuing unit (not shown) having only a function of issuing an SQL statement, and an SQL storage unit (not shown) storing the SQL statement actually issued by this SQL issuing unit. ), The data is registered in the DB 11 of the sixth layer, and the data registered in the DB 11 is searched.

Another example in which the existing management system is applied to the data hierarchical structure consisting of 6 layers as shown in FIG. 1 will be described with reference to FIG.

First, based on the function of the existing management system, the GUI screen 6 which is a screen image is arranged as the first layer on the client computer 3 side. The GUI screen 6 is a Visual language that is a programming language of Microsoft Corporation of the United States, depending on the programming language that configures the system.
GUI screen 6 (#a) compatible with Basic, Delp, a programming language developed and sold by Borland, Inc.
GUI screen 6 (#b) corresponding to hi, GUI screen 6 corresponding to VC ++, which is a programming language developed by Microsoft Corporation in the GUI environment based on the C ++ language so that interactive programming can be easily performed.
(#C) is arranged separately.

Similarly, as the event handler 7 of the second layer, the three GUI screens 6 (#
The three event handlers 7 (#a to #c) corresponding to a to #c) are separately arranged.

Next, the communication M / W 8 of the third layer is arranged in both the client computer 3 and the server computer 4.
The communication M / W 8 has a data transmission / reception function between the client computer 3 and the server computer 4.

Further, on the server computer 4 side, a fourth hierarchy, a fifth hierarchy, and a sixth hierarchy below the third hierarchy are arranged. In the example shown in FIG. 3, the business logic 9 of the fourth layer includes a login processing business logic 9 (#a) for performing login processing to this system, a data registration business logic 9 (#b) for performing data registration, The master search business logic 9 (#c) for performing master search and the print data creation business logic 9 (#d) for creating print data are separately arranged.

Finally, an SQL statement issuing unit is arranged as the DB access 10 of the fifth layer, and a DB table is arranged as the database 11 of the sixth layer.

In the data hierarchy structure shown in FIG. 3, the communication M / W 8 of the third hierarchy, the DB access 10 of the fifth hierarchy, and the database 11 of the sixth hierarchy are parts that depend on middleware such as databases and networks and OS. is there. This dependent part enables data exchange even with different middleware and OS. For example, by constructing the third layer, the fifth layer, and the sixth layer as components of Active-X, which is the Internet technology of Microsoft Corporation, the usage and functions in all middleware and OS that support Active-X. It can be expanded. As a result, it is possible to deal locally with a layer unit in case of a middleware or OS version upgrade or a trouble.

In the data hierarchy structure of the management system according to the embodiment of the present invention, as described above, the data hierarchy construction method consisting of the 6 hierarchy structure in which the function is clarified for each hierarchy is applied. The functions of layers 6 to 11 become clear. This makes it possible to provide a highly maintainable multi-platform that not only makes the interfaces of each layer clear but also ensures a unified system architecture. That is, it is possible to provide a multi-client that supports client functions in a plurality of languages.

Also for the communication M / W 8, a data delivery part can be created, and the protocol can be generalized.

Further, since the functions are divided for each of the layers 6 to 11, it is easy to separate the duplicated functions. As a result, it is possible to reduce an overlapping function part between functions and to create it as an independent common part.

As described above, since the unified system architecture is secured by applying the above-mentioned data hierarchy construction method to the existing management system, an integrated system integrating these existing management systems. Can be easily constructed. Also, since the common part can be easily extracted, it is also possible to reduce the number of manufacturing steps of this integrated system.

The preferred embodiments of the present invention have been described above with reference to the accompanying drawings, but the present invention is not limited to such configurations. Within the scope of the technical idea described in the claims, those skilled in the art can contemplate various modifications and modifications, and the modifications and modifications are also within the technical scope of the present invention. Be understood to belong to.

That is, the data hierarchical structure is not limited to the six hierarchical structure, and by appropriately integrating the functions of the respective hierarchical layers in the six hierarchical structure, the five hierarchical structure as shown in FIG. It can also be realized with a four-layer structure as shown in.

A five-layer structure as shown in FIG. 4 has a DB access / function which has the functions of the fifth-level DB access 10 and the sixth-level database 11 shown in FIG.
The DB main body 15 is the fifth layer.

On the other hand, in the four-layer structure shown in FIG. 5, the client screen 16 having the functions of the first layer which is the GUI screen 6 and the second layer which is the event handler 7 shown in FIG. Hierarchy, and below, the second hierarchy is communication M /
In this example, W8, the third hierarchy is the business logic 9, and the fourth hierarchy is the DB access / DB main body 15.

When considering the integration of each management system into an integrated system, it is generally better to divide the management system into a number of layers in advance, but the more divided it is, the more the existing management system is constructed. Since it takes time and labor, the number of layers of data structure to be constructed is appropriately set according to the number and size of each management system to be integrated into the integrated system.

[0055]

As described above, according to the present invention,
By constructing each management system on the basis of a system architecture in a form that can be easily integrated into the integrated system, the integration of each management system into the integrated system can be facilitated.

As described above, the data hierarchy structure and data of the management system capable of constructing an efficient integrated system having commonality of overlapping functions, high reliability for data interlocking, and high flexibility for expandability of functions. A hierarchical construction method can be realized.

[Brief description of drawings]

FIG. 1 is a data structure diagram showing an example of a data hierarchical structure of a management system according to an embodiment of the present invention.

FIG. 2 is a data structure diagram showing an example in which an existing system is applied to a data hierarchical structure consisting of 6 layers.

FIG. 3 is a data structure diagram showing another example when an existing system is applied to a data hierarchical structure consisting of 6 layers.

FIG. 4 is a data structure diagram showing an example of a data hierarchical structure composed of five layers.

FIG. 5 is a data structure diagram showing an example of a data hierarchical structure composed of four layers.

[Figure 6] Conceptual diagram of integrated system

[Explanation of symbols]

A: Accounting management system B ... Sales management system C ... Salary management system D ... Duplicate function E ... Integrated system 1 ... Management system 2 ... Communication network 3 ... Client computer 4 ... Server computer 6 ... GUI screen 7 ... Event handler 8 ... Communication middleware 9 ... Business logic 10 ... Database access (DB access) 11 ... Database (DB) 13 ... Data input function 15 ... DB access / DB main body 16 ... Client screen

Claims (4)

[Claims] 1. A management that is constructed in a client server system consisting of a server computer and a client computer connected to the server computer, and performs data processing in the server computer based on an operation input made via the client computer. A data hierarchical structure of a system, which is constructed in the client computer and performs a screen display control layer for controlling display of an interface screen for the operation input, and data processing based on the operation input constructed in the server computer. A processing control layer for controlling, a data access / storing layer that is built in the server computer and controls storage of data for the data processing and access to the stored data, the client computer and the server computer Built on both the client computer and Data hierarchy structure of the management system, characterized in that serial constructed by at least four layers consisting of a communications hierarchy for data communication between the server computer. 2. A management which is constructed in a client server system consisting of a server computer and a client computer connected to the server computer, and performs data processing in the server computer based on an operation input made through the client computer. A data hierarchical structure of a system, which is a screen display layer that is constructed in the client computer and displays an interface screen that receives the operation input, and a logic that is constructed in the client computer and that displays the interface screen. A logic control layer, a processing control layer that is built in the server computer and controls data processing based on the operation input, a data storage layer that is built in the server computer and stores data for the data processing, Built on the server computer, A data access layer for controlling access to data stored in the data storage layer, and communication for establishing data communication between the client computer and the server computer, which is built in both the client computer and the server computer A data hierarchy structure of a management system characterized by being constructed by 6 layers consisting of a hierarchy. 3. The data hierarchy structure of the management system according to claim 1 or 2, wherein the hierarchy built in the server computer is provided with a plurality of programs each having a different created programming language. Management system data hierarchy structure. 4. A management that is constructed in a client server system consisting of a server computer and a client computer connected to the server computer, and that performs data processing in the server computer based on an operation input made through the client computer. A construction method for constructing a data hierarchy of a system, comprising a screen display hierarchy constructed on the client computer and displaying an interface screen for accepting the operation input, and a construction constructed on the client computer for displaying the interface screen. A logic control layer that controls logic, a processing control layer that is built in the server computer and controls data processing based on the operation input, and a data storage that is built in the server computer and stores data for the data processing. Hierarchy and the server computer A data access layer that is built and controls access to data stored in the data storage layer, and data communication between the client computer and the server computer that is built in both the client computer and the server computer A method for constructing a data hierarchy of a management system, characterized in that the management system is constructed by six hierarchies consisting of a communication hierarchy for performing.