JP4412951B2 - Database system, server, program, and recording medium - Google Patents

Description

  The present invention relates to a database system using a network, and more particularly to a batch update function for information acquired from a database.

  In recent years, when creating catalogs, with the spread of computers, product data to be put on catalogs has been used as a database. Collaborating with a database, catalog creation work is performed by desktop publishing (DTP) or the like, and the efficiency has been improved. For example, there are several database systems consisting of a database that stores product information, a server that manages database information, provides functions such as input / output, search, and browsing of database information, and a plurality of user terminal devices. (For example, Patent Document 1).

JP 2001-306377 A

  In a conventional database system, when a (product) information group on a database is updated at once, it is necessary to prepare an update text file (a text file describing a search condition and an updated value). In addition, even when the updated value is in accordance with certain rules (partial character string replacement, conversion of numerical values using formulas, etc.), it was necessary to specify the updated value specifically. .

  FIG. 14 shows an update text file 1400. As shown in FIG. 14, for example, when updating the value of the item “price” of the product information whose item “model number” starts with “ABC” to be updated 1.05 times, the item “model number” is set as the search condition. The item 1401 and the item “price” are set as the update target items 1402, and the update text file 1400 describing the search condition value 1403 and the updated value 1404 (original value × 1.05) is prepared. Do. There is a problem that the more product information corresponding to the search condition, the more lines in the update text file 1400, and the preparation work takes time and labor, which is not efficient.

  The present invention has been made in view of the above points, and an object of the present invention is to provide a database system or the like that enables batch update based on a specified rule for the values of items in an information group extracted from a database. To do.

In order to achieve the above-described object, the first invention is a system in which a terminal device of a registered user and a server are connected via a network, and the server stores a plurality of information from items. In response to a request from the terminal device , a database, main screen transmission means for sending data of a main screen for searching and browsing the database to the terminal device, and designated from the terminal device on the main screen In accordance with a search condition , search result transmission means for sending a search result , which is information searched and extracted from the database, to the terminal device, and an item to be updated and an update content are specified in response to a request from the terminal device Update content designation screen transmission means for sending update content designation screen data to the terminal device, and the terminal device in the update content designation screen Based on the items and the update content of the update object designated from the search the value of the results of the items collectively updating, and updating means for holding in the database, the update result is collectively updated information by said updating means Update result transmission means for sending the search result to the terminal device , and the terminal device includes search result display means for displaying the search result sent by the search result transmission means on the main screen, and the update result transmission means. An update result display means for displaying an update result to be sent on the main screen .

The update content designation screen includes a first designation unit that designates the item to be updated , value substitution that substitutes the value of the item to be updated with another value, and the beginning of the value of the item to be updated. Add the beginning to add a string, add the end to the end of the value of the item to be updated, and replace the string included in the value of the item to be updated with the replacement string And a value replacement of an expression for converting the value of the item to be updated by an expression, and a second specifying unit for specifying the update content.
The main screen includes a search unit for specifying a search condition for the database and instructing the server to execute a search, and an information list unit for displaying the search result and the update result.

  In the first invention, the server has a database for accumulating a plurality of items of information, and collects the values of the items of the information group acquired from the database based on a predetermined rule according to designation from the terminal device. Update and keep in the database.

A second invention is a server connected via a network to a registered user's terminal device, a database for storing a plurality of information from items, and a search for the database in response to a request from the terminal device A main screen transmission means for sending main screen data for browsing to the terminal device, and a search that is information retrieved and extracted from the database in accordance with a search condition designated by the terminal device on the main screen Search result sending means for sending a result to the terminal device, and update content designation for sending update content designation screen data for designating items to be updated and update content to the terminal device in response to a request from the terminal device Based on the screen transmission means, the item to be updated specified from the terminal device on the update content specification screen, and the update content Te, the search the value of the results of the items collectively updating comprises updating means for holding in the database, and a update result transmitting means for transmitting to the terminal device the update result is collectively updated information by said updating means It is a server characterized by this.

The “item” is information that corresponds to the field in the database record.
“Rule” is an update function according to the regularity of the updated value at the time of batch update. Rules include a value replacement that replaces an item value with another value that you specify, a prefix that adds a specified string to the beginning of an item value, and an append that adds a specified string to the end of an item value There are character string replacement that replaces a specified character string included in an item value with a specified replacement character string, value replacement of an expression that converts an item value by a specified mathematical expression, and the like.

The third invention is a program for causing a computer to function as the server of the second invention.
4th invention is the recording medium which recorded the program which makes a computer function as a server of 2nd invention.

  The above-mentioned program may be held and distributed on a recording medium such as a CD-ROM, or the program can be transmitted and received via a communication line.

  The present invention can provide a database system or the like that enables batch updating based on a specified rule for the values of information group items that satisfy a condition.

  Hereinafter, preferred embodiments of a database system and the like according to the present invention will be described in detail with reference to the accompanying drawings. In the following description and the accompanying drawings, the same reference numerals are given to components having substantially the same functional configuration, and redundant description is omitted.

  FIG. 1 is a diagram showing a schematic configuration of a database system 100 according to the present embodiment of the present invention. As shown in FIG. 1, the database system 100 is configured by connecting a server 101, a terminal device 103, and the like via a network 109. The database system 100 is a configuration diagram in the case where the database system 100 is realized by using WWW (World Wide Web) technology.

  The network 109 is a network such as the Internet, a local area network (LAN), or an in-house LAN, and may be wired or wireless.

  The server 101 is a server computer or the like, and includes a WWW server 110, a database operation unit 111, a database server management unit 112, a database management unit 113, and the like. The database operation unit 111 is called from the WWW server 110, and searches the product information database 301, refers to the information content, browses, and the like. The database server management unit 112 performs system operation and management such as registration of the user 104 and various settings. The database management means 113 is a database engine or the like, and performs corresponding processing for various requests such as search, reference, registration, and deletion to the database.

The user 104 is a user who uses the product information database 301 and is registered in the server 101 in advance, and includes the terminal device 103. The terminal device 103 is equipped with a WWW browser 120. The terminal device 103 accesses the WWW server 110 of the server 101 via the WWW browser 120, transmits an operation request, input information, and the like of the product information database 301, and receives information acquired from the product information database 301. The terminal device 103 is a personal computer, a personal digital assistant, or the like.
The server administrator 105 is an administrator who operates and manages the database system 100 and has a terminal device 103. The terminal device 103 accesses the WWW server 110 of the server 101 via the WWW browser 120, activates the database server management unit 112, transmits requests for registration, various settings, etc. of the user 104, operation / management information, etc. Receive.

  Next, the hardware configuration of the server 101 will be described. FIG. 2 is a hardware configuration diagram of the server 101.

  2, the server 101 includes a control unit 201, a storage device 202 (hard disk), a media input / output unit 203 (CD-ROM), a communication control unit 204 (communication control device, communication port, etc.), an input unit 205. (Keyboard, mouse, etc.), printing unit 206 (printer), display unit 207 (display) and the like are connected via a bus 209.

  The control unit 201 includes a CPU, a ROM, a RAM, and the like, and drives and controls each device connected via the bus 209 in accordance with a program stored in the storage device 202 as a large-capacity storage medium.

  The storage device 202 stores a control program 311 that drives and controls each component, an application program 312, a product information database 301, and the like.

  Each of these program codes is read by the control unit 201 as necessary, transferred to the RAM, read by the CPU, and executed as various means.

  The media input / output unit 203 (CD-ROM drive device) is used to upgrade the program and information stored in the ROM of the control unit 201 and the storage device 202, and make settings such as device settings.

  The communication control unit 204 is a communication control device, a communication port, and the like, and performs communication control between the server 101 and the terminal device 103 via the network 109.

The input unit 205 is a keyboard, a mouse, and the like, and performs operation guidance, various processes, and operations displayed on the display unit 207 (display).
A printing unit 206 is a printer and performs print output processing.

  Next, database file-related file arrangement in the storage device 202 will be described. FIG. 3 shows a file arrangement related to the database system in the storage device 202. As shown in FIG. 3, the storage device 202 stores a product information database 301, a control program 311, an application program 312 and the like.

  The product information database 301 stores product information and the like. Note that a plurality of product information databases 301 managed by the server 101 may exist as necessary.

The control program 311 is a program that drives and controls each component of the server 101.
The application program 312 is an executable program, and corresponds to the WWW server 110, the database operation unit 111, the database server management unit 112, the database management unit 113, and the like.

  Next, the hardware configuration of the terminal device 103 will be described. FIG. 4 is a hardware configuration diagram of the terminal device 103.

  As shown in FIG. 4, the terminal device 103 includes a control unit 401, a storage device 402 (hard disk, external memory), a media input / output unit 403 (CD-ROM), a communication control unit 404 (communication control device, communication port, etc.). An input unit 405 (keyboard, mouse, etc.), a printing unit 406 (printer), a display unit 407 (display), etc. are connected via a bus 409.

  The control unit 401 includes a CPU, a ROM, a RAM, and the like, and drives and controls each device connected via the bus 409 according to a program stored in the storage device 402 as a large-capacity storage medium.

  The storage device 402 (hard disk) stores a program for driving and controlling each component, an application program such as the WWW browser 120, and the like.

  Each of these program codes is read by the control unit 401 as necessary, transferred to the RAM, read by the CPU, and executed as various means.

  The media input / output unit 403 (CD-ROM drive device) is used to upgrade the program and information stored in the ROM of the control unit 401 and the storage device 402, and make settings such as device settings.

  The communication control unit 404 is a communication control device, a communication port, and the like, and performs communication control between the terminal device 103 and the server 101 via the network 109.

The input unit 405 is a keyboard, a mouse, and the like, and performs operation guidance, various processes, and operations displayed on the display unit 407 (display).
A printing unit 406 is a printer and performs print output processing.

  Next, a flow of batch update processing for the retrieved information group in the database system 100 will be described. 5 and 6 are flowcharts showing the processing procedure of the database system 100. FIG.

  As shown in FIG. 5, the control unit 401 of the terminal device 103 accesses the server 101 and logs in (step 501).

  For example, the user 104 accesses the server 101 by specifying the URL of the server 101 from the WWW browser 120 of the terminal device 103, and the control unit 201 of the server 101 sends the login screen data to the terminal device 103 via the WWW server 110. Send. The control unit 401 displays the received login screen (not shown) via the WWW browser 120 and transmits the input user ID, password, and the like to the server 101.

  The control unit 201 of the server 101 receives a user ID, a password, and the like via the WWW server 110 and performs user authentication (step 502). Thereafter, data transmission / reception between the terminal device 103 and the server 101 is performed via the WWW browser 120 and the WWW server 110.

  When the user authentication is correctly performed, the control unit 201 transmits main screen data on which the user 104 searches and browses the product information database 301 to the terminal device 103 (step 503).

  The control unit 401 of the terminal device 103 displays the received main screen (step 504).

The user 104 sets an arbitrary search condition on the search screen 710 on the main screen and clicks a search execution button 715 in order to extract a product information group corresponding to the arbitrary condition (step 505).
The control unit 401 transmits a search request together with the set search condition to the server 101 (step 506).

The control unit 201 of the server 101 searches and extracts a product information group corresponding to the received search condition 714 from the product information database 301 (step 507), and transmits search result data (step 508).
The control unit 401 of the terminal device 103 displays the received search result data on the information list 701 (step 509).

FIG. 7 shows a main screen 700 that displays the product information before the update after the information search. As shown in FIG. 7, the main screen 700 displays an information list 701 for displaying product information 702 acquired from the product information database 301, a search screen 710, and various control buttons and a control menu. The search screen 710 includes a search condition 714 including items 711, values 712, comparison instructions 713, a search execution button 715, a condition addition button, a condition deletion button, and the like.
For example, when a search condition 714 in which the value 712 of the item 711 “model number” starts with “ABC” (comparison instruction 713) is set as a search condition and a search request is made, the information list 701 corresponds to the search condition 714. The product information 702 whose “model number” starts with “ABC” is displayed.

As shown in FIG. 6, the user 104 clicks the edit menu button 705 or the like and performs a batch update on the searched product information group, and selects “update” from the displayed edit menu (step 601). ).
The control unit 401 makes an update content designation request (step 602).

  The control unit 201 of the server 101 transmits update content designation screen data (step 603).

The control unit 401 displays the received update content designation screen 800 (step 604).
FIG. 8 shows an update content designation screen 800. As shown in FIG. 8, the update content designation screen 800 includes items 711 to be updated, update content 801, a completion button 809, and the like. An item 711 designates an item to be updated. The update content 801 includes value replacement 811, head addition 812, tail addition 813, character string replacement 814, expression value replacement 815, and the like, and is updated collectively based on these rules (functions).

The value replacement 811 replaces the value of the designated item 711 with another value 712.
In the head addition 812, a character string 820 is added to the head of the value of the designated item 711.
Add end 813 adds a character string 820 to the end of the value of the specified item 711.
The character string replacement 814 replaces the character string 820 included in the value of the designated item 711 with the replacement character string 821.
The expression value replacement 815 converts the value of the designated item 711 by the expression 822. Expression 822 is an expression, a function, or the like.

The user 104 selects and designates the update content 801 for the product information group corresponding to the condition that is the search result, and clicks the completion button 809 (step 605).
For example, as shown in FIG. 8, the value 712 of the item 711 “price” is set to the price including the consumption tax (1...) With respect to the product information 702 in which the value 712 of the item 711 “model number” previously searched starts with “ABC”. In the case of updating to (05 times), “replace value of formula” 815 is selected as the update content 801, and “price” * 1.05 is set as formula 822.

  The control unit 401 transmits the designated update content 801 and an update request (step 606).

The control unit 201 of the server 101 updates the product information group corresponding to the condition based on the rule according to the received update content 801, and stores the updated product information group in the product information database 301 (step 607). The control unit 201 transmits update result data (step 608).
The control unit 401 of the terminal device 103 displays the received update result data on the information list 701 (step 609).

  FIG. 9 shows a main screen 700 that displays the updated product information. As shown in FIG. 9, for example, for the product information 702 in which the value 712 of the item 711 “model number” starts with “ABC”, the value 712 of the item 711 “price” is set to a price including consumption tax (1.05 times). When updated, the information list 701 includes an item 711 “model number” value 712 that starts with “ABC”. The item 711 “price” of the product information 702 has a value updated 1.05 times (for example, “price”). “100,000”-> “105000”) is displayed.

  Next, the batch update of the product information group based on the update contents 801- “value replacement” 811 will be described. FIG. 10 shows the batch update of the product information group by the update content 801-“value replacement” 811.

  As illustrated in FIG. 10, for example, when the item 711 “product name” of the item information 711 “model number” 712 starts with “ABC” is replaced with “DYNAGALAXY”, the search result extracted from the item information database 301 The item 711 “model number” value 712 is a product information group (before update) 1001 including one or a plurality of product information 702 starting with “ABC”. ”811, the value 712“ DYNAGALAXY ”is set, and the update is performed, the product information group (after update) 1002 is replaced with one or a plurality of items in which the value 712 of the item 711“ product name ”is replaced with“ DYNAGALAXY ” It consists of product information 702 (for example, “product name” “dynagalaxy”-> “DYNAGALAXY”, etc.). The control unit 201 of the server 101 holds a product information group (after update) 1002 in the product information database 301 of the storage device 202.

  Next, the batch update of the merchandise information group by the update content 801- “add head” 812 will be described. FIG. 11 shows the batch update of the product information group by the update content 801-“add head” 812.

  As shown in FIG. 11, for example, when “super” is added to the beginning of the value of the item 711 “product name” of the product information in which the value 712 of the item 711 “model number” starts with “ABC”, from the product information database 301. For the product information group (before update) 1001 including one or a plurality of product information 702 in which the value 712 of the item 711 “model number” as the extracted search result starts with “ABC”, the update content 801 is displayed on the update content designation screen 800. When “add top” 812 is selected, the character string 820 “super” is set, and updating is performed, the product information group (after update) 1002 has “super” at the head of the value 712 of the item 711 “product name”. (For example, "product name" "dynagalaxy V.2"-> "super dynamicaly V.2"). "Etc.). The control unit 201 of the server 101 holds a product information group (after update) 1002 in the product information database 301 of the storage device 202.

  Next, the batch update of the merchandise information group by the update content 801- “add end” 813 will be described. FIG. 12 shows the batch update of the product information group by the update content 801-"add end" 813.

  As shown in FIG. 12, for example, when “V.4” is added to the end of the value of the item 711 “product name” of the product information in which the value 712 of the item 711 “model number” starts with “ABC”, the product information database The item 711 “model number” value 712 that is the search result extracted from 301 is updated on the update content designation screen 800 for a product information group (before update) 1001 including one or more product information 702 starting with “ABC”. When “add end” 813 is selected as the content 801, the character string 820 “V.4” is set, and updating is performed, the product information group (after update) 1002 is the end of the value 712 of the item 711 “product name”. 1 or a plurality of product information 702 added to “V.4” (for example, “product name” “dynagalaxy”-> “dynagalaxy V.4”, etc.). The control unit 201 of the server 101 holds a product information group (after update) 1002 in the product information database 301 of the storage device 202.

  Next, the batch update of the product information group by the update content 801- “character string replacement” 814 will be described. FIG. 13 shows the batch update of the product information group by the update content 801-“character string replacement” 814.

  As shown in FIG. 13, for example, when the character string “dynagalaxy” included in the item 711 “product name” of the product information in which the value 712 of the item 711 “model number” starts with “ABC” is replaced with “DYNAGALAXY” An update content designation screen 800 for a product information group (before update) 1001 including one or a plurality of product information 702 in which the value 712 of the item 711 “model number”, which is the search result extracted from the information database 301, starts with “ABC”. In the update content 801, “character string replacement” 814 is selected, the character string 820 “dynagalaxy” and the replacement character string 821 “DYNAGALAXY” are set, and update is performed. The character string “dynagalaxy” included in 711 “product name” is replaced with “DYNAGALAXY” 1 The other consists of a plurality of product information 702 (for example, "product name" "dynagalaxy V.1" -> "DYNAGALAXY V.1", etc.). The control unit 201 of the server 101 holds a product information group (after update) 1002 in the product information database 301 of the storage device 202.

  As described above, according to the embodiment of the present invention, the server 101 selects items for the items of the product information group extracted from the product information database 301 based on the conditions specified by the terminal device 103. A value replacement 811 for replacing the value of 711 with another value 712, a head addition 812 for adding a character string 820 to the head of the value of the item 711, a tail addition 813 for adding a character string 820 to the end of the value of the item 711, an item The product information database is updated collectively based on rules such as a character string replacement 814 that replaces the character string 820 included in the value 711 with the replacement character string 821, and a value replacement 815 of an expression that converts the value of the item 711 by the expression 822. 301.

  As a result, it is possible to update the searched product information group without preparing the update text file as in the past, and when the updated value is in accordance with a certain rule, Updates can be made by simply specifying rules, and labor savings in preparation work for batch updates can be achieved.

  In the present embodiment, the product information database 301 that stores product information and the like is used as the database, but the present invention is not limited to product information and the like.

  In this embodiment, the WWW technology is used. However, the terminal device 103 can be realized without using the WWW technology by providing a dedicated user program.

  Note that the program for performing the processing shown in FIGS. 5 and 6 may be distributed on a recording medium such as a CD-ROM, or the program may be transmitted and received via a communication line.

  The preferred embodiments of the database system and the like according to the present invention have been described above with reference to the accompanying drawings, but the present invention is not limited to such examples. It will be apparent to those skilled in the art that various changes or modifications can be conceived within the scope of the technical idea disclosed in the present application, and these are naturally within the technical scope of the present invention. Understood.

The figure which shows schematic structure of the database system 100 which concerns on this Embodiment. Hardware configuration diagram of server 101 The figure which shows the database system related file in the memory | storage device 202 Hardware configuration diagram of the terminal device 103 The flowchart which shows the process sequence of the batch update process with respect to the information group which the database system 100 searched. The flowchart which shows the process sequence of the batch update process with respect to the information group which the database system 100 searched. The figure which shows the main screen 700 which displays the merchandise information before an update after an information search. The figure which shows the update content designation | designated screen 800 The figure which shows the main screen 700 which displays the merchandise information after an update Update contents 801-diagram showing batch update of product information group by “value replacement” 811 Update contents 801-diagram showing batch update of product information group by "add head" 812 Update contents 801-diagram showing batch update of product information group by “add end” 813 Update contents 801-diagram showing batch update of product information group by “character string replacement” 814 The figure which shows the text file 1400 for update (conventional example)

Explanation of symbols

DESCRIPTION OF SYMBOLS 100 ......... Database system 101 ......... Server 103 ......... Terminal device 104 ......... User 105 ......... Server administrator 109 ......... Network 111 ......... Database operation means 112 ......... Database server management means 113 ......... Database management means 201, 401 ......... Control unit 202, 402 ......... Storage device 301 ......... Product information database 702 ......... Product information 711 ......... Items

Claims (8)

A system in which a registered user terminal device and a server are connected via a network,
The server
A database that accumulates multiple information from items;
In response to a request from the terminal device, a main screen transmission means for sending data of a main screen for searching and browsing the database to the terminal device;
Search result transmission means for sending a search result , which is information searched and extracted from the database, to the terminal device according to a search condition specified from the terminal device on the main screen ,
In response to a request from the terminal device, an update content designation screen transmission means for sending data of an update content designation screen for designating items to be updated and update content to the terminal device;
Updating means for collectively updating values of the search result items based on the update target items and the update details designated from the terminal device on the update content designation screen ;
Update result transmission means for sending an update result , which is information collectively updated by the update means, to the terminal device;
Comprising
The terminal device
Search result display means for displaying the search results sent by the search result sending means on the main screen;
Update result display means for displaying the update result sent by the update result sending means on the main screen;
A database system comprising: The update content designation screen includes a first designation unit that designates the item to be updated , value substitution that substitutes the value of the item to be updated with another value, and the beginning of the value of the item to be updated. Add the beginning to add a string, add the end to the end of the value of the item to be updated, and replace the string included in the value of the item to be updated with the replacement string And a second designation unit that designates the update content, comprising: a value replacement of an expression that converts the value of the item to be updated by an expression. Database system.   The main screen includes a search unit for specifying a search condition for the database and instructing the server to execute a search, and an information list unit for displaying the search result and the update result. The database system according to claim 1 or 2, characterized by the above-mentioned. A server connected to a registered user's terminal device via a network,
A database that accumulates multiple information from items;
In response to a request from the terminal device, a main screen transmission means for sending data of a main screen for searching and browsing the database to the terminal device;
Search result transmission means for sending a search result , which is information searched and extracted from the database, to the terminal device according to a search condition specified from the terminal device on the main screen ,
In response to a request from the terminal device, an update content designation screen transmission means for sending data of an update content designation screen for designating items to be updated and update content to the terminal device;
Updating means for collectively updating values of the search result items based on the update target items and the update details designated from the terminal device on the update content designation screen ;
Update result transmission means for sending an update result , which is information collectively updated by the update means, to the terminal device;
A server comprising: The update content designation screen includes a first designation unit that designates the item to be updated , value substitution that substitutes the value of the item to be updated with another value, and the beginning of the value of the item to be updated. Add the beginning to add a string, add the end to the end of the value of the item to be updated, and replace the string included in the value of the item to be updated with the replacement string And a second designation unit for designating the update content, comprising: a value replacement of an expression for converting the value of the item to be updated by an expression. server.   The main screen includes a search unit for specifying a search condition for the database and instructing the server to execute a search, and an information list unit for displaying the search result and the update result. The server according to claim 4 or 5, characterized in that: A program that causes a computer to function as the server according to any one of claims 4 to 6 . A recording medium on which a program for causing a computer to function as the server according to any one of claims 4 to 6 is recorded.

Images