JPH0744577A - Data base table system - Google Patents

Abstract

PURPOSE:To provide a data base table system in which data base access information and a chart processing function can be set as the attribute information of a table, and the chart processing function can be executed by performing an access to the data base. CONSTITUTION:In the data base table system, the data base access information and operation description data normalizing the operation of the chart processing function are set as the table attribute information in a document preparation application, and the chart processing function is conducted to the data of a data base 17. This system is equipped with a chart function setting means 18 which sets the data base access information and the operation description data normalizing the operation of the chart processing function as the table attribute information, data base access procedure interpreting means 16 which interprets the data base access information, and performs an access to the data base 17, and chart function processing means 12 which interprets the operation description data, and conducts the chart processing function to the data from the data base 17.

Description

Detailed Description of the Invention

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a database table system, and more particularly, it sets the operation description data defining the access information of the database and the operation of the table processing function as the attribute information of the table in the document creating application, The present invention relates to a database table system capable of accessing a database by an interface function and executing a table processing function.

[0002]

2. Description of the Related Art Conventionally, as in the "dialogue processing composition system" proposed in Japanese Patent Application Laid-Open No. 2-266424, a system is provided with parts composed of visual data and behavioral description data of a database. There is known a dialogue processing system which combines these to synthesize a user interface operation program of a computer application system to facilitate the construction of the user interface.

In this interactive processing composition system, an interface component database section for providing a component composed of visual data and behavioral description data, an interface component editor section for describing the components of the interface component database section in combination, and An interface synthesis unit that synthesizes the dialogue processing unit based on the description of the interface component editor unit is provided. As a result, the interactive processing unit of the computer application system can be configured by a simple method of combining the parts.

Further, an interactive processing system for creating a prototype of a man-machine interface section of an interactive CAD system by graphic input, such as a "software prototype creation support device" proposed in Japanese Patent Laid-Open No. 254539/1990. Are known. The software prototype creation support device here individually registers the input graphic as a man / machine interface component (menus) of the interactive CAD system in the database, and operates according to the specified operation definition.
Realize the function as a prototype. Furthermore, the source code of the target system is converted and output.

[0005]

By the way, in the case of creating a user interface function panel of an application program in a dialogue processing system, for example, a part of the user interface function component is changed to create a plurality of user interface function panels. In the case of making a change in which the operations assigned to the parts are combined and integrated as a new function, it is necessary to change the source program of the original program of the interface part, compile it again, and link it with the application program body.
The change work is complicated, and there is a problem that work efficiency is poor.

[0006] When an application program including data operations for a relational database (RDB) is created, a database operation language (SQL: Structured Query Language) command statement is input in the spreadsheet program of the application program. There is a problem that work efficiency is poor because a program for executing a search and an update for the database must be created.

Further, in the case of using the data in the database in the document creation by the document creating application program, the data is once accessed from the database by the SQL command statement and the data is used by being copied. In any case, when using the data in the database, it is a function to make many users strongly aware of RDB by being aware of SQL.

Although an interactive processing system in which an SQL command statement is embedded in an interface component has been developed, the SQL command sentence must be embedded in the button function of the interface component in consideration of RDB.
There is a problem that the data in the database cannot be used easily and efficiently.

Therefore, if the database can be accessed by using the spreadsheet program or the table function in the ordinary document creation application program without being aware of the SQL command statement, the user will not be aware of the RDB and the table of the document creation processing will be performed. Since data management using a database can be performed among the functions, a database access function using such a table function is desired.

The present invention has been made to solve the above problems, and an object of the present invention is to provide access information of a database and operation of a table processing function as attribute information of a table in a document creation application. It is to provide a database table system capable of setting prescribed behavioral description data, accessing a database by a user interface function, and executing a table processing function.

[0011]

In order to achieve the above-mentioned object, the database table system, which is the first feature of the present invention, has the database access information and the operation of the table processing function as the table attribute information in the document creation application. Is a database table system that executes the table processing function for the data in the database by setting the behavior description data that specifies the above, and sets the database access information and the operation description data that specifies the operation of the table processing function in the table attribute information. Table function setting means (18: FIG. 1)
And a database access procedure interpreting means (16: FIG. 1) for interpreting the database access information and accessing the database, interpreting the behavioral description data with respect to the data from the database, and displaying the data with respect to the data. Table function processing means (12: FIG. 1) for executing a processing function is provided.

In the database table system according to the second aspect of the present invention, the table function processing means further comprises:
It is characterized in that it is equipped with a basic function of accessing a database as a part of the table attribute information as a user interface component.

According to a third aspect of the present invention, a database table system sets database access information and operation description data defining an operation of a table processing function as table attribute information in a document creation application, and the data in the database is set. A database table system for executing a table processing function for a document, and a database access specifying means (1) for specifying a table processing function and database access specifying data in a document creation application.
8: FIG. 1), a database operation language command is expanded from the database access designation data, and the database access procedure interpretation means for accessing the database (16: FIG. 1) and the database access designation data are passed to the database access procedure interpretation means. And a table function means (12: FIG. 1) for obtaining result data obtained by executing a search and an update with respect to the database by the database access procedure interpreting means and performing a table processing function on the result data. To do.

[0014]

In the database table system of the first feature of the present invention, the database access information and the operation description data defining the operation of the table processing function are set as the table attribute information in the document creating application. When the table processing function for the data in the database is executed, the table function setting means (18) sets the database access information and the operation description data defining the operation of the table processing function in the table attribute information. An interpretation means (16) interprets the database access information and performs access processing to the database. By this access processing, the table function processing means (12) interprets the behavioral description data for the access result data obtained from the database, and executes the table processing function for the data.

Further, in this case, in the database table system which is the second feature of the present invention, the table function processing means is further equipped with a basic function of accessing the database as a part of the table attribute information as a user interface component. Therefore, it is possible to easily perform the database operation in the table function of the document creation application by using each of these database basic functions.

In the database table system of the third aspect of the present invention, the database access designating means (18) designates the table processing function data and the database access designating data in the document creation application. A database access procedure interpreting means (16) expands a database operation language command from the database access designation data to access the database. Then, the table function means (12) passes the database access designation data to the database access procedure interpretation means, obtains the result data obtained by executing the search and update of the database by the database access procedure interpretation means, and obtains the result data. Perform table processing functions. Thus, by setting the database access information and the operation description data that defines the operation of the table processing function as the table attribute information in the document creating application, the data of the database can be directly stored in the table processing function of the document creating application. The table processing function for can be executed.

[0017]

DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS An embodiment of the present invention will be specifically described below with reference to the drawings. FIG. 1 is a block diagram showing a configuration of a main part of a database table system according to an embodiment of the present invention. In FIG. 1, 11 is a document creation software program main unit, 12 is a table function processing unit, 13 is an operating system, 14 is an input / output device control unit, 15 is an input / output device, 16 is a database access procedure interpretation unit, and 17 is a database. , 18 are database access designating parts.

As the input / output device 15, a CRT display as a display output device, a mouse as a pointing device, a keyboard as a character input device, etc. are used. The input / output device controller 14 is a driver that controls the input / output devices connected to the hardware devices of the system, and controls the input / output devices such as the CRT display, the mouse, and the keyboard. Operating system 1
3 provides a system environment in which application programs operate, and controls the entire system of hardware devices. The table function processing unit 12 includes a user interface function processing unit, controls interface components, and executes the document creation software program main unit 1
1 executes the table function process when 1 operates.

The database 17 stores the table data by the table function of the document creation application in the RDB.
Manage as element data of (relational database) table. This database may be a general database management system. This database 1
In FIG. 7, the database access procedure interpretation unit 16 interprets the database access information set as the attribute information of the table to access the designated database. That is, the database access designation unit 1
8, the database operation language command is expanded from the database access designation data set as the attribute information of the table, and the database access processing is performed.

The basic processing elements of the database table system according to the present embodiment are mainly composed of a document creation software program main body 11, a table function processing unit 12 for processing table functions therein, and table attribute information. It is composed of a database access designating unit 18 for setting database access information and a database access procedure interpreting unit 16 for expanding a SQL command statement by the database access information to access the database.

Document creation software program body 1
When the document creation application (program) is activated in 1, the table function processing unit is read into the system. When the database access information is set as the attribute information of the table function, the database access information to be set is input from the input / output device 15 via the input / output device control unit 14, the operating system 13 and the table function processing unit 12 to the database access designation unit. 1
8 and the database access information is stored in the database access designating unit 18.

When the user wants to access the specified database, the user specifies the database access by the table function by the input operation of the input / output device 15, and the document creation software program main body is generated according to the event information of the operation action. The section 11 issues a database access instruction to the table function processing section 12. Upon receiving this instruction, the table function processing unit 12 sends the database access information from the database access designating unit 18 to the database access procedure interpreting unit 1.
6, the database access procedure interpreting unit 16 searches and updates the database 17 according to the interpreted data, and outputs the result to the table function processing unit 12
Return to. The table function processing unit 12 executes the processing of the table function by using the result data of accessing the database as the data of each column (row) of the table.

Thus, as the attribute information of the table function which is a component of the document creation application (program), the basic function of database access (creating, searching,
By embedding a parameter that can be used for (addition, update), database exchange can be performed by the table function without paying attention to a complicated SQL command statement. Further, since the data can be poured from the database to the document which is being created and edited by the document creating application (program), it is possible to easily automatically create the document using the document in the database.

FIG. 2 is a diagram for explaining an example of database access information set as table attribute information when a document creation application edits a document in the database table system of this embodiment. Figure 2
21, 21 is a document edit window of the document creation application, 22 is a table created in the document being edited, 23 is a first property window for setting table properties, and 24 is database access information as table attribute information. Is a second sub-window for setting column properties, and 25 is a second sub-window for setting database data structure information as column attribute information.

The document edit window 21 of the document creation application is opened, the table 22 created in the document being edited is displayed, and the attribute information for the table function is set in this table 22. Therefore, in order to set the attribute information of the table, the first property window 23
And the table property information such as the table name, the number of rows and the number of columns of the table is set in the first property window 23. Further, as the table attribute information here, in the first property window 23,
Click the database access condition change button, and then the first subwindow (access condition change sheet)
24 is opened, and database access information is further set as a part of the table attribute information.

The database access information set by this first sub-window specifies the database name of the access target for the table here, and specifies the type of basic access function (creation, search, addition, update) of the database. , Specify by button selection and set. Further, at that time, access conditions are set. That is, here, the database name is designated as "MyRDB", the type of the basic access function is the "update" button, and the access condition is the update condition "number>1".
00 "is specified. When this update condition is satisfied,
Access for updating the data of the database is performed from the table function processing unit.

Further, as the attribute information of the table, the database access information is set for the attribute information for each column forming the table. Also in this case, the column property information is set by the second property window 25 for setting the column property information of the table, and the second sub-window (column access information sheet) 26 is set as a part of the column property information. Sets the data structure information for database access. Here, for the column for which the column name is set to "name", the data structure information of some of the database of the column attribute information includes the RDB item, internal column name, index, data format, character length, etc. Information is set.

As described above, as the initial value of the database access information set as the attribute information of the table, the table name RDBTable of the database name MyRDB.
On the other hand, the update of the database is specified, and the update condition is set to, for example, "number>100". Therefore, when this update condition is satisfied, the access process is performed on the database. Also, from the document creation application, the ExecTable (RDBTable
The database may be accessed according to the content specified by the database access information by directly executing the instruction e). The command from the document creation application may be used not only by the document creation script but also by performing a database access process by using a menu in the document as a trigger.

FIG. 2 shows the interlocking (correspondence) between the columns of the database table and the names of the tables and tables in the document of the document creation application. A column of each table is specified, a property sheet is displayed, and column information (column access information) can be set by this property sheet. When a database is created using the database access information set in this way, tables and columns in the database are created in the database corresponding to the internal column names set previously. This state is shown in FIG. Here, the information such as the data format set as the column access information is the information required when creating the table in the database.

FIG. 3 is a view for explaining an operation example of the main part when setting column access information in a table and creating the table in the database. As shown in FIG. 3, in the document edit window 21 of the document creation application, a table 22 is created in order to perform the table function processing, and database access information is set in the table 22. For example, as illustrated here:
The column access information sheet 31 sets the column access information for the column with the column name “name” in the table 22 as the internal column name “name1”, and the column with the column name “number” in the table 22. The column access information sheet 32 sets the column access information as the internal column name “number”. Then, in the access condition change sheet (24: FIG. 2) of the first sub-window for setting the attribute information of the table, when the “create” of the access basic function of the database is instructed, the database is changed by the function of the interface component (button) At 33, a database table 34 is created in the database with each internal column name as a column name.

Next, an example of the operation of operating the database by using the table function in the edited document thus created will be described. FIG. 4 is a diagram for explaining an operation example in the case of operating the database using the table function in the document. As shown in FIG. 4, the table 4 created in the document compilation window 21 of the document creation application
It is assumed that the database access information as described with reference to FIG. In this case, when data is added using the table function in the table 41 during document editing, the data is also added to the database table 42 of the database 33 correspondingly.

Next, the processing contents of the basic function of database access that can be set as the attribute information of the table will be described. The basic functions of database access (creating, searching, adding, deleting, updating) are equipped with the basic functions of accessing the database as user interface parts (button functions) as part of the table attribute information. Therefore, when the selection button displaying the function is clicked in the first sub-window for setting the table attribute information, the corresponding database access process is started.

Next, the processing of the basic function of database access will be described. FIG. 5 is a flowchart showing the processing flow of database creation. 6 is a flowchart showing a data update processing flow, FIG. 7 is a flowchart showing a data deletion processing flow, and FIG. 8 is a flowchart showing a data search processing flow. FIG. 9 is a flowchart showing the processing flow of data addition.

Next, the processing contents related to each basic function of these database accesses will be sequentially described.
First, the database creation process will be described with reference to the flowchart in FIG. 5. When the database creation process starts, first in step 51, the table name is acquired from the table property and the database name is acquired from the access condition change sheet. To get. Next, in step 52, the RD required for creating the database table is calculated from the column access information of each column of the table.
Get B item, internal column name, index, data format, character length. Next, in step 53, R
SQL command "CREATE T" for creating a DB table
"ABLE" is synthesized from the acquired information and issued, and a database table corresponding to the table in the document is created in the database.

Next, the data updating process of the database table will be described. Please refer to the flowchart of FIG. In the data update processing, when the data in the table in the document is updated and the data update processing in the database is started, first, the existence of the database table in which the data is to be updated is confirmed. Therefore, in step 61, it is determined whether or not the corresponding RDB table already exists. If the corresponding RDB table does not exist, the RDB table creation function is executed in step 62, and the process proceeds to step 63. If there is a corresponding RDB table, that is all that is required, and the process directly proceeds to step 63.

In step 63, the SQL DEL
By the ETE statement, the data on the RDB table side corresponding to the condition is deleted. Next, in step 64, column information is extracted from the table in the edited document, and in step 65, column information is extracted from the table in the edited document. Next, in step 66, an SQL INSERT statement is issued to the data of the fetched table to add a column to the RDB table. Then, in step 67, it is determined whether or not the update processing of all the column data is completed, and if the update processing of all the column data is not completed, the update processing for the next column data is performed.
Returning to step 65, the processing from step 65 is repeated. When it is possible to determine the end of update processing for all column data,
A series of data update processing ends.

Next, the data deletion processing of the database table will be described. Please refer to the flowchart of FIG. In the data deleting process, the data in the table in the document is deleted, and when the data deleting process in the database is started, first, in step 71, the condition of the data in the database to be deleted is taken out. That is, the condition of the target data to be deleted is taken out from the table property, and in the next step 72, the SQL DELETE statement is issued in accordance with the condition of the target data, and the process is ended.

Next, the data search process of the database table will be described. In the data search process, as shown in the flowchart of FIG. 8, the search is performed corresponding to the data in the table in the document. Therefore, when the data search process is started, first in step 81, the target data to be searched from the table property is searched. Take out the condition. Then, in the next step 82, S is set according to the condition of the target data.
A QL SELECT statement is issued, the search results are placed in the table in the edited document, and the process is terminated.

Next, the data addition processing of the database table will be described. Please refer to the flowchart of FIG. When the data addition process is started, first, in order to confirm the existence of the table of the database to which the data is added, in step 91, it is determined whether or not the corresponding RDB table already exists. If the corresponding RDB table does not exist, the RDB table creating function is executed in step 92, and the process proceeds to step 93. Also,
If the corresponding RDB table exists, that is all right, and the process directly proceeds to step 93.

In step 93, column information is extracted from the table in the edited document, and then in step 94.
At, column information is extracted from the table in the edited document. Next, in step 95, an SQL INSERT statement is issued to the data of the fetched table, and R
Add a column to the DB table. Then, in step 96, it is determined whether or not the addition processing for all the column data has been completed. If the addition processing for all the column data has not been completed, the addition processing for the next column data is performed, so that step 94 Then, the process from step 94 is repeated. When the end of the addition processing of all the column data can be determined, the series of data addition processing is ended.

Next, application examples and modification examples of the components in the database table system according to this embodiment will be described. (1) For the access condition of the database set in the sub-window as the attribute information of the table, the SQL command statement may be written as it is. (2) Also, the user name and password for accessing the database may be held as data of the database access information. (3) The actual update process of the database may be started from the script language prepared by the document creation program, or may be started by using the auxiliary menu of the document having the table or table. Such a configuration is also possible. (4) The database name and access method may be prepared as a preliminary system parameter so that the user who is creating the document is not aware of it. (5) When the internal column name used as the column name of the database table is not set, the first row of the table can be used as the column name. (6) If one column has multiple column names,
Data can be combined and flowed from a plurality of columns of a database table to a table column in one document, and various table functions in the document can be used.

[0042]

As described above, according to the database table system of the present invention, the basic function of database access (creation, search, addition, deletion,
By embedding a parameter that can use (update),
It is possible to provide a system capable of exchanging databases without being aware of complicated SQL command statements. Further, since the data can be poured from the database to the document, the document can be automatically created.

[Brief description of drawings]

FIG. 1 is a block diagram showing a configuration of a main part of a database table system according to an embodiment of the present invention,

FIG. 2 is a diagram illustrating an example of database access information set as table attribute information when a document is edited by a document creation application in the database table system of this embodiment;

FIG. 3 is a diagram illustrating an operation example of a main part when setting column access information in a table and creating the table in the database;

FIG. 4 is a diagram illustrating an operation example in the case of operating a database using a table function in a document,

FIG. 5 is a flowchart showing a processing flow of database creation,

FIG. 6 is a flowchart showing a processing flow of data update,

FIG. 7 is a flowchart showing a processing flow of data deletion,

FIG. 8 is a flowchart showing a processing flow of data search,

FIG. 9 is a flowchart showing a processing flow of data addition.

[Explanation of symbols]

11 ... Document creation software program main unit, 12 ...
Table function processing unit, 13 ... Operating system, 14 ... Input / output device control unit, 15 ... Input / output device, 16 ... Database access procedure interpretation unit, 17 ... Database, 18 ... Database access designation unit, 21
... document edit window, 22 ... table, 23 ... first property window, 24 ... first subwindow,
25 ... 2nd property window, 26 ... 2nd subwindow, 31, 32 ... Column access information sheet,
33 ... Database, 34 ... Database table, 4
1 ... table in edited document, 42 ... database table

Claims (3)

[Claims] 1. A database table system that sets database access information and operation description data that defines the operation of a table processing function as table attribute information in a document creation application, and executes the table processing function for database data. And table function setting means for setting database access information and operation description data defining the operation of the table processing function in the table attribute information, and database access procedure interpreting means for interpreting the database access information and accessing the database. A table function processing unit that interprets the behavioral description data for data from a database and executes a table processing function on the data. 2. The database table system according to claim 1, wherein the table function processing means is equipped with a basic function of accessing the database as a part of the table attribute information as a user interface component. . 3. A database table system that sets database access information and operation description data that defines the operation of a table processing function as table attribute information in a document creation application, and executes the table processing function for database data. A database access designating means for designating a table processing function and database access designating data in the document creation application; a database access procedure interpreting means for expanding a database operation language command from the database access designating data and accessing the database; The database access specification data is passed to the database access procedure interpreting means, and the database access procedure interpreting means obtains the result data of the search and update of the database, A database table system comprising a table function means for executing a table processing function.