SQL database-based set top box data storage method

A data storage and database technology, which is applied in the direction of electric digital data processing, special data processing applications, color TV parts, etc., can solve the problems of reduced program stability, low program execution efficiency, and difficult database writing, etc., to achieve The effect of fast query speed, fast storage speed, and simple program expansion method

Inactive Publication Date: 2010-05-26
FUJIAN NEWLAND COMM SCI TECH
View PDF0 Cites 8 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0002] Traditional digital TV set-top boxes use a relatively simple array or linked list management method for data storage. When the data volume is relatively large, the stored data types are relatively diverse, and the query conditions are relatively complicated, it will cause difficulties in writing the program when using the database. The program execution efficiency is low and the speed is slow. At the same time, a large number of codes need to be changed when expanding data types and adding query conditions, resulting in the responsibility of program writing and reducing the stability of the program.

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
  • SQL database-based set top box data storage method
  • SQL database-based set top box data storage method
  • SQL database-based set top box data storage method

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0025] see figure 1 As shown, the SQL model used in the present invention includes two parts, the SQL kernel and the SQL compiler. Among them, the SQL kernel is divided into SQL api interface, SQL command processor, and virtual machine; the SQL compiler is divided into compiler, analyzer, and code generator. The main working principles of the SQL model are:

[0026] 1. The SQL statement is passed to the SQL command processor through the SQL api interface;

[0027] 2. The SQL command processor splits the SQL statement into necessary statement segments and sends them to the compiler;

[0028] 3. The compiler compiles the SQL statement in segments into symbols that the analyzer can recognize, and then sends these symbols to the analyzer;

[0029] 4. The analyzer decomposes the received symbols into specific SQL syntax and sends them to the code generator;

[0030] 5. The code generator translates the decomposed SQL syntax into a code that can be recognized by the virtual mach...

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 relates to a digital TV set top box, in particular to an SQL database-based set top box data storage method, which comprises the following steps: step 10, after the set top box is powered up, importing partial entities of an SQL database stored on a Flash into a memory, and performing initiation judgment on the segment of memory data; step 20, when data is required to be written to the SQL database, selecting required data of the SQL database, and writing the data to a corresponding place according to the type of the data; and step 30, when the data is about to be read, querying in the required data of the SQL database according to required conditions to obtain all required data results. The method has the advantages of quick storage and query, simple expansion, easy writing and high executing efficiency.

Description

【Technical field】 [0001] The invention relates to a digital TV set-top box, in particular to a method for storing data of the set-top box based on an SQL database. 【Background technique】 [0002] Traditional digital TV set-top boxes use a relatively simple array or linked list management method for data storage. When the data volume is relatively large, the stored data types are relatively diverse, and the query conditions are relatively complicated, it will cause difficulties in writing the program when using the database. The execution efficiency of the program is low and the speed is slow. At the same time, a large number of codes need to be changed when expanding the data type and adding query conditions, resulting in the responsibility of program writing and reducing the stability of the program. 【Content of invention】 [0003] The technical problem to be solved by the present invention is to provide a set-top box data storage method based on SQL database, which has f...

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/30H04N5/00
Inventor 方立
Owner FUJIAN NEWLAND COMM SCI TECH
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

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

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap