CN108572945A - Create method, system, storage medium and the electronic equipment of report - Google Patents
Create method, system, storage medium and the electronic equipment of report Download PDFInfo
- Publication number
- CN108572945A CN108572945A CN201810195718.9A CN201810195718A CN108572945A CN 108572945 A CN108572945 A CN 108572945A CN 201810195718 A CN201810195718 A CN 201810195718A CN 108572945 A CN108572945 A CN 108572945A
- Authority
- CN
- China
- Prior art keywords
- report
- data
- query
- sql
- attribute
- 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
- 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
Abstract
The present invention provides method, system, storage medium and the electronic equipment for creating report.It is described create report method include:Acquire the essential information of report yet to be built;The essential information includes:SQL query statement;The data for extracting one or more table fields are concentrated from pre-stored data according to the SQL query statement;The attribute information of one or more of table fields is acquired, and the attribute of one or more of table fields is configured to create report according to the attribute information.The present invention, which helps to integrate the data source of multiple business platforms to avoid quickly to create report needed for user when traditional report creates, needs the troublesome operation of data inputting one by one, while being also convenient for user and can check, extract and analytical statement data at any time.
Description
Technical field
The present invention relates to computer software fields, more particularly to the method for establishment report, system, storage medium, electronics
Equipment.
Background technology
There are a large amount of inventory extraction, verification of data, interim report, by hand this kind of demand data of statistics, enterprises in enterprise
It is more that IT resources expend resource in this respect, and excessively relies on personnel's individual capability, using outsourcing service provider, part
This demand data is alleviated, but can not fundamentally solve the problems, such as this, prodigious burden is brought to enterprise.
The data of enterprise are greatly mostly from different operation systems at present, and are difficult to be integrated between each operation system, industry
Business personnel need frequently to log in different operation systems to obtain related statements in real time, inevitably occur that data are inconsistent etc. to ask
Topic.As it can be seen that being currently badly in need of a business platform independently of operation system, the multiple data sources of integration to solve administrative staff's record
Enter, check the cumbersome and inconvenient problem of all kinds of bordereaus, to facilitate business personnel that can check, extract and analyze whenever and wherever possible
Report data.
Invention content
In view of the foregoing deficiencies of prior art, the purpose of the present invention is to provide create the method for report, system, deposit
Storage media, electronic equipment, for solving the above problem in the prior art.
In order to achieve the above objects and other related objects, the present invention provides a kind of method creating report, including:Acquisition waits for
Build the essential information of report;The essential information includes:SQL query statement;According to the SQL query statement from pre-stored data collection
In extract the data of one or more table fields;Acquire the attribute information of one or more of table fields, and according to
The attribute information configures the attribute of one or more of table fields to create report.
In one embodiment of the invention, the essential information further includes:To limit the script sentence of query context;It is described
Method further includes:According to the script sentence limit the pre-stored data collection can query context, and in the inquiry of the restriction
The data of one or more fields are extracted in range according to the SQL query statement.
In one embodiment of the invention, data are extracted according to the SQL query statement in the query context of the restriction
Before, the method further includes:The step of examining the SQL statement correctness.
In one embodiment of the invention, the method further includes:Define the query argument of the report;The query argument
For providing that the report according to keywords inquires the rule searching of data.
In order to achieve the above objects and other related objects, the present invention provides a kind of system creating report, including:Basic letter
Cease acquisition module, the essential information for acquiring report yet to be built;The essential information includes:SQL query statement;Field data carries
Modulus block, for concentrating the data for extracting one or more table fields from pre-stored data according to the SQL query statement;Word
Section attribute configuration module, the attribute information for acquiring one or more of table fields, and matched according to the attribute information
The attribute of one or more of table fields is set to create report.
In one embodiment of the invention, the essential information further includes:To limit the script sentence of query context;It is described
Field data extraction module is additionally operable to:According to the script sentence limit the pre-stored data collection can query context, and in institute
State the data for extracting one or more fields in the query context of restriction according to the SQL query statement.
In one embodiment of the invention, the field data extraction module is additionally operable to:In the query context of the restriction
Before extracting data according to the SQL query statement, the SQL statement correctness is examined.
In one embodiment of the invention, the system also includes:Query argument definition module, for defining the report
Query argument;The query argument is for providing that the report according to keywords inquires the rule searching of data.
In order to achieve the above objects and other related objects, the present invention provides a kind of storage medium, wherein being stored with computer
Program when the computer program is by processor load and execution, realizes as above any method for creating report.
In order to achieve the above objects and other related objects, the present invention provides a kind of electronic equipment, including:Processor and storage
Device;Wherein, the memory is for storing computer program;The processor is used for computer program described in load and execution, with
The method for making the electronic equipment execute as above any establishment report.
As described above, method, system, storage medium and the electronic equipment of the establishment report of the present invention, acquire report yet to be built
Essential information;The essential information includes:SQL query statement;It is concentrated and is extracted from pre-stored data according to the SQL query statement
Go out the data of one or more table fields;The attribute information of one or more of table fields is acquired, and according to the category
The attribute of the property one or more of table fields of information configuration is to create report.The establishment method of report of the present invention, system,
Storage medium and electronic equipment help to integrate the data source of multiple business platforms, quickly to create report needed for user, to keep away
Exempt to need the troublesome operation of data inputting one by one when traditional report creates, while being also convenient for user's looking at any time to the data of report
It sees, extract and analyzes.
Description of the drawings
Fig. 1 is shown as the flow diagram of the method for the establishment report in one embodiment of the invention.
Fig. 2 is shown as the human-computer interaction interface signal of the essential information of the acquisition report yet to be built in one embodiment of the invention
Figure.
Fig. 3 is shown as the schematic diagram of the human-computer interaction interface of the acquisition field attribute information in one embodiment of the invention.
Fig. 4 is shown as the module diagram of the system of the establishment report in one embodiment of the invention.
Component label instructions
S11~S13 steps
41 essential information acquisition modules
42 field data extraction modules
43 field attribute configuration modules
Specific implementation mode
Illustrate that embodiments of the present invention, those skilled in the art can be by this specification below by way of specific specific example
Disclosed content understands other advantages and effect of the present invention easily.The present invention can also pass through in addition different specific realities
The mode of applying is embodied or practiced, the various details in this specification can also be based on different viewpoints with application, without departing from
Various modifications or alterations are carried out under the spirit of the present invention.It should be noted that in the absence of conflict, following embodiment and implementation
Feature in example can be combined with each other.
It should be noted that the diagram provided in following embodiment only illustrates the basic structure of the present invention in a schematic way
Think, component count, shape and size when only display is with related component in the present invention rather than according to actual implementation in schema then
Draw, when actual implementation kenel, quantity and the ratio of each component can be a kind of random change, and its assembly layout kenel
It is likely more complexity.
Referring to Fig. 1, the embodiment of the present invention provides a kind of method creating report, this method has broken traditional establishment report
Table needs the hard work amount of logging data one by one, largely improves report and creates efficiency and accuracy, and can create
Facilitate checking, extract and analyzing for user personnel after building.The method of the establishment report of the present embodiment mainly includes the following steps:
S11:Acquire the essential information of report yet to be built.
With reference to figure 2, it is shown as a kind of human-computer interaction interface figure of the essential information of acquisition report yet to be built.Newly-built report is adopted
The essential information of collection includes:Report name, report abbreviation, version number, maximum statistics section, report coding, relevant department, report
Mode, control data permission item etc..Particularly, it need to includes SQL query statement to create the essential information that report is acquired, that is, is needed
User is wanted to key in SQL query statement in " query SQL " text box as shown in Figure 2 manually.The SQL query statement of key entry is usual
Define the range of data query and the object of data query.Optionally, in another embodiment, create what report was acquired
Essential information further includes limiting the script sentence of query context, that is, needs user manually in " script " text as shown in Figure 2
Script sentence is keyed in this frame.The script sentence of key entry generally defines SQL query statement and is inquired what pre-stored data was concentrated
Range.
S12:The data for extracting one or more table fields are concentrated from pre-stored data according to the SQL query statement.
It should be noted that the present embodiment incorporates several data sheets of multiple business platform to establish data in advance
Collection, the title of every data sheet are all recorded in comprising field name, comprising information such as data values in the data set.SQL query language
The purpose of sentence is exactly to extract target data from the data set.Such as:Pass through SQL query statement shown in Fig. 2, the meeting of this step
Be focused to find out " T_SYS_USER " report from data, and extract from the report " username ", " usernum ",
The related data of " email ", " c_agency_nme ", " c_branch_nme " this five fields.In another example:Shown in Fig. 2
Script sentence can be under the restriction of query context, this step can be according to SQL query statement from can find " T_SYS_ in query context
USER " reports, and " username ", " usernum ", " email ", " c_agency_nme ", " c_ are extracted from the report
The related data of this five fields of branch_nme ".
Optionally, in another embodiment, the SQL query statement correctness is first examined before executing this step.
This step is then executed when user has keyed in correct SQL query statement;Conversely, then user is prompted to key in SQL query statement again.
S13:The attribute information of one or more of table fields is acquired, and described one is configured according to the attribute information
The attribute of a or multiple table fields is to create report.
With reference to figure 3, it is shown as a kind of human-computer interaction interface figure of acquisition field attribute information, which show the SQL of Fig. 2 to look into
Ask the attributes letter such as five fields and this respective data type of five fields, display order, sortord that sentence is extracted
Breath.This step can configure each field according to configuration information input by user.For example, pass through human-computer interaction circle
Face, user can be that each field adds field Chinese name, as illustrated in the drawing " user ", " personal code work ", " mailbox ", " list
Position ", " department ".In addition to this, by the human-computer interaction interface, user can also determine the display order of each field, such as scheme
Shown in the display orders of this five fields be followed successively by:" user ", " personal code work ", " mailbox ", " unit ", " department " etc..
Report is produced after the attribute information that each field is determined, the data of different table fields but colleague in the report of generation
Between be associated with according to " display order " is corresponding.By taking Fig. 3 as an example, the correspondence incidence relation positioned at the data of same a line is:User-user
Code-mailbox-unit-department.
Optionally, in another embodiment, the query argument of report is also can define before creating report.The inquiry ginseng
Number is for providing that the report according to keywords inquires the rule searching of data.Specifically, the query argument includes:Be equal to,
Be not equal to, be less than (or being equal to), be more than (or being equal to) ... between ... among, include ..., with ... start, with ... terminate etc.
Operation rule.After defining query argument, if user wants that the keyword by input inquires dependency number in the report created
According to the embodiment can then inquire legal data according to the operation rule of the query argument of definition.Such as:Definition is looked into
The operation rule for asking parameter is "comprising", and the field of inquiry is " user name ", and the keyword of input is " horse ", then query result meeting
Include all data lines of " horse " in display " user name ", in addition to including " horse " in display username field in each data line
Data can also sequentially show colleague's data of other corresponding associated fields, as shown in table 1.
Table 1
User | Personal code work | Mailbox | Unit | Department |
Horse A | 1234 | XX | C companies | E departments |
B horses | 12345 | XXX | D companies | Nothing |
Fig. 4 is shown as schematic diagram of the system of the establishment report of the present invention in an embodiment.The system includes mainly:Base
It is fixed to further comprise query argument for this information acquisition module 41, field data extraction module 42, field attribute configuration module 43
Adopted module (being unillustrated).Since this system embodiment is corresponding identical as the principle of preceding method embodiment, so not right in this
Identical technical detail repeats.
Essential information acquisition module 41 acquires the essential information of report yet to be built;The essential information includes:SQL query language
Sentence, limiting the script sentence etc. of query context.
Field data extraction module 42 extracts one or more tables according to the SQL query statement from pre-stored data concentration
The data of lattice field.Optionally, in another embodiment, field data extraction module 42 is according to described in script sentence restriction
Pre-stored data collection can query context, and in the query context of the restriction according to the SQL query statement extract one or
The data of multiple table fields.Optionally, in another embodiment, it is looked into according to the SQL in the query context of the restriction
Before asking sentence extraction data, the SQL statement correctness is examined.
Field attribute configuration module 43 acquires the attribute information of one or more of table fields, and according to the attribute
The attribute of the one or more of table fields of information configuration is to create report.
Query argument definition module is used to define the query argument of the report;The query argument is for providing the report
Table according to keywords inquires the rule searching of data.
In addition to this, the invention also includes a kind of storage medium and a kind of electronic equipment, due to the skill in previous embodiment
Art feature can be applied to storage medium embodiment, electronic equipment embodiment, thus it is no longer repeated.
The storage medium includes:The various media that can store program code such as ROM, RAM, magnetic disc or CD,
In be stored with computer program, the computer program when by processor load and execution, realize previous embodiment in create report
Method all or part of step.
The electronic equipment be include processor (CPU/MCU/SOC), memory (ROM/RAM), communication module (it is wired/
Wireless network), the equipment of display module, preferably desktop computer.Particularly, it is stored with computer program in the memory, it should
Processor when computer program, realizes all or part of step for the method that report is created in previous embodiment described in load and execution
Suddenly.
In conclusion method, system, storage medium and the electronic equipment of the establishment report of the present invention, help to integrate more
The data source of a business platform quickly creates report needed for user, avoids the data inputting one by one that traditional report creates
Troublesome operation, while being also convenient for user and checking, extract and analytical statement data at any time, it effectively overcomes in the prior art various
Disadvantage and have high industrial utilization.
The above-described embodiments merely illustrate the principles and effects of the present invention, and is not intended to limit the present invention.It is any ripe
The personage for knowing this technology can all carry out modifications and changes to above-described embodiment without violating the spirit and scope of the present invention.Cause
This, institute is complete without departing from the spirit and technical ideas disclosed in the present invention by those of ordinary skill in the art such as
At all equivalent modifications or change, should by the present invention claim be covered.
Claims (10)
1. a kind of method creating report, which is characterized in that including:
Acquire the essential information of report yet to be built;The essential information includes:SQL query statement;
The data for extracting one or more table fields are concentrated from pre-stored data according to the SQL query statement;
The attribute information of one or more of table fields is acquired, and one or more of according to attribute information configuration
The attribute of table field is to create report.
2. according to the method described in claim 1, it is characterized in that, the essential information further includes:To limit query context
Script sentence;The method further includes:According to the script sentence limit the pre-stored data collection can query context, and
The data of one or more table fields are extracted in the query context of the restriction according to the SQL query statement.
3. according to the method described in claim 2, it is characterized in that, being looked into according to the SQL in the query context of the restriction
Before asking sentence extraction data, the method further includes:The step of examining the SQL statement correctness.
4. according to the method described in claim 1, it is characterized in that, further including:Define the query argument of the report;It is described to look into
Parameter is ask for providing that the report according to keywords inquires the rule searching of data.
5. a kind of system creating report, which is characterized in that including:
Essential information acquisition module, the essential information for acquiring report yet to be built;The essential information includes:SQL query statement;
Field data extraction module, for extracting one or more tables from pre-stored data concentration according to the SQL query statement
The data of lattice field;
Field attribute configuration module, the attribute information for acquiring one or more of table fields, and according to the attribute
The attribute of the one or more of table fields of information configuration is to create report.
6. system according to claim 5, which is characterized in that the essential information further includes:To limit query context
Script sentence;The field data extraction module is additionally operable to:According to the script sentence limit the pre-stored data collection can
Query context, and according to the data of the one or more fields of SQL query statement extraction in the query context of the restriction.
7. system according to claim 6, which is characterized in that the field data extraction module is additionally operable to:In the limit
Before extracting data according to the SQL query statement in fixed query context, the SQL statement correctness is examined.
8. system according to claim 5, which is characterized in that further include:Query argument definition module, it is described for defining
The query argument of report;The query argument is for providing that the report according to keywords inquires the rule searching of data.
9. a kind of storage medium, wherein being stored with computer program, which is characterized in that the computer program is loaded by processor
When execution, the method for creating report as described in any in Claims 1-4 is realized.
10. a kind of electronic equipment, which is characterized in that including:Processor and memory;Wherein,
The memory is for storing computer program;
The processor is for computer program described in load and execution, so that the electronic equipment is executed as in Claims 1-4
The method of any establishment report.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201810195718.9A CN108572945A (en) | 2018-03-09 | 2018-03-09 | Create method, system, storage medium and the electronic equipment of report |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201810195718.9A CN108572945A (en) | 2018-03-09 | 2018-03-09 | Create method, system, storage medium and the electronic equipment of report |
Publications (1)
Publication Number | Publication Date |
---|---|
CN108572945A true CN108572945A (en) | 2018-09-25 |
Family
ID=63576799
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201810195718.9A Pending CN108572945A (en) | 2018-03-09 | 2018-03-09 | Create method, system, storage medium and the electronic equipment of report |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN108572945A (en) |
Cited By (7)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN109492056A (en) * | 2018-10-24 | 2019-03-19 | 江苏满运软件科技有限公司 | A kind of method and system of business intelligence data inquiry |
CN110263314A (en) * | 2019-06-19 | 2019-09-20 | 北京明略软件系统有限公司 | Form processing method and device, storage medium, electronic device |
CN110347992A (en) * | 2019-07-10 | 2019-10-18 | 成都函夏科技有限公司 | Data analysing method and system based on electronic report forms |
CN110442595A (en) * | 2019-07-26 | 2019-11-12 | 南京南瑞继保电气有限公司 | A kind of method and apparatus of general SQL report data collection building |
CN110825944A (en) * | 2019-10-29 | 2020-02-21 | 深圳前海环融联易信息科技服务有限公司 | Webpage table data acquisition method and device, computer equipment and storage medium |
CN111159164A (en) * | 2020-01-16 | 2020-05-15 | 四川天翼网络服务有限公司 | Report data access authority control method based on parametric transfer |
CN111241053A (en) * | 2018-11-29 | 2020-06-05 | 中国移动通信集团四川有限公司 | Data table creating method, device, equipment and storage medium |
Citations (16)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US20050216830A1 (en) * | 2004-03-29 | 2005-09-29 | Turner Jeffrey S | Access tool to facilitate exchange of data to and from an end-user application software package |
US20070299823A1 (en) * | 2006-06-26 | 2007-12-27 | Microsoft Corporation | Customizable parameter user interface |
CN102163223A (en) * | 2011-04-02 | 2011-08-24 | 锐词文化发展(北京)有限公司 | Self-service query method and device thereof for background data |
CN103034681A (en) * | 2012-11-22 | 2013-04-10 | 用友软件股份有限公司 | Report generation device and report generation method |
CN103064689A (en) * | 2013-01-04 | 2013-04-24 | 大唐软件技术股份有限公司 | Implementation method and system for dynamically generating report pages |
CN104573065A (en) * | 2015-01-23 | 2015-04-29 | 广东能龙教育股份有限公司 | Report display engine based on metadata |
CN104572032A (en) * | 2013-10-09 | 2015-04-29 | 腾讯科技(深圳)有限公司 | Report creation method and electronic equipment |
CN105138501A (en) * | 2015-08-10 | 2015-12-09 | 北京思特奇信息技术股份有限公司 | Configurable dynamic report generating method and system |
CN105260476A (en) * | 2015-11-06 | 2016-01-20 | 上海熙菱信息技术有限公司 | Self-defined configuration method and system for reports |
CN105812430A (en) * | 2014-12-31 | 2016-07-27 | 金蝶软件(中国)有限公司 | Intelligent inquiry method for mobile terminal, mobile terminal and server |
CN105843945A (en) * | 2016-04-08 | 2016-08-10 | 联动优势科技有限公司 | Report generation method and system |
CN105930511A (en) * | 2016-05-12 | 2016-09-07 | 深圳市傲天科技股份有限公司 | Answer big data subscription platform |
CN106250501A (en) * | 2016-07-28 | 2016-12-21 | 五八同城信息技术有限公司 | Report processing method and reporting system |
CN106951430A (en) * | 2016-12-28 | 2017-07-14 | 金蝶软件(中国)有限公司 | Account table querying method and device |
CN107168940A (en) * | 2017-03-29 | 2017-09-15 | 长春市万易科技有限公司 | A kind of report generating system and method |
CN107480280A (en) * | 2017-08-22 | 2017-12-15 | 金蝶软件(中国)有限公司 | The method and relevant device of a kind of data processing |
-
2018
- 2018-03-09 CN CN201810195718.9A patent/CN108572945A/en active Pending
Patent Citations (16)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US20050216830A1 (en) * | 2004-03-29 | 2005-09-29 | Turner Jeffrey S | Access tool to facilitate exchange of data to and from an end-user application software package |
US20070299823A1 (en) * | 2006-06-26 | 2007-12-27 | Microsoft Corporation | Customizable parameter user interface |
CN102163223A (en) * | 2011-04-02 | 2011-08-24 | 锐词文化发展(北京)有限公司 | Self-service query method and device thereof for background data |
CN103034681A (en) * | 2012-11-22 | 2013-04-10 | 用友软件股份有限公司 | Report generation device and report generation method |
CN103064689A (en) * | 2013-01-04 | 2013-04-24 | 大唐软件技术股份有限公司 | Implementation method and system for dynamically generating report pages |
CN104572032A (en) * | 2013-10-09 | 2015-04-29 | 腾讯科技(深圳)有限公司 | Report creation method and electronic equipment |
CN105812430A (en) * | 2014-12-31 | 2016-07-27 | 金蝶软件(中国)有限公司 | Intelligent inquiry method for mobile terminal, mobile terminal and server |
CN104573065A (en) * | 2015-01-23 | 2015-04-29 | 广东能龙教育股份有限公司 | Report display engine based on metadata |
CN105138501A (en) * | 2015-08-10 | 2015-12-09 | 北京思特奇信息技术股份有限公司 | Configurable dynamic report generating method and system |
CN105260476A (en) * | 2015-11-06 | 2016-01-20 | 上海熙菱信息技术有限公司 | Self-defined configuration method and system for reports |
CN105843945A (en) * | 2016-04-08 | 2016-08-10 | 联动优势科技有限公司 | Report generation method and system |
CN105930511A (en) * | 2016-05-12 | 2016-09-07 | 深圳市傲天科技股份有限公司 | Answer big data subscription platform |
CN106250501A (en) * | 2016-07-28 | 2016-12-21 | 五八同城信息技术有限公司 | Report processing method and reporting system |
CN106951430A (en) * | 2016-12-28 | 2017-07-14 | 金蝶软件(中国)有限公司 | Account table querying method and device |
CN107168940A (en) * | 2017-03-29 | 2017-09-15 | 长春市万易科技有限公司 | A kind of report generating system and method |
CN107480280A (en) * | 2017-08-22 | 2017-12-15 | 金蝶软件(中国)有限公司 | The method and relevant device of a kind of data processing |
Cited By (11)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN109492056A (en) * | 2018-10-24 | 2019-03-19 | 江苏满运软件科技有限公司 | A kind of method and system of business intelligence data inquiry |
CN111241053A (en) * | 2018-11-29 | 2020-06-05 | 中国移动通信集团四川有限公司 | Data table creating method, device, equipment and storage medium |
CN111241053B (en) * | 2018-11-29 | 2022-08-23 | 中国移动通信集团四川有限公司 | Data table creating method, device, equipment and storage medium |
CN110263314A (en) * | 2019-06-19 | 2019-09-20 | 北京明略软件系统有限公司 | Form processing method and device, storage medium, electronic device |
CN110263314B (en) * | 2019-06-19 | 2023-07-11 | 北京明略软件系统有限公司 | Form processing method and device, storage medium and electronic device |
CN110347992A (en) * | 2019-07-10 | 2019-10-18 | 成都函夏科技有限公司 | Data analysing method and system based on electronic report forms |
CN110442595A (en) * | 2019-07-26 | 2019-11-12 | 南京南瑞继保电气有限公司 | A kind of method and apparatus of general SQL report data collection building |
CN110442595B (en) * | 2019-07-26 | 2022-07-22 | 南京南瑞继保电气有限公司 | Method and device for constructing universal SQL report data set |
CN110825944A (en) * | 2019-10-29 | 2020-02-21 | 深圳前海环融联易信息科技服务有限公司 | Webpage table data acquisition method and device, computer equipment and storage medium |
CN111159164A (en) * | 2020-01-16 | 2020-05-15 | 四川天翼网络服务有限公司 | Report data access authority control method based on parametric transfer |
CN111159164B (en) * | 2020-01-16 | 2024-01-30 | 四川天翼网络股份有限公司 | Report data access right control method based on parameterization transfer |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN108572945A (en) | Create method, system, storage medium and the electronic equipment of report | |
US9959311B2 (en) | Natural language interface to databases | |
US10042921B2 (en) | Robust and readily domain-adaptable natural language interface to databases | |
US20200233905A1 (en) | Systems and Methods for Data Analysis and Visualization Spanning Multiple Datasets | |
US9047346B2 (en) | Reporting language filtering and mapping to dimensional concepts | |
US8751216B2 (en) | Table merging with row data reduction | |
US10339038B1 (en) | Method and system for generating production data pattern driven test data | |
US20140100910A1 (en) | System and Method for Audits with Automated Data Analysis | |
US20120150820A1 (en) | System and method for testing data at a data warehouse | |
US20130166563A1 (en) | Integration of Text Analysis and Search Functionality | |
Petermann et al. | Graph-based data integration and business intelligence with BIIIG | |
US20150293947A1 (en) | Validating relationships between entities in a data model | |
US9110935B2 (en) | Generate in-memory views from universe schema | |
CN110427188B (en) | Configuration method, device, equipment and storage medium of single-test assertion program | |
Baumgartner et al. | Web data extraction for business intelligence: the lixto approach | |
US8260772B2 (en) | Apparatus and method for displaying documents relevant to the content of a website | |
US20160188685A1 (en) | Fan identity data integration and unification | |
US20180357278A1 (en) | Processing aggregate queries in a graph database | |
Passlick et al. | Self-service business intelligence and analytics application scenarios: A taxonomy for differentiation | |
CN113962597A (en) | Data analysis method and device, electronic equipment and storage medium | |
US10505873B2 (en) | Streamlining end-to-end flow of business-to-business integration processes | |
US20130262417A1 (en) | Graphical Representation and Automatic Generation of Iteration Rule | |
US20150363711A1 (en) | Device for rapid operational visibility and analytics automation | |
US20190129989A1 (en) | Automated Database Configurations for Analytics and Visualization of Human Resources Data | |
CN113157978B (en) | Data label establishing method and device |
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: 20180925 |
|
RJ01 | Rejection of invention patent application after publication |