CN104268269A - Database operating method - Google Patents
Database operating method Download PDFInfo
- Publication number
- CN104268269A CN104268269A CN201410538968.XA CN201410538968A CN104268269A CN 104268269 A CN104268269 A CN 104268269A CN 201410538968 A CN201410538968 A CN 201410538968A CN 104268269 A CN104268269 A CN 104268269A
- Authority
- CN
- China
- Prior art keywords
- database
- client
- label
- service end
- data file
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/90—Details of database functions independent of the retrieved data types
- G06F16/95—Retrieval from the web
- G06F16/958—Organisation or management of web site content, e.g. publishing, maintaining pages or automatic linking
- G06F16/972—Access to data in other repository systems, e.g. legacy data or dynamic Web page generation
Landscapes
- Engineering & Computer Science (AREA)
- Databases & Information Systems (AREA)
- Theoretical Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses a database operating method. The database operating method comprises the following steps that: step 1, a client edits a database operating request into a data file in a preset format; step 2, the client delivers the data file to a service end through a network; step 3, the service end resolves the data file based on the preset format to obtain a database operating request; step 4, the service end sends the database operating request to the database; step 5, the database operates based on the database operating request to form a corresponding result data collection; step 6, the service end edits the result data collection via the preset format to form a result data file and sends the result data file to the client end through the network. The beneficial effects of the technical scheme are that a database system which is only visited locally can be visited through the network, and a returned result is a text embedded with a label and can be directly applied to display of a hypertext.
Description
Technical field
The present invention relates to areas of information technology, particularly relate to a kind of database operation method.
Background technology
Database is the data storage system that areas of information technology are commonly used, and because it is powerful so expensive, the database of especially network enabled access, its price is not that general enterprises can accept.And some are low-cost, even free Database Systems are not network enabled access usually then, only supports local IP access.
Summary of the invention
For the problems referred to above that existing Database Systems exist, now provide a kind of and be intended to realize the database operation method that the Database Systems of local IP access are only supported in network access.
Concrete technical scheme is as follows:
A kind of database operation method, comprises and is in long-range client, and is in local service end, and described service end is provided with database, and described client is connected by network with described service end, wherein, comprises the steps:
Step 1, database manipulation request editor is formed the data file with predetermined format by client;
Step 2, described client by described data file by described network delivery to described service end;
Step 3, described service end resolves described data file according to described predetermined format, to obtain described database manipulation request;
Step 4, described database manipulation request is sent to described database by described service end;
Step 5, described database root carries out operating according to described database manipulation request and forms corresponding result data collection;
Step 6, described result data collection is formed result data files with described predetermined format editor by described service end, and is sent to described client by described network.
Preferably, described predetermined format is text formatting.
Preferably, described text formatting is that label is nested form.
Preferably, when database manipulation request editor is formed described data file by client described in described step 1, operational order name is referred to as label, using the content of operational order content as the label of the described operational order title of correspondence.
Preferably, when database manipulation request editor is formed described data file by client described in described step 1, using operational order parameter name as label, using the content of the content of operational order parameter as the label of the described operational order parameter name of correspondence, and the label cover of described for correspondence operational order parameter name is embedded in the label of corresponding described operational order title.
Preferably, when database manipulation request editor is formed described data file by client described in described step 1, the label of instruction client is formed in described data file, using the content of the numbering of described client as the label of the described client of instruction, and the label cover of described for correspondence operational order title is embedded in the label of the described client of described instruction.
Preferably, also comprise after described step 6, described client resolves described result data files according to described predetermined format, to obtain described result data collection
Preferably, described database is Lucece database.
The beneficial effect of technique scheme is:
Realizing being accessed by network only can the Database Systems of local IP access;
Return results the text for label is nested, the display of hypertext document can be directly applied to.
Accompanying drawing explanation
Fig. 1 is the steps flow chart block diagram of the embodiment of database operation method of the present invention.
Embodiment
Below in conjunction with the drawings and specific embodiments, the invention will be further described, but not as limiting to the invention.
A kind of database operation method, comprises and is in long-range client, and is in local service end, and service end is provided with database, and client is connected by network with service end, wherein, as shown in Figure 1, comprises the steps:
Step 1, database manipulation request editor is formed the data file with predetermined format by client;
Step 2, client by data file by network delivery to service end;
Step 3, service end according to predetermined format resolution data file, to obtain database manipulation request;
Step 4, database manipulation request is sent to database by service end;
Step 5, database root carries out operating according to database manipulation request and forms corresponding result data collection;
Step 6, result data collection is edited formation result data files by service end in a predetermined format, and is sent to client by network.
Technique scheme achieve client by network access service end only with the database of local IP access, and because the mode transmitted by data file carries out communication, avoid the designated communication port taking service end for a long time, thus make service end need not be equipped with complicated Port Management logic.Also be convenient to be realized by udp protocol, decrease taking of server resource.
On technique scheme basis, further, predetermined format is text formatting.
On technique scheme basis, further, text formatting is that label is nested form.
On technique scheme basis, further, when database manipulation request editor is formed data file by client in step 1, operational order name is referred to as label, using the content of operational order content as the label of respective operations instruction name.
On technique scheme basis, further, when in step 1, database manipulation request editor is formed data file by client, using operational order parameter name as label, using the content of the content of operational order parameter as the label of respective operations order parameter title, and the label cover of respective operations order parameter title is embedded in the label of respective operations instruction name.
On technique scheme basis, further, when in step 1, database manipulation request editor is formed data file by client, the label of instruction client is formed in data file, using the content of the numbering of client as the label of instruction client, and the label cover of respective operations instruction name is embedded in the label of instruction client.
On technique scheme basis, further, also comprise after step 6, client according to predetermined format analysis result data file, to obtain result data collection
On technique scheme basis, further, database is Lucece database.
It is to be noted, the result data files that service end returns also is that label is nested form, the label of corresponding data table or Data View can be set in a kind of preferably embodiment, table name or Data View name are as label substance, and the label of the record in corresponding table or Data View is set, and the label of field in corresponding record, the label of all record correspondences inquired and content thereof are embedded in the label of corresponding data table or Data View with parallel fashion cover, the label of all fields in a corresponding record is embedded in the label of corresponding record with order parallel fashion cover, and the content of corresponding field label is filled with the field contents of data centralization.
The format match of Table object in the result data files that this embodiment produces and hyper text protocol, the i.e. Table mark of the corresponding Table object of the label of corresponding data table or Data View, the Tr mark of the corresponding Table object of label of the record in corresponding table or Data View, the Td mark of the corresponding Table object of label of the field in corresponding record, the result data files that service end returns can be resolved by above-mentioned corresponding relation, and only need simple processing, as passed through to replace tag characters, the result data files that can realize service end being returned directly applies in hyper text protocol, thus decrease the system overhead of client.
The foregoing is only preferred embodiment of the present invention; not thereby embodiments of the present invention and protection domain is limited; to those skilled in the art; should recognize and all should be included in the scheme that equivalent replacement done by all utilizations instructions of the present invention and diagramatic content and apparent change obtain in protection scope of the present invention.
Claims (8)
1. a database operation method, comprises and is in long-range client, and is in local service end, and described service end is provided with database, and described client is connected by network with described service end, it is characterized in that, comprises the steps:
Step 1, database manipulation request editor is formed the data file with predetermined format by client;
Step 2, described client by described data file by described network delivery to described service end;
Step 3, described service end resolves described data file according to described predetermined format, to obtain described database manipulation request;
Step 4, described database manipulation request is sent to described database by described service end;
Step 5, described database root carries out operating according to described database manipulation request and forms corresponding result data collection;
Step 6, described result data collection is formed result data files with described predetermined format editor by described service end, and is sent to described client by described network.
2. database operation method as claimed in claim 1, it is characterized in that, described predetermined format is text formatting.
3. database operation method as claimed in claim 2, is characterized in that, described text formatting is that label is nested form.
4. database operation method as claimed in claim 3, it is characterized in that, when database manipulation request editor is formed described data file by client described in described step 1, operational order name is referred to as label, using the content of operational order content as the label of the described operational order title of correspondence.
5. database operation method as claimed in claim 4, it is characterized in that, when database manipulation request editor is formed described data file by client described in described step 1, using operational order parameter name as label, using the content of the content of operational order parameter as the label of the described operational order parameter name of correspondence, and the label cover of described for correspondence operational order parameter name is embedded in the label of corresponding described operational order title.
6. database operation method as claimed in claim 4, it is characterized in that, when database manipulation request editor is formed described data file by client described in described step 1, the label of instruction client is formed in described data file, using the content of the numbering of described client as the label of the described client of instruction, and the label cover of described for correspondence operational order title is embedded in the label of the described client of described instruction.
7. database operation method as claimed in claim 1, its feature is from being, also comprise after described step 6, described client resolves described result data files according to described predetermined format, to obtain described result data collection.
8., as database operation method as described in arbitrary in claim 1-7, it is characterized in that, described database is Lucece database.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201410538968.XA CN104268269A (en) | 2014-10-13 | 2014-10-13 | Database operating method |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201410538968.XA CN104268269A (en) | 2014-10-13 | 2014-10-13 | Database operating method |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN104268269A true CN104268269A (en) | 2015-01-07 |
Family
ID=52159790
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201410538968.XA Pending CN104268269A (en) | 2014-10-13 | 2014-10-13 | Database operating method |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN104268269A (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105260277A (en) * | 2015-10-29 | 2016-01-20 | 西安交通大学 | Lognormal model-based text test dataset generation method |
Citations (11)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1410918A (en) * | 2002-05-31 | 2003-04-16 | 浙江大学 | Searching engine based on information extraction technique |
| WO2006046070A1 (en) * | 2004-10-27 | 2006-05-04 | Contextus Limited | Decentralised database network |
| US20070044012A1 (en) * | 2005-08-19 | 2007-02-22 | Microsoft Corporation | Encoding of markup language data |
| CN101021848A (en) * | 2006-02-15 | 2007-08-22 | 鸿富锦精密工业（深圳）有限公司 | Information searching system and method |
| CN101192234A (en) * | 2007-06-07 | 2008-06-04 | 腾讯科技（深圳）有限公司 | Searching system and method based on web page extraction |
| CN101458712A (en) * | 2008-12-24 | 2009-06-17 | 南京邮电大学 | Polymerization process for calculating context facing to generalization |
| CN101458703A (en) * | 2007-12-13 | 2009-06-17 | 音乐会技术公司 | Resizing tag representations or tag group representations to control relative importance |
| CN101534306A (en) * | 2009-04-14 | 2009-09-16 | 深圳市腾讯计算机***有限公司 | Detecting method and a device for fishing website |
| CN101782924A (en) * | 2009-01-19 | 2010-07-21 | 索尼公司 | Information processing method, information processing apparatus, and program |
| CN103778258A (en) * | 2014-02-27 | 2014-05-07 | 华为技术有限公司 | Method for sending and receiving data of database, client terminal and server |
| CN103793749A (en) * | 2014-02-27 | 2014-05-14 | 四川物联恒安安全技术研究有限公司 | Safety production comprehensive supervisory platform data transmission method |
-
2014
- 2014-10-13 CN CN201410538968.XA patent/CN104268269A/en active Pending
Patent Citations (11)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1410918A (en) * | 2002-05-31 | 2003-04-16 | 浙江大学 | Searching engine based on information extraction technique |
| WO2006046070A1 (en) * | 2004-10-27 | 2006-05-04 | Contextus Limited | Decentralised database network |
| US20070044012A1 (en) * | 2005-08-19 | 2007-02-22 | Microsoft Corporation | Encoding of markup language data |
| CN101021848A (en) * | 2006-02-15 | 2007-08-22 | 鸿富锦精密工业（深圳）有限公司 | Information searching system and method |
| CN101192234A (en) * | 2007-06-07 | 2008-06-04 | 腾讯科技（深圳）有限公司 | Searching system and method based on web page extraction |
| CN101458703A (en) * | 2007-12-13 | 2009-06-17 | 音乐会技术公司 | Resizing tag representations or tag group representations to control relative importance |
| CN101458712A (en) * | 2008-12-24 | 2009-06-17 | 南京邮电大学 | Polymerization process for calculating context facing to generalization |
| CN101782924A (en) * | 2009-01-19 | 2010-07-21 | 索尼公司 | Information processing method, information processing apparatus, and program |
| CN101534306A (en) * | 2009-04-14 | 2009-09-16 | 深圳市腾讯计算机***有限公司 | Detecting method and a device for fishing website |
| CN103778258A (en) * | 2014-02-27 | 2014-05-07 | 华为技术有限公司 | Method for sending and receiving data of database, client terminal and server |
| CN103793749A (en) * | 2014-02-27 | 2014-05-14 | 四川物联恒安安全技术研究有限公司 | Safety production comprehensive supervisory platform data transmission method |
Non-Patent Citations (1)
| Title |
|---|
| 汪博: "面向手机终端的数据备份***的研究与实现", 《中国优秀硕士学位论文全文数据库 信息科技辑》 * |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105260277A (en) * | 2015-10-29 | 2016-01-20 | 西安交通大学 | Lognormal model-based text test dataset generation method |
| CN105260277B (en) * | 2015-10-29 | 2019-05-03 | 西安交通大学 | A kind of text test data set creation method based on lognormal model |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| WO2017025056A1 (en) | Method and system for realizing data tracking by means of software development kit | |
| CN104994122B (en) | A kind of newsletter method based on JSON data protocol | |
| RU2014145195A (en) | TECHNOLOGIES FOR AUTOMATIC SYNDICATION OF NETWORK CONTENT | |
| CN103257958B (en) | A kind of interpretation method based on cloud storage and system | |
| CN104915398A (en) | Method and device for webpage point burying | |
| CN103246963B (en) | Based on the staffs training system of Internet of Things | |
| RU2009148317A (en) | LOCATION IMPORTING DATA DELIVERY DEVICE, LOCATION DATA IMPORTATION SYSTEM AND METHOD OF LOCATING DATA IMPORTATION | |
| US20180129721A1 (en) | Systems and Methods for Managing Aviation Records | |
| CN105681476A (en) | Page skipping method, device and system | |
| CN101916293B (en) | Introduce the method and apparatus of media information in a document | |
| CN104283723A (en) | Network access log processing method and device | |
| CN102904823B (en) | A kind of multiple services Accurate Data Flow Control method of multi-user based on memory | |
| SE0701143L (en) | traffic control | |
| CN103095839A (en) | System and method of client data presentation | |
| CN104378236A (en) | Internet of things device management platform and method | |
| CN104767839A (en) | IP positioning method and device | |
| CN101719163A (en) | Method for cutting and combing computer network pages with permission system | |
| CN104268269A (en) | Database operating method | |
| Smith | Beyond GSM-R: the future of railway radio | |
| CN104598235A (en) | Method and system for displaying team working interface of power management system | |
| JP2016057920A (en) | Drawing display device, drawing display method, and drawing display program | |
| CN101697161A (en) | Method and device for managing semantic Portlet library for power grid enterprises | |
| EP4031988A1 (en) | Computerized systems and methods for bi-directional file sharing and synchronization on and over a network | |
| CN102110144A (en) | Document access method and terminal equipment | |
| CN103248717A (en) | Method and system for marking geographical position of host |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| RJ01 | Rejection of invention patent application after publication | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20150107 |