CN104461494B - A kind of method and device for the data packet generating data processing tools - Google Patents
A kind of method and device for the data packet generating data processing tools Download PDFInfo
- Publication number
- CN104461494B CN104461494B CN201410594884.8A CN201410594884A CN104461494B CN 104461494 B CN104461494 B CN 104461494B CN 201410594884 A CN201410594884 A CN 201410594884A CN 104461494 B CN104461494 B CN 104461494B
- Authority
- CN
- China
- Prior art keywords
- data
- information
- data item
- client
- name
- 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.)
- Active
Links
Landscapes
- Data Exchanges In Wide-Area Networks (AREA)
Abstract
The embodiment of the present invention provides a kind of method and device for the data packet generating data processing tools, and method therein may include：Import the data information for data processing；The selection instruction for receiving client input, selects the data information that selection instruction selects as data item information from data information；The generation request of the data packet for the data packet format for generating target data handling implement that client is submitted is received, the generation request carries package name；Response generates request, and according to data item information, the related data information of data item information is obtained from data information；Data item information, related data information and package name are transmitted to as parameter in the data packet of preset structure, to generate the data packet of target data packet format.The invention avoids using complicated manual operations to generate the data packet of data processing tools corresponding format, the generation of the data packet to data processing tools corresponding format is facilitated.
Description
Technical field
The present invention relates to a kind of field of computer technology more particularly to a kind of sides for the data packet generating data processing tools
Method and device.
Background technology
With the development of computer technology, data to be treated are more and more on computers at present, asked for this
Topic, occur in computer realm at present much for handle data data processing tools (such as：Busincess intelligence tool),
And different data processing tools are owned by the data packet of its corresponding format in practical applications, and there have exploitation to define it to be corresponding
The data packet Core Generator of the data packet of format.
Although these data packet Core Generators is powerful, data are generated using these data packet Core Generators
The technical threshold of packet is higher, needs to generate data packet by complicated manual operations, manual operations generates the complexity of data packet
Degree is high, cannot be conveniently generated data packet.
Invention content
An embodiment of the present invention provides a kind of method and devices for the data packet generating data processing tools, can avoid using
Complicated manual operations reduces to generate the data packet of data processing tools corresponding format and generates the corresponding lattice of data processing tools
The complexity of the data packet of formula facilitates the generation of the data packet to data processing tools corresponding format.
First aspect present invention provides a kind of method for the data packet generating data processing tools, it may include：
Import the data information for data processing；
The selection instruction for receiving client input selects the data letter of the selection instruction selection from the data information
Breath is used as data item information；
Receive the generation request for the data packet for generating target data packet format that the client is submitted, the target
Data packet format is the data packet format of target data handling implement, and the target data handling implement is in data processing tools
One or more, generation request carries package name；
The generation request is responded, according to the data item information, the data item letter is obtained from the data information
The related data information of breath；
The data item information, the related data information and the package name are transmitted to default knot as parameter
In the data packet of structure, to generate the data packet of the target data packet format.
Second aspect of the present invention provides a kind of device for the data packet generating data processing tools, it may include：
Import modul, for importing the data information for data processing；
First receiving module, the selection instruction for receiving client input, selects the choosing from the data information
It selects and instructs the data information selected as data item information；
Second receiving module, for receiving the data packet for generating target data packet format that the client is submitted
Request is generated, the target data packet format is the data packet format of target data handling implement, and the target data handles work
Tool is one or more of data processing tools, and the generation request carries package name；
Respond module, according to the data item information, is obtained for responding the generation request from the data information
The related data information of the data item information；
Transfer module, for using the data item information, the related data information and the package name as ginseng
Number is transmitted in the data packet of preset structure, to generate the data packet of the target data packet format.
Implement the embodiment of the present invention, has the advantages that：
Data information of the embodiment of the present invention by importing for data processing, the selection for then receiving client input refer to
It enables, selects the data information that the selection instruction selects as data item information from the data information, pass through customer in response
The generation request for holding the data packet for generating target data packet format for the carrying package name submitted, according to the data
Information, obtains the related data information of the data item information from the data information, then by the data item information, institute
It states related data information and the package name is transmitted to as parameter in the data packet of preset structure, to generate the target
The data packet of data packet format generates the number of data processing tools corresponding format so as to avoid complicated manual operations is used
According to packet, the complexity for the data packet for generating data processing tools corresponding format is reduced, is facilitated to data processing tools phase
Answer the generation of the data packet of format.
Description of the drawings
In order to more clearly explain the embodiment of the invention or the technical proposal in the existing technology, to embodiment or will show below
There is attached drawing needed in technology description to be briefly described, it should be apparent that, the accompanying drawings in the following description is only this
Some embodiments of invention for those of ordinary skill in the art without creative efforts, can be with
Obtain other attached drawings according to these attached drawings.
Fig. 1 is a kind of flow chart of the method for data packet generating data processing tools provided in an embodiment of the present invention；
Fig. 2 is the flow chart of the method for another data packet for generating data processing tools provided in an embodiment of the present invention；
Fig. 3 is a kind of structural representation of the device of data packet generating data processing tools provided in an embodiment of the present invention
Figure；
Fig. 4 is the structural representation of the device of another data packet for generating data processing tools provided in an embodiment of the present invention
Figure；
Fig. 5 is the structural schematic diagram of the embodiment of the first receiving module shown in Fig. 3；
Fig. 6 is the structural schematic diagram of the embodiment of transfer module shown in Fig. 3.
Specific implementation mode
Following will be combined with the drawings in the embodiments of the present invention, and technical solution in the embodiment of the present invention carries out clear, complete
Site preparation describes, it is clear that described embodiments are only a part of the embodiments of the present invention, instead of all the embodiments.It is based on
Embodiment in the present invention, those of ordinary skill in the art are obtained every other without creative efforts
Embodiment shall fall within the protection scope of the present invention.
As data to be treated are more and more on computers, for this problem, go out in computer realm at present
Many data processing tools for handling data are showed.Data processing tools using the application of data processing technique by being formed.
Wherein, data processing technique may include but be not limited to：Data warehouse technology, data mining technology, OLTP (On-Line
Transaction Processing, Transaction Processing), On Line Analysis Process (On-Line Analytical
Processing, on-line analytical processing), data backup and data the technologies such as restore.Wherein data warehouse technology is using certain
The storing mode of special data, allows all data for including, and is particularly conducive to analyzing processing, with generate valuable information and according to
This makes decisions.Data mining technology is using technologies such as neural network, rule inductions, for finding the pass between data
System, makes the deduction based on data.OLTP technologies are mainly used in traditional relevant database, be mainly to it is basic,
The technology that daily affairs are handled, essential characteristic, which is the initial data of user, can be immediately communicated to the progress of calculating center
Processing, and handling result is provided in a short period of time.OLAP technologies are mainly used in data warehouse, by being answered
Miscellaneous analysis operation stresses decision support, and provides query result intuitive and easy to understand.The target of OLAP technologies is to meet decision
It supports or meets specifically to inquire and report demand, its technological core Shi " under multi-dimensional environment;Tie up "This concept." dimension "
It is the angle that people observe objective world, is a kind of high-level Type division.Pass through the multinomial important category an entity
Property is defined as multiple dimensions (dimension), enables users to be compared the data in different dimensional.Using OLAP technologies to more
The data that dimension form is organized take slice (Slice), stripping and slicing (Dice), drill through (Drill-down and Roll-up), rotation
(Pivot) the various analyses actions such as, in the hope of profile data, allow user from multiple angles, mostly laterally from database
Data, to deeply understand the information being included in data, therefore OLAP technologies could also say that multidimensional data analysis technology.
When data processing tools are handled using data processing technique team data, the number using data processing tools corresponding format is needed
The processing to data could be carried out according to packet.
Below in conjunction with attached drawing 1- attached drawings 2, to the data packet provided in an embodiment of the present invention for generating data processing tools
The flow of method describes in detail.
It is provided in an embodiment of the present invention generate data processing tools data packet method can be Windows systems,
It is executed in the systems such as IOS systems.
Fig. 1 is referred to, for a kind of stream of the method for the data packet generating data processing tools provided in an embodiment of the present invention
Cheng Tu；This method may include following steps S101- steps S105.
S101 imports the data information for data processing.
In embodiments of the present invention, the data information may include but be not limited to tables of data Chinese, tables of data English
Pass between title, data sheet field Chinese name, data sheet field English name, the data type of data sheet field, each tables of data
Connection relationship, dimension name, dimension hierarchy title, dimension hierarchy serial number, dimension field name, data source name, dimension hierarchy class
The data informations such as other and dimension field description.Import the data information can include but is not limited to from local data base or
The data information is imported in network data base etc..
S102 receives the selection instruction of client input, and the selection instruction selection is selected from the data information
Data information is as data item information.
Wherein, the data item information may include but be not limited at least one data sheet field Chinese name or dimension field
Title.In this step, the selection instruction that can be inputted by repeatedly receiving client, to select the choosing from the data information
It selects and instructs the data information selected as data item information.
In the embodiment of the present invention, in above-mentioned step S102, the selection instruction of client input is received, is believed from the data
The data information that the selection instruction selects is selected to may comprise steps of as data item information in breath：
1) the first data search request that the client is submitted, is received, first data search request carries the
One search data item；
Wherein, first search data item may include but be not limited to data sheet field Chinese name, tables of data Chinese name, dimension
Spend the data informations such as field Chinese name, dimension name, data source name.
2) first search data item, and acquisition and institute from the data information, are searched in the data information
State relevant first search result of the first search data item；
Wherein, first search result may include but be not limited to data sheet field Chinese name, data sheet field English name,
The data informations such as tables of data Chinese name, tables of data English name, dimension field Chinese name, dimension name.It, can in the embodiment of the present invention
To take global search technology to carry out the search of data item, such as：When first search data item of input is issued volume, first searches
Hitch fruit may include the data fields Chinese names such as issued volume, accumulative issued volume, wealth card issued volume, can also include the data word
The data informations such as the corresponding tables of data Chinese name of section.
3) first search result, is sent to the client；
4) the first choice information that the client is chosen from first search result, the first choice, are obtained
Information carries the second data search request；
Wherein, the first choice information can be an item data literary name section Chinese name or dimension field Chinese name.
5), search the first choice information in the data information, and obtain from the data information with it is described
Relevant second search result of first choice information；
Wherein, second search result may include the data informations such as tables of data Chinese name and dimension name.
For example, when first choice information is data sheet field Chinese name, the second search result can be data sheet field
The Chinese name and dimension name of tables of data corresponding to Chinese name.
6) second search result, is sent to the client；
7) the second selection information that the client is chosen from second search result, is obtained；
Wherein, the second selection information may include data sheet field Chinese name, dimension name etc..
8) the first choice information and second of selection information, are determined as the data item information.
S103 receives the generation request for the data packet for generating target data packet format that the client is submitted, institute
The data packet format that target data packet format is target data handling implement is stated, the target data handling implement is data processing
One or more of tool, the generation request carry package name.
The data processing tools may include but be not limited to 8 data processing tools of Cognos Series, Business
The data processing tools such as Objects Enterprise data processing tools and Microstrategy data processing tools.Each
Data processing tools have the data packet of its corresponding format, and the data of the data packet ability pair of its corresponding format is only used to carry out
Data processing.
S104 responds the generation request, according to the data item information, the data is obtained from the data information
The related data information of item information.
Wherein, the related data information includes but not limited to data sheet field English name, tables of data Chinese name, dimension name
The data informations such as title.For example, when the data item information is data field Chinese name, the related data information of acquisition can be
The corresponding data sheet field English name of the data sheet field Chinese name, tables of data where the data field Chinese name and should
Corresponding dimension name of data sheet field Chinese name etc..
The data item information, the related data information and the package name are transmitted to by S105 as parameter
In the data packet of preset structure, to generate the data packet of the target data packet format.
In the present embodiment, the preset structure can be made of physical layer, logical layer and represent layer, and wherein physical layer is used for
Store direct physical table information.Logical layer is used to store the information that physical table is mapped to logical table.Represent layer, which is used to store, to be needed
It is published to the data item and some derivative indexes of corresponding data handling implement.By by the data item information, the dependency number
It is believed that breath and package name are transmitted to as parameter in physical layer, logical layer and represent layer, to generate data processing tools phase
Answer the data packet of format.It is transmitted in the data packet of preset structure by directly regarding data information as parameter, to generate data
The data packet of handling implement corresponding format, to avoid developer according to the data of the various different structures of hobby generation of oneself
Packet, facilitates the maintenance and management of data packet after reaching the standard grade.
In the embodiment of the present invention, in above-mentioned step S105, by the data item information, the related data information and institute
It states package name to be transmitted in the data packet of preset structure as parameter, to generate the data packet of the target data packet format
It may comprise steps of：
1) the data item information and the related data information, are built into data item tree；
In the present embodiment, such as：When the related data information is data source name, data table name and data literary name
When name section, then data source name, data table name and data literary name name section are generated into nodal information, then by these nodes
It carries out assembling and generates data item tree.
2) the data item information and the related data information, are obtained from data item tree, by the data item information,
The related data information and the package name are transmitted to as parameter in the data packet of preset structure, to generate the mesh
Mark the data packet of data packet format.
For example, in the present embodiment, the data item letter can be obtained from data item tree by ergodic data Xiang Shu
Breath, the related data information and package name, then using they as parameter be transmitted to preset structure physical layer, logical layer,
In represent layer, to generate the data packet of data processing tools.
Data information of the embodiment of the present invention by importing for data processing, the selection for then receiving client input refer to
It enables, selects the data information that the selection instruction selects as data item information from the data information, pass through customer in response
The generation request for holding the data packet for generating target data packet format for the carrying package name submitted, according to the data
Information, obtains the related data information of the data item information from the data information, then by the data item information, institute
It states related data information and the package name is transmitted to as parameter in the data packet of preset structure, to generate the target
The data packet of data packet format generates the number of data processing tools corresponding format so as to avoid complicated manual operations is used
According to packet, the complexity for the data packet for generating data processing tools corresponding format is reduced, is facilitated to data processing tools phase
Answer the generation of the data packet of format.
Fig. 2 is referred to, the method for the data packet of data processing tools is generated for another kind provided in an embodiment of the present invention
Flow chart；This method may include following steps S201- steps S210.
S201 imports the data information for data processing.
S202, the data access entitlement for receiving the user information for carrying at least one user that the client is submitted are asked
It asks.
Wherein, the user information must include that can uniquely determine the user identifier of user, such as user identifier ID.
The user information is stored in authorization database by S203.
The authorization database can be local data base or network data base.
S204, receives the data access request that the client is submitted, and the data access request carries data access and uses
The user information at family.
In the present embodiment, before carrying out step S206, need the carrying data access user's for receiving client submission
The data access request of user information, such as the user information are user identifier ID, then can be according to user login name and close
Code finds user identifier ID.
S205, the user information that the data access user is searched in the authorization database whether there is the mandate
In database, if so, to the client output for prompt the data access user can input selection instruct prompt
Information.
Such as：It can be by searching whether there is user identifier identical with user identifier ID in authorization database
ID, and if it exists, then judge the user for authorized user, and prompt message is exported to client where the user, prompt the user
It can be instructed with input selection, carry out the selection of data item information.
S206 receives the selection instruction of client input, and the selection instruction selection is selected from the data information
Data information is as data item information.
S207 receives the generation request for the data packet for generating target data packet format that the client is submitted, institute
The data packet format that target data packet format is target data handling implement is stated, the target data handling implement is data processing
One or more of tool, the generation request carry package name.
S208 responds the generation request, according to the data item information, the data is obtained from the data information
The related data information of item information.
The data item information, the related data information and the package name are transmitted to by S209 as parameter
In the data packet of preset structure, to generate the data packet of the target data packet format.
The step S206- steps S209 of the present embodiment can be found in the step S102- step S105 of embodiment illustrated in fig. 1,
This is not repeated.
The data item information, the related data information and the package name are stored in data by S210
In library.
Wherein, the document data base can be the databases such as local data base or network data base.This step passes through
The data item information, the related data information and the package name are stored in document data base, to facilitate day
Maintenance and management is carried out to data packet afterwards.For example, demand according to circumstances, needs to increase one newly on the basis of source data item information
Item data item information can then inquire the data by package name to generate new data packet in document data base
The corresponding data item information of packet title newly increases an item data item information by selection again after obtaining source data item information, then
New data packet is advantageously generated according to step S207- steps S210.For another example, demand according to circumstances is needed in former data
An item data item information is deleted on the basis of item information, it, then can be by package name in data to generate new data packet
The corresponding data item information of the package name is inquired in database, deletes what needs were deleted after obtaining source data item information
Data item information advantageously generates new data packet according still further to step S207- steps S210.Step S210 can also be in step
It is executed before step S209 after S208.
Data information of the embodiment of the present invention by importing for data processing, the selection for then receiving client input refer to
It enables, selects the data information that the selection instruction selects as data item information from the data information, pass through customer in response
The generation request for holding the data packet for generating target data packet format for the carrying package name submitted, according to the data
Information, obtains the related data information of the data item information from the data information, then by the data item information, institute
It states related data information and the package name is transmitted to as parameter in the data packet of preset structure, to generate the target
The data packet of data packet format generates the number of data processing tools corresponding format so as to avoid complicated manual operations is used
According to packet, the complexity for the data packet for generating data processing tools corresponding format is reduced, is facilitated to data processing tools phase
Answer the generation of the data packet of format.
Below in conjunction with attached drawing 3- attached drawings 4, to a kind of data generating data processing tools provided in an embodiment of the present invention
The device of packet describes in detail.It should be noted that the data packet of the generation data processing tools described in attached drawing 3- attached drawings 4
Device can be applied to execute the attached methods shown in Fig. 2 of above-mentioned attached drawing 1-.
Fig. 3 is referred to, for a kind of knot of the device for the data packet generating data processing tools provided in an embodiment of the present invention
Structure schematic diagram；The device may include：Import modul 301, the first receiving module 302, the second receiving module 303, respond module
304, transfer module 305.
Import modul 301, for importing the data information for data processing.
In embodiments of the present invention, the data information may include but be not limited to tables of data Chinese, tables of data English
Pass between title, data sheet field Chinese name, data sheet field English name, the data type of data sheet field, each tables of data
Connection relationship, dimension name, dimension hierarchy title, dimension hierarchy serial number, dimension field name, data source name, dimension hierarchy class
The data informations such as other and dimension field description.Import the data information can include but is not limited to from local data base or
The data information is imported in network data base etc..
First receiving module 302, the selection instruction for receiving client input, from the data information described in selection
The data information that selection instruction selects is as data item information.
Wherein, the data item information may include but be not limited at least one data sheet field Chinese name or dimension field
Title.In this step, the selection instruction that can be inputted by repeatedly receiving client, to select the choosing from the data information
It selects and instructs the data information selected as data item information.
Second receiving module 303, the data for generating target data packet format submitted for receiving the client
The generation of packet is asked, and the target data packet format is the data packet format of target data handling implement, at the target data
Science and engineering tool is one or more of data processing tools, and the generation request carries package name.
The data processing tools may include but be not limited to 8 data processing tools of Cognos Series, Business
The data processing tools such as Objects Enterprise data processing tools and Microstrategy data processing tools.Each
Data processing tools have the data packet of its corresponding format, and the data of the data packet ability pair of its corresponding format is only used to carry out
Data processing.
Respond module 304, for responding the generation request, according to the data item information, from the data information
Obtain the related data information of the data item information.
Wherein, the related data information includes but not limited to data sheet field English name, tables of data Chinese name, dimension name
The data informations such as title.For example, when the data item information is data field Chinese name, the related data information of acquisition can be
The corresponding data sheet field English name of the data sheet field Chinese name, tables of data where the data field Chinese name and should
Corresponding dimension name of data sheet field Chinese name etc..
Transfer module 305, for using the data item information, the related data information and the package name as
Parameter is transmitted in the data packet of preset structure, to generate the data packet of the target data packet format.
In the present embodiment, the preset structure can be made of physical layer, logical layer and represent layer, and wherein physical layer is used for
Store direct physical table information.Logical layer is used to store the information that physical table is mapped to logical table.Represent layer, which is used to store, to be needed
It is published to the data item and some derivative indexes of corresponding data handling implement.By by the data item information, the dependency number
It is believed that breath and package name are transmitted to as parameter in physical layer, logical layer and represent layer, to generate data processing tools phase
Answer the data packet of format.It is transmitted in the data packet of preset structure by directly regarding data information as parameter, to generate data
The data packet of handling implement corresponding format, to avoid developer according to the data of the various different structures of hobby generation of oneself
Packet, facilitates the maintenance and management of data packet after reaching the standard grade.
Data information of the embodiment of the present invention by importing for data processing, the selection for then receiving client input refer to
It enables, selects the data information that the selection instruction selects as data item information from the data information, pass through customer in response
The generation request for holding the data packet for generating target data packet format for the carrying package name submitted, according to the data
Information, obtains the related data information of the data item information from the data information, then by the data item information, institute
It states related data information and the package name is transmitted to as parameter in the data packet of preset structure, to generate the target
The data packet of data packet format generates the number of data processing tools corresponding format so as to avoid complicated manual operations is used
According to packet, the complexity for the data packet for generating data processing tools corresponding format is reduced, is facilitated to data processing tools phase
Answer the generation of the data packet of format.
Fig. 4 is referred to, the device of the data packet of data processing tools is generated for another kind provided in an embodiment of the present invention
Structural schematic diagram；The device may include：Import modul 301, the first receiving module 302, the second receiving module 303, respond module
304, transfer module 305, third receiving module 306, the first storage module 307, the 4th receiving module 308,309 and of searching module
Second storage module 310.Wherein, import modul 301, the first receiving module 302, the second receiving module 303, respond module 304,
The structure of transfer module 305 can be found in the associated description of embodiment illustrated in fig. 3, and this will not be repeated here.
Import modul 301, for importing the data information for data processing.
Third receiving module 306, the selection instruction for receiving client input in the first receiving module, from the data
Selected in information the data information that the selection instruction selects as data item information before, receive that the client submits takes
The data access entitlement of user information at least one user is asked.
Wherein, the user information must include that can uniquely determine the user identifier of user, such as user identifier ID.
First storage mould 307, for the user information to be stored in authorization database.
The authorization database can be local data base or network data base.
4th receiving module 308, the data access request submitted for receiving the client, the data access request
Carry the user information of data access user.
In the present embodiment, the selection instruction of client input is received in the first receiving module 302, from the data information
Select the data information that the selection instruction selects as data item information before, need receive client submit carrying data
Access the data access request of the user information of user, such as the user information is user identifier ID, then it can be according to user
Login name and password find user identifier ID.
Searching module 309, for searched in the authorization database data access user user information whether
There are in the authorization database, if so, being exported to the client for prompting the data access user that can input choosing
Select the prompt message of instruction.
Such as：It can be by searching whether there is user identifier identical with user identifier ID in authorization database
ID, and if it exists, then judge the user for authorized user, and prompt message is exported to client where the user, prompt the user
It can be instructed with input selection, carry out the selection of data item information.
First receiving module 302, the selection instruction for receiving client input, from the data information described in selection
The data information that selection instruction selects is as data item information.
Second receiving module 303, the data for generating target data packet format submitted for receiving the client
The generation of packet is asked, and the target data packet format is the data packet format of target data handling implement, at the target data
Science and engineering tool is one or more of data processing tools, and the generation request carries package name.
Respond module 304, for responding the generation request, according to the data item information, from the data information
Obtain the related data information of the data item information.
Transfer module 305, for using the data item information, the related data information and the package name as
Parameter is transmitted in the data packet of preset structure, to generate the data packet of the target data packet format.
Second storage module 310 is believed for responding the generation request in the respond module according to the data item
Breath, after the related data information for obtaining the data item information in the data information, by the data item information, described
Related data information and the package name are stored in document data base.
Wherein, the document data base can be the databases such as local data base or network data base.Second storage
The data item information, the related data information and the package name can be stored in document data base by storing module 310
In, maintenance and management is carried out to data packet in the future to facilitate.For example, demand according to circumstances, needs in source data item information
On the basis of increase newly an item data item information then can be by package name in document data base to generate new data packet
The corresponding data item information of the package name is inquired, an item number is newly increased by selection again after obtaining source data item information
New data packet is advantageously generated according to item information, then by the second receiving module 303, corresponding module 304, transfer module 305.
For another example, demand according to circumstances needs to delete an item data item information on the basis of source data item information, to generate new number
According to packet, then the corresponding data item information of the package name can be inquired in document data base by package name,
Obtain to delete after source data item information and need the data item information deleted, then by the second receiving module 303, corresponding module 304,
Transfer module 305 advantageously generates new data packet.
Data information of the embodiment of the present invention by importing for data processing, the selection for then receiving client input refer to
It enables, selects the data information that the selection instruction selects as data item information from the data information, pass through customer in response
The generation request for holding the data packet for generating target data packet format for the carrying package name submitted, according to the data
Information, obtains the related data information of the data item information from the data information, then by the data item information, institute
It states related data information and the package name is transmitted to as parameter in the data packet of preset structure, to generate the target
The data packet of data packet format generates the number of data processing tools corresponding format so as to avoid complicated manual operations is used
According to packet, the complexity for the data packet for generating data processing tools corresponding format is reduced, is facilitated to data processing tools phase
Answer the generation of the data packet of format.
Fig. 5 is referred to, is the structural schematic diagram of the embodiment of the first receiving module 302 shown in Fig. 3；The first reception mould
Block 302 may include：Receiving unit 3201, the first searching unit 3202, the first transmission unit 3203, first acquisition unit 3204,
Second searching unit 3205, the second transmission unit 3206, second acquisition unit 3207, determination unit 3208.
Receiving unit 3201, the first data search request submitted for receiving the client, first data are searched
Rope request carries the first search data item.
Wherein, first search data item may include but be not limited to data sheet field Chinese name, tables of data Chinese name, dimension
Spend the data informations such as field Chinese name, dimension name, data source name.
First searching unit 3202, for searching first search data item in the data information, and from described
It is obtained and relevant first search result of first search data item in data information.
Wherein, first search result may include but be not limited to data sheet field Chinese name, data sheet field English name,
The data informations such as tables of data Chinese name, tables of data English name, dimension field Chinese name, dimension name.It, can in the embodiment of the present invention
To take global search technology to carry out the search of data item, such as：When first search data item of input is issued volume, first searches
Hitch fruit may include the data fields Chinese names such as issued volume, accumulative issued volume, wealth card issued volume, can also include the data word
The data informations such as the corresponding tables of data Chinese name of section.
First transmission unit 3203, for sending first search result to the client.
First acquisition unit 3204, the first choice chosen from first search result for obtaining the client
Information, the first choice information carry the second data search request.
Wherein, the first choice information can be an item data literary name section Chinese name or dimension field Chinese name.
Second searching unit 3205, for searching the first choice information in the data information, and from the number
It is believed that being obtained and relevant second search result of the first choice information in breath.
Wherein, second search result may include the data informations such as tables of data Chinese name and dimension name.
For example, when first choice information is data sheet field Chinese name, the second search result can be data sheet field
The Chinese name and dimension name of tables of data corresponding to Chinese name.
Second transmission unit 3206, for sending second search result to the client.
Second acquisition unit 3207, the second selection chosen from second search result for obtaining the client
Information.
Wherein, the second selection information may include data sheet field Chinese name, dimension name etc..
Determination unit 3208, for the first choice information and second of selection information to be determined as the data
Item information.
Fig. 6 is referred to, is the structural schematic diagram of the embodiment of transfer module 305 shown in Fig. 3；The transfer module 305 can
Including：Construction unit 3501, third acquiring unit 3502.
The data item information and the related data information are built into data item tree by construction unit 3501.
In the present embodiment, such as：When the related data information is data source name, data table name and data literary name
When name section, then data source name, data table name and data literary name name section are generated into nodal information, then by these nodes
It carries out assembling and generates data item tree.
Third acquiring unit 3502, for obtaining the data item information and the dependency number from data item tree it is believed that
Breath, preset structure is transmitted to using the data item information, the related data information and the package name as parameter
In data packet, to generate the data packet of the target data packet format.
For example, in the present embodiment, the data item letter can be obtained from data item tree by ergodic data Xiang Shu
Breath, the related data information and package name, then using they as parameter be transmitted to preset structure physical layer, logical layer,
In represent layer, to generate the data packet of data processing tools.
Data information of the embodiment of the present invention by importing for data processing, the selection for then receiving client input refer to
It enables, selects the data information that the selection instruction selects as data item information from the data information, pass through customer in response
The generation request for holding the data packet for generating target data packet format for the carrying package name submitted, according to the data
Information, obtains the related data information of the data item information from the data information, then by the data item information, institute
It states related data information and the package name is transmitted to as parameter in the data packet of preset structure, to generate the target
The data packet of data packet format generates the number of data processing tools corresponding format so as to avoid complicated manual operations is used
According to packet, the complexity for the data packet for generating data processing tools corresponding format is reduced, is facilitated to data processing tools phase
Answer the generation of the data packet of format.
Claims (6)
1. a kind of method for the data packet generating data processing tools, which is characterized in that including：
Import the data information for data processing；
The selection instruction for receiving client input selects the data information of the selection instruction selection to make from the data information
For data item information；
Receive the generation request for the data packet for generating target data packet format that the client is submitted, the target data
Packet format is the data packet format of target data handling implement, and the target data handling implement is one in data processing tools
Kind is a variety of, and the generation request carries package name；
The generation request is responded, according to the data item information, the data item information is obtained from the data information
Related data information, when the data item information is data field Chinese name, the related data information is the data item
The Chinese name of tables of data and the data item information where the corresponding data sheet field English name of information, the data item information
Corresponding dimension name；
The data item information and the related data information are built into data item tree；
The data item information and the related data information are obtained from data item tree, by the data item information, the phase
It closes data information and the package name is transmitted to as parameter in the data packet of preset structure, to generate the target data
The data packet of packet format；
Wherein, the selection instruction for receiving client input selects the selection instruction selection from the data information
Data information includes as data item information：
The first data search request that the client is submitted is received, first data search request carries the first search number
According to item；
First search data item is searched in the data information, and is obtained from the data information and searched with described first
Relevant first search result of rope data item, first search result include data sheet field Chinese name；
First search result is sent to the client；
The first choice information that the client is chosen from first search result is obtained, the first choice information carries
There is the second data search request；
The first choice information is searched in the data information, and is obtained and the first choice from the data information
Relevant second search result of information, when first choice information is data sheet field Chinese name, the second search result packet
Include the Chinese name and dimension name of the tables of data corresponding to the first choice information；
Second search result is sent to the client；
Obtain the second selection information that the client is chosen from second search result；
The first choice information and the second selection information are determined as the data item information.
2. the method as described in claim 1, which is characterized in that the selection instruction for receiving client input, from the number
It is believed that breath in select the data information that the selection instruction selects as data item information before, further include：
Receive the data access entitlement request for the user information for carrying at least one user that the client is submitted；
The user information is stored in authorization database；
The data access request that the client is submitted is received, the data access request carries user's letter of data access user
Breath；
The user information that the data access user is searched in the authorization database whether there is in the authorization database,
If so, to the client output for prompt the data access user can input selection instruct prompt message.
3. the method as described in claim 1, which is characterized in that the response generation request is believed according to the data item
It ceases, after the related data information for obtaining the data item information in the data information, further includes：
The data item information, the related data information and the package name are stored in document data base.
4. a kind of device for the data packet generating data processing tools, which is characterized in that including：
Import modul, for importing the data information for data processing；
First receiving module, the selection instruction for receiving client input select the selection to refer to from the data information
Enable the data information selected as data item information；
Second receiving module, the generation for receiving the data packet for generating target data packet format that the client is submitted
Request, the target data packet format are the data packet format of target data handling implement, and the target data handling implement is
One or more of data processing tools, the generation request carry package name；
Respond module, for responding the generation request, according to the data item information, from the data information described in acquisition
The related data information of data item information, when the data item information is data field Chinese name, the related data information
For the Chinese name of tables of data and institute where the corresponding data sheet field English name of the data item information, the data item information
State the corresponding dimension name of data item information；
The data item information and the related data information are built into data item tree by construction unit；
Third acquiring unit will be described for obtaining the data item information and the related data information from data item tree
Data item information, the related data information and the package name are transmitted to as parameter in the data packet of preset structure,
To generate the data packet of the target data packet format；
Wherein, first receiving module includes：
Receiving unit, the first data search request submitted for receiving the client, first data search request are taken
With the first search data item；
First searching unit, for searching first search data item in the data information, and from the data information
Middle acquisition and relevant first search result of first search data item, first search result includes in data sheet field
Literary fame；
First transmission unit, for sending first search result to the client；
First acquisition unit, the first choice information chosen from first search result for obtaining the client, institute
It states first choice information and carries the second data search request；
Second searching unit, for searching the first choice information in the data information, and from the data information
Acquisition and relevant second search result of the first choice information, when first choice information is data sheet field Chinese name,
Second search result includes the Chinese name and dimension name of the tables of data corresponding to the first choice information；
Second transmission unit, for sending second search result to the client；
Second acquisition unit, the second selection information chosen from second search result for obtaining the client；
Determination unit, for the first choice information and the second selection information to be determined as the data item information.
5. device as claimed in claim 4, which is characterized in that
Third receiving module, the selection instruction for receiving client input in the first receiving module, from the data information
Select the data information that the selection instruction selects as data item information before, receive that the client submits carry to
The data access entitlement request of the user information of a few user；
First storage module, for the user information to be stored in authorization database；
4th receiving module, the data access request submitted for receiving the client, the data access request carry number
According to the user information for accessing user；
Searching module, for searching the user information of the data access user in the authorization database with the presence or absence of described
In authorization database, if so, to the client output for prompt the data access user can input selection instruct
Prompt message.
6. device as claimed in claim 4, which is characterized in that
Second storage module is asked for responding generations in the respond module, according to the data item information, from described
After the related data information for obtaining the data item information in data information, by the data item information, the related data
Information and the package name are stored in document data base.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201410594884.8A CN104461494B (en) | 2014-10-29 | 2014-10-29 | A kind of method and device for the data packet generating data processing tools |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201410594884.8A CN104461494B (en) | 2014-10-29 | 2014-10-29 | A kind of method and device for the data packet generating data processing tools |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN104461494A CN104461494A (en) | 2015-03-25 |
| CN104461494B true CN104461494B (en) | 2018-10-26 |
Family
ID=52907606
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201410594884.8A Active CN104461494B (en) | 2014-10-29 | 2014-10-29 | A kind of method and device for the data packet generating data processing tools |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN104461494B (en) |
Families Citing this family (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106528272B (en) * | 2016-10-18 | 2019-08-27 | 北京用友薪福社云科技有限公司 | A kind of data processing equipment, method and terminal |
| CN112883425B (en) * | 2021-03-26 | 2023-05-16 | 重庆度小满优扬科技有限公司 | Block chain-based data processing method and block chain link point |
Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101044472A (en) * | 2004-08-31 | 2007-09-26 | 国际商业机器公司 | Methods and systems for semantic identification in data systems |
| CN101826185A (en) * | 2010-05-20 | 2010-09-08 | 中国农业大学 | WebGIS irrigation area management method of shared data and realization system thereof |
| CN102640146A (en) * | 2009-09-11 | 2012-08-15 | 萨姆万斯集团知识产权控股私人有限公司 | Database searching method, system and controller |
| CN103092980A (en) * | 2013-01-31 | 2013-05-08 | 中国科学院自动化研究所 | Method and system of data automatic conversion and storage |
| CN103092993A (en) * | 2013-02-18 | 2013-05-08 | 五八同城信息技术有限公司 | Data exporting method and data exporting device |
| CN103577611A (en) * | 2013-11-25 | 2014-02-12 | 方正国际软件有限公司 | Data unifying device and data unifying method |
| CN103678442A (en) * | 2012-08-30 | 2014-03-26 | 国际商业机器公司 | Method and system of database table format conversion based on user data access patterns |
Family Cites Families (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| WO2001052117A2 (en) * | 2000-01-10 | 2001-07-19 | Science Applications International Corporation | 'data integrator' system for collecting, fusing and displaying information including persistent connection and storage arrangement |
-
2014
- 2014-10-29 CN CN201410594884.8A patent/CN104461494B/en active Active
Patent Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101044472A (en) * | 2004-08-31 | 2007-09-26 | 国际商业机器公司 | Methods and systems for semantic identification in data systems |
| CN102640146A (en) * | 2009-09-11 | 2012-08-15 | 萨姆万斯集团知识产权控股私人有限公司 | Database searching method, system and controller |
| CN101826185A (en) * | 2010-05-20 | 2010-09-08 | 中国农业大学 | WebGIS irrigation area management method of shared data and realization system thereof |
| CN103678442A (en) * | 2012-08-30 | 2014-03-26 | 国际商业机器公司 | Method and system of database table format conversion based on user data access patterns |
| CN103092980A (en) * | 2013-01-31 | 2013-05-08 | 中国科学院自动化研究所 | Method and system of data automatic conversion and storage |
| CN103092993A (en) * | 2013-02-18 | 2013-05-08 | 五八同城信息技术有限公司 | Data exporting method and data exporting device |
| CN103577611A (en) * | 2013-11-25 | 2014-02-12 | 方正国际软件有限公司 | Data unifying device and data unifying method |
Also Published As
| Publication number | Publication date |
|---|---|
| CN104461494A (en) | 2015-03-25 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| Kumar Kaliyar | Graph databases: A survey | |
| CN104767813B (en) | Public's row big data service platform based on openstack | |
| CN102193917B (en) | Method and device for processing and querying data | |
| US9317711B2 (en) | Privacy restrictions for columnar storage | |
| CN110019555B (en) | Relation data semantical modeling method | |
| CN103810224A (en) | Information persistence and query method and device | |
| TW201205320A (en) | Optimizing data cache when applying user-based security | |
| CN101582767A (en) | Authorization control method and authorization server | |
| CN102880720B (en) | The management of information resources and semantic retrieving method | |
| CN115757689A (en) | Information query system, method and equipment | |
| US20090265314A1 (en) | Secure file searching | |
| CN107181729B (en) | Data encryption in a multi-tenant cloud environment | |
| Garg et al. | Big data analytics recommendation solutions for crop disease using Hive and Hadoop Platform | |
| Kajáti et al. | Advanced analysis of manufacturing data in Excel and its Add-ins | |
| US9984108B2 (en) | Database joins using uncertain criteria | |
| CN100485688C (en) | Method for structural information issue and search at network environment | |
| US20140365498A1 (en) | Finding A Data Item Of A Plurality Of Data Items Stored In A Digital Data Storage | |
| CN104461494B (en) | A kind of method and device for the data packet generating data processing tools | |
| CN105389330A (en) | Cross-community matched correlation method for open source resources | |
| CN107870935A (en) | A kind of searching method and device | |
| CN111143356B (en) | Report retrieval method and device | |
| US20210019146A1 (en) | Custom term unification for analytical usage | |
| US10423629B2 (en) | Intelligent tabular big data presentation in search environment based on prior human input configuration | |
| CN103020300B (en) | Method and device for information retrieval | |
| RU2396593C2 (en) | Method for searching data on objects and in various databases and system for its realisation |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |