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

Data processing method and apparatus based on embedded database

A data processing device and data processing technology, applied in the database field, can solve problems such as unusable and locked-up of other functions

Inactive Publication Date: 2015-08-26
SHENZHEN WORKEC TECH
View PDF5 Cites 17 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0005] The embodiment of the present invention provides a data processing method based on an embedded database, which aims to solve the problem that the entire database is locked and other functions cannot be used under the high concurrent operation state 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 processing method and apparatus based on embedded database
  • Data processing method and apparatus based on embedded database
  • Data processing method and apparatus based on embedded database

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0018] In order to make the object, technical solution and advantages of the present invention clearer, the present invention will be further described in detail below in conjunction with the accompanying drawings and embodiments. It should be understood that the specific embodiments described here are only used to explain the present invention, not to limit the present invention.

[0019] The embodiment of the present invention uses the sub-database and sub-table technology to divide the embedded database into at least two databases, so that when the user program performs a large amount of data read and write operation on a certain table in the database, the entire database will not be locked. At the same time, users can perform normal read and write operations on other tables in the database, so that when the database performs high-concurrency operations, there will be no phenomenon that the memory occupied by the App application is too high, the CPU consumption is too high, ...

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 present invention is applicable to the field of database technologies, and provides a data processing method and apparatus based on an embedded database. The method comprises the following steps: sharding a source database to generate at least two new databases; encapsulating data operation syntax of the new databases to generate a corresponding operational function; and enabling a thread pool to make a response to calling of the operational function. According to the present invention, the sharding technology is used to segmenting an embedded database SQlite into at least two databases, and in the mean time a thread pool is used to manage operational calling of multiple threads to the database, such that the entire database is not locked when a user's APP performs large data-volume read and write operations on a form in the database. In addition, the user can also perform normal read and write operations on the other forms in the database, thereby preventing the cases where the APP occupies much memory, the CPU consumption is great, and the mobile phone produces too much heat.

Description

technical field [0001] The invention belongs to the technical field of databases, in particular to a data processing method and device based on an embedded database. Background technique [0002] Mobile App programs are more and more widely used in mobile phones. During the running of the App, a large number of data read and write operations will be performed. In order to ensure the speed of data read and write operations, currently mobile phones generally use embedded databases, such as SQlite databases for data processing. management. [0003] When multiple users are reading and writing data in the database, in order to ensure the integrity and consistency of the data, SQlite adopts the lock mechanism to control. SQlite locks are divided into two types, one is exclusive lock, and the other is It is a shared lock: when a transaction writes data in the database, the transaction acquires an exclusive lock on the data. During the operation of the transaction, other transactio...

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
CPCG06F16/2343
Inventor 吴剑文
Owner SHENZHEN WORKEC TECH
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

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic, Popular Technical Reports.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com