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

SQLite-based embedded database synchronization method

A database and embedded technology, which is applied in the design field of embedded database synchronization methods, can solve problems such as high cost and inflexible configuration, and achieve the effects of occupying less resources, ensuring reliability and stability, and saving costs

Active Publication Date: 2017-04-26
CHENGDU JIUZHOU ELECTRONIC INFORMATION SYSTEM CO LTD
View PDF8 Cites 20 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0006] The purpose of the present invention is to solve the problem that the cost of the existing embedded data synchronization technology is high, and the configuration is not flexible enough, and a SQLite-based embedded database synchronization method is proposed

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
  • SQLite-based embedded database synchronization method
  • SQLite-based embedded database synchronization method

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0037] Embodiments of the present invention will be further described below in conjunction with the accompanying drawings.

[0038] The invention provides an embedded database synchronization method based on SQLite, including three stages of system initialization, system startup and incremental synchronization. Such as figure 1 As shown, each stage specifically includes the following steps:

[0039] (1) System initialization phase:

[0040] S1. Configure the role of the user's own device in the synchronization network.

[0041] The database used in the present invention is SQLite, which is a lightweight, cross-platform relational database, and occupies less resources, has good performance, and has no management cost. In the database synchronization system, the synchronization device is called a node. The nodes in the system are divided into master nodes and slave nodes. There can only be one master node and at least one slave node in the system; if there are multiple slave ...

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 SQLite-based embedded database synchronization method. The method comprises three stages of system initialization, system startup and increment synchronization. The method is established in a database of a device; a special device for handling a synchronization business does not need to be additionally added in the whole process, so that the cost is reduced; and the characteristics of an embedded system are met. Meanwhile, the database used in the method is SQLite, occupies few resources, is good in performance and free from management cost, meets cost control demand of an embedded device, and ensures synchronization reliability and stability; and the data loss caused by network transmission is prevented through database operation logs, and synchronized database tables can be flexibly configured according to actual needs.

Description

technical field [0001] The invention belongs to the technical field of embedded databases, and in particular relates to the design of an SQLite-based embedded database synchronization method. Background technique [0002] In the field of business information systems, the information stored and managed on embedded devices is often a part of the entire integrated information system, and these data often need to be synchronized and interacted with the data of the entire information system. With the development of embedded technology And widely used, embedded data synchronization and interaction become more and more important. [0003] For the synchronization method, the current data synchronization is mainly based on incremental synchronization, that is, the data changed in one database is transferred to another database within a period of time to achieve database consistency. The changed data mainly includes added data and modified data. Deleted data. In this way, if the dat...

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
IPC IPC(8): G06F17/30
CPCG06F16/2358G06F16/2365G06F16/27G06F16/284
Inventor 邹杰邹式论
Owner CHENGDU JIUZHOU ELECTRONIC INFORMATION SYSTEM CO LTD
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