WO1991004534A1 - Systeme a base de donnees decentralisee et procede d'execution de l'extraction de donnees destine a celui-ci - Google Patents
Systeme a base de donnees decentralisee et procede d'execution de l'extraction de donnees destine a celui-ci Download PDFInfo
- Publication number
- WO1991004534A1 WO1991004534A1 PCT/JP1990/001164 JP9001164W WO9104534A1 WO 1991004534 A1 WO1991004534 A1 WO 1991004534A1 JP 9001164 W JP9001164 W JP 9001164W WO 9104534 A1 WO9104534 A1 WO 9104534A1
- Authority
- WO
- WIPO (PCT)
- Prior art keywords
- keyword
- data
- terminal
- file
- contents
- Prior art date
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/27—Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor
Definitions
- the present invention relates to a distributed database system and a data search processing method thereof, and more particularly, to a distributed database system in which a plurality of terminals each having a distributed and robust database are connected to a public network. It relates to the data search processing method.
- Figure 16 shows an example of the configuration of a distributed database system.
- 5 is a public network
- 6, 7, and 8 are terminals connected to the public network
- 6a, 7a, and 8a are data bases of 6, 7, and 8, respectively
- 6b, 7 b and 8b are the contents of the distributed database of terminals 6, 7, and 8, respectively.
- Each terminal 6, 7, and 8 has a database 6a, 7a, and 8a, respectively, and manages its table of contents 6b, 7b, and 8b.
- Terminals 6, 7, and 8 use the table of contents to search for a terminal that manages the data in response to the data search request, access the terminal via public network 5, and request the search data.
- data processing is performed while interacting with the display screen on a terminal such as a workstation.
- the terminal searches and displays the display screen required by the user.
- the search processing of the display screen must be configured so that it can be executed at high speed in order to increase the efficiency of data processing.
- a configuration is adopted in which the key-pad assigned to the display screen name is specified. That is, as shown in Fig. 17, the terminal manages one or more keywords assigned to each display screen name in units of display screen names. Is provided.
- the terminal displays the display screen to which the specified keyword is assigned according to the key-table when the user specifies the key-pad (if there is more than one K, Display the table).
- the search processing of the display screen is executed as described above.
- the keypad information assigned to the display screen of each terminal is not managed at all according to the concept of distributed processing.
- a keyword it is necessary to search whether the specified keyword is assigned in order from the name of one terminal; and the display screen name at the top of the key word table.
- the display screen since the key information assigned to the display screen of each terminal is not managed, the display screen must be searched for each terminal in accordance with the key. Therefore, it is not possible to easily search the west side of the display of the terminal of the same distributed database system.
- the present invention provides a distributed database system in which predetermined data among data registered in a plurality of terminals as a distributed database is managed by one predetermined terminal, and a data search processing method therefor. The purpose is to do.
- a predetermined terminal is set as a temporary center, and in this temporary center, data retrieval information such as keywords and table of contents information that may be shared in the database of each terminal is registered. .
- the temporary center searches for the terminal that manages the search data. As a result, the load on each terminal in the data search process can be reduced.
- the data search information registered in the temporary center is stored in a keyword link file.
- the keyword link file stores the keyword of the data and at least the number of the terminal that manages the data, that is, the key word as a set. ⁇ Thus, the terminal that manages the data is easily identified. Can be specified. Therefore, which terminal Since it is quickly determined whether or not to perform the search, the search for the data can be performed remarkably fast.
- Fig. 1 is a block diagram of the principle of the present invention
- Fig. 2 is a block diagram of the embodiment
- Fig. 3 is a block diagram of the parts file and key file
- Fig. 4 is a keyword table of contents file.
- Schematic diagram of the file Fig. 5 is a table of contents file configuration diagram
- Fig. 6 is a diagram illustrating the relationship between records
- Fig. 7 is a diagram showing an example of matching link data
- Fig. 8 is a keyword link file.
- Fig. 9 is a diagram illustrating the relationship between records
- Fig. 10 is a diagram illustrating the center system
- Fig. 11 is a diagram illustrating the communication between the center system and the terminal
- FIG. 13 is a flowchart of data version check processing
- Fig. 13 is a flowchart of registration processing
- Fig. 14 is a flowchart of update processing
- Fig. 15 is a flowchart of search processing
- Fig. 16 is a conventional chart.
- Fig. 2 is a block diagram of a conventional keyword table. [Best mode for carrying out the invention]
- Fig. 1 is a block diagram of the principle of the present invention, showing a distributed database system according to the present invention.
- Reference numeral 1 denotes a terminal to which the present invention is applied, which manages distributed database data, for example, registered display screens. 3 is suitable for the present invention.
- This terminal is used as a temporary center (hereinafter referred to as a center system) and manages a plurality of terminals 1 for predetermined data> for example, a registered display screen.
- Reference numeral 10 denotes a man-machine interface provided in the terminal 1
- reference numeral 11 denotes an input / output control unit of the terminal 1, which executes input / output control with the man-machine interface 10
- reference numeral 12 denotes a command.
- a command allocating unit which executes a command allocating process that defines the attributes of the display screen.
- Reference numeral 13 denotes a component file, which is a command assigned to the west side of the registered display.
- 14 manages attribute information such as keywords, and 14 is a keyword file pointed by the component file 13, which is one or a plurality of keys set on the display screen.
- 15 is a link file registration unit that manages words in units of command names, that registers keywords in the link file 32 of the center system 3, and 16 is a link file registration unit.
- the next file, which manages the command names to which each keyword is assigned in units of keys, 17 is a table of contents file registration unit, which is a keyword file.
- the communication control unit 18 registers the data of the file 14 in the table of contents file 16 and communicates data with the other terminals 1 and the center system 3 via the public network 4.
- the interface 31 is an input / output control unit of the center system 3, which executes input / output control with the machine interface 30, and 32 is an input / output control unit. It is a keyword link firmware that manages the terminal number of terminal 1 in which each keyword is registered in units of keywords, and preferably corresponds to the key code.
- a communication control unit 33 manages the command names to be assigned, and executes data communication with the terminal 1 via the public network 4.
- the input / output control unit 11 sends the name of the display screen for which a registration request has been made to the component file 13.
- a process for registering attribute information such as a command name, a key, and the like is executed.
- the command allocation unit 12 performs command name allocation processing.
- the actual data of the key corresponding to the command name is registered in the keyword file 14.
- the link file registration unit 15 stores the new command name and keyword data in the link file 32 of the center system 3.
- the paired data of this registered keyword preferably, in addition to the command name
- its own terminal number preferably, in addition to the command name.
- the table of contents file registration section 17 registers the registered command name / key pair data in the table of contents file 16. In fact, the terminal number that manages this can be specified from the command name.
- the input / output control unit 11 When a search request for the display screen is made from the man-machine interface 10 of the terminal 1 by designating a key word, the input / output control unit 11 does not use the keyword file 14 but the contents file 16 of the table of contents 16. Perform the process of searching for In the table of contents file 16 to be searched, command names are managed in units of keywords. Therefore, the input / output control unit 11 can specify the command name required by one access process, and can correspond to the command name specified by referring to the component file 13. The name of the display screen to be attached is specified, and the display screen associated with the name is displayed on the man-machine interface 10. When a plurality of command names are managed in the table of contents file 16, the display screen corresponding to each command is displayed on the display screen of the man-machine * interface 10. Displays the name of. In this manner, according to the present invention, the corresponding command name can be specified only by accessing the table of contents file 16 once, so that the display screen can be displayed.
- Terminal 1 responds to the keyword for which a search request has been issued. If there is no command name, the link file 32 of the center system 3 is searched through the communication control unit 18. By the search processing of the link file 32, the terminal number that manages the keyword for which the search request is made is specified. Then, the terminal 1 transmits a keyword to the terminal 1 of the specified terminal number via the communication control unit 18 to execute a display screen search request, and is searched according to the above-described processing procedure. Have the display screen transferred. As described above, the display of the corresponding display screen is executed. At this time, if the link file 32 manages the command name, the display name is immediately transmitted by transmitting the command name to the terminal 1 of the specified terminal number. A screen search is performed. In this way, according to the present invention, it is possible to know which terminal 1 should execute the search processing according to the center system 3, so that the display screen search can be executed remarkably fast.
- FIG. 2 illustrates the configuration of the terminal 1 and the center system 3 to which the present invention is applied.
- 10a is a display corresponding to the man-machine interface 10
- 11a is an input / output table processing unit corresponding to the input / output control unit 11
- 19 is a command specifying unit
- Il 16 especially keyword Next? File 16c
- One or more of the command names read from the file are identified according to the interaction with the operator.
- 20 is a real data file, which is a file having a display screen.
- 21 stores actual data of data such as files (hereinafter referred to as parts).
- Reference numeral 21 denotes a part actualization table, which is a command name assigned to a part and an actual data file of the part. It manages the relationship with the stored address in the file 20.
- the table of contents file 16 consists of three more files 16a, 16b and 16c. That is, a keyword table of contents index management file 16a that manages the keyword of keyword file 1 as an index, and the index management A keyword index index file 16b that manages the keywords of the keyword file 14 by assigning item numbers using the file 16a, and this index file 16b It consists of a keyword table of contents file 16c to which link data and matching link data are added by b.
- the final keyword table of contents file 16c can be created from the keyword file 14, but as described above, the keyword table of contents index file 16b
- the use of the file allows for quicker file registration and retrieval.
- the link file 32 of the center system 3 also consists of three files 32a, 32b and 32c.
- a keyword link index management file 32a and a keyword link index file 32b are provided in order to manage the keyword link file 32c.
- the structure of each of the files 32a, 32b, and 32c on the center system 3 side is basically the same as the structure of each of the files 16a, 16b, and 16c on the terminal 1 side.
- the communication control mechanism between terminals 1 and the communication control mechanism between terminal 1 and center system 3 that manages terminal 1 are omitted for convenience of drawing.
- Fig. 3 shows the detailed embodiment of the parts file 13 and the keyword file 14.
- the part file 13 is a screen name, comment, and keyword link of the display screen, which is a part registered in the actual data file 20, (KW link in the figure). It is configured to manage attribute information such as command name, version number, and flags.
- the screen name field stores the name of the relevant screen in a length of up to 40 characters and the abbreviation of the name of the relevant screen in a length of up to 10 characters.
- the key link points to the position in the keyword file 14 of the command name assigned to the screen name.
- the command assigned to the part The name describes the behavior (ie, processing) of the part.
- the version number indicates how many times the part or data having the screen name has been revised.
- the one with the largest version is the latest part, that is, data.
- the flag indicates the presence or absence of external registration of the component having the screen name, that is, data. For example, if the flag is "0", the part cannot be referenced at all except for the terminal 1. Therefore, each file in the own terminal 1 has information about the part. ', Each file in the center system 3 and other 0 terminal 1 has no information about the part. That is, the part is not open ⁇ On the other hand, if the flag is “" ”, the part is open. Therefore, information on the part is stored in the local terminal 1, the center system 3, and other information as necessary. Terminal 1
- Each of the fifteen files exists in the prescribed format.
- the keyword file 14 is pointed to by the key link of the part file 13 and is assigned one or more keywords KW 1, KW 2, KW 1, KW 2, which are assigned to the command name of each part. Configured to manage... ⁇
- Figure 4 illustrates the basic concept of the table of contents file 16, which is one of the features of the present invention.
- Table of contents file
- the keyword file 16 uses the keyword table of contents file ISc, whereas the keyword file 14 manages the keys assigned to each command name in units of command names. , Sort this management content And manages the command names to which each keyword is assigned in units of keywords.
- the registration (creation) processing of the table of contents file 16 by such rearrangement is executed by the table of contents file registration unit 17.
- Fig. 5 shows the details of the three files 16a, 16b and 16c that make up the table of contents file 16.
- the key word table of contents index management file 16a manages the first characters of the keywords in the keyword file 14, such as "A”, “I”, ..., and the starting item number of the first character. .
- the item number is, X, or is Table 7 digit number X 7.
- the upper two digits “ ⁇ , ⁇ 2 ”of the item number are used as the identifier of the first character of the keypad. For example, “01” represents “A”, “02” represents “I”, and “51” represents “ ⁇ ”.
- the remaining five digits of the item number " ⁇ 3 XX 5 X 6 X 7" is the value of 00001 to 99999.
- the item numbers are assigned to each record in the table of contents file 16, and are uniquely determined.
- the starting item number for the first character “A” is “01 00000” in the keyword table of contents index management file 16a. That is, it is an identifier.
- the keyword table of contents index file 16b assigns a more detailed item number to the input keyword based on the item number of the first character registered in the keyword table of contents index management file 16a. And then, for example, Record. However, new input from the middle is registered in the back row of file 16b. Then, the numbers are sorted in the order of the Japanese syllabary every certain period. For example, the item numbers for the keywords "Oh” and “Ai” are "0100010" and "0100020", respectively, and the identifiers are equal. The keyword “Oh” added later is set to the item number “0100011j” between the former two item numbers, and is registered at the back of file 16b.
- the keyword table of contents file 16c basically manages keys and command names (hereinafter also referred to as commands), and also manages item numbers (1) to (3).
- Item No. is a number assigned to each keyword, and is registered as the management number at the beginning of the record using the index file 16b.
- Item number (3) is for linking records to increase the number of commands when the number of commands exceeds one record. For example, as for the keyword “Ah, first, the corresponding command is stored. Also, as the item number 1, the own item number“ 0100010 ”is stored.
- the following keyword“ A No. “0100011” of “Ai” is stored. This Thus, when the keyword “Ai” is newly input, it is easy to search for keywords in the order of the Japanese syllabary, regardless of the physical position on the file. Item number 3 is “N ullj.” This means that the keyword “Oh” does not have the next record. On the other hand, as for item 3 of the keyword “Ai”, “0100021” is stored. This item No. “0100021” stores the command corresponding to the keyword “Ai” and which could not be accommodated in the record of No. “0100020”. Therefore, the keyword “Ai” has two items.
- the terminal 1 “:” is registered.
- searching for a desired display screen from the display screens according to keywords the required display screen can be searched at high speed.
- the key word is managed by the key index table of contents index management file 16a that manages the first character and the item number associated with it, and the item number of this file 16a.
- the provision of the index table of contents index file 16b to be managed enables quick retrieval using keywords.
- a table of contents file 16c can be created, which allows a quick search in the order of the specified characters.
- the keyword table of contents index management file 16a and the keyword table of contents index file 16b are used, the keyword table of contents file 16c is registered in the predetermined character order. Searching in the predetermined character order can be easily performed.
- the keyword index file 16c is prepared after the item number corresponding to the keyword is prepared in the keyword index index file 16, so that the keyword index file can be easily created. Can be performed.
- Fig. 6 shows the relationship of each record in the keyword table of contents file 16c.
- the size of one record is fixed length.
- an item number (item number 1) that is uniquely determined for each record is added.
- One record corresponds to one keyword in principle. Therefore, since the record is fixed length (that is, only a predetermined number of commands can be registered), if the number of commands exceeds a predetermined value, it is truncated and not saved. Command may not be displayed. Therefore, the keyword table of contents file 16c contains one command for the keyword.
- the link data with the next record is also managed as item No. 3.
- terminal 1 specifies a keyword, not only the command name associated with that key word, but also the command name associated with another keyword linked with the link data. Are identified. Therefore, even if the number of commands for each keyword increases:
- the display screen can be displayed for any number of commands without truncation. The above link can be performed between records as long as the file capacity allows.
- the item No. 3 in the “link data of the next record” is the second record from the top in Fig. 6 (the first record). Item 2 of the 2nd record).
- the keyword of the first record can store the command corresponding to the second record.
- the keyword, item No. 2 and item No. 3 of the second record are “Null”. This is because the second record follows the first record. However, if it is necessary to store more commands for the key record of the first record, it is pointed to the item No. 3 of the second record and the item No. 4 of the linked record. You. Similarly, the required number of records can be linked.
- the end of each record is In the field, the matching link data corresponding to the key or item number is stored as item number.
- This matching link data stores a keyword that has some relationship with the keyword by its item number (item number 1).
- the keyword index file 16 and the matching link data indicating the matching between keywords by item numbers are managed together.
- the item of “matching link data”, ie, item No. is the third record from the top of FIG. 6 (the third record) and the fourth record from the top. Item (4th record). Therefore, each record can store multiple item numbers as its item number.
- the third record and the fourth record are different from the second record in that they are ordinary independent records. — Is When the first record is specified by its keyword> Not only the command in the first record but also the commands in the linked third and fourth records Can be identified. At this time, the command of the second record, which is a continuation of the first record, is also specified.
- Fig. 7 shows an example of matching link data.
- the item numbers are from “001” to “006”. Since the key of item number “001 j does not have a similar keyword, the matching link data is“ N u 1 1 ”.
- the keyword of item number “002” has “003” and “005” as matching link data.
- the keyword of item number “003” has “006” (and “002j”) as the matching link data.
- the keyword of item number “005” has “002”,... as the matching link data.
- the keyword of item number "006” has "003", ... as matching link data.
- the command of item number "003"> "005"> "006 ." is specified in addition to the command of item number "002".
- the command may be specified by considering the “depth of association” so that infinite chains do not occur due to the matched link data. For example, when the keyword of item number “002 j” is specified, only item numbers “003” and “005 j” specified in the direct match link data are specified. You may also specify the item numbers “003” and “005” directly indicated to the item numbers “006” and so on.
- the present invention is characterized in that a link file 32 is provided on the center system 3 side.
- the link file 32 is composed of three files 32a, 32b, and 32c.
- Files 32a, 32b and 32c correspond to files 16a, 16b and 16c at terminal 1, respectively. Therefore, the files 32a, 32b, and 32c have the same structure as the files 16a, 16b, and 16c described above, respectively.
- the keyword link index file 32a and the keyword link index file 32b are provided in addition to the key link file 32c, so that the center system 3 is provided.
- the keyword can be searched at high speed.
- the keyword link file 32c also manages link data
- the terminal number and command name associated with the keyword are assigned. In addition to this, it is possible to identify other command names registered beyond the limit of one record by the link data.
- the terminal 1 receives the link data, the command name associated with the keyword of the linked item number, or the command name associated with that keyword. From the terminal 1 of the terminal number, the desired command name can be characterized by using the AA.
- the keyword link file 32c manages the link data together, when a keyword is specified from the terminal to the center system, the keyword matches not only the terminal number and command name associated with the keyword. It is also possible to specify the terminal number and command name associated with another keypad linked by the link data. If there is no corresponding command name in terminal 1, the command name is specified by matching link data from center system 3, or the desired command name is specified from terminal 1 by receiving matching link data. be able to.
- the link file 32 is similar to the union of the table of contents file 16 of multiple terminals 1. Therefore, the link file 32 of the center system 3 is expected to be considerably large. It is expected that searching the link file 32 in the center system 3 will require considerable time.
- the configuration of the keyword link file 32c may be as shown in Fig. SA.
- Figure 8A shows This contrasts with Fig. 4 and shows the basic concept of the configuration of the keyword link file 32c.
- the key link file 32c is used as information for identifying the terminal 1 in which each keyword is registered in units of keywords, and the terminal number of the terminal 1 (instead of the command name) is used. TN).
- the actual keyword link file 32c has the same configuration as the keyword table of contents file 16c shown in Fig. 5, in which terminal numbers are stored instead of commands. Since the terminal number is shorter than the command, the file size can be reduced accordingly.
- the keyword link file 32c may be configured as shown in Fig. 8B.
- Figure 8B is also comparable to Figure 4.
- This keyword link file 32c is configured to manage the command name associated with the keyword in addition to the terminal number.
- FIG. 9 shows the relationship of each record in the key drink file 32c in this case.
- the center system 3 notifies the terminal 1 that requested the search the terminal number of the terminal 1 that manages the command corresponding to the keyword, but this terminal number usually needs to be extracted from the command. is there. Therefore, if a command is obtained as a result of the search, this extraction processing is necessary.
- the terminal number is obtained as the search result, which eliminates the extraction process and results in a high-speed search. Become.
- the center system 3 is a link file
- the terminal 1 is provided with the link file 32
- the terminal 1 provided with the link file 32 can be said to be the temporary center, that is, the center system 3.
- the center system 3 is also just one terminal 1, and differs from the other terminals 1 only in that a certain item of the distributed database, for example, a link file 32 for the display screen is provided. is there.
- Fig. 10 shows an outline of the creation of the link file 32, that is, the setting of the center system 3.
- the terminal 1A declares to be a temporary center (center system 3), and notifies the other terminals IB and 1C via the public network 4 of this.
- the terminals 1 B and 1 C respectively transmit, via the public network 4, the search data such as the table of contents and keywords regarding the data that may be shared (external registration) in their own databases.
- End 1 Send to A.
- Terminal 1A that has received the search information stores this search information in its own file.
- the terminals 1 B and 1 C transmit the contents of their own component file 13, of which the external registration is permitted (that is, the flag can be set to “ ⁇ ”).
- Terminal 1A is Create link file 32 based on the received information.
- the terminal 1A also uses the contents of its own component file 13 that can be externally registered to create the link file 32. Therefore, the link file 32 is an integrated version of the data of the table of contents file 16 of each terminal 1A to 1C that is permitted to be registered externally.
- the terminal 1A has a link file 32 in addition to its own table of contents file 16. By providing the link file 32, the terminal 1A becomes the center system 3.
- terminal 1A creates data table of contents 34 in the same way as link file 32.
- the data table 34 has, for example, a configuration substantially similar to that of the component file 13, and is a list of components (data) that are permitted to be externally registered.
- Data Table 3 shows only "Screen Name” and "Version” for convenience of illustration.
- all the search information on the shared data in the database of each terminal 1A to 1C is registered in the center system 3 together with the corresponding terminal number (actually, the command) and is centrally managed. Then, when a data search request is generated at a certain terminal, for example, terminal 1B, first, the center system 3 is queried for search information, and the terminal 1C that manages the requested data is searched. Next, terminal 1 B finds terminal 1 You can directly access C and retrieve the required data.
- Terminals 1 B> 1 C other than the center system 3 do not manage the table of contents of the shared data of the entire distributed database, so the terminals IB and 1 C alone manage the required data. You cannot find the number.
- the terminal IB, 1C refers to the table of contents
- it requests the center system 3 for the table of contents, and the center system 3 sends the table of contents (one of the contents of the link file 32).
- the terminal number that manages the data to be obtained can be found. If a keyword is used, this keyword is sent to the center system 3, and the center system 3 checks whether the keyword is applicable. If "Yes", the keyword is registered with this keyword. The terminal number is sent to the sender terminal.
- Figure 11 shows the communication between the center system 3 and the terminal 1.
- Terminal 1A declares a temporary center and notifies other terminals 1B and 1C that they have become a temporary center (center system 3).
- the other terminals 1B and 1C that have received the notification respectively transmit the search information such as keywords and tables of contents related to the shared data in their own databases to the center system. Send to system 3.
- the center system 3 registers the received search information in its own link file 32 or the like. As described above, the search information on the shared data in the distributed database system is centrally managed by the center system 3.
- the terminal 1 B that has issued the data search request queries the center system 3 for search information.
- the center system 3 performs processing according to the contents of the inquiry. That is, in the case of an inquiry using a keyword, this keyword is searched for in the registered data, and the corresponding terminal number is returned to the inquiry source terminal 1B. If the keyword cannot be found, a response to that effect is made.
- Terminal 1B refers to this table of contents information to find a terminal that manages the required data.
- Terminal 1B confirms terminal 1C found in this way, requests data from it, receives the data, and displays the data.
- the center system 3 consisting of a terminal 1. Therefore, the center system Terminals IB and 1C other than system 3 need only have the function of connecting and communicating with other terminals 1C and 1B and public network 4 via the public network. , 1C can be searched without imposing a load.
- the terminals 1 B and 1 C other than the center system 3 may be configured as workstations, computers, and computers alone.
- the center system 3 maintains the identity of the data (parts) at each terminal 1A to 1C by having the "version number" as information in the data table of contents 34. be able to. In other words, data can be created and updated only by the originating terminal. However, when data that is permitted to be externally registered (opened) is updated, the data is exchanged between the terminals 1A to 1C. Data inconsistencies may occur. In order to avoid this, the person who updated the data must notify each of the terminals 1A to 1C of the change in the data, which is complicated. Therefore, the “version” is managed in the data table 34 of the center system 3 so that the terminals 1 B and 1 C that search data can use the data table 34 to check whether or not the data is the latest data. .
- Figure 12 shows the processing flow of the data version check.
- One terminal 1B is strong and another terminal 1C
- a command request is issued to the center system 3 and the command is acquired. Then, this command is used to search the database in the local terminal 1B. That is, it checks whether the data exists in the file of the local terminal IB.
- terminal 1B learns source terminal 1C from center system 3 and receives the relevant data from terminal 1C (performs data learning) by the processing in Fig. 11. This learned data is displayed on CRT of terminal 1B in later processing (1).
- Terminal 1B If the data is data that was previously learned by processing (2) or the like, the data exists in its own terminal 1B. Terminal 1B then knows the latest version number of the data by referring to “version number” in data table 34 of center system 3. Then, it compares the version of its own data with the version obtained from Center System 3.
- the version number of the data held by the user can be known from the component file 13 for the data. Therefore, this version number remains as it was when the data was obtained.
- a data change notification is sent from the data source terminal 1 each time the data is changed.
- This message Knowledge consists of, for example, the data name (eg, screen name) and the latest version number. Therefore, the version number of the data table 34 of the center system 3 is always the latest. For this reason, if the data is changed after terminal 1B relays the data, the version number of its own data and the version number obtained from center system 3 are different (the data version numbers match. No), 10 If the versions of the data match, Terminal 1B extracts the data from its own file. This data has been confirmed to be the latest data by matching the version numbers. This data will be displayed on the CRT of terminal 1B in later processing (1).
- terminal 1B obtains the original terminal 1C from center system 3 and obtains the latest version of the data from terminal 1C by the processing in Fig. 11. (Re-learn the data). The re-learned data will be displayed on the CRT of terminal 1B in later processing c . The latest version of the data to be referred to will be displayed on the CRT of terminal 1B.
- any of the terminals 1A to 1C can search and refer to the latest data.
- Figure 13A shows the overall flowchart of the part registration process.
- step S1 actual data (for example, a screen) is created and registered as a part (step S1). This processing will be described later with reference to FIG. 13B.
- Matching link data is set for the registered parts (step S2). This process is shown in Figure 13C.
- step S3 It is checked whether or not the record force of the keyword table of contents file 16c for the part concerned exceeds a fixed record length of 1 record.
- step S4 If it exceeds, the link data of the next record is set (step S4). This process is shown in Figure 13D. If not, step S4 is not executed.
- the keywords are rearranged in a predetermined order, for example, in the order of the Japanese syllabary (step S5). This process is shown in Figure 13E.
- step S6 Of the registered parts, those for which external registration is permitted are specified and registered in the center system 3 (step S6). This process is shown in Figure 13F.
- Fig. 13B shows the part registration process and displays the registration screen.
- the process for registering data in the parts file 13 and the contents file 16 is shown below.
- the terminal 1 When the actual data of the part is stored in the actual data file 20, the terminal 1 is activated and a registration screen for registering the part is displayed on the display 10a (step S7).
- the terminal 1 stores the part screen 13 with the part screen name, comment, and command name (what kind of part is this?). ), And register attribute information such as the version number (step S8).
- the command allocating unit 12 executes a unique command allocating process in the system.
- the version number is "" "because of new registration.
- one or more keywords assigned to the component to be registered are registered in the keyword file 14 in association with the command name in the keyword file 14 through the above-mentioned dialog (Step 1). S 9).
- step S10 When the keyword file 14 is created in this way, the terminal 1 works hard, and the key number in each file 14 in this file 14 is determined by the fifth character. A search is made from the keyword table of contents index management file 16a shown in the figure (step S10).
- the table of contents file registration unit 17 ⁇ For each keyword, this item number is associated with a more detailed item number, and the keyword table of contents is entered. It is registered as an index file 16b (S11). From the keyword table of contents index file 16b and keyword file 14 thus created, a table of contents file registering section 17 is added for each keyword as shown in FIG. The registered item number and the item number assigned to the next key word are registered to create a keyword table of contents file 16c (step S12).
- Fig. 13C shows the process of setting the matching link, and shows the process of selecting the matched keywords and registering them in the keyword index file 16c.
- the keyword (eg, elementary school student and junior high school student) to be matched from the keyword index index file 16b registered in step S4 and the keyword (eg, student) of the registration destination are The operator selects from the screen and specifies the item number. As a result, as shown in FIGS. 6 and 7, matching link data is added to the keyword table of contents file 16c, and the item number of the key word to be matched is registered (step S13). . This registration is performed by the table of contents file registration unit 17.
- Fig. 13D shows the process for setting the record link data, and when the number of commands corresponding to the keyword becomes too large to be registered in one record, the process for registering the next record.
- the table-of-contents file registration unit 17 registers the item number (item number 1) of the expanded record as item number 3 in the previous record (step S15).
- steps S14 and S15 are repeated until all the commands can be registered.
- Figure 13E shows the file reordering process, and shows the reordering process of newly registered keys in the keyword table of contents file 16c and the keyword table of contents index file 16b. .
- step S16 the item number of the record in the order of the following Japanese syllabary is registered in each record of the keyword index file 16b (step S16).
- step S17 the item number of the record in the order of the next Japanese syllabary is registered as item No. ⁇ in each record of the keyword table of contents file 16c (step S17).
- step S18 By rearranging the records of the files 16b and 16c created in this way in the order of item numbers over a certain period (step S18), the key-index table of contents in alphabetical order A file 16b and a keypad table of contents file 16c are created. These processes are This is performed by the next file registration unit 17.
- Fig. 13F shows the external registration process, in which a part (surface name) for which external registration is permitted is specified, and the corresponding keyword and command are sent to the center system 3 for registration.
- the link file registration unit 15 When registering the data registered in the keyword index file 16c in the center system 3, the link file registration unit 15 displays a registration surface for external registration on the display 10a and interacts with the operator. Then, a reception process for specifying a component registered in the center system 3, for example, a screen name is executed (step S19). As a result, the flag of the component file 13 corresponding to the screen name is set to “ ⁇ ”.
- the link file registration unit 15 searches the component file 13 to search for the keyword and command name assigned to the specified screen name (step S20).
- the link file registration unit 15 adds the searched keyword and the command name (and the terminal number of the own station), and transmits the command to the center system 3 (step S21).
- the center system 3 when the center system 3 receives this transmission data, it checks whether or not the same keyword as the keyword requested for registration is registered in the keyword link file 32c. If you are registered The command name of the terminal 1 requesting registration is registered in the entry of the keyword. That is, the command is additionally registered to the existing record. If not registered, the keyword and the command name for which registration is requested are registered in the keyword link file 32. As described above, the registration processing to the center system 3 is executed (step S22).
- link data and item numbers are not transmitted to the center system 3 is that it is necessary for each terminal 1 to link only those parts for which external registration is desired. Therefore, after this, the center system 3 adds link data based on the registered keyword link file 32c in the same manner as the terminal. In this case, in the keyword link file 32c, it is sufficient to register the item number, command and its link data for each keyword, but register the terminal number in addition to the command. The terminal number may be notified directly from the center system 3.
- the center system 3 can create the keyword link file 32c by adding the terminal number to the command and registering it in the cases shown in Figs. 8B and 9.
- Fig. 14 shows the part update process according to the present invention.
- the actual data of the part is updated, and the updated actual data The data is registered in the actual data file 20 (step S23).
- the terminal 1 counts up the version number of the part in the part file 13 by +1 (step S24).
- step S25 the registration process described with reference to FIG. 13 is performed.
- the terminal 1 checks whether or not the flag of the component is “ ⁇ ” in the component file 13 (step S26).
- the component is a component that can be registered externally and has been registered externally at the time of the previous registration (Fig. 13F).
- a re-registration request is sent to the center system 3 together with the screen name and the new version number (step S27), where the data table 34 is updated and the new version is updated. It is a number.
- step S27 is not performed. This is because external registration is not allowed for this part, and it is data used only by the terminal 1 concerned.
- Figure 15A shows the overall flow of the search process.
- terminal 1 calls up the keyword selection (designation) screen by interacting with the operator and displays the keyword list.
- the terminal 1 checks whether or not it exists in the terminal 1 by searching its own keyword index index file 16b (step S29).
- search processing in own terminal 1 is performed (step S30). This process is shown in Figure 15B.
- step S31 This process is shown in Figure 15C.
- the screen names of the parts obtained in steps S30 and S31 are displayed on the display 10a (S32).
- step S32 the terminal 1 executes command selection, that is, narrowing down of screen names as necessary, by interacting with the operator (step S33). This process Is shown in Figure 15D.
- the display screen specified by the narrowed screen name is displayed on the display 10a (step S34) ⁇
- Fig. 15B shows the search processing in own terminal 1.
- the terminal 1 calls the index table of contents index file 16b, displays a list of the keywords, and selects the keyword of the screen to be searched (step S35). .
- the terminal 1 calls and searches the keyword index file 16c, and specifies a command name (there may be a plurality of command names) associated with the specified keyword (step S36).
- step S37 it is checked whether or not the item number link between the records exists on the screen of the keyword table of contents file 16c on which the terminal 1 is displayed.
- the terminal 1 specifies the corresponding command name from the item number of the key indicated by the link data (step S38).
- terminal 1 uses the item number 3 of the keyword table of contents 16c to record the next record.
- the command of item number “0100021” is also specified.
- the terminal 1 skips step S38 and executes step S39.
- Terminal 1 checks whether a matching link exists in the screen of the displayed keyword table of contents file 16c. (Step S39).
- the terminal 1 identifies the corresponding command name from the keyword item number indicated by the matching link data (step S40).
- the matching link data indicates the item numbers “003” and “005”. ",” 003 "and” 005 "are equivalent to specifying the three keywords. It should be noted that the other keyword is registered in the matching link data, and similarly, the item number of the original keyword is also registered in the matching link data of the other keyword.
- terminal 1 skips step S40 and executes step S41.
- the terminal obtains a screen name corresponding to the command name specified in steps S36, S38 and S40 (step S41) and displays it on the display 10a (step S32). ).
- the screen name is specified from the command name for the following reasons.
- the command describes the procedural meaning of the part.
- the terminal 1 and the data processing unit in the center system 3 send and receive this command as a message. This allows data processing to be performed. Therefore, the terminal 1 and the center system 3 basically handle the parts according to the command.
- a command name equivalent to the command name is used according to the screen name of the character string that can be understood by the operator. indicate. With this configuration, even if the screen name is changed later, the corresponding display screen can be specified without any error.
- Figure 15C shows the search processing in the center system 3.
- terminal 1 executes the reception processing of the key-pad specification by interacting with the operator, and receives it.
- the keyword is transmitted to the center system 3 (step S31).
- the center system 3 searches the link file 32 in the same procedure as the search processing in the terminal 1 shown in FIG. 15 and identifies the command corresponding to the keyword (step S42). That is, the same processing as in step S35 is performed using the keyword link index file 32b, and the same processing as in steps S36 to S40 is performed using the keyword link file 32c.
- the center system 3 returns the command name specified in step S42 as a search result to the terminal 1 that has requested the search (step S43).
- Terminal 1 receiving this search result displays the received command name on display 10a, and selects one command name from among multiple command names by interacting with the operator. Then, the terminal 1 having the actual data of the component corresponding to the specified command is transmitted with the command name to request the data (step S44).
- Terminal 1 that has received this command name reads the display screen data of the component associated with this command name from its own actual data file 20 via its own component realization table 21 and makes a request. Send to former terminal 1. If the keyword name of the center system 3 does not manage the command name, terminal 1 asks the keyword to be sent so that the display screen of the part can be read. put out.
- the requesting terminal 1 Upon receiving this data, the requesting terminal 1 stores it in its own actual data file 20 and performs the registration process shown in Fig. 13 on this data. After that, the terminal 1 obtains the screen name associated with the command name in the same manner as in step S41, and It is displayed on the screen 10a (step S32).
- the center system 3 can know which terminal 1 should execute the search processing, the search of the display screen can be executed at extremely high speed.
- a search request is sent to the center system 3 in a batch, and the search results are also reported in a batch. For example, the display of the received command name is repeated for the number of screens.
- FIG 15D shows the command selection process.
- the screen name displayed in step 32 is usually plural. Therefore, the terminal 1 determines whether the operator uses another keyword to request a screen name narrowing down (step S45).
- the terminal 1 executes the reception process for the next keyword (step S46).
- the terminal 1 searches the keyword table of contents file 16c, identifies one or more command names associated with the specified key, and responds in accordance with the component file 13.
- the screen name is obtained, and a narrowing down process is executed by specifying a screen name that is the same as the screen name previously obtained (step S47).
- the terminal 1 displays the narrowed west side name on the display 10a (step S48), and performs processing to return to step S24.
- step S45 determines whether or not the specified screen names are plural (step S49), and the request for the display screen to be displayed is It is determined whether there is more than one (step S50). If there are a plurality of specified screen names and a plurality of display screen display requests are specified, the terminal 1 opens a window and displays the specified display screen. Is displayed (step S51). On the other hand, if there are multiple specified screen names and there is a display request for one display screen,> Terminal 1 executes the selection processing of one screen name from step 50 in accordance with the interaction with the operator (step S52), the display of the selected display screen is executed (step S53). If there is only one display screen specified in step S49, terminal 1 executes the display of the display screen (step S53). Steps S51 and S53 overlap with step S34.
- the specific display processing of the display screen is as follows.
- the component realization table 21 is searched to specify the address information associated with the command name, and the actual data file 20 is determined in accordance with the specified address information. This is executed by reading the display screen data of the corresponding part from the.
- the display command screen corresponding to the display 10a can be displayed by specifying the corresponding command name by accessing only one screen of the keyword table of contents file 16. it can.
- the distributed database system and the data search processing method according to the present invention are useful when it is necessary to perform high-speed data search, and in particular, a large number of systems connected via a public network. It is suitable for high-speed retrieval of data that has been released between terminals, while minimizing the burden on each terminal.
Landscapes
- Engineering & Computer Science (AREA)
- Databases & Information Systems (AREA)
- Theoretical Computer Science (AREA)
- Computing Systems (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Description
Claims
Applications Claiming Priority (8)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
JP23943989 | 1989-09-14 | ||
JP1/239439 | 1989-09-14 | ||
JP1/265571 | 1989-10-12 | ||
JP26557189 | 1989-10-12 | ||
JP1/337033 | 1989-12-26 | ||
JP33703389 | 1989-12-26 | ||
JP33936889 | 1989-12-27 | ||
JP1/339368 | 1989-12-27 |
Publications (1)
Publication Number | Publication Date |
---|---|
WO1991004534A1 true WO1991004534A1 (fr) | 1991-04-04 |
Family
ID=27477767
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
PCT/JP1990/001164 WO1991004534A1 (fr) | 1989-09-14 | 1990-09-11 | Systeme a base de donnees decentralisee et procede d'execution de l'extraction de donnees destine a celui-ci |
Country Status (3)
Country | Link |
---|---|
EP (1) | EP0443035A4 (ja) |
CA (1) | CA2042052A1 (ja) |
WO (1) | WO1991004534A1 (ja) |
Citations (4)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
JPS61283943A (ja) * | 1985-06-11 | 1986-12-13 | インタ−ナショナル ビジネス マシ−ンズ コ−ポレ−ション | デイレクトリ・デ−タベ−ス装置 |
JPS62125445A (ja) * | 1985-11-26 | 1987-06-06 | インタ−ナショナル ビジネス マシ−ンズ コ−ポレ−ション | デ−タ・オブジエクト・レプリカの管理方法 |
JPS62126458A (ja) * | 1985-11-26 | 1987-06-08 | インタ−ナショナル・ビジネス・マシ−ンズ・コ−ポレ−ション | デ−タ・オブジエクト変更管理方法 |
JPS62198929A (ja) * | 1986-02-27 | 1987-09-02 | Ricoh Co Ltd | デ−タベ−ス検索システム |
Family Cites Families (2)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
EP0204993A3 (en) * | 1985-06-11 | 1990-08-22 | International Business Machines Corporation | Hybrid directory data distribution system |
CA1260151A (en) * | 1985-06-11 | 1989-09-26 | Frank D. Bartocci | Propagation of network queries through superior- subordinate and peer-peer data distribution relationships |
-
1990
- 1990-09-11 WO PCT/JP1990/001164 patent/WO1991004534A1/ja not_active Application Discontinuation
- 1990-09-11 EP EP19900913228 patent/EP0443035A4/en not_active Ceased
- 1990-09-11 CA CA002042052A patent/CA2042052A1/en not_active Abandoned
Patent Citations (4)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
JPS61283943A (ja) * | 1985-06-11 | 1986-12-13 | インタ−ナショナル ビジネス マシ−ンズ コ−ポレ−ション | デイレクトリ・デ−タベ−ス装置 |
JPS62125445A (ja) * | 1985-11-26 | 1987-06-06 | インタ−ナショナル ビジネス マシ−ンズ コ−ポレ−ション | デ−タ・オブジエクト・レプリカの管理方法 |
JPS62126458A (ja) * | 1985-11-26 | 1987-06-08 | インタ−ナショナル・ビジネス・マシ−ンズ・コ−ポレ−ション | デ−タ・オブジエクト変更管理方法 |
JPS62198929A (ja) * | 1986-02-27 | 1987-09-02 | Ricoh Co Ltd | デ−タベ−ス検索システム |
Non-Patent Citations (1)
Title |
---|
See also references of EP0443035A4 * |
Also Published As
Publication number | Publication date |
---|---|
EP0443035A1 (en) | 1991-08-28 |
EP0443035A4 (en) | 1992-12-09 |
CA2042052A1 (en) | 1991-03-15 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
US5634048A (en) | Distributed database system having a center system with a link file and a method for retrieving data from same | |
US6298349B1 (en) | System resource display apparatus and method thereof | |
US5315705A (en) | Communication address management system | |
WO1991004532A1 (fr) | Systeme a centre temporaire dans un systeme a base de donnees decentralisee | |
US6725251B2 (en) | Local-file-transfer method and local-filed-transfer system for client-server system | |
EP0150273B1 (en) | Multi-lingual system across nodes | |
US20020111944A1 (en) | Data lookup | |
JP2002099568A (ja) | 個人用ブックマーク自動作成機能を有したwwwサーバー | |
JPH07297924A (ja) | 電話システム及びその制御方法 | |
JP2527904B2 (ja) | ユ―ザ入力の挿入支援方法 | |
WO1991004534A1 (fr) | Systeme a base de donnees decentralisee et procede d'execution de l'extraction de donnees destine a celui-ci | |
JP2629072B2 (ja) | 分散型データベースシステム及びそのデータ検索処理方法 | |
US7036074B1 (en) | Apparatus and method for controlling display of database search items | |
JPH0546450A (ja) | マルチホストデータベースアクセス装置 | |
EP0555881A2 (en) | Office automation system wherein files in a database are available to electronic mail services | |
JP3436392B2 (ja) | ネットワークにおける計算機資源管理装置 | |
JPH10143525A (ja) | 携帯情報端末装置 | |
JPH08272810A (ja) | 分散データベースシステム | |
JPH0728834A (ja) | 情報検索装置 | |
JPS63121924A (ja) | 情報処理システム | |
JP2001060203A (ja) | ホームページ検索システムおよびこのシステムを用いたホームページ検索方法 | |
JPH034354A (ja) | 情報分散処理システム | |
EP0292647A2 (en) | Operator assistance method for data processing | |
JPH11195044A (ja) | 情報流通システム及び可搬型記憶媒体 | |
JP2710689B2 (ja) | 分散型データベースシステムにおける仮センター方式 |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
AK | Designated states |
Kind code of ref document: A1 Designated state(s): CA JP US |
|
AL | Designated countries for regional patents |
Kind code of ref document: A1 Designated state(s): AT BE CH DE DK ES FR GB IT LU NL SE |
|
WWE | Wipo information: entry into national phase |
Ref document number: 2042052 Country of ref document: CA |
|
WWE | Wipo information: entry into national phase |
Ref document number: 1990913228 Country of ref document: EP |
|
WWP | Wipo information: published in national office |
Ref document number: 1990913228 Country of ref document: EP |
|
WWR | Wipo information: refused in national office |
Ref document number: 1990913228 Country of ref document: EP |
|
WWW | Wipo information: withdrawn in national office |
Ref document number: 1990913228 Country of ref document: EP |