Method and system for operating database

A database and master database technology, applied in the network field, can solve problems such as unfavorable project upgrades and expansions, and the inability to achieve relatively safe protection of data, so as to achieve the effect of ensuring access security

Active Publication Date: 2012-04-25
沈文策
View PDF3 Cites 38 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] 1) The server directly operates the database, and the data in the database cannot be protected more safely
[0005] 2) Once the project structure of the database is modified, the scripts of each front-end server need to be modified at the same time, which is not conducive to the upgrade and expansion of the project

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Method and system for operating database
  • Method and system for operating database
  • Method and system for operating database

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0067] figure 2 The flow chart of the main method provided by Embodiment 1 of the present invention, such as figure 2 As shown, the method mainly includes the following steps:

[0068] Step 201: the front-end server receives an operation request from the browser.

[0069] The embodiment of the present invention is still based on the b / s mode. The user sends an operation request to the front-end server of the user center website through the browser. The operation request includes but is not limited to: read data operation, write data operation, modify data operation or search data operation, etc. . For example, reading data operations such as checking mailboxes and blogs, user information setting, and writing blogs are data writing operations, modifying user passwords, modifying blog content, etc. are data modification operations, and searching for friends and blogs are data search operations.

[0070] Step 202: the front-end server judges the type of the operation request...

Embodiment 2

[0099] In this embodiment, the process of reading data is described in detail by taking mailbox checking as an example. image 3 The flow chart of the method for viewing messages in the station provided by Embodiment 2 of the present invention, as shown in image 3 As shown, the method includes the following steps:

[0100] Step 301: the front-end server receives a data read request from a browser to view messages in the site.

[0101] When the user clicks the link to view the in-site message through the browser, the browser will carry the ID of the in-site message to be viewed in the read data request and send it to the front-end server.

[0102] Step 302: the front-end server sends the internal message ID carried in the read data request to the cache unit.

[0103] Step 303: The cache unit judges whether there is data corresponding to the internal letter ID in the memory, and if so, returns the corresponding data to the front-end server through a response; otherwise, retur...

Embodiment 3

[0116] In this embodiment, the process of writing data is described in detail by taking writing a blog as an example. Figure 4 The flow chart of the blogging method provided by Embodiment 3 of the present invention, such as Figure 4 As shown, the method includes the following steps:

[0117] Step 401: the front-end server receives a data write request containing blog content from a browser.

[0118] When the user writes blog content through the browser, the browser will carry the blog content in the write data request and send it to the front-end server.

[0119] Step 402: the front-end server sends a data write request to the gateway database middleware.

[0120] Step 403: The gateway database middleware uses the write data request to verify the authority of the front-end server.

[0121] Assuming that the IP address of the front-end server is an intranet address, and the verification is passed, go to step 404 .

[0122] Step 404: The gateway database middleware sends a...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

PUM

No PUM Login to view more

Abstract

The invention provides a method and system for operating a database. The method comprises the following steps of: sending an operation request from a browser to a gateway database middleware by a front-end server; sending the operation request to a database layer by the gateway database middleware after the front-end server passes the right certification; operating the database by the database layer according to operating target information in the operation request and returning back an operating result to the gateway database middleware; and sending the operating result to the front-end server by the gateway database middleware according to a format appointed with the front-end server. According to the method, the gateway database middleware is used for separating the operation to the database from the front-end server and is used as an operating interface between the front-end server and the database, and the right control is realized on the gateway database middleware, thereby efficiently ensuring the access safety of the database and being beneficial to the upgrading and expanding of a project.

Description

【Technical field】 [0001] The invention relates to the field of network technology, in particular to a method and system for operating a database. 【Background technique】 [0002] With the rapid development of the Internet, changes in user groups, product updates, and website experience upgrades require sensitivity to the user center, and adjust the pace of user center development according to market demand. In order to improve user loyalty, cohesion, satisfaction and product experience, various professional and comprehensive user-centered websites with more personalized operations, richer content, and more active interactive forms have emerged, such as the recent Various e-commerce websites, microblogging websites, etc. have emerged. The above-mentioned user center website needs to record user information and behavior by operating the database, and at the same time needs to ensure the security of user information. [0003] Most of the existing methods of operating the datab...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

Application Information

Patent Timeline
no application Login to view more
Patent Type & Authority Applications(China)
IPC IPC(8): G06F17/30
Inventor 沈文策
Owner 沈文策
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products