CN106776644B - A kind of reporting system configuration method and device - Google Patents
A kind of reporting system configuration method and device Download PDFInfo
- Publication number
- CN106776644B CN106776644B CN201510825179.9A CN201510825179A CN106776644B CN 106776644 B CN106776644 B CN 106776644B CN 201510825179 A CN201510825179 A CN 201510825179A CN 106776644 B CN106776644 B CN 106776644B
- Authority
- CN
- China
- Prior art keywords
- data
- user
- information
- retrieval source
- field
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Active
Links
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
The embodiment of the invention provides a kind of reporting system configuration method and device, method therein includes: that reporting system receives the retrieval source configuration information that user sends;Retrieval source is configured based on received retrieval source configuration information;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;Determine screening washer corresponding with the retrieval source and querying condition pattern;Reporting system query interface is generated according to the ways of presentation configuration information, screening washer and querying condition pattern.Reporting system configuration method provided in an embodiment of the present invention is flexible and easy to operate, can satisfy the needs of any field user based on the reporting system that the method generates and has very strong continuity.
Description
Technical field
The present invention relates to technical field of information processing, and in particular to a kind of reporting system configuration method and device.
Background technique
Currently, common reporting system has two classes: self-defined report tools production, such as Fine Report and fixed industry
The report tool product in business direction, e.g., the financial tool of the companies such as UF and Kingdee.
Wherein, self-defined report work product be client production, usually by technological development such as JAVA, C or delphi and
At deployment is convenient, is mounted directly;Since there is no the fixed scopes of business and direction for such product, so providing big
Complicated function is measured to be applicable in various businesses scene.Such product needs user to have following ability in use:
(a) SQL script edit ability
For extracting the operation of work, the selection comprising table and field and the storage of complexity to the product report data
Journey is write;
(b) data analysis capabilities
Most effective statistical information and more efficient inquiry means are provided for analyzing business datum;
(c) related service ability
The understanding for needing user to have comparison deep business, to simply, effectively configure oneself desired statistics letter
Breath and report;Occur new query demand user simultaneously and also needs to repeat query configuration operation.
The report tool in fixed service direction is usually enterprises orientation development or is type products of the same trade,
It is usually formed by language such as C or JAVA with the mechanical development of B/S or C/S, the server that such product needs better performances comes
It supports;Before this kind of product is developed, needs requirement engineering teacher and user targetedly to carry out linking up contact early period, excavate
User demand is to reach all expections of user, and therefore, the production cycle of such product is very very long and versatility is low, Yong Hu
Early period using when can reach good effect, but in the case where the query demand in later period changes or is newly-increased, engineer is to needing
The modification asked, workload are substantially similar with a product is developed again.
As it can be seen that the shortcomings that self-defined report tools production, is the scope of business and direction that do not fix, so providing
A large amount of function is to make user that a large amount of time be needed to go to study in depth, however this in order to guarantee that the versatility of product makes again
The average no surprise that the performance of product is shown in the specific transactions field of certain user;Moreover, its configuration method is complicated, user is needed
Has the script edit ability of certain databases (such as: ORACLE, SQLSERVER, MYSQL) (comprising complicated storing process foot
Originally write), and need service logic and database model to operation system very familiar.
The shortcomings that fixed service direction report tool product, is that system development cycle is too long, needs development teams investment big
The time of amount and manpower, although system can come into operation as soon as possible and can reach user's desired final effect early period,
But user demand is constantly to change, the demand of change also needs a large amount of time and links up with personnel and opened again
Hair;Therefore, such product continuity is not strong, and the change of user demand can bring major disaster to system with newly-increased.
Summary of the invention
In order to solve in the prior art 1. self-defined report tool degraded performance and configuration complexity in specific transactions field
The high 2. not strong problem of fixed service direction report product development continuity is required to user, an embodiment of the present invention is intended to provide one
Kind reporting system configuration method and device.
The embodiment of the invention provides a kind of reporting system configuration methods, comprising:
Reporting system receives the retrieval source configuration information that user sends;
Retrieval source is configured based on received retrieval source configuration information;
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;
Determine screening washer corresponding with the retrieval source and querying condition pattern;
Reporting system query interface is generated according to the ways of presentation configuration information, screening washer and querying condition pattern.
Preferably, retrieval source configuration information includes: retrieval source link information;
Retrieval source link information includes: database linkage information and/or tables of data link information;
It is described that retrieval source is configured based on the retrieval source configuration information received, comprising:
The database connecting with reporting system and/or tables of data are determined based on retrieval source link information;
Connection is established with the database and/or tables of data.
It is preferably, described that retrieval source is configured based on the retrieval source configuration information received further include:
The field in the field and/or the tables of data in the database in tables of data is extracted, the field of extraction is true
It is set to the first dimensional information;
The first dimensional information of the determination is sent to user;
Receive the second dimensional information that user selects from the first dimensional information of the determination;
Second dimensional information is determined as to the dimensional information of user's care.
Preferably, retrieval source configuration information further include: data pick-up period assignment information;
It is described that retrieval source is configured based on the retrieval source configuration information received, further includes:
Extract the data pick-up period in the data pick-up period assignment information;
The data pick-up period extracted is determined as itself data pick-up period from data source extraction data;
Data are extracted from data source according to the data pick-up period.
It is preferably, described to be based on the ways of presentation configuration information configuration data ways of presentation, comprising:
Extract the ways of presentation for including in the ways of presentation configuration information;
By the ways of presentation extracted be determined as to data show in the retrieval source when ways of presentation.
Preferably, determination screening washer corresponding with the retrieval source, comprising:
It extracts the field of tables of data in the database connecting with reporting system and/or described is connect with reporting system
The field of tables of data;
The attribute value of each field is determined respectively;
Attribute value corresponding to each field and each field user is sent to respectively to select for user;
Receive the field and the corresponding attribute value of each field of user's selection;
The field that the user selects is determined as to the field of user's care, the corresponding attribute value of each field is determined as
The attribute value that user is concerned about;
It sets the field that user is concerned about to the filter condition of screening washer, sets the word for the attribute value of each field
The value of the corresponding filter condition of section, to generate screening washer.
Preferably, determination querying condition pattern corresponding with the retrieval source, comprising:
Reporting system presets multiple querying condition patterns corresponding with the retrieval source and selects for user;
Receive the querying condition pattern of user's selection;
The querying condition pattern that the user selects is determined as to the querying condition pattern of itself.
The embodiment of the invention provides a kind of reporting system configuration devices, comprising: information receiving module, retrieval source configure mould
Block, data exhibiting mode configuration information, determining module and interface generation module;Wherein,
The information receiving module, what retrieval source configuration information and the user for receiving user's transmission were sent is directed to
The ways of presentation configuration information of data in the retrieval source;
Retrieval source configuration module, for configuring retrieval source based on received retrieval source configuration information;
The data exhibiting mode configuration module, for being based on the ways of presentation configuration information configuration data side of showing
Formula;
The determining module, for determining screening washer corresponding with the retrieval source and querying condition pattern;
The interface generation module, for raw according to the ways of presentation configuration information, screening washer and querying condition pattern
At the query interface of reporting system.
Preferably, retrieval source configuration information includes: retrieval source link information;Retrieval source link information includes:
Database linkage information and/or tables of data link information;
Retrieval source configuration module, comprising: first determines submodule and connection submodule;Wherein,
Described first determines submodule, for determining the database of reporting system connection based on retrieval source link information
And/or tables of data;
The connection submodule, for the reporting system to be connected with the database and/or tables of data.
Preferably, retrieval source configuration module further include: the first extracting sub-module, first information sending submodule,
One information receiving submodule;Wherein,
First extracting sub-module, for extracting field and/or the tables of data in the database in tables of data
In field;
Described first determines submodule, for the field of extraction to be determined as the first dimensional information;
The first information sending submodule, for sending the first dimensional information of the determination to user;
The first information receiving submodule, selected from the first dimensional information of the determination for receiving user
Two-dimensions information;
Described first determines submodule, for second dimensional information to be determined as to the dimensional information of user's care.
Preferably, retrieval source configuration information further include: data pick-up period assignment information;
First extracting sub-module is also used to extract the data pick-up week in the data pick-up period assignment information
Phase;
Described first determines submodule, is also used to the data pick-up period extracted being determined as the reporting system
The data pick-up period of data is extracted from data source;
Retrieval source configuration module, further includes: data pick-up submodule, for according to the data pick-up period from number
Data are extracted according to source.
Preferably, the data exhibiting mode configuration module, comprising: the second extracting sub-module and second determines submodule;
Wherein,
Second extracting sub-module, for extracting the ways of presentation for including in the ways of presentation configuration information;
It is described second determine submodule, for by the ways of presentation extracted be determined as to data in the retrieval source into
Ways of presentation when row shows.
Preferably, the determining module, comprising: third extracting sub-module, third determine that submodule, the second information send son
Module, the second information receiving submodule and screening washer generate submodule;Wherein,
The third extracting sub-module, for extracting the field of tables of data in the database connecting with reporting system
And/or the field in the tables of data being connect with reporting system;
The third determines submodule, for determining the attribute value of each field respectively;
The second information sending submodule, for attribute value corresponding to field and each field to be sent to use respectively
Family is selected for user;
The second information receiving submodule, for receiving the field and the corresponding attribute value of each field of user's selection;
The third determines submodule, is also used to for the field that the user selects being determined as the field of user's care, will
The corresponding attribute value of each field is determined as the attribute value of user's care;
The screening washer generates submodule, for generating screening washer according to following manner:
It sets the field that user is concerned about to the filter condition of screening washer, sets the word for the attribute value of each field
The value of the corresponding filter condition of section.
Preferably, the determining module, further includes: setting submodule, it is multiple with retrieval source phase for presetting
Corresponding querying condition pattern is selected for user;
The second information receiving submodule is also used to receive the querying condition pattern of user's selection;
The third determines submodule, is also used to the querying condition pattern that the user selects being determined as reporting system
Querying condition pattern.
Compared with prior art, the embodiment of the present invention includes following advantages:
A kind of reporting system configuration method and device provided by the embodiment of the present invention can receive the retrieval of user's transmission
The ways of presentation configuration information for data in the retrieval source that source configuration information and the user send;And it is based on being received
The retrieval source configuration information arrived configures retrieval source, based on the ways of presentation configuration information configuration data ways of presentation;The report
Table system can also determine screening washer corresponding with the retrieval source and querying condition pattern;Finally according to the ways of presentation
Configuration information, screening washer and querying condition pattern generate reporting system query interface.It was generated in the reporting system query interface
Cheng Zhong, the function interface that user only needs to provide by reporting system send retrieval source configuration information to reporting system and are directed to institute
The ways of presentation configuration information of data in retrieval source is stated, the configuration mode is not only flexible and easy to operate;In addition, the report system
System can also directly determine screening washer corresponding with the retrieval source and querying condition pattern, simplify and configured for user
Journey;Additionally, due to which user takes part in the overall process of reporting system query interface generation, therefore, which is
It needs to customize according to user completely, complies fully with the use habit of user, can satisfy the needs of any field user;And
And the function interface provided based on reporting system, when user demand changes, it may be convenient to be carried out by function interface
Corresponding configuration greatly enhances the continuity of reporting system to regenerate system queries interface.
Detailed description of the invention
Fig. 1 is reporting system configuration method flow chart one provided in an embodiment of the present invention;
Fig. 2 is reporting system configuration method flowchart 2 provided in an embodiment of the present invention;
Fig. 3 is the basic block diagram of reporting system configuration device provided in an embodiment of the present invention.
Specific embodiment
Embodiment one
Referring to Fig.1, a kind of step flow chart of reporting system configuration method embodiment one of the invention, this method are shown
Applied to reporting system, can specifically include:
Step 101 receives the retrieval source configuration information that user sends;
Specifically, the step in, by reporting system with receive user send retrieval source configuration information, the retrieval source
Configuration information is for configuring retrieval source;Retrieval source is usually database or multiple tables of data;The multiple tables of data
It can be by way of table, middle table, view or structured query language (SQL) sentence segment or function or storing process
Storage;The database includes one or more tables of data.Reporting system obtains data by retrieval source.The step in, use
Family can according to their needs and own right configure the retrieval source that reporting system multipotency retrieves, in configuration process,
Retrieval source configuration information is sent to reporting system.
Step 102 configures retrieval source based on received retrieval source configuration information;
In step 101, after reporting system receives the retrieval source configuration information of user's transmission, it is based on institute in a step 102
The retrieval source configuration information configuration retrieval source received, that is to say, that by step 101 and step 102, mentioned based on reporting system
The function interface of confession, user can configure retrieval source according to own actual situation.
Step 103 receives the ways of presentation configuration information for data in the retrieval source that the user sends;
Reporting system obtains data by retrieval source, report is generated, it is thus necessary to determine that the ways of presentation of data.Therefore,
The step in, receive the ways of presentation configuration information for data in the retrieval source that the user sends.
Step 104 is based on the ways of presentation configuration information configuration data ways of presentation;
Reporting system configures number according to the ways of presentation configuration information for data in the retrieval source that user sends
According to ways of presentation, that is to say, that by step 103 and step 104, based on the function interface that reporting system provides, user can
Data ways of presentation configured according to their needs.
Step 105 determines screening washer corresponding with the retrieval source and querying condition pattern;
After retrieval source determines, on the one hand reporting system can be determined and the retrieval by the analysis to retrieval source
On the other hand the corresponding screening washer in source also can determine querying condition pattern corresponding with the retrieval source.
Step 106 generates reporting system inquiry according to the ways of presentation configuration information, screening washer and querying condition pattern
Interface.
Specifically, system is according to above-mentioned letter after ways of presentation configuration information, screening washer and querying condition pattern determine
Breath produces reporting system query interface, which is that the analysis based on user configuration and reporting system generates.
During the reporting system query interface generates, user participates in the overall process, therefore, the reporting system query interface
It needs to customize according to user completely, complies fully with the use habit of user.
To sum up, the according to embodiments of the present invention one reporting system configuration method provided can receive the retrieval of user's transmission
The ways of presentation configuration information for data in the retrieval source that source configuration information and the user send;And it is based on being received
The retrieval source configuration information arrived configures retrieval source, based on the ways of presentation configuration information configuration data ways of presentation;The report
Table system can also determine screening washer corresponding with the retrieval source and querying condition pattern;Finally according to the ways of presentation
Configuration information, screening washer and querying condition pattern generate reporting system query interface.It was generated in the reporting system query interface
Cheng Zhong, the function interface that user only needs to provide by reporting system send retrieval source configuration information to reporting system and are directed to institute
The ways of presentation configuration information of data in retrieval source is stated, the configuration mode is not only flexible and easy to operate;In addition, the report system
System can also directly determine screening washer corresponding with the retrieval source and querying condition pattern, simplify and configured for user
Journey;Additionally, due to which user takes part in the overall process of reporting system query interface generation, therefore, which is
It needs to customize according to user completely, complies fully with the use habit of user, can satisfy the needs of any field user;And
And the function interface provided based on reporting system, when user demand changes, it may be convenient to be carried out by function interface
Corresponding configuration greatly enhances the continuity of reporting system to regenerate system queries interface.
Embodiment two
Referring to Fig. 2, a kind of step flow chart of reporting system configuration method embodiment of the invention is shown, it specifically can be with
Include:
Step 201 receives the retrieval source configuration information that user sends, and retrieval source configuration information includes: that retrieval source connects
Information is connect, retrieval source link information includes: database linkage information and/or tables of data link information;
Specifically, the step in, by reporting system with receive user send retrieval source configuration information, the retrieval source
Configuration information is for configuring retrieval source;Retrieval source is usually database or multiple tables of data, in practical applications,
It due to access privilege difference, or considers problem of data safety, possibly can not directly open to reporting system to database
Access authority, at this moment, so that it may will allow reporting system access tables of data as retrieval source, if the user determine that can be right
The access authority of some open database of reporting system, then can also be by database directly as retrieval source;It can certainly
It regard database and one or more tables of data as retrieval source simultaneously;The multiple tables of data can pass through table, middle table, view
Figure or SQL statement segment or the storage of the form of function or storing process;The database includes one or more tables of data.
Reporting system obtains data by retrieval source.The step in, user can according to their needs and own right, to report system
The retrieval source that system multipotency retrieves is configured, and in configuration process, sends retrieval source configuration information to reporting system.
Step 202 configures retrieval source based on received retrieval source configuration information;
In step 201, after reporting system receives the retrieval source configuration information of user's transmission, it is based on institute in step 202
The retrieval source configuration information configuration retrieval source received, that is to say, that by step 201 and step 202, mentioned based on reporting system
The function interface of confession, user can configure retrieval source according to own actual situation.
Specifically, described configure retrieval source based on the retrieval source configuration information received, comprising:
The database connecting with reporting system and/or tables of data are determined based on retrieval source link information;
Connection is established with the database and/or tables of data.
It is described based on the retrieval source configuration information configuration inspection received in another alternative embodiment of the invention
Suo Yuan further include:
The field in the field and/or the tables of data in the database in tables of data is extracted, the field of extraction is true
It is set to the first dimensional information;
The first dimensional information of the determination is sent to user;
Receive the second dimensional information that user selects from the first dimensional information of the determination;
Second dimensional information is determined as to the dimensional information of user's care.
In above scheme, the first data dimension information or the second dimensional information include dimension name, dimension type, dimension
Degree explanation and code and title corresponding relationship in partial dimensional type;The dimension type includes but is not limited to: time and ground
Area's type.
In another alternative embodiment of the invention, retrieval source configuration information further include: the data pick-up period matches
Confidence breath;
It is described that retrieval source is configured based on the retrieval source configuration information received, further includes:
Extract the data pick-up period in the data pick-up period assignment information;
The data pick-up period extracted is determined as itself data pick-up period from data source extraction data;
Data are extracted from data source according to the data pick-up period.
Step 203 receives the ways of presentation configuration information for data in the retrieval source that the user sends;
Reporting system obtains data by retrieval source, report is generated, it is thus necessary to determine that the ways of presentation of data.Therefore,
The step in, receive the ways of presentation configuration information for data in the retrieval source that the user sends.
Step 204 is based on the ways of presentation configuration information configuration data ways of presentation;
Reporting system configures number according to the ways of presentation configuration information for data in the retrieval source that user sends
According to ways of presentation, that is to say, that by step 203 and step 204, based on the function interface that reporting system provides, user can
Data ways of presentation configured according to their needs.
It is described to be based on the ways of presentation configuration information configuration data ways of presentation, comprising:
Extract the ways of presentation for including in the ways of presentation configuration information;
By the ways of presentation extracted be determined as to data show in the retrieval source when ways of presentation.
Specifically, the ways of presentation for including in the ways of presentation configuration information includes basic ways of presentation, such as list, figure
Shape or the interaction of list figure;The ways of presentation can further include: peculiar ways of presentation;The peculiar ways of presentation packet
Include: row is total, column are total, peculiar column count (comprising adding, subtracting multiplication and division operation), shows on year-on-year basis with ring ratio, column percentage, data
Highlighted prompt etc..
Step 205 determines querying condition pattern corresponding with the retrieval source;
After retrieval source determines, reporting system can determine querying condition pattern corresponding with the retrieval source.
Specifically, determination querying condition pattern corresponding with the retrieval source, comprising:
Reporting system presets multiple querying condition patterns corresponding with the retrieval source and selects for user;
Receive the querying condition pattern of user's selection;
The querying condition pattern that the user selects is determined as to the querying condition pattern of itself.
In practical realization, reporting system is capable of providing querying condition pattern abundant, and e.g., traditional pattern is (such as tree, drop-down
Frame, input frame etc.), menu pattern (e.g., the menu filtered model of electric business formula) and advanced inquiry pattern be comprising advanced (that is, search
The inquiry pattern of the functions such as single choice and multiselect, list fuzzy matching in rope, dynamic filtration) etc..
Therefore, the pre-set querying condition pattern corresponding with the retrieval source of the reporting system includes but unlimited
In: traditional pattern, menu pattern, advanced inquiry pattern.
Step 206 extracts the field of tables of data and/or described and report system in the database connecting with reporting system
The field for the tables of data connected of uniting;
Tables of data is usually made of multirow data, and every data line all includes one or more fields;
Table 1 is certain corporations, school member's Basic Information Table:
Name | Age | Department | Profession | Native place | Affiliated function |
Zhang Yi | 19 | Telecommunications institute | Communication engineering | Shaanxi | Public Relations Department |
Zhao two | 20 | College of art | Industrial design | Hunan | Publicity department |
Grandson three | 18 | Build work system | Construction Economics and Management | Shaanxi | Movable part |
Table 1
It as shown in table 1, include three row data, every a line includes five fields, name, age, department, profession, native place
And affiliated function.
Therefore, the field that can be extracted from table 1 are as follows: name, age, department, profession, native place and affiliated function.
It is similar, in step 206, the field of field and/or the tables of data to tables of data in the database into
Row extracts, that is, extracts all fields included in all tables of data.
Step 207, the attribute value for determining each field respectively;
Still be exemplified by Table 1, to the step for be introduced, as shown in table 1, in addition to native place field, each field
There are three attribute values, for example, there are three attribute values for age field: 19,20,18;And native place field is there are two attribute value: Shaanxi and
Hunan.
Step 208, respectively by attribute value corresponding to each field and each field be sent to user for user select;
Step 209, the field and the corresponding attribute value of each field for receiving user's selection;
Step 210, the field that the field that the user selects is determined as to user's care, by the corresponding attribute of each field
Value is determined as the attribute value of user's care;
Step 211, the filter condition for setting the field that user is concerned about to screening washer, the attribute value of each field is arranged
For the value of the corresponding filter condition of the field, to generate screening washer;
The step for, including above-mentioned steps 206 to step 210 is provided to determine and generates screening washer;Screening washer can be with
It is determined by the value of filter condition and filter condition;
For example, when user selects filter condition as native place, that is, selection screens data according to native place,
When determined screened by native place after, further by selection filter condition value, then can determine by some specific mistake
Filter condition is screened, for example, will filter out the data that all native places are Shaanxi at this time when user selects native place value as Shaanxi
Record.
Since data are numerous in retrieval source, if as in the prior art by demand analysis early period determine user demand thus
Determine screening washer, since user is likely to itself all dimension of concern and the value of each dimension impossible to exhaust,
After developer generates screening washer according to demand, it is difficult to meet the actual needs of user;On the other hand, if by tables of data
All dimensions are determined as filter condition, set all properties value of each dimension to the value of filter condition, for users,
Difficulty can will be undoubtedly caused when using screening washer, user using screening washer when inquiring, from the filtering rod of substantial amounts
It is selected in the value of part or filter condition, inherently a time-consuming and laborious thing, is unfavorable for user and uses report
The recall precision of system;As it can be seen that the attribute value of itself dimension of interest, dimension is selected by user through the above steps,
Screening washer can be generated with a kind of scientific and reasonable scheme, implementation is simple and can satisfy the actual needs of user.
Step 212 generates reporting system inquiry according to the ways of presentation configuration information, screening washer and querying condition pattern
Interface.
Specifically, system is according to above-mentioned letter after ways of presentation configuration information, screening washer and querying condition pattern determine
Breath produces reporting system query interface, which is that the analysis based on user configuration and reporting system generates.
During the reporting system query interface generates, user participates in the overall process, therefore, the reporting system query interface
It needs to customize according to user completely, complies fully with the use habit of user.
Specifically, reporting system parsing data exhibiting mode configuration information, querying condition pattern and screening washer match confidence
Breath, and query interface is generated according to the configuration information of above-mentioned data exhibiting mode configuration information, querying condition pattern and screening washer
Correlative code, which can be realized in a manner of JAVA or JSP or JS and related SQL scripted code etc., reporting system meeting
Information in a manner of file or database after storing and resolving, meanwhile, reporting system can save query interface parsing code access
Address, when using report query function, need to only access this address can carry out the integrated of report query interface.
As it can be seen that using reporting system configuration method provided by Embodiment 2 of the present invention, it can not only be with one kind simply, efficiently
Mode needs the query interface of report customization system according to user, moreover, screening washer generated in a kind of entirely different mode,
The specific method is as follows:
The field of the field of tables of data and/or the tables of data in the database is extracted, determines each field respectively
Attribute value corresponding to each field and each field is sent to user respectively and selected for user by attribute value, receives user's choosing
The field that the user selects is determined as the field of user's care by the field and the corresponding attribute value of each field selected, will be every
The corresponding attribute value of a field is determined as the attribute value of user's care, sets the field that user is concerned about to the filtering rod of screening washer
Part, sets the attribute value of each field to the value of the corresponding filter condition of the field, to generate screening washer;
On the one hand, compared to the prior art in user demand determined by demand analysis early period so that it is determined that when screening washer,
Since user is likely to itself all dimension of concern and the value of each dimension impossible to exhaust, when developer is according to need
After seeking survival into screening washer, usually there are problems that screening washer is difficult to meet the actual needs of user, user only needs in above scheme
Itself dimension of interest and attribute are chosen in all dimensions and attribute value option, can be avoided due to demand early period
Analysis is insufficient, caused by system difficulty the problem of using;Moreover, in scheme provided by Embodiment 2 of the present invention, when user demand is sent out
Raw also to be modified at any time to screening washer by special function also face when changing, this method is simple, operability
By force;
On the other hand, due in retrieval source data it is numerous, if dimensions all in tables of data are determined as filter condition, will
The all properties value of each dimension is set as the value of filter condition, for users, can will undoubtedly make when using screening washer
At difficulty, user using screening washer when being inquired, from carrying out in the value of the filter conditions of substantial amounts or filter condition
Selection, inherently a time-consuming and laborious thing are unfavorable for the recall precision that user uses reporting system;Therefore, pass through
The above method is selected the attribute value of itself dimension of interest, dimension by user, can be with a kind of scientific and reasonable scheme
Generate screening washer, implementation is simple and can satisfy the actual needs of user.
Installation practice one
Referring to Fig. 3, a kind of structural block diagram of reporting system configuration device embodiment of the present invention is shown, described device is located at
Reporting system, comprising: information receiving module 31, retrieval source configuration module 32, data exhibiting mode configuration information 33, determining module
34 and interface generation module 35;Wherein,
The information receiving module 31, the needle that retrieval source configuration information and the user for receiving user's transmission are sent
To the ways of presentation configuration information of data in the retrieval source;
Retrieval source configuration module 32, for configuring retrieval source based on received retrieval source configuration information;
The data exhibiting mode configuration module 33, for being based on the ways of presentation configuration information configuration data side of showing
Formula;
The determining module 34, for determining screening washer corresponding with the retrieval source and querying condition pattern;
The interface generation module 35, for according to the ways of presentation configuration information, screening washer and querying condition pattern
Generate the query interface of reporting system.
Specifically, retrieval source configuration information includes: retrieval source link information;Retrieval source link information includes:
Database linkage information and/or tables of data link information;
Specifically, retrieval source configuration module 32, comprising: first determines submodule and connection submodule;Wherein,
Described first determines submodule, for determining the database of reporting system connection based on retrieval source link information
And/or tables of data;
The connection submodule, for the reporting system to be connected with the database and/or tables of data.
In another alternative embodiment of the invention, retrieval source configuration module 32 further include: the first extracting sub-module,
First information sending submodule, first information receiving submodule;Wherein,
First extracting sub-module, for extracting the field in the database connecting with reporting system in tables of data
And/or the field in the tables of data being connect with reporting system;
Described first determines submodule, for the field of extraction to be determined as the first dimensional information;
The first information sending submodule, for sending the first dimensional information of the determination to user;
The first information receiving submodule, selected from the first dimensional information of the determination for receiving user
Two-dimensions information;
Described first determines submodule, for second dimensional information to be determined as to the dimensional information of user's care.
In another alternative embodiment of the invention, retrieval source configuration information further include: the data pick-up period matches
Confidence breath;
First extracting sub-module is also used to extract the data pick-up week in the data pick-up period assignment information
Phase;
Described first determines submodule, is also used to the data pick-up period extracted being determined as the reporting system
The data pick-up period of data is extracted from data source;
Retrieval source configuration module, further includes: data pick-up submodule, for according to the data pick-up period from number
Data are extracted according to source.
Specifically, the data exhibiting mode configuration module 33, comprising: the second extracting sub-module and second determines submodule
Block;Wherein,
Second extracting sub-module, for extracting the ways of presentation for including in the ways of presentation configuration information;
It is described second determine submodule, for by the ways of presentation extracted be determined as to data in the retrieval source into
Ways of presentation when row shows.
Specifically, the determining module 34, comprising: third extracting sub-module, third determine that submodule, the second information are sent
Submodule, the second information receiving submodule and screening washer generate submodule;Wherein,
The third extracting sub-module, for extracting in the database in the field of tables of data and/or the tables of data
Field;
The third determines submodule, for determining the attribute value of each field respectively;
The second information sending submodule, for attribute value corresponding to field and each field to be sent to use respectively
Family is selected for user;
The second information receiving submodule, for receiving the field and the corresponding attribute value of each field of user's selection;
The third determines submodule, is also used to for the field that the user selects being determined as the field of user's care, will
The corresponding attribute value of each field is determined as the attribute value of user's care;
The screening washer generates submodule, for generating screening washer according to following manner:
It sets the field that user is concerned about to the filter condition of screening washer, sets the word for the attribute value of each field
The value of the corresponding filter condition of section.
In another alternative embodiment of the invention, the determining module 34, further includes: setting submodule, for pre-
Multiple querying condition patterns corresponding with the retrieval source are first arranged to select for user;
The second information receiving submodule is also used to receive the querying condition pattern of user's selection;
The third determines submodule, is also used to the querying condition pattern that the user selects being determined as reporting system
Querying condition pattern.
In the specific implementation process, above- mentioned information receiving module 31, retrieval source configuration module 32, data exhibiting mode configure
Information 33, determining module 34, interface generation module 35, first determine submodule and connection submodule, the first extracting sub-module, the
One information sending submodule, first information receiving submodule, data pick-up submodule, the second extracting sub-module, second determine son
Module, third extracting sub-module, third determine submodule, the second information sending submodule, the second information receiving submodule, screening
Device generates submodule and setting submodule can be by central processing unit (CPU, the Central Processing in reporting system
Unit), microprocessor (MPU, Micro Processing Unit), digital signal processor (DSP, Digital Signal
) or programmable logic array (FPGA, Field-Programmable Gate Array) Lai Shixian Processor.
For device embodiment, since it is basically similar to the method embodiment, related so being described relatively simple
Place illustrates referring to the part of embodiment of the method.
All the embodiments in this specification are described in a progressive manner, the highlights of each of the examples are with
The difference of other embodiments, the same or similar parts between the embodiments can be referred to each other.
It should be understood by those skilled in the art that, the embodiment of the embodiment of the present invention can provide as method, apparatus or calculate
Machine program product.Therefore, the embodiment of the present invention can be used complete hardware embodiment, complete software embodiment or combine software and
The form of the embodiment of hardware aspect.Moreover, the embodiment of the present invention can be used one or more wherein include computer can
With in the computer-usable storage medium (including but not limited to magnetic disk storage, CD-ROM, optical memory etc.) of program code
The form of the computer program product of implementation.
The embodiment of the present invention be referring to according to the method for the embodiment of the present invention, terminal device (system) and computer program
The flowchart and/or the block diagram of product describes.It should be understood that flowchart and/or the block diagram can be realized by computer program instructions
In each flow and/or block and flowchart and/or the block diagram in process and/or box combination.It can provide these
Computer program instructions are set to general purpose computer, special purpose computer, Embedded Processor or other programmable data processing terminals
Standby processor is to generate a machine, so that being held by the processor of computer or other programmable data processing terminal devices
Capable instruction generates for realizing in one or more flows of the flowchart and/or one or more blocks of the block diagram
The device of specified function.
These computer program instructions, which may also be stored in, is able to guide computer or other programmable data processing terminal devices
In computer-readable memory operate in a specific manner, so that instruction stored in the computer readable memory generates packet
The manufacture of command device is included, which realizes in one side of one or more flows of the flowchart and/or block diagram
The function of being specified in frame or multiple boxes.
These computer program instructions can also be loaded into computer or other programmable data processing terminal devices, so that
Series of operation steps are executed on computer or other programmable terminal equipments to generate computer implemented processing, thus
The instruction executed on computer or other programmable terminal equipments is provided for realizing in one or more flows of the flowchart
And/or in one or more blocks of the block diagram specify function the step of.
Although the preferred embodiment of the embodiment of the present invention has been described, once a person skilled in the art knows bases
This creative concept, then additional changes and modifications can be made to these embodiments.So the following claims are intended to be interpreted as
Including preferred embodiment and fall into all change and modification of range of embodiment of the invention.
Finally, it is to be noted that, herein, relational terms such as first and second and the like be used merely to by
One entity or operation are distinguished with another entity or operation, without necessarily requiring or implying these entities or operation
Between there are any actual relationship or orders.Moreover, the terms "include", "comprise" or its any other variant meaning
Covering non-exclusive inclusion, so that process, method, article or terminal device including a series of elements not only wrap
Those elements are included, but also including other elements that are not explicitly listed, or further includes for this process, method, article
Or the element that terminal device is intrinsic.In the absence of more restrictions, being wanted by what sentence "including a ..." limited
Element, it is not excluded that there is also other identical elements in process, method, article or the terminal device for including the element.
Above to a kind of reporting system configuration method provided by the present invention and device, it is described in detail, herein
Apply that a specific example illustrates the principle and implementation of the invention, the explanation of above example is only intended to help
Understand method and its core concept of the invention;At the same time, for those skilled in the art, thought according to the present invention,
There will be changes in the specific implementation manner and application range, in conclusion the content of the present specification should not be construed as to this
The limitation of invention.
Claims (12)
1. a kind of reporting system configuration method, which is characterized in that the described method includes:
Reporting system receives the retrieval source configuration information that user sends;
Retrieval source is configured based on received retrieval source configuration information;
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;
Determine screening washer corresponding with the retrieval source and querying condition pattern;
Reporting system query interface is generated according to the ways of presentation configuration information, screening washer and querying condition pattern;
Wherein, the retrieval source is database and/or tables of data;
Wherein, the querying condition pattern is set in advance in reporting system;
Wherein, determination screening washer corresponding with the retrieval source, comprising:
Extract the field of tables of data and/or the word for the tables of data connecting with reporting system in the database connecting with reporting system
Section;
The attribute value of each field is determined respectively;
Attribute value corresponding to each field and each field user is sent to respectively to select for user;
Receive the field and the corresponding attribute value of each field of user's selection;
The field that the user selects is determined as to the field of user's care, the corresponding attribute value of each field is determined as user
The attribute value of care;
It sets the field that user is concerned about to the filter condition of screening washer, sets the field pair for the attribute value of each field
The value for the filter condition answered, to generate screening washer.
2. the method according to claim 1, wherein retrieval source configuration information includes: retrieval source connection letter
Breath;
Retrieval source link information includes: database linkage information and/or tables of data link information;
It is described that retrieval source is configured based on the retrieval source configuration information received, comprising:
The database connecting with reporting system and/or tables of data are determined based on retrieval source link information;
Connection is established with the database and/or tables of data.
3. according to the method described in claim 2, it is characterized in that, described matched based on the retrieval source configuration information received
Set retrieval source further include:
The field in the field and/or the tables of data in the database in tables of data is extracted, the field of extraction is determined as
First dimensional information;
The first dimensional information of the determination is sent to user;
Receive the second dimensional information that user selects from the first dimensional information of the determination;
Second dimensional information is determined as to the dimensional information of user's care.
4. according to the method described in claim 2, it is characterized in that, retrieval source configuration information further include: data pick-up week
Phase configuration information;
It is described that retrieval source is configured based on the retrieval source configuration information received, further includes:
Extract the data pick-up period in the data pick-up period assignment information;
The data pick-up period extracted is determined as itself data pick-up period from data source extraction data;
Data are extracted from data source according to the data pick-up period.
5. the method according to claim 1, wherein described be based on the ways of presentation configuration information configuration data
Ways of presentation, comprising:
Extract the ways of presentation for including in the ways of presentation configuration information;
By the ways of presentation extracted be determined as to data show in the retrieval source when ways of presentation.
6. the method according to claim 1, wherein determination querying condition corresponding with the retrieval source
Pattern, comprising:
Reporting system presets multiple querying condition patterns corresponding with the retrieval source and selects for user;
Receive the querying condition pattern of user's selection;
The querying condition pattern that the user selects is determined as to the querying condition pattern of itself.
7. a kind of reporting system configuration device, which is characterized in that described device includes: information receiving module, retrieval source configuration mould
Block, data exhibiting mode configuration information, determining module and interface generation module;Wherein,
The information receiving module, what retrieval source configuration information and the user for receiving user's transmission were sent is directed to described
The ways of presentation configuration information of data in retrieval source;
Retrieval source configuration module, for configuring retrieval source based on received retrieval source configuration information;
The data exhibiting mode configuration module, for being based on the ways of presentation configuration information configuration data ways of presentation;
The determining module, for determining screening washer corresponding with the retrieval source and querying condition pattern;
The interface generation module is reported for being generated according to the ways of presentation configuration information, screening washer and querying condition pattern
The query interface of table system;
Wherein, the retrieval source is database and/or tables of data;
Wherein, the querying condition pattern is set in advance in reporting system;
Wherein, the determining module, comprising: third extracting sub-module, third determine submodule, the second information sending submodule,
Second information receiving submodule and screening washer generate submodule;Wherein,
The third extracting sub-module, for extract in the database being connect with reporting system the field of tables of data and/or with report
Field in the tables of data of table system connection;
The third determines submodule, for determining the attribute value of each field respectively;
The second information sending submodule is supplied for attribute value corresponding to field and each field to be sent to user respectively
User's selection;
The second information receiving submodule, for receiving the field and the corresponding attribute value of each field of user's selection;
The third determines submodule, is also used to for the field that the user selects being determined as the field of user's care, will be each
The corresponding attribute value of field is determined as the attribute value of user's care;
The screening washer generates submodule, for generating screening washer according to following manner:
It sets the field that user is concerned about to the filter condition of screening washer, sets the field pair for the attribute value of each field
The value for the filter condition answered.
8. device according to claim 7, which is characterized in that retrieval source configuration information includes: retrieval source connection letter
Breath;Retrieval source link information includes: database linkage information and/or tables of data link information;
Retrieval source configuration module, comprising: first determines submodule and connection submodule;Wherein,
It is described first determine submodule, for based on retrieval source link information determine reporting system connection database and/
Or tables of data;
The connection submodule, for the reporting system to be connected with the database and/or tables of data.
9. device according to claim 8, which is characterized in that retrieval source configuration module further include: first extracts son
Module, first information sending submodule, first information receiving submodule;Wherein,
First extracting sub-module, for extracting in the field and/or the tables of data in the database in tables of data
Field;
Described first determines submodule, for the field of extraction to be determined as the first dimensional information;
The first information sending submodule, for sending the first dimensional information of the determination to user;
The first information receiving submodule, the second dimension selected from the first dimensional information of the determination for receiving user
Spend information;
Described first determines submodule, for second dimensional information to be determined as to the dimensional information of user's care.
10. device according to claim 8, which is characterized in that retrieval source configuration information further include: data pick-up week
Phase configuration information;
First extracting sub-module is also used to extract the data pick-up period in the data pick-up period assignment information;
Described first determines submodule, is also used to the data pick-up period extracted being determined as the reporting system from number
The data pick-up period of data is extracted according to source;
Retrieval source configuration module, further includes: data pick-up submodule, for according to the data pick-up period from data source
Extract data.
11. device according to claim 7, which is characterized in that the data exhibiting mode configuration module, comprising: second
Extracting sub-module and second determines submodule;Wherein,
Second extracting sub-module, for extracting the ways of presentation for including in the ways of presentation configuration information;
Described second determines submodule, for the ways of presentation extracted to be determined as opening up data in the retrieval source
Current ways of presentation.
12. device according to claim 7, which is characterized in that the determining module, further includes: setting submodule is used for
Multiple querying condition patterns corresponding with the retrieval source are preset to select for user;
The second information receiving submodule is also used to receive the querying condition pattern of user's selection;
The third determines submodule, is also used to for the querying condition pattern that the user selects being determined as the inquiry of reporting system
Condition pattern.
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 CN106776644A (en) | 2017-05-31 |
CN106776644B true CN106776644B (en) | 2019-11-29 |
Family
ID=58963543
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201510825179.9A Active 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) |
Families Citing this family (4)
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 |
CN109358943B (en) * | 2018-11-09 | 2022-03-22 | 金色熊猫有限公司 | Page configuration method and device, electronic equipment and storage medium |
CN109684387B (en) * | 2018-12-24 | 2021-03-09 | 成都四方伟业软件股份有限公司 | 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 active Active
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 |
Also Published As
Publication number | Publication date |
---|---|
CN106776644A (en) | 2017-05-31 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
US11792291B1 (en) | Proxying hypertext transfer protocol (HTTP) requests for microservices | |
US10922493B1 (en) | Determining a relationship recommendation for a natural language request | |
US11836148B1 (en) | Data source correlation user interface | |
US10592525B1 (en) | Conversion of cloud computing platform data for ingestion by data intake and query system | |
CN106776644B (en) | A kind of reporting system configuration method and device | |
CN105354314B (en) | Data migration method and device | |
CN102982075A (en) | Heterogeneous data source access supporting system and method thereof | |
CN103617047A (en) | Method, device and processor for developing business processes | |
CN110019555A (en) | A kind of relation data semantization modeling method | |
CN102279848A (en) | Method and device for generating report template | |
JP5535062B2 (en) | Data storage and query method for time series analysis of weblog and system for executing the method | |
CN106886535A (en) | A kind of data pick-up method and apparatus for being adapted to multiple data sources | |
CN106682099A (en) | Data storage method and device | |
CN110309113A (en) | Log analytic method, system and equipment | |
CN108388623A (en) | ER relationships generation method, device, computer equipment and storage medium | |
CN114610963A (en) | Customized data display method, system, computer equipment and storage medium | |
CN110515750A (en) | A kind of applied topology generation method, system and cluster | |
CN109033157B (en) | Complex data retrieval method and system based on user-defined search condition tree | |
CN103605806B (en) | Implementation method for configurable structural data organization mode | |
CN107193842B (en) | Service positioning method and device for platform system | |
WO2017117870A1 (en) | Processing method and apparatus for trap instruction trap | |
Gibson et al. | Application of Named Graphs Towards Custom Provenance Views. | |
CN114860851A (en) | Data processing method, device, equipment and storage medium | |
CN114296696A (en) | Business function operation method and device, storage medium and electronic equipment | |
WO2017124877A1 (en) | Method and device for realizing data configuration for user resource |
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 |