CN104090937A - Database access method and database access system based on cloud calculation - Google Patents
Database access method and database access system based on cloud calculation Download PDFInfo
- Publication number
- CN104090937A CN104090937A CN201410300008.XA CN201410300008A CN104090937A CN 104090937 A CN104090937 A CN 104090937A CN 201410300008 A CN201410300008 A CN 201410300008A CN 104090937 A CN104090937 A CN 104090937A
- Authority
- CN
- China
- Prior art keywords
- database
- cloud
- user
- cloud user
- access request
- 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/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/24—Querying
- G06F16/245—Query processing
Abstract
The invention discloses a database access method and a database access system based on cloud calculation. The database access method based on cloud calculation comprises the following steps of: receiving the database access request sent by a cloud user; matching database metadata carried in the database access request with the metadata of each database in a cloud system, and determining the database to be accessed according to the database access request; analyzing the database access request to obtain an SQL statement; executing the SQL statement on the current database connection of the user to obtain an execution result; converting the execution result to the data format used by the cloud user and then feeding back to the cloud user.
Description
Technical field
The present invention relates to cdr database access technique field, be specifically related to a kind of data bank access method and system based on cloud computing.
Background technology
Cloud computing is a kind of emerging business computation model, and this model is distributed in calculation task on the resource pool of a large amount of computing machines formations, makes various application systems can obtain as required computing power, storage space and various software service.At present, in network environment data access and integration mostly adopt visitor directly and DBS (Database System, Database Systems) service interface mutual.This interactive mode can force user of service in the inner data access and integration problem that solves of application system, supvr or management organization are absorbed among the technical matterss such as database connection, Data Format Transform, have increased complicacy and the repeatability of management automation program development.
Summary of the invention
In view of the above problems, the present invention has been proposed to a kind of overcome the problems referred to above or the data bank access method based on cloud computing addressing the above problem at least in part and the corresponding data base access system based on cloud computing are provided.
According to one aspect of the present invention, a kind of data bank access method based on cloud computing is provided, comprising:
Receive the database access request that cloud user sends;
The database metadata carrying in described database access request is mated with the metadata of each database in cloud system, determine the database that described data access request will be accessed;
Resolve described database access request, obtain SQL statement;
Connect and carry out SQL statement at described cloud user's current database, obtain execution result;
After being converted to the data layout that described cloud user adopts, described execution result feeds back to this cloud user.
According to another aspect of the present invention, a kind of data base access system based on cloud computing is provided, comprising:
Request reception unit, the database access request sending for receiving cloud user;
Database determining unit, mates with the metadata of each database in cloud system for the database metadata that described database access request is carried, and determines the database that described data access request will be accessed;
Resolution unit, for resolving described database access request, obtains SQL statement;
Performance element, connects and carries out SQL statement for the current database described cloud user, obtains execution result;
Execution result feedback unit feeds back to this cloud user after described execution result being converted to the data layout that described cloud user adopts.
A kind of data bank access method and system based on cloud computing provided by the invention, the database access request that cloud system sends by receiving user, and the database metadata carrying in database access request is mated with the metadata of the each database in cloud system, the database that specified data request of access will be accessed, resolution data request of access, obtain SQL (the Structured Query Language that will carry out, Structured Query Language (SQL)) statement, then connect and carry out SQL statement at the current database of cloud user, and the execution result that execution is obtained feeds back to this cloud user.Method provided by the invention, realize the access to database by cloud system, avoided various application and in environment, distribute, the database of isomery is directly connected, realize the platform-neutral of message reference and integrated model, strengthen portability, the robustness of management automation system, thereby there is boundless application prospect.
Brief description of the drawings
Fig. 1 is a kind of data bank access method process flow diagram based on cloud computing of the embodiment of the present invention;
Fig. 2 is a kind of data base access system schematic diagram based on cloud computing of the embodiment of the present invention.
Embodiment
Below in conjunction with accompanying drawing, principle of the present invention and feature are described, example, only for explaining the present invention, is not intended to limit scope of the present invention.
Embodiment mono-, a kind of data bank access method based on cloud computing.Below in conjunction with Fig. 1, method provided by the invention is elaborated.
In Fig. 1, the database access request that S101, reception cloud user send.
S102, the database metadata carrying in database access request is mated to the database that specified data request of access will be accessed with the metadata of each database in cloud system.
Concrete, in the time that cloud user wishes to conduct interviews to the database in cloud system, cloud user sends database access request to cloud system, wherein, in database access request, carries database metadata.In the time that cloud system receives the database access request of cloud user transmission, cloud system mates the database metadata carrying in database access request with the database metadata of storing in cloud system, the database that specified data storehouse request of access will be accessed.
S103, resolution data storehouse request of access, obtain SQL statement.
Concrete, determine after the database that database access request will access at above-mentioned steps cloud system, cloud user's access rights have been verified, if be verified, the database access request receiving is resolved, obtain the SQL statement of the desired execution of database access request; If checking is not passed through, cloud system sends unexpected message to cloud user, and the user rs authentication of notice cloud is not passed through.
When specific implementation, in the database access request that cloud user sends, carry cloud user's user name and password, in the authorization information by this username and password in established data storehouse, mate, if coupling is verified; Otherwise checking is not passed through.
Pass through when user's access authority verification, database request of access is resolved, obtain SQL statement.
S104, on user's current database connects, carry out SQL statement, obtain execution result.
Concrete, database access request cloud user being sent by above-mentioned steps S103 is resolved, obtain SQL statement, wherein, SQL statement comprises DQL (Data Query Language, data query language) and DML (Data Manipulation Language, data manipulation language (DML)).When SQL statement is DQL statement, cloud user wishes the data in database to inquire about; When SQL statement is DML statement, cloud user wishes the data in database to operate, such as insert (INSERT) data, change (UPDATE) data or deletion (DELETE) data in database.
Then cloud system judge cloud user current whether have database connect, if cloud user current have database connect, cloud user current database connect on carry out SQL statement, obtain execution result; If cloud user is current not to be had database and connects, from database connection pool, take out a connection and connect as the current database of this cloud user, connect and carry out SQL statement at the database of this removal, obtain execution result.
In the time that SQL statement is DQL statement, the execution result returning is data result; In the time that SQL statement is DML statement, the execution result returning is successful information or failure information.
S105, by execution result be converted to cloud user adopt data layout after feed back to this cloud user.
Concrete, step S104 has obtained the performed result of database access request, because the data layout of the data layout with adopting in every family and cloud system employing is inconsistent, the data layout that this execution result is converted into cloud user employing by cloud system feeds back to this cloud user, so far the process that, cloud user accesses the database in cloud system completes.
Embodiment bis-, a kind of data base access system based on cloud computing.Below in conjunction with Fig. 2, system provided by the invention is described in detail.
In Fig. 2, system provided by the invention comprises request reception unit 201, database determining unit 202, resolution unit 203, performance element 204 and execution result feedback unit 205.
Wherein, request reception unit 201 is mainly used in receiving the data access request that cloud user sends.
Database determining unit 202 is mainly used in the database metadata carrying in database access request to mate with the metadata of each database in cloud system, the database that specified data storehouse request of access will be accessed.
Concrete, in the time that cloud user wishes to conduct interviews to the database in cloud system, cloud user sends database access request to cloud system, wherein, in database access request, carries database metadata.In the time that the request reception unit 201 in cloud system receives the database access request of cloud user transmission, the database determining unit 202 being arranged in cloud system is mated the database metadata carrying in database access request with the database metadata of storing in cloud system, the database that specified data storehouse request of access will be accessed.
Resolution unit 203 is mainly used in resolution data storehouse request of access, obtains SQL statement.
Concrete, determine after the database that database access request will access in database determining unit 202, user authentication unit is verified cloud user's access rights, if be verified, resolution unit 203 is resolved the database access request receiving, and obtains the SQL statement of the desired execution of database access request; If checking is not passed through, cloud system sends unexpected message to cloud user, and the user rs authentication of notice cloud is not passed through.
When specific implementation, in the database access request that cloud user sends, carry cloud user's user name and password, in the authorization information by this username and password in established data storehouse, mate, if coupling is verified; Otherwise checking is not passed through.
Pass through when user's access authority verification, database request of access is resolved, obtain SQL statement.
Performance element 204 is mainly used in connecting and carrying out SQL statement at user's current database, obtains execution result.
Concrete, database access request cloud user being sent by resolution unit 203 is resolved, obtain SQL statement, wherein, SQL statement comprises DQL (Data Query Language, data query language) and DML (Data Manipulation Language, data manipulation language (DML)).When SQL statement is DQL statement, cloud user wishes the data in database to inquire about; When SQL statement is DML statement, cloud user wishes the data in database to operate, such as insert (INSERT) data, change (UPDATE) data or deletion (DELETE) data in database.
Then be arranged at whether database connection judgment unit judges cloud user in cloud system is current has database and connect, there is database and connect if cloud user is current, on cloud user current database connects, carry out SQL statement, obtain execution result; If cloud user is current not to be had database and connects, from database connection pool, take out a connection and connect as the current database of this cloud user, connect and carry out SQL statement at the database of this removal, obtain execution result.
In the time that SQL statement is DQL statement, the execution result returning is data result; In the time that SQL statement is DML statement, the execution result returning is successful information or failure information.
Execution result feedback unit 205 be mainly used in by execution result be converted to cloud user adopt data layout after feed back to this cloud user.
Concrete, performance element 204 has obtained the performed result of database access request, because the data layout of the data layout with adopting in every family and cloud system employing is inconsistent, the data layout that this execution result is converted into cloud user employing by execution result feedback unit 205 in cloud system feeds back to this cloud user, so far the process that, cloud user accesses the database in cloud system completes.
A kind of data bank access method and system based on cloud computing provided by the invention, the database access request that cloud system sends by receiving user, and the database metadata carrying in database access request is mated with the metadata of the each database in cloud system, the database that specified data request of access will be accessed, resolution data request of access, obtain SQL (the Structured Query Language that will carry out, Structured Query Language (SQL)) statement, then connect and carry out SQL statement at the current database of cloud user, and the execution result that execution is obtained feeds back to this cloud user.Method provided by the invention, realize the access to database by cloud system, avoided various application and in environment, distribute, the database of isomery is directly connected, realize the platform-neutral of message reference and integrated model, strengthen portability, the robustness of management automation system, thereby there is boundless application prospect.
The foregoing is only preferred embodiment of the present invention, in order to limit the present invention, within the spirit and principles in the present invention not all, any amendment of doing, be equal to replacement, improvement etc., within all should being included in protection scope of the present invention.
Claims (9)
1. the data bank access method based on cloud computing, is characterized in that, comprising:
The database access request that step S101, reception cloud user send;
Step S102, the database metadata carrying in described database access request is mated with the metadata of each database in cloud system, determine the database that described data access request will be accessed;
Step S103, resolve described database access request, obtain SQL statement;
Step S104, on described cloud user's current database connects, carry out SQL statement, obtain execution result;
Step S105, after being converted to the data layout that described cloud user adopts, described execution result feeds back to this cloud user.
2. data bank access method as claimed in claim 1, is characterized in that, before described execution step S103, also comprises:
Described cloud user is verified, if be verified, described database access request is resolved, obtain SQL statement; If checking is not passed through, send unexpected message to described cloud user.
3. data bank access method as claimed in claim 2, is characterized in that, described cloud user is verified and comprised:
According to the cloud user's who carries in described database access request username and password, in the user authentication information in determined database, mate, if coupling is verified; Otherwise checking is not passed through.
4. data bank access method as claimed in claim 1, is characterized in that, after execution step S103, also comprises:
Judge described cloud user current whether have database connect;
Described cloud user is current do not have database and connect in the situation that, from database connection pool, take out a connection and connect as the current database of this cloud user.
5. data bank access method as claimed in claim 1 or 2, is characterized in that, described SQL statement comprises data query language and data manipulation language (DML).
6. the data base access system based on cloud computing, is characterized in that, comprising:
Request reception unit, the database access request sending for receiving cloud user;
Database determining unit, mates with the metadata of each database in cloud system for the database metadata that described database access request is carried, and determines the database that described data access request will be accessed;
Resolution unit, for resolving described database access request, obtains SQL statement;
Performance element, connects and carries out SQL statement for the current database described user, obtains execution result;
Execution result feedback unit feeds back to this cloud user after described execution result being converted to the data layout that described cloud user adopts.
7. data base access system as claimed in claim 6, is characterized in that, described resolution unit, for resolving described database access request, obtains also comprising before SQL statement:
User authentication unit, for verifying described cloud user;
If be verified, described database access request is resolved, obtain SQL statement; If checking is not passed through, send unexpected message to described cloud user.
8. data base access system as claimed in claim 7, is characterized in that, user authentication unit is used for for described cloud user is verified specifically and comprised:
According to the cloud user's who carries in described database access request username and password, in the user authentication information in determined database, mate, if coupling is verified; Otherwise checking is not passed through.
9. data base access system as claimed in claim 6, is characterized in that, described performance element connects and carries out SQL statement for the current database described user, obtains also comprising before execution result:
Database connection judgment unit, for judge described cloud user current whether have database connect;
Described cloud user is current do not have database and connect in the situation that, from database connection pool, take out a connection and connect as the current database of this cloud user.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201410300008.XA CN104090937A (en) | 2014-06-27 | 2014-06-27 | Database access method and database access system based on cloud calculation |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201410300008.XA CN104090937A (en) | 2014-06-27 | 2014-06-27 | Database access method and database access system based on cloud calculation |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN104090937A true CN104090937A (en) | 2014-10-08 |
Family
ID=51638653
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201410300008.XA Pending CN104090937A (en) | 2014-06-27 | 2014-06-27 | Database access method and database access system based on cloud calculation |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN104090937A (en) |
Cited By (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106599121A (en) * | 2016-11-30 | 2017-04-26 | 海尔优家智能科技（北京）有限公司 | Data processing method and system for Internet of things |
| CN107766490A (en) * | 2017-10-17 | 2018-03-06 | 链家网（北京）科技有限公司 | Automatic operation method, system, equipment and the storage medium of SQL files |
| CN110580258A (en) * | 2019-09-20 | 2019-12-17 | 中国银行股份有限公司 | big data free query method and device |
| CN111209289A (en) * | 2019-12-25 | 2020-05-29 | 中科驭数（北京）科技有限公司 | Database access method and device |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102508898A (en) * | 2011-11-04 | 2012-06-20 | 浪潮(北京)电子信息产业有限公司 | Data access method and database system based on cloud computing |
| CN102724221A (en) * | 2011-03-30 | 2012-10-10 | 上海微河信息科技有限公司 | Enterprise information system using cloud computing and method for setting user authority thereof |
| CN103150304A (en) * | 2011-12-06 | 2013-06-12 | 郑红云 | Cloud database system |
| CN103365971A (en) * | 2013-06-27 | 2013-10-23 | 北京中科金财科技股份有限公司 | Mass data access processing system based on cloud computing |
| US20140059001A1 (en) * | 2012-08-23 | 2014-02-27 | Lsis Co., Ltd. | Cloud computing-based data sharing system and method |
-
2014
- 2014-06-27 CN CN201410300008.XA patent/CN104090937A/en active Pending
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102724221A (en) * | 2011-03-30 | 2012-10-10 | 上海微河信息科技有限公司 | Enterprise information system using cloud computing and method for setting user authority thereof |
| CN102508898A (en) * | 2011-11-04 | 2012-06-20 | 浪潮(北京)电子信息产业有限公司 | Data access method and database system based on cloud computing |
| CN103150304A (en) * | 2011-12-06 | 2013-06-12 | 郑红云 | Cloud database system |
| US20140059001A1 (en) * | 2012-08-23 | 2014-02-27 | Lsis Co., Ltd. | Cloud computing-based data sharing system and method |
| CN103365971A (en) * | 2013-06-27 | 2013-10-23 | 北京中科金财科技股份有限公司 | Mass data access processing system based on cloud computing |
Cited By (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106599121A (en) * | 2016-11-30 | 2017-04-26 | 海尔优家智能科技（北京）有限公司 | Data processing method and system for Internet of things |
| CN106599121B (en) * | 2016-11-30 | 2020-11-10 | 海尔优家智能科技（北京）有限公司 | Data processing method and system for Internet of things |
| CN107766490A (en) * | 2017-10-17 | 2018-03-06 | 链家网（北京）科技有限公司 | Automatic operation method, system, equipment and the storage medium of SQL files |
| CN110580258A (en) * | 2019-09-20 | 2019-12-17 | 中国银行股份有限公司 | big data free query method and device |
| CN110580258B (en) * | 2019-09-20 | 2022-05-17 | 中国银行股份有限公司 | Big data free query method and device |
| CN111209289A (en) * | 2019-12-25 | 2020-05-29 | 中科驭数（北京）科技有限公司 | Database access method and device |
| CN111209289B (en) * | 2019-12-25 | 2021-01-15 | 中科驭数（北京）科技有限公司 | Database access method and device |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN106776780B (en) | Data exchange and sharing method and system in cloud environment | |
| CN103957248B (en) | A kind of public real time data releasing cloud service platform based on Internet of Things | |
| CN103038788B (en) | Providing multiple network resources | |
| CN102508898A (en) | Data access method and database system based on cloud computing | |
| CN101621518A (en) | Method for managing permission | |
| US20050278384A1 (en) | External authentication against a third-party directory | |
| CN102624728B (en) | Method and system for carrying out whole-network login authentication by utilizing registered website user information | |
| CN103946841A (en) | Systems and methods for dynamic service integration | |
| WO2014074957A1 (en) | Systems and methods involving resource description framework distributed data base managenent systems and/or related aspects | |
| CN103685463A (en) | Access control method and system in cloud computing system | |
| CN104363211A (en) | Method and system for managing authority | |
| CN103685568A (en) | Platform service application deployment method and system of PAAS (Platform As A Service) platform under cloud computing environment | |
| CN104090937A (en) | Database access method and database access system based on cloud calculation | |
| US20130117290A1 (en) | Platform for software as a service and method for provisioning service for supporting multi-tenants using the platform | |
| CN103916395A (en) | Method, device and system for service calling | |
| KR20140054950A (en) | System and method of data federation module for sociality storage service on cloud computing | |
| CN102800015A (en) | Financial IC (Integrated Circuit) card long-distance individualized method and system | |
| CN101741558A (en) | Method for realizing uniform identity authentication | |
| CN101706925A (en) | On-line life information service platform system | |
| CN105426469A (en) | Database cluster metadata management method and system | |
| CN102917006A (en) | Method and device for achieving uniform control management of computing resource and object authority | |
| CN109961630A (en) | A kind of intelligent bus information acquisition system | |
| CN109088858B (en) | Medical system and method based on authority management | |
| CN104104702A (en) | Cloud computation architecture facing household internet of things | |
| CN101989923A (en) | Method and system for registering computer integrated manufacturing (CIM) agency to management agency and management system |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into 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: 20141008 |