JPH0331944A - Data base system - Google Patents

Abstract

PURPOSE:To make operations from an access start up to a necessary data display simple and smooth by inputting a user identification code, a secret code and the indication of access contents to be used in a batch in the operation at the time of the access start to a data base system. CONSTITUTION:The operations from the access start to the data base up to the data display are achieved by the input in a batch. Namely, a data base access start accepting part 7 is activated by executing an access start operation to the data base system with a keyboard KB, etc., by a user, and the input contents from the keyboard KB, etc., are accepted by an access start indication accepting means. The input contents are transferred to an access capable/ incapable deciding means, whether the access to the data base system is capable or not is decided based on access capable/incapable decision information held in an external storage part 4 by the data base system based on the user identification code and secret code contained in the input contents. Thus, the operations from the access start up to the access to be the goal smoothly and simply are executed.

Description

[Detailed Description of the Invention] [Field of Industrial Application] The present invention relates to a database system, and in particular to a user interface suitable for a database system composed of a plurality of workstations and personal computers connected via a network. Regarding.

[Background Art] In recent years, many shared database systems have been constructed in which multiple workstations and personal computers are connected via a network to share data. In such a database system,
Users can select the data they need from the many data provided.

You need to be able to view that data in a format that is convenient for you.

For example, relational database systems, which are most commonly used in workstation and personal computer databases, generally manage data in two-dimensional table units. When referencing the required data, you can select or project only the necessary records (table rows) or items (table columns) from each table, or select a certain table from two or more tables. Based on the data contained in the records in each table, it is possible to set conditions such as merging the records contained in each table.

In order to describe these, a database access language (typically SQL (Structure)
edQuery Language) is available. These methods allow users to refer to one or more tables in the form of a convenient virtual table (view) without changing the structure of the underlying data (tables). .

However, setting the above conditions is generally complicated.

Furthermore, since data can change from moment to moment, it is troublesome to set the above conditions each time for frequently accessed data, and it is also a waste of effort and time.

For this reason, many databases allow multiple access conditions to be registered, and when accessing the database, a name or bankin (hereinafter referred to as By simply specifying an access code (called an access code), complex database access can be easily performed.

In addition, in a shared database system, in order to protect data, it is possible to limit the users who can access each data. Therefore, when a user starts accessing a database, it is necessary to prove the user's identity to the database so that access can only be made if permission is granted. For this reason, many database systems deal with this by requiring the user to enter a different identifier or identification code and password character or code when starting access.

Therefore, when starting to access the database system, the first step is to enter the Wt code.
After entering the identification code, you will be asked to enter the PIN code. After entering the password, an operation command for the database must be entered. Of course, there may be cases where no password code is set, and in this case, input of the password code is not required.

As mentioned above, when using access contents that have been registered in advance, access to the database can be started by inputting a specific command to specify the access contents and the access code attached to the access contents. and the results will be displayed. If the user wishes to refer to the correspondence between registered access details and access codes, a list of correspondences will be displayed by inputting a specific command.

[Problem M to be Solved by the Invention] In the above-mentioned prior art, the operation at the start of access to the database system is a procedure of performing the following input in response to a request from the database system. Therefore, the operation is interrupted.

Additionally, special operations are required to use registered access details, and no consideration has been given to smooth operations, resulting in the problem that frequently used accesses cannot be quickly performed with simple operations. Ta.

An object of the present invention is to provide a user identification code in operation at the beginning of access to a database system.

The object of the present invention is to provide a database system that allows the user to input a password and instructions for the access content desired at once, thereby simplifying and smoothing operations from the start of access to the display of desired data. .

[Means for Solving the Problems] - In order to solve the above-mentioned aU, the present invention provides a system that uses different identification codes for each user when starting access to a shared database system that is commonly used by multiple users. and/or In a database system that allows you to access pre-registered access details by inputting an access code specifying the access details after inputting a PIN code, any of the above-mentioned pre-registered access details can be accessed. Provided is a database system characterized by having means for inputting an access code instruction specifying whether to use a user identification code and/or a password all at once.

As a means for collectively inputting each of the above instructions together with a user identification code and/or password, there is a means for accepting and accepting an instruction to start database access, and a means for inputting information in the input information, as shown in the first construction drawing. User identification code/PIN code (including letters, numbers, symbols, and other low-input codes)
By means of determining whether or not access is possible, and access designation instructions such as access codes in the input information,
Means for determining the content of the access instruction is provided as a database access start reception unit.

The above-mentioned means for inputting all at once includes: - a means for recognizing each input user identification code/PIN code and access code; and comparing each recognized code with information held by a database system; and means for determining.

In the database system of the present invention, preferably, means is provided for inputting an instruction for displaying a list of previously registered access details together with a user identification code and/or password.

Preferably, means is provided for inputting an instruction to replace a part of the access content that has been WTAed in advance as a character string combined with the access code together with the user identification code and/or the password.

Further, a means may be provided for inputting an instruction for outputting data obtained as a result of access to a specified printer as a character string combined with the access code, together with the user identification code and/or password. .

Also, an instruction for outputting the data obtained as a result of the access to a file to a local external storage device or a remote external storage device connected via a network, as a character string combined with the access code.

A means for inputting the user identification code and/or password together with the user identification code and/or password may be provided.

Preferably, means is provided for inputting an access code to the database and instructions for processing data obtained as a result of the access together with the user's identification code and/or password Z.

Furthermore, by storing the access code as a character string combined with the user identification code and/or PIN code in a magnetic card, etc., and reading the magnetic card into a magnetic card noder, etc., database access can be started and access can be controlled. It is also possible to provide a means for collectively operating the instructions.

The database system of the present invention configured as described above is applied to, for example, a workstation or a personal computer having the functions shown in FIG.

In this case, the access start reception unit 7 of the database system is attached to the input unit 1 that accepts operations such as a keyboard.

[Operation] With the above configuration, it is possible to process the input of the user identification code/password code and access code as a preprocess of the original database processing.

As a result, operations from the start of accessing the database to displaying data can be far-reaching through batch input.

That is, the database access start reception section is activated when a user performs an access start operation to the database system using a keyboard or the like, and input contents from the keyboard or the like are accepted by the access start instruction reception means. The input content is passed to the access permission determination means, based on the user identification code and password included in the input content.

Based on the access permission determination information held by the database system in the external storage unit 4 shown in FIG. 2, etc.

It is determined whether access to the database system is possible. If the user identification code and password Z are appropriate, access to the database system is possible.

Information instructing the access content, such as an access code included in the input content, is passed to the access instruction determination means shown in FIG.
It is determined whether the access instruction is appropriate or not based on the access content HtiA information for each user held in, for example.

If appropriate, the access content corresponding to the access code in the input content is extracted from the registered access content and passed to the database system. The database system performs data search processing based on the passed access details and displays the results.

(Margin below) 〔Example] Embodiments of the present invention will be described below with reference to the drawings.

[Configuration of Embodiment] FIG. 2 shows the system configuration of an embodiment of the database system according to the present invention.

This embodiment includes an input section 1 that connects a keyboard KE, pointing device MUS, etc. as input devices and inputs data, etc., an arithmetic section 2 that performs arithmetic processing based on the input data, and An internal memory 3 that stores and holds arithmetic processing data, an external storage unit 4 that connects a magnetic disk device such as EDD to hold data, a display unit 5 that displays a CRT display, etc., and a printer PRT.
The present invention is applied to a data processing apparatus such as a workstation or a personal computer, which is equipped with an output section 6 for printing out data and the like.

As shown in FIG. 1, in this embodiment, a database access start reception section (FIG. 2) consisting of an access start instruction reception means, an access permission determination means, and an access instruction determination means is connected to the data processing apparatus. It is attached to the input section 1 of the.

With such a configuration, various data of the database stored in the external storage unit 4 is retrieved to the internal memory 3 based on information and access instructions for starting database access inputted from the input unit 1, and the data is read out to the internal memory 3. In step 2, processing such as a search is performed based on the access content. The results are displayed by the display unit 5 on a display CRT or the like, and are outputted by the output unit 6 to a printer PRT or the like.

[Operation of the embodiment] Next, the operation of the embodiment configured as described above will be explained with reference to the drawings.

When a user starts accessing the database system, the database access start reception unit 7 shown in FIG. 2 is activated and, as shown in FIG. 3(a), the user is requested to input a user identification code. When the user presses the return key after inputting the user identification code, the user is requested to input the password and access code, as shown in FIG. 4(b). After inputting the access code simultaneously with the password, if the return key is input (FIG. 1(c)), the input is recognized as a password and an access code. After checking the password, access to the database is started based on the input access code ((d) in the same figure), and the access result is displayed ((e) in the same figure), and (c) in the same figure. In this case, echoing back of input data such as a password to the display screen is suppressed to maintain confidentiality. In addition, in FIG. 4B, if only the password is entered, the screen shifts to a user interface for performing the original database operations.

In addition, in FIG. 5A, in addition to inputting the user identification code and recovery key, the password code and access code can also be input at once. That is, even if a password and access code are input without being requested, the input will be accepted and access to the database can be started in the same way as above. In this case, between the input of the user identification code and the PIN code.

If you do not enter the recovery key, as shown in (f) in the same figure,
Same as above except all input data is echoed back to the display screen.

In the access result display shown in FIG. 2(s), the database access start reception unit shown in FIG. 2 is activated again and a new access code is input.

Access to the database is started based on the new access content ((g) in the same figure).

In the same figure (e), inputting only the restore key moves to the user interface that performs the original database operation,
Inputting the escape key terminates database access.

In the above operation, in the process of determining whether access is possible using the user identification code and password, and in the process of determining access instructions using the access code, the database access start reception unit takes in necessary information from the database system, Processing is done based on that.

Although the structure of each information differs depending on the database system used, a general data structure is shown in FIG. 4. FIG. b) is an example of data for access instruction determination processing.

The operation of the database access initiation reception unit described above will be explained with reference to the flowchart of FIG.

When a user starts accessing the database, the second
The database access start reception unit 7 in the figure is the input unit 1
It is activated from , requests the input of the user identification code on the display screen, and waits for the input (Sl).

When a user identification code is input, data for determining access permission is fetched from the database system and the input contents are checked (S2). If the entered content is correct, only the user identification code is entered, determine whether the user's PIN code has been set (33), and if so, enter the PIN code and access code on the display screen. It requests input and waits for input (S4). When input is received,
Check the input content (S5); if the password is correct, retrieve data for access instruction determination from the database system; check the access code (S6); if the access code is correct, enter the corresponding access content (S7) and tell the database system to take over the access contents (S7).
S), end.

In S6, if there is no access content, the process proceeds to the original operation of the database system (S9), and if an escape is input, the database access is terminated (S10).

If the access code is incorrect in S6, an error message is displayed (S11), and the process waits for an access code input request (S12).

In the input content check in S2, if the user identification code is correct and the input content includes a password code and an access code, the password code check in S5 is performed without waiting for the password code input.

If the input contents are checked in S2 and 85 and are not correct, the process waits for the user identification code input in S1 again. Further, in checking whether or not a password has been set in S3, if it has not been set, the process waits for an access code input request (S12).

After the database access process is performed by the database system and the access results are displayed on the display screen, the database access initiation reception unit is started again so that the user can access the database again. In this case, there is no need to input a user identification code or a password, so the process immediately waits for the access code 312 to be input.

According to this embodiment, the mode of the input procedure for access can be changed according to the operator's selection. That is,
For example, for items that are frequently used, the process from the start of access to the display of desired data can be achieved by batch input, and depending on the content of the access, interactive input can be performed as necessary.

[Modification 1 of the embodiment] Waiting for input of user identification code (Sl), waiting for input of password code (84), and waiting for input of access code (S12) in FIG.
, instead of inputting the access code, a specific character (for example, ?) is accepted and accepted, and when the character is determined in S6, a list of the access code and the access contents corresponding to it is displayed. (S13), thereby allowing the user to refer to the access code and its contents. In this embodiment, this can be realized by adding the process in S6 and newly adding S13 in the flowchart of FIG.

[Modification 2 of Embodiment] As shown in the example of access codes XY and XX in FIG. At the time of input, as shown in FIGS. 6(a) and (b).

By inputting a parameter value following the access code, specific characters in the access content are replaced with the input parameter value.

In this embodiment, 86 and 8 in the flowchart of FIG.
This can be realized by adding the processing in step 7.

[When inputting the modified three access codes of the embodiment, as shown in FIGS. 6(C) and (d), following the access code, specific characters (for example,
By allowing input of a character string starting with 〉), it becomes possible to switch the output light of the access result. The example in Figure 6(c) is 〉(Printer name), and the access result is output to the printer, and the example in Figure 6(d) is 〉(File name), which is a file containing the contents of the access result. This is a case where the file is created on an external storage device.

In this embodiment, after the processing of the database system is completed, the created access result data is passed to the output unit 6 or the external storage unit 4, instead of being normally passed to the display unit 5 shown in FIG. This can be achieved by switching.

[Other variations of the embodiment] In the above embodiment, the database access start reception unit 7
Although the database access start receiving section 7 is provided on the input section, the database access start reception section 7 may be provided on the database system main body side and control access operations via communication means.

[Configuration of Another Embodiment] Each of the embodiments described above is an example using a single processing device as shown in FIG. 2, but as shown in FIG. 7.

It can also be realized by a system configuration in which a plurality of processing devices shown in FIG. 2 are connected via a network.

That is, as shown in FIG. 8, the processing device has the same configuration as the processing device in FIG. 2! tA and B are provided with communication control units 8 and 8' for transmitting and receiving data by communication, and when processing device A uses the database of processing device B, data inputted by keyboard operation etc. on the processing device A side is provided. The input unit 1 accepts the data and transmits the data from the communication control unit 8 to the communication control unit 8', thereby making it possible to access the database of the processing device B. The data to be accessed is conversely received from the communication control section 8' to the communication control section 8, and the access result is obtained on the display section 5 on the processing device A side.

In the configuration shown in FIG. 8, (1) database processing is performed by processing device A and processing device B is used simply as a remote external storage device, or (2) database processing is performed by processing device B and processing device A is , used mainly for input/output control.

Two methods are generally considered.

In the case of (1) above, the database access start reception unit 7 in FIG. This can be realized by attaching it to the input section 1' of the processing device B, as shown in FIG.

That is, in the case of (1) above, the database access start receiving unit 7 on the processing device A side in FIG. Based on the data for access permission determination and access instruction determination obtained via the communication system 91 parts 8' and 8, the access content is created and passed to the database system on the processing device A side. After processing, the access The results are displayed on the 1 display unit 5 or the like.

On the other hand, in the case of (2) above, information input by keyboard operations on the processing device A side in FIG. The database access start reception unit 7' of the processing device B receives the input information and the external storage unit 4.
Based on the data for access permission determination and access instruction determination obtained from ', access contents are created and passed to the database system. The post-processing access result is passed to the display unit 5 of processing device A# via communication control units 8' and 8, and displayed.

In each of the above embodiments, preferably, the access designation instruction is stored in a magnetic card or the like as a character string combined with a user identification code and/or a PIN code, and the magnetic card is read into a magnetic card reader or the like. Means is provided for collectively manipulating the initiation of database access and instructions for access.

According to each of the above embodiments, operations from the start of access to the database system to the display of data can be performed simply and smoothly, and in particular, frequently used accesses can be performed quickly.

[Effects of the Invention] According to the database system according to the present invention, when a user starts accessing the database system using frequently used access contents, if desired, the user can access the database system together with a user identification code or a password. , access instructions for pre-registered access details can be input all at once, eliminating the hassle of inputting information in response to requests from the database system, and simplifying operations from the start of access to the desired access. This has the effect of being smooth and simple.

It also eliminates operational delays when inputting data while waiting for a response from the database system.

It is also possible to process user identification codes, passwords, and access instructions all at once, so when accessing a database via a network, the number of communications on the network can be reduced.
Another effect is that the speed at the start of access can be increased.

[Brief explanation of drawings]

FIG. 1 is a block diagram showing the configuration of a database access initiation reception unit necessary for realizing the database system of the present invention, and FIG. 2 is a block diagram showing the system configuration of a data processing device to which the present invention is applied. , FIG. 3 is a diagram showing the operation sequence at the start of database access according to the present invention, FIG. 4 is a diagram showing an example of a data structure used when implementing the present invention, and FIG.
FIG. 6 is a flowchart showing an embodiment of the processing of the access initiation reception unit, FIG. 6 is a diagram showing a modification of the embodiment according to the present invention, and FIGS. FIG. 1 is a block diagram showing the system configuration. Engineering...Input section, 2...Calculation section, 3...Internal memory, 4...External storage section, 5...Display section, 6...Output section, 7...Database access start Reception department, 8...
・Communication control unit, KB...Keyboard, MUS...Pointing device, CRT...Display, D
D...External storage device, RT printer, NW...Network, 81-S13...Each step of processing.

Claims (1)

[Claims] 1. A shared database commonly used by multiple users.
When starting to access the system, you can access the system by entering an identification code and/or password that is different for each user, and then entering an access code that specifies the access details that you have registered in advance. The database system is characterized by having a means for collectively inputting an access code instruction specifying which of the pre-registered access contents to be used together with a user identification code and/or a password. database system. 2. The above-mentioned means for inputting all at once includes means for recognizing the user identification code/PIN code and access code inputted at once for each code, and comparing each recognized code with information held by the database system. 2. The database according to claim 1, further comprising means for determining .
system. 3. An input means for inputting the password and an access code specifying the content of access to the database if the user identification code and password are registered, and the input user identification code and password are input into the database. - In a database system that includes a means for comparing and determining access permission determination information held by the system, and a means for comparing and determining an input access code with access content information held by the database system, each of the above codes means for monitoring whether or not a specific code has been input during the input of the code, and means for recognizing input before the specific code for each code in response to the input of the specific code, and detecting each recognized code. , a database system characterized by comparing information held by the database system and making a determination. 4. Equipped with an input means for inputting a user identification code and a password when a password is registered, and an access code specifying the content of access to the database, and a communication control means for transmitting and receiving data. In a database system constructed by connecting at least two information processing apparatuses through a communication means, a user identification code and a password input by one of the information processing apparatuses are input to at least one of the at least two information processing apparatuses. Start of database access, which consists of means for comparing the code with access permission determination information held by the database system and making a decision, and means for making a judgment by comparing the input access code with access content information held by the database system. A reception unit is provided, and the database access start reception unit includes means for monitoring whether or not a specific code has been input in the input of each of the above codes, and means for responding to the input of the above specific code,
A database system is provided with means for recognizing input before the specific code for each code, and each recognized code is compared with information held by the database system to make a determination.
system. 5. An information processing system comprising the database system according to claim 1, 2, 3 or 4.