JP3671715B2 - Database session management method in WWW server client system and server client system using the same - Google Patents

Description

[0001]
BACKGROUND OF THE INVENTION
The present invention relates to a business system using WWW (World Wide Web), and more particularly to a database session management method in a WWW server / client system and a server / client system using the same.
[0002]
[Prior art]
With the spread of Internet-related technologies, the construction of a server-client system (also called a WWW application) that performs business processing with a Web browser on a client terminal by linking WWW, which is one of Internet-related technologies, and a database is popular. Has been done.
The mechanism of this WWW application is that when a user accesses a Web page with a Web browser, various programs called modularized component software are downloaded and run on the Web browser to perform business processing. Realize. It is also possible to operate the component software on the web server and return the processing result to the web browser. By using modularized and componentized component software in this way, the Web page becomes one application system.
[0003]
In addition, in the protocol HTTP (Hyper Text Transfer Protocol) used for sending and receiving information such as files between the web server and web browser, the connection is lost each time one page is read, so the application consists of multiple pages. Requires a device for grasping a series of HTTP accesses as being continuous. This is called session management.
This session management method is described in the special article (P.185-187) of the June 1998 issue of “Nikkei Open System” published by Nikkei BP.
In order to manage the session, a mechanism for grasping the state transition of the user is indispensable. There are two main mechanisms for grasping the state transition. There are a method for providing state transition on the client side and a method for managing state transition on the server side. Actually, it is rarely used alone and often used in combination.
[0004]
There are three methods for providing state transition on the client side.
(1). Embed in URL (Uniform Resource Locator).
(2). Embed in the Hidden field in the form.
(3). Use Cookie.
Either way, you must consider that there is a limit to the amount of information a client can have.
In the case of (1), the URL length is limited and is limited to 255 characters.
In the case of (2), when the Hidden field increases, there is a possibility that the memory on the browser side becomes insufficient.
In the case of (3), there is a limit to the information that can be stored in Cookie itself.
Even using only these client-side mechanisms, an application such as a refined search can be created, but an application that requires timeout processing cannot be created. For this reason, in many cases, the client side has only an ID for identifying the user, and the server side creates logic for managing the state transition.
[0005]
There are also three methods for managing state transitions on the server side.
(1). Make the process that manages the state transition resident.
(2). Save state transitions to the database.
(3). Save state transitions to a file.
Each difference is in processing speed and management method.
The process (1) has a high processing speed because the process for managing the state transition is resident in the memory, but is not suitable for a site where a large amount of access is expected. It is necessary to secure a memory on the assumption that the user performs the last process, and the memory is consumed regardless of whether the user executes the process. At the same time, the reserved memory reserved for the user is wasted until timeout processing is performed. Not suitable for applications that span many screens or sites that have tens of thousands of accesses per day.
[0006]
The processing speed of (2) is slower than (1) in that there is a database connection process that starts the CGI program each time it is accessed. However, since state transitions can be managed in a database, it is suitable for applications that span multiple screens and for sites that have a large amount of access.
(3) activates the CGI program each time it is accessed, as in (2). The processing speed is slower than (1) in that there is a file access overhead. For applications that span many screens, file management becomes complicated. However, it is suitable for small-scale use because it does not require a database and it is easy to create an application.
In addition, when building a WWW application that requires database access processing, session management with the database server is required in addition to session management with the Web server of the article.
[0007]
In general, when creating component software having a connection function with a database server, the component software is created in a form including a componentized function module for database connection. In this method, each business component software builds its own session with the database, so when the component software is downloaded on the web browser, it connects to the database, and queries, updates, etc. to the database Perform access processing. Then, when the process ends and transitions to another screen (when unloading from the web browser is triggered), disconnection processing from the database is performed.
[0008]
[Problems to be solved by the invention]
In the WWW application that is downloaded from the web server to the web browser and performs the access processing to the database server as described above, the method of building the component software by dividing the module for each business process is divided into modules. Although the download time of the component software is shortened by this, each component software performs the session connection, maintenance, and disconnection processing with the database, so the time for session connection and disconnection with the database increases. As a result, it takes time to display the screen, and the operability with the user is impaired.
Hereinafter, this problem will be described in detail with reference to specific examples.
[0009]
FIGS. 7 to 8 show a case in which, in the WWW application, the order data is registered by the order entry program, and then the order registration data is registered by referring to the data previously registered by the order inquiry program. In the figure, 1 is a WWW server, 2 is a client personal computer, and 3 is a database server (DB server).
First, as shown in FIG. 6, an order entry program (PG) is downloaded from the WWW server ((1) '). The downloaded program (order input PG) connects to the DB server via a line ((2) '). This connection line is temporarily named “Session 1”. The downloaded order entry PG performs processing such as updating the order data of the DB server ((3) '). In this case, in the PG, it is necessary to access the DB server using the connection line of “Session 1”.
[0010]
Next, as shown in FIG. 7, the PG of the order inquiry is downloaded from the WWW server (4). At this point, the order entry PG is discarded. The downloaded program (order inquiry PG) is connected to the DB server via a line ((5) '). This connection line is temporarily named “Session 2”. The downloaded order inquiry PG makes an inquiry to the order data of the DB server ((6) '). In this case, in the PG, it is necessary to access the DB server using the connection line of “Session 2”. This is because even if an attempt is made to access the DB server with the name of session 1, the order entry PG managing session 1 is discarded and cannot be used.
[0011]
Next, as shown in FIG. 8, the order input PG is downloaded from the WWW server ((7) '). At this point, the order inquiry PG is discarded. The downloaded program (order input PG) is connected to the DB server via a line ((8) '). This connection line is temporarily named “Session 3”. The downloaded order entry PG performs processing such as updating the order data of the DB server ((9) '). Also in this case, it is necessary to access the DB server using the connection line of “Session 3” in the PG. This is because even if an attempt is made to access the DB server with the name of session 1, the order entry PG managing session 1 cannot be used because it has been discarded, and the order inquiry PG has also been discarded. This is because the name of session 2 cannot be used.
[0012]
As mentioned above, although the module software download time is shortened by dividing the module, each component software performs session connection, maintenance, and disconnection processing with the database. The time for cutting increases, and as a result, it takes time to display the screen and the operability with the user is impaired.
An object of the present invention is to solve the above-mentioned problems in the prior art, and to quickly display a business processing screen on a Web browser in a WWW application, in a WWW server / client system. To provide a session management method and a server / client system using the same.
[0013]
[Means for Solving the Problems]
In order to achieve the above object, in the session management method according to the present invention, a session management program for managing a session with a database server is downloaded from a WWW server to a client, and the database server receives the session management program from the client. After the line connection is made by the session management program, various function programs are downloaded from the WWW server to the client, and the various function programs continuously use the connection line from the client, in the database server. Access to data corresponding to the various function programs is provided.
[0014]
Further, in the server / client system using the session management method according to the present invention, in the server / client system including the web server, the database server, and the client, the component that performs session management from the web server to the client. Means for downloading software A; means for connecting a line from the client to the database server by the component software A; and business processing components modularized for each business function from the web server to the client; Means for downloading the software group B and the business processing component / software group B from the client to the data corresponding to the business processing component / software group B in the database server; When Seth, characterized by having a means for access by using continuously the connection line from the client.
[0015]
Furthermore, in the server / client system according to the present invention, the component software that divides the display screen of the web browser on the client into two frames, and manages the session with the database server without displaying one frame. A is used, and the other frame displays a business processing screen of a plurality of business processing components / software group B.
That is, in the session management method according to the present invention, component software that always maintains a session with the database server and performs only services such as inquiry and update is created, and the handle is obtained from a plurality of business processing component software. It is designed to be shared.
[0016]
That is, when using the conventional method, when each program is downloaded, a connection to the DB server must be individually established. Here, if the previous screen (order input PG) is not discarded when the order inquiry PG is downloaded in (4) 'in FIG. 6, the name of "Session 1" is processed in the process (6)'. By specifying (handle), a correct connection is recognized, and DB data can be accessed. However, the fact that the previous screen is not discarded means that the display of the screen does not change, which is inconvenient in switching the screen depending on the work to be performed. Therefore, in the present invention, the screen display is divided into two in advance, half of the business screen is used, and the session management PG with the DB server is arranged in the other half.
[0017]
In an OS (Windows or the like), when all applications, services, and the like are activated, numbers that are always unique are automatically assigned to identify them. By using (sharing) this number, communication between other applications can be performed, and services such as use of functions and reference of values can be received. This number is also referred to as a handle, and the handles and their sharing in this description are intended to be synonymous.
In the present invention, component software that maintains a session with the database server is created and displayed on the Web browser so that the handle can be used from the start to the end of the sales management system that operates on the Web browser. For example, using an HTML FRAMESET tag to divide the screen into two upper and lower frames, component software having a session with the database server in one frame, and business processing of the sales management system in the other frame Each component software to perform is arranged.
[0018]
In this case, screen switching (URL transition on the web browser) occurs in the sales management system only on the frame side where the business processing component software is arranged. Therefore, the component software (for maintaining the session with the database server) placed in the other frame maintains the session until the Web browser is terminated. By sharing, session management steps with the database server can be reduced, and the time required for screen transition can be reduced.
[0019]
DETAILED DESCRIPTION OF THE INVENTION
Hereinafter, embodiments of the present invention will be described in detail based on preferred examples shown in the drawings.
FIGS. 1 to 4 relate to an embodiment of the present invention. In the WWW application, which was also used for explaining the problems of the prior art, after the order data is registered by the order input program, the order is received. An example is shown in which a task for registering ordering data is performed by referring to data registered in advance by an inquiry program. In the figure, 1 indicates a WWW server, 2 indicates a client personal computer, and 3 indicates a DB server.
6 to 8 is different from the prior art shown in FIGS. 6 to 8, the conventional technique does not share the connection to the DB server, whereas the technique according to the present embodiment shares the connection to the DB server. There is in point.
[0020]
The operation of the embodiment will be described below.
First, as shown in FIG. 1, the session management PG with the DB server is downloaded to the half of the screen (for example, the upper half) from the WWW server ((1)), and the downloaded program (session management PG) is Connect the line to the DB server ((2)). This connection line is temporarily named “Session 0”.
Next, as shown in FIG. 2, the order entry PG is downloaded from the WWW server to half of the screen (for example, the lower half) ((3)). The downloaded program (order input PG) performs processing such as updating the order data of the DB server ((4)). In this case, in the PG, the DB server is accessed using the connection line of “Session 0”.
[0021]
Similarly, as shown in FIG. 3, the order inquiry PG is downloaded to the half of the screen (for example, the lower half) from the WWW server ((5)). At this point, the order entry PG is discarded. The downloaded program (order inquiry PG) inquires about the order data of the DB server ((6)). In this case, in the PG, the DB server is accessed using the connection line of “Session 0”.
Furthermore, as shown in FIG. 4, the order entry PG is downloaded from the WWW server to half of the screen (for example, the lower half) (7). At this point, the order inquiry PG is discarded. The downloaded program (order input PG) performs processing such as updating the order data of the DB server ((8)). In this case, in the PG, the DB server is accessed using the connection line of “Session 0”.
[0022]
FIG. 5 shows a more specific example of the display screen of the web browser according to the embodiment, and the display screen of the web browser in FIG. 5 shows the display screen of the sales management business system.
The screen displayed on the Web browser is divided into two upper and lower frames (FRAME1 and FRAME2) using the HTML FRAMESET tag, and the component software that manages the session with the DB server is sold to FRAME1, and the other FRAME2 is sold. Component software corresponding to each business process of the management system (main menu screen process and each business process selected from the main menu screen, such as "order", "order", "purchase") is placed To do. However, since the component software itself that manages the session with the DB server does not require screen display, the frame size (height) is set to 0 in the frame definition, and the screen is displayed in the web browser. The entire system is used for displaying each business component software of the sales management business system.
[0023]
When the sales management business system is started from the web browser, first, the component software (object 1) corresponding to the session maintenance with the DB server and the component software (object 2) corresponding to the main menu screen are downloaded from the web server. It is activated. At this time, session connection processing with the DB server is performed by the object 1, and the main menu screen is displayed on the screen. Since the frame for component software that supports session maintenance with the DB server is defined as non-display, the screen displayed to the user is only the main menu screen.
[0024]
When there is a user process selection instruction from the main menu screen, the component software corresponding to the main menu screen is unloaded, the selected process, for example, the component software for the “order input” process is downloaded, and the screen switching ( URL transition on the web browser) occurs, and the business process screen of the “order input” process is displayed. At this time, the component software (for maintaining the session with the DB server) placed in the other frame keeps the session until the Web browser is terminated. Can be accessed with the DB server, and even if the component software for the "order entry" process is downloaded and a screen switch (URL transition on the Web browser) occurs, the session with the DB server Since the disconnection and reconnection processes are not executed, the time required for screen transition can be reduced.
[0025]
As described above in detail including specific examples, according to the above-described embodiment, the use of component software that maintains a DB connection on a Web browser can reduce waiting time at the time of screen transition, Database session management in a WWW server client system that can improve the operability and reduce the load on the server related to session construction, and can quickly switch the display of business processing screens in a Web browser in a WWW application A method and a server client system using the method can be realized.
[0026]
A typical example of the modularized and componentized component software technology is Active X control developed by Microsoft Corporation.
Moreover, the said Example shows an example of this invention, and it cannot be overemphasized that this invention should not be limited to this.
[0027]
【The invention's effect】
As described above in detail, according to the present invention, in the WWW application, the database session management method in the WWW server / client system capable of speedily performing the switching display of the business processing screen in the Web browser, and There is a remarkable effect that a server-client system using this can be realized.
[Brief description of the drawings]
FIG. 1 is an operation explanatory diagram (part 1) in a WWW application according to an embodiment of the present invention;
FIG. 2 is an operation explanatory diagram (part 2) in a WWW application according to an embodiment of the present invention;
FIG. 3 is an operation explanatory diagram (part 3) in the WWW application according to an embodiment of the present invention;
FIG. 4 is an operation explanatory diagram (4) in the WWW application according to an embodiment of the present invention;
FIG. 5 is a diagram illustrating a frame configuration example of a sales management business system according to the present embodiment.
FIG. 6 is an operation explanatory diagram (part 1) in a conventional WWW application.
FIG. 7 is an operation explanatory diagram (part 2) in a conventional WWW application.
FIG. 8 is an operation explanatory diagram (part 3) in a conventional WWW application.
[Explanation of symbols]
1 WWW server 2 Client PC 3 DB server (1), (3), (5), (7) PG download from WWW server (2) Line connection to DB server (4), (6), (8) ▼ Access to DB

Claims (3)

A session management method in a WWW server client system that performs access processing from a client to a database server using a Web browser,
By the Web browser in the client from the WWW server, operating in the first frame of the Web browser to download the session management program for session management between the database server,
After starting the session management program in the first frame of the Web browser and connecting the line from the client to the database server by the session management program,
Various function programs that operate in the second frame of the Web browser and access data in the database server are downloaded from the WWW server to the client by the Web browser ;
The various function programs are sequentially activated in the second frame of the Web browser, and the various function programs are continuously connected to the line connected by the session management program activated from the client in the first frame. And a session management method in a WWW server client system, wherein the data corresponding to the various function programs in the database server is accessed. In a server / client system consisting of a Web server, database server, and client,
Means for downloading component software A that operates in the first frame of the Web browser from the Web server to the client and performs session management with the database server ;
Means for activating the component software A in the first frame of the Web browser and connecting the line from the client to the database server by the component software A;
Business processing component software group B that is modularized for each business function that operates in the second frame of the Web browser from the Web server to the client and accesses data in the database server A means of downloading
When accessing data in which the business processing component software group B sequentially activated in the second frame of the Web browser corresponding to the business processing component software group B in the pre Kide database server, the Web And a means for continuously accessing the line connected by the component software A activated in the first frame of the browser . Server-client system according to claim 2, wherein the first frame of the Web browser, wherein the non-display and to Rukoto on the client.

Images