JP5265476B2 - Data processing device between document object and schema definition - Google Patents

Description

  The present invention relates to an apparatus for accessing, in a database description language (SQL), data stored in a document object format storage area held by a Web browser.

With the widespread use of Web services, there is an increasing need for storing information related to user Web page browsing and using it for various Web services. This storage function is provided as a function of a Web browser, and cookies are generally used. However, cookies can only store several kilobytes (KB) of data, and the capacity is insufficient to realize more advanced services.
On the other hand, as a new HTML specification, a method of storing in an area called DOMStorage has been proposed, and this DOMStorage can store data with a capacity of several megabytes (MB).

  By using DOMStorage, which is a large-capacity storage area, various services can be developed using information for each user.

  Conventionally, a technique for handling a database in a document description language such as XML has been proposed (see, for example, Patent Document 1), but the opposite is the case, such as DOMStorage for handling a document described in a document description language such as XML or HTML. No method has been proposed for handling character string data in a database description language such as SQL.

JP-T-2004-519755

  However, in order to handle character string data such as DOMStorage in a database description language such as SQL, it is necessary to add an information structure of data that can be handled by each program, so for each character string data There is a problem that the processing defined in the program is necessary, the program becomes complicated, and the database cannot be easily created.

  Therefore, an object of the present invention is to provide a technique for defining and utilizing a schema as a database so that data described using only a character string such as DOMStorage can be easily handled in a database description language such as SQL. And

  In order to solve the above-described problems, the present invention is configured as follows.

(1) One aspect of the present invention is a data processing apparatus for using, as a database, a document object type storage area that stores only character strings.
Web browser processing means for performing processing for displaying the Web page on the terminal screen;
Script language processing means that is executed in the web browser processing means and executes a script program written in a script language in the web page;
Program data structure / character string that is executed in the script language processing means and performs processing for converting program data described in the script program into a representation of both program data structure and data as character string data Data conversion processing means;
Character string data / program data structure conversion processing means for converting the character string data converted by the program data structure / character string data conversion processing means into a program data structure executed in the script language processing means It is characterized by that.

  According to such a data processing apparatus, data stored in a document object type storage area held by a Web browser can be processed in a format having a SQL language schema structure, and data management is facilitated. Become.

(2) Another aspect of the present invention, comprising the database processing unit for processing the descriptions of the programs written data structure in said script program describing the processing by the database description language including steaming crypto program The data processing device according to (1) is characterized in that

(3) A data processing apparatus for using a document object type storage area that stores only character strings as a database,
A web browser processing step for performing processing for displaying the web page on the terminal screen;
A script language processing step that is executed in the Web browser processing step and executes a script program written in a script language in the Web page;
A program data structure / character string that is executed in the script language processing step and performs processing for converting the program data described in the script program into a representation of both the program data structure and the data as character string data A data conversion process step;
A character string data / program data structure conversion processing step for converting the character string data converted in the program data structure / character string data conversion processing step into a program data structure executed in the script language processing step. A data processing method.

(4) A data processing apparatus for using a document object type storage area that stores only character strings as a database,
A web browser processing step for performing processing for displaying the web page on the terminal screen;
A script language processing step that is executed in the Web browser processing step and executes a script program written in a script language in the Web page;
A program data structure / character string that is executed in the script language processing step and performs processing for converting the program data described in the script program into a representation of both the program data structure and the data as character string data A data conversion process step;
A character string data / program data structure conversion processing step for converting the character string data converted in the program data structure / character string data conversion processing step into a program data structure executed in the script language processing step. A data processing program characterized by that.

According to the document object / schema definition data processing apparatus of the present invention, in DOMStorage that can store only character strings, a data structure can be freely configured and accessed by an SQL command that is a database description language, and a tree can be accessed. Data stored in DOMStorage that can describe only the structure can be handled using SQL like a database, and Web system programming can be facilitated.

It is a figure which shows the structural example of the data processing apparatus between the document object schema definition concerning one Embodiment of this invention. It is a figure which shows the example of a database produced. It is a figure which shows the example of description of JSON. It is a figure which shows the example of a database produced. It is a figure which shows the structure which represented the characteristic of this invention notionally. It is a figure which shows the flowchart which shows the process example of this embodiment.

  Next, modes for carrying out the present invention (referred to as “embodiments”) will be described with reference to the drawings. It should be noted that assumptions common to those already described in the background art and problems are omitted as appropriate.

[overall structure]
FIG. 1 shows a configuration example of a system according to an embodiment of the present invention.

  The user terminal device 2 is configured as an application on a Web browser of the user terminal, and is connected to a plurality of Web application servers 3 via a network 1 such as the Internet.

  The user terminal device 2 includes a CPU (Central Processing Unit) constituting a control unit, a ROM (Read Only Memory) and RAM (Random Access Memory) constituting a storage unit, and a communication I / F (interface) constituting a communication unit. It is realized by a computer program executed on hardware resources such as.

  The user terminal device 2 includes a Web browser processing unit 21, a script language processing unit 22, a program data structure / character string data conversion processing unit 23, a character string data / program data structure conversion processing unit 24, a database language processing unit 25, a storage It comprises means 26 and browser storage area 51.

  The Web browser processing means 21 requests, obtains, displays, and transmits form data of page data described in a language such as HTML (Hyper Text Markup Language) according to HTTP (Hyper Text Transfer Protocol) that is a standard protocol of the Internet. It is realized by Web browser software such as Internet Explorer or Mozilla Firefox (registered trademark).

  The script language processing unit 22 is one of the functions provided by the Web browser processing unit 21 and processes a script language (JavaScript or the like) described in HTML.

  Program data structure / character string data conversion processing means 23 converts data having structure information of data described in a programming language such as JavaScript into data described only by character string data without structure information. Process. The converted character string data is expressed in, for example, JSON (JavaScript Object Notation) format.

  The character string data / program data structure conversion processing unit 24 performs a conversion process opposite to the program data structure / character string data conversion processing unit 23, and describes data described only by the character string data in a program language. The data is converted into data having the structure information.

  The database language processing means 25 processes a language for describing database definitions, operations, and control functions, for example, SQL (Structured Query Language).

  The storage means 26 is processed in accordance with instructions in the program language, and stores the character string data converted by the program data structure / character string data conversion processing means 23 in the browser storage area 51. This storage means 26 is described by, for example, JavaScript. Details will be described later.

  On the other hand, the application server 3 transmits a page written in HTML or a program written in JavaScript to the user terminal device 2, or receives document data from the user terminal device 2 via the Internet 1.

  The application server 3 includes content transmission means 31, character string data reception means 32, character string data / program data structure conversion processing means 33, database language processing means 34, and database 52.

  The application server 3 is configured by a computer (single or plural) including a control unit, a storage unit, and the like. Specifically, the CPU that constitutes the control unit, the ROM, RAM, and HDD (Hard Disc Drive) that constitute the storage unit, the communication I / F (interface) that constitutes the communication unit, the display device that constitutes the display unit, and the input It is composed of hardware resources such as an input device such as a keyboard and a mouse constituting the unit.

  Each unit included in the application server 3 is realized by a computer program executed on hardware resources such as a control unit and a storage unit of the computer described above. Note that these means do not need to be arranged on a single computer, and may be distributed as necessary.

  In addition, although the database 52 referred to by the application server 3 is provided, these databases systematically hold predetermined data on a storage medium such as an HDD in a computer that holds each database.

  The content transmission unit 31 transmits a document file described in HTML to the user terminal device 2. This HTML includes a program written in a script language such as JavaScript.

  The character string data receiving unit 32 performs a process of receiving data converted into a character string by the program data structure / character string data conversion processing unit 23 in the user terminal device 2.

  The character string data / program data structure conversion processing means 33 performs processing for converting the character string data received by the character string data receiving means 32 into a format including program data structure information that can be used by a program activated in the server.

  The database language processing means 34 performs processing for storing the data obtained by converting the character string data / program data structure by the conversion processing means 33 in the database 52.

[Operation]
Next, an outline of the operation will be described based on the flow of FIG. 6 while showing a more detailed processing procedure at the program level.

  First, a Web browser serving as an execution environment of the present invention is activated (S101), and script language processing (S102) is executed. The script language processing at this time is described as follows.

(1) Define a storage area to be used as a database on DOMStorage. The description in JavaScript is as follows.
var LS = window.localStorage || window.globalStorage [location.hostname];
This is a description that is a definition part for securing a storage area to be used in the browser data storage process of S104.
Since the local storage area is restricted for each domain, http://www.aaaaa.com cannot access the local storage area at http://www.bbbbb.com. The domain will act as a DB schema.
This DOMStorage has the following properties (attributes) and methods (operation processing), for example.
(a) clear method
Remove all key / value pairs from DOMStorage.
(b) Returns a reference to the constructor of the constructor property object.
(c) getItem method
Get the current value associated with the DOMStorage key.
(d) Get the key at the specified index from the key method collection.
(e) Get the length of the length property key and value list.
(f) remainingSpace property Returns the remaining memory space used for the storage object in bytes.
(g) removeItem method
Removes a key / value pair from the DOMStorage collection.
(h) setItem method Set key-value pair.

(2) Table definition For local storage area prepared for each domain prepared in (1),
LS.Table name = {};
Create a table area. (Multiple tables such as LS.user and LS.ob_info can be created).

In addition, the data stored in the created area is described in JavaScript as follows.
var data = {
Column name 1: [Data 1-1, Data 1-2, Data 1-3, ...],
Column name 2: [Data 2-1, Data 2-2, Data 2-3, ...],
Column name 3: [Data 3-1, Data 3-2, Data 3-3, ...]
};

  Here, portions other than the data portion such as data 1-1 and data 1-2, for example, descriptions such as “column name 1” and “column name 2” are description portions of the program data structure.

  This data description format is called JSON format and is a kind of data description format for exchanging data derived from JavaScript. It was formulated as RFC 4627 in July 2006. JSON is considered to be a data exchange format suitable for describing Web applications, and its use in Ajax and the like is attracting attention.

  A description example of data in this JSON format is shown in FIG. This is an address book database as shown in FIG. 4 described in JSON format.

  Here, portions other than the data “Sato” and “Roppongi 123” described after “:”, for example, descriptions such as “address” and “zip code” are description portions of the program data structure.

(3) Data storage Data is stored locally even after the browser is closed, but since the local storage area can only store character strings, DB structure data created up to (2) is stored as character strings. It is necessary to store it in JSON format in a string form.

  However, if the data defined as a JSON object is converted into a character string, the structure information of the data is lost, but it can be restored by the following procedure.

The description in JavaScript is as follows.
LS.table name = uneval (data);
Here, “uneval” is a function that JavaScript has, and is a function that returns the syntax of JavaScript as a character string. By doing so, a table structure as shown in FIG. 2 can be created. The process of the uneval function executed with this description corresponds to the process of S103, and the process of substituting the data into the LS. Table name corresponds to S104.

By doing the above, store the JSON data as a string. To retrieve this again and restore the structural information,
Table storage data = eval (LS.table name.value);
And Here, “eval” is a function of JavaScript, and is a function that returns a character string as JavaScript syntax. The processing of this eval function corresponds to S105 and S203.

(4) SQL
Furthermore, in order to make it possible to access data once stored as DOMStorage as a database, the following processing is performed.

  In order to handle DB, SQL is generally used, but the same treatment as DB is possible by implementing SQL for local storage as well. Specific examples of SELECT are given below.

Performs a SELECT discrimination on the input SQL. The description in JavaScript is as follows.
var res = SQL.match (/ ^ select \ s (. *) / i);
, tkn = res [1] .match (/ ^ (. +?) \ sfROM \ s (. +?) (\ s (. *))? $ / i);
Here, the following characters are regular expressions, which respectively match characters satisfying the following conditions.
“/” Indicates the start of a regular expression.
"^" Matches at the beginning of the line.
"\ S" is a space character.
“*” Indicates that there are 0 or more immediately preceding expressions.
“+” Indicates that there is at least one previous expression.
“?” Indicates that there are 0 or 1 immediately preceding expressions.
"." Matches any character.
“$” Matches the end of the string.
“/” Indicates the end of the regular expression.
“I” after “/” indicates that case is not distinguished.

  Based on the above match, it can be determined that it is a SELECT, and tkn [1] can be confirmed as an acquisition column name, tkn [2] as an acquisition target table name, and tkn [4] as an acquisition condition. Here, “SELECT” indicates a process of extracting data stored in the database in one process in the SQL language.

For example, the simplest SQL
select column name 1 FROM table name;
The treatment of,
tkn [1] = column name 1
tkn [2] = table name. To actually get the data from the table,
// Get target table data
var trgt_table = eval (LS.table name.value);
// Get the column data (* When there is one acquisition column)
var data = trgt_table [column name 1];
Access and get as above. For other SQL, the data access method basically follows the same flow. The SQL processing corresponds to S106 and S204.

[Conceptual configuration]
FIG. 5 is a conceptual diagram showing the characteristics of the present invention described above.

  The conversion processing unit 7 according to the present invention converts the JSON data 71 into a format that can be used as the program data 6 by the eval function 73 and the uneval function 72, and stores the data in the DOMStorage area 8 as a character string data. Represents the processing to be performed.

[effect]
According to the document object / schema definition data processing apparatus of the present invention, in DOMStorage that can store only character strings, a data structure can be freely configured and accessed by an SQL command that is a database description language, and a tree can be accessed. Data stored in DOMStorage that can describe only the structure can be handled using SQL like a database, and Web system programming can be facilitated.

[Other Embodiments]
In addition, although the said embodiment illustrated in specific programming languages, such as JavaScript and SQL, it is possible to implement | achieve the same process also in other programming languages, and this invention includes another embodiment. . In the present invention, elements such as each means may be realized by an electronic circuit based on a wired logic or the like without being limited to an arithmetic control unit of a computer. Further, each configuration diagram, data diagram, flowchart diagram, and the like are merely examples, and the presence, order, specific content, and the like of each element can be changed as appropriate within the scope of the present invention.

  Further, the effects described in the embodiments of the present invention enumerate suitable effects generated from the embodiments of the present invention, and the effects of the present invention are limited to those described in the embodiments of the present invention. Is not to be done.

DESCRIPTION OF SYMBOLS 1 Internet 2 User terminal device 3 Application server 6 Program data 7 Conversion processing part 8 DOMStorage area 21 Web browser processing means 22 Script language processing means 23 Program data structure / character string data conversion processing means 24 Character string data / program data structure conversion processing Means 25 Database language processing means 26 Storage means 31 Content transmission means 32 Character string data reception means 33 Character string data / program data structure conversion processing means 34 Database language processing means 51 Browser storage area 52 Database 61 SQL sentence 71 JSON data 72 uneval function 73 eval function

Claims (3)

A data processing device for using a document object type storage area that stores only character strings as a database,
Web browser processing means for performing processing for displaying the Web page on the terminal screen;
Script language processing means that is executed in the web browser processing means and executes a script program written in a script language in the web page;
Program data structure / character string data which is executed in the script language processing means and performs processing for converting program data described in the script program into a program data structure and data represented as character string data. Conversion processing means;
Character string data / program data structure conversion processing means for converting the character string data converted by the program data structure / character string data conversion processing means into a program data structure executed in the script language processing means, and
Furthermore, the data processing apparatus which comprises a database processing unit for processing the descriptions of the programs written data structure in said script program describing the processing by the database description language including steaming crypto program. A data processing method for using a document object type storage area that stores only character strings as a database,
A web browser processing step for performing processing for displaying the web page on the terminal screen;
A script language processing step that is executed in the Web browser processing step and executes a script program written in a script language in the Web page;
Program data structure / character string data that is executed in the script language processing step and performs processing for converting the program data described in the script program into a representation of both the program data structure and data as character string data A conversion processing step;
A character string data / program data structure conversion processing step for converting the character string data converted by the program data structure / character string data conversion processing step into a program data structure executed in the script language processing step,
Furthermore, the data processing method characterized in that it comprises a database processing step of processing the descriptions of the programs written data structure in said script program describing the processing by the database description language including steaming crypto program. A data processing program for using a document object type storage area that stores only character strings as a database,
A web browser processing step for performing processing for displaying the web page on the terminal screen;
A script language processing step that is executed in the Web browser processing step and executes a script program written in a script language in the Web page;
Program data structure / character string data that is executed in the script language processing step and performs processing for converting the program data described in the script program into a representation of both the program data structure and data as character string data A conversion processing step;
A character string data / program data structure conversion processing step for converting the character string data converted by the program data structure / character string data conversion processing step into a program data structure executed in the script language processing step,
Furthermore, the data processing program, characterized in that it comprises a database processing step of processing the descriptions of the programs written data structure in said script program describing the processing by the database description language including steaming crypto program.

Images