CN106547766A - A kind of data access method and device - Google Patents
A kind of data access method and device Download PDFInfo
- Publication number
- CN106547766A CN106547766A CN201510601348.0A CN201510601348A CN106547766A CN 106547766 A CN106547766 A CN 106547766A CN 201510601348 A CN201510601348 A CN 201510601348A CN 106547766 A CN106547766 A CN 106547766A
- Authority
- CN
- China
- Prior art keywords
- data
- source
- data source
- visited
- determined
- 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
- G06F16/252—Integrating or interfacing systems involving database management systems between a Database Management System and a front-end application
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 relates to wireless communication technology field, more particularly to a kind of data access method and device, to simplify data access process.In the embodiment of the present application, after the access request of service application transmission is received by unified access interface unit, according to the attribute information of the data to be visited included in access request, it is determined that at least one data source of storage data to be visited, according to data to be visited and at least one data source, determine the corresponding mission bit stream of each data source at least one data source, and the mission bit stream of determination is sent to into the corresponding data source of the mission bit stream;The initial data returned after each data source at least one data source performs the corresponding mission bit stream of each data source is received, according to each initial data, data to be output is determined, data to be output is returned to into service application.Thus, the developer of service application is familiar only with the make of access request, the skill set requirements degree of the developer to service application is reduced.
Description
Technical field
The application is related to database technical field, more particularly to a kind of data access method and device.
Background technology
The big data epoch, generally by mass data storage in data base.Mass data is managed for convenience,
Generally by data temporally or other dimensions carry out the storage of point table.In order to optimize the utilization rate of data base, generally
Data can be carried out the process such as moving according to the characteristic of data, such as, will seldom be accessed for data resettlement and arrive
In the lower data base of carrying cost.
Give an example, according to day, Month And Year by data point table storage, be one point by the data storage of a day
Table, by the general packet radio service (General Packet Radio Service, abbreviation GPRS) of N
Ticket table is stored in data base's MPP (Massively Parallel Processing, abbreviation MPP)
In, N is current year, the GPRS ticket tables by (N-1) Nian Zhi (N-3) between year move to
In the lower Hadoop clusters of carrying cost, the GPRS tickets table by (N-3) before year is deleted.
As shown in figure 1, Fig. 1 illustrate in prior art each service application and each data base it
Between annexation.Service application 1001 includes multiple business application, such as customer analysis service application
1002nd, market operation monitoring business application 1003, marketing assessment service application 1004, user behavior analysis
Service application 1005, flow analysis service application 1006 etc..Data base includes various, and each data base carries
For providing different access interface for service application, so that each service application passes through the corresponding access of the data base
Interface accessing and manage the data base in data.Such as service application can pass through SQL
(Structured Query Language, abbreviation SQL) interface accessing relational database management system
(Relational Database Management System, abbreviation RDBMS) 1007, can be connect by SQL
Mouth accesses MPP data bases (Database, abbreviation DB) 1008, can pass through application programming interface
(Application Programming Interface, abbreviation API) accesses Hadoop clusters 1009.Each industry
When business application needs to access the data in multiple data bases, many numbers that each service application is accessed with needs
Simultaneously connect according to storehouse, in such as Fig. 1 customer analysis service application 1002 connect simultaneously RDBMS1007 and
Hadoop clusters 1009.Data type defined in each data base is also differed, such as in data base
Variable length character type is defined with varchar2 in oracle, the text used in GreeenPlum defines variable length
Character type.
When service application need to access the different types of data base of two data simultaneously, the service application needs to visit
The data of two data bases are asked, therefore on the one hand the service application needs to support the driving of two data bases
Program or access interface, on the other hand, the developer of the service application needs to know both data bases'
Programming language, i.e., be programmed respectively according to the data type of two data bases.
To sum up, the method for conducting interviews to data in prior art is complex, and each service application is opened
Send out personnel requirement higher.
The content of the invention
The embodiment of the present application provides a kind of data access method and device, to simplify data access process.
A kind of first aspect, there is provided data access method, comprises the following steps:
After the access request of service application transmission is received by unified access interface unit, please according to accessing
The attribute information of the data to be visited included in asking, it is determined that at least one data source of storage data to be visited;
According to data to be visited and at least one data source, each data source pair at least one data source is determined
The mission bit stream answered, and the mission bit stream of determination is sent to into the corresponding data source of mission bit stream;
Receive after each data source at least one data source performs the corresponding mission bit stream of each data source
The initial data of return;
According to each initial data, determine data to be output, and data to be output are returned to into service application.
With reference in a first aspect, in the first possible implementation of first aspect, the category of data to be visited
Property information includes instance identification of the data to be visited in data source;
According to the attribute information of the data to be visited included in access request, it is determined that storage data to be visited are extremely
A few data source, including:
According to the instance identification and the corresponding relation of data source of data, the number to be visited that attribute information is included is determined
According to corresponding at least one data source of instance identification.
With reference in a first aspect, in second possible implementation of first aspect, the category of data to be visited
Property information includes service identification of the data to be visited in service application;
According to the attribute information of the data to be visited included in access request, it is determined that storage data to be visited are extremely
A few data source, including:
The corresponding relation of the instance identification according to the service identification and data of data in data source, determines attribute
The corresponding instance identification of service identification of the data to be visited that packet contains;
According to the instance identification and the corresponding relation of data source of data, the instance identification pair of data to be visited is determined
At least one data source answered.
With reference to any one possible realization in second possible implementation of first aspect to first aspect
Mode, in the third possible implementation of first aspect, according to data to be visited and at least one number
According to source, the corresponding mission bit stream of each data source at least one data source is determined, including:
Following steps are performed for each data source at least one data source:
If it is determined that the data type of access request is inconsistent with the data type of the data source, then according to access
The corresponding relation of the data type of request and the data type of data source, by the data type conversion of access request
For the data type of the data source, the corresponding mission bit stream of the data source is obtained;
If it is determined that the data type of access request is consistent with the data type of the data source, then by access request
As the corresponding mission bit stream of the data source.
With reference to any one possible realization in second possible implementation of first aspect to first aspect
Mode, in the 4th kind of possible implementation of first aspect, according to data to be visited and at least one number
According to source, the corresponding mission bit stream of each data source at least one data source is determined, including:
If it is determined that the data source of storage data to be visited is at least two, for each at least one data source
Individual data source performs following steps:
The partial data of the data to be visited stored by the data source according to determining, generates the data source pair
The operation information answered;Wherein, the part number of the data to be visited stored in including the data source by operation information
According to attribute information;
If it is determined that the data type of the corresponding operation information of the data source is consistent with the data type of the data source,
Then using the data source corresponding operation information as the corresponding mission bit stream of the data source;
If it is determined that the data type of the corresponding operation information of the data source is differed with the data type of the data source
Cause, then the corresponding relation according to the data type of access request and the data type of data source, by the data source
The data type conversion of corresponding operation information is the data type of the data source, obtains the data source corresponding
Mission bit stream.
With reference to any one possible realization in the 4th kind of possible implementation of first aspect to first aspect
Mode, in the 5th kind of possible implementation of first aspect, according to each initial data, it is determined that treating defeated
Go out data, including:
If it is determined that data manipulation need not be carried out to initial data, and in the coded format and business of initial data
Using coded format it is inconsistent when, the coded format of initial data is converted to into the coding lattice of service application
Formula, obtains data to be output;
If it is determined that data manipulation need not be carried out to initial data, and in the coded format and business of initial data
Using coded format it is consistent when, using initial data as data to be output;
If it is determined that need to carry out initial data data manipulation, and the coded format in initial data should with business
When coded format is inconsistent, the coded format of the data obtained after carrying out data manipulation to initial data
The coded format of service application is converted to, data to be output are obtained;
If it is determined that need to carry out initial data data manipulation, and the coded format in initial data should with business
When coded format is consistent, the data obtained after carrying out data manipulation to initial data are used as number to be output
According to.
With reference to the 5th kind of possible implementation of first aspect, in the 6th kind of possible realization of first aspect
In mode, if meeting the one kind in following condition, it is determined that need to carry out data manipulation:
It is determined that the data source at least two, access request of storage data to be visited includes indicating to be visited
Information that data are ranked up, access request include that it is to be viewed to indicate the format setting of data to be visited
The information of form;
Data manipulation is carried out according to following manner:
If it is determined that the data source at least two of storage data to be visited, then by the original of each data source return
Data are collected;
If access request includes the information for indicating to be ranked up data to be visited, each data source is returned
The initial data for returning is ranked up;
If access request includes indicating by the information that the format setting of data to be visited is form to be viewed,
The format setting of the initial data that each data source is returned is the form to be viewed that access request includes.
With reference to any one possible realization in the 6th kind of possible implementation of first aspect to first aspect
Mode, in the 7th kind of possible implementation of first aspect, also includes:
The data in data source are managed according to management configured information, and will be received according to management configured information
To the new corresponding data source of data of new data Cun Chudao in.
With reference to the 7th kind of possible implementation of first aspect, in the 8th kind of possible realization of first aspect
In mode, management configured information includes indicating the data for meeting first condition are moved to mesh from source data source
The information of mark data source;
The data in data source are managed according to management configured information, including:
The data for meeting first condition are determined from source data source;
If it is determined that the data type of the data type and target data source in source data source is inconsistent, first will be met
Data type of the data type conversion of the data of condition for target data source;
The data storage for meeting first condition after by data type conversion to target data source, and from source data
The data for meeting first condition are deleted in source.
A kind of second aspect, there is provided DAA, including:
Receiving unit, for the access request of service application transmission is received by unified access interface unit;
In receiving at least one data source, each data source performs return after the corresponding mission bit stream of each data source
Initial data;
Determining unit, in the access request that service application transmission is received by unified access interface unit
Afterwards, the attribute information according to the data to be visited included in access request, it is determined that storage data to be visited are extremely
A few data source;According to data to be visited and at least one data source, determine each at least one data source
The corresponding mission bit stream of individual data source, and the mission bit stream of determination is sent to into the corresponding data of mission bit stream
Source;According to each initial data, data to be output are determined;
Transmitting element, for data to be output are returned to service application.
With reference to second aspect, in the first possible implementation of second aspect, the category of data to be visited
Property information includes instance identification of the data to be visited in data source;
Determining unit, specifically for:
According to the instance identification and the corresponding relation of data source of data, the number to be visited that attribute information is included is determined
According to corresponding at least one data source of instance identification.
With reference to second aspect, in second possible implementation of second aspect, the category of data to be visited
Property information includes service identification of the data to be visited in service application;
Determining unit, specifically for:
The corresponding relation of the instance identification according to the service identification and data of data in data source, determines attribute
The corresponding instance identification of service identification of the data to be visited that packet contains;
According to the instance identification and the corresponding relation of data source of data, the instance identification pair of data to be visited is determined
At least one data source answered.
With reference to any one possible realization in second possible implementation of second aspect to second aspect
Mode, in the third possible implementation of second aspect, determining unit, at least one data
Each data source in source, specifically for:
If it is determined that the data type of access request is inconsistent with the data type of the data source, then according to access
The corresponding relation of the data type of request and the data type of data source, by the data type conversion of access request
For the data type of the data source, the corresponding mission bit stream of the data source is obtained;
If it is determined that the data type of access request is consistent with the data type of corresponding data source, then will access
Request is used as the corresponding mission bit stream of the data source.
With reference to any one possible realization in second possible implementation of second aspect to second aspect
Mode, in the 4th kind of possible implementation of second aspect, however, it is determined that go out the number for storing data to be visited
It is at least two according to source, determining unit, for each data source at least one data source, specifically for:
The partial data of the data to be visited stored by the data source according to determining, generates the data source pair
The operation information answered;Wherein, the part number of the data to be visited stored in including the data source by operation information
According to attribute information;
If it is determined that the data type of the corresponding operation information of the data source is consistent with the data type of the data source,
Then using the data source corresponding operation information as the corresponding mission bit stream of the data source;
If it is determined that the data type of the corresponding operation information of the data source is differed with the data type of the data source
Cause, then the corresponding relation according to the data type of access request and the data type of data source, by the data source
The data type conversion of corresponding operation information is the data type of the data source, obtains the data source corresponding
Mission bit stream.
With reference to any one possible realization in the 4th kind of possible implementation of second aspect to second aspect
Mode, in the 5th kind of possible implementation of second aspect, determining unit, specifically for:
If it is determined that data manipulation need not be carried out to initial data, and in the coded format and business of initial data
Using coded format it is inconsistent when, the coded format of initial data is converted to into the coding lattice of service application
Formula, obtains data to be output;
If it is determined that data manipulation need not be carried out to initial data, and in the coded format and business of initial data
Using coded format it is consistent when, using initial data as data to be output;
If it is determined that need to carry out initial data data manipulation, and the coded format in initial data should with business
When coded format is inconsistent, the coded format of the data obtained after carrying out data manipulation to initial data
The coded format of service application is converted to, data to be output are obtained;
If it is determined that need to carry out initial data data manipulation, and the coded format in initial data should with business
When coded format is consistent, the data obtained after carrying out data manipulation to initial data are used as number to be output
According to.
With reference to the 5th kind of possible implementation of second aspect, in the 6th kind of possible realization of second aspect
In mode, if meeting the one kind in following condition, it is determined that need to carry out data manipulation:
It is determined that the data source at least two, access request of storage data to be visited includes indicating to be visited
Information that data are ranked up, access request include that it is to be viewed to indicate the format setting of data to be visited
The information of form;
Data manipulation is carried out according to following manner:
If it is determined that the data source at least two of storage data to be visited, then by the original of each data source return
Data are collected;
If access request includes the information for indicating to be ranked up data to be visited, each data source is returned
The initial data for returning is ranked up;
If access request includes indicating by the information that the format setting of data to be visited is form to be viewed,
The format setting of the initial data that each data source is returned is the form to be viewed that access request includes.
With reference to any one possible realization in the 6th kind of possible implementation of second aspect to second aspect
Mode, in the 7th kind of possible implementation of second aspect, also including administrative unit, is used for:
The data in data source are managed according to management configured information, and will be received according to management configured information
To the new corresponding data source of data of new data Cun Chudao in.
With reference to the 7th kind of possible implementation of second aspect, in the 8th kind of possible realization of second aspect
In mode, management configured information includes indicating the data for meeting first condition are moved to mesh from source data source
The information of mark data source;
Administrative unit, specifically for:
The data for meeting first condition are determined from source data source;
If it is determined that the data type of the data type and target data source in source data source is inconsistent, first will be met
Data type of the data type conversion of the data of condition for target data source;
The data storage for meeting first condition after by data type conversion to target data source, and from source data
The data for meeting first condition are deleted in source.
A kind of third aspect, there is provided DAA, including:
Processor, for reading the program in memorizer, performs following process:
After the access request of service application transmission is received by unified access interface unit, please according to accessing
The attribute information of the data to be visited included in asking, it is determined that at least one data source of storage data to be visited;
According to data to be visited and at least one data source, each data source pair at least one data source is determined
The mission bit stream answered, and the mission bit stream of determination is sent to into the corresponding data source of mission bit stream;
Receive after each data source at least one data source performs the corresponding mission bit stream of each data source
The initial data of return;
According to each initial data, determine data to be output, and data to be output are returned to into service application.
In the embodiment of the present application, please in the access that service application transmission is received by unified access interface unit
After asking, according to the attribute information of the data to be visited included in access request, it is determined that storage data to be visited
At least one data source;According to data to be visited and at least one data source, in determining at least one data source
The corresponding mission bit stream of each data source, and the mission bit stream of determination is sent to into the corresponding data of mission bit stream
Source;Receive after each data source at least one data source performs the corresponding mission bit stream of each data source and return
The initial data for returning;According to each initial data, determine data to be output, and data to be output are returned to
Service application.Thus, any one service application only can send access request by unified access interface, i.e.,
Data at least one data source of accessible storage data to be visited, it is seen then that the exploit person of service application
Member is familiar only with the make of access request, need not pay close attention to the concrete operations environment of each data source, drops
The skill set requirements degree of the low developer to service application, simplifies the side for accessing data in data source
Method, improves data access efficiency.
Description of the drawings
For the technical scheme being illustrated more clearly that in the embodiment of the present application, below will be to institute in embodiment description
The accompanying drawing that needs are used is briefly introduced, it should be apparent that, drawings in the following description are only the application's
Some embodiments, for one of ordinary skill in the art, on the premise of not paying creative work,
Can be with according to these other accompanying drawings of accompanying drawings acquisition.
Fig. 1 is the annexation schematic diagram in prior art between each service application and each data base;
Fig. 2 is a kind of data access system configuration diagram that the embodiment of the present application is suitable for;
A kind of data access method schematic flow sheet that Fig. 3 is provided for the embodiment of the present application;
Storage mode and the number of the data that Fig. 3 a are provided for the embodiment of the present application in logic data model
According to the storage mode schematic diagram in data source;
A kind of structural representation of DAA that Fig. 4 is provided for the embodiment of the present application;
The structural representation of another kind of DAA that Fig. 5 is provided for the embodiment of the present application.
Specific embodiment
In order that the purpose of the application, technical scheme and beneficial effect become more apparent, below in conjunction with accompanying drawing
And embodiment, the application is further elaborated.It should be appreciated that described herein be embodied as
Example only to explain the application, is not used to limit the application.
Fig. 2 illustrates a kind of data access system configuration diagram that the embodiment of the present application is suitable for.Such as
Shown in Fig. 2, the system architecture includes service application 101, multiple data sources, and DAA
201.May include in DAA 201 that unifying access interface unit 202, SQL drives (SQL
Enging the encapsulation of) 203, cache memory (cache storege) 204, and multiple external datas
(Foreign Data Wrapper, abbreviation FDW), such as FDW205, FDW206, FDW207.
Unified access interface unit 202 is used to connect all service applications, such as customer analysis service application
102 etc..Alternatively, unified access interface unit 202 is specifically as follows java data bases connection (Java Data
Base Connectivity, abbreviation JDBC) interface.That is, the data access in the embodiment of the present application
Device 201 has done an encapsulation to each data source, provides a unified JDBC to each service application and connects
Mouthful.In addition, unified access interface unit 202 can be with independently of DAA 201, positioned at data
Between access mechanism 201 and service application 101.
Alternatively, DAA 201 is included into a driving for providing unified access interface unit 202,
The driving of DAA 201 can drive 203 for SQL, for realizing access request is carried out parsing,
Optimization, and accordingly generate the corresponding mission bit stream of each data source.Alternatively, definable DAA
201 are suitable for a standard syntax, for example:SQL92 standard syntax, to make the exploitation of each service application
Personnel are suitable for unified standard grammer and write access request.
Alternatively, also include cache memory 204 in DAA 201, for caching the bottom of from
The data obtained in each data source such as RDBMS107 of layer, so as to improve service application from data
The efficiency of data is inquired about in access mechanism 201.
The data source connected by DAA 201 may include polytype, such as RDBMSM107,
MPP DB108, Hadoop cluster 109 etc..Alternatively, the data source in the embodiment of the present application may include
The data of database form storage, may also comprise the data of non-database form storage, in the embodiment of the present application
Data source when being data base, data base can be various ways, can such as be non-relational database and relation
Type data base.
The SQL that each data source has special access interface or driver, such as RDBMS107 connects
Mouth, the SQL interfaces of MPP DB108, the api interface of Hadoop clusters 109, data base's inscriptions on bones or tortoise shells
(oracle) database call interface (Oracle Call Interface, abbreviation OCI) driver, number
According to the LIBPQ drivers of storehouse GreenPlum.In order that DAA 201 passes through each data
The special access interface in source or driver connect each data source, and DAA includes multiple
FDW.The ability of the SQL decompiling frameworks of FDW, data access dress are enhanced in the embodiment of the present application
Put 201 to assign outside data as a table to realize necessary calculating, DAA by FDW
201 itself do not preserve these external datas, simply when needing using external data, by FDW come
Data required for obtaining.Alternatively, each data source connects a FDW, such as data base
RDBMS107 connects FDW205, and MPP DB108 connection FDW206, Hadoop clusters 109 connect
FDW207。
Service application 101 includes multiple business application, such as the customer analysis service application 102, market operation
Monitoring business application 103, marketing assessment service application 104, user behavior analysis service application 105, flow
Analysis service application 106 etc..Service application be by data source data through cleaning, it is integrated, analysis,
Excavate, visualization, so as to formed it is understandable that information, so as to help user excavate be hidden in big data
In information and knowledge.Service application is generally by operational indicator come the letter by hiding in user's display data
Breath.Operational indicator has various, the 4G user activities of such as telecommunications industry, people's flow monitoring, pseudo-base station inspection
Survey, common form.
Based on the system architecture shown in Fig. 2, Fig. 3 shows a kind of data access that the embodiment of the present application is provided
Method, alternatively, the DAA that said method flow process can be as shown in Figure 2 is realized, the method flow process
Comprise the following steps:
Step 301, after the access request of service application transmission is received by unified access interface unit,
According to the attribute information of the data to be visited included in access request, it is determined that at least the one of storage data to be visited
Individual data source;
Step 302, according to data to be visited and at least one data source, determines each at least one data source
The corresponding mission bit stream of individual data source, and the mission bit stream of determination is sent to into the corresponding data of mission bit stream
Source;
Step 303, in receiving at least one data source, each data source performs the corresponding task of each data source
The initial data returned after information;
Step 304, according to each initial data, determines data to be output, and data to be output is returned to
Service application.
In above-mentioned steps 301, the unified access interface unit in the embodiment of the present application is used for as one or more
Service application provides a unified interface, and alternatively, it can be JDBC interfaces that this unifies access interface unit.
Alternatively, there is provided the driving of the interface can be driven for SQL, arbitrary service application can pass through the unification
Interface sends information, such as access request or management configured information etc..Arbitrary service application passes through the unification
Interface send access request and/or management configured information data type be the DAA
The data type that successfully can be parsed, it is predefined to be DAA institute, so as to each industry
Application developer is only it should be understood that the operating environment of the DAA, discernible data type etc. for business
Information, you can the DAA is connected by the DAA in the embodiment of the present application
Each data source carries out data access or data management.Alternatively, the grammer that DAA is suitable for is fixed
Justice is SQL92 standard syntax.
In order to illustrate conveniently, by " the instance identification and data source of data in herein below in the embodiment of the present application
Corresponding relation " definition " the first corresponding relation ", will " service identification and data of data be in data source
Instance identification corresponding relation " be defined as " the second corresponding relation ", by " the data class of access request
The corresponding relation of the data type of type and data source " is defined as the 3rd corresponding relation.In the embodiment of the present application
The storage form of the first corresponding relation, the second corresponding relation and the 3rd corresponding relation has various, such as, data
Table, text etc., the embodiment of the present application is without limitation.The embodiment of the present application provides one kind and alternatively implements
Mode, the first corresponding relation, the second corresponding relation and the 3rd corresponding relation are deposited in the form of logic data model
Storage.It is introduced as a example by logic-based data model pair in the embodiment of the present application.
A set of unified data type is pre-defined, table 1 is illustrated defined in the embodiment of the present application
Unified data type table, as shown in table 1, defined a set of unified data type includes character type
(Char), character type (String), shaping (Int), long shaping (Long), double precision shaping (Double), cloth
Your type (Boolean) etc., may also include other data types, such as shaping (Real) and date type (Datetime).
From the predefined unified data type afterwards data type used by selection logic data model,
That is, the data access request or the data type of management configured information sent by service application is the logical number
According to the data type that model is configured.
Table 1
Data type | Size |
Byte (Byte) | 8 |
Short (Shot) | 16 |
Shaping (Int) | 32 |
Long shaping (Long) | 64 |
Floating type (Float) | 32 |
Double precision shaping (Double) | 64 |
Boolean type (Boolean) | 1 |
Character type (Char) | 16 |
Character type (String) | Variable length |
Boolean type (Boolean) | Need appointed day form |
Big object (BLOB/CLOB/NLOB) | Suitable for partial data source |
Each data source has special access interface or driver, and each data source also has the data source
Proprietary data type.Data type and number of the 3rd corresponding relation in the embodiment of the present application for access request
According to the corresponding relation of the data type in source, and as the data type of access request is logic data model
Data type, therefore, the data type and logic data model of the 3rd corresponding relation namely each data source
Data type corresponding relation.Give an example, such as, in the data type of logic data model
String (1000) corresponding to the varchar2 (1000) in the data type of data source oracle, in logic
String (1000) in the data type of data model is corresponding to being exactly text in data source GreenPlum
(1000)。
Secondly, also include the attribute information of data in each data source in logic data model.Attribute information can
Including much information, such as instance identification of the data in data source, instance identification is data storage and is counting
According to the mark used in source, usually English mark, row name id_no of the table in such as data base and
Mobile_phone, or hdfs filename dw_user_info and gprs_cdr_yyyymmdd.Alternatively,
Attribute information may also include service identification of the data in service application, and service identification is service-oriented application
, the mark with business semantics, service identification are more square typically to the developer for making service application
Just quickly understand defined in the meaning of the data.Service identification is usually Chinese mark, than in user table
User identity card number and subscriber phone number.The industry of the data of data is may also include in logic data model
Second corresponding relation of business mark and instance identification of the data in data source, thus, opening when service application
The personnel of sending out when access request is write, the service identification that simple service-oriented can be used semantic, and not
The instance identification of complexity of the data in data source must be related to, DAA can be closed according to the second correspondence
System, determines instance identification of the service identification in data source, reduce further service application developer
Work difficulty.
Also include data type of the data in logic data model in attribute information, such as, define the number
According to for variable length character types or lint-long integer type, wherein, the data type in logic data model choose in
Predefined unified data type.Other some description letters to data are may also include in attribute information
Breath, the length of the such as data.
Alternatively, can be different according to the storage mode of data, the attribute of the data in logic data model is believed
Preserved if breath is divided into the tables of data of dry type
The generally data volume of ticket information table, can be by natural gift table, i.e., with one day point of table or one day one than larger
The mode of individual file stores ticket information table.
The developer of each service application can send management configured information by unified access interface, and data are visited
Ask that device can be managed to the data in data source according to management configured information, and according to management configured information
By in new data Cun Chudao for the receiving new corresponding data source of data.Also include pipe in logic data model
First corresponding relation of reason configured information, i.e. instance identification and data source.
Specifically, managing configured information may include the attribute of each data source institute data storage.The application reality
The example below a1,3 several embodiments of example a 2 and example a are provided in applying example:
Example a 1, it is intended that data source Hadoop cluster, and to the data source Hadoop cluster-based storage data
When, HDFS files need to be stored as, then need to be configured for storage formats such as txt/xml/json, than
Such as file separator, xml paths, document No., compression type etc.;
Example a 2, it is intended that data source Hadoop cluster, and to the data source Hadoop cluster-based storage data
When, Hbase tables need to be stored as, then need setting row race information;
Example a 3, it is intended that data source MPP greenplum clusters, then allow setting index information.
The storage rule of each data is may also include in management configured information, specifically, it is intended that data are deposited
The data source of storage, and the storage period of the data, arrive when the storage period of data, DAA
Data can be moved in target data source from source data source immediately or when periodicity performs task,
Or burnin operation is performed to the data, that is, delete the data.There is provided in the embodiment of the present application following example b1,
Example b2 and example b3 several embodiments:
Example b1, managing configured information includes indicating the data storage that newly will be received into source data source.This
When, the data type of the data that DAA is really newly received whether with source data source in data type one
Cause, if unanimously, according to management configured information by the data storage for newly receiving to source data source;If differing
Cause, then by the data type conversion of the data for newly receiving be the corresponding data type in source data source, and according to pipe
Reason configured information is by the data storage for newly receiving to source data source.During source data source is the embodiment of the present application
Any one data source in data source.
Example b2, managing configured information includes indicating the data for meeting first condition are moved from source data source
To the information of target data source.The data for meeting first condition can be apart from the current date number of 11 to 30 days
According to.Now, DAA determines the data for meeting first condition from source data source, however, it is determined that source
The data type of the data type and target data source of data source is inconsistent, will meet the data of first condition
Data type of the data type conversion for target data source, by data type conversion after meet first condition
Data storage is to target data source, and the data for meeting first condition are deleted from source data source.If it is determined that source
The data type of data source is consistent with the data type of target data source, then deposit the data for meeting first condition
Store up to target data source, and the data for meeting first condition are deleted from source data source.Source data source and target
Data source is any two data sources in the data source in the embodiment of the present application.
Example b3, management configured information include indicating to meet the data deletion of second condition.Meet second
The data of condition are apart from current date 30 days and the data of the above.Now, DAA is according to the pipe
Reason configured information will meet the data deletion of second condition from data source.
Give an example, the storage rule of user's GPRS ticket tables (day table) is:It is nearest apart from current date
10 days in data storage in data source MPP, apart from the current date data storage of 11 to 30 days
In data source HDFS, delete apart from current date 30 days and the data of the above.DAA root
Following operation can be performed according to the storage rule:The daily new data for obtaining is stored into data source MPP,
Daily the data before the 11st day are clipped in HDFS data sources, and by 30 days in HDFS data sources with
On data deletion.
Management configured information may also include quality of data rule, such as arrange the user mobile phone in GPRS tickets
The necessary non-NULL of number, thus, can be checked to the quality of data by periodic task scheduling, is found out
The data that subscriber phone number in GPRS tickets must be empty for, are deleted or are reported.
Management configured information may also include data safety privacy, such as by GPRS call bill data models
Subscriber phone number uses Advanced Encryption Standard (Advanced Encryption Standard, write a Chinese character in simplified form AES)
Encryption, thus, then in data load process, data can be performed with encryption behaviour according to corresponding key information
Make.
DAA can create corresponding text automatically in specified data source based on management configured information
Part catalogue or database table.
Fig. 3 a illustrate storage side of the data of the embodiment of the present application offer in logic data model
The storage mode schematic diagram of formula and the data in data source.As shown in Figure 3 a, in DAA
The attribute information in logic data model in 201 as shown in table 2, illustrates logical number in table 2
According to the attribute information example in model.As shown in table 2, in logic data model the first row data business mark
Know for " ID ", instance identification is " USER_ID ", and the data type of the data is " variable length word
Symbol ", the length of the data type is 40.In logic data model, the service identification of the second row data is " GPRS
Duration ", instance identification is " GPRS_TIME ", and the data type of the data is " lint-long integer ", the data
The length of type is 20.
Table 2
Service identification | Instance identification | Data type | Length | … |
ID | USER_ID | Variable length character | 40 | … |
GPRS durations | GPRS_TIME | Lint-long integer | 20 | … |
… | … | … | … | … |
Wherein, the form of the GRPS_TIME in logic data model is
The method for expressing of GPRS_CDR_YYYYMMDD, YYYYMMDD for time date.Logical number
According to the management configured information in model it is:Counting away from the data storage in nearest 10 days of current date
According in the MPP of source;Apart from the current date data storage of 11 to 30 days in data source HDFS;Delete
Apart from current date 30 days and the data of the above.
Based on the logic data model shown in Fig. 3 a, table 3 illustrates data in data source MPP3101
In concrete storage form.Data are stored in data source MPP3103 in the form of table (tables), its
The string of middle GRPS_TIME is as shown in table 3.
Table 3
GPRS_CDR_20150430 |
GPRS_CDR_20150429 |
GPRS_CDR_20150428 |
GPRS_CDR_20150427 |
GPRS_CDR_20150426 |
… |
GPRS_CDR_20150421 |
The database schema definitional language performed by such as when the data of table 3 is generated in data source MPP3101
(Data Definition Language, abbreviation DDL) is specially:
Create table Create table GPRS_CDR_20150430 (USER_ID text);
GRPS_TIME int;
…
Based on the logic data model shown in Fig. 3 a, table 4 illustrates data in data source
Concrete storage form in HDFS3102.Data are in data source HDFS3102 with file (files)
Form is stored, and the wherein storage form of GRPS_TIME is as shown in table 4.
Table 4
In data source HDFS3102, the file structure of data storage is specially, number
Every string according to table is separated using vertical line " | ", can such as be " ID | GPRS durations | ... ".
In above-mentioned steps 301, any one or more service applications are received by unified access interface unit and is sent out
The access request sent.A kind of optional embodiment is that DAA supports SQL statement, is accessed
Request is the SQL statement that DAA successfully can be parsed, the data type and data of access request
The data type of the logic data model of access mechanism is consistent.
After receiving access request, the parsing of syntax and semantics is carried out to the access request of the SQL statement.
The attribute information of data to be visited is may include in access request, attribute information may include the example of data to be visited
Mark, also may not include the instance identification of data to be visited, but including the service identification of data to be visited.
That is, the operation object of data to be visited is actually concrete in logic data model, rather than each data source
Physical database table or HDFS files.Syntactic analysiss are carried out to access request, to check that the access please
Seeking Truth is no syntax error, it is ensured that the correctness of access request statements structure.Semantic point is carried out to access request
Analysis, so that the examination of contextual relevance is carried out to the correct access request of sentence structure, and ties to sentence
The correct access request of structure carries out type examination.If it find that there is mistake in the grammer or semanteme of access request,
Then directly terminate performing current process.Alternatively, corresponding error code is returned to service application.
In the embodiment of the present application, in service application after DAA sets up connection, by unification
Before access interface unit receives the access request of service application transmission, also receive service application and send user
Mark.It is preset with DAA with the user totem information for sending access request claim, can be with
The form storage of table.Afterwards according to it is default with send access request claim user totem information, to
Family mark is authenticated;If it is determined that ID has the authority for sending access request, then according to access request
In the attribute information of data to be visited that includes, it is determined that at least one data source of storage data to be visited.If
Determine that ID does not have the authority for sending access request, then directly terminate performing current process.Alternatively,
Corresponding error code is returned to service application.
In above-mentioned steps 301, it is determined that the mode of at least one data source of storage data to be visited has various,
The embodiment of the present application provides the embodiment of in the following manner c1 and mode c2:
Mode c1, the attribute information of data to be visited include instance identification of the data to be visited in data source then
According to the instance identification and the first corresponding relation of data source of data, the number to be visited that attribute information is included is determined
According to corresponding at least one data source of instance identification.
Mode c2, the attribute information of data to be visited include business mark of the data to be visited in service application
Know, then the second corresponding relation of the instance identification according to the service identification and data of data in data source, really
Determine the corresponding instance identification of service identification of the data to be visited that attribute information is included;According to the example mark of data
Know the first corresponding relation with data source, determine corresponding at least one data of instance identification of data to be visited
Source.
In above-mentioned steps 302, according to data to be visited and each data source, determine that each data source is corresponding
Mission bit stream specifically includes various ways, and following manner d1, mode d2, side are provided in the embodiment of the present application
Formula d3, mode d4 and mode d5 several embodiments:
Mode d1, however, it is determined that the data source for going out to store data to be visited is one, and the data class of access request
Type is inconsistent with the data type of corresponding data source, then the data type and data source according to access request
3rd corresponding relation of data type, by the data that the data type conversion of access request is corresponding data source
Type, obtains the corresponding mission bit stream of data source.
Mode d2, however, it is determined that the data source for going out to store data to be visited is one, and the data class of access request
Type is consistent with the data type of corresponding data source, then using access request as the corresponding task letter of data source
Breath.
Mode d3, however, it is determined that the data source for going out to store data to be visited is at least two, then at least one
In data source, each data source performs following steps:
If it is determined that the data type of access request is inconsistent with the data type of the data source, then according to access
The corresponding relation of the data type of request and the data type of data source, by the data type conversion of access request
For the data type of the data source, the corresponding mission bit stream of the data source is obtained;If it is determined that access request
Data type is consistent with the data type of the data source, then using access request as the corresponding task of the data source
Information.
Give an example for aforesaid way d3, in access request, data to be visited are apart from current date 20 days
Within GPRS durations, judged according to the data to be visited, the GPRS within current date 10 days
Duration in data source MPP, apart from the current date GPRS durations of 10 days to 20 days in data source HDFS
In, now, however, it is determined that the data type for going out access request is identical with the data type of data source MPP, visit
Ask that the data type of request is different from data source HDFS, then by access request directly as data source MPP
Mission bit stream, by the data type conversion of the access request for data source HDFS data type, obtain
The executable mission bit stream of data source HDFS.
Mode d4, however, it is determined that the data source for going out to store data to be visited is at least two, at least one number
Following steps are performed according to each data source in source:
The partial data of the data to be visited stored by the data source according to determining, generates the data source pair
The operation information answered;Wherein, the part number of the data to be visited stored in including the data source by operation information
According to attribute information;
If it is determined that the data type of the corresponding operation information of the data source is consistent with the data type of the data source,
Then using the data source corresponding operation information as the corresponding mission bit stream of the data source.
Mode d5, however, it is determined that the data source for going out to store data to be visited is at least two, at least one number
Following steps are performed according to each data source in source:
The partial data of the data to be visited stored by the data source according to determining, generates the data source pair
The operation information answered;Wherein, the part number of the data to be visited stored in including the data source by operation information
According to attribute information;
If it is determined that the data type of the corresponding operation information of the data source is differed with the data type of the data source
Cause, then the data type and the 3rd corresponding relation of the data type of data source according to access request, this is counted
According to the data type that the data type conversion of the corresponding operation information in source is the data source, the data source pair is obtained
The mission bit stream answered.
Give an example for aforesaid way d5, in access request, data to be visited are apart from current date 20 days
Within GPRS durations, judged according to the data to be visited, the GPRS within current date 10 days
Duration in data source MPP, apart from the current date GPRS durations of 10 days to 20 days in data source HDFS
In, now, generate the corresponding operation information of data source MPP and " read within current date 10 days
GPRS durations ", and the corresponding operation information of data source HDFS " read apart from current date 10 days extremely
20 GPRS durations ", the partial data of the data to be visited stored in including the data source by operation information
Attribute information.Afterwards, if judging the data type and data source MPP and data source of access request
HDFS is different, then by the data type conversion of data source MPP corresponding operation information be the data source
Data type, obtain the executable mission bit stream of data source MPP, by data source HDFS correspondence
Operation information data type conversion be the data source data type, obtaining data source HDFS can hold
Capable mission bit stream.
Each data source corresponding mission bit stream is sent to into each data source, each data source performs each afterwards
Self-corresponding mission bit stream, and initial data is returned to DAA performing after mission bit stream terminates.
The initial data can be the data of the original storage in data source, and may also be data source has carried out some calculating
Data afterwards.
In being embodied as, during across data source access big data, the sentence that can sink sinks to data source as far as possible
Calculate, DAA only carries out some as far as possible and the data manipulation, now, data source such as such as collects, sorts
The initial data of return is exactly that data source has carried out the data after some calculating according to the data for being stored.Across
When data source small data quantity is accessed, the data in each data source all can be drawn into DAA
In telling buffer storage, whole calculating and data manipulation are completed by DAA.Now, data
The initial data that source returns is exactly the data stored by data source.
After DAA receives the initial data that all data sources are returned, in addition it is also necessary to determine whether to need
The initial data is carried out data manipulation or coded format conversion, specifically, can by the following manner e1,
Several implementations of mode e2, mode e3 and mode e4:
Mode e1, however, it is determined that data manipulation need not be carried out to initial data, and in the coding lattice of initial data
When formula is inconsistent with the coded format of service application, the coded format of initial data is converted to into service application
Coded format, obtains data to be output;
Mode e2, however, it is determined that data manipulation need not be carried out to initial data, and in the coding lattice of initial data
When formula is consistent with the coded format of service application, using initial data as data to be output;
Mode e3, however, it is determined that need to carry out initial data data manipulation, and in the coded format of initial data
When inconsistent with the coded format of service application, the data obtained after data manipulation being carried out to initial data
Coded format is converted to the coded format of service application, obtains data to be output;
Mode e4, however, it is determined that need to carry out initial data data manipulation, and in the coded format of initial data
When consistent with the coded format of service application, the data obtained after data manipulation being carried out to initial data as
Data to be output.
In aforesaid way e1, mode e2, mode e3 and mode e4, if meeting the one kind in following condition,
Then determining needs to carry out data manipulation:
It is determined that the data source at least two, access request of storage data to be visited includes indicating to be visited
Information that data are ranked up, access request include that it is to be viewed to indicate the format setting of data to be visited
The information of form.
In aforesaid way e1, mode e2, mode e3 and mode e4, data manipulation is carried out according to following manner:
If it is determined that the data source at least two of storage data to be visited, then by the original of each data source return
Data are collected;If access request includes the information for indicating to be ranked up data to be visited, will be every
The initial data that individual data source is returned is ranked up;If access request includes indicating the lattice of data to be visited
Formula typesetting is the information of form to be viewed, then the format setting of the initial data for returning each data source is visit
Ask the form to be viewed that request includes.
The embodiment of the present application provides a kind of easy data access method, there is provided a kind of service-oriented semanteme
Unified access interface unit, each business unit can by the uniform interface unit access any one or it is many
Individual data source, and when accessing different types of data source, the developer of service application waits to visit without the need for relation
Data storage is asked in which data source, which kind of access interface and data class supported without care data source
Type, developer's development process indifference of service application.The indiscriminate exploitation experience reduces big data
The difficulty for using of platform, improves the development efficiency of service application.
Second aspect, provides the data managing method of logic-based data model in the embodiment of the present application, can
Value, temperature according to data rationally arranges management configured information, effectively improves system resource service efficiency.
The third aspect, effectively shields basic unit's basic software based on DAA in the embodiment of the present application
Ins and outs;That is, service application need to only access logic data model in DAA i.e.
May have access to and peration data source, such as physical database table or Hadoop group documents.
Fourth aspect, the data source in the embodiment of the present application except can in addition to traditional relevant database,
Can also be the cluster distributed files of Hadoop.
In terms of 5th, the DAA in the embodiment of the present application, can spirit by FDW external datas source
The various data sources of access living.
Take a particular example below, for illustrating said process.
A newly-built logic data model in DAA, specially:Service identification is user GPRS
Ticket table, instance identification are gprs_cdr_yyyymmdd, and the memory module of logic data model is according to number
Day database table of natural gift table, i.e., one or one day file are pressed according to temporal information.
The data type of logic data model is set, it is specific as follows:
User identity card number (id_no), character type
Subscriber phone number (mobile_phone), character type
Ticket time started (start_time), timestamp
Ticket end time (end_time), timestamp
Ticket duration (cdr_len), integer, unit:Second
Management configured information is set, it is specific as follows:
The data storage of nearest 10 days is in predefined data source MPP;Data away from modern 11-30 days
It is stored in predefined data source HDFS, is stored as txt forms, and separates each row letter using vertical line
Breath;Away from modern 30 days data deletions in addition.
DAA is managed to the data in data source according to management configured information, specific as follows:
User's GPRS tickets table of nearest 10 days is loaded according to the date and time information of user's GPRS ticket tables
To in data source MPP;
Dispatched by timed task, DAA daily by automatically the data before modern 11st day from
Move in data source MPP into data source HDFS data source;And the user GPRS more than 30 days is talked about
Single table is deleted from data source HDFS.
The access request that DAA is received is:Inquiry subscriber phone number is 13100000000
The GPRS of nearest 20 days consumes total duration, then the concrete SQL statement of data access request can be:
select sum(cdr_len)from gprs_cdr_yyyymmdd where begin_time>now()-20
And mobile_phone=' 13100000000 ';
DAA determines that data are located in data source MPP and data source HDFS respectively, data
Access mechanism obtains subscriber phone number respectively from data source MPP according to said method flow process
User's GPRS ticket tables of nearest 10 days of 13100000000, obtain user's handss from data source HDFS
Machine number is user's GPRS ticket tables of nearest 10 to 20 days of 13100000000;
DAA enters to the data for obtaining from data source MPP and from data source HDFS respectively
Row collects, and obtains the GPRS consumption total durations of nearest 20 days that subscriber phone number is 13100000000.
In the example, if access request is for " inquiry subscriber phone number is nearest the 20 of 13100000000
It user's GPRS ticket tables ", and be ranked up according to temporal information, then DAA needs right
The data for obtaining from data source MPP and from data source HDFS respectively are ranked up according to temporal information,
When determining that the coded format of service application is different from the coded format of DAA afterwards, after sequence
Subscriber phone number is that user's GPRS tickets table of nearest 20 days of 13100000000 carries out code conversion,
And be the user GPRS words of nearest 20 days of 13100000000 by the subscriber phone number after code conversion
Single table is exported to service application.
In the example, as the data in MPP are the form of tables of data, the data in HDFS are txt lattice
Formula, therefore, a kind of alternatively embodiment is that the data that will be obtained from data source HDFS enter row format row
Version, makes from the neutralization of data source MPP the data form unification obtained from data source HDFS, afterwards by lattice
The unified data output of formula is to service application.
It can be seen from the above:In the embodiment of the present application, received by unified access interface unit
After the access request that service application sends, according to the attribute information of the data to be visited included in access request,
It is determined that at least one data source of storage data to be visited;According to data to be visited and each data source, it is determined that
The corresponding mission bit stream of each data source, and the mission bit stream of determination is sent to into corresponding data source;Receive
The initial data that each data source is returned after performing the corresponding mission bit stream of data source;According to each original number
According to determining data to be output, and data to be output returned to service application.Thus, any one business should
Access request is sent with can only pass through unified access interface, you can access at least the one of storage data to be visited
Data in individual data source, it is seen then that the developer of service application is familiar only with the make of access request i.e.
Can, the concrete operations environment of each data source need not be paid close attention to, the skill of the developer to service application is reduced
Degree can be required, the method for accessing data in data source is simplified, is improve data access efficiency.
Fig. 4 illustrates a kind of structural representation of DAA of the embodiment of the present application offer.
Based on same idea, the embodiment of the present application provides a kind of DAA, as shown in figure 4, including
Receiving unit 401, determining unit 402, transmitting element 403, administrative unit 404:
Receiving unit, for the access request of service application transmission is received by unified access interface unit;
In receiving at least one data source, each data source performs return after the corresponding mission bit stream of each data source
Initial data;
Determining unit, in the access request that service application transmission is received by unified access interface unit
Afterwards, the attribute information according to the data to be visited included in access request, it is determined that storage data to be visited are extremely
A few data source;According to data to be visited and at least one data source, determine each at least one data source
The corresponding mission bit stream of individual data source, and the mission bit stream of determination is sent to into the corresponding data of mission bit stream
Source;According to each initial data, data to be output are determined;
Transmitting element, for data to be output are returned to service application.
Alternatively, the attribute information of data to be visited includes instance identification of the data to be visited in data source;
Determining unit, specifically for:
According to the instance identification and the corresponding relation of data source of data, the number to be visited that attribute information is included is determined
According to corresponding at least one data source of instance identification.
Alternatively, the attribute information of data to be visited includes business mark of the data to be visited in service application
Know;
Determining unit, specifically for:
The corresponding relation of the instance identification according to the service identification and data of data in data source, determines attribute
The corresponding instance identification of service identification of the data to be visited that packet contains;
According to the instance identification and the corresponding relation of data source of data, the instance identification pair of data to be visited is determined
At least one data source answered.
Optionally it is determined that unit, for each data source at least one data source, specifically for:
If it is determined that the data type of access request is inconsistent with the data type of the data source, then according to access
The corresponding relation of the data type of request and the data type of data source, by the data type conversion of access request
For the data type of the data source, the corresponding mission bit stream of the data source is obtained;
If it is determined that the data type of access request is consistent with the data type of corresponding data source, then will access
Request is used as the corresponding mission bit stream of the data source.
Alternatively, however, it is determined that go out to store data to be visited data source be at least two, determining unit, for
Each data source at least one data source, specifically for:
If it is determined that the data source of storage data to be visited is at least two, perform for each data source following
Step:
The partial data of the data to be visited stored by the data source according to determining, generates the data source pair
The operation information answered;Wherein, the part number of the data to be visited stored in including the data source by operation information
According to attribute information;
If it is determined that the data type of the corresponding operation information of the data source is consistent with the data type of the data source,
Then using the data source corresponding operation information as the corresponding mission bit stream of the data source;
If it is determined that the data type of the corresponding operation information of the data source is differed with the data type of the data source
Cause, then the corresponding relation according to the data type of access request and the data type of data source, by the data source
The data type conversion of corresponding operation information is the data type of the data source, obtains the data source corresponding
Mission bit stream.
Optionally it is determined that unit, specifically for:
If it is determined that data manipulation need not be carried out to initial data, and in the coded format and business of initial data
Using coded format it is inconsistent when, the coded format of initial data is converted to into the coding lattice of service application
Formula, obtains data to be output;
If it is determined that data manipulation need not be carried out to initial data, and in the coded format and business of initial data
Using coded format it is consistent when, using initial data as data to be output;
If it is determined that need to carry out initial data data manipulation, and the coded format in initial data should with business
When coded format is inconsistent, the coded format of the data obtained after carrying out data manipulation to initial data
The coded format of service application is converted to, data to be output are obtained;
If it is determined that need to carry out initial data data manipulation, and the coded format in initial data should with business
When coded format is consistent, the data obtained after carrying out data manipulation to initial data are used as number to be output
According to.
Alternatively, if meeting the one kind in following condition, it is determined that need to carry out data manipulation:
It is determined that the data source at least two, access request of storage data to be visited includes indicating to be visited
Information that data are ranked up, access request include that it is to be viewed to indicate the format setting of data to be visited
The information of form;
Data manipulation is carried out according to following manner:
If it is determined that the data source at least two of storage data to be visited, then by the original of each data source return
Data are collected;
If access request includes the information for indicating to be ranked up data to be visited, each data source is returned
The initial data for returning is ranked up;
If access request includes indicating by the information that the format setting of data to be visited is form to be viewed,
The format setting of the initial data that each data source is returned is the form to be viewed that access request includes.
Alternatively, also including administrative unit, it is used for:
The data in data source are managed according to management configured information, and will be received according to management configured information
To the new corresponding data source of data of new data Cun Chudao in.
Alternatively, managing configured information includes indicating the data for meeting first condition are moved from source data source
To the information of target data source;
Administrative unit, specifically for:
The data for meeting first condition are determined from source data source;
If it is determined that the data type of the data type and target data source in source data source is inconsistent, first will be met
Data type of the data type conversion of the data of condition for target data source;
The data storage for meeting first condition after by data type conversion to target data source, and from source data
The data for meeting first condition are deleted in source.
It can be seen from the above:In the embodiment of the present application, received by unified access interface unit
After the access request that service application sends, according to the attribute information of the data to be visited included in access request,
It is determined that at least one data source of storage data to be visited;According to data to be visited and at least one data source,
Determine the corresponding mission bit stream of each data source at least one data source, and the mission bit stream for determining is sent
Give mission bit stream corresponding data source;In receiving at least one data source, each data source performs each data source
The initial data returned after corresponding mission bit stream;According to each initial data, data to be output are determined,
And data to be output are returned to into service application.Thus, any one service application can only by unified access
Interface sends access request, you can access the data at least one data source of storage data to be visited, can
See, the developer of service application is familiar only with the make of access request, need not pay close attention to each data
The concrete operations environment in source, reduces the skill set requirements degree of the developer to service application, simplifies visit
The method for asking data in data source, improves data access efficiency.
Fig. 5 illustrates the structural representation of another kind of DAA of the embodiment of the present application offer
Figure.
Based on same idea, the embodiment of the present application provides a kind of DAA, as shown in figure 5, including
Processor 500, transmitter 510, receiver 530, memorizer 520:
Processor, for reading the program in memorizer, performs following process:
After the access request of service application transmission is received by unified access interface unit, please according to accessing
The attribute information of the data to be visited included in asking, it is determined that at least one data source of storage data to be visited;
According to data to be visited and at least one data source, each data source pair at least one data source is determined
The mission bit stream answered, and the mission bit stream of determination is sent to into the corresponding data source of mission bit stream;
Each data source at least one data source is received by receiver and performs corresponding of each data source
The initial data returned after business information;
According to each initial data, determine data to be output, and data to be output are returned to by transmitter
Service application.
Wherein, in Figure 5, bus architecture can include any number of interconnection bus and bridge, specifically by
The various circuits of the memorizer that the one or more processors and memorizer that processor is represented are represented are linked at one
Rise.Bus architecture can also by such as ancillary equipment, manostat and management circuit or the like it is various its
He links together circuit, these be all it is known in the art, therefore, no longer enter traveling one herein to which
Step description.EBI provides interface.Transmitter and receiver can be multiple elements, i.e., including transmitter
With transmitter and receiver, there is provided for the unit for communicating with various other devices over a transmission medium.Process
Device is responsible for bus architecture and common process, and memorizer can store processor and be made when operation is performed
Data.
Alternatively, the attribute information of data to be visited includes instance identification of the data to be visited in data source;
Processor, specifically for:
According to the instance identification and the corresponding relation of data source of data, the number to be visited that attribute information is included is determined
According to corresponding at least one data source of instance identification.
Alternatively, the attribute information of data to be visited includes business mark of the data to be visited in service application
Know;
Processor, specifically for:
The corresponding relation of the instance identification according to the service identification and data of data in data source, determines attribute
The corresponding instance identification of service identification of the data to be visited that packet contains;
According to the instance identification and the corresponding relation of data source of data, the instance identification pair of data to be visited is determined
At least one data source answered.
Alternatively, processor, for each data source at least one data source, specifically for:
If it is determined that the data type of access request is inconsistent with the data type of the data source, then according to access
The corresponding relation of the data type of request and the data type of data source, by the data type conversion of access request
For the data type of the data source, the corresponding mission bit stream of the data source is obtained;
If it is determined that the data type of access request is consistent with the data type of corresponding data source, then will access
Request is used as the corresponding mission bit stream of the data source.
Alternatively, however, it is determined that the data source for going out to store data to be visited is at least two, processor, for extremely
Each data source in a few data source, specifically for:
If it is determined that the data source of storage data to be visited is at least two, perform for each data source following
Step:
The partial data of the data to be visited stored by the data source according to determining, generates the data source pair
The operation information answered;Wherein, the part number of the data to be visited stored in including the data source by operation information
According to attribute information;
If it is determined that the data type of the corresponding operation information of the data source is consistent with the data type of the data source,
Then using the data source corresponding operation information as the corresponding mission bit stream of the data source;
If it is determined that the data type of the corresponding operation information of the data source is differed with the data type of the data source
Cause, then the corresponding relation according to the data type of access request and the data type of data source, by the data source
The data type conversion of corresponding operation information is the data type of the data source, obtains the data source corresponding
Mission bit stream.
Alternatively, processor, specifically for:
If it is determined that data manipulation need not be carried out to initial data, and in the coded format and business of initial data
Using coded format it is inconsistent when, the coded format of initial data is converted to into the coding lattice of service application
Formula, obtains data to be output;
If it is determined that data manipulation need not be carried out to initial data, and in the coded format and business of initial data
Using coded format it is consistent when, using initial data as data to be output;
If it is determined that need to carry out initial data data manipulation, and the coded format in initial data should with business
When coded format is inconsistent, the coded format of the data obtained after carrying out data manipulation to initial data
The coded format of service application is converted to, data to be output are obtained;
If it is determined that need to carry out initial data data manipulation, and the coded format in initial data should with business
When coded format is consistent, the data obtained after carrying out data manipulation to initial data are used as number to be output
According to.
Alternatively, if meeting the one kind in following condition, it is determined that need to carry out data manipulation:
It is determined that the data source at least two, access request of storage data to be visited includes indicating to be visited
Information that data are ranked up, access request include that it is to be viewed to indicate the format setting of data to be visited
The information of form;
Data manipulation is carried out according to following manner:
If it is determined that the data source at least two of storage data to be visited, then by the original of each data source return
Data are collected;
If access request includes the information for indicating to be ranked up data to be visited, each data source is returned
The initial data for returning is ranked up;
If access request includes indicating by the information that the format setting of data to be visited is form to be viewed,
The format setting of the initial data that each data source is returned is the form to be viewed that access request includes.
Alternatively, processor, is additionally operable to:
The data in data source are managed according to management configured information, and will be received according to management configured information
To the new corresponding data source of data of new data Cun Chudao in.
Alternatively, managing configured information includes indicating the data for meeting first condition are moved from source data source
To the information of target data source;
Processor, specifically for:The data for meeting first condition are determined from source data source;
If it is determined that the data type of the data type and target data source in source data source is inconsistent, first will be met
Data type of the data type conversion of the data of condition for target data source;
The data storage for meeting first condition after by data type conversion to target data source, and from source data
The data for meeting first condition are deleted in source.
Alternatively, receiver, is additionally operable to:Service application transmission is being received by unified access interface unit
Access request before, receive service application send ID;
It can be seen from the above:In the visit that service application transmission is received by unified access interface unit
After asking request, according to the attribute information of the data to be visited included in access request, it is determined that storage number to be visited
According at least one data source;According to data to be visited and at least one data source, at least one data are determined
The corresponding mission bit stream of each data source in source, and it is corresponding that the mission bit stream of determination is sent to mission bit stream
Data source;Receive each data source at least one data source perform the corresponding mission bit stream of each data source it
The initial data for returning afterwards;According to each initial data, determine data to be output, and data to be output are returned
Back to service application.Thus, any one service application only can send access request by unified access interface,
Data i.e. at least one data source of accessible storage data to be visited, it is seen then that the exploitation of service application
Personnel are familiar only with the make of access request, need not pay close attention to the concrete operations environment of each data source,
The skill set requirements degree of the developer to service application is reduced, the side for accessing data in data source is simplified
Method, improves data access efficiency.
Those skilled in the art are it should be appreciated that embodiments herein can be provided as method or computer journey
Sequence product.Therefore, the application can adopt complete hardware embodiment, complete software embodiment or combine software
With the form of the embodiment of hardware aspect.And, the application can wherein include meter using at one or more
Calculation machine usable program code computer-usable storage medium (including but not limited to disk memory,
CD-ROM, optical memory etc.) on the form of computer program implemented.
The application be with reference to according to the method for the embodiment of the present application, equipment (system), and computer program produce
The flow chart and/or block diagram of product is describing.It should be understood that can by computer program instructions flowchart and
/ or block diagram in each flow process and/or square frame and flow chart and/or the flow process in block diagram and/
Or the combination of square frame.These computer program instructions can be provided to general purpose computer, special-purpose computer, embedded
The processor of formula datatron or other programmable data processing devices is producing a machine so that by calculating
The instruction of the computing device of machine or other programmable data processing devices is produced for realizing in flow chart one
The device of the function of specifying in individual flow process or one square frame of multiple flow processs and/or block diagram or multiple square frames.
These computer program instructions may be alternatively stored in and computer or other programmable datas process can be guided to set
In the standby computer-readable memory for working in a specific way so that be stored in the computer-readable memory
Instruction produce and include the manufacture of command device, command device realization is in one flow process or multiple of flow chart
The function of specifying in one square frame of flow process and/or block diagram or multiple square frames.
These computer program instructions can be also loaded in computer or other programmable data processing devices, made
Obtain and series of operation steps is performed on computer or other programmable devices to produce computer implemented place
Reason, so as to the instruction performed on computer or other programmable devices is provided for realizing in flow chart one
The step of function of specifying in flow process or one square frame of multiple flow processs and/or block diagram or multiple square frames.
Although having been described for the preferred embodiment of the application, those skilled in the art once know base
This creative concept, then can make other change and modification to these embodiments.So, appended right will
Ask and be intended to be construed to include preferred embodiment and fall into the had altered of the application scope and change.
Obviously, those skilled in the art can carry out various changes and modification without deviating from this Shen to the application
Spirit and scope please.So, if the application these modification and modification belong to the application claim and
Within the scope of its equivalent technologies, then the application is also intended to comprising these changes and modification.
Claims (19)
1. a kind of data access method, it is characterised in that comprise the following steps:
After the access request of service application transmission is received by unified access interface unit, according to the visit
The attribute information of the data to be visited included in asking request, it is determined that at least one of the storage data to be visited
Data source;
According to the data to be visited and at least one data source, in determining at least one data source
The corresponding mission bit stream of each data source, and the mission bit stream for determining is sent to into the mission bit stream pair
The data source answered;
In receiving at least one data source, each data source performs the corresponding task of each data source
The initial data returned after information;
According to each initial data, determine data to be output, and the data to be output are returned to into institute
State service application.
2. the method for claim 1, it is characterised in that the attribute of the data to be visited
Information includes instance identification of the data to be visited in the data source;
The attribute information according to the data to be visited included in the access request, it is determined that treating described in storage
At least one data source of data is accessed, including:
According to the corresponding relation of the instance identification of data and data source, waiting of determining that the attribute information includes is visited
Ask corresponding at least one data source of the instance identification of data.
3. the method for claim 1, it is characterised in that the attribute of the data to be visited
Information includes service identification of the data to be visited in the service application;
The attribute information according to the data to be visited included in the access request, it is determined that treating described in storage
At least one data source of data is accessed, including:
The corresponding relation of the instance identification according to the service identification and data of data in data source, it is determined that described
The corresponding instance identification of the service identification of the data described to be visited that attribute information is included;
According to the instance identification and the corresponding relation of data source of data, the reality of the data to be visited is determined
Corresponding at least one data source of example mark.
4. the method as described in claims 1 to 3 any claim, it is characterised in that the basis
The data to be visited and at least one data source, determine each data at least one data source
The corresponding mission bit stream in source, including:
Following steps are performed for each data source at least one data source:
If it is determined that the data type of the access request is inconsistent with the data type of the data source, then basis
The corresponding relation of the data type of access request and the data type of data source, by the data of the access request
Type is converted to the data type of the data source, obtains the corresponding mission bit stream of the data source;
If it is determined that the data type of the access request is consistent with the data type of the data source, then will be described
Access request is used as the corresponding mission bit stream of the described data source.
5. the method as described in claims 1 to 3 any claim, it is characterised in that the basis
The data to be visited and at least one data source, determine each data at least one data source
The corresponding mission bit stream in source, including:
If it is determined that the data source of the storage data to be visited is at least two, for described at least one number
Following steps are performed according to each data source in source:
The partial data of the data described to be visited stored by the data source according to determining, generates the data
The corresponding operation information in source;Wherein, what the operation information was stored in including the data source is described to be visited
The attribute information of the partial data of data;
If it is determined that the data type of the data type of the corresponding operation information of the data source and the data source
Unanimously, then using the data source corresponding operation information as the corresponding mission bit stream of the data source;
If it is determined that the data type of the data type of the corresponding operation information of the data source and the data source
Inconsistent, then the data type and the corresponding relation of the data type of data source according to access request, this is counted
According to the data type that the data type conversion of the corresponding operation information in source is the data source, the data are obtained
The corresponding mission bit stream in source.
6. the method as described in claim 1 to 5 any claim, it is characterised in that the basis
Each described initial data, determines data to be output, including:
If it is determined that data manipulation need not be carried out to the initial data, and in the coding lattice of the initial data
When formula is inconsistent with the coded format of the service application, the coded format of the initial data is converted to into institute
The coded format of service application is stated, the data to be output are obtained;
If it is determined that data manipulation need not be carried out to the initial data, and in the coding lattice of the initial data
When formula is consistent with the coded format of the service application, using the initial data as the data to be output;
If it is determined that need to carry out the initial data data manipulation, and in the coded format of the initial data
When inconsistent with the coded format of the service application, will obtain after carrying out data manipulation to the initial data
The coded format of data be converted to the coded format of the service application, obtain the data to be output;
If it is determined that need to carry out the initial data data manipulation, and in the coded format of the initial data
When consistent with the coded format of the service application, obtain after data manipulation being carried out to the initial data
Data are used as the data to be output.
7. method as claimed in claim 6, it is characterised in that if meeting the one kind in following condition,
Then determining needs to carry out data manipulation:
It is determined that the data source at least two of the storage data to be visited, the access request include indicating
The information that is ranked up to the data to be visited, the access request include indicating the number to be visited
According to format setting be form to be viewed information;
Data manipulation is carried out according to following manner:
If it is determined that the data source at least two of the storage data to be visited, then return each described data source
The initial data for returning is collected;
If the access request includes the information for indicating to be ranked up the data to be visited, by each
The initial data that the data source is returned is ranked up;
If the access request includes indicating that by the format setting of the data to be visited be form to be viewed
Information, then the format setting of the initial data for returning each described data source is the access request
The form described to be viewed for including.
8. the method as described in claim 1 to 7 any claim, it is characterised in that also include:
The data in data source are managed according to management configured information, and according to the management configured information
By in the corresponding data source of data new described in new data Cun Chudao for receiving.
9. method as claimed in claim 8, it is characterised in that the management configured information includes referring to
Show and move the data for meeting first condition to the information of target data source from source data source;
It is described the data in data source to be managed according to management configured information, including:
The data for meeting the first condition are determined from the source data source;
If it is determined that the data type of the data type and the target data source in the source data source is inconsistent, will
The data type conversion for meeting the data of the first condition is the data type of the target data source;
The data storage for meeting the first condition after by data type conversion to the target data source, and
The data for meeting the first condition are deleted from source data source.
10. a kind of DAA, it is characterised in that include:
Receiving unit, for the access request of service application transmission is received by unified access interface unit;
Receive after each data source at least one data source performs the corresponding mission bit stream of each data source
The initial data of return;
Determining unit, in the access request that service application transmission is received by unified access interface unit
Afterwards, the attribute information according to the data to be visited included in the access request, it is determined that storage is described to be visited
At least one data source of data;According to the data to be visited and at least one data source, really
The corresponding mission bit stream of each data source in fixed at least one data source, and the task for determining is believed
Breath is sent to the corresponding data source of the mission bit stream;According to each initial data, number to be output is determined
According to;
Transmitting element, for the data to be output are returned to the service application.
11. devices as claimed in claim 10, it is characterised in that the category of the data to be visited
Property information includes instance identification of the data to be visited in the data source;
The determining unit, specifically for:
According to the corresponding relation of the instance identification of data and data source, waiting of determining that the attribute information includes is visited
Ask corresponding at least one data source of the instance identification of data.
12. devices as claimed in claim 10, it is characterised in that the category of the data to be visited
Property information includes service identification of the data to be visited in the service application;
The determining unit, specifically for:
The corresponding relation of the instance identification according to the service identification and data of data in data source, it is determined that described
The corresponding instance identification of the service identification of the data described to be visited that attribute information is included;
According to the instance identification and the corresponding relation of data source of data, the reality of the data to be visited is determined
Corresponding at least one data source of example mark.
13. devices as described in claim 10 to 12 any claim, it is characterised in that described true
Order unit, for each data source at least one data source, specifically for:
If it is determined that the data type of the access request is inconsistent with the data type of the data source, then basis
The corresponding relation of the data type of access request and the data type of data source, by the data of the access request
Type is converted to the data type of the data source, obtains the corresponding mission bit stream of the data source;
If it is determined that the data type of the access request is consistent with the data type of the corresponding data source,
Then using the access request as the corresponding mission bit stream of the data source.
14. devices as described in claim 10 to 12 any claim, it is characterised in that if it is determined that
The data source for going out to store the data to be visited is at least two, the determining unit, for described at least
Each data source in individual data source, specifically for:
The partial data of the data described to be visited stored by the data source according to determining, generates the data
The corresponding operation information in source;Wherein, what the operation information was stored in including the data source is described to be visited
The attribute information of the partial data of data;
If it is determined that the data type of the data type of the corresponding operation information of the data source and the data source
Unanimously, then using the data source corresponding operation information as the corresponding mission bit stream of the data source;
If it is determined that the data type of the data type of the corresponding operation information of the data source and the data source
Inconsistent, then the data type and the corresponding relation of the data type of data source according to access request, this is counted
According to the data type that the data type conversion of the corresponding operation information in source is the data source, the data are obtained
The corresponding mission bit stream in source.
15. devices as described in claim 10 to 14 any claim, it is characterised in that described true
Order unit, specifically for:
If it is determined that data manipulation need not be carried out to the initial data, and in the coding lattice of the initial data
When formula is inconsistent with the coded format of the service application, the coded format of the initial data is converted to into institute
The coded format of service application is stated, the data to be output are obtained;
If it is determined that data manipulation need not be carried out to the initial data, and in the coding lattice of the initial data
When formula is consistent with the coded format of the service application, using the initial data as the data to be output;
If it is determined that need to carry out the initial data data manipulation, and in the coded format of the initial data
When inconsistent with the coded format of the service application, will obtain after carrying out data manipulation to the initial data
The coded format of data be converted to the coded format of the service application, obtain the data to be output;
If it is determined that need to carry out the initial data data manipulation, and in the coded format of the initial data
When consistent with the coded format of the service application, obtain after data manipulation being carried out to the initial data
Data are used as the data to be output.
16. devices as claimed in claim 15, it is characterised in that if meeting the one kind in following condition,
Then determining needs to carry out data manipulation:
It is determined that the data source at least two of the storage data to be visited, the access request include indicating
The information that is ranked up to the data to be visited, the access request include indicating the number to be visited
According to format setting be form to be viewed information;
Data manipulation is carried out according to following manner:
If it is determined that the data source at least two of the storage data to be visited, then return each described data source
The initial data for returning is collected;
If the access request includes the information for indicating to be ranked up the data to be visited, by each
The initial data that the data source is returned is ranked up;
If the access request includes indicating that by the format setting of the data to be visited be form to be viewed
Information, then the format setting of the initial data for returning each described data source is the access request
The form described to be viewed for including.
17. devices as described in claim 10 to 16 any claim, it is characterised in that also include
Administrative unit, is used for:
The data in data source are managed according to management configured information, and according to the management configured information
By in the corresponding data source of data new described in new data Cun Chudao for receiving.
18. devices as claimed in claim 17, it is characterised in that the management configured information includes
Instruction moves the data for meeting first condition to the information of target data source from source data source;
The administrative unit, specifically for:
The data for meeting the first condition are determined from the source data source;
If it is determined that the data type of the data type and the target data source in the source data source is inconsistent, will
The data type conversion for meeting the data of the first condition is the data type of the target data source;
The data storage for meeting the first condition after by data type conversion to the target data source, and
The data for meeting the first condition are deleted from source data source.
19. a kind of DAAs, it is characterised in that include:
Processor, for reading the program in memorizer, performs following process:
After the access request of service application transmission is received by unified access interface unit, according to the visit
The attribute information of the data to be visited included in asking request, it is determined that at least one of the storage data to be visited
Data source;
According to the data to be visited and at least one data source, in determining at least one data source
The corresponding mission bit stream of each data source, and the mission bit stream for determining is sent to into the mission bit stream pair
The data source answered;
In receiving at least one data source, each data source performs the corresponding task of each data source
The initial data returned after information;
According to each initial data, determine data to be output, and the data to be output are returned to into institute
State service application.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201510601348.0A CN106547766A (en) | 2015-09-18 | 2015-09-18 | A kind of data access method and device |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201510601348.0A CN106547766A (en) | 2015-09-18 | 2015-09-18 | A kind of data access method and device |
Publications (1)
Publication Number | Publication Date |
---|---|
CN106547766A true CN106547766A (en) | 2017-03-29 |
Family
ID=58362507
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201510601348.0A Pending CN106547766A (en) | 2015-09-18 | 2015-09-18 | A kind of data access method and device |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN106547766A (en) |
Cited By (18)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN107391622A (en) * | 2017-07-06 | 2017-11-24 | 联动优势科技有限公司 | A kind of data access method and equipment |
CN108021369A (en) * | 2017-12-21 | 2018-05-11 | 马上消费金融股份有限公司 | Data integration processing method and related device |
CN108256046A (en) * | 2018-01-12 | 2018-07-06 | 福建星瑞格软件有限公司 | The implementation method of the unified access path of big data processing frame source data |
CN108563772A (en) * | 2018-04-20 | 2018-09-21 | 郑州市轨道交通有限公司 | Inter-system data sharing method based on general-purpose interface |
WO2018196650A1 (en) * | 2017-04-26 | 2018-11-01 | 平安科技(深圳)有限公司 | User feature data acquisition method and device, server, and medium |
CN108809900A (en) * | 2017-05-02 | 2018-11-13 | 武汉斗鱼网络科技有限公司 | A kind of frame and method of unified resource access |
CN109560895A (en) * | 2018-12-27 | 2019-04-02 | 北京百佑科技有限公司 | Data transmission method and device |
CN110309214A (en) * | 2018-04-10 | 2019-10-08 | 腾讯科技(深圳)有限公司 | A kind of instruction executing method and its equipment, storage medium, server |
CN110309213A (en) * | 2018-03-28 | 2019-10-08 | 腾讯科技(深圳)有限公司 | A kind of Access and control strategy of database method, apparatus, system, medium and equipment |
CN110489471A (en) * | 2019-07-25 | 2019-11-22 | 北京文渊佳科技有限公司 | A kind of data request processing method, apparatus, storage medium and server |
CN110555178A (en) * | 2019-08-28 | 2019-12-10 | 贝壳技术有限公司 | Data proxy method and device |
WO2020082875A1 (en) * | 2018-10-26 | 2020-04-30 | 阿里巴巴集团控股有限公司 | Blockchain-based cross-chain data access method and apparatus |
CN111240733A (en) * | 2020-01-21 | 2020-06-05 | 深圳市优必选科技股份有限公司 | Data acquisition method and device based on multiple third-party interfaces |
CN111680108A (en) * | 2019-03-11 | 2020-09-18 | 杭州海康威视数字技术股份有限公司 | Data storage method and device and data acquisition method and device |
CN112307122A (en) * | 2020-10-30 | 2021-02-02 | 杭州海康威视数字技术股份有限公司 | Data lake-based data management system and method |
CN112559447A (en) * | 2020-12-24 | 2021-03-26 | 光大兴陇信托有限责任公司 | Interface metadata management system based on distributed file system |
CN112632114A (en) * | 2019-10-08 | 2021-04-09 | 中国移动通信集团辽宁有限公司 | Method and device for MPP database to quickly read data and computing equipment |
US11797557B2 (en) | 2020-12-03 | 2023-10-24 | Boe Technology Group Co., Ltd. | Data management platform, intelligent defect analysis system, intelligent defect analysis method, computer-program product, and method for defect analysis |
Citations (4)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US20110082889A1 (en) * | 2009-10-07 | 2011-04-07 | Oracle International Corporation | Online database modeling |
CN102521387A (en) * | 2011-12-21 | 2012-06-27 | 北京人大金仓信息技术股份有限公司 | Plug-in-based data migration method |
CN103440303A (en) * | 2013-08-21 | 2013-12-11 | 曙光信息产业股份有限公司 | Heterogeneous cloud storage system and data processing method thereof |
CN103916368A (en) * | 2012-12-31 | 2014-07-09 | 中国移动通信集团公司 | Method and apparatus for realizing data processing among different data sources |
-
2015
- 2015-09-18 CN CN201510601348.0A patent/CN106547766A/en active Pending
Patent Citations (4)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US20110082889A1 (en) * | 2009-10-07 | 2011-04-07 | Oracle International Corporation | Online database modeling |
CN102521387A (en) * | 2011-12-21 | 2012-06-27 | 北京人大金仓信息技术股份有限公司 | Plug-in-based data migration method |
CN103916368A (en) * | 2012-12-31 | 2014-07-09 | 中国移动通信集团公司 | Method and apparatus for realizing data processing among different data sources |
CN103440303A (en) * | 2013-08-21 | 2013-12-11 | 曙光信息产业股份有限公司 | Heterogeneous cloud storage system and data processing method thereof |
Cited By (28)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
WO2018196650A1 (en) * | 2017-04-26 | 2018-11-01 | 平安科技(深圳)有限公司 | User feature data acquisition method and device, server, and medium |
CN108809900B (en) * | 2017-05-02 | 2021-09-07 | 武汉斗鱼网络科技有限公司 | Framework and method for unified resource access |
CN108809900A (en) * | 2017-05-02 | 2018-11-13 | 武汉斗鱼网络科技有限公司 | A kind of frame and method of unified resource access |
CN107391622A (en) * | 2017-07-06 | 2017-11-24 | 联动优势科技有限公司 | A kind of data access method and equipment |
CN108021369A (en) * | 2017-12-21 | 2018-05-11 | 马上消费金融股份有限公司 | Data integration processing method and related device |
CN108021369B (en) * | 2017-12-21 | 2020-10-16 | 马上消费金融股份有限公司 | Data integration processing method and related device |
CN108256046A (en) * | 2018-01-12 | 2018-07-06 | 福建星瑞格软件有限公司 | The implementation method of the unified access path of big data processing frame source data |
CN110309213A (en) * | 2018-03-28 | 2019-10-08 | 腾讯科技(深圳)有限公司 | A kind of Access and control strategy of database method, apparatus, system, medium and equipment |
CN110309213B (en) * | 2018-03-28 | 2023-10-13 | 腾讯科技(深圳)有限公司 | Database access control method, device, system, medium and equipment |
CN110309214A (en) * | 2018-04-10 | 2019-10-08 | 腾讯科技(深圳)有限公司 | A kind of instruction executing method and its equipment, storage medium, server |
CN110309214B (en) * | 2018-04-10 | 2023-06-23 | 腾讯科技(深圳)有限公司 | Instruction execution method and equipment, storage medium and server thereof |
CN108563772A (en) * | 2018-04-20 | 2018-09-21 | 郑州市轨道交通有限公司 | Inter-system data sharing method based on general-purpose interface |
US11126683B2 (en) | 2018-10-26 | 2021-09-21 | Advanced New Technologies Co., Ltd. | Blockchain-based cross-chain data access method and apparatus |
WO2020082875A1 (en) * | 2018-10-26 | 2020-04-30 | 阿里巴巴集团控股有限公司 | Blockchain-based cross-chain data access method and apparatus |
CN109560895A (en) * | 2018-12-27 | 2019-04-02 | 北京百佑科技有限公司 | Data transmission method and device |
CN111680108A (en) * | 2019-03-11 | 2020-09-18 | 杭州海康威视数字技术股份有限公司 | Data storage method and device and data acquisition method and device |
CN111680108B (en) * | 2019-03-11 | 2023-11-03 | 杭州海康威视数字技术股份有限公司 | Data storage method and device and data acquisition method and device |
CN110489471A (en) * | 2019-07-25 | 2019-11-22 | 北京文渊佳科技有限公司 | A kind of data request processing method, apparatus, storage medium and server |
CN110555178B (en) * | 2019-08-28 | 2020-07-21 | 贝壳找房(北京)科技有限公司 | Data proxy method and device |
CN110555178A (en) * | 2019-08-28 | 2019-12-10 | 贝壳技术有限公司 | Data proxy method and device |
CN112632114A (en) * | 2019-10-08 | 2021-04-09 | 中国移动通信集团辽宁有限公司 | Method and device for MPP database to quickly read data and computing equipment |
CN112632114B (en) * | 2019-10-08 | 2024-03-19 | 中国移动通信集团辽宁有限公司 | Method, device and computing equipment for fast reading data by MPP database |
CN111240733A (en) * | 2020-01-21 | 2020-06-05 | 深圳市优必选科技股份有限公司 | Data acquisition method and device based on multiple third-party interfaces |
CN112307122A (en) * | 2020-10-30 | 2021-02-02 | 杭州海康威视数字技术股份有限公司 | Data lake-based data management system and method |
CN112307122B (en) * | 2020-10-30 | 2023-06-02 | 杭州海康威视数字技术股份有限公司 | Data lake-based data management system and method |
US11797557B2 (en) | 2020-12-03 | 2023-10-24 | Boe Technology Group Co., Ltd. | Data management platform, intelligent defect analysis system, intelligent defect analysis method, computer-program product, and method for defect analysis |
CN112559447A (en) * | 2020-12-24 | 2021-03-26 | 光大兴陇信托有限责任公司 | Interface metadata management system based on distributed file system |
CN112559447B (en) * | 2020-12-24 | 2023-01-31 | 光大兴陇信托有限责任公司 | Interface metadata management system based on distributed file system |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN106547766A (en) | A kind of data access method and device | |
CN105956082B (en) | Real time data processing and storage system | |
US11086894B1 (en) | Dynamically updated data sheets using row links | |
US11816100B2 (en) | Dynamically materialized views for sheets based data | |
CN106055584B (en) | Manage data query | |
AU2016359060B2 (en) | Storing and retrieving data of a data cube | |
CN105912949B (en) | Data permission management method, data right management system and business management system | |
CN108874971B (en) | Tool and method applied to mass tagged entity data storage | |
CN108038222B (en) | System of entity-attribute framework for information system modeling and data access | |
CN105408857B (en) | Data warehouse, production Methods database multiple row index method and system | |
Karnitis et al. | Migration of relational database to document-oriented database: structure denormalization and data transformation | |
CN102982075B (en) | Support to access the system and method for heterogeneous data source | |
CN103631596B (en) | Business object data typing and the configuration device and collocation method for updating rule | |
US10268645B2 (en) | In-database provisioning of data | |
US20150199378A1 (en) | Method and apparatus for realizing a dynamically typed file or object system enabling a user to perform calculations over the fields associated with the files or objects in the system | |
CN101438280A (en) | Managing related data objects | |
CN106599164A (en) | Support for a parameterized query/view in complex event processing | |
CN103646049B (en) | The method and system of automatically generated data form | |
CN109656963A (en) | Metadata acquisition methods, device, equipment and computer readable storage medium | |
CN103189866B (en) | Support for a parameterized query/view in complex event processing | |
US20080263078A1 (en) | Runtime class database operation | |
CN112930529A (en) | Generating software artifacts from conceptual data models | |
EP2965492B1 (en) | Selection of data storage settings for an application | |
JP5075653B2 (en) | Database management method, database management apparatus, database management program, and database system | |
CN106599241A (en) | Big data visual management method for GIS software |
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 | ||
RJ01 | Rejection of invention patent application after publication |
Application publication date: 20170329 |
|
RJ01 | Rejection of invention patent application after publication |