Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

Data base read-write system and method

A technology for reading and writing systems and databases, applied in the field of data processing, can solve problems such as the impact of database reading, failure to function, and affecting database updates, so as to speed up writing and reading, improve access speed, and reduce Query the effect of pressure

Active Publication Date: 2009-08-05
BEIJING KINGSOFT OFFICE SOFTWARE INC
View PDF7 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

Existing technology 1, the method of sub-table is used to solve the query pressure of the database, that is, the database is classified according to the content, and the content of different categories is stored in different tables; but as the content of the database increases, the number of table splits There are also more and more, and the time for users to access web pages to connect to the database will also increase. Users cannot see the content to be accessed for a long time, and the experience is very poor.
The second prior art uses caching technology to alleviate the query pressure of the database, stores infrequently queried content in the database, and frequently queried content but infrequently updated content is stored in an array file, which acts as a cache , the user can connect to the array file at a faster speed, which relieves the query pressure on the database; however, the caching technology does not work for websites that need to be updated frequently (such as forums), and the scope of application is limited
When the database is accessed in large quantities, the reading of the database is affected, and the connection speed is slow. Similarly, the writing of the database will also be affected, and the writing speed is slow, which affects the update of the database.

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
  • Data base read-write system and method
  • Data base read-write system and method
  • Data base read-write system and method

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0017] The embodiment of the present invention provides a system and method for reading and writing a database, which are used to realize fast reading and writing of a website database.

[0018] see figure 1 It is an implementation principle diagram of database reading and writing provided by the embodiment of the present invention.

[0019] In the embodiment of the present invention, one server is used as data writing, and multiple servers process data query. The writing server is called writing server, and the server processing data query is called reading server. Writing server and reading server The server is connected through the network. When data is written into the database of the writing server, the written data is updated to the reading server through data synchronization; in this way, when users read data, they only need to connect to the reading server and access the database on the reading server. As the access to the database increases, the number of read serve...

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 discloses a system and method for reading and writing a database. The system for reading and writing the database of the present invention includes: a writing server, a synchronization unit and at least one reading server; the writing server is used to receive the data written by the user and store it in the writing database; the synchronization unit is used to Synchronize the data written by the user to the reading database of the reading server; the reading database is used to store the reading database for the user to read data. The database reading and writing method of the present invention includes: writing data into a writing database; synchronizing said data to at least one reading database; connecting said at least one reading database to read data. The invention can realize fast reading and writing of the database.

Description

technical field [0001] The invention relates to the field of data processing, in particular to a system and method for reading and writing a database. Background technique [0002] With the advent of the information age and the rapid development of the Internet, searching for information online has become a part of people's daily life; many large-scale websites provide people with fast and rich information and win people's favor. A large number of users visit these sites every day. Websites pose a great challenge to the stable operation of these website databases. [0003] In the prior art, the databases are all on one server. Existing technology 1, the method of sub-table is used to solve the query pressure of the database, that is, the database is classified according to the content, and the content of different categories is stored in different tables; but as the content of the database increases, the number of table splits There are also more and more, and the time for...

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 Patents(China)
IPC IPC(8): G06F17/30
Inventor 曾建
Owner BEIJING KINGSOFT OFFICE SOFTWARE INC
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products