JP2005092692A - Database system, server, data input and display support method, program, and recording medium - Google Patents

Abstract

<P>PROBLEM TO BE SOLVED: To provide a database system or the like capable of providing an information input screen and a display screen using one shared template. <P>SOLUTION: A server 101 has a merchandise information database 301 and a form database 302 for storing a corresponding template 320 shared by an information confirmation screen 1000 and an information input screen 1200. The template 320 is described in a language written on a Web page filled with items 702 and layout information 701 or the like. The template 320 matching merchandise information selected from a terminal device 103 is read from the form database 302, and the information confirmation screen 1000 on which the merchandise information is displayed according to the template 320, and the information input screen 1200 enabling the display or an input of the merchandise information according to the template 320 are provided. <P>COPYRIGHT: (C)2005,JPO&NCIPI

Description

  The present invention relates to a database system using a network, and more particularly to data input and data display.

  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, refer to Patent Document 1 and Patent Document 2).

JP 2001-306377 A JP 2002-328941 A

  In the conventional system, when inputting information and confirming the input, it is necessary to incorporate necessary functions on the respective screens at the time of input and confirmation into dedicated software or a template. In this case, each time an item to be input or a change in the appearance of the screen is changed, the software or template needs to be corrected on the corresponding screen, which puts a burden on the software development staff. Furthermore, the modification requires a plurality of corrections such as an input screen and a display screen, 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 and the like that can provide an information input screen and a display screen by using one shared template. 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 items of information. A first database, a second database for storing a template to be shared and used for the information input screen and the information display screen according to the information, and the template according to the information specified by the terminal device. The information input screen for reading from the second database and inputting or displaying the information based on the template, and providing means for providing the information display screen to the terminal device are provided. It is a database system.

  The template is preferably described in a data description language in which input or display items, layout information, and the like are embedded.

  In the first invention, the server includes a first database for storing a plurality of items of information, and a second database for storing a template to be shared and used for an information input screen and an information display screen according to the information. A template corresponding to the information specified by the terminal device is read from the second database, and an information input screen and an information display screen for inputting or displaying information based on the template are provided to the terminal device. .

A second invention is a server connected via a network to a registered user's terminal device, a first database that stores a plurality of items of information, an information input screen corresponding to the information, A second database for storing a template to be shared and used for the information display screen, and the template corresponding to the information designated from the terminal device are read from the second database, and the information is read based on the template. A server comprising: the information input screen that can be input or displayed; and a provision unit that provides the information display screen to the terminal device.
The second invention is an invention relating to a server used in the database system of the first invention.

A third invention is a data input and display support method used in a system in which a terminal device of a registered user and a server are connected via a network, and stores a plurality of information consisting of items. A database, a second database for storing a template to be shared and used for an information input screen and an information display screen according to the information, and the template according to the information designated by the terminal device. And a providing step of providing the terminal device with the information input screen for inputting or displaying the information on the basis of the template and the information display screen. This is an input and display support method.
A third invention is an invention relating to a data input and display support method executed by the server of the second invention.

“Item” is information included in a database record corresponding to a form, and is an input / display item.
The “template” is described in a language that describes a Web page in which input or display items, layout information, and the like are embedded. “Language” includes HTML (Hypertext Markup Language), XML (extensible Markup Language), SGML (Standard Generalized Markup Language), and the like.
The “layout information” describes the appearance of the screen. In particular, for input items, as “option information”, display format information indicating the display method of the input form, size information indicating the size of the input form , Information indicating the name of the item corresponding to the input form, information for setting whether to display the input form, information for setting whether the input form can be input, and the like.

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

  The present invention can provide a database system or the like that can provide an information input screen and a display screen by using one shared template.

  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 will be 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 when implemented 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, a database support unit 114, and the like.
The database operation unit 111 is called from the WWW server 110 and performs information input, input confirmation, search, information content reference, browsing, and the like of the product information database 301. 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 database support means 114 performs input support such as creation of a form such as an input / display screen for product information and the like, input / editing of product information, and input confirmation according to the form.

  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.

  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, a form database 302, 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 control program 311, an application program 312, a product information database 301, a form database 302, and the like.

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, the database support unit 114, 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 form database 302 holds a template 320 corresponding to the input screen and display screen corresponding to the product information.

  Next, the template 320 will be described in detail. FIG. 7 shows a description method of the template 320. FIG. 8 shows the template source code 800.

The template 320 used on the input screen and the display screen is registered and held in the form database 302 from the terminal device 103 of the user 104 using the database support unit 114 of the server 101, the editor 121, and the like. Called from the terminal device 103 by the user 104 of the user group and used. The template 320 is managed by the server 101 for each user group.
The template 320 is described in a language described in a Web page in which items 702, layout information 701, and the like are embedded. For example, HTML (Hypertext Markup Language) is used as the language.

  As shown in FIG. 7A, the layout information 701 of the template 320 is described in, for example, HTML. As shown in FIG. 7B, the input / display items 702 are included in the layout information 701. Embedded using special tags. For example, the item 702 “Manufacturer” is embedded and described as “<% Manufacturer%>”. Furthermore, as shown in FIG. 7C, when the item 702 is inputable, special tag option information 703 is described.

  The option information 703 includes display form information indicating the display form of the input form, size information (“Size”, “Row”, “Cols”, etc.) indicating the size of the input form, and items corresponding to the input form. Information “Name” indicating the name of the input form, identification information “Id” of the input form, information “Disable” that sets whether or not the input form is displayed according to the input / display screen, whether or not the input form can be input Is “Read Only” or the like that is set according to the input / display screen. The display form information includes a “Text Box” single-line text box, a “Text Area” multi-line text box, a “Select” pull-down menu selection box, and the like.

  For example, as shown in FIG. 7C, “<% Manufacturer. TextBox. Id = A0003. Name = Text 03. Size = 20%>” in the item 702 and option information 703 is an input form of the item 702 “Manufacturer”. As a single-line text box, the length of the text box is 20 digits, and the name “Text03”, ID “A0003”, and the like are set.

  In the present embodiment, the description language is described using HTML, but any language that can describe a Web page may be used. Further, the option information 703 is not limited to the information shown here.

As shown in FIG. 8, the template source code 800 is the source code (HTML) of the template 320 that is shared and used in an information confirmation screen 1000 shown in FIG. 10 and an information input screen 1200 shown in FIG.
The template source code 800 includes layout information 701-1, 701-2, 701-3, 701-4, and the like. For example, the layout information 701-4 includes items 702-3 “maker”, item 702-4 “frame.shape”, item 702-5 “frame.mark”, item 702 on the information confirmation screen 1000 and the information input screen 1200. -6 Describe "Related URL" etc. Item 702-3 “Manufacturer”, item 702-6 “Related URL”, and the like are items that can be input, and each further describes option information 703.

  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, application programs such as a WWW browser 120 and an editor 121, 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, the flow of processing such as information input, input confirmation display, and information correction of 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 after logging in by the user 104, inputs product information according to the input form screen using an input support application of the server 101, and performs control. The unit 401 transmits input data (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, password, and the like via the WWW server 110, performs user authentication, and when the user authentication is correctly performed, the control unit 201 inputs information to the product information database 301 by the user 104. Input form screen data for performing the above is transmitted to the terminal device 103. 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.

  The control unit 201 of the server 101 holds the received input data in the product information database 301 of the storage device 202 (step 502).

As shown in FIG. 9, when performing input confirmation, the user 104 clicks a preview button 901 or the like on the supporter screen 900 and selects a target product information template 320 (step 503).
FIG. 9 shows a supporter screen 900. The supporter screen 900 is a screen that is displayed when the database support unit 114 is activated by the server 101, and various support functions are displayed by selecting a tag 910 such as a preview button 901.
The control unit 401 of the terminal device 103 transmits an information confirmation (preview display) request (step 504).

  The control unit 201 of the server 101 reads out the corresponding template 320 from the form database 302 and the corresponding product information from the product information database 301, creates information confirmation screen data for displaying the product information based on the template 320, and transmits it. (Step 505).

As shown in FIGS. 9 and 10, the control unit 401 displays the received information confirmation screen 1000 (step 506).
FIG. 10 shows an information confirmation screen 1000. The information confirmation screen 1000 displays product information 706 based on the template 320 registered in the form database 302.
For example, “PC0001” of item 702-1 “series code”, “AAA-9000” of item 702-2 “series name”, “XXX” of item 702-3 “manufacturer”, and the like are displayed.

  FIG. 11 shows a specification display screen 1100. As shown in FIG. 11, the specification display screen 1100 displays a list of product information 706 including items 702 indicating the product specifications and values 705 for each product. Originally, the product information 706 shown in the specification display screen 1100 is held in the product information database 301. From this, the item 702 is picked up as necessary, and the information confirmation screen is created based on the template 320 created and registered. 1000 product information 706 is displayed.

  The user 104 confirms the input of the product information 706 on the information confirmation screen 1000. If there is information correction or addition to the item 702, the user 104 clicks the edit button 902 or the like on the supporter screen 900, and the control unit 401 An input / edit request is made (step 507).

  As shown in FIG. 6, the control unit 201 of the server 101 creates and transmits information input screen data for inputting / displaying product information based on the template 320 from the template 320 and the product information 706 (step). 508).

The control unit 401 of the terminal device 103 displays the information input screen 1200 (step 509).
FIG. 12 shows an information input screen 1200. As shown in FIG. 12, the information input screen 1200 has the same items 702 and screen appearance as the information confirmation screen 1000, and an input form 1201 is displayed for each inputable item 702, and input and editing are performed. It becomes possible. For example, item 702-1 “series code”, item 702-2 “series name”, item 702-3 “maker”, item 702-4 “related URL”, and the like can be input.

The user 104 inputs and corrects the items 702-1, 702-2, etc. that can be input, and the control unit 401 transmits the input data to the server 101 (step 510).
The control unit 201 of the server 101 holds the received input data in the product information database 301 (step 511).

  Note that an input screen 1300 and a confirmation screen 1301 always exist even on a screen for applying for member registration or the like on the Web. The screen can be mounted and applied by a method based on the unification of the input screen and display screen template 320 shown in this embodiment. For example, FIG. 13 shows a member registration input screen 1300 and a confirmation screen 1301. As illustrated in FIG. 13, the member registration input screen 1300 includes a plurality of input items 1302, and the member registration confirmation screen 1301 includes display items 1304 similar to the input items 1302 of the input screen 1300 and the appearance of the screen. . By using the template 320 shared between the input screen 1300 and the confirmation screen 1301, the input screen 1300, the confirmation screen 1301, etc. can be provided to the terminal device 103 on the user 104 side. It should be noted that the difference between the details of the input screen and the confirmation screen, such as items and items, can be set by the option information 703 or the like.

  As described above, according to the embodiment of the present invention, the server 101 includes the product information database 301 and the form database 302 that stores the template 320 that is shared and corresponds to the input screen and the display screen according to the information. Have. The template 320 is described in a language described in a Web page in which an input / display item 702 and layout information 701 and the like are embedded. The input / display item 702 includes a special tag in the layout information 701. In the case where the item 702 is embedded and used and can be input, special tag option information 703 is described. A template 320 corresponding to the product information designated from the terminal device 103 is read from the form database 302, information confirmation screen data for displaying product information is transmitted to the terminal device 103 based on the template 320, information confirmation is performed, Based on the template 320, information input screen data that enables display and input of product information is transmitted to the terminal device 103, and input items are corrected.

  As a result, when there is a change or addition to the input item, the appearance of the screen, etc., it can be handled immediately, and the load at the time of correction is reduced. In addition, the layout and the template are unified on the input screen and the display screen, and consistency can be maintained.

  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 case where HTML is used as the description language of the template has been described. However, any language may be used as long as it describes a Web page, and in addition to HTML, XML (eXtensible Markup Language), SGML (Standard Generalized) Markup Language) or the like can be used.

  In the present 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 Flowchart showing processing procedures such as input confirmation display and information correction of the database system 100 Flowchart showing processing procedures such as input confirmation display and information correction of the database system 100 The figure which shows the description method of the template 320 Diagram showing template source code 800 The figure which shows the supporter screen 900 Diagram showing information confirmation screen 1000 The figure which shows the specification display screen 1100 The figure which shows the information input screen 1200 The figure which shows the input screen 1300 and confirmation screen 1301 of member registration

Explanation of symbols

DESCRIPTION OF SYMBOLS 100 ......... Database system 101 ......... Server 103 ......... Terminal device 104 ......... User 109 ......... Network 111 ......... Database operation means 112 ......... Database server management means 113 ......... Database management means 114 ......... Database support means 201, 401 ......... Control unit 202, 402 ......... Storage device 301 ......... Product information database 302 ......... Form database 320 ......... Template 701 ......... Layout information 702 ......... Item 703 ... Option information

Claims (19)

A system in which a registered user terminal device and a server are connected via a network,
The server
A first database for storing a plurality of items of information;
A second database for storing a template to be shared and used for the information input screen and the information display screen according to the information;
The template corresponding to the information specified from the terminal device is read from the second database, and the information input screen and the information display screen that can input or display the information based on the template are displayed on the screen. Providing means for providing to the terminal device;
A database system comprising: The template is
The database system according to claim 1, wherein the database system is described in a data description language in which input or display items and layout information are embedded. The layout information is
The database system according to claim 2, further comprising information for setting a display form of the input form for the input item. The layout information is
3. The database system according to claim 2, further comprising information for setting a size of the input form for the input item. The layout information is
The database system according to claim 2, further comprising information for setting a name corresponding to the input form for the input item. The layout information is
3. The database system according to claim 2, further comprising information for setting whether to display the input form in accordance with the information input screen or the information display screen for the input item. The layout information is
The database system according to claim 2, further comprising information for setting whether or not the input form can be input for an input item. The data description language is:
The database system according to claim 2, wherein the database system is any one of HTML, XML, SGML, and the like. A server connected to a registered user's terminal device via a network,
A first database for storing a plurality of items of information;
A second database for storing a template to be shared and used for the information input screen and the information display screen according to the information;
The template corresponding to the information specified from the terminal device is read from the second database, and the information input screen and the information display screen that can input or display the information based on the template are displayed on the screen. Providing means for providing to the terminal device;
A server comprising: The template is
The server according to claim 9, wherein the server is described in a data description language in which input or display items and layout information are embedded. The layout information is
11. The server according to claim 10, further comprising information for setting a display form of the input form for the input item. The layout information is
The server according to claim 10, further comprising information for setting a size of the input form for an input item. The layout information is
11. The server according to claim 10, further comprising information for setting a name corresponding to the input form for the input item. The layout information is
The server according to claim 10, further comprising information for setting whether to display the input form in accordance with the information input screen or the information display screen for the input item. The layout information is
The server according to claim 10, further comprising information for setting whether or not the input form can be input for an input item. The data description language is:
The server according to claim 10, wherein the server is any one of HTML, XML, SGML, and the like. A data input and display support method used in a system in which a registered user terminal device and a server are connected via a network,
A first database for storing a plurality of items of information;
A second database for storing a template to be shared and used for the information input screen and the information display screen according to the information;
The template corresponding to the information specified from the terminal device is read from the second database, and the information input screen and the information display screen that can input or display the information based on the template are displayed on the screen. A providing process to be provided to the terminal device;
A data input and display support method comprising: A program causing a computer to function as the server according to any one of claims 9 to 16. A recording medium recording a program that causes a computer to function as the server according to any one of claims 9 to 16.

Images