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

Abstract

<P>PROBLEM TO BE SOLVED: To provide a database system allowing efficient maintenance work of related information such as material information related to prescribed information such as commodity information. <P>SOLUTION: In this database system 100, a server 101 and at least one terminal device 103 are connected via a network 109. The server 101 has a database management means 111 managing a commodity database 301, an update detection means 114, and a specific value update means 115. The database 301 manages a specific value of a specific item of the commodity information as a specific value of a specific item of the material information. When the update detection means 114 detects association addition and deletion of the commodity information and the material information, deletion of the commodity information, or a change of the specific value of the specific item of the commodity information, the specific value update means 115 updates the specific value of the specific item of the corresponding material information. <P>COPYRIGHT: (C)2008,JPO&INPIT

Description

  The present invention relates to a database system using a network. Specifically, the present invention relates to a database system that manages specific values of specific items for search.

  In recent years, when creating catalogs, with the spread of computers, product data placed in catalogs is used in 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 is a database system including a database that stores product information, a server that manages database information, and provides functions such as input / output, search, and browsing of database information, and a plurality of user terminal devices (for example, [See Patent Document 1].

  Further, there is a product database configured by associating material information such as image data with product information such as text data.

JP 2001-306377 A

However, in the above product database, when performing maintenance on the material information of the target product, it is necessary to search from the product information side to trace the target material information, and the maintenance work of the material information is inefficient. There is a problem.
Also, by managing the same specific value in both product information and material information, it is possible to search for material information of the target product using the same specific value as a key. When the association, the deletion of association, the change of the specific value in the product information, the deletion of the product information, etc. occur, the specific value in the material information needs to be updated separately.

  The present invention has been made in view of the above problems, and provides a database system capable of efficiently performing maintenance work on related information such as material information related to predetermined information such as product information. For the purpose.

  In order to achieve the above-mentioned object, the first invention is characterized in that at least one terminal device and a database for providing predetermined information and related information to the terminal device are provided via a network. A database system to be connected, wherein the database manages a specific value of a specific item of the predetermined information as a specific value of the specific item of the related information, and the server detects an update for detecting a predetermined update in the database A database system comprising: a detection unit; and a specific value update unit that updates a specific value of the related information when the update detection unit detects a predetermined update in the database.

  The server includes a database related to the predetermined information and related information, and the database manages a specific value of a specific item of the predetermined information as a specific value of the specific item of the related information. When the server detects a predetermined update in the database, the server updates the specific value of the related information.

  The database is, for example, a product database. The predetermined information is, for example, product information such as spec data. The related information is information related to the predetermined information, for example, material information such as image data. The predetermined update in the database includes addition or deletion of association between the predetermined information and related information, deletion of the predetermined information, change of a specific value of the predetermined information, and the like.

  In the database system of the first invention, even when the database manages the specific value of the specific item of the predetermined information as the specific value of the specific item of the related information, the specific value of the related information is automatically updated with the update of the database. Therefore, it is not necessary to perform work related to updating the specific value of the related information. Moreover, by managing the specific value of the specific item of the predetermined information as the specific value of the specific item of the related information, when searching or maintaining the related information, the related information can be directly searched or maintained without tracing from the predetermined information. As a result, maintenance work of related information can be performed efficiently.

  A second invention is a server that is connected to at least one terminal device via a network, includes a database relating to predetermined information and related information, and provides the predetermined information and the related information to the terminal device, wherein the database Manages the specific value of the specific item of the predetermined information as the specific value of the specific item of the related information and detects a predetermined update in the database, and the update detection unit detects the predetermined update in the database. And a specific value updating means for updating the specific value of the related information when it is detected.

The third invention is a program for causing a computer to function as the server of the second invention.
A fourth invention is a computer-readable recording medium on which a program for causing a computer to function as the server of the second invention is recorded.
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.

  According to the present invention, it is possible to provide a database system capable of efficiently performing maintenance work of related information such as material information related to predetermined information such as product information.

  Hereinafter, a preferred embodiment of a database system 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 will be omitted.

(1. Database system configuration)
First, the configuration of the database system 100 will be described with reference to FIG.
FIG. 1 is a configuration diagram of the database system 100.
The database system 100 is configured by connecting a server 101 and a plurality of client terminals 103 via a network 109.

The server 101 is a server computer or the like, and includes a WEB server 110, a database management unit 111, an update detection unit 114, and a specific value update unit 115.
The database management unit 111 is a database engine. In response to a request from the client terminal 103, the database management unit 111 performs processing for various requests such as search, reference, registration, and deletion of the product database 301.
The update detection unit 114 detects an update of the product database 301. The update of the detection target is addition and deletion of the association between the product information and the material information, the deletion of the product information, and the change of the specific value of the product information.
The specific value update unit 115 updates the specific value of the material information based on the detection result of the update detection unit 114.
The details of the update detection unit 114 and the specific value update unit 115 will be described later.

The user 104 is a user registered in advance in the server 101 in order to use the product database 301, and includes the terminal device 103.
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 transmits an operation request, input information, and the like of the product database 301 and receives information acquired from the product database 301. The terminal device 103 is a personal computer, a personal digital assistant PDA (Personal Digital Assistant), or the like.

  The network 109 is a network such as the Internet or a LAN (Local Area Network), and may be wired or wireless.

  The database system 100 is realized using WWW (World Wide Web) technology. The server 101 includes a WEB server 110, and the client terminal 103 of the user 104 includes a WEB browser 120. The server 101 and the client terminal 103 of the user 104 transmit and receive data via the WEB server 110 and the WEB browser 120, respectively. The terminal device 103 of the server administrator 105 can directly access the server 101 without going through the WEB server 110 and the WEB browser 120.

(2. Server 101)
(2-1. Hardware configuration)
Next, the hardware configuration of the server 101 will be described with reference to FIG.
FIG. 2 is a hardware configuration diagram of the server 101.

  The server 101 is configured by connecting a control unit 201, a storage unit 202, a media input / output unit 203, a communication control unit 204, an input unit 205, a display unit 206, and a printing unit 207 via a system bus 209.

  The control unit 201 includes a CPU (Central Processing Unit), a ROM (Read Only Memory), a RAM (Random Access Memory), and the like.

The CPU calls a program stored in the storage unit 202, ROM, recording medium or the like to a work memory area on the RAM, executes it, controls the drive of each device connected via the system bus 209, and is performed by the server 101. Implement various database management processes.
The ROM is a non-volatile memory and permanently holds a computer boot program, a program such as BIOS, data, and the like.
The RAM is a volatile memory, and temporarily stores a program, data, and the like loaded from the storage unit 202, ROM, recording medium, and the like, and includes a work area used by the control unit 201 for performing various processes.

The storage unit 202 is an HDD (hard disk drive), and stores a program executed by the control unit 201, data necessary for program execution, an OS (operating system), and the like. As for programs, a control program 391 corresponding to an OS (operating system), an application program 392 corresponding to various database management processes performed by the server 101 to which the computer is applied, and the like are stored.
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 (drive device) performs data input / output, for example, floppy disk drive, PD drive, CD drive (-ROM, -R, -RW, etc.), DVD drive (-ROM, -R, etc.) -RW etc.) and media input / output devices such as MO drives.

  The communication control unit 204 includes a communication control device, a communication port, and the like, and is a communication interface that mediates communication between the server 101 and the network 109. Communication control between the server 101 and the client terminal 103 is performed via the network 109. I do.

The input unit 205 inputs data and includes, for example, a keyboard, a pointing device such as a mouse, and an input device such as a numeric keypad.
An operation instruction, an operation instruction, data input, and the like can be performed on the server 101 via the input unit 205.

The display unit 206 includes a display device such as a CRT monitor and a liquid crystal panel, and a logic circuit (such as a video adapter) for realizing a video function of the computer in cooperation with the display device.
A printing unit 207 is a printer and performs print output processing.
The system bus 209 is a path that mediates transmission / reception of control signals, data signals, and the like between the devices.

(2-2. Information held by the storage unit 202)
Next, information stored in the storage unit 202 of the server 101 will be described with reference to FIG.
FIG. 3 is a diagram illustrating information stored in the storage unit 202.

The storage unit 202 stores a plurality of product databases 301, a control program 391, and an application program 392.
The control program 391 is a program that drives and controls each component of the server 101, and corresponds to an OS (operating system).
The application program 392 is an executable program corresponding to the WEB server 110, the data management unit 111, the update detection unit 114, and the specific value update unit 115 included in the server 101.

(2-3. Product database 301)
Next, the data structure of the product database 301 will be described with reference to FIG.
FIG. 4 is a diagram illustrating a data structure of the product database 301.

  The product database 301 includes product information 311, material information 312 and a correspondence table 313. Note that a plurality of product databases 301 managed by the server 101 may exist as necessary.

The product information 311 is character information such as product spec data. The product information 311 holds the product information item 314 and the value 315 in association with each other.
The material information 312 is information related to a product such as product image data 321. The material information 312 holds a material information item 316 and a value 317 in association with each other. In the value 317, the reference destination of the image data 321 is also recorded.
The correspondence table 313 is a table that associates the product information 311 with the material information 312. The correspondence table 313 holds product information ID 318 and material information ID 319 in association with each other.
The data configuration of the product database 301 is not limited to this configuration.

  The specific item 331 is a specific item managed by the product information 311. The specific value 332 is a value of the specific item 331. The specific item 333 is a specific item managed by the material information 312. The specific value 334 is the value of the specific item 333. The specific item 331 and the specific item 333 are unique items for each product such as a product code, for example.

  The specific value 332 of the specific item 331 of the product information 311 is also managed in the specific value 334 of the specific item 333 of the material information 312. That is, the same specific value is recorded in the specific value 332 of the product information 311 and the specific value 334 of the material information 312 related to the product information 311. For example, the product information 311 holds the specific value 332 “a1” of the specific item 331 “A”, and the material information 312 holds the specific value 334 “a1” of the specific item 333 “B”.

(3. Terminal device 103)
(3-1. Hardware configuration)
Next, the hardware configuration of the terminal device 103 will be described with reference to FIG.
FIG. 5 is a hardware configuration diagram of the terminal device 103.

The terminal device 103 is connected to a control unit 401, a storage unit 402, a communication control unit 403, a media input / output unit 404, an input unit 405, a display unit 406, a printing unit 407, and the like via a system bus 409.
The hardware configuration of the terminal device 103 is the same as that of the server 101 described above with reference to FIG.

(4. Operation)
Next, the operation of the database system 100 will be described with reference to FIGS.

(4-1. Update of specific value 334 of material information 312)
FIG. 6 is a flowchart showing update detection processing and specific value update processing in the database system 100.

The control unit 201 of the server 101 detects an update of the database 301 (step 601). Update detection targets of the database 301 in the processing of step 601 are addition and deletion of association between the product information 311 and the material information 312, deletion of the product information 311, and change of the specific value 332 of the product information 311.
When the update of the database 301 is detected (YES in step 601), the control unit 201 of the server 101 refers to the correspondence table 313 and extracts material information 312 that manages the same specific value as the product information 311 (step 602). ). The control unit 201 of the server 101 updates the specific value 334 of the material information 312 (step 603).

  FIG. 7 is a diagram illustrating specific contents of the update detection process and the specific value update process. FIG. 7 shows the detected update content and the specific value 334 of the material information 312 before and after the update.

  When the detected update content is addition of association (when the record of the correspondence table 313 is added), for example, the server 101 sets the specific value 334 “-(null)” of the specific item 333 “B” of the material information 312. The value is updated to “a1”, and is set to the same specific value as the specific value 332 “a1” of the specific item 331 “A” of the product information 311.

  When the detected update content is deletion of association (when the record of the correspondence table 313 is deleted), for example, the server 101 sets the specific value 334 “a1” of the specific item 333 “B” of the material information 312 to “-( null) ”.

  When the detected update content is product information deletion (when product information 311 is deleted and a record in the correspondence table 313 is deleted), for example, the server 101 specifies a specific value of the specific item 333 “B” of the material information 312. 334 “a1” is updated to “− (null)”.

  When the detected update content is a change of the specific value 332 of the specific item 331 of the product information 311 (when the specific value 332 is changed from “a1” to “a2”), for example, the server 101 stores the material information 312. The specific value 334 “a1” of the specific item 333 “B” is updated to “a2” to be the same specific value as the specific value 332 “a2” of the specific item 331 “A” of the product information 311.

(4-2. Search processing of material information 312)
FIG. 8 is a flowchart showing processes from the login process to the main screen display process in the database system 100.
FIG. 9 is a flowchart showing a search process for the material information 312 in the database system 100.
FIG. 10 is a screen transition diagram of the terminal device 103 from the login process to the main screen display process.
FIG. 11 is a screen transition diagram of the terminal device 103 in the search process for the material information 312.

The control unit 401 of the terminal device 103 accesses the server 101 and logs in (step 801).
The user 104 specifies the URL of the server 101 from the WWW browser 120 of the terminal device 103 to access the server 101, and the control unit 201 of the server 101 transmits login screen data to the terminal device 103 via the WWW server 110. To do.

  The control unit 401 of the terminal device 103 displays the received login screen 1001 (FIG. 10) via the WWW browser 120. The user 104 inputs the user ID and password, and the control unit 401 of the terminal device 103 transmits the input user ID and password to the server 101. If there are a plurality of servers 101, the server name may be specified.

The control unit 201 of the server 101 receives the user ID and password via the WWW server 110 and performs user authentication (step 802). 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 is correctly authenticated, the control unit 201 of the server 101 transmits the database selection screen data to the terminal device 103 (step 803).

The control unit 401 of the terminal device 103 displays the received database selection screen 1002 (FIG. 10) (step 804).
The user 104 selects a user group and a database. When a user group is selected, a connectable database name is displayed.
The control unit 401 of the terminal device 103 transmits the user group and database name to the server 101 (step 805).

The control unit 201 of the server 101 sets the product information database 301 corresponding to the user group and the database name (step 806).
The control unit 201 of the server 101 transmits main screen data on which the user 104 searches and browses the information database 301 to the terminal device 103 (step 807).
The control unit 401 of the terminal device 103 displays the received main screen 1003 (FIG. 10) (step 808).

When the “material” button 11 and the “search” tab 12 are designated on the main screen 1003, the control unit 401 of the terminal device 103 requests the server 101 to search for material information (step 809).
The control unit 201 of the server 101 returns material information search screen data (step 810).
The control unit 401 of the terminal device 103 displays the material information search screen 1004 (FIG. 11) (step 811). When the search condition 13 (item, value, condition, etc.) is input on the material information search screen 1004, the control unit 401 of the terminal device 103 sends the contents of the search condition 13 to the server 101 (step 812).

  Since the database system 100 manages the specific value 332 of the specific item 331 of the product information 311 as the specific value 334 of the specific item 333 of the material information 312, the specific item of the product information 311 is used as the search condition 13 of the material information 312. A specific value 332 of 331 can be specified.

The control unit 201 of the server 101 searches the material information 312 based on the search condition 13 and returns a search result (step 813).
The control unit 401 of the terminal device 103 displays the material information search result 14 on the material information search screen 1004 (step 814).

When the “detail” button 15 of the material information search result 14 is pressed, the control unit 401 of the terminal device 103 requests the server 101 for material information details (step 815).
The control unit 201 of the server 101 returns the material information detail screen data (step 816).
The control unit 401 of the terminal device 103 displays the material information detail screen 1005 (FIG. 11) (step 817).
On the material information detail screen 1005, browsing of material information 312 and maintenance work are performed. For example, maintenance work related to the material file information 16 and the material additional information 17 can be performed.

  If the database system 100 does not manage the specific value 332 of the specific item 331 of the product information 311 as the specific value 334 of the specific item 333 of the material information 312, the specification of the product information 311 is specified as the search condition 13 of the material information 312. The specific value 332 of the item 331 cannot be specified. When searching for material information 312 related to specific product information 311, the product information search screen 1011 (FIG. 11) is displayed by designating the “product” button 21 and the “search” tab 12 on the main screen 1003. It is necessary to search the product information 311 once by inputting the search condition 23 of the product information 311. Then, the “detail” button 25 of the product information search result 24 is pressed to display the product information detail screen 1012 (FIG. 11), the material information 312 is selected from the related material list 26, and the “detail” button 27 is pressed. The material information detail screen 1005 (FIG. 11) is displayed.

  On the other hand, the database system 100 according to the embodiment of the present invention manages the specific value 332 of the specific item 331 of the product information 311 as the specific value 334 of the specific item 333 of the material information 312, so By specifying the specific value 332 of the specific item 331 of the product information 311 as the material information detailed screen 1005 (FIG. 11) without passing through the product information search screen 1011 (FIG. 11) and the product information detailed screen 1012 (FIG. 11). ) Can be reached.

(5. Effects, etc.)
As described above, according to the embodiment of the present invention, the database system manages the specific value of the specific item of the product information as the specific value of the specific item of the material information, and adds and deletes the association between the product information and the material information, the product When the deletion of the information or the change of the specific value of the specific item of the product information is detected, the specific value of the specific item of the corresponding material information is updated.
As a result, the specific value of the material information is automatically updated as the database is updated, so that it is not necessary to perform an operation related to the specific value update of the material information. Also, by managing the specific value of the specific item of the product information as the specific value of the specific item of the material information, when searching or maintaining the material information, the material information can be directly searched or maintained without tracing from the product information. Therefore, maintenance work of material information can be performed efficiently.

  The preferred embodiments of the database system 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 naturally belong to the technical scope of the present invention. Understood.

Configuration diagram of database system 100 Hardware configuration diagram of server 101 The figure which shows the information which the memory | storage part 202 hold | maintains The figure which shows the data structure of the goods database 301 Hardware configuration diagram of the terminal device 103 The flowchart which shows the update detection process and specific value update process in the database system 100 The figure which shows the concrete contents of update detection processing and specific value update processing A flowchart showing processing from login processing to main screen display processing in the database system 100 The flowchart which shows the search process of the material information 312 in the database system 100 Screen transition diagram of terminal device 103 from login processing to main screen display processing Screen transition diagram of terminal device 103 in search processing of material information 312

Explanation of symbols

100 ......... Database system 101 ......... Server 103 ......... Terminal device 104 ......... User 105 ......... Server administrator 109 ......... Network 110 ......... Web server 111 ......... Database management means 114 ... ... Update detection means 115 ......... Specific value update means 120 ... ... WEB browser 201, 401 ... ... Control unit 202, 402 ... ... Storage device 301 ... ... Product database 311 ... ... Product information 312 ... ... Material information 313 ......... Correspondence table 331, 333 ......... Specific items 332, 334 ......... Specific values

Claims (8)

A database system comprising a database relating to at least one terminal device and predetermined information and related information, wherein a server for providing the predetermined information and the related information to the terminal device is connected via a network,
The database manages the specific value of the specific item of the predetermined information as the specific value of the specific item of the related information,
The server
Update detection means for detecting a predetermined update in the database;
A specific value updating unit for updating a specific value of the related information when the update detecting unit detects a predetermined update in the database;
A database system comprising:   The predetermined update in the database includes at least one of addition or deletion of association between the predetermined information and the related information, deletion of the predetermined information, or change of a specific value of the predetermined information. 1. The database system according to 1. The server further includes:
The database system according to claim 1, further comprising a related information search unit that searches for the related information based on a specific value of the predetermined information. A server connected to at least one terminal device via a network, comprising a database relating to predetermined information and related information, and providing the predetermined information and related information to the terminal device;
The database manages the specific value of the specific item of the predetermined information as the specific value of the specific item of the related information,
Update detection means for detecting a predetermined update in the database;
A specific value updating unit for updating a specific value of the related information when the update detecting unit detects a predetermined update in the database;
A server comprising:   The predetermined update in the database includes at least one of addition or deletion of association between the predetermined information and the related information, deletion of the predetermined information, or change of a specific value of the predetermined information. 4. The server according to 4.   6. The server according to claim 4, further comprising related information search means for searching for the related information based on a specific value of the predetermined information.   A program for causing a computer to function as the server according to any one of claims 4 to 6.   A computer-readable 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