JP2004341770A - Data management system and data management method - Google Patents

Abstract

<P>PROBLEM TO BE SOLVED: To provide a data management system and a data management method, allowing construction of a database even without expert knowledge related to the database, and allowing easy change and use of data stored in the database. <P>SOLUTION: By selecting cells 118 of Excel respectively allowing input of a data item name and individual data corresponding to the data item name, and inputting the individual data, a table can be produced in a database area 103b with one sheet of Excel as one data unit. <P>COPYRIGHT: (C)2005,JPO&NCIPI

Description

[0001]
TECHNICAL FIELD OF THE INVENTION
The present invention relates to a data management system or a data management method.
[0002]
[Prior art]
2. Description of the Related Art Conventionally, a data management system that converts data stored in a database into a format usable in a spreadsheet application and edits the data on the spreadsheet application has been proposed (for example, Patent Documents). 1).
[0003]
[Patent Document 1]
JP-A-8-36487 [0004]
[Problems to be solved by the invention]
However, in the conventional data management system, since necessary data is read out from a pre-established database and used for a spreadsheet application, it is necessary to store customer information and the like in the database in advance. , SQL, and other database languages, and specialized knowledge about databases.
[0005]
Therefore, the present invention provides a data management system and a data management system capable of constructing a database without any specialized knowledge about the database, and capable of easily changing and using data stored in the database. The aim is to provide a method.
[0006]
[Means for Solving the Problems]
In order to solve the above problems, the present invention is a data management system capable of managing data stored in a database in a spreadsheet application, wherein the spreadsheet application has a data item name and a data item name. By selecting cells for inputting the corresponding individual data and inputting the individual data, a table in the database can be edited with one sheet of the spreadsheet application as one data unit. Provided is a data management system characterized by adding a table editing function.
[0007]
As described above, by enabling the spreadsheet application to edit the table in the database, the database can be easily constructed without any specialized knowledge about the database.
[0008]
Further, a search function capable of searching a database is added to the spreadsheet application, and the search function generates a database language for searching for the keyword based on the input keyword, and searches the database. Thus, the database can be searched without knowing the database language such as SQL.
[0009]
Here, a list display function capable of displaying the specified or all of the individual data corresponding to the searched keyword in a list or specifying or all the individual data of the data unit corresponding to the searched keyword. Is added to the spreadsheet application so that search results can be used effectively.
[0010]
In addition, by adding an individual data change function that can change individual data in the database by changing individual data that is searched and displayed, the spreadsheet application can be used on the spreadsheet application. It is convenient because the data stored in the database can be changed.
[0011]
Here, the spreadsheet application is executable on the client computer, while the database is stored on the server computer, and the client computer and the server computer are communicably connected to each other via a network. By doing so, a database stored in a server computer can be used from a client computer located at a remote location, which is convenient.
[0012]
The present invention is also a data management method capable of managing data to be stored in a database in a spreadsheet application, and inputs a data item name and individual data corresponding to the data item name in the spreadsheet application. By selecting each cell and inputting the individual data, one sheet of the spreadsheet application can be used as one data unit to have a table editing process in which a table in the database can be edited. A featured data management method is provided.
[0013]
As described above, by allowing the spreadsheet application to edit the table stored in the database, the database can be constructed without any specialized knowledge about the database.
[0014]
In addition, the spreadsheet application has a search process for searching a database, and the search process generates a database language for searching the keyword based on the input keyword, and searches the database. By doing so, the database can be searched without any specialized knowledge about the database language.
[0015]
Then, a list display process in which a specified or all individual data of the data unit corresponding to the searched keyword can be displayed as a list in the spreadsheet application, and a specification or all of the data unit corresponding to the searched keyword can be performed. By having an individual display step in which individual data can be individually displayed for each data unit in a spreadsheet application, search results can be effectively utilized.
[0016]
Also, in the spreadsheet application, by changing the individual data that is searched and displayed, the individual data in the database can be changed by having an individual data change process, and stored in the database in the spreadsheet application. You can change what you have, which is convenient.
[0017]
The present invention is also a program for causing a computer to execute a process of managing data to be stored in a database in a spreadsheet application, wherein the program corresponds to a data item name and the data item name for the spreadsheet application. Select a cell for inputting individual data to be input, and input the individual data, thereby making it possible to edit a table in the database using one sheet of the spreadsheet application as one data unit. Provided is a program characterized by adding an editing function.
[0018]
Thus, by providing a program that can add a table editing function that can edit a database table to a spreadsheet application, such a function can be provided to an existing spreadsheet application. Can be add-in.
[0019]
In addition, a search function for searching a database is added to a spreadsheet application. This search function generates a database language for searching for a keyword based on an input keyword and searches the database. By doing so, a database can be searched without any specialized knowledge about the database language.
[0020]
Then, for the spreadsheet application, specifying a data unit corresponding to the searched keyword or a list display function capable of displaying all individual data in a list and specifying a data unit corresponding to the searched keyword Alternatively, a search result can be effectively utilized by adding an individual display function capable of displaying all individual data individually for each data unit.
[0021]
Also, by adding an individual data change function that allows individual data in the database to be changed by changing the individual data that is searched and displayed for the spreadsheet application, the database can be displayed on the spreadsheet application. It is convenient to change the data stored in.
[0022]
BEST MODE FOR CARRYING OUT THE INVENTION
FIG. 1 is a schematic configuration diagram of a data management system 100 according to the first embodiment of the present invention.
[0023]
The data management system 100 includes a personal computer 104 including a CPU 101, a main memory 102, and a hard disk 103, a display 105, a mouse 106, and a keyboard 107.
[0024]
The CPU 101 is a Central Processing Unit, and is a chip that executes programs and performs various calculations.
[0025]
The main memory 102 is a storage device for temporarily storing data.
[0026]
The hard disk 103 is an auxiliary storage device so that stored data is not erased even when the power is turned off.
[0027]
Here, the hard disk 103 includes a program area 103a in which an OS (Operating system) and various applications for operating a personal computer 104 including the CPU 101, the main memory 102, and the hard disk 103 are stored. It consists of.
[0028]
In this embodiment, a Microsoft Windows (registered trademark) OS is used as the OS.
[0029]
Here, the applications stored in the program area 103a include a database system program including a database management system and a database application for managing the database area 103b, an Excel program which is a spreadsheet application by Microsoft, and a personal computer. A data management system program for causing the computer 104 to function as the data management system 100 is stored.
[0030]
The database area 103b stores a table as a set of data units, and uses SQL as a database language.
[0031]
When a command to execute this Excel is issued to the CPU 101 via a GUI (Graphical User Interface) using a mouse 106 and a keyboard 107 as input devices, the CPU 101 causes the program area 103a of the hard disk 103 to be executed. Then, an Excel execution program is stored in the main memory 102, Excel is executed, and the Excel is displayed on the display 105.
[0032]
Here, a database creation button (not shown) is added to the Excel toolbar or menu bar by the data management system program stored in the program area 103a, and the database creation button is clicked with the mouse 106. Then, a database table edit selection screen is displayed, asking whether to create a new table in the database area 103b or to add a new data unit to a table already created in the database area 103b.
[0033]
Here, a case where a new data unit is added to a table already created in the database area 103b will be described as an example.
[0034]
Note that a data unit is data for each case constituting a table, and is a set of individual data corresponding to a data item name.
[0035]
When a new data unit is to be added to a table already created in the database area 103b, selecting a table to add a data unit opens a database creation screen 110 as shown in FIG. 2, for example. .
[0036]
Here, a table for creating a receipt was selected.
[0037]
The database creation screen 110 includes an item name input box 111 for inputting a data item name, an item name cell selection box 112 for selecting a cell for displaying the data item name input in the item name input box 111, and a data item name. A data cell selection box 113 for selecting a cell for inputting the corresponding individual data, a data type selection box 114 for selecting a format of the individual data to be input to the cell selected by the data cell selection box 113, which data item name corresponds A key value selection box 115 is provided for selecting whether the individual data to be used is a key value of a table in the database.
[0038]
In the item name input box 111, a character string serving as a data item name is input using the keyboard 107.
[0039]
In the item name cell selection box 112, a character string that specifies a cell on an Excel displaying a data item name is defined in advance, and the cell specified by the predetermined character string is designated by the mouse 106 or the keyboard 107. select.
[0040]
Here, in the present embodiment, regarding the position of the cell on the Excel displaying the data item name, the horizontal line is indicated by the initial letter of “ROW”, and the horizontal row is located to the right of the letters “R” and “R”. The number of the row from the top is indicated by a number, and the vertical column to the right of this number is “COLUMN”, and the vertical column is to the right of the letter “C” and “C”. The number of the column from the left is identified by a number.
[0041]
For example, when “R1C1” is selected in the item name selection box 112, the character string input to the item name input box 111 is displayed in the cell in the first column from the left of the first row from the top. .
[0042]
In the data cell selection box 113, similarly to the item name cell selection box 112, a character string that specifies a cell on Excel is set in advance, and the cell specified by the predetermined character string is designated by the mouse 106 or By selecting with the keyboard 107, a cell for inputting individual data corresponding to the data item name can be selected.
[0043]
In the data type selection box 114, the format of the individual data to be input to the cell selected by the data cell selection box 113 is selected from "character type", "date type", and "numeric type" using the mouse 106 or the keyboard 107. I do.
[0044]
Here, “date type” is selected when the individual data to be input to the cell selected by the data cell selection box 113 is a date, and “numeric type” is selected by the data cell selection box 113. Select when the individual data to be entered in the cell does not enter characters other than numbers such as quantity and unit price. Select "Character type" when other than "Date type" and "Numeric type". is there.
[0045]
As described above, by selecting the format of the individual data to be input to the cell selected by the data cell selection box 113, for example, when a character string other than a date is input to a cell in which “date type” is selected, When a character other than a number is input to a cell in which “numerical type” is selected, a character string, a graphic, a symbol, or the like indicating an error can be displayed.
[0046]
Note that when "character type" is selected, such an error display is not performed.
[0047]
In the key value selection box 115, it is possible to select which data item name is to be used as the key value of the database table by checking the key value selection box 115. Have been.
[0048]
Here, the “key value” refers to individual data used to specify one data unit from the tables configuring the database, and in the present embodiment, “key number” By checking the box, “customer”, “customer code”, “receipt No”, “issue date”, “item”, “quantity”, “unit price” and “ A data unit consisting of a set of individual data such as "amount" can be specified.
[0049]
Note that all of these item name input boxes 111, item name cell selection boxes 112, data cell selection boxes 113, data type selection boxes 114, and key value selection boxes 115 need to be specified when a new table is created. However, when adding individual data to an existing table, these information is already specified when the table is created, so this information must be specified again unless there is a need to change it. When the user clicks the completion button 116 with the mouse 106, an input sheet 117 as shown in FIG. 3 is displayed on the Excel.
[0050]
The individual data is input to a predetermined cell 118 of the input sheet 117 displayed on the Excel. For example, the name and the name of “customer” are described in the first row of the database creation screen 110 in the column B (column B). Since the input is to be made in the cell 118a (two columns), the name and the name of this “customer” are input into this cell 118a using the keyboard 107, and the save to database button (not shown) is clicked with the mouse 106 By doing so, it is additionally stored in the table of the database area 103b.
[0051]
A database search button (not shown) is added to the toolbar or menu bar of Excel by the data management system program stored in the program area 103a. When specified and executed, a list of already created table names is displayed in the database area 103b. When a table to be searched is selected from this list, a search keyword input as shown in FIG. A screen 119 is displayed on the Excel.
[0052]
Here, it is assumed that a table for creating a receipt is selected and search is performed.
[0053]
In the search keyword input screen 119, the data item name input to the item name input box 111 when the table selected for the search is created is displayed in the cell selected in the item name cell selection box 112.
[0054]
Then, by inputting a keyword into a cell corresponding to the data item name to be searched using a keyword from the cells selected in the data cell selection box 113, data having this keyword is selected from the selected table. Units have been made searchable.
[0055]
When a keyword is input and a search execution button (not shown) is clicked with the mouse 106, a data item selection screen 120 for selecting a data item name to be displayed on a screen displaying a search result is displayed. By checking the selection check input box 121 of the selection screen 120, the individual data corresponding to the checked data item name is displayed on the screen displaying the search result.
[0056]
Here, “AAAA” is used as a search keyword as a customer on the search keyword input screen 119, and “customer”, “customer code”, “receipt No”, “issue date” are displayed on the data item selection screen 120. , "Item", "quantity", "unit price", and "amount" were checked, and the search was executed.
[0057]
When the search is executed in this manner, the data management system program searches the database area 103b for a data unit including the search keyword input to the search keyword input screen 119 in accordance with the SQL language system. An SQL sentence is generated, and a data unit including this keyword is searched from the database area 103b.
[0058]
Here, as for the search results, for example, as in a search result list display sheet 122 shown in FIG. 4, a list is displayed on Excel such that individual data of one data unit is displayed in one row. You.
[0059]
Note that the data item name is displayed in the top row of Excel.
[0060]
Further, a specific line is specified using the mouse 106 or the keyboard 107 in the search result list display sheet 122, and the individual display button 123a of the display screen selection button 123 added to the Excel toolbar or menu bar is clicked with the mouse 106. By doing so, the selected data units are individually displayed on the individual display sheet 124 shown in FIG.
[0061]
In the display on the individual display sheet 124, the item names and the individual data are displayed in the cells specified on the database creation screen 110 described above.
[0062]
Then, in either the search result list display sheet 122 or the individual display sheet 124, the individual data is changed using the mouse 106 or the keyboard 107, and a save button (not shown) in the database is clicked with the mouse 106. This change is stored in the database area 103b.
[0063]
When returning from the individual display sheet 124 to the search result list display sheet 122, the list display button 123b of the display screen selection button 123 may be clicked with the mouse 106.
[0064]
In the present embodiment, an example is described in which a new data unit is added to a table that has already been created in the database area 103b. However, when a new table is created in the database area 103b, Excel is used. A database creation button (not shown) added to the toolbar or menu bar is designated and executed with the mouse 106 or the keyboard 107, and a new table is created in the database area 103b or a database is already created in the database area 103b. By selecting to create a new table in the database area 103b on the selection screen for adding a new data unit to the created table, an input box (not shown) for inputting a table name is displayed. Is displayed, enter an appropriate table name in this input box
[0065]
Then, when the input of the table name is completed, the database creation screen 110 is opened, and the item name input box 111, the item name cell selection box 112, the data cell selection box 113, the data type selection box 114, and the key value selection box 115 A new table is created in the database area 103b by inputting or selecting information, inputting individual data into predetermined cells 118 of the input sheet 117 shown in FIG. 3, and storing the data.
[0066]
FIG. 6 is a schematic configuration diagram of a data management system 200 according to the second embodiment of the present invention.
[0067]
The data management system 200 according to the present embodiment includes a database server 230, a client computer 231, and a network 232 connecting them.
[0068]
The database server 230, like the personal computer 104 according to the first embodiment, has a CPU 201, a main memory 202, and a hard disk 203. The hard disk 203 has at least a database area and a program area. The program area stores at least an OS, a database management system for managing the database area, and a database system program including a database application.
[0069]
Further, the client computer 231 includes a personal computer 304 having a CPU 301, a main memory 302, and a hard disk 303, a display 305, a mouse 306, and a keyboard 307, as in the data management system 100 of the first embodiment. The program area of the hard disk 303 stores at least an OS, an Excel, and a data management system program.
[0070]
The database server 230 and the client computer 231 are communicably connected to each other by a network 232.
[0071]
The data management system 200 configured as described above differs from the data management system 100 according to the first embodiment in that a database area is created in the database server 230, but uses the Excel in the client computer 231. Since the operation example of managing the data is the same as that of the first embodiment, the following description is omitted.
[0072]
【The invention's effect】
As described above, since the present invention is configured, a database can be constructed without any specialized knowledge about the database, and data stored in the database can be easily changed and used. A data management system and a data management method can be provided.
[Brief description of the drawings]
FIG. 1 is a schematic configuration diagram of a data management system 100 according to a first embodiment.
FIG. 2 is a schematic configuration diagram of a database creation screen 110.
FIG. 3 is a schematic configuration diagram of an input sheet 117 and a database area 103b.
FIG. 4 is a schematic configuration diagram of a search keyword input screen 119, a data item selection screen 120, and a search result list display sheet 122.
FIG. 5 is a schematic configuration diagram of a search result list display sheet 122 and an individual display sheet 124.
FIG. 6 is a schematic configuration diagram of a data management system 200 according to a second embodiment.
[Explanation of symbols]
100, 200 Data management system 101, 201, 301 CPU
102, 202, 203 Main memory 103, 203, 303 Hard disk 104, 304 Personal computer 105, 305 Display 106, 306 Mouse 107, 307 Keyboard 230 Database server 231 Client computer 232 Network

Claims (16)

A data management system capable of managing data stored in a database in a spreadsheet application,
In the spreadsheet application, select a cell for inputting a data item name and individual data corresponding to the data item name, and input the individual data, thereby saving one sheet of the spreadsheet application as one data A data management system, characterized by adding a table editing function for editing a table in the database as a unit. The spreadsheet application is provided with a search function for searching the database,
2. The data management system according to claim 1, wherein the search function generates a database language for searching for the keyword based on the input keyword and searches the database. 3. The spreadsheet application is provided with a list display function capable of displaying a specified or all of the individual data of the data unit corresponding to the searched keyword as a list. Item 3. The data management system according to Item 2. The spreadsheet application is provided with an individual display function capable of individually specifying the data unit corresponding to the searched keyword or displaying all the individual data individually for each data unit. The data management system according to claim 2 or 3, wherein 4. The spreadsheet application is provided with an individual data change function capable of changing the individual data in the database by changing the displayed individual data. 5. The data management system according to 4. The spreadsheet application is executable on a client computer, the database is stored on a server computer, and the client computer and the server computer can communicate with each other by being connected via a network. The data management system according to any one of claims 1 to 5, wherein: A data management method capable of managing data stored in a database in a spreadsheet application,
In the spreadsheet application, by selecting a data item name and a cell for inputting individual data corresponding to the data item name, and inputting the individual data, one sheet of the spreadsheet application is converted to one data unit. A data editing method comprising the step of editing a table in the database. The spreadsheet application has a search process that can search the database.
8. The data management method according to claim 7, wherein the searching step generates a database language for searching for the keyword based on the input keyword, and searches the database. 9. The spreadsheet application according to claim 8, further comprising a list display step of displaying a specified or all of the individual data of the data unit corresponding to the searched keyword as a list. Data management methods. The said spreadsheet application has an individual display process which can specify the said data unit corresponding to the searched keyword or all the individual data for each said data unit. 10. The data management method according to 8 or 9. The said spreadsheet application has the individual data change process which can change the said individual data in the said database by changing the said displayed individual data, The Claims 9 or 10 characterized by the above-mentioned. Data management method. A program for causing a computer to execute a process of managing data stored in a database in a spreadsheet application,
For the spreadsheet application, select a cell for inputting the data item name and the individual data corresponding to the data item name, and input the individual data, thereby connecting one sheet of the spreadsheet application to one sheet. A program for adding a table editing function for editing a table in the database as a data unit. For the spreadsheet application, add a search function that can search the database,
13. The program according to claim 12, wherein the search function generates a database language for searching for the keyword based on the input keyword, and searches the database. The spreadsheet application is provided with a list display function capable of displaying a specified or all of the individual data of the data unit corresponding to the searched keyword as a list. The program according to claim 13. The spreadsheet application is provided with an individual display function capable of individually specifying the data unit corresponding to the searched keyword or displaying all the individual data individually for each data unit. The program according to claim 13, wherein the program comprises: 15. The spreadsheet application is provided with an individual data change function capable of changing the individual data in the database by changing the displayed individual data. Or the program according to 15.

Images