CN107341235A - Report form inquiring method, device, medium and electronic equipment - Google Patents
Report form inquiring method, device, medium and electronic equipment Download PDFInfo
- Publication number
- CN107341235A CN107341235A CN201710536625.3A CN201710536625A CN107341235A CN 107341235 A CN107341235 A CN 107341235A CN 201710536625 A CN201710536625 A CN 201710536625A CN 107341235 A CN107341235 A CN 107341235A
- Authority
- CN
- China
- Prior art keywords
- report
- query
- result set
- inquiring method
- original
- 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
- 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
-
- 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)
- Software Systems (AREA)
- Computational Linguistics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention provides a kind of report form inquiring method, device, medium and electronic equipment.The report form inquiring method includes：Pretreatment operation is carried out to the original report, to obtain pretreated result set, the pretreatment operation includes table connection and packet aggregation operation；Obtain report query request；Asked according to the report query, the result set is inquired about.Technical scheme can carry out table connection and packet aggregation operation in advance, and then each report query can be avoided all to repeat table connection and packet aggregation operation, effectively shorten the report query time.
Description
Technical field
The present invention relates to database technical field, in particular to a kind of report form inquiring method, device, medium and electricity
Sub- equipment.
Background technology
, it is necessary to generate form according to demand in the application scenarios for being counted, being collected to data, to pass through form, figure
Data are dynamically presented in the modes such as table.
At present, reporting system is required for performing following step in inquiry form every time：
1st, dimension table and true table are attached；
2nd, data are screened according to screening conditions；
3rd, it is grouped according to dimension, aminated polyepichlorohydrin is carried out to index；
4th, existing index is calculated, obtains the parameters such as stock rate, turnover rate.
Meanwhile existing reporting system is that the computing engineering of parameter is placed in code to realize.
Problems be present in existing reporting system：
1st, because the table connection of database, packet aggregation operation are than relatively time-consuming, inquiry every time all carries out table connection and packet
Converging operation adds the report query time, have impact on Consumer's Experience；
2nd, realized due to the calculating process of parameter is placed in code, therefore workload is larger and the system of parameter
When meter bore changes, it is necessary to issue that system is reached the standard grade again.
It should be noted that information is only used for strengthening the reason of the background to the present invention disclosed in above-mentioned background section
Solution, therefore can include not forming the information to prior art known to persons of ordinary skill in the art.
The content of the invention
It is an object of the invention to provide a kind of report form inquiring method, device, medium and electronic equipment, and then at least one
Determine to overcome in degree one or more problem caused by the limitation of above-mentioned correlation technique and defect.
Other characteristics and advantage of the present invention will be apparent from by following detailed description, or partially by the present invention
Practice and acquistion.
According to the first aspect of the invention, there is provided a kind of report form inquiring method, including：The original report is pre-processed
Operation, to obtain pretreated result set, the pretreatment operation includes table connection and packet aggregation operation；Form is obtained to look into
Ask request；Asked according to the report query, the result set is inquired about.
In some embodiments of the invention, based on aforementioned schemes, pretreatment operation is carried out to the original report, it is pre- to obtain
The step of result set after processing, including：Dimensional information and the non-computational index being presented to as needed in the form of user, it is raw
Into query statement；The query statement is performed for the original report, to obtain the result set.
In some embodiments of the invention, need to be presented to use to be described based on aforementioned schemes, the non-computational index
Field in the form at family.
In some embodiments of the invention, also included based on aforementioned schemes, described report form inquiring method：By consistent
Property hash algorithm to the original report carry out Hash processing.
In some embodiments of the invention, based on aforementioned schemes, asked according to the report query, to the result
Before the step of collection is inquired about, in addition to：Judge that the result set whether there is；When judging that the result set is not present,
Asked according to the report query, inquiry is associated to the original report；In the presence of the result set is judged, according to institute
Report query request is stated, the result set is inquired about.
In some embodiments of the invention, based on aforementioned schemes, the step of report query is asked is obtained, including：According to
Need to be presented to the dimensional information in the form of user and non-computational index, and the parameter defined in configuration file, it is raw
Into query statement, asked with obtaining the report query.
In some embodiments of the invention, based on aforementioned schemes, the parameter is multiple non-computational indexs
Combination.
In some embodiments of the invention, based on aforementioned schemes, the result set is stored by interim form.
In some embodiments of the invention, based on aforementioned schemes, according to predetermined timing to the original report
Carry out pretreatment operation.
In some embodiments of the invention, also included based on aforementioned schemes, described report form inquiring method：By the report
The Query Result of table inquiry request is preserved into memory database；If obtaining report query request again, described in preferential inquiry
Memory database.
According to the second aspect of the invention, there is provided a kind of report query device, including：Pretreatment unit, for original
Beginning form carries out pretreatment operation, and to obtain pretreated result set, the pretreatment operation includes table connection and is grouped poly-
Closing operation；Acquiring unit, for obtaining report query request；Query unit, for being asked according to the report query, to described
Result set is inquired about.
According to the third aspect of the invention we, there is provided a kind of computer-readable medium, be stored thereon with computer program, institute
State the report form inquiring method realized when program is executed by processor as described in above-mentioned first aspect.
According to the fourth aspect of the invention, there is provided a kind of electronic equipment, including：One or more processors；Storage dress
Put, for storing one or more programs, when one or more of programs are by one or more of computing devices, make
Obtain report form inquiring method of one or more of processors realizations as described in above-mentioned first aspect.
In the technical scheme that some embodiments of the present invention are provided, by carrying out pretreatment operation to the original report,
When obtaining report query request, directly to inquire about pretreated result set, enabling carry out table connection in advance
Operated with packet aggregation, can so avoid each report query from all repeating table connection and packet aggregation operation, effectively contracting
The short report query time.
In the technical scheme that some embodiments of the present invention are provided, by using uniformity hash algorithm to original report
Table carries out Hash processing so that the original report can be uniformly distributed in each database, avoid data base read-write focus
Problem.
In the technical scheme that some embodiments of the present invention are provided, because parameter is defined by configuration file
, therefore user can neatly define parameter by configuration file, avoid the fortune of parameter in the prior art
Calculation process be placed in code realize and need to reach the standard grade again when the Statistical Criteria of parameter changes delivery system the problem of.
In the technical scheme that some embodiments of the present invention are provided, protected by the Query Result for asking report query
Deposit into memory database, with the preferential audit memory database when obtaining report query request again so that inquiring about again
During the form inquired about, Query Result can quickly be obtained by the inquiry to memory database, improve report query
Efficiency.
It should be appreciated that the general description and following detailed description of the above are only exemplary and explanatory, not
Can the limitation present invention.
Brief description of the drawings
Accompanying drawing herein is merged in specification and forms the part of this specification, shows the implementation for meeting the present invention
Example, and for explaining principle of the invention together with specification.It should be evident that drawings in the following description are only the present invention
Some embodiments, for those of ordinary skill in the art, on the premise of not paying creative work, can also basis
These accompanying drawings obtain other accompanying drawings.In the accompanying drawings：
Fig. 1 diagrammatically illustrates the flow chart of report form inquiring method according to an embodiment of the invention；
Fig. 2 shows the configuration diagram of report inquiring system according to an embodiment of the invention；
Fig. 3 shows the schematic diagram of the preprocessing process in report query scheme according to an embodiment of the invention；
Fig. 4 shows the schematic diagram of the report query process in report query scheme according to an embodiment of the invention；
Fig. 5 diagrammatically illustrates the block diagram of report query device according to an embodiment of the invention；
The structure that Fig. 6 diagrammatically illustrates the computer system suitable for being used for the electronic equipment for realizing the embodiment of the present invention is shown
It is intended to.
Embodiment
Example embodiment is described more fully with referring now to accompanying drawing.However, example embodiment can be with a variety of shapes
Formula is implemented, and is not understood as limited to example set forth herein；On the contrary, these embodiments are provided so that the present invention will more
Fully and completely, and by the design of example embodiment comprehensively it is communicated to those skilled in the art.
In addition, described feature, structure or characteristic can be incorporated in one or more implementations in any suitable manner
In example.In the following description, there is provided many details fully understand so as to provide to embodiments of the invention.However,
It will be appreciated by persons skilled in the art that technical scheme can be put into practice without one or more in specific detail,
Or other methods, constituent element, device, step etc. can be used.In other cases, side known in being not shown in detail or describe
Method, device, realization are operated to avoid fuzzy each aspect of the present invention.
Block diagram shown in accompanying drawing is only functional entity, not necessarily must be corresponding with physically separate entity.
I.e., it is possible to realize these functional entitys using software form, or realized in one or more hardware modules or integrated circuit
These functional entitys, or these functional entitys are realized in heterogeneous networks and/or processor device and/or microcontroller device.
Flow chart shown in accompanying drawing is merely illustrative, it is not necessary to including all contents and operation/step,
It is not required to perform by described order.For example, some operation/steps can also decompose, and some operation/steps can close
And or partly merging, therefore the order actually performed is possible to be changed according to actual conditions.
Fig. 1 diagrammatically illustrates the flow chart of report form inquiring method according to an embodiment of the invention.
Reference picture 1, report form inquiring method according to an embodiment of the invention, comprises the following steps：
Step S10, pretreatment operation is carried out to the original report, to obtain pretreated result set, the pretreatment behaviour
Work includes table connection and packet aggregation operation.
In an exemplary embodiment of the present invention, Hash can be carried out to the original report by uniformity hash algorithm
Processing, the original report is evenly distributed in each database, the problem of avoiding data base read-write focus.
In step slo, by carrying out pretreatment operation to the original report, enabling carry out table connection and packet in advance
Converging operation, and then can effectively shorten the report query time.
According to the exemplary embodiment of the present invention, step S10 is specifically included：It is presented to as needed in the form of user
Dimensional information and non-computational index, generate query statement；The query statement is performed for the original report, it is described to obtain
Result set.
It should be noted that non-computational index is to need to be presented to the generic field in the form of user, the inquiry of generation
Sentence can be SQL (Structured Query Language, SQL) sentence.
, can be by interim after pretreatment operation is carried out to the original report according to the exemplary embodiment of the present invention
The result set that form storage pretreatment obtains.
In addition, in an exemplary embodiment of the present invention, the original report can be entered according to predetermined timing
Row pretreatment operation.
Step S12, obtain report query request.
According to the exemplary embodiment of the present invention, step S12 is specifically included：It is presented to as needed in the form of user
Dimensional information and non-computational index, and the parameter defined in configuration file, query statement is generated, to obtain the form
Inquiry request.
It should be noted that because parameter is defined by configuration file, therefore user can be by configuring text
Part neatly defines parameter, avoids that the calculating process of parameter is placed in code in the prior art and realizes and counting
Calculate the Statistical Criteria of index need to reach the standard grade again when changing delivery system the problem of.Wherein, parameter is multiple non-computational
The combination of index.
Step S14, asked according to the report query, the result set is inquired about.
In some embodiments of the invention, based on aforementioned schemes, also include before step S142：Judge the result
Collection whether there is；When judging that the result set is not present, asked according to the report query, the original report is closed
Joint investigation is ask；In the presence of the result set is judged, asked further according to the report query, the result set is inquired about.
In addition, in some embodiments of the invention, based on aforementioned schemes, described report form inquiring method also includes：Will
The Query Result of the report query request is preserved into memory database；If obtaining report query request again, preferentially look into
Ask the memory database.
Fig. 2 show the configuration diagram of report inquiring system according to an embodiment of the invention.Specifically, the system
Framework mainly includes following four parts：
1st, data storage, initial data form are stored in MySql databases.It is right by task scheduling system timing daily
Initial data form is pre-processed, and the result obtained after table connection and packet aggregation is stored in interim table.
2nd, service layer, there is provided database access ability, and database query result is buffered in memory database (such as
JimDB in).
3rd, interface (such as REST API), it is the interface of opening, report query can be carried out by calling interface.Wherein,
REST full name are Representational State Transfer, which depict the network system of a framework pattern, such as
Weblication；API full name are Application Programming Interface, and it represents that application programming connects
Mouthful.
4th, multiple terminals is supported, can be that offer service is applied in browsing device net page and mobile terminal.
Based on the system architecture shown in Fig. 2, the report query scheme of the embodiment of the present invention mainly include preprocessing process and
Report query process, is illustrated individually below：
Preprocessing process：
The process is specific as shown in figure 3, comprising the following steps：
Step S302, uniformity hash algorithm carries out Hash to the original report ID, and determines the database where interim table.
In step s 302, Hash processing is carried out to the original report by uniformity hash algorithm so that the original report energy
It is enough uniformly to fall in each database, avoid data base read-write hot issue.
Step S304, the dimension being presented to as needed in the form of user and non-computational index spelling SQL query statement.
Step S306, SQL query is performed, and obtained result set is stored in interim table.
In pretreatment stage, table connection, packet aggregation mainly during processing report query etc. are than relatively time-consuming behaviour
Make, and result is saved in interim table.Preprocessing process is supported to the multiple data sources such as MySql, Oracle, SQL Server
In data handled, when generating SQL statement, prototype pattern can be used, compatible different SQL syntax.
Report query process：
The process is specific as shown in figure 4, comprising the following steps：
Step S402, the dimension being presented to as needed in the form of user and non-computational index, and in configuration file
Customized parameter spells SQL statement.
Step S404, audit memory database (such as JimDb).
Step S406, judges whether audit memory database hits, if so, then report query terminates；Otherwise, step is performed
S408。
Step S408, uniformity hash algorithm carry out Hash to form ID, it is determined that the database where interim table.
Step S410, judge that interim table whether there is, if in the presence of execution step S412；Otherwise, step S414 is performed.
Step S412, SQL query is performed on interim table, can so avoid the connection of carry out table and packet aggregation operation,
The execution time of query statement is shortened, improves search efficiency.
Step S414, SQL correlation inquiries are carried out on the original report.
Step S416, Query Result is saved in memory database (such as JimDb).In an embodiment of the present invention, pass through
Query Result is saved in memory database so that directly can quickly be returned from memory database when inquiring about the form again
Result is returned, improves search efficiency, this is also exactly the reason for inquiry first memory database in step S404.
From above-mentioned elaboration, the report query scheme of the embodiment of the present invention by carry out in advance database table connection and
Division operation, reduce the report query time；Parameter can neatly be defined by configuration file simultaneously；And pass through one
Cause property hash algorithm carries out a point storehouse to the original report, the problem of can avoiding data base read-write focus.It should be noted that this hair
The technical scheme of bright embodiment supports that Star Model (is a kind of data relationship of multidimensional, it is by a true table and one group
Dimension table forms) and snowflake model (in snowflake model, one or more dimension tables are not directly connected on true table, and
It is to be connected to by other dimension tables on true table).
Fig. 5 diagrammatically illustrates the block diagram of report query device according to an embodiment of the invention.
Reference picture 5, report query device 500 according to an embodiment of the invention, including：Pretreatment unit 502, obtain list
Member 504 and query unit 506.
Specifically, pretreatment unit 502 is used to carry out pretreatment operation to the original report, to obtain pretreated result
Collection, the pretreatment operation include table connection and packet aggregation operation；Acquiring unit 504 is used to obtain report query request；Look into
Ask unit 506 to be used to be asked according to the report query, the result set is inquired about.
It should be noted that the detail of each module/unit included in above-mentioned report query device 500 is right
It is described in detail in the report form inquiring method answered, therefore here is omitted.
Below with reference to Fig. 6, it illustrates suitable for for realizing the computer system 600 of the electronic equipment of the embodiment of the present invention
Structural representation.The computer system 600 of electronic equipment shown in Fig. 6 is only an example, should not be to the embodiment of the present invention
Function and use range bring any restrictions.
As shown in fig. 6, computer system 600 includes CPU (CPU) 601, it can be read-only according to being stored in
Program in memory (ROM) 602 or be loaded into program in random access storage device (RAM) 603 from storage part 608 and
Perform various appropriate actions and processing.In RAM 603, various programs and data needed for system operatio are also stored with.CPU
601st, ROM 602 and RAM 603 are connected with each other by bus 604.Input/output (I/O) interface 605 is also connected to bus
604。
I/O interfaces 605 are connected to lower component：Importation 606 including keyboard, mouse etc.；Penetrated including such as negative electrode
The output par, c 607 of spool (CRT), liquid crystal display (LCD) etc. and loudspeaker etc.；Storage part 608 including hard disk etc.；
And the communications portion 609 of the NIC including LAN card, modem etc..Communications portion 609 via such as because
The network of spy's net performs communication process.Driver 610 is also according to needing to be connected to I/O interfaces 605.Detachable media 611, such as
Disk, CD, magneto-optic disk, semiconductor memory etc., it is arranged on as needed on driver 610, in order to read from it
Computer program be mounted into as needed storage part 608.
Especially, according to an embodiment of the invention, it may be implemented as computer above with reference to the process of flow chart description
Software program.For example, embodiments of the invention include a kind of computer program product, it includes being carried on computer-readable medium
On computer program, the computer program include be used for execution flow chart shown in method program code.In such reality
To apply in example, the computer program can be downloaded and installed by communications portion 609 from network, and/or from detachable media
611 are mounted.When the computer program is performed by CPU (CPU) 601, perform what is limited in the system of the application
Above-mentioned function.
It should be noted that the computer-readable medium shown in the present invention can be computer-readable signal media or meter
Calculation machine readable storage medium storing program for executing either the two any combination.Computer-readable recording medium for example can be --- but not
Be limited to --- electricity, magnetic, optical, electromagnetic, system, device or the device of infrared ray or semiconductor, or it is any more than combination.Meter
The more specifically example of calculation machine readable storage medium storing program for executing can include but is not limited to：Electrical connection with one or more wires, just
Take formula computer disk, hard disk, random access storage device (RAM), read-only storage (ROM), erasable type and may be programmed read-only storage
Device (EPROM or flash memory), optical fiber, portable compact disc read-only storage (CD-ROM), light storage device, magnetic memory device,
Or above-mentioned any appropriate combination.In the present invention, computer-readable recording medium can any include or store journey
The tangible medium of sequence, the program can be commanded the either device use or in connection of execution system, device.And at this
In invention, computer-readable signal media can include in a base band or as carrier wave a part propagation data-signal,
Wherein carry computer-readable program code.The data-signal of this propagation can take various forms, including but unlimited
In electromagnetic signal, optical signal or above-mentioned any appropriate combination.Computer-readable signal media can also be that computer can
Any computer-readable medium beyond storage medium is read, the computer-readable medium, which can send, propagates or transmit, to be used for
By instruction execution system, device either device use or program in connection.Included on computer-readable medium
Program code can be transmitted with any appropriate medium, be included but is not limited to：Wirelessly, electric wire, optical cable, RF etc., or it is above-mentioned
Any appropriate combination.
Flow chart and block diagram in accompanying drawing, it is illustrated that according to the system of various embodiments of the invention, method and computer journey
Architectural framework in the cards, function and the operation of sequence product.At this point, each square frame in flow chart or block diagram can generation
The part of one module of table, program segment or code, a part for above-mentioned module, program segment or code include one or more
For realizing the executable instruction of defined logic function.It should also be noted that some as replace realization in, institute in square frame
The function of mark can also be with different from the order marked in accompanying drawing generation.For example, two square frames succeedingly represented are actual
On can perform substantially in parallel, they can also be performed in the opposite order sometimes, and this is depending on involved function.Also
It is noted that the combination of each square frame and block diagram in block diagram or flow chart or the square frame in flow chart, can use and perform rule
Fixed function or the special hardware based system of operation are realized, or can use the group of specialized hardware and computer instruction
Close to realize.
Being described in unit involved in the embodiment of the present invention can be realized by way of software, can also be by hard
The mode of part realizes that described unit can also set within a processor.Wherein, the title of these units is in certain situation
Under do not form restriction to the unit in itself.
As on the other hand, present invention also provides a kind of computer-readable medium, the computer-readable medium can be
Included in electronic equipment described in above-described embodiment；Can also be individualism, and without be incorporated the electronic equipment in.
Above computer computer-readable recording medium carries one or more program, and when said one or multiple programs, by one, the electronics is set
During standby execution so that the electronic equipment realizes the report form inquiring method as described in above-mentioned embodiment.
For example, the electronic equipment can be realized as shown in Figure 1：Step S10, pretreatment behaviour is carried out to the original report
Make, to obtain pretreated result set, the pretreatment operation includes table connection and packet aggregation operation；Step S12, obtain
Report query is asked；Step S14, asked according to the report query, the result set is inquired about.
And for example, the electronic equipment can realize each step shown in Fig. 3 or Fig. 4.
It should be noted that although some modules or list of the equipment for action executing are referred in above-detailed
Member, but this division is not enforceable.In fact, according to the embodiment of the present invention, it is above-described two or more
Either the feature of unit and function can embody module in a module or unit.A conversely, above-described mould
Either the feature of unit and function can be further divided into being embodied by multiple modules or unit block.
Through the above description of the embodiments, those skilled in the art is it can be readily appreciated that example described herein is implemented
Mode can be realized by software, can also be realized by way of software combines necessary hardware.Therefore, according to the present invention
The technical scheme of embodiment can be embodied in the form of software product, the software product can be stored in one it is non-volatile
Property storage medium (can be CD-ROM, USB flash disk, mobile hard disk etc.) in or network on, including some instructions are to cause a calculating
Equipment (can be personal computer, server, touch control terminal or network equipment etc.) is performed according to embodiment of the present invention
Method.
Those skilled in the art will readily occur to the present invention its after considering specification and putting into practice invention disclosed herein
Its embodiment.The application be intended to the present invention any modification, purposes or adaptations, these modifications, purposes or
Person's adaptations follow the general principle of the present invention and including undocumented common knowledges in the art of the invention
Or conventional techniques.Description and embodiments are considered only as exemplary, and true scope and spirit of the invention are by following
Claim is pointed out.
It should be appreciated that the invention is not limited in the precision architecture for being described above and being shown in the drawings, and
And various modifications and changes can be being carried out without departing from the scope.The scope of the present invention is only limited by appended claim.
Claims (13)
- A kind of 1. report form inquiring method, it is characterised in that including：Pretreatment operation is carried out to the original report, to obtain pretreated result set, the pretreatment operation connects including table Operated with packet aggregation；Obtain report query request；Asked according to the report query, the result set is inquired about.
- 2. report form inquiring method according to claim 1, it is characterised in that pretreatment operation is carried out to the original report, with The step of obtaining pretreated result set, including：Dimensional information and the non-computational index being presented to as needed in the form of user, generate query statement；The query statement is performed for the original report, to obtain the result set.
- 3. report form inquiring method according to claim 2, it is characterised in that the non-computational index needs to present to be described To the field in the form of user.
- 4. report form inquiring method according to claim 1, it is characterised in that also include：Pass through uniformity hash algorithm pair The original report carries out Hash processing.
- 5. report form inquiring method according to claim 1, it is characterised in that asked according to the report query, to institute Before stating the step of result set is inquired about, in addition to：Judge that the result set whether there is；When judging that the result set is not present, asked according to the report query, inquiry is associated to the original report；In the presence of the result set is judged, asked according to the report query, the result set is inquired about.
- 6. report form inquiring method according to claim 1, it is characterised in that the step of obtaining report query request, including：Dimensional information and the non-computational index being presented to as needed in the form of user, and the calculating defined in configuration file Index, query statement is generated, asked with obtaining the report query.
- 7. report form inquiring method according to claim 6, it is characterised in that the parameter is multiple described non-computational The combination of index.
- 8. report form inquiring method according to claim 1, it is characterised in that the result set is stored by interim form.
- 9. report form inquiring method according to claim 1, it is characterised in that according to predetermined timing to described original Form carries out pretreatment operation.
- 10. report form inquiring method according to any one of claim 1 to 9, it is characterised in that also include：The Query Result that the report query is asked is preserved into memory database；If obtaining report query request again, the memory database is preferentially inquired about.
- A kind of 11. report query device, it is characterised in that including：Pretreatment unit, for carrying out pretreatment operation to the original report, to obtain pretreated result set, the pretreatment Operation includes table connection and packet aggregation operation；Acquiring unit, for obtaining report query request；Query unit, for being asked according to the report query, the result set is inquired about.
- 12. a kind of computer-readable medium, is stored thereon with computer program, it is characterised in that described program is held by processor The report form inquiring method as any one of claim 1 to 10 is realized during row.
- 13. a kind of electronic equipment, it is characterised in that including：One or more processors；Storage device, for storing one or more programs, when one or more of programs are by one or more of processing When device performs so that one or more of processors realize the report query side as any one of claim 1 to 10 Method.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710536625.3A CN107341235A (en) | 2017-07-04 | 2017-07-04 | Report form inquiring method, device, medium and electronic equipment |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710536625.3A CN107341235A (en) | 2017-07-04 | 2017-07-04 | Report form inquiring method, device, medium and electronic equipment |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN107341235A true CN107341235A (en) | 2017-11-10 |
Family
ID=60218300
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201710536625.3A Pending CN107341235A (en) | 2017-07-04 | 2017-07-04 | Report form inquiring method, device, medium and electronic equipment |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN107341235A (en) |
Cited By (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN108021618A (en) * | 2017-11-13 | 2018-05-11 | 北京天元创新科技有限公司 | A kind of data query method and system |
| CN108415964A (en) * | 2018-02-07 | 2018-08-17 | 平安科技（深圳）有限公司 | Tables of data querying method, device, terminal device and storage medium |
| CN109471893A (en) * | 2018-10-24 | 2019-03-15 | 上海连尚网络科技有限公司 | Querying method, equipment and the computer readable storage medium of network data |
| CN110032567A (en) * | 2019-04-24 | 2019-07-19 | 江苏满运软件科技有限公司 | Report form inquiring method, device, server and storage medium |
| CN111368146A (en) * | 2018-12-26 | 2020-07-03 | 北京国双科技有限公司 | Path information query method and device, storage medium and processor |
| CN113486066A (en) * | 2021-07-15 | 2021-10-08 | 福建博思软件股份有限公司 | Method and terminal for hierarchically summarizing report forms |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20070185833A1 (en) * | 2006-01-27 | 2007-08-09 | Oracle International Corporation | Query generation method |
| CN102222097A (en) * | 2011-06-16 | 2011-10-19 | 西北工业大学 | Method for generating complex structured query language (SQL) statement |
| CN102663116A (en) * | 2012-04-11 | 2012-09-12 | 中国人民大学 | Multi-dimensional OLAP (On Line Analytical Processing) inquiry processing method facing column storage data warehouse |
-
2017
- 2017-07-04 CN CN201710536625.3A patent/CN107341235A/en active Pending
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20070185833A1 (en) * | 2006-01-27 | 2007-08-09 | Oracle International Corporation | Query generation method |
| CN102222097A (en) * | 2011-06-16 | 2011-10-19 | 西北工业大学 | Method for generating complex structured query language (SQL) statement |
| CN102663116A (en) * | 2012-04-11 | 2012-09-12 | 中国人民大学 | Multi-dimensional OLAP (On Line Analytical Processing) inquiry processing method facing column storage data warehouse |
Non-Patent Citations (2)
| Title |
|---|
| 王书海 等: "基于多表连接的分组查询语句的性能分析与优化", 《计算机工程》 * |
| 童维勤: "《数据密集型计算和模型》", 31 January 2015, 上海科学技术出版社 * |
Cited By (9)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN108021618A (en) * | 2017-11-13 | 2018-05-11 | 北京天元创新科技有限公司 | A kind of data query method and system |
| CN108021618B (en) * | 2017-11-13 | 2020-10-16 | 北京天元创新科技有限公司 | Data query method and system |
| CN108415964A (en) * | 2018-02-07 | 2018-08-17 | 平安科技（深圳）有限公司 | Tables of data querying method, device, terminal device and storage medium |
| CN109471893A (en) * | 2018-10-24 | 2019-03-15 | 上海连尚网络科技有限公司 | Querying method, equipment and the computer readable storage medium of network data |
| CN109471893B (en) * | 2018-10-24 | 2022-05-20 | 上海连尚网络科技有限公司 | Network data query method, equipment and computer readable storage medium |
| CN111368146A (en) * | 2018-12-26 | 2020-07-03 | 北京国双科技有限公司 | Path information query method and device, storage medium and processor |
| CN110032567A (en) * | 2019-04-24 | 2019-07-19 | 江苏满运软件科技有限公司 | Report form inquiring method, device, server and storage medium |
| CN110032567B (en) * | 2019-04-24 | 2022-09-06 | 江苏满运软件科技有限公司 | Report query method, device, server and storage medium |
| CN113486066A (en) * | 2021-07-15 | 2021-10-08 | 福建博思软件股份有限公司 | Method and terminal for hierarchically summarizing report forms |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN107341235A (en) | Report form inquiring method, device, medium and electronic equipment | |
| CN107645562A (en) | Data transmission processing method, device, equipment and system | |
| CN105912500A (en) | Machine learning model generation method and machine learning model generation device | |
| CN107451109A (en) | Report form generation method and system | |
| CN109408205A (en) | Method for scheduling task and device based on hadoop cluster | |
| CN109976997A (en) | Test method and device | |
| CN111488995B (en) | Method, device and system for evaluating joint training model | |
| CN109614312A (en) | Method for generating test case, device, electronic equipment and storage medium | |
| CN108804402A (en) | Report generating system based on big data platform and method | |
| CN108733662A (en) | Method, apparatus, electronic equipment and the readable storage medium storing program for executing of comparison of data consistency | |
| CN104753706B (en) | A kind of distributed type assemblies configuring management method and device | |
| CN109359281A (en) | Dynamic list generation method and device | |
| CN109901987A (en) | A kind of method and apparatus generating test data | |
| CN107977678A (en) | Method and apparatus for output information | |
| CN110309142A (en) | The method and apparatus of regulation management | |
| JP2022136234A (en) | Federated learning method and apparatus, electronic apparatus, storage medium, and computer program | |
| CN107948437A (en) | Put out screen and show method and apparatus | |
| CN110019331A (en) | A kind of method and apparatus of the inquiry database based on structured query language | |
| CN109753424A (en) | The method and apparatus of AB test | |
| CN107347093A (en) | Collocation method and device for distributed server system | |
| CN110223179A (en) | The data processing method of fund, device, system, medium | |
| CN111428159B (en) | Online classification method and device | |
| CN109902698A (en) | Information generating method and device | |
| CN108733691A (en) | Data preprocessing method and device | |
| CN109634866A (en) | Data test method, apparatus, 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 | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20171110 |
|
| RJ01 | Rejection of invention patent application after publication |