WO2013065823A1

WO2013065823A1 - Database creation management system

Info

Publication number: WO2013065823A1
Application number: PCT/JP2012/078472
Authority: WO
Inventors: 茂樹岩佐; 治之木村; 丈二柏原; 淳也阿部
Original assignee: 株式会社ＳＴＮｅｔ
Priority date: 2011-11-04
Filing date: 2012-11-02
Publication date: 2013-05-10
Also published as: JP5307219B2; JP2013097717A

Abstract

In the present invention, a screen creation area (40) for displaying a data input portion to be created, a control icon bar (42) upon which a plurality of controls used for creating the data input portion are displayed, and an input condition setting-use display area (43) for displaying a plurality of input condition setting portions of the data input portion are displayed upon display means by way of an operation control circuit (not shown) of a customer area server so that creation of the data input portion and setting of input conditions are performed upon a single screen.

Description

Database creation management system

The present invention relates to a database creation management system for constructing a database by setting data input units and input conditions of the data input units.

Conventionally, various database development systems using communication lines such as Web have been considered (for example, see Patent Documents 1 and 2).

On the other hand, when building a database in a database development system, create the required multiple tables, set the attributes of each item in each table, and associate each table to normalize the associated table In general, an input form provided with an input unit based on a table is set.

JP 2010-128873 A JP-A-9-237274

For this reason, it was difficult to construct a database unless the skilled person had a basic knowledge of the database to some extent.

Therefore, an object of the present invention is to provide a database creation management system that can easily construct a database even when there is no basic knowledge of the database.

Therefore, the database creation management system according to the present invention includes a recording means in which database creation software having a database creation screen is recorded, a display means for displaying the database creation screen, and an operation of the database creation screen displayed on the display means. Screen operating means for performing The database creation screen includes a screen creation area for displaying a data input section to be created, a control display area for displaying a plurality of controls used for creating the data input section, and a plurality of input conditions for the data input section. An input condition setting display area for displaying a setting section is simultaneously displayed on the database creation screen. This display is performed by arithmetic control means. Further, the operation control means is controlled by the database creation software, and drags and drops the control display area control to the screen creation area by the screen operation means. Created in the screen creation area. In addition, the calculation control means sets and controls the input condition setting of the data input unit created in the screen creation area by operating the input condition setting unit. Such creation of the data input unit in the screen creation area and setting of the input conditions of the data input unit are performed on one database creation screen.

This configuration makes it possible to easily construct a database even if there is no basic knowledge of the database.

It is explanatory drawing which shows an example of the database creation management system which concerns on this invention. FIG. 2 is a control circuit diagram of the fixed terminal shown in FIG. 1. It is a schematic block diagram explaining the user authentication server shown in FIG. FIG. 2 is a schematic configuration explanatory diagram of a common management server shown in FIG. 1. FIG. 2 is a schematic configuration explanatory diagram of a customer server shown in FIG. 1. FIG. 2 is a schematic configuration explanatory diagram of a system area server shown in FIG. 1. FIG. 2 is a control circuit diagram of the mobile terminal shown in FIG. 1. It is explanatory drawing which shows the display screen by the database creation management system of FIG. It is explanatory drawing which shows the display screen by the database creation management system of FIG. It is explanatory drawing which shows the display screen by the database creation management system of FIG. It is explanatory drawing which shows the display screen by the database creation management system of FIG. It is explanatory drawing which shows the display screen by the database creation management system of FIG. It is explanatory drawing which shows the display screen by the database creation management system of FIG. It is explanatory drawing which shows the display screen by the database creation management system of FIG. It is explanatory drawing which shows the display screen by the database creation management system of FIG. It is explanatory drawing which shows the display screen by the database creation management system of FIG. It is explanatory drawing which shows the display screen by the database creation management system of FIG. It is explanatory drawing which shows the display screen by the database creation management system of FIG. It is explanatory drawing which shows the display screen by the database creation management system of FIG. It is explanatory drawing which shows the display screen by the database creation management system of FIG. It is explanatory drawing which shows the display screen by the database creation management system of FIG. It is explanatory drawing which shows the display screen by the database creation management system of FIG. It is explanatory drawing which shows the display screen by the database creation management system of FIG. It is explanatory drawing which shows the display screen by the database creation management system of FIG. It is explanatory drawing which shows the display screen by the database creation management system of FIG. It is explanatory drawing which shows the display screen by the database creation management system of FIG. It is explanatory drawing which shows the display screen by the database creation management system of FIG. It is explanatory drawing which shows the display screen by the database creation management system of FIG. It is explanatory drawing which shows the display screen by the database creation management system of FIG. It is explanatory drawing which shows the display screen by the database creation management system of FIG. It is explanatory drawing which shows the display screen by the database creation management system of FIG. It is explanatory drawing which shows the display screen by the database creation management system of FIG. It is explanatory drawing which shows the display screen by the database creation management system of FIG. It is explanatory drawing which shows the display screen by the database creation management system of FIG. It is explanatory drawing which shows the display screen by the database creation management system of FIG. It is explanatory drawing which shows the display screen by the database creation management system of FIG. It is explanatory drawing which shows the display screen by the database creation management system of FIG. It is explanatory drawing which shows the display screen by the database creation management system of FIG. It is explanatory drawing which shows the display screen by the database creation management system of FIG. It is explanatory drawing which shows the display screen by the database creation management system of FIG. It is explanatory drawing which shows the display screen by the database creation management system of FIG. It is explanatory drawing which shows the display screen by the database creation management system of FIG. It is explanatory drawing which shows the display screen by the database creation management system of FIG. It is explanatory drawing which shows the display screen by the database creation management system of FIG. It is explanatory drawing which shows the display screen by the database creation management system of FIG. It is explanatory drawing which shows the display screen by the database creation management system of FIG. It is explanatory drawing which shows the display screen by the database creation management system of FIG. It is explanatory drawing which shows the display screen by the database creation management system of FIG. It is explanatory drawing of the access right management screen in the database creation management system of FIG.

Hereinafter, embodiments of the present invention will be described with reference to the drawings.
[Constitution]
(i). Schematic Components of Database Creation Management System As shown in FIG. 1, a database creation management system according to the present invention includes a database Web server system 1 and a fixed terminal on the client (user) side. (Communication terminals) A and B and mobile terminals (communication terminals) C such as mobiles on the client (user) side are provided. The database creation management system also includes connection communication devices 3 such as routers and gateways that connect the fixed terminals A and B to the Web server system 1 via the online line 2. In addition, the fixed terminal B and the mobile terminal C are connected to the Web server system 1 via the Internet 2 a and the connection communication device 3.

As shown in FIG. 2, the fixed terminals A and B include a keyboard 4 used for inputting characters and the like, a mouse 5 used for screen operation, a keyboard (screen operation means) 4, a mouse (screen operation means) 5, and the like. An arithmetic control unit 6 that is an arithmetic control circuit (terminal control unit) to which an input signal by the input operation means and an operation signal are input, a memory (storage unit) 7 connected to the arithmetic control unit 6, and a memory 7 And a display device (display means) 8 such as a liquid crystal display for displaying a screen based on the control program.

As shown in FIG. 3, the mobile terminal C is stored in the arithmetic control unit 9 which is an arithmetic control circuit (terminal control unit), a memory (storage unit) 10 connected to the arithmetic control unit 9, and the memory 10. And a display device (display means, screen operation means) 11 such as a touch panel type liquid crystal display that displays a screen based on the control program.

Since the fixed terminal B is connected to the Web server system 1 via the internetwork 2a, it can be used as a mobile terminal as long as it is a notebook type.
(ii). Schematic Components of Web Server System 1 The Web server system 1 includes a user authentication server 12, a common management server 13, a customer area server 14, and a system area server 15.
(User authentication server 12)
The user authentication server 12 is used for user authentication, and performs authentication by customer ID / user ID / PW (password). The user authentication server 12 includes a management server control unit (management server control circuit) 12a and a storage unit (memory such as RAM and ROM) 12b shown in FIG. 2A, a program and data recording unit (hard disk, silicon disk or optical disk). Magnetic recording device) 12c and the like.
(Common management server 13)
The common management server 13 includes a management server control unit (arithmetic control circuit) 13a and a storage unit (memory such as RAM and ROM) 13b shown in FIG. 2B, a program and data recording unit (hard disk, silicon disk, or magneto-optical). Recording device) 13c and the like. The common management server 13 provides a common function for all customers, and mainly provides various database templates. Examples of the template include a control template, a form template, and a skin template.
(Customer area server 14)
The customer area server (data server, data storage unit) 14 includes a data server control unit (arithmetic control circuit) 14a and a storage unit (memory such as RAM and RON) 14b, programs and data which are not shown in FIG. 2C. And a recording unit (hard disk, silicon disk, or magneto-optical recording apparatus) 14c. The customer area server 14 is a data storage unit that provides a WebDB (web database) function for each customer. The WebDB function includes a WebDB management function, a WebDB utilization function, and the like.
(System area server 15)
The system area server 15 includes a system control unit (arithmetic control circuit) 15a and a storage unit (memory such as RAM and RON) 15b, a program and data recording unit (hard disk, silicon disk, or magneto-optical recording) shown in FIG. 2D. Device) 15c and the like. The system area server 15 provides a customer addition / deletion function and outputs various source usage logs.
(Example of software used)
In addition, software such as CentOS, Apache, MySQL, Ruby, etc. is recorded in a recording unit (not shown) of programs and data such as the user authentication server 12, the common management server 13, the customer area server 14, and the system area server 15. Has been. CentOS is a free Linux (registered trademark) distribution software aiming at complete compatibility with RedHatEnterpriseLinux (hereinafter referred to as “RHEL”). Apache is Web server software. MySQL is free database software. Ruby is software used to write programs such as Web application system management and text processing.
(iii). Schematic Configuration and Access Procedure for Database Creation of Web Server System 1 The user authentication server 12 is accessed from the fixed terminal A via the connection communication device 3 to the Web server system 1, or the fixed terminal B When the Web server system 1 is accessed from the mobile terminal C via the Internet 2a and the connection communication device 3, the initial customer authentication screen 20 as shown in FIG. It is displayed on the display device 11 of the terminal C.

The customer authentication screen 20 includes an ID input unit (ID input box) 21 for inputting a user ID, a PW input unit (PW input box) 22 for inputting a PW (password), a clear button 23, and a login button 24. Is displayed.

On the customer authentication screen 20, the customer ID can be input to the ID input unit 21 using the keyboards 4 of the fixed terminals A and B, and the customer password can be input to the PW input unit 22. In the mobile terminal C, a customer ID or a customer password can be input by touching a character button or the like displayed on the display device 11.

Further, the clear button 23 and the login button 24 can be operated with the mouse 5 of the fixed terminals A and B. The mobile terminal C can be operated by touching the clear button 23 or the login button 24 displayed on the display device 11. The button selection operation using the mouse 5 and the selection operation by touching the touch panel display device 11 will be described below simply as a selection operation or a button selection operation.

The user authentication server 12 selects the login button 24 on the customer authentication screen 20 shown in FIG. 4 while the customer ID is correctly input to the ID input unit 21 and the customer password is correctly input to the PW input unit 22. When operated, the control of the user authentication server 12 is switched to the control of the customer area server 14. When the control from the user authentication server 12 is switched, the customer area server 14 displays the selection screen 27 on which the WebDB use button 25 and the WebDB management button 26 shown in FIG. 5 are displayed.
On the customer authentication screen 20 in FIG. 4, a window ribbon WRb having items such as file (F), edit (E), display (V), address (D), and return is displayed. The window ribbon WRb is also displayed on other screens.

When the WebDB use button 25 is selected and operated, the calculation control circuit (control unit) (not shown) of the customer area server 14 searches a recording area (not shown) of the customer area server 14 and uses it other than the manager of the customer. A WebDB (web database) for inputting data is called from a recording area (not shown) of the customer area server 14 and switched to an input selection screen (not shown) of the WebDB.

In addition, when a WebDB management button 26 is selected on the selection screen 27, an arithmetic control circuit (control unit) (not shown) of the customer area server 14 searches a recording area (not shown) of the customer area server 14 and manages the customer. The management screen (list screen) 28 of the WebDB (web database) as shown in FIG.

The management screen 28 displays a DB management menu bar 28a and a selection list 28b. In addition, items such as “WebDB”, “system management”, “WebDB use”, and “logout” are displayed on the DB management menu bar 28a. Items such as screen title, owner (administrator), version, update date / time, screen content, type, disclosure (public / private), change, and deletion are displayed in the selection list 28b.

When “WebDB” in the DB management menu bar 28a of FIG. 6 is selected, “WebDB list”, “Create new form”, “Screen access control setting” as shown in FIG. , Items such as “form template list” are displayed. When the form template list in FIG. 7 is selected, a list of various templates in a database (not shown) is read from the common management server 13 and displayed. Examples of the various templates include templates recorded in the common management server 13 such as a control template, a form template, and a skin template.

Then, a data input screen G1 of the database, for example, a data input screen of “company car master” whose screen title is shown in FIG. 8, or a screen title created using this “company car master” is shown. The present invention will be described by taking as an example a case where a data input screen G2 for “company car use management” as shown in FIG. 9 is created.

First, the database items of the database input screen G1 of the “company car master” database shown in FIG. 8, the data input screen G2 of “company car use management” as shown in FIG. 9 and the like will be described. (The input items of the “company car master” data input screen G1 etc.) In the data input screen G1 of the “company car master” database shown in FIG. 8, the company car master is displayed as the screen title of the database. In addition, data entry items such as “parking lot number, vehicle number, mission, equipment, use start date, remarks, car name, address, display contents” are displayed.

A text box (number input box) dB1 is displayed as a data input section to the right of the parking lot number, and a region selection combo box dB2, number input boxes dB21, dB22, and dB23 are data input sections to the right of the vehicle number. It is displayed as.

On the right side of the mission, an AT selection radio button RB1 and an MT selection radio button RB2 which are mission types are displayed as a data input section, and on the right side of the equipment, an equipment check ETC check box ChB1, A navigation check box ChB2 is displayed as a data input section.

Further, a date input box dB3 is displayed as a data input part on the right side of the use start date and a calendar icon CL is displayed for date selection, and a remarks input box dB4 is displayed as a data input part on the right side of the remarks. A car name input box dB5 is displayed as a data input part on the right side of the car name, an address input box dB6 is displayed as a data input part on the right side of the address, and a content input box dB7 is entered on the right side of the display contents. It is displayed as a part.

In addition, a “cancel” button is displayed at the lower left of the data input screen G1, and a “next” button for displaying the next input screen is displayed at the lower right of the data input screen G1.

In this data input screen G1, text box (number input box) dB1, area selection combo box dB2, number input boxes dB21, dB22, dB23, AT selection radio button RB1, MT selection radio button RB2, equipment check The ETC check box ChB1, the navigation check box ChB2, the date input box dB3, the remarks input box dB4, the car name input box dB5, the address input box dB6, the content input box dB7, and the like serve as data input sections. (Input items on the data entry screen G2 for “company-owned car use management”) The data entry screen G2 for “company-owned car use management” in FIG. 9 displays “company-owned car use management” as the screen title. At the same time, items such as “management number, company-owned vehicle, representative user, use start date, use end date, use purpose, vehicle state, remarks” and the like are displayed. Since the data entry screen G2 for the “company car use management” is created in the same manner as the data entry screen G1 for the “company car master”, detailed description of the data entry screen G2 is omitted. Also on this data input screen G2, input boxes and buttons on the right side of items such as “management number, company-owned vehicle, representative user, use start date, use end date, use purpose, vehicle state, remarks”, etc. (reference number omitted) Becomes a data input part.

In the first creation method, a template for a “company car master” data input screen as shown in FIG. 8 or a “company car use management” data input screen as shown in FIG. If prepared on the 1st side, select "Form template list" from the pull-down menu of "WebDB" to display the form template list, and from this list, "Company owned car master" or "Used company owned car management" Template. Then, a data input screen for “company car master” and “company car use management” is created using the selected template.

In the second creation method, click “Create New Form” in FIG. When this “create new form” is clicked, a form information input screen 29 for creating a new form as shown in FIG. 10 is displayed.

The form information input screen 29 includes a new selection button 30 that is a radio button, a template use button 31 that is a radio button, a template selection box 32, a template selection button 33, a screen corresponding to the form creation method item. A title input box 34, a screen content input box 35, a category input box 36, a cancel button 37, a create button 38, and the like are displayed.

In the fixed terminals A and B, a cursor (not shown) is operated by the mouse 5, and in the mobile terminal C, the touch panel-type display device 11 is touched to select a new selection button 30, a template use button 31, a template selection selection button 33, Button operations such as a cancel button 37 and a create button 38 can be performed.

Then, a template use button 31 that is a radio button is selected and a selection button 33 for selecting a template is clicked or touched to display a template list that is a template of an already created database. A database template can be selected from this list and displayed in the template selection box 32.

When the screen title input box 34, the screen content input box 35, the category input box 36, and the like are selected by touching the cursor (not shown) with the mouse 5 or the touch panel display device 11, the keyboards in the fixed terminals A and B are selected. 4 enables character input or the like to be performed in the screen title input box 34, the screen content input box 35, the category input box 36, and the like. This input can also be performed by touching a character button or the like displayed on the display device 11 on the mobile terminal C.

For example, as shown in FIG. 11, the title “company-owned car master” can be input in the screen title input box 34, and the content of “company-owned car master” is displayed in the screen content input box 35. The user can input the contents of the screen “This is the master of the company” and can input that the “company-owned car master” is in the category “master” in the category input box 36.
(iv) Detailed configuration for database creation by the Web server system 1 Since the input operations by the fixed terminals A and B and the mobile terminal C can be executed in the same manner, a new database form is created by the operation by the fixed terminal A. The case will be described, and the description of operations by the fixed terminal B and the mobile terminal C will be omitted. In this description, a case where a database used for management of vehicles owned by a company, that is, a “company-owned vehicle master” is created will be described as an example of database creation.

As described above, click “Create New Form” in FIG. Clicking “create new form” displays a form information input screen 29 for creating a new form as shown in FIG.

When a new selection button 30 is selected on the form information input screen 29, a black circle 30a indicating that the selection operation has been performed is displayed in the new selection button 30. In this state, as described above, for example, the title “company-owned car master” is input to the screen title input box 34, and the content of “company-owned car master” is set to “company-owned car master” in the screen content input box 35. The screen content “I am a master” is input, and the category input box 36 is input that “company-owned car master” is a category “master”. After this input, the creation button 38 is selected and operated.

By this operation, the calculation control circuit (control unit) (not shown) of the customer area server 14 controls the common management server 13, and the database creation shown in FIG. 12 is performed by the calculation control circuit (control unit) (not shown) of the common management server 13. A screen (management software created image) 39 is displayed.

The database creation screen 39 includes a screen creation area (input form display area) 40 for displaying a data input section created by a computation control circuit (calculation control means) (not shown) of the customer area server 14 and a screen creation area (input form). (Display area) 40 has a screen creation operation display area 41 for creating and displaying a data input section. This screen creation operation display area 41 is used for the control icon bar 42 used for creating the data input section of the screen creation area (input form display area) 40, and for other setting operations such as item creation and arrangement of the data input section, input conditions, etc. It has an input condition setting display area 43 to be used.
A. Screen creation operation display area 41
a. Control icon bar 42
This control icon bar 42 is indicated by a trash can control (trash can icon) 42a, a radio button creation control (radio button creation icon) 44 indicated by "middle inside black", and a "square" line. A check button creation control (check button creation icon) 45 and a combo box creation control (combo box creation icon) 46 indicated by “vertical lines and downward triangles in a rectangular frame that is elongated to the left and right” are arranged. .

The control icon bar 42 includes a single line text box creation control (text box creation icon) 47 indicated by “Aiueo”, and a numeric input box creation control (numerical input box creation icon) indicated by “12345”. ) 48, several lines of text box creation control (text box creation icon) 49 shown in “2-line AIUEO”, date input box creation control (date input box creation icon) shown in “calendar icon” 50 is arranged.

Further, the control icon bar 42 includes a URL input box creation control (URL input box creation icon) 51 indicated by “URL”, and a master linkage box creation indicated by “an icon using a right-angled arrow”. Control (master link box creation icon) 52, automatic number box creation control (auto number box creation icon) 53 indicated by "auto", screen information setting button 54 for screen information confirmation, "gear is displayed The control batch setting button 55 indicated by “Icon” is arranged.

For convenience of illustration, in FIG. 14 and subsequent figures, radio button creation control 44, check button creation control 45, combo box creation control 46, one-line text box creation control 47, numeric input box creation control 48, number A line text box creation control 49, a date input box creation control 50, a URL input box creation control 51, a master linkage box creation control 52, an automatic number box creation control 53, etc. are used as they are or explained. For convenience, it is simply used as controls 44-53. Further, the control (icons) 44 to 53 of the control icon bar 42 and the symbols of the buttons will be described with reference to the drawings as necessary.
・ Trash control 42a
The trash can control 42a moves the buttons and input boxes created in the screen creation area 40 by dragging and dropping them to the trash can control 42a with a mouse. Used to delete.
-Radio button creation control 44
The radio button creation control 44 is used to create a radio button in the screen creation area 40 by dragging and dropping with a mouse.
-Check button creation control 45
The check button creation control 45 is used to create a check button in the screen creation area 40 by a drag-and-drop operation with a mouse.
・ Combo box creation control 46
This combo box creation control 46 is used to create a combo box in the screen creation area 40 by dragging and dropping with a mouse.
-Text box creation control 47
The text box creation control 47 is used to create a text input box in the screen creation area 40 by dragging and dropping with a mouse.
・ Control 48 for creating numeric input boxes
The numerical input box creation control 48 is used to create a numerical input box in the screen creation area 40 by dragging and dropping with a mouse.
-Text box creation control 49
The text box creation control 49 is used to create a long text input box in the screen creation area 40 by dragging and dropping with a mouse.
・ Control 50 for creating date box
The date input box creation control 50 is used to create a date input box in the screen creation area 40 by dragging and dropping with a mouse.
-URL input box creation control 51
The URL input box creation control 51 is used to create a URL input box in the screen creation area 40 by dragging and dropping with a mouse.
・ Control 52 for creating master linkage box
The master linkage box creation control 52 is used to create a linkage operation box in the screen creation area 40 by dragging and dropping with a mouse.
・ Automatic number box creation control 53
The automatic number box creation control 53 is used to create an automatic number input box in the screen creation area 40 by dragging and dropping with a mouse. Screen information setting button 54 for confirming screen information The screen information setting button 54 for confirming screen information is used for displaying the created database input screen and confirming the database input screen.
・ Control batch setting button 55
This control batch setting button 55 is used to control the contents of the created database item (for example, presence / absence, uniqueness, display order in list, presence / absence of search target, display alignment, presence / absence of label, X coordinate and Y coordinate This is used to confirm or reset the position.
b. Input condition setting display area 43
(b-1). Basic Display In FIGS. 12 and 13, nothing is displayed in the input condition setting display area 43.

The controls 44 to 53 of the control icon bar 42 are moved to the screen creation area (input form display area) 40 by the touch movement operation of the mouse 5 of the fixed terminals A and B and the touch panel of the display device 11 of the mobile terminal C. By dragging and dropping, boxes and buttons corresponding to the controls 44 to 53 are created in the screen creation area 40. In this case, in the input condition setting display area 43, an item name input box (input condition setting unit) 56 and a label check box (input condition setting unit) 57 are displayed as an operation unit. In addition to the item name input box 56, a condition setting unit (operation unit) for inputting necessary conditions in the text box dB1 created in the screen creation area 40 is displayed. The label check box 57 is used to set whether the item name input in the item name input box 56 is the item name of the box or button created in the screen creation area 40 by the controls 44-53. Used for. When the label check box 57 is checked, the item name input in the item name input box 56 is displayed on the left side of the box or button created in the screen creation area 40 by the controls 44-53. 53, item names of boxes and buttons created in the screen creation area 40 are displayed.

For example, the text box creation control 47 of the control icon bar 42 is displayed on the screen creation area (input form display area) 40 by a touch movement operation of the mouse 5 of the fixed terminals A and B or the touch panel of the display device 11 of the mobile terminal C. A drag and drop operation is performed in the creation area 40. In this case, a text box dB1 is created in the screen creation area 40 as shown in FIG. When the text box dB1 is created in the screen creation area 40, the item name input box 56 for inputting the item name of the text box dB1 and the item name input in the item name input box 56 are used as the label of the text box dB1. A label check box 57 for setting whether or not is displayed as an operation unit.

Then, an item name is input to the item name input box 56 by operating the keyboard 4 of the fixed terminals A and B and the touch panel of the display device 11 of the mobile terminal C, and the label check box 57 is checked and operated. When a tick mark is entered at 57, the item name input in the item name input box 56 is displayed as the item name in the text box dB1 on the left side of the text box dB1 in the screen creation area 40.

In addition to the item name input box 56 and the label check box 57, the input condition setting display area 43 includes a condition setting section for inputting necessary conditions in the text box dB1 created in the screen creation area 40. (Operation section) is also displayed.

That is, in the input condition setting display area 43 in FIG. 14, a mandatory check box (input condition setting unit) 58 for setting whether or not to input characters and data to the data input unit and a data input unit are input. Unique check box (input condition setting unit) 59 for setting whether or not to allow duplicate registration of characters and data to be registered, and whether to use characters and data input to the data input unit for search An operation unit such as a search target check box (input condition setting unit) 60 to be displayed is displayed.

Further, in the input condition setting display area 43, a display order input section (display order number input box, input condition setting section) 61 for setting the display order in the list, and a left alignment icon (input condition setting section for setting display alignment) ) 62, an operation unit such as a center alignment icon (input condition setting unit) 63, a right alignment icon (input condition setting unit) 64, and the like are displayed.

The input condition setting display area 43 includes a help content input unit 65 for explaining contents to be input to the data input unit, an initial value input unit 66, a prefix input unit 67, and a suffix input unit 68. The number of input characters 69 of the data input unit, the X coordinate input unit 70 and the Y coordinate input unit 71 of the data input unit, and the item of the label created in the screen creation area 40 by being input to the item name input unit 60 The operation units such as the label X coordinate input unit 72 and the label Y coordinate input unit 73 of the name are displayed.

In FIG. 14, reference numerals attached to the input portion of the input condition setting display area 43 and the like will be described as necessary in other drawings.
(b-2). Display of selected content operation by another display / radio button creation control 44 in the input condition setting display area 43 In the screen creation area 40 using the radio button creation control 44 in the control icon bar 42 When a radio button is pasted as shown in FIG. 19, a selection content input unit 74 for selecting the content to be selected by the radio button is displayed in the input condition setting display area 43 as an operation unit.
Display of selected content operation by check button creation control 45 When a check box is pasted in the screen creation area 40 using the check button creation control 45 of the control icon bar 42 as shown in FIG. A selection content input unit 75 for selecting the content to be selected is displayed in the input condition setting display area 43 as an operation unit.
Display of operation of selected contents by combo box creation control 46 When combo box is pasted as data input part in screen creation area 40 using combo box creation control 46 in control icon bar 42 as shown in FIG. The selection content input unit 76 displays the content to be selected in the combo box as an operation unit in the input condition setting display area 43.
Display of setting operation by the numerical value input box creation control 48 Further, the numerical value input box is pasted as a data input section in the screen creation area 40 by using the numerical value input box creation control 48 of the control icon bar 42 as shown in FIG. In the case of the input condition setting display area 43, the number-of-digits input setting unit 77 for setting the number of digits of the numerical value to be input to the numerical value input box and the check box 78 for setting whether or not the numerical value separator is displayed as a comma are displayed. Is displayed as an operation unit.
Display of setting operation by the date input box creation control 50 The date input box is pasted in the screen creation area 40 as a data input section as shown in FIG. 22 using the date input box creation control 50 of the control icon bar 42. In this case, the setting unit 79 for initial values of dates to be input to the date input box and the selection unit 80 for selecting and setting the date display style are displayed on the input condition setting display area 43 as operation units.
[Action]
Next, an example of database creation by the database creation management system having such a configuration and input of the created database will be described.
(1). Creation of Database A user accesses the database Web server system 1 from the fixed terminals A and B, the mobile terminal C, etc. via the online line 2, the Internet 2 a and the connection communication device 3. This access is executed via the keyboard 4 of the fixed terminals A and B, the mouse 5 or the touch panel of the display device 11 of the mobile terminal C.

With this access, the user authentication server 12 of the database Web server system 1 moves the customer authentication screen 20 of FIG. 4 to the fixed terminals A and B via the connection communication device 3 and the online line 2 or the Internet 2a. The data is transmitted to the terminal C and displayed on the display device 8 of the fixed terminals A and B and the display device 11 of the mobile terminal C. Hereinafter, when it is simply abbreviated as “display”, the user authentication server 12, the common management server 13, the customer area server 14, the system area server 15 and the like of the Web server system 1 are connected to the fixed terminals A and B, the mobile terminal C, and the like. The display simply means display.

In the customer authentication screen 20 of FIG. 4, a user (customer) ID input unit 21 and a PW (password) input unit 22 are displayed. In this state, the user inputs the customer ID into the ID input unit 21 and the customer password into the PW input unit 22 using the keyboard 4 of the fixed terminals A and B and the touch panel of the display device 11 of the mobile terminal C. .

In a state where the customer ID and the customer password are correctly input to the ID input unit 21 and the PW input unit 22 in the ID input unit 21, the user presses the login button 24 with the mouse 5 of the fixed terminals A and B, A selection operation is performed on the touch panel of the display device 11 of the mobile terminal C.

This operation switches the control of the user authentication server 12 to the control of the customer area server 14. When the control from the user authentication server 12 is switched, the customer area server 14 displays the selection screen 27 on which the WebDB use button 25 and the WebDB management button 26 shown in FIG. 5 are displayed on the display devices 8 of the fixed terminals A and B. Or displayed on the display device 11 of the mobile terminal C.

Then, an arithmetic control circuit (control unit) (not shown) of the customer area server 14 selects and operates the WebDB management button 26 on the selection screen 27 by using the mouse 5 of the fixed terminals A and B and the touch panel of the display device 11 of the mobile terminal C. A WebDB (web database) management screen (list screen) 28 as shown in FIG. 6 for searching a recording area (not shown) of the customer area server 14 and selecting a database managed by the customer administrator is displayed on the fixed terminal A. , B and the display device 11 of the mobile terminal C are displayed.

When the user selects and operates “WebDB” in the DB management menu bar 28a in FIG. 6 using the mouse 5 of the fixed terminals A and B or the touch panel of the display device 11 of the mobile terminal C, the pull-down menu of “WebDB” displays Items such as “WebDB list”, “Create new form”, “Both-screen access control setting”, “Form template list” and the like as shown in FIG. 7 are displayed.

Then, when creating a data input screen of a database, for example, a data input screen of “company-owned car master” as shown in FIG. 8, the mouse 5 of the fixed terminals A and B and the display device 11 of the mobile terminal C are used. On the touch panel shown in FIG. 7, “Create new form” in FIG. 7 is clicked and selected. In addition, in the database of “company car master” shown in FIG. 8, data input items such as parking lot number, vehicle number, mission, equipment, start date of use, remarks, car name, address, display contents, etc. are set. Has been.

When the “company car master” shown in FIG. 8 is created, the form information input screen 29 for creating a new form as shown in FIG. Display.

The user selects and operates a template use button 31 that is a radio button by using the touch panel of the mouse 5 of the fixed terminals A and B or the display device 11 of the mobile terminal C, thereby creating a template of a template that has already been created. A list can be displayed, and a database template can be selected from this list and displayed in the template selection box 32.

Accordingly, the user moves to the screen title input box 34, the screen content input box 35, and the category input box 36 shown in FIG. 11 by using the touch panel of the display device 11 of the fixed terminal A and B or the mobile terminal C. The contents are input through the keyboard 4 of the fixed terminals A and B and the touch panel of the display device 11 of the mobile terminal C. For example, as shown in FIG. 11, the title “company-owned car master” is input to the screen title input box 34, and the content of “company-owned car master” is displayed in the screen content input box 35. The screen content “is a master” is input, and a category “company car master” is input in the category input box 36. After this input, the creation button 38 on the screen of FIG. 11 is selected and operated.

By this selection operation, the database creation screen 39 shown in FIG. 12 is displayed by the customer area server 14 on the display devices 8 of the fixed terminals A and B and the display device 11 of the mobile terminal C. In this state, nothing is displayed in the screen creation area 40 or the input condition setting display area 43 of the database creation screen 39. From this state, when creating the parking lot number, vehicle number, mission, equipment, use start date, remarks, car name, address, display contents, etc. of “company-owned car master” shown in FIG. Will be described in order. (Parking number) When various icons in the control icon bar 42 are dragged and dropped onto the screen creation area 40 by operating the mouse 5 of the fixed terminals A and B or the touch panel of the display device 11 of the mobile terminal C, a box corresponding to the icon And a button are created in the screen creation area 40 by the customer area server 14.

Therefore, when creating a data input section with the item name relating to the parking lot number, first, the text box creation control 45 of the control icon bar 42 is dragged and dropped into the screen creation area 40 as indicated by the arrow A1 in FIG. As a result, a text box dB1 is created in the screen creation area 40.

With this operation, the customer area server 14 displays the input condition setting display area 43 as shown in FIG. When the text box dB1 is created in the screen creation area 40 as a data input part, the item name input box 56 for inputting the item name of the text box dB1 and the item name input in the item name input box 56 are entered in the text box dB1. A label check box 57 for setting whether or not to use the label is displayed as an operation unit in the input condition setting display area 43. Hereinafter, display control to the input condition setting display area 43 is performed by the customer area server 14, but description of the customer area server 14 is omitted.

Then, by operating the keyboard 4 of the fixed terminals A and B and the touch panel of the display device 11 of the mobile terminal C, the item name is input to the item name input box 56, for example, “parking lot number”, and the label check box 57 is checked. When the tick mark is entered in the label check box 57 by operating, the item name “parking lot number” input in the item name input box 56 on the left side of the text box dB1 in the screen creation area 40 is used as the item name of the text box dB1. Is displayed. (Other Condition Setting Unit) In addition to the item name input box 56 and the label check box 57, the input condition setting display area 43 includes conditions necessary for the text box dB1 created in the screen creation area 40. Other condition setting sections (operation sections) for inputting are also displayed.

In other words, in the input condition setting display area 43 in FIG. 14, a mandatory check box 58 for setting whether or not to make sure that characters and data are input to the data input portion overlaps with characters and data input to the data input portion. An operation unit such as a unique check box 59 for setting whether or not registration is prohibited and a search target check box 60 for setting whether or not to use characters or data input to the data input unit for search are displayed. Is done.

Further, in the input condition setting display area 43, a display order input section (display order number input box) 61 for setting the display order in the list, a left justified icon 62, a center justified icon 63, and a right justified icon 64 for setting display alignment. Etc. are displayed.

The input condition setting display area 43 includes a help content input part (input condition setting part) 65 for explaining contents to be input to the data input part, an initial value input part (input condition setting part) 66, A prefix input unit (input condition setting unit) 67, a suffix input unit (input condition setting unit) 68, an input character number input unit (input condition setting unit) 69 of the data input unit, and an X coordinate input of the data input unit Label of the item name “parking lot number” of the label which is inputted to the part (input condition setting part) 70, the Y coordinate input part (input condition setting part) 71 and the item name input part 60 and created in the screen creation area 40 Operation units such as an X coordinate input unit (input condition setting unit) 72 and a label Y coordinate input unit (input condition setting unit) 73 are displayed.

In addition, other condition setting units for inputting necessary conditions (unique, arrangement, etc.) in the text box dB1 created in the screen creation area 40 are created by other boxes and buttons created in the screen creation area 40. In this case, the input condition setting display area 43 is used to set conditions such as (uniqueness, arrangement, etc.) of other boxes and buttons. Since the setting operation contents of the other condition setting units are performed in the same manner as in the case of the text box dB1, description of other condition setting units of other boxes and buttons is omitted in the following description.
(Vehicle number)
Next, the combo box creation control 46 of the control icon bar 42 is dragged and dropped to the screen creation area 40, and the region selection combo box dB2 is pasted to the screen creation area 40 as a data input section as shown in FIG. In this case, if the item name is input as “vehicle number_prefecture” in the item name input box 56 and a tick mark is put in the label check box 57, the region selection combo box dB2 on the left side of the screen creation area 40 is displayed. The item name “vehicle number_prefecture” input in the item name input box 56 is displayed as the item name of the region selection combo box dB2 as shown in FIG.

The selection content input unit 76 displays the content to be selected in the region selection combo box dB2 as an operation unit in the input condition setting display area 43. In this selection content input section 76, prefecture names such as “Kagawa, Ehime, Kochi...” Are input as a list of selection items. The name of the prefecture for selecting the area can be selected by operating the combo box dB2. If an incorrect box E is created in the screen creation area 40 as shown in FIG. 16, the box E can be deleted by dragging and dropping the box E to the trash can control 42a.

Also, as shown in FIG. 17, the numerical value input box creation control 48 is dragged and dropped to the right side of the region selection combo box dB2 to create the number input box dB21. Similarly, a number input box dB22 is created on the right side of the number input box dB21 as shown in FIG. 18, and a number input box dB23 is created on the right side of the number input box dB21 as shown in FIG.
(Mission)
Next, as shown in FIG. 19, the radio button creation control 44 is dragged and dropped into the screen creation area 40, and radio buttons (RB1 in FIG. 19, RB1, RB2 in FIG. 20) are placed in the screen creation area 40. When created, an input condition setting display area 43 as shown in FIG. 19 is displayed. When the item name “mission” is input in the item name input box 56 of the input condition setting display area 43 and a check mark is put in the label check box 57, the item name of the radio button is “mission” on the left side of the radio button. "Is displayed.

When a radio button is pasted into the screen creation area 40 using the radio button creation control 44 of the control icon bar 42 as shown in FIG. 19, the selection content input unit 74 for selecting the content to be selected with the radio button is input conditions. It is displayed in the setting display area 43 as an operation unit. In the selection content input section 74, as shown in FIG. 19, a list of selection contents AT (automatic car) and MT (manual car) to be selected by a radio button is set.

Then, when the AT of the selection content input unit 74 is selected with the radio button created, the selection content “AT” is displayed to the right of the AT selection radio button RB1, as shown in FIG. The radio button becomes the AT selection radio button RB1.

Further, the radio button creation control 44 is dragged and dropped to the screen creation area 40, and the radio button is pasted on the right side of the AT selection radio button RB1 as shown in FIG. Then, the radio button on the right side of the AT selection radio button RB1 becomes the MT selection radio button RB2.
(Equipment)
Next, as shown in FIG. 21, when the check button creation control 45 is dragged and dropped into the screen creation area 40 to create check boxes (ChB1, ChB2 in FIG. 22) in the screen creation area 40, FIG. An input condition setting display area 43 as shown in FIG. When an item name “equipment” is entered in the item name input box 56 of the input condition setting display area 43 and a check mark is entered in the label check box 57, the item name of the check box is “equipment” on the left side of the check box. "Is displayed.

Further, when a check box is pasted into the screen creation area 40 using the check button creation control 45 of the control icon bar 42 as shown in FIG. 21, a selection content input unit 75 for selecting a content to be selected with a radio button. Is displayed as an operation unit in the input condition setting display area 43. In this selection content input section 75, as shown in FIG. 21, a selection content to be selected by a check box is set as an ETC and navigation list. When the ETC of the selection content input unit 75 is selected with the check box created, the selection content “ETC” is displayed to the right of the check box, and the created check box becomes the ETC selection check box ChB1. . Next, when another check box is pasted on the right side of the ETC selection check box ChB1 and the navigation of the selection content input section 75 is selected, the check box on the right side of the ETC selection check box ChB1 is the check box for navigation selection. ChB2.
(Start date of use)
Further, when the date input box dB3 is pasted as a data input section as shown in FIG. 22 in the screen creation area 40 using the date entry box creation control 50 of the control icon bar 42, the input condition setting as shown in FIG. A display area 43 is displayed. When an item name “starting date of use” is entered in the item name input box 56 of the input condition setting display area 43 and a check mark is put in the label check box 57, the item name is displayed on the left side of the date input box dB3. “Date of use start” and a calendar icon CL for date selection are displayed.

Accordingly, in the input condition setting display area 43, the initial value setting unit 79 for inputting the date in the date input box dB3 and the selecting unit 80 for selecting and setting the date display style are displayed in the input condition setting display area 43. Displayed as an operation unit.
(Remarks)
Next, by dragging and dropping the text box creation control 49 to the screen creation area 40 to create a long text input box as the remarks input box dB4 in the screen creation area 40, the input as shown in FIG. A condition setting display area 43 is displayed.

When the item name “remarks” is input in the item name input box 56 of the input condition setting display area 43 and a check mark is put in the label check box 57, the item name is “remarks” on the left side of the remark input box dB4. Is displayed. (Car name)
Next, as shown in FIG. 25, when the text box creation control 45 of the control icon bar 42 is dragged and dropped onto the screen creation area 40 as shown by the arrow A2 in FIG. Created. Accordingly, an input condition setting display area 43 as shown in FIG. 25 is displayed.

When an item name “car name” is entered in the item name input box 56 of the input condition setting display area 43 and a check mark is put in the label check box 57, the item name is “car name” on the left side of the text box. And the text box becomes the car name input box dB5.

Then, when the control batch setting button 55 in FIG. 26 is clicked, the item name, essential, unique, display order in the list, search target, display line, label as shown in FIG. 27 created in the “company car master” , Setting contents having items such as X coordinate, Y coordinate, and deletion are displayed, and the setting contents for the item names can be collectively confirmed. By operating the items of the setting contents, the setting contents can be changed. Thereafter, by clicking the apply button 81, the setting content is confirmed.

In order to confirm the screen information of the “company car master”, the screen information setting button 54 for confirming the screen information in FIG. 28 is clicked. As a result, the screen information shown in FIG. 29 is displayed. In this screen information, a screen title, screen content, category, application disclosure status, screen transition pattern, registration message, owner, form template, and the like are displayed. In this example, the screen title is “company-owned car master”, the screen content is “company-owned car master”, the category is “master”, the application disclosure status is “unpublished”, and the screen transition pattern is “registration> confirm> “Result display”, registration message, owner “manager 4”, and form template “template registration” are displayed. Setting a category makes it easier to search when the number of WebDBs increases. Further, as shown in FIG. 30, the transition pattern of the screen used by the user can be registered in the registration message. For example, if the number of inputs is large and there is no need to check each time, registration> result display is selected.

In this content, if the application button 81 is clicked, the registration confirmation box 82 shown in FIG. 31 is displayed. If “Yes” is selected and clicked, the WebDB of the “owned car master” is displayed in the customer area. It is registered (recorded) in the server (data storage unit) 14. After this registration, click the WebDB on the DB management menu bar 28a, and click the WebDB list of WebDB to display a list of registered databases as shown in FIG. Since there is “company car master” in the database list of FIG. 32, it can be confirmed that “company car master” is registered. Since this registration is the first registration, it is Ver0.1. Note that the item “company car master” displayed in the screen title of the database list of FIG. 32 is also the master of the created database.

Thereafter, when adding an item, for example, when adding an address or display content, drag and drop the URL input box creation control 51 to the screen creation area 40 as shown in FIG. 40, an address input box dB6 and a display content input box dB7 are created and registered.

By such an operation, it can be confirmed that Ver0.2 of “company car master” of the administrator 4 is created on the WebDB list screen as shown in FIG.
(2). Data input to “company-owned car master” When using this “company-owned car master”, click “WebDB use” in the DB management menu bar 28a to display the WebDB list screen shown in FIG. Click “Car Master” to select it. By this selection operation, a screen for the screen title “company car master” of FIG. 36 is displayed. In the case of FIG. 36, the screen for the first data input, nothing is registered. On this screen, the add button is clicked to display the data input screen of FIG.

In this data input screen, the keyboard 4 and the touch panel of the display device 11 are provided in the data input section such as each item name “parking lot number, vehicle number, mission, equipment, start date of use, remarks, car name, address, display contents”. After data entry is performed by using the WebDB data registration, the confirmation screen for data entered in the “company car master” shown in FIG. 38 is displayed. After confirming the input data on this confirmation screen, clicking the registration button completes the data input and registration to the “company car master”.
(3). Database creation of “company-owned car use management” using “company-owned car master” When using the data of “company-owned car master” created as described above in another database, for example, “company-owned car master” When creating a database whose screen title shown in FIG. 9 linked to is “company car management”, click WebDB on the DB management menu bar 28a in the same way as when creating a new form. Select and click Create new form from the pull-down menu of WebDB No.7. By this selection, the form information input screen 29 shown in FIG. 10 is displayed, and for example, “company car use management” is input to the screen title of this new form information input screen 29 as shown in FIG. Click Create to display the database creation screen 39 of FIG.

In the database creation screen 39, the automatic number box creation control 54 of the control icon bar 42 is dragged and dropped into the screen creation area 40, and the registration number automatic creation box 83 is created in the screen creation area 40. It should be noted that the registration number automatic creation box 83 is automatically registered in the screen creation area 40 in the order in which the numerical values of the data numbers to be registered in the “company car use management” database are numbered.

When the item name “automatic number 1” is entered in the item name input box 56 of the input condition setting display area 43 of the database creation screen 39, the registration number automatic creation box 83 of the screen creation area 40 as shown in FIG. "Auto number 1" is displayed in the box.

Also, as shown in FIG. 41, when the item name “management number” is entered in the item name input box 56 and the label check box 57 is checked, the registration number automatic creation box 83 in the screen creation area 40 is displayed. The item name of the item name input box 56 “management number” is displayed.

Next, as shown in FIG. 42, the master link box creation control 52 is dragged and dropped to the screen creation area 40 to create the linkage box 84 in the screen creation area 40 below the registration number automatic creation box 83. To do.

Then, when the item name of the link box 84 is set to “link source form” and the button for selecting the link box 84 is clicked, a selection list 84a shown in FIG. 43 is displayed. This selection list 84a is for setting which screen form information is linked as a master, and displays a master that has been created and registered in advance. As a function of the system, a master can be prepared in advance from the beginning and displayed in the selection list 84a. For example, a user master, affiliation master, post master, etc., which are described as this master, are prepared and selected. It can also be displayed in the list 84a. In FIG. 43, the registration number automatic creation box 83 of FIG. 42 is omitted for convenience of illustration.

From this selection list 84a, the “company car master” which is the link source form is selected and input into the link box 84, and the link source form of “company car use management” is set to “company car master”. .

Similarly,

linkage boxes

85, 86, and 87 for setting contents related to the master selected in the linkage box 84 of the linkage source form are created in the screen creation area 40.

Then, the item name of the linkage box 85 is set in the linkage key selection image, and the selection is made from the selection list 85a in the linkage box 85 and the parking lot number-vehicle name is input. The selection list 85a uses a unique item as a key, and selects the display method.

Also, the item name of the linkage box 86 is set to a display format, and the key: label is input by selecting from the selection list 86a in the linkage box 86. The selection list 86a is used to set whether a key (display method specified by the linked key selection image) is a label, a key label, or a key when displayed on the screen.

Further, the item name of the linkage box 87 is set as a label, and the vehicle name is selected and input from the selection list 87a in the linkage box 87. In this selection list 87a, item names of company-owned vehicle masters are displayed. This setting is only an example, and the present invention is not limited to this.

後 After setting the link in this way, click the Apply button to complete the link setting for the “Company-owned car use management” database. Furthermore, additional settings can be made by dragging and dropping the master linkage box creation control 53.

In addition, the necessary items are created in the same way as the creation of “company-owned car master” in “company-owned car use management” linked to “company-owned car master” (detailed explanation is omitted). As a result, a database whose screen title shown in FIG. 9 is “company car use management” is created.
(4). Public use of database If the database such as “company-owned car master” and “company-owned car use management” created as described above is set to “public”, “company-owned” as shown in FIG. The items of the screen titles of “Car Master” and “Company Car Use Management” are displayed. By selecting the database of the “Company Car Master” and “Company Car Use Management” items, the database of the selected item is displayed. An input screen can be displayed to input data.
(5). Management of Access to Database In the WebDB (web database) management screen (list screen) 28 of FIG. 6 described above, a DB management menu bar 28a and a selection list 28b are displayed. In addition, items such as “WebDB”, “system management”, “WebDB use”, and “logout” are displayed on the DB management menu bar 28a. Items such as screen title, owner (administrator), version, update date / time, screen content, type, disclosure (public / private), change, and deletion are displayed in the selection list 28b.

When “system management” in FIG. 6 is selected by clicking with the mouse or touch operation in the case of a touch panel, items such as “user list”, “new user registration”, “group maintenance”, “system operation setting” are displayed. Is done. Further, when “WebDB” in the DB management menu bar 28a of FIG. 6 is selected, “WebDB list”, “Create new form”, “Screen access control” as shown in FIG. Items such as “Setting” and “Form template list” are displayed.

When this “screen access control setting” is selected by a click operation with a mouse or a touch operation in the case of a touch panel, a database access management screen 28c as shown in FIG. 45 is displayed. An access management screen 28c selection bar BS is provided at the upper edge of the access management screen 28c. By opening the access management screen 28c, it is possible to display a WebDB list and access control setting status.

The selection bar BS of the access management screen 28c is provided with an item “screen / group” s-1 and a “setting change section” s-2. The access management screen 28c simultaneously displays a list of a plurality of databases created below the item “screen / group” s-1. In this database list, the name of the database group and the name of the database are displayed together with the folder icon.

Also, the “setting change unit” s-2 has a database list authority management unit M1 and a group management unit GM. This authority management unit M1 has setting change items such as “inquiry”, “change”, “add”, and “delete”. Further, the group management unit GM has setting change items of “group deletion” and “group addition”.

Here, FIG. 45 shows a plurality of databases created by the above-described database creation management system such as “company-owned car use management” and “company-owned car master” for the user access restriction to the database. As described above, it is possible to display a list of access restriction statuses on one screen and to perform centralized management such as addition / change of access restrictions.

45, for example, when the “safety confirmation ledger” holder is opened, “affiliation: information system headquarters”, “affiliation: information system headquarters> system development department> system development third team as a database of the contents of“ safety confirmation ledger ” ", Affiliation: Culture Department> Photo Department", etc. are displayed under "Safety Confirmation Ledger".

If you open the folder of the group name of each database and display the list of database names included in the group name, "Inquiry", "Change", "Add", A check box corresponding to a setting change item such as “delete” is displayed. In the “safety confirmation ledger” of the group database of FIG. 45, “affiliation: information system headquarters”, “affiliation: information system headquarters> system development department> system development third team”, “ Check boxes ch1b to ch4b are displayed on the right side of the names of databases such as “Affiliation: Culture Department> Photograph Department”.

In this case, since the check box ch1b of “Affiliation: Information System Headquarters” is checked, all users belonging to “Information System Headquarters” and below can inquire (view) “Safety Confirmation Ledger”, but check Since the boxes ch2b to ch4b are not checked, data cannot be added, changed or deleted.

In “Information System Headquarters> System Development Department> System Development 3rd Team”, check boxes ch2b to ch4b are checked, so only users belonging to “System Development 3rd Team” or lower can check “Safety Confirmation Ledger”. Can be added / changed / deleted.

In addition, when belonging to multiple groups among the set groups, access authority is set by logical sum for each authority (inquiry, change, addition, deletion) (inquiry authority is set) If you belong to any group, you have the query authority for WebDB).

(Other)
In the embodiment described above, an example in which the database creation management system for database creation and input according to the present invention is applied to the web server system 1 using the Internet is shown, but it is not necessarily limited to the web server system 1 using the Internet. The database creation management system of this invention is not applied. For example, the database creation management system according to the present invention can be applied to a server system using an intranet. Further, the database creation management system according to the invention can be used for a stand-alone computer in addition to a server system using the Internet or an intranet.

<Supplementary explanation 1>
As described above, the database creation management system according to the embodiment of the present invention includes a recording means (customer area server 14) in which database creation software for creating a database is recorded, and a display means for displaying the database creation screen 39. (Display devices 8 and 11). The database creation management system includes screen operation means (keyboard 4, mouse 5, display device 11) for operating a database creation screen displayed on the display means (display devices 8 and 11), and the database creation software. Computation control means (calculation control circuit (not shown) of the customer area server 14) that performs display control of the database creation screen 39 on the display means (display devices 8 and 11). Further, a screen creation area 40 for displaying data input sections (dB1 to dB7) to be created and a control display displaying a plurality of controls (42a to 53) used for creating the data input sections (dB1 to dB7). An input condition setting display area 43 for displaying an area (control icon bar 42) and a plurality of input condition setting sections (56 to 73, etc.) of the data input sections (dB1 to dB7) is displayed on the database creation screen 39 simultaneously. Calculation control means (calculation control circuit (not shown) of the customer area server 14) is provided. In addition, the calculation control means (the calculation control circuit (not shown) of the customer area server 14) is controlled by the database creation software to control the controls (42a to 53) in the control display area (control icon bar 42). By dragging and dropping to the creation area 40 with the screen operation means (keyboard 4, mouse 5, display device 11), the data input parts (dB1 to dB7) by the control are created in the screen creation area 40, and The input condition setting of the data input units (dB1 to dB7) created in the screen creation area 40 is set within one screen by the operation of the input condition setting unit (56 to 73, etc.).

According to this configuration, after creating the table for creating the database input screen form and setting the created table, use this created table to set the layout of the database input screen form Thus, there is no need to perform operations such as adding to this form. That is, it is possible to easily create a database input screen form with only one database creation screen 39 with almost no switching of a plurality of screens. Therefore, even when there is no basic knowledge of the database, the database can be easily constructed.
<Supplementary explanation 2>
In the database creation management system according to the embodiment of the present invention, a database created by the database creation software is recorded in the recording means (customer management server 14). According to this configuration, the created database can be used, and the database created with the database creation software is recorded in the same recording means (customer management server 14), so that the database input screen can be easily changed. it can.
<Supplementary explanation 3>
In the database creation management system according to the embodiment of the present invention, the input condition setting display area 43 includes at least an item name, a label, a selection content input part of a data entry part created in the screen creation area 40, Coordinate boxes (56, 57, 70 to 73, 76) are displayed as the input condition setting section.
According to this configuration, it is possible to easily create a database input screen form using only one database creation screen 39 with almost no switching of a plurality of screens. Therefore, even when there is no basic knowledge of the database, the database can be easily constructed.

<Supplementary explanation 4>
In the database creation management system according to the embodiment of the present invention, the calculation control means (keyboard 4, mouse 5 and display device 11) is constructed of data management software by the database construction software and data stored by the constructed data management software. A server system (Web server system 1) used for management, and the display means (display devices 8 and 11) are terminals (fixed terminals A and B) connected to the server system (Web server system 1) via communication means. , Mobile terminal C) display device (8, 11), and the screen operation means is the screen operation means (keyboard 4, mouse 5, display device 11) of the terminal (fixed terminals A, B, mobile terminal C). is there.

This configuration allows users to easily construct and use databases without database software.

<Supplementary explanation 5>
Furthermore, in the database creation management system according to the embodiment of the present invention, the communication means is online (line 2) or the Internet 2a or an intranet, and the terminal is online (line 2) or the server via the Internet 2a or intranet. A plurality of terminals (fixed terminals A and B, mobile terminal C) connected to the system (Web server system 1).

This configuration allows users to easily construct a database and use it for multiple users without database software.

<Supplementary explanation 6>
In the database creation management system according to the embodiment of the present invention, the computation control means (the computation control circuit (not shown) of the customer area server 14) includes the name of the created database, the contents of the access right to the database, and the A plurality of lists including an access right setting change unit are simultaneously displayed on the management screen of the display unit, and the setting change unit is operated by the screen operation unit, whereby the created plurality of databases are displayed. The access right setting change control is performed.

According to this configuration, it is possible to easily manage access rights for a plurality of created databases on a single screen.
Although the embodiments of the present invention have been described in detail with reference to the drawings, the embodiments are merely examples of the present invention, and the present invention is not limited only to the configurations of the embodiments. Needless to say, design changes and the like within a range not departing from the gist of the invention are included in the present invention.

Cross-reference of related applications

This application claims priority based on Japanese Patent Application No. 2011-242445 filed with the Japan Patent Office on November 4, 2011, the entire disclosure of which is fully incorporated herein by reference.

Claims

A recording means in which database creation software having a database creation screen is recorded;
Display means for displaying the database creation screen;
Screen operation means for operating a database creation screen displayed on the display means;
Screen creation area that displays the data input part to be created,
A control display area displaying a plurality of controls used to create the data input unit;
An input condition setting display area for displaying a plurality of input condition setting sections of the data input section is simultaneously displayed on the database creation screen, and the operation of the control display area is controlled by the database creation software. By dragging and dropping to the creation area by the screen operation means, the data input unit by the control is created in the screen creation area, and the input condition setting of the data input unit created in the screen creation area is set A database creation management system comprising arithmetic control means for performing setting control within one screen by operating an input condition setting unit.
2. The database creation management system according to claim 1, wherein a database created by the database creation software is recorded in the recording means.
The database creation management system according to claim 1, wherein the input condition setting display area includes at least an item name, a label, a selection content input part, and a coordinate box of the data input part created in the screen creation area. A database creation management system, wherein the database is displayed as the input condition setting unit.
The database creation management system according to claim 2 or 3, wherein the calculation control unit is a server system used for data management by construction of data management software by the database construction software and data management by the constructed data management software,
The database creation management system, wherein the display means is a display device of a terminal connected to the server system via a communication means, and the screen operation means is a screen operation means of the terminal.
5. The database creation management system according to claim 4, wherein the communication means is online or the Internet or an intranet, and the terminals are a plurality of terminals connected to the server system online or via the Internet or an intranet. A database creation management system.
5. The database creation management system according to claim 4, wherein the calculation control unit displays a plurality of lists including a name of the created database, contents of the access right of the database, and a setting change unit of the access right. The access right setting change control to the plurality of created databases is performed by simultaneously displaying on the management screen of the means and operating the setting change unit by the screen operation means. Database creation management system.