CN103838781A - Database access method and system - Google Patents

Database access method and system Download PDF

Info

Publication number
CN103838781A
CN103838781A CN201210490746.6A CN201210490746A CN103838781A CN 103838781 A CN103838781 A CN 103838781A CN 201210490746 A CN201210490746 A CN 201210490746A CN 103838781 A CN103838781 A CN 103838781A
Authority
CN
China
Prior art keywords
data base
remote
data
access
remote data
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
Application number
CN201210490746.6A
Other languages
Chinese (zh)
Inventor
白玉宾
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
ZTE Corp
Original Assignee
ZTE Corp
Priority date (The priority date 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 date listed.)
Filing date
Publication date
Application filed by ZTE Corp filed Critical ZTE Corp
Priority to CN201210490746.6A priority Critical patent/CN103838781A/en
Publication of CN103838781A publication Critical patent/CN103838781A/en
Pending legal-status Critical Current

Links

Images

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/24Querying
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/27Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor

Landscapes

  • Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • Databases & Information Systems (AREA)
  • Data Mining & Analysis (AREA)
  • Physics & Mathematics (AREA)
  • General Engineering & Computer Science (AREA)
  • General Physics & Mathematics (AREA)
  • Computing Systems (AREA)
  • Computational Linguistics (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)

Abstract

The invention discloses a database access method and system. An information transceiving module of a local database receives a remote data access request and transmits the received remote data access request to a processing module of the local database. The processing module transmits the received remote data access request to a corresponding remote database through an SQL mode and receives an execution result of the remote database on the remote data access request. By embedding the processing module in the local database, the remote data access request is pushed to the corresponding remote database through the SQL mode, no independent course support is needed, resource cost can be reduced, and increase of the resource utilization rate is facilitated. Furthermore, system deployment, operation and maintenance cost can be reduced to a large extent, and complexity in achieving database access is reduced. Accurate flow control is facilitated, therefore, tasks can be allocated to the local database and the remote database reasonably, and flexibility and controllability of the system can be improved.

Description

Data bank access method and system
Technical field
The present invention relates to the communications field, be specifically related to a kind of data bank access method and system.
Background technology
Since Dr.E.F.Codd in 1970 proposes the relational model theory of Database Systems, relevant database has obtained sufficient development, and becomes gradually the main model of database schema.Relevant database has following characteristics and advantage, easily understands (bivariate table structure), and (general sql like language) easy to use, is easy to safeguard (abundant integrity constraint).At present, relational database is widely used in industry-by-industry, as ERP, and MIS, EAM etc., become structure management information system, store and basic software that the data of dealing with relationship are indispensable.Along with popularizing of Internet technology, after particularly WEB2.0 rises, traditional relational database is being dealt with WEB2.0, particularly ultra-large and high concurrent application type, as community network (SNS), blog (BLOG), encyclopedia etc., seem unable to do what one wishes, exposed and be much difficult to the problem that overcomes, as the demand to high concurrent reading and writing, high-level efficiency storage to mass data and the demand of access, the demand to enhanced scalability and high availability.Traditional relational database is due to the restriction on data model, in performance, in expansion retractility, and relational database has run into the obstacle that is difficult to overcome.And for many as the application scenarios of WEB2.0, a lot of key properties of relational database are but often lack scope for their abilities, as strict consistent affairs, write-read real-time, complicated SQL query.Therefore, for the non-relational database that solves this class problem arises at the historic moment, as analyzed for OLAP(on line data) distributed data base, parallel database, for the NOSQL of WEB etc., Database Development more and more presents diversified situation.
Due to history, technology, cost reason, in a system, may there is multitype database, as distributed data base and traditional relational database; And this multitype database the commingled system of depositing, also will continue the quite a long time; And adopt existing data bank access method to carry out between disparate databases system that the process of data access is loaded down with trivial details, cost is higher, and poor controllability.
Summary of the invention
The main technical problem to be solved in the present invention is, a kind of data bank access method and system are provided, and solves existing database access method and between disparate databases system, carries out that the process of data access is loaded down with trivial details, cost is high, the problem of poor controllability.
For solving the problems of the technologies described above, the invention provides a kind of data bank access method, comprising:
Local data base receiving remote data access request;
Described local data base sends to corresponding remote data base by the remote data access request receiving by SQL form;
Described local data base receives the execution result of described remote data base to described remote data access request, and described execution result is processed.
In an embodiment of the present invention, before described local data base receiving remote data access request, also comprise the step that creates and store teledata source information.
In an embodiment of the present invention, described teledata source packet is drawn together remote database server information, or described teledata source packet is drawn together remote database server information and remote database server calling party information; Described remote database server information comprises reference address, the data access mode of remote data base.
In an embodiment of the present invention, described local data base sends to corresponding remote data base to comprise by SQL form the remote data access request receiving:
Described local data base obtains the data access mode that described remote database access request comprises;
Described local data base selects corresponding remote data base to be connected according to described teledata source information with described data access mode;
Described local data base sends to described remote data access request the remote data base being attached thereto by SQL form.
In an embodiment of the present invention, described remote data access request is the remote data access request that user sends to described local data base with SQL form by client.
In an embodiment of the present invention, described local data base is distributed data base.
In order to solve the problems of the technologies described above, the present invention also provides a kind of data base access system, comprises local data base, and described local data base comprises data access subsystem, and described data access subsystem comprises signal dispatcher module, Data access module,
Signal dispatcher module, for receiving remote data access request, and sends to processing module by the data access request receiving;
Processing module, for sending to corresponding remote data base by the remote data access request receiving by SQL form; And for receiving the execution result of described remote data base to described remote data access request, and described execution result is processed.
In an embodiment of the present invention, described access sub-system also comprises remote data source information creating module, and described remote data source information creating module is for creating and store teledata source information.
In an embodiment of the present invention, described teledata source packet is drawn together remote database server information, or described teledata source packet is drawn together remote database server information and remote database server calling party information; Described remote database server information comprises reference address, the data access mode of remote data base.
In an embodiment of the present invention, described processing module comprises data access submodule and remote data access driven element module;
Described data access submodule, for obtaining the data access mode that described remote database access request comprises, is selected corresponding remote data access driven element module;
Described remote data access driven element module is used for selecting corresponding remote data base to be connected according to described teledata source information with described data access mode, and for described remote data access request is sent to this remote data base by SQL form.
In an embodiment of the present invention, described remote data access driven element module is one group of set of standard interfaces.
In an embodiment of the present invention, described data base access system comprises the client being connected with described local data base, and described client is for sending remote data access request with SQL form to described local data base.
In an embodiment of the present invention, described local data base is distributed data base.
The invention has the beneficial effects as follows:
Data bank access method provided by the invention and system, in multitype database the commingled system of depositing, by the signal dispatcher module receiving remote data access request of local data base, and the data access request receiving is sent to the processing module of local data base; Processing module sends to corresponding remote data base by the remote data access request receiving by SQL form, and receives the execution result of this remote data base to remote data access request.Because processing module is embedded in local data base, therefore do not need independently process support, can reduce the expense of resource, be more conducive to improve resource utilization; In addition, the present invention is pushed to corresponding remote data base by SQL form by remote data access request, only need to provide simple, unified SQL access interface, has reduced to a great extent the cost of system deployment, operation and maintenance; Reduce the complexity of accessing data base; Simultaneously, owing to adopting SQL form to push remote data access request, can adopt various constraint condition (for example WHERE condition, JION ON) accurately to control flow, be more conducive to rational allocating task to local data base and remote data base, improve dirigibility and the reliability of system.
Accompanying drawing explanation
Fig. 1 is the data base access system structural representation of an embodiment of the present invention;
Fig. 2 is the data access subsystem structure schematic diagram of an embodiment of the present invention;
Fig. 3 is the schematic flow sheet of the remote data source information creating of an embodiment of the present invention;
Fig. 4 is the structural representation of processing module shown in Fig. 2;
Fig. 5 is the data bank access method schematic flow sheet one of an embodiment of the present invention;
Fig. 6 is the data bank access method schematic flow sheet two of an embodiment of the present invention;
Fig. 7 is the schematic flow sheet of the remote data access driven element module accesses remote data base of an embodiment of the present invention.
Embodiment
By reference to the accompanying drawings the present invention is described in further detail below by embodiment.
Data base access system shown in Figure 1, this data base access system is multitype database the commingled system of depositing, for example, can be the commingled system that comprises distributed data base and traditional relational database.In the present embodiment, the promoter of data access request is referred to as local data base, other database with respect to this promoter referred to as teledata.In the present embodiment just take this access system as the commingled system that comprises distributed data base and traditional relational database as example describes, if distributed data base is data access request promoter, be called local data base, traditional relational database with respect to this distributed data base referred to as remote data base; Data base access system in the present embodiment also comprises the client being connected with local data base, also can be called local client, and user can send corresponding instruction to local data base by this client; Corresponding, the client being connected with remote data base can be described as Terminal Server Client.
Local data base in this example comprises data access subsystem, and wherein, analytics engine, execution engine, storage engines that the database access subsystem in the present embodiment and local data base comprise are existed side by side, and it can be storage engines data source is provided.Refer to Fig. 2, this data access subsystem comprises signal dispatcher module and Data access module, wherein:
Signal dispatcher module, for receiving remote data access request, and sends to processing module by the data access request receiving; Remote data access request herein can be that user sends by the client that is connected with local data base, the form of its transmission also can be selected according to actual conditions, in the present embodiment, preferably sends remote data access request by SQL (structured query language) form to local data base;
Processing module, for sending to corresponding remote data base by the remote data access request receiving by SQL form; And for receiving the execution result of this remote data base to described remote data access request, and described execution result is processed.
Visible, the processing module in the present embodiment is embedded in local data base, does not therefore need independently process support, can reduce the expense of resource, is more conducive to improve resource utilization.
In addition, in the present embodiment, by SQL form, remote data access request is pushed to corresponding remote data base, therefore local data base only need to provide simple, unified SQL access interface, the cost that reduction system is to a great extent disposed, moved and safeguard; Reduce the complexity of accessing data base.
Simultaneously, owing to adopting SQL form to push remote data access request, also can adopt various constraint condition (for example WHERE condition, JION ON) accurately to control flow, be more conducive to rational allocating task to local data base and remote data base, improve dirigibility and the controllability of system.
It should be understood that, access sub-system in the present embodiment also comprises remote data source information creating module, create and store teledata source information by client for user, teledata source information in the present embodiment can comprise remote database server information, and this remote database server information comprises reference address, port, data access mode, the database of remote data base.In addition, the teledata source information in the present embodiment also can further comprise remote database server calling party information.Refer to Fig. 3, the flow process of remote data source information creating is specific as follows:
Step 301: receive the remote data source information creating request that client sends;
Step 302: set up teledata source information according to this remote data source information creating request, specifically can be by corresponding function creation, for example, by create_server_statement function creation, the teledata source information of establishment can comprise remote database access address, port, database, data access mode etc.; Concrete, create_server_statement for function Backus normal form (BNF) (Backus-Naur Form, BNF) be expressed as follows:
Figure BDA00002475541100061
Figure BDA00002475541100071
Step 303: set up remote database server calling party information according to this remote data source information creating request, specifically also can be by corresponding function creation, for example, by create_server_user_statement function creation.It should be noted that, when distributed data base user accesses remote data source in the present embodiment, Distributed Datebase Access user is called local user, remote server access user is called long-distance user.In embodiment, a corresponding long-distance user of local user, a data source can corresponding one or more local users.Concrete, create_server_user_statement for function Backus normal form (BNF) (Backus-NaurForm, BNF) be expressed as follows:
<create_server_user_statement>::=CREATE?SERVER?USER?LOCAL<local_user>TO
<server_name>REMOTE<server_user>IDENTIFIED?BY<server_passwd>
Step 304: the result that creates information to the client feedback remote data source that sends the request of remote data source information creating.
Because the Share-Nothing framework that distributed data base is made up of multiple data processing nodes, for the Database Systems of analytic type application; Each node can independently be carried out SQL statement, storage data recording, and all back end are shared data dictionary.Therefore, in the present embodiment, can preferably the remote data source establishment information of establishment be stored in the data dictionary of database.
Refer to Fig. 4, the processing module in the present embodiment specifically comprises data access submodule and remote data access driven element module;
Data access submodule, for obtaining the data access mode that remote database access request comprises, is selected corresponding remote data access driven element module;
Remote data access driven element module selects corresponding remote data base to be connected for the teledata source information data access mode that request comprises with remote database access of storing according to local data base, then this remote data access request is sent to this remote data base by SQL form.
Because the remote data access driven element module in the present embodiment sends to corresponding remote data base by SQL form by remote data access request, therefore the journey data access driven element module in the present embodiment can be preferably one group of set of standard interfaces, every kind of data access mode is set and all realizes this group interface.If need to add new data access mode, or the remote data source of newtype, only need correspondence to realize a kind of data access mode.Such setting is more conducive to expansion, and third party database only need to be realized one group of standard interface that data access drives, and accessible distributed data base is also local data base.
Concrete, remote data access driven element module in the present embodiment can mainly be made up of following function interface: connect interface connects remote data source, execute interface sends data access request SQL, match Interface Matching this locality and teledata dictionary, fetch interface obtains one or one group of record (also obtaining the result data collection of remote data base feedback), one or one group record of format interface formatization, close closes remote data source and connects.
For a better understanding of the present invention, be that example is further described the present invention below in conjunction with concrete method flow:
Shown in Figure 5, the data bank access method in the present embodiment comprises:
Step 501: local data base receiving remote data access request;
Step 502: local data base sends to corresponding remote data base by the remote data access request receiving by SQL form;
Step 503: local data base receives the execution result of described remote data base to described remote data access request, and execution result is processed; Comprise in the time that execution result comprises result data collection and request executing state, result data collection is stored in the buffer memory of local data base after certain processing, and request executing state is fed back to the client that sends this request.
Wherein, before step 501, also can comprise the process of setting up teledata source information by the step shown in Fig. 3.
When by Distributed Datebase Access remote data source, specifically can realize by the execution engine calling data access subsystem of distributed data base.Analytics engine, execution engine, storage engines that database access subsystem in the present embodiment and local data base comprise are existed side by side, and it can be storage engines data source is provided.User can pass through the data in the SQL access remote data bases such as execute_server_statement, select_server_statement, carry out the DML statement except SELECT by execute_server_statement, and the executing state of remote data base is turned back to client; Carry out SELECT statement by select_server_statement, result data collection is deposited in to distributed data base, and statement executing state is returned to client, adopt and can in distributed data base, create in advance in this way local library and this earth's surface.Wherein, above-mentioned for function Backus normal form (BNF) (Backus-Naur Form, BNF) be expressed as follows:
Figure BDA00002475541100091
Refer to Fig. 6, in the present embodiment, the data access flow process of data base access system is specific as follows:
Step 601: the client of distributed data base (being also local data base) sends remote data access request by SQL;
Step 602: distributed data base is resolved, executing data request of access SQL, calling data access submodule;
Step 603: the data access mode (access_type) of data access submodule in asking by SQL, call corresponding remote data base corresponding to remote data access driven element module accesses;
Step 604: remote data access driven element module connects with corresponding remote data base, receives the execution result of this remote data base feedback, and this execution result is processed; Concrete, in the time that execution result comprises result data collection and request executing state, result data collection is sent to data access submodule with request executing state after certain processing;
Step 605: data are visited son and asked that module is pushed to result data collection (if there is) the storage engines of distributed data base, storage engines is by certain consistency algorithm (such as HASH algorithm), after various logic control (daily record etc.), result set is distributed to the corresponding data node of distributed data base;
Step 606: data access submodule is executing state that should remote data access request is returned to execution engine;
Step 607: the execution engine of distributed data base returns to the executing state of this request the client of sending this remote data access request.
As from the foregoing, the remote data access driven element module in the present embodiment is the core of data base access system, its access remote data base flow process as shown in Figure 7:
Step 701: distributed data base (being local data base) receives after the remote data access request of SQL form, call its execution engine and ask module by data visit of SQL statement calling data access sub-system, and then call corresponding remote data access driving submodule; The grammer of this SQL is teledata grammer, is resolved and is carried out by remote data base;
Step 702: remote data access drives submodule to be connected to corresponding remote data base; Specifically by the teledata source information that creates with and the data access mode obtained select corresponding remote data base to be connected; Preferably, in the present embodiment, the form with connection pool is safeguarded;
Step 703: remote data access drives submodule to connect to the remote data base connecting and pushes remote data access request with SQL form, connecting after remote data base success, by the SQL of data access request, the network interface by specific access mode push connect to remote database server;
Step 704: remote data access drives submodule pairing to resemble type.According to data dictionary, whether the field type of comparing this earth's surface and long-range table is compatible, and whether user's defining objects such as storehouse tabular are effective etc.;
Step 705: remote data access drives submodule to obtain the execution result of remote data base feedback, this execution result comprises result data collection and request executing state; Concrete, remote data access drives submodule to obtain by the network interface of data access mode (access_type) definition, obtains execution result;
Step 706: remote data access drives submodule to obtain result data collection is processed, and comprises it is formatd, and the data type of remote data base is converted into native data types.For example, specifically can by indirect type change or directly type conversion it is formatd.Wherein, indirect type conversion, is to define universal class take the type of ODBC definition as basis, and local type of distributed database correspondence, first teledata is changed into into universal class, is driven and is automatically converted into native data types again by data access.Directly type conversion, is to be directly converted into local data by realizing teledata.Indirect type conversion has the features such as highly versatile, compatible high, easy care; And directly type conversion efficiency is higher, but encode more, versatility is poor; Specifically can select which kind of mode to format according to actual conditions.
Step 707: remote data access drives submodule result data collection after treatment to deposit local cache in; Specifically result data collection after treatment can be returned to data visit and ask module, data are visited son and are asked that module is pushed to result data collection the storage engines of distributed data base, storage engines is by certain consistency algorithm (such as HASH algorithm) or security control, after various logic control (daily record etc.), result set is distributed to the corresponding data node of distributed data base;
Step 708: remote data access drives submodule to close and being connected of remote data base, and visits and subly ask that module returns to the executing state of teledata request in the execution engine of distributed data base by data.
Visible, the present invention is by inline processed module in local data base, and remote data access request is pushed to corresponding remote data base by SQL form, do not need independently process support, can reduce the expense of resource, is more conducive to improve resource utilization; Simultaneously reduction system to a great extent dispose, operation and the cost safeguarded, reduced the complexity of accessing data base; Also be more conducive to realize accurate control flow, and then reasonably allocating task, to local data base and remote data base, improves dirigibility and the controllability of system.
Above content is in conjunction with concrete embodiment further description made for the present invention, can not assert that specific embodiment of the invention is confined to these explanations.For general technical staff of the technical field of the invention, without departing from the inventive concept of the premise, can also make some simple deduction or replace, all should be considered as belonging to protection scope of the present invention.

Claims (13)

1. a data bank access method, is characterized in that comprising:
Local data base receiving remote data access request;
Described local data base sends to corresponding remote data base by the remote data access request receiving by SQL form;
Described local data base receives the execution result of described remote data base to described remote data access request, and described execution result is processed.
2. data bank access method as claimed in claim 1, is characterized in that, before described local data base receiving remote data access request, also comprises the step that creates and store teledata source information.
3. data bank access method as claimed in claim 2, it is characterized in that, described teledata source packet is drawn together remote database server information, or described teledata source packet is drawn together remote database server information and remote database server calling party information; Described remote database server information comprises reference address, the data access mode of remote data base.
4. data bank access method as claimed in claim 3, is characterized in that, described local data base sends to corresponding remote data base to comprise by SQL form the remote data access request receiving:
Described local data base obtains the data access mode that described remote database access request comprises;
Described local data base selects corresponding remote data base to be connected according to described teledata source information with described data access mode;
Described local data base sends to described remote data access request the remote data base being attached thereto by SQL form.
5. the data bank access method as described in claim 1-4 any one, is characterized in that, described remote data access request is the remote data access request that user sends to described local data base with SQL form by client.
6. the data bank access method as described in claim 1-4 any one, is characterized in that, described local data base is distributed data base.
7. a data base access system, is characterized in that comprising local data base, and described local data base comprises data access subsystem, and described data access subsystem comprises signal dispatcher module, Data access module,
Signal dispatcher module, for receiving remote data access request, and sends to processing module by the data access request receiving;
Processing module, for sending to corresponding remote data base by the remote data access request receiving by SQL form; And for receiving the execution result of described remote data base to described remote data access request, and described execution result is processed.
8. data base access system as claimed in claim 7, is characterized in that, described access sub-system also comprises remote data source information creating module, and described remote data source information creating module is for creating and store teledata source information.
9. data base access system as claimed in claim 8, it is characterized in that, described teledata source packet is drawn together remote database server information, or described teledata source packet is drawn together remote database server information and remote database server calling party information; Described remote database server information comprises reference address, the data access mode of remote data base.
10. data base access system as claimed in claim 9, is characterized in that, described processing module comprises data access submodule and remote data access driven element module;
Described data access submodule, for obtaining the data access mode that described remote database access request comprises, is selected corresponding remote data access driven element module;
Described remote data access driven element module is used for selecting corresponding remote data base to be connected according to described teledata source information with described data access mode, and for described remote data access request is sent to this remote data base by SQL form.
11. data base access systems as claimed in claim 10, is characterized in that, described remote data access driven element module is one group of set of standard interfaces.
12. data base access systems as described in claim 7-11 any one, it is characterized in that, described data base access system comprises the client being connected with described local data base, and described client is for sending remote data access request with SQL form to described local data base.
13. data base access systems as described in claim 7-11 any one, is characterized in that, described local data base is distributed data base.
CN201210490746.6A 2012-11-27 2012-11-27 Database access method and system Pending CN103838781A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN201210490746.6A CN103838781A (en) 2012-11-27 2012-11-27 Database access method and system

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN201210490746.6A CN103838781A (en) 2012-11-27 2012-11-27 Database access method and system

Publications (1)

Publication Number Publication Date
CN103838781A true CN103838781A (en) 2014-06-04

Family

ID=50802290

Family Applications (1)

Application Number Title Priority Date Filing Date
CN201210490746.6A Pending CN103838781A (en) 2012-11-27 2012-11-27 Database access method and system

Country Status (1)

Country Link
CN (1) CN103838781A (en)

Cited By (7)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN106021253A (en) * 2015-03-31 2016-10-12 欧姆龙株式会社 Programmable logic controller, data collection apparatus, database access method, and database access program
CN106354605A (en) * 2016-09-05 2017-01-25 上海爱数信息技术股份有限公司 Database access method and system and server provided with system
WO2017063441A1 (en) * 2015-10-15 2017-04-20 华为技术有限公司 Database access control method and apparatus
CN106933971A (en) * 2017-02-13 2017-07-07 北京优炫软件股份有限公司 A kind of data analysis statistical system based on science service
CN108153877A (en) * 2017-12-26 2018-06-12 平安科技(深圳)有限公司 Data dictionary methods of exhibiting, device, terminal device and storage medium
CN111143369A (en) * 2019-12-27 2020-05-12 合肥美的智能科技有限公司 Cloud service data unloading method and device, local server and electronic equipment
WO2021027126A1 (en) * 2019-08-14 2021-02-18 平安科技(深圳)有限公司 Database monitoring method, apparatus, device and computer-readable storage medium

Non-Patent Citations (1)

* Cited by examiner, † Cited by third party
Title
莫松海等: "ORACLE数据库中异地数据的存取技术", 《计算机应用》 *

Cited By (11)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN106021253A (en) * 2015-03-31 2016-10-12 欧姆龙株式会社 Programmable logic controller, data collection apparatus, database access method, and database access program
WO2017063441A1 (en) * 2015-10-15 2017-04-20 华为技术有限公司 Database access control method and apparatus
US10726035B2 (en) 2015-10-15 2020-07-28 Huawei Technologies Co., Ltd. Database access control method and apparatus
CN106354605A (en) * 2016-09-05 2017-01-25 上海爱数信息技术股份有限公司 Database access method and system and server provided with system
CN106354605B (en) * 2016-09-05 2019-06-21 上海爱数信息技术股份有限公司 A kind of access method of database, system and the server with the system
CN106933971A (en) * 2017-02-13 2017-07-07 北京优炫软件股份有限公司 A kind of data analysis statistical system based on science service
CN106933971B (en) * 2017-02-13 2020-06-16 北京优炫软件股份有限公司 Data analysis statistical system based on scientific and technological service
CN108153877A (en) * 2017-12-26 2018-06-12 平安科技(深圳)有限公司 Data dictionary methods of exhibiting, device, terminal device and storage medium
CN108153877B (en) * 2017-12-26 2021-03-12 平安科技(深圳)有限公司 Data dictionary display method and device, terminal equipment and storage medium
WO2021027126A1 (en) * 2019-08-14 2021-02-18 平安科技(深圳)有限公司 Database monitoring method, apparatus, device and computer-readable storage medium
CN111143369A (en) * 2019-12-27 2020-05-12 合肥美的智能科技有限公司 Cloud service data unloading method and device, local server and electronic equipment

Similar Documents

Publication Publication Date Title
CN107463637B (en) Distributed NewSQL database system and data storage method
US11630830B2 (en) Background format optimization for enhanced queries in a distributed computing cluster
CN103838781A (en) Database access method and system
KR101621137B1 (en) Low latency query engine for apache hadoop
CA2843886C (en) Cloud-based distributed persistence and cache data model
EP2932370B1 (en) System and method for performing a transaction in a massively parallel processing database
CN103631870B (en) System and method used for large-scale distributed data processing
US12014248B2 (en) Machine learning performance and workload management
CN105354328B (en) A kind of system and method solving the access conflict of NoSQL database concurrency
CN103605698A (en) Cloud database system used for distributed heterogeneous data resource integration
CN104573115A (en) Method and system for achieving integration interface supporting operation of multi-type databases
CN105138661A (en) Hadoop-based k-means clustering analysis system and method of network security log
CN104899274B (en) A kind of memory database Efficient Remote access method
CN107066546B (en) MPP engine-based cross-data center quick query method and system
WO2019047441A1 (en) Communication optimization method and system
CN106980672A (en) The data-storage system and method for a kind of isomerous environment Based on Object-Oriented Technology
CN102214236A (en) Method and system for processing mass data
EP2981908A1 (en) Query integration across databases and file systems
CN106471501A (en) The method of data query, the storage method data system of data object
CN117321582A (en) Graph operation engine for tenant management in a multi-tenant system
CN112163029A (en) Virtual database system and query method
CN110019113B (en) Database service processing method and database server
US11803568B1 (en) Replicating changes from a database to a destination and modifying replication capacity
CN103092591A (en) XML (Extensive Makeup Language) and Web Service based data integration middleware method

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

Application publication date: 20140604

RJ01 Rejection of invention patent application after publication