JP2006146588A - Database access system, database access device, character string substitution method, and computer program - Google Patents

Abstract

<P>PROBLEM TO BE SOLVED: To easily and surely implement substitution of character strings in a plurality of specifications. <P>SOLUTION: An information processing device 100, which can access a database 200 to register and capture data on the contents of descriptions of specifications (design information data), is provided with; a term conversion guidance screen display part 105 which displays a term conversion guidance screen on a display device 400 according to inputted instructions; a character string retrieval part 106 which receives the designation of a retrieval character string through the term conversion guidance screen and retrieves data including the retrieval character string from the design information data registered with the DB 200; a retrieval result display part 107 which displays the result of the retrieval on the display device 400; a character string substituting part 108 which receives the designation of a substituting character string through the term conversion guidance screen and substitutes the substituting character string thus received for the retrieval character string thus retrieved; and a retrieval result display part 109 which displays, on the display device 400, the result of the substitution made by the character string substituting part 108. <P>COPYRIGHT: (C)2006,JPO&NCIPI

Description

  The present invention accesses a database in which data of description contents of a plurality of documents such as specifications (hereinafter simply referred to as specifications) is registered, and converts a character string included in the data into a character string designated by the user. The present invention relates to a database access system, a database access device, a character string replacement method, and a computer program that can be replaced.

  In recent years, most specifications for designing a certain object are created by document creation software or spreadsheet software. In a specification created by general document creation software or spreadsheet software, when a character string is to be replaced, the specification including the character string to be replaced is opened. Then, if a character string to be searched and a character string to be replaced are input on a replacement screen displayed by a predetermined command and the replacement execution is instructed, the replacement of the character string is executed.

  However, for example, if the design object becomes complicated, many specifications will be created. It is desirable to use the same terminology in these multiple specifications, but replacing the character strings with the specifications open one by one as described above is very laborious. Furthermore, the replacement may leak.

  The present invention has been made in view of the above points. Instead of executing character string replacement in a plurality of specifications on the document creation software or spreadsheet software, the specification registered in the database is used. An object of the present invention is to enable easy and reliable replacement of character strings in a plurality of specifications by enabling execution of data of description contents.

  A data access system according to the present invention includes an information processing apparatus capable of accessing a database in which data of description contents of a plurality of specifications are registered, an input device connected to the information processing apparatus, and the information processing apparatus. A database access system comprising a display device connected to the information processing device, wherein the information processing device uses search means for searching for data including a character string designated by a user from data registered in the database, and the search means Display means for displaying data including the searched character string on the display device, and replacement means for replacing the character string included in the data searched by the search means with a character string designated by the user Characterized by points.

A database access device according to the present invention is a database access device capable of accessing a database in which data of description contents of a plurality of specifications is registered, and a character string designated by a user from the data registered in the database. A user designates a search means for searching for data to be included, a display means for displaying data including the character string searched by the search means on a display device, and a character string included in the data searched by the search means And a replacement means for replacing the character string.
Another feature of the database access apparatus according to the present invention is that the display means includes information indicating to which specification the data belongs when displaying the data including the character string searched by the search means. It is in the point to display in association. Furthermore, the display means is further characterized in that information indicating which item of the specification document belongs is displayed in association with each other.
Another feature of the database access apparatus of the present invention is that when the display means displays data including the character string searched by the search means, the character string is replaced with another character string. It is in the point of displaying differentiated.
Another feature of the database access apparatus according to the present invention is that it is possible to narrow down specifications to be searched when searching by the search means.
Another feature of the database access apparatus according to the present invention is that the data to be replaced among the data searched by the search means can be specified when the replacement is performed by the replacement means.

  According to the character string replacement method of the present invention, a character string included in the data is replaced with a character string designated by a user by an information processing apparatus capable of accessing a database in which data of description contents of a plurality of specifications is registered. A method for searching for data including a character string designated by a user from data registered in the database, and a display unit of the information processing device, A procedure for displaying data including the character string searched for by the search means on a display device, and a replacement means of the information processing device specifies the character string included in the data searched by the search means. And a procedure for replacing with a character string.

  The computer program of the present invention is a computer program executed on a computer capable of accessing a database in which data of description contents of a plurality of specifications is registered, and is designated by the user from the data registered in the database Search processing for searching for data including a character string to be displayed, display processing for displaying data including the character string searched for by the search processing on a display device, and the character string included in the data searched for by the search processing It is characterized in that the computer executes a replacement process for replacing the character string designated by the user.

  According to the present invention, the character strings included in the data of the description contents of the plurality of specifications can be collectively replaced with the character string designated by the user, so that the plurality of specifications are opened one by one. Thus, it is possible to easily and surely replace character strings in a plurality of specifications without the need for the replacement work. Further, since the design document using the data including the searched character string and the usage range of the specification are known in association with each other, the user can perform more detailed data replacement.

  Hereinafter, preferred embodiments of the present invention will be described with reference to the drawings. FIG. 1 is a diagram showing a schematic configuration of a database access system to which the present invention is applied. The database access system accesses the database 200 (hereinafter referred to as “DB”), registers data of description contents of the specification (hereinafter referred to as “design information data”), and takes in design information data. The information processing apparatus 100 includes an input device 300 such as a keyboard and a pointing device, and a display device 400 such as a CRT display and an LCD.

  The information processing apparatus 100 includes a DB access guidance screen display unit 101 that displays a DB access guidance screen on the display device 400 according to an instruction input from the input device 300, and an instruction via the DB access guidance screen. The design information data DB registration unit 102 that registers design information data described in the specification document (design document) 104 in the DB 200 and the design information data registered in the DB 200 in response to an instruction via the DB access guidance screen are displayed. And a design information data capturing unit 103 that captures and reflects the specification document (design document) 104.

  Furthermore, the information processing apparatus 100 displays a term conversion guidance screen display unit 105 that displays a term conversion guidance screen on the display device 400 according to an instruction input from the input device 300, and a search character string via the term conversion guidance screen. A character string search unit 106 that receives a designation and searches the design information data registered in the DB 200 for a search that includes the search character string, and a search result that displays the search result by the character string search unit 106 on the display device 400 A character string replacement unit 108 that receives designation of a replacement character string via the display unit 107 and the term conversion guide screen, replaces the search character string searched by the character string search unit 106 with the replacement character string, and a character string A search result display unit 109 that displays the result of replacement by the replacement unit 108 on the display device 400 is provided.

  In the present embodiment, the information processing apparatus 100 corresponds to the information processing apparatus and database access apparatus referred to in the present invention. In the illustrated example, the DB 200 is in the information processing apparatus 100. However, for example, the information processing apparatus 100 may access the DB 200 via a network.

  FIG. 2 shows an example of specifications. In the present embodiment, a specification document for designing a process control computer for controlling and managing a production line in a steelworks is taken as an example. As shown in FIG. 3, the specifications include “detailed function specification related”, “processing specification related”, “technical calculation related”, “CRT common specification related”, “form common specification related”, “ It is broadly divided into specification category names such as “Transmission common specification related”, “Alarm specification related”, “File specification related”, “Table specification related”, etc., and each specification is further divided into specification names. Has been. The specification shown in FIG. 2 is one specification belonging to the specification name “functional outline / prerequisite” in the specification category name “related to detailed functional specification”.

  In the specification shown in FIG. 2, there are large items “function overview” and “prerequisite”. In addition, the “Function Summary” has sub-items “Purpose”, “Summary”, “Target Equipment”, “Supplementary Materials”, and “Supplementary Explanation”, and “Preconditions” include “Equipment” and “Operation”. , A sub-item “special notes” is provided.

  Further, each specification includes a specification abbreviation name (for example, “function abbreviation”, “task module abbreviation”, “file abbreviation”, “table abbreviation”, etc.) defined according to each type and a specification. Abbreviations (for example, “A1A1”, “A1A2”, “B1B1”, etc.) are given, and specification abbreviations are written in the right header portion. In the specification shown in FIG. 2, the specification abbreviation name “Function abbreviation” and the specification abbreviation “A1A1” are given, and “A1A1” is written in the right header portion.

  Such a specification is created as a design document 104 by document creation software or spreadsheet software as shown in FIG. Here, the design document 104 is created as described in the sectioned and formatted as shown in FIG. For example, the specification shown in FIG. 3 (format name “function overview” of format numbers “BF01” belonging to the format classification “BF # format”).

  Hereinafter, processing operations in the database access system of this embodiment will be described in detail with reference to FIGS. FIG. 5 is a flowchart for explaining registration and fetching of design information data with respect to the DB 200, and FIG. 6 is a flowchart for explaining character string search / replacement. 7 to 13 are diagrams showing screens displayed on the display device 400 in each process.

  As shown in FIG. 7, for example, when a DB access menu display operation is performed in a state where specifications are created by spreadsheet software (step S <b> 501), the information processing apparatus 100 displays a DB access guidance screen on the display apparatus 400. DB access menu 700 is displayed (step S502).

  When the registration button 701 is pressed in the DB access menu 700 (step S503), the information processing apparatus 100 checks the specification (step S504). If there is no abnormality as a result of the specification check, the design information data is registered in the DB 200 (step S505), and the success or failure of registration is notified (steps S507 to S509). In this embodiment, the contents described in the specification, excluding graphics, are registered as design information data. When registering, the specification abbreviation ("A1A1" in the example of FIG. 2) is used as a key. On the other hand, if there is an abnormality such as, for example, a document that is not a registration target as a result of the specification check, that fact is notified (step S506), and registration in the DB 200 is not performed.

  When the capture button 702 is pressed in the DB access menu 700 (step S510), the information processing apparatus 100 captures design information data registered in the DB 200. The process will be described later.

  When the history display button 703 is pressed in the DB access menu 700 (step S517), the information processing apparatus 100 displays a registration history in the DB 200 (step S518), although not specifically illustrated.

  When the design information data of a plurality of specifications is registered in the DB 200 as described above, when the user wants to replace a certain character string used in the plurality of specifications with another character string, the user provides a term conversion guide. What is necessary is just to perform display operation of a screen. When there is an operation for displaying the term conversion guide screen (step S601), the information processing apparatus 100 displays the term conversion guide screen 800 on the display device 400 as shown in FIG. 8 (step S602).

  The term conversion guide screen 800 includes an EIC classification check box 801, a search character string input field 802, a replacement character string input field 803, a range specification input field 804, a search condition input field 805, and a search condition expression input. A column 806 is set.

  In the check box 801 for EIC classification, “Pro-con” is checked in this example. In the search character string input field 802, the character string to be searched is input. In this example, the character string “hot stove” is input. In this case, for example, if * is input between character strings (such as “hot stove * control”), an ambiguous search may be performed.

  Further, a narrow search can be performed by inputting the range of the specification to be searched in the input field 804 for specifying the range. This range designation input field 804 is composed of a combo box, and is divided into specifications classified as shown in FIG. 3, ie, “Detailed function specification related”, “Processing specification related”, “Technical calculation related” ”,“ CRT common specifications ”,“ form common specifications ”,“ transmission common specifications ”,“ alarm specifications ”,“ file specifications ”,“ table specifications ” In this example, “Detailed function specification related” is selected. Of course, it is also possible not to specify the range of specifications to be searched.

  Further, by further entering a search condition in the search condition input field 805 or the search condition expression input field 806, further refinement search can be performed. The search condition input field 805 includes a specification abbreviation name input field 805a composed of a combo box, a specification abbreviation name input field 805b composed of a text box, and an AND / OR input field 805c composed of a combo box. When a plurality of (up to 4) items are entered in the search condition input field 805, when the condition expression creation button 807 is pressed, for example, “(Function abbreviation = A1A1 OR Task module abbreviation LIKE A1A *) appears in the search condition expression input field 806. "Is displayed. In the search condition expression displayed in the input field 806, the user can arbitrarily insert a half-width bracket for the position, thereby changing the search condition expression. If the search condition clear button 808 is pressed, the search condition can be cleared. Of course, it is possible not to input a search condition or a search condition expression.

  As described above, the EIC classification check box 801, the search character string input field 802, the range specification input field 804, the search condition input field 805, and the search condition expression input field 806 are input as necessary. When the search button 809 is pressed in the state (step S603), the information processing apparatus 100 searches the design information data registered in the DB 200 for items including the character string “hot stove” based on these conditions. (Step S606). In this case, if the search character string, range, and search condition are not appropriate (step S604), the fact is notified and the search is not performed (step S605).

  When executing the search, the information processing apparatus 100 displays the search result on the search / replacement result display screen 900 on the term conversion guide screen 800 as shown in FIGS. 9 and 10 (step S607). FIG. 9 shows the search result when the specification category name “related to detailed function specification” is input in the input field 804 for specifying the range. FIG. 10 shows the specification category name “related to detailed function specification”. Further, a search result when a function abbreviation name “function abbreviation” and a function abbreviation “A1A1” are entered in the search condition input field 805.

  In the search / replacement result display screen 900, for each item number 901, a column 902 for whether or not to replace, a column 903 for data to be replaced, a column 904 for EIC classification, a column 905 for a specification name, a column 906 for a specification item name, A specification abbreviation column 907 is set, and design information data including the character string “hot stove” is displayed in the replacement target data column 903. In this case, only the searched character string “hot stove” is displayed differentiating from other character strings by changing the font or displaying it in red. Although only a part of the design information data appears in the replacement target data column 903, if the width of the column 903 is increased, all of the design information data can be viewed.

  The EIC section column 904 displays the EIC section selected in the EIC section check box 801 (in this example, “Pro-con”). When all the check boxes 801 for EIC classification are selected, the EIC classification corresponding to the design information data displayed in each replacement target data column 903 is displayed.

  The specification name column 905 shows the specification name, the specification item name column 906 shows the item name of the specification, and the specification abbreviation column 907 shows the specification abbreviation. It is displayed in association with the design information data displayed in the data column 903. For example, the item number (1) in FIG. 10 will be explained. Of the specifications specified by the specification abbreviation “A1A1” with the specification name “Summary of Functions / Prerequisites”, that is, among the specifications shown in FIG. This indicates that the search character string “hot stove” is included in the description of the small item “purpose” in the item “functional overview”.

  Here, for example, in the example shown in FIG. 10, when it is desired to replace the character string “hot stove” with the character string “HS”, “HS” is entered in the replacement character string input field 803 as shown in FIG. 11. Then, “1” is input to the replacement information column 902 for the design information data desired to be replaced, and nothing is input to the design information data not desired to be replaced.

  Thereafter, when the replace button 810 is pressed (step S608), the information processing apparatus 100 replaces the character string “hot stove” with “HS” for the design information data designated as the replacement target in the DB 200 (step S608). Step S611). In this case, if the replacement character string is not appropriate (step S609), the fact is notified and the search is not performed (step S610).

  When performing the replacement, the information processing apparatus 100 displays the replacement result on the search / replacement result display screen 900 as shown in FIG. 12 (step S612). That is, the design information data in which the character string “Hot Furnace” is replaced with the character string “HS” is displayed in the replacement target data field 903 in which “1” is input in the replacement presence / absence field 902. In this case, only the replaced character string “HS” is displayed differentiating from other character strings by changing the font or displaying it in blue.

  As described above, design information data of a plurality of specifications is registered in the DB 200, and the design information data of the specifications registered in the DB 200 is fetched in a state where substitution of character strings is executed as necessary. When it is desired to reflect in the specification document (design document) 104, as described above, the user may press the import button 702 in the DB access menu 700. In this case, a specification abbreviation (“A1A1” in the example of FIG. 2) that is a key of design information data to be imported is selected and input in the data import designation field 704.

  When the capture button 702 is pressed (step S510), the information processing apparatus 100 checks whether there is design information data to be captured (step S511). As a result of checking whether or not there is design information data to be fetched, if there is design information data to be fetched, the design information data is fetched from the DB 200 (step S512), and the success or failure of the fetch is notified (steps S514 to S516). FIG. 13 shows a state in which design information data in which the character string “hot stove” is replaced with the character string “HS” is taken in and reflected as described above. On the other hand, if there is no design information data to be fetched as a result of checking whether or not there is design information data to be fetched, that fact is notified (step S513), and no fetching from the DB 200 is performed.

  FIG. 14 is a block diagram showing an example of a computer system that can constitute the data access system described above. In the figure, reference numeral 1200 denotes a computer PC. The PC 1200 includes a CPU 1201, executes device control software stored in the ROM 1202 or the hard disk (HD) 1211, or supplied from the flexible disk drive (FD) 1212, and collects all devices connected to the system bus 1204. To control. Each functional unit of the present embodiment is configured by a program stored in the CPU 1201, ROM 1202, or hard disk (HD) 1211 of the PC 1200.

  A RAM 1203 functions as a main memory, work area, and the like for the CPU 1201. Reference numeral 1205 denotes a keyboard controller (KBC), which controls to input a signal input from the keyboard (KB) 1209 into the system main body. Reference numeral 1206 denotes a display controller (CRTC) which performs display control on the display device (CRT) 1210. A disk controller (DKC) 1207 is a hard disk (boot program (start program: a program that starts execution (operation) of personal computer hardware and software)), a plurality of applications, editing files, user files, a network management program, and the like. HD) 1211 and flexible disk (FD) 1212 are controlled.

  Reference numeral 1208 denotes a network interface card (NIC) that performs bidirectional data exchange with a network printer, other network devices, or other PCs via the LAN 1220.

(Other embodiments)
The functions of the above-described embodiments can also be realized by a computer executing a computer program. Further, means for supplying a computer program to a computer, for example, a computer-readable recording medium such as a CD-ROM recording such a program or a transmission medium such as the Internet for transmitting such a program is also applied as an embodiment of the present invention. be able to. A computer program product such as a computer-readable recording medium in which the above program is recorded can also be applied as an embodiment of the present invention. The above computer program, recording medium, transmission medium, and computer program product are included in the scope of the present invention. As the recording medium, for example, a flexible disk, a hard disk, an optical disk, a magneto-optical disk, a CD-ROM, a magnetic tape, a nonvolatile memory, a ROM, or the like can be used.

It is a figure showing a schematic structure of a database access system of an embodiment. It is a figure which shows an example of a specification document. It is a figure for demonstrating the kind of specification. It is a figure for demonstrating the example of formatting of a design document. It is a flowchart for demonstrating the processing operation (registration and taking in of design information data with respect to DB) in a database access system. It is a flowchart for demonstrating the processing operation (search / replacement of a character string) in a database access system. It is a figure which shows the screen where DB access menu was displayed. It is a figure which shows the screen on which the term conversion guidance screen was displayed. It is a figure which shows the state by which the search result was displayed on the search and replacement result display screen on a vocabulary conversion guidance screen. It is a figure which shows the state by which the search result was displayed on the search and replacement result display screen on a vocabulary conversion guidance screen. It is a figure which shows the state by which the substitution character string was input into the term conversion guidance screen. It is a figure which shows the state by which the replacement result was displayed on the search and replacement result display screen on a vocabulary conversion guidance screen. It is a figure which shows the screen where DB access menu was displayed. It is a block diagram which shows an example of the computer system which can comprise a data access system.

Explanation of symbols

DESCRIPTION OF SYMBOLS 100 Information processing apparatus 101 DB access guidance screen display part 102 Design information data DB registration part 103 Design information data taking-in part 104 Design document 105 Term conversion guidance screen display part 106 Character string search part 107 Search result display part 108 Character string replacement part 109 Replacement result display unit 200 Database 300 Input device 400 Display device

Claims (9)

An information processing apparatus capable of accessing a database in which data of description contents of a plurality of specifications are registered;
An input device connected to the information processing device;
A database access system comprising a display device connected to the information processing device,
The information processing apparatus
Search means for searching for data including a character string designated by the user from data registered in the database;
Display means for displaying data including the character string searched for by the search means on the display device;
A database access system comprising: replacement means for replacing the character string included in the data searched by the search means with a character string designated by a user. A database access device capable of accessing a database in which data of description contents of a plurality of specifications is registered,
Search means for searching for data including a character string designated by the user from data registered in the database;
Display means for displaying data including the character string searched by the search means on a display device;
A database access apparatus comprising: a replacement unit that replaces the character string included in the data searched by the search unit with a character string designated by a user.   3. The database according to claim 2, wherein when displaying the data including the character string searched by the search unit, the display unit displays information indicating which specification belongs to the data in association with each other. Access device.   4. The database access apparatus according to claim 3, wherein the display means further displays information indicating to which item of the specification the document belongs.   5. The display unit according to claim 2, wherein, when displaying the data including the character string searched by the search unit, the display unit displays the character string differently from other character strings. The database access device according to claim 1.   6. The database access apparatus according to claim 2, wherein a specification to be searched can be narrowed down when searching by the search means.   The database access apparatus according to any one of claims 2 to 6, characterized in that, in the replacement by the replacement means, data to be replaced among the data searched by the search means can be specified. A character string replacement method for replacing a character string included in the data with a character string specified by a user by an information processing apparatus capable of accessing a database in which data of description contents of a plurality of specifications is registered,
A procedure for the search means of the information processing device to search for data including a character string designated by the user from data registered in the database;
A procedure in which display means of the information processing device displays data including the character string searched by the search means on a display device;
A character string replacement method, wherein the replacement means of the information processing apparatus includes a procedure of replacing the character string included in the data searched by the search means with a character string designated by a user. A computer program executed on a computer capable of accessing a database in which data of description contents of a plurality of specifications is registered,
A search process for searching for data including a character string specified by the user from data registered in the database;
Display processing for displaying data including the character string searched by the search processing on a display device;
A computer program for causing the computer to execute a replacement process for replacing the character string included in the data searched by the search process with a character string designated by a user.

Images