CN106682064A - Number picking device and method for enterprise report - Google Patents
Number picking device and method for enterprise report Download PDFInfo
- Publication number
- CN106682064A CN106682064A CN201610955597.4A CN201610955597A CN106682064A CN 106682064 A CN106682064 A CN 106682064A CN 201610955597 A CN201610955597 A CN 201610955597A CN 106682064 A CN106682064 A CN 106682064A
- Authority
- CN
- China
- Prior art keywords
- function
- sql statement
- metadata
- enterprise report
- group
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Granted
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
- G06F16/2457—Query processing with adaptation to user needs
- G06F16/24573—Query processing with adaptation to user needs using data annotations, e.g. user-defined metadata
-
- 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/22—Indexing; Data structures therefor; Storage structures
- G06F16/2282—Tablespace storage structures; Management thereof
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Library & Information Science (AREA)
- Computational Linguistics (AREA)
- Software Systems (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention provides a number picking device and method for an enterprise report. The number picking device for the enterprise report comprises a metadata assembly, an arithmetic device assembly and an SQL actuator assembly. The metadata assembly is used for defining metadata in the business field. The arithmetic device assembly is used for dividing all function grids in the enterprise report into multiple groups according to the metadata, wherein the function grids in each group in the groups have the same query logic. The SQL actuator assembly is used for executing multiple SQL statements of the groups, wherein the SQL statements correspond to the groups one to one. The arithmetic device assembly is further used for displaying the executing results of the SQL statements according to the format of the enterprise report. According to the technical scheme, the number picking efficiency of the enterprise report can be improved, and the development difficulty of the enterprise report can be reduced.
Description
Technical field
The present invention relates to ERP (Enterprise Resource Planning) systems technology field, in particular to
A kind of peek device of enterprise report and a kind of access method of enterprise report.
Background technology
Common ERP system has various enterprise reports, and the query logic of each enterprise report is extremely multiple
It is miscellaneous, generally comprise in enterprise report many peeks function grid (or referred to as grid, because grid represents a function,
Therefore referred to as function grid).To peek from enterprise report, in the related, as shown in figure 1, obtaining enterprise's report first
All function grid (abbreviation grid in Fig. 1) in table, all function grid of searching loop, the inquiry for each function grid is patrolled
Spelling SQL (Structured Query Language, SQL) sentence is collected, SQL statement is finally performed.Entirely
Process needs circulation execution SQL statement many times, and function grid is more, performance issue more easily occurs.While each business
Field is required for overlapping development to be adapted to the framework of enterprise report to make the enterprise report of oneself, and workload is huge.
Therefore, how to improve the peek efficiency of enterprise report, and reduce the development difficulty of enterprise report becomes and urgently solves
Problem certainly.
The content of the invention
The present invention is based on the problems referred to above, it is proposed that a kind of new technical scheme, can improve the peek of enterprise report
Efficiency, and reduce the development difficulty of enterprise report.
In view of this, a first aspect of the present invention proposes a kind of peek device of enterprise report, including:Metadata group
Part, for defining the metadata of business scope;Computing device assembly, for according to the metadata by the institute in the enterprise report
There is function grid to be divided into multiple groups, wherein, the function grid in each group in the plurality of group has identical query logic;
SQL actuator assemblies, for performing the plurality of group of a plurality of SQL statement, wherein, a plurality of SQL statement with it is the plurality of
Group is corresponded;The computing device assembly is additionally operable to, and according to the form of the enterprise report, a plurality of SQL statement is held
Row result is shown.
In the technical scheme, it is grouped by all function grid in enterprise report, each group of correspondence one
SQL statement, perform the corresponding SQL statement of multiple groups of difference and be capable of achieving to be peeked from enterprise report, it is to avoid in correlation technique
The all function grid of execution in each function grid SQL statement, so as to greatly reduce the number of times for performing SQL statement,
The peek efficiency of enterprise report is so not only increased, is also avoided the number of times due to performing SQL statement excessive and is caused treatability
Can decline.In addition, this programme supports that the framework of the enterprise report of any ERP system is accessed, so as to reduce opening for enterprise report
Degree of raising difficult questions.
In above-mentioned technical proposal, it is preferable that the computing device assembly includes:Parallel computation scheduling engine, if opening institute
Parallel computation scheduling engine is stated, then the parallel computation scheduling engine controls many described in the SQL actuator assemblies executed in parallel
Bar SQL statement;If or do not open the parallel computation scheduling engine, the SQL actuator assemblies serial performs described many
Bar SQL statement.
In the technical scheme, a plurality of SQL statement of parallel computation scheduling engine control SQL actuator assembly executed in parallel,
Further increasing the peek efficiency of enterprise report.It is of course also possible to serial performs a plurality of SQL statement.Or according to user
Actual demand, hardware case perform a plurality of SQL statement determining parallel or serial.
In any of the above-described technical scheme, it is preferable that the SQL actuator assemblies are additionally operable to, modification instruction, modification are received
The SQL statement of arbitrary group in the plurality of group.
In the technical scheme, by arbitrary group of SQL statement of modification, for example, by arbitrary group of inquiry sales data
SQL statement is revised as inquiring about the SQL statement of sales data and procurement data, the as reserved extension mechanism of user, right so as to facilitate
SQL statement carries out dynamic expansion to meet the demand of user.
In any of the above-described technical scheme, it is preferable that also include:Function component, for storing and encapsulating a plurality of SQL
The implementing result of sentence.
In the technical scheme, the implementing result of a plurality of SQL statement is stored and encapsulated by function component, with realize by
Implementing result is displayed on the interface of enterprise report.
In any of the above-described technical scheme, it is preferable that the metadata includes:Function metadata and parameter metadata, its
In, the function metadata includes one below or various combinations:Function description, function definition, function prompting, function are crucial
Word, function packet condition, the parameter metadata includes one below or various combinations:The species of functional query condition, letter
Number querying conditions type, whether be grouped, type of database.
In the technical scheme, by the metadata for defining the above, will be patrolled with identical inquiry according to the metadata
In the same set, group one SQL statement of correspondence performs the secondary of SQL statement to the function grid point collected so as to greatly reduce
Number, is effectively improved the efficiency peeked from enterprise report.
A second aspect of the present invention proposes a kind of access method of enterprise report, including:Define first number of business scope
According to;The all function grid in the enterprise report are divided into multiple groups according to the metadata, wherein, in the plurality of group
Function grid in each group has identical query logic;The plurality of group of a plurality of SQL statement is performed, wherein, it is described many
Bar SQL statement and the plurality of group of one-to-one corresponding;According to the form of the enterprise report, the execution to a plurality of SQL statement
As a result shown.
In the technical scheme, it is grouped by all function grid in enterprise report, each group of correspondence one
SQL statement, perform the corresponding SQL statement of multiple groups of difference and be capable of achieving to be peeked from enterprise report, it is to avoid in correlation technique
The all function grid of execution in each function grid SQL statement, so as to greatly reduce the number of times for performing SQL statement,
The peek efficiency of enterprise report is so not only increased, is also avoided the number of times due to performing SQL statement excessive and is caused treatability
Can decline.In addition, this programme supports that the framework of the enterprise report of any ERP system is accessed, so as to reduce opening for enterprise report
Degree of raising difficult questions.
In above-mentioned technical proposal, it is preferable that a plurality of SQL statement described in executed in parallel;Or serial execution is described a plurality of
SQL statement.
In the technical scheme, SQL actuator assemblies can further increasing enterprise with a plurality of SQL statement of executed in parallel
The peek efficiency of retribution for sins table.It is of course also possible to serial performs a plurality of SQL statement.Or according to user actual demand, hardware feelings
Condition performs a plurality of SQL statement determining parallel or serial.
In any of the above-described technical scheme, it is preferable that also include:Modification instruction is received, appointing in the plurality of group is changed
One group of SQL statement.
In the technical scheme, by arbitrary group of SQL statement of modification, for example, by arbitrary group of inquiry sales data
SQL statement is revised as inquiring about the SQL statement of sales data and procurement data, the as reserved extension mechanism of user, right so as to facilitate
SQL statement carries out dynamic expansion to meet the demand of user.
In any of the above-described technical scheme, it is preferable that also include:Store and encapsulate a plurality of SQL statement performs knot
Really.
In the technical scheme, the implementing result of a plurality of SQL statement is stored and encapsulated by function component, with realize by
Implementing result is displayed on the interface of enterprise report.
In any of the above-described technical scheme, it is preferable that the metadata includes:Function metadata and parameter metadata, its
In, the function metadata includes one below or various combinations:Function description, function definition, function prompting, function are crucial
Word, function packet condition, the parameter metadata includes one below or various combinations:The species of functional query condition, letter
Number querying conditions type, whether be grouped, type of database.
In the technical scheme, by the metadata for defining the above, will be patrolled with identical inquiry according to the metadata
In the same set, group one SQL statement of correspondence performs the secondary of SQL statement to the function grid point collected so as to greatly reduce
Number, is effectively improved the efficiency peeked from enterprise report.
By technical scheme, the peek efficiency of enterprise report can be improved, and reduce opening for enterprise report
Degree of raising difficult questions.
Description of the drawings
Fig. 1 shows the principle schematic peeked from enterprise report in correlation technique;
Fig. 2 shows the structural representation of the peek device of enterprise report according to an embodiment of the invention;
Fig. 3 shows the structural representation of the peek device of enterprise report according to another embodiment of the invention;
Fig. 4 shows the principle schematic peeked from enterprise report in Fig. 3;
Fig. 5 shows the schematic flow sheet of the access method of enterprise report according to an embodiment of the invention;
Fig. 6 shows the schematic flow sheet of the access method of enterprise report according to another embodiment of the invention.
Specific embodiment
It is below in conjunction with the accompanying drawings and concrete real in order to the above objects, features and advantages of the present invention can be more clearly understood that
Apply mode to be further described in detail the present invention.It should be noted that in the case where not conflicting, the enforcement of the application
Feature in example and embodiment can be mutually combined.
Many details are elaborated in the following description in order to fully understand the present invention, but, the present invention may be used also
Implemented with being different from other modes described here using other, therefore, protection scope of the present invention is not by described below
Specific embodiment restriction.
Fig. 2 shows the structural representation of the peek device of enterprise report according to an embodiment of the invention.
As shown in Fig. 2 the peek device 200 of enterprise report according to an embodiment of the invention, including:Metadata group
Part 202, computing device assembly 204 and SQL actuator assemblies 206.
Metadata component 202, for defining the metadata of business scope;Computing device assembly 204, for according to first number
It is divided into multiple groups according to by all function grid in the enterprise report, wherein, the function in each group in the plurality of group
Grid has identical query logic;SQL actuator assemblies 206, for performing the plurality of group of a plurality of SQL statement, wherein,
The a plurality of SQL statement and the plurality of group of one-to-one corresponding;The computing device assembly 204 is additionally operable to, according to the enterprise report
Form, the implementing result of a plurality of SQL statement is shown.
In the technical scheme, it is grouped by all function grid in enterprise report, each group of correspondence one
SQL statement, perform the corresponding SQL statement of multiple groups of difference and be capable of achieving to be peeked from enterprise report, it is to avoid in correlation technique
The all function grid of execution in each function grid SQL statement, so as to greatly reduce the number of times for performing SQL statement,
The peek efficiency of enterprise report is so not only increased, is also avoided the number of times due to performing SQL statement excessive and is caused treatability
Can decline.In addition, this programme supports that the framework of the enterprise report of any ERP system is accessed, so as to reduce opening for enterprise report
Degree of raising difficult questions.
In above-mentioned technical proposal, it is preferable that the computing device assembly 204 includes:Parallel computation scheduling engine 2042, if
The parallel computation scheduling engine 2042 is opened, then the parallel computation scheduling engine 2042 controls the SQL actuator assemblies
A plurality of SQL statement described in 206 executed in parallel;If or do not open the parallel computation scheduling engine 2042, the SQL is performed
The serial of device assembly 206 performs a plurality of SQL statement.
In the technical scheme, the control of parallel computation scheduling engine 2042 SQL 206 executed in parallel of actuator assembly are a plurality of
SQL statement, further increasing the peek efficiency of enterprise report.It is of course also possible to serial performs a plurality of SQL statement.Or
Parallel or serial is determined according to the actual demand of user, hardware case and performs a plurality of SQL statement.
In any of the above-described technical scheme, it is preferable that the SQL actuator assemblies 206 are additionally operable to, modification instruction is received,
Change the SQL statement of arbitrary group in the plurality of group.
In the technical scheme, by arbitrary group of SQL statement of modification, for example, by arbitrary group of inquiry sales data
SQL statement is revised as inquiring about the SQL statement of sales data and procurement data, the as reserved extension mechanism of user, right so as to facilitate
SQL statement carries out dynamic expansion to meet the demand of user.
In any of the above-described technical scheme, it is preferable that the peek device 200 of enterprise report also includes:Function component 208,
For storing and encapsulating the implementing result of a plurality of SQL statement.
In the technical scheme, the implementing result of a plurality of SQL statement is stored and encapsulated by function component 208, with reality
Now implementing result is included on the interface of enterprise report.
In any of the above-described technical scheme, it is preferable that the metadata includes:Function metadata and parameter metadata, its
In, the function metadata includes one below or various combinations:Function description, function definition, function prompting, function are crucial
Word, function packet condition, the parameter metadata includes one below or various combinations:The species of functional query condition, letter
Number querying conditions type, whether be grouped, type of database.
In the technical scheme, by the metadata for defining the above, will be patrolled with identical inquiry according to the metadata
In the same set, group one SQL statement of correspondence performs the secondary of SQL statement to the function grid point collected so as to greatly reduce
Number, is effectively improved the efficiency peeked from enterprise report.
In any of the above-described technical scheme, it is preferable that the peek device 200 of enterprise report also includes:Facade interfaces component
210, encapsulate the peek interface of enterprise report in facade interfaces component 210 pairs, unification realize enterprise report function peek,
The functions such as function registration, function declaration, function execution.Can be performed by computing device assembly 204, metadata component 202, SQL
Device assembly 206 performs facade interfaces component 210 to dispatch.Facade interfaces component 210 externally encapsulates the entrance of business scope and connects
Mouthful, facilitate business scope to be adapted to.
Fig. 3 and Fig. 4 show the structural representation of the peek device of the enterprise report of an alternative embodiment of the invention.
As shown in Figure 3 and Figure 4, the peek device 200 of enterprise report according to another embodiment of the invention, including:
Facade interfaces component 210, computing device assembly 204, metadata component 202, SQL actuator assemblies 206 and function component 208.Under
It is described in detail in the face of each component.
Facade interfaces component 210:The peek interface of enterprise report is encapsulated in facade interfaces component 210 pairs, it is unified to realize
The function peek of enterprise report, function registration, function declaration, function such as perform at the function.Can by computing device assembly 204,
Metadata component 202, SQL actuator assemblies 206 perform facade interfaces component 210 to dispatch.Facade interfaces component 210 is to covering
The ingress interface of business scope is filled, has facilitated business scope to be adapted to.
Computing device assembly 204:All function grid (abbreviation grid in Fig. 4) in enterprise report are grouped.For example,
All function grid are grouped by three-level.1st grade defined by business scope it is specified, by what is substantially can not be combined
The packet of function grid is distinguished, and such as Select a, b, c from A, the middle tables of B where ... ..group by ... are all different,
Necessarily can not be in same group;2nd grade carries out second level packet, such as Select a, b, c according to whether querying condition is identical
Whether where conditions in from A, B where ... ..group by ... are identical to be grouped;3rd level is according to packet condition
Difference carry out third level packet, such as Select a, b, c from A, the middle group of B where ... ..group by ...
The difference of by conditions is grouped.
In addition, the built-in parallel computation scheduling engine in the inside of computing device assembly 204, can be according to actual business scenario, choosing
Unlatching parallel computation scheduling engine is selected, by multiple SQL statement executed in parallel, accelerates the processing speed of system.
Metadata component 202:Core component, each component in the peek device 200 of enterprise report all can be using first number
According to component 202.Metadata component 202 is used to define the metadata of business scope, and metadata includes function metadata and parameter unit
Data.Wherein, the function grid in function metadata main definitions enterprise report, comprising function description, letter in function grid
Number definition, function prompting, the keyword of function, packet condition of function etc.;Parameter metadata defines functional query condition
Species, type, whether be grouped, the description such as type of database.By to metadata definition, in the peek device 200 of enterprise report
Each component can be with the encapsulation and extension that carry out public function of dynamic flexible.
SQL actuator assemblies 206:It is responsible for the execution of concrete each SQL statement.Unified SQL statement splicing machine is provided
System, acquiescence meeting is according to metadata automatic Mosaic SQL statement and performs.And reserved extension mechanism facilitates business scope to SQL languages
Sentence carries out dynamic expansion, while the splicing and execution of whole SQL statement can be carried out intervention and replace.
Function component 208:Encapsulate when function grid runs required entrance querying condition and perform after SQL statement
Implementing result.
Computing device assembly 204 is additionally operable to, and according to the form of enterprise report, the implementing result of a plurality of SQL statement is shown
Show.
Fig. 5 shows the schematic flow sheet of the access method of enterprise report according to an embodiment of the invention.
As shown in figure 5, the access method of enterprise report according to an embodiment of the invention, including:
Step 502, defines the metadata of business scope.
All function grid in the enterprise report are divided into multiple groups by step 504 according to the metadata, wherein,
The function grid in each group in the plurality of group has identical query logic.
Step 506, performs the plurality of group of a plurality of SQL statement, wherein, a plurality of SQL statement with the plurality of group
Correspond.
Step 508, according to the form of the enterprise report, shows to the implementing result of a plurality of SQL statement.
In the technical scheme, it is grouped by all function grid in enterprise report, each group of correspondence one
SQL statement, perform the corresponding SQL statement of multiple groups of difference and be capable of achieving to be peeked from enterprise report, it is to avoid in correlation technique
The all function grid of execution in each function grid SQL statement, so as to greatly reduce the number of times for performing SQL statement,
The peek efficiency of enterprise report is so not only increased, is also avoided the number of times due to performing SQL statement excessive and is caused treatability
Can decline.In addition, this programme supports that the framework of the enterprise report of any ERP system is accessed, so as to reduce opening for enterprise report
Degree of raising difficult questions.
In above-mentioned technical proposal, it is preferable that a plurality of SQL statement described in executed in parallel;Or serial execution is described a plurality of
SQL statement.
In the technical scheme, SQL actuator assemblies can further increasing enterprise with a plurality of SQL statement of executed in parallel
The peek efficiency of retribution for sins table.It is of course also possible to serial performs a plurality of SQL statement.Or according to user actual demand, hardware feelings
Condition performs a plurality of SQL statement determining parallel or serial.
In any of the above-described technical scheme, it is preferable that also include:Modification instruction is received, appointing in the plurality of group is changed
One group of SQL statement.
In the technical scheme, by arbitrary group of SQL statement of modification, for example, by arbitrary group of inquiry sales data
SQL statement is revised as inquiring about the SQL statement of sales data and procurement data, the as reserved extension mechanism of user, right so as to facilitate
SQL statement carries out dynamic expansion to meet the demand of user.
In any of the above-described technical scheme, it is preferable that also include:Store and encapsulate a plurality of SQL statement performs knot
Really.
In the technical scheme, the implementing result of a plurality of SQL statement is stored and encapsulated by function component, with realize by
Implementing result is displayed on the interface of enterprise report.
In any of the above-described technical scheme, it is preferable that the metadata includes:Function metadata and parameter metadata, its
In, the function metadata includes one below or various combinations:Function description, function definition, function prompting, function are crucial
Word, function packet condition, the parameter metadata includes one below or various combinations:The species of functional query condition, letter
Number querying conditions type, whether be grouped, type of database.
In the technical scheme, by the metadata for defining the above, will be patrolled with identical inquiry according to the metadata
In the same set, group one SQL statement of correspondence performs the secondary of SQL statement to the function grid point collected so as to greatly reduce
Number, is effectively improved the efficiency peeked from enterprise report.
Fig. 6 shows the schematic flow sheet of the access method of enterprise report according to another embodiment of the invention.
As shown in fig. 6, the access method of enterprise report according to another embodiment of the invention, including:
Step 602, by facade interfaces component enterprise report platform is connected to.
Step 604, initializes computing device assembly.
Step 606, metadata component defines the metadata of business scope.
Step 608, initializes SQL actuator assemblies.
Step 610, initialization function components.
All function grid in enterprise report are divided into multiple groups by step 612, computing device assembly according to metadata, its
In, the function grid in each group in multiple groups has identical query logic.
Step 614, according to the parallel computation scheduling engine in service needed Glycerine enema device assembly.
Step 616, by parallel computation scheduling engine the SQL statement of multiple groups of SQL actuator executed in parallel is controlled.
Step 618, the implementing result and querying condition of function component package SQL statement.
Step 620, computing device assembly according to enterprise report form, the data of explicit function component package.
Technical scheme is described in detail above in association with accompanying drawing, by technical scheme, can be improved
The peek efficiency of enterprise report, and reduce the development difficulty of enterprise report.
In the present invention, term " first ", " second " are only used for the purpose for describing, and it is not intended that indicating or implying phase
To importance;Term " multiple " represents two or more.For the ordinary skill in the art, can be according to tool
Body situation understands above-mentioned term concrete meaning in the present invention.
The preferred embodiments of the present invention are the foregoing is only, the present invention is not limited to, for the skill of this area
For art personnel, the present invention can have various modifications and variations.It is all within the spirit and principles in the present invention, made any repair
Change, equivalent, improvement etc., should be included within the scope of the present invention.
Claims (10)
1. the peek device of a kind of enterprise report, it is characterised in that include:
Metadata component, for defining the metadata of business scope;
Computing device assembly, for all function grid in the enterprise report to be divided into multiple groups according to the metadata, its
In, the function grid in each group in the plurality of group has identical query logic;
SQL actuator assemblies, for performing the plurality of group of a plurality of SQL statement, wherein, a plurality of SQL statement with it is described
Multiple groups of one-to-one corresponding;
The computing device assembly is additionally operable to, and according to the form of the enterprise report, the implementing result of a plurality of SQL statement is entered
Row shows.
2. the peek device of enterprise report according to claim 1, it is characterised in that the computing device assembly includes:And
Row calculates scheduling engine,
If opening the parallel computation scheduling engine, the parallel computation scheduling engine controls the SQL actuator assemblies simultaneously
Row performs a plurality of SQL statement;Or
If not opening the parallel computation scheduling engine, the SQL actuator assemblies serial performs a plurality of SQL statement.
3. the peek device of enterprise report according to claim 1, it is characterised in that the SQL actuator assemblies are also used
In,
Modification instruction is received, the SQL statement of arbitrary group in the plurality of group is changed.
4. the peek device of enterprise report according to claim 1, it is characterised in that also include:
Function component, for storing and encapsulating the implementing result of a plurality of SQL statement.
5. the peek device of enterprise report according to any one of claim 1 to 4, it is characterised in that
The metadata includes:Function metadata and parameter metadata,
Wherein, the function metadata includes one below or various combinations:Function description, function definition, function prompting, letter
Number keyword, function packet condition, the parameter metadata includes one below or various combinations:The kind of functional query condition
Class, the type of functional query condition, whether be grouped, type of database.
6. a kind of access method of enterprise report, it is characterised in that include:
Define the metadata of business scope;
The all function grid in the enterprise report are divided into multiple groups according to the metadata, wherein, in the plurality of group
Each group in function grid there is identical query logic;
The plurality of group of a plurality of SQL statement is performed, wherein, a plurality of SQL statement and the plurality of group of one-to-one corresponding;
According to the form of the enterprise report, the implementing result of a plurality of SQL statement is shown.
7. the access method of enterprise report according to claim 6, it is characterised in that
A plurality of SQL statement described in executed in parallel;Or
Serial performs a plurality of SQL statement.
8. the access method of enterprise report according to claim 6, it is characterised in that also include:
Modification instruction is received, the SQL statement of arbitrary group in the plurality of group is changed.
9. the access method of enterprise report according to claim 6, it is characterised in that also include:
Store and encapsulate the implementing result of a plurality of SQL statement.
10. the access method of the enterprise report according to any one of claim 6 to 9, it is characterised in that
The metadata includes:Function metadata and parameter metadata,
Wherein, the function metadata includes one below or various combinations:Function description, function definition, function prompting, letter
Number keyword, function packet condition, the parameter metadata includes one below or various combinations:The kind of functional query condition
Class, the type of functional query condition, whether be grouped, type of database.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201610955597.4A CN106682064B (en) | 2016-11-03 | 2016-11-03 | Data acquisition device and method for enterprise report |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201610955597.4A CN106682064B (en) | 2016-11-03 | 2016-11-03 | Data acquisition device and method for enterprise report |
Publications (2)
Publication Number | Publication Date |
---|---|
CN106682064A true CN106682064A (en) | 2017-05-17 |
CN106682064B CN106682064B (en) | 2020-02-11 |
Family
ID=58839543
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201610955597.4A Active CN106682064B (en) | 2016-11-03 | 2016-11-03 | Data acquisition device and method for enterprise report |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN106682064B (en) |
Cited By (2)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN110019497A (en) * | 2017-08-07 | 2019-07-16 | 北京国双科技有限公司 | A kind of method for reading data and device |
CN110597846A (en) * | 2019-09-18 | 2019-12-20 | 金瓜子科技发展(北京)有限公司 | KSQL processing method and device |
Citations (5)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN101789027A (en) * | 2010-03-15 | 2010-07-28 | 江苏大学 | Metadata management method based on DBMS and metadata server |
CN102521413A (en) * | 2011-12-28 | 2012-06-27 | 畅捷通信息技术股份有限公司 | Data reading device based on network reports and method |
CN103092997A (en) * | 2013-02-21 | 2013-05-08 | 用友软件股份有限公司 | Linkage query system and linkage query method used for statement analysis |
CN103488700A (en) * | 2013-09-04 | 2014-01-01 | 用友软件股份有限公司 | Data extracting system and data extracting method |
CN103678590A (en) * | 2013-12-12 | 2014-03-26 | 用友软件股份有限公司 | Report collecting device and report collecting method based on OLAP |
-
2016
- 2016-11-03 CN CN201610955597.4A patent/CN106682064B/en active Active
Patent Citations (6)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN101789027A (en) * | 2010-03-15 | 2010-07-28 | 江苏大学 | Metadata management method based on DBMS and metadata server |
CN102521413A (en) * | 2011-12-28 | 2012-06-27 | 畅捷通信息技术股份有限公司 | Data reading device based on network reports and method |
CN102521413B (en) * | 2011-12-28 | 2013-04-03 | 畅捷通信息技术股份有限公司 | Data reading device based on network reports and method |
CN103092997A (en) * | 2013-02-21 | 2013-05-08 | 用友软件股份有限公司 | Linkage query system and linkage query method used for statement analysis |
CN103488700A (en) * | 2013-09-04 | 2014-01-01 | 用友软件股份有限公司 | Data extracting system and data extracting method |
CN103678590A (en) * | 2013-12-12 | 2014-03-26 | 用友软件股份有限公司 | Report collecting device and report collecting method based on OLAP |
Cited By (4)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN110019497A (en) * | 2017-08-07 | 2019-07-16 | 北京国双科技有限公司 | A kind of method for reading data and device |
CN110019497B (en) * | 2017-08-07 | 2021-06-08 | 北京国双科技有限公司 | Data reading method and device |
CN110597846A (en) * | 2019-09-18 | 2019-12-20 | 金瓜子科技发展(北京)有限公司 | KSQL processing method and device |
CN110597846B (en) * | 2019-09-18 | 2022-04-08 | 金瓜子科技发展(北京)有限公司 | KSQL processing method and device |
Also Published As
Publication number | Publication date |
---|---|
CN106682064B (en) | 2020-02-11 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
EP3367234B1 (en) | Systems and methods for arbitrary software logic modeling | |
CN109344223A (en) | Building information model management system and method based on cloud computing technology | |
CN101571802B (en) | Visualization automatic generation method of embedded software test data and system thereof | |
CN104268428B (en) | A kind of visual configuration method calculated for index | |
CN114035773B (en) | Configuration-based low-code form development method, system and device | |
US20130218924A1 (en) | Method of providing data included in building information modeling data file, recording medium therefor, system using the method, and method of providing data using building information modeling server | |
CN109492266A (en) | Optimum design method, device and the equipment of standard component model data | |
CN105528418B (en) | A kind of design documentation generation method and device | |
CN101901265B (en) | Objectification management system of virtual test data | |
CN105095320A (en) | System for identifying, correlating, searching and displaying documents based on relationship superposition and combination | |
CN104778124A (en) | Automatic testing method for software application | |
CN106648587A (en) | Annotation-based Web application code generation method | |
CN103425672A (en) | Method and device for creating indexes of database | |
CN108319673B (en) | Fault tree construction method based on relational database | |
CN113721892A (en) | Domain modeling method, domain modeling device, computer equipment and storage medium | |
CN103903086A (en) | Method and system for developing management information system based on service model driving | |
CN103309667A (en) | Method for positioning UI (user interface) control and picture modifying position in Android system | |
CN103631931A (en) | Method and system for hierarchically storing data | |
KR101955376B1 (en) | Processing method for a relational query in distributed stream processing engine based on shared-nothing architecture, recording medium and device for performing the method | |
CN106096159B (en) | A kind of implementation method of distributed system behavior simulation analysis system under cloud platform | |
CN103677841B (en) | IETM code generation method and device based on element-level template | |
CN106682064A (en) | Number picking device and method for enterprise report | |
CN114117645A (en) | Ship overall performance prediction integrated application system | |
CN113919158A (en) | Simulation method and device for flight control panel and storage medium | |
CN117009038B (en) | Graph computing platform based on cloud native technology |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
PB01 | Publication | ||
PB01 | Publication | ||
SE01 | Entry into force of request for substantive examination | ||
SE01 | Entry into force of request for substantive examination | ||
GR01 | Patent grant | ||
GR01 | Patent grant |