The title of the invention: database, business content data management server, and business content data management program
Technical field
[0001]
　The present invention is a database that stores the job contents data indicating the contents of the business of the business processes, business content data management server for managing the work contents data stored in the database, and work contents to be mounted on the work contents data management server about the data management program.
BACKGROUND
[0002]
　Conventionally, as a package software for building a core business systems in the enterprise, what are called ERP (Enterprise Resource Planning) has been a mainstream. The basic operation system which the ERP is mounted, relational and databases on becoming often be constructed by, often designing an application program that focuses on the operational process is performed, the focus is on the form output It is often operated without resides.
[0003]
　Under these circumstances, it processes large amounts of operational data at a high speed, and to analyze the operational data in a variety of perspectives, for the purpose of form output various data warehouses play a complementary role in the basic operation system system began to be provided (see Patent Document 1).
CITATION
Patent literature
[0004]
Patent Document 1: JP 2002-312208 JP
Summary of the invention
Problems that the Invention is to Solve
[0005]
　However, in the conventional data warehouse system, since it is so as to manage the operational data of each job acquired from the line-of-business system side, it stops to provide the form data for each job, and to grasp the business progress, etc. there has been a problem that it is impossible to provide the form data for multiple operations for.
[0006]
　Meanwhile, in order to manage the form data for multiple operations, it is necessary to mount and to develop new complex program for document management, development cost and operation cost is enormous. Therefore, it has been very difficult to realize a system for managing form data for multiple operations.
[0007]
　The present invention is to solve the problems described above, without requiring a complicated program for document management, and an object thereof is to be able to provide the form data for a plurality of business at low cost.
Means for Solving the Problems
[0008]
　Database of the present invention is a database for storing work contents data representing contents of the services in the business process, said business units each indicating respective contents of the operations of each business unit in the business process among the business content data and the one-dimensional data storage unit for storing the unit business content data as one-dimensional data, out of the contents of each business one-dimensional data stored in the one-dimensional data storage unit respectively, given that span multiple business units It is characterized in that the and a two-dimensional data storage unit for storing relevant work contents data for each of the related operations shown by integrating the contents as the two-dimensional data of the related operations.
[0009]
　By the the above configuration, without requiring a complicated program for document management, it is possible to provide a form data for multiple business at low cost.
[0010]
　Other of the contents of the associated business two-dimensional data stored in said two-dimensional data storage unit is indicated, the content or other two-dimensional data of the job indicated by the one-dimensional data stored in the one-dimensional data storage unit indicated A series operational contents data for each of the series operations that indicates the contents of the series operations may be configured to include a multi-dimensional data storage unit for storing a multi-dimensional data of the related operations certain that the the integrated contents.
[0011]
　The multi-dimensional data may be configured to include those which are set operational data content of a series operations, including the contents of the other set operations indicated other multi-dimensional data.
[0012]
　Provided in the business content data management server that manages the business content data, the business content data management server, the unit business content to get the unit operational content data from the unit business content data management server to collect the unit business content data first update that updates the data acquisition means, and registered in the one-dimensional data storage unit as the one-dimensional data unit work contents data acquired by the unit work contents data acquisition means the registered contents of the one-dimensional data storage unit and means, when the related business across multiple business units, including the contents of the business that one-dimensional data that has been registered by the first update means is shown to exist, two-dimensional data, which is a related business content data for the related services or it may be configured to to reflect the registration result of the one-dimensional data which has been registered and a second updating means for updating the registered contents of the two-dimensional data memory unit by said first updating means.
[0013]
　The work contents data management server, in response to a request from the client terminal, includes the operational contents data providing means for providing a work contents data stored in the database, the work contents data providing means is designated by said client terminal or it may be configured to provide one-dimensional data or two-dimensional data.
[0014]
　In addition, business content data management server of the present invention, there is provided a business content data management server that manages the business content data showing the contents of the business in business processes, and the database that stores the business content data, work in the business process and unit business content data acquisition means for acquiring the unit business content data from the unit business content data management server to collect unit business content data for each relevant business unit that shows the contents of each business per unit, respectively, the unit business content data the unit operational data content storage means for storing the unit operational contents data in the database acquired by the acquisition means, in response to a request from the client terminal, the business content data providing means for providing the stored business content data in the database includes bets, the database shows a one-dimensional data storage unit that stores a one-dimensional data to the unit work contents data of said work contents data, one-dimensional data stored in the one-dimensional data storage unit, respectively Of the contents of each job, and a two-dimensional data storage unit for storing relevant work contents data for each of the related operations shown by integrating the contents of certain related activities across multiple business unit as two-dimensional data, the BUSINESS data providing means, as the work contents data, characterized by providing at least a portion of said one-dimensional data or the two-dimensional data.
[0015]
　Furthermore, operational content data management program of the present invention is a business content data management program for managing the business content data to the business content data management server comprising a database for storing work contents data indicating the contents of the business of the business process matching, said the business content data management server, said the unit business content data from the unit business content data management server to collect unit business content data for each of the business units respectively showing the contents of each business of each business unit in the business process the unit operational contents data acquisition process of acquiring, the unit operational content data storage process for storing the unit operational contents data in the database acquired in the unit work contents data acquisition process, in response to a request from a client terminal, wherein to execute the business content data providing process for providing a work contents data stored in the database, the database, the one-dimensional data storage unit that stores a one-dimensional data to the unit work contents data of said work contents data, Of the contents of each business one-dimensional data stored in the one-dimensional data storage unit respectively, related business content data for each of the related operations shown by integrating the contents of certain related activities across multiple business units The and a two-dimensional data storage unit for storing a two-dimensional data, wherein in the operational data content providing process, as the business content data, to execute a process for providing at least a portion of said one-dimensional data or the two-dimensional data it is intended for.
Effect of the invention
[0016]
　According to the present invention, without requiring a complicated program for document management, it is possible to provide a form data for multiple business at low cost.
BRIEF DESCRIPTION OF THE DRAWINGS
[0017]
[Figure 1] is a block diagram showing a configuration example of a form inquiry system according to an embodiment of the present invention.
[Figure 2] is an explanatory diagram for explaining the relationship between the various cubes.
Is a flowchart illustrating an example of FIG. 3 slip data registration process.
It is a flowchart illustrating an example of FIG. 4 form output processing.
[Figure 5] is an explanatory view showing an example of a cube selection screen.
6 is an explanatory diagram showing an example of a registration item display screen.
7 is an explanatory diagram showing an example of a registration item selection screen.
8 is an explanatory diagram showing an example of a form display screen.
9 is an explanatory view showing another example of a form display screen.
EMBODIMENTS OF THE INVENTION
[0018]
　Hereinafter, an example of one embodiment of the present invention will be described with reference to the drawings.
[0019]
　Figure 1 is a block diagram showing a configuration example of a form query system 500 according to an embodiment of the present invention. As shown in Figure 1, form the query system 500 includes a line-of-business server 200, a data warehouse server (DWH server) 300, the client 10, the client 20. Each element constituting the document query system 500 is connected by the respective communication networks.
[0020]
　In this example, the line-of-business server 200 and DWH server 300 is assumed to be connected by a dedicated line 51. The client 10 is connected to the DWH server 300 by LAN (Local Area Network) 52. The client 20 is connected to the DWH server 300 via the Internet 53.
[0021]
　Line-of-business server 200 is, for example, a server managed by the data collectors being collected form data, has various functions for managing the form information about the various operations. Line-of-business server 200 is composed of a general information processing apparatus including an OS (Operating System) and relational DB. In addition, the form and is a generic term for books and slips. Moreover, carrying and are those regarding teller money and goods are entered, a document, it is to be the evidence of transactions on a data to be a basis for creating the books operations. In this example, line of business server 200, be described a case of handling only the slip data as form data in the case.
[0022]
　In this example, the line-of-business server 200 is provided with a business application program DB210, a slip data DB220.
[0023]
　Business application program DB210 is a storage medium that stores a program used for various operations. The programs that are stored in the business application program DB210, sales operations management program, sales operations management program, production management program, and the like financial accounting management program, and management accounting management program.
[0024]
　Slip data DB220 is a storage medium for storing various slip data that has been collected and organized, etc. by various kinds of information processing using the various programs stored in the business application program DB210. In slip data DB220, for example, for the slip data corresponding to the sales order, the sales order header information, sales order item information, and delivery date schedule is associated, in a searchable structure based on keys such as document number It is stored.
[0025]
　Moreover, line-of-business server 200, the various data stored in the document data DB220, CSV according to a predetermined criteria
has a function of transmitting the DWH server 300 is converted into (Comma Separated Values) format. It should be noted that, in this example, line-of-business server 200 transfers the data file that was in CSV format to DWH server 300 by FTP (File Transfer Protocol).
[0026]
　DWH server 300 is, for example, a server that is managed by the system administrator of the system, has various functions to realize the data warehouse. Here, the data warehouse, it says a system that analyzes the relationships between each of the items from the business data, such as form data that has been accumulated in the time series. Also, DWH server 300 by, for example, convert the CSV format file transferred from the line-of-business server 200 into a predetermined data format, and registers the document data in a predetermined storage area corresponding to the transferred document data features I have. Incidentally, DWH server 300 without conversion of the data format may be configured to register the document data into a predetermined storage region remains in the CSV format. Note that in this example, DWH server 300, line-of-business server 200 predetermined data from the document data transferred from (ie, data corresponding to the data that the one-dimensional cube is stored) by extracting, one-dimensional, which will be described later is registered only in the cube, with respect to the cubes belonging to other dimensions, the processing for reflecting the registration result of the one-dimensional cubes. The data to be registered in one-dimensional cube, is created as carrying data because from the received document data is obtained by extracting predetermined data simply Some those accumulated slip data, based on the slip data some others. Therefore, in this example, the data stored in the cube generally is referred to as "form data '.
[0027]
　In this example, DWH server 300 cubes that means a unit of storage area or the database comprises a plurality cubes group storage section 100 provided.
[0028]
　Cube group storage unit 100, the document data that has been transferred from the line-of-business server 200 is a database that stores in a predetermined format, composed of a plurality of cube hierarchy is defined.
[0029]
　In this example, the cube group storage unit 100, a one-dimensional cubes representing the cube of the primary tier to store the form data for each business transferred from the line-of-business server 200, which is the second tier the lower layer of the primary tier and two-dimensional cube that shows the cube, is constituted by a multi-dimensional cube that shows the multi-following hierarchy of the cube, which is a still of a is three and subsequent lower layer hierarchy of secondary hierarchy.
[0030]
　2 is an explanatory diagram for explaining the relationship between the various cubes making up the cube group storage section 100. Each dimension of the cube, which is managed by the cube group storage unit 100 has a hierarchical structure as shown in FIG. 2, for example. In the present example, it is assumed to be a cube located at the top of the hierarchical structure as the lower dimensional cube.
[0031]
　The one-dimensional cubes, of the form data, the form data corresponding to the contents of the operations of each business unit in the business process in accordance with the business application program is stored as one-dimensional data. In other words, the one-dimensional cube, for example, sales order item, shipping document item, invoice specification, form data corresponding to the content of each business, such as order document item is stored.
[0032]
　The two-dimensional cubes, of the contents of each business showing one-dimensional data, respectively, and the form data corresponding to the relevant business content per related operations shown by integrating the contents of certain related activities across multiple business units, and stored as two-dimensional data. That is, the two-dimensional cube, for example, certain related activities, such as orders ship delivery (orders, shipment, and delivery associated operations) form data indicating by integrating the content of is stored.
[0033]
　In the multidimensional cube, cube form data of a series of operations across the business showing the respective form data stored in a plurality of cubes containing the two-dimensional cube or other multidimensional cube is stored as multi-dimensional data is there.
[0034]
　That is, the multidimensional cube, for example, the contents of the related operations indicated by the two-dimensional data, a predetermined sequence that integrates the contents of the other related operations indicated by the contents, or other two-dimensional data of the job indicated by the one-dimensional data form data in response to a series business content of each series business that shows the contents of the business is stored as a multidimensional data. For example, the multidimensional cube, form data indicating by integrating the contents of the given set operations such as sales purchasing is stored.
[0035]
　As shown in FIG. 2, the multi-dimensional data, the form data corresponding to a set operational contents of the series operations, including the contents of the other set operations indicated by other multi-dimensional data is stored as multi-dimensional data If there is also. In this case, it will be the hierarchical structure is formed between the multidimensional cube.
[0036]
　Further, in this embodiment, as shown by the arrows in Figure 2, the cubes of the lower layer, and a cube of the plurality of upper layers of the form data used for generating the form data stored in a lower layer are respectively stored There is assumed to be associated in advance. The cube of the lower layer, the form data of the form data to the cube of the association that has been higher layer are stored respectively are integrated is stored. This correspondence is assumed to be predetermined by a system administrator depending on the contents of a form that is needed and relevant for each business.
[0037]
　Specifically, for example, in Figure 2, one-dimensional cube AO, AP, AQ, AY, AZ, from Aa, respectively, inventory status information, material valuation, orders inventory valuation, sales order stock, lot inventory, suppliers If it is a cube that stores the form data on special stock, one-dimensional cube AO, AP, AQ, AY, AZ, in a two-dimensional cube BG, which is associated in common to Aa, one-dimensional cube AO, AP, AQ, AY, AZ, Aa form data that integrate the document data stored in each of which would be stored. In this case, the form data stored in the two-dimensional cube BG is, for example, a form data representing the "inventory".
[0038]
　Also, the two-dimensional cube BG, and to store the form data that integrates one-dimensional cubes AJ (form data regarding goods movements item) is a multidimensional cube CD. In this example, the form data stored in the multidimensional cube CD, the form data corresponding to the "inventory receipts and payments".
[0039]
　The two-dimensional cubes and multidimensional cube, it is preferable to have high needs and desire to understand by integrating the form data of a plurality of related operations are stored, association is preset between each cube, primary By the data stored in the original cube is updated, the data stored in the two-dimensional cubes and multidimensional cube located under the one-dimensional cube is updated it also becomes possible to be updated.
[0040]
　In this way, since there is a structure previously provided with the two-dimensional cube or multidimensional cube as previously required, and performs operations for generating data corresponding to the form data stored in the two-dimensional cube or multidimensional cube it is possible to eliminate the need.
[0041]
　The client 10, 20, CPU (central processing unit), an information processing apparatus comprising ROM, RAM, and the display screen and the like. In this example, client 10 and 20, such as a Web browser or a spreadsheet, assumed to have a variety of applications available to handle form data. In the present example, client 10 and 20, for example in response to an operation input by a user, the cube name to query (see for acquiring the necessary form data from a DWH server 300, the item name to be used, the form layout information , extraction conditions, etc.) is defined, and has a function to be sent to the DWH server 300.
[0042]
　In this example, client 10 communicates with DWH server 300 via the LAN, has a function of outputting to the display screen data acquired from DWH server 300 by a given spreadsheet.
[0043]
　The client 20 communicates with DWH server 300 via the Internet, has a function of outputting the data acquired from DWH server 300 on the display screen by the Web browser.
[0044]
　Next, will be described with reference to the drawings, the operation of the line-of-business server 200 and DWH server 300 in the form query system 500 of the present example. Note that in particular not related operations and processes of the present invention may have been omitted its contents.
[0045]
　Figure 3 is a flow chart showing an example of a slip data registration processing and mission-critical server 200 and DWH server 300 executes. In slip data registration processing, processing for storing in the cube group storage unit 100 included in the DWH server 300 by extracting predetermined data from the stored document data in line-of-business server 200 is executed.
[0046]
　In slip data registration processing, first of all, line-of-business server 200, and stores the document data in the document data DB220 (step S101)
[0047]
　And, line-of-business server 200, for example, at a predetermined time interval, determines whether or not a predetermined slip data transmission condition is satisfied (step S102). Incidentally, the document data transmission condition is set to be stored in the storage unit in advance with the line-of-business server 200, for example, it is assumed that such "am elapsed 1:00" is set. Here, when the slip data transmission condition is determined not to be satisfied (N in step S102), line-of-business server 200 continues to accumulate slip data.
[0048]
　On the other hand, when determining that slip data transmission condition is satisfied (Y in step S102), line-of-business server 200 transfers the document data to DWH server 300 is converted into CSV format (step S103). Note that the file format for transferring the document data may be any format that can be processed by DWH server 300 may be another format other than the CSV format.
[0049]
　When you transfer the document data, line-of-business server 200, remove the transferred slip data from the document data DB220 (step S104), a transition to step S101. It should be noted that the line-of-business server 200, for example, in the case where the data amount of slip data does not exceed the predetermined amount, may be configured to leave the transferred slip data as already transferred data. In addition, mission-critical server 200 may be configured to keep stored the transferred to the slip data to another other storage medium and DHW server 300. In addition, line-of-business server 200, leave identifiable accumulated whether or not all of the slip data is already transferred data, and transfer only the non-transfer of data at step S103 in the document data stored It is, may be configured to not perform deletion in step S104.
[0050]
　Meanwhile, DWH server 300 receives the document data, converts the data format into a predetermined format (step S201), extracts the data corresponding the document data in each one-dimensional cubes and the corresponding primary and the extracted data It is registered in the original cube (step S202). DWH server 300, when the operation item is present in the item of the form data of one-dimensional cubes to be registered, at step S201, the other items in the arithmetic expressions (form data which is preset to the Factor 1 or performs arithmetic processing in accordance with the arithmetic expression) used two or more at step S202, processing is performed to set the operation result to the operation field. The so doing to, it is possible to eliminate the need to perform the operation process in providing form data, it can be a calculation program therefor unnecessary.
[0051]
　When you register the data in the one-dimensional cube (ie, when you update the data in the cube), DWH server 300 newly determines whether the data is there is a two-dimensional cube that is associated with the one-dimensional cube that has been registered ( step S203). Here, when newly determined that there is no two-dimensional cube which is mapped to one-dimensional cubes registered data (N in step S203), DWH server 300 terminates the process here.
[0052]
　On the other hand, when newly determined that the data is there is two-dimensional cube which is mapped to one-dimensional cubes registered (Y in step S203), DWH server 300, reflects the registration result of the one-dimensional cubes in two-dimensional cube It makes (step S204). DWH server 300, when the operation item is present in the item of the form data of the two-dimensional cubes to be registered, at step S204, the other items in the arithmetic expressions (form data which is preset to the Factor 1 or performs arithmetic processing in accordance with the arithmetic expression) using two or more, processing is performed to set the operation result to the operation field.
[0053]
　Then, DWH server 300 determines whether the cube (lower cube) is located in the lower layer relative to the registration result of the new data is reflected cubes (step S205). Here, newly it is determined that the registration result data no cubes positioned in the lower layer with respect to a cube that reflects (N in step S205), DWH server 300 terminates the process here.
[0054]
　Meanwhile, a new If it is determined that the registration result data there is a cube which is positioned in the lower layer with respect to a cube that reflects (Y in step S205), DWH server 300, to reflect the registration result data to the underlying cube (step S206). DWH server 300, if there are items in the operation items of the form data of the lower layer cubes to be registered, at step S206, or one of the other items in the arithmetic expressions (form data that is preset in its Factor performs arithmetic processing in accordance with the arithmetic expression) using two or more, processing is performed to set the operation result to the operation field.
[0055]
　When to reflect the registration result of the data in the lower cube, DWH server 300 determines whether the cube there is further located in the lower layer (step S207).
[0056]
　Here, DWH server 300 further is determined that there is no cubes located below (N in step S207), and terminates the processing of this case, further Y of when it is determined that there is a cube which is positioned in the lower layer (step S207 ), it proceeds to step S206.
[0057]
　Will now be described with reference to FIG. The operation of DWH server 300 and the client 10, 20 in the form query system 500 of the present example. Note that in particular not related operations and processes of the present invention may have been omitted its contents.
[0058]
　Figure 4 is a flow chart showing an example of a form output processing and DWH server 300 and the client 10 is performed. In form output processing is to extract any data from the cube group storage unit 100 included in the DWH server 300, the processing for outputting the document on the client 10 is executed. Incidentally, the client 10 and the client 20 to perform the type of communication network, since the type of an application for outputting a form such differ only, the description as an example a case of using the client 10 in this example.
[0059]
　In form output processing, first, the client 10, for example in response to an operation input by the user, and transmits the cube selection screen request to the DWH server 300 (step S401).
[0060]
　Upon receiving the cube selection window requests, DWH server 300 transmits a cube selection screen according to the received cube selection screen request. In this example, DWH server 300 transmits the data for displaying a screen including a list of names of the cube in accordance with the query created by the client 10 as a cube selection screen to the client 10.
[0061]
　Upon receiving the cube selection screen, the client 10 displays a cube selection screen on the display screen (step S402). Thus, by displaying a cube selection screen including a list of names of the cube in response to a query, requesting comprehensively it is possible to enable viewing a cube depending on the cube (or document) is readily it is possible to choose.
[0062]
　5 is an explanatory view showing an example of a cube selection screen. As shown in Figure 5, the cube selection screen, a cube information display area 11 for displaying information about the cube in the form of a list, a button 12 to return receives a request for switching a screen displayed on the display screen to another screen , an OK button 13 is provided.
[0063]
　In this example, the cube information display area 11, a cube number (No.), and the cube name (name), the dimension to which the cube (dimension) and is displayed in a selectable state.
[0064]
　Client 10, for example, selection of a cube by a cursor P operable by mouse operation (eg, selection of cube name) is accepted and the selected cube and provisionally selected. Then, when accepting the selection of the OK button 13, the client 10 is sent determined that accepts the selection of the cube in the provisionally selected (step S403), the cube name of accepting the selected cube DWH server 300 to.
[0065]
　Upon receiving the cube name, DWH server 300 searches the cube corresponding to the received cube name, and transmits a registration item stored in the cube to the client 10 (step S302). Here, the registration items is part of the form data stored in the cube, and are those necessary items as the form for each job content is registered in advance. In this example, the registration is stored in the one-dimensional cubes AO item "stock", "stock small, Order Ready", "inventory small, order reception impossible" explained with an example in which such is sent to the client 10 do.
[0066]
　Upon receiving the registration items, the client 10 displays a registration item display screen on the display screen (step S404).
[0067]
　6 is an explanatory view showing an example of a registration item display screen. As shown in Figure 6, the registration item display screen, the cube name display area 21, a registration item display area 22, a return button 24, OK button 25 is provided.
[0068]
　In this example, the client 10, the registration item display area 22 displays a registration item received from a DWH server 300. Here, for example, upon receiving a selection of a button 24 to return by the cursor P (N in step S405), the client 10 proceeds to step S402.
[0069]
　Meanwhile, for example, upon receiving a selection of the OK button 25 by the cursor P (Y in Step S405), the client 10 displays a registration item selection screen (step S406)
[0070]
　7 is an explanatory view showing an example of a registration item selection screen. As shown in Figure 7, the registration item selection screen, the registration item display area 31 for selectably displaying a registration item selection item display area for displaying the item selected by the internal user of the items displayed as the registration items 32, a return button 33, are provided an OK button 34.
[0071]
　Here, for example, upon receiving a selection of the OK button 34 in a state where the selected item is set by dragging the registration items by the cursor P, the client 10, it is determined that that receives the selection of the registration items (step S407) , it wants to send the selected items that are set to DWH server 300.
[0072]
　Upon receiving the selection, DWH server 300 extracts the form data corresponding to the selected item from the cube and transmitted to the client 10 (step S303), the process ends here.
[0073]
　Upon receiving the document data extracted from the cube, the client 10 displays a document display screen (step S408).
[0074]
　8 is an explanatory view showing an example of a form display screen when form data which the client 10 has received is the document data stored in the two-dimensional cube. The form display screen, as shown in Figure 8, a document display area 41 for displaying the document data received from a DWH server 300 stores the document data displayed in the form display region 41 in a storage medium in which the client 10 has a save button 42 to accept the request to, and a return button 43 for returning to the state before the screen is provided.
[0075]
　For example, among the document data stored in the one-dimensional cubes, if the inventory status information item evaluation, the form data corresponding to such orders inventory valuation are integrated "new inventory management" is displayed, so that as shown in FIG. 8 to, form data on the new inventory management is displayed.
[0076]
　Also, if the form data corresponding to the "inventory receipts and payments" which form data is integrated to be stored in the form data and the two-dimensional cubes stored in one-dimensional cube is displayed, for example, as shown in FIG. 9, the form displays may be configured to the character size is adjusted so as to be displayed all the document data in the area 41. In addition, the client 10, for example, a mouse display mode may be a configuration is changeable in response operations.
[0077]
　In the example described above, the cube group storage unit 100, one-dimensional cubes, two-dimensional cubes, and has been described to have a multi-dimensional cube, without having a multi-dimensional cube and one-dimensional cubes and the two-dimensional cubes it is also possible to configure the cube group storage unit 100 by the.
[0078]
　As described above, in the embodiment described above, business content data (for example, the form data) indicating the contents of the business of the business process database to store (for example, a cube group storage unit 100), the business data content each inside and one-dimensional cube that stores the unit business content data of each business unit respectively the contents of each business of each business unit as one-dimensional data in a business process, a one-dimensional data stored in the one-dimensional cube respectively Of the contents of the operations, since it is configured to include a two-dimensional cube that stores relevant work contents data for each related operations shown by integrating the contents of certain related activities across multiple business unit as two-dimensional data, complex queryable system diverse forms at low cost comes to be built without the need for a form program.
[0079]
　In other words, to build a new database using the existing functions of the data warehouse, which have been used for supplementary role of mission-critical servers, a program for managing information in newly constructed database with a simple configuration of only generated, which can query the system will be able to build a wide variety of forms. In addition, a plurality of cubes that form a hierarchical structure and by to manage business content data such as document data, it is possible to reduce the workload for performing cube design development in cooperation between complex business so as to.
[0080]
　In the embodiment described above, the database (for example, a cube group storage unit 100), and contents of related operations indicated by the two-dimensional data stored in the two-dimensional cubes, one-dimensional and is stored in one-dimensional cubes multidimensional cube for storing a set operational contents data for each set operations indicating the contents of the given set operations that integrate the content of the other relevant activities indicated business contents or other two-dimensional data representing the data as a multidimensional data Since you are configured to include a more diverse forms queryable system will be able build. Furthermore, by previously provided with a plurality of pre multidimensional cube, it is possible to reduce the workload for accessing information the user needs.
[0081]
　In the embodiment described above, the multi-dimensional data, so that a structure containing the case of a series operational contents data of the set operations including the contents of the other set operations indicated other multi-dimensional data, a more complex and associated it is possible to manage and organize the data between business having sex.
[0082]
　Further, in the embodiment described above, as the case of the configuration in which an operation item as an item in advance may also be able to reduce the workload for the design and development of the cube in cooperation between complex business Become.
[0083]
　In the embodiment described above, provided in the database (for example, a cube group storage unit 100), business content data (for example, the form data) SERVICES data management server for managing (eg, data warehouse server 300) , business content data management server, unit business content data management server to collect unit business content data (for example, line-of-business server 200) to get the unit operational content data from the primary to the acquired unit business content data as one-dimensional data If you are registered based on the cube to update the registration contents of the one-dimensional cube, there are related activities across the plurality of business units, including the contents of the operations indicated by the one-dimensional data registered and related to the related activities Since you are configured to reflect the registration result of the one-dimensional data registered in the two-dimensional data is a business content data to update the registration contents of the two-dimensional cube, efficient registration contents of a plurality of cubes that form a hierarchical structure and it is possible to update it without omission, it is possible to keep the fast and accurate response possible state to the form query request about the diverse forms from the client. If a configuration including a multi-dimensional cube, it is possible to keep the fast and accurate response possible state to the form query request for more diverse forms from the client.
[0084]
　In the embodiment described above, the request from the database (eg, cube group storage unit 100) SERVICES data management server with a (eg, data warehouse server 300), the client terminal (for example, the client 10, 20) Depending on to the client a configuration that provides a work contents data stored in the database, and therefore has a configuration that provides one-dimensional data or two-dimensional data specified by the client terminal, the two-dimensional data is not limited to one-dimensional data can be provided to, it is possible to provide various forms of low cost without requiring a complicated form programs. If a configuration including a multi-dimensional cube, it is possible to provide a more diverse forms at low cost.
[0085]
　In the embodiment described above, operational content data management server (for example, data warehouse server 300) for managing the work contents data indicating the contents of the business of the business processes, the database that stores the job contents data (for example, cubes and a group storage unit 100), unit business content data management server to collect unit business content data of each business unit respectively showing the contents of each business of each business unit in business processes (for example, unit business from line-of-business server 200) Content data (eg, slip data) is acquired, and stores the acquired unit business content data in the database, the client terminal (for example, the client 10, 20) in response to a request from the work contents data stored in the database is provided, as shown database (eg, cube group storage unit 100), a one-dimensional cube is stored as one-dimensional data unit operational contents data in the business content data, a one-dimensional data stored in the one-dimensional cubes, respectively Among the contents of each business, and a two-dimensional cube that stores the relevant business content data for each related business that indicates to integrate the contents of the prescribed related business across multiple business units as a two-dimensional data, as business content data , and since it is configured to provide at least a portion of the one-dimensional data, or two-dimensional data, a variety of forms queryable system at low cost it is possible to build without requiring complicated form programs.
Industrial applicability
[0086]
　According to the present invention, it is useful to provide various forms queryable system at low cost without requiring a complicated form programs.
Description of the code
[0087]
　10 client
　20 clients
　51 dedicated line
　52 LAN
　53 Internet
　100 cube group storage unit
　200 line-of-business server
　300 DWH server
　500 form inquiry system

Claims
[Claim 1]
　A database for storing business content data showing the contents of the business in the business process,
　the unit business content data for each of the business units respectively showing the contents of each business of each business unit in the business process out of the business content data and one-dimensional data storage unit that stores a one-dimensional data,
　among the contents of the operations of one-dimensional data stored in the one-dimensional data storage unit respectively, the contents of certain related activities across multiple business units and a two-dimensional data storage unit for storing relevant work contents data for each of the related operations shown by integrating the two-dimensional data
　database, characterized in that.
[Claim 2]
　Other of the contents of the associated business two-dimensional data stored in said two-dimensional data storage unit is indicated, the content or other two-dimensional data of the job indicated by the one-dimensional data stored in the one-dimensional data storage unit indicated including the multi-dimensional data storage unit for storing a series business content data as a multidimensional data for each the series business that shows the contents of a given set business that integrates the contents of the related business of
　database according to claim 1.
[Claim 3]
　The multi-dimensional data, including the case is a series business content data of a series business, including the contents of the other series work indicated by the other multidimensional data
　database of claim 2.
[Claim 4]
　It provided in the business content data management server that manages the business content data,
　the business content data management server,
　unit business content to get the unit operational content data from the unit business content data management server to collect the unit business content data a data acquisition means,
　first update to update by registering the one-dimensional data storage unit as the one-dimensional data unit work contents data acquired by the unit work contents data acquisition means the registered contents of the one-dimensional data storage unit and means,
　when the related business across multiple business units, including the contents of the business that one-dimensional data that has been registered by the first update means is shown to exist, two-dimensional data, which is a related business content data for the related services to reflect the registration result of the one-dimensional data which has been registered and a second updating means for updating the registered contents of the two-dimensional data memory unit by said first updating means to
　a database according to claim 1.
[Claim 5]
　The work contents data management server, in response to a request from the client terminal, includes the operational contents data providing means for providing a work contents data stored in the database,
　the work contents data providing means is designated by said client terminal to provide a one-dimensional data, or two-dimensional data
　database according to claim 4.
[6.]
　A business content data management server that manages the business content data showing the contents of the business in business processes,
　and the database that stores the business content data,
　the business that shows each of the contents of each business of each business unit in the business process and unit SERVICES data acquisition means for acquiring the unit operational contents data from the unit operational contents data management server collects the unit operational data content of each unit,
　and said the unit operational contents data units work contents data acquired by the acquisition means and unit SERVICES data storing means for storing in a database,
　in response to a request from a client terminal, wherein and a business content data providing means for providing a work contents data stored in the database,
　the database,
　the work contents data and one-dimensional data storage unit that stores a one-dimensional data to the unit work contents data among,
　among the contents of the operations of one-dimensional data stored in the one-dimensional data storage unit respectively, the plurality of business units and a two-dimensional data storage unit for storing relevant work contents data for each of the related operations shown by integrating the contents of certain related activities as two-dimensional data across,
　the work contents data providing means, as the work contents data and provide at least a portion of said one-dimensional data or the two-dimensional data
　SERVICES data management server, characterized in that.
[7.]
　A work contents data management program for managing the business content data to the business content data management server comprising a database for storing work contents data indicating the contents of the business of the business process,
　the business content data management server,
　and the and unit business content data acquisition process from the unit business content data management server to collect unit business content data for each relevant business unit to acquire the unit business content data indicating respectively the contents of each business of each business unit in the business process,
　the and unit SERVICES data storage process for storing the unit operational contents data acquired by the unit operational data content acquisition processing in the database,
　operations in response to a request from the client terminal, provides operational contents data stored in said database is allowed to execute the content data providing process,
　the database is
　a one-dimensional data storage unit that stores a one-dimensional data to the unit work contents data of said work contents data,
　the primary that is stored in the one-dimensional data storage unit Among the contents of each business in which the original data indicates respectively, two-dimensional data storage unit for storing the relevant business content data for each of the related business that indicates to integrate the contents of the prescribed related business across multiple business units as a two-dimensional data wherein the door,
　said at operational data content providing process, the as work contents data, a process for providing at least a portion of said one-dimensional data or the two-dimensional data
　and business content data management program for executing.