JP3844914B2 - Information processing apparatus and method for inserting record into database - Google Patents

Description

[0001]
BACKGROUND OF THE INVENTION
The present invention relates to an information processing apparatus such as a computer and a method for inserting a record into a database.
[0002]
[Prior art]
Conventionally, a database (DB), such as a relational database (RDB), has been used for a keyword search of stored (registered) data, but if the amount of data registered in the RDB increases, the database itself Therefore, it is desired to improve the access performance.
[0003]
Conventionally, the RDB is managed by a database management system (DBMS). The DBMS has a clustering function for the purpose of improving the access performance of the RDB. This clustering function is a function for storing data by dividing it into predetermined units.
[0004]
Normally, in DBMS, an index can be defined from the user side, that is, from the application side, but it is only a logical definition, and the physical record insertion position in the DB, such as where in the database the record is to be inserted. Cannot be specified.
[0005]
There are an addition type and an insertion type as a form for storing records in the DB. The addition type is a form in which a new record is stored after the current storage record. The insertion type is a form in which new records are stored in the order of cluster keys.
[0006]
[Problems to be solved by the invention]
By the way, in the conventional DBMS, when a record is inserted, a new record is stored in the vicinity of the related record by the clustering function. There was a problem that it was mixed and it was easy for competition to occur.
[0007]
Therefore, in order to avoid this situation, conventionally, the database is monitored, and the database is reorganized as needed to increase the storage interval.
[0008]
However, as the amount of data stored in the database increases, the database search speed will only slow down by simply monitoring and operating the database to avoid contention. There is a problem that you can not.
[0009]
The present invention has been made to solve such a problem. An information processing apparatus and a database record capable of improving search performance by eliminating contention during database access and reducing work during database operation. It aims to provide an insertion method.
[0010]
[Means for Solving the Problems]
In order to achieve the above object, the invention according to claim 1 is an information processing apparatus for inserting, changing, and deleting records in a database, and a record insertion page for inserting records into the database. Interval information holding means in which the logical insertion position in the page and the number of records that can be inserted in the page are set, and means for issuing an instruction to insert, change, and delete records in the database by record name When a record insertion instruction to the database is issued, a record different from the first record set in the interval information holding means is inserted at the first position of the page of the corresponding record to be inserted on the database. And a means for inserting the instructed record .
[0011]
According to a second aspect of the present invention, in the information processing apparatus according to the first aspect, a record insertion page, a logical insertion position in the page, and the number of records that can be inserted in the page are stored in the interval information holding unit. It further has an interval information setting means for setting.
[0013]
The invention according to claim 3 is a method for inserting a record into a database in which a record is inserted into the database. When an instruction to insert a record into the database is issued with a record name, the record information is set in the interval information holding means. For the same record as the first record, the record is inserted at the next position of the inserted record on the page of the first record on the database, while the next record for the first record set in the interval information holding means is inserted. This record is characterized in that the record is inserted at the first position of the next record with an interval corresponding to the number of records set in the first record on the database .
[0014]
In the first and third aspects of the invention, when an instruction to insert a record into the database is issued , the same record as the first record held in the interval information holding means is inserted into the page of the first record on the database. While inserting a record at the next position of the already- recorded record, for the next record with respect to the first record set in the interval information holding means, an interval corresponding to the number of records set in the first record on the database Since the record is inserted at the first position of the next record with a mark, the database is partitioned logically and physically, and the database search performance can be improved. In addition, the database reorganization work that increases the database monitoring and storage interval, which has been conventionally performed, is unnecessary, and the work during the database operation can be reduced.
[0015]
The invention according to claim 2 is more flexible by having interval information setting means for setting the record insertion page, the insertion position in the page, and the number of records that can be inserted in the page with respect to the interval information holding means. An interval can be set.
[0016]
In addition, by setting interval information with the record name and the number of pages of the record name, a database suitable for a business in which the number of pages is determined in advance can be constructed. In addition, by setting interval information with the record name and the number of records that can be inserted into the page of this record name, the database can be searched like a dictionary with an index, and the database search performance is improved. Can do.
[0018]
DETAILED DESCRIPTION OF THE INVENTION
Hereinafter, embodiments of the present invention will be described in detail with reference to the drawings.
FIG. 1 is a diagram showing a configuration of a database search system according to a first embodiment relating to an information processing apparatus and a record insertion method for a database according to the present invention.
[0019]
As shown in the figure, this database search system is composed of a business processing unit 1 having a SQL issue processing unit 1a and a database management system (DBMS) 2.
[0020]
The DBMS 2 includes a load processing unit 3, an SQL determination processing unit 4, an insertion processing unit 5, an update processing unit 6, a deletion processing unit 7, an interval setting processing unit 8, an interval table 9, an interval determination processing unit 10, and a record insertion processing unit 11. And a database 12 or the like.
[0021]
The load processing unit 3 is a processing unit that operates when loading data to be stored. The SQL determination processing unit 4 determines the SQL and determines whether it is an insertion process, an update process, or a deletion process. The interval table 9 is a table in which intervals are set. The interval setting processing unit 8 sets interval data corresponding to the business content in the interval table 9. The business processing unit 1 is a business program and is installed in a hard disk device of a computer. The SQL issuance processing unit 1a is a module of the business processing unit 1, and performs processing for issuing an SQL. The insertion processing unit 5 performs record insertion processing. The update processing unit 6 performs a record update process. The deletion processing unit 7 performs record deletion processing. The interval determination processing unit 10 determines an interval required for the insertion process. The database 12 is a part that stores data in association with each other physically. The record insertion processing unit 11 is activated by the interval determination processing unit 10. When activated, the record insertion processing unit 11 performs record insertion processing on the database 12. The record insertion processing unit 11 has a record interval function, a page interval function, a simple interval function, and the like. Each of these functions will be described later.
[0022]
The operation of this database search system will be described with reference to the flowchart of FIG. FIG. 2 is a flowchart showing the operation of this database search system.
[0023]
As shown in the figure, the interval setting processing unit 8 generates interval data corresponding to the business contents in advance and sets it in the interval table 9. Interval data is the basic information when inserting records.
[0024]
When the SQL processing unit 1a is activated in the business processing unit 1 to execute the SQL issuing processing, and the SQL is issued (S101 in FIG. 2), the SQL determination processing unit 4 that has received the SQL inserts the record. It is first determined whether or not the process is other than that (S102).
[0025]
If the determination result is a record update process or a delete process (No in S102), the update processor 6 or the delete processor 7 performs a record update process or a delete process on the database storage unit 12 (S103). .
[0026]
On the other hand, if it is determined that the insertion process is the result of the determination (Yes in S102), the SQL processing unit 4 starts the insertion processing unit 5 to move to the record insertion processing, and the interval determination processing unit 10 performs the interval determination processing. I do.
[0027]
The interval determination processing unit 10 acquires information at the time of record insertion, that is, interval data, from the already set interval table 9 and activates the record insertion processing unit 11.
[0028]
The activated record insertion processing unit 11 searches the interval table (S104) and finds (exists) the interval data (S105). When the record insertion function is found (S105), a record interval function, page interval function, simple interval function, etc. The insertion position is determined (S106), physical record insertion processing is executed for the database 12 (S107), and after the records are inserted into the database 12, the processing is terminated.
[0029]
A specific example of the record insertion operation in the record insertion processing unit 11 will be described below.
[0030]
First, a record insertion operation by the record interval function will be described with reference to FIG.
In the record interval function, the record insertion page, the insertion position in the page, and the number of records that can be inserted in the page are set in the interval table 9.
[0031]
As shown in FIG. 3, for example, if the first record to be inserted into the database 12 is record A, and the next record to be inserted is B, A- * is set in the interval table 9 and m is set as the number of cases. , B- * is set as the record name, and n is set as the number of records.
[0032]
As described above, when the record to be inserted into the database 12 is set to m records and n records in the interval table 9, for example, when the insertion of the record A-1 is instructed, the record insertion processing unit 11 refers to the interval table 9 and the database Record A-1 is inserted at the first position of the page of 12 records A.
[0033]
Next, when the insertion of the record A-2 is instructed, the record insertion processing unit 11 refers to the interval table 9 and inserts the record A-2 at the position next to the record A-1 on the page of the record A.
[0034]
Further, when the insertion of the record B-1 is instructed, the record insertion processing unit 11 refers to the interval table 9 and inserts the record B-1 at the first position on the page of the record B.
[0035]
Thus, by setting information up to the number of records to be inserted for each page in the interval table 9 in advance, the records that should be logically separated from each other are physically mixed in the same page of the database 12. There is no longer to do. That is, records can be registered in the database 12 by logically and physically separating records.
[0036]
For example, when tens of thousands of data is recorded in the database 12, the number of records that can be registered in one page is set in advance, and logically the same records are arranged and inserted in units of pages within that range, By registering data, even if there are tens of thousands of data registered in each record, it is possible to improve the search and access speed of the database 12 by searching the database 12 in units of pages.
[0037]
More specifically, for example, the record A page is the Tokyo page, the record A-1 is the Shinagawa ward, the record A-2 is the Adachi ward, the record B page is the Osaka prefecture page, and the record B-1 is the Osaka city. For example, page A in Tokyo only needs to secure the number of 23 wards and 27 cities (areas), and records are inserted into the database 12 at such intervals. Therefore, when a new record such as Toshima Ward is inserted into the database 12, a record as Toshima Ward is inserted into the vacant page A of Tokyo.
[0038]
When searching the database 12 in which the record is inserted in this way, there is no competition between the process of searching for Tokyo data and the process of searching for Osaka data, and the database search performance can be improved.
[0039]
Next, a record insertion operation by the page interval function will be described with reference to FIG.
[0040]
In this page interval function, the name of the record to be inserted and the number of pages to insert this record are set in the interval table 9 as interval data.
[0041]
As shown in FIG. 4, for example, assuming that the first record to be inserted is record A and the next record to be inserted is B, A- * is set as the record name and “1” is set as the page in the interval table 9. Set B- * as the record name and “2” as the page.
[0042]
In this case, m records can be stored in the database 12, and records for n pages are inserted.
[0043]
In this way, by setting the insertion page for each record to be inserted into the database 12 in the interval table 9, for example, when the insertion of the record A- 1 is instructed, the record insertion processing unit 11 refers to the interval table 9. The record A-1 is inserted into the page of the record A, that is, the first page.
[0044]
Next, when the insertion of the record A-2 is instructed, the record insertion processing unit 11 refers to the interval table 9 and inserts the record A-2 on the page of the record A (after the record A-1 on the first page). .
[0045]
Further, when the insertion of the record B-1 is instructed, the record insertion processing unit 11 refers to the interval table 9 and inserts the record B-1 on the page of the record B, that is, the second page.
[0046]
In this way, by setting in advance in the interval table 9 the page into which records are to be inserted, records that should be logically separated from the same page in the database are not mixed.
[0047]
This page interval function is effective when the number of pages is predetermined, for example, when monthly reports are made on 12 pages for one year.
[0048]
Further, a record insertion operation by the simple interval function will be described with reference to FIG.
[0049]
In this simple interval function, a certain interval (information called page unit) is set in the interval table 9 as record insertion interval information.
[0050]
Therefore, when all the records are inserted, the record insertion processing unit 11 refers to the interval table 9, but there is no designation of the insertion position in the page although there is a page designation, so the record is recorded in an empty area in the page. Insert. That is, a record is inserted at any position within a page.
[0051]
This simple interval function is effective in a business where the number of records to be inserted in one page is fixed, for example, in the case of 12 data for one year.
[0052]
As described above, in the database search system according to the first embodiment, when a record is inserted into the database 12, an interval that is physical record insertion interval information is specified in the interval table, so that the page is logically separated. There is no state where the records to be mixed are present on the same page, and contention at the time of data retrieval can be eliminated.
[0053]
In addition, DB monitoring and reorganization work conventionally performed to avoid a state where records that should be logically separated on the same page are mixed are not required, and workability can be improved.
[0054]
That is, by analyzing the business contents and setting interval data of records to be inserted into the database 12 in the DBMS 2, the search performance of the database 12 is improved and the workability in the operation of this database search system is greatly improved. can do.
[0055]
Next, a second embodiment according to the database search system of the present invention will be described with reference to FIG. FIG. 6 is a diagram showing the configuration of the database search system of the second embodiment.
[0056]
This database search system is a modification of the first embodiment, and includes a business processing unit 30 and a database management system (DBMS) 40.
[0057]
The business processing unit 30 is an application having modules such as the SQL issue processing unit 1a, the SQL determination processing unit 4, and the interval setting processing unit 8.
[0058]
The DBMS 40 includes a load processing unit 3, an insertion processing unit 5, an update processing unit 6, a deletion processing unit 7, an interval table 9, an interval determination processing unit 10, a record insertion processing unit 11, a database 12, and the like.
[0059]
That is, in the second embodiment, the SQL processing unit 1a, the SQL determination processing unit 4, the interval setting processing unit 8 and the like are provided on the business processing unit (application) 30 side, and the insertion position of the record can be determined on the application side. It is a thing.
[0060]
In this case, it is determined whether or not to perform the insertion process when the SQL issuance processing unit 1a performs the SQL issuance process.
[0061]
Here, when performing the insertion processing, the SQL issuing processing unit 1 a instructs the interval setting processing unit 8, and the interval setting processing unit 8 sets interval data in the interval table 9 in accordance with this instruction.
[0062]
When the interval data is set in the interval table 9, an insertion instruction is issued from the business processing unit 30 to the DBMS 40, and the insertion processing unit 5 of the DBMS 40 is activated.
[0063]
Then, when the inserted insertion processing unit 5 performs the insertion processing, the interval determination processing unit 10 searches the interval table 9, performs the interval determination processing, and inserts a record into the database 12 based on the determination result.
[0064]
The interval table 9 changed by the SQL issuance processing unit 4 is returned to the initial setting value when the insertion process is completely completed.
[0065]
As described above, according to the database search system of the second embodiment, the same effects as those of the first embodiment can be obtained, and each process of SQL issuance, SQL determination, and interval setting is performed on the application (business processing unit 30) side. By having a section, it is possible to set the interval in a timely manner in application units (program units), and it can handle special business processing such as inserting a certain record only on a specific page, making it more customizable. This makes it possible to perform detailed record insertion processing.
[0066]
The application (program) described in the above embodiment may be stored in a computer-readable storage medium such as a floppy disk. In this case, each program is read by the computer reading out the program stored in the storage medium. Processing in the form becomes possible.
[0067]
As storage media, programs such as magnetic disk, floppy disk, hard disk, optical disk (CD-ROM, CD-R, DVD, etc.), magneto-optical disk (MO, etc.), semiconductor memory, etc. can be stored and read by a computer. As long as it is a possible storage medium, the storage format may be any form.
[0068]
Further, in order to realize this embodiment, a DBMS, an OS (operating system) operating on the computer, network software, or other MW (middleware) based on an instruction of an application (program) installed in the computer from the storage medium. A part of each process may be executed.
[0069]
Furthermore, the storage medium is not limited to a medium independent of the computer, but also includes a storage medium in which a program transmitted via a LAN or the Internet is downloaded and stored or temporarily stored.
[0070]
Further, the number of storage media is not limited to one, and the case where the processing in the present embodiment is executed from a plurality of media is also included in the recording medium in the present invention, and the media configuration may be any configuration.
[0071]
The computer executes each process in the present embodiment based on a program stored in a storage medium, and includes any one device such as a personal computer or a system in which a plurality of devices are connected to a network. It may be configured as follows.
[0072]
The computer is not limited to a personal computer, but includes an arithmetic processing device, a microcomputer, and the like included in an information processing device, and is a generic term for devices and devices that can realize the functions of the present invention by a program.
[0073]
【The invention's effect】
As described above, according to the present invention, when an instruction to insert a record into the database is issued, the record is inserted into the database based on the interval information held in the interval information holding means. Are logically and physically separated, and the database search performance can be improved.
[0074]
In addition, the database reorganization work that increases the database monitoring and storage interval, which has been conventionally performed, is no longer necessary, and the work during database operation can be reduced.
[Brief description of the drawings]
FIG. 1 is a diagram showing a configuration of a database search system according to a first embodiment of this invention.
FIG. 2 is a flowchart showing the operation of the database search system.
FIG. 3 is a diagram for explaining a record interval function of the database search system.
FIG. 4 is a diagram for explaining a page interval function of the database search system.
FIG. 5 is a diagram for explaining a simple interval function of the database search system.
FIG. 6 is a diagram showing a configuration of a database search system according to a second embodiment of this invention.
[Explanation of symbols]
DESCRIPTION OF SYMBOLS 1 ... Business processing part, 2 ... Database Management System (DBMS), 3 ... Load processing part, 4 ... SQL determination processing part, 5 ... Insertion processing part, 6 ... Update processing part, 7 ... Deletion processing part, 8 ... Interval setting Processing unit, 9 ... interval table, 10 ... interval determination processing unit, 11 ... record insertion processing unit, 12 ... database.

Claims (3)

An information processing apparatus for inserting, changing, and deleting records in a database,
Interval information holding means in which a record insertion page for inserting records into the database, a logical insertion position in the page, and the number of records that can be inserted in the page are set,
Means for issuing an instruction to insert, change and delete a record in the database by a record name;
When an instruction to insert a record into the database is issued , the same record as the first record set in the interval information holding unit is placed at the position next to the inserted record on the page of the first record on the database. While the record is inserted, for the next record with respect to the first record set in the interval information holding means, the first of the next record with an interval of the number set in the first record on the database An information processing apparatus comprising: means for inserting a record at a position . The information processing apparatus according to claim 1,
Information processing further comprising interval information setting means for setting a record insertion page, a logical insertion position in the page, and the number of records that can be inserted in the page with respect to the interval information holding means. apparatus. A method for inserting a record into a database, wherein the record is inserted into the database,
When an instruction to insert a record into the database is issued with a record name, for the same record as the first record set in the interval information holding means, next to the inserted record in the first record page on the database For the next record for the first record set in the interval information holding means, the next record with the number of records set in the first record on the database is inserted . A method for inserting a record into a database, wherein the record is inserted at the first position of the record .

Images