CN104699681A - Data processing method based on metadata base - Google Patents
Data processing method based on metadata base Download PDFInfo
- Publication number
- CN104699681A CN104699681A CN201310646882.4A CN201310646882A CN104699681A CN 104699681 A CN104699681 A CN 104699681A CN 201310646882 A CN201310646882 A CN 201310646882A CN 104699681 A CN104699681 A CN 104699681A
- Authority
- CN
- China
- Prior art keywords
- report
- user
- metadatabase
- query
- configuration
- 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
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses a data processing method based on a metadata base. The data processing method comprises the following steps: Step100, saving configuration data required by report query and data export, comprising configuration of report information, configuration of filtering conditions, configuration of report representing information and configuration of detailed information in a form of the metadata base; Step 200, when a user enters a report module, listing the report information through the metadata base for the selection of the user, providing the report filtering conditions for the input of the user, displaying query results according to a format defined by the metadata base and displaying related detailed information; meanwhile, when the user has a data export request, using the same parameters to execute query and using the same format to export a file. Through adopting the mode, development and maintenance are more convenient, the development workload is reduced, and research and development technical thresholds are reduced.
Description
Technical field
The present invention relates to microcomputer data processing field, particularly relate to a kind of data processing method based on metadatabase.
Background technology
There is bulk information system all to need data query function at present, also wish to provide Excel statistical conversion function after inquiring related data.But, every query function in each system varies, the data of inquiry are different, the filtercondition provided is different, display report tableau format is different, row name, alignment thereof, data display format, the height-width of each row in form, etc. all vary, meanwhile, various form also has the demand of statistical conversion.User needs the data derived, and should be the same with report query result, that display format is consistent form document, be unfavorable for data processing.Therefore, be necessary to provide a kind of data processing method based on metadatabase.
Summary of the invention
The object of the present invention is to provide a kind of data processing method based on metadatabase, it makes development and maintenance all convenient, has both reduced development amount, again reduces research and development technology threshold.
For realizing a kind of data processing method based on metadatabase that the present invention provides, comprise the steps:
By the configuration data needed for report query and statistical conversion, comprise the configuration of report messages, the configuration of filtercondition, the configuration of form exhibition information, the configuration of details, saved by the form of metadatabase;
When user enters Reports module, enumerate report messages by metadatabase to select for user, there is provided report filtering condition for user's input, according to the form display Query Result of metadatabase definition, and displaying associated detailed information, meanwhile, when receiving the statistical conversion request that user proposes, use same parameter to perform inquiry, use same form export.
More preferably, described configuration data needed for report query and statistical conversion to be comprised the steps:
Configuration report messages allocation list, configures the information of all forms, comprises the numbering of form, title, report form type, form classification, title, gauge outfit subtitle, query statement, whether onset, creator and date;
Configurating filtered condition allocation list, configures the filtercondition that each form provides for user, comprise report number, filtercondition title, control name, control type, conditional statement, query argument, control width, highly, row cross over, row cross over;
Configuration form exhibition information allocation list, whether the form of the report interface that configuration querying result should show and statistical conversion file, comprise report number, row name, Chinese name, DISPLAY ORDER, col width, data layout, layout, row leap, show;
Configuration details allocation list, whether how configure user shows the details of this line item when clicking certain line item, comprise report number, template number, DISPLAY ORDER, title, querying condition, show.
More preferably, described when user enters Reports module, enumerate report messages by metadatabase and select for user, there is provided report filtering condition for user's input, according to the form display Query Result of metadatabase definition, and show associated detailed information, comprise the steps:
When user enters Reports module, enumerate report messages by metadatabase and select for user, provide report filtering condition for user's input, according to the form display Query Result of metadatabase definition, and show associated detailed information;
Derivation is performed after user inquires about form, by the data query of query State object acquisition inquiry last time, then from metadatabase, read the information of each allocation list, go to perform statistical conversion according to the data of these allocation lists, data and the form of derivation use identical query statement, identical displaying form.
More preferably, described when user enters Reports module, enumerate report messages by metadatabase and select for user, there is provided report filtering condition for user's input, according to the form display Query Result of metadatabase definition, and show associated detailed information, comprise the steps:
Enumerate all forms when user enters form center to select for user, all report messages in described form center all derive from the data in metadatabase report messages allocation list;
When user selects a form, the filtercondition showing this form for user's input, user input filtercondition needed for oneself and requesting query time, report number, will to be submitted in background server by control value, the filtercondition selected;
Background server receive submit on foreground report number, by select control value, after filtercondition, the query statement of this form is inquired by report number, filtercondition is inserted in query statement, control value is submitted to database in the lump as query argument and performs inquiry;
After database performs inquiry, show the definition to this form in allocation list according to form in metadatabase, show form according to corresponding form; When selecting certain record in form as user, show the details of this record according to the definition in details allocation list in metadatabase.
The invention has the beneficial effects as follows: the data processing method that the present invention is based on metadatabase, for developer, operation maintenance personnel and field conduct personnel provide the many support of report making and derivation aspect with convenient, it compares with method for designing of the same type, it is advantageous that:
1. the invention provides developer, operation maintenance personnel and field conduct personnel to make and a series of functions safeguarded needed for form, comprise form configuration, filtercondition configuration, report display configuration, details configuration.
2. the present invention is all based on the basis being kept at metadatabase to the configuration of above information, brings following advantage like this:
1) maintenance mode is easy, only need carry out maintenance just passable in relevant configuration table, and without the need to search and searching in a large amount of program code again;
2) because various parameter is present in database, after parameter is revised, without the need to restarting application, parameter just can come into force, and development and maintenance are all convenient;
3) because various parameter is effectively shared in report query and statistical conversion module, make Query Result can keep considerably consistent with derivation result, related personnel is without the need to safeguarding it respectively simultaneously, reduces maintenance workload.
3. the present invention is that the design that each information system carries out report query and derivation provides powerful platform support.Developer uses the present invention, can carry out Report Form Design, both reduced development amount, again reduced research and development technology threshold under without any the prerequisite of program development.
Accompanying drawing explanation
Fig. 1 is the data processing method process flow diagram based on metadatabase of one embodiment of the invention;
Fig. 2 is the metadatabase relation schematic diagram of one embodiment of the invention.
Embodiment
In order to make object of the present invention, technical scheme and advantage clearly thorough, below in conjunction with drawings and Examples, the data processing method based on metadatabase of the present invention is further elaborated.Should be appreciated that specific embodiment described herein only in order to explain the present invention, be not intended to limit the present invention.
Although the inquiry in computer system varies, still can therefrom find common rule, that is exactly that they all adopt a common pattern, has the step that identical.Specifically, any query function all will provide one section of query statement (may be SQL also may be HQL), be supplied to some filterconditions of user available simultaneously, last row name, alignment thereof, data display format, the height-width that System inventory should be told when real Query Result to show, etc.If this common pattern is made framework, places different for each inquiry form is made a lot of parameter to preserve in a database, form a metadatabase that every element in inquiry form is described, then can provide the inquiry report capability of each information system and support forcefully.
And if to unify at derived data, just require that data derivation program and report query program will share query statement, filtercondition, form display parameter etc. information.Realizing such demand, just requiring all these information to be stored in metadatabase, simultaneously by data inquiry module and statistical conversion module are shared when designing.
The data processing method based on metadatabase of the embodiment of the present invention, as shown in Figure 1, comprises the steps:
Step S100, by the configuration data needed for report query and statistical conversion, is comprised the configuration of report messages, the configuration of filtercondition, the configuration of form exhibition information, the configuration of details, is saved by the form of metadatabase.
Core of the present invention sets up metadatabase, is configured with essential information, query statement, filtercondition, form exhibition information, the details of inquiry form in metadatabase.
The present invention is first by the configuration data needed for report query and statistical conversion, comprise the configuration of report messages, the configuration of filtercondition, the configuration of form exhibition information, the configuration of details, as shown in Figure 2, saved by the form of metadatabase, comprise the steps:
Step S110, configuration report messages allocation list, configure the essential information of all forms, include but not limited to the classification of the numbering of form, title, report form type, form, title, gauge outfit subtitle, query statement, whether onset, creator and date etc.;
Report messages allocation list (RPT_REPORTER) configures the essential information of all forms, includes but not limited to the classification of the numbering of form, title, report form type, form, title, gauge outfit subtitle, query statement, whether onset, creator and date etc.Report name is the title that user selects at form center to show during form, and form can be classified according to modes such as functional modules by exploitation or enforcement personnel.Meanwhile, each form can have a title and subtitle, if not, what all need not be filled in.In addition, which report display field conduct personnel can arrange, and which form does not show.The form that field conduct personnel are created by foreground, all will record creator and date.Concrete as table 1.
Table 1: report messages allocation list (RPT_REPORTER)
| Field is named | Chinese | Field type | Whether be empty | Whether major key |
| ID | Report number | Varchar2(16) | No | Be |
| NAME | Report name | Varchar2(200) | No | |
| RPT_TYPE | Report form type | Char(3) | Be | |
| CLASSIFY | Form is classified | Varchar2(16) | Be | |
| TITLE | Title | Varchar2(500) | Be | |
| SUBTITLE | Gauge outfit subtitle | Varchar2(500) | Be | |
| IS_AVAILABLE | Whether onset | Char(1) | Be | |
| SQL | Query statement | Varchar2(4000) | No | |
| CREATOR | Creator | Varchar2(20) | Be | |
| CREAT_DATE | Date created | Date | Be |
In report messages allocation list, the field of most critical is " query statement ", query statement required when this field record form performs inquiry.Query statement can be SQL, also can be HQL, and they are configured by " report form type ".Can pass through in query statement ": variable name " mark variable, mark the position of insertion condition by " <COND> " thus realize dynamic condition filtration.
Step S120, configurating filtered condition allocation list, configure the filtercondition that each form provides for user, include but not limited to report number, filtercondition title, control name, control type, conditional statement, query argument, control width, highly, row crosses over, information such as row leap etc.;
Filtercondition allocation list (RPT_CONDITION) configures the filtercondition that each form provides for user.The information that this table stores comprises: report number, filtercondition title, control name, control type, conditional statement, query argument, control width, highly, row crosses over, information such as row leap etc.Report number determines each form for which filtercondition; Filtercondition title determines the Chinese name of this condition when filtering interface shows; Control name is an English name, and it represents the control id of this condition in filtering interface on the one hand, represents the title of this variable in query statement on the other hand; Control type determines the text box, combobox, radio box etc. that this condition shows in filtering interface, and the configuration of control and method for drafting are included in a widget library; Control width, highly, row crosses over, information such as row leap etc. determines the rendering parameter of this condition in filtering interface.
In filtercondition allocation list, most critical is undoubtedly " conditional statement " field.Upon selection by the user, system needs this condition dynamic insertion in query statement each filtercondition.But these filterconditions may be fairly simple, also may be very complicated.The present invention, by " conditional statement " field, can solve the situation of most of complicated filtercondition.Filtercondition allocation list as table 2.
Table 2: filtercondition allocation list (RPT_CONDITION)
| Field is named | Chinese | Field type | Whether be empty | Whether major key |
| ID | Filtercondition is numbered | Varchar2(16) | No | Be |
| LABEL | Filtercondition title | Varchar2(200) | No | |
| RPT_ID | Report number | Varchar2(16) | No | |
| NAME | Control name | Varchar2(100) | No | |
| CONTROL_ID | Control type | Char(6) | No | |
| CONDITION | Conditional statement | Varchar2(4000) | No | |
| PARAMS | Query argument | Varchar2(200) | Be | |
| WIDTH | Control width | Number(4) | Be | |
| HEIGHT | Control height | Number(4) | Be | |
| ROWSPAN | Row is crossed over | Number(4) | Be | |
| COLSPAN | Row are crossed over | Number(4) | Be | |
| IS_AVAILABLE | Whether onset | Char(1) | Be |
| DISP_ORDER | Displaying order | Number(4) | Be |
Step S130, configuration form exhibition information allocation list, the form of the report interface that configuration querying result should show and statistical conversion file, includes but not limited to the information such as report number, row name, Chinese name, DISPLAY ORDER, col width, data layout, layout, row are crossed over, whether show.
Form exhibition information allocation list (RPT_COLUMN), the report interface that not only configuration querying result should show, the also form of configuration data export, this is also one of feature of the present invention.The information that it stores comprises: the information such as whether report number, row name, Chinese name, DISPLAY ORDER, col width, data layout, layout, row are crossed over, show.Row name refers to the row name that Query Result is concentrated, and it requires that in query statement, those calculated columns must get alias, and row name identical in different table must be distinguished by another name; Chinese name is then the Chinese of each row head display in configuration form; What arrange in DISPLAY ORDER and form puts in order, and identifies with arabic numeral; Be empty under data layout default situations, fill in " % " then show percent, fill in " 0.00 " display amount of money form (i.e. 3 CSVs retain 2 decimals), fill in " date " and show date form, fill in " time " and show the date and add Hour Minute Second.
In addition, whether each row also configurable col width, layout (i.e. alignment thereof: placed in the middle, keep left, keep right) and " showing ", improves the maintainability of report display.In addition, present invention also offers the configuration of " row are crossed over " field.When the situation of multilayer row name appears in the gauge outfit of form, namely a situation always having several height arrange below row, then always will arrange the numbering of the multiple son row comprised, list with the form of CSV in " row leap " field.All these, can be embodied in excel form when statistical conversion simultaneously.Report messages allocation list as table 3.
Table 3: form exhibition information allocation list (RPT_COLUMN)
| Field is named | Chinese | Field type | Whether be empty | Whether major key |
| ID | Column number | Varchar2(16) | No | Be |
| RPT_ID | Report number | Varchar2(16) | No | |
| COL | Row name | Varchar2(30) | No | |
| CHS | Chinese name | Varchar2(60) | No | |
| DISP_ORDER | Displaying order | Number(4) | No | |
| WIDTH | Col width | Number(4) | Be | |
| ALIGN | Layout | Varchar2(10) | Be | |
| FORMAT | Data layout | Varchar2(10) | Be | |
| COLSPAN | Row are crossed over | Varchar2(100) | Be | |
| IS_SHOWN | Whether show | Char(1) | Be |
Step S140, configuration details allocation list, whether how configure user shows the details of this line item when clicking certain line item, include but not limited to report number, template number, DISPLAY ORDER, title, querying condition, show.
How details allocation list (RPT_DETAIL) configure user shows the details of this line item when clicking certain line item.Under default situations, developer can not configure any details.In this case, when user clicks certain line item, the present invention can eject details interface display essential information, the information of all row namely configured in report messages allocation list.Such design is convenient to when the data item in Query Result is many especially, and partial data item is presented in inquiry form by exploitation or enforcement personnel, and out of Memory then shows after point opens details.
Except showing all data item of certain record, the present invention more importantly divides the form of tab, for user provides display other information relevant to this record.As made out an invoice while information display taxpayer, invoice stock that this taxpayer is correlated with can also be shown, declare dutiable goods, the information such as registration.Each line item in details allocation list represents a tab.Tab is divided into three kinds of forms: show a list, display form, a display webpage.If only show a record in tab, be then shown as a list, its requires exploitation or the personnel of enforcement first this list of configuration in the details template table (RPT_TEMPLATE), then in details allocation list for this form adds this template; If what show in tab is a data set, then show a form; If the page made, then the url of this page is filled in into.
Whether the information that details allocation list stores comprises: report number, template number, DISPLAY ORDER, title, querying condition, show.Template can be shared by multiple form, if but this secondary display form, and this form toward the query statement adding conditional of template configuration, then will fill in querying condition herein when performing inquiry.Details allocation list as table 4.
Table 4: details allocation list (RPT_DETAIL)
| Field is named | Chinese | Field type | Whether be empty | Whether major key |
| ID | Details are numbered | Varchar2(16) | No | Be |
| RPT_ID | Report number | Varchar2(16) | No | |
| TMP_ID | Template number | Varchar2(16) | No | |
| DISP_ORDER | Displaying order | Number(4) | Be | |
| TITLE | Title | Varchar2(200) | Be | |
| CONDITION | Querying condition | Number(4) | Be | |
| IS_SHOWN | Whether show | Char(1) | Be |
The information that details template table stores comprises: template number, template name, query statement, interface type (list, form, webpage), URL.
Details template table as table 5.
Table 5: details template table (RPT_TEMPLATE)
| Field is named | Chinese | Field type | Whether be empty | Whether major key |
| ID | Template number | Varchar2(16) | No | Be |
| SQL | Query statement | Varchar2(4000) | No | |
| UI_TYPE | Interface type | Varchar2(20) | No | |
| NAME | Template name | Varchar2(400) | Be | |
| URL | Web page address | Varchar2(500) | Be | |
| DISCRIPTION | Template explanation | Varchar2(2000) | Be |
Step S200, when user proposes inquiry request, obtain related statements parameter by metadatabase, realize the whole process that form is selected, filtercondition inputs, form is shown, details show, and when user proposes statistical conversion request, use same parameter to perform derivation.
The embodiment of the present invention by the configuration of metadatabase, for the parameter sharing of data query and derivation provides possibility.When user proposes inquiry request, show all forms by metadatabase; When user selects certain form, show filtercondition by metadatabase; When user input filterd condition performs inquiry, show form by metadatabase; When user selects certain to record, show details by metadatabase.Meanwhile, when user proposes derivation request, the same parameter of use is performed derivation by the present invention, makes data and the form of final derivation, remains consistent with inquiry form.
Described step S200 comprises the steps:
Step S210, when user proposes inquiry request, obtains correlation parameter by metadatabase, performs inquiry;
Preferably, described step S210 comprises the steps:
Step S211, user selects form from form center, input inquiry filtercondition requesting query, described form center is that system concentrates the functional module being supplied to all forms of user, and these report messages all derive from the data in metadatabase report messages allocation list;
Had the design of metadatabase, the design of other side of the present invention is just fairly simple, is first report query.In this part of report query, the present invention provide firstly form center, and namely all forms of certain infosystem can be come together at form centre punch.When user enters form center, all forms oneself having authority can be checked.Here, all report messages in form center all derive from the data in metadatabase report messages allocation list.Form center Main Function is in the present invention the entrance allowing user enter each form, but each operation system can not design form center in use, and the form that present invention also offers url enters each form.
Step S212, enters the filtering interface of this form after user have selected certain form.When user input filtercondition needed for oneself and requesting query time, report number, will to be submitted in background server by control value, the filtercondition selected;
When user selects certain form, the interface of this form will be entered; If operation system does not design form center, also can enter this form in places such as menus with the form of url, in url, report number will become an important parameter.What enter that first certain form show later is the filtercondition interface of this form configuration, the present invention by filtercondition allocation list in metadatabase, for each form is configured with respective personalized filtering interface.In filtering interface, the mode that filtercondition allocation list shows except configuring each condition, if it is user-selected to be also configured with this condition, by the condition inserted in query statement.When user inputs the filtercondition needed for oneself and inquires about, report number, will to be submitted in background server by control value, the filtercondition selected.
Step S213, background server receive submit on foreground report number, by select control value, after filtercondition, inquired the query statement of this form by report number, filtercondition is inserted in query statement, control value is submitted to database in the lump as query argument and performs inquiry;
This process also can carry out the processes such as paging process, parameter processing, sequence process.
Carry out paging process, parameter processing, sequence process be a kind of prior art, therefore, in embodiments of the present invention, describe in detail no longer one by one.
Step S214, after database performs inquiry, according to the definition of form exposition in metadatabase, shows result form.When user pays close attention to certain row data, according to the definition showing detailed information section in metadatabase, show details.
The present invention, after inquiry obtains result set, by reading form exhibition information allocation list, drawing form in the mode of Ajax, then being inserted wherein by data result collection.The present invention supports paging query, and in paging query, more crucial technology is exactly the maintenance of state, comprises query statement, filtercondition, query argument, paging information etc.Above status information has been encapsulated in value object when returning results collection by the present invention, both can ensure that each paging is all identical inquiry, also can ensure the data consistency that subsequent data is derived.
In the embodiment of the present invention, as a kind of embodiment, when user is when checking Query Result, by clicking certain a line result data, enter the details of these data of details showing interface; When the row in Query Result are many, in order to the effect shown, some row in inquiry form can be set to " not showing ", then these row will not be presented in form, and be presented in details.In addition, serve more easily to provide to client, except showing the information of this record in details, other relevant information can also be shown by the form of Shipping Options Page, as made out an invoice while information display taxpayer, invoice stock that this taxpayer is correlated with can also be shown, declare dutiable goods, the information such as registration.Whether first other relevant information has been made into template, only need configuration report number, template number, DISPLAY ORDER, title, querying condition (if also will add special condition on the basis of template herein) herein, and show.
Step S220, derivation is performed after user inquires about form, by the query argument of query State object acquisition inquiry last time, then from metadatabase, read form exhibition information allocation list, go to perform statistical conversion according to the data of these allocation lists, data and the form of derivation use identical query statement, identical displaying form.
When user inquires the data of various form, an often adjoint action is exactly statistical conversion, and the statistical conversion inquired is become excel file.Here, the data in export and report query data out often have a corresponding relation, such as derive all data that this page should be just this page of display, derive and all just should use same query statement and parameter with report query by derived data.Moreover, the data layout in export should be also the same with the data layout in form, such as column width, alignment thereof, data display format etc.
The present invention, by the configuration of metadatabase, achieves export and the consistance of inquiring about form well.Derivation is performed after user inquires about form, by the data such as query statement, query argument, filtercondition, paging information of query State object acquisition inquiry last time, then from metadatabase, report messages allocation list is read, according to the form of form in the data configure export of this table, perform inquiry with the identical query statement of inquiry form, Query Result to be filled in export and to derive.
The data processing method based on metadatabase of the embodiment of the present invention by the design of metadatabase, for data query and derivation provide convenient and processing mode flexibly.The present invention proposes the concept of metadatabase, every configuration data of inquiry form is stored in a database.Developer is write and to design form more convenient, they only need to go adjustment metadatabase just passable in a database.Meanwhile, then convenient when operation maintenance personnel and enforcement personnel will adjust form according to user's request at user scene, greatly reduce the difficulty of operation maintenance.
Finally it should be noted that obviously, those skilled in the art can carry out various change and modification to the present invention and not depart from the spirit and scope of the present invention.Like this, if these amendments of the present invention and modification belong within the scope of the claims in the present invention and equivalent technologies thereof, then the invention is intended to also to comprise these and change and modification.
Claims (4)
1. based on a data processing method for metadatabase, it is characterized in that, comprise the steps:
By the configuration data needed for report query and statistical conversion, comprise the configuration of report messages, the configuration of filtercondition, the configuration of form exhibition information, the configuration of details, saved by the form of metadatabase;
When user enters Reports module, enumerate report messages by metadatabase to select for user, there is provided report filtering condition for user's input, according to the form display Query Result of metadatabase definition, and displaying associated detailed information, meanwhile, when receiving the statistical conversion request that user proposes, use same parameter to perform inquiry, use same form export.
2. data processing method according to claim 1, is characterized in that, is describedly comprised the steps: by configuration data needed for report query and statistical conversion
Configuration report messages allocation list, configures the information of all forms, comprises the numbering of form, title, report form type, form classification, title, gauge outfit subtitle, query statement, whether onset, creator and date;
Configurating filtered condition allocation list, configures the filtercondition that each form provides for user, comprise report number, filtercondition title, control name, control type, conditional statement, query argument, control width, highly, row cross over, row cross over;
Configuration form exhibition information allocation list, whether the form of the report interface that configuration querying result should show and statistical conversion file, comprise report number, row name, Chinese name, DISPLAY ORDER, col width, data layout, layout, row leap, show;
Configuration details allocation list, whether how configure user shows the details of this line item when clicking certain line item, comprise report number, template number, DISPLAY ORDER, title, querying condition, show.
3. data processing method according to claim 1 and 2, it is characterized in that, it is described when user enters Reports module, enumerate report messages by metadatabase to select for user, there is provided report filtering condition for user's input, according to the form display Query Result of metadatabase definition, and show associated detailed information, comprise the steps:
When user enters Reports module, enumerate report messages by metadatabase and select for user, provide report filtering condition for user's input, according to the form display Query Result of metadatabase definition, and show associated detailed information;
Derivation is performed after user inquires about form, by the query argument of query State object acquisition inquiry last time, then from metadatabase, read the information of each allocation list, go to perform statistical conversion according to the data of these allocation lists, data and the form of derivation use identical query statement, identical displaying form.
4. data processing method according to claim 3, it is characterized in that, it is described when user enters Reports module, enumerate report messages by metadatabase to select for user, there is provided report filtering condition for user's input, according to the form display Query Result of metadatabase definition, and show associated detailed information, comprise the steps:
Enumerate all forms when user enters form center to select for user, all report messages in described form center all derive from the data in metadatabase report messages allocation list;
When user selects a form, the filtercondition showing this form for user's input, user input filtercondition needed for oneself and requesting query time, report number, will to be submitted in background server by control value, the filtercondition selected;
Background server receive submit on foreground report number, by select control value, after filtercondition, the query statement of this form is inquired by report number, filtercondition is inserted in query statement, control value is submitted to database in the lump as query argument and performs inquiry;
After database performs inquiry, show the definition to this form in allocation list according to form in metadatabase, show form according to corresponding form; When selecting certain record in form as user, show the details of this record according to the definition in details allocation list in metadatabase.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201310646882.4A CN104699681A (en) | 2013-12-04 | 2013-12-04 | Data processing method based on metadata base |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201310646882.4A CN104699681A (en) | 2013-12-04 | 2013-12-04 | Data processing method based on metadata base |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN104699681A true CN104699681A (en) | 2015-06-10 |
Family
ID=53346819
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201310646882.4A Pending CN104699681A (en) | 2013-12-04 | 2013-12-04 | Data processing method based on metadata base |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN104699681A (en) |
Cited By (19)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105138501A (en) * | 2015-08-10 | 2015-12-09 | 北京思特奇信息技术股份有限公司 | Configurable dynamic report generating method and system |
| CN105404442A (en) * | 2015-09-24 | 2016-03-16 | 国网山东省电力公司 | Selection screen configuration method and system based on SAP (System Applications and Products in Data Processing) platform |
| CN106570004A (en) * | 2015-10-08 | 2017-04-19 | 北京国双科技有限公司 | Data management method device |
| CN107315808A (en) * | 2017-06-27 | 2017-11-03 | 石化盈科信息技术有限责任公司 | A kind of Web query framework |
| CN107451104A (en) * | 2017-06-23 | 2017-12-08 | 江苏艾科半导体有限公司 | A kind of file version information storage method and its special purpose device |
| CN108153919A (en) * | 2018-02-28 | 2018-06-12 | 弘成科技发展有限公司 | DBF data export platform and its deriving method |
| CN108388588A (en) * | 2018-01-30 | 2018-08-10 | 福建星瑞格软件有限公司 | The offline read method of database functions and system of sql sentence Auto-Generation Tools |
| CN109063146A (en) * | 2018-08-07 | 2018-12-21 | 北京神州泰岳软件股份有限公司 | A kind of data export method, apparatus and system |
| CN109213969A (en) * | 2018-08-31 | 2019-01-15 | 北京海数宝科技有限公司 | Inventory format switching method, device, computer equipment and storage medium |
| CN109582936A (en) * | 2017-09-28 | 2019-04-05 | 北京国双科技有限公司 | The method and apparatus for configuring report messages |
| CN109614408A (en) * | 2018-10-25 | 2019-04-12 | 南京行者易智能交通科技有限公司 | The implementation method of web terminal self-defined report based on spring and poi |
| CN110413974A (en) * | 2019-07-26 | 2019-11-05 | 北京恒华伟业科技股份有限公司 | Form template configuration and device, table deriving method and device |
| CN110941654A (en) * | 2019-11-25 | 2020-03-31 | 杭州晨鹰军泰科技有限公司 | Data query display system, method, device and medium based on configuration template |
| CN110990654A (en) * | 2019-12-04 | 2020-04-10 | 山东浪潮通软信息科技有限公司 | Method and system for controlling data to be displayed on demand |
| CN111143358A (en) * | 2019-12-13 | 2020-05-12 | 航天信息股份有限公司 | Report configuration method and system |
| CN112036143A (en) * | 2020-09-02 | 2020-12-04 | 中国银行股份有限公司 | Method and system for generating sustainable self-defined report responding to report requirement |
| CN112434507A (en) * | 2020-12-10 | 2021-03-02 | 四川长虹电器股份有限公司 | Electronic bill generating method based on bill element configuration |
| CN112905558A (en) * | 2020-12-30 | 2021-06-04 | 银盛通信有限公司 | Report system implementation method and system based on database configuration |
| CN113407563A (en) * | 2021-06-04 | 2021-09-17 | 莱斯发展有限公司 | Query form generation method, device and equipment |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US6529911B1 (en) * | 1998-05-27 | 2003-03-04 | Thomas C. Mielenhausen | Data processing system and method for organizing, analyzing, recording, storing and reporting research results |
| CN1787448A (en) * | 2004-12-06 | 2006-06-14 | 中兴通讯股份有限公司 | Method for auto-forming reporting forms of telecommunication equipment performance |
| CN101697123A (en) * | 2009-10-20 | 2010-04-21 | 金蝶软件（中国）有限公司 | Method and device for modifying interface layout in ERP system and ERP system |
| CN101719119A (en) * | 2009-11-18 | 2010-06-02 | 上海众恒信息产业有限公司 | Report management system and method |
| CN102789457A (en) * | 2011-05-17 | 2012-11-21 | 航天信息股份有限公司 | Method for dynamically customizing filter conditions |
-
2013
- 2013-12-04 CN CN201310646882.4A patent/CN104699681A/en active Pending
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US6529911B1 (en) * | 1998-05-27 | 2003-03-04 | Thomas C. Mielenhausen | Data processing system and method for organizing, analyzing, recording, storing and reporting research results |
| CN1787448A (en) * | 2004-12-06 | 2006-06-14 | 中兴通讯股份有限公司 | Method for auto-forming reporting forms of telecommunication equipment performance |
| CN101697123A (en) * | 2009-10-20 | 2010-04-21 | 金蝶软件（中国）有限公司 | Method and device for modifying interface layout in ERP system and ERP system |
| CN101719119A (en) * | 2009-11-18 | 2010-06-02 | 上海众恒信息产业有限公司 | Report management system and method |
| CN102789457A (en) * | 2011-05-17 | 2012-11-21 | 航天信息股份有限公司 | Method for dynamically customizing filter conditions |
Cited By (24)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105138501B (en) * | 2015-08-10 | 2018-04-03 | 北京思特奇信息技术股份有限公司 | A kind of configurable dynamic report generation method and system |
| CN105138501A (en) * | 2015-08-10 | 2015-12-09 | 北京思特奇信息技术股份有限公司 | Configurable dynamic report generating method and system |
| CN105404442A (en) * | 2015-09-24 | 2016-03-16 | 国网山东省电力公司 | Selection screen configuration method and system based on SAP (System Applications and Products in Data Processing) platform |
| CN105404442B (en) * | 2015-09-24 | 2018-09-18 | 国网山东省电力公司 | Selection screen configuration method and system based on SAP platforms |
| CN106570004A (en) * | 2015-10-08 | 2017-04-19 | 北京国双科技有限公司 | Data management method device |
| CN106570004B (en) * | 2015-10-08 | 2021-03-30 | 北京国双科技有限公司 | Data management method and device |
| CN107451104A (en) * | 2017-06-23 | 2017-12-08 | 江苏艾科半导体有限公司 | A kind of file version information storage method and its special purpose device |
| CN107315808A (en) * | 2017-06-27 | 2017-11-03 | 石化盈科信息技术有限责任公司 | A kind of Web query framework |
| CN109582936A (en) * | 2017-09-28 | 2019-04-05 | 北京国双科技有限公司 | The method and apparatus for configuring report messages |
| CN108388588A (en) * | 2018-01-30 | 2018-08-10 | 福建星瑞格软件有限公司 | The offline read method of database functions and system of sql sentence Auto-Generation Tools |
| CN108153919A (en) * | 2018-02-28 | 2018-06-12 | 弘成科技发展有限公司 | DBF data export platform and its deriving method |
| CN109063146A (en) * | 2018-08-07 | 2018-12-21 | 北京神州泰岳软件股份有限公司 | A kind of data export method, apparatus and system |
| CN109213969A (en) * | 2018-08-31 | 2019-01-15 | 北京海数宝科技有限公司 | Inventory format switching method, device, computer equipment and storage medium |
| CN109614408A (en) * | 2018-10-25 | 2019-04-12 | 南京行者易智能交通科技有限公司 | The implementation method of web terminal self-defined report based on spring and poi |
| CN109614408B (en) * | 2018-10-25 | 2019-09-20 | 南京行者易智能交通科技有限公司 | The implementation method of web terminal self-defined report based on spring and poi |
| CN110413974A (en) * | 2019-07-26 | 2019-11-05 | 北京恒华伟业科技股份有限公司 | Form template configuration and device, table deriving method and device |
| CN110941654A (en) * | 2019-11-25 | 2020-03-31 | 杭州晨鹰军泰科技有限公司 | Data query display system, method, device and medium based on configuration template |
| CN110990654A (en) * | 2019-12-04 | 2020-04-10 | 山东浪潮通软信息科技有限公司 | Method and system for controlling data to be displayed on demand |
| CN111143358A (en) * | 2019-12-13 | 2020-05-12 | 航天信息股份有限公司 | Report configuration method and system |
| CN112036143A (en) * | 2020-09-02 | 2020-12-04 | 中国银行股份有限公司 | Method and system for generating sustainable self-defined report responding to report requirement |
| CN112036143B (en) * | 2020-09-02 | 2023-09-22 | 中国银行股份有限公司 | Method and system for generating sustainable custom report responding to report demand |
| CN112434507A (en) * | 2020-12-10 | 2021-03-02 | 四川长虹电器股份有限公司 | Electronic bill generating method based on bill element configuration |
| CN112905558A (en) * | 2020-12-30 | 2021-06-04 | 银盛通信有限公司 | Report system implementation method and system based on database configuration |
| CN113407563A (en) * | 2021-06-04 | 2021-09-17 | 莱斯发展有限公司 | Query form generation method, device and equipment |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN104699681A (en) | Data processing method based on metadata base | |
| EP3485400B1 (en) | Methods and systems for server-side rendering of native content for presentation | |
| JP2024029229A (en) | System and method for server of website construction system | |
| CN102779040B (en) | A kind of method and apparatus generating customizing form | |
| CN100430939C (en) | Method and system for client-side manipulation of tables | |
| CN102789491B (en) | A kind of configurable data subscription and delivery system and method thereof | |
| US7756819B2 (en) | Integrated authoring system for electronic technical manual and paper technical manual using logistics support analysis data and authoring method therefor | |
| CN104133772A (en) | Automatic test data generation method | |
| CN103827857A (en) | Personalized content delivery system and method | |
| US10248643B2 (en) | Detecting compatible layouts for content-based native ads | |
| KR101275871B1 (en) | System and method for producing homepage in SaaS ENVIRONMENT, A computer-readable storage medium therefor | |
| CN105354025A (en) | Service model configuration system and method based on mobile application | |
| CN107203595A (en) | A kind of method of the dynamic generation web interface based on flexible form | |
| CN102163237A (en) | Implementation method of loosely coupled flow | |
| CN111427577A (en) | Code processing method and device and server | |
| CN111414405A (en) | Data acquisition method and device and electronic equipment | |
| CN105138532A (en) | Method, device and system for processing service data | |
| CN101354723B (en) | Method and apparatus for implementing combined field | |
| CN113538626A (en) | Workflow generation method and device | |
| CN104182226B (en) | A kind of General Mobile information system adaptation method and device | |
| US8799256B2 (en) | Incorporated web page content | |
| CN108572817B (en) | Method, apparatus and medium for dynamic resource configuration based on business modeling | |
| CN104199648B (en) | A kind of General Mobile information system adaptation method and device | |
| CN113760285A (en) | Page configuration method and device, computer equipment and page display method | |
| JP4959501B2 (en) | Information processing apparatus, information processing method, and program |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20150610 |
|
| RJ01 | Rejection of invention patent application after publication |