CN105320690B - A kind of statistics list rapid generation and system based on metadata - Google Patents
A kind of statistics list rapid generation and system based on metadata Download PDFInfo
- Publication number
- CN105320690B CN105320690B CN201410370145.0A CN201410370145A CN105320690B CN 105320690 B CN105320690 B CN 105320690B CN 201410370145 A CN201410370145 A CN 201410370145A CN 105320690 B CN105320690 B CN 105320690B
- Authority
- CN
- China
- Prior art keywords
- report
- index
- metadatabase
- definition unit
- unit
- 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
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The present invention provides a kind of statistics list rapid generation and system based on metadata, and system includes metadatabase management module and Report Customization module；Metadatabase management module includes：Attribute metadata library definition unit, measurement unit metadatabase definition unit, classification metadata library definition unit and shared index metadatabase definition unit；Report Customization module includes report attribute definition unit, template definition unit, index definition unit, report style definition unit, administration authority definition unit, access definition unit, preview definition unit；By configuring structure of report rule, when structure of report changes, Report Engine voluntarily adjusts structure of report according to variation, generates new report, improves Report Customization flexibility；Using management model level of control title and Criterion Attribute, when index name and Criterion Attribute variation, it is only necessary to change the metadata in metadatabase, simplify investigation index and customize mode.
Description
Technical field
The present invention relates to a kind of generation methods of list, and in particular to a kind of statistics list based on metadata quickly generates
Method and system.
Background technology
Traditional rural area statistics is mainly acquired by papery questionnaire, i.e.,：Investigator is needed to carry papery questionnaire
It goes to the countryside and registers one's residence, survey data is filled in manually by respondent person, then will fill in the papery of survey data by investigator again
Questionnaire reports step by step.This kind of survey mode has the following problems：Fact-finding process needs to expend a large amount of manpower, adjusts
It looks into of high cost；Fact-finding process needs to use longer time, causes survey data timeliness poor；Audit to investigation result,
It is also required to expend a large amount of time and efforts of investigator, with the low problem of review efficiency.
Invention content
In view of the defects existing in the prior art, the present invention provides a kind of statistics list rapid generation based on metadata
And system, to solve the above problems.
The technical solution adopted by the present invention is as follows：
The present invention provides a kind of statistics list rapid generation based on metadata, includes the following steps：
S1 is created and is safeguarded multiple metadatabases；Each category of the metadatabase for storing report in the form of metadata
Property information, including attribute metadata library, measurement unit metadatabase, classification metadata library and shared index metadatabase；Its
In, attribute metadata library is for storing Criterion Attribute information；Measurement unit metadatabase is used to store the measurement unit letter of index
Breath；Classification metadata library is used to store multiple index name ID by index category classification, also, index classification is in inclusion relation,
Including the 1st grade of index, it is under the jurisdiction of the 2nd grade of index ... of the 1st grade of index according to analogize；Shared index metadatabase is for storing needle
To the mapping relations for the index name ID and index name of authorized user shared for multiple reports；
S2 creates the report form template of blank；
Define total Table Header information of report；Total Table Header information includes table number, report name, formulates organ, code, approval
One or more of code, report classification, report form type and report term of validity；Total Table Header information is defined in report mould simultaneously
Position on plate；
S3, after total Table Header information definition of report is completed, verification of correctness unit believes total gauge outfit of the report
Breath is verified, if be proved to be successful, continues S4；Otherwise, report generation fails；
S4, the main field for defining report form template are set and are set with guest's field, main field set it is upper generate main column, set in guest's field
Generate guest column；Main column and guest column are made of multiple main unit lattice；The intersection region on main column and guest column is data cells；
S5, will be in position relationship of the main unit lattice on each main column in the statistical form generated and each metadatabase
Specific metadata establish binding relationship；Based on the binding relationship, default correspondence is pressed to each main unit lattice on main column
It is directed respectively into " index name " field, " measurement unit " field, " guideline code " field and at least one specific index category
Property field；
By the tool in position relationship of each guest column main unit lattice in the statistical form generated and classification metadata library
Voxel data establishes binding relationship；Based on the binding relationship, classification metadata library is read, is inquired and " index name " field pair
The index name ID answered, then based on the index name ID found, inquiry request is sent to shared index metadatabase, shared
After index metadatabase is to transmitting terminal authentication success, search whether there is specific index name corresponding with index name ID
Claim, if so, then returning to specific index name to transmitting terminal；If it is not, returning to the notification message of inquiry failure；It sends
End customizes the specific index name of privately owned index property；Then, it is set to guest's field corresponding with " index name " field by finger
Mark classification is directed respectively into specific index name；To with " measurement unit " field and specific index name corresponding guest simultaneously
Field, which is set, imports specific measurement unit information；To with " code " field and specific index name corresponding guest's field simultaneously
It sets and imports specific code information, generate initial statistical list；
S6 defines data auditing rule corresponding with initial statistical list, access rights management information, report and shows pattern
And with the single-phase associated task scheduling interface of other statistical forms, generate final statistics list.
Preferably, in S6, the data auditing rule includes auditing rule between auditing rule and table in table；Wherein, described
Auditing rule is that the membership between the specific index name imported based on " index name " field is generated in table
Mathematic(al) representation；
Auditing rule is for dispatching relationship between the table between level relation and table and table between check list and table.
Preferably, the access rights management information is：With filling in the initial statistical list in data cells
Hold the user name and cipher list of permission；Registered user name can access and fill in the initial system only in the list
Count the data in data cells in list.
The present invention also provides a kind of statistics list quick-speed generation system based on metadata, including metadatabase management module
With Report Customization module；
The metadatabase management module, for defining and safeguard each metadatabase, including：
Attribute metadata library definition unit, measurement unit metadatabase definition unit, classification metadata library definition unit and
Shared index metadatabase definition unit；
Attribute metadata library definition unit is based on the general type mechanism of java, for customizing and management business report generation
Required Criterion Attribute in journey, including define data item type and data type；
The measurement unit metadatabase definition unit is based on the general type mechanism of java, for customizing and the life of management business report
At the measurement unit of required index in the process, including define data item type and data type；
Classification metadata library definition unit is based on industry class and divides basic library, is standard according to every profession and trade classification, point
Each index name of the class storage with inclusion relation；
The shared index metadatabase definition unit is used for for Business Entity type in bordereau, define index with
Derived relation between classification metadata library and expansion relation；
The Report Customization module includes report attribute definition unit, template definition unit, index definition unit, report sample
Formula definition unit, administration authority definition unit, access definition unit, preview definition unit；
The template definition unit is used to create the report form template of blank, then fixed in advance on the report form template of the blank
Total Table Header information of adopted report, including table number, report name, formulation organ, code, authentication code, report classification, report form type
And one or more of report term of validity；It is then based on java mapping mechanisms and generates an initial report in the database automatically
Table；
The report attribute definition unit is used on the basis of the initial report, further defines report show line base
This information is then based on java mapping relations and generates a set of contingency table；It is additionally operable to define report displaying row essential information, then base
A set of contingency table is generated in java mapping relations；
The report that the report style definition unit is used to obtain after defining the report attribute definition unit carries out cloth
Then office, typesetting and format editing use java mappings to generate pattern relation table；
The index definition unit is used to be based on current business report essential information, defines between index and pattern relation table
Relationship, and generate contingency table；
Administration authority definition unit, access definition unit, preview definition unit；
Criterion Attribute and index of the administration authority definition unit for defining generated report check the management of permission；
Rights management library is automatically generated by java reflex mechanisms；
The access definition unit is used to provide logical algorithm grammer for the report generated, maps machine with Hibernate
It is made as basis, then calls java interfaces to realize expression parsing function, expression parsing process, which calls radiation, has buffering
Effect；
The preview definition unit is used to be based on defined report messages, and complete report is shown by calling logic relationship
Table.
Beneficial effects of the present invention are as follows：
(1) management model level of control title and Criterion Attribute are used, Criterion Attribute and index name needed for report
Title can facilitate by searching for metadatabase and obtain, when index name and Criterion Attribute variation, it is only necessary to change metadata
Metadata in library need not change former report, that is, simplify investigation index and customize mode, user flexibility management is also facilitated to refer to
Library information is marked, solves the problems, such as that index adjustment difficulty is larger；
(2) by configuring structure of report rule, when structure of report changes, Report Engine is voluntarily adjusted according to variation
Structure of report generates new report, improves Report Customization flexibility；
(3) when report customization, since logic budget verifies and audits work(, it can be achieved that report is real-time between having the function of index
Can, greatly reduce report error rate, improves Report Customization accuracy；
(4) report timeliness can be improved with the self-defined report period, improves report investigation supervision simultaneously, also ensures
It makes a report on data age and makes a report on the authenticity of data.
Description of the drawings
Fig. 1 is the flow diagram of the statistics list rapid generation provided by the invention based on metadata；
Fig. 2 shows for the specific of statistics list that the statistics list rapid generation that provides through the invention is generated
Example；
Fig. 3 is the continued of Fig. 2；
Fig. 4 is a kind of specific example figure in classification metadata library.
Specific implementation mode
Below in conjunction with attached drawing, the present invention is described in detail：
The present invention provides a kind of statistics list rapid generation based on metadata, can rely on existing " Beijing's statistics
Acquisition platform in data set ", according to the pattern of " overall arrangement, hierarchical responsibility, gradually ripe, iterative method ", to mitigate base
The principle of statistical work burden, to innovate the Internet model as support, promotes data acquisition based on information-based means
Diversity, improve resident family participate in enthusiasm, improve collecting efficiency.
As shown in Figure 1, specifically including following steps：
S1 is created and is safeguarded multiple metadatabases；Each category of the metadatabase for storing report in the form of metadata
Property information, including attribute metadata library, measurement unit metadatabase, classification metadata library and shared index metadatabase；Its
In, attribute metadata library is for storing Criterion Attribute information；Measurement unit metadatabase is used to store the measurement unit letter of index
Breath；Classification metadata library is used to store multiple index name ID by index category classification, also, index classification is in inclusion relation,
Including the 1st grade of index, it is under the jurisdiction of the 2nd grade of index ... of the 1st grade of index according to analogize；Shared index metadatabase is for storing needle
To the mapping relations for the index name ID and index name of authorized user shared for multiple reports；
As shown in Fig. 2, the statistics list that the statistics list rapid generation to provide through the invention is generated
Specific example, Fig. 3 be Fig. 2 continued；With reference to Fig. 2 and Fig. 3, it is conveniently even further appreciated that some concepts of the present invention：
The Criterion Attribute information that attribute metadata library is stored refers to relevant with index name and is needed for this statistics list
Some to be counted parameters are in Fig. 2：Practical sown area, crops occupy cultivated land area, the per mu yield of broadcasting area, reality (in advance
Production) yield etc..It is said for storage attribute coding, Property Name, attribute in addition, the Criterion Attribute information that is stored of metadatabase is practical
Bright and attribute data type mapping relations；As shown in table 1, it is a kind of specific storage example in attribute metadata library：
Table 1
| Attribute coding | Property Name | Attribute specification | Attribute data type |
| T120 | Practical sown area | Nothing | Text |
| T121 | Crops occupy cultivated land area | Nothing | Text |
| T122 | Quantity | Nothing | Number |
In addition, minimum unit, that is, metadata of the Criterion Attribute as report, entire platform realizes metadata pipe end to end
Reason pattern, all Criterion Attribute customizations are operated by administrator, and index customization foundation Criterion Attribute is as basic unit, then
It being defined by being associated between Criterion Attribute and index, index customization is audited after completing, after audit passes through,
Index side can be put into shared index metadatabase and be used, just can only be to specific report form template if it is privately owned index
It is associated.
The index computation unit information that measurement unit metadatabase is stored is：Need the metering of each Criterion Attribute counted
Unit, such as：Mu, kilogram, ton etc..
It classification metadata library can be by each index name of tree structure classification storage, as shown in figure 4, being classification metadata library
A kind of specific example.
Metadata is the descriptive data information about data, illustrate data content, quality, situation and other in relation to feature
Background information.Metadata can promote the efficient utilization of data set, help the effective maintenance and management number of data production unit
According to；Metadata can improve the autgmentability of data, facilitate extended counter information.Data sharing, Neng Goubao are convenient for using metadata
It demonstrate,proves the accuracys of data, consistency and manages end to end.Therefore, in the present invention, each metadatabase is with the side of metadata
Formula stores particular content.
In addition, it is necessary to explanation, in of the invention, the metadata quantity and classification that each metadatabase is stored can roots
According to statistics the case where office's investigation business, real-time update is carried out, to ensure to count the generation of list.
S2 creates the report form template of blank；
Define total Table Header information of report；Total Table Header information includes table number, report name, formulates organ, code, approval
One or more of code, report classification, report form type and report term of validity；Total Table Header information is defined in report mould simultaneously
Position on plate；
With reference to figure 2, table number is A202-2 tables, and report name is：Staple crops occupy cultivated land area and it is expected that, practical production
Amount；Formulation organ is Beijing Statistics Bureau, Beijing investigation army unit of State Statistics Bureau；Code：Capital system hair【2012】No. 68；Approval text
Number：State's controlling【2012】No. 117；Report valid until：In January, 2014.
During generating Fig. 2, need to define position of total Table Header information on report form template be：1-7 rows,
1-6 arranges formed region.
S3, after total Table Header information definition of report is completed, verification of correctness unit believes total gauge outfit of the report
Breath is verified, if be proved to be successful, continues S4；Otherwise, report generation fails；
S4, the main field for defining report form template are set and are set with guest's field, main field set it is upper generate main column, set in guest's field
Generate guest column；Main column and guest column are made of multiple main unit lattice；The intersection region on main column and guest column is data cells；
During generating Fig. 2, it is that main field sets the 1st and is classified as guest's field and sets to need to define eighth row.Main unit lattice are
Store the cell of specific field；Data cells are the cell for filling in statistical data.
S5, will be in position relationship of the main unit lattice on each main column in the statistical form generated and each metadatabase
Specific metadata establish binding relationship；Based on the binding relationship, default correspondence is pressed to each main unit lattice on main column
It is directed respectively into " index name " field, " measurement unit " field, " guideline code " field and at least one specific index category
Property field；Wherein, " index name " field refers to during generating statistical form, each specific for what is arrived involved in the statistical form
The unique mark that index name assigns respectively, the mark in rear continued or between table for auditing.With reference to figure 2, " cereal crops "
Guideline code is set as 01, and the guideline code of " cereal " is set as 02, and the guideline code of " paddy " is set as 03 etc..
In addition, due in the present invention, by position relationship of each main unit lattice in the statistical form generated with it is each
Specific metadata in metadatabase establishes binding relationship, such as：Position relationship is：Eighth row the 3rd arranges；With attribute metadata library
In " practical sown area " establish binding relationship；Then after this report generation, if report other content is constant, it is only necessary to
The row of eighth row the 3rd are changed to other Criterion Attributes, then the binding relationship are directly changed, without re-establishing one again
The report of Zhang Xin, to simplify the process of report generation.
By the tool in position relationship of each guest column main unit lattice in the statistical form generated and classification metadata library
Voxel data establishes binding relationship；Based on the binding relationship, classification metadata library is read, is inquired and " index name " field pair
The index name ID answered, then based on the index name ID found, inquiry request is sent to shared index metadatabase, shared
After index metadatabase is to transmitting terminal authentication success, search whether there is specific index name corresponding with index name ID
Claim, if so, then returning to specific index name to transmitting terminal；If it is not, returning to the notification message of inquiry failure；It sends
End customizes the specific index name of privately owned index property；Then, it is set to guest's field corresponding with " index name " field by finger
Mark classification is directed respectively into specific index name；To with " measurement unit " field and specific index name corresponding guest simultaneously
Field, which is set, imports specific measurement unit information；To with " code " field and specific index name corresponding guest's field simultaneously
It sets and imports specific code information, generate initial statistical list；
S6 defines data auditing rule corresponding with initial statistical list, access rights management information, report and shows pattern
And with the single-phase associated task scheduling interface of other statistical forms, generate final statistics list.
Report shows that style definitions refer to：Report layouts and format of the definition with the binding of this report, after the completion of binding, pass through
Java Reflection mechanism automatically generates a set of mapping table.
Task scheduling interface refers to：The current statistical report form formulated, can directly invoke other systems for having formulated completion
The relevant parameters such as survey data, report style or the report form index of report are counted, to simplify report formulation process.
Data auditing rule includes auditing rule between auditing rule and table in table；Wherein, auditing rule is to be based on " referring in table
Entitling claims " mathematic(al) representation that is generated of the membership between the specific index name that is imported of field；For by Fig. 2 and
The sample report that Fig. 3 is formed can define auditing rule in following table：
Row relationship：(1) 01=02+11+15
(2) 02=03+04+07+08+09+10
(3) 04=05+06
(4)11≥12+13+14
(5) 16=17+22+23+24+28
(6) 17=18+19+20+21
(7)24≥25+26+27
(8) 29=30+37+40+41+42+43
(9) 30=31+35
(10)31≥32+33
(11)31≥34
(12)35≥36
(13) 37=38+39
Row relationship：(1)1≥2
(2) 3=4 × (1000) ÷ 1 or ÷ of 4=1 × 3 (1000)
(12)35≥36
(13) 37=38+39
Due to during generating report, defining auditing rule in table, therefore, when generation statistical report form, and receive
After each data cells have filled in the statistical report form of specific data content, can auditing rule in the automatic running table, to each number
Audited according to the data content that cell is filled in, if there is with the incongruent data of auditing rule in table, then directly to
Go out prompt.
Auditing rule is for dispatching relationship between table between level relation and table and table between check list and table.
In addition, in specific implementation, auditing rule includes audit condition, audit target (attribute, unit) and audit mode；It examines
Core condition is a mathematic(al) representation for including arithmetic operator and Boolean calculation, and can generate complexity by dynamic combined mode
Logical operation.Audit mode includes being audited between audit and table in table, can be automatically generated audit target and audit condition multiple
Miscellaneous logical expression.The parsing of expression formula is built upon on the data basis of the report form template met, and is reflected with java
Calling interface realizes that expression parsing process calls radiation and plays cushioning effect, avoids repeated reflection calling, improves solution
The efficiency of analysis.
Access rights management information is：With fill in initial statistical list the user name of data cells content rights and
Cipher list；Registered user name can be accessed and be filled in initial statistical list in data cells only in the list
Data.In addition, also defining checking permission and filling in permission for generated report, by report, index, permission and the power of filling in are checked
Limit is bound, and a set of authority relation table is automatically generated.Therefore, in subsequent process, the use of permission is only checked with this report
Family can just check this report；Only the user with this filling report forms permission can just fill in this report, to ensure report
Issue the safety of process.
In addition, in the present invention, after the raw statement of costs, in such a way that java autotasks are dispatched, can automatically generate down
Grade report.
The present invention also provides a kind of statistics list quick-speed generation system based on metadata, including metadatabase management module
With Report Customization module；
The metadatabase management module, for defining and safeguard each metadatabase, including：
Attribute metadata library definition unit, measurement unit metadatabase definition unit, classification metadata library definition unit and
Shared index metadatabase definition unit；
Attribute metadata library definition unit is based on the general type mechanism of java, for customizing and management business report generation
Required Criterion Attribute in journey, including define data item type and data type；
The measurement unit metadatabase definition unit is based on the general type mechanism of java, for customizing and the life of management business report
At the measurement unit of required index in the process, including define data item type and data type；
Classification metadata library definition unit is based on industry class and divides basic library, is standard according to every profession and trade classification, point
Each index name of the class storage with inclusion relation；
The shared index metadatabase definition unit is used for for Business Entity type in bordereau, define index with
Derived relation between classification metadata library and expansion relation；
The Report Customization module includes report attribute definition unit, template definition unit, index definition unit, report sample
Formula definition unit, administration authority definition unit, access definition unit, preview definition unit；
The template definition unit is used to create the report form template of blank, then fixed in advance on the report form template of the blank
Total Table Header information of adopted report, including table number, report name, formulation organ, code, authentication code, report classification, report form type
And one or more of report term of validity；It is then based on java mapping mechanisms and generates an initial report in the database automatically
Table；
The report attribute definition unit is used on the basis of the initial report, further defines report show line base
This information is then based on java mapping relations and generates a set of contingency table；It is additionally operable to define report displaying row essential information, then base
A set of contingency table is generated in java mapping relations；
The report that the report style definition unit is used to obtain after defining the report attribute definition unit carries out cloth
Then office, typesetting and format editing use java mappings to generate pattern relation table；
The index definition unit is used to be based on current business report essential information, defines between index and pattern relation table
Relationship, and generate contingency table；
Administration authority definition unit, access definition unit, preview definition unit；
Criterion Attribute and index of the administration authority definition unit for defining generated report check the management of permission；
Rights management library is automatically generated by java reflex mechanisms；
The access definition unit is used to provide logical algorithm grammer for the report generated, maps machine with Hibernate
It is made as basis, then calls java interfaces to realize expression parsing function, expression parsing process, which calls radiation, has buffering
Effect；
The preview definition unit is used to be based on defined report messages, and complete report is shown by calling logic relationship
Table.
In conclusion statistics list rapid generation and system provided by the invention based on metadata, have following
Advantage：
(1) management model level of control title and Criterion Attribute are used, Criterion Attribute and index name needed for report
Title can facilitate by searching for metadatabase and obtain, when index name and Criterion Attribute variation, it is only necessary to change metadata
Metadata in library need not change former report, that is, simplify investigation index and customize mode, user flexibility management is also facilitated to refer to
Library information is marked, solves the problems, such as that index adjustment difficulty is larger；
(2) by configuring structure of report rule, when structure of report changes, Report Engine is voluntarily adjusted according to variation
Structure of report generates new report, improves Report Customization flexibility；
(3) Report Customization process can be completed Report Customization by graphical interfaces mode of operation completely, have without coding
The simple advantage of Report Customization process；
(4) when report customization, since logic budget verifies and audits work(, it can be achieved that report is real-time between having the function of index
Can, greatly reduce report error rate, improves Report Customization accuracy；
(5) report timeliness can be improved with the self-defined report period, improves report investigation supervision simultaneously, also ensures
It makes a report on data age and makes a report on the authenticity of data.
(6) have and efficiently send and recycle report mechanism, can quickly send report and recycle the report number that user submits
According to, and provide and summarize data function automatically, ensure " fast, essence, the standard " of statistical data.
The above is only a preferred embodiment of the present invention, it is noted that for the ordinary skill people of the art
For member, various improvements and modifications may be made without departing from the principle of the present invention, these improvements and modifications are also answered
Depending on protection scope of the present invention.
Claims (2)
1. a kind of statistics list rapid generation based on metadata, which is characterized in that include the following steps：
S1 is created and is safeguarded multiple metadatabases；Each attribute letter of the metadatabase for storage report in the form of metadata
Breath, including attribute metadata library, measurement unit metadatabase, classification metadata library and shared index metadatabase；Wherein, attribute
Metadatabase is for storing Criterion Attribute information；Measurement unit metadatabase is used to store the measurement unit information of index；Classification
Metadatabase is used to store multiple index name ID by index category classification, also, index classification is in inclusion relation, including the 1st
Grade index is under the jurisdiction of the 2nd grade of index ... of the 1st grade of index according to analogize；Shared index metadatabase has been awarded for storing to be directed to
Weigh the mapping relations for the index name ID and index name of user shared for multiple reports；
Minimum unit, that is, metadata of the Criterion Attribute as report, entire platform realize management model end to end, institute
Criterion Attribute customization is operated by administrator, and index customization, as basic unit, then passes through index according to Criterion Attribute
It is associated with and is defined between attribute and index, index customization is audited after completing, and after audit passes through, index side is put
Enter shared index metadatabase to be used, if it is privately owned index, specific report form template can only be just associated；
The index computation unit information that measurement unit metadatabase is stored is：Need the metering list of each Criterion Attribute counted
Position；
Press each index name of tree structure classification storage in classification metadata library；
Metadata is the descriptive data information about data, illustrates data content, quality, situation and other back ofs the body in relation to feature
Scape information；Metadata can promote the efficient utilization of data set, help the effective maintenance and management data of data production unit；Member
Data can improve the autgmentability of data, facilitate extended counter information；Data sharing is convenient for using metadata, can ensure data
Accuracy, consistency and manage end to end；Therefore, each metadatabase stores particular content in a manner of metadata；
In addition, metadata quantity and classification that each metadatabase is stored, the case where business can be investigated according to statistics bureau, carry out
Real-time update, to ensure to count the generation of list；
S2 creates the report form template of blank；
Define total Table Header information of report；Total Table Header information includes table number, report name, formulates organ, code, approval text
Number, one or more of report classification, report form type and the report term of validity；Total Table Header information is defined in report form template simultaneously
On position；
S3, after total Table Header information definition of report is completed, verification of correctness unit to total Table Header information of the report into
Row verification continues S4 if be proved to be successful；Otherwise, report generation fails；
S4, the main field for defining report form template are set and are set with guest's field, main field set it is upper generate main column, set upper generation in guest's field
Guest column；Main column and guest column are made of multiple main unit lattice；The intersection region on main column and guest column is data cells；
S5, by the tool in position relationship of the main unit lattice on each main column in the statistical form generated and each metadatabase
Voxel data establishes binding relationship；Based on the binding relationship, presses default correspondence to each main unit lattice on main column and distinguish
Import " index name " field, " measurement unit " field, " guideline code " field and at least one specific Criterion Attribute word
Section；
By the specific member in position relationship of each guest column main unit lattice in the statistical form generated and classification metadata library
Data establish binding relationship；Based on the binding relationship, classification metadata library is read, is inquired corresponding with " index name " field
Index name ID, then based on the index name ID found, inquiry request is sent to shared index metadatabase, in shared index
After metadatabase is to transmitting terminal authentication success, search whether there is specific index name corresponding with index name ID,
If so, then returning to specific index name to transmitting terminal；If it is not, returning to the notification message of inquiry failure；Transmitting terminal
Customize the specific index name of privately owned index property；Then, it is set to guest's field corresponding with " index name " field by index
Classification is directed respectively into specific index name；To with " measurement unit " field and specific index name corresponding guest column simultaneously
Position imports specific measurement unit information；To corresponding guest's field is set simultaneously with " code " field and specific index name
Specific code information is imported, initial statistical list is generated；
S6, define corresponding with initial statistical list data auditing rule, access rights management information, report show pattern and
With the single-phase associated task scheduling interface of other statistical forms, final statistics list is generated；
Report shows that style definitions refer to：Report layouts and format of the definition with the binding of this report, after the completion of binding, pass through java
Reflection mechanism automatically generates a set of mapping table；
Task scheduling interface refers to：The current statistical report form formulated, directly invokes other statistical report forms for having formulated completion
Survey data, report style or report form index relevant parameter, to simplify report formulation process；
Wherein, in S6, the data auditing rule includes auditing rule between auditing rule and table in table；Wherein, it is examined in the table
Core rule is the mathematical table that the membership between the specific index name imported based on " index name " field is generated
Up to formula；
Auditing rule is for dispatching relationship between the table between level relation and table and table between check list and table；
Wherein, the access rights management information is：With filling in data cells content rights in the initial statistical list
User name and cipher list；Registered user name can access and fill in the initial statistical list only in the list
Data in middle data cells.
2. a kind of statistics list quick-speed generation system based on metadata, which is characterized in that including metadatabase management module and
Report Customization module；
The metadatabase management module, for defining and safeguard each metadatabase, including：
Attribute metadata library definition unit, measurement unit metadatabase definition unit, classification metadata library definition unit and shared
Index metadatabase definition unit；
Attribute metadata library definition unit is based on the general type mechanism of java, during customization and management business report generation
Required Criterion Attribute, including define data item type and data type；
The measurement unit metadatabase definition unit is based on the general type mechanism of java, for customizing and management business report generation
The measurement unit of required index in journey, including define data item type and data type；
Classification metadata library definition unit is based on industry class and divides basic library, is standard according to every profession and trade classification, and classification is deposited
Store up each index name with inclusion relation；
The shared index metadatabase definition unit is used to, for Business Entity type in bordereau, define index and classification
Derived relation between metadatabase and expansion relation；
The Report Customization module includes that report attribute definition unit, template definition unit, index definition unit, report style are fixed
Adopted unit, administration authority definition unit, access definition unit, preview definition unit；
The template definition unit is used to create the report form template of blank, and report is then pre-defined on the report form template of the blank
Total Table Header information of table, including table number, report name, formulate organ, code, authentication code, report classification, report form type and
One or more of report term of validity；It is then based on java mapping mechanisms and generates an initial report in the database automatically；
The report attribute definition unit is used on the basis of the initial report, is further defined report show line and is believed substantially
Breath is then based on java mapping relations and generates a set of contingency table；It is additionally operable to define report displaying row essential information, be then based on
Java mapping relations generate a set of contingency table；
The report that the report style definition unit is used to obtain after defining the report attribute definition unit is laid out, arranges
Then version and format editing use java mappings to generate pattern relation table；
The index definition unit is used to be based on current business report essential information, defines and is closed between index and pattern relation table
System, and generate contingency table；
Administration authority definition unit, access definition unit, preview definition unit；
Criterion Attribute and index of the administration authority definition unit for defining generated report check the management of permission；Pass through
Java reflex mechanisms automatically generate rights management library；
The access definition unit is used to provide logical algorithm grammer for the report generated, is with Hibernate mapping mechanisms
Then basis calls java interfaces to realize expression parsing function, expression parsing process, which calls radiation, has cushioning effect；
The preview definition unit is used to be based on defined report messages, and complete report is shown by calling logic relationship.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201410370145.0A CN105320690B (en) | 2014-07-30 | 2014-07-30 | A kind of statistics list rapid generation and system based on metadata |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201410370145.0A CN105320690B (en) | 2014-07-30 | 2014-07-30 | A kind of statistics list rapid generation and system based on metadata |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN105320690A CN105320690A (en) | 2016-02-10 |
| CN105320690B true CN105320690B (en) | 2018-09-25 |
Family
ID=55248090
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201410370145.0A Active CN105320690B (en) | 2014-07-30 | 2014-07-30 | A kind of statistics list rapid generation and system based on metadata |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN105320690B (en) |
Families Citing this family (47)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105678475B (en) * | 2016-03-01 | 2019-09-10 | 中国联合网络通信集团有限公司 | Method for prewarning risk and equipment |
| CN107291749B (en) * | 2016-03-31 | 2020-11-10 | 菜鸟智能物流控股有限公司 | Method and device for determining data index association relation |
| CN106228440A (en) * | 2016-08-02 | 2016-12-14 | 南京坦道信息科技有限公司 | A kind of income index based on dimension map coupling is efficiently entered an item of expenditure in the accounts method |
| CN106598924A (en) * | 2016-10-28 | 2017-04-26 | 深圳前海微众银行股份有限公司 | Form generation method and device |
| CN106598925A (en) * | 2016-11-22 | 2017-04-26 | 广州悦审软件科技有限公司 | Method and system for quickly generating department final statement report data |
| CN106776885B (en) * | 2016-11-29 | 2021-03-30 | 盐城工学院 | Data export method and device |
| CN106557884B (en) * | 2016-11-30 | 2018-05-29 | 中国南方电网有限责任公司 | index library generating method and device |
| CN107357774A (en) * | 2017-07-24 | 2017-11-17 | 郑州云海信息技术有限公司 | A kind of report form generation method and reporting system |
| CN107391716A (en) * | 2017-07-31 | 2017-11-24 | 安徽云软信息科技有限公司 | A kind of port freight volume express statistic system |
| CN107368990A (en) * | 2017-07-31 | 2017-11-21 | 安徽云软信息科技有限公司 | A kind of cargoes imported and exported statistical system |
| CN107391718A (en) * | 2017-07-31 | 2017-11-24 | 安徽云软信息科技有限公司 | One kind inlet and outlet real-time grading method |
| CN108196921B (en) * | 2017-12-26 | 2021-03-16 | 金蝶软件（中国）有限公司 | Document development method and device, computer equipment and storage medium |
| CN108345673A (en) * | 2018-02-09 | 2018-07-31 | 弘成科技发展有限公司 | Online adult education institution of higher learning customize report deriving method |
| CN108153919A (en) * | 2018-02-28 | 2018-06-12 | 弘成科技发展有限公司 | DBF data export platform and its deriving method |
| CN108345682A (en) * | 2018-03-02 | 2018-07-31 | 弘成科技发展有限公司 | Platform and method are imported and exported based on what multi-tenant can configure |
| CN109241075B (en) * | 2018-07-02 | 2022-09-09 | 土巴兔集团股份有限公司 | Index basic data processing method and equipment and computer readable storage medium |
| CN108959227A (en) * | 2018-07-12 | 2018-12-07 | 山东汇贸电子口岸有限公司 | A kind of self-defined report system and method based on B/S framework |
| CN109117467A (en) * | 2018-07-27 | 2019-01-01 | 广东讯飞启明科技发展有限公司 | Generation method, system, equipment and the medium of configurable dynamic data report |
| CN109213747B (en) * | 2018-08-08 | 2021-11-16 | 麒麟合盛网络技术股份有限公司 | Data management method and device |
| CN109726235A (en) * | 2018-11-27 | 2019-05-07 | 东软集团股份有限公司 | Method for interchanging data, device, readable storage medium storing program for executing, electronic equipment and system |
| CN109669992A (en) * | 2018-12-20 | 2019-04-23 | 云南电网有限责任公司玉溪供电局 | A kind of implementation method of data visualization conversion |
| CN110263307A (en) * | 2019-04-15 | 2019-09-20 | 重庆金融资产交易所有限责任公司 | Report form generation method, server and computer readable storage medium |
| CN109783184B (en) * | 2019-04-15 | 2019-07-19 | 南京孜博汇信息科技有限公司 | User's customizing form generation method |
| CN110287219B (en) * | 2019-06-28 | 2020-04-07 | 北京九章云极科技有限公司 | Data processing method and system |
| CN110347740A (en) * | 2019-07-15 | 2019-10-18 | 华瑞新智科技（北京）有限公司 | The safety patrol inspection of Excel format checks table data lead-in method, system, equipment and computer readable storage medium |
| CN110162763A (en) * | 2019-07-18 | 2019-08-23 | 成都希盟泰克科技发展有限公司 | Magnanimity quality tests the optimization method for commenting form data intelligently to be configured and its system |
| CN110750972A (en) * | 2019-08-30 | 2020-02-04 | 中国铁道科学研究院集团有限公司电子计算技术研究所 | Scheduling report information acquisition method and system |
| CN110827156A (en) * | 2019-11-04 | 2020-02-21 | 泰康保险集团股份有限公司 | Method, device and equipment for generating application page and computer readable storage medium |
| CN111124394A (en) * | 2019-11-26 | 2020-05-08 | 泰康保险集团股份有限公司 | Form configuration method and device based on metadata, equipment and medium |
| CN110827943A (en) * | 2019-12-03 | 2020-02-21 | 中国医学科学院北京协和医院 | Method for researching rare diseases |
| CN111159991B (en) * | 2019-12-12 | 2023-06-27 | 远光软件股份有限公司 | Report modeling design device and method |
| CN111079398A (en) * | 2019-12-13 | 2020-04-28 | 蚁安居(天津)网络技术有限公司 | Report system |
| CN111192015A (en) * | 2019-12-30 | 2020-05-22 | 上海数熙科技有限公司 | Integrated data management system based on core object |
| CN111858555B (en) * | 2020-07-15 | 2021-03-16 | 杭州数云信息技术有限公司 | Method for data management depending on metadata |
| CN112016287B (en) * | 2020-07-24 | 2024-01-26 | 浙江鸿程计算机系统有限公司 | Data management method, platform, storage medium and electronic equipment |
| CN112036142A (en) * | 2020-09-02 | 2020-12-04 | 中国银行股份有限公司 | Real-time report generation method and system based on data configuration |
| CN112307729A (en) * | 2020-11-04 | 2021-02-02 | 恒瑞通（福建）信息技术有限公司 | Online filling report generation method and terminal |
| CN112434077A (en) * | 2020-11-18 | 2021-03-02 | 中国建设银行股份有限公司 | Data statistics display method, device, equipment and medium based on customized report |
| CN112487107B (en) * | 2020-11-28 | 2021-11-23 | 河北省科学技术情报研究院(河北省科技创新战略研究院) | Processing method for presenting data index hierarchy and classification in electronic form |
| CN112463797A (en) * | 2020-12-08 | 2021-03-09 | 航天信息股份有限公司 | Report generation method, system, storage medium and electronic equipment |
| CN113378041B (en) * | 2021-05-24 | 2024-04-16 | 北京京东振世信息技术有限公司 | Prompt message pushing method, device, electronic equipment and computer readable medium |
| CN113255307A (en) * | 2021-06-15 | 2021-08-13 | 国能信控互联技术有限公司 | Intelligent reporting method and system for power system |
| CN113449499A (en) * | 2021-08-31 | 2021-09-28 | 深圳市永兴元科技股份有限公司 | Off-site data management method, device, equipment and storage medium |
| CN114064716B (en) * | 2021-10-29 | 2023-10-20 | 北京市农林科学院信息技术研究中心 | Metadata-based automatic WEB report generation method and device |
| CN114330262B (en) * | 2022-03-08 | 2022-05-20 | 北京理工大学 | Statistical method and device for material data and electronic equipment |
| CN114548062B (en) * | 2022-04-27 | 2022-08-02 | 成都瑞华康源科技有限公司 | Report arranging method |
| CN117349296B (en) * | 2023-12-04 | 2024-03-15 | 技鼎软件科技(南京)有限公司 | Report automatic sending system and method |
Citations (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1877563A (en) * | 2006-07-06 | 2006-12-13 | 北京北大方正电子有限公司 | Report form defining method and system |
| CN101308490A (en) * | 2008-04-28 | 2008-11-19 | 北京航空航天大学 | Dynamic report generation method and platform |
| CN101599067A (en) * | 2009-06-02 | 2009-12-09 | 广东金宇恒科技有限公司 | A kind of method of self-customizing report forms |
| CN101661460A (en) * | 2009-09-18 | 2010-03-03 | 上海宝信软件股份有限公司 | Method and device for generating management system report |
| CN101719119A (en) * | 2009-11-18 | 2010-06-02 | 上海众恒信息产业有限公司 | Report management system and method |
| CN101894099A (en) * | 2010-06-29 | 2010-11-24 | 北京科技大学 | Report template customization method |
| CN103064659A (en) * | 2011-10-21 | 2013-04-24 | 镇江金软计算机科技有限责任公司 | Software as a service (SAAS) model based on metadata extraction user-defined worksheet system |
| CN103606045A (en) * | 2013-11-20 | 2014-02-26 | 国家电网公司 | Report form generation method and report form system |
Family Cites Families (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US7505888B2 (en) * | 2004-11-30 | 2009-03-17 | International Business Machines Corporation | Reporting model generation within a multidimensional enterprise software system |
-
2014
- 2014-07-30 CN CN201410370145.0A patent/CN105320690B/en active Active
Patent Citations (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1877563A (en) * | 2006-07-06 | 2006-12-13 | 北京北大方正电子有限公司 | Report form defining method and system |
| CN101308490A (en) * | 2008-04-28 | 2008-11-19 | 北京航空航天大学 | Dynamic report generation method and platform |
| CN101599067A (en) * | 2009-06-02 | 2009-12-09 | 广东金宇恒科技有限公司 | A kind of method of self-customizing report forms |
| CN101661460A (en) * | 2009-09-18 | 2010-03-03 | 上海宝信软件股份有限公司 | Method and device for generating management system report |
| CN101719119A (en) * | 2009-11-18 | 2010-06-02 | 上海众恒信息产业有限公司 | Report management system and method |
| CN101894099A (en) * | 2010-06-29 | 2010-11-24 | 北京科技大学 | Report template customization method |
| CN103064659A (en) * | 2011-10-21 | 2013-04-24 | 镇江金软计算机科技有限责任公司 | Software as a service (SAAS) model based on metadata extraction user-defined worksheet system |
| CN103606045A (en) * | 2013-11-20 | 2014-02-26 | 国家电网公司 | Report form generation method and report form system |
Also Published As
| Publication number | Publication date |
|---|---|
| CN105320690A (en) | 2016-02-10 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN105320690B (en) | A kind of statistics list rapid generation and system based on metadata | |
| CN108280365B (en) | Data access authority management method, device, terminal device and storage medium | |
| CN101599067B (en) | Method of self-customizing report forms for users | |
| CN104866426B (en) | Software test integrated control method and system | |
| CN104572122B (en) | A kind of generating means and method of software application data | |
| CN101382957B (en) | System for establishing enquiry model and establishing method | |
| CN103425778B (en) | A kind of intelligent development platform of database application system | |
| US20130111562A1 (en) | Method and apparatus for delivering application service using pre-configured access control corresponding to organizational hierarchy | |
| CN106991183B (en) | A kind of packaging method and system of business intelligence ETL | |
| CN101539855A (en) | Service basic software platform | |
| CN110443010A (en) | One kind permission visual configuration control method, device, terminal and storage medium in information system | |
| CN101452503A (en) | Isomerization clinical medical information shared system and method | |
| CN103177068A (en) | Systems and methods for merging source records in accordance with survivorship rules | |
| CN103606045A (en) | Report form generation method and report form system | |
| CN110457891A (en) | A kind of authority configuration interface display method, device, terminal and storage medium | |
| CN107291450A (en) | A kind of quick code automatic generation method for programming friendly | |
| CN102496083B (en) | Credit rating report manuscript manufacturing method | |
| CN102819557B (en) | Data query treating apparatus and data query disposal route | |
| CA2646362A1 (en) | Report generation with integrated quality management | |
| CN102208057A (en) | Method, platform and system for processing audit information | |
| CN107451738A (en) | A kind of construction-engineering project appraisal procedure and its assessment system | |
| CN107992519A (en) | The multi-source heterogeneous data verification system and method for a kind of smart grid-oriented big data | |
| CN107330628A (en) | A kind of construction method and device of auditing risk management information bank | |
| CN111897866A (en) | Remote sensing monitoring pattern spot docking system and using method thereof | |
| CN107403308B (en) | Data management method, system, computer readable storage medium and computer device |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| CB03 | Change of inventor or designer information |
Inventor after: Xu Qi Inventor after: Ding Guanggao Inventor after: Xiao Yao Inventor after: Guo Ran Inventor after: Wang Yali Inventor before: Nan Xiaodao Inventor before: Xu Qi Inventor before: Xiao Yao Inventor before: Ding Guanggao Inventor before: Yang Gongbai |
|
| CB03 | Change of inventor or designer information | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant | ||
| CP03 | Change of name, title or address |
Address after: 6 / F, Haidian Science and technology building, building 689, zone 1, No. 5, Zhongguancun South Street, Haidian District, Beijing 100081 Patentee after: Zhongguancun Science City City brain Co.,Ltd. Address before: 100080, Beijing Haidian District Zhongguancun South Street 3, Haidian science and technology building, 6 floor Patentee before: BEIJING ZHONGHAIJIYUAN DIGITAL TECHNOLOGY DEVELOPMENT Co.,Ltd. |
|
| CP03 | Change of name, title or address |