CN109492056A - A kind of method and system of business intelligence data inquiry - Google Patents
A kind of method and system of business intelligence data inquiry Download PDFInfo
- Publication number
- CN109492056A CN109492056A CN201811247196.9A CN201811247196A CN109492056A CN 109492056 A CN109492056 A CN 109492056A CN 201811247196 A CN201811247196 A CN 201811247196A CN 109492056 A CN109492056 A CN 109492056A
- Authority
- CN
- China
- Prior art keywords
- data
- report
- inquiry
- information
- external member
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q30/00—Commerce
- G06Q30/02—Marketing; Price estimation or determination; Fundraising
- G06Q30/0201—Market modelling; Market analysis; Collecting market data
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q30/00—Commerce
- G06Q30/02—Marketing; Price estimation or determination; Fundraising
- G06Q30/0201—Market modelling; Market analysis; Collecting market data
- G06Q30/0203—Market surveys; Market polls
Landscapes
- Business, Economics & Management (AREA)
- Strategic Management (AREA)
- Engineering & Computer Science (AREA)
- Accounting & Taxation (AREA)
- Development Economics (AREA)
- Finance (AREA)
- Entrepreneurship & Innovation (AREA)
- Game Theory and Decision Science (AREA)
- Data Mining & Analysis (AREA)
- Economics (AREA)
- Marketing (AREA)
- Physics & Mathematics (AREA)
- General Business, Economics & Management (AREA)
- General Physics & Mathematics (AREA)
- Theoretical Computer Science (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses a kind of methods of business intelligence data inquiry, comprising: obtains the inquiry external member of user query data information;The inquiry external member of acquisition is parsed, and obtains inquiry external member parameter information;According to the inquiry external member after parsing from data information needed for calling and obtaining user in database;The data information inquired is constructed into data sheet;The data sheet of building is shown to user.The object of the present invention is to provide a kind of method and systems of business intelligence data inquiry, the data for realizing data sheet pattern and required inquiry show that index often changes, under conditions of needing to expand and develop data service engine to support new demand, lead to the problem of the realization logical comparison complexity of data query.
Description
Technical field
The present invention relates to internet business intelligence application field, in particular to the method for a kind of business intelligence data inquiry and
System.
Background technique
Business intelligence (Business Intelligence, referred to as: BI), refers to on modern data REPOSITORY TECHNOLOGY, line points
Analysis processing technique, data mining and data exhibiting technology carry out data analysis to realize commercial value.Business intelligence is as one
A tool for handling available data in enterprise, and is come out data query by data service engine, and data analysis is presented to
Personnel.
Currently during utilization, following problem is often faced:
On the one hand, data sheet pattern and the data of required inquiry show that index often changes, and need to expand and develop
Data service engine is to support new demand;Another aspect data sheet may be relatively more, and extension is complicated;Therefore, above-mentioned two
The realization logical comparison that a problem will lead to data query is complicated.
For there are technical problems above, this application provides the technical solutions for solving the above technical problem.
Summary of the invention
The object of the present invention is to provide a kind of method and systems of business intelligence data inquiry, realize data sheet pattern
And the data of required inquiry show that index often changes, and need to expand and develop data service engine to support new demand
Under the conditions of, lead to the problem of the realization logical comparison complexity of data query.
Technical solution provided by the invention is as follows:
A kind of method of business intelligence data inquiry, comprising: obtain the inquiry external member of user query data information;To acquisition
Inquiry external member parsed, and obtain inquiry external member parameter information;It is transferred from database according to the inquiry external member after parsing
Data information needed for user;The data information inquired is constructed into data sheet;The datagram of building is shown to user
Table.
It is further preferred that further include: the unified query interface of inquiry data information is established, and passes through the unified query
The inquiry external member of interface captures user input.
It is further preferred that further include: corresponding report id information, report form type parameter letter are extracted from the inquiry external member
Breath and report conditional parameter information;Inquiry meets the report conditional parameter information from database, when inquiry is less than satisfaction
When the conditional parameter of the report, the conditional parameter of the alternatively report is configured according to the conditional parameter of the report;It will
The correspondence report id information of extraction, report form type parameter information and replaced report conditional parameter information are sent to described
The query interface of database.
It is further preferred that further include: it is transferred from the database according to the inquiry external member after parsing and report
Related data information;And the data information related with report that will be transferred, report ID information, report form type ginseng are answered with described
Number information is associated setting, and is built into the data sheet.
It is further preferred that further include: dynamic dimension figure is generated according to the data sheet.
A kind of system of business intelligence data inquiry, comprising: external member obtains module, obtains looking into for user query data information
Ask external member;External member parsing module obtains module communication connection with the external member, parses to the inquiry external member of acquisition, and obtain
Take inquiry external member parameter information;Data transfer module, communicate to connect with the external member parsing module, according to the inquiry set after parsing
Part is from data information needed for calling and obtaining user in database;Report constructs module, transfers module communication connection with the data, will
The data information building data sheet inquired;Report display module is communicated to connect with report building module, to user's exhibition
Show the data sheet of building.
It is further preferred that query interface constructs module, the unified query interface of inquiry data information is established, and passes through institute
State the inquiry external member of unified query interface captures user input.
It is further preferred that the external member parsing module includes: parameter extraction submodule, extracted from the inquiry external member
Corresponding report id information, report form type parameter information and report conditional parameter information;Parameter information handles submodule, from number
Meet the report conditional parameter information according to inquiry in library, when inquiry is less than the conditional parameter for meeting the report, according to institute
The conditional parameter for stating report configures the conditional parameter of the alternatively report;Parameter information sending submodule, by pair of extraction
Report id information is answered, report form type parameter information and replaced report conditional parameter information are sent to the database
Query interface.
It is further preferred that further include: data information matched sub-block, according to the parameter of the inquiry external member after parsing
Information transfers data information related with report from the database;Data information is associated with submodule, and will transfer and report
The related data information of table answers report id information with described, and report form type parameter information is associated setting, and is built into described
Data sheet.
It is further preferred that further include: image construction module generates dynamic dimension figure according to the data sheet.
A kind of method and system of business intelligence data inquiry provided by the invention, can bring following at least one beneficial
Effect:
1, user in the present invention, is arranged to the query argument condition of data information by inquiry external member, and according to parameter
Condition in the database, establishes dynamic chart-information, according to the demand of user the corresponding data sheet of different displayings, while
It can show image information;Therefore, the application can fast implement the inquiry and exhibition of the business intelligence report data of business datum
Show;By independently defining respective inquiry " external member " for data present graphical (or report) required for each BI client, then
In conjunction with BI data query automotive engine system, thus can only be configured by backstage in the case where not needing system for varying code
Can quick response BI system business demand variation.
2, the inquiry external member that in the present invention, BI query engine receives user's input provides unified BI query interface;
For client when carrying out request of data, datagraphic (or report) whatever all requests the same data-query interfaces,
Only according to different datagraphics, the variation of interface requests content of parameter.Such design realization greatly reduces BI client
Dock the complexity of BI server-side inquiry data.
3, parametric variable in the present invention, is passed through for the conditional parameter of ungratified external member by parsing inquiry external member
Replacement realize that transfer relevant parameter from database, and generate matched report messages, therefore, the application is real
A variety of patterns displaying to data sheet, while the parameter information by saving in database are showed, have realized and needing to inquire
Data show that index often changes in the case where, and need to expand and develop data service engine to support new demand data
Report may be relatively more, solve the problems, such as that extension is complicated;Keep its logical comparison simple, realizes more convenient.
Detailed description of the invention
Below by clearly understandable mode, preferred embodiment is described with reference to the drawings, a kind of business intelligence data is looked into
Above-mentioned characteristic, technical characteristic, advantage and its implementation of the method and system of inquiry are further described.
Fig. 1 is a kind of flow chart of method one embodiment of business intelligence data inquiry of the present invention;
Fig. 2 is a kind of flow chart of another embodiment of the method for business intelligence data inquiry of the present invention;
Fig. 3 is a kind of flow chart of another embodiment of the method for business intelligence data inquiry of the present invention;
Fig. 4 is a kind of flow chart of another embodiment of the method for business intelligence data inquiry of the present invention;
Fig. 5 is a kind of method system structure chart of business intelligence data inquiry of the present invention;
Fig. 6 is the embodiment of framework map of the invention.
Specific embodiment
In order to more clearly explain the embodiment of the invention or the technical proposal in the existing technology, Detailed description of the invention will be compareed below
A specific embodiment of the invention.It should be evident that drawings in the following description are only some embodiments of the invention, for
For those of ordinary skill in the art, without creative efforts, it can also be obtained according to these attached drawings other
Attached drawing, and obtain other embodiments.
To make simplified form, part related to the present invention is only schematically shown in each figure, they are not represented
Its practical structures as product.In addition, there is identical structure or function in some figures so that simplified form is easy to understand
Component only symbolically depicts one of those, or has only marked one of those.Herein, "one" is not only indicated
" only this ", can also indicate the situation of " more than one ".
The present invention provides a kind of one embodiment of the method for business intelligence data inquiry, as shown in Figure 1,
The inquiry external member of step S110 acquisition user query data information;
Step S120 parses the inquiry external member of acquisition, and obtains inquiry external member parameter information;
Step S130 is according to the inquiry external member after parsing from data information needed for calling and obtaining user in database;
The data information inquired is constructed data sheet by step S140;
Step S150 shows the data sheet of building to user;
Step S160 generates dynamic dimension figure according to the data sheet.
Specifically, in the present embodiment, as shown in Figure 1 and shown in 6;Specifically include that BI inquiry is drawn based on the application framework
It holds up, BI Command Line Parsing device, BI configuration database, BI data warehouse composition;External member is inquired, is corresponded to set by a data report query
Dimension and index definition required for the query statements of needs, data exhibiting are set, and cooperates data query system by data sheet
Query result return go back.Inquiring external member is that parameter requirements according to the needs of users are configured, and can dynamically be changed.
BI query engine is sent in BI Command Line Parsing device after getting inquiry external member, and BI Command Line Parsing device parses it, parsing
The Parameter Conditions of data information required for user out, and by the Parameter Conditions information by BI query engine BI database into
Row match query matches the data information of the satisfaction inquiry external member conditional parameter after inquiry, and logical BI query engine is defeated
Out to client;Certainly further include that difference can be shown in the form of images according to the demand of user, realize various dimensions
It shows, the shape of figure includes;Column, pie, threadiness etc..
In this application, user is arranged to the query argument condition of data information by inquiry external member, and according to parameter item
Part in the database, establishes dynamic chart-information, different according to the demand of user to show corresponding data sheet, while can also
To show image information;Therefore, the application can fast implement the inquiry and displaying of the business intelligence report data of business datum;
By independently defining respective inquiry " external member " for data present graphical (or report) required for each BI client, in conjunction with
BI data query automotive engine system, thus can be in the case where not needing system for varying code, only can by backstage configuration
Changed with the business demand of quick response BI system.
The present invention also provides one embodiment, shown in Figure 2;Further include:
Step S210 establishes the unified query interface of inquiry data information, and passes through the unified query interface captures user
The inquiry external member of input;
The inquiry external member of step S220 acquisition user query data information;
Step S230 parses the inquiry external member of acquisition, and obtains inquiry external member parameter information;
Step S240 is according to the inquiry external member after parsing from data information needed for calling and obtaining user in database;
The data information inquired is constructed data sheet by step S250;
Step S260 shows the data sheet of building to user;
Step S270 generates dynamic dimension figure according to the data sheet.
Specifically, in this application, specifically including that BI query engine, BI Command Line Parsing device, BI are matched based on the application framework
Set database, BI data warehouse composition;Inquire external member, query statement, the number needed set by a corresponding data report query
According to dimension and index definition required for showing, and cooperate data query system that the query result return of data sheet is gone back.
Inquiring external member is that parameter requirements according to the needs of users are configured, and can dynamically be changed.BI query engine, which is got, to be looked into
It is sent in BI Command Line Parsing device after asking external member, BI Command Line Parsing device parses it, parses data required for user
The Parameter Conditions of information, and the Parameter Conditions information is subjected to match query in BI database by BI query engine, it will inquire
The data information of satisfaction inquiry external member conditional parameter afterwards is matched, and logical BI query engine is exported to client;Certainly also
Including difference can be shown in the form of images according to the demand of user, realize the displaying of various dimensions, the shape packet of figure
It includes;Column, pie, threadiness etc..
Wherein, the inquiry external member that BI query engine receives user's input provides unified BI query interface;
Interface and the designing technique feature for entering and leaving ginseng are as follows:
A. unified data-query interfaces: http: //<host_name>:<port>/ bi/query-chart-
data
B. unified discrepancy moduli plate.
Moduli plate is entered and left to be made of following key message:
ChartId: a pictorial statement ID is indicated
QueryCondition: the contingent condition in report query is indicated
Querying condition (entering ginseng) uniform format of each BI figure, the part of variation is figure/report ID for identifying
It is which chart/report ID out, and incoming querying condition Id (conditionId), querying condition type
(conditionType), query condition value (conditionValue).These three parameters are for identifying a figure/report
Inquire condition required for data.Software code example as provided above, one will inquire 2018-06-01 to 2018-08-
Between 01 two months, all access App, the figure/report for daily showing user's number of request, order numbers, number of deals that version is 7.6.1
Table.
Therefore, in this application, the inquiry external member that BI query engine receives user's input provides unified BI inquiry and connects
Mouthful;For client when carrying out request of data, datagraphic (or report) whatever all requests the same data query to connect
Mouthful, only according to different datagraphics, the variation of interface requests content of parameter.Such design realization greatly reduces BI client
The complexity of end docking BI server-side inquiry data.
The present invention also provides one embodiment, shown in Figure 3;Include:
Step S310 establishes the unified query interface of inquiry data information, and passes through the unified query interface captures user
The inquiry external member of input;
The inquiry external member of step S320 acquisition user query data information;
Step S331 extracts corresponding report id information, report form type parameter information and report from the inquiry external member
Conditional parameter information;
Step S332 is inquired from database meets the report conditional parameter information, when inquiry is less than meeting the report
Conditional parameter when, according to the conditional parameter of the report configure alternatively the report conditional parameter;
Step S333 is by the correspondence report id information of extraction, report form type parameter information and replaced report condition
Parameter information is sent to the query interface of the database;
Step S340 is according to the inquiry external member after parsing from data information needed for calling and obtaining user in database;
The data information inquired is constructed data sheet by step S350;
Step S360 shows the data sheet of building to user;
Step S270 generates dynamic dimension figure according to the data sheet.
Specifically, in this application, specifically including that BI query engine, BI Command Line Parsing device, BI are matched based on the application framework
Set database, BI data warehouse composition;Inquire external member, query statement, the number needed set by a corresponding data report query
According to dimension and index definition required for showing, and cooperate data query system that the query result return of data sheet is gone back.
Inquiring external member is that parameter requirements according to the needs of users are configured, and can dynamically be changed.BI query engine, which is got, to be looked into
It is sent in BI Command Line Parsing device after asking external member, BI Command Line Parsing device parses it, parses data required for user
The Parameter Conditions of information, and the Parameter Conditions information is subjected to match query in BI database by BI query engine, it will inquire
The data information of satisfaction inquiry external member conditional parameter afterwards is matched, and logical BI query engine is exported to client;Certainly also
Including difference can be shown in the form of images according to the demand of user, realize the displaying of various dimensions, the shape packet of figure
It includes;Column, pie, threadiness etc..
Wherein, the inquiry external member that BI query engine receives user's input provides unified BI query interface;
Interface and the designing technique feature for entering and leaving ginseng are as follows:
A. unified data-query interfaces: http: //<host_name>:<port>/ bi/query-chart-
data
B. unified discrepancy moduli plate.
Moduli plate is entered and left to be made of following key message:
ChartId: a pictorial statement ID is indicated
QueryCondition: the contingent condition in report query is indicated
Querying condition (entering ginseng) uniform format of each BI figure, the part of variation is figure/report ID for identifying
It is which chart/report ID out, and incoming querying condition Id (conditionId), querying condition type
(conditionType), query condition value (conditionValue).These three parameters are for identifying a figure/report
Inquire condition required for data.Software code example example as provided above, one will inquire 2018-06-01 to 2018-
Between 08-01 two months, all access App, the figure for daily showing user's number of request, order numbers, number of deals that version is 7.6.1
Shape/report.
In the present embodiment, it is directed to BI Command Line Parsing device and BI configuration database, for inquiring the parsing packet of external member
Include: BI Command Line Parsing module can be responsible for from BI configuration database inquiry, and to parse each BI pictorial statement corresponding with confidence
Breath;The configuration technology feature of BI pictorial statement are as follows:
A. each BI pictorial statement configuration ' external member ' is by a pictorial statement Id, the SQL query template of pictorial statement, figure
The data dimension for needing to show on report horizontal axis defines, the data dimension definition composition for needing to show on the pictorial statement longitudinal axis.
B. configuration information is stored in database table.
The content that enters to join of variable part and BI unified query interface matches and draws in BI inquiry in C.SQL query template
Variable replacement is done in holding up.BI SQL query template example is as follows, wherein being the replaceable part of parameter by the variable of $ { } mark.Such as
Example below,
Wherein, $ { ts_conditionType }, $ { ts_conditionValue } indicate the item that can be queried replacement
Part.The process of inquiry replacement is reporting system after the request for receiving BI query interface, parses following SQL template, will have
The input parameter of body, which is substituted into following SQL, becomes the SQL statement that execution can be parsed by database engine.
select sum(indi_block_pv)as block_pv,sum(indi_block_uv)as block_uv,
round(sum(indi_block_pv)/sum(indi_page_pv),2)as block_pv_rate,
round(sum(indi_block_uv)/sum(indi_page_uv),2)as block_uv_rate,page_
id,
block_id from t_indicator_page where ts${ts_conditionType}
${ts_conditionValue}and client_type${client_type_conditionType}
${client_type_conditionValue}and client_sys${client_sys_
conditionType}
${client_sys_conditionValue}and client_ver${client_ver_conditionType}
${client_ver_conditionValue}andblock_id${block_id_conditionType}
${block_id_conditionValue}andpage_id${page_id_conditionType}
${page_id_conditionValue}group bypage_id,block_id.
The data dimension and data target configurableization that D.BI pictorial statement can show.In following example, figure report
Cross, longitudinal axis configuration in table configuration specify and specifically to inquire the data dimension of return in a pictorial statement transverse and longitudinal axis and refer to
Mark.BI query engine module can configure the formatting encapsulation for carrying out BI report data and be returned according to this.
Horizontal axis configuration definition:
{"xAxisDes":"xAxis","xAxisValueDes":[{"xv":"block_id"},{"xv": "page_
id"}]};
Longitudinal axis configuration definition:
{"yAxisDes":"yAxis","yAxisValueDes":[{"yv":"block_pv"},{"yv": "block_
uv"},{"yv":"block_pv_rate"},{"yv":"block_uv_rate"}]}.
The present invention also provides one embodiment, shown in Figure 4;Include:
Step S410 establishes the unified query interface of inquiry data information, and passes through the unified query interface captures user
The inquiry external member of input;
The inquiry external member of step S420 acquisition user query data information;
Step S431 extracts corresponding report id information, report form type parameter information and report from the inquiry external member
Conditional parameter information;
Step S432 is inquired from database meets the report conditional parameter information, when inquiry is less than meeting the report
Conditional parameter when, according to the conditional parameter of the report configure alternatively the report conditional parameter;
Step S433 is by the correspondence report id information of extraction, report form type parameter information and replaced report condition
Parameter information is sent to the query interface of the database;
Step S441 transfers data related with report according to the inquiry external member after parsing from the database and believes
Breath;
Step S442 and the data information related with report that will be transferred answer report id information, report form type ginseng with described
Number information is associated setting, and is built into the data sheet.
Step S450 shows the data sheet of building to user;
Step S460 generates dynamic dimension figure according to the data sheet.
Specifically, in this application, specifically including that BI query engine, BI Command Line Parsing device, BI are matched based on the application framework
Set database, BI data warehouse composition;Inquire external member, query statement, the number needed set by a corresponding data report query
According to dimension and index definition required for showing, and cooperate data query system that the query result return of data sheet is gone back.
Inquiring external member is that parameter requirements according to the needs of users are configured, and can dynamically be changed.BI query engine, which is got, to be looked into
It is sent in BI Command Line Parsing device after asking external member, BI Command Line Parsing device parses it, parses data required for user
The Parameter Conditions of information, and the Parameter Conditions information is subjected to match query in BI database by BI query engine, it will inquire
The data information of satisfaction inquiry external member conditional parameter afterwards is matched, and logical BI query engine is exported to client;Certainly also
Including difference can be shown in the form of images according to the demand of user, realize the displaying of various dimensions, the shape packet of figure
It includes;Column, pie, threadiness etc..
Wherein, the inquiry external member that BI query engine receives user's input provides unified BI query interface;
Interface and the designing technique feature for entering and leaving ginseng are as follows:
A. unified data-query interfaces: http: //<host_name>:<port>/ bi/query-chart-
data
B. unified discrepancy moduli plate.
Moduli plate is entered and left to be made of following key message:
ChartId: a pictorial statement ID is indicated
QueryCondition: the contingent condition in report query is indicated
Querying condition (entering ginseng) uniform format of each BI figure, the part of variation is figure/report ID for identifying
It is which chart/report ID out, and incoming querying condition Id (conditionId), querying condition type
(conditionType), query condition value (conditionValue).These three parameters are for identifying a figure/report
Inquire condition required for data.Software code example example as provided above, one will inquire 2018-06-01 to 2018-
Between 08-01 two months, all access App, the figure for daily showing user's number of request, order numbers, number of deals that version is 7.6.1
Shape/report.
It is directed to BI Command Line Parsing device and BI configuration database, and the parsing for inquiring external member includes: BI Command Line Parsing
Module can be responsible for the inquiry from BI configuration database and parse the corresponding configuration information of each BI pictorial statement;BI pictorial statement
Configuration technology feature are as follows:
A. each BI pictorial statement configuration ' external member ' is by a pictorial statement Id, the SQL query template of pictorial statement, figure
The data dimension for needing to show on report horizontal axis defines, the data dimension definition composition for needing to show on the pictorial statement longitudinal axis.
B. configuration information is stored in database table.
The content that enters to join of variable part and BI unified query interface matches and draws in BI inquiry in C.SQL query template
Variable replacement is done in holding up.BI SQL query template example is as follows, wherein being the replaceable part of parameter by the variable of $ { } mark.Such as
Example below,
Wherein, $ { ts_conditionType }, $ { ts_conditionValue } indicate the item that can be queried replacement
Part.The process of inquiry replacement is reporting system after the request for receiving BI query interface, parses following SQL template, will have
The input parameter of body, which is substituted into following SQL, becomes the SQL statement that execution can be parsed by database engine.
select sum(indi_block_pv)as block_pv,sum(indi_block_uv)as block_uv,
round(sum(indi_block_pv)/sum(indi_page_pv),2)as block_pv_rate,
round(sum(indi_block_uv)/sum(indi_page_uv),2)as block_uv_rate,page_
id,
block_id from t_indicator_page where ts${ts_conditionType}
${ts_conditionValue}and client_type${client_type_conditionType}
${client_type_conditionValue}and client_sys${client_sys_
conditionType}
${client_sys_conditionValue}and client_ver${client_ver_conditionType}
${client_ver_conditionValue}andblock_id${block_id_conditionType}
${block_id_conditionValue}andpage_id${page_id_conditionType}
${page_id_conditionValue}group bypage_id,block_id.
The data dimension and data target configurableization that D.BI pictorial statement can show.In following example, figure report
Cross, longitudinal axis configuration in table configuration specify and specifically to inquire the data dimension of return in a pictorial statement transverse and longitudinal axis and refer to
Mark.BI query engine module can configure the formatting encapsulation for carrying out BI report data and be returned according to this.
Horizontal axis configuration definition:
{"xAxisDes":"xAxis","xAxisValueDes":[{"xv":"block_id"},{"xv": "page_
id"}]};
Longitudinal axis configuration definition:
{"yAxisDes":"yAxis","yAxisValueDes":[{"yv":"block_pv"},{"yv": "block_
uv"},{"yv":"block_pv_rate"},{"yv":"block_uv_rate"}]}.
According to embodiment provided above, provide in the present embodiment in the database to data information transfer with
And associated process is following:
Query engine module is responsible for returning the inquiry request that BI unified query interface is passed to BI Command Line Parsing module polls
The BI configuration external member returned carries out matching treatment and carries out data query into data warehouse, and detailed process includes:
A. the incoming data packet of parsing BI unified query interface, is taken out report Id, such as ' chartId ' in example,
And querying condition queryCondition list;
B. according to pictorial statement Id, BI Command Line Parsing module is called, is read out for defined in this pictorial statement ID
Inquire ' external member ' information, including specific SQL template, figure/report configuration information, such as the definition of horizontal axis data dimension, longitudinal axis number
According to index definition;
C. it is replaced the SQL that generates and can be performed to the variable in pictorial statement SQL template, then calls data warehouse
Inquire data;
D.BI query engine is according to horizontal axis, longitudinal axis data dimension defined in report pattern corresponding ' inquiry external member ' and refers to
Calibration justice is filtered the data set that data warehouse query returns, encapsulates, then returns.
In this application, parametric variable is passed through for the conditional parameter of ungratified external member by parsing inquiry external member
Replacement to transfer relevant parameter from database, and generates matched report messages to realize, therefore, the application realizes
The a variety of patterns of data sheet are shown, while the parameter information by being saved in database, realizes and needing to inquire
In the case that data show that index often changes, and need to expand and develop data service engine to support new demand data report
Table may be relatively more, solve the problems, such as that extension is complicated;Keep its logical comparison simple, realizes more convenient.
The present invention also provides a kind of one embodiment of the system of business intelligence data inquiry, show and scheme with reference to figure institute 5
Shown in 6;Include: that external member obtains module 100, obtains the inquiry external member of user query data information;External member parsing module 200, with
The external member obtains module communication connection, parses to the inquiry external member of acquisition, and obtains inquiry external member parameter information;Data
Transfer module 300, with the external member parsing module communicate to connect, according to the inquiry external member after parsing from database calling and obtaining user
Required data information;Report constructs module 400, transfers module communication connection, the data information that will be inquired with the data
Construct data sheet;Report display module 500 is shown described in building with report building module communication connection to user
Data sheet;/ or;Image construction module 600 generates dynamic dimension figure according to the data sheet.
Specifically, in the present embodiment, specifically including that BI query engine, BI Command Line Parsing device, BI based on the application framework
Configuration database, BI data warehouse composition;Inquire external member, the query statement needed set by a corresponding data report query,
Dimension and index definition required for data exhibiting, and data query system is cooperated to return to back the query result of data sheet
It goes.Inquiring external member is that parameter requirements according to the needs of users are configured, and can dynamically be changed.BI query engine is got
It is sent in BI Command Line Parsing device after inquiry external member, BI Command Line Parsing device parses it, parses number required for user
It is believed that the Parameter Conditions of breath, and the Parameter Conditions information is subjected to match query in BI database by BI query engine, it will look into
The data information of satisfaction inquiry external member conditional parameter after inquiry is matched, and logical BI query engine is exported to client;Certainly
Further include that difference can be shown in the form of images according to the demand of user, realizes the displaying of various dimensions, the shape of figure
Including;Column, pie, threadiness etc..
In this application, user is arranged to the query argument condition of data information by inquiry external member, and according to parameter item
Part in the database, establishes dynamic chart-information, different according to the demand of user to show corresponding data sheet, while can also
To show image information;Therefore, the application can fast implement the inquiry and displaying of the business intelligence report data of business datum;
By independently defining respective inquiry " external member " for data present graphical (or report) required for each BI client, in conjunction with
BI data query automotive engine system, thus can be in the case where not needing system for varying code, only can by backstage configuration
Changed with the business demand of quick response BI system.
Preferably, further includes: query interface constructs module 000, establishes the unified query interface of inquiry data information, and leads to
Cross the inquiry external member of the unified query interface captures user input;External member obtains module 100, obtains user query number
It is believed that the inquiry external member of breath;External member parsing module 200 obtains module communication connection with the external member, to the inquiry external member of acquisition
It is parsed, and obtains inquiry external member parameter information;Data transfer module 300, communicate to connect with the external member parsing module, root
According to the inquiry external member after parsing from data information needed for calling and obtaining user in database;Report constructs module 400, with the data
Module communication connection is transferred, the data information inquired is constructed into data sheet;Report display module 500, with the report structure
Block communication connection is modeled, the data sheet of building is shown to user;And/or;Image construction module 600, according to the number
According to report generation dynamic dimension figure.
Preferably, the external member parsing module 200 includes: parameter extraction submodule 210, is extracted from the inquiry external member
Corresponding report id information, report form type parameter information and report conditional parameter information;Number information processing submodule 220, from number
Meet the report conditional parameter information according to inquiry in library, when inquiry is less than the conditional parameter for meeting the report, according to institute
The conditional parameter for stating report configures the conditional parameter of the alternatively report;Parameter information sending submodule 230, by extraction
Corresponding report id information, report form type parameter information and replaced report conditional parameter information are sent to the database
Query interface.And/or image construction module 600, dynamic dimension figure is generated according to the data sheet.
Preferably, it includes: data information matched sub-block 310 that the data, which transfer module 300, according to after parsing
The parameter information of inquiry external member transfers data information related with report from the database;According to information association submodule 320,
And the data information related with report that will be transferred, report ID information is answered with described, report form type parameter information, which is associated, to be set
It sets, and is built into the data sheet;And/or image construction module 600, dynamic dimension figure is generated according to the data sheet
Shape.
Based on the above, in conjunction with shown in Fig. 1-Fig. 6;The application system Quan Yaoyu method power to correspond, therefore with side
Method any embodiment can be used in this system, here, repeating no more.
In the present invention, if being realized in the form of SFU software functional unit and selling or use as independent product
When, it can store in a computer readable storage medium.Based on this understanding, the technical solution of the application is substantially
In other words the part to the contribution of the prior art or the technical solution in whole or in part can be in the form of software products
It embodies, which is stored in a storage medium, including some instructions are used so that a computer
Equipment (but personal computer, server perhaps network equipment) or processor execute the application embodiment the method
All or part of the steps.And storage above-mentioned is worth bag data server, cloud server, read-only memory (ROM, Read-
Only Memory), random access memory (RAM, Random Access Memory), mobile communication equipment or CD,
Or the various media that can store code such as USB flash disk.
It should be noted that above-described embodiment can be freely combined as needed.The above is only of the invention preferred
Embodiment, it is noted that for those skilled in the art, in the premise for not departing from the principle of the invention
Under, several improvements and modifications can also be made, these modifications and embellishments should also be considered as the scope of protection of the present invention.
Claims (10)
1. a kind of method of business intelligence data inquiry characterized by comprising
Obtain the inquiry external member of user query data information;
The inquiry external member of acquisition is parsed, and obtains inquiry external member parameter information;
According to the inquiry external member after parsing from data information needed for calling and obtaining user in database;
The data information inquired is constructed into data sheet;
The data sheet of building is shown to user.
2. the method for business intelligence data inquiry as described in claim 1, which is characterized in that further include:
The unified query interface of inquiry data information is established, and is looked by the described of unified query interface captures user input
Ask external member.
3. the method for business intelligence data inquiry as described in claim 1, which is characterized in that further include:
Corresponding report id information, report form type parameter information and report conditional parameter information are extracted from the inquiry external member;
Inquiry meets the report conditional parameter information from database, when inquiry is less than the conditional parameter for meeting the report
When, the conditional parameter of the alternatively report is configured according to the conditional parameter of the report;
By the correspondence report id information of extraction, report form type parameter information and replaced report conditional parameter information are sent
To the query interface of the database.
4. the method for business intelligence data inquiry as claimed in claim 3, which is characterized in that further include:
Data information related with report is transferred from the database according to the inquiry external member after parsing;
And the data information related with report that will be transferred, report id information is answered with described, report form type parameter information is closed
Connection setting, and it is built into the data sheet.
5. the method that the business intelligence data as described in claim 1-4 is any is inquired, which is characterized in that further include:
Dynamic dimension figure is generated according to the data sheet.
6. a kind of system of business intelligence data inquiry characterized by comprising
External member obtains module, obtains the inquiry external member of user query data information;
External member parsing module obtains module communication connection with the external member, parses to the inquiry external member of acquisition, and obtain and look into
Ask external member parameter information;
Data transfer module, communicate to connect with the external member parsing module, are adjusted from database according to the inquiry external member after parsing
Data information needed for taking family;
Report constructs module, transfers module communication connection with the data, the data information inquired is constructed data sheet;
Report display module shows the data sheet of building to user with report building module communication connection.
7. the system of business intelligence data inquiry as claimed in claim 6, which is characterized in that further include:
Query interface constructs module, establishes the unified query interface of inquiry data information, and is obtained by the unified query interface
Take the inquiry external member of family input.
8. the system of business intelligence data inquiry as claimed in claim 6, which is characterized in that the external member parsing module packet
It includes:
Parameter extraction submodule extracts corresponding report id information, report form type parameter information, Yi Jibao from the inquiry external member
Surface condition parameter information;
Parameter information handles submodule, and inquiry meets the report conditional parameter information from database, when inquiry is less than satisfaction
When the conditional parameter of the report, the conditional parameter of the alternatively report is configured according to the conditional parameter of the report;
Parameter information sending submodule, by the correspondence report id information of extraction, report form type parameter information and replaced report
Surface condition parameter information is sent to the query interface of the database.
9. the system of business intelligence data inquiry as claimed in claim 8, which is characterized in that the report constructs module packet
It includes:
Data information matched sub-block, according to the parameter information of the inquiry external member after parsing transfer from the database with
The related data information of report;
Data information is associated with submodule, and the data information related with report that will be transferred, and answers report id information, report with described
Type parameter information is associated setting, and is built into the data sheet.
10. the system that the business intelligence data as described in claim 6-9 is any is inquired, which is characterized in that further include:
Image construction module generates dynamic dimension figure according to the data sheet.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201811247196.9A CN109492056A (en) | 2018-10-24 | 2018-10-24 | A kind of method and system of business intelligence data inquiry |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201811247196.9A CN109492056A (en) | 2018-10-24 | 2018-10-24 | A kind of method and system of business intelligence data inquiry |
Publications (1)
Publication Number | Publication Date |
---|---|
CN109492056A true CN109492056A (en) | 2019-03-19 |
Family
ID=65691888
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201811247196.9A Pending CN109492056A (en) | 2018-10-24 | 2018-10-24 | A kind of method and system of business intelligence data inquiry |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN109492056A (en) |
Cited By (6)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN111708992A (en) * | 2020-05-06 | 2020-09-25 | 咪咕文化科技有限公司 | Report data access method and device, electronic equipment and storage medium |
CN112667663A (en) * | 2020-12-28 | 2021-04-16 | 北京明略软件系统有限公司 | Data query method and system |
WO2021093674A1 (en) * | 2019-11-15 | 2021-05-20 | 深圳前海微众银行股份有限公司 | Bi node execution method in workflow system, apparatus, device, and computer readable storage medium |
CN113010591A (en) * | 2021-03-22 | 2021-06-22 | 薪得付信息技术(上海)有限公司 | Report generation method, device and system based on application interface |
CN113238945A (en) * | 2021-05-17 | 2021-08-10 | 上海中通吉网络技术有限公司 | Automatic test method for chart query of BI (business intelligence) system |
CN113342821A (en) * | 2021-06-29 | 2021-09-03 | 深圳前海微众银行股份有限公司 | Report configuration method, device, equipment and computer storage medium |
Citations (5)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN105843945A (en) * | 2016-04-08 | 2016-08-10 | 联动优势科技有限公司 | Report generation method and system |
CN106776834A (en) * | 2016-11-28 | 2017-05-31 | 中通服公众信息产业股份有限公司 | A kind of data analysis based on index is from access method and system |
CN108446309A (en) * | 2018-02-05 | 2018-08-24 | 深圳市资本在线金融信息服务有限公司 | The application process and device of WEB intelligent report forms |
CN108572945A (en) * | 2018-03-09 | 2018-09-25 | 吉贝克信息技术(北京)有限公司 | Create method, system, storage medium and the electronic equipment of report |
CN108694214A (en) * | 2017-04-12 | 2018-10-23 | 北京京东尚科信息技术有限公司 | Generation method, generating means, readable medium and the electronic equipment of data sheet |
-
2018
- 2018-10-24 CN CN201811247196.9A patent/CN109492056A/en active Pending
Patent Citations (5)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN105843945A (en) * | 2016-04-08 | 2016-08-10 | 联动优势科技有限公司 | Report generation method and system |
CN106776834A (en) * | 2016-11-28 | 2017-05-31 | 中通服公众信息产业股份有限公司 | A kind of data analysis based on index is from access method and system |
CN108694214A (en) * | 2017-04-12 | 2018-10-23 | 北京京东尚科信息技术有限公司 | Generation method, generating means, readable medium and the electronic equipment of data sheet |
CN108446309A (en) * | 2018-02-05 | 2018-08-24 | 深圳市资本在线金融信息服务有限公司 | The application process and device of WEB intelligent report forms |
CN108572945A (en) * | 2018-03-09 | 2018-09-25 | 吉贝克信息技术(北京)有限公司 | Create method, system, storage medium and the electronic equipment of report |
Non-Patent Citations (2)
Title |
---|
王洪艳: "《计算机与化学化工试验数据处理》", 31 October 2002, 吉林大学出版社 * |
黄强: "《国土安全 理念政策技术装备及系统》", 31 December 2013, 东南大学出版社 * |
Cited By (8)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
WO2021093674A1 (en) * | 2019-11-15 | 2021-05-20 | 深圳前海微众银行股份有限公司 | Bi node execution method in workflow system, apparatus, device, and computer readable storage medium |
CN111708992A (en) * | 2020-05-06 | 2020-09-25 | 咪咕文化科技有限公司 | Report data access method and device, electronic equipment and storage medium |
CN111708992B (en) * | 2020-05-06 | 2023-07-14 | 咪咕文化科技有限公司 | Report data access method and device, electronic equipment and storage medium |
CN112667663A (en) * | 2020-12-28 | 2021-04-16 | 北京明略软件系统有限公司 | Data query method and system |
CN113010591A (en) * | 2021-03-22 | 2021-06-22 | 薪得付信息技术(上海)有限公司 | Report generation method, device and system based on application interface |
CN113010591B (en) * | 2021-03-22 | 2024-04-19 | 薪得付信息技术(上海)有限公司 | Report generation method, device and system based on application interface |
CN113238945A (en) * | 2021-05-17 | 2021-08-10 | 上海中通吉网络技术有限公司 | Automatic test method for chart query of BI (business intelligence) system |
CN113342821A (en) * | 2021-06-29 | 2021-09-03 | 深圳前海微众银行股份有限公司 | Report configuration method, device, equipment and computer storage medium |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN109492056A (en) | A kind of method and system of business intelligence data inquiry | |
WO2018188666A1 (en) | Information processing method and device | |
CN111651510A (en) | Data processing method and device, electronic equipment and computer readable storage medium | |
CN108875042B (en) | Hybrid online analysis processing system and data query method | |
US20160196319A1 (en) | Multi-dimensional data analysis | |
CN103559619A (en) | Response method and system for garment size information | |
CN103312751A (en) | Instant messaging method based on browser | |
CN102622444A (en) | XML (extensible markup language) message processing method and XML message processing device | |
CN104361049A (en) | Method and system for quickly expressing data of database | |
CN110888672B (en) | Expression engine implementation method and system based on metadata architecture | |
CN107636655A (en) | Data are provided in real time to service(DaaS)System and method | |
US11108717B1 (en) | Trends in a messaging platform | |
CN112925954A (en) | Method and apparatus for querying data in a graph database | |
CN110555023B (en) | Data storage method and device based on credit contract | |
CN113742392A (en) | Data synchronization method and device, electronic equipment and storage medium | |
US11620284B2 (en) | Backend data aggregation system and method | |
CN111814020A (en) | Data acquisition method and device | |
CN105740251B (en) | Method and system for integrating different content sources in bus mode | |
CN111047362A (en) | Statistical management method and system for use activity of intelligent sound box | |
CN116233253A (en) | Service processing method, device, computer equipment and storage medium | |
CN103166927B (en) | A kind of XML communication protocol dynamic management approach | |
CN113704486A (en) | Map data construction method and device and map data query method and device | |
US20050159975A1 (en) | Multiple-party business cooperation system and method | |
Pullen et al. | Linked Heterogenous BML Servers in NATO MSG-085 | |
CN107368477B (en) | HBase coprocessor-based SQL-like query method and system |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
PB01 | Publication | ||
PB01 | Publication | ||
SE01 | Entry into force of request for substantive examination | ||
SE01 | Entry into force of request for substantive examination | ||
RJ01 | Rejection of invention patent application after publication |
Application publication date: 20190319 |
|
RJ01 | Rejection of invention patent application after publication |