CN107515866A - A kind of data manipulation method, device and system - Google Patents
A kind of data manipulation method, device and system Download PDFInfo
- Publication number
- CN107515866A CN107515866A CN201610424587.8A CN201610424587A CN107515866A CN 107515866 A CN107515866 A CN 107515866A CN 201610424587 A CN201610424587 A CN 201610424587A CN 107515866 A CN107515866 A CN 107515866A
- Authority
- CN
- China
- Prior art keywords
- data source
- target
- data
- attribute
- label
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Granted
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/27—Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor
-
- 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/258—Data format conversion from or to a database
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)
- Computing Systems (AREA)
- User Interface Of Digital Computer (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The embodiment of the invention discloses a kind of data manipulation method, device and system, in the data system with variety classes data source, it is respectively processed using data content as according to the data to the variety classes data source, to obtain each self-corresponding tag set of the variety classes data source, the data source label included by tag set, multiple business object labels and multiple attribute tags mark corresponding data source and business object and attribute in the data source.The unified definition to data content in variety classes data source can be realized by way of tag set, user is when in face of data system with variety classes data source, data operation request only need to be sent according to this unified definition mode, the data of each data source in the data system can be operated, and obtain corresponding operating result, the operability of this data system with variety classes data source is improved, is more conducively promoted.
Description
Technical field
The present invention relates to data processing field, more particularly to a kind of data manipulation method, device and system.
Background technology
With the development of big data, the species of data source is more and more.Typically pass through the interface of data source in traditional approach
The species of type classification data source, the data source with same-interface type are the data source of identical type, otherwise are not of the same race
The data source of class, such as real-time data base, lot data storehouse and stream data storehouse can be three different types of data sources.No
Differed with storage of the species data source to data, description, mode of operation.
In order to meet the use demand to data resource, variety classes data source may be needed to use in a data system
Data.For the user of data system, in order to realize the data of processing different data sources, it is necessary to learn difference
The data manipulation method of data source, to carry out processing operation to the data being stored in different data sources, if desired to difference
Mutual operation is carried out between species data source, the user of data system also needs to learn again and uses other linking instruments, with
Just the operation such as interrelated, duplication stickup between progress variety classes data source.
It can be seen that to the complex operation of this data system with variety classes data source, at least need additional studies every
The data manipulation method of one species data source, highly dependent upon the personal experience of user, data processing does not have stability, no
Beneficial to the popularization of this data system.
The content of the invention
In order to solve the above-mentioned technical problem, the invention provides a kind of data manipulation method, device and system, this is improved
The operability of kind data system, is more conducively promoted.
The embodiment of the invention discloses following technical scheme：
A kind of data operation system, the data operation system include user equipment, server, the first data source and second
Data source, first data source and the second data source are different types of data source in data system：
The server, for distinguishing using data content as according to the data of first data source and the second data source
Handled, tag set corresponding to tag set corresponding to first data source and the second data source is obtained by processing；
Wherein, the processing for the first data source is specially：Using data content as according to the data of first data source
Reason；Tag set corresponding to first data source is obtained by the processing, wrapped in the tag set of first data source
Include for position first data source data source label, the industry for positioning target service object in first data source
The attribute tags of object tag of being engaged in and the objective attribute target attribute for positioning the target service object；
The user equipment, for sending data operation request to the server, the data operation request includes institute
State the identifying of the first data source, the identifying of the target service object, the mark and operational requirements of the objective attribute target attribute；
The server determines institute when receiving the data operation request, according to the mark of first data source
State the tag set of the first data source；According to the mark of the target service object and the mark of the objective attribute target attribute from described the
The business object label and the attribute tags are transferred in the tag set of one data source；Determined according to the data source label
Go out access position of first data source in the data system, the target is determined according to the business object label
Storage location of the business object in first data source, determine the objective attribute target attribute described according to the attribute tags
Storage location in first data source；The target service object and mesh are obtained according to the access position determined and storage location
Mark attribute；Data manipulation is carried out to the target service object and objective attribute target attribute according to the operational requirements, obtains operating result.
A kind of data manipulation method, applied in the data system with variety classes data source, using data content as according to
It is respectively processed according to the data to the variety classes data source, it is each right to obtain the variety classes data source by processing
The tag set answered；Wherein, the processing for target data source is specially：Using data content as according to the target data source
Data handled, the target data source be the variety classes data source in a data source；Pass through the processing
Tag set corresponding to the target data source is obtained, the tag set of the target data source includes being used to identify the mesh
Mark the data source label of data source, multiple be used to identifying the business object label of business object in the target data source and multiple
For identifying the attribute tags of business object association attributes in the target data source, methods described includes：
Data operation request is obtained, the data operation request includes mark, the target service pair of the target data source
The mark of elephant, the mark of objective attribute target attribute and operational requirements；
The tag set of the target data source is determined according to the mark of the target data source；According to the target industry
The mark of business object and the mark of the objective attribute target attribute transfer the target service from the tag set of the target data source
Label corresponding to label corresponding to object and the objective attribute target attribute；
Data source label in the target data source tag set determines the target data source in the number
According to the access position in system, determine the target service object described according to label corresponding to the target service object
Storage location in target data source, the label according to corresponding to objective attribute target attribute determine the objective attribute target attribute in the target data
Storage location in source；
The target service object and objective attribute target attribute are obtained according to the access position determined and storage location；
Data manipulation is carried out to the target service object and objective attribute target attribute according to the operational requirements, obtains operation knot
Fruit.
Optionally, mark and the target data source of the data source label including the target data source are in the number
According to the access position in system；Target service object tag includes the mark of target service object and the target service object exists
Storage location in the target data source, the target service object tag are one in the multiple business object label
Business object label；Mark and the objective attribute target attribute of the objective attribute target attribute label including objective attribute target attribute are in the target data source
Storage location, the objective attribute target attribute label be the multiple attribute tags in an attribute tags, the objective attribute target attribute be with
An attribute in the target service object association attributes.
Optionally, the data source the label also species including the target data source, access rights and access interface letter
Breath.
Optionally, the data operation request also includes presentation parameter, it is described according to the operational requirements to the mesh
Mark business object and objective attribute target attribute carries out data manipulation, after obtaining operating result, in addition to：
The operating result is shown to the sender of the data operation request according to the presentation parameter.
Optionally, the data operation request also includes return parameters, and the return parameters include echo plex mode and return
Position, data manipulation is carried out to the target service object and objective attribute target attribute according to the operational requirements described, operated
As a result after, in addition to：
Returned with the echo plex mode to the home position by the operating result.
A kind of data operation device, applied in the data system with variety classes data source, described device includes：
Processing unit, for being respectively processed using data content as according to the data to the variety classes data source；
Label acquiring unit, for obtaining each self-corresponding tag set of the variety classes data source by processing；Its
In, the processing for target data source is specially：
The processing unit is specifically used for handling using data content as according to the data to the target data source, institute
Target data source is stated as a data source in the variety classes data source；
The label acquiring unit is specifically used for obtaining tag set corresponding to the target data source by the processing,
The tag set of the target data source include be used for identify the target data source data source label, it is multiple be used for identify
In the target data source business object label of business object and it is multiple be used for identify business object in the target data source
The attribute tags of association attributes；
Acquisition request unit, for obtaining data operation request, the data operation request includes the target data source
Mark, the mark of target service object, the mark of objective attribute target attribute and operational requirements；
First determining unit, for determining the tally set of the target data source according to the mark of the target data source
Close；According to the mark of the target service object and the mark of the objective attribute target attribute from the tag set of the target data source
Transfer label corresponding to label corresponding to the target service object and the objective attribute target attribute；
Second determining unit, the mesh is determined for the data source label in the target data source tag set
Access position of the data source in the data system is marked, the mesh is determined according to label corresponding to the target service object
Storage location of the business object in the target data source is marked, the label according to corresponding to objective attribute target attribute determines the target category
Storage location of the property in the target data source；The target service is obtained according to the access position determined and storage location
Object and objective attribute target attribute；
Operating unit, for carrying out data behaviour to the target service object and objective attribute target attribute according to the operational requirements
Make, obtain operating result.
Optionally, mark and the target data source of the data source label including the target data source are in the number
According to the access position in system；Target service object tag includes the mark of target service object and the target service object exists
Storage location in the target data source, the target service object tag are one in the multiple business object label
Business object label；Mark and the objective attribute target attribute of the objective attribute target attribute label including objective attribute target attribute are in the target data source
Storage location, the objective attribute target attribute label be the multiple attribute tags in an attribute tags, the objective attribute target attribute be with
An attribute in the target service object association attributes.
Optionally, the data source the label also species including the target data source, access rights and access interface letter
Breath.
Optionally, the data operation request also includes presentation parameter, in addition to：
Display unit, for being tied according to the sender displaying operation of the presentation parameter to the data operation request
Fruit.
Optionally, the data operation request also includes return parameters, and the return parameters include echo plex mode and return
Position, in addition to：
Returning unit, for being returned with the echo plex mode to the home position by the operating result.
It can be seen from above-mentioned technical proposal in the data system with variety classes data source, using data content as
It is respectively processed according to the data to the variety classes data source, it is each self-corresponding to obtain the variety classes data source
Tag set, the data source label included by tag set, multiple business object labels and multiple attribute tags mark pair
Answer data source and business object and attribute in the data source.It can be realized by way of tag set unified to not of the same race
The definition of data content in class data source, user only need foundation when in face of data system with variety classes data source
This unified definition mode sends data operation request, you can the data of each data source in the data system are grasped
Make, and obtain corresponding operating result, improve the operability of this data system with variety classes data source, it is more sharp
In popularization.
Brief description of the drawings
In order to illustrate more clearly about the embodiment of the present invention or technical scheme of the prior art, below will be to embodiment or existing
There is the required accompanying drawing used in technology description to be briefly described, it should be apparent that, drawings in the following description are only this
Some embodiments of invention, for those of ordinary skill in the art, without having to pay creative labor, may be used also
To obtain other accompanying drawings according to these accompanying drawings.
Fig. 1 a are a kind of system construction drawing of data operation system provided in an embodiment of the present invention
Fig. 1 is a kind of method flow diagram of data processing method provided in an embodiment of the present invention；
Fig. 2 is a kind of method flow diagram of data manipulation method provided in an embodiment of the present invention；
Fig. 3 is a kind of structure drawing of device of data processing equipment provided in an embodiment of the present invention；
Fig. 4 is a kind of structure drawing of device of data operation device provided in an embodiment of the present invention.
Embodiment
To make the purpose, technical scheme and advantage of the embodiment of the present invention clearer, below in conjunction with the embodiment of the present invention
In accompanying drawing, the technical scheme in the embodiment of the present invention is explicitly described, it is clear that described embodiment be the present invention
Part of the embodiment, rather than whole embodiments.Based on the embodiment in the present invention, those of ordinary skill in the art are not having
The every other embodiment obtained under the premise of creative work is made, belongs to the scope of protection of the invention.
With the development of big data, the source of required processing data is more and more in data handling, in a data system
In system, the data of required processing may come from different types of data source.Typically can be from the type of data source external interface
On distinguish whether data source belongs to a kind of species.The interface type of different types of data source is different.The data source can be with
It is traditional types of databases, such as real-time data base, lot data storehouse and stream data storehouse can be three differences
The data source of species.The data source can also be stored in the text of data warehouse, NoSQL database (non-relationals
Database) etc..Storage of the variety classes data source to data, description, mode of operation differ.
This data system with multiple types of data source is referred to as isomeric data system, due to difference during use
The data source of species causes complex operation, and user needs to learn the data manipulation method of different data sources, sets data system
User also need to learn and use other linking instruments, so as to carry out between variety classes data source it is interrelated, replicate
The operation such as stickup.It can be seen that this isomeric data system, highly dependent upon the personal experience of user, data processing stability is not high, no
Beneficial to the popularization of this isomeric data system.
Inventor is had found, the unified definition of data in variety classes data source is described if can realize, behaviour is uniformly processed
It is described.The operation difficulty of this isomeric data system can be greatly simplified.
Therefore, the embodiments of the invention provide a kind of data manipulation method, device and system, with variety classes data
In the data system in source, it is respectively processed using data content as according to the data to the variety classes data source, to obtain
Each self-corresponding tag set of variety classes data source, the data source label included by tag set, multiple business
Object tag and multiple attribute tags mark corresponding data source and business object and attribute in the data source.Pass through tally set
The mode of conjunction can realize the unified definition to data content in variety classes data source, and user is in face of with variety classes
During the data system of data source, only data operation request need to be sent according to this unified definition mode, you can to the data system
The data of each data source are operated in system, and obtain corresponding operating result, and improving this has variety classes data
The operability of the data system in source, is more conducively promoted.
The embodiments of the invention provide a kind of data operation system, and as shown in Figure 1a, the data operation system can wrap
Include user equipment 10, server 20, the first data source 30 and the second data source 40.
First data source 30 and the second data source 40 are different types of data source in data system.Variety classes data source
The form of middle data generally differs, such as the data in data source a can be stored, grasped in the form of table structure
Make, and the data in data source b can be stored, operated in the form of a file.Needing by data source a and b
Data together carry out needs during data processing and carry out data call, processing by other linking instruments, and implementation process is complicated.
In order to realize that the unified definition to data in variety classes data source is handled, inventor has found, if not for another example
Focused data processing procedure in itself, and transfers operation of the concern to data content in traditional data processing mode, using closer to
The data manipulation language of data content, data are handled from logic level, by it is a kind of it is unified in a manner of establish Compatible object
Model attributes model, the content in model can be the label (English described in the embodiment of the present invention：Tag) gather, the mark
Label can be specially the forms such as field.By unified definition, when data operate in needing to data source, can obtain employment
Business work angle describes data handling procedure so that data processing code is more readable, and data manipulation logic is more directly perceived, operation
Instruct the statement closer to business demand.Processing to data in different data sources can be realized by server.Such as scheme
Server 20 in 1a
Server 20 can enter respectively using data content as according to the data to the first data source 30 and the second data source 40
Row processing, tag set corresponding to tag set corresponding to the first data source 30 and the second data source 40 is obtained by processing.Example
Data processing as indicated by the dashed line in fig 1A.
Wherein, the processing for the first data source 30 is specially：Using data content as according to the number to the first data source 30
According to being handled.Tag set corresponding to first data source 30, the tag set of the first data source 30 are obtained by the processing
Include being used for the data source label for positioning the first data source 30, the industry for positioning target service object in the first data source 30
The attribute tags of object tag of being engaged in and the objective attribute target attribute for positioning the target service object.
Because the data content unified definition for the different pieces of information structure that can realize multitype database system describes, at unification
Reason operation description.So that data content being read out with cross-system, associate, calculate, checking, check, the operation of write-in.
Therefore user equipment 10 need operate the first data source 30 in data when, user equipment 10 can be according to above-mentioned unification
Data definition, send data operation request to server 20, the data operation request includes the mark of first data source
Know, the identifying of the target service object, the mark and operational requirements of the objective attribute target attribute.
Server 20 determines the first number when receiving the data operation request, according to the mark of the first data source 30
According to the tag set in source 30；According to the mark of the target service object and the mark of the objective attribute target attribute from the first data source 30
Tag set in transfer the business object label and the attribute tags；First number is determined according to the data source label
According to access position of the source 30 in the data system, determine that the target service object exists according to the business object label
Storage location in first data source 30, determine the objective attribute target attribute in the first data source 30 according to the attribute tags
Storage location；The target service object and objective attribute target attribute are obtained according to the access position determined and storage location；According to institute
State operational requirements and data manipulation is carried out to the target service object and objective attribute target attribute, obtain operating result.
The data manipulation method that the embodiment of the present invention is provided, applied to the data system with variety classes data source
In, in the method, by being respectively processed to the data of the variety classes data source, to obtain the variety classes number
According to the tag set in source；The different types of data source of unified definition by way of tag set.
Wherein, for for a data source, specifically obtaining the side of tag set by processing in the data system
Formula may refer to Fig. 1.Processing for target data source specifically includes：
S101：Handled using data content as according to the data to the target data source, the target data source is
A data source in the variety classes data source.
S102：The tag set of the target data source, the tally set of the target data source are obtained by the processing
Conjunction includes data source label, multiple business object labels and multiple attribute tags, wherein, the data source label is used to identify
The target data source, including the mark of the target data source and access of the target data source in the data system
Position；Target service object tag is used to identify the target service object in the target data source, including the target service
The mark and storage location of the target service object in the target data source of object, the target service object tag
For a business object label in the multiple business object label；Objective attribute target attribute label is used to identify and the target service
The related objective attribute target attribute of object, including the mark of the objective attribute target attribute and the objective attribute target attribute depositing in the target data source
Storage space is put, the objective attribute target attribute label be the multiple attribute tags in an attribute tags, the objective attribute target attribute for institute
State an attribute in target service object association attributes.
For example, by predetermined data processing rule, the content to variety classes data source data that can unify
Handled.Interface type, the information of predefined object properties processing rule one data source of identification can be used, so as to create
Build the data source label (English for this data source：Schema), the data creation further according to this data source obtains multiple
Business object label and multiple attribute tags.
Business object is a kind of software abstract, can be used to indicate that a people, place, things or concept etc..Such as one
User can be a business object.Attribute is related to data content corresponding to business object, for example, the age of user, sex,
Trading volume etc..
There can be corresponding relation between this three classes label, such as the data source label is corresponding with multiple business object marks
Label, a business object label are corresponding with one or more attribute tags.One is formed so as to the corresponding relation between
For kind using the data source label as root node, other labels are the tree of child node.
The definition statement carried in the data source label can be as shown in table 1, and the right column of table 1 is explanation in Chinese：
Table 1
" set code " can be the mark of the target data source, and " set project " can be the target in table 1
Access position of the data source in the data system.Optionally, the data source label can also include the target data
Source species (referring in table 1 " set type "), access rights are (referring to " set accesskey " and " set in table 1
Accessid ") and access interface information (referring in table 1 " set endpoint ").So as to accurately fixed with the information more refined
An adopted data source.The data source label can with it is self-defined displaying title (referring in table 1 " set name "), made with facilitating
User understands.
A business object label in tag set can be used for identifying a business object, a business object label
The definition statement carried in (by taking the target service object tag as an example) can be as shown in table 2, and the right column of table 2 is explanation in Chinese：
Table 2
In table 2 " set code " can be the mark of the target service object,
" set meta schema0.project0.table.field in table 2:fieldtype”、
“set meta schema1.project1.table.field:Fieldtype " and
“set meta schema2.project2.table.field:Fieldtype " can be the target service pair
As the storage location in the target data source.The target service object tag can with it is self-defined displaying title (referring to
In table 2 " set name "), understood with convenient use person.
An attribute tags in tag set can be used for identify a business object possessed by an attribute, one
The definition statement carried in attribute tags (by taking the objective attribute target attribute label as an example) can be as shown in table 3, and the right column of table 3 is said for Chinese
It is bright：
Table 3
" set code " can be the mark of the objective attribute target attribute, " set meta in table 3 in table 3
schema0.project0.table.field:Fieldtype " can be the objective attribute target attribute in the target data source
Storage location.Optionally, can also include business object corresponding to the attribute mark (referring in table 3 " set object "),
And the property content deletion mode (referring in table 3 " set production butch "), the objective attribute target attribute label is also
Can with it is self-defined displaying title (referring in table 3 " set name "), with convenient use person understand.
It can be seen that in the data system with variety classes data source, using data content as according to the variety classes
The data of data source are respectively processed, and to obtain each self-corresponding tag set of the variety classes data source, pass through label
Data source label, multiple business object labels and multiple attribute tags mark corresponding data source and data that set includes
Business object and attribute in source.It can be realized by way of tag set unified to data content in variety classes data source
Definition, user only need to grasp this unified definition mode i.e. when in face of data system with variety classes data source
The data of each data source in the data system can be operated, and the data manipulation across data source, improve this
The operability of data system, is more conducively promoted.
Next will illustrate how to realize in the data system to data on the basis of embodiment corresponding to Fig. 1
Operated.
Fig. 2 is a kind of method flow diagram of data manipulation method provided in an embodiment of the present invention, and methods described includes：
S201：Data operation request is obtained, the data operation request includes the identifying of the target data source, the mesh
Mark the identifying of business object, the mark and operational requirements of the objective attribute target attribute.
For example, the data operation request can be system creation, or user creates, in the present invention
Do not limit.
The action statement used in isomeric data system can mutually correspond to the sentence of unified definition data content, lead to
Cross the calling for changing into actual sentence to complete the specific data manipulation to isomeric data system and perform interface.Receiving
After stating data operation request, the sentence in the data operation request will be parsed, to determine the data operation request
Which which ask to perform data concrete operations performed to.
The definition statement carried in the data operation request can be as shown in table 4, and the right column of table 4 is explanation in Chinese：
Table 4
Wherein, " on " can be the mark of the target data source in table 4." use " can be the target service object
Mark." when " can be the mark and operational requirements of the objective attribute target attribute.Such as：Target service object is specially client
(English：Costom), objective attribute target attribute includes three kinds, respectively sex (English：Gender), age (English：Age) and last time is clear
Look at the website time (English：last_visit_time).Operational requirements are specially：use custom when age>20and age
<30and gender=1and last_visit_time>2016-04-01, for representing to obtain the age between 20~30,
Sex is female and in April, 2016 accessed the customer group of website afterwards.
Optionally, the data operation request can also include presentation parameter (referring to " show in table 4
[distitinct] "), it can serve to indicate that sender's displaying to the data operation request is directed to this data operation request
Operating result.
Optionally, the data operation request also includes return parameters (referring to " into " in table 4), the return parameters bag
Include echo plex mode and home position, it is described obtain operating result according to the operational requirements after, can according to it is described return join
Several instructions, returned with the echo plex mode to the home position by the operating result.For example, echo plex mode can be limited
For wherein callback | ads | ots | rds | osps | odps is a kind of.Every kind of echo plex mode may specify parameter, such as：callback
, it is necessary to specify parameter under (readjustment) mode：For the url addresses of readjustment, whether timeout (time-out time), Rollback (return
Rolling) etc..Ads is a kind of Ali's cloud product, it is necessary to specify data source identification etc..
S202：The tag set of the target service object is determined according to the mark of the target data source；According to institute
State the mark of target service object and the mark of the objective attribute target attribute transfers institute from the tag set of the target service object
State target service object tag and the objective attribute target attribute label.
S203：According to access position of the obtained target data source in the data system, the target service
Storage location and objective attribute target attribute storage location in the target data source of the object in the target data source
The target service object and objective attribute target attribute are obtained from the target data source.
S204：Data manipulation is carried out to the target service object and objective attribute target attribute according to the operational requirements, grasped
Make result.
For example, according to the mark carried in the data operation request, can quickly and accurately be previously obtained
Corresponding label is found in tag set.In the present embodiment, the label found can be the target service object mark
Label and the objective attribute target attribute label, can also include other multiple business object labels and attribute tags.Due to the target industry
Include the storage location for identifying target service object and objective attribute target attribute in business object tag and the objective attribute target attribute label, can
To help to obtain the target service object and objective attribute target attribute from the target data source.And for the data operation request
Sender for, can be with not it should be understood that the target data source data definition mode in itself and data manipulation mode
Data manipulation demand is represented using the sentence carried in the data operation request.Same format (such as language can equally be used
Sentence form) data operation request operate the data in the data system in other variety classes data sources.Equivalent to adopting
Handle variety classes data source in the data system with unified interface, data access mode is unified, so as to simplify pair
The operation difficulty of the data system.
It can be seen that user is when in face of data system with variety classes data source, only need to be according to this unified definition
Mode sends data operation request, system tag set according to corresponding to searching the data operation request, so as to obtain target
Business object and objective attribute target attribute, and corresponding operating result is obtained, improve this data system with variety classes data source
The operability of system.
Fig. 3 is a kind of structure drawing of device of data processing equipment provided in an embodiment of the present invention, applied to not of the same race
In the data system of class data source, described device includes：
Processing unit 301, for being respectively processed to the data of the variety classes data source；
Label acquiring unit 302, for obtaining the tag set of the variety classes data source；
Wherein, the processing for target data source is specially：
The processing unit 301 be specifically used for using data content for foundation to the data of the target data source at
Reason, the target data source are a data source in the variety classes data source；
The label acquiring unit 302 is specifically used for obtaining the tag set of the target data source by the processing,
The tag set of the target data source includes data source label, multiple business object labels and multiple attribute tags, wherein,
The data source label is used to identify the target data source, including the mark of the target data source and the target data source
Access position in the data system；Target service object tag is used to identify the target service in the target data source
Object, including the mark of the target service object and storage position of the target service object in the target data source
Put, the target service object tag is a business object label in the multiple business object label；Objective attribute target attribute mark
Sign for identifying the objective attribute target attribute related to the target service object, including the mark of the objective attribute target attribute and the target category
Property storage location in the target data source, the objective attribute target attribute label is an attribute in the multiple attribute tags
Label, the objective attribute target attribute are and an attribute in the target service object association attributes.
Optionally, the data source the label also species including the target data source, access rights and access interface letter
Breath.
Optionally, on the basis of embodiment corresponding to Fig. 3, Fig. 4 is a kind of data manipulation provided in an embodiment of the present invention
The structure drawing of device of device, including：
Acquiring unit 401, for obtaining data operation request, the data operation request includes the target data source
Mark, the identifying of the target service object, the mark and operational requirements of the objective attribute target attribute；
First determining unit 402, the target service object is determined for the mark according to the target data source
Tag set；According to the mark identified with the mark of the objective attribute target attribute from the target service object of the target service object
The target service object tag and the objective attribute target attribute label are transferred in label set；
Second determining unit 403, for the access position according to the obtained target data source in the data system
Put, storage location and the objective attribute target attribute of the target service object in the target data source be in the target data
Storage location in source obtains the target service object and objective attribute target attribute from the target data source；
Operating unit 404, for carrying out data to the target service object and objective attribute target attribute according to the operational requirements
Operation, obtains operating result.
Optionally, the data operation request also includes presentation parameter, in addition to：
Display unit, for being tied according to the sender displaying operation of the presentation parameter to the data operation request
Fruit.
Optionally, the data operation request also includes return parameters, and the return parameters include echo plex mode and return
Position, in addition to：
Returning unit, for being returned with the echo plex mode to the home position by the operating result.
It can be seen that in the data system with variety classes data source, using data content as according to the variety classes
The data of data source are respectively processed, and to obtain each self-corresponding tag set of the variety classes data source, pass through label
Data source label, multiple business object labels and multiple attribute tags mark corresponding data source and data that set includes
Business object and attribute in source.It can be realized by way of tag set unified to data content in variety classes data source
Definition, user need to only send out when in face of data system with variety classes data source according to this unified definition mode
Send data operation request, you can the data of each data source in the data system are operated, and operated accordingly
As a result, the operability of this data system with variety classes data source is improved, is more conducively promoted.
One of ordinary skill in the art will appreciate that：Realizing all or part of step of above method embodiment can pass through
Programmed instruction related hardware is completed, and foregoing routine can be stored in a computer read/write memory medium, and the program exists
During execution, execution the step of including above method embodiment；And foregoing storage medium can be in following media at least one
Kind：Read-only storage (English：Read-only memory, abbreviation：ROM), RAM, magnetic disc or CD etc. are various to store
The medium of program code.
It should be noted that each embodiment in this specification is described by the way of progressive, each embodiment it
Between identical similar part mutually referring to what each embodiment stressed is the difference with other embodiment.
For equipment and system embodiment, because it is substantially similar to embodiment of the method, so describe fairly simple,
The relevent part can refer to the partial explaination of embodiments of method.Equipment and system embodiment described above is only schematic
, wherein as the unit that separating component illustrates can be or may not be physically separate, be shown as unit
Part can be or may not be physical location, you can with positioned at a place, or can also be distributed to multiple networks
On unit.Some or all of module therein can be selected to realize the purpose of this embodiment scheme according to the actual needs.
Those of ordinary skill in the art are without creative efforts, you can to understand and implement.
The foregoing is only a preferred embodiment of the present invention, but protection scope of the present invention be not limited thereto,
Any one skilled in the art the invention discloses technical scope in, the change or replacement that can readily occur in,
It should all be included within the scope of the present invention.Therefore, protection scope of the present invention should be with scope of the claims
It is defined.
Claims (11)
1. a kind of data operation system, it is characterised in that the data operation system includes user equipment, server, the first number
According to source and the second data source, first data source and the second data source are different types of data source in data system：
The server, for being carried out respectively to the data of first data source and the second data source by foundation of data content
Processing, tag set corresponding to tag set corresponding to first data source and the second data source is obtained by processing；Wherein,
Processing for the first data source is specially：Handled using data content as according to the data to first data source；It is logical
Cross the processing and obtain tag set corresponding to first data source, the tag set of first data source includes being used for
Position the data source label of first data source, the business object for positioning target service object in first data source
The attribute tags of label and the objective attribute target attribute for positioning the target service object；
The user equipment, for sending data operation request to the server, the data operation request includes described the
The identifying of one data source, the identifying of the target service object, the mark and operational requirements of the objective attribute target attribute；
The server determines described when receiving the data operation request, according to the mark of first data source
The tag set of one data source；Counted according to the mark of the mark of the target service object and the objective attribute target attribute from described first
According to transferring the business object label and the attribute tags in the tag set in source；Institute is determined according to the data source label
Access position of first data source in the data system is stated, the target service is determined according to the business object label
Storage location of the object in first data source, determine the objective attribute target attribute described first according to the attribute tags
Storage location in data source；The target service object and target category are obtained according to the access position determined and storage location
Property；Data manipulation is carried out to the target service object and objective attribute target attribute according to the operational requirements, obtains operating result.
2. a kind of data manipulation method, it is characterised in that applied in the data system with variety classes data source, with data
Content is to be respectively processed according to the data to the variety classes data source, and the variety classes data are obtained by processing
Each self-corresponding tag set in source；Wherein, the processing for target data source is specially：Using data content as according to the mesh
The data of mark data source are handled, and the target data source is a data source in the variety classes data source；Pass through
The processing obtains tag set corresponding to the target data source, and the tag set of the target data source includes being used to mark
Know the data source label of the target data source, multiple business object marks for being used to identify business object in the target data source
Label and multiple attribute tags for being used to identify business object association attributes in the target data source, methods described include：
Obtain data operation request, the mark of the data operation request including the target data source, target service object
Mark, the mark and operational requirements of objective attribute target attribute；
The tag set of the target data source is determined according to the mark of the target data source；According to the target service pair
The mark of elephant and the mark of the objective attribute target attribute transfer the target service object from the tag set of the target data source
Label corresponding to corresponding label and the objective attribute target attribute；
Data source label in the target data source tag set determines the target data source in the data system
Access position in system, determine the target service object in the target according to label corresponding to the target service object
Storage location in data source, the label according to corresponding to objective attribute target attribute determine the objective attribute target attribute in the target data source
Storage location；
The target service object and objective attribute target attribute are obtained according to the access position determined and storage location；
Data manipulation is carried out to the target service object and objective attribute target attribute according to the operational requirements, obtains operating result.
3. according to the method for claim 2, it is characterised in that the data source label includes the mark of the target data source
Know and access position of the target data source in the data system；Target service object tag includes target service object
Mark and storage location of the target service object in the target data source, the target service object tag is institute
State a business object label in multiple business object labels；Objective attribute target attribute label includes the mark of objective attribute target attribute and the mesh
Storage location of the attribute in the target data source is marked, the objective attribute target attribute label is one in the multiple attribute tags
Attribute tags, the objective attribute target attribute are and an attribute in the target service object association attributes.
4. according to the method for claim 2, it is characterised in that the data source label also includes the target data source
Species, access rights and access interface information.
5. according to the method for claim 2, it is characterised in that the data operation request also includes presentation parameter, in institute
State and data manipulation is carried out to the target service object and objective attribute target attribute according to the operational requirements, after obtaining operating result,
Also include：
The operating result is shown to the sender of the data operation request according to the presentation parameter.
6. according to the method described in claim 2 to 5 any one, it is characterised in that the data operation request also includes returning
Return parameter, the return parameters include echo plex mode and home position, it is described according to the operational requirements to the target industry
Business object and objective attribute target attribute carry out data manipulation, after obtaining operating result, in addition to：
Returned with the echo plex mode to the home position by the operating result.
A kind of 7. data operation device, it is characterised in that applied in the data system with variety classes data source, the dress
Put including：
Processing unit, for being respectively processed using data content as according to the data to the variety classes data source；
Label acquiring unit, for obtaining each self-corresponding tag set of the variety classes data source by processing；Wherein, pin
Processing to target data source is specially：
The processing unit is specifically used for handling using data content as according to the data to the target data source, the mesh
It is a data source in the variety classes data source to mark data source；
The label acquiring unit is specifically used for obtaining tag set corresponding to the target data source by the processing, described
Data source label that the tag set of target data source includes being used to identify the target data source, it is multiple be used to identifying it is described
The business object label of business object is used for that to identify business object in the target data source related to multiple in target data source
The attribute tags of attribute；
Acquisition request unit, for obtaining data operation request, the data operation request includes the mark of the target data source
Knowledge, the mark of target service object, the mark of objective attribute target attribute and operational requirements；
First determining unit, for determining the tag set of the target data source according to the mark of the target data source；
Adjusted according to the mark of the mark of the target service object and the objective attribute target attribute from the tag set of the target data source
Take label corresponding to label corresponding to the target service object and the objective attribute target attribute；
Second determining unit, the number of targets is determined for the data source label in the target data source tag set
According to access position of the source in the data system, the target industry is determined according to label corresponding to the target service object
Storage location of the business object in the target data source, the label according to corresponding to objective attribute target attribute determine that the objective attribute target attribute exists
Storage location in the target data source；The target service object is obtained according to the access position determined and storage location
And objective attribute target attribute；
Operating unit, for carrying out data manipulation to the target service object and objective attribute target attribute according to the operational requirements, obtain
To operating result.
8. device according to claim 7, it is characterised in that the data source label includes the mark of the target data source
Know and access position of the target data source in the data system；Target service object tag includes target service object
Mark and storage location of the target service object in the target data source, the target service object tag is institute
State a business object label in multiple business object labels；Objective attribute target attribute label includes the mark of objective attribute target attribute and the mesh
Storage location of the attribute in the target data source is marked, the objective attribute target attribute label is one in the multiple attribute tags
Attribute tags, the objective attribute target attribute are and an attribute in the target service object association attributes.
9. device according to claim 7, it is characterised in that the data source label also includes the target data source
Species, access rights and access interface information.
10. device according to claim 7, it is characterised in that the data operation request also includes presentation parameter, also wraps
Include：
Display unit, for showing the operating result to the sender of the data operation request according to the presentation parameter.
11. according to the device described in claim 7 to 10 any one, it is characterised in that the data operation request also includes
Return parameters, the return parameters include echo plex mode and home position, in addition to：
Returning unit, for being returned with the echo plex mode to the home position by the operating result.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201610424587.8A CN107515866B (en) | 2016-06-15 | 2016-06-15 | Data operation method, device and system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201610424587.8A CN107515866B (en) | 2016-06-15 | 2016-06-15 | Data operation method, device and system |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN107515866A true CN107515866A (en) | 2017-12-26 |
| CN107515866B CN107515866B (en) | 2021-01-29 |
Family
ID=60721009
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201610424587.8A Active CN107515866B (en) | 2016-06-15 | 2016-06-15 | Data operation method, device and system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN107515866B (en) |
Cited By (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110347480A (en) * | 2019-06-26 | 2019-10-18 | 联动优势科技有限公司 | The preferred access path method and device of data source containing coincidence data item label |
| CN110390208A (en) * | 2019-06-26 | 2019-10-29 | 联动优势科技有限公司 | A kind of the preferred data source access method and device of composite data item label |
| CN110910108A (en) * | 2019-11-01 | 2020-03-24 | 华青融天(北京)软件股份有限公司 | Data association method and device, electronic equipment and storage medium |
| CN112785368A (en) * | 2020-12-24 | 2021-05-11 | 江苏苏宁云计算有限公司 | Label production method, management method, device and system |
| CN112905586A (en) * | 2019-12-03 | 2021-06-04 | 阿里巴巴集团控股有限公司 | Data processing and accessing method, device, computer system and readable storage medium |
Citations (12)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US5649136A (en) * | 1995-02-14 | 1997-07-15 | Hal Computer Systems, Inc. | Processor structure and method for maintaining and restoring precise state at any instruction boundary |
| US20050114394A1 (en) * | 2003-11-21 | 2005-05-26 | Kaipa Sam P. | Mapping XML schema components to qualified Java components |
| CN101145163A (en) * | 2007-10-30 | 2008-03-19 | 金蝶软件（中国）有限公司 | Method and system for obtaining data from a plurality of data pool |
| CN101241506A (en) * | 2008-03-17 | 2008-08-13 | 张建中 | Many dimensions search method and device and system |
| US7680453B2 (en) * | 2004-04-17 | 2010-03-16 | Hewlett-Packard Development Company, L.P. | Method of storing and accessing electronic data and apparatus therefor |
| CN101799826A (en) * | 2010-03-04 | 2010-08-11 | 中国电子科技集团公司第二十八研究所 | Networking data sharing system and method based on virtual view |
| US20110099466A1 (en) * | 2004-12-20 | 2011-04-28 | Adobe Systems Incorporated | Multiple Bindings in Web Service Data Connection |
| CN102236681A (en) * | 2010-04-20 | 2011-11-09 | 中兴通讯股份有限公司 | System and method for storing and obtaining data |
| CN104200402A (en) * | 2014-09-11 | 2014-12-10 | 国家电网公司 | Publishing method and system of source data of multiple data sources in power grid |
| CN104462244A (en) * | 2014-11-19 | 2015-03-25 | 武汉大学 | Smart city heterogeneous data sharing method based on meta model |
| US20150242412A1 (en) * | 2012-09-27 | 2015-08-27 | Ge Intelligent Platforms, Inc. | System and method for enhanced process data storage and retrieval |
| CN105338113A (en) * | 2015-11-25 | 2016-02-17 | 北京航空航天大学 | Multi-platform data interconnected system for sharing urban data resources |
-
2016
- 2016-06-15 CN CN201610424587.8A patent/CN107515866B/en active Active
Patent Citations (12)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US5649136A (en) * | 1995-02-14 | 1997-07-15 | Hal Computer Systems, Inc. | Processor structure and method for maintaining and restoring precise state at any instruction boundary |
| US20050114394A1 (en) * | 2003-11-21 | 2005-05-26 | Kaipa Sam P. | Mapping XML schema components to qualified Java components |
| US7680453B2 (en) * | 2004-04-17 | 2010-03-16 | Hewlett-Packard Development Company, L.P. | Method of storing and accessing electronic data and apparatus therefor |
| US20110099466A1 (en) * | 2004-12-20 | 2011-04-28 | Adobe Systems Incorporated | Multiple Bindings in Web Service Data Connection |
| CN101145163A (en) * | 2007-10-30 | 2008-03-19 | 金蝶软件（中国）有限公司 | Method and system for obtaining data from a plurality of data pool |
| CN101241506A (en) * | 2008-03-17 | 2008-08-13 | 张建中 | Many dimensions search method and device and system |
| CN101799826A (en) * | 2010-03-04 | 2010-08-11 | 中国电子科技集团公司第二十八研究所 | Networking data sharing system and method based on virtual view |
| CN102236681A (en) * | 2010-04-20 | 2011-11-09 | 中兴通讯股份有限公司 | System and method for storing and obtaining data |
| US20150242412A1 (en) * | 2012-09-27 | 2015-08-27 | Ge Intelligent Platforms, Inc. | System and method for enhanced process data storage and retrieval |
| CN104200402A (en) * | 2014-09-11 | 2014-12-10 | 国家电网公司 | Publishing method and system of source data of multiple data sources in power grid |
| CN104462244A (en) * | 2014-11-19 | 2015-03-25 | 武汉大学 | Smart city heterogeneous data sharing method based on meta model |
| CN105338113A (en) * | 2015-11-25 | 2016-02-17 | 北京航空航天大学 | Multi-platform data interconnected system for sharing urban data resources |
Non-Patent Citations (3)
| Title |
|---|
| 姬倩倩: ""公共交通大数据平台架构研究"", 《电子科技》 * |
| 李亢 等: ""多源异构装备数据集成研究综述"", 《中国电子科学研究院学报》 * |
| 陈宏 等: ""分布异构环境下的数据集成方法及应用"", 《计算机工程》 * |
Cited By (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110347480A (en) * | 2019-06-26 | 2019-10-18 | 联动优势科技有限公司 | The preferred access path method and device of data source containing coincidence data item label |
| CN110390208A (en) * | 2019-06-26 | 2019-10-29 | 联动优势科技有限公司 | A kind of the preferred data source access method and device of composite data item label |
| CN110347480B (en) * | 2019-06-26 | 2021-06-25 | 联动优势科技有限公司 | Data source preferred access path method and device containing coincident data item label |
| CN110390208B (en) * | 2019-06-26 | 2023-02-21 | 联动优势科技有限公司 | Optimized data source access method and device for composite data item label |
| CN110910108A (en) * | 2019-11-01 | 2020-03-24 | 华青融天(北京)软件股份有限公司 | Data association method and device, electronic equipment and storage medium |
| CN110910108B (en) * | 2019-11-01 | 2022-11-15 | 华青融天(北京)软件股份有限公司 | Data association method and device, electronic equipment and storage medium |
| CN112905586A (en) * | 2019-12-03 | 2021-06-04 | 阿里巴巴集团控股有限公司 | Data processing and accessing method, device, computer system and readable storage medium |
| CN112785368A (en) * | 2020-12-24 | 2021-05-11 | 江苏苏宁云计算有限公司 | Label production method, management method, device and system |
Also Published As
| Publication number | Publication date |
|---|---|
| CN107515866B (en) | 2021-01-29 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN103810196B (en) | The method that database performance measurement is carried out based on business model | |
| US9460415B2 (en) | Determining semantic information of business applications | |
| US8806345B2 (en) | Information exchange using generic data streams | |
| US9495429B2 (en) | Automatic synthesis and presentation of OLAP cubes from semantically enriched data sources | |
| CN107515866A (en) | A kind of data manipulation method, device and system | |
| US20150378721A1 (en) | Methods for managing applications using semantic modeling and tagging and devices thereof | |
| US20040187111A1 (en) | Content management portal and method for communicating media content | |
| CN105630938A (en) | Intelligent question-answering system | |
| US20130054650A1 (en) | Automatic detection of columns to be obfuscated in database schemas | |
| WO2003083724A1 (en) | Metadata database management system and method therfor | |
| CN108279987A (en) | The method for edition management and device of application program | |
| US20080027899A1 (en) | Systems and Methods for Integrating from Data Sources to Data Target Locations | |
| US10338894B2 (en) | Generating applications based on data definition language (DDL) query view and application page template | |
| CN102880683A (en) | Automatic network generation system for feasibility study report and generation method thereof | |
| US20140229223A1 (en) | Integrated erp based planning | |
| US10489024B2 (en) | UI rendering based on adaptive label text infrastructure | |
| CN107784068A (en) | Acquisition methods, device, storage medium, processor and the service end of data variation | |
| CN110675238A (en) | Client label configuration method, system, readable storage medium and electronic equipment | |
| CN105468571A (en) | Method and device used for automatically generating report | |
| CN112463986A (en) | Information storage method and device | |
| CN114265957A (en) | Multiple data source combined query method and system based on graph database | |
| US9823804B2 (en) | Unified user interface framework for creating configurable web-portals using menu options | |
| CN102193907B (en) | A kind of manuscript control methods based on B/S structure and system | |
| CN113051333B (en) | Data processing method and device, electronic equipment and storage medium | |
| US10650015B2 (en) | Dynamic migration of user interface application |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant | ||
| TR01 | Transfer of patent right | ||
| TR01 | Transfer of patent right |
Effective date of registration: 20210903 Address after: Room 508, floor 5, building 4, No. 699, Wangshang Road, Changhe street, Binjiang District, Hangzhou City, Zhejiang Province Patentee after: Alibaba (China) Co.,Ltd. Address before: Cayman Islands Grand Cayman capital building, a four storey No. 847 mailbox Patentee before: ALIBABA GROUP HOLDING Ltd. |
|
| TR01 | Transfer of patent right | ||
| TR01 | Transfer of patent right |
Effective date of registration: 20211122 Address after: 310000 No. 12, Zhuantang science and technology economic block, Xihu District, Hangzhou City, Zhejiang Province Patentee after: Aliyun Computing Co.,Ltd. Address before: 310052 room 508, 5th floor, building 4, No. 699 Wangshang Road, Changhe street, Binjiang District, Hangzhou City, Zhejiang Province Patentee before: Alibaba (China) Co.,Ltd. |