CN110019328A - A kind of data processing method and device based on mobile terminal application class - Google Patents
A kind of data processing method and device based on mobile terminal application class Download PDFInfo
- Publication number
- CN110019328A CN110019328A CN201710617162.3A CN201710617162A CN110019328A CN 110019328 A CN110019328 A CN 110019328A CN 201710617162 A CN201710617162 A CN 201710617162A CN 110019328 A CN110019328 A CN 110019328A
- Authority
- CN
- China
- Prior art keywords
- database
- information table
- critical field
- data
- information
- 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.)
- Pending
Links
- 238000003672 processing method Methods 0.000 title claims abstract description 11
- 238000000034 method Methods 0.000 claims abstract description 16
- 238000012545 processing Methods 0.000 claims abstract description 13
- 238000012546 transfer Methods 0.000 claims abstract description 8
- 238000013507 mapping Methods 0.000 claims description 41
- 238000000605 extraction Methods 0.000 claims description 10
- 238000012217 deletion Methods 0.000 abstract description 2
- 230000037430 deletion Effects 0.000 abstract description 2
- 230000004044 response Effects 0.000 abstract description 2
- 230000001960 triggered effect Effects 0.000 description 6
- 238000003780 insertion Methods 0.000 description 5
- 230000037431 insertion Effects 0.000 description 5
- 238000012986 modification Methods 0.000 description 4
- 230000004048 modification Effects 0.000 description 4
- 230000008569 process Effects 0.000 description 4
- 230000008859 change Effects 0.000 description 3
- 239000000284 extract Substances 0.000 description 2
- 238000009434 installation Methods 0.000 description 2
- 230000000149 penetrating effect Effects 0.000 description 2
- 239000011800 void material Substances 0.000 description 2
- 241001269238 Data Species 0.000 description 1
- 230000009286 beneficial effect Effects 0.000 description 1
- 230000008901 benefit Effects 0.000 description 1
- 238000010276 construction Methods 0.000 description 1
- 238000010586 diagram Methods 0.000 description 1
- 230000006870 function Effects 0.000 description 1
- 238000004321 preservation Methods 0.000 description 1
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/22—Indexing; Data structures therefor; Storage structures
- G06F16/2228—Indexing structures
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
- G06F16/2453—Query optimisation
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Computational Linguistics (AREA)
- Software Systems (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses a kind of data processing methods and device based on mobile terminal application class, and this method application is on mobile terminals, which comprises establishes database for the mobile terminal；Virtual table corresponding with the information table in the database is created, the Virtual table is stored with the corresponding information of critical field in the information table；When carrying out data retrieval, the Virtual table is retrieved according to the critical field, to transfer corresponding data from the information table.This method can effectively improve retrieval rate when data processing, and can easily carry out the retrieval of data, the operation such as inquiry or deletion, additionally it is possible to improve the response speed of mobile device application class, improve user experience.
Description
Technical field
The present invention relates to data processing field, in particular to a kind of data processing method based on mobile terminal application class and
Device.
Background technique
Data processing is being carried out using class to mobile terminal (such as smart phone with Android system) at present, especially
When carrying out the operation such as retrieval of data, carry out the operation such as retrieving usually using the mode of fuzzy query, such as carry out full table and sweep
The mode retouched carries out, and for the data processing method due to matching algorithm itself, the field length of fuzzy query is bigger, obscures
Search efficiency is lower, is greatly increased the burden of operation in this way, often to expend mobile terminal CPU and memory it is a large amount of
Resource, so as to cause class (such as application program) Caton, poor user experience is applied.
Summary of the invention
The embodiment of the present invention is designed to provide a kind of data processing method and device based on mobile terminal application class,
This method can effectively improve retrieval rate when data processing, improve user experience.
In order to solve the above-mentioned technical problem, the embodiment of the present invention adopts the technical scheme that a kind of based on mobile terminal
Using the data processing method of class, using on mobile terminals, which comprises
Database is established for the mobile terminal；
Virtual table corresponding with the information table in the database is created, the Virtual table is stored in the information table
The corresponding information of critical field；
When carrying out data retrieval, the Virtual table is retrieved according to the critical field, with from the information table
In transfer corresponding data.
Preferably, after creating Virtual table corresponding with the information table in the database, the method also includes:
The Virtual table and information table are subjected to real time correlation, to timely update the void according to the variation of the information table
Quasi- table.
Preferably, the creation Virtual table corresponding with the information table in the database includes:
Classification creates at least one described information table in the database；
Critical field is extracted in the information table, and establish critical field data corresponding with the critical field it
Between mapping relations；
The Virtual table is established according to the critical field and mapping relations.
Preferably, described retrieve the Virtual table according to the critical field, from the information table
Transferring corresponding data includes:
The Virtual table is retrieved using the critical field；
The mapping relations are obtained in the Virtual table according to the critical field；
Corresponding data is obtained from the information table by the mapping relations.
Preferably, described establishes database for the mobile terminal specifically: extremely for the mobile terminal
A few application program establishes database.
The embodiment of the invention also provides a kind of data processing equipment based on mobile terminal application class, apply mobile whole
On end, there is database for mobile terminal foundation, described device includes creation module and retrieval module interconnected；
The creation module is connect with database, and the creation module is configured to creation and the information table in the database
Corresponding Virtual table, the Virtual table are stored with the corresponding information of critical field in the information table；
The retrieval module is connect with database, and the retrieval module is configured to when carrying out data retrieval, according to described
Critical field retrieves the Virtual table, to transfer corresponding data from the information table.
Preferably, described device further includes update module；
The update module is connect with database, and the update module is configured to carry out the Virtual table and information table real
Shi Guanlian, to be timely updated the Virtual table according to the variation of the information table.
Preferably, the creation module includes taxon, extraction unit and unit is established；
The taxon, which is configured to classify in the database, creates at least one described information table；
The extraction unit is connect with unit is established, and the extraction unit is configured to extract keyword in the information table
Section, so that the mapping relations establishing unit and establishing between the critical field and the relevant information of the critical field, and root
The Virtual table is established according to the critical field and mapping relations.
Preferably, the retrieval module includes acquiring unit and retrieval unit；
The retrieval unit is configured so that the critical field retrieves the Virtual table；
The acquiring unit is connect with the retrieval unit and database respectively, and the acquiring unit is configured to according to
Critical field obtains the mapping relations in the Virtual table, and obtains phase from the information table by the mapping relations
Answer data.
Preferably, the database is the database established at least one application program of the mobile terminal.
The beneficial effect of the embodiment of the present invention is: this method can effectively improve retrieval rate when data processing, and
The retrieval of data, the operation such as inquiry or deletion can easily be carried out, additionally it is possible to the response speed of mobile device application class is improved,
Improve user experience.
Detailed description of the invention
Fig. 1 is the flow chart of the data processing method based on mobile terminal application class of the embodiment of the present invention；
Fig. 2 is the flow chart of the creation Virtual table corresponding with the information table in database of the embodiment of the present invention；
Fig. 3 be the embodiment of the present invention slave information table in transfer the flow chart of corresponding data；
Fig. 4 is the connection relationship diagram of the data processing equipment based on mobile terminal application class of the embodiment of the present invention.
Description of symbols
1- data processing equipment 2- creation module 3- retrieval module
4- update module 5- Virtual table 6- database
Specific embodiment
Various schemes and feature of the invention are described herein with reference to attached drawing.
It should be understood that various modifications can be made to the embodiment invented herein.Therefore, description above should not regard
To limit, and only as the example of embodiment.Those skilled in the art will expect within the scope and spirit of this invention
Other modifications.
The attached drawing being included in the description and forms part of the description shows the embodiment of the present invention, and with it is upper
What face provided is used to explain the present invention substantially description and the detailed description given below to embodiment of the invention together
Principle.
It is of the invention by the description of the preferred form with reference to the accompanying drawings to the embodiment for being given as non-limiting example
These and other characteristic will become apparent.
Although being also understood that invention has been described referring to some specific examples, those skilled in the art
Member realizes many other equivalents of the invention in which can determine, they have feature as claimed in claim and therefore all
In the protection scope defined by whereby.
When read in conjunction with the accompanying drawings, in view of following detailed description, above and other aspect of the invention, feature and advantage will become
It is more readily apparent.
Specific embodiments of the present invention are described hereinafter with reference to attached drawing；It will be appreciated, however, that the embodiment invented is only
Various ways implementation can be used in example of the invention.Known and/or duplicate function and structure and be not described in detail to avoid
Unnecessary or extra details makes the present invention smudgy.Therefore, the specific structural and functionality invented herein is thin
Section is not intended to restrictions, but as just the basis of claim and representative basis be used to instructing those skilled in the art with
Substantially any appropriate detailed construction diversely uses the present invention.
This specification can be used phrase " in one embodiment ", " in another embodiment ", " in another embodiment
In " or " in other embodiments ", it can be referred to one or more of identical or different embodiment according to the present invention.
A kind of data processing method based on mobile terminal application class of the embodiment of the present invention, using on mobile terminals,
It can be the various types of programs being mounted on mobile terminal, such as the operating system of mobile terminal, mobile terminal using class
Various types of application programs etc., which includes:
S1 establishes database 6 for mobile terminal.The database 6 can store the various data about mobile terminal,
The data that mobile terminal saves can be stored in the database 6, wherein mobile terminal can install several operation systems, such as
Android operation system.In one embodiment, multiple corresponding databases 6, example can be established according to the type of storing data
Such as, corresponding database 6 is established respectively for the cinematic data and document data of mobile terminal preservation, carrying out data processing
When, it the purposive data called in corresponding database 6 and can be handled according to process object.
S2, creates Virtual table 5 corresponding with the information table in database 6, and Virtual table 5 is stored with keyword in information table
The corresponding information of section.Virtual table 5, which refers to, to be not physically exist, but logically there are table.In one embodiment, virtually
Table 5 be it is a kind of by query statement inquire constant expression formed a result set, in database 6 view, physical table,
Interim table is similar, can be similar to the operation to common table to the mode of operation of the Virtual table 5, Virtual table 5 has operation luck
Scanning frequency degree is fast, feature convenient to use.In one embodiment, the data of Virtual table 5 and table structure are stored among memory,
When exiting, shared by space can be released automatically, save amount of physical memory.A database 6 can in one embodiment
Multiple information tables are stored in sort data into, such as establish the database 6 (cantv.db) of a video application, for
For the database 6, all data of the video application can be respectively stored in user message table (userInfo), shadow
Piece information table (videoInfo) is watched record information list (watchRecordInfo), Information on Collection table (collectInfo)
It is same type Deng, data stored in each information table.In the present embodiment, Virtual table 5 is stored with critical field in information table
Corresponding information, and the relationship between information table is established by the corresponding information of the critical field, such as store in Virtual table 5
There are the name and other information of the director of film, then the Virtual table 5 can pass through the name of the director of the film and other letters
Breath and film information table (videoInfo) opening relationships.Furthermore in one embodiment, which can be created in shifting
In dynamic equipment.
S3 retrieves Virtual table 5 according to critical field, when carrying out data retrieval to transfer phase from information table
Answer data.Specifically, when being retrieved according to critical field to Virtual table 5 can quickly from Virtual table 5 obtain with
The corresponding relationship of the critical field, the relationship can in the form of a table, preset the form of retrieval scheme or the shape of data link
Formula embodies.It is shadow that the critical field in corresponding data, such as Virtual table 5 can be called from corresponding information table by the relationship
The name and other information of the director of piece can then be obtained from film information table (videoInfo) by above-mentioned critical field
All also has taken the title of other films, the prize-winning feelings of the director with the associated data of the critical field, such as director
The information such as condition.
It in one embodiment of the invention, should after creating Virtual table 5 corresponding with the information table in database 6
Data processing method based on mobile terminal application class further include: Virtual table 5 and information table are subjected to real time correlation, according to letter
The variation of breath table timely updates Virtual table 5.In one embodiment, can with predetermined time interval to information table whether generation
Variation is detected, and certain predetermined time interval can modify according to actual use situation, when in discovery information table
Data are changed, and the corresponding information of data variation is obtained, with more new data.In one embodiment, for Virtual table
(videoInfo_search) addition trigger (vir_videoInfo_update) is respectively set, deletes trigger (vir_
VideoInfo_delete) and/or be inserted into trigger (vir_videoInfo_insert) etc., trigger is not required to manually boot,
But triggered by event, complicated 6 language of database can be set in trigger, obey complicated business rule for forcing
Or it requires.When the data detected in information table are changed, then it can trigger above-mentioned trigger and work, be become according to data
The corresponding information of change the operation such as be added, delete and/or be inserted into Virtual table 5, for example, working as film information table
(videoInfo) when having content update, corresponding data is added in addition trigger (vir_videoInfo_update) immediately
To Virtual table videoInfo_search；When film information table (videoInfo) deletes data, trigger is deleted
(vir_videoInfo_delete) respective record being triggered in synchronization removal videoInfo_search；When film information table
(videoInfo) when having data insertion, insertion trigger (vir_videoInfo_insert) is triggered Virtual table
Corresponding data is inserted into videoInfo_search, so that Virtual table 5 and information table carry out real time correlation.
In one embodiment of the invention, creation Virtual table 5 corresponding with the information table in database 6 is wrapped
It includes:
S21, classification creates at least one information table in database 6.It in most cases can be according to data in database 6
Type creates multiple information tables, such as creates user message table (userInfo) in the database 6 of entitled cantv.db, shadow
Piece information table (videoInfo) watches record information list (watchRecordInfo) and Information on Collection table (collectInfo)
Deng can have the intersection of data between information table, and the relevant information for intersecting data can be pre-recorded.
S22 extracts critical field in information table, and establishes between critical field data corresponding with the critical field
Mapping relations.The critical field can be to be able to carry out the field of full-text search, and the corresponding data of critical field can be distributed in
Plurality of positions in the information table, and mapping relations can be many-one or one-to-many relationship, establish in the present embodiment crucial
One-to-many mapping relations, available in information table by critical field between field data corresponding with the critical field
Corresponding multiple data.
S23 establishes Virtual table 5 according to critical field and mapping relations.The Virtual table 5 of foundation can by critical field and
Mapping relations are contacted with information table foundation.In one embodiment, Virtual table 5 can be established according to critical field and mapping relations
Lesser data structure, so that being more easier to carry out it operation of data.In another embodiment, to critical field and reflecting
The relationship of penetrating establishes priority, so that can be according to above-mentioned priority when obtaining the data in information table by Virtual table 5
Preferentially to obtain corresponding data.Such as can be preferential by the name of director the film for obtaining its director information, and it is right
It can then be obtained again in the back alley news of the non-preferential director.
In one embodiment of the invention, described that Virtual table 5 is retrieved according to critical field, with from information table
In the step of transferring corresponding data include:
S31 retrieves Virtual table 5 using critical field.The retrieval mode is the most effective, and critical field
For the key message of corresponding data, can readily all related data retrievals be come out by carrying out retrieval by critical field.
S32 obtains mapping relations in Virtual table 5 according to critical field.Keyword has corresponding mapping relations, this is reflected
The relationship of penetrating can in the form of a table or the form etc. of link embodies, the mapping relations can be it is one-to-one, it is one-to-many, many-one or
The relationships such as multi-to-multi can also pass through the mapping according to the variation of data by the available corresponding data of the mapping relations
Relationship carries out Virtual table 5 to update operation accordingly.
S33 obtains corresponding data by mapping relations from information table.The mapping relations can be preset in the form of a table
The form of retrieval scheme or the form of data link embody.In one embodiment, specific for above-mentioned default retrieval scheme
For, it can be preset database command collection, acquisition modes can be operated or be limited by the database command collection
It is fixed.For example, user retrieves database 6 by keyword, formal change, or retrieval mesh can be carried out to keyword
The operations such as target restriction are such as retrieved according to film title from film information table (videoInfo) with optimizing retrieving, also
It can be retrieved according to the information of the data record obtained, such as be retrieved again according to the film being retrieved again
Other films of the same name.
In one embodiment of the invention, the mobile terminal that is directed to establishes database 6 specifically: for mobile whole
At least one application program at end establishes database 6.Application program that can be numerous with installation number on mobile terminal, at least
One application program establishes database 6 can be to avoid the confusion in establishment process in logic, and when operating to data
Can be targeted, and be easy to carry out data classification to generate multiple corresponding information tables, thus reach quickly to data into
The purpose of row operation.
In addition, in one embodiment, match sentence is used when retrieving according to critical field to Virtual table 5.No
It needs using Like sentence, to avoid retrieve for a long time waiting.Such as:
It is used when carrying out the matching of full table: SELECT*FROM videoInfo_search WHERE videoInfo_
Search MATCH ' needs matched field '；
The use when carrying out by column matching: SELECT*FROM videoInfo_search WHERE needs matched column name
MATCH ' needs matched field '.
The embodiment of the invention also provides a kind of data processing equipments 1 based on mobile terminal application class, apply in movement
In terminal, there is database 6 for mobile terminal foundation, which can store the various data about mobile terminal, can also
It is stored in the database 6 with the data for saving mobile terminal, wherein mobile terminal can install several operation systems, such as pacify
Tall and erect operating system.In one embodiment, multiple corresponding databases 6 can be established according to the type of storing data, for example,
The cinematic data and document data saved for mobile terminal establishes corresponding database 6 respectively, can when carrying out data processing
With the data called in corresponding database 6 purposive according to process object and handled.
The data processing equipment 1 includes creation module 2 interconnected and retrieval module 3.
Creation module 2 is connect with database 6, and it is corresponding with the information table in database 6 that creation module 2 is configured to creation
Virtual table 5, Virtual table 5 are stored with the corresponding information of critical field in information table.Virtual table 5, which refers to, to be not physically exist, but
Logically there are table.In one embodiment, the Virtual table 5 that creation module 2 creates is a kind of by query statement inquiry
The result set that constant expression is formed, it is similar with view, physical table, the interim table in database 6, to the Virtual table 5
Mode of operation can be similar to the operation to common table, the speed of service fast, convenient to use feature when Virtual table 5 has operation.
In one embodiment, the data of Virtual table 5 and table structure are stored among memory, when exiting, shared by space can be from
It is dynamic to be released, save amount of physical memory.A database 6, which can sort data into, in one embodiment is stored in multiple letters
Table is ceased, such as establishes the database 6 (cantv.db) of a video application, it, can be by the view for the database 6
All data of frequency application program are respectively stored in user message table (userInfo), film information table (videoInfo), viewing
Record information list (watchRecordInfo), Information on Collection table (collectInfo) etc., the data stored in each information table
For same type.In the present embodiment, the Virtual table 5 that creation module 2 creates is stored with the corresponding information of critical field in information table,
And the relationship between information table is established by the corresponding information of the critical field, such as leading for film is stored in Virtual table 5
The name and other information drilled, then the Virtual table 5 can be believed by the name and other information and film of the director of the film
Cease table (videoInfo) opening relationships.Furthermore in one embodiment, which can be created the creation of module 2 in movement
In equipment.
Retrieval module 3 is connect with database 6, and retrieval module 3 is configured to when carrying out data retrieval, according to critical field pair
Virtual table 5 is retrieved, to transfer corresponding data from information table.Specifically, retrieval module 3 according to critical field to void
Quasi- table 5 can quickly obtain relationship corresponding with the critical field from Virtual table 5 when being retrieved, which can be with
The form of the form of table, the form or data link of presetting retrieval scheme embodies.It can be from corresponding by the relationship retrieval module 3
Information table in call the critical field in corresponding data, such as Virtual table 5 to be the name and other information of the director of film, then
Retrieval module 3 can be obtained from the film information table (videoInfo) all with the critical field by above-mentioned critical field
Associated data, as the director also has taken the title of other films, the information such as prize-winning situation of the director.
In one embodiment of the invention, which further includes update module 4；Update module 4 and data
Library 6 connects, and update module 4 is configured to Virtual table 5 and information table carrying out real time correlation, with according to the variation of information table in time more
New Virtual table 5.
In one embodiment, update module 4 can the progress that whether changes with predetermined time interval to information table
Detecting, certain predetermined time interval can modify according to actual use situation, when update module 4 is found in information table
Data are changed, and the corresponding information of data variation is obtained, with more new data.In one embodiment, in update module 4
Addition trigger (vir_videoInfo_update) is respectively set for Virtual table (videoInfo_search), deletes triggering
Device (vir_videoInfo_delete) and/or insertion trigger (vir_videoInfo_insert) etc., trigger is not required to hand
Dynamic starting, but triggered by event, complicated 6 language of database can be set in trigger, obey complexity for forcing
Business rule or requirement.Changed when update module 4 detects the data in information table, then can trigger above-mentioned trigger into
Row work the operation such as be added, delete and/or be inserted into Virtual table 5 according to the corresponding information of data variation, for example, working as shadow
When piece information table (videoInfo) has content update, addition trigger (vir_videoInfo_update) is added immediately
Corresponding data is to Virtual table videoInfo_search；When film information table (videoInfo) deletes data, touching is deleted
The respective record that hair device (vir_videoInfo_delete) is triggered in synchronization removal videoInfo_search；When film is believed
When breath table (videoInfo) has data insertion, insertion trigger (vir_videoInfo_insert) is triggered Virtual table
Corresponding data is inserted into videoInfo_search, so that Virtual table 5 and information table carry out real time correlation.
In one embodiment of the invention, creation module 2 includes taxon, extraction unit and establishes unit.
Taxon is configured to the classification in database 6 and creates at least one information table.Taxon meeting in most cases
Multiple information tables are created according to the type of data in database 6, such as create user in the database 6 of entitled cantv.db
Information table (userInfo), film information table (videoInfo) are watched record information list (watchRecordInfo) and are collected
Information table (collectInfo) etc. can have the intersection of data between the information table of taxon creation, and intersect data
Relevant information can be pre-recorded.
Extraction unit is connect with unit is established, and extraction unit is configured to extract critical field in information table, so as to establish
Unit establishes the mapping relations between critical field and the relevant information of the critical field, and according to critical field and mapping relations
Establish Virtual table 5.The critical field that extraction unit extracts can be to be able to carry out the field of full-text search, and critical field is corresponding
Data can be distributed in plurality of positions in the information table, and mapping relations can be many-one or one-to-many relationship, in this reality
It applies and establishes unit in example and establish mapping relations one-to-many between critical field data corresponding with the critical field, pass through key
The available corresponding multiple data in information table of field.In one embodiment, establishing unit can be according to keyword
Section and mapping relations establish lesser data structure to Virtual table 5, so that being more easier to carry out it operation of data.Another
It in a embodiment, establishes unit and priority is established to critical field and mapping relations, so that obtaining information by Virtual table 5
Corresponding data can preferentially be obtained according to above-mentioned priority when data in table.Such as it can be excellent by the name of director
The information of the first film for obtaining its director, and the back alley news of the non-preferential director can be obtained then again.
In one embodiment of the invention, retrieval module 3 includes acquiring unit and retrieval unit；
Retrieval unit is configured so that critical field retrieves Virtual table 5.The retrieval mode is the most effective, and
And critical field is the key message of corresponding data, can readily all related datas be examined by carrying out retrieval by critical field
Rope comes out.
Acquiring unit is connect with retrieval unit and database 6 respectively, and acquiring unit is configured to according to critical field virtual
Mapping relations are obtained in table 5, and corresponding data is obtained from information table by mapping relations.There is keyword corresponding mapping to close
System, which can in the form of a table or the form etc. of link embodies, the mapping relations can be it is one-to-one, it is one-to-many,
The relationships such as many-one or multi-to-multi, for acquiring unit by the available corresponding data of the mapping relations, update module 4 can also be with
Virtual table 5 is carried out by the mapping relations according to the variation of data to update operation accordingly.The mapping relations can be with table
The form of form, the form or data link of presetting retrieval scheme embodies.In one embodiment, for above-mentioned default retrieval
Scheme specifically, can be preset database command collection, and acquiring unit can be to acquisition by the database command collection
Mode is operated or is limited.For example, user retrieves database 6 by keyword, form can be carried out to keyword
On change or searched targets the operation such as restriction to optimize retrieving, such as according to film title from film information table
(videoInfo) it is retrieved, can also be retrieved again according to the information of the data record obtained, such as according to
The film being retrieved retrieves other films of the same name again.
In one embodiment of the invention, database 6 is at least one application program foundation for mobile terminal
Database 6.Application program that can be numerous with installation number on mobile terminal, establishes database 6 at least one application program
Can be to avoid the confusion in establishment process in logic, and can be targeted when being operated to data, and be easy pair
Data carry out classification and generate multiple corresponding information tables, to achieve the purpose that quickly to operate data.
In addition, in one embodiment, match sentence is used when retrieving according to critical field to Virtual table 5.No
It needs using Like sentence, to avoid retrieve for a long time waiting.Such as:
It is used when carrying out the matching of full table: SELECT*FROM videoInfo_search WHERE videoInfo_
Search MATCH ' needs matched field '；
The use when carrying out by column matching: SELECT*FROM videoInfo_search WHERE needs matched column name
MATCH ' needs matched field '.
Above embodiments are only exemplary embodiment of the present invention, are not used in the limitation present invention, protection scope of the present invention
It is defined by the claims.Those skilled in the art can within the spirit and scope of the present invention make respectively the present invention
Kind modification or equivalent replacement, this modification or equivalent replacement also should be regarded as being within the scope of the present invention.
Claims (10)
1. a kind of data processing method based on mobile terminal application class, using on mobile terminals, which is characterized in that the side
Method includes:
Database is established for the mobile terminal；
Virtual table corresponding with the information table in the database is created, the Virtual table is stored in the information table crucial
The corresponding information of field；
When carrying out data retrieval, the Virtual table is retrieved according to the critical field, to be adjusted from the information table
Take corresponding data.
2. the method according to claim 1, wherein in the creation and the information table phase in the database
After corresponding Virtual table, the method also includes:
The Virtual table and information table are subjected to real time correlation, it is described virtual to be timely updated according to the variation of the information table
Table.
3. the method according to claim 1, wherein the creation is opposite with the information table in the database
The Virtual table answered includes:
Classification creates at least one described information table in the database；
Critical field is extracted in the information table, and is established between critical field data corresponding with the critical field
Mapping relations；
The Virtual table is established according to the critical field and mapping relations.
4. the method according to claim 1, wherein it is described according to the critical field to the Virtual table into
Row is retrieved, and includes: to transfer corresponding data from the information table
The Virtual table is retrieved using the critical field；
The mapping relations are obtained in the Virtual table according to the critical field；
Corresponding data is obtained from the information table by the mapping relations.
5. the method according to claim 1, wherein described, for the mobile terminal to establish database specific
Are as follows: database is established at least one application program of the mobile terminal.
6. a kind of data processing equipment based on mobile terminal application class, using on mobile terminals, which is characterized in that be directed to institute
Stating mobile terminal foundation has database, and described device includes creation module and retrieval module interconnected；
The creation module is connect with database, and it is opposite with the information table in the database that the creation module is configured to creation
The Virtual table answered, the Virtual table are stored with the corresponding information of critical field in the information table；
The retrieval module is connect with database, and the retrieval module is configured to when carrying out data retrieval, according to the key
Field retrieves the Virtual table, to transfer corresponding data from the information table.
7. device according to claim 6, which is characterized in that described device further includes update module；
The update module is connect with database, and the update module is configured to information table be closed the Virtual table in real time
Connection, to be timely updated the Virtual table according to the variation of the information table.
8. device according to claim 6, which is characterized in that the creation module includes taxon, extraction unit and
Establish unit；
The taxon, which is configured to classify in the database, creates at least one described information table；
The extraction unit is connect with unit is established, and the extraction unit is configured to extract critical field in the information table,
So that the mapping relations establishing unit and establishing between the critical field and the relevant information of the critical field, and according to institute
It states critical field and mapping relations establishes the Virtual table.
9. device according to claim 6, which is characterized in that the retrieval module includes acquiring unit and retrieval unit；
The retrieval unit is configured so that the critical field retrieves the Virtual table；
The acquiring unit is connect with the retrieval unit and database respectively, and the acquiring unit is configured to according to the key
Field obtains the mapping relations in the Virtual table, and obtains respective counts from the information table by the mapping relations
According to.
10. device according to claim 6, which is characterized in that the database be for the mobile terminal at least
The database that one application program is established.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710617162.3A CN110019328A (en) | 2017-07-26 | 2017-07-26 | A kind of data processing method and device based on mobile terminal application class |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710617162.3A CN110019328A (en) | 2017-07-26 | 2017-07-26 | A kind of data processing method and device based on mobile terminal application class |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN110019328A true CN110019328A (en) | 2019-07-16 |
Family
ID=67185876
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201710617162.3A Pending CN110019328A (en) | 2017-07-26 | 2017-07-26 | A kind of data processing method and device based on mobile terminal application class |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN110019328A (en) |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112486414A (en) * | 2020-11-27 | 2021-03-12 | 惠州Tcl移动通信有限公司 | Data processing method and device, storage medium and mobile terminal |
| CN113704306A (en) * | 2021-08-31 | 2021-11-26 | 上海观安信息技术股份有限公司 | Database data processing method and device, storage medium and electronic equipment |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1283828A (en) * | 1999-08-06 | 2001-02-14 | 英业达集团(上海)电子技术有限公司 | Database index method and system |
| CN102055835A (en) * | 2009-11-02 | 2011-05-11 | 康佳集团股份有限公司 | Mobile terminal information managing method and equipment |
| CN103841656A (en) * | 2012-11-22 | 2014-06-04 | 三星电子株式会社 | Mobile terminal and data processing method thereof |
| CN104598555A (en) * | 2014-12-31 | 2015-05-06 | 天津智达慧远商务咨询有限公司 | Interactive network retrieval service system |
-
2017
- 2017-07-26 CN CN201710617162.3A patent/CN110019328A/en active Pending
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1283828A (en) * | 1999-08-06 | 2001-02-14 | 英业达集团(上海)电子技术有限公司 | Database index method and system |
| CN102055835A (en) * | 2009-11-02 | 2011-05-11 | 康佳集团股份有限公司 | Mobile terminal information managing method and equipment |
| CN103841656A (en) * | 2012-11-22 | 2014-06-04 | 三星电子株式会社 | Mobile terminal and data processing method thereof |
| CN104598555A (en) * | 2014-12-31 | 2015-05-06 | 天津智达慧远商务咨询有限公司 | Interactive network retrieval service system |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112486414A (en) * | 2020-11-27 | 2021-03-12 | 惠州Tcl移动通信有限公司 | Data processing method and device, storage medium and mobile terminal |
| CN113704306A (en) * | 2021-08-31 | 2021-11-26 | 上海观安信息技术股份有限公司 | Database data processing method and device, storage medium and electronic equipment |
| CN113704306B (en) * | 2021-08-31 | 2024-01-30 | 上海观安信息技术股份有限公司 | Database data processing method and device, storage medium and electronic equipment |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN106663109A (en) | Providing automatic actions for mobile onscreen content | |
| JP4786945B2 (en) | Indexing forced query | |
| JP2002207749A (en) | Agent for integrated annotation and retrieval of image | |
| US7536512B2 (en) | Method and apparatus for space efficient identification of candidate objects for eviction from a large cache | |
| JPH1049414A (en) | Device and method for version management | |
| US12050578B2 (en) | Distributed database management system with dynamically split B-Tree indexes | |
| US8818971B1 (en) | Processing bulk deletions in distributed databases | |
| CN108268438B (en) | Page content extraction method and device and client | |
| US20170060922A1 (en) | Method and device for data search | |
| CN111914020A (en) | Data synchronization method and device and data query method and device | |
| CN110019328A (en) | A kind of data processing method and device based on mobile terminal application class | |
| EP3098726A1 (en) | Method for extracting useful content from setup files of mobile applications | |
| US6775669B2 (en) | Retrieval processing method and apparatus and memory medium storing program for same | |
| US20160266741A1 (en) | Electronic whiteboard system, search result display method of electronic whiteboard, and non-transitory computer readable medium storing program thereof | |
| CN113360571A (en) | Characteristic mark-based power grid monitoring system memory database relation database synchronization method | |
| WO2017080198A1 (en) | Memo update method and device | |
| CN109189728B (en) | Intelligent hardware device, disk data processing method and storage medium | |
| CN105574192A (en) | Computer document retrieval method | |
| US9020995B2 (en) | Hybrid relational, directory, and content query facility | |
| CN112800181B (en) | Text retrieval method, device, computer equipment and storage medium | |
| CN108415946A (en) | Computer based image processing method and picture processing unit | |
| CN108765803A (en) | Library's book management system and taking care of books method | |
| JP7180769B2 (en) | Data management device, control method, and storage medium | |
| CN104424223A (en) | Input method-based APP (Application) search and fast boot method and related input method system | |
| CN108984519B (en) | Method, device and storage medium for automatic construction of event corpus based on dual mode |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| WD01 | Invention patent application deemed withdrawn after publication |
Application publication date: 20190716 |
|
| WD01 | Invention patent application deemed withdrawn after publication |