CN107943868A - The method and apparatus for the database middleware that support system information close friend checks - Google Patents
The method and apparatus for the database middleware that support system information close friend checks Download PDFInfo
- Publication number
- CN107943868A CN107943868A CN201711106717.4A CN201711106717A CN107943868A CN 107943868 A CN107943868 A CN 107943868A CN 201711106717 A CN201711106717 A CN 201711106717A CN 107943868 A CN107943868 A CN 107943868A
- Authority
- CN
- China
- Prior art keywords
- system information
- close friend
- database middleware
- information close
- standard sql
- 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/25—Integrating or interfacing systems involving database management systems
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F11/00—Error detection; Error correction; Monitoring
- G06F11/30—Monitoring
- G06F11/34—Recording or statistical evaluation of computer activity, e.g. of down time, of input/output operation ; Recording or statistical evaluation of user activity, e.g. usability assessment
- G06F11/3452—Performance evaluation by statistical analysis
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/242—Query formulation
- G06F16/2433—Query languages
-
- 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
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F2201/00—Indexing scheme relating to error detection, to error correction, and to monitoring
- G06F2201/80—Database-specific techniques
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- Databases & Information Systems (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Data Mining & Analysis (AREA)
- Evolutionary Biology (AREA)
- Probability & Statistics with Applications (AREA)
- Computer Hardware Design (AREA)
- Bioinformatics & Computational Biology (AREA)
- Quality & Reliability (AREA)
- Bioinformatics & Cheminformatics (AREA)
- Life Sciences & Earth Sciences (AREA)
- Mathematical Physics (AREA)
- Computational Linguistics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The method and apparatus for the database middleware that support system information close friend checks, including step：S1, is inquired about by standard sql sentences.The equipment is used for realization the method.The order being made of management port input standard sql sentences is inquired about, convenient and practical.
Description
Technical field
The present invention relates to database middleware, more particularly to support the side for the database middleware that system information close friend checks
Method and equipment.
Background technology
As Internet service amount develops rapidly, data volume surges, and unit MySQL can not meet Internet service performance need
Ask.Scale-up schemes improve performance by lifting hardware configuration at the same time, its scheme is expensive, can only also meet a period of time industry
Business amount, can not tackle the problem at its root, and industry uses scale-out schemes, by the way that data are carried out horizontal fractionation, allow data
It is balanced in the Duo Tai MySQL machines of backstage, whole MySQL clusters concurrent computation ability is lifted by increasing machine, to meet
The demand of internet fast development, its technological means are that table is divided in a point storehouse, wherein using MyCat as the distributed middleware technology of representative
It is the most typical.
However, still there are system information during using MyCat to check disagreeableness problem.
The content of the invention
In order to solve the above-mentioned technical problem, the present invention proposes the side for the database middleware for supporting system information close friend to check
Method and equipment, its technical solution are：
The method for the database middleware that support system information close friend checks, it is characterised in that including step：
S1, is inquired about by standard sql sentences.
The standard sql sentences are inputted by management port.
The step S1 includes step：
S11, by the asynchronous record of standard sql sentences into H2DB databases；
S12, the standard sql sentence implementation status described in periodically asynchronous statistic procedure S11.
The step S1 further includes step：
S13, database middleware information described in periodicity asynchronous collecting.
The equipment for the database middleware that support system information close friend checks, including it is stored with the computer of computer program
Computer-readable recording medium, described program are run for performing：
S1, is inquired about by standard sql sentences.
The beneficial effects of the invention are as follows：The order being made of management port input standard sql sentences is inquired about, both
It is convenient and practical.
Brief description of the drawings
The support sql close friend that Fig. 1 shows according to an embodiment of the present application checks the structure diagram of system information.
Embodiment
In order to be better understood by technical scheme, 1 the invention will be further described below in conjunction with the accompanying drawings.
The method for the database middleware that support system information close friend checks, it is characterised in that including step：
S1, is inquired about by standard sql sentences.
The standard sql sentences are inputted by management port.
As shown in Figure 1, in order to support sql close friend to check system information, query statement is used as using standard sql sentences.
As shown in Figure 1, step S1 includes step：1, asynchronous record SQL is inserted into H2DB databases：
Open a thread to be responsible for asynchronous will to be written into H2DB databases by the SQL of MyCat-X, for uniting later
Meter analysis, there is provided data supply 9066 interface queryings.
MyCat-X is the distributed data base middleware for supporting system information close friend to check.As technology according to the present invention
Scheme is improved existing MyCat rear acquired new distributed data base middleware, is based on community MyCat bases
Secondary development has been done, has been renamed as MyCat-X.
2, periodicity asynchronous collecting MyCat-X information:
Open a thread and be responsible for gathering MyCat-X operation informations (including memory service condition, connection pool, rear end DB heartbeats
Information etc.) write in H2DB databases, there is provided data supply 9066 interface queryings.
3, implementation status of the periodically asynchronous SS sql sentences in MyCat-X:
Open a thread cycle to count based on the SQL that step 1 records, for example SQL performs the time longest TOP
10SQL performs the TOP 10 for influencing result set maximum, and SQL performs the TOP 10 of number, SQL read-write ratios etc..
Periodicity in step 2 and step 3 refer to following in the time cycle each set carry out asynchronous collecting or
Asynchronous statistical correlation information.Step 2 might not be identical with the cycle that the periodicity in step 3 is followed.
Community MyCat-X can record various operation informations, these operation informations are in management port (9066) in operational process
Check that its output form is unfriendly by traditional show@@orders, check inconvenience.It is desirable that a kind of flexible, close friend can be provided
Check various operation informations, inspired by database, be well positioned to meet ours by the SQL statement inquiry mode of standard
It is required that therefore, H2DB low profile edge databases are introduced inside MyCAT-X.Allow information in its operational process, directly write
Enter or timing writes H2DB databases, so by 9066 port input inquiry orders (standard sql sentences), be forwarded to H2DB
In database query engine, H2DB databases return result to user.It is so convenient and practical.
The equipment for the database middleware that support system information close friend checks, including it is stored with the computer of computer program
Computer-readable recording medium, described program are run for performing the above method.
Above description is only the preferred embodiment of the application and the explanation to institute's application technology principle.People in the art
Member should be appreciated that invention scope involved in the application, however it is not limited to the technology that the particular combination of above-mentioned technical characteristic forms
Scheme, while should also cover in the case where not departing from the inventive concept, carried out by above-mentioned technical characteristic or its equivalent feature
The other technical solutions for being combined and being formed.Such as features described above has similar work(with (but not limited to) disclosed herein
The technical solution that the technical characteristic of energy is replaced mutually and formed.
Claims (5)
1. the method for the database middleware that support system information close friend checks, it is characterised in that including step：
S1, is inquired about by standard sql sentences.
2. the method for the database middleware according to claim 1 for supporting system information close friend to check, it is characterised in that
The standard sql sentences are inputted by management port.
3. the method for the database middleware according to claim 1 for supporting system information close friend to check, it is characterised in that
The step S1 includes step：
S11, by the asynchronous record of standard sql sentences into H2DB databases；
S12, the standard sql sentence implementation status described in periodically asynchronous statistic procedure S11.
4. the method for the database middleware according to claim 3 for supporting system information close friend to check, it is characterised in that
The step S1 further includes step：
S13, database middleware information described in periodicity asynchronous collecting.
5. the equipment of database middleware for supporting system information close friend to check, including be stored with the computer of computer program can
Read medium, it is characterised in that described program is run for performing：
S1, is inquired about by standard sql sentences.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201711106717.4A CN107943868B (en) | 2017-11-10 | 2017-11-10 | Method and equipment for supporting database middleware for friendly viewing of system information |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201711106717.4A CN107943868B (en) | 2017-11-10 | 2017-11-10 | Method and equipment for supporting database middleware for friendly viewing of system information |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN107943868A true CN107943868A (en) | 2018-04-20 |
| CN107943868B CN107943868B (en) | 2021-12-24 |
Family
ID=61934816
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201711106717.4A Active CN107943868B (en) | 2017-11-10 | 2017-11-10 | Method and equipment for supporting database middleware for friendly viewing of system information |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN107943868B (en) |
Citations (12)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101183377A (en) * | 2007-12-10 | 2008-05-21 | 华中科技大学 | High availability data-base cluster based on message middleware |
| CN101201842A (en) * | 2007-10-30 | 2008-06-18 | 北京航空航天大学 | Digital museum gridding and construction method thereof |
| US20130297868A1 (en) * | 2012-05-04 | 2013-11-07 | Battelle Memorial Institute | Method and system for managing power grid data |
| CN103793749A (en) * | 2014-02-27 | 2014-05-14 | 四川物联恒安安全技术研究有限公司 | Safety production comprehensive supervisory platform data transmission method |
| CN104063425A (en) * | 2014-06-04 | 2014-09-24 | 五八同城信息技术有限公司 | Method for querying data through database middleware and database middleware |
| US20150005652A1 (en) * | 2012-10-08 | 2015-01-01 | Perminova Inc. | Database and algorithm for evaluating efficacy of an electrophysiology procedure |
| CN104598531A (en) * | 2014-12-25 | 2015-05-06 | 广东电子工业研究院有限公司 | Incremental data migration method among heterogeneous relational databases based on trigger |
| US20160020917A1 (en) * | 2014-07-18 | 2016-01-21 | Oracle International Corporation | Communication gateway services in a networked message distribution system |
| CN106503087A (en) * | 2016-10-12 | 2017-03-15 | 郑州云海信息技术有限公司 | A kind of database middleware for Distributed Data Visits |
| CN106528293A (en) * | 2016-11-04 | 2017-03-22 | 武汉斗鱼网络科技有限公司 | Database access method and apparatus |
| CN106686031A (en) * | 2015-11-09 | 2017-05-17 | 广东华邦云计算股份有限公司 | Method and device for updating application to be in SaaS mode |
| US20170161327A1 (en) * | 2015-12-04 | 2017-06-08 | Dell Software, Inc. | Distributed database driver middleware |
-
2017
- 2017-11-10 CN CN201711106717.4A patent/CN107943868B/en active Active
Patent Citations (12)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101201842A (en) * | 2007-10-30 | 2008-06-18 | 北京航空航天大学 | Digital museum gridding and construction method thereof |
| CN101183377A (en) * | 2007-12-10 | 2008-05-21 | 华中科技大学 | High availability data-base cluster based on message middleware |
| US20130297868A1 (en) * | 2012-05-04 | 2013-11-07 | Battelle Memorial Institute | Method and system for managing power grid data |
| US20150005652A1 (en) * | 2012-10-08 | 2015-01-01 | Perminova Inc. | Database and algorithm for evaluating efficacy of an electrophysiology procedure |
| CN103793749A (en) * | 2014-02-27 | 2014-05-14 | 四川物联恒安安全技术研究有限公司 | Safety production comprehensive supervisory platform data transmission method |
| CN104063425A (en) * | 2014-06-04 | 2014-09-24 | 五八同城信息技术有限公司 | Method for querying data through database middleware and database middleware |
| US20160020917A1 (en) * | 2014-07-18 | 2016-01-21 | Oracle International Corporation | Communication gateway services in a networked message distribution system |
| CN104598531A (en) * | 2014-12-25 | 2015-05-06 | 广东电子工业研究院有限公司 | Incremental data migration method among heterogeneous relational databases based on trigger |
| CN106686031A (en) * | 2015-11-09 | 2017-05-17 | 广东华邦云计算股份有限公司 | Method and device for updating application to be in SaaS mode |
| US20170161327A1 (en) * | 2015-12-04 | 2017-06-08 | Dell Software, Inc. | Distributed database driver middleware |
| CN106503087A (en) * | 2016-10-12 | 2017-03-15 | 郑州云海信息技术有限公司 | A kind of database middleware for Distributed Data Visits |
| CN106528293A (en) * | 2016-11-04 | 2017-03-22 | 武汉斗鱼网络科技有限公司 | Database access method and apparatus |
Non-Patent Citations (2)
| Title |
|---|
| HAO XUE 等: "A document-relation associated query system based on distributed middleware", 《2016 5TH INTERNATIONAL CONFERENCE ON COMPUTER SCIENCE AND NETWORK TECHNOLOGY (ICCSNT)》 * |
| 叶炜: "分布式数据库中间件中的查询优化", 《中国优秀硕士学位论文全文数据库 信息科技辑》 * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN107943868B (en) | 2021-12-24 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN101719149B (en) | Data synchronization method and device | |
| WO2016004813A1 (en) | Data storage method, query method and device | |
| CN108536761A (en) | Report data querying method and server | |
| WO2020192064A1 (en) | Incremental data consistency implementation method and device | |
| CN104899295B (en) | A kind of heterogeneous data source data relation analysis method | |
| CN102629269B (en) | Searching and storing method for embedded database | |
| CN103345469B (en) | The storage of set of numbers, querying method and device thereof | |
| CN111767303A (en) | Data query method and device, server and readable storage medium | |
| CN102270225A (en) | Data change log monitoring method and device | |
| CN105095247B (en) | symbol data analysis method and system | |
| WO2019161645A1 (en) | Shell-based data table extraction method, terminal, device, and storage medium | |
| CN105808653A (en) | User label system-based data processing method and device | |
| CN101650742A (en) | System and method for prompting search condition during English search | |
| CN105630934A (en) | Data statistic method and system | |
| CN113032420A (en) | Data query method and device and server | |
| CN106294128B (en) | A kind of automated testing method and device exporting report data | |
| CN111367994A (en) | Method and system for synchronously backing up incremental data of database | |
| CN105279138B (en) | A kind of information research report automatic creation system | |
| CN111753015A (en) | Data query method and device of payment clearing system | |
| CN114064660B (en) | Data structured analysis method based on ElasticSearch | |
| CN106919697A (en) | A kind of method that data are imported multiple Hadoop components simultaneously | |
| TW569110B (en) | Dynamic database management system and method | |
| CN108182204A (en) | The processing method and processing device of data query based on house prosperity transaction multi-dimensional data | |
| CN110489490A (en) | Data storage and query method based on distributed data base | |
| US9576004B1 (en) | Free space management in databases |
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 |