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

Abstract

<P>PROBLEM TO BE SOLVED: To provide a database system or the like capable of display by freely processing information to be displayed at the time of list-displaying information acquired from a database. <P>SOLUTION: A server 101 sets a process setting information for processing display information for a display item 35 when list-displaying the information of an information database 301, and provides an information list of the display information processed according to the process setting information, to a terminal device 103. The information list 10a displays the information of the information database 301 as it is, while the information list (processed display) 10b displays the processed information of the information database 301 on the basis of a display item set 33 of a "list display (processed)" set for processing. For example, a standard price is added with yen for display on the basis of a processing expression 45 "'standard price' ¾¾ 'yen'" for the display item 35 "standard price". <P>COPYRIGHT: (C)2005,JPO&NCIPI

Description

  The present invention relates to a database system using a network, and more particularly to processing display and processing setting of display data in a list display of 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 the conventional database system, if you want to temporarily change the information displayed in the application at the time of display (for example, if you want to output the display contents in all capital letters only this time when you want to output the display contents as text) It was necessary to change the record itself, and the opportunity for record operations such as undoing the changed record or making a different change increased, which was not efficient. In addition, there is a problem that the risk of mistakes in changing records in the database increases. In addition, there is a problem that the display contents cannot be changed for each user (for example, a certain user is displayed with “sama” added to the name, or “*” is displayed for information desired to be hidden).

  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 can freely process and display information to be displayed when displaying a list of information acquired from a database. And

  In order to achieve the above-mentioned object, a first invention is a system in which a terminal device of a registered user and a server are connected via a network, wherein the server includes a database for storing information, In response to a request from the terminal device, processing setting means for setting processing setting information for processing display information for display items when displaying a list of information acquired from the database, and for each display item A database system comprising processing processing means for processing display information and providing it to the terminal device according to processing setting information.

The server preferably further includes a holding unit that holds the processing setting information corresponding to the display items together with the display items and the arrangement thereof when displaying the list.
Further, it is desirable that the processing setting means designates and holds the processing setting information including a processing formula and identification information thereof.
Further, the processing setting means stores the display item name as a target specified in the processing formula as a special variable character string representing the display item name, so that the same processing setting information for other items is stored. It is desirable to be able to use.

  In the first invention, the server has a database for storing information, and processes display information for display items when displaying a list of information acquired from the database in response to a request from the terminal device. Processing setting information is set, and display information is processed and provided to the terminal device according to the processing setting information for each display item.

A second invention is a server connected via a network to a registered user's terminal device, a database for storing information, and information acquired from the database in response to a request from the terminal device. Processing setting means for setting processing setting information for processing display information for display items when displaying a list, and an information list obtained by processing the information in accordance with the processing setting information for each display item And a processing means provided to the server.
The second invention is an invention relating to a server used in the database system of the first invention.

The “display item” is an item for displaying a list of information acquired from the database.
“Processing setting information” includes a processing formula, an identification name, and the like, and is specified by the processing setting means. “Processing expressions” use functions, arithmetic operators, string concatenation operators, etc., and “functions” include substitution, numeric values, rounding of price digits, string extraction, date formatting, characters Includes functions such as column concatenation

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 can freely display and process information to be displayed when displaying a list of information acquired from a database.

  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, terminal devices 103 of a plurality of users 104, 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, and the like. The database operation unit 111 is called from the WWW server 110, and searches the 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 information database 301 and is registered in advance in the server 101, and has a 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 for the information database 301, input information, and the like, and receives information acquired from the 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, an 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 illustrated in FIG. 3, the storage device 202 stores an information database 301, a control program 311, an application program 312, and the like.

  Information is stored in the information database 301. Note that a plurality of 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, with reference to FIGS. 5, 6, 7, and 8, a processing flow of display data processing setting and processing display when the database system 100 displays a list will be described. 5, 6, 7, and 8 are flowcharts showing the processing procedure of the database system 100.

  The control unit 401 of the terminal device 103 accesses the server 101, logs in, and transmits a request for specifying the information database 301 to be operated (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. The control unit 201 of the server 101 receives the user ID, password, and the like input on the login screen from the terminal device 103 via the WWW server 110 and performs user authentication. Thereafter, transmission / reception of data 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 the database selection screen data to the terminal device 103. The control unit 401 of the terminal device 103 displays a database selection screen (not shown) and is selected by the user 104. Database name, user group, etc.

The control unit 201 sets the database name from the terminal device 103, the information database 301 corresponding to the user group, the user group, and the like, and reads the information database 301 from the storage device 202 (step 502). A user group is a group of registered users. A display item set consisting of display items and their arrangement can be used according to the registered user or the user group of the registered user, and the contents can be changed. And
The control unit 201 transmits main screen data on which the user 104 searches and browses the information database 301 to the terminal device 103 (step 503).

The control unit 401 of the terminal device 103 displays the received main screen 900 (step 504). FIG. 9 shows the main screen 900.
As shown in FIG. 9, in the main screen 900, the information list 10 for displaying the information acquired from the information database 301 according to the display item 35, the work box list 13 / the basket list 14, and the search for searching for items as search conditions. A screen 15, a target structure 31, a display target 32, a box for designating a display item set 33, various control buttons, a control menu, and the like are displayed.

  The structure 31 indicates, for example, a data structure of a product unit, and is represented by a product name (personal computer, television, kitchen, etc.). Note that the structure 31 is not limited to a product name, and may be a name such as “electric appliance” or “accessory” classified into a product category, for example. The display item set 33 indicates display items and their arrangement when displaying information in the information database 301 as a list. For example, the display item set “list display” includes “product name”, “product code”, “standard”. The display item 35 is composed of display items 35 such as “price” and “minimum price” and their arrangement, and a display item set name 34 which is a storage name of the existing display item set 33 created before is displayed.

  Next, processing setting and storage of display items will be described. When the user 104 presses the display item setting button 11 or the like, the control unit 401 transmits a display item setting request to the server 101 (step 505). Further, by clicking “list display item setting” in the display menu displayed by the display menu button 12, the control unit 401 transmits a display item setting request to the server 101.

The control unit 201 of the server 101 transmits display item setting screen data indicating a list of items to be displayed (step 506).
The control unit 401 of the terminal device 103 displays the display item setting screen 901 (step 507). FIG. 10 shows a display item setting screen 901.

  As shown in FIG. 10, the display item setting screen 901 includes control buttons such as a target structure 31, a display item set name 34, an item list 41, a display item list 42, an OK button 22, and a save button 23. The item list 41 is a list of items 36 of the target structure 31. The display item list 42 includes the display items 35 of the designated display item set name 34 and their arrangement. The control unit 401 shifts to the main screen 900 by the OK button 22. With the save button 23, the control unit 401 assigns a name to the set display items and their arrangements, processing settings for the display items, and saves them.

The user 104 selects the display item 35 to be processed and set from the display item list 42 of the display item set 33 indicated by the display item set name 34 (step 508).
For example, the display item 35 “standard price” is selected from the display item list 42.
The control unit 401 of the terminal device 103 transmits a processing setting selection request for the display item 35 (for example, “standard price”) to be processed (step 509).
The control unit 201 of the server 101 transmits processing setting selection screen data (step 601).

The control unit 401 of the terminal device 103 displays a processing setting selection screen 902 (step 602). FIG. 11 shows a processing setting selection screen 902.
As shown in FIG. 11, the processing setting selection screen 902 includes control buttons such as a processing method list 43, a processing formula 45, an OK button 22, an add button 25, an edit button 26, and a delete button 27.
The processing method list 43 includes processing method names 44 that are identification names of existing processing settings created and held so far.
The processing formula 45 uses, for example, a DBMS (Oracle) SQL function, an arithmetic operator, a character string combination operator, or the like. The functions include, for example, replacement (REPLACE), numeric value, price rounding (ROUND), character string extraction (SUBSTR), date format (TO_CHAR), character string concatenation (CONCAT), and the like.

As an example using a function,
REPLACE (“product code”, 10000, “No.”) → 1000 is changed to No. Replace with and display.
ROUND ('interest', 2) → Displayed as a number rounded to two decimal places.
SUBSTR (“product code”, 3, 2) → displays only the second to third characters from the left of the value of the product code.
TO_CHAR ('publication date', 'yy-mm-dd') → Display the date display format as, for example, “04-01-26”.
CONCAT ('Manufacturer', 'Like')-> Mark the manufacturer and display like "Company A".
In addition to functions, examples of things that can be used in machining formulas are:
Arithmetic operator: “'standard price' + 100” → 100 is added to the standard price and displayed.
Character combination operator: “'standard price' || 'yen'" → displays the standard price with a circle added.

  The processing formula 45 can use the same processing setting (processing method) for another display item by saving the display item name portion to be specified as a special character string (variable character string). It becomes. For example, the expression “REPLACE (“ product code ”,“ ABC ”,“ No. ”)” is stored as “REPLACE (% item%,“ ABC ”,“ No. ”)”. Also, the processing method name 44 “for adding price unit” for the display item name “standard price” 45 “'standard price' || '' circle '" is "% item% ||'" circle ' When the processing method name 44 “for adding price unit” is used for the other display item name “minimum price”, the processing formula 45 is displayed as “'minimum price' || 'circle'". The

  With the add button 25, the control unit 401 displays a processing setting screen 903 for newly generating processing settings. With the edit button 26, the control unit 401 displays a processing setting screen 903 for editing the processing setting indicated by the specified existing processing method name 44. With the delete button 27, the control unit 401 deletes the processing setting indicated by the processing method name 44 in the specified processing method list 43. With the OK button 22, the control unit 401 shifts to the display item setting screen 901.

The user 104 presses the add button 25 (or selects an existing processing method name 44 and edit button 26), and the control unit 401 transmits a processing setting request (step 603).
For example, when the processing method name 44 “for price unit addition” in the processing method list 43 is selected, the processing formula 45 has “standard price” | | 'Circle' is displayed, and the user 104 presses the edit button 26.

  The control unit 201 of the server 101 transmits the processing setting screen data (step 604). The control unit 201 includes blank processing setting screen data when newly creating with the add button 25, and processing setting information of the specified processing method name 44 when editing existing processing settings with the edit button 26. Send processing setting screen data.

The control unit 401 displays a processing setting screen 903 (step 605). FIG. 12 shows a processing setting screen 903.
As shown in FIG. 12, the processing setting screen 903 includes target items 46 to be processed, processing method name 44, processing formula 45, processing setting save button 28, control buttons such as option 29, and the like.

For example, when the existing processing method name 44 “for adding price unit” is selected on the processing setting selection screen 902 in FIG. 11 and the edit button 26 is pressed, the processing setting screen 903 displays the processing setting target as shown in FIG. For the item 46 “standard price”, the processing method name 44 “for adding price unit” and the processing formula 45 ““ standard price ”||“ circle ”” are shown. The user 104 edits the processing settings such as the displayed processing method name 44 and processing formula 45 as necessary.
In the case of new creation with the add button 25, the processing is set by inputting a new processing method name 44, processing formula 45, etc. in the blank.

  The user 104 inputs or edits and specifies the processing method name 44 and the processing formula 45 in the processing method list 43 for the processing setting target item 46 (step 606).

Also, by pressing the option button 29, the control unit 401 displays a processing setting (option) screen 904 for easily creating the processing formula 45 from the function (step 607). FIG. 13 shows a processing setting (option) screen 904.
As shown in FIG. 13, the processing setting (option) screen 904 includes a processing type 47 including a function group frequently used in the processing formula 45, a parameter 48 thereof, and the like.
The processing type 47 is a function group such as replacement (REPLACE), numerical value, rounding of the number of digits of the price (ROUND), extraction of a character string (SUBSTR), date format (TO_CHAR), concatenation of character strings (CONCAT), and the like. A function group having a high use frequency is set in advance.
The parameter 48 is one or more input parameters corresponding to the function, and specifies, for example, a target item name, a replacement character string, the number of characters, the number of digits, and the like to be processed.

The user 104 selects a function from the processing type 47 and designates the parameter 48 of the function (step 608).
For example, as shown in FIG. 13, for the processing setting target item 46 “product code”, the processing method name 44 “product code processing” “replace with“ ABC ”→“ No. ”In information” ”. In creating the setting, the user 104 selects the processing method name 44 “product code processing” and the function “replace (REPLACE)” from the processing type 47 and sets the parameter 48 as “product code” that is the parameter 1: target item 46. ”, Parameter 2: the character string“ ABC ”before replacement, parameter 3: the character string“ No. ”after replacement, and the like, the control unit 401 causes the processing formula 45“ REPLACE (“product code”, “ ABC ',' No. ') "is set and displayed.

After the processing setting is completed, when the processing setting save button 28 is pressed, the control unit 401 transmits a processing setting information storage request including the specified processing formula 45, processing method name 44, and the like (step 609).
The control unit 201 of the server 201 holds the specified processing formula 45 in the information database 301 as the processing method name 44 (step 701). As a result, when the machining setting is performed next time, the machining setting of the machining method name is displayed in the machining method list 43 and can be used.
The control unit 201 of the server 101 transmits the processing setting selection screen data (step 702).

  The control unit 401 of the terminal device 103 displays the processing setting selection screen 902 (step 703), and when the OK button 22 is pressed, shifts to the item setting screen 901 and displays it (step 704).

  When the user 104 presses the save button 23, the control unit 401 displays a display item set name designation dialog (not shown) to be saved (step 705), and the user 104 inputs the display item set name 34. The control unit 401 requests the server 101 to save the display items, their arrangement, and the processing setting of the target display item (step 706).

  The control unit 201 of the server 101 saves the display item set 33 including the display item set name 34, the display items 35 and their arrangement, and the processing setting information of the target display item in the information database 301 of the storage device 202 ( Step 707).

  Next, processing for processing display when displaying a list of information acquired from the information database 301 will be described.

  When the user 104 displays the processed and set information as a list, when the display item set name 34 storing the processed and displayed display items and their arrangement is selected from the display item set 33 on the main screen 900, the control unit 401 A list display request for the display item set name 34 is transmitted (step 801). For example, the display item set name “list display (processing)” on the main screen 900 is selected.

  The control unit 201 of the server 101 transmits information list data for processing and displaying information in the information database 301 based on the processing formula 45 of the processing setting information for each display item 35 of the specified display item set 33. (Step 802).

The control unit 401 of the terminal device 103 displays the received information list (processed display) 10b (step 803). FIG. 14 shows an information list (display database contents as they are) 10a and an information list (process display) 10b.
As shown in FIG. 14, the information list (display database contents as it is) 10 a of the main screen 900 is based on the display item set 33 (“product name”, “item name”, “list display”) based on the display item set 33 of the selected display item set name 34 “list display”. The information in the information database 301 for “product code”, “standard price”, “minimum price”, etc.) is displayed as a list as it is.

  The information list (processed display) 10b includes display items 35 ("product name", "product code", "standard price") based on the display item set 33 of the display item set name 34 "list display (processed)" that has been processed. , “Minimum Price”, etc.) is processed and displayed.

For example, “ABC” in the product code information based on the processing formula 45: REPLACE (“product code”, “ABC”, “No.”) for the display item 35 “product code”, which is the processing setting information. Is replaced with “No.” and displayed. For example, “ABC1224” → “No.1224” is displayed.
Based on the processing formula 45: “'standard price' || 'circle'" for the display item 35 "standard price", a circle is added to the standard price and displayed. For example, “100,000” → “100,000 yen” is displayed.
Based on the processing formula 45: DECODE ('lowest price', NULL, '****', '******') for the display item 35 "lowest price", the lowest price (including no value) Are all displayed as “*.” For example, “150,000” → “***” is displayed.

  As described above, according to the embodiment of the present invention, the server 101 has the information database 301 for accumulating information, and lists information acquired from the information database 301 in response to a request from the terminal device 103. Processing setting information (processing formula 45 using a function, an arithmetic operator, a character string combination operator, etc.) for processing the display information is set for the display item 35 at the time of display. When a list of information acquired from the information database 301 is displayed, by specifying a display item set 33 including display items 35 that have been processed and set, list information 10b that is processed and displayed for each display item 35 according to the processing setting information. Provided to the terminal device 103.

As a result, when displaying the contents of the database in the application, it is possible to display the list with the contents temporarily changed without changing the information in the database. Risks of operations and the like can be reduced, and efficient database operations can be performed.
In addition, by saving the processing setting information that has been processed and set as a special variable character string that represents the display item name, the same processing can be performed for other items. Allows setting to be used.
Furthermore, processing setting information is stored as a display item set together with display items and their arrangement in the information list display, and when displaying the list, the display item set can be displayed at any time by selecting the display item set. This is not a fixed data processing method prepared by the application, but the user can freely process the display data using DBMS functions, and the flexible processing display according to the user ( Can be added and displayed, or information that is desired to be hidden is displayed with “*”.

  In this embodiment, the 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 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.

  The program for performing the processing shown in FIGS. 5, 6, 7, 8, etc. may be distributed on a recording medium such as a CD-ROM, or the program may be transmitted / received via a communication line. You can also.

  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 database system 100 The flowchart which shows the process sequence of the database system 100 The flowchart which shows the process sequence of the database system 100 The flowchart which shows the process sequence of the database system 100 The figure which shows the main screen 900 The figure which shows the display item setting screen 901 The figure which shows the process setting selection screen 902 The figure which shows the process setting screen 903 The figure which shows the process setting (option) screen 904 The figure which shows information list (database content as it is displayed) 10a and information list (processing display) 10b

Explanation of symbols

DESCRIPTION OF SYMBOLS 100 ......... Database system 101 ......... Server 103 ......... Terminal device 104 ......... User 109 ......... Network 110 ......... WWW server 111 ...... Database operation means 112 ...... Database server management means 113 ... ... Database management means 120 ... WWW browser 201, 401 ... Control unit 202, 402 ... Storage device 301 ... Information database 10, 10a, 10b ... Information list 33 ... Display item set 34 ......... Display item set name 35 ......... Display item 36 ......... Item 43 ......... Processing method list 44 ...... Processing method name 45 ......... Processing formula 46 ......... Target item 47 ......... Processing type

Claims (14)

A system in which a registered user terminal device and a server are connected via a network,
The server
A database for storing information;
In response to a request from the terminal device, processing setting means for setting processing setting information for processing display information for display items when displaying a list of information acquired from the database;
Processing processing means for processing the display information and providing it to the terminal device according to the processing setting information for each display item;
A database system comprising: The server
A holding means for holding the processing setting information according to the display items together with the display items and the arrangement when displaying the list,
The database system according to claim 1, further comprising: The processing setting means includes
The database system according to claim 1, wherein the processing setting information including a processing formula and identification information thereof is designated and held. The processing setting means includes
By saving the display item name specified in the processing formula as a special variable character string representing the display item name, the same processing setting information can be used for other items. The database system according to any one of claims 1 to 3. The database system according to any one of claims 1 to 4, wherein the processing formula uses at least one of a function, an arithmetic operator, a character string combination operator, and the like. 6. The database according to claim 5, wherein the function includes at least one function of replacement, numerical value, rounding of digits of price, extraction of character string, date format, concatenation of character strings, and the like. system. A server connected to a registered user's terminal device via a network,
A database for storing information;
In response to a request from the terminal device, processing setting means for setting processing setting information for processing display information for display items when displaying a list of information acquired from the database;
Processing processing means for processing the display information and providing it to the terminal device according to the processing setting information for each display item;
A server comprising: A holding means for holding the processing setting information according to the display items together with the display items and the arrangement when displaying the list,
The server according to claim 7, further comprising: The processing setting means includes
The server according to claim 7, wherein the processing setting information including a processing formula and identification information thereof is designated and held. The processing setting means includes
By saving the display item name specified in the processing formula as a special variable character string representing the display item name, the same processing setting information can be used for other items. The server according to any one of claims 7 to 9. The server according to any one of claims 7 to 10, wherein the processing formula uses at least one of a function, an arithmetic operator, a character string combination operator, and the like. 12. The server according to claim 11, wherein the function includes at least one function of replacement, numerical value, rounding of digits of price, extraction of character string, date format, concatenation of character strings, and the like. . A program that causes a computer to function as the server according to any one of claims 7 to 12. A recording medium on which a program for causing a computer to function as the server according to any one of claims 7 to 12 is recorded.

Images