JP2007226508A - Method of operating database engine received from web server at terminal connectable to network, and terminal - Google Patents

Abstract

<P>PROBLEM TO BE SOLVED: To provide a method of operating, at a terminal, a database engine downloaded from a Web server and a method of operating the terminal off-line. <P>SOLUTION: This method comprises a step where the terminal 30 writes argument data to a memory section 120 by an unauthorized thread of the database engine, a step of transmitting argument setting notification data to an authorized thread of the database engine permitted to access a storage section 130 by the unauthorized thread, a step of reading the argument data written into the memory section 120 by the authorized thread, a step of accessing the database stored in the storage section 130 by the authorized thread, executing a command of the database engine, and writing the execution result as a return value to the memory section 120, and a step of transmitting return value setting notification data to the unauthorized thread by the authorized thread. <P>COPYRIGHT: (C)2007,JPO&INPIT

Description

The present invention relates to a method and a terminal for operating a database engine received from a Web server in a terminal connectable to a network. In particular, the present invention relates to a method and a terminal for operating the database engine even when the network is disconnected.

Conventionally, a so-called We composed of a Web server and a terminal connected via a network
In the system b, various methods have been proposed to operate a database engine (details will be described later). For example, there is a method in which only a web browser is introduced into a terminal, and a necessary program is transmitted from the web server connected to the network to the terminal via the network for operation.

FIG. 9 is an example of a Web system configured for the above purpose. According to this method, the database server 10 that manages data includes a storage unit that stores the data, and accesses the data stored in the storage unit to manage search, insertion, deletion, update, and the like of the data. The data management program (database engine) to be executed is operated. The terminal 30 transmits, via the network 40, an application program including a business interface and a user interface program for displaying data and receiving an operation input by a user.
It is downloaded from the server 20 and operated at any time.

For example, an application program realized by JavaScript (registered trademark) is transmitted from the Web server 20 to the terminal 30, and the terminal 30 executes the application program in the Web browser, and the database server 10 via the Web server 20.
In cooperation with the above database engine, the entire system can function as a database application system.

Further, a method has been proposed in which the terminal 30 executes only the user interface program portion of the application program, and the web server 20 operates the business logic as the web application server.

In this case, the web application server accepts a request from the web browser of the terminal 30, operates the business logic, and connects to the database server 10 to access the database. The web application server is a database server 1
A web page representing the result set is configured based on the result set from 0 and transmitted to the terminal 30 as a web page response. The terminal 30 receives and displays a web page representing the result set by the web browser.

In this method, it is considered that an excessive operational load problem does not occur as in a so-called Fat Client type system in which application programs and the like are installed in the terminal 30 in advance. That is, it is not necessary to install the application program in the terminal 30 in advance, and updating is easy. Furthermore, the problem that the application program depends on the OS of the terminal 30 does not occur. In addition, the terminal 30 has a W
Since it can be realized with only an eb browser, there is also an advantage that the application program can be developed with only standard and open technology.

As a related technique, a technique has also been proposed in which an advertisement is read from the advertisement DB and embedded in a program that transmits the advertisement to the user terminal, and the program displays the advertisement even when the user terminal is not connected to the network. (Patent Document 1).

However, the technology disclosed in Patent Document 1 simply transmits a program in which advertisement data is embedded to a terminal and causes the server to execute the data search, insertion,
Data operations such as deletion and update cannot be performed on the terminal.

The background art of the present invention is disclosed in Non-Patent Document 1, for example.
JP 2002-24695 A DBMS Anatomy A well-understood relational database system Yukiichi Suzuki / Tetsuya Fujitsuka Shosuisha Co., Ltd. (February 21, 2005)

However, in the so-called Web system as described above, there is a new problem for operating the database engine on the terminal 30.

First, there is a problem that the terminal 30 cannot operate in the offline state. In the above-described Web system, the terminal 30 does not have the subset data that is part of the master data of the database managed by the database server 10 and the database engine that manages the subset data. Therefore, in the offline state, the terminal 3
0 cannot run business logic that needs to access the database.

Therefore, for example, the subset data may be downloaded from the database server 10 to the terminal 30 and stored in the hard disk device, and a database engine configured by a Java (registered trademark) applet or the like operating on the terminal 30 may be downloaded from the Web server 20. It is done.

However, in a normal operation, such a Java applet is deployed in the memory unit of the terminal 30 and operates, but access to a hard disk device or the like that is a local resource of the terminal 30 has certain restrictions. Such restrictions are considered necessary in order to protect data stored in the terminal 30 from computer viruses, cyber terrorism, and the like that have become another major problem in recent years.

For this reason, even if the terminal 30 downloads subset data, which is a part of master data, from the database server 10 via the network 40 and stores it in a storage unit such as a hard disk device, the Java applet downloaded from the Web server 20 Since the access to the stored subset data is restricted, the database cannot be operated after all.

Therefore, for example, it is conceivable to download a database engine constituted by a Java applet with an electronic signature that runs on the terminal 30 from the Web server 20 and download the subset data from the database server 10 to the terminal 30 and store it in the hard disk device.

However, a Java applet with an electronic signature itself is allowed to access a hard disk device or the like that is a local resource of the terminal 30, but even if a Java applet with an electronic signature is called from a script program downloaded from the Web server 20. Access to a hard disk device or the like that is a local resource of the terminal 30 is not permitted.

For this reason, it is assumed that a database engine configured by a Java applet with an electronic signature operating on the terminal 30 is downloaded from the Web server 20 and the subset data is downloaded from the database server 10 to the terminal 30 and stored in the hard disk device or the like. The script program downloaded from the Web server 20 is
Since access to the stored subset data is restricted, the database cannot be operated after all.

The present invention has been made in view of the above-described problems, and an object thereof is to provide a method for operating a database engine downloaded from a Web server 20 on a terminal 30.
Furthermore, it aims at providing the method of implement | achieving the database engine which can operate | move even if the terminal 30 is an offline state.

The present invention relates to a memory unit in which a terminal that can be connected to a Web server and a database server receives and expands a database engine that operates on a Web browser from the Web server, and at least a master of a database managed by the database server A storage unit that receives subset data as part of the data from the database server via the Web server and temporarily stores the subset data, and operates at least on a Web browser that performs user interface processing of the database Script program
Receiving from a server, and in accordance with the script program, invoking the database engine with an unauthenticated thread to set an argument in order to execute a command for operating the subset data stored in the storage unit, An unauthenticated thread writes out argument data representing the argument to the memory unit, and writes out the argument data by the non-authenticated thread to an authentication thread of a database engine that is permitted to access the storage unit Transmitting argument setting notification data; reading the argument data written to the memory unit by the authentication thread in response to receiving the argument setting notification data; and storing the authentication thread in accordance with the argument data The subset data stored in the Accessing and executing the command, writing the execution result to the memory unit as a return value, and sending return value setting notification data notifying the non-authentication thread of writing of the return value by the authentication thread; And the step of the non-authenticating thread returning the return value to the script program in response to receiving the return value setting notification data.

According to such a configuration of the present invention, a terminal that can be connected to a Web server and a database server receives a database engine that operates on a Web browser from the Web server and expands, and at least the database server includes A storage unit that receives subset data, which is a part of master data of the database being managed, from the database server via the Web server and temporarily stores the subset data, and at least performs user interface processing of the database In order to execute a command for operating the subset data stored in the storage unit in accordance with the script program, a script program operating on a Web browser to be executed is received from the Web server. The argument is set and called, and the unauthenticated thread writes the argument data representing the argument to the memory unit, and the permission to access the storage unit for writing the argument data by the unauthenticated thread is given. Argument setting notification data to be notified to the authentication thread of the database engine is transmitted, and in response to receiving the argument setting notification data, the authentication thread reads the argument data written to the memory unit, and according to the argument data, the The authentication thread accesses the subset data stored in the storage unit, executes the command, writes the execution result to the memory unit as a return value, and notifies the unauthenticated thread to write the return value by the authentication thread. Sends return value setting notification data and responds to reception of the return value setting notification data Has the effect that the non-authentication thread is capable of returning the return value to the script program.

As a result, in order for the terminal to execute a command for manipulating the subset data from the script program, the script program itself that operates in an unauthenticated thread calls the database engine, and the unauthenticated thread on the database engine side. As a result, it is possible to execute a database command that needs to access a local resource from the script program.

As a result, a database engine that operates on the Web browser of the terminal can be realized.

By applying the principle of the present invention, for example, in a Web system, subset data that is part of master data of a database managed by a database server and a database engine that manages the subset data can be downloaded to a terminal and operated. It becomes possible. Furthermore, even when the terminal is in an offline state, the terminal can operate business logic that needs to access the database. In the Web system, since the database engine operates on the Web browser, it can be designed with only standard and open technology.

  FIG. 10 is a diagram showing the configuration and effects of the present invention.

Further, according to the present invention, the user of the terminal determines whether or not to allow the authentication thread of the database to access the storage unit in response to the terminal receiving the database engine from the Web server for the first time. Displaying a screen for making an inquiry to the database engine, and in response to receiving an instruction to permit the access to the authentication thread by the user's operation, the storage unit for the authentication thread of the database engine And granting permission to access.

According to such a configuration of the present invention, the terminal sets the database engine to the We.
In response to the first reception from the server b, a screen for inquiring to the user of the terminal whether or not to allow access to the storage unit to the authentication thread of the database is displayed. Thus, in response to receiving an instruction to permit the access to the authentication thread, it is possible to give permission to access the storage unit to the authentication thread of the database engine.

As a result, the terminal only accepts the access permission to the storage unit from the user once for the authentication thread of the database engine at first, and then does not accept the user's permission again. Makes it possible to access the database.

Further, the present invention provides data requesting that the terminal transmit at least a part of master data managed by the database server from the database server by an authentication thread of the database engine at a predetermined reception timing. To the We
a subset transmitted to the server and the master thread managed by the database server via the Web server by the authentication thread of the database engine and stored in the storage unit Updating the data;
It is desirable to further include.

According to such a configuration, the web server sends data requesting that the terminal transmit at least a part of master data managed by the database server from the database server at a predetermined reception timing. It has the effect that it is possible to transmit and receive at least part of the master data managed by the database server via the Web server and update the subset data stored in the storage unit .

As a result, in order to maintain the consistency between the master data and the subset data, the terminal can store at least a part of the master data managed by the database server via the Web server at a predetermined reception timing. Download to the device,
The subset data stored in the storage unit can be updated.

Further, according to the present invention, at least a part of the subset data stored in the storage unit is transmitted to the database server via the Web server by the authentication thread of the database engine at a predetermined transmission timing. It is desirable to further include the step of transmitting.

According to such a configuration, at a predetermined transmission timing, the terminal uses the database engine authentication thread to at least partly store subset data stored in the storage unit via the Web server. This has the effect that it can be transmitted to the server.

Thus, in order to maintain consistency between the master data and the subset data,
At the predetermined transmission timing, the terminal reads at least a part of the subset data stored in the storage unit by the authentication thread of the database engine, uploads it to the database server, and stores the master data of the database server. It can be updated.

Further, according to the present invention, the terminal is updated by the database server at a predetermined reception timing after the previous reception timing among master data managed by the database server by an authentication thread of the database engine. A step of transmitting data requesting transmission of master data from the database server to the Web server, and the master data updated through the Web server by the authentication thread of the database engine; And updating the subset data stored in the storage unit.

According to such a configuration, at the predetermined reception timing, the terminal is updated by the database server after the previous reception timing among the master data managed by the database server by the authentication thread of the database engine. Data requesting that the master data be transmitted from the database server,
b, receiving the updated master data from the database server via the Web server by the authentication thread of the database engine, and updating the subset data stored in the storage unit It has the effect that it is possible.

As a result, if there is differential data that is master data updated by the database server after the previous reception timing, which should be downloaded from the database server via the Web server, it is downloaded to the terminal. The subset data stored in the storage unit can be updated.

As a result, the communication load on the network as a whole can be suppressed, and data can be downloaded efficiently.

In addition, the present invention provides the terminal that has received from the database server and stored in the storage unit by the authentication thread of the database engine at a predetermined transmission timing after the previous transmission timing. Preferably, the method further includes a step of transmitting the updated subset data to the database server via the Web server.

According to such a configuration, at a predetermined transmission timing, the terminal uses the authentication thread of the database engine to receive the database data from the database server and store it in the storage unit after the previous transmission timing. The subset data updated by the terminal can be transmitted to the database server via the Web server.

By this, when there is differential data that is subset data updated by the terminal since the previous transmission timing to be uploaded to the database server via the Web server, the authentication thread of the database engine The database of the database server can be updated by reading from the storage unit of the terminal and uploading it to the database server.

As a result, the network communication load as a whole can be suppressed, and data can be uploaded efficiently.

The present invention is a terminal that can be connected to a Web server and a database server, and that performs processing related to a database, and that receives a database engine that operates on a Web browser from the Web server and expands the memory unit, A storage unit that receives subset data that is part of master data of a database managed by the database server from the database server via the Web server and temporarily stores the subset data;
Means for receiving at least a script program operating on a web browser that performs user interface processing of the database from the web server, and executing a command for operating the subset data stored in the storage unit according to the script program Means for calling the database engine by setting an argument with an unauthenticated thread, means for writing the argument data representing the argument into the memory unit by the unauthenticated thread, and the argument data by the unauthenticated thread Means for transmitting argument setting notification data to notify the authentication thread of the database engine that has been given permission to access the storage unit, and in response to reception of the argument setting notification data, the authentication thread Written in the department Means for reading numerical data; means for accessing the subset data stored in the storage unit by the authentication thread according to the argument data; executing the command; and writing the execution result as a return value to the memory unit; and the authentication Means for transmitting return value setting notification data for notifying the unauthentic thread of writing of the return value by a thread; and in response to receiving the return value setting notification data, the non-authenticating thread responds to the script program. And a means for returning the return value.

According to such a configuration of the present invention, the terminal receives a database engine that operates on a web browser from the web server and expands it, and at least master data of a database managed by the database server A script that operates on at least a web browser that performs user interface processing of the database, and a storage unit that temporarily stores subset data that is a part of the database from the database server via the web server In order to receive a program from the Web server and execute a command for operating the subset data stored in the storage unit according to the script program, the database engine is called with an unauthenticated thread with an argument, Unauthenticated thread Argument setting notification data for the database engine to write argument data representing the argument to the memory unit, and to notify the authentication thread of the database engine that is permitted to access the storage unit to write the argument data by the unauthenticated thread In response to receiving the argument setting notification data, the authentication thread reads the argument data written in the memory unit, and the authentication thread stores the subset data stored in the storage unit according to the argument data. Access and execute the command, write the execution result to the memory unit as a return value, send return value setting notification data for notifying the unauthenticated thread to write the return value by the authentication thread, and return the return value In response to the reception of the setting notification data, the unauthenticated thread It has the effect that it is possible to return the return value to the beam.

  An example of a preferred embodiment according to the present invention will be described below based on the drawings.

[System functional configuration]
FIG. 1 is a block diagram showing a main configuration of each server and terminal constituting a computer system according to an example of a preferred embodiment of the present invention. The database server 10, the Web server 20, and the terminal 30 are connected via a network 40. There is no restriction | limiting in the number of these apparatuses, You may comprise by 1 or multiple.

The database server 10 manages the master data of the database, searches for data,
A database engine for managing insertion, deletion, update, etc. is provided. Further, at least a part of the master data is transmitted to the terminal 30 via the Web server 20 as necessary.

The Web server 20 transmits programs such as a user interface program in the terminal 30 and an application program (script 312) including business logic and a database engine (database applet 313) that manages a database on the terminal 30 to the terminal 30.

In this embodiment, the database server 10 and the Web server 20 are configured by different computers, but may be configured by the same computer.

In addition, the database engine (database applet 313) is the Web server 20
The database synchronization logic 21 communicates with the database server 10 at a predetermined timing.
Is synchronized with the subset data (database file 321) that is a part of the master data stored in the storage unit (cache 320) of the terminal 30.

The terminal 30 stores the subset data (database file 321) received as data necessary for the offline operation from the database server 10 in the cache 320 provided in the storage unit 130. Further, the terminal 30 executes an application program (script 312) and a database engine (database applet 313) received from the Web server 20 and operating on the Web browser 310, and dynamically displays the Web page 311 on the Web browser 310. Display / update.

A specific example of the script 312 is JavaScript. Specific examples of Web pages to be displayed include those configured with HTML, CSS, GIF, XML, and the like.

The application program (script 312) and the database engine (database applet 313) operate on the Web browser 310, and the OS and W of the terminal 30
It does not depend on the type of the eb browser 310.

Further, examples of a method in which the script 312 calls the database applet 313 include LiveConnect (registered trademark), ActiveX (registered trademark) scripting, and the like.

Based on the execution result data set returned by the database applet 313, the script 312 is based on JavaScript, DynamicHTML, DOM (Document
A Web page is dynamically generated or updated using Object Model) and reflected on the screen. The terminal 30 then accepts input from the user again and repeats the above process.

By such processing, the terminal 30 can use the database engine (database applet 313) on the terminal 30 even in the offline state, and can dynamically display the Web page.

[Configuration of each server and terminal]
FIG. 2 is a block diagram showing the configuration of the database server 10, the web server 20, and the terminal 30 according to an example of the preferred embodiment of the present invention. For example, in the database server 10, the control unit 110, the memory unit 120, the storage unit 130, the communication interface unit 140,
The input unit 150 and the display unit 160 are connected via a bus 170.

  Hereinafter, the database server 10 will be described.

The control unit 110 is an information calculation processing device that performs calculation and processing of information.
real Processing Unit). In addition, the control unit 110 controls the entire database server 10, reads various programs stored in the storage unit 130 as appropriate, develops them in the memory unit 120, and executes them, whereby the above hardware cooperates,
Various functions according to the present invention are realized.

The display unit 160 displays a screen for accepting data input to the user or displays a calculation result screen by the database server 10, and includes a cathode ray tube display device (CRT), a liquid crystal display device (LCD), and the like. Display devices.

The input unit 150 receives input from the user and includes a keyboard, a pointing device, and the like. The input unit 150 can be connected to the database server 10 directly or via an intervening I / O controller.

The communication interface unit 140 is a network adapter that enables the database server 10 to be connected to the Web server 20 and the terminal 30 via a dedicated network or a public network. The communication interface unit 140 includes a modem, a cable modem, and an Ethernet (registered trademark) adapter.

The memory unit 120 includes a local memory used in combination with the control unit 110 to execute a program. The storage unit 130 includes a large-capacity bulk memory and a cache memory used for efficiently searching the bulk memory. Memory unit 120 and storage unit 1
Computer readable media that implement 30 include those that are implemented electrically, magnetically, optically, or electromagnetically. More specifically, a semiconductor storage device, magnetic tape, flexible disk, random access memory (RAM), read only memory (ROM), CD-
An optical disk including a ROM, a CD-R / W, and a DVD is included.

  Further, the Web server 20 and the terminal 30 have the same configuration as the database server 10.

[Coordination of authentication thread and non-authentication thread]
FIG. 3 is a diagram showing a method of operating the database engine on the web browser of the terminal 30 in the system according to an example of the preferred embodiment of the present invention, in which the authentication thread and the non-authentication thread cooperate via the memory 316. is there.

The database applet 313 of the terminal 30 may be an applet permitted to access the storage unit 130 including the cache 320 of the terminal 30 by an authentication thread. For example, an applet authenticated by a third party by a digital signature It is. The database applet 313 is an application interface API (Application Pr) for calling the database engine 314 from the script 312.
and an interface 315, a memory 316 (data structures such as variables and queues), and a database engine 314.

Here, the database applet 313 operates with two types of threads: an unauthenticated thread 317 that cannot access local resources such as the cache 320, and an authenticated thread 318 that is allowed to access local resources.

The unauthenticated thread 317 is a thread generated by an operation such as a user's operation of the Web page 311 or a timer, and causes the script 312 to operate and the database applet 31.
3 API is called and executed.

The authentication thread 318 is a thread generated by the database applet 313, operates the database engine 314, and operates the database file 321. The non-authentication thread 317 and the authentication thread 318 cooperate via a memory 316 as will be described later with reference to FIG.

[Dynamic Web page display processing]
FIG. 4 is a flowchart showing dynamic Web page display processing in the system according to an example of the preferred embodiment of the present invention.

First, when an event occurs as the web browser 310 accepts an input operation by a user or executes business logic, the control unit 110 of the terminal 30 calls a corresponding script 312 (step S111).

Further, the control unit 110 of the terminal 30 generates a database command according to the script 312 (step S112), sets an argument, and calls the database engine (database applet 313) (step S113). More specifically, for example, a SQL Select statement is set as an argument to set the database engine (database applet 31).
Call the command of 3).

Next, the control unit 110 of the terminal 30 performs a database engine (database applet 3).
13) executes a database command based on the argument (step S114),
The database file 321 is operated (step S115).

When the result set as the execution result of the database command is obtained as a result of the operation of the database file 321 (step S116), the control unit 110 of the terminal 30 uses the script 312 to output from the database engine (database applet 313). The result set as a return value is read (step S117). In some cases, there may be no result set, in which case the return value NULL is returned to the script 312.

Next, the control unit 110 of the terminal 30 uses the script 312 to execute the database engine (
A Web page is dynamically generated and updated based on the result set read as a return value from the database applet 313) (step S118).

[Details of linking authentication and non-authentication threads]
FIG. 5 is a flowchart showing details of a method in which the authentication thread 318 and the non-authentication thread 317 cooperate via the memory 316 and execute the database command in the terminal 30 of the system according to an example of the preferred embodiment of the present invention. is there. The left side of the figure is an unauthenticated thread 317
The right side represents processing by the authentication thread 318.

First, the control unit 110 of the terminal 30 uses the script 312 to execute the database engine 3.
The API command 315 is called with an argument value set, and execution of the database command is started.

Next, the control unit 110 of the terminal 30 performs the unauthenticated thread 3 of the database applet 313.
The argument value of the API 315 thus set is acquired at 17 (step S211). Specifically, for example, dbms. An argument value of a command such as execute (“select (...)”) is acquired.

Next, the control unit 110 of the terminal 30 sets the argument data representing the argument value by writing to the memory 316 (memory unit 120) by the unauthenticated thread 317 (step S).
212), data (argument setting notification data) notifying that the setting of the argument value has been completed is transmitted to the authentication thread 318 (step S213), and a notification from the authentication thread 318 is awaited (step S214).

Next, the control unit 110 of the terminal 30 uses the non-authentication thread 317 to execute the authentication thread 318.
In response to receiving data (return value setting notification data) notifying that the setting of the return value has been completed (step S215), it is obtained by reading the return value from the memory 316 (memory unit 120), It is set as a return value of the API 315 (step S216).

On the other hand, the control unit 110 of the terminal 30 uses the authentication thread 318 to execute the non-authentication thread 317.
(Step S311).

Then, the control unit 110 of the terminal 30 acquires the argument value from the memory 316 (memory unit 120) in response to the reception of data notifying that the setting of the argument value is completed by the authentication thread 318 ( Step S312).

Next, the control unit 110 of the terminal 30 operates the database file 321 using the authentication thread 318 (step S313). More specifically, for example, a Select statement designated by the argument value is executed.

Next, the control unit 110 of the terminal 30 sets a return value to the memory 316 (memory unit 120) based on the operation result of the database file 321 by the authentication thread 318 (
In step S314), data (return value setting notification data) notifying that the setting of the return value has been completed is transmitted to the unauthenticated thread 317 (step S315).

In this way, the authentication thread 318 of the terminal 30 waits for a notification from the next non-authentication thread 317 and repeats the series of processes described above.

As described above, the control unit 110 of the terminal 30 includes the non-authentication thread 317 and the authentication thread 318.
Are linked via the memory 316 (memory unit 120), and the database command is executed in the terminal 30.

[Database synchronization processing]
FIG. 6 is a flowchart showing database synchronization processing in the system according to an example of the preferred embodiment of the present invention.

  First, the control unit 110 of the terminal 30 starts the synchronization process at a predetermined timing.

Here, the predetermined timing may be determined when the terminal 30 is activated or terminated, at a timing when a user operation is accepted, or may be determined regardless of the user operation. When offline, the synchronization process may be repeated several times.

If there is data to be uploaded to the database server 10 (step S41)
1) The control unit 110 of the terminal 30 reads the database file 321 from the storage unit 130 (step S412), and uploads the read database file 321 to the database server 10 via the Web server 20 (step S413).

Similarly, when there is data to be downloaded to the database server 10 (step S414), the control unit 110 of the terminal 30 sends the Web server 2
0, data is downloaded from the database server 10 (step S415).
). Further, the control unit 110 of the terminal 30 stores the downloaded data in the storage unit 130.
Is written out as a database file 321 (step S416).

The determination as to whether there is data to be uploaded or whether there is data to be downloaded may be made according to appropriately set rules, such as whether differential data has been generated or periodic maintenance.

[Authentication confirmation processing]
FIG. 7 is a flowchart showing a method for inquiring a user whether or not to allow the database engine (database applet 313) to access local resources.

First, in response to the first reception of the database engine (database applet 313) from the Web server 20, the control unit 110 of the terminal 30 sends the terminal 30 the database engine (database applet 313) the terminal. 30 storage units 1
An inquiry is made as to whether or not to grant access to a local resource such as 30 (step S
511).

FIG. 8 shows a database engine (database applet 3) for the user of the terminal 30.
It is a figure which shows an example of the screen for inquiring whether access to a local resource is permitted to 13). In this example, the database engine (database applet 313) “RemoteDB.jar” is inquired whether permission is granted.

Next, the control unit 110 of the terminal 30 performs the database engine (
In response to receiving an instruction to permit access to the local resource of the terminal 30 to the database applet 313), the database engine (database applet 3)
13) is given permission to access the storage unit (step S512).

Here, once the database engine (database applet 313) is permitted to access the local resources of the terminal 30 once by the user's operation, the thread that the database engine (database applet 313) generates thereafter is an authentication thread. Similarly, the access permission to the local resource of the terminal 30 is given.

Therefore, for example, when operating a business application applying the principle of the present invention,
At each terminal, if the user gives the database engine (database applet 313) access permission to the local resource of the terminal only once, the terminal operates as a terminal of the business application on the Web browser thereafter. It is possible to execute business applications using the database engine.

Thus, according to the present invention, in order to provide a terminal that can use an application with an unstoppable front service such as a POS system even in an offline state, a database engine that can be executed offline on the terminal side is provided. Can be provided.

As mentioned above, although embodiment of this invention was described, this invention is not restricted to embodiment mentioned above. The effects described in the embodiments of the present invention are only the most preferable effects resulting from the present invention, and the effects of the present invention are limited to those described in the embodiments of the present invention. is not.

It is a block diagram showing the main structures of each server and terminal which comprise the computer system concerning this invention. It is a block diagram which shows the structure of the database server 10, the web server 20, and the terminal 30 which concern on this invention. It is a figure which shows the method in which the authentication thread | sled and a non-authentication thread | sled cooperate through a memory in the system which concerns on this invention. It is a flowchart which shows the dynamic web page display process in the system which concerns on this invention. 5 is a flowchart showing details of a method in which an authentication thread and a non-authentication thread cooperate via a memory in the system according to the present invention. It is a flowchart which shows the database synchronization process in the system which concerns on this invention. 6 is a flowchart illustrating a method for inquiring a user whether to allow a database applet to access a local resource in the system according to the present invention. In the system according to the present invention, it is a diagram showing a screen for inquiring the user whether to allow the database applet access to local resources. It is a figure which shows the structural example of the Web system which concerns on a prior art. It is a figure which shows the structure and effect of this invention.

Explanation of symbols

10 database server, 20 Web server, 30 terminal, 110 control unit, 12
0 memory unit, 130 storage unit, 140 communication interface, 150 input unit, 16
0 display, 170 buses

Claims (7)

A memory unit that a terminal that can be connected to the Web server and the database server receives a database engine that operates on a Web browser from the Web server and expands it, and at least a part of master data of a database managed by the database server A storage unit that receives the subset data from the database server via the Web server and temporarily stores the subset data,
Receiving at least a script program operating on a web browser that performs user interface processing of the database from the web server;
In accordance with the script program, in order to execute a command for manipulating the subset data stored in the storage unit, calling the database engine with an unauthenticated thread, setting an argument;
Writing the argument data representing the argument by the unauthenticated thread to the memory unit;
Sending argument setting notification data to notify the authentication thread of the database engine that is permitted to access the storage unit to write the argument data by the unauthenticated thread;
In response to receiving the argument setting notification data, the authentication thread reads the argument data written to the memory unit;
According to the argument data, the authentication thread accesses the subset data stored in the storage unit to execute the command, and writes an execution result to the memory unit as a return value;
Sending return value setting notification data for notifying the unauthenticated thread of writing of the return value by the authentication thread;
A method in which the unauthenticated thread returns the return value to the script program in response to receiving the return value setting notification data. In response to first receiving the database engine from the web server, the terminal inquires of the user of the terminal whether or not to allow the database authentication thread to access the storage unit. A step of displaying a screen;
Further comprising: granting access to the storage unit to the authentication thread of the database engine in response to receiving an instruction to permit the access to the authentication thread by the user's operation. Item 2. The method according to Item 1. Data that requests that the terminal transmit at least a part of master data managed by the database server from the database server to the Web server by an authentication thread of the database engine at a predetermined reception timing. Sending, and
Receiving at least a part of master data managed by the database server via the web server by the authentication thread of the database engine, and updating subset data stored in the storage unit; The method according to claim 1 or 2, further comprising: At a predetermined transmission timing, the terminal uses the authentication thread of the database engine to transfer at least a part of the subset data stored in the storage unit to the Web
The method according to claim 1, further comprising transmitting to the database server via a server. At the predetermined reception timing, the database server stores the master data updated by the database server since the previous reception timing among the master data managed by the database server by the authentication thread of the database engine at a predetermined reception timing. Transmitting data requesting to be transmitted from the web server;
Receiving the updated master data from the database server via the Web server by the authentication thread of the database engine and updating the subset data stored in the storage unit. 3. A method according to claim 1 or claim 2. Subset data updated by the terminal since the previous transmission timing among subset data received from the database server and stored in the storage unit by an authentication thread of the database engine at a predetermined transmission timing, The web
6. The method according to claim 1, further comprising transmitting to the database server via a server. A terminal that can be connected to a Web server and a database server and that executes processing related to a database,
A memory unit that receives and expands a database engine that operates on a web browser from the web server, and at least subset data that is a part of master data of a database managed by the database server via the web server A storage unit that receives from the database server and temporarily stores the data;
Means for receiving at least a script program operating on a web browser that performs user interface processing of the database from the web server;
In accordance with the script program, in order to execute a command for operating the subset data stored in the storage unit, means for calling the database engine with an unauthenticated thread by setting an argument;
Means for writing argument data representing the argument by the unauthenticated thread to the memory unit;
Means for sending argument setting notification data for notifying the authentication thread of the database engine, which is permitted to access the storage unit, to write the argument data by the unauthenticated thread;
Means for reading the argument data written in the memory unit by the authentication thread in response to receiving the argument setting notification data;
Means for accessing the subset data stored in the storage unit by the authentication thread according to the argument data, executing the command, and writing an execution result to the memory unit as a return value;
Means for sending return value setting notification data for notifying the unauthenticated thread of writing of the return value by the authentication thread;
A terminal provided with means for the non-authenticated thread to return the return value to the script program in response to reception of the return value setting notification data.

Images