CN106776644A - A kind of reporting system collocation method and device - Google Patents
A kind of reporting system collocation method and device Download PDFInfo
- Publication number
- CN106776644A CN106776644A CN201510825179.9A CN201510825179A CN106776644A CN 106776644 A CN106776644 A CN 106776644A CN 201510825179 A CN201510825179 A CN 201510825179A CN 106776644 A CN106776644 A CN 106776644A
- Authority
- CN
- China
- Prior art keywords
- user
- data
- information
- submodule
- determining
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Granted
Links
- 238000000034 method Methods 0.000 title claims abstract description 60
- 238000013075 data extraction Methods 0.000 claims description 39
- 238000000605 extraction Methods 0.000 claims description 21
- 238000001914 filtration Methods 0.000 claims description 21
- 238000012216 screening Methods 0.000 abstract 2
- 230000008569 process Effects 0.000 description 18
- 238000010586 diagram Methods 0.000 description 10
- 230000006870 function Effects 0.000 description 10
- 238000004590 computer program Methods 0.000 description 7
- 238000004458 analytical method Methods 0.000 description 5
- 238000012545 processing Methods 0.000 description 5
- 238000011161 development Methods 0.000 description 4
- 230000018109 developmental process Effects 0.000 description 4
- 238000003860 storage Methods 0.000 description 4
- 230000009471 action Effects 0.000 description 3
- 230000004048 modification Effects 0.000 description 3
- 238000012986 modification Methods 0.000 description 3
- 230000002776 aggregation Effects 0.000 description 2
- 238000004220 aggregation Methods 0.000 description 2
- 238000004891 communication Methods 0.000 description 2
- 230000000694 effects Effects 0.000 description 2
- 239000012634 fragment Substances 0.000 description 2
- 238000004519 manufacturing process Methods 0.000 description 2
- 230000004075 alteration Effects 0.000 description 1
- 230000009286 beneficial effect Effects 0.000 description 1
- 238000004364 calculation method Methods 0.000 description 1
- 230000008859 change Effects 0.000 description 1
- 238000010276 construction Methods 0.000 description 1
- 238000007405 data analysis Methods 0.000 description 1
- 230000007547 defect Effects 0.000 description 1
- 238000013461 design Methods 0.000 description 1
- 230000002349 favourable effect Effects 0.000 description 1
- 230000010365 information processing Effects 0.000 description 1
- 230000010354 integration Effects 0.000 description 1
- 230000003993 interaction Effects 0.000 description 1
- 238000004573 interface analysis Methods 0.000 description 1
- 230000003287 optical effect Effects 0.000 description 1
- 230000000750 progressive effect Effects 0.000 description 1
- 230000033772 system development Effects 0.000 description 1
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
- G06F16/2455—Query execution
- G06F16/24553—Query execution of query operations
- G06F16/24558—Binary matching operations
- G06F16/2456—Join operations
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/242—Query formulation
- G06F16/2428—Query predicate definition using graphical user interfaces, including menus and forms
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
- G06F16/2457—Query processing with adaptation to user needs
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/25—Integrating or interfacing systems involving database management systems
- G06F16/254—Extract, transform and load [ETL] procedures, e.g. ETL data flows in data warehouses
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Databases & Information Systems (AREA)
- Physics & Mathematics (AREA)
- Data Mining & Analysis (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Computational Linguistics (AREA)
- Human Computer Interaction (AREA)
- Mathematical Physics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
A kind of reporting system collocation method and device are the embodiment of the invention provides, method therein includes：Reporting system receives the retrieval source configuration information that user sends；Based on received retrieval source configuration information configuration retrieval source；Receive the ways of presentation configuration information for data in the retrieval source that the user sends；Based on the ways of presentation configuration information configuration data ways of presentation；It is determined that the screening washer and querying condition pattern corresponding with the retrieval source；Reporting system query interface is generated according to the ways of presentation configuration information, screening washer and querying condition pattern.Reporting system collocation method provided in an embodiment of the present invention is flexible and easy to operate, the need for the reporting system based on the method generation disclosure satisfy that any field user and possesses very strong continuity.
Description
Technical Field
The invention relates to the technical field of information processing, in particular to a method and a device for configuring a report system.
Background
Currently, there are two types of reporting systems: self-defining Report tool products, such as Fine Report and the like, and Report tool products with fixed business directions, such as financial tools of companies such as Youyou and Jinma.
The user-defined report work product is a client product, is usually developed by technologies such as JAVA, C or delphi and the like, is convenient to deploy and can be directly installed; since the products do not have fixed service range and direction, a large number of complex functions are provided so as to be suitable for various service scenes. The product needs the following ability for users in use:
(a) SQL script writing capability
The operation for extracting the product report data comprises the selection of tables and fields and the compiling of a complex storage process;
(b) data analysis capability
The method is used for analyzing the business data to give the most effective statistical information and more efficient query means;
(c) related business capability
Users need to deeply understand the business, so that the statistical information and the report which are required by the users can be simply and effectively configured; and meanwhile, new query requirements appear, and users also need to repeatedly perform query configuration operation.
The report tool with fixed business direction is usually an enterprise internal directional development product or a product of the same industry type, and is usually developed by C or JAVA and other languages in a B/S or C/S structure, and the product needs a server with better performance to support; before the development of the product, a demand engineer and a user are required to carry out targeted communication and engagement in an early stage, and the demand of the user is mined to achieve all expectations of the user, so that the production period of the product is very long and the universality is low, the user can achieve a good effect when using the product in the early stage, but under the condition that the later query demand is changed or newly increased, the workload of the engineer on the demand modification is basically similar to that of re-developing a product.
Therefore, the custom report tool product has the defects that a fixed service range and direction are not available, so that a great deal of functions are provided, and a user needs a great deal of time to deeply learn, but the performance of the product is obvious and not peculiar in the specific service field of some users in order to ensure the universality of the product; moreover, the configuration method is complex, the user is required to have the scripting capability (including complex stored procedure scripting) of some databases (such as ORACLE, SQLSERVER and MYSQL), and the user is required to be very familiar with the service logic and database model of the service system.
The report tool product with the fixed business direction has the disadvantages that the system development period is too long, a development team is required to invest a large amount of time and manpower, the system can be put into use as soon as possible in the early stage and can achieve the final effect expected by a user, the user requirement is changed from time to time, and the changed requirement also requires a large amount of time to communicate with personnel and carry out redevelopment; therefore, such products are not very continuous, and the change and new increase of user requirements can bring a serious disaster to the system.
Disclosure of Invention
In order to solve the problems that a custom report tool in the prior art has low performance in a specific business field, is complex in configuration and has high requirements on users, and report products with fixed business directions have weak development continuity, the embodiment of the invention provides a report system configuration method and a report system configuration device.
The embodiment of the invention provides a report system configuration method, which comprises the following steps:
the report system receives retrieval source configuration information sent by a user;
configuring a retrieval source based on the received retrieval source configuration information;
receiving presentation mode configuration information which is sent by the user and aims at the data in the retrieval source;
configuring a data display mode based on the display mode configuration information;
determining a filter and a query condition style corresponding to the retrieval source;
and generating a report system query interface according to the presentation mode configuration information, the filter and the query condition style.
Preferably, the retrieving the source configuration information includes: retrieving source connection information;
the retrieving source connection information includes: database connection information and/or data table connection information;
the configuring the search source based on the received search source configuration information comprises:
determining a database and/or a data table connected with a reporting system based on the retrieval source connection information;
and establishing connection with the database and/or the data table.
Preferably, the configuring a search source based on the received search source configuration information further includes:
extracting fields in a data table and/or fields in the data table in the database, and determining the extracted fields as first dimension information;
sending the determined first dimension information to a user;
receiving second dimension information selected by a user from the determined first dimension information;
and determining the second dimension information as dimension information concerned by the user.
Preferably, the retrieving the source configuration information further includes: data extraction cycle configuration information;
the configuring a search source based on the received search source configuration information further comprises:
extracting a data extraction period in the data extraction period configuration information;
determining the extracted data extraction period as a data extraction period for extracting data from a data source;
and extracting data from the data source according to the data extraction period.
Preferably, the configuring the data presentation mode based on the presentation mode configuration information includes:
extracting the presentation mode contained in the presentation mode configuration information;
and determining the extracted presentation mode as the presentation mode when the data in the retrieval source is presented.
Preferably, the determining the filter corresponding to the retrieval source includes:
extracting fields of the data table in the database connected with the reporting system and/or fields of the data table connected with the reporting system;
respectively determining the attribute value of each field;
respectively sending each field and the attribute value corresponding to each field to a user for selection;
receiving fields selected by a user and attribute values corresponding to the fields;
determining the fields selected by the user as fields concerned by the user, and determining the attribute value corresponding to each field as the attribute value concerned by the user;
and setting fields concerned by the user as the filtering conditions of the filter, and setting the attribute values of the fields as the values of the filtering conditions corresponding to the fields, thereby generating the filter.
Preferably, the determining the query condition style corresponding to the retrieval source includes:
the report system presets a plurality of query condition styles corresponding to the retrieval sources for selection by a user;
receiving a query condition style selected by a user;
and determining the query condition style selected by the user as the query condition style of the user.
The embodiment of the invention provides a report system configuration device, which comprises: the system comprises an information receiving module, a retrieval source configuration module, data display mode configuration information, a determining module and an interface generating module; wherein,
the information receiving module is used for receiving retrieval source configuration information sent by a user and presentation mode configuration information aiming at data in the retrieval source sent by the user;
the retrieval source configuration module is used for configuring a retrieval source based on the received retrieval source configuration information;
the data presentation mode configuration module is used for configuring a data presentation mode based on the presentation mode configuration information;
the determining module is used for determining a filter and a query condition pattern corresponding to the retrieval source;
and the interface generating module is used for generating a query interface of the report system according to the display mode configuration information, the filter and the query condition style.
Preferably, the retrieving the source configuration information includes: retrieving source connection information; the retrieving source connection information includes: database connection information and/or data table connection information;
the retrieval source configuration module comprises: a first determination submodule and a connection submodule; wherein,
the first determining submodule is used for determining a database and/or a data table connected with a reporting system based on the retrieval source connection information;
and the connection sub-module is used for connecting the reporting system with the database and/or the data table.
Preferably, the retrieval source configuration module further comprises: the system comprises a first extraction submodule, a first information sending submodule and a first information receiving submodule; wherein,
the first extraction submodule is used for extracting fields in a data table in the database and/or fields in the data table;
the first determining submodule is used for determining the extracted field as first dimension information;
the first information sending submodule is used for sending the determined first dimension information to a user;
the first information receiving submodule is used for receiving second dimension information selected by a user from the determined first dimension information;
the first determining submodule is used for determining the second dimension information as the dimension information concerned by the user.
Preferably, the retrieving the source configuration information further includes: data extraction cycle configuration information;
the first extraction submodule is further configured to extract a data extraction period in the data extraction period configuration information;
the first determining submodule is further used for determining the extracted data extraction period as a data extraction period for the reporting system to extract data from a data source;
the retrieval source configuration module further comprises: and the data extraction submodule is used for extracting data from the data source according to the data extraction period.
Preferably, the data presentation mode configuration module includes: a second extraction submodule and a second determination submodule; wherein,
the second extraction submodule is used for extracting the presentation modes contained in the presentation mode configuration information;
and the second determining submodule is used for determining the extracted presentation mode as the presentation mode when the data in the retrieval source is presented.
Preferably, the determining module includes: a third extraction submodule, a third determination submodule, a second information sending submodule, a second information receiving submodule and a filter generation submodule; wherein,
the third extraction submodule is used for extracting fields of the data table in the database connected with the reporting system and/or fields of the data table connected with the reporting system;
the third determining submodule is used for respectively determining the attribute values of all the fields;
the second information sending submodule is used for respectively sending the fields and the attribute values corresponding to the fields to a user for selection;
the second information receiving submodule is used for receiving fields selected by a user and attribute values corresponding to the fields;
the third determining submodule is further configured to determine the fields selected by the user as fields concerned by the user, and determine an attribute value corresponding to each field as an attribute value concerned by the user;
the filter generation submodule is used for generating a filter according to the following modes:
setting fields concerned by a user as filter conditions of a filter, and setting attribute values of the fields as values of the filter conditions corresponding to the fields.
Preferably, the determining module further includes: the setting submodule is used for presetting a plurality of query condition styles corresponding to the retrieval sources for a user to select;
the second information receiving submodule is also used for receiving a query condition style selected by a user;
and the third determining submodule is also used for determining the query condition style selected by the user as the query condition style of the report system.
Compared with the prior art, the embodiment of the invention has the following advantages:
the report system configuration method and the report system configuration device provided by the embodiment of the invention can receive retrieval source configuration information sent by a user and presentation mode configuration information aiming at data in a retrieval source sent by the user; configuring a retrieval source based on the received retrieval source configuration information and configuring a data presentation mode based on the presentation mode configuration information; the report system can also determine a filter and a query condition style corresponding to the retrieval source; and finally generating a report system query interface according to the presentation mode configuration information, the filter and the query condition style. In the generating process of the report system query interface, a user only needs to send retrieval source configuration information and display mode configuration information aiming at data in a retrieval source to the report system through a functional interface provided by the report system, and the configuration mode is flexible and simple to operate; in addition, the report system can also directly determine the filter and the query condition style corresponding to the retrieval source, thereby simplifying the configuration process for the user; in addition, because the user participates in the whole process of generating the report system query interface, the report system query interface is completely customized according to the user requirement, completely accords with the use habit of the user, and can meet the requirements of users in any field; moreover, based on the functional interface provided by the report system, when the user requirement changes, the corresponding configuration can be conveniently carried out through the functional interface, so that the system query interface is regenerated, and the continuity of the report system is greatly enhanced.
Drawings
Fig. 1 is a first flowchart of a report system configuration method according to an embodiment of the present invention;
FIG. 2 is a flowchart of a report system configuration method according to an embodiment of the present invention;
fig. 3 is a basic structure diagram of a report system configuration device according to an embodiment of the present invention.
Detailed Description
Example one
Referring to fig. 1, a flowchart of a first embodiment of a report system configuration method according to the present invention is shown, where the method is applied to a report system, and specifically may include:
step 101, receiving retrieval source configuration information sent by a user;
specifically, in this step, the reporting system receives retrieval source configuration information sent by the user, where the retrieval source configuration information is used to configure the retrieval source; the retrieval source is typically a database, or a plurality of data tables; the plurality of data tables may be stored in the form of tables, intermediate tables, views, or fragments of Structured Query Language (SQL) statements, or functions, or stored procedures; the database contains one or more data tables. The reporting system obtains data through the retrieval source. In the step, the user can configure the retrieval source which can be retrieved by the report system according to the self requirement and the self authority, and in the configuration process, the retrieval source configuration information is sent to the report system.
102, configuring a retrieval source based on the received retrieval source configuration information;
in step 101, after the report system receives the retrieval source configuration information sent by the user, in step 102, the retrieval source is configured based on the received retrieval source configuration information, that is, through step 101 and step 102, based on the functional interface provided by the report system, the user can configure the retrieval source according to the actual situation of the user.
103, receiving presentation mode configuration information aiming at the data in the retrieval source, which is sent by the user;
the report system obtains data through a retrieval source to generate a report, so that the display mode of the data needs to be determined. Therefore, in this step, the presentation mode configuration information for the data in the search source sent by the user is received.
104, configuring a data display mode based on the display mode configuration information;
the reporting system configures the data presentation mode according to the presentation mode configuration information for the data in the retrieval source sent by the user, that is, through step 103 and step 104, based on the functional interface provided by the reporting system, the user can configure the data presentation mode according to the need of the user.
Step 105, determining a filter and a query condition style corresponding to the retrieval source;
after the retrieval source is determined, the report system can determine a filter corresponding to the retrieval source through analysis of the retrieval source on one hand, and can also determine a query condition style corresponding to the retrieval source on the other hand.
And 106, generating a report system query interface according to the presentation mode configuration information, the filter and the query condition style.
Specifically, after the presentation mode configuration information, the filter and the query condition style are determined, the system can generate a report system query interface according to the information, and the interface is generated based on user configuration and analysis of the report system.
In the process of generating the report system query interface, the user participates in the whole process, so the report system query interface is completely customized according to the user requirement and completely accords with the use habit of the user.
In summary, according to the report system configuration method provided by the embodiment of the present invention, the retrieval source configuration information sent by the user and the presentation mode configuration information sent by the user for the data in the retrieval source can be received; configuring a retrieval source based on the received retrieval source configuration information and configuring a data presentation mode based on the presentation mode configuration information; the report system can also determine a filter and a query condition style corresponding to the retrieval source; and finally generating a report system query interface according to the presentation mode configuration information, the filter and the query condition style. In the generating process of the report system query interface, a user only needs to send retrieval source configuration information and display mode configuration information aiming at data in a retrieval source to the report system through a functional interface provided by the report system, and the configuration mode is flexible and simple to operate; in addition, the report system can also directly determine the filter and the query condition style corresponding to the retrieval source, thereby simplifying the configuration process for the user; in addition, because the user participates in the whole process of generating the report system query interface, the report system query interface is completely customized according to the user requirement, completely accords with the use habit of the user, and can meet the requirements of users in any field; moreover, based on the functional interface provided by the report system, when the user requirement changes, the corresponding configuration can be conveniently carried out through the functional interface, so that the system query interface is regenerated, and the continuity of the report system is greatly enhanced.
Example two
Referring to fig. 2, a flowchart illustrating steps of an embodiment of a reporting system configuration method according to the present invention is shown, which may specifically include:
step 201, receiving retrieval source configuration information sent by a user, where the retrieval source configuration information includes: retrieving source connection information, the retrieving source connection information comprising: database connection information and/or data table connection information;
specifically, in this step, the reporting system receives retrieval source configuration information sent by the user, where the retrieval source configuration information is used to configure the retrieval source; in practical application, because the access authority of users is different or the data security problem is considered, the access authority of the databases cannot be directly opened to the reporting system, at this time, the data tables which allow the reporting system to access can be used as a retrieval source, and if the users determine that the access authority of a certain database can be opened to the reporting system, the databases can also be directly used as the retrieval source; of course, the database and one or more data tables can be used as the retrieval source at the same time; the plurality of data tables can be stored in the form of tables, intermediate tables, views, or SQL statement fragments, or functions, or stored procedures; the database contains one or more data tables. The reporting system obtains data through the retrieval source. In the step, the user can configure the retrieval source which can be retrieved by the report system according to the self requirement and the self authority, and in the configuration process, the retrieval source configuration information is sent to the report system.
Step 202, configuring a retrieval source based on the received retrieval source configuration information;
in step 201, after the report system receives the retrieval source configuration information sent by the user, in step 202, the retrieval source is configured based on the received retrieval source configuration information, that is, through step 201 and step 202, based on the functional interface provided by the report system, the user can configure the retrieval source according to the actual situation of the user.
Specifically, the configuring a search source based on the received search source configuration information includes:
determining a database and/or a data table connected with a reporting system based on the retrieval source connection information;
and establishing connection with the database and/or the data table.
In another optional embodiment of the present invention, the configuring a search source based on the received search source configuration information further includes:
extracting fields in a data table and/or fields in the data table in the database, and determining the extracted fields as first dimension information;
sending the determined first dimension information to a user;
receiving second dimension information selected by a user from the determined first dimension information;
and determining the second dimension information as dimension information concerned by the user.
In the above scheme, the first data dimension information or the second dimension information includes a dimension name, a dimension type, a dimension description, and a correspondence between a code and a name in a partial dimension type; the dimension types include, but are not limited to: time and region type.
In another optional embodiment of the present invention, the retrieving the source configuration information further includes: data extraction cycle configuration information;
the configuring a search source based on the received search source configuration information further comprises:
extracting a data extraction period in the data extraction period configuration information;
determining the extracted data extraction period as a data extraction period for extracting data from a data source;
and extracting data from the data source according to the data extraction period.
Step 203, receiving presentation mode configuration information aiming at the data in the retrieval source, which is sent by the user;
the report system obtains data through a retrieval source to generate a report, so that the display mode of the data needs to be determined. Therefore, in this step, the presentation mode configuration information for the data in the search source sent by the user is received.
Step 204, configuring a data display mode based on the display mode configuration information;
the reporting system configures the data presentation mode according to the presentation mode configuration information for the data in the retrieval source sent by the user, that is, through the step 203 and the step 204, based on the functional interface provided by the reporting system, the user can configure the data presentation mode according to the need of the user.
The configuring the data presentation mode based on the presentation mode configuration information comprises:
extracting the presentation mode contained in the presentation mode configuration information;
and determining the extracted presentation mode as the presentation mode when the data in the retrieval source is presented.
Specifically, the presentation modes included in the presentation mode configuration information include basic presentation modes, such as lists, graphs or list graph interactions; the display mode may further include: a unique presentation mode; the unique display mode comprises the following steps: row aggregation, column aggregation, unique column calculations (including addition, subtraction, multiplication, division operations), parity-to-ring ratios, column percentage display, data highlighting cues, and the like.
Step 205, determining a query condition style corresponding to the retrieval source;
after the retrieval source is determined, the reporting system can determine a query condition style corresponding to the retrieval source.
Specifically, the determining the query condition style corresponding to the retrieval source includes:
the report system presets a plurality of query condition styles corresponding to the retrieval sources for selection by a user;
receiving a query condition style selected by a user;
and determining the query condition style selected by the user as the query condition style of the user.
In practical implementation, the report system can provide rich query condition styles, such as traditional styles (e.g., tree, drop-down box, input box, etc.), menu styles (e.g., e-commerce style menu filtering mode), and advanced query styles (i.e., query styles including single and multiple selection in advanced search, dynamic filtering, list fuzzy matching, etc.).
Therefore, the query condition style preset by the reporting system and corresponding to the retrieval source includes but is not limited to: traditional style, menu style, advanced query style.
Step 206, extracting the fields of the data table in the database connected with the report system and/or the fields of the data table connected with the report system;
a data table typically consists of a plurality of rows of data, each row of data containing one or more fields;
table 1 is a basic information table of a group member in a certain community of a certain school:
| name (I) | Age (age) | Hospital system | Professional | Native place | The department to which it belongs |
| One piece of Zhang | 19 | Institute of telecommunications | Communication engineering | Shaanxi province | Outer connecting part |
| Zhao two | 20 | Art college | Design of industry | Hunan province | Propaganda department |
| Sun III | 18 | Construction system | Building economic management | Shaanxi province | Movable part |
TABLE 1
As shown in Table 1, three lines of data are included, each line including five fields, name, age, department, specialty, native, and department.
Thus, the fields that can be extracted from table 1 are: name, age, department, specialty, native place, and department of the country.
Similarly, in step 206, the fields of the data tables and/or the fields of the data tables in the database are extracted, i.e. all the fields contained in all the data tables are extracted.
Step 207, determining the attribute values of each field respectively;
again taking table 1 as an example, this step is described, as shown in table 1, except for the home field, each field has three attribute values, for example, the age field has three attribute values: 19. 20, 18; and native fields have two attribute values: shanxi and hunan.
Step 208, respectively sending each field and the attribute value corresponding to each field to a user for selection;
step 209, receiving fields selected by a user and attribute values corresponding to the fields;
step 210, determining the fields selected by the user as fields concerned by the user, and determining the attribute value corresponding to each field as the attribute value concerned by the user;
step 211, setting fields concerned by the user as filter conditions of the filter, and setting attribute values of the fields as values of the filter conditions corresponding to the fields, thereby generating the filter;
this step, including steps 206 through 210, is to determine and generate a filter; the filter can be determined by the filtering condition and the value of the filtering condition;
for example, when the user selects the native filtering condition, that is, selects to filter the data according to the native, and after the native filtering is determined, the value of the filtering condition is further selected, the filtering according to a specific filtering condition can be determined, for example, when the user selects the native value as shanxi, all the native data records as shanxi are screened.
Because the data in the retrieval source is numerous, if the user requirement is determined through early-stage requirement analysis so as to determine the filter in the prior art, the user is likely to be unable to exhaust all dimensions concerned by the user and the value of each dimension, so that after the developer generates the filter according to the requirement, the actual requirement of the user is difficult to meet; on the other hand, if all dimensions in the data table are determined as filtering conditions, and all attribute values of each dimension are set as values of the filtering conditions, the user is difficult to use when using the filter undoubtedly, and when the user uses the filter to inquire, the user selects from the values of the filtering conditions or the filtering conditions with huge number, which is a time-consuming and labor-consuming matter and is not beneficial to the retrieval efficiency of the user using the report system; therefore, the dimensions and the attribute values of the dimensions concerned by the user are selected by the user through the steps, the filter can be generated by a scientific and reasonable scheme, the implementation mode is simple, and the actual needs of the user can be met.
And 212, generating a report system query interface according to the presentation mode configuration information, the filter and the query condition style.
Specifically, after the presentation mode configuration information, the filter and the query condition style are determined, the system can generate a report system query interface according to the information, and the interface is generated based on user configuration and analysis of the report system.
In the process of generating the report system query interface, the user participates in the whole process, so the report system query interface is completely customized according to the user requirement and completely accords with the use habit of the user.
Specifically, the report system analyzes the configuration information of the data presentation mode, the query condition pattern and the configuration information of the filter, and generates a relevant code of the query interface according to the configuration information of the data presentation mode, the query condition pattern and the configuration information of the filter, the code can be realized in a JAVA mode, a JSP mode, a JS mode, a relevant SQL script code and the like, the report system stores the analyzed information in a file or database mode, meanwhile, the report system stores a query interface analysis code access address, and when the report query function is used, the integration of the report query interface can be carried out only by accessing the address.
Therefore, by using the report system configuration method provided by the second embodiment of the present invention, not only can the query interface of the report system be customized according to the user's needs in a simple and fast manner, but also a filter is generated in a completely different manner, and the specific method is as follows:
extracting fields of a data table and/or fields of the data table in the database, respectively determining attribute values of the fields, respectively sending the fields and the attribute values corresponding to the fields to a user for selection, receiving the fields selected by the user and the attribute values corresponding to the fields, determining the fields selected by the user as fields concerned by the user, determining the attribute values corresponding to the fields as the attribute values concerned by the user, setting the fields concerned by the user as filter conditions of a filter, and setting the attribute values of the fields as values of the filter conditions corresponding to the fields, thereby generating the filter;
on one hand, compared with the prior art that when the user requirements are determined through early-stage requirement analysis to determine the filter, the user is likely to be unable to exhaust all dimensions concerned by the user and values of each dimension, and after the developer generates the filter according to the requirements, the problem that the actual requirements of the user are difficult to meet by the filter usually exists; in addition, in the scheme provided by the second embodiment of the invention, when the user requirement changes, the filter can be modified at any time through special functions, and the method is simple and has strong operability;
on the other hand, as the data in the retrieval source is numerous, if all dimensions in the data table are determined as the filtering conditions, all attribute values of each dimension are set as the values of the filtering conditions, the user is difficult to use the filter undoubtedly, and when the user uses the filter to inquire, the user selects from the huge number of filtering conditions or the values of the filtering conditions, so that the retrieval source is a time-consuming and labor-consuming matter and is not favorable for the retrieval efficiency of the user using the report system; therefore, the dimensions and the attribute values of the dimensions concerned by the user are selected by the user through the method, the filter can be generated by a scientific and reasonable scheme, the implementation mode is simple, and the actual needs of the user can be met.
Apparatus embodiment one
Referring to fig. 3, a block diagram of a configuration apparatus of a reporting system according to an embodiment of the present invention is shown, where the apparatus is located in the reporting system, and includes: the system comprises an information receiving module 31, a retrieval source configuration module 32, data display mode configuration information 33, a determining module 34 and an interface generating module 35; wherein,
the information receiving module 31 is configured to receive retrieval source configuration information sent by a user and presentation mode configuration information sent by the user and specific to data in the retrieval source;
the retrieval source configuration module 32 is configured to configure a retrieval source based on the received retrieval source configuration information;
the data presentation mode configuration module 33 is configured to configure a data presentation mode based on the presentation mode configuration information;
the determining module 34 is configured to determine a filter and a query condition pattern corresponding to the search source;
the interface generating module 35 is configured to generate a query interface of the report system according to the presentation mode configuration information, the filter, and the query condition style.
Specifically, the retrieving source configuration information includes: retrieving source connection information; the retrieving source connection information includes: database connection information and/or data table connection information;
specifically, the retrieval source configuration module 32 includes: a first determination submodule and a connection submodule; wherein,
the first determining submodule is used for determining a database and/or a data table connected with a reporting system based on the retrieval source connection information;
and the connection sub-module is used for connecting the reporting system with the database and/or the data table.
In another optional embodiment of the present invention, the retrieving source configuring module 32 further includes: the system comprises a first extraction submodule, a first information sending submodule and a first information receiving submodule; wherein,
the first extraction submodule is used for extracting fields in a data table in the database connected with the reporting system and/or fields in the data table connected with the reporting system;
the first determining submodule is used for determining the extracted field as first dimension information;
the first information sending submodule is used for sending the determined first dimension information to a user;
the first information receiving submodule is used for receiving second dimension information selected by a user from the determined first dimension information;
the first determining submodule is used for determining the second dimension information as the dimension information concerned by the user.
In another optional embodiment of the present invention, the retrieving the source configuration information further includes: data extraction cycle configuration information;
the first extraction submodule is further configured to extract a data extraction period in the data extraction period configuration information;
the first determining submodule is further used for determining the extracted data extraction period as a data extraction period for the reporting system to extract data from a data source;
the retrieval source configuration module further comprises: and the data extraction submodule is used for extracting data from the data source according to the data extraction period.
Specifically, the data presentation mode configuration module 33 includes: a second extraction submodule and a second determination submodule; wherein,
the second extraction submodule is used for extracting the presentation modes contained in the presentation mode configuration information;
and the second determining submodule is used for determining the extracted presentation mode as the presentation mode when the data in the retrieval source is presented.
Specifically, the determining module 34 includes: a third extraction submodule, a third determination submodule, a second information sending submodule, a second information receiving submodule and a filter generation submodule; wherein,
the third extraction submodule is used for extracting fields of a data table in the database and/or fields in the data table;
the third determining submodule is used for respectively determining the attribute values of all the fields;
the second information sending submodule is used for respectively sending the fields and the attribute values corresponding to the fields to a user for selection;
the second information receiving submodule is used for receiving fields selected by a user and attribute values corresponding to the fields;
the third determining submodule is further configured to determine the fields selected by the user as fields concerned by the user, and determine an attribute value corresponding to each field as an attribute value concerned by the user;
the filter generation submodule is used for generating a filter according to the following modes:
setting fields concerned by a user as filter conditions of a filter, and setting attribute values of the fields as values of the filter conditions corresponding to the fields.
In another optional embodiment of the present invention, the determining module 34 further includes: the setting submodule is used for presetting a plurality of query condition styles corresponding to the retrieval sources for a user to select;
the second information receiving submodule is also used for receiving a query condition style selected by a user;
and the third determining submodule is also used for determining the query condition style selected by the user as the query condition style of the report system.
In a specific implementation process, the information receiving module 31, the retrieval source configuration module 32, the data display mode configuration information 33, the determining module 34, the interface generating module 35, the first determining submodule and the connecting submodule, the first extracting submodule, the first information sending submodule, the first information receiving submodule, the data extracting submodule, the second determining submodule, the third extracting submodule, the third determining submodule, the second information sending submodule, the second information receiving submodule, the filter generating submodule, and the setting submodule may all be implemented by a Central Processing Unit (CPU), a microprocessor Unit (MPU), a Digital signal processor (DSP, Digital signal processor) or a Programmable logic Array (FPGA).
For the device embodiment, since it is basically similar to the method embodiment, the description is simple, and for the relevant points, refer to the partial description of the method embodiment.
The embodiments in the present specification are described in a progressive manner, each embodiment focuses on differences from other embodiments, and the same and similar parts among the embodiments are referred to each other.
As will be appreciated by one skilled in the art, embodiments of the present invention may be provided as a method, apparatus, or computer program product. Accordingly, embodiments of the present invention may take the form of an entirely hardware embodiment, an entirely software embodiment or an embodiment combining software and hardware aspects. Furthermore, embodiments of the present invention may take the form of a computer program product embodied on one or more computer-usable storage media (including, but not limited to, disk storage, CD-ROM, optical storage, and the like) having computer-usable program code embodied therein.
Embodiments of the present invention are described with reference to flowchart illustrations and/or block diagrams of methods, terminal devices (systems), and computer program products according to embodiments of the invention. It will be understood that each flow and/or block of the flow diagrams and/or block diagrams, and combinations of flows and/or blocks in the flow diagrams and/or block diagrams, can be implemented by computer program instructions. These computer program instructions may be provided to a processor of a general purpose computer, special purpose computer, embedded processor, or other programmable data processing terminal to produce a machine, such that the instructions, which execute via the processor of the computer or other programmable data processing terminal, create means for implementing the functions specified in the flowchart flow or flows and/or block diagram block or blocks.
These computer program instructions may also be stored in a computer-readable memory that can direct a computer or other programmable data processing terminal to function in a particular manner, such that the instructions stored in the computer-readable memory produce an article of manufacture including instruction means which implement the function specified in the flowchart flow or flows and/or block diagram block or blocks.
These computer program instructions may also be loaded onto a computer or other programmable data processing terminal to cause a series of operational steps to be performed on the computer or other programmable terminal to produce a computer implemented process such that the instructions which execute on the computer or other programmable terminal provide steps for implementing the functions specified in the flowchart flow or flows and/or block diagram block or blocks.
While preferred embodiments of the present invention have been described, additional variations and modifications of these embodiments may occur to those skilled in the art once they learn of the basic inventive concepts. Therefore, it is intended that the appended claims be interpreted as including preferred embodiments and all such alterations and modifications as fall within the scope of the embodiments of the invention.
Finally, it should also be noted that, herein, relational terms such as first and second, and the like may be used solely to distinguish one entity or action from another entity or action without necessarily requiring or implying any actual such relationship or order between such entities or actions. Also, the terms "comprises," "comprising," or any other variation thereof, are intended to cover a non-exclusive inclusion, such that a process, method, article, or terminal that comprises a list of elements does not include only those elements but may include other elements not expressly listed or inherent to such process, method, article, or terminal. Without further limitation, an element defined by the phrase "comprising an … …" does not exclude the presence of other like elements in a process, method, article, or terminal that comprises the element.
The report system configuration method and device provided by the invention are introduced in detail, and a specific example is applied in the text to explain the principle and the implementation mode of the invention, and the description of the embodiment is only used for helping to understand the method and the core idea of the invention; meanwhile, for a person skilled in the art, according to the idea of the present invention, there may be variations in the specific embodiments and the application scope, and in summary, the content of the present specification should not be construed as a limitation to the present invention.
Claims (14)
1. A reporting system configuration method, the method comprising:
the report system receives retrieval source configuration information sent by a user;
configuring a retrieval source based on the received retrieval source configuration information;
receiving presentation mode configuration information which is sent by the user and aims at the data in the retrieval source;
configuring a data display mode based on the display mode configuration information;
determining a filter and a query condition style corresponding to the retrieval source;
and generating a report system query interface according to the presentation mode configuration information, the filter and the query condition style.
2. The method of claim 1, wherein retrieving source configuration information comprises: retrieving source connection information;
the retrieving source connection information includes: database connection information and/or data table connection information;
the configuring the search source based on the received search source configuration information comprises:
determining a database and/or a data table connected with a reporting system based on the retrieval source connection information;
and establishing connection with the database and/or the data table.
3. The method of claim 2, wherein configuring a search source based on the received search source configuration information further comprises:
extracting fields in a data table and/or fields in the data table in the database, and determining the extracted fields as first dimension information;
sending the determined first dimension information to a user;
receiving second dimension information selected by a user from the determined first dimension information;
and determining the second dimension information as dimension information concerned by the user.
4. The method of claim 2, wherein retrieving source configuration information further comprises: data extraction cycle configuration information;
the configuring a search source based on the received search source configuration information further comprises:
extracting a data extraction period in the data extraction period configuration information;
determining the extracted data extraction period as a data extraction period for extracting data from a data source;
and extracting data from the data source according to the data extraction period.
5. The method of claim 1, wherein the configuring the data presentation based on the presentation configuration information comprises:
extracting the presentation mode contained in the presentation mode configuration information;
and determining the extracted presentation mode as the presentation mode when the data in the retrieval source is presented.
6. The method of claim 2, wherein determining the filter corresponding to the search source comprises:
extracting fields of the data table in the database connected with the reporting system and/or fields of the data table connected with the reporting system;
respectively determining the attribute value of each field;
respectively sending each field and the attribute value corresponding to each field to a user for selection;
receiving fields selected by a user and attribute values corresponding to the fields;
determining the fields selected by the user as fields concerned by the user, and determining the attribute value corresponding to each field as the attribute value concerned by the user;
and setting fields concerned by the user as the filtering conditions of the filter, and setting the attribute values of the fields as the values of the filtering conditions corresponding to the fields, thereby generating the filter.
7. The method of claim 1, wherein determining the query condition pattern corresponding to the search source comprises:
the report system presets a plurality of query condition styles corresponding to the retrieval sources for selection by a user;
receiving a query condition style selected by a user;
and determining the query condition style selected by the user as the query condition style of the user.
8. A reporting system configuration apparatus, the apparatus comprising: the system comprises an information receiving module, a retrieval source configuration module, data display mode configuration information, a determining module and an interface generating module; wherein,
the information receiving module is used for receiving retrieval source configuration information sent by a user and presentation mode configuration information aiming at data in the retrieval source sent by the user;
the retrieval source configuration module is used for configuring a retrieval source based on the received retrieval source configuration information;
the data presentation mode configuration module is used for configuring a data presentation mode based on the presentation mode configuration information;
the determining module is used for determining a filter and a query condition pattern corresponding to the retrieval source;
and the interface generating module is used for generating a query interface of the report system according to the display mode configuration information, the filter and the query condition style.
9. The apparatus of claim 8, wherein retrieving source configuration information comprises: retrieving source connection information; the retrieving source connection information includes: database connection information and/or data table connection information;
the retrieval source configuration module comprises: a first determination submodule and a connection submodule; wherein,
the first determining submodule is used for determining a database and/or a data table connected with a reporting system based on the retrieval source connection information;
and the connection sub-module is used for connecting the reporting system with the database and/or the data table.
10. The apparatus of claim 9, wherein the retrieval source configuration module further comprises: the system comprises a first extraction submodule, a first information sending submodule and a first information receiving submodule; wherein,
the first extraction submodule is used for extracting fields in a data table in the database and/or fields in the data table;
the first determining submodule is used for determining the extracted field as first dimension information;
the first information sending submodule is used for sending the determined first dimension information to a user;
the first information receiving submodule is used for receiving second dimension information selected by a user from the determined first dimension information;
the first determining submodule is used for determining the second dimension information as the dimension information concerned by the user.
11. The apparatus of claim 9, wherein retrieving source configuration information further comprises: data extraction cycle configuration information;
the first extraction submodule is further configured to extract a data extraction period in the data extraction period configuration information;
the first determining submodule is further used for determining the extracted data extraction period as a data extraction period for the reporting system to extract data from a data source;
the retrieval source configuration module further comprises: and the data extraction submodule is used for extracting data from the data source according to the data extraction period.
12. The apparatus of claim 8, wherein the data presentation configuration module comprises: a second extraction submodule and a second determination submodule; wherein,
the second extraction submodule is used for extracting the presentation modes contained in the presentation mode configuration information;
and the second determining submodule is used for determining the extracted presentation mode as the presentation mode when the data in the retrieval source is presented.
13. The apparatus of claim 9, wherein the determining module comprises: a third extraction submodule, a third determination submodule, a second information sending submodule, a second information receiving submodule and a filter generation submodule; wherein,
the third extraction submodule is used for extracting fields of the data table in the database connected with the reporting system and/or fields of the data table connected with the reporting system;
the third determining submodule is used for respectively determining the attribute values of all the fields;
the second information sending submodule is used for respectively sending the fields and the attribute values corresponding to the fields to a user for selection;
the second information receiving submodule is used for receiving fields selected by a user and attribute values corresponding to the fields;
the third determining submodule is further configured to determine the fields selected by the user as fields concerned by the user, and determine an attribute value corresponding to each field as an attribute value concerned by the user;
the filter generation submodule is used for generating a filter according to the following modes:
setting fields concerned by a user as filter conditions of a filter, and setting attribute values of the fields as values of the filter conditions corresponding to the fields.
14. The apparatus of claim 8, wherein the determining module further comprises: the setting submodule is used for presetting a plurality of query condition styles corresponding to the retrieval sources for a user to select;
the second information receiving submodule is also used for receiving a query condition style selected by a user;
and the third determining submodule is also used for determining the query condition style selected by the user as the query condition style of the report system.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201510825179.9A CN106776644B (en) | 2015-11-24 | 2015-11-24 | A kind of reporting system configuration method and device |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201510825179.9A CN106776644B (en) | 2015-11-24 | 2015-11-24 | A kind of reporting system configuration method and device |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN106776644A true CN106776644A (en) | 2017-05-31 |
| CN106776644B CN106776644B (en) | 2019-11-29 |
Family
ID=58963543
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201510825179.9A Expired - Fee Related CN106776644B (en) | 2015-11-24 | 2015-11-24 | A kind of reporting system configuration method and device |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN106776644B (en) |
Cited By (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN108804629A (en) * | 2018-05-31 | 2018-11-13 | 北京五八信息技术有限公司 | A kind of processing method, device, storage medium and the equipment of screening item |
| CN109358943A (en) * | 2018-11-09 | 2019-02-19 | 金色熊猫有限公司 | Page configuration method and device, electronic equipment, storage medium |
| CN109614098A (en) * | 2017-09-30 | 2019-04-12 | 北京国双科技有限公司 | The generation method and device of configuration interface |
| CN109684387A (en) * | 2018-12-24 | 2019-04-26 | 成都四方伟业软件股份有限公司 | Report generation method and device |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US7356779B2 (en) * | 2000-04-03 | 2008-04-08 | Business Objects Software Ltd. | Analytical reporting on top of multidimensional data model |
| CN102541529A (en) * | 2010-12-30 | 2012-07-04 | 北京亿阳信通软件研究院有限公司 | Query page generating device and method |
| CN104615602A (en) * | 2013-11-05 | 2015-05-13 | 深圳中兴力维技术有限公司 | Automatic generation device and method thereof for query interface |
-
2015
- 2015-11-24 CN CN201510825179.9A patent/CN106776644B/en not_active Expired - Fee Related
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US7356779B2 (en) * | 2000-04-03 | 2008-04-08 | Business Objects Software Ltd. | Analytical reporting on top of multidimensional data model |
| CN102541529A (en) * | 2010-12-30 | 2012-07-04 | 北京亿阳信通软件研究院有限公司 | Query page generating device and method |
| CN104615602A (en) * | 2013-11-05 | 2015-05-13 | 深圳中兴力维技术有限公司 | Automatic generation device and method thereof for query interface |
Cited By (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109614098A (en) * | 2017-09-30 | 2019-04-12 | 北京国双科技有限公司 | The generation method and device of configuration interface |
| CN108804629A (en) * | 2018-05-31 | 2018-11-13 | 北京五八信息技术有限公司 | A kind of processing method, device, storage medium and the equipment of screening item |
| CN109358943A (en) * | 2018-11-09 | 2019-02-19 | 金色熊猫有限公司 | Page configuration method and device, electronic equipment, storage medium |
| CN109358943B (en) * | 2018-11-09 | 2022-03-22 | 金色熊猫有限公司 | Page configuration method and device, electronic equipment and storage medium |
| CN109684387A (en) * | 2018-12-24 | 2019-04-26 | 成都四方伟业软件股份有限公司 | Report generation method and device |
| CN109684387B (en) * | 2018-12-24 | 2021-03-09 | 成都四方伟业软件股份有限公司 | Report generation method and device |
Also Published As
| Publication number | Publication date |
|---|---|
| CN106776644B (en) | 2019-11-29 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN107861859B (en) | Log management method and system based on micro-service architecture | |
| CN109408347A (en) | A kind of index real-time analyzer and index real-time computing technique | |
| CN106776644B (en) | A kind of reporting system configuration method and device | |
| CN103020158A (en) | Report form creation method, device and system | |
| CN111339171B (en) | Data query method, device and equipment | |
| CN106570022B (en) | Cross-data-source query method, device and system | |
| CN105550241A (en) | Multidimensional database query method and apparatus | |
| CN104361140A (en) | Dynamically generated data model configuration device and method | |
| JP2010524060A (en) | Data merging in distributed computing | |
| CN110543571A (en) | knowledge graph construction method and device for water conservancy informatization | |
| CN106991100B (en) | Data import method and device | |
| CN111475564A (en) | Streaming data processing method, system, computer equipment and storage medium | |
| CN104268241A (en) | Attribute display method in configuration database | |
| CN109408711B (en) | Data filtering method and device, electronic equipment and storage medium | |
| CN106156047A (en) | A kind of SNAPSHOT INFO processing method and processing device | |
| CN111723087A (en) | Mining method and device of data blood relationship, storage medium and electronic equipment | |
| CN111047434B (en) | Operation record generation method and device, computer equipment and storage medium | |
| CN114820080A (en) | User grouping method, system, device and medium based on crowd circulation | |
| CN111382155A (en) | Data processing method of data warehouse, electronic equipment and medium | |
| CN109033157B (en) | Complex data retrieval method and system based on user-defined search condition tree | |
| CN112825068B (en) | Data blood margin generation method and device | |
| CN109697234B (en) | Multi-attribute information query method, device, server and medium for entity | |
| CN107644103B (en) | Method and system for storing traceable information source information | |
| CN114880385B (en) | Method and device for accessing geological disaster data through automatic combination process | |
| JP2016521889A (en) | Cross model filtering |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant | ||
| CF01 | Termination of patent right due to non-payment of annual fee | ||
| CF01 | Termination of patent right due to non-payment of annual fee |
Granted publication date: 20191129 |