CN108170718A - A kind for the treatment of method and apparatus of achievement data - Google Patents
A kind for the treatment of method and apparatus of achievement data Download PDFInfo
- Publication number
- CN108170718A CN108170718A CN201711271131.3A CN201711271131A CN108170718A CN 108170718 A CN108170718 A CN 108170718A CN 201711271131 A CN201711271131 A CN 201711271131A CN 108170718 A CN108170718 A CN 108170718A
- Authority
- CN
- China
- Prior art keywords
- data
- achievement data
- metadata
- reporting system
- definition
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/23—Updating
- G06F16/2365—Ensuring data consistency and integrity
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
- G06F16/2455—Query execution
-
- 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
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Databases & Information Systems (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Computational Linguistics (AREA)
- Computer Security & Cryptography (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
An embodiment of the present invention provides a kind for the treatment of method and apparatus of achievement data.The method includes：According to the definition metadata of achievement data, business datum is handled, obtain achievement data, database interface based on REST frameworks, which provides, defines metadata, receive the inquiry request of reporting system, the inquiry request defines metadata generation according to described, it searches target indicator data and feeds back to the reporting system, so that the reporting system generates target report according to the target indicator data, so that the definition of achievement data is unified and is hidden in index system, third party's reporting system need to only pay close attention to the use of achievement data, the definition of achievement data need not be paid close attention to, and due to using the database interface based on REST frameworks, it realizes when achievement data definition is changed, it can be synchronized to third party's reporting system immediately, it ensure that the consistency that the achievement data of generation report is defined with achievement data.
Description
Technical field
The present invention relates to technical field of data processing, more particularly to a kind for the treatment of method and apparatus of achievement data.
Background technology
Enterprise can carry out the statistic analysis of a large amount of business datum during management, but each business department
Door defines disunity with branch for the bore of statistical analysis so that the definition of identical achievement data is present in different institutions
Different system in, even if having built the achievement data system of unified management, also because the definition bore of achievement data is stored in
INDEX MANAGEMENT system, the definition bore of achievement data can only be accessed by the application module that itself is integrated, can not be with third
Square tool realizes Seamless integration-.
Third party's tool system exports data from achievement data system, Ran Hou usually in a manner of data file
After tripartite's system introducing, being utilized so that data, which replicate, generates mass data redundancy, and operating process is cumbersome, and efficiency is low, and
And the definition adjustment of achievement data is difficult to synchronize, and can not ensure the uniformity that achievement data is defined with achievement data, it is even more impossible to realities
Existing achievement data defines coming into force in real time for modification.
Invention content
In view of the above problems, it is proposed that the present invention overcomes the above problem in order to provide one kind or solves at least partly
State a kind for the treatment of method and apparatus of achievement data of problem.
One side according to the present invention provides a kind of processing method of achievement data, including：
According to the definition metadata of achievement data, business datum is handled, obtains achievement data, the first number of definition
According to the regular mark with achievement data of processing for defining business datum；
Database interface based on REST frameworks provides the definition metadata；
The inquiry request of reporting system is received, the inquiry request carries the mark of the achievement data of acquisition request, described
Inquiry request defines metadata generation according to described；
It searches target indicator data and feeds back to the reporting system, so that the reporting system is according to the target indicator
Data generate target report.
Optionally, the database interface of the REST frameworks includes JDBC interfaces or ODBC interfaces, and REST is based on described
Before the database interface of framework provides the definition metadata, the method further includes：
JDBC drivings or ODBC drivings are provided, establishing JDBC corresponding with the REST frameworks for the reporting system connects
Mouth or ODBC interfaces.
Optionally, the metadata that defines includes the dimension mark of achievement data and measures mark, and the inquiry request is led to
Cross the dimension mark for quoting the achievement data and measurement mark generation.
Optionally, it the lookup target indicator data and feeds back to the reporting system and includes：
The target indicator data are back to reporting system in a manner of result set or Json specifications.
Optionally, the inquiry request is transmitted by the database interface based on REST frameworks.
According to another aspect of the present invention, a kind of processing unit of achievement data is provided, including：
Data processing module for the definition metadata according to achievement data, handles business datum, obtains index
The mark of data, the processing rule for defining metadata definition business datum and achievement data；
Metadata provides module, for providing the definition metadata based on the database interface of REST frameworks；
Request receiving module, for receiving the inquiry request of reporting system, the inquiry request carries the finger of acquisition request
The mark of data is marked, the inquiry request is generated according to the metadata that defines；
Data feedback module, for searching target indicator data and feeding back to the reporting system, for the report system
System generates target report according to the target indicator data.
Optionally, the database interface of the REST frameworks includes JDBC interfaces or ODBC interfaces, described device further include：
Driving provides module, for the database interface based on REST frameworks provide it is described define metadata it
Before, JDBC drivings or ODBC drivings are provided, for the reporting system establish corresponding with REST frameworks JDBC interfaces or
ODBC interfaces.
Optionally, the metadata that defines includes the dimension mark of achievement data and measures mark, and the inquiry request is led to
Cross the dimension mark for quoting the achievement data and measurement mark generation.
Optionally, the data feedback module, specifically for the target indicator data are advised with result set or Json
The mode of model is back to reporting system.
Optionally, the inquiry request is transmitted by the database interface based on REST frameworks.
In conclusion embodiment according to the present invention, by the definition metadata according to achievement data, carries out business datum
Processing obtains the mark of achievement data, the processing rule for defining metadata definition business datum and achievement data, is based on
The database interface of REST frameworks provides the definition metadata, receives the inquiry request of reporting system, and the inquiry request is taken
The mark of achievement data with acquisition request, the inquiry request are generated according to the metadata that defines, and search target indicator number
According to and feed back to the reporting system, so that the reporting system generates target report according to the target indicator data so that
The definition of achievement data is unified and is hidden in index system, and third party's reporting system need to only pay close attention to the use of achievement data, nothing
The definition of achievement data need to be paid close attention to, and due to using the database interface based on REST frameworks, realizes and determines in achievement data
When justice changes, it can be synchronized to third party's reporting system immediately, ensure that the achievement data and achievement data of generation report
The consistency of definition.
Description of the drawings
Fig. 1 shows a kind of step flow chart of embodiment of the processing method of achievement data of the present invention；
Fig. 2 shows the step flow charts of another embodiment of the processing method of achievement data of the present invention；
Fig. 3 shows a kind of structure diagram of embodiment of the processing unit of achievement data of the present invention.
Specific embodiment
In order to make the foregoing objectives, features and advantages of the present invention clearer and more comprehensible, it is below in conjunction with the accompanying drawings and specific real
Applying mode, the present invention is described in further detail.
With reference to Fig. 1, show a kind of step flow chart of embodiment of the processing method of achievement data of the present invention, specifically may be used
To include the following steps：
Step 101, according to the definition metadata of achievement data, business datum is handled, obtains achievement data.
Achievement data includes the numerical value that entity is weighed from multiple angles, for example, every deposit, to public affairs deposit etc., Huo Zheqi
His any suitable data, the embodiment of the present invention are without limitation.
Metadata, also known as broker data, relaying data are defined, to describe the data of data, mainly describes data attribute
Information, for support such as indicate storage location, historical data, resource lookup, file record function.Metadata is a kind of at last
Electronic type catalogue, in order to achieve the purpose that scheduling, it is necessary to describe and collect perhaps characteristic, and then reach association in data
Help the purpose of data retrieval.The information that metadata is the tissue about data, data field and its relationship is defined, in short, definition
Metadata is exactly the data about data.
Business datum include with the relevant arbitrary data of business, for example, so-and-so so-and-so subbranch Mr. Yu year in such a month, and on such a day certain
The deposit of certain amount of money or so-and-so company in so-and-so in such a month, and on such a day loan of so-and-so amount of money etc. or any other in subbranch Mr. Yu year
Applicable is data, and the embodiment of the present invention is without limitation.
In embodiments of the present invention, the processing rule of metadata definition business datum and the mark of achievement data are defined, is pressed
According to the processing rule for defining metadata, business datum is handled, it is possible to obtain achievement data, and definition member can be used
The mark reference achievement data of the achievement data of data definition.
In embodiments of the present invention, the definition metadata of achievement data is defined in achievement data system, for example, respectively
Item is deposited, to public deposit, savings account, every loan etc., business datum can be handled in achievement data system, tool
Body can be handled according to metadata is defined, and obtain achievement data.For example, it is deposited according to items, to indexs numbers such as public affairs deposits
According to definition metadata, the processing such as plus and minus calculation are carried out to business datum, obtain achievement data.
In embodiments of the present invention, business datum obtains achievement data after treatment, storage to achievement data system
Accumulation layer, so that reporting system uses.
By taking each site loans and deposits situation daily paper of bank as an example, such as the following table 1：
Each site loans and deposits situation daily paper of full row
Tabulation department：XX bank programs Finance Department unit：Wan Yuan
| Line number | Subbranch's title | Items deposit | Public affairs are deposited | Savings account | Items loan |
| 1 | Linchpin summarizes entirely for ×× bank | ||||
| 2 | Summarize in ×× area | ||||
| 3 | ×× banking department (administration) | ||||
| 4 | ×× banking department | ||||
| 5 | ××× subbranch of ×× bank | ||||
| 6 | ××× subbranch of ×× bank | ||||
| 7 | ××× subbranch of ×× bank | ||||
| 8 | ×× subbranch of ×× bank (administration) | ||||
| 9 | ××× subbranch of ×× bank | ||||
| 10 | ××× subbranch of ×× bank | ||||
| 11 | ××× subbranch of ×× bank | ||||
| … | … |
The common statistical forms of bank, " the items deposit " of the inside, " providing a loan public affairs ", " savings account ", " items are borrowed
Money " in the line can there are bores to define difference during different system statistical analysis.
The bore defined in achievement data system is：
Every deposit=savings account+to public deposit+marginal deposit for security；
Public affairs are deposited=to public affairs deposit+small micro- deposit；
Savings account=individual's current deposit+individual's scheduled store；
Items loan=to public loan+personal loan+bill.
Step 102, the database interface based on REST frameworks provides the definition metadata.
REST (Representational State Transfer, declarative state are transmitted) is a kind of software architecture wind
Lattice are a kind of designs and development scheme for network application, can reduce the complexity of exploitation, improve the scalable of system
Property.
Declarative state transfer is one group of framework constraints and principle.It should be noted that REST be design style and
It is not standard.REST is typically based on using HTTP, URI and XML (a subset under standard generalized markup language) and HTML
(application under standard generalized markup language) these existing pandemic agreements and standard.
REST defines one group of architectural framework principle, you can be designed according to these principles centered on system resource
Web service includes the use of the client that different language writes and how to be handled by HTTP and transmission resource state.If it is considered that make
With the quantity of its Web service, REST has become most important Web service design pattern in recent years.In fact, REST pairs
The influence of Web is very big, since its use is quite convenient, generally instead of the Interface design based on SOAP and WSDL.
Resource in REST it is signified be not data, but the combination of data and the form of expression, such as " the 10 of newest access
Position member " and " most active 10 members " may have in data to be overlapped or identical, and due to their performance shape
Formula is different, so being classified as different resources, namely why the full name of REST is Representational State for this
The reason of Transfer.Resource identifier is exactly URI (Uniform Resource Identifier), either picture, Word
Or video file or even a kind of only virtual service, are an XML (sons under standard generalized markup language regardless of you
Collection) form, txt-formatted file or other file formats, all resource is uniquely identified by URI.
Database interface is the technology being connect with Database, for example, ODBC (Open Database
Connectivity, open CNC) interface, JDBC (Java DataBase Connectivity, java database connect
Connecing) interface, the database interface based on REST or any other applicable interface, the embodiment of the present invention be not restricted this.
In embodiments of the present invention, reporting system is supplied to by metadata is defined by the database interface of REST frameworks,
So that reporting system generates report.For example, the Virtual table defined with achievement data, reporting system can be referred to by defining metadata
Can these Virtual tables be obtained by corresponding database interface.
Step 103, the inquiry request of reporting system is received.
In embodiments of the present invention, reporting system can obtain required finger for generating report from achievement data system
Data are marked, reporting system can send inquiry request to achievement data system.Inquiry request carries the achievement data of acquisition request
Mark, and the definition metadata that inquiry request is provided according to achievement data system generates, for example, reporting system can be BI
(Business Intelligence, business intelligence) analysis tool, can develop report, can directly lead in reporting system
Drag operation reference report data is crossed, forms report definition.
Step 104, target indicator data are searched and feed back to the reporting system, so that the reporting system is according to
Target indicator data generate target report.
In embodiments of the present invention, according to inquiry request, the corresponding target indicator of achievement data system searching inquiry request
Data, and reporting system is fed back to, so that reporting system generates target report according to target indicator data.
In conclusion embodiment according to the present invention, by the definition metadata according to achievement data, carries out business datum
Processing obtains the mark of achievement data, the processing rule for defining metadata definition business datum and achievement data, is based on
The database interface of REST frameworks provides the definition metadata, receives the inquiry request of reporting system, and the inquiry request is taken
The mark of achievement data with acquisition request, the inquiry request are generated according to the metadata that defines, and search target indicator number
According to and feed back to the reporting system, so that the reporting system generates target report according to the target indicator data so that
The definition of achievement data is unified and is hidden in index system, and third party's reporting system need to only pay close attention to the use of achievement data, nothing
The definition of achievement data need to be paid close attention to, and due to using the database interface based on REST frameworks, realizes and determines in achievement data
When justice changes, it can be synchronized to third party's reporting system immediately, ensure that the achievement data and achievement data of generation report
The consistency of definition.
In embodiments of the present invention, it is preferable that the metadata that defines includes the dimension mark of achievement data and measurement mark
Know, by quoting, the dimension of the achievement data identifies the inquiry request and measurement identifies generation.Dimension is achievement data
Grouped data, for representing the angle of observation, statistics entity, such as time limit, asset quality etc..Measurement is quantifying for achievement data
Data, for representing to measure entity attributes, such as remaining sum etc..It defines metadata and includes dimension mark and measurement mark.It looks into
Asking request can be generated by quoting dimension mark and the measurement mark of achievement data.
The dimension and measurement of index are issued as the Virtual table of operation layer, and field name is Chinese Chinese, convenient for business
It uses.The table that third party system (such as reporting system) can obtain these Virtual tables by way of JDBC/ODBC interfaces is determined
Justice.
In embodiments of the present invention, it is preferable that inquiry request is transmitted by the database interface based on REST frameworks.Inquiry
It can also be transmitted based on the database interface of REST frameworks that request is transferred to achievement data system from reporting system.Third
Method, system (for example, reporting system) achievement data is inquired or statistical analysis during, JDBC or ODBC etc. can be passed through
The database interface of REST frameworks sends SQL query statement to achievement data system.
With reference to Fig. 2, the step flow chart of another embodiment of the processing method of achievement data of the present invention is shown, specifically
It may include steps of：
Step 201, according to the definition metadata of achievement data, business datum is handled, obtains achievement data.
Step 202, JDBC drivings or ODBC drivings are provided, so that reporting system foundation is corresponding with the REST frameworks
JDBC interfaces or ODBC interfaces.
The database interface of REST frameworks includes JDBC interfaces or ODBC interfaces.
JDBC is a kind of Java API for being used to perform SQL statement, and unified access can be provided for a variety of relational databases,
The class and interface that it is write by one group with Java language form.JDBC provides a kind of benchmark, can build accordingly more advanced
Tool and interface enable database development personnel to write database application.
ODBC is a component part in relation to database in Microsoft's open services architecture, it establishes one group of rule
Model, and provide one group of standard API (application programming interface) to database access.These API complete it using SQL
Most of task.ODBC also provides the support to sql like language in itself, and user directly can give SQL statement to ODBC.
If reporting system drives without JDBC or ODBC drives, it can be driven by network transmission JDBC and ODBC drives
It is dynamic, so that reporting system installation JDBC drivings or ODBC drivings, establish JDBC corresponding with the REST frameworks of achievement data system
Interface or ODBC interfaces.
In embodiments of the present invention, according to the specification of JDBC or ODBC, the mode based on REST is realized in JDBC or ODBC
The methods of basic connect (connection), retrieve MetaData (retrieval metadata), execute (execution).
In embodiments of the present invention, the JDBC drivings or ODBC drivings that reporting system is provided by achievement data system will be fixed
The dimension and the chinese metadata of measure statistical value that adopted metadata includes imported into report software, without being defined metadata
Semantic translation link.
Step 203, the database interface based on REST frameworks provides the definition metadata.
Step 204, the inquiry request of reporting system is received.
Step 205, the target indicator data are back to reporting system in a manner of result set or Json specifications, with
For the reporting system target report is generated according to the target indicator data.
Result set is that object includes all row sets for meeting SQL statement conditional.It by a set of get methods, these
Get methods can access the different lines in current line, provide the access to data in these rows.Result set is usually one
Table inquires returned column heading and corresponding value wherein having.
Json (JavaScript Object Notation, JS object tag) is a kind of data exchange lattice of lightweight
Formula.It is based on a subset of ECMAScript (the js specifications that w3c is formulated), using the text lattice for being totally independent of programming language
Formula stores and represents data.It is succinct JSON to be caused to become ideal data interchange language with clearly hierarchical structure.It is easy to people
It reads and writes, while be also easy to machine parsing and generation, and effectively promote network transmission efficiency.
In embodiments of the present invention, it after finding target indicator data, is back in a manner of result set or Json specifications
Reporting system.
In conclusion embodiment according to the present invention, by the definition metadata according to achievement data, carries out business datum
Processing, obtains achievement data, JDBC drivings or ODBC drivings is provided, so that the reporting system is established and the REST frameworks pair
The JDBC interface or ODBC interfaces answered, the database interface based on REST frameworks provide the definition metadata, receive report system
The target indicator data are back to reporting system by the inquiry request of system in a manner of result set or Json specifications, for
The reporting system generates target report according to the target indicator data so that the definition of achievement data unifies and is hidden in finger
In mark system, third party's reporting system need to only pay close attention to the use of achievement data, without paying close attention to the definition of achievement data, and due to
It using the database interface based on REST frameworks, realizes when achievement data definition is changed, the can be synchronized to immediately
Tripartite's reporting system ensure that the consistency that the achievement data of generation report is defined with achievement data.
It should be noted that for embodiment of the method, in order to be briefly described, therefore it is all expressed as to a series of action group
It closes, but those skilled in the art should know, the embodiment of the present invention is not limited by described sequence of movement, because according to
According to the embodiment of the present invention, certain steps may be used other sequences or be carried out at the same time.Secondly, those skilled in the art also should
Know, embodiment described in this description belongs to preferred embodiment, and the involved action not necessarily present invention is implemented
Necessary to example.
With reference to Fig. 3, a kind of structure diagram of embodiment of the processing unit of achievement data of the present invention is shown, it specifically can be with
Including following module：
Data processing module 301 for the definition metadata according to achievement data, handles business datum, obtains
The mark of achievement data, the processing rule for defining metadata definition business datum and achievement data；
Metadata provides module 302, for providing the definition metadata based on the database interface of REST frameworks；
Request receiving module 303, for receiving the inquiry request of reporting system, the inquiry request carries acquisition request
The mark of achievement data, the inquiry request are generated according to the metadata that defines；
Data feedback module 304, for searching target indicator data and feeding back to the reporting system, for the report
System generates target report according to the target indicator data.
In embodiments of the present invention, it is preferable that the database interface of the REST frameworks includes JDBC interfaces or ODBC connects
Mouthful, described device further includes：
Driving provides module, for the database interface based on REST frameworks provide it is described define metadata it
Before, JDBC drivings or ODBC drivings are provided, for the reporting system establish corresponding with REST frameworks JDBC interfaces or
ODBC interfaces.
In embodiments of the present invention, it is preferable that the metadata that defines includes the dimension mark of achievement data and measurement mark
Know, by quoting, the dimension of the achievement data identifies the inquiry request and measurement identifies generation.
In embodiments of the present invention, it is preferable that the data feedback module, specifically for by the target indicator data with
The mode of result set or Json specifications is back to reporting system.
In embodiments of the present invention, it is preferable that the inquiry request is transmitted by the database interface based on REST frameworks.
In conclusion embodiment according to the present invention, by the definition metadata according to achievement data, carries out business datum
Processing obtains the mark of achievement data, the processing rule for defining metadata definition business datum and achievement data, is based on
The database interface of REST frameworks provides the definition metadata, receives the inquiry request of reporting system, and the inquiry request is taken
The mark of achievement data with acquisition request, the inquiry request are generated according to the metadata that defines, and search target indicator number
According to and feed back to the reporting system, so that the reporting system generates target report according to the target indicator data so that
The definition of achievement data is unified and is hidden in index system, and third party's reporting system need to only pay close attention to the use of achievement data, nothing
The definition of achievement data need to be paid close attention to, and due to using the database interface based on REST frameworks, realizes and determines in achievement data
When justice changes, it can be synchronized to third party's reporting system immediately, ensure that the achievement data and achievement data of generation report
The consistency of definition.
For device embodiment, since it is basicly similar to embodiment of the method, so description is fairly simple, it is related
Part illustrates referring to the part of embodiment of the method.
Each embodiment in this specification is described by the way of progressive, the highlights of each of the examples are with
The difference of other embodiment, just to refer each other for identical similar part between each embodiment.
It should be understood by those skilled in the art that, the embodiment of the embodiment of the present invention can be provided as method, apparatus or calculate
Machine program product.Therefore, the embodiment of the present invention can be used complete hardware embodiment, complete software embodiment or combine software and
The form of the embodiment of hardware aspect.Moreover, the embodiment of the present invention can be used one or more wherein include computer can
With in the computer-usable storage medium (including but not limited to magnetic disk storage, CD-ROM, optical memory etc.) of program code
The form of the computer program product of implementation.
The embodiment of the present invention be with reference to according to the method for the embodiment of the present invention, terminal device (system) and computer program
The flowchart and/or the block diagram of product describes.It should be understood that flowchart and/or the block diagram can be realized by computer program instructions
In each flow and/or block and flowchart and/or the block diagram in flow and/or box combination.These can be provided
Computer program instructions are set to all-purpose computer, special purpose computer, Embedded Processor or other programmable data processing terminals
Standby processor is to generate a machine so that is held by the processor of computer or other programmable data processing terminal equipments
Capable instruction generation is used to implement in one flow of flow chart or multiple flows and/or one box of block diagram or multiple boxes
The device for the function of specifying.
These computer program instructions, which may also be stored in, can guide computer or other programmable data processing terminal equipments
In the computer-readable memory to work in a specific way so that the instruction being stored in the computer-readable memory generates packet
The manufacture of command device is included, which realizes in one flow of flow chart or multiple flows and/or one side of block diagram
The function of being specified in frame or multiple boxes.
These computer program instructions can be also loaded into computer or other programmable data processing terminal equipments so that
Series of operation steps are performed on computer or other programmable terminal equipments to generate computer implemented processing, thus
The instruction offer performed on computer or other programmable terminal equipments is used to implement in one flow of flow chart or multiple flows
And/or specified in one box of block diagram or multiple boxes function the step of.
Although the preferred embodiment of the embodiment of the present invention has been described, those skilled in the art once know base
This creative concept can then make these embodiments other change and modification.So appended claims are intended to be construed to
Including preferred embodiment and fall into all change and modification of range of embodiment of the invention.
Finally, it is to be noted that, herein, relational terms such as first and second and the like be used merely to by
One entity or operation are distinguished with another entity or operation, without necessarily requiring or implying these entities or operation
Between there are any actual relationship or orders.Moreover, term " comprising ", "comprising" or its any other variant meaning
Covering non-exclusive inclusion, so that process, method, article or terminal device including a series of elements are not only wrapped
Those elements are included, but also including other elements that are not explicitly listed or are further included as this process, method, article
Or the element that terminal device is intrinsic.In the absence of more restrictions, it is wanted by what sentence "including a ..." limited
Element, it is not excluded that also there are other identical elements in the process including the element, method, article or terminal device.
It above to a kind for the treatment of method and apparatus of achievement data provided by the present invention, is described in detail, herein
In apply specific case the principle of the present invention and embodiment be expounded, the explanation of above example is only intended to sides
Assistant solves the method and its core concept of the present invention；Meanwhile for those of ordinary skill in the art, think of according to the present invention
Think, in specific embodiments and applications there will be changes, in conclusion the content of the present specification should not be construed as pair
The limitation of the present invention.
Claims (10)
1. a kind of processing method of achievement data, which is characterized in that including：
According to the definition metadata of achievement data, business datum is handled, obtains achievement data, the metadata that defines is determined
The processing rule of adopted business datum and the mark of achievement data；
Database interface based on REST frameworks provides the definition metadata；
The inquiry request of reporting system is received, the inquiry request carries the mark of the achievement data of acquisition request, the inquiry
Request defines metadata generation according to described；
It searches target indicator data and feeds back to the reporting system, so that the reporting system is according to the target indicator data
Generate target report.
2. according to the method described in claim 1, it is characterized in that, the database interface of the REST frameworks includes JDBC interfaces
Or ODBC interfaces, before the database interface based on REST frameworks provides the definition metadata, the method is also wrapped
It includes：
JDBC drivings or ODBC drivings are provided, for the reporting system establish corresponding with REST frameworks JDBC interfaces or
ODBC interfaces.
3. the according to the method described in claim 1, it is characterized in that, dimension mark for defining metadata and including achievement data
It is identified with measurement, by quoting, the dimension of the achievement data identifies the inquiry request and measurement identifies generation.
4. according to the method described in claim 1, it is characterized in that, described search target indicator data and feed back to the report
System includes：
The target indicator data are back to reporting system in a manner of result set or Json specifications.
5. according to the method described in claim 1, it is characterized in that, the inquiry request passes through the database based on REST frameworks
Interface transmits.
6. a kind of device of the processing of achievement data, which is characterized in that including：
Data processing module for the definition metadata according to achievement data, handles business datum, obtains index number
According to the mark of the processing rule for defining metadata definition business datum and achievement data；
Metadata provides module, for providing the definition metadata based on the database interface of REST frameworks；
Request receiving module, for receiving the inquiry request of reporting system, the inquiry request carries the index number of acquisition request
According to mark, the inquiry request according to it is described define metadata generate；
Data feedback module, for searching target indicator data and feeding back to the reporting system, for the reporting system root
Target report is generated according to the target indicator data.
7. device according to claim 6, which is characterized in that the database interface of the REST frameworks includes JDBC interfaces
Or ODBC interfaces, described device further include：
Driving provides module, for before the database interface based on REST frameworks provides the definition metadata, carrying
For JDBC drivings or ODBC drivings, so that reporting system foundation JDBC interfaces corresponding with the REST frameworks or ODBC connect
Mouthful.
8. device according to claim 6, which is characterized in that the dimension mark for defining metadata and including achievement data
It is identified with measurement, by quoting, the dimension of the achievement data identifies the inquiry request and measurement identifies generation.
9. device according to claim 6, which is characterized in that the data feedback module, specifically for by the target
Achievement data is back to reporting system in a manner of result set or Json specifications.
10. device according to claim 6, which is characterized in that the inquiry request passes through the data based on REST frameworks
Bank interface transmits.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201711271131.3A CN108170718A (en) | 2017-12-05 | 2017-12-05 | A kind for the treatment of method and apparatus of achievement data |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201711271131.3A CN108170718A (en) | 2017-12-05 | 2017-12-05 | A kind for the treatment of method and apparatus of achievement data |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN108170718A true CN108170718A (en) | 2018-06-15 |
Family
ID=62525172
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201711271131.3A Pending CN108170718A (en) | 2017-12-05 | 2017-12-05 | A kind for the treatment of method and apparatus of achievement data |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN108170718A (en) |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109542954A (en) * | 2018-11-30 | 2019-03-29 | 长城计算机软件与***有限公司 | A kind of data query method and system of unified interface |
| CN109740134A (en) * | 2018-12-17 | 2019-05-10 | 泰康保险集团股份有限公司 | Report generation method and device |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1588369A (en) * | 2004-09-06 | 2005-03-02 | 杭州恒生电子股份有限公司 | Relation type data base system and its search and report method |
| CN104504028A (en) * | 2014-12-15 | 2015-04-08 | 浪潮通用软件有限公司 | Index value calculation method, device and system |
| CN104536982A (en) * | 2014-12-08 | 2015-04-22 | 北京用友政务软件有限公司 | Data processing method and data processing device |
| US20150199399A1 (en) * | 2014-01-10 | 2015-07-16 | Sebastian Schroetel | Query generator |
| CN106776834A (en) * | 2016-11-28 | 2017-05-31 | 中通服公众信息产业股份有限公司 | A kind of data analysis based on index is from access method and system |
-
2017
- 2017-12-05 CN CN201711271131.3A patent/CN108170718A/en active Pending
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1588369A (en) * | 2004-09-06 | 2005-03-02 | 杭州恒生电子股份有限公司 | Relation type data base system and its search and report method |
| US20150199399A1 (en) * | 2014-01-10 | 2015-07-16 | Sebastian Schroetel | Query generator |
| CN104536982A (en) * | 2014-12-08 | 2015-04-22 | 北京用友政务软件有限公司 | Data processing method and data processing device |
| CN104504028A (en) * | 2014-12-15 | 2015-04-08 | 浪潮通用软件有限公司 | Index value calculation method, device and system |
| CN106776834A (en) * | 2016-11-28 | 2017-05-31 | 中通服公众信息产业股份有限公司 | A kind of data analysis based on index is from access method and system |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109542954A (en) * | 2018-11-30 | 2019-03-29 | 长城计算机软件与***有限公司 | A kind of data query method and system of unified interface |
| CN109740134A (en) * | 2018-12-17 | 2019-05-10 | 泰康保险集团股份有限公司 | Report generation method and device |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US10740429B2 (en) | Apparatus and method for acquiring, managing, sharing, monitoring, analyzing and publishing web-based time series data | |
| US10235430B2 (en) | Systems, methods, and apparatuses for detecting activity patterns | |
| US8812950B2 (en) | Spreadsheet software services | |
| US7657534B2 (en) | Order commitment method and system | |
| CN101131747B (en) | Method, device and system for catching and/or analyzing Web page events at client terminal | |
| US8838627B2 (en) | Systems and methods for providing template based output management | |
| US20100319002A1 (en) | Systems and methods for metadata driven dynamic web services | |
| CN108572963A (en) | Information acquisition method and device | |
| US8352958B2 (en) | Systems and methods for providing a generic audit trail service | |
| WO2007072501A2 (en) | A system and a methodology for providing integrated business performance management platform | |
| CN102687143A (en) | A method and system for implenting definable actions | |
| CN101151592A (en) | De-serializing data objects on demand | |
| CA2511196A1 (en) | System and method for embedding business data in forms | |
| US20110145005A1 (en) | Method and system for automatic business content discovery | |
| CN109002440A (en) | Method, apparatus and system for big data multidimensional analysis | |
| CN103246963A (en) | Staff training system based on Internet of Things | |
| US10698904B1 (en) | Apparatus and method for acquiring, managing, sharing, monitoring, analyzing and publishing web-based time series data | |
| CN108874757A (en) | Report form generation method and system, computer-readable medium, electronic equipment | |
| CN108170718A (en) | A kind for the treatment of method and apparatus of achievement data | |
| US20020116354A1 (en) | Method and system for transforming session data | |
| US20220114483A1 (en) | Unified machine learning feature data pipeline | |
| US20090319429A1 (en) | Systems and methods for cash positioning and reporting | |
| US20140143278A1 (en) | Application programming interface layers for analytical applications | |
| Zhang | 2-Tier Cloud Architecture and Application in Electronic Health Record. | |
| Luo et al. | Web services-based test report generation |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20180615 |
|
| RJ01 | Rejection of invention patent application after publication |