JP2021056570A - Database division system, database division method, and database division program - Google Patents

Abstract

To provide a database division system capable of dividing data of table in consideration of usage by an application while alleviating time and effort of a work well-informed person, and a database division method and database division program thereof.SOLUTION: A database division system includes data access analysis means which performs structural analysis with input of definition information of a source code of an application and a table structure of the database, job analysis means which performs analysis from a viewpoint of the job with input of feature information on the actual job and an operation log, and table division means which divides data of the table by using the analysis result of the data access analysis means and the analysis result of the job analysis means.SELECTED DRAWING: Figure 1B

Description

The present invention relates to a database partitioning system, a database partitioning method, and a database partitioning program, and more particularly to a system that supports database partitioning and integration.

When the database is bloated and tightly coupled, the database is organized from the viewpoint of improving maintainability. Databases are divided and integrated to organize the database, but standard methods for integration and division have not been established.

This Patent Document 1 relates to a data rearrangement method for a distributed database. In Patent Document 1, a division condition is generated from a computer resource status and a distribution of the number of times data is accessed for a distributed database in which data is divided and arranged at a plurality of computer sites, so as to match this data division condition. It has been proposed to move the data, rearrange the data, and efficiently distribute the load to each computer site.

Japanese Unexamined Patent Publication No. 6-259478

However, organizing the above-mentioned database has the following problems. When the database is bloated and tightly coupled, integration and division are performed for the purpose of organizing the database from the viewpoint of improving maintainability, but all of them are manually laborious.

In addition, when dividing or integrating, it is necessary to consider how it is used from the application and the impact on the current processing, but the fact that it is done manually by business experts also increases the time and effort. There is.

Patent Document 1 proposes the rearrangement of data in a distributed database, but does not know about considering how to use it from an application and does not present a solution.

An object of the present invention is to provide a database partitioning system, a database partitioning method, and a database partitioning program that enable data partitioning of a table in consideration of usage from an application while reducing the labor of business experts. To provide.

In order to achieve the above object, the database partitioning system according to the present invention is used.
Data access analysis means that performs structural analysis by inputting application source code and database table structure definition information, business analysis means that analyzes business viewpoints by inputting actual business characteristic information and operation logs, and data access analysis It includes a table dividing means for dividing table data using the analysis result of the means and the analysis result of the business analysis means.

The method of dividing the database according to the present invention is as follows.
Data access is analyzed by performing structural analysis using the application source code and database table structure definition information as input.
We analyze the business viewpoint by inputting the characteristic information and operation log of the actual business.
Data division of the table is performed using the analysis result of the data access and the analysis result of the business viewpoint.

The database partitioning program according to the present invention is
Information processing device,
Data access analysis means that performs structural analysis by inputting application source code and database table structure definition information, business analysis means that analyzes business viewpoints by inputting actual business characteristic information and operation logs, and data access analysis It functions as a table division means for dividing table data using the analysis result of the means and the analysis result of the business analysis means.

The present invention provides a database partitioning system, a database partitioning method, and a database partitioning program that enable data partitioning of a table in consideration of how it is used from an application while reducing the labor of business experts. be able to.

It is a block diagram for demonstrating the database division system of embodiment of the superordinate concept of this invention. It is a block diagram for demonstrating the database division system of 1st Embodiment of this invention. Table This is a table showing an example of data access information for each file. It is a table which shows an example of the data access information for each data item. It is a table which shows an example of the data item which cannot be duplicated. It is a table which shows an example of the data item which cannot be separated. It is a table which shows an example of the program of the same business group. It is a table showing an example of aggregation of operation logs. It is a flowchart for demonstrating the division method of the database of embodiment. It is a table showing an example of a rule and its weighting. It is a table for explaining the table X'divided from the viewpoint of access from a program. It is a table for explaining the table X "divided from the viewpoint of access from a program.

The database partitioning system, the database partitioning method, and the database partitioning program of the present invention are, for example, a proposal for design modification of database partitioning or integration in consideration of a logical viewpoint on the source code and a business processing viewpoint. Is presented.

In the embodiment of the present invention, the source code is analyzed to extract the access from each application to the database table or the data item included in the table, and the table / data item accessed from the application and the generation (C) / reference. The two viewpoints of the program logic viewpoint of the access type of (R), update (U), and deletion (D) and the business viewpoint considering the characteristics of the business processing configured by the application are combined. Then, in the embodiment of the present invention, the database is divided according to the actual business processing, and for example, the time and effort of an expert is reduced and the data is automatically divided.

Business viewpoints include data characteristics (whether or not duplication is possible and relationships between data items), program characteristics (same business, similar processing), program execution frequency, and data access frequency. When there are multiple division methods, the intended division can be performed by dividing according to the set weighting. For weighting, the priority of the division rule for dividing the table and the priority of the division suppression rule that you do not want to divide in business are held, and the policy is decided by the combination of them.

Before explaining a specific embodiment, a database partitioning system according to an embodiment of the superordinate concept of the present invention will be described. FIG. 1A is a configuration diagram for explaining a database partition system according to an embodiment of the superordinate concept of the present invention. The database partitioning system 30 of FIG. 1A is a data access analysis means 31 that performs structural analysis by inputting the source code of the application and the definition information of the table structure of the database, and the business viewpoint by inputting the characteristic information and the operation log of the actual business. Includes a business analysis means 32 for performing analysis. Further, the database division system 30 of FIG. 1A includes a table division means 33 that divides table data using the analysis result of the data access analysis means 31 and the analysis result of the business analysis means 32.

As the analysis result of the data access analysis means 31, the source code is analyzed, the access to the database table and the data items included in the table is extracted from each application, and the table / data item and access type accessed from the application. Combination with is conceivable. The analysis results of the business analysis means 32 include the characteristics of the data in the database (whether or not replication is possible and the relationship between data items), the characteristics of the program accessing the database (same business, similar processing), the execution frequency of the program, and the data. Access frequency etc. can be considered.

According to the database partitioning system of the present embodiment, the table partitioning means 33 divides the data of the table using the analysis result of the data access analysis means 31 and the analysis result of the business analysis means 32. That is, the data of the table is divided by using the combination of the two viewpoints of the program logic viewpoint and the business viewpoint.

As a result, a loosely coupled database suitable for business processing can be efficiently obtained. It is possible to significantly reduce the time and effort required for business experts to check each program one by one. A specific embodiment will be described below.

[First Embodiment]
First, the database partition system according to the first embodiment of the present invention will be described. FIG. 1B is a configuration diagram for explaining a database partition system according to the first embodiment of the present invention. FIG. 2A is a table showing an example of data access information for each table file. FIG. 2B is a table showing an example of data access information for each data item. FIG. 3A is a table showing an example of data items that cannot be duplicated. FIG. 3B is a table showing an example of inseparable data items. FIG. 3C is a table showing an example of a program of the same business group. FIG. 4 is a table showing an example of aggregation of operation logs. FIG. 5 is a flowchart for explaining a method of dividing the database of the present embodiment. FIG. 6 is a table showing a rule and an example of weighting of the rule. FIG. 7A is a table for explaining the table X'divided from the viewpoint of access from the program. FIG. 7B is a table for explaining the table X "divided from the viewpoint of access from the program.

(Structure of Embodiment)
The configuration of the database partition system according to the first embodiment of the present invention will be described. As shown in FIG. 1B, the database partitioning system according to the embodiment of the present invention includes a data access analysis unit 1 that performs structural analysis by inputting the source code 11 of the application and the table definition 12 of the table structure of the database. Further, as shown in FIG. 1B, the database division system according to the embodiment of the present invention has a business analysis unit 2 that analyzes a business viewpoint by inputting characteristic information 13 and an operation log 14 of an actual business, and a data access analysis unit 1. It includes a table partitioning unit 3 that divides data using the analysis result and the analysis result of the business analysis unit 2. The table partitioning unit 3 performs table partitioning using the weighting 15 and outputs the partitioning result 16.

Next, the functions and operations of each component of the database partition system of FIG. 1B will be described.

First, the data access analysis unit 1 inputs the information of the source code 11 and the table definition 12 and performs static analysis to visualize the access to the program and the data. This static analysis method is performed according to the language specifications in which the program is written. Visualization to the data obtained by static analysis will be described with reference to FIGS. 2A and 2B. Data access to the database is assumed to be for tables and files in the database, and the level of visualization can be set to table / file units, and visualization of access to data items in tables with finer granularity can be considered. The types of access to the database are also distinguished by creation (C), reference (R), update (U), and deletion (D), and they are visualized. Although FIGS. 2A and 2B show the case of visualization in a tabular format, it is also possible to visualize in a format other than the tabular format, and a special format is not limited.

Next, the business analysis unit 2 inputs the program and data access information, characteristic information 13, and operation log 14 analyzed by the data access analysis unit 1, and the information and business information analyzed by the data access analysis unit 1. Link with.

The characteristic information 13 will be described with reference to FIGS. 3A to 3C. The characteristic information 13 indicates the business meaning of the actual application, and sets necessary information from the application design document, operational rules, and the like. From the data point of view of database reconstruction, the non-replicatable data item in FIG. 3A shows the master data that should be centrally managed without allowing duplication in the application. The inseparable data item in FIG. 3B shows the data to be managed in the same table / file with consistency. From the program point of view, by designating a program that can be regarded as the same business group in FIG. 3C, the data accessed from the same business group can be regarded as the same. The operation log 14 in FIG. 1B corresponds to the log information of the middleware in which the application operates. Specifically, as shown in FIG. 4, the business analysis unit 2 extracts from the log information which program has operated. Holds information on program name, number of operations and last operation date.

Next, in the table division unit 3, the table is divided / integrated by a specific algorithm using the results analyzed by the data access analysis unit 1 and the business analysis unit 2 and the weighting 15, and the division result 16 is output. To do.

(Operation of the embodiment)
Next, a series of steps up to the division of the program will be described with reference to FIG. Assuming this embodiment, the database to be divided or integrated is data accessed from different programs. First, it is determined from the result of the data access analysis unit 1 whether there is data accessed from a different program (step S1). When there is no corresponding data (NO in S1), the process ends.

Explaining with the example of FIGS. 2A and 2B, the table X is accessed from the program A (reference (R) notation in FIGS. 2A and 2B) and accessed from the program B (reference (R) in FIGS. 2A and 2B). (Notation), and the database table X is the target of division.

Next, it is determined whether or not the programs being accessed are in the same business group based on the result of analysis by the business analysis unit 2 (step S2). If they are in the same business group, they can be regarded as the same in terms of business. Therefore, if program A and program B are in the same business group, they are not subject to division. When it is determined that they are in the same business group (NO in S2), the data is excluded as data not subject to division or integration (step S3), and the process returns to step S1.

When it is determined that the program A and the program B are not in the same business group (YES in S2), it is determined whether or not the rules are met (step S4). Here, the rule is a set of rules regarding data change as shown in FIG. In FIG. 6, six rules are shown, and priority: 1 to priority: 6 are set. In FIG. 6, the categories of rules include those from a business viewpoint and those from a program viewpoint, and the types of rules include deterrence rules and division rules. In step S4, it is determined whether or not the rule is met. If the rules are not met (NO in S4), the process proceeds to step S3, the data is excluded as data not subject to division or integration, and the process returns to step S1. When the rules are matched (YES in S4), it is determined whether or not there are a plurality of matching rules (step S5). If one rule is applicable (NO in S5), the change is made according to the rule (step S6). If a plurality of rules are met (YES in S5), the change is made according to the high priority rule according to the weighting in FIG. 6 (step S7).

In the examples of FIGS. 2A and 2B, when the access from the program A and the access from the program B is viewed at the data item level, the items being accessed are different. In FIG. 2B, the program A accesses the data item name: item 1 and the data item name: item 2 in the table X (reference (R) notation in FIG. 2B), and the program B accesses the data item name in the table X: Item 3, data item name: item 4, and data item name: item 5 are accessed (reference (R) notation in FIG. 2B), and the accessed items are different between program A and program B. ..

From this situation, as shown in FIGS. 7A and 7B, from the viewpoint of the program, a table X'that summarizes only the data items accessed from the program A and a table X that summarizes only the data items accessed from the program B. However, when the data item 2 and the data item 3 of the table X are specified as the inseparable data as shown in FIG. 3B, the rule is applied according to the priority.

By repeating this process for the data accessed from different programs, the division result 16 can be obtained. The division result itself should be in a format that allows you to understand the changed table definition.

(Effect of embodiment)
According to the database partitioning system of the present embodiment, the table partitioning unit 3 divides the data of the table using the analysis result of the data access analysis unit 1 and the analysis result of the business analysis unit 2. That is, the data of the table is divided by using the combination of the two viewpoints of the program logic viewpoint and the business viewpoint.

As a result, a loosely coupled database suitable for business processing can be efficiently obtained. It is possible to significantly reduce the time and effort required for business experts to check each program one by one.

[Other Embodiments]
Although the first embodiment has been described above, the present invention is not limited thereto. The database partitioning system of the first embodiment described above causes the information processing apparatus to read and execute a database partitioning program that realizes functions such as the data access analysis unit 1, the business analysis unit 2, and the table partitioning unit 3 of FIG. 1B. It can also be realized by. That is, in an information processing device including a CPU (Central Processing Unit) and a memory, a database partitioning program that realizes functions such as data access analysis means, business analysis means, and table partitioning means stored in the memory is read by the CPU. The database partitioning system of the first embodiment can also be realized by executing it.

In addition, such a program can be distributed in the form of a recording medium on which the program is recorded. This program is a general-purpose semiconductor recording device such as CF (Compact Flash (registered trademark)) and SD (Secure Digital), a magnetic recording medium such as a flexible disk, or a CD-ROM (Compact Disc Read Only Memory). ), Etc., can be distributed in the form of an optical recording medium or the like.

Although the preferred embodiment of the present invention has been described above, the present invention is not limited thereto. In the present embodiment, the table partitioning unit 3 has been described as performing data partitioning using the analysis result of the data access analysis unit 1 and the analysis result of the business analysis unit 2, but the present invention is not limited to this. For example, the table partitioning unit 3 refers to the analysis result of the data access analysis unit 1 and the analysis result of the business analysis unit 2, and presents to a business expert that any of the rules shown in FIG. It is also conceivable to configure the data partitioning to be performed after the approval of an expert. Even in such a database partitioning system, the burden on experts can be significantly reduced. It goes without saying that various modifications are possible within the scope of the invention described in the claims, and these are also included in the scope of the present invention.

Some or all of the above embodiments may also be described, but not limited to:
(Appendix 1) Data access analysis means that performs structural analysis by inputting application source code and database table structure definition information, and
A business analysis method that analyzes business perspectives by inputting characteristic information and operation logs of actual business,
Includes a table partitioning means that divides table data using the analysis results of the data access analysis means and the analysis results of the business analysis means.
Database partitioning system.
(Supplementary Note 2) The database partitioning system according to Appendix 1, wherein the table partitioning means determines whether or not a predetermined rule is met, and if the table partitioning means matches, the data partitioning is performed.
(Appendix 3) After determining whether the table partitioning means matches a plurality of predetermined rules, when the table dividing means matches a plurality of predetermined rules, the table partitioning means follows the high priority rule according to the weighting for each predetermined rule. The database partitioning system according to Appendix 2, which divides the data.
(Appendix 4) In the analysis result of the data access analysis means, if the programs accessing the same table are from the same business group, the data division is excluded from any of the appendices 1 to 3. The database partitioning system described in one.
(Appendix 5) Data access is analyzed by performing structural analysis using the application source code and database table structure definition information as input.
We analyze the business viewpoint by inputting the characteristic information and operation log of the actual business.
Data division of the table is performed using the analysis result of the data access and the analysis result of the business viewpoint.
How to partition the database.
(Appendix 6) The method for dividing a database according to Appendix 5, wherein the data division is performed when the data division meets the predetermined rule after determining whether the data division meets the predetermined rule.
(Appendix 7) The data division is determined based on the priority set for each of the predetermined rules when the data division matches the plurality of predetermined rules after determining whether the data division matches the plurality of predetermined rules. The method for dividing a database according to Appendix 6, wherein data division is performed according to one rule.
(Appendix 8) In the analysis result of the data access, if the programs accessing the same table are from the same business group, any one of the appendices 5 to 7 is excluded from the data division. How to split the database as described in.
(Appendix 9) Information processing device
Data access analysis means that performs structural analysis by inputting application source code and database table structure definition information, business analysis means that analyzes business viewpoints by inputting actual business characteristic information and operation logs, and data access analysis It functions as a table division means for dividing table data using the analysis result of the means and the analysis result of the business analysis means.
Database partition program.
(Supplementary Note 10) The database partitioning program according to Appendix 9, wherein the table partitioning means determines whether or not the table partitioning means conforms to a predetermined rule, and when the table partitioning means matches, causes the table partitioning means to function to perform the data partitioning.
(Appendix 11) After determining whether the table partitioning means matches a plurality of predetermined rules, when the table dividing means matches a plurality of predetermined rules, it is determined based on the priority set for each of the predetermined rules. The database partitioning program according to Appendix 10, which functions to perform data partitioning according to one rule.
(Appendix 12) In the analysis result of the data access analysis means, if the programs accessing the same table are from the same business group, any of the appendices 9 to 11 is excluded from the data division. The database partitioning program described in one.

1 Data access analysis department 2 Business analysis department 3 Table division department 11 Source code 12 Table definition 13 Characteristic information 14 Operation log 15 Weighting 16 Division result

Claims (10)

Data access analysis means that performs structural analysis by inputting application source code and database table structure definition information, business analysis means that analyzes business viewpoints by inputting actual business characteristic information and operation logs, and data access analysis Including the table division means for dividing the data of the table using the analysis result of the means and the analysis result of the business analysis means.
Database partitioning system. The table partitioning means determines whether or not the predetermined rule is met, and if so, performs the data partitioning.
The database partitioning system according to claim 1. After determining whether the table partitioning means matches a plurality of predetermined rules, when the table partitioning means matches the plurality of predetermined rules, the table partitioning means divides the data according to the high priority rule according to the weighting for each predetermined rule. Do, do
The database partitioning system according to claim 2. In the analysis result of the data access analysis means, if the programs accessing the same table are from the same business group, they are excluded from the data division.
The database partitioning system according to any one of claims 1 to 3. Data access is analyzed by performing structural analysis using the application source code and database table structure definition information as input.
We analyze the business viewpoint by inputting the characteristic information and operation log of the actual business.
Data division of the table is performed using the analysis result of the data access and the analysis result of the business viewpoint.
How to partition the database. The data division is performed when the predetermined rule is met after determining whether the predetermined rule is met.
The method for partitioning a database according to claim 5. After determining whether the data division matches a plurality of predetermined rules, when the data division matches a plurality of predetermined rules, the data division is divided into one rule determined based on the priority set for each predetermined rule. Perform data division along
The method for partitioning a database according to claim 6. In the data access analysis result, if the programs accessing the same table are from the same business group, they are excluded from the data division.
The method for partitioning a database according to any one of claims 5 to 7. Information processing device,
Data access analysis means that performs structural analysis by inputting application source code and database table structure definition information, business analysis means that analyzes business viewpoints by inputting actual business characteristic information and operation logs, and data access analysis It functions as a table division means for dividing table data using the analysis result of the means and the analysis result of the business analysis means.
Database partition program. It is determined whether the table partitioning means matches a predetermined rule, and if it matches, the data partitioning is performed.
The database partitioning program according to claim 9.

Images