CN107463693A - A kind of data processing method, device, terminal and computer-readable recording medium - Google Patents
A kind of data processing method, device, terminal and computer-readable recording medium Download PDFInfo
- Publication number
- CN107463693A CN107463693A CN201710684861.XA CN201710684861A CN107463693A CN 107463693 A CN107463693 A CN 107463693A CN 201710684861 A CN201710684861 A CN 201710684861A CN 107463693 A CN107463693 A CN 107463693A
- Authority
- CN
- China
- Prior art keywords
- data
- target
- database
- mark
- flag bit
- 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.)
- Granted
Links
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
- G06F16/2255—Hash tables
-
- 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/28—Databases characterised by their database models, e.g. relational or object models
- G06F16/284—Relational databases
Landscapes
- Engineering & Computer Science (AREA)
- Databases & Information Systems (AREA)
- Theoretical Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Software Systems (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses a kind of data processing method, device, terminal and computer-readable recording medium, this method includes：The first Data Identification is obtained from query sentence of database, the first Data Identification includes target data mark and data station location marker；Identified according to Data Position and determine target database mark and target matrix mark；Identified according to target database, target matrix identifies and target data identifier lookup target data；Query sentence of database is performed to target data.The embodiment of the present invention, which can identify target data, is converted to corresponding target database and target matrix, and then the data storage method of the more tables of data of multiple database of implementation relation type database.During by the storage modes of the more tables of data of multiple database, the data volume that is stored when the data volume stored in each tables of data will be substantially less that single storehouse list table in the prior art in tables of data, and then target data can be more quickly found, improve data read-write efficiency.
Description
Technical field
The present embodiments relate to database technology, more particularly to a kind of data processing method, device, terminal and computer
Readable storage medium storing program for executing.
Background technology
As financial business is fast-developing, the data that financial business is related to increase in blowout.Such as storing and managing
The asset management system of financial transaction data is managed, the asset data amount that it needs to store is by millions index rapid growth to trillion
The quantity of level.
Because the asset management system is using relevant database progress O＆M, and the database used uses single storehouse list table number
According to memory technology, cause as data volume blowout increases, existing database memory technology can not meet current TERA-SCALE
Data volume demand, data read-write efficiency is low.
The content of the invention
The present invention provides a kind of data processing method, device, terminal and computer-readable recording medium, to realize raising number
According to the data read-write efficiency in storehouse.
In a first aspect, the embodiments of the invention provide a kind of data processing method, including：
The first Data Identification is obtained from query sentence of database, the first Data Identification includes target data mark and data
Station location marker；
Identified according to Data Position and determine target database mark and target matrix mark；
Identified according to target database, target matrix identifies and target data identifier lookup target data；
Query sentence of database is performed to target data.
Further, identified according to Data Position and determine that target database mark and target matrix identify, including：
Numerical value corresponding at least one first flag bit during Data Position is identified is defined as target database mark；
Numerical value corresponding at least one second flag bit during Data Position is identified is defined as target matrix mark, extremely
Few first flag bit is adjacent with least one second flag bit.
Further, identified according to Data Position and determine that target database mark and target matrix identify, including：
Numerical value corresponding at least one 3rd flag bit during Data Position is identified is defined as extension bits, and at least one
The adjacent and at least one 3rd flag bit composition data station location marker of one flag bit, at least one second flag bit.
Further, Data Position mark includes four flag bits；Identified according to Data Position and determine target database mark
Know and target matrix identifies, including：
First flag bit during Data Position is identified is defined as extension bits；
Second flag bit and the 3rd flag bit during Data Position is identified are defined as target database mark；
The 4th flag bit during Data Position is identified is defined as target matrix mark.
Further, identified according to target database, target matrix mark and target data identifier lookup target data,
Including：
Identified according to target database, target matrix mark and target data mark generate the second Data Identification；
The first Data Identification in query sentence of database is replaced with into the second Data Identification；
Target data is searched according to the second Data Identification.
Second aspect, the embodiment of the present invention additionally provide a kind of data processing equipment, including：
Data Position mark module, for obtaining the first Data Identification, the first Data Identification from query sentence of database
Including target data mark and data station location marker；
Target identification determining module, the Data Position mark for being obtained according to Data Position identifier acquisition module determine mesh
Mark Database Identification and target matrix mark；
Target data searching modul, for target database mark, the number of targets determined according to target identification determining module
According to table mark and target data identifier lookup target data；
Database statement execution module, the target data for being found to target data searching modul perform database and looked into
Ask sentence.
The third aspect, the embodiment of the present invention additionally provide a kind of terminal, and terminal includes：
One or more processors；
Storage device, for storing one or more programs,
When one or more programs are executed by one or more processors so that one or more processors realize such as first
Data processing method shown in aspect.
Fourth aspect, the embodiment of the present invention additionally provide a kind of computer-readable recording medium, are stored thereon with computer
Program, the data processing method as shown in first aspect is realized when the program is executed by processor.
The embodiment of the present invention can obtain the first Data Identification from query sentence of database, and the first Data Identification includes mesh
Mark Data Identification and data station location marker；Identified according to Data Position and determine target database mark and target matrix mark
Know；Identified according to target database, target matrix identifies and target data identifier lookup target data；Target data is performed
Query sentence of database, and then realize the relevant database storage mode of the more tables of data of multiple database.Relative to prior art
Target data can be identified and is converted to correspondingly by the middle data storage method using single database forms data table, the embodiment of the present invention
Target database and target matrix, and then the data storage side of the more tables of data of multiple database of implementation relation type database
Formula.For same data volume, during by the storage modes of the more tables of data of multiple database, the data volume that is stored in each tables of data
The data volume stored when will be substantially less that single storehouse list table in the prior art in tables of data, and then during each data access, this
Inventive embodiments can more quickly find target data, improve data read-write efficiency.
Brief description of the drawings
Fig. 1 is a kind of flow chart of data processing method in the embodiment of the present invention；
Fig. 2 is the flow chart of another data processing method in the embodiment of the present invention；
Fig. 3 is the flow chart of another data processing method in the embodiment of the present invention；
Fig. 4 is a kind of structural representation of data processing equipment in the embodiment of the present invention；
Fig. 5 is a kind of structural representation of mobile terminal in the embodiment of the present invention.
Embodiment
The present invention is described in further detail with reference to the accompanying drawings and examples.It is understood that this place is retouched
The specific embodiment stated is used only for explaining the present invention, rather than limitation of the invention.It also should be noted that in order to just
Part related to the present invention rather than entire infrastructure are illustrate only in description, accompanying drawing.
At present in financial business field, the assets information that financial business is related to is deposited usually using relevant database
Storage and management.Prior art is stored using the storage mode of single storehouse list table to assets information.But with assets information well
Spray formula increases, and causes existing single storehouse list table mode can not timely respond to data access.Based on this, the embodiments of the invention provide
A kind of data storage method of the relevant database of more storehouse multilists, for being stored and being handled to assets information.
Fig. 1 is a kind of flow chart of data processing method provided in an embodiment of the present invention, and the present embodiment is applicable to use
The situation that relevant database is stored and managed to the assets information of financial system, this method can be by being stored with database
Terminal perform, the terminal can be smart mobile phone, tablet personal computer, PC etc., and this method specifically comprises the following steps：
Step 110, the first Data Identification is obtained from query sentence of database, the first Data Identification includes target data mark
Know and data station location marker.
Query sentence of database is used to read data, write-in data and inquiry data etc. into database.Database is looked into
It is corresponding with database to ask sentence, such as SQL (Structured can be used for relevant database
Query Language, SQL) sentence is as query sentence of database.
When foreground interface receives user's input or the inquiry generated according to user behavior, reading or write-in, generation
Corresponding query sentence of database.Data query sentence includes action type and operation object.Action type can be choosing
Operation (select) is selected, (write) is write or reads (read) etc..The first Data Identification of operation object bronze drum Europe.
In one implementation, the first Data Identification includes target data mark and data station location marker.Target data
Mark identifies for Data Position below.In assets operation field, target data mark can be asset identification, can pass through assets
Sequence number identifies as target data.Data Position is identified for outlining database and data where target data
Table.
Step 120, determination target database mark and target matrix mark are identified according to Data Position.
After step 110 gets the first Data Identification, the Data Position mark in the first Data Identification is parsed.Parsing
Formula, can according to pre-set Data Position mark corresponding to data bit read out Data Position mark.Can also be according to pre-
The Data Identification first set, the identification data station location marker from the first Data Identification.
Optionally, Data Position is identified as number format, or text formatting.Data Position mark can pass through Kazakhstan
Multiple databases and multiple tables of data at uncommon table mapping.
In one implementation, step 120 can be implemented by following manner：
First, numerical value corresponding at least one first flag bit during Data Position is identified is defined as target database mark
Know；Then, numerical value corresponding at least one second flag bit during Data Position is identified is defined as target matrix mark, extremely
Few first flag bit is adjacent with least one second flag bit.
The digit of first flag bit is determined that the digit of the first flag bit can be identified for that existing whole by the quantity of database
Database.The digit of second flag bit is determined that the digit of the second flag bit can be identified for that existing whole by the quantity of tables of data
Tables of data.For example, currently there are 30 databases, then all database can be indicated with two the first flag bits.Currently
30 tables of data are respectively provided with each database, then total data table can be indicated with two the second flag bits.Now,
Data Position mark is made up of two the first flag bits and two the second flag bits, and the first flag bit and the second flag bit phase
It is adjacent.First mark is adjacent positioned at the second flag bit, can be in real time first second flag bit of the first flag bit rear, or, the
First first flag bit of two flag bits is rear.Wherein, multiple first flag bits are continuous, and multiple second flag bits are also continuous.
Find in use, asset data amount is increased sharply at present, in order to improve the scalability of database, keeps each data
The quantity of list item will not be too high in the quantity of tables of data and each tables of data in storehouse, can will be to data bit by following manner
Mark is put to be extended：
Numerical value corresponding at least one 3rd flag bit during Data Position is identified is defined as extension bits, and at least one
The adjacent and at least one 3rd flag bit composition data station location marker of one flag bit, at least one second flag bit.
3rd flag bit can be used for extending, and the quantity of the 3rd flag bit does not limit, and it can also be more that can be one
It is individual.When extension bits of the extension bits as the first flag bit, the 3rd flag bit can be located at before the first flag bit, can also position
After the first flag bit.When extension bits of the extension bits as the second flag bit, the 3rd flag bit can be located at the second mark
Before position, it can also be located at after the second flag bit.
Whenever using an extension bits, corresponding data medium is by the identification means of more an order of magnitude.Exemplary,
If current have two the first flag bits and an extension bits, and each flag bit is represented using 10 binary digits, then currently
Denotable quantity database is 100, if enabling extension bits, the quantity database that can be represented is 1000, and then
Workable database is significantly increased, improves resource utilization.
Step 130, identified according to target database, target matrix mark and target data identifier lookup target data.
There may be identical target data mark in different tables of data, also may be present in identical tables of data more
Recorded corresponding to individual identical data mark.In same tables of data, there is the record of identical data mark to be used to record assets
In record corresponding to the different business stage.Wherein, the Service Period of assets includes examination ＆ verification, financing, remittance, flowing water etc..
In one implementation, when searching target data, first according to target database identifier lookup to number of targets
According to storehouse, then in access target database, target matrix corresponding to target data mark table mark, finally in target matrix
It is middle to search multiple records with target data mark.According to the current assets operation stage, in multiple records such as finding
Target data.
Above embodiment described one kind after interception database query statement, the mistake that is read out to target data
Journey., can be after interception database query statement, to the data bit in query sentence of database in another implementation
Put mark to be parsed, obtain the address of target data.Then the address of the target data obtained according to parsing, generates new number
According to identification feedback to Database Systems, so that the mechanism of data access that Database Systems carry according to it can be according to new data
Identification access is to target data.Specifically, as shown in Fig. 2 it can be implemented by following manner：
Step 131, identified according to target database, target matrix mark and target data mark the second data mark of generation
Know.
Second Data Identification can be the form that Database Systems can recognize that.Due to the data contained in the first Data Identification
Form, in order to save memory space or facilitate input to be abridged to true address, therefore it is not necessarily database and can knows
It is other.Therefore step 131 generates the second Data Identification after target database mark and target matrix mark is obtained.Second
Data Identification can include database in True Data storehouse corresponding with target database mark title and tables of data in and
The title of True Data table corresponding to target matrix mark.
Step 132, the first Data Identification in query sentence of database replaced with into the second Data Identification.
The first Data Identification in the query sentence of database that step 110 is obtained is deleted, then, by the second Data Identification
It is added to the position of the first Data Identification.Or according to former query sentence of database (the data base querying language that step 110 obtains
Sentence) type, generate new query sentence of database, the type of new query sentence of database and former query sentence of database one
Cause, it is the target data that the second Data Identification represents that it, which performs object,.
Step 133, according to the second Data Identification search target data.
The new query sentence of database for including the second Data Identification is fed back into Database Systems.Database Systems root
The target data pointed to according to new query sentence of database to the second Data Identification operates.
Step 140, query sentence of database is performed to target data.
The data processing method that the present embodiment provides, can obtain the first Data Identification from query sentence of database, the
One Data Identification includes target data mark and data station location marker；According to Data Position identify determine target database mark with
And target matrix mark；Identified according to target database, target matrix identifies and target data identifier lookup target data；
Query sentence of database is performed to target data, and then realizes the relevant database storage mode of the more tables of data of multiple database.
Relative to the data storage method for using single database forms data table in the prior art, the present embodiment can identify target data
Target database and target matrix corresponding to being converted to, and then the more tables of data of multiple database of implementation relation type database
Data storage method.For same data volume, during by the storage modes of the more tables of data of multiple database, deposited in each tables of data
The data volume stored when the data volume of storage will be substantially less that single storehouse list table in the prior art in tables of data, and then in each data access
During, the embodiment of the present invention can more quickly find target data, improve data read-write efficiency.
It is described further below by a usage scenario, in usage scenario, Data Position mark includes four
Flag bit, first flag bit are that extension bits, second flag bit and the 3rd flag bit identify for target database, the 4th
Flag bit identifies for target matrix, as shown in figure 3, this method includes：
Step 200, establish database instance.
A database instance is established, comprising 100 databases, each database includes 10 tables.
Each the name form of database is：Database name _ XX, XX is two digits, from 00 to 99.
The name form of every table is：Data table name _ X, X is one-bit digital, from 0 to 9.
1000 database tables altogether.
Data Position mark corresponding to step 210, each assets information of generation.
The random number that Data Position is identified with four is formed.Wherein, first of four random numbers is extension bits, second
With the target database where the 3rd corresponding assets information, the target matrix where the 4th corresponding assets information.
Step 220, the first Data Identification according to corresponding to Data Position mark determines each assets information.
For every assets, first Data Identification of " Asset ID " as assets information corresponding to assets is generated.Should " money
Produce ID " latter four, are 4 random numbers.
Exemplary, Asset ID is：Asset serial numbers+XXXX.Wherein, asset serial numbers are that English alphabet and numeral combine
Character string, XXXX is 4-digit number.
Step 230, when triggering assets information requirements for access, generate query sentence of database.
Wherein query sentence of database includes the first Data Identification.
Query sentence of database can be SQL statement.The each sql sentences operated to database, all transmit " assets
ID " is used as parameter.
Step 240, the first Data Identification is obtained from query sentence of database, the first Data Identification includes target data mark
Know and data station location marker.
The SQL for intercepting ORM frameworks performs action, and " Asset ID " is extracted from SQL statement.
Step 250, Data Position is identified in first flag bit be defined as extension bits.
Assuming that four after in the Asset ID intercepted, i.e., Data Position is identified as, 0601.Then using first " 0 " as expansion
Exhibition position, due to for 0, then illustrating not actuated extension at present.
Step 260, Data Position is identified in second flag bit and the 3rd flag bit be defined as target database
Mark.
In the above example, second flag bit and the 3rd flag bit are " 60 ", and then can determine that target database mark
Know for 60.
Step 270, Data Position is identified in the 4th flag bit be defined as target matrix mark.
In the above example, the 4th flag bit is " 1 ", and then can determine that target matrix is identified as 1.
Step 280, identified according to target database, target matrix mark and target data identifier lookup target data.
It can be realized by step 250-270, when the 4-digit number intercepted is 0601, three bit digital 601 after interception
For valid data, the second Data Identification of generation is " database table name _ 1 " of database name _ 60..
Step 290, query sentence of database is performed to target data.
The data processing method that the present embodiment provides, by establishing the table of hundred storehouse ten, meet hundred billion grades of amount of assets of storage, subtract
The data storage pressure of light single storehouse list table.Point storehouse divides table scheme to utilize the attribute of assets in itself, and asset data is route.Protect
Same batch traffic data have been demonstrate,proved, have been stored in identical storehouse table, have improved data preservation and effectiveness of retrieval.In addition, the present embodiment
The shortcomings that abandoning single storehouse list table memory technology stored number bottom, the storage that the design table scheme of hundred storehouse ten meets hundred billion grades of systems will
Ask.Traditional relevant database is extremely difficult to store the expection of magnanimity asset data, but makes traditional pass by this programme
It is the asset data that type database disclosure satisfy that storage magnanimity.By the implementation of this programme, former asset data storage and retrieval speed
Degree lifts millisecond step velocity by second level, meets business datum preservation and Search Requirement.
Fig. 4 is a kind of structural representation of data processing equipment provided in an embodiment of the present invention, and the device is used to realize
The above-mentioned method of embodiment is stated, the device is located in terminal, including：
Data Position mark module 310, for obtaining the first Data Identification, the first data mark from query sentence of database
Knowledge includes target data mark and data station location marker；
Target identification determining module 320, the Data Position mark for being obtained according to Data Position identifier acquisition module are true
Set the goal Database Identification and target matrix mark；
Target data searching modul 330, for determined according to target identification determining module 320 target database mark,
Target matrix identifies and target data identifier lookup target data；
Database statement execution module 340, the target data for being found to target data searching modul 330 perform number
According to library inquiry sentence.
Further, target identification determining module 320 is used for：
Numerical value corresponding at least one first flag bit during Data Position is identified is defined as target database mark；
Numerical value corresponding at least one second flag bit during Data Position is identified is defined as target matrix mark, extremely
Few first flag bit is adjacent with least one second flag bit.
Further, target identification determining module 320 is used for：
Numerical value corresponding at least one 3rd flag bit during Data Position is identified is defined as extension bits, and at least one
The adjacent and at least one 3rd flag bit composition data station location marker of one flag bit, at least one second flag bit.
Further, Data Position mark includes four flag bits, and target identification determining module 320 is used for：
First flag bit during Data Position is identified is defined as extension bits；
Second flag bit and the 3rd flag bit during Data Position is identified are defined as target database mark；
The 4th flag bit during Data Position is identified is defined as target matrix mark.
Further, target data searching modul 330 is used for：
Identified according to target database, target matrix mark and target data mark generate the second Data Identification；
The first Data Identification in query sentence of database is replaced with into the second Data Identification；
Target data is searched according to the second Data Identification.
Data processing equipment provided in an embodiment of the present invention, Data Position mark module can be from query sentence of database
The first Data Identification is obtained, the first Data Identification includes target data mark and data station location marker；Target identification determining module
Identified according to Data Position and determine target database mark and target matrix mark；Target data searching modul is according to target
Database Identification, target matrix mark and target data identifier lookup target data；Database statement execution module is to target
Data perform query sentence of database, and then realize the relevant database storage mode of the more tables of data of multiple database.Relative to
The data storage method of single database forms data table is used in the prior art, and the embodiment of the present invention, which can identify target data, to be turned
Target database and target matrix corresponding to being changed to, and then the number of the more tables of data of multiple database of implementation relation type database
According to storage mode.For same data volume, during by the storage modes of the more tables of data of multiple database, stored in each tables of data
The data volume that is stored in tables of data when will be substantially less that single storehouse list table in the prior art of data volume, and then in each data access mistake
Cheng Zhong, the embodiment of the present invention can more quickly find target data, improve data read-write efficiency.
The method that the executable foregoing all embodiments of the present invention of said apparatus are provided, it is corresponding to possess the execution above method
Functional module and beneficial effect.Not ins and outs of detailed description in the present embodiment, reference can be made to the foregoing all implementations of the present invention
The method that example is provided.
Fig. 5 is a kind of structural representation of terminal provided in an embodiment of the present invention.As shown in figure 5, the terminal can include：
Housing (not shown), first memory 401, the first central processing unit (Central Processing Unit, CPU) 402
(also known as first processor, hereinafter referred to as CPU), it is stored on first memory 401 and can be run on first processor 402
Computer program, circuit board (not shown) and power circuit (not shown).Foregoing circuit plate is placed in above-mentioned housing
The interior volume surrounded；Above-mentioned CPU402 and above-mentioned first memory 401 are arranged on foregoing circuit plate；Above-mentioned power circuit,
For each circuit or the device power supply for above-mentioned terminal；Above-mentioned first memory 401, for storing executable program code；
Above-mentioned CPU402 is run and above-mentioned executable journey by reading the executable program code stored in above-mentioned first memory 401
Program corresponding to sequence code, for performing：
The first Data Identification is obtained from query sentence of database, the first Data Identification includes target data mark and data
Station location marker；
Identified according to Data Position and determine target database mark and target matrix mark；
Identified according to target database, target matrix identifies and target data identifier lookup target data；
Query sentence of database is performed to target data.
Above-mentioned terminal also includes：Peripheral Interface 403, RF (Radio Frequency, radio frequency) circuit 405, voicefrequency circuit
406th, loudspeaker 411, power management chip 408, input/output (I/O) subsystem 409, touch-screen 412, other input/controls
Equipment 410 and outside port 404, these parts are communicated by one or more communication bus or signal wire 407.
In addition, terminal also includes camera and RGB light sensor.RGB light sensor is located at beside camera, can be with
It is disposed adjacent with camera.Camera can be that front camera can also be rear camera.RGB light sensor can be with
It is first-class such as disposed in the narrow side of terminal side with camera configured separate, example.
It should be understood that graphic terminal 400 is only an example of terminal, and terminal 400 can have than figure
Shown in more or less parts, two or more parts can be combined, or can have different portions
Part configures.Various parts shown in figure can be including one or more signal transactings and/or application specific integrated circuit
Hardware, software or hardware and software combination in realize.
The terminal for being used to realize control doorbell that the present embodiment provides is described in detail below, the terminal is with intelligence
Exemplified by mobile phone.
First memory 401, above-mentioned first memory 401 can be accessed by CPU402, Peripheral Interface 403 etc., and above-mentioned
One memory 401 can include high random access first memory, can also include non-volatile first memories, such as one
Individual or multiple disk first memory parts, flush memory device or other volatile solid-state first memory parts.
The input of equipment and output peripheral hardware can be connected to CPU402 and the by Peripheral Interface 403, above-mentioned Peripheral Interface 403
One memory 401.
I/O subsystems 409, above-mentioned I/O subsystems 409 can be by the input/output peripherals in equipment, such as touch-screen 412
With other input/control devicess 410, Peripheral Interface 403 is connected to.I/O subsystems 409 can include the He of display controller 4091
For controlling one or more input controllers 4092 of other input/control devicess 410.Wherein, one or more input controls
Device 4092 processed receives electric signal from other input/control devicess 410 or sends electric signal to other input/control devicess 410,
Other input/control devicess 410 can include physical button (pressing button, rocker buttons etc.), dial, slide switch, behaviour
Vertical pole, click on roller.What deserves to be explained is input controller 4092 can with it is following any one be connected：Keyboard, infrared port,
The instruction equipment of USB interface and such as mouse.
Wherein, according to touch-screen operation principle and transmission information medium classification, touch-screen 412 can be resistance-type,
Capacitor induction type, infrared-type or surface acoustic wave type.Classify according to mounting means, touch-screen 412 can be：It is external hanging type, built-in
Formula or monoblock type.Classify according to technical principle, touch-screen 412 can be：Vector pressure sensing technology touch-screen, resistive technologies are touched
Touch screen, capacitance technology touch-screen, infrared technology touch-screen or surface acoustic wave technique touch-screen.
Touch-screen 412, above-mentioned touch-screen 412 are the input interface and output interface between user terminal and user, can
It can include figure, text, icon, video etc. to user, visual output depending on output display.Optionally, touch-screen 412 is by user
The electric signal (electric signal of such as contact surface) triggered on touch screen curtain, is sent to first processor 402.
Display controller 4091 in I/O subsystems 409 receives electric signal from touch-screen 412 or sent out to touch-screen 412
Electric signals.Touch-screen 412 detects the contact on touch-screen, and the contact detected is converted to and shown by display controller 4091
The interaction of user interface object on touch-screen 412, that is, realize man-machine interaction, the user interface being shown on touch-screen 412
Icon that object can be the icon of running game, be networked to corresponding network etc..What deserves to be explained is equipment can also include light
Mouse, light mouse is not show the touch sensitive surface visually exported, or the extension of the touch sensitive surface formed by touch-screen.
RF circuits 405, it is mainly used in establishing the communication of intelligent sound box and wireless network (i.e. network side), realizes intelligent sound box
Data receiver and transmission with wireless network.Such as transmitting-receiving short message, Email etc..
Voicefrequency circuit 406, it is mainly used in receiving voice data from Peripheral Interface 403, the voice data is converted into telecommunications
Number, and the electric signal is sent to loudspeaker 411.
Loudspeaker 411, for the voice signal for receiving intelligent sound box from wireless network by RF circuits 405, it is reduced to
Sound simultaneously plays the sound to user.
Power management chip 408, the hardware for being connected by CPU402, I/O subsystem and Peripheral Interface are powered
And power management.
In the present embodiment, central first processor 402 is used for：
The first Data Identification is obtained from query sentence of database, the first Data Identification includes target data mark and data
Station location marker；
Identified according to Data Position and determine target database mark and target matrix mark；
Identified according to target database, target matrix identifies and target data identifier lookup target data；
Query sentence of database is performed to target data.
Further, identified according to Data Position and determine that target database mark and target matrix identify, including：
Numerical value corresponding at least one first flag bit during Data Position is identified is defined as target database mark；
Numerical value corresponding at least one second flag bit during Data Position is identified is defined as target matrix mark, extremely
Few first flag bit is adjacent with least one second flag bit.
Further, identified according to Data Position and determine that target database mark and target matrix identify, including：
Numerical value corresponding at least one 3rd flag bit during Data Position is identified is defined as extension bits, and at least one
The adjacent and at least one 3rd flag bit composition data station location marker of one flag bit, at least one second flag bit.
Further, Data Position mark includes four flag bits；Identified according to Data Position and determine target database mark
Know and target matrix identifies, including：
First flag bit during Data Position is identified is defined as extension bits；
Second flag bit and the 3rd flag bit during Data Position is identified are defined as target database mark；
The 4th flag bit during Data Position is identified is defined as target matrix mark.
Further, identified according to target database, target matrix mark and target data identifier lookup target data,
Including：
Identified according to target database, target matrix mark and target data mark generate the second Data Identification；
The first Data Identification in query sentence of database is replaced with into the second Data Identification；
Target data is searched according to the second Data Identification.
The embodiment of the present invention additionally provides a kind of computer-readable recording medium, is stored thereon with computer program, the journey
Sequence can realize following steps when being executed by processor：
The first Data Identification is obtained from query sentence of database, the first Data Identification includes target data mark and data
Station location marker；
Identified according to Data Position and determine target database mark and target matrix mark；
Identified according to target database, target matrix identifies and target data identifier lookup target data；
Query sentence of database is performed to target data.
Further, identified according to Data Position and determine that target database mark and target matrix identify, including：
Numerical value corresponding at least one first flag bit during Data Position is identified is defined as target database mark；
Numerical value corresponding at least one second flag bit during Data Position is identified is defined as target matrix mark, extremely
Few first flag bit is adjacent with least one second flag bit.
Further, identified according to Data Position and determine that target database mark and target matrix identify, including：
Numerical value corresponding at least one 3rd flag bit during Data Position is identified is defined as extension bits, and at least one
The adjacent and at least one 3rd flag bit composition data station location marker of one flag bit, at least one second flag bit.
Further, Data Position mark includes four flag bits；Identified according to Data Position and determine target database mark
Know and target matrix identifies, including：
First flag bit during Data Position is identified is defined as extension bits；
Second flag bit and the 3rd flag bit during Data Position is identified are defined as target database mark；
The 4th flag bit during Data Position is identified is defined as target matrix mark.
Further, identified according to target database, target matrix mark and target data identifier lookup target data,
Including：
Identified according to target database, target matrix mark and target data mark generate the second Data Identification；
The first Data Identification in query sentence of database is replaced with into the second Data Identification；
Target data is searched according to the second Data Identification.
The computer-readable storage medium of the embodiment of the present invention, any of one or more computer-readable media can be used
Combination.Computer-readable medium can be computer-readable signal media or computer-readable recording medium.It is computer-readable
Storage medium for example may be-but not limited to-the system of electricity, magnetic, optical, electromagnetic, infrared ray or semiconductor, device or
Device, or any combination above.The more specifically example (non exhaustive list) of computer-readable recording medium includes：Tool
There are the electrical connections of one or more wires, portable computer diskette, hard disk, random access memory (RAM), read-only storage
(ROM), erasable programmable read only memory (EPROM or flash memory), optical fiber, portable compact disc read-only storage (CD-
ROM), light storage device, magnetic memory device or above-mentioned any appropriate combination.In this document, computer-readable storage
Medium can be any includes or the tangible medium of storage program, the program can be commanded execution system, device or device
Using or it is in connection.
Computer-readable signal media can include in a base band or as carrier wave a part propagation data-signal,
Wherein carry computer-readable program code.The data-signal of this propagation can take various forms, including but unlimited
In electromagnetic signal, optical signal or above-mentioned any appropriate combination.Computer-readable signal media can also be that computer can
Any computer-readable medium beyond storage medium is read, the computer-readable medium, which can send, propagates or transmit, to be used for
By instruction execution system, device either device use or program in connection.
The program code included on computer-readable medium can be transmitted with any appropriate medium, including --- but it is unlimited
In wireless, electric wire, optical cable, RF etc., or above-mentioned any appropriate combination.
It can be write with one or more programming languages or its combination for performing the computer that operates of the present invention
Program code, programming language include object oriented program language-such as Java, Smalltalk, C++, also wrapped
Include conventional procedural programming language-such as " C " language or similar programming language.Program code can be complete
Ground is performed, partly performed on the user computer on the user computer, the software kit independent as one performs, partly existed
Subscriber computer upper part is performed or performed completely on remote computer or server on the remote computer.It is being related to
In the situation of remote computer, remote computer can pass through the network of any kind --- including LAN (LAN) or wide area
Net (WAN)-be connected to subscriber computer, or, it may be connected to outer computer (such as utilize ISP
To pass through Internet connection).
Pay attention to, above are only presently preferred embodiments of the present invention and institute's application technology principle.It will be appreciated by those skilled in the art that
The invention is not restricted to specific embodiment above-mentioned here, can carry out for a person skilled in the art various obvious changes,
Readjust and substitute without departing from protection scope of the present invention.Therefore, although being carried out by above example to the present invention
It is described in further detail, but the present invention is not limited only to above example, without departing from the inventive concept, also
Other more equivalent embodiments can be included, and the scope of the present invention is determined by scope of the appended claims.
Claims (10)
- A kind of 1. data processing method, it is characterised in that including：The first Data Identification is obtained from query sentence of database, first Data Identification includes target data mark and data Station location marker；Identified according to the Data Position and determine target database mark and target matrix mark；According to target database mark, target matrix mark and the target data identifier lookup target data；The query sentence of database is performed to the target data.
- 2. data processing method according to claim 1, it is characterised in that described identified according to the Data Position determines Target database identifies and target matrix mark, including：Numerical value corresponding at least one first flag bit during the Data Position is identified is defined as target database mark；Numerical value corresponding at least one second flag bit during the Data Position is identified is defined as target matrix mark, institute It is adjacent with least one second flag bit to state at least one first flag bit.
- 3. data processing method according to claim 2, it is characterised in that described identified according to the Data Position determines Target database identifies and target matrix mark, including：Numerical value corresponding at least one 3rd flag bit during the Data Position is identified is defined as extension bits, and described at least one Adjacent and described at least one 3rd flag bit of individual first flag bit, at least one second flag bit forms the data bit Put mark.
- 4. data processing method according to claim 3, it is characterised in that the Data Position mark includes four marks Position；Described identified according to the Data Position determines that target database mark and target matrix identify, including：First flag bit during the Data Position is identified is defined as extension bits；Second flag bit and the 3rd flag bit during the Data Position is identified are defined as target database mark；The 4th flag bit during the Data Position is identified is defined as target matrix mark.
- 5. data processing method according to claim 1, it is characterised in that it is described according to the target database mark, Target matrix identifies and the target data identifier lookup target data, including：According to target database mark, target matrix mark and target data mark the second Data Identification of generation；The first Data Identification in the query sentence of database is replaced with into second Data Identification；Target data is searched according to second Data Identification.
- A kind of 6. data processing equipment, it is characterised in that including：Data Position mark module, for obtaining the first Data Identification, first Data Identification from query sentence of database Including target data mark and data station location marker；Target identification determining module, the Data Position mark for being obtained according to the Data Position identifier acquisition module are true Set the goal Database Identification and target matrix mark；Target data searching modul, the target database for being determined according to the target identification determining module identifies, institute State target matrix mark and the target data identifier lookup target data；Database statement execution module, perform for the target data that is found to the target data searching modul described in Query sentence of database.
- 7. data processing equipment according to claim 6, it is characterised in that the target identification determining module is used for：Numerical value corresponding at least one first flag bit during the Data Position is identified is defined as target database mark；Numerical value corresponding at least one second flag bit during the Data Position is identified is defined as target matrix mark, institute It is adjacent with least one second flag bit to state at least one first flag bit.
- 8. data processing equipment according to claim 6, it is characterised in that the target data searching modul is used for：According to target database mark, target matrix mark and target data mark the second Data Identification of generation；The first Data Identification in the query sentence of database is replaced with into second Data Identification；Target data is searched according to second Data Identification.
- 9. a kind of terminal, it is characterised in that the terminal includes：One or more processors；Storage device, for storing one or more programs,When one or more of programs are by one or more of computing devices so that one or more of processors are real The now data processing method as described in any in claim 1-5.
- 10. a kind of computer-readable recording medium, is stored thereon with computer program, it is characterised in that the program is by processor The data processing method as described in any in claim 1-5 is realized during execution.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710684861.XA CN107463693B (en) | 2017-08-11 | 2017-08-11 | Data processing method, device, terminal and computer readable storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710684861.XA CN107463693B (en) | 2017-08-11 | 2017-08-11 | Data processing method, device, terminal and computer readable storage medium |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN107463693A true CN107463693A (en) | 2017-12-12 |
| CN107463693B CN107463693B (en) | 2020-05-01 |
Family
ID=60548878
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201710684861.XA Active CN107463693B (en) | 2017-08-11 | 2017-08-11 | Data processing method, device, terminal and computer readable storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN107463693B (en) |
Cited By (15)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN108304491A (en) * | 2018-01-09 | 2018-07-20 | 北京比特大陆科技有限公司 | Data query method, apparatus and electronic equipment |
| CN108959940A (en) * | 2018-06-19 | 2018-12-07 | 杭州朗和科技有限公司 | Data access control method, medium, device and calculating equipment |
| CN109656980A (en) * | 2018-12-27 | 2019-04-19 | Oppo（重庆）智能科技有限公司 | Data processing method, electronic equipment, device and readable storage medium storing program for executing |
| CN109800270A (en) * | 2019-01-22 | 2019-05-24 | 青岛聚好联科技有限公司 | A kind of method and Internet of things system of data storage and query |
| CN110019244A (en) * | 2018-05-14 | 2019-07-16 | 网联清算有限公司 | Data processing method, device and computer readable storage medium |
| CN110415095A (en) * | 2019-07-24 | 2019-11-05 | 深圳乐信软件技术有限公司 | A kind of account checking method, device, terminal and storage medium |
| CN110795431A (en) * | 2019-10-28 | 2020-02-14 | 天津同阳科技发展有限公司 | Environment monitoring data processing method, device, equipment and storage medium |
| CN110941627A (en) * | 2019-12-12 | 2020-03-31 | 南京医渡云医学技术有限公司 | Data processing method and device, electronic equipment and storage medium |
| CN111143424A (en) * | 2018-11-05 | 2020-05-12 | 百度在线网络技术（北京）有限公司 | Characteristic scene data mining method and device and terminal |
| CN112579344A (en) * | 2019-09-29 | 2021-03-30 | 北京国双科技有限公司 | Data processing method, device and equipment |
| CN112765443A (en) * | 2020-12-31 | 2021-05-07 | 广州技象科技有限公司 | Internet of things data query method and device based on historical operation data |
| CN112883048A (en) * | 2019-11-29 | 2021-06-01 | 阿里巴巴集团控股有限公司 | Data access method, device, server and readable storage medium |
| CN113111138A (en) * | 2021-05-10 | 2021-07-13 | 网易传媒科技（北京）有限公司 | Data processing method, device, computing equipment and medium |
| CN113626458A (en) * | 2021-08-19 | 2021-11-09 | 咪咕数字传媒有限公司 | High-concurrency data updating method, device, equipment and computer storage medium |
| US20210374267A1 (en) * | 2016-08-19 | 2021-12-02 | Nec Corporation | Information processing device, information processing method, and recording medium |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101308513A (en) * | 2008-06-27 | 2008-11-19 | 福建星网锐捷网络有限公司 | Distributed system cache data synchronous configuration method and apparatus |
| CN104090901A (en) * | 2013-12-31 | 2014-10-08 | 腾讯数码（天津）有限公司 | Method, device and server for processing data |
| CN105243167A (en) * | 2015-11-10 | 2016-01-13 | 中国建设银行股份有限公司 | Data processing method and device |
| US20160026682A1 (en) * | 2010-08-06 | 2016-01-28 | At&T Intellectual Property I, L.P. | Securing Database Content |
-
2017
- 2017-08-11 CN CN201710684861.XA patent/CN107463693B/en active Active
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101308513A (en) * | 2008-06-27 | 2008-11-19 | 福建星网锐捷网络有限公司 | Distributed system cache data synchronous configuration method and apparatus |
| US20160026682A1 (en) * | 2010-08-06 | 2016-01-28 | At&T Intellectual Property I, L.P. | Securing Database Content |
| CN104090901A (en) * | 2013-12-31 | 2014-10-08 | 腾讯数码（天津）有限公司 | Method, device and server for processing data |
| CN105243167A (en) * | 2015-11-10 | 2016-01-13 | 中国建设银行股份有限公司 | Data processing method and device |
Cited By (22)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20210374267A1 (en) * | 2016-08-19 | 2021-12-02 | Nec Corporation | Information processing device, information processing method, and recording medium |
| CN108304491B (en) * | 2018-01-09 | 2021-05-11 | 比特大陆科技有限公司 | Data query method and device and electronic equipment |
| CN108304491A (en) * | 2018-01-09 | 2018-07-20 | 北京比特大陆科技有限公司 | Data query method, apparatus and electronic equipment |
| CN110019244A (en) * | 2018-05-14 | 2019-07-16 | 网联清算有限公司 | Data processing method, device and computer readable storage medium |
| US11934371B2 (en) | 2018-05-14 | 2024-03-19 | Netsunion Clearing Corporation | Data processing method and apparatus, and computer-readable storage medium |
| CN108959940A (en) * | 2018-06-19 | 2018-12-07 | 杭州朗和科技有限公司 | Data access control method, medium, device and calculating equipment |
| CN108959940B (en) * | 2018-06-19 | 2024-01-19 | 杭州网易数之帆科技有限公司 | Data access control method, medium, device and computing equipment |
| CN111143424B (en) * | 2018-11-05 | 2024-05-28 | 阿波罗智能技术(北京)有限公司 | Feature scene data mining method, device and terminal |
| CN111143424A (en) * | 2018-11-05 | 2020-05-12 | 百度在线网络技术（北京）有限公司 | Characteristic scene data mining method and device and terminal |
| CN109656980A (en) * | 2018-12-27 | 2019-04-19 | Oppo（重庆）智能科技有限公司 | Data processing method, electronic equipment, device and readable storage medium storing program for executing |
| CN109800270A (en) * | 2019-01-22 | 2019-05-24 | 青岛聚好联科技有限公司 | A kind of method and Internet of things system of data storage and query |
| CN110415095A (en) * | 2019-07-24 | 2019-11-05 | 深圳乐信软件技术有限公司 | A kind of account checking method, device, terminal and storage medium |
| CN112579344A (en) * | 2019-09-29 | 2021-03-30 | 北京国双科技有限公司 | Data processing method, device and equipment |
| CN110795431B (en) * | 2019-10-28 | 2020-12-01 | 天津同阳科技发展有限公司 | Environment monitoring data processing method, device, equipment and storage medium |
| CN110795431A (en) * | 2019-10-28 | 2020-02-14 | 天津同阳科技发展有限公司 | Environment monitoring data processing method, device, equipment and storage medium |
| CN112883048A (en) * | 2019-11-29 | 2021-06-01 | 阿里巴巴集团控股有限公司 | Data access method, device, server and readable storage medium |
| CN112883048B (en) * | 2019-11-29 | 2024-06-04 | 阿里巴巴集团控股有限公司 | Data access method, device, server and readable storage medium |
| CN110941627A (en) * | 2019-12-12 | 2020-03-31 | 南京医渡云医学技术有限公司 | Data processing method and device, electronic equipment and storage medium |
| CN112765443A (en) * | 2020-12-31 | 2021-05-07 | 广州技象科技有限公司 | Internet of things data query method and device based on historical operation data |
| CN112765443B (en) * | 2020-12-31 | 2023-10-24 | 广州技象科技有限公司 | Internet of things data query method and device based on historical operation data |
| CN113111138A (en) * | 2021-05-10 | 2021-07-13 | 网易传媒科技（北京）有限公司 | Data processing method, device, computing equipment and medium |
| CN113626458A (en) * | 2021-08-19 | 2021-11-09 | 咪咕数字传媒有限公司 | High-concurrency data updating method, device, equipment and computer storage medium |
Also Published As
| Publication number | Publication date |
|---|---|
| CN107463693B (en) | 2020-05-01 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN107463693A (en) | A kind of data processing method, device, terminal and computer-readable recording medium | |
| CN107291962B (en) | Searching method, searching device, storage medium and electronic equipment | |
| CN108647052A (en) | Application program preloads method, apparatus, storage medium and terminal | |
| CN107844992A (en) | comment information processing method, device, terminal device and storage medium | |
| CN103702297A (en) | Short message enhancement method, device and system | |
| CN108363792A (en) | Link generation method, device, storage medium and the electronic equipment of five application page | |
| CN104111794A (en) | Method and apparatus for providing a changed shortcut icon corresponding to a status thereof | |
| CN107678823A (en) | Control method, device and the storage medium and mobile terminal of mobile terminal application | |
| CN108363817A (en) | Document handling method, device, mobile terminal and computer readable storage medium | |
| CN108427549B (en) | Method and device for processing sound of notification message, storage medium and terminal | |
| CN107612974A (en) | Information recommendation method, device, mobile terminal and storage medium | |
| CN109408465A (en) | The recording method of file attaching information, device, storage medium and terminal | |
| CN107547646B (en) | Application program pushing method and device, terminal and computer readable storage medium | |
| US20140096089A1 (en) | Electronic device including mind-map user interface and method for manipulating mind-map using the same | |
| CN103678441A (en) | Device and content searching method using the same | |
| CN112241461B (en) | Method and equipment for generating character relation graph of book | |
| CN107528899A (en) | Information recommendation method, device, mobile terminal and storage medium | |
| CN109085983A (en) | Method of controlling operation thereof, device, storage medium and electronic equipment | |
| CN107493339A (en) | Information-pushing method, device, terminal and computer-readable recording medium | |
| CN108491325B (en) | File system testing method and device, storage medium and terminal | |
| CN107491242A (en) | application icon management method, device and user terminal | |
| CN110347865A (en) | Lyrics reminding method, device, storage medium and augmented reality equipment | |
| CN107612981A (en) | Application program method for pushing, device, terminal and computer-readable recording medium | |
| CN113434585B (en) | Resource preservation method and equipment | |
| CN107765956B (en) | User interface editing method, device, terminal and computer readable storage medium |
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 | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |