JPH0410142A - Vertical branch type data base access system - Google Patents

Abstract

PURPOSE:To efficiently access data bases by copying partial records of another data base to an own data base on a desired copy condition and retrieving the own data base and another data base on a desired retrieval condition and this retrieval condition, where the copy condition is excluded, respectively at the time of a retrieval request on this desired retrieval condition from a user. CONSTITUTION:When the user requests copying on a copy condition A from a terminal 4, pertinent records are copied to an own data base 3 from another data base 2 and the copy condition A is stored in the copy condition management area of a virtual distributed processing part 1. When the user issues a retrieval request on a retrieval condition B, the own data base 3 is retrieved on the retrieval condition B, and logical NOT A' of the copy condition A from the copy condition management area is added to the retrieval condition B and another data base 2 is retrieved on a retrieval condition A'.B. Thus, retrieval results alpha and beta are coupled by a retrieval result coupling processing part 13, and the result is returned to the user through the terminal 4 as the retrieval result of all records.

Description

[Detailed Description of the Invention] [Objective of the Invention] (Industrial Application Field) The present invention relates to a vertical branching database that can copy and hold some records of tables in other databases in its own database. This invention relates to a vertically branched database access method that can virtualize distributed tables.

(Prior art) As an access method for a vertically branching database, some records of a table that a user wants to access are copied in advance to the own database, and when a search request is received from a user, the records specified by the user are There is a method that searches the own database using search conditions and returns the corresponding records.

(Section 8 to be invented or solved) In the conventional vertical branch database access method described above, some records of tables that may be accessed must be copied to the own database in advance.
There is a problem that the processing is complicated.

The present invention has been made in view of the above, and its purpose is to enable the user to arbitrarily determine the scope of copying from other databases to the own database, and to enable the user to do so without being aware of the own and other databases. The object of the present invention is to provide a vertically branched database access method that can access the database.

[Structure of the invention]

(Means for Solving the Problems) In order to achieve the above object, the vertical branch database access method of the present invention copies some records of a desired table of another database to its own database under desired copy conditions. When the copy conditions are managed as key information, and a user makes a search request using the desired search conditions, the record is searched for the own database using the search conditions, and the record is searched for the record using the search conditions for other databases. The gist of this method is to search for records using the search conditions excluding the copy conditions, combine the search results from both databases, and output the results to the user.

(Operation) In the vertical branching database access method of the present invention, some records from a desired table in another database are copied to the own database under desired copy conditions, and when a user makes a search request using desired search conditions. When the database is searched for the record using the search condition, the other database is searched for the record using the search condition excluding the copy condition, and the search results from both databases are combined. It is output to the user.

(Example) Hereinafter, the present invention will be explained in detail using the drawings.

First, one embodiment of the present invention will be described with reference to FIGS. 1 to 3. In FIG. 1, when a user makes a copy request from a terminal 4 under desired copy conditions A, the corresponding record is copied from another database 2 to its own database 3 under the control of the virtual distributed processing unit 1. At the same time, the copy condition A in this case is stored in the copy condition management area 1 in the virtual distributed processing unit 1.
Remember it in 1.

Next, as shown in FIG. 2, when the user issues a search request using the desired search condition B from the terminal 4, the database 3 is searched using the desired search condition B specified by the user, and the virtual Refinement condition addition processing unit 12 of distributed processing unit 1
A search condition (B-A) in which the logical negation A of the copy condition A obtained from the copy condition management area 11 is added to the search condition B specified by the user, thereby excluding the copy condition A from the search condition B. Search other database 2 using .

Then, as shown in FIG. 3, search result β obtained by searching the own database 3 using search condition B and search condition (B-A) obtained by excluding copy condition A from search condition B are used to search other database 2. The search results α obtained by the search are combined by the search result combination processing unit 13 of the virtual distributed processing unit 1 and returned to the user via the terminal 4 as search results for all records.

FIG. 4 is a flowchart showing the operation of the vertical branch database access method shown in FIGS. 1 to 3;
Next, a specific example shown in FIG. 5 will be explained according to the flowchart.

Out of the personnel tables stored in the other database 2, the personnel information related to copy condition A1, that is, "Branch - Yokosuka" is copied to the own database 3, and also, through processing within the own database 3, among the copied information, " Name - Year of joining Kinugasa Nibu from ``55'' to ``57.''
Suppose you change it to 2018.

In such a case, a process for searching all employees for employees who joined the company in ``55'' will be explained. The user searches his own database 3 using the search condition B, that is, "55 years since joining the company" via the terminal 4 (step 110), and at the same time, the narrowing condition addition processing unit 12 searches the database 3 for the copy obtained from the copy condition management area 11. Negative logic A of condition A, that is, “branch-Yokosuka”, that is, “branch-
"Not in Yokosuka" and the search condition B1, that is, "Joining -5
Search the other database 2 using the logical AND (B-A) with "5 years", that is, "J joined the company - 55 years, not branch - Yokosuka" (step 120). Search both search results. The results are combined in the result combination processing unit 13 (step 13o), thereby obtaining search results for all records in which the change processing has been correctly reflected, and the search results are sent to the user via the terminal 4 (step 140).

FIG. 6 is a diagram showing an example of a system configuration when implementing the vertical branch database access method of the present invention. In the figure, a center 5 is a database that is intended to be shared, and a personal database 7 that can be used exclusively on a personal computer 6 is provided. By applying the vertical branch database access method of the present invention to a system configured in this manner, both databases can be virtually treated as one database.

〔Effect of the invention〕

As explained above, according to the present invention, the conditions for copying from another database to the own database are managed, and in response to a search request from a user, records are searched using search conditions excluding the copy conditions. Therefore, even if the database is distributed and managed between other databases and the own database, the user can access the database without being aware of the scope of copying to the own database or the own and other databases, improving efficiency. I can do it.

[Brief explanation of drawings]

1 to 3 are explanatory diagrams showing the principle of a vertical branch database access method according to an embodiment of the present invention, and FIG. 4 is an illustration of the vertical branch database access method shown in FIGS. 1 to 3. Flowchart showing the operation; FIG. 5 is a diagram showing a specific example of applying the vertical branch database access method shown in FIGS. 1 to 3; FIG. 1 is a diagram showing an example of a system configuration. 1. Virtual distributed processing unit, 2. Other databases, 3. Local database, 4. Terminal, 11. Copy condition management area, 12. Refinement condition addition processing unit, 13. Search result combination processing unit. . Agent: Patent Attorney Hide Kazu Miyoshi] Figure 2, Figure 13, Figure 4

Claims (1)

[Claims] When copying some records from a desired table in another database to the own database using desired copy conditions, the copy conditions are managed as key information, and when a user requests a search using the desired search conditions, Search for the record using the search conditions in the own database, search for records in other databases using the search conditions excluding the copy conditions, combine the search results from both databases, and send the search results to the user. A vertical branch database access method characterized by output.