CN106372162A - Extension method and device of database cluster application - Google Patents
Extension method and device of database cluster application Download PDFInfo
- Publication number
- CN106372162A CN106372162A CN201610777793.7A CN201610777793A CN106372162A CN 106372162 A CN106372162 A CN 106372162A CN 201610777793 A CN201610777793 A CN 201610777793A CN 106372162 A CN106372162 A CN 106372162A
- Authority
- CN
- China
- Prior art keywords
- sql sentence
- application
- instruction
- sentence
- default rule
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
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 invention provides an application invoking method and device of a database cluster. The method comprises the steps of determining an instruction of a to-be-invoked application; generating SQL sentences of the instruction according to preset rules; sending the SQL sentences to a node of the to-be-invoked application. Thus, the to-be-invoked application is determined by the node according to the SQL sentences, the operating procedure is simplified, and the user operation is facilitated.
Description
Technical field
The invention belongs to data-base cluster technical field, especially relate to a kind of extended method of data-base cluster application and
Device.
Background technology
Data-base cluster, as the term suggests it is simply that utilizing at least two or multiple stage database server, composition one is virtual
Centralized database logical image, as single database system, provides transparent data, services to client.Obtain wide at present
General application.
With data-base cluster use scale continuous expansion, the continuous extension of application scenarios, each to data-base cluster
Plant functional requirement to get more and more, user develops multiple applications, to realize more functions.A section in data-base cluster
On point, the third-party application on another node to be started, current mechanism is generally by network tools such as ssh, telnet even
It is connected to destination node, then manually boots related application, because being related to extra purview certification and the actual behaviour of different execution flow processs
It is very inconvenient that work gets up.
Content of the invention
Embodiments provide a kind of extended method of data-base cluster application and device, to realize automatically calling it
The purpose of his node third-party application.
In a first aspect, embodiments providing a kind of extended method of data-base cluster application, comprising:
Determine the instruction needing to call application；
Generate the sql sentence calling described instruction according to default rule；
Described sql sentence is sent the node calling application.
Further, described generation according to default rule calls the sql sentence of described instruction also to include:
Encapsulate described sql sentence.
Second aspect, the embodiment of the present invention additionally provides a kind of method of data-base cluster execution application, comprising:
Receive sql sentence；
Parse described sql sentence according to default rule, obtain call instruction；
Execute described call instruction.
Further, described according to default rule parse described sql sentence, comprising:
Encapsulation sql sentence is extracted from sql sentence；
Parse described sql sentence according to default rule.
The third aspect, the embodiment of the present invention additionally provides a kind of expanding unit of data-base cluster application, comprising:
Instruction-determining unit, for determining the instruction needing to call application；
Sentence signal generating unit, for generating the sql sentence of described instruction according to default rule；
Transmitting element, for sending the node calling application by described sql sentence.
Further, described sentence signal generating unit is used for:
Encapsulate described sql sentence.
Fourth aspect, the embodiment of the present invention additionally provides a kind of device of data-base cluster execution application, comprising:
Receiving unit, for receiving sql sentence；
Acquiring unit, for parsing described sql sentence according to default rule, obtains call instruction；
Performance element, for executing described call instruction.
Further, acquiring unit is used for:
Encapsulation sql sentence is extracted from sql sentence；
Parse described sql sentence according to default rule.
The embodiment of the present invention is passed through to determine the instruction needing to call application；Generate according to default rule and call described instruction
Sql sentence；Described sql sentence is sent the node calling application.So that node can determine and can call according to sql sentence
Application, simplify operation sequence, user-friendly.
Brief description
In order to be illustrated more clearly that the technical scheme of the embodiment of the present invention, below will be in embodiment or description of the prior art
The accompanying drawing of required use be briefly described it should be apparent that, drawings in the following description be only the present invention some are real
Apply example, for those of ordinary skill in the art, without having to pay creative labor, can also be attached according to these
Figure obtains other accompanying drawings.
Fig. 1 is the schematic flow sheet of the extended method of data-base cluster application that the embodiment of the present invention one provides；
Fig. 2 is the schematic flow sheet of the data-base cluster execution application that the embodiment of the present invention two provides；
Fig. 3 is the structural representation of the expanding unit of data-base cluster application that the embodiment of the present invention three provides；
Fig. 4 is the structural representation of the device of data-base cluster execution application that the embodiment of the present invention four provides.
Specific embodiment
In order to be better understood from the present invention, with reference to specific embodiments and the drawings, the present invention is further retouched
State.
Below in conjunction with the accompanying drawing in the embodiment of the present invention, the technical scheme in the embodiment of the present invention is carried out clear, complete
Site preparation description is it is clear that described embodiment a part of embodiment that is the present invention, rather than whole embodiments.Based on this
Embodiment in bright, the every other enforcement that those of ordinary skill in the art are obtained under the premise of not making creative work
Example, broadly falls into the scope of protection of the invention.
Embodiment one
Fig. 1 is the schematic flow sheet of the method that the data-base cluster that the embodiment of the present invention one provides calls application.This enforcement
Example is applicable to the situation of data-base cluster application call, and the method can be held by the device that data-base cluster calls application
OK, this device can be realized by software/hardware mode, and can be integrated in the client of data-base cluster.
The method calling application referring to Fig. 1, described data-base cluster, comprising:
S110, determines the instruction needing to call application.
Application can be the abbreviation of application program, be a kind of computer program, refer to be certain application mesh for user
The software write.Generally in user pattern, it can interact fortune with user, typically has visual user
Interface.When client needs node to execute corresponding function, determine the corresponding application of this function.For example: synchronous applications etc..
S120, generates the sql sentence of described instruction according to default rule.
Generate the sql sentence calling application instruction according to rule set in advance, sql can be divided into two parts: data
Operating language (dml) data definitional language (ddl).Sql (SQL) is performed for the grammer inquired about.But
Sql language also comprise for update, insert and deletion record grammer.Inquiry and more new command constitute the dml part of sql.
The DDL (ddl) of sql partly can create or Delete Table.Can also index of definition (key) it is stipulated that between table
Link, and apply the constraint between table.Node analysis instruction can be facilitated by sql sentence.
S130, described sql sentence is sent the node calling application.
Client sends the sql sentence of described for above-mentioned one-tenth instruction to node, and node parses described sentence, and it is right to obtain institute
The application answered, executes described application.The autgmentability of database server can be strengthened, call third party's instrument to avoid repeating out
Send out, reduce development cost, the function of extreme enrichment data base；More agile and all-purpose on using, convenient mixed with common sql,
It is integrated in a sql script；Collaborative interactive process between especially suitable Cluster Database node.
The embodiment of the present invention is passed through to determine the instruction needing to call application；Generate according to default rule and call described instruction
Sql sentence；Described sql sentence is sent the node calling application.So that node can determine and can call according to sql sentence
Application, simplify operation sequence, user-friendly.
Embodiment two
Fig. 2 is the schematic flow sheet of the method for data-base cluster execution application that the embodiment of the present invention two provides.This enforcement
Example is applicable to the situation that application is called in data-base cluster execution, and the method can be come by the device of data-base cluster execution application
Execution, this device can be realized by software/hardware mode, and can be integrated in the client of data-base cluster.
Referring to Fig. 2, the method for described data-base cluster execution application, comprising:
S210, receives sql sentence.
Node receives, by network, the sql sentence that client sends, and described sql sentence includes normal data transfer sql
Sentence, also includes calling the sql sentence of application instruction.
S220, parses described sql sentence according to default rule, obtains call instruction.
According to default rule, the sql sentence receiving is parsed, obtain to be encapsulated in and call finger in sql sentence
Order.
S230, executes described call instruction.
According to the result execution call instruction of parsing, that is, run the corresponding application of this instruction.
The embodiment of the present invention is passed through to receive sql sentence；Parse described sql sentence according to default rule, obtain and call finger
Order；Execute described call instruction.Simplify operation sequence, user-friendly.
Embodiment three
Fig. 3 is the structural representation of the device that the data-base cluster that the embodiment of the present invention three provides calls application, as Fig. 3 institute
Show, described device includes:
Instruction-determining unit 310, for determining the instruction needing to call application；
Sentence signal generating unit 320, for generating the sql sentence of described instruction according to default rule；
Transmitting element 330, for sending the node calling application by described sql sentence.
The embodiment of the present invention is passed through to determine the instruction needing to call application；Generate according to default rule and call described instruction
Sql sentence；Described sql sentence is sent the node calling application.So that node can determine and can call according to sql sentence
Application, simplify operation sequence, user-friendly.
Further, described sentence signal generating unit is used for:
Encapsulate described sql sentence.
Example IV
Fig. 4 is the structural representation of the device of data-base cluster execution application that the embodiment of the present invention four provides, as Fig. 4 institute
Show, described device includes:
Receiving unit 410, for receiving sql sentence；
Acquiring unit 420, for parsing described sql sentence according to default rule, obtains call instruction；
Performance element 430, for executing described call instruction.
The embodiment of the present invention is passed through to receive sql sentence；Parse described sql sentence according to default rule, obtain and call finger
Order；Execute described call instruction.Simplify operation sequence, user-friendly.
Further, described acquiring unit is used for:
Encapsulation sql sentence is extracted from sql sentence；
Parse described sql sentence according to default rule.
One of ordinary skill in the art will appreciate that: all or part of step realizing above-mentioned each method embodiment can be led to
Cross the related hardware of programmed instruction to complete.Aforesaid program can be stored in a computer read/write memory medium.This journey
Sequence upon execution, executes the step including above-mentioned each method embodiment；And aforesaid storage medium includes: rom, ram, magnetic disc or
Person's CD etc. is various can be with the medium of store program codes.
Finally it is noted that various embodiments above, only in order to technical scheme to be described, is not intended to limit；To the greatest extent
Pipe has been described in detail to the present invention with reference to foregoing embodiments, it will be understood by those within the art that: its according to
So the technical scheme described in foregoing embodiments can be modified, or wherein some or all of technical characteristic is entered
Row equivalent；And these modifications or replacement, do not make the essence of appropriate technical solution depart from various embodiments of the present invention technology
The scope of scheme.
Claims (8)
1. a kind of data-base cluster calls the method for application it is characterised in that including:
Determine the instruction needing to call application；
Generate the sql sentence of described instruction according to default rule；
Described sql sentence is sent the node calling application.
2. method according to claim 1 is it is characterised in that described generation according to default rule calls described instruction
Sql sentence also includes:
Encapsulate described sql sentence.
3. a kind of method of data-base cluster execution application is it is characterised in that include:
Receive sql sentence；
Parse described sql sentence according to default rule, obtain call instruction；
Execute described call instruction.
4. method according to claim 3 is it is characterised in that described parse described sql sentence, bag according to default rule
Include:
Encapsulation sql sentence is extracted from sql sentence；
Parse described sql sentence according to default rule.
5. a kind of data-base cluster calls the device of application it is characterised in that including:
Instruction-determining unit, for determining the instruction needing to call application；
Sentence signal generating unit, for generating the sql sentence of described instruction according to default rule；
Transmitting element, for sending the node calling application by described sql sentence.
6. device according to claim 5 is it is characterised in that described sentence signal generating unit is used for:
In the described sql sentence of encapsulation.
7. a kind of device of data-base cluster execution application is it is characterised in that include:
Receiving unit, for receiving sql sentence；
Acquiring unit, for parsing described sql sentence according to default rule, obtains call instruction；
Performance element, for executing described call instruction.
8. device according to claim 7 is it is characterised in that acquiring unit is used for:
Encapsulation sql sentence is extracted from sql sentence；
Parse described sql sentence according to default rule.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201610777793.7A CN106372162A (en) | 2016-08-31 | 2016-08-31 | Extension method and device of database cluster application |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201610777793.7A CN106372162A (en) | 2016-08-31 | 2016-08-31 | Extension method and device of database cluster application |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN106372162A true CN106372162A (en) | 2017-02-01 |
Family
ID=57902550
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201610777793.7A Pending CN106372162A (en) | 2016-08-31 | 2016-08-31 | Extension method and device of database cluster application |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN106372162A (en) |
Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101034349A (en) * | 2007-04-06 | 2007-09-12 | 西安万年科技实业有限公司 | Data base application system development platform based on functional design |
| CN101047704A (en) * | 2006-04-05 | 2007-10-03 | 华为技术有限公司 | Data base access system, device and method based on session initiate protocol network |
| CN101908046A (en) * | 2009-06-05 | 2010-12-08 | 北大方正集团有限公司 | Service processing method and system |
| CN102467510A (en) * | 2010-11-05 | 2012-05-23 | 中兴通讯股份有限公司 | Data acquisition method and system and communication equipment |
| CN103164270A (en) * | 2011-12-12 | 2013-06-19 | 阿里巴巴集团控股有限公司 | Java system application programming interface calling method and system using the same |
| CN103365987A (en) * | 2013-07-05 | 2013-10-23 | 北京人大金仓信息技术股份有限公司 | Clustered database system and data processing method based on shared-disk framework |
| US20140096127A1 (en) * | 2012-09-28 | 2014-04-03 | Wal-Mart Stores, Inc. | Systems and methods for installing, managing, and provisioning applications |
-
2016
- 2016-08-31 CN CN201610777793.7A patent/CN106372162A/en active Pending
Patent Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101047704A (en) * | 2006-04-05 | 2007-10-03 | 华为技术有限公司 | Data base access system, device and method based on session initiate protocol network |
| CN101034349A (en) * | 2007-04-06 | 2007-09-12 | 西安万年科技实业有限公司 | Data base application system development platform based on functional design |
| CN101908046A (en) * | 2009-06-05 | 2010-12-08 | 北大方正集团有限公司 | Service processing method and system |
| CN102467510A (en) * | 2010-11-05 | 2012-05-23 | 中兴通讯股份有限公司 | Data acquisition method and system and communication equipment |
| CN103164270A (en) * | 2011-12-12 | 2013-06-19 | 阿里巴巴集团控股有限公司 | Java system application programming interface calling method and system using the same |
| US20140096127A1 (en) * | 2012-09-28 | 2014-04-03 | Wal-Mart Stores, Inc. | Systems and methods for installing, managing, and provisioning applications |
| CN103365987A (en) * | 2013-07-05 | 2013-10-23 | 北京人大金仓信息技术股份有限公司 | Clustered database system and data processing method based on shared-disk framework |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN108279932B (en) | Method and device for dynamically configuring user interface of mobile terminal | |
| CN106528129B (en) | A kind of Web application interface generation system and method | |
| CN114035773B (en) | Configuration-based low-code form development method, system and device | |
| US7210096B2 (en) | Methods and apparatus for constructing semantic models for document authoring | |
| CN101546260B (en) | Method and device thereof for reconstructing service-oriented applications | |
| US20040243613A1 (en) | System and method for creating a custom view from information in a managed data store | |
| CN106293664A (en) | Code generating method and device | |
| CN108762743A (en) | Data table operation code generation method and device | |
| CN109636301A (en) | Workflow configuration method, system, terminal and the readable storage medium storing program for executing of financial business | |
| CN109753492A (en) | A kind of system constituting method and device based on metadata configurations | |
| CN113821565B (en) | Method for synchronizing data by multiple data sources | |
| CN109271561A (en) | A kind of profile information search method and device | |
| US20060047723A1 (en) | Custom database system and method of building the same | |
| US20080256515A1 (en) | Systems & Methods For Creating Software | |
| CN109947435A (en) | The dispositions method and system of server cluster software environment | |
| CN114254606A (en) | Microservice framework model | |
| CN113157904B (en) | Sensitive word filtering method and system based on DFA algorithm | |
| CN111104181A (en) | Webpage data filling system for visually editing task flow | |
| CN109165039B (en) | A kind of configuration and execution method, system and medium of web API | |
| Baldassari et al. | PROTOB a hierarchical object-oriented CASE tool for distributed systems | |
| CN111740851B (en) | Configuration message generation method, device and system | |
| CN106559493B (en) | Service issuing method and service delivery system | |
| CN106372162A (en) | Extension method and device of database cluster application | |
| CN115168365A (en) | Data storage method and device, electronic equipment and storage medium | |
| WO2017084515A1 (en) | Method and device for transmitting data code stream |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| RJ01 | Rejection of invention patent application after publication | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20170201 |