JP2009048313A - Data processor and data processing method - Google Patents

Abstract

<P>PROBLEM TO BE SOLVED: To provide technology for properly managing a creation state of a storage area. <P>SOLUTION: A data processing part 50 operates data of already created table information 36 and in-creation table information 38 when receiving a table creation request from a user to create a table 32. The data processing part 50 deletes a table name recorded in the in-creation table information 38 in prescribed timing. Thereby, the creation state of the table is properly managed, and reuse of the table name is materialized. <P>COPYRIGHT: (C)2009,JPO&INPIT

Description

  The present invention relates to a data processing technique, and more particularly, to a technique for processing data using a storage device having a plurality of storage areas.

  Currently, many IT systems record information to be processed in a storage device having a plurality of storage areas. The amount of information to be processed by the IT system is steadily increasing, and storage devices for storing information may be distributed at different locations.

On the other hand, it is desirable that a user who uses information stored in the storage device can access each storage area without being aware of the physical location of the storage device. In order to solve this problem, a virtual storage area (hereinafter referred to as “reference object”) that refers to each storage area may be prepared. By accessing the reference object, the user can access necessary information without being aware of the physical location of the storage device and the storage area (see, for example, Patent Document 1).
JP 2006-227820 A

  Identification information is assigned to each of the storage area and the reference object, and is associated with each other by the identification information. The present inventor considered that it is necessary to appropriately manage the creation state of the storage area in order to appropriately assign the identification information to the storage area.

  The present invention has been completed based on the above-mentioned attention by the present inventor, and its main purpose is to provide a technique for appropriately managing the creation state of the storage area.

  In order to solve the above problems, a data processing apparatus according to an aspect of the present invention includes a storage area holding unit that holds a storage area specified by predetermined identification information, and a creation that accepts storage area creation requests from a plurality of users. A request accepting unit, an identification information selecting unit for selecting identification information for specifying a storage area created based on the creation request, and an in-creation area information indicating the identification information of the storage area being created An identification information temporary recording unit that records the selected identification information, a storage area creation unit that creates a storage area that is specified by the selected identification information, and a storage area that is created after the storage area creation unit creates the storage area After the storage area is created by the storage area creation section, the identification information main recording section for recording the identification information of the storage area created in the created area information indicating the identification information of the storage area in the completed state, An identification information deleting unit for releasing the identification information of the created storage area from the in-creation area information, and deleting the in-creation area information to release the identification information recorded in the in-creation area information at a predetermined timing A section.

  Another aspect of the present invention is a data processing method. The method includes a step of receiving a storage area creation request from a plurality of users, a step of selecting identification information for specifying a storage area created based on the creation request, and a storage area in a state of being created. A step of recording the selected identification information in the creation area information indicating the identification information, a step of creating a storage area specified by the selected identification information, and a creation of the storage area after the creation of the storage area A step of recording the identification information of the created storage area in the created area information indicating the identification information of the storage area in the state, and an area in which the identification information of the created storage area is created after the creation of the storage area A step of releasing the information, and a step of releasing the identification information recorded in the area information being created from the area information being created at a predetermined timing.

  It should be noted that any combination of the above-described constituent elements and a representation of the present invention converted between an apparatus, a method, a system, a program, a recording medium storing the program, and the like are also effective as an aspect of the present invention.

  According to the present invention, it becomes easy to manage the creation state of the storage area.

  Before describing the embodiment of the present invention, a data processing apparatus that accesses each storage area of a storage device via a reference object will be described as a prerequisite technique.

  FIG. 1 shows a configuration of a data processing apparatus in the base technology. The data processing apparatus 100 includes a first database 30 a and a second database 30 b that are collectively referred to as the database 30, and a virtual table holding unit 20. The database 30 is a storage area specified by the identification information, and includes a first table 32 a to a fourth table 32 d collectively referred to as a table 32. The virtual table holding unit 20 includes a first synonym 22 a to a fourth synonym 22 d that are collectively referred to as a synonym 22.

  In FIG. 1, the first synonym 22a is a reference object that refers to the first table 32a, and the same applies to the other synonyms 22. The first user 10a accesses the first table 32a by accessing the first synonym 22a. The second user 10b accesses the third table 32c by accessing the third synonym 22c. That is, each synonym 22 and each table 32 are associated with each other by identification information, in the figure, a table name and a synonym name.

  As described above, the data processing apparatus 100 can provide the user interface in a form in which the physical positions of the database 30 and the table 32 are concealed by the synonym 22 of the virtual table holding unit 20. In other words, the user can access each table 32 without being aware of the physical positions of the database 30 and the table 32. The “physical location of the database and table” refers to the IP address, port number, database instance name, database service name, table schema name, etc. of the database server.

  Note that the fourth table 32d indicated by the broken line in FIG. 1 is not created, but, as between the other synonyms 22 and the created table 32, also between the fourth synonym 22d and the fourth table 32d. The reference relationship is set in advance. The effect of this will be described later.

  As described above, when referring to the table 32 in the data processing apparatus 100, the user accesses the table via the synonym 22. However, when creating the table 32, the user needs to access the database 30 directly. Therefore, when the user creates the fourth table, it is necessary to directly access the second database 30b and create the fourth table 32d.

  FIG. 2 shows a configuration when a table is created in the database of FIG. In the figure, the third user 10c creates a fourth table 32d. As described above, since the reference relationship is set in advance between the fourth synonym 22d and the fourth table 32d, the second user 10b immediately follows the creation of the fourth table 32d. The fourth table 32d can be accessed by accessing the fourth synonym 22d.

  As described above, before the table 32 is created, a predetermined number of synonyms 22 are prepared in advance in the virtual table holding unit 20, and a reference relationship between each table 32 and each synonym 22 created in the future is set in advance. Thus, immediately after the table 32 is actually created, the user can access the created table 32 via the synonym 22 having identification information associated with the table.

  In order to set the reference relationship in advance, it is necessary to determine at least the number of synonyms 22 as table names for identifying the table 32 in advance. The table name determined in advance is hereinafter referred to as “table name candidate”. When actually creating a table, it is necessary to select a table name that is not used in another table from the table name candidates.

  For this selection, a management table that records the usage status of the table is prepared. FIG. 3 shows a configuration in which a management table is added to FIG. The third user 10c selects a table name to be created by referring to the management table 34, in this example “fourth table”, and creates a fourth table 32d. FIG. 4 shows the data structure of the management table 34 of FIG. The fourth table whose use flag is “unused” in FIG. 4A is “in use” in FIG. 4B.

  FIG. 5 is a flowchart showing a flow of table name selection in FIG. First, the third user 10c refers to the management table 34 in the state of FIG. 4A, and determines a table name “fourth table” to be used from among the unused table name candidates (S2). Next, the third user 10c changes the use flag in the “fourth table” of the management table 34 to “in use” (S4). As a result, the management table 34 is in the state shown in FIG. Finally, the third user 10c creates a fourth table 32d (S6).

Here, consider a case where a failure occurs in S6 of FIG. Here, the failure is assumed to be a state in which exception handling due to failure of table creation is not possible. For example, the following failures are included.
1. The connection between the third user 10c and the second database 30b has been disconnected.
2. The table creation application on the third user 10c side has gone down.
3. The database instance of the second database 30b has gone down.

  In this case, although the management table 34 is in the state shown in FIG. 4B by S4 in FIG. 5, the fourth table 32d is not actually created. That is, the configuration of FIG. 3 cannot properly manage the table creation state. Further, another user who refers to the management table 34 in the state of FIG. 4B determines that the “fourth table” is “in use”, and the table name is not used. This is a problem in that unused table names are generated among finite table name candidates.

  Further, as a method of selecting a table name in FIG. 3, there is a method of changing the status of the management table 34 to “in use” after completing the creation of the table. However, in this case, when one user is creating a table with a specific table name, the table name is “unused” in the management table 34, so other users have the same table name. There is a problem of creating a table. Accordingly, in this case as well, the table creation state cannot be properly managed in the configuration of FIG. Hereinafter, in describing the embodiment of the present invention, it will be described that these problems are solved.

  FIG. 6 shows the configuration of the data processing apparatus in this embodiment. In addition to the configuration of the data processing apparatus 100, the data processing apparatus 200 includes created table information 36, in-creation table information 38, and a data processing unit 50.

  The created table information 36 is a table that holds the created table name. FIG. 7 shows the data structure of the created table information 36 of FIG. If the fourth table 32d is created by the data processing unit 50 when the created table information 36 is in the state of FIG. 7A, the state is changed to the state of FIG. 7B.

  The information recorded in the created table information 36 is not limited to the table name, and may be identification information that can uniquely identify each table 32. For example, identification information different from the table name may be recorded in the created table information 36, and the identification information and the table name may be associated with each other by an association table (not shown). Further, the table name may be specified from the identification information by predetermined data conversion. In the following description, the table name itself is recorded as identification information. The same applies to the table information 38 being created.

  The table information 38 being created is a table that holds the name of the table being created. FIG. 8 shows the data structure of the table information 38 being created shown in FIG. When the data processing unit 50 receives a table creation request from the third user 10c when the table information 38 being created is in the state of FIG. 8A, the data processing unit 50 stores the table information 38 being created in FIG. Change to the state of b). Further, after creating the fourth table 32d, the data processing unit 50 changes the creating table information 38 again to the state shown in FIG.

  When the data processing unit 50 receives a table creation request from the user and creates the table 32, the data processing unit 50 operates the data of the created table information 36 and the table information 38 being created. In addition, the data processing unit 50 deletes the table name recorded in the creating table information 38 at a predetermined timing. As a result, the creation status of the table is appropriately managed, and the table name can be reused. Details will be described later.

  FIG. 9 is a block diagram showing a functional configuration of the data processing unit 50 of FIG. The data processing unit 50 includes a creation request receiving unit 52 that receives table creation request information from a plurality of users, an identification information selecting unit 54, an identification information temporary recording unit 56, a storage area creating unit 58, and an identification information main record. A section 60, an identification information deletion section 62, and a creating area information deletion section 64. In terms of hardware components, these configurations are realized by a CPU, a memory, a program loaded in the memory, and the like of an arbitrary computer. Here, functional blocks realized by their cooperation are illustrated. Accordingly, those skilled in the art will understand that these functional blocks can be realized in various forms by hardware only, software only, or a combination thereof.

  The identification information selection unit 54 selects a table name of the table created by the request information received by the creation request receiving unit 52 from the table name candidates. The table name candidates may be stored in an identification information candidate storage unit (not shown), or may be set in advance in the form of a table name naming rule. The identification information selection unit 54 may select a table name based on various conditions. The conditions for selecting the table name will be described later.

  The identification information temporary recording unit 56 records the table name selected by the identification information selection unit 54 in the creating table information 38. The storage area creation unit 58 creates the table 32 based on the table name selected by the identification information selection unit 54 after recording by the identification information temporary recording unit 56.

  The identification information main recording unit 60 records the table name in the created table information 36 after the table creation by the storage area creating unit 58. The identification information deletion unit 62 deletes the table name from the table information 38 being created after the table creation by the storage area creation unit 58. The identification information deleting unit 62 cancels the state in which the table name is recorded in the table information 38 being created by processing such as checking the deletion flag without deleting the table name from the table information 38 being created. May be. The same applies to the creating area information erasing unit 64.

  The creating area information erasing unit 64 deletes the table name recorded in the creating table information 38 at a predetermined timing. This timing may be once a day, typically at night, or may be a timing at which a deletion request explicitly issued to the data processing apparatus 200 by the operator is detected, but a time period when the table is not created by the user Is desirable. In addition, a computer program that issues a deletion request to the creating area information deletion unit 64 may be started as a daily job once a day.

  FIG. 10 is a flowchart showing the flow of table creation processing. First, the creation request receiving unit 52 receives table creation request information from a user (S12). The identification information selection unit 54 selects a table name from the table name candidates (S14). The identification information temporary recording unit 56 records the selected table name in the creating table information 38 (S16). The storage area creation unit 58 creates a table based on the selected table name (S18). The identification information main recording unit 60 records the table name of the created table in the created table information 36 (S20). The identification information deleting unit 62 deletes the table name of the created table from the creating table information 38 (S22).

Next, an example of conditions under which the identification information selection unit 54 selects a table name will be shown.
1. The table name candidates are arranged in a predetermined order such as ascending order or descending order, and the first table name candidate that does not exist in the created table information 36 is selected.
2. The table name candidates are divided into a plurality of groups, and each group is associated with a user. When selecting a table name, a table name candidate that does not exist in the created table information 36 is selected from the group associated with the user who requested the table creation.

3. The table name candidates are divided into a plurality of groups associated with specific numerical values, and specific numerical values are obtained by a predetermined calculation based on the time when the table creation request is received. A table candidate that does not exist in the created table information 36 is selected from the group associated with the obtained numerical value. For example, the table name candidates are divided into 10 groups and are associated with 0 to 9, respectively. A table name candidate that does not exist in the created table information 36 is selected from the group associated with the remainder when the reception time is divided by 10. The unit of reception time is preferably less than a second.
4). Although it is substantially the same as 3 above, instead of based on the time at which the table creation request is received, the arithmetic processing is performed based on a random value generated by the identification information selection unit 54.

  In this way, the table name is divided into a plurality of groups, and the table name is selected from a specific group selected based on a predetermined rule. The possibility of selecting a table name is reduced. Even if the same table name is accidentally selected, when recording a table name in the table information 38 being created, one cannot be recorded by exclusive control. You may make it do.

  According to the present embodiment, the table name being created is managed in the table information being created 38, while the table name already created is managed in the created table information 36. Thus, the table creation state can be appropriately managed by managing the table name in different storage areas according to the table creation state. In other words, unlike the management table 34 in FIG. 3, it is possible to clearly distinguish between a table in which an abnormality may occur during creation and a table that has been created without abnormality.

  As described above, in the configuration of FIG. 3, when one user is creating a table, another user may create a table with the same table name. In this embodiment, when one user starts creating a table, the table name is recorded in the creating table information 38. Thereby, it is possible to prevent the table creation using the same table name by another user until the table creation is completed and the table name is deleted from the table information 38 being created.

  Further, according to the present embodiment, after the table creation is completed, the table name recorded in the creating table information 38 is deleted. As a result, it can be determined that table creation has failed for a table whose table name is still recorded in the table information 38 being created during a time zone when the table should not be created, typically at night or during system maintenance. Therefore, by deleting the table name from the table information 38 being created, the table name is reused as a table name candidate. As described above, in the present embodiment, another problem in the configuration of FIG. 3, that is, generation of a table name that is not reused is solved by appropriately managing the creation state of the table.

  Furthermore, according to the present embodiment, the problem that occurs can be solved by setting the reference relationship between the synonym 22 and the table 32 in advance. That is, as described above, access to the table 32 via the synonym 22 is realized immediately after the creation of the table 32 by setting the reference relationship in advance. On the other hand, the number of table name candidates is limited due to the pre-set reference relationship, and the occurrence of table names that are not reused becomes a problem. In the present embodiment, by combining the virtual table holding unit 20 and the data processing unit 50, as described above, it is possible to obtain a merit by setting the reference relationship in advance while preventing generation of a table name that is not reused. In other words, according to the present embodiment, it is possible to provide a mechanism for realizing quick information sharing and information cooperation between users and effectively utilizing limited resources by reuse.

  Furthermore, according to the present embodiment, EUC (End-User Computing) can be promoted. That is, even a user who does not have knowledge about an IT system including a database can provide information to other users using the data processing device 200. Since the operation is performed by a user who does not have knowledge about the IT system, there is a high possibility that table creation will end abnormally. In this embodiment, even if table creation ends abnormally, reuse of the table name can be realized and the influence on other users can be reduced.

  Note that the virtual table holding unit 20, the database 30, and the data processing unit 50 in FIG. 6 may exist at physically separated positions, or may be connected to each other via a communication network (not shown). In that case, the remote connection function of the database management software may be used. Specifically, in the case of Oracle (registered trademark), a database link may be used, and in the case of SQL Server (registered trademark), a link server may be used. Alternatively, the connection may be made using an ODBC (Open Database Connectivity) driver or a JDBC (Java (registered trademark) Database Connectivity) driver.

  As described above, in the data processing device 200, since the physical positions of the respective functional units may be separated from each other, it is possible to construct a system more flexibly and to easily improve performance and availability. This is particularly effective when it is necessary to accept access from a large number of users and when it is necessary to manage a large number of tables.

  The present invention has been described based on the embodiments. This embodiment is an exemplification, and it will be understood by those skilled in the art that various modifications can be made to combinations of the respective constituent elements and processing processes, and such modifications are also within the scope of the present invention. is there.

  A first modification will be described. In the above-described embodiment, the storage area creation unit 58 executes “create table” and “insert” in SQL (Structured Query Language) as a series of processes in creating a table. In other words, creating a table in a narrow sense and inserting data into the table were executed as a series of processes. However, depending on the function of the identification information main recording unit 60, the table name may be recorded in the created table information at the stage of creating the table in a narrow sense.

  FIG. 11 is a flowchart showing a flow of table creation processing in the first modification. S32, S34, S36 and S44 in the figure are respectively the same as S12, S14, S16 and S22 in FIG. In this modification, the storage area creation unit 58 first creates a table in a narrow sense (S38). The identification information main recording unit 60 records the table name in the created table information 36 when a narrowly-defined table is created (S40). The storage area creation unit 58 inserts data into the created table (S42). In this modification, S44 may be performed before S42.

  In this case, the table name is recorded in the created table information 36 before the data insertion into the table is completed. Therefore, even if a failure occurs during data insertion and the process ends abnormally, the table name is already recorded in the created table information 36, so that the table name cannot be reused when creating another table. .

  In this modification, in order to solve this problem, the data processing unit 50 may further include a storage area deleting unit. Further, the table creation request information by the user includes designation information of the lifetime of the table 32. The storage area deleting unit refers to the information on the duration specified in the table creation request information, deletes the table 32 whose duration has elapsed, and deletes the table name from the created table information 36.

  According to this modification, even if a table that cannot be actually used due to abnormal termination of data insertion is recorded in the created table information 36, the table name can be reused. In other words, the table that cannot be used exists for the duration specified in the request information, but the table is deleted when the duration expires, so that the table name can be reused as a table name candidate.

  Next, a second modification will be described. The data processing unit 50 according to the present modification further includes a storage area deletion unit as in the first modification. The creating area information erasing unit 64 of the present modification deletes the table name recorded in the creating table information and notifies the storage area deleting unit of the table name. The storage area deleting unit deletes the table 32 specified by the notified table name and also deletes the table name from the created table information 36.

  As described above, it can be determined that creation of the table 32 in which the table name is recorded in the table information being created during the time zone when the table should not be created has failed. Therefore, at the timing when the creating area information deleting unit 64 deletes the table name from the creating table information, the storage area deleting unit can delete the table 32 specified by the table name. Further, by deleting the table name from the created table information 36, the table name can be reused as a table name candidate. While the first modification is triggered by the elapse of the lifetime specified by the request information, this modification is triggered by the timing at which the creating area information erasing unit 64 operates.

It is a figure which shows the structure of the data processor in a base technology. It is a figure which shows a structure when a table is produced in the database of FIG. It is a figure which shows the structure by which the management table was added to FIG. It is a figure which shows the data structure of the management table of FIG. It is a flowchart which shows the flow of table name selection in FIG. It is a figure which shows the structure of the data processor in this Embodiment. It is a figure which shows the data structure of the created table information of FIG. It is a figure which shows the data structure of the table information in preparation of FIG. It is a block diagram which shows the function structure of the data processing part of FIG. It is a flowchart which shows the flow of a table creation process. It is a flowchart which shows the flow of the table creation process in a 1st modification.

Explanation of symbols

  20 virtual table holding unit, 22 synonym, 30 database, 32 table, 34 management table, 36 created table information, 38 creating table information, 50 data processing unit, 52 creation request receiving unit, 54 identification information selecting unit, 56 identification Information temporary recording unit, 58 storage area creating unit, 60 identification information main recording unit, 62 identification information deleting unit, 64 creating area information erasing unit, 100, 200 data processing device.

Claims (7)

A storage area holding unit for holding a storage area specified by predetermined identification information;
A creation request accepting unit that accepts creation requests for the storage area from a plurality of users;
An identification information selection unit for selecting identification information for specifying a storage area created based on the creation request;
An identification information temporary recording unit for recording the selected identification information in the in-creation area information indicating the identification information of the storage area in the state of being created;
A storage area creation unit for creating a storage area specified by the selected identification information;
An identification information main recording unit that records identification information of the created storage area in created area information indicating identification information of the created storage area after the storage area is created by the storage area creation unit When,
After the storage area is created by the storage area creation unit, an identification information deletion unit that releases the created storage area identification information from the creating area information;
A creating area information erasing unit for releasing the identification information recorded in the creating area information from the creating area information at a predetermined timing;
A data processing apparatus comprising:   The creating area information erasing unit releases the identification information recorded in the creating area information from the creating area information when a predetermined computer program is started in a daily job executed on a daily basis. The data processing apparatus according to claim 1, wherein:   The identification information selection unit divides predetermined identification information into a plurality of groups, and selects identification information for specifying a storage area from a specific group selected based on a predetermined rule. Item 3. The data processing device according to Item 1 or 2. A storage area deletion unit for deleting the created storage area;
The creation request includes lifetime information that specifies the lifetime of the storage area to be created,
The storage area deleting unit deletes a storage area whose lifetime specified by the lifetime information has passed, and releases identification information of the deleted storage area from the created area information. The data processing device according to any one of 1 to 3.   A user interface object for a user to access the storage area, which is a reference holding that holds a reference object specified by predetermined identification information and associated with a storage area held by the storage area holding unit The data processing apparatus according to claim 1, further comprising a unit. Receiving a storage area creation request from a plurality of users;
Selecting identification information for specifying a storage area created based on the creation request;
Recording the selected identification information in the in-creation area information indicating the identification information of the storage area in the state of being created;
Creating a storage area identified by the selected identification information;
Recording the created storage area identification information in the created area information indicating the identification information of the storage area in the created state after the storage area is created;
After the storage area is created, releasing the created storage area identification information from the creating area information;
Releasing the identification information recorded in the creating area information from the creating area information at a predetermined timing;
A data processing method comprising: A storage area holding function for holding a storage area specified by predetermined identification information;
A creation request accepting function for accepting creation requests of the storage area from a plurality of users;
An identification information selection function for selecting identification information for specifying a storage area created based on the creation request;
An identification information temporary recording function for recording the selected identification information in the in-creation area information indicating the identification information of the storage area in the state of being created;
A storage area creation function for creating a storage area specified by the selected identification information;
Identification information main recording function for recording identification information of the created storage area in created area information indicating the identification information of the storage area in the created state after the storage area is created by the storage area creation function When,
After the storage area is created by the storage area creation function, the identification information deletion function for releasing the identification information of the created storage area from the creating area information,
A creation area information erasing function for releasing the identification information recorded in the creation area information from the creation area information at a predetermined timing;
A computer program for causing a computer to realize the above.

Images