CN102750290B - Realizing method of STB (Set Top Box) database and STB - Google Patents

Realizing method of STB (Set Top Box) database and STB Download PDF

Info

Publication number
CN102750290B
CN102750290B CN201110101677.0A CN201110101677A CN102750290B CN 102750290 B CN102750290 B CN 102750290B CN 201110101677 A CN201110101677 A CN 201110101677A CN 102750290 B CN102750290 B CN 102750290B
Authority
CN
China
Prior art keywords
data
database file
information
top box
data format
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Active
Application number
CN201110101677.0A
Other languages
Chinese (zh)
Other versions
CN102750290A (en
Inventor
蓝允长
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Shenzhen Skyworth Digital Technology Co Ltd
Original Assignee
Shenzhen Skyworth Digital Technology Co Ltd
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by Shenzhen Skyworth Digital Technology Co Ltd filed Critical Shenzhen Skyworth Digital Technology Co Ltd
Priority to CN201110101677.0A priority Critical patent/CN102750290B/en
Publication of CN102750290A publication Critical patent/CN102750290A/en
Application granted granted Critical
Publication of CN102750290B publication Critical patent/CN102750290B/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Abstract

The embodiment of the invention discloses a realizing method of an STB (Set Top Box) database. The realizing method of the STB database comprises the following steps of obtaining a database document needed by an STB during the operation; uniformly coding the database document according to a preset coding regulation, and transforming the coded database document into a preset data format; and storing the database document which is transformed into the preset data format. The embodiment of the invention also discloses the STB. By adopting the invention, an obtained database document can be uniformly coded and transformed into data with the same data format so as to be stored in the database, and the unification of all the information in the database document in the STB database on the coding mode and the data format is realized.

Description

A kind of implementation method of data of set top box storehouse and Set Top Box
Technical field
The present invention relates to field, data of set top box storehouse, particularly relate to a kind of implementation method and Set Top Box of data of set top box storehouse.
Background technology
The development of current Set Top Box industry is quite ripe, the functional module that producer adds on the set-top box gets more and more, it has entered the epoch of a Development of Modular, to the independence of functional module, functional, transplantability all requires very high, but general Set Top Box producer too pays close attention to module upgrade and functional requirement, and ignores background data base in Set Top Box.
At present, the database model that most Set Top Box producer is ununified when design database, more random to database definition, simply deposit data is planned a blocks of data region in flash memory, then the direct bivariate table by the relevant information of the various data formats of typing is stored in this flash memory, and there is the unsharp phenomenon of concept.The bivariate tables such as the aerial information bivariate table that the database file in data of set top box storehouse comprises, satellite information bivariate table, frequency point information bivariate table, programme information bivariate table and system configuration information bivariate table are not identical all to some extent in data format and coded system, due to the difference between each bivariate table, as differing greatly between system configuration information and program list information, this just causes the managerial confusion of database in flash memory, reduces the performance of Set Top Box entirety.Simultaneously due to the difference between each bivariate table, also make to there are differences between set-top box platform, thus cause the comparison in difference of the different Set Top Box interface in calling data storehouse at the middle and upper levels large, cause software development cycle long, maintainable poor, availability is low, not portability.
Summary of the invention
Embodiment of the present invention technical problem to be solved is, a kind of implementation method and Set Top Box of data of set top box storehouse are provided, unified coding can be carried out to the database file obtained and the data converting identical data format to are stored in database, realize the unification of every terms of information in coded system and data format in the database file in data of set top box storehouse.
In order to solve the problems of the technologies described above, embodiments provide a kind of implementation method of data of set top box storehouse, comprising:
Obtain the database file that Set Top Box is operationally required;
According to the coding rule preset, Unified coding is carried out to described database file, and convert the database file after coding to predetermined data format;
The database file of predetermined data format is converted to described in storage.
Wherein, also comprise: when set-top box software starts, the database file converting predetermined data format to described in storing is resolved, and be loaded in internal memory and run.
Wherein, the step of the database file that described acquisition Set Top Box is operationally required, comprising:
Obtain the data that the Set Top Box of user's input is operationally required;
Judge that whether the described data obtained legal, if so, using the described data that obtain as the operationally required database file of Set Top Box, otherwise, abandon this data.
Wherein, before the step of database file converting predetermined data format described in described storage to, also comprise:
Whether the size of data converting the database file of predetermined data format described in judgement to exceedes the size of top-set hardware memory space;
If so, compression process is carried out to the described database file converting predetermined data format to.
Wherein, also comprise: if resolving the database file converting predetermined data format described in storage to, and be loaded in the process run in internal memory, if when loading unsuccessfully, then exit this to resolve and load operation the database file converting predetermined data format described in storage to, before recovery, load the database file of successfully predetermined data format.
Wherein, described database file comprises in aerial information, satellite information, frequency point information, programme information and system configuration information one or multinomial;
Converting in the step of the database file of predetermined data format described in described storage, is store according to the form of bivariate table to the every terms of information in the described database file converting predetermined data format to.
Wherein, also comprise: when set-top box software starts, retrieval is carried out to the bivariate table stored and arranges, so that realize the retrieval to information in the described database file stored.
Correspondingly, the embodiment of the present invention additionally provides a kind of Set Top Box, comprising:
Data acquisition module, for obtaining the operationally required database file of Set Top Box;
Data processing module, for carrying out Unified coding according to the coding rule preset to the database file that described data acquisition module obtains, and converts the database file after coding to predetermined data format;
Data memory module, for storing the database file of the converted tentation data form of described data processing module.
Wherein, also comprise: Data Analysis load-on module, for when set-top box software starts, the database file converting predetermined data format to described in storing is resolved, and be loaded in internal memory and run.
Wherein, described data acquisition module comprises:
Acquiring unit, the data that the Set Top Box for obtaining user's input is operationally required;
Judging unit, whether legal for judging the data that described acquiring unit obtains, if so, using the described data that obtain as the operationally required database file of Set Top Box, otherwise, abandon this data.
Wherein, also comprise: compression module, whether the size of data for the database file judging the predetermined data format that described data processing module converts to exceedes the size of top-set hardware memory space, and when being judged as YES, compression process is carried out to the described database file converting tentation data form to.
Wherein, also comprise: data recovery module, for when described Data Analysis load-on module loads unsuccessfully, exit this to resolve and load operation the database file converting predetermined data format described in storage to, before recovery, load the database file of successfully predetermined data format.
Wherein, described database file comprises in aerial information, satellite information, frequency point information, programme information and system configuration information one or multinomial, converting in the step of the database file of predetermined data format described in described storage, is store according to the form of bivariate table to the every terms of information in the described database file converting predetermined data format to;
This Set Top Box also comprises:
Retrieval arranges module, for when set-top box software starts, carries out retrieval arrange the bivariate table stored, so that realize the retrieval to information in the described database file stored;
Data management module, for providing unified calling interface for database, so that calling the database file in database.
Implement the embodiment of the present invention, there is following beneficial effect:
By carrying out unified coding to the database file obtained and the data converting identical data format to are stored in database, realize the unification of every terms of information in coded system and data format in the database file in data of set top box storehouse, avoid due to various information in data of set top box storehouse difference cause the problem of data base administration confusion, facilitate user and unified management is carried out to the data in data of set top box storehouse, also the cycle of the software development relevant to database is shortened, improve the maintainability in data of set top box storehouse, availability, and make the transplanting of database comparatively easy.
Accompanying drawing explanation
Fig. 1 is the first example structure composition schematic diagram of Set Top Box of the present invention;
Fig. 2 is the second example structure composition schematic diagram of Set Top Box of the present invention;
Fig. 3 is the first example structure composition schematic diagram of the implementation method in data of set top box storehouse of the present invention;
Fig. 4 is the second example structure composition schematic diagram of the implementation method in data of set top box storehouse of the present invention.
Embodiment
Below in conjunction with the accompanying drawing in the embodiment of the present invention, be clearly and completely described the technical scheme in the embodiment of the present invention, obviously, described embodiment is only the present invention's part embodiment, instead of whole embodiments.Based on the embodiment in the present invention, those of ordinary skill in the art, not making the every other embodiment obtained under creative work prerequisite, belong to the scope of protection of the invention.
Refer to Fig. 1, be the first example structure composition schematic diagram of Set Top Box of the present invention, this Set Top Box comprises: data acquisition module 1, data processing module 2 and data memory module 3, wherein:
Described data acquisition module 1, for obtaining the operationally required database file of Set Top Box.
Described database file comprises in aerial information, satellite information, frequency point information, programme information and system configuration information one or multinomial.These information can obtain from establishing with this Set Top Box the equipment such as the USB flash disk of data cube computation or computer, also by being supplied to user's edit tool, can obtain the information that user is manually inputted by this edit tool.
Wherein, comprise in the mode of the database files such as aerial information, satellite information, frequency point information, programme information and system configuration information what manually inputted by acquisition user, can in Set Top Box the edit tool of built-in PC end, described data acquisition module 1 obtains the operationally required database file of the Set Top Box of user's input by this edit tool.Concrete, user can be discharged by Set Top Box producer and hold edit tool to this PC of user, when running PC and holding edit tool, carry out data edition visually, input the information such as corresponding aerial information, satellite information, frequency point information, programme information and system configuration information, obtain this data to make described data acquisition module 1.User's default database of generation can load alone or be upgraded in Set Top Box by user; Or this user's default database is sent to producer by user, manufacturer production time it can be used as default data to be loaded in database.This PC holds edit tool to be C/S framework, and operation is relatively simple, and user directly can input data, mainly comprises the title of data and the value of data.In addition, described database file is except the contents such as above-mentioned aerial information, satellite information, frequency point information, programme information and system configuration information, also can comprise some more complicated data or data types, as the configuration, the configuration of start-up picture data, the configuration of interface menu etc. of set-top-box system data.Namely user with the above-mentioned each data of the relation database table editor of two dimension in excel table, to make described data acquisition module 1 obtain these data, can obtain the operationally required database file of Set Top Box.
In addition, described data acquisition module 1 is when acquisition data, need to the data transmitted from the equipment such as USB flash disk or computer, or the data of user's input judge, determine that whether data are legal, namely judge whether these data meet corresponding aerial information, satellite information, frequency point information, the substantive requirements of form of the information such as programme information and system configuration information, as whether comprised the name of satellite in satellite information, the longitude and latitude of satellite, the local oscillator etc. of satellite, if, using the described data that obtain as the operationally required database file of Set Top Box, otherwise, abandon this data, or while abandoning data, point out user data input error.
Described data acquisition module 1 exports described database file to described data processing module 2 with text file format (* .txt) or binary file (* .uuf, * .bin).
Described data processing module 2, for carrying out Unified coding according to the coding rule preset to the database file that described data acquisition module 2 obtains, and converts the database file after coding to predetermined data format.
The main work of described data processing module 2 is the database file of text or (* .uuf) file exported by described data acquisition module 1 converts Unified coding to data according to the coding rule preset, and becomes specific data format to export this data transaction.
Concrete, such as, this coding rule preset can be: each character accounts for the ASCII coding of a byte, the coding rule that can certainly identify for some other computer.Convert the text data of each information in database file to ASCII character and according to specific formatted output, need step to be processed to comprise: converting the value (being all with tab tabulation in excel) of all tab keys in text data to space; Again the text data after conversion is converted to the sheet format of bivariate table definition, the data on the process excel table of a record record, and convert the record after process to header file (* .h) or binary file (* .bin) file etc.
The output file of described data processing module 2 is header file (* .h) or binary file (* .bin) file.
Described data memory module 3, for storing the database file of the converted tentation data form of described data processing module 2.
Concrete, the data format that data processing module 2 exports by described data memory module 3 is that the database file of * .h or * .bin stores by the form of the data store organisation defined in flash, thus achieves all unified data of set top box storehouse of every terms of information in coded system and data format in database file.Can store according to forms such as bivariate tables the every terms of information in the database file of changed into predetermined data format.
A series of attributes such as in addition, the bivariate table corresponding to each information in described database file has Table Header information, and this Table Header information comprises the size of table, name, memory address, and whether table can be write, readable.Respectively by system configuration bivariate table main in Set Top Box, satellite data bivariate table, antenna data bivariate table, frequency point data bivariate table, the database file of program data bivariate table etc. is stored in corresponding flash memory address, this makes to make mistakes by a certain bivariate table wherein, or when needing amendment renewal etc. to operate, directly find corresponding bivariate table to carry out process operation according to gauge outfit, facilitate programmer to safeguard, amendment, transplants.
The present invention is by carrying out unified coding to the database file obtained and the data converting identical data format to are stored in database, realize the unification of every terms of information in coded system and data format in the database file in data of set top box storehouse, avoid due to various information in data of set top box storehouse difference cause the problem of data base administration confusion, facilitate user and unified management is carried out to the data in data of set top box storehouse, also the cycle of the software development relevant to database is shortened, improve the maintainability in data of set top box storehouse, availability, and make the transplanting of database comparatively easy.
Refer to Fig. 2 again, it is the second example structure composition schematic diagram of Set Top Box of the present invention, Set Top Box in the present embodiment comprises the described data acquisition module 1 in above-mentioned first embodiment, and data processing module 2 and data memory module 3, comprise in the present embodiment further:
Data Analysis load-on module 4, for when set-top box software starts, resolves the database file converting predetermined data format to described in storing, and is loaded in internal memory and runs.
By described data acquisition module 1, data processing module 2 and data memory module 3 store the database file accordingly with Unified coding form, Uniform data format, after establishing corresponding database, when Set Top Box uses, namely, when set-top box software starts, parsing and the loading of being carried out the database file in database by this Data Analysis load-on module 4 is also needed.Described Data Analysis load-on module 4 is equally according to the coding rule (coding rule identical with described data processing module 2) preset, to the system configuration bivariate table in database file, satellite data bivariate table, antenna data bivariate table, frequency point data bivariate table, the bivariate tables such as program data bivariate table are resolved, and each bivariate table after resolving is loaded in internal memory and is run.
Further, as shown in Figure 2, the described data acquisition module 1 in the Set Top Box of the present embodiment specifically comprises:
Acquiring unit, the data that the Set Top Box for obtaining user's input is operationally required.
Judging unit, whether legal for judging the data that described acquiring unit obtains, if so, using the described data that obtain as the operationally required database file of Set Top Box, otherwise, abandon this data.
Further, as shown in Figure 2, the Set Top Box of the present embodiment also can comprise:
Compression module 5, whether the size of data for the database file judging the predetermined data format that described data processing module 2 converts to exceedes the size of top-set hardware memory space, and when being judged as YES, compression process is carried out to the described database file converting tentation data form to.
Database file after described compression module 5 compresses, before carried out parsing loading by described Data Analysis load-on module 4, first described Data Analysis load-on module 4 performs the operation of decompression, then resolves the database file after decompressing and load.
Further, as shown in Figure 2, the Set Top Box of the present embodiment also can comprise:
Data recovery module 6, for when described Data Analysis load-on module 4 loads failed, exit this to resolve and load operation the database file converting predetermined data format described in storage to, before recovery, load the database file of successfully predetermined data format.Namely, when this Data import is unsuccessful, automatically to recover before this and in time apart from the successful data of the recent loading of this Data import.
Retrieval arranges module 7, for when set-top box software starts, carries out retrieval arrange the bivariate table stored, so that realize the retrieval to information in the described database file stored.
Described database file comprises in aerial information, satellite information, frequency point information, programme information and system configuration information one or multinomial, and described data memory module 3 store described in convert in the database file of predetermined data format, can store according to the form of bivariate table the every terms of information in the described database file converting predetermined data format to.When set-top box software starts, described retrieval arranges module 7 and performs corresponding setting operation so that after set-top box software starts, corresponding information in database file of checking can be retrieved, wherein, carry out retrieval setting to the bivariate table stored then specifically to comprise: set up into two scale in each bivariate table by the mode of every bar record; The chained list of row is set up by the attribute arranged in bivariate table; The tables of data of load default (namely can not be empty table) on demand; Corresponding chained list is set up by the pattern of sequence; And generate the operations such as event handling function.The interface of the visit data chained list of unified data management module is provided simultaneously.This makes upper layer application etc. by table name word access data, by the data of the attribute access row of row in table, can press major key search records of record etc.
Further, as shown in Figure 2, the Set Top Box of the present embodiment also can comprise:
Data management module 8, for providing unified calling interface for database, so that calling the database file in database.This module, for providing a unified calling interface to other module range databases, facilitates the database file in other application call databases.The management of Set Top Box to the database file in database is main: trigger the storage of data, amendment, inquiry, sequence, event and be loaded into the medium operation of internal memory, and described data management module 8 provides unified calling interface can make faster to facilitate the Management Operation Ratios of database for database.If need the result of operation to be saved in flash after bookkeeping, data are saved in flash data storehouse by the data management process of data management module 8.Have in administration module: data management process, application process, queue, and the access etc. of flash.
The present invention is by carrying out unified coding to the database file obtained and the data converting identical data format to are stored in database, realize the unification of every terms of information in coded system and data format in the database file in data of set top box storehouse, avoid due to various information in data of set top box storehouse difference cause the problem of data base administration confusion, facilitate user and unified management is carried out to the data in data of set top box storehouse, also the cycle of the software development relevant to database is shortened, improve the maintainability in data of set top box storehouse, availability, and make the transplanting of database comparatively easy.
Refer to Fig. 3, be the first example structure composition schematic diagram of the implementation method in data of set top box storehouse of the present invention, the method comprises:
S301: obtain the database file that Set Top Box is operationally required.
Concrete, necessaryly when Set Top Box is run in described database file comprise in aerial information, satellite information, frequency point information, programme information and system configuration information one or multinomial.These information can obtain from establishing with this Set Top Box the equipment such as the USB flash disk of data cube computation or computer, also by being supplied to user's edit tool, can obtain the information that user is manually inputted by this edit tool.
Wherein, comprise in the mode of the database files such as aerial information, satellite information, frequency point information, programme information and system configuration information what manually inputted by acquisition user, can in Set Top Box the edit tool of built-in PC end, described data acquisition module 1 obtains the operationally required database file of the Set Top Box of user's input by this edit tool.Concrete, user can be discharged by Set Top Box producer and hold edit tool to this PC of user, when running PC and holding edit tool, carry out data edition visually, input the information such as corresponding aerial information, satellite information, frequency point information, programme information and system configuration information, obtain this data to make described S301.User's default database of generation can load alone or be upgraded in Set Top Box by user; Or this user's default database is sent to producer by user, manufacturer production time it can be used as default data to be loaded in database.This PC holds edit tool to be C/S framework, and operation is relatively simple, and user directly can input data, mainly comprises the title of data and the value of data.
In addition, described database file is except the contents such as above-mentioned aerial information, satellite information, frequency point information, programme information and system configuration information, also can comprise some more complicated data or data types, as the configuration, the configuration of start-up picture data, the configuration of interface menu etc. of set-top-box system data.Namely user with the above-mentioned each data of the relation database table editor of two dimension in excel table, to make described S301 obtain these data, can obtain the operationally required database file of Set Top Box.
In addition, described S301 is when acquisition data, need to the data transmitted from the equipment such as USB flash disk or computer, or the data of user's input judge, determine that whether data are legal, namely judge whether these data meet corresponding aerial information, satellite information, frequency point information, the substantive requirements of form of the information such as programme information and system configuration information, as whether comprised the name of satellite in satellite information, the longitude and latitude of satellite, the local oscillator etc. of satellite, if, using the described data that obtain as the operationally required database file of Set Top Box, otherwise, abandon this data, or while abandoning data, point out user data input error.
Described S301 exports described database file with text file format (* .txt) or (* .uuf).
S302: Unified coding is carried out to described database file according to the coding rule preset, and convert the database file after coding to predetermined data format.
The main work of described S302 is the database file of text or (* .uuf) file exported by described S301 converts Unified coding to data according to the coding rule preset, and becomes specific data format to export this data transaction.
Concrete, such as, this coding rule preset can be: each character accounts for the ASCII coding of a byte, the coding rule that can certainly identify for some other computer.Convert text data to ASCII character and according to specific formatted output, need step to be processed to comprise: converting the value (being all with tab tabulation in excel) of all tab keys in the text data of each information in database file to space; Again by the text data transaction sheet format that becomes bivariate table to define after conversion, data on the process excel table of a record record, and converting the record after process to * .h or * .bin file etc., the output file of described S302 is * .h or * .bin file.
S303: the database file converting predetermined data format described in storage to.
Concrete, concrete, the data format that data processing module 2 exports by described data memory module 3 is that the database file of * .h or * .bin stores by the form of the data store organisation defined in flash.Can store according to forms such as bivariate tables the every terms of information in the described database file converting predetermined data format to.
A series of attributes such as in addition, the bivariate table corresponding to each information in described database file has Table Header information, and this Table Header information comprises the size of table, name, memory address, and whether table can be write, readable.Respectively by system configuration bivariate table main in Set Top Box, satellite data bivariate table, antenna data bivariate table, frequency point data bivariate table, the database file of program data bivariate table etc. is stored in corresponding flash memory address, this makes to make mistakes by a certain bivariate table wherein, or when needing amendment renewal etc. to operate, directly find corresponding bivariate table to carry out process operation according to gauge outfit, facilitate programmer to safeguard, amendment, transplants.
The present invention is by carrying out unified coding to the database file obtained and the data converting identical data format to are stored in database, realize the unification of every terms of information in coded system and data format in the database file in data of set top box storehouse, avoid due to various information in data of set top box storehouse difference cause the problem of data base administration confusion, facilitate user and unified management is carried out to the data in data of set top box storehouse, also the cycle of the software development relevant to database is shortened, improve the maintainability in data of set top box storehouse, availability, and make the transplanting of database comparatively easy.
Refer to Fig. 4 again, be the second example structure composition schematic diagram of the implementation method in data of set top box storehouse of the present invention, the method comprises:
S401: obtain the data that the Set Top Box of user's input is operationally required.These data can comprise in aerial information, satellite information, frequency point information, programme information and system configuration information one or multinomial, and the data such as some other configuration as set-top-box system data, the configuration of start-up picture data, configuration of interface menu.
S402: judge that whether the described data obtained are legal.If so, step S403 is performed, otherwise, abandon this data, or point out user's input error while abandoning.
Need judge the data of user's input, determine that whether data are legal, namely judge whether these data meet the substantive requirements of form of the information such as corresponding aerial information, satellite information, frequency point information, programme information and system configuration information, as whether comprised name, the longitude and latitude of satellite, the local oscillator etc. of satellite of satellite in satellite information, if, using the described data that obtain as the operationally required database file of Set Top Box, otherwise, abandon this data, or point out user data input error while abandoning data.
S403: using the described data that obtain as the operationally required database file of Set Top Box, according to the coding rule preset, Unified coding is carried out to described database file, and convert the database file after coding to predetermined data format.
S404: whether the size of data converting the database file of predetermined data format described in judgement to exceedes the size of top-set hardware memory space.If so, S405 is performed, otherwise, perform S406.
S405: compression process is carried out to the described database file converting predetermined data format to.
Can store according to the form of bivariate table the every terms of information in the described database file converting predetermined data format to.
S406: the database file converting predetermined data format described in storage to.
Above-mentioned steps achieves carries out Unified coding by the information of various forms that user inputs and the data converting Uniform data format to store, and achieves all unified data of set top box storehouse of every terms of information in coded system and data format in database file.Meanwhile, after set-top box software starts, the method also comprises the following steps:
S407: the database file converting predetermined data format to described in storing is resolved, and be loaded in internal memory and run, retrieval is carried out to the bivariate table stored and arranges, so that realize the retrieval of information in the described database file to storage.
After establishing corresponding database by described S401 to S406, when Set Top Box uses, namely when set-top box software starts, S407 carries out parsing and the loading of the database file in database.Described S407 is equally according to the coding rule (coding rule identical with described S403) preset, to the system configuration bivariate table in database file, satellite data bivariate table, antenna data bivariate table, frequency point data bivariate table, the bivariate tables such as program data bivariate table are resolved, and each bivariate table after resolving is loaded in internal memory and is run.
S408: judge that whether loading is successful, if load successfully, then terminate, if when loading unsuccessfully, then perform S409.
S409: exit this and database file converting predetermined data format described in storage to is resolved and load operation, load the database file of successfully predetermined data format before recovery.
The present invention is by carrying out unified coding to the database file obtained and the data converting identical data format to are stored in database, realize the unification of every terms of information in coded system and data format in the database file in data of set top box storehouse, avoid due to various information in data of set top box storehouse difference cause the problem of data base administration confusion, facilitate user and unified management is carried out to the data in data of set top box storehouse, also the cycle of the software development relevant to database is shortened, improve the maintainability in data of set top box storehouse, availability, and make the transplanting of database comparatively easy.
One of ordinary skill in the art will appreciate that all or part of flow process realized in above-described embodiment method, that the hardware that can carry out instruction relevant by computer program has come, described program can be stored in a computer read/write memory medium, this program, when performing, can comprise the flow process of the embodiment as above-mentioned each side method.Wherein, described storage medium can be magnetic disc, CD, read-only store-memory body (Read-Only Memory, ROM) or random store-memory body (Random Access Memory, RAM) etc.
Above disclosedly be only present pre-ferred embodiments, certainly can not limit the interest field of the present invention with this, therefore according to the equivalent variations that the claims in the present invention are done, still belong to the scope that the present invention is contained.

Claims (12)

1. the implementation method in data of set top box storehouse, is characterized in that, comprising:
Obtain the database file that Set Top Box is operationally required; The bivariate table corresponding to each information in described database file is provided with Table Header information, and described Table Header information comprises the access limit of the size of bivariate table, name, memory address and bivariate table;
According to the coding rule preset, Unified coding is carried out to described database file, and convert the database file after coding to predetermined data format, described default coding rule comprises ASCII ASCII coding rule, specifically comprise: the text data of each information in described database file is converted to ASCII ASCII character and the text data after conversion is converted to the sheet format of bivariate table definition, and convert the data record after process to predetermined data format, described predetermined data format comprises header file h or binary system bin data format,
The database file of predetermined data format is converted to described in storage;
When set-top box software starts, two scale is set up into by the mode of every bar record in each bivariate table, the chained list of row is set up by the attribute arranged in bivariate table, the tables of data of the non-NULL of load default on demand, corresponding chained list is set up by the pattern of sequence, and generation event handling function, so that realize the retrieval to information in the described database file stored.
2. the method for claim 1, is characterized in that, also comprises: when set-top box software starts, and resolves the database file converting predetermined data format to described in storing, and is loaded in internal memory and runs.
3. method as claimed in claim 2, is characterized in that, the step of the database file that described acquisition Set Top Box is operationally required, comprising:
Obtain the data that the Set Top Box of user's input is operationally required;
Judge that whether the described data obtained legal, if so, using the described data that obtain as the operationally required database file of Set Top Box, otherwise, abandon this data.
4. method as claimed in claim 3, is characterized in that, before the step of database file converting predetermined data format described in described storage to, also comprise:
Whether the size of data converting the database file of predetermined data format described in judgement to exceedes the size of top-set hardware memory space;
If so, compression process is carried out to the described database file converting predetermined data format to.
5. method as claimed in claim 2, is characterized in that, also comprise:
If resolving the database file converting predetermined data format described in storage to, and be loaded in the process run in internal memory, if when loading unsuccessfully, then exit this to resolve and load operation the database file converting predetermined data format described in storage to, before recovery, load the database file of successfully predetermined data format.
6. the method as described in claim 4 or 5, is characterized in that, described database file comprises in aerial information, satellite information, frequency point information, programme information and system configuration information one or multinomial;
Converting in the step of the database file of predetermined data format described in described storage, is store according to the form of bivariate table to the every terms of information in the described database file converting predetermined data format to.
7. the implement device in data of set top box storehouse, is characterized in that, comprising:
Data acquisition module, for obtaining the operationally required database file of Set Top Box; The bivariate table corresponding to each information in described database file is provided with Table Header information, and described Table Header information comprises the access limit of the size of bivariate table, name, memory address and bivariate table;
Data processing module, for carrying out Unified coding according to the coding rule preset to described database file, and convert the database file after coding to predetermined data format, described default coding rule comprises ASCII ASCII coding rule, specifically comprise: the text data of each information in described database file is converted to Unite States Standard information exchange ASCII character and the text data after conversion is converted to the sheet format of bivariate table definition, and convert the record after process to predetermined data format, described predetermined data format comprises header file h or binary system bin data format,
Data memory module, for storing the database file of the converted tentation data form of described data processing module;
Retrieval arranges module, for when set-top box software starts, two scale is set up into by the mode of every bar record in each bivariate table, the chained list of row is set up by the attribute arranged in bivariate table, the tables of data of the non-NULL of load default on demand, set up corresponding chained list by the pattern of sequence, and generate event handling function, so that realize the retrieval to information in the described database file stored.
8. device as claimed in claim 7, is characterized in that, also comprise:
Data Analysis load-on module, for when set-top box software starts, resolves the database file converting predetermined data format to described in storing, and is loaded in internal memory and runs.
9. device as claimed in claim 8, it is characterized in that, described data acquisition module comprises:
Acquiring unit, the data that the Set Top Box for obtaining user's input is operationally required;
Judging unit, whether legal for judging the data that described acquiring unit obtains, if so, using the described data that obtain as the operationally required database file of Set Top Box, otherwise, abandon this data.
10. device as claimed in claim 9, is characterized in that, also comprise:
Compression module, whether the size of data for the database file judging the predetermined data format that described data processing module converts to exceedes the size of top-set hardware memory space, and when being judged as YES, compression process is carried out to the described database file converting tentation data form to.
11. devices as claimed in claim 8, is characterized in that, also comprise:
Data recovery module, if for resolving the database file converting predetermined data format described in storage to, and be loaded in the process run in internal memory, if when loading unsuccessfully, exit this to resolve and load operation the database file converting predetermined data format described in storage to, before recovery, load the database file of successfully predetermined data format.
12. devices as claimed in claim 11, it is characterized in that, described database file comprises in aerial information, satellite information, frequency point information, programme information and system configuration information one or multinomial, and it is store according to the form of bivariate table that described data memory module is used for the every terms of information in the described database file converting predetermined data format to.
CN201110101677.0A 2011-04-22 2011-04-22 Realizing method of STB (Set Top Box) database and STB Active CN102750290B (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN201110101677.0A CN102750290B (en) 2011-04-22 2011-04-22 Realizing method of STB (Set Top Box) database and STB

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN201110101677.0A CN102750290B (en) 2011-04-22 2011-04-22 Realizing method of STB (Set Top Box) database and STB

Publications (2)

Publication Number Publication Date
CN102750290A CN102750290A (en) 2012-10-24
CN102750290B true CN102750290B (en) 2015-04-29

Family

ID=47030482

Family Applications (1)

Application Number Title Priority Date Filing Date
CN201110101677.0A Active CN102750290B (en) 2011-04-22 2011-04-22 Realizing method of STB (Set Top Box) database and STB

Country Status (1)

Country Link
CN (1) CN102750290B (en)

Families Citing this family (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN105653506B (en) * 2015-12-30 2019-07-12 北京奇艺世纪科技有限公司 It is a kind of based on character code conversion GPU in text-processing method and device
CN107330666A (en) * 2017-06-21 2017-11-07 王建 One kind coding management system

Citations (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN1512318A (en) * 2002-12-31 2004-07-14 北京中视联数字系统有限公司 Method for renewing set-top box software
CN101646037A (en) * 2008-08-08 2010-02-10 鸿富锦精密工业(深圳)有限公司 Electronic program list server and electronic program list processing method thereof
CN101959006A (en) * 2010-09-25 2011-01-26 深圳市迎风传讯科技有限公司 Set top box and method for processing programs by same

Patent Citations (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN1512318A (en) * 2002-12-31 2004-07-14 北京中视联数字系统有限公司 Method for renewing set-top box software
CN101646037A (en) * 2008-08-08 2010-02-10 鸿富锦精密工业(深圳)有限公司 Electronic program list server and electronic program list processing method thereof
CN101959006A (en) * 2010-09-25 2011-01-26 深圳市迎风传讯科技有限公司 Set top box and method for processing programs by same

Also Published As

Publication number Publication date
CN102750290A (en) 2012-10-24

Similar Documents

Publication Publication Date Title
CN103500196A (en) EXCEL data export method and export device in multi-concurrence large data volume environment
CN104133772A (en) Automatic test data generation method
CN102236672A (en) Method and device for importing data
CN108334609B (en) Method, device, equipment and storage medium for realizing JSON format data access in Oracle
CN111061475B (en) Software code generating method, device, computer equipment and storage medium
US8880463B2 (en) Standardized framework for reporting archived legacy system data
CN109062925B (en) Method, device, computer equipment and storage medium for automatically generating insert sentences
CN115391439B (en) Document data export method, device, electronic equipment and storage medium
CN111367975A (en) Multi-protocol data conversion processing method and device
CN112328631A (en) Production fault analysis method and device, electronic equipment and storage medium
CN101290622A (en) Database cleaning system and method
CN102750290B (en) Realizing method of STB (Set Top Box) database and STB
CN114706915A (en) Method for building BOM information from PLM system by EDA software
CN108108478B (en) Data format conversion method and system and electronic equipment
CN101388018A (en) Computer aided design document management method
CN113722337B (en) Service data determination method, device, equipment and storage medium
CN115729933A (en) Structured bill of material management method, system and storage medium
CN105224317A (en) A kind of APK is applied to the method and system in Android project source code
CN101425079B (en) NV data processing method and apparatus
CN101894098B (en) Embedded font data processing method and device
CN115774745A (en) Extraction method and system for high-capacity Excel file data
CN113177059A (en) Method and device for generating matching platform SQL script
CN103164526A (en) Generation method and generation device of test report
CN103164468A (en) Patent sort management method and management system
CN111045917A (en) Method and device for converting format of test case

Legal Events

Date Code Title Description
C06 Publication
PB01 Publication
C10 Entry into substantive examination
SE01 Entry into force of request for substantive examination
C53 Correction of patent for invention or patent application
CB02 Change of applicant information

Address after: 518000 Guangdong city of Shenzhen province Nanshan District Gao Xin Road Building A14, SKYWORTH

Applicant after: Shenzhen Skyworth Digital Technology Co., Ltd.

Address before: 518000 Guangdong city of Shenzhen province Nanshan District Gao Xin Road Building A14, SKYWORTH

Applicant before: Shenzhen Skyworth Digital Technology Co., Ltd.

COR Change of bibliographic data

Free format text: CORRECT: APPLICANT; FROM: SKY-WORTH DIGITAL TECHNOLOGY CO., LTD.;SHENZHEN CITY TO: SHENZHEN SKYWORTH DIGITAL TECHNOLOGY CO., LTD.

C14 Grant of patent or utility model
GR01 Patent grant