CN112949269A - Method, system, equipment and storage medium for generating visual data analysis report - Google Patents
Method, system, equipment and storage medium for generating visual data analysis report Download PDFInfo
- Publication number
- CN112949269A CN112949269A CN202110368003.0A CN202110368003A CN112949269A CN 112949269 A CN112949269 A CN 112949269A CN 202110368003 A CN202110368003 A CN 202110368003A CN 112949269 A CN112949269 A CN 112949269A
- Authority
- CN
- China
- Prior art keywords
- report
- data
- configuring
- generating
- data analysis
- 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
- 230000000007 visual effect Effects 0.000 title claims abstract description 54
- 238000007405 data analysis Methods 0.000 title claims abstract description 40
- 238000000034 method Methods 0.000 title claims abstract description 40
- 238000004364 calculation method Methods 0.000 claims abstract description 14
- 238000012216 screening Methods 0.000 claims abstract description 8
- 230000006870 function Effects 0.000 claims description 9
- 238000004220 aggregation Methods 0.000 claims description 8
- 238000004458 analytical method Methods 0.000 claims description 8
- 230000002776 aggregation Effects 0.000 claims description 6
- 238000012517 data analytics Methods 0.000 claims description 6
- 238000012795 verification Methods 0.000 claims description 5
- 230000004044 response Effects 0.000 abstract description 9
- 238000011161 development Methods 0.000 abstract description 8
- 238000012545 processing Methods 0.000 description 13
- 238000010586 diagram Methods 0.000 description 6
- 230000003287 optical effect Effects 0.000 description 3
- 238000013461 design Methods 0.000 description 2
- 238000005111 flow chemistry technique Methods 0.000 description 2
- 239000013307 optical fiber Substances 0.000 description 2
- 230000008569 process Effects 0.000 description 2
- 230000000644 propagated effect Effects 0.000 description 2
- 241000282813 Aepyceros melampus Species 0.000 description 1
- 230000004931 aggregating effect Effects 0.000 description 1
- 238000003491 array Methods 0.000 description 1
- 238000013475 authorization Methods 0.000 description 1
- 230000008859 change Effects 0.000 description 1
- 238000004891 communication Methods 0.000 description 1
- 238000010276 construction Methods 0.000 description 1
- 238000005553 drilling Methods 0.000 description 1
- 238000001914 filtration Methods 0.000 description 1
- 230000002093 peripheral effect Effects 0.000 description 1
- 230000003252 repetitive effect Effects 0.000 description 1
- 239000004065 semiconductor Substances 0.000 description 1
- 238000006467 substitution reaction Methods 0.000 description 1
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/166—Editing, e.g. inserting or deleting
- G06F40/177—Editing, e.g. inserting or deleting of tables; using ruled lines
- G06F40/18—Editing, e.g. inserting or deleting of tables; using ruled lines of spreadsheets
-
- 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/26—Visual data mining; Browsing structured data
-
- 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/28—Databases characterised by their database models, e.g. relational or object models
- G06F16/283—Multi-dimensional databases or data warehouses, e.g. MOLAP or ROLAP
Abstract
The invention provides a method, a system, equipment and a storage medium for generating a visual data analysis report, wherein the method comprises the following steps: configuring a data set, binding the data set through a data set function according to a data table developed by a data warehouse, setting dimensionality and indexes required by the subsequent report form creation, and supporting the data preview; configuring a report according to a data set, comprising the following steps: configuring a screening item module; a configuration index module; configuring an icon display module; storing the report and setting a report storage position; and setting menu authority and data authority of the report. The method and the device can provide the capability of dynamically creating the visual report, reduce the workload of customized report development, improve the response timeliness of the demand, and meet the requirements of business, and solve the problem of flexibility and timeliness that the traditional relational database can not meet the requirements of business in a big data calculation scene based on a big data distributed OLAP engine.
Description
Technical Field
The invention relates to the field of report automatic generation, in particular to a method, a system, equipment and a storage medium for generating a visual data analysis report.
Background
The visualized data analysis report system can help the personnel of the company in business, product, operation and the like to save the labor cost for checking data and can assist the personnel in making daily analysis decisions, so the system is an indispensable internal tool in many companies; the traditional online process of visualizing data analysis reports generally comprises the following steps:
1. the business puts forward report requirements;
2. product design prd (business requirement documentation) according to business requirements;
3. prd according to product design is developed, and the development is carried out on-line delivery to service for use;
the 3 rd step in the whole process consumes the longest time, both the human resources and the time schedule are developed, and various reports developed in a customized manner lack unified standardization; in addition, the traditional data analysis reporting system based on the relational database cannot meet the performance requirement in a big data scene.
Therefore, the invention provides a method, a system, equipment and a storage medium for generating a visual data analysis report.
Disclosure of Invention
Aiming at the problems in the prior art, the invention aims to provide a method, a system, equipment and a storage medium for generating a visual data analysis report, overcomes the difficulties in the prior art, can provide the capability of dynamically creating the visual report, reduce the workload of customized report development, improve the response timeliness of requirements, and meet the requirements of services, and solves the problem that a big data calculation scene which cannot be met by a traditional relational database can meet the flexibility and timeliness of service requirements based on a big data distributed OLAP engine.
The embodiment of the invention provides a method for generating a visual data analysis report, which comprises the following steps:
s110, configuring a data set, binding through a data set function according to a data table developed by a data warehouse, setting dimensionality and indexes required by subsequent report form creation, and supporting data preview;
s120, configuring a report according to the data set, and comprising the following steps:
s121, configuring a screening item module;
s122, configuring an index module;
s123, configuring an icon display module;
s124, saving the report, and setting a report storage position; and
and S125, setting menu authority and data authority for the report.
Preferably, one of a big data OLAP engine analysis type data warehouse Kylin, a column storage database Clickhouse and a memory computing type engine Presto is used as an underlying query engine.
Preferably, each OLAP engine is accessed in a JDBC mode, a uniform query interface is provided for the front end, the query request is converted into sql, and a corresponding appropriate OLAP engine can be selected according to different demand scenarios.
Preferably, the request parameter is subjected to matching check and parameterization processing, and the request is subjected to authority check.
Preferably, the Kylin OLAP engine is used for very large data volumes, optimized by Aggregation Groups.
Preferably, the index containing complex calculation is matched in a way of simultaneously carrying out respectively querying and re-aggregating calculation on multiple tables.
Preferably, the method further comprises the following steps:
s130, checking and accepting the internal check and the external service; and
and S140, the online report is used by business personnel.
The embodiment of the present invention further provides a system for generating a visual data analysis report, which is used to implement the method for generating a visual data analysis report, and the system for generating a visual data analysis report includes:
the data set configuration module is used for binding through a data set function according to the data tables developed by the data warehouse, setting dimensionality and indexes required by the subsequent report form creation, and supporting the data preview;
the report configuration module is used for configuring a report according to the data set, configuring the screening item module, the index configuration module, the icon configuration display module and the report storage module, and setting the storage position of the report; and setting menu authority and data authority of the report.
The system also comprises a checking and accepting module and a report form online module, wherein the checking and accepting module is used for carrying out internal checking and external service acceptance; and the report on-line module is used for the service personnel to use the report on line.
The embodiment of the present invention further provides a device for generating a visual data analysis report, including:
a processor;
a memory having stored therein executable instructions of the processor;
wherein the processor is configured to execute the steps of the method for generating a visual data analysis report via execution of the executable instructions.
The embodiment of the present invention further provides a computer-readable storage medium for storing a program, where the program, when executed, implements the steps of the method for generating a visual data analysis report.
The invention aims to provide a method, a system, equipment and a storage medium for generating a visual data analysis report, which can provide the capability of dynamically creating the visual report, provide a unified and standardized visual analysis report, reduce the workload of customized report development, improve the response timeliness of demand, meet the requirements of business, and solve the problem that a big data calculation scene which cannot be met by a traditional relational database can meet the flexibility and timeliness of business requirements based on a big data distributed OLAP engine.
Drawings
Other features, objects and advantages of the present invention will become more apparent upon reading of the following detailed description of non-limiting embodiments thereof, with reference to the accompanying drawings.
FIG. 1 is a flow chart of a method for generating a visual data analytics report in accordance with the present invention.
FIG. 2 is a block diagram of a system for generating a visual data analytics report in accordance with the present invention.
FIG. 3 is a schematic structural diagram of a generation device of a visual data analysis report according to the present invention.
Fig. 4 is a schematic structural diagram of a computer-readable storage medium according to an embodiment of the present invention.
Detailed Description
Example embodiments will now be described more fully with reference to the accompanying drawings. Example embodiments may, however, be embodied in many different forms and should not be construed as limited to the embodiments set forth herein. Rather, these embodiments are provided so that this disclosure will be thorough and complete, and will fully convey the concept of example embodiments to those skilled in the art. The same reference numerals in the drawings denote the same or similar structures, and thus their repetitive description will be omitted.
FIG. 1 is a flow chart of a method for generating a visual data analytics report in accordance with the present invention. As shown in fig. 1, an embodiment of the present invention provides a method for generating a visual data analysis report, including the following steps:
s110, configuring a data set, binding through a data set function according to a data table developed by a data warehouse, setting dimensionality and indexes required by subsequent report form creation, and supporting data preview;
s120, configuring a report according to the data set, and comprising the following steps:
s121, configuring a screening item module;
s122, configuring an index module;
s123, configuring an icon display module;
s124, saving the report, and setting a report storage position; and
and S125, setting menu authority and data authority for the report.
In a preferred embodiment, one of big data OLAP engine analytic data warehouse Kylin, columnar storage database Clickhouse, and memory computing type engine Presto is used as the underlying query engine. OLAP (On-Line Analytical Processing), which is online Analytical Processing, has the main functions of facilitating large-scale data analysis and statistical calculation, and providing reference and support for decision. Currently, the mainstream open source OLAP engines on the market include but are not limited to: hive, Spark SQL, Presto, Kylin, Impala, drive, Clickhouse, greenply and the like, and at present, no engine can perfectly achieve data size, flexibility degree and performance, and a user needs to select types according to own requirements.
In a preferred embodiment, each OLAP engine is accessed through JDBC, a uniform query interface is provided for the front end, the query request is converted into sql, and a corresponding appropriate OLAP engine can be selected according to different demand scenarios. JDBC generally refers to Java database connections. Java Database Connectivity (JDBC) is an application program interface in Java language that specifies how client programs access databases, providing methods such as querying and updating data in databases. JDBC is also a trademark of Sun Microsystems. JDBC is generally referred to as relational database oriented. SQL is a standard computer language for accessing and processing databases.
In a preferred embodiment, the request parameters are subjected to matching check and parameterization processing, and the request is subjected to authority check.
In a preferred embodiment, the Kylin OLAP engine is used for very large data volumes, tuned by Aggregation Groups. According to the dimension combination concerned by the user, the user can divide the large combination classes concerned by the user, and the large classes are called Aggregation Groups (Aggregation Groups) in the Apache Kylin.
In a preferred embodiment, the way of performing separate query and re-aggregation calculations on multiple tables simultaneously matches indices containing complex calculations.
In a preferred embodiment, the method further comprises the following steps:
s130, checking and accepting the internal check and the external service; and
and S140, the online report is used by business personnel.
In order to meet the data viewing requirements of users with various levels and different roles, the invention needs to enable the report to simultaneously support a plurality of indexes, screening options and drilling dimensions, and for scenes with complicated calculated indexes and large data volume, how to ensure the response speed of the report to meet the requirements of the users is the biggest problem faced by people.
In the technical scheme of the invention, a big data OLAP engine Kylin \ Clickhouse \ Presto is used as a bottom query engine. And accessing each OLAP engine in a JDBC mode, providing a uniform query interface for the front end, converting the query request into sql, and selecting the corresponding appropriate OLAP engine according to different demand scenes. And matching verification and parameterization processing are carried out on the request parameters, so that the sql is prevented from being injected with a vulnerability. And performing authority verification on the request to prevent data from being acquired without authorization. The interface supports a mode of respectively inquiring and then aggregating calculation on a plurality of tables at the same time to meet some indexes containing complex calculation. For the huge data volume, a Kylin OLAP engine is used, Cube construction speed is reduced through Aggregation Groups tuning, and query performance of frequently used functional scenes is improved through adding subset cubes.
The system adopts a B/S architecture, a user accesses the system through a browser, and the overall report flow is as follows:
(1) and configuring a data set, binding the data set through the data set function according to the table developed by the data warehouse, setting dimensionality and indexes required by the subsequent report form creation, and supporting the data preview.
(2) Configuring a report according to a dataset includes the following modules:
(2.1) configuring a screening item module;
(2.2) configuring an index module;
(2.3) configuring an icon display module;
(2.4) storing the report and setting a report storage position;
and (2.5) setting the menu authority and the data authority of the report.
(3) Internal verification and external service acceptance.
(4) The online report is used by business personnel.
By the system, the online change of the report form into warehouse development is directly configured based on the data table, so that the development human resources of the customized report form are saved, and the response speed of the report form requirement is improved; by adopting the big data distributed OLAP engine, a good query experience can be provided for some complex reports with large data volumes.
FIG. 2 is a block diagram of a system for generating a visual data analytics report in accordance with the present invention. As shown in fig. 2, the system 5 for generating a visual data analysis report according to the present invention is configured to implement the method for generating a visual data analysis report, and the system for generating a visual data analysis report includes:
and the configuration data set module 51 is used for binding through a data set function according to the data tables developed by the data warehouse, setting dimensionality and indexes required by the subsequent report form creation, and supporting the data preview.
A report configuration module 52, which configures the report according to the data set configuration, configures the filtering item module, the index configuration module, the icon configuration display module, and the report saving module, and sets the report storing position; and setting menu authority and data authority of the report.
And a check and acceptance module 53, which performs internal check and external service acceptance.
And a report on-line module 54, which enables the business personnel to use the report on line.
The generation system of the visual data analysis report can provide the capability of dynamically creating the visual report, provide a unified and standardized visual analysis report, reduce the workload of customized report development, improve the response timeliness of requirements, and meet the requirements of services.
The embodiment of the invention also provides a generation device of the visual data analysis report, which comprises a processor. A memory having stored therein executable instructions of the processor. Wherein the processor is configured to perform the steps of the method of generating a visual data analytics report via execution of the executable instructions.
As shown above, the generation system of the visual data analysis report according to the embodiment of the present invention can provide the capability of dynamically creating a visual report, provide a unified and standardized visual analysis report, reduce the workload of developing a customized report, improve the response timeliness of the demand, and meet the requirements of the business, and solve the problem that a big data calculation scenario that cannot be met by a conventional relational database meets the flexibility and timeliness of the business requirements based on a big data distributed OLAP engine.
As will be appreciated by one skilled in the art, aspects of the present invention may be embodied as a system, method or program product. Thus, various aspects of the invention may be embodied in the form of: an entirely hardware embodiment, an entirely software embodiment (including firmware, microcode, etc.) or an embodiment combining hardware and software aspects that may all generally be referred to herein as a "circuit," module "or" platform.
FIG. 3 is a schematic structural diagram of a generation device of a visual data analysis report according to the present invention. An electronic device 600 according to this embodiment of the invention is described below with reference to fig. 3. The electronic device 600 shown in fig. 3 is only an example and should not bring any limitation to the functions and the scope of use of the embodiments of the present invention.
As shown in fig. 3, the electronic device 600 is embodied in the form of a general purpose computing device. The components of the electronic device 600 may include, but are not limited to: at least one processing unit 610, at least one memory unit 620, a bus 630 connecting the different platform components (including the memory unit 620 and the processing unit 610), a display unit 640, etc.
Wherein the storage unit stores program code executable by the processing unit 610 to cause the processing unit 610 to perform steps according to various exemplary embodiments of the present invention described in the above-mentioned electronic prescription flow processing method section of the present specification. For example, processing unit 610 may perform the steps as shown in fig. 1.
The storage unit 620 may include readable media in the form of volatile memory units, such as a random access memory unit (RAM)6201 and/or a cache memory unit 6202, and may further include a read-only memory unit (ROM) 6203.
The memory unit 620 may also include a program/utility 6204 having a set (at least one) of program modules 6205, such program modules 6205 including, but not limited to: an operating system, one or more application programs, other program modules, and program data, each of which, or some combination thereof, may comprise an implementation of a network environment.
The electronic device 600 may also communicate with one or more external devices 700 (e.g., keyboard, pointing device, bluetooth device, etc.), with one or more devices that enable a user to interact with the electronic device 600, and/or with any devices (e.g., router, modem, etc.) that enable the electronic device 600 to communicate with one or more other computing devices. Such communication may occur via an input/output (I/O) interface 650. Also, the electronic device 600 may communicate with one or more networks (e.g., a Local Area Network (LAN), a Wide Area Network (WAN), and/or a public network such as the Internet) via the network adapter 660. The network adapter 660 may communicate with other modules of the electronic device 600 via the bus 630. It should be appreciated that although not shown in the figures, other hardware and/or software modules may be used in conjunction with the electronic device 600, including but not limited to: microcode, device drivers, redundant processing units, external disk drive arrays, RAID systems, tape drives, and data backup storage platforms, to name a few.
The embodiment of the invention also provides a computer-readable storage medium for storing the program, and the steps of the method for generating the visual data analysis report are realized when the program is executed. In some possible embodiments, the aspects of the present invention may also be implemented in the form of a program product comprising program code for causing a terminal device to perform the steps according to various exemplary embodiments of the present invention described in the above-mentioned electronic prescription flow processing method section of this specification, when the program product is run on the terminal device.
As shown above, the generation system of the visual data analysis report according to the embodiment of the present invention can provide the capability of dynamically creating a visual report, provide a unified and standardized visual analysis report, reduce the workload of developing a customized report, improve the response timeliness of the demand, and meet the requirements of the business, and solve the problem that a big data calculation scenario that cannot be met by a conventional relational database meets the flexibility and timeliness of the business requirements based on a big data distributed OLAP engine.
Fig. 4 is a schematic structural diagram of a computer-readable storage medium of the present invention. Referring to fig. 4, a program product 800 for implementing the above method according to an embodiment of the present invention is described, which may employ a portable compact disc read only memory (CD-ROM) and include program code, and may be run on a terminal device, such as a personal computer. However, the program product of the present invention is not limited in this regard and, in the present document, a readable storage medium may be any tangible medium that can contain, or store a program for use by or in connection with an instruction execution system, apparatus, or device.
The program product may employ any combination of one or more readable media. The readable medium may be a readable signal medium or a readable storage medium. A readable storage medium may be, for example, but not limited to, an electronic, magnetic, optical, electromagnetic, infrared, or semiconductor system, apparatus, or device, or any combination of the foregoing. More specific examples (a non-exhaustive list) of the readable storage medium include: an electrical connection having one or more wires, a portable disk, a hard disk, a Random Access Memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), an optical fiber, a portable compact disc read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the foregoing.
A computer readable storage medium may include a propagated data signal with readable program code embodied therein, for example, in baseband or as part of a carrier wave. Such a propagated data signal may take many forms, including, but not limited to, electro-magnetic, optical, or any suitable combination thereof. A readable storage medium may also be any readable medium that is not a readable storage medium and that can communicate, propagate, or transport a program for use by or in connection with an instruction execution system, apparatus, or device. Program code embodied on a readable storage medium may be transmitted using any appropriate medium, including but not limited to wireless, wireline, optical fiber cable, RF, etc., or any suitable combination of the foregoing.
Program code for carrying out operations for aspects of the present invention may be written in any combination of one or more programming languages, including an object oriented programming language such as Java, C + + or the like and conventional procedural programming languages, such as the "C" programming language or similar programming languages. The program code may execute entirely on the user's computing device, partly on the user's device, as a stand-alone software package, partly on the user's computing device and partly on a remote computing device, or entirely on the remote computing device or server. In the case of a remote computing device, the remote computing device may be connected to the user computing device through any kind of network, including a Local Area Network (LAN) or a Wide Area Network (WAN), or may be connected to an external computing device (e.g., through the internet using an internet service provider).
In summary, the present invention is directed to a method, a system, a device and a storage medium for generating a visual data analysis report, which can provide a capability of dynamically creating a visual report, provide a unified and standardized visual analysis report, reduce workload of customized report development, improve response timeliness of demand, and meet requirements of services, and solve flexibility and timeliness of meeting requirements of services in a big data computing scenario that cannot be met by a conventional relational database based on a big data distributed OLAP engine.
The foregoing is a more detailed description of the invention in connection with specific preferred embodiments and it is not intended that the invention be limited to these specific details. For those skilled in the art to which the invention pertains, several simple deductions or substitutions can be made without departing from the spirit of the invention, and all shall be considered as belonging to the protection scope of the invention.
Claims (10)
1. A method for generating a visual data analysis report is characterized by comprising the following steps:
s110, configuring a data set, binding through a data set function according to a data table developed by a data warehouse, setting dimensionality and indexes required by subsequent report form creation, and supporting data preview;
s120, configuring a report according to the data set, and comprising the following steps:
s121, configuring a screening item module;
s122, configuring an index module;
s123, configuring an icon display module;
s124, saving the report, and setting a report storage position; and
and S125, setting menu authority and data authority for the report.
2. The method of claim 1, wherein one of a big data OLAP analysis type data warehouse Kylin, a column type storage database Clickhouse, and a memory computing type engine Presto is used as the underlying query engine.
3. The method for generating a visual data analysis report according to claim 1, wherein each OLAP engine is accessed through JDBC, a uniform query interface is provided for the front end, the query request is converted into sql, and a corresponding appropriate OLAP engine can be selected according to different demand scenarios.
4. The method for generating a visual data analysis report according to claim 1, wherein the request parameter is subjected to matching verification and parameterization, and the request is subjected to authority verification.
5. The method for generating a visual data analysis report according to claim 1, wherein said method uses Kylin OLAP engine for huge data volume, and is optimized by Aggregation Groups.
6. The method for generating a visual data analysis report according to claim 1, wherein the index containing complex calculations is matched in a manner of performing respective query and re-aggregation calculations on a plurality of tables at the same time.
7. The method for generating a visual data analysis report according to claim 1, further comprising the steps of:
s130, checking and accepting the internal check and the external service; and
and S140, the online report is used by business personnel.
8. A system for generating a visual data analysis report, which is used for implementing the method for generating a visual data analysis report according to claim 1, and comprises:
the data set configuration module is used for binding through a data set function according to the data tables developed by the data warehouse, setting dimensionality and indexes required by the subsequent report form creation, and supporting the data preview;
the report configuration module is used for configuring a report according to the data set, configuring the screening item module, the index configuration module, the icon configuration display module and the report storage module, and setting the storage position of the report; and setting menu authority and data authority of the report.
9. A generation device for a visual data analysis report is characterized by comprising:
a processor;
a memory having stored therein executable instructions of the processor;
wherein the processor is configured to perform the steps of the method of generating a visual data analytics report of any one of claims 1 to 7 via execution of the executable instructions.
10. A computer-readable storage medium storing a program, wherein the program is executed to implement the steps of the method for generating a visual data analysis report according to any one of claims 1 to 7.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110368003.0A CN112949269A (en) | 2021-04-06 | 2021-04-06 | Method, system, equipment and storage medium for generating visual data analysis report |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110368003.0A CN112949269A (en) | 2021-04-06 | 2021-04-06 | Method, system, equipment and storage medium for generating visual data analysis report |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN112949269A true CN112949269A (en) | 2021-06-11 |
Family
ID=76230727
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202110368003.0A Pending CN112949269A (en) | 2021-04-06 | 2021-04-06 | Method, system, equipment and storage medium for generating visual data analysis report |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN112949269A (en) |
Cited By (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113407587A (en) * | 2021-07-19 | 2021-09-17 | 北京百度网讯科技有限公司 | Data processing method, device and equipment for online analysis processing engine |
| CN113642300A (en) * | 2021-07-30 | 2021-11-12 | 南京星云数字技术有限公司 | Report generation method and device, electronic equipment and computer readable medium |
| CN113742342A (en) * | 2021-08-30 | 2021-12-03 | 欧电云信息科技(江苏)有限公司 | Display method, display system, electronic device and storage medium of multi-source data |
| CN113779641A (en) * | 2021-09-02 | 2021-12-10 | 新奥数能科技有限公司 | Data configuration method and device, computer equipment and computer readable storage medium |
Citations (11)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20070179975A1 (en) * | 2006-01-31 | 2007-08-02 | Microsoft Corporation | Report generation using metadata |
| CN101477526A (en) * | 2008-12-31 | 2009-07-08 | 中兴通讯股份有限公司 | Method and system for implementing statistical forms customization |
| CN102841938A (en) * | 2012-08-14 | 2012-12-26 | 北京久其软件股份有限公司 | Method and system for generating parameterized report |
| CN105260476A (en) * | 2015-11-06 | 2016-01-20 | 上海熙菱信息技术有限公司 | Self-defined configuration method and system for reports |
| CN105808228A (en) * | 2014-12-31 | 2016-07-27 | 青岛中科软件股份有限公司 | Generation method of dynamic configuration statement |
| CN105843821A (en) * | 2015-01-16 | 2016-08-10 | 腾讯科技（深圳）有限公司 | Data processing method and system capable of configuring reports |
| CN106528514A (en) * | 2016-10-31 | 2017-03-22 | 山东鲁能软件技术有限公司 | Report generation system and method |
| CN107704608A (en) * | 2017-10-17 | 2018-02-16 | 北京览群智数据科技有限责任公司 | A kind of OLAP multidimensional analyses and data digging system |
| US20180275845A1 (en) * | 2017-03-23 | 2018-09-27 | International Business Machines Corporation | Dashboard Creation With Popular Patterns and Suggestions Using Analytics |
| CN110728126A (en) * | 2019-10-24 | 2020-01-24 | 北京新氧万维科技咨询有限公司 | Report generation method, device and equipment |
| CN112417838A (en) * | 2020-12-18 | 2021-02-26 | 北京易车互联信息技术有限公司 | Configurable automated reporting system |
-
2021
- 2021-04-06 CN CN202110368003.0A patent/CN112949269A/en active Pending
Patent Citations (11)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20070179975A1 (en) * | 2006-01-31 | 2007-08-02 | Microsoft Corporation | Report generation using metadata |
| CN101477526A (en) * | 2008-12-31 | 2009-07-08 | 中兴通讯股份有限公司 | Method and system for implementing statistical forms customization |
| CN102841938A (en) * | 2012-08-14 | 2012-12-26 | 北京久其软件股份有限公司 | Method and system for generating parameterized report |
| CN105808228A (en) * | 2014-12-31 | 2016-07-27 | 青岛中科软件股份有限公司 | Generation method of dynamic configuration statement |
| CN105843821A (en) * | 2015-01-16 | 2016-08-10 | 腾讯科技（深圳）有限公司 | Data processing method and system capable of configuring reports |
| CN105260476A (en) * | 2015-11-06 | 2016-01-20 | 上海熙菱信息技术有限公司 | Self-defined configuration method and system for reports |
| CN106528514A (en) * | 2016-10-31 | 2017-03-22 | 山东鲁能软件技术有限公司 | Report generation system and method |
| US20180275845A1 (en) * | 2017-03-23 | 2018-09-27 | International Business Machines Corporation | Dashboard Creation With Popular Patterns and Suggestions Using Analytics |
| CN107704608A (en) * | 2017-10-17 | 2018-02-16 | 北京览群智数据科技有限责任公司 | A kind of OLAP multidimensional analyses and data digging system |
| CN110728126A (en) * | 2019-10-24 | 2020-01-24 | 北京新氧万维科技咨询有限公司 | Report generation method, device and equipment |
| CN112417838A (en) * | 2020-12-18 | 2021-02-26 | 北京易车互联信息技术有限公司 | Configurable automated reporting system |
Cited By (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113407587A (en) * | 2021-07-19 | 2021-09-17 | 北京百度网讯科技有限公司 | Data processing method, device and equipment for online analysis processing engine |
| CN113407587B (en) * | 2021-07-19 | 2023-10-27 | 北京百度网讯科技有限公司 | Data processing method, device and equipment for online analysis processing engine |
| CN113642300A (en) * | 2021-07-30 | 2021-11-12 | 南京星云数字技术有限公司 | Report generation method and device, electronic equipment and computer readable medium |
| CN113742342A (en) * | 2021-08-30 | 2021-12-03 | 欧电云信息科技(江苏)有限公司 | Display method, display system, electronic device and storage medium of multi-source data |
| CN113779641A (en) * | 2021-09-02 | 2021-12-10 | 新奥数能科技有限公司 | Data configuration method and device, computer equipment and computer readable storage medium |
| CN113779641B (en) * | 2021-09-02 | 2024-03-05 | 新奥数能科技有限公司 | Data configuration method, device, computer equipment and computer readable storage medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US11163739B2 (en) | Database table format conversion based on user data access patterns in a networked computing environment | |
| US20230315730A1 (en) | Self-service data platform | |
| US10169433B2 (en) | Systems and methods for an SQL-driven distributed operating system | |
| CN110795509B (en) | Method and device for constructing index blood-margin relation graph of data warehouse and electronic equipment | |
| CN1713179B (en) | Impact analysis in an object model | |
| US9418101B2 (en) | Query optimization | |
| CN112949269A (en) | Method, system, equipment and storage medium for generating visual data analysis report | |
| KR20200106950A (en) | Dimensional context propagation techniques for optimizing SQL query plans | |
| US20180165347A1 (en) | Multi-dimensional analysis using named filters | |
| US20090248651A1 (en) | Apparatus and method for maintaining metadata version awareness during set evaluation for olap hierarchies | |
| US11200231B2 (en) | Remote query optimization in multi data sources | |
| US10157234B1 (en) | Systems and methods for transforming datasets | |
| US10936640B2 (en) | Intelligent visualization of unstructured data in column-oriented data tables | |
| CN110795478A (en) | Data warehouse updating method and device applied to financial business and electronic equipment | |
| CN110807016A (en) | Data warehouse construction method and device applied to financial business and electronic equipment | |
| EP4150484A1 (en) | Efficient indexing for querying arrays in databases | |
| CN112181962A (en) | Report form checking method, device, equipment and storage medium | |
| US20170262507A1 (en) | Feedback mechanism for query execution | |
| US11669538B1 (en) | Systems, devices, and methods for data analytics | |
| US9460139B2 (en) | Distributed storage system with pluggable query processing | |
| CN115803729A (en) | Direct data loading of middleware generated records | |
| CN112069185B (en) | Index construction method and device, electronic equipment and medium | |
| US11023485B2 (en) | Cube construction for an OLAP system | |
| US11586604B2 (en) | In-memory data structure for data access | |
| CN114461716A (en) | Data loading method and device, storage medium and electronic equipment |
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 |