JPS5854442A - Relational data base system - Google Patents

Abstract

PURPOSE:To simply add a command or command syntax requested by a user by previously recording a key ward for the command or command syntax in a system table. CONSTITUTION:If a user registers a key ward SQRT in a system together with a source program when no function including a square root (SQRT) is provided to a control system, the key ward SQRT is registered in a system table SYSTBL through buses 1', 2', 3' and, after compiling and linkage, the SQRT is stored in a file through buses 4', 5'. When an inquiry command is inputted, the SYSTBL checks th SQRT through buses 1, 2, 3 to analyse the sentence structure. The analysed result is sent to an execution planning part S through a bus 4 and the SQRT is loaded through buses 5, 6. While requesting to execute the SQRT to a user's program execution part I2, an execution part I1 executes inquiry processing through a bus 9.

Description

DETAILED DESCRIPTION OF THE INVENTION The present invention relates to a relational database system that allows users to easily add their own commands or command syntax to a command system handled by a relational database management system.

For example, a makeshift statement to a relational database is 1.

Get Item name enumeration F data collection Table name enumeration W &# r a Search conditions. The item name is 1.For example, employee name or salary.e19. For example, the table name is 69. Employee table. The search condition is, for example, that the salary is 10,000 yen or more. Such an inquiry is the simplest example, but in some cases there may be a request to know the maximum or minimum salary. If the command syntax for maximum value and minimum value is not provided in the language specifications of the relational database management system, MAX (maximum value) and MI
The keyword N (minimum value) had to be added to the language specification, and in the prior art, the management program of the management system had to be modified each time. Additionally, in general relational database systems, commands such as search, update, and addition are provided, but when a user requests a special request for adding a cloak, it is managed in the same way as adding 1&1s coin syntax. The present invention is based on the above considerations, and the program of the system must be modified.

9 relational databases that allow users to easily add commands or syntax required by users.
It is an object of the present invention to provide a relational database system and therefore a relational database system of the present invention that includes a database, a database, a cough database, and a database.
Table and access process to the above database mt
Data access section to do and entered: 2! The syntax analysis section of the command that parses the syntax of the command, and the execution plan section that outputs the entire execution result based on the syntax analysis result of the above-mentioned cloak syntax analysis section, and the execution result section of the execution result section The execution part to be executed, the process of distributing the name of the inputted knee blog 2m along with the necessary information and registering it in the stem table, and the creation of a haze de mosier corresponding to the user program, and the execution part that performs the outer ring. The connection Durham registration section, the load module creation section that creates the load module, and the load module 1 defined by the user.
A relational database system comprising a user program execution unit that executes a program, and a system table access unit that performs access processing to the system table, wherein the system table includes a The command or command syntax keyword is registered, as well as the program name defined by the user, its language type, the nine keywords given corresponding to the program, and whether the keyword is system-specific or user-defined. A key load e type is registered to indicate whether the

The parsing unit of the above 27th block is configured to read the system table management via the system table access unit and the data access unit, and perform the parsing based on this content. If it is necessary to execute a user-defined object/cage raid, configure the processing value II management for the user program execution WK.

The above needs program registration section stores the keywords and keyword types of the source program when a need program in source format is input.

Enter the language type and its program name in the above system.
In addition to requesting the process of writing to the table to the system table access department, request the above p-do module creation flsK to convert the Shoji source program 2m to the load module. configured.

11. The system table access department receives a request to access the system number-pull. The system is configured to access system tables through the data access section.

The above-mentioned need quadrature execution section is configured to execute a designated quadrature program upon receiving the processed value II tube. The present invention will be explained below with reference to the drawings.

In summary, one shot! The keyword of the IIIi command or the keyword of the command syntax is registered in advance in the system table (hereinafter referred to as 8YSTBL), and is referred to by the relational database management system when performing syntax analysis. 5Y
STBLK is a keyword.

Keyword type, language type and source program name are entered. The keyword type indicates whether it is unique to the relational database or defined by the user.Language type and Fi indicate what language the source program corresponding to the keyword is written in. This is Amano. The source program name indicates the source program that corresponds to the keyword. User-defined commands or commands
For syntax keywords, the language type and the following information are required, but for keywords unique to relational database management systems, the information below the language type is not required. When a user adds a command or registers the frame command syntax t8Y8TBL, the relational database management system will create a corresponding program? Compile and create an executable load module.

The relational database management system uses 8Y8 during parsing.
Referring to TBLt, the program tube defined by the kneader is executed using the entire execution plan and the predetermined tie setting.

The figure shows a block diagram of one embodiment of the present invention. In the figure, STA is a command analysis section, S is an execution planning section, and 11#'
i execution part, b is user program execution 1i1DA is data access 11 part, DB is relational database %UPRFi
Needs program registration section, 8A is 8YSTBL access section, LMA is loading/mineral creation section, CM is various compilers, LIB is various libraries, LM program loading/module meeting, respectively. ,...
...... indicates the order of l&gaki.

User program registration department UPRt! , When the program to be registered is input, it is registered in 8Y8TBL via the path ■', ■', 0', and the keyword is managed in the program.・
Module creation ffls Request LMA to create a load module ・Load module creation department LMAt!
, using the % seed compiler CM and library LIBt through the path ■'.

A load module crystal corresponding to the input source program is created and stored in a file via the path of the created load module LM tube nail.

Command syntax analysis IBsTA/fi, when a command is input, it reads 8Y8TBL through the paths ■, ■, ■, performs a syntax check based on this, and executes this check result through the path ■. The execution plan section S, which sends the plan sSK, is called a scheduler and generates the entire execution plan based on the result of the syntax check. When the execution planning unit S determines that a user-defined program is to be used, it notifies the user via the path (2) that the necessary load/module data should be stored in the memory (Kc+-). When you receive this notification tube.

Knee Zabu Four Grams Execution Club! Load onto the af/module LMt king page specified by three companies ◎ Execution total 1iis
s conveys the execution plan to the execution unit 1. The execution unit 11 is called an interpreter. ? If it is necessary to execute a program defined by KJ-- while processing an inquiry while accessing it.

Execution SM is a request for processing - first program execution part! ■Notify. 2-Zab cost Gutum execution s1 is also called an interpreter, and if the process falsifies the request name, executes the #bug load modifier @This II, must
Database DB through the path of ■, ■ depending on K? The data access section DAa is responsible for accessing the data, and is responsible for database access, exclusive control, and recovery control. ai clear. Population: Cheaple (prefecture name (Fl), male population (F2), female population (F3)
It has the following structure. What is the makeshift statement when calculating the standard deviation of the population for the entire country?

Get 5QRT (AVG (F2+F3)**
Z-AVG (F20F3)Water*Z) Fr Mouse Population Cheaple; becomes 0 In the above makeshift sentence, 5QRT represents the function Fr that takes the square root t.

AVG ((F20F3)**2) is the average tl of the square of (F2+F3)! eagle, I.

AVG (F2+P3)**2 represents the square of the average of ('F 2 +73).

Suppose that the function to take the square root (8QRT) t- is not provided in the management system. When the user registers the word 8QRT to the system along with the source program, the system operates according to the order of F. ◎That is, %
(Register 5QRT's one-party gram to 8Y8TBL with the path D'&■',■', then load the source program with the path qQ'*@', and store it in a file with C after linkage. 0 When the above makeshift command is input.

The system operates in the following order: ◇ 0) ■ Perform syntax analysis while checking that the 8Q R, T keywords have been added to 8Y8TBLK by the 0.00 pass.

(b) After that, the above result pipe is sent to the execution planning section S via the path (2).

Load the necessary user-defined load/reference data structure (8QRT) via the path f1@, @, and write it on the meeting data structure. Send the result tube 〇-Execution part! 1, it is performed via path 1 of the makeshift process tO1■ while requesting the 8QRT's execution manager knee program execution unit.

As is clear from the above explanation, according to the present invention, 3-
The command line that Ichizu demands! Addition of ydoe syntax 8YSTBLt in the database is added to the system database management system that utilizes it, and it is said that commands or command syntax requested by the user can be added with a simple operation. Effects can be obtained.

[Brief explanation of drawings]

The figure is a block diagram of one embodiment of the present invention. 8TA...Command analysis section, S...Execution planning section, D
A...Data access department, DB...Relational database, UPR...User program access department, SA...
・5Y8TBL access its, LMA...Lord Moji. -Line creation department, CM... various compilers, LIB...
Various libraries, LM...Load 11 pages. Patent Applicant: Fujitsu Limited Representative Patent Attorney Yotsube Kyotani

Claims (1)

[Scope of Claim] A database, nine system tables provided in the database, and a data access unit that performs access processing to the database. A command syntax analysis section that parses the syntax of an input command, an execution planning section that creates an execution result based on the syntax analysis result of the command syntax analysis section, and a processing pipe that executes according to the execution result of the scissors execution result section. an execution unit, a needs program registration unit that performs processing for registering the input user program name and all necessary information in the system table and creating a load module corresponding to the needs program; A load/module creation unit for creating load/minerals, a user program execution unit for executing the load/module defined by the kneader, and an access control unit for the above system table.
6. A relational database system with a system table access section. In the above system table, commands or command syntax keywords specific to the relational database system are registered, and the program name defined by Needer, its language type, and the keywords given corresponding to the program are registered. The keyword type that indicates whether the keyword is system-specific or user-defined is registered. The syntax analysis S of the above command is configured to read the system table 9 through the system table access unit and the data access unit, and perform the syntax analysis based on this content, and the execution unit: When it is necessary to execute a needs-defined object/module, the system is configured to issue a processing request to the user program execution section. When a needs program in source format is input to the a-zu program entry section, the keyword of the source program is the keyword Φ type. Enter the language type and its program name in the above system.
mmt to write to the table, request the above system table access department, and write the relevant source program Oa.
It is configured to request the conversion tube to the above-mentioned load/mine table creation department. System table access S#'i is configured to access the system table t via the data access section when there is an access request to the system table. The above-mentioned tool program execution IIl is a relational database system that is configured to execute a nine-load module designated as II & processing request nine.