CN108090219A - The processing method and processing device of database onboard data - Google Patents
The processing method and processing device of database onboard data Download PDFInfo
- Publication number
- CN108090219A CN108090219A CN201711486486.4A CN201711486486A CN108090219A CN 108090219 A CN108090219 A CN 108090219A CN 201711486486 A CN201711486486 A CN 201711486486A CN 108090219 A CN108090219 A CN 108090219A
- Authority
- CN
- China
- Prior art keywords
- database
- functional
- index
- onboard data
- functional interface
- 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
- 238000012545 processing Methods 0.000 title claims abstract description 49
- 238000003672 processing method Methods 0.000 title claims abstract description 19
- 238000000034 method Methods 0.000 claims abstract description 74
- 238000011022 operating instruction Methods 0.000 claims abstract description 47
- 230000006870 function Effects 0.000 claims description 72
- 238000013475 authorization Methods 0.000 claims description 10
- 238000011112 process operation Methods 0.000 claims description 8
- 241001269238 Data Species 0.000 description 15
- 230000008569 process Effects 0.000 description 10
- 230000008901 benefit Effects 0.000 description 4
- 238000010586 diagram Methods 0.000 description 4
- 238000012423 maintenance Methods 0.000 description 4
- 230000002123 temporal effect Effects 0.000 description 4
- 230000006399 behavior Effects 0.000 description 3
- 238000004590 computer program Methods 0.000 description 2
- 238000012986 modification Methods 0.000 description 2
- 230000004048 modification Effects 0.000 description 2
- 238000005096 rolling process Methods 0.000 description 2
- 230000009286 beneficial effect Effects 0.000 description 1
- 238000004364 calculation method Methods 0.000 description 1
- 230000008859 change Effects 0.000 description 1
- 238000000151 deposition Methods 0.000 description 1
- 238000013461 design Methods 0.000 description 1
- 238000001514 detection method Methods 0.000 description 1
- 238000009826 distribution Methods 0.000 description 1
- 238000001035 drying 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/25—Integrating or interfacing systems involving database management systems
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)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The present invention provides a kind of processing method and processing devices of database onboard data.This method includes:During database is run, operating instruction is received, wherein, with functional interface there are one-to-one relationship, the generation method of functional interface includes operating instruction:It is determined at least one functional performance handled database onboard data;For each functional performance, generation in the database is able to carry out the functional interface of the functional performance;And the functional interface of generation and database onboard data are established into call relation, when being called for any functional interface, corresponding function is performed to database onboard data using the functional interface and is operated;Call functional interface corresponding with the operating instruction received;And corresponding function is performed to database onboard data using functional interface and is operated.It can solve the problems, such as only external environment and/or external tool be used to handle database onboard data in the prior art.
Description
The application is《The generation method of database function interface, the processing method and processing device of onboard data》Division Shen
Please:
The applying date of original application:20141224
The application number of original application:201410817129.1
The invention and created name of original application:The generation method of database function interface, the processing method of onboard data and dress
It puts.
Technical field
The present invention relates to Internet technical field, more particularly to a kind of processing method and dress of database onboard data
It puts.
Background technology
All the time, association type database is obtained largely due to superior data processing speed and data processing flexibility
The favor of user.And in association type database, MySQL with its is small, speed is fast, the total cost of ownership is low, open source code,
And be many merits such as the most frequently used standardized language for accessing database using SQL language by more and more extensive use
Approve and use in family.
But in the prior art, the data organizing tool of itself is not present in MySQL.It is being managed, count, tieed up
It protects and detects when a variety of operations, it is necessary to which external environment and/or external tool is used to carry out corresponding processing operation.It is and this
To using the dependence of external environment and/or external tool so that have to the operation such as management of MySQL in the time and/or spatially
There is larger limitation, and need higher maintenance cost.
The content of the invention
In view of the above problems, the embodiment of the present invention proposes a kind of processing method and processing device of database onboard data,
To overcome the above problem or solve the above problems at least partly.
One side according to the invention provides a kind of generation method of database function interface, including:It is determined to
At least one functional performance handled database onboard data;For each functional performance, in the database
It is middle to generate the functional interface for being able to carry out the functional performance;The functional interface of generation and the database onboard data are established
Call relation when being called for any functional interface, performs the database onboard data using the functional interface
Corresponding function operates.
Optionally, the database is MySQL database.
Another aspect according to the invention provides a kind of processing method of database onboard data, including:In operation number
During according to storehouse, operating instruction is received, wherein, the operating instruction according to the functional interface of above-mentioned method generation with depositing
In one-to-one relationship;Call functional interface corresponding with the operating instruction received;And utilize the functional interface
Corresponding function operation is performed to database onboard data.
Optionally, the method is further included:Corresponding work(is performed to database onboard data using the functional interface
Can property operation after, operating result is shown according to predetermined manner, wherein, the predetermined manner include it is following at least it
One:Roll the mode of exhibition method, pop-up display mode, display portion or whole implementing results.
Optionally, the functional performance includes at least one following:Inquiry operation, wherein, the inquiry operation includes
It is at least one following:Visit capacity status inquiry operation, Index Status inquiry operation, lock status inquiry operation, authorization message inquiry
Operation, structured query language SQL frequency of use inquiry operation, input and output consumption figures inquiry operation;Statistical operation, wherein,
The statistical operation includes at least:Visit capacity statistical operation and/or table Information Statistics operation;Batch closes process operation;Slow language
Sentence grasping manipulation;Index uses policer operation;Null clear operation.
Optionally, it is described using the functional interface to database onboard data perform corresponding function operate the step of into
One step includes:Using dbastat functional interfaces from information_schema.global_status tables, it is pre- to obtain interval
If the first com_commit of time and the 2nd com_commit, and difference operation is carried out, obtain the first difference;Utilize dbastat
Functional interface obtains the first com_ for being spaced the preset time from information_schema.global_status tables
Rollback and the 2nd com_rollback, and difference operation is carried out, obtain the second difference;To first difference and described second
Difference sums up, and by obtained result divided by the preset time, obtains visit capacity state value.
Optionally, the method is further included:After obtaining visit capacity state value, determine to show according to the preset time
Show the cycle-index of the visit capacity state value;The visit capacity state value is shown according to definite cycle-index.
Optionally, it is further that the step of corresponding function operation is performed to database onboard data using the functional interface
Including:Library name information and table name are obtained from information_schema.tables using dbalock functional interfaces
Information, and index name is obtained from performance_schema.table_io_waits_summary_by_index_usage
Claim information;Untapped index is determined using the library name information, the table name information and the index name information,
Complete Index Status inquiry operation.
Optionally, the method is further included:After determining untapped index, untapped index is determined to described
Carry out list display.
Optionally, it is further that the step of corresponding function operation is performed to database onboard data using the functional interface
Including:INNODB_TRX tables, the INNODB_LOCK_ in information_schema storehouses are obtained using dbalock functional interfaces
WAITS tables and INNODB_LOCKS tables are as data to be managed;Compare INNODB_TRX tables, the INNODB_LOCK_ got
WAITS tables and INNODB_LOCKS tables, the thread information locked complete lock status inquiry operation, wherein, the locking
Thread information includes at least one following:The thread identification information of locking, the temporal information of thread locking, triggering thread lock
Structured query language SQL.
Optionally, the method is further included:Complete lock status inquiry operation, and to the thread information of the locking into
Row displaying.
Optionally, the method further includes:Before receiving operating instruction, data described in login banner information registration are utilized
Storehouse.
Optionally, the database is MySQL database.
Another aspect according to the invention provides a kind of generating means of database function interface, including:Determine mould
Block is adapted to determine that at least one functional performance that can be handled database onboard data;Generation module, suitable for being directed to
Each functional performance, in the database generation are able to carry out the functional interface of the functional performance;Relation establishes module,
Suitable for the functional interface of generation and the database onboard data are established call relation, so that any functional interface is adjusted
Used time performs corresponding function to the database onboard data using the functional interface and operates.
Optionally, the database is MySQL database.
It is according to the invention in another aspect, additionally provide a kind of processing unit of database onboard data, including:Receive mould
Block, suitable for during database is run, receiving operating instruction, wherein, the operating instruction with according to above-mentioned device
There are one-to-one relationships for the functional interface of generation;Calling module, it is corresponding suitable for the operating instruction that calls with receive
Functional interface;Processing module operates suitable for performing corresponding function to database onboard data using the functional interface.
Optionally, described device further includes:Display module, suitable for being held using the functional interface to database onboard data
After the operation of row corresponding function, operating result is shown according to predetermined manner, wherein, the predetermined manner includes following
At least one:Roll the mode of exhibition method, pop-up display mode, display portion or whole implementing results.
Optionally, the functional performance includes at least one following:Inquiry operation, wherein, the inquiry operation includes
It is at least one following:Visit capacity status inquiry operation, Index Status inquiry operation, lock status inquiry operation, authorization message inquiry
Operation, structured query language SQL frequency of use inquiry operation, input and output consumption figures inquiry operation;Statistical operation, wherein,
The statistical operation includes at least:Visit capacity statistical operation and/or table Information Statistics operation;Batch closes process operation;Slow language
Sentence grasping manipulation;Index uses policer operation;Null clear operation.
Optionally, the processing module further includes:Acquiring unit, suitable for using dbastat functional interfaces from
In information_schema.global_status tables, the first com_commit and second of interval preset time is obtained
com_commit;And it is obtained using dbastat functional interfaces from information_schema.global_status tables
Take the first com_rollback and the 2nd com_rollback for being spaced the preset time;Determination unit, suitable for described
One com_commit and the 2nd com_commit carries out difference operation, obtains the first difference;To the first com_
Rollback and the 2nd com_rollback carries out difference operation, obtains the second difference;And to first difference and
Second difference sums up, and by obtained result divided by the preset time, obtains visit capacity state value.
Optionally, the display module is further adapted for:It is determined to show the visit capacity state value according to the preset time
Cycle-index;The visit capacity state value is shown according to definite cycle-index.
Optionally, the processing module further includes:The acquiring unit, be further adapted for using dbalock functional interfaces from
Obtain library name information and table name information in information_schema.tables, and from performance_
Index name information is obtained in schema.table_io_waits_summary_by_index_usage;The determination unit,
It is further adapted for determining untapped index using the library name information, the table name information and the index name information,
Complete Index Status inquiry operation.
Optionally, the display module is further adapted for:After determining untapped index, untapped index is determined to described
Carry out list display.
Optionally, the processing module further includes:The acquiring unit is further adapted for obtaining using dbalock functional interfaces
INNODB_TRX tables, INNODB_LOCK_WAITS tables and INNODB_LOCKS table conducts in information_schema storehouses
Data to be managed;The determination unit, be further adapted for comparison get INNODB_TRX tables, INNODB_LOCK_WAITS tables and
INNODB_LOCKS tables, the thread information locked complete lock status inquiry operation, wherein, the thread information of the locking
Including at least one following:The structuring that the thread identification information of locking, the temporal information of thread locking, triggering thread lock is looked into
Ask language SQL.
Optionally, the display module is further adapted for:Lock status inquiry operation is completed, the thread information of the locking is carried out
Displaying.
Optionally, described device further includes:Login module, suitable for work as the receiving module receive any operating instruction it
Before, utilize database described in login banner information registration.
Optionally, the database is MySQL database.
According to the embodiment of the present invention database function interface generation method, be determined to database onboard data into
At least one functional performance of row processing, for each functional performance, generation in the database is able to carry out the functionality
The functional interface of operation, and the functional interface of generation and database onboard data are established into call relation, so that any function connects
When mouth is called, corresponding function is performed to database onboard data using the functional interface and is operated.It can be seen that the present invention is real
The functional interface handled database onboard data of the generation method generation of example is applied, for the function of generating in the database
Interface does not depend on external environment and/or external tool, is provided for database itself.For example, to database onboard data
The functional interface of reason can be based on database store process, and the functional interface write using SQL statement.When database is run
When, without any additional conditions, you can the functional interface generated in this example to be used to perform database, management etc. is functional to grasp
Make, can solve only external environment and/or external tool be used to handle database onboard data in the prior art
The problem of.Therefore, the functional interface logarithm generated using the generation method of the database function interface according to the embodiment of the present invention
It is operated according to storehouse executive function, to external dependence when processing database onboard data can be greatly reduced, and then can
Maintenance cost is effectively reduced, and enables to the limitation of the operation such as management to database from the time and/or spatially, is expanded
The use scope of large database concept.It is in addition, directly right using the instrument according to database itself and/or the functional interface of environment generation
Database onboard data is handled, and is substituted the participation of external environment and/or external tool, can be saved memory source, avoid
The onboard data of database is handled using external environment and/or external tool the operation of database in itself is caused it is bad
It influences.
Above description is only the general introduction of technical solution of the present invention, in order to better understand the technological means of the present invention,
And can be practiced according to the content of specification, and in order to allow above and other objects of the present invention, feature and advantage can
It is clearer and more comprehensible, below the special specific embodiment for lifting the present invention.
According to the accompanying drawings to the detailed description of the specific embodiment of the invention, those skilled in the art will be brighter
The above and other objects, advantages and features of the present invention.
Description of the drawings
By reading the detailed description of following description, it is various other the advantages of and benefit for ordinary skill
Personnel will be apparent understanding.Attached drawing is only used for showing the purpose of embodiment, and is not considered as limitation of the present invention.And
And throughout the drawings, the same reference numbers will be used to refer to the same parts.In the accompanying drawings:
Fig. 1 shows the process chart of the generation method of database function interface according to an embodiment of the invention;
Fig. 2 shows the process chart of the processing method of database onboard data according to an embodiment of the invention;
Fig. 3 shows the structure diagram of the generating means of database function interface according to an embodiment of the invention;
Fig. 4 shows the structure diagram of the processing unit of database onboard data according to an embodiment of the invention;
Fig. 5 shows the structural representation of the processing unit of database onboard data in accordance with another embodiment of the present invention
Figure;
Fig. 6 shows the structural representation of the processing unit of the database onboard data of another embodiment according to the present invention
Figure;And
Fig. 7 shows the structural representation of the processing unit of the database onboard data of further embodiment according to the present invention
Figure.
Specific embodiment
The exemplary embodiment of the disclosure is more fully described below with reference to accompanying drawings.Although the disclosure is shown in attached drawing
Exemplary embodiment, it being understood, however, that may be realized in various forms the disclosure without should be by embodiments set forth here
It is limited.On the contrary, these embodiments are provided to facilitate a more thoroughly understanding of the present invention, and can be by the scope of the present disclosure
Completely it is communicated to those skilled in the art.
In order to solve the above technical problems, an embodiment of the present invention provides a kind of generation methods of database function interface.Fig. 1
Show the process chart of the generation method of database function interface according to an embodiment of the invention.It please refers to Fig.1, it should
Flow includes at least following steps:
Step S102:It is determined at least one functional performance handled database onboard data;
Step S104:For each functional performance, generation in the database is able to carry out the function of the functional performance
Interface;
Step S106:The functional interface of generation and database onboard data are established into call relation, so that any function connects
When mouth is called, corresponding function is performed to database onboard data using the functional interface and is operated.
According to the embodiment of the present invention database function interface generation method, be determined to database onboard data into
At least one functional performance of row processing, for each functional performance, generation in the database is able to carry out the functionality
The functional interface of operation, and the functional interface of generation and database onboard data are established into call relation, so that any function connects
When mouth is called, corresponding function is performed to database onboard data using the functional interface and is operated.It can be seen that the present invention is real
The functional interface handled database onboard data of the generation method generation of example is applied, for the function of generating in the database
Interface does not depend on external environment and/or external tool, is provided for database itself.For example, to database onboard data
The functional interface of reason can be based on database store process, and the functional interface write using SQL statement.When database is run
When, without any additional conditions, you can the functional interface generated in this example to be used to perform database, management etc. is functional to grasp
Make, can solve only external environment and/or external tool be used to handle database onboard data in the prior art
The problem of.Therefore, the functional interface logarithm generated using the generation method of the database function interface according to the embodiment of the present invention
It is operated according to storehouse executive function, to external dependence when processing database onboard data can be greatly reduced, and then can
Maintenance cost is effectively reduced, and enables to the limitation of the operation such as management to database from the time and/or spatially, is expanded
The use scope of large database concept.It is in addition, directly right using the instrument according to database itself and/or the functional interface of environment generation
Database onboard data is handled, and is substituted the participation of external environment and/or external tool, can be saved memory source, avoid
The onboard data of database is handled using external environment and/or external tool the operation of database in itself is caused it is bad
It influences.
It should be noted that the database in the embodiment of the present invention can be arbitrarily can utilize itself instrument and/or
Database of the environment generation functional interface to be managed to onboard data, the embodiment of the present invention is to this and is not limited.It is real
In the operation of border, MySQL database is with its is small, speed is fast, the total cost of ownership is low, open source code and used SQL languages
Speech is many merits such as the most frequently used standardized language for accessing database by more and more extensive customer acceptance and use, because
This, the database in the embodiment of the present invention includes MySQL database.
The generation method of the database function interface in the embodiment of the present invention is described above.When generation database
After functional interface, database onboard data can be handled using the functional interface of generation.Therefore, based on each reality above
The generation method of the database function interface of example offer is applied, the embodiment of the present invention additionally provides a kind of place of database onboard data
Reason method.Fig. 2 shows the process chart of the processing method of database onboard data according to an embodiment of the invention.Please
With reference to figure 2, which includes at least following steps:
Step S202:During database is run, receive operating instruction, wherein, operating instruction with according to above
There are one-to-one relationships for the functional interface of the generation method generation of the database function interface of introduction;
Step S204:Call functional interface corresponding with the operating instruction received;
Step S206:Corresponding function is performed using functional interface to database onboard data to operate.
According to the embodiment of the present invention database onboard data processing method, can during database is run,
It receives with the functional interface using method generation described above there are the operating instruction of one-to-one relationship, calls corresponding
Functional interface, and corresponding function is performed to database onboard data using the functional interface called and is operated.Therefore, according to this hair
The processing method of the database onboard data of bright embodiment can utilize the functional interface generated in the database in database
It puts data to be handled, external environment and/or external tool can only be used to number built in database in the prior art by solving
The problem of according to being handled, improves the efficiency that processing operation is carried out to database onboard data.
It is referred to when the generation method to database function interface is introduced, the database in the embodiment of the present invention can be with
It is that can arbitrarily utilize database of the instrument and/or environment generation functional interface of itself to be managed to onboard data, this
Inventive embodiments are to this and are not limited.Also, the database in the embodiment of the present invention includes MySQL database.Now with
MySQL database is introduced the processing method of database onboard data of the present invention for embodiment, and by MySQL database
Referred to as MySQL.
According to above it will be appreciated that, during MySQL is run, operating instruction can be received.To ensure that basis receives
Operating instruction security, the operating instruction for receiving malice is avoided to damage MySQL onboard datas, in this example,
Before receiving operating instruction, login banner information registration MySQL is utilized.When logining successfully, when receiving operating instruction, adjust
With functional interface corresponding with operating instruction, to handle MySQL onboard datas.If login failure, possible active user
To the onboard data of MySQL without processing authority, then refuse to call corresponding functional interface pair according to the operating instruction received
MySQL onboard datas are handled, to ensure the security of MySQL onboard datas.
When logining successfully, if receiving operating instruction, the embodiment of the present invention is called corresponding with the operating instruction received
Functional interface, and corresponding function is performed to MySQL onboard datas using the functional interface called and is operated.Utilizing functional interface
After corresponding function operation is performed to MySQL onboard datas, to guarantee to know operating result in time, so as to according to operation
As a result the operation subsequently to MySQL onboard datas is adjusted, the embodiment of the present invention is shown operating result according to predetermined manner.
Wherein, predetermined manner used in being shown to operating result can be arbitrarily can be to side that operating result is shown
Formula.For example, the mode being shown to operating result can include rolling exhibition method, pop-up exhibition method, exposition or
The mode of all operationss result.
In addition, functional interface corresponding with the operating instruction received is called in the embodiment of the present invention to number built in MySQL
According to execution functional performance can include arbitrarily to MySQL onboard datas perform management operation and/or statistical operation and/or
Attended operation and/or detection operation etc..It is closed for example, batch can be included to the functional performance that MySQL onboard datas perform
It closes process operation, slow sentence grasping manipulation, index and uses policer operation, null clear operation, statistical operation and inquiry operation etc..
Wherein, statistical operation may further include visit capacity statistical operation and/or table Information Statistics operation.Inquiry operation can be into one
Step includes visit capacity status inquiry operation, Index Status inquiry operation, lock status inquiry operation, authorization message inquiry operation, knot
Structure query language SQL frequency of use inquiry operation, input and output consumption figures inquiry operation etc..
The processing method of MySQL onboard datas for each embodiment above is provided is illustrated and must be more clearly understood, and is now carried
The processing method of MySQL onboard datas provided in an embodiment of the present invention is introduced for embodiment.
Embodiment one
It in MySQL operational process, receives visit capacity state value and checks instruction (i.e. one of operating instruction), call
Dbastat functional interfaces, and using dbastat functional interfaces from information_schema.global_status tables,
Obtain interval the first com_commit of preset time and the 2nd com_commit and the first com_rollback and second
Com_rollback, and difference operation is carried out respectively, obtain the first difference and the second difference.
For example, it is respectively 80 Hes to get the first com_commit and the 2nd com_commit that interval time is 10 seconds
90, it is respectively 10 and 60 to get the first com_rollback and the 2nd com_rollback that interval time is 10 seconds, respectively
After carrying out difference operation, it is 10 to obtain the first difference, and the second difference is 50.
The first obtained difference and the second difference are summed up, and obtained result is in preset time, must be visited
The amount of asking state value.Such as, it is 10 that the first difference is obtained in upper example, and the second difference is 50, and preset time is 10 seconds, then obtains visit capacity
State most 6, unit are a per second.
After obtaining visit capacity state value, the embodiment of the present invention determines following for display visit capacity state value according to preset time
Ring number, and visit capacity state value is shown according to definite cycle-index.For example, preset time is 10 seconds, if per second
Visit capacity state value is once shown, it is determined that cycle-index is 10 times.Further, since visit capacity state value is single
Value, usually not compared with other state values, therefore, when being shown to visit capacity state value, can select rolling exhibition
The mode shown shows visit capacity state value.
Embodiment two
During MySQL is run, if receiving Index Status checks instruction (i.e. one of operating instruction), call
Dbaindexno functional interfaces obtain storehouse using dbaindexno functional interfaces from information_schema.tables
Name information and table name information, and from performance_schema.table_io_waits_summary_by_
Index name information is obtained in index_usage, and then utilizes library name information, table name information and the index name got
Information is claimed to complete Index Status inquiry operation.
For example, library name information and table are obtained from information_schema.tables using dbaindexno
Name information, the corresponding library name information in storehouse that removal MySQL is carried, and remove table name of the number of data lines less than the table of 1000 rows
Claim information.Afterwards, using dbaindexno from performance_schema.table_io_waits_summary_by_
The index name information that index name information is sky and the index that index name information is PRIMARY are removed in index_usage
Name information, and determine the result (each directory entry being not used by line) of COUNT_STAR=0.
After completing Index Status inquiry operation, definite each untapped directory entry is shown, also, is worked as
When the quantity of untapped directory entry is excessive, the unused directory entry of preset number can be only shown.For example, currently not
The directory entry used is 10000, when being shown to untapped directory entry, 20 is only shown, so as to follow-up
Index is optimized in operation.
Embodiment three
During MySQL is run, if receiving lock status inquiry instruction (i.e. one of operating instruction), call
Dbalock functional interfaces, and obtain the INNODB_TRX in information_schema storehouses using dbalock functional interfaces
Table, INNODB_LOCK_WAITS tables and INNODB_LOCKS tables.Compare INNODB_TRX tables, the INNODB_LOCK_ got
WAITS tables and INNODB_LOCKS tables, the thread information locked complete lock status inquiry operation, and the locking to obtaining
Thread information be shown.When the thread information to locking is shown, the line of each locking got can be shown
Journey information, the structuralized query that the temporal information and triggering thread that the thread identification information including locking, thread lock lock
Language (Structured Query Language, hereinafter referred to as SQL).
The processing method of the MySQL onboard datas of the embodiment of the present invention has been carried out further using three embodiments above
Ground introduction.It should be noted that by above it will be appreciated that in this example to MySQL onboard datas perform functional performance include can be right
The arbitrary processing that MySQL onboard datas carry out, however it is not limited to the functional performance provided in above three embodiment.For example, this
The functional performance that can also be performed in example to MySQL onboard datas includes:
(1) information_ is called according to the field type of input using dbakill functional interfaces
Data in schema.PROCESSLIST tables, and perform and close corresponding connection threading operation;
(2) data in information_schema.PROCESSLIST tables are called using dbaslow functional interfaces, drawn
As execution time longest preset number (such as 100) SQL on front.
(3) information_schema.schemata and information_ is called using dbatable functional interfaces
Schema.tables tables calculate the distribution of outbound table, the information such as table size, index size, table row number;
(4) using dbaindex functional interfaces call information_schema.STATISTICS and
Information_schema.tables tables, comparison draw the information such as table index state and the table row number of specified bank;
(5) authorization message of database is called using dbagrant functional interfaces, and according to the user name of offer, network is mutual
Each authorization message met is listed in the fuzzy matching such as connection protocol fields;
(6) tables, the statistics in information_schema are called using dbawarm functional interfaces,
Columns, key_column_usage, to perform warm-up operation to database before each application is come into operation;
(7) using dbasqlmost functional interfaces to performance_schema.events_statements_
Summary_by_digest tables are calculated, and draw the execution time in sentence on line until current time since Startup time
The most sentence of number;
(8) using dbahottable functional interfaces to performance_schema.table_io_waits_
Summary_by_index_usage tables are calculated, and obtain the highest table name information of access frequency;
(9) using dbaiofile functional interfaces to performance_schema.table_io_waits_summary_
By_index_usage tables are calculated, and obtain the file name information that input and output consume highest file;
(10) behaviour is emptied to each statistical form execution under performance_schema using dbacleanps functional interfaces
Make;
(11) using dbasqlanalyze functional interfaces to the events_ in performance_schema storehouses
Statements_summary_by_digest, table_io_waits_summary_by_index_usage and events_
The tables such as the tables in waits_history and information_schema carry out combined calculation, and obtain single SQL and exist
The time-consuming situation of each step in implementation procedure.
Based on the generation method of each database function interface for implementing to provide above, based on same inventive concept, the present invention
Embodiment provides a kind of generating means of database function interface.Fig. 3 shows data according to an embodiment of the invention
The structure diagram of the generating means of library facility interface.Referring to Fig. 3, the generation of the database function interface of the embodiment of the present invention fills
It puts and establishes module 330 including at least determining module 310, generation module 320 and relation.
Now introduce each device of the generating means of the database function interface of the embodiment of the present invention or the function of composition and
Connection relation between each several part:
Determining module 310:It is adapted to determine that at least one functional performance that can be handled database onboard data;
Generation module 320:It is coupled with determining module 310, suitable for being directed to each functional performance, generates in the database
It is able to carry out the functional interface of the functional performance;
Relation establishes module 330:It is coupled with generation module 320, suitable for built in the functional interface and database that will generate
Data establish call relation, and when being called for any functional interface, database onboard data is performed using the functional interface
Corresponding function operates.
In another embodiment, database is MySQL database.
Based on the processing method of the database onboard data that each embodiment provides above, based on same inventive concept, this hair
Bright embodiment additionally provides a kind of processing unit of database onboard data.Fig. 4 shows according to an embodiment of the invention
The structure diagram of the processing unit of database onboard data.Referring to Fig. 4, the place of the database onboard data of the embodiment of the present invention
It manages device and includes at least receiving module 410, calling module 420 and processing module 430.
Now introduce each device of the processing unit of the database onboard data of the embodiment of the present invention or the function of composition and
Connection relation between each several part:
Receiving module 410:Suitable for during database is run, receiving operating instruction, wherein, operating instruction and root
There are one-to-one relationships for the functional interface generated according to the generating means of database function interface described above;
Calling module 420:It is coupled with receiving module 410, suitable for the corresponding function of the operating instruction that calls with receive
Interface;
Processing module 430:It is coupled with calling module 420, suitable for being performed using functional interface to database onboard data
Corresponding function operates.
Fig. 5 shows the structural representation of the processing unit of database onboard data in accordance with another embodiment of the present invention
Figure.Please also refer to Fig. 4 and Fig. 5, the processing unit of the database onboard data in the Fig. 4 that compares, the database of the present embodiment
The processing unit (as shown in Figure 5) of onboard data further includes:
Display module 440 is coupled with processing module 430, suitable for being performed using functional interface to database onboard data
Corresponding function operation after, operating result is shown according to predetermined manner, wherein, predetermined manner include it is following at least it
One:Roll the mode of exhibition method, pop-up display mode, display portion or whole implementing results.
In another embodiment, functional performance includes at least one following:
Inquiry operation, wherein, inquiry operation includes at least one following:Visit capacity status inquiry operation, Index Status are looked into
Ask operation, lock status inquiry operation, authorization message inquiry operation, structured query language SQL frequency of use inquiry operation, input
Export consumption figures inquiry operation;
Statistical operation, wherein, statistical operation includes at least:Visit capacity statistical operation and/or table Information Statistics operation;Batch
Amount closes process operation;Slow sentence grasping manipulation;Index uses policer operation;Null clear operation.
Fig. 6 shows the structural representation of the processing unit of the database onboard data of another embodiment according to the present invention
Figure.Please also refer to Fig. 4 and Fig. 6, the processing unit of the database onboard data in the Fig. 4 that compares, the processing mould of the present embodiment
Block 430 (as shown in Figure 6) further includes:
Acquiring unit 431, suitable for utilizing dbastat functional interfaces from information_schema.global_status
In table, the first com_commit and the 2nd com_commit of interval preset time are obtained;And
Using dbastat functional interfaces from information_schema.global_status tables, it is pre- to obtain interval
If the first com_rollback of time and the 2nd com_rollback;
Determination unit 432 is coupled with acquiring unit 431, suitable for the first com_commit and the 2nd com_commit
Difference operation is carried out, obtains the first difference;
Difference operation is carried out to the first com_rollback and the 2nd com_rollback, obtains the second difference;And
First difference and the second difference are summed up, and by obtained result divided by preset time, obtain visit capacity shape
State value.
In another embodiment, display module 440 is further adapted for:
The cycle-index of display visit capacity state value is determined according to preset time;
Visit capacity state value is shown according to definite cycle-index.
In another embodiment, processing module 430 further includes:
Acquiring unit 431 is further adapted for obtaining from information_schema.tables using dbalock functional interfaces
Take library name information and table name information, and from performance_schema.table_io_waits_summary_by_
Index name information is obtained in index_usage;
Determination unit 432 is further adapted for determining to be not used using library name information, table name information and index name information
Index, complete Index Status inquiry operation.
In another embodiment, display module 440 is further adapted for:
After determining untapped index, to determining that untapped index carries out list display.
In another embodiment, processing module 430 further includes:
Acquiring unit 431 is further adapted for obtaining in information_schema storehouses using dbalock functional interfaces
INNODB_TRX tables, INNODB_LOCK_WAITS tables and INNODB_LOCKS tables are as data to be managed;
Determination unit 432, be further adapted for comparison get INNODB_TRX tables, INNODB_LOCK_WAITS tables and
INNODB_LOCKS tables, the thread information locked complete lock status inquiry operation, wherein, the thread information of locking includes
It is at least one following:The structuralized query language that the thread identification information of locking, the temporal information of thread locking, triggering thread lock
Say SQL.
In another embodiment, display module 440 is further adapted for:
Lock status inquiry operation is completed, and the thread information of locking is shown.
Fig. 7 shows the structural representation of the processing unit of the database onboard data of further embodiment according to the present invention
Figure.Please also refer to Fig. 4 and Fig. 7, the processing unit for the database onboard data shown in Fig. 4 that compares, the data of the present embodiment
The processing unit of storehouse onboard data further includes (shown in Fig. 7):
Login module 450 suitable for working as before receiving module receives any operating instruction, utilizes login banner information registration
Database.
In another embodiment, database is MySQL database.
According to the combination of any one above-mentioned embodiment or multiple embodiments, the embodiment of the present invention can reach following beneficial
Effect:
According to the embodiment of the present invention database function interface generation method, be determined to database onboard data into
At least one functional performance of row processing, for each functional performance, generation in the database is able to carry out the functionality
The functional interface of operation, and the functional interface of generation and database onboard data are established into call relation, so that any function connects
When mouth is called, corresponding function is performed to database onboard data using the functional interface and is operated.It can be seen that the present invention is real
The functional interface handled database onboard data of the generation method generation of example is applied, for the function of generating in the database
Interface does not depend on external environment and/or external tool, is provided for database itself.For example, to database onboard data
The functional interface of reason can be based on database store process, and the functional interface write using SQL statement.When database is run
When, without any additional conditions, you can the functional interface generated in this example to be used to perform database, management etc. is functional to grasp
Make, can solve only external environment and/or external tool be used to handle database onboard data in the prior art
The problem of.Therefore, the functional interface logarithm generated using the generation method of the database function interface according to the embodiment of the present invention
It is operated according to storehouse executive function, to external dependence when processing database onboard data can be greatly reduced, and then can
Maintenance cost is effectively reduced, and enables to the limitation of the operation such as management to database from the time and/or spatially, is expanded
The use scope of large database concept.It is in addition, directly right using the instrument according to database itself and/or the functional interface of environment generation
Database onboard data is handled, and is substituted the participation of external environment and/or external tool, can be saved memory source, avoid
The onboard data of database is handled using external environment and/or external tool the operation of database in itself is caused it is bad
It influences.
In the specification provided in this place, numerous specific details are set forth.It is to be appreciated, however, that the implementation of the present invention
Example can be put into practice without these specific details.In some instances, well known method, structure is not been shown in detail
And technology, so as not to obscure the understanding of this description.
Similarly, it should be understood that in order to simplify the disclosure and help to understand one or more of each inventive aspect,
Above in the description of exemplary embodiment of the present invention, each feature of the invention is grouped together into single implementation sometimes
In example, figure or descriptions thereof.However, the method for the disclosure should be construed to reflect following intention:I.e. required guarantor
Shield the present invention claims the more features of feature than being expressly recited in each claim.It is more precisely, such as following
Claims reflect as, inventive aspect is all features less than single embodiment disclosed above.Therefore,
Thus the claims for following specific embodiment are expressly incorporated in the specific embodiment, wherein each claim is in itself
Separate embodiments all as the present invention.
Those skilled in the art, which are appreciated that, to carry out adaptively the module in the equipment in embodiment
Change and they are arranged in one or more equipment different from the embodiment.It can be the module or list in embodiment
Member or component be combined into a module or unit or component and can be divided into addition multiple submodule or subelement or
Sub-component.In addition at least some in such feature and/or process or unit exclude each other, it may be employed any
Combination is disclosed to all features disclosed in this specification (including adjoint claim, summary and attached drawing) and so to appoint
Where all processes or unit of method or equipment are combined.Unless expressly stated otherwise, this specification is (including adjoint power
Profit requirement, summary and attached drawing) disclosed in each feature can be by providing the alternative features of identical, equivalent or similar purpose come generation
It replaces.
In addition, it will be appreciated by those of skill in the art that although some embodiments described herein include other embodiments
In included some features rather than other feature, but the combination of the feature of different embodiments means in of the invention
Within the scope of and form different embodiments.For example, in detail in the claims, embodiment claimed it is one of arbitrary
It mode can use in any combination.
The all parts embodiment of the present invention can be with hardware realization or to be run on one or more processor
Software module realize or realized with combination thereof.It will be understood by those of skill in the art that it can use in practice
Microprocessor either digital signal processor (DSP) come realize in device according to embodiments of the present invention or equipment some or
The some or all functions of person's whole component.The present invention is also implemented as performing one of method as described herein
Divide either whole equipment or program of device (for example, computer program and computer program product).Such this hair of realization
Bright program can may be stored on the computer-readable medium or can have the form of one or more signal.It is such
Signal can be downloaded from internet website to be obtained either providing on carrier signal or providing in the form of any other.
It should be noted that the present invention will be described rather than limits the invention for above-described embodiment, and ability
Field technique personnel can design alternative embodiment without departing from the scope of the appended claims.In the claims,
Any reference symbol between bracket should not be configured to limitations on claims.Word "comprising" does not exclude the presence of not
Element or step listed in the claims.Word "a" or "an" before element does not exclude the presence of multiple such
Element.The present invention can be by means of including the hardware of several different elements and being come by means of properly programmed computer real
It is existing.If in the unit claim for listing equipment for drying, several in these devices can be by same hardware branch
To embody.The use of word first, second, and third does not indicate that any order.These words can be explained and run after fame
Claim.
So far, although those skilled in the art will appreciate that detailed herein have shown and described multiple showing for the present invention
Example property embodiment, still, without departing from the spirit and scope of the present invention, still can according to the present disclosure directly
Determine or derive many other variations or modifications consistent with the principles of the invention.Therefore, the scope of the present invention is understood that and recognizes
It is set to and covers other all these variations or modifications.
The invention also discloses a kind of processing methods of database onboard data of A1., including:
During database is run, operating instruction is received, wherein, the operating instruction exists one by one with functional interface
Correspondence, wherein, the generation method of the functional interface includes:Be determined to handle database onboard data to
A few functional performance;
For each functional performance, generation in the database is able to carry out the functional interface of the functional performance;
And
The functional interface of generation and the database onboard data are established into call relation, for any functional interface
When called, corresponding function is performed to the database onboard data using the functional interface and is operated;
Call functional interface corresponding with the operating instruction received;And
Corresponding function is performed using the functional interface to database onboard data to operate;
Wherein, the step of corresponding function operates is performed to database onboard data using the functional interface further to wrap
It includes:
Obtained using dbaindexno functional interfaces from information_schema.tables library name information and
Table name information, and obtained from performance_schema.table_io_waits_summary_by_index_usage
Index name information;
Untapped rope is determined using the library name information, the table name information and the index name information
Draw, complete Index Status inquiry operation.
A2. the method according to A1, wherein, the method is further included:
After performing corresponding function operation to database onboard data using the functional interface, according to predetermined manner pair
Operating result is shown, wherein, the predetermined manner includes at least one following:Roll exhibition method, pop-up exhibition method,
Exposition or all mode of the operating result.
A3. the method according to A1 or A2, wherein, the functional performance includes at least one following:
Inquiry operation, wherein, the inquiry operation includes at least one following:Visit capacity status inquiry operation, index shape
State inquiry operation, lock status inquiry operation, authorization message inquiry operation, structured query language SQL frequency of use inquiry operation,
Input and output consumption figures inquiry operation;
Statistical operation, wherein, the statistical operation includes at least:Visit capacity statistical operation and/or table Information Statistics behaviour
Make;
Batch closes process operation;
Slow sentence grasping manipulation;
Index uses policer operation;
Null clear operation.
A4. the method according to A1, wherein, the method is further included:After determining untapped index, to institute
It states definite untapped index and carries out list display.
A5. the method according to A1 or A2, wherein, the method further includes:Before receiving operating instruction, using stepping on
It records identification information and logs in the database.
A6. the method according to A1 or A2, wherein, the database is MySQL database.
The invention also discloses a kind of processing units of database onboard data of B7., including:
Receiving module, suitable for during database is run, receiving operating instruction, wherein, the operating instruction and work(
Can interface there are one-to-one relationship, wherein, the functional interface generates as follows:Determining module, being adapted to determine that can
At least one functional performance handled database onboard data;
Generation module, suitable for being directed to each functional performance, generation in the database is able to carry out functionality behaviour
Work energy interface;
Relation establishes module, suitable for the functional interface of generation and the database onboard data are established call relation, with
When being called for any functional interface, corresponding function is performed to the database onboard data using the functional interface and is grasped
Make;
Calling module, suitable for the corresponding functional interface of the operating instruction that calls with receive;
Processing module operates suitable for performing corresponding function to database onboard data using the functional interface;
Wherein, the processing module further includes:
Acquiring unit, suitable for obtaining library name from information_schema.tables using dbalock functional interfaces
Claim information and table name information, and from performance_schema.table_io_waits_summary_by_index_
Index name information is obtained in usage;Determination unit, suitable for utilizing the library name information, the table name information and institute
It states index name information and determines untapped index, complete Index Status inquiry operation.
B8. the device according to B7, wherein, described device further includes:
Display module, after performing corresponding function operation to database onboard data using the functional interface,
Operating result is shown according to predetermined manner, wherein, the predetermined manner includes at least one following:Roll displaying side
Formula, pop-up display mode, display portion or whole modes of the operating result.
B9. the device according to B7 or B8, wherein, the functional performance includes at least one following:
Inquiry operation, wherein, the inquiry operation includes at least one following:Visit capacity status inquiry operation, index shape
State inquiry operation, lock status inquiry operation, authorization message inquiry operation, structured query language SQL frequency of use inquiry operation,
Input and output consumption figures inquiry operation;Statistical operation, wherein, the statistical operation includes at least:Visit capacity statistical operation and/
Or table Information Statistics operation;Batch closes process operation;Slow sentence grasping manipulation;Index uses policer operation;Null clear operation.
B10. the device according to B8, wherein, the display module is further adapted for:It is right after determining untapped index
It is described to determine that untapped index carries out list display.
B11. the device according to B7 or B8, wherein, described device further includes:
Login module suitable for working as before the receiving module receives any operating instruction, is stepped on using login banner information
Record the database.
B12. the device according to B7 or B8, wherein, the database is MySQL database.
Claims (10)
1. a kind of processing method of database onboard data, including:
During database is run, operating instruction is received, wherein, the operating instruction exists with functional interface to be corresponded
Relation, wherein, the generation method of the functional interface includes:It is determined to database onboard data is handled at least one
A functional performance;
For each functional performance, generation in the database is able to carry out the functional interface of the functional performance;And
The functional interface of generation and the database onboard data are established into call relation, so that any functional interface is adjusted
Used time performs corresponding function to the database onboard data using the functional interface and operates;
Call functional interface corresponding with the operating instruction received;And
Corresponding function is performed using the functional interface to database onboard data to operate;
Wherein, the step of corresponding function operates is performed to database onboard data using the functional interface to further comprise:
Library name information and table name are obtained from information_schema.tables using dbaindexno functional interfaces
Claim information, and index is obtained from performance_schema.table_io_waits_summary_by_index_usage
Name information;
Untapped index is determined using the library name information, the table name information and the index name information, it is complete
Into Index Status inquiry operation.
2. according to the method described in claim 1, wherein, the method is further included:
After performing corresponding function operation to database onboard data using the functional interface, according to predetermined manner to operation
As a result it is shown, wherein, the predetermined manner includes at least one following:Roll exhibition method, pop-up exhibition method, displaying
The mode of the part or all of operating result.
3. method according to claim 1 or 2, wherein, the functional performance includes at least one following:
Inquiry operation, wherein, the inquiry operation includes at least one following:Visit capacity status inquiry operation, Index Status are looked into
Ask operation, lock status inquiry operation, authorization message inquiry operation, structured query language SQL frequency of use inquiry operation, input
Export consumption figures inquiry operation;
Statistical operation, wherein, the statistical operation includes at least:Visit capacity statistical operation and/or table Information Statistics operation;
Batch closes process operation;
Slow sentence grasping manipulation;
Index uses policer operation;
Null clear operation.
4. according to the method described in claim 1, wherein, the method is further included:It is right after determining untapped index
It is described to determine that untapped index carries out list display.
5. method according to claim 1 or 2, wherein, the method further includes:Before receiving operating instruction, utilize
Database described in login banner information registration.
6. method according to claim 1 or 2, wherein, the database is MySQL database.
7. a kind of processing unit of database onboard data, including:
Receiving module, suitable for during database is run, receiving operating instruction, wherein, the operating instruction connects with function
Mouthful there are one-to-one relationship, wherein, the functional interface generates as follows:Determining module, being adapted to determine that being capable of logarithm
At least one functional performance handled according to storehouse onboard data;
Generation module, suitable for being directed to each functional performance, generation in the database is able to carry out the functional performance
Functional interface;
Relation establishes module, suitable for the functional interface of generation and the database onboard data are established call relation, for appointing
When one functional interface is called, corresponding function is performed to the database onboard data using the functional interface and is operated;
Calling module, suitable for the corresponding functional interface of the operating instruction that calls with receive;
Processing module operates suitable for performing corresponding function to database onboard data using the functional interface;
Wherein, the processing module further includes:
Acquiring unit is believed suitable for obtaining library name from information_schema.tables using dbalock functional interfaces
Breath and table name information, and from performance_schema.table_io_waits_summary_by_index_usage
Middle acquisition index name information;Determination unit, suitable for utilizing the library name information, the table name information and the index
Name information determines untapped index, completes Index Status inquiry operation.
8. device according to claim 7, wherein, described device further includes:
Display module, after performing corresponding function operation to database onboard data using the functional interface, according to
Predetermined manner is shown operating result, wherein, the predetermined manner includes at least one following:Roll exhibition method, bullet
The mode of window display mode, display portion or whole operating results.
9. the device according to claim 7 or 8, wherein, the functional performance includes at least one following:
Inquiry operation, wherein, the inquiry operation includes at least one following:Visit capacity status inquiry operation, Index Status are looked into
Ask operation, lock status inquiry operation, authorization message inquiry operation, structured query language SQL frequency of use inquiry operation, input
Export consumption figures inquiry operation;Statistical operation, wherein, the statistical operation includes at least:Visit capacity statistical operation and/or table
Information Statistics operate;Batch closes process operation;Slow sentence grasping manipulation;Index uses policer operation;Null clear operation.
10. device according to claim 8, wherein, the display module is further adapted for:After determining untapped index,
Determine that untapped index carries out list display to described.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201711486486.4A CN108090219B (en) | 2014-12-24 | 2014-12-24 | Method and device for processing built-in data of database |
Applications Claiming Priority (2)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201711486486.4A CN108090219B (en) | 2014-12-24 | 2014-12-24 | Method and device for processing built-in data of database |
CN201410817129.1A CN104516964B (en) | 2014-12-24 | 2014-12-24 | The generation method of database function interface, the processing method and processing device of onboard data |
Related Parent Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201410817129.1A Division CN104516964B (en) | 2014-12-24 | 2014-12-24 | The generation method of database function interface, the processing method and processing device of onboard data |
Publications (2)
Publication Number | Publication Date |
---|---|
CN108090219A true CN108090219A (en) | 2018-05-29 |
CN108090219B CN108090219B (en) | 2021-08-20 |
Family
ID=52792263
Family Applications (3)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201711486486.4A Expired - Fee Related CN108090219B (en) | 2014-12-24 | 2014-12-24 | Method and device for processing built-in data of database |
CN201410817129.1A Active CN104516964B (en) | 2014-12-24 | 2014-12-24 | The generation method of database function interface, the processing method and processing device of onboard data |
CN201711482742.2A Pending CN107977475A (en) | 2014-12-24 | 2014-12-24 | The processing method and processing device of database onboard data |
Family Applications After (2)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201410817129.1A Active CN104516964B (en) | 2014-12-24 | 2014-12-24 | The generation method of database function interface, the processing method and processing device of onboard data |
CN201711482742.2A Pending CN107977475A (en) | 2014-12-24 | 2014-12-24 | The processing method and processing device of database onboard data |
Country Status (1)
Country | Link |
---|---|
CN (3) | CN108090219B (en) |
Cited By (1)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN109460416A (en) * | 2018-12-12 | 2019-03-12 | 成都四方伟业软件股份有限公司 | A kind of data processing method, device, electronic equipment and storage medium |
Citations (13)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN1595386A (en) * | 2003-09-09 | 2005-03-16 | 华为技术有限公司 | A method for implementing database access |
CN101217711A (en) * | 2008-01-15 | 2008-07-09 | 中国移动通信集团福建有限公司 | A CRBT Portal stripping method and new platform construction for CRBT after the stripping |
CN101252547A (en) * | 2008-04-14 | 2008-08-27 | 广州汇思通讯科技有限公司 | Middleware system for realizing interactive increase value traffic based on IP set top box and method thereof |
US20080281846A1 (en) * | 2007-05-11 | 2008-11-13 | Oracle International Corporation | High performant row-level data manipulation using a data layer interface |
CN101398915A (en) * | 2007-09-24 | 2009-04-01 | 广州市百成科技有限公司 | Electronic stamp platform system based on internet |
WO2010061260A1 (en) * | 2008-11-03 | 2010-06-03 | Elvin Slavik | Method, system, and product for managing spatial data in a database |
CN202217381U (en) * | 2011-09-14 | 2012-05-09 | 青岛精益优华能源科技有限公司 | Data collector |
CN102508929A (en) * | 2011-12-01 | 2012-06-20 | 浪潮(北京)电子信息产业有限公司 | System, device and method for realizing data migration of heterogeneous database |
CN102750354A (en) * | 2012-06-11 | 2012-10-24 | 清华大学 | Method for analyzing and processing non-structured data query operating language |
CN102902798A (en) * | 2012-10-11 | 2013-01-30 | 德讯科技股份有限公司 | SQL information acquisition and audit method and system for Informix database |
CN103500202A (en) * | 2013-09-29 | 2014-01-08 | 中国船舶重工集团公司第七0九研究所 | Security protection method and system for light-weight database |
CN103795814A (en) * | 2014-02-13 | 2014-05-14 | 浪潮软件股份有限公司 | Short message equipment universal communication interface based on fully domestic CPU and OS |
CN104216989A (en) * | 2014-09-09 | 2014-12-17 | 广东电网公司中山供电局 | Method for storing transmission line integrated data based on HBase |
Family Cites Families (10)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN1264106C (en) * | 2002-03-30 | 2006-07-12 | 中兴通讯股份有限公司 | Method for accessing database system uniformly |
US20060122976A1 (en) * | 2004-12-03 | 2006-06-08 | Shumeet Baluja | Predictive information retrieval |
US8041742B1 (en) * | 2004-12-20 | 2011-10-18 | American Megatrends, Inc. | Method, system, and apparatus for providing generic database services within an extensible firmware interface environment |
CN1848111A (en) * | 2005-04-15 | 2006-10-18 | 中兴通讯股份有限公司 | Realizing method of a data operating interface used in internal-memory database |
CN100433011C (en) * | 2006-01-17 | 2008-11-12 | 中兴通讯股份有限公司 | Under embedded environment, method for protecting consistency of memory database |
JP4940973B2 (en) * | 2007-02-02 | 2012-05-30 | 富士通株式会社 | Logical structure recognition processing program, logical structure recognition processing method, and logical structure recognition processing apparatus |
CN101075266B (en) * | 2007-07-16 | 2010-04-14 | 华为技术有限公司 | Searching system and method |
US8909621B2 (en) * | 2012-11-16 | 2014-12-09 | International Business Machines Corporation | Contextual search history in collaborative archives |
CN103019721B (en) * | 2012-12-14 | 2016-03-30 | 上海华勤通讯技术有限公司 | The implementation method of automation mechanized operation and mobile terminal |
CN103198140B (en) * | 2013-04-16 | 2017-09-19 | 上海斐讯数据通信技术有限公司 | A kind of database storage system and date storage method |
-
2014
- 2014-12-24 CN CN201711486486.4A patent/CN108090219B/en not_active Expired - Fee Related
- 2014-12-24 CN CN201410817129.1A patent/CN104516964B/en active Active
- 2014-12-24 CN CN201711482742.2A patent/CN107977475A/en active Pending
Patent Citations (13)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN1595386A (en) * | 2003-09-09 | 2005-03-16 | 华为技术有限公司 | A method for implementing database access |
US20080281846A1 (en) * | 2007-05-11 | 2008-11-13 | Oracle International Corporation | High performant row-level data manipulation using a data layer interface |
CN101398915A (en) * | 2007-09-24 | 2009-04-01 | 广州市百成科技有限公司 | Electronic stamp platform system based on internet |
CN101217711A (en) * | 2008-01-15 | 2008-07-09 | 中国移动通信集团福建有限公司 | A CRBT Portal stripping method and new platform construction for CRBT after the stripping |
CN101252547A (en) * | 2008-04-14 | 2008-08-27 | 广州汇思通讯科技有限公司 | Middleware system for realizing interactive increase value traffic based on IP set top box and method thereof |
WO2010061260A1 (en) * | 2008-11-03 | 2010-06-03 | Elvin Slavik | Method, system, and product for managing spatial data in a database |
CN202217381U (en) * | 2011-09-14 | 2012-05-09 | 青岛精益优华能源科技有限公司 | Data collector |
CN102508929A (en) * | 2011-12-01 | 2012-06-20 | 浪潮(北京)电子信息产业有限公司 | System, device and method for realizing data migration of heterogeneous database |
CN102750354A (en) * | 2012-06-11 | 2012-10-24 | 清华大学 | Method for analyzing and processing non-structured data query operating language |
CN102902798A (en) * | 2012-10-11 | 2013-01-30 | 德讯科技股份有限公司 | SQL information acquisition and audit method and system for Informix database |
CN103500202A (en) * | 2013-09-29 | 2014-01-08 | 中国船舶重工集团公司第七0九研究所 | Security protection method and system for light-weight database |
CN103795814A (en) * | 2014-02-13 | 2014-05-14 | 浪潮软件股份有限公司 | Short message equipment universal communication interface based on fully domestic CPU and OS |
CN104216989A (en) * | 2014-09-09 | 2014-12-17 | 广东电网公司中山供电局 | Method for storing transmission line integrated data based on HBase |
Non-Patent Citations (3)
Title |
---|
R. BHOWMIK等: "Managing reference tables using Oracle Dynamic SQL and metadata", 《 INTERNATIONAL CONFERENCE ON INFORMATION TECHNOLOGY: RESEARCH AND EDUCATION, 2003. PROCEEDINGS. ITRE2003.》 * |
SPRINGSIDE例子: "MYSQL-INFORMATION_SCHEMA信息数据库(MYSQL注入猜解)", 《HTTPS://WWW.CNBLOGS.COM/SPRINGSIDE-EXAMPLE/ARCHIVE/2007/08/07/2529965.HTML》 * |
郝春吉等: "关系数据库向关联对象的动态转换", 《微计算机信息》 * |
Cited By (1)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN109460416A (en) * | 2018-12-12 | 2019-03-12 | 成都四方伟业软件股份有限公司 | A kind of data processing method, device, electronic equipment and storage medium |
Also Published As
Publication number | Publication date |
---|---|
CN108090219B (en) | 2021-08-20 |
CN107977475A (en) | 2018-05-01 |
CN104516964B (en) | 2018-06-08 |
CN104516964A (en) | 2015-04-15 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
US11030521B2 (en) | Estimating cardinality selectivity utilizing artificial neural networks | |
US9189524B2 (en) | Obtaining partial results from a database query | |
EP2565802B1 (en) | Data masking setup | |
DE112016003626T5 (en) | Natural language interface to databases | |
CN109344153A (en) | The processing method and terminal device of business datum | |
CN102236672A (en) | Method and device for importing data | |
CN108197486A (en) | Big data desensitization method, system, computer-readable medium and equipment | |
CN108304522A (en) | Comparison method, device and the terminal device of difference between a kind of database | |
CN109522228A (en) | Interface automatic test data configuration method, apparatus, platform and storage medium | |
CN108829884A (en) | data mapping method and device | |
US11308086B2 (en) | Increasing database performance through query aggregation | |
CN117033424A (en) | Query optimization method and device for slow SQL (structured query language) statement and computer equipment | |
CN109376063A (en) | A kind of blog search method and apparatus, storage medium | |
CN104516964B (en) | The generation method of database function interface, the processing method and processing device of onboard data | |
US11379478B2 (en) | Optimizing a join operation | |
US10078560B2 (en) | Using run time and historical customer profiling and analytics to determine customer disaster recovery vs. production differences, and to enhance customer disaster recovery readiness and effectiveness | |
CN109829678A (en) | A kind of rollback processing method, device and electronic equipment | |
CN116992092A (en) | Method and device for establishing flow model, storage medium and terminal equipment | |
US10013457B2 (en) | Context based access path selection | |
US9996559B2 (en) | Maintenance actions and user-specific settings of the attribute value derivation instruction set user interface | |
CN111612616A (en) | Block chain account evaluation method and device, terminal device and computer readable medium | |
CN109271431A (en) | Data pick-up method, apparatus, computer equipment and storage medium | |
US8832110B2 (en) | Management of class of service | |
CN109857832A (en) | A kind of preprocess method and device of payment data | |
CN107480210A (en) | Internal storage data operating method and device |
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 | ||
CF01 | Termination of patent right due to non-payment of annual fee | ||
CF01 | Termination of patent right due to non-payment of annual fee |
Granted publication date: 20210820 |