Specification
DESCRIPTION
DATABASE, SLIP DATA MANAGEMENT SERVER, AND INDEX DATA MANAGEMENT PROGRAM
Technical Field [0001]
The present invention relates to a database for storing an index table in which index data used for retrieval of slip data, which are generated for every business unit in a business process, are registered, a slip data management server provided with this database and an index data management program contained in the slip data management server.
Background Art [0002]
Heretofore, one so-called ERP (Enterprise Resource Planning) has become mainstream as package software for establishing a core business system for a company. In a core business system in which this ERP is contained, it is most often constructed on a relational database, and design of an application program that focuses on business processes is mostly made. Thus, it is often operated without focusing on an report output. [0003]
For the purpose of processing the large amount of business data at a high speed, analyzing the business data from various angles, and outputting reports under such a situation, various data warehouse systems that undertake a complementary role to the core business system have been provided (see Patent Literature 1).
2
Prior Art Literature
Patent Literature [0004]
Patent Literature 1: Japanese Patent Application Publication No. 2002-312208
Summary of the Invention
Problems to be solved by the Invention [0005]
However, in the conventional data warehouse system, business data of each business acquired from a core business system side are managed, but report data for each business are merely provided. For this reason, there has been a problem that it is required to retrieve each of report data on each related business by tracing slip numbers and to acquire them separately in order to confirm progress of each business. [0006]
Further, since slip data related to respective businesses are held at a core business system side, there has been a problem that it is also required to retrieve each of slip data on the related businesses by tracing slip numbers and to acquire them separately in order to confirm progress of the business and the like. ^ [0007]
It is an object of the present invention to resolve the problems described above and to establish a system capable of readily making an inquiry into progress of a business and the like without carrying out a burdensome retrieving task.
Means for Solving the Problems [0008]
According to the present invention, there is provided a
3
database for storing an index table therein, index data being registered in the index table, the index data being used for retrieval of slip data, the slip data being generated for every business unit in a business process, wherein the index data are data that contain a plurality of slip processed data respectively corresponding to the slip data, wherein the slip processed data are data in which a specific item and the content of the specific item are associated with each other in unit of slip data, and the specific item contains a predetermined item suitable for grasp of a business process in each business and a key item defined in advance in each business among items respectively set up to the slip data on various kinds of businesses, and wherein the index data are stored in the index table in a state where the content of the specific item respectively indicated by the plurality of slip processed data corresponding to the slip data can be arranged for every specific item. [0009]
By configuring it as described above, it becomes possible to establish a system capable of readily making an inquiry into progress of a business and the like without carrying out a burdensome retrieving task. [0010]
The database may be configured so that a slip number of a business indicated by the slip data corresponding to the slip processed data and a slip number of a business indicated by the slip data generated for the business that has been carried out before the business in the business process including the business indicated by the slip data are contained in the predetermined item of the slip processed data. [0011]
The database may be configured so that the database is provided in a slip data management server that manages the slip data generated for every business unit, and the slip data management server includes an index data provider for providing, in response to a request from a client terminal, a part or all of the index data registered in the index table stored in the database to the client terminal. [0012]
Further, according to the present invention, there is provided a slip data management server for managing slip data, the slip data being generated for every business unit in a business process, the slip data management server including: a database for storing an index table therein, the index data used for retrieval of slip data being registered in the index table; and an index data provider for providing, in response to a request from a client terminal, a part or all of the index data registered in the index table stored in the database to the client terminal, wherein the index data are data that contain a plurality of slip processed data respectively corresponding to the slip data, wherein the slip processed data are data in which a specific item and the content of the specific item are associated with each other in unit of slip data, and the specific item contains a predetermined item suitable for grasp of a business process in each business and a key item defined in advance in each business among items respectively set up to the slip data on various kinds of businesses, and wherein the index data are stored in the index table in a state where the content of the specific item respectively indicated by the plurality of slip processed data corresponding to the slip data can be arranged for every specific item. [0013]
5
Moreover, according to the present invention, there is provided an index data management program for causing a slip data management server to manage index data, the slip data management server being provided with a database for storing an index table, the index data being registered in the index table, the index data being used for retrieval of slip data, the slip data being generated for every business unit in a business process, wherein the index data are data that contain a plurality of slip processed data respectively corresponding to the slip data, wherein the slip processed data are data in which a specific item and the content of the specific item are associated with each other in unit of slip data, and the specific item contains a predetermined item suitable for grasp of a business process in each business and a key item defined in advance in each business among items respectively set up to the slip data on various kinds of businesses, wherein the index data are stored in the index table in a state where the content of the specific item respectively indicated by the plurality of slip processed data corresponding to the slip data can be arranged for every specific item, and wherein the index data management program causes the slip data management server to execute: providing, in response to a request from a client terminal, a part or all of the index data registered in the index table stored in the database to the client terminal.
Effects of the Invention [0014]
According to the present invention, it becomes possible to establish a system capable of readily making an inquiry into progress of a business and the like without carrying out a burdensome retrieving task.
c
Brief Description of the Drawings [0015]
FIG. 1 is a block diagram showing a configuration example of a report inquiry system according to one embodiment of the present invention.
FIGS. 2A and 2B are explanatory drawings showing an example of a storage state of index data registered in an index table.
FIG. 3 is a flowchart showing an example of a database updating process.
FIG. 4 is a flowchart showing an example of an index data outputting process.
FIG. 5 is an explanatory drawing showing an example of a retrieval key input screen.
FIG. 6 is an explanatory drawing showing an example of an index data display screen.
FIG. 7 is an explanatory drawing showing an example of an extraction result display screen.
FIG. 8 is an explanatory drawing showing other example of the extraction result display screen.
Mode for Carrying out the Invention [0016]
Hereinafter, an example of one embodiment according to the present invention will be described with reference to the drawings. [0017]
FIG. 1 is a block diagram showing a configuration example of a report inquiry system 500 according to one embodiment of the present invention. As shown in FIG. 1, the report inquiry system 500 includes a core business server 200, a data warehouse server (DWH server) 300, a client 10 and a client 20. The
7
respective elements, which constitute the report inquiry system
500, are connected by a communication network.
[0018]
In the present embodiment, the core business server 200 is connected to the DWH server 300 by means of a dedicated line 51. Further, the client 10 is connected to the DWH server 300 by means of a LAN (Local Area Network) 52. Further, the client 20 is connected to the DWH server 300 by means of the Internet 53. [0019]
The core business server 200 is a server managed by a data collector who is a collecting target of report data, for example, and has various kinds of functions for managing report information on various kinds of businesses. The core business server 200 is configured by a general information-processing apparatus provided with an OS (Operating System) and a relational DB. In this regard, the report is the general term of books and a type of slip. Further, the books denote one in which matters concerning purse of money or goods are filled, and the slip denotes one that is data to become a basis when to create books and constitutes evidence of transactions and the like on a business. In the present embodiment, the case where the core business server 200 treats only the slip data as report data will be described as an example. [0020]
In the present embodiment, the core business server 200 includes a business application program DB 210, a slip data DB 220A and an index table DB 220B. [0021]
The business application program DB 210 is a storage medium for storing programs used for various kinds of businesses. A sales business management program, a sales business
management program, a production management program, a financial accounting management program, a managerial accounting management program and the like are included in the programs stored in the business application program DB 210. [0022]
The slip data DB 220A is a storage medium for storing various kinds of slip data collected and marshaled by means of various kinds of information processing using various kinds of programs stored in the business application program DB 210. In the slip data DB 220A, for example, received order slip header information, received order slip description information, delivery date schedules and the like are associated with slip data corresponding to a received order slip, and they are stored in a structure capable of retrieving them on the basis of a key, such as a slip number. In this regard, the slip number includes a received order number, a purchase order number, a shipment number, an acceptance or delivery number, a bill reference, a billing number, an accounting number and the like. [0023]
The index table DB 220B is a storage medium for storing an index table in which index data are registered. The index data are updated (or created) on the basis of relevance between respective slips indicated by the slip data that are stored in the slip data DB 220A. The index data are data used for retrieval of slip data, and contain a plurality of slip processed data respectively corresponding to the slip data. Namely, in the present embodiment, all of the data stored in the index table, which is a storage region, is called as the index data, and the respective data constituting the index data are called as the slip processed data. [0024]
Here, the slip processed data are data in which a specific
item and data indicating the content of the specific item are associated with each other in unit of slip data. The specific item contains a predetermined item suitable for grasp of a business process in each business and a key item defined in advance in each business among items respectively set up to the slip data on various kinds of businesses. [0025]
The specific item in the slip processed data is set up in advance in a storage region of the core business server 200. In this regard, in the present embodiment, setup of the specific item can be changed appropriately by a manager of the core business server 200 or the like. [0026]
Further, it is preferable that the key item is data becoming an important element for specifying a slip indicated by the slip data. In the present embodiment, the case where a slip number is set up as the key item will be described as an example. In this regard, the key item is not limited to a slip number. It may not be contained in the predetermined item of the slip processed data so long as it is data contained in the slip data. [0027]
The index table DB 220B stores the index data therein in a state where the content of the specific items respectively indicated by a plurality of slip processed data corresponding to the slip data can be arranged for every specific item. Namely, they are stored in the index data so that the specific items of the plurality of slip processed data are respectively associated with each other. In this regard, the index table DB 220B may be provided in the DWH server 300. [0028]
FIGS. 2A and 2B are explanatory drawings showing an
10
example of a storage state of index data registered in the index table stored in the index table DB 220B. As shown in FIGS. 2A and 2B, the index data contain: types, which are predetermined items indicated by the stored slip processed data; business partners (debts and credits); item goods; plants; reference date 1 (required date); reference date 2 (closing date); received order numbers; purchase order numbers; shipment numbers; acceptance or delivery numbers; bill references; billing numbers; accounting numbers; required quantities (signed); required quantities (plus (+)); and required quantities (minus (-) ) . Further, the index data contain a slip number as the key item (key) indicated by the stored slip processed data. Therefore, in the present embodiment, a slip number as the predetermined item and a slip number as the key item are separately managed in each of the slip processed data contained in the index data. [0029]
Further, in the present embodiment, in the case where there is a business that has been carried out before the business indicated by the slip data in the business process including the slip number of the business indicated by the slip data respectively corresponding to the slip processed data and the business indicated by the slip data, the slip processed data containing data indicating the slip number contain the slip number of the business indicated by the slip data generated by carrying out the business . Namely, for example, slip processed data, which are slip data on a shipment business and contain data CI indicating a shipment number, contain data Al, which contain a received order number indicating a received order business by which implementation of this shipment business is caused. [0030]
II
In this regard, in the case where each of the slip processed data does not contain corresponding data among items constituting the index data, the item is treated as blank data. In this regard, slip processed data that do not meet an index data creating condition stored in the index table DB 220B in advance may be configured so as not to be contained in the index data. Namely, for example, by eliminating slip processed data that contain no data indicating a slip number to create the index data, it is possible to treat only slip processed data for which relevance among slips can be grasped from the slip numbers, and this makes it possible to prevent an unnecessary processing load to manage unsuitable data. [0031]
In this regard, the core business server 200 has a function to convert various kinds of data (slip data and index data) respectively stored in the slip data DB 220A and the index table DB 220B into a CSV (Comma Separated Values) format in accordance with a predetermined extraction condition, and a function to transmit them to the DWH server 300. In this regard, in the present embodiment, the core business server 200 transfers the data file converted into the CSV format by FTP (File Transfer Protocol) to the DWH server 300. [0032]
The DWH server 300 is a server managed by a system manager of the present system, for example, and has various kinds of functions to realize a data warehouse. Here, the data warehouse means a system that analyzes relevance between the respective items among business data such as report data accumulated in chronological order. Further, the DWH server 300 has a function to register various kinds of data in a predetermined storage region by converting a file with a CSV format, which is transferred from the core business server 200, into a
\1
predetermined data format or the like. In this regard, the DWH server 300 may be configured so as to extract data according to the respective storage regions from a state of the CSV format without carrying out conversion of data formats. [0033]
Each of the clients 10, 20 is an information-processing apparatus provided with a CPU (Central Processing Unit) , a ROM, a RAM, a display section and the like. In the present embodiment, each of the clients 10, 20 has various kinds of applications available for treating report data, such as a Web browser, spreadsheet software and the like. Further, in the present embodiment, each of the clients 10, 20 has a function to define a query (a retrieval item, a retrieval key, an extraction key and the like) for acquiring necessary report data from the DWH server 300 in response to an operational input by a user, for example, and a function to transmit it to the DWH server 300. [0034]
In the present embodiment, the client 10 has a function to communicate with the DWH server 300 via a LAN and a function to output the data acquired from the DWH server 300 onto the display section by means of the predetermined spreadsheet software. [0035]
Further, the client 20 has a function to communicate with the DWH server 300 via the Internet and a function to output the data acquired from the DWH server 300 onto the display section by means of the Web browser. [0036]
In this regard, in the present embodiment, each of the clients 10, 20 has a function to output the index table stored in the index table DB 220B of the core business server 200 onto the display section using predetermined application software.
\3
[0037]
In this regard, the configuration of the report inquiry-system is not limited to this, and it may be configured so that the clients 10, 20 are allowed to directly transmit and receive data to and from the core business server 200 without the DWH server 300, for example. Namely, each of the clients 10, 20 may be configured so as to be capable of accessing the index table DB 220B. [0038]
Next, an operation of the core business server 200 in the report inquiry system 500 according to the present embodiment will be described with reference to the drawings. In this regard, the content of operation and processes particularly with no relationship to the present invention may be omitted. [0039]
FIG. 3 is a flowchart showing an example of a database updating process carried out by the core business server 200. In the database updating process, a process to update the slip data DB 220A and the index table DB 220B in the core business server 200 is carried out. [0040]
In the database updating process, the core business server 200 first determines whether new slip data are acquired or not (Step SlOl). [0041]
In the case where it is determined that the new slip data are acquired ("Yes" at Step SlOl), the core business server 200 updates the slip database 220A (Step S102), and extracts data according to a predetermined item from the newly acquired slip data (Step S103) . [0042]
Here, the core business server 200 extracts the.
m
predetermined item from the slip data on the basis of an extraction condition stored in advance in a storage medium included in the core business server 200. It is preferable that a condition to extract an item indicating relevance between other slips or an item indicating an element that becomes a key of each slip is set up in the slip data as the extraction condition. In the present embodiment, the core business server 200 extracts data corresponding to a specific item set up as the slip processed data from the slip data. [0043]
When the data corresponding to the specific item set up as the slip processed data are extracted from the slip data, the core business server 200 determines whether there are data corresponding to a predetermined computational item in the extracted data or not (Step S104) . Here, in the case where it is determined that there are no data corresponding to the predetermined computational item ("No" at Step S104), the core business server 200 causes the process to shift to Step S106 (will be described later). [0046]
On the other hand, in the case where it is determined that there are the data corresponding to the predeterinined computational item ("Yes" at Step S104), the core business server 200 carries out arithmetic processing in accordance with arithmetic expressions (including an arithmetic expression using one or two or more other items in the index data) set up in advance in the computational item (Step S105). [0047]
When a computational result is acquired by carrying out the computation, the core business server 200 adds the extracted data and the computational result into the index data (Step S106) , and causes the process to shift to Step SlOl. This makes
15
it possible to cut out the need to carry out arithmetic processing when to provide index data to the DWH server 300 or the like, and it is possible to eliminate an arithmetic program for this process. [0048]
In this regard, in the present embodiment, all of the items that the slip processed data may contain are set up in the index data. [0049]
Next, operations of the core business server 200, the DWH server 300 and the clients 10, 20 in the report inquiry system 500 according to the present embodiment will be described with reference to the drawings. In this regard, the content of operations and processes particularly with no relationship to the present invention may be omitted. [0050]
FIG. 4 is a flowchart showing an example of an index data outputting process carried out by the DWH server 300 and the client 10. In the index data outputting process, a process in which the client 10 acquires the index data (a part or all of the index data) from the core business server 200 via the DWH server 300 to output them is carried out. In this regard, since a kind of communication network of the client 10 is different from that of the client 20 merely, the case of using the client 10 will be described as an example in the present embodiment. Further, the DWH server 300 in the present embodiment merely assists in carrying out communication between the core business server 200 and the client 10 (for example, authentication of a client and the like). Therefore, explanation about an operation of the DWH server 300 is omitted hereinafter. [0051]
In the index data outputting process, the client 10 first
1
Documents
Application Documents
| # |
Name |
Date |
| 1 |
2520-DELNP-2012-AbandonedLetter.pdf |
2019-10-17 |
| 1 |
2520-delnp-2012-Form-18-(18-07-2012).pdf |
2012-07-18 |
| 2 |
2520-delnp-2012-Correspondence-Others-(18-07-2012).pdf |
2012-07-18 |
| 2 |
2520-DELNP-2012-FER.pdf |
2018-09-28 |
| 3 |
2520-delnp-2012-Form-13-(08-08-2012).pdf |
2012-08-08 |
| 3 |
2520-delnp-2012-Correspondance Others-(19-12-2014).pdf |
2014-12-19 |
| 4 |
2520-delnp-2012-Others-(19-12-2014).pdf |
2014-12-19 |
| 4 |
2520-delnp-2012-Form-1-(08-08-2012).pdf |
2012-08-08 |
| 5 |
2520-delnp-2012-Correspondence Others-(12-11-2013).pdf |
2013-11-12 |
| 5 |
2520-delnp-2012-Correspondence Others-(08-08-2012).pdf |
2012-08-08 |
| 6 |
2520-DELNP-2012-GPA-(21-09-2012).pdf |
2012-09-21 |
| 6 |
2520-delnp-2012-Form-3-(12-11-2013).pdf |
2013-11-12 |
| 7 |
2520-delnp-2012-Form-3-(21-09-2012).pdf |
2012-09-21 |
| 7 |
2520-delnp-2012-Correspondence Others-(14-06-2013).pdf |
2013-06-14 |
| 8 |
2520-delnp-2012-Form-3-(14-06-2013).pdf |
2013-06-14 |
| 8 |
2520-DELNP-2012-Form-1-(21-09-2012).pdf |
2012-09-21 |
| 9 |
2520-delnp-2012-Correspondance Others-(22-04-2013).pdf |
2013-04-22 |
| 9 |
2520-DELNP-2012-Correspondence-Others-(21-09-2012).pdf |
2012-09-21 |
| 10 |
2520-delnp-2012-Correspondence-Others-(21-09-2012)..pdf |
2012-09-21 |
| 10 |
2520-delnp-2012-Form-3-(22-04-2013).pdf |
2013-04-22 |
| 11 |
2520-delnp-2012-Abstract.pdf |
2013-03-04 |
| 11 |
2520-delnp-2012-Form-3-(23-11-2012).pdf |
2012-11-23 |
| 12 |
2520-delnp-2012-Claims.pdf |
2013-03-04 |
| 12 |
2520-delnp-2012-Correspondence Others-(23-11-2012).pdf |
2012-11-23 |
| 13 |
2520-delnp-2012-Correspondence-Others.pdf |
2013-03-04 |
| 13 |
2520-delnp-2012-Form-5.pdf |
2013-03-04 |
| 14 |
2520-delnp-2012-Description (Complete).pdf |
2013-03-04 |
| 14 |
2520-delnp-2012-Form-3.pdf |
2013-03-04 |
| 15 |
2520-delnp-2012-Drawings.pdf |
2013-03-04 |
| 15 |
2520-delnp-2012-Form-2.pdf |
2013-03-04 |
| 16 |
2520-delnp-2012-Form-1.pdf |
2013-03-04 |
| 17 |
2520-delnp-2012-Form-2.pdf |
2013-03-04 |
| 17 |
2520-delnp-2012-Drawings.pdf |
2013-03-04 |
| 18 |
2520-delnp-2012-Form-3.pdf |
2013-03-04 |
| 18 |
2520-delnp-2012-Description (Complete).pdf |
2013-03-04 |
| 19 |
2520-delnp-2012-Correspondence-Others.pdf |
2013-03-04 |
| 19 |
2520-delnp-2012-Form-5.pdf |
2013-03-04 |
| 20 |
2520-delnp-2012-Claims.pdf |
2013-03-04 |
| 20 |
2520-delnp-2012-Correspondence Others-(23-11-2012).pdf |
2012-11-23 |
| 21 |
2520-delnp-2012-Abstract.pdf |
2013-03-04 |
| 21 |
2520-delnp-2012-Form-3-(23-11-2012).pdf |
2012-11-23 |
| 22 |
2520-delnp-2012-Correspondence-Others-(21-09-2012)..pdf |
2012-09-21 |
| 22 |
2520-delnp-2012-Form-3-(22-04-2013).pdf |
2013-04-22 |
| 23 |
2520-delnp-2012-Correspondance Others-(22-04-2013).pdf |
2013-04-22 |
| 23 |
2520-DELNP-2012-Correspondence-Others-(21-09-2012).pdf |
2012-09-21 |
| 24 |
2520-delnp-2012-Form-3-(14-06-2013).pdf |
2013-06-14 |
| 24 |
2520-DELNP-2012-Form-1-(21-09-2012).pdf |
2012-09-21 |
| 25 |
2520-delnp-2012-Form-3-(21-09-2012).pdf |
2012-09-21 |
| 25 |
2520-delnp-2012-Correspondence Others-(14-06-2013).pdf |
2013-06-14 |
| 26 |
2520-DELNP-2012-GPA-(21-09-2012).pdf |
2012-09-21 |
| 26 |
2520-delnp-2012-Form-3-(12-11-2013).pdf |
2013-11-12 |
| 27 |
2520-delnp-2012-Correspondence Others-(12-11-2013).pdf |
2013-11-12 |
| 27 |
2520-delnp-2012-Correspondence Others-(08-08-2012).pdf |
2012-08-08 |
| 28 |
2520-delnp-2012-Others-(19-12-2014).pdf |
2014-12-19 |
| 28 |
2520-delnp-2012-Form-1-(08-08-2012).pdf |
2012-08-08 |
| 29 |
2520-delnp-2012-Form-13-(08-08-2012).pdf |
2012-08-08 |
| 29 |
2520-delnp-2012-Correspondance Others-(19-12-2014).pdf |
2014-12-19 |
| 30 |
2520-DELNP-2012-FER.pdf |
2018-09-28 |
| 30 |
2520-delnp-2012-Correspondence-Others-(18-07-2012).pdf |
2012-07-18 |
| 31 |
2520-DELNP-2012-AbandonedLetter.pdf |
2019-10-17 |
| 31 |
2520-delnp-2012-Form-18-(18-07-2012).pdf |
2012-07-18 |
Search Strategy