CN108255967A - Call method, device, storage medium and the terminal of storing process - Google Patents
Call method, device, storage medium and the terminal of storing process Download PDFInfo
- Publication number
- CN108255967A CN108255967A CN201711431187.0A CN201711431187A CN108255967A CN 108255967 A CN108255967 A CN 108255967A CN 201711431187 A CN201711431187 A CN 201711431187A CN 108255967 A CN108255967 A CN 108255967A
- Authority
- CN
- China
- Prior art keywords
- data
- storing process
- report
- reporting system
- oracle database
- 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/22—Indexing; Data structures therefor; Storage structures
- G06F16/2291—User-Defined Types; Storage management thereof
-
- 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/23—Updating
- G06F16/2379—Updates performed during online database operations; commit processing
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/28—Databases characterised by their database models, e.g. relational or object models
- G06F16/284—Relational databases
Landscapes
- Engineering & Computer Science (AREA)
- Databases & Information Systems (AREA)
- Theoretical Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Software Systems (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The present invention is suitable for field of communication technology, provides a kind of call method of storing process, device, storage medium and terminal, the method includes：Report receptance function is created in oracle database, the report receptance function is used for the storing process in the call request calling oracle database for responding reporting system；When the data request information for getting reporting system transmission, the data request information is parsed, obtains required parameter；The required parameter is passed to the report receptance function, the corresponding storing process of the required parameter is called by the report receptance function；The storing process is performed to be processed to the data in oracle database, the data after working process are read, to respond the request of data of the reporting system；The present invention solves the problems, such as that reporting system in the prior art can not call the storing process in oracle database, data updating efficiency slow.
Description
Technical field
The invention belongs to field of communication technology more particularly to a kind of call method of storing process, device, storage medium and
Terminal.
Background technology
Pentaho is current most popular business intelligence software of increasing income, and is using workflow as core, emphasizes towards solution party
The BI external members of case rather than tool assembly have gathered a large amount of machine learning algorithms that can undertake data mining task, including to data
It pre-processed, classified, being returned, being clustered, Association Rule Analysis and data being visualized on interactive interface.It is however, existing
BI report tools do not carry the function of data mart modeling.Pentaho reporting systems mainly use HSQLDB databases as money
Expect library, only data bank is updated daily primary.When user on Pentaho reporting systems when checking data, due to HSQLDB's
Update efficiency is slow, and user can not get newest data in time.As it can be seen that Pentaho reporting systems can not expire in the prior art
Sufficient user's dynamic checks the demand of latest data.
Invention content
An embodiment of the present invention provides a kind of call method of storing process, device, storage medium and terminals, existing to solve
Have that the data updating efficiency of reporting system in technology is slow, can not meet the problem of user's dynamic checks latest data.
An embodiment of the present invention provides a kind of call method of storing process, the call method includes：
Report receptance function is created in oracle database, the report receptance function is used to respond the tune of reporting system
With the storing process in request call oracle database；
When the data request information for getting reporting system transmission, the data request information is parsed, obtains request ginseng
Number；
The required parameter is passed to the report receptance function, the required parameter is started by the report receptance function
Corresponding storing process；
The storing process is performed to be processed to the data in oracle database, after reading working process
Data, to respond the request of data of the reporting system.
Further, it is described to perform the storing process to be processed to the data in oracle database, it reads
The data after working process are taken, are included with the request of data for responding the reporting system：
The storing process is performed to be processed to the data in oracle database；
Main table to be read is obtained from oracle database according to the required parameter；
Target data is read from the main table, read target data is written to from table, generation is suitable for institute
State the report data of reporting system；
The report data is sent to the reporting system, so that the reporting system receives and shows the report
Data.
Further, the data request information includes storing process name to be called, dimensional information to be asked, asks
Ask date, timing query time.
Further, it is described to read target data from the main table, read target data is written to from table,
Generation further includes later suitable for the report data of the reporting system：
Storing process name is obtained from the required parameter, the knot of the storing process is obtained according to the storing process name
Structure query language SQL code；
Checking command is generated based on the SQL code；
Whether the content verified according to the checking command in the report data is consistent with the record of the main table, if one
It causes, then the report data is back to the reporting system.
Further, user account is further included in the data request information；
It is described to parse the data request information when getting the data request information that reporting system is sent, later also
Including：
Obtain the user account；
Verify whether the user account has processing authority based on preset authorization list；
If so, obtain required parameter from the data request information；
If it is not, then generating unauthorized prompting message, the unauthorized prompting message is sent to the reporting system.
The embodiment of the present invention additionally provides a kind of calling device of storing process, and the calling device includes：
Creation module, for creating report receptance function in oracle database, the report receptance function is used to ring
Answer the storing process in the call request calling oracle database of reporting system；
Acquisition module, for when getting the data request information that reporting system is sent, parsing the request of data and disappearing
Breath obtains required parameter；
Starting module for the required parameter to be passed to the report receptance function, is opened by the report receptance function
Move the corresponding storing process of the required parameter；
Execution module for performing the storing process to be processed to the data in oracle database, is read
The data after working process are taken, to respond the request of data of the reporting system.
Further, the execution module includes：
Unit is processed, for performing the storing process to be processed to the data in oracle database；
First acquisition unit, for obtaining main table to be read from oracle database according to the required parameter；
First generation unit, for reading target data from the main table, by read target data be written to from
In table, generation is suitable for the report data of the reporting system；
Transmitting element, for the report data to be sent to the reporting system, so that the reporting system receives
And show the report data.
Further, user account is further included in the data request information；
The calling device further includes：
Correction verification module for obtaining the user account, verifies whether the user account has based on preset authorization list
Standby processing authority；
The acquisition module formula is used for the check results in correction verification module when being, to be obtained from the data request information
Required parameter；
Reminding module, for when the check results of correction verification module are no, generating unauthorized prompting message, not awarded described
Power prompting message is sent to the reporting system.
The embodiment of the present invention additionally provides a kind of computer readable storage medium, is stored thereon with computer program, the journey
The step described in the call method of storing process as described above is realized when sequence is performed as processor.
The embodiment of the present invention additionally provides a kind of terminal, and the terminal includes memory, processor and is stored in memory
Computer program that is upper and can running on a processor, the processor are realized as described above when performing the computer program
Step described in the call method of storing process.
Compared with prior art, the embodiment of the present invention is integrated in Pentaho reporting systems to oracle database
Calling function creates report receptance function, to be rung by the report receptance function by increasing in oracle database
Answer call request of the reporting system to storing process；When the data request information for getting reporting system transmission, described in parsing
Data request information obtains required parameter；The required parameter is passed to the report receptance function, letter is responded by the report
Number starts the corresponding storing process of the required parameter；The storing process is performed to be carried out to the data in oracle database
Working process reads the data after working process, to respond the request of data of the reporting system；It is achieved thereby that in report system
Call the storing process in oracle database in system, and due to oracle database to the update efficiency of data faster, pass through
Storing process can read newest data from oracle database, efficiently solve the number of reporting system in the prior art
According to updating, efficiency is slow, can not meet the problem of user's dynamic checks latest data.
Description of the drawings
In order to illustrate more clearly about the embodiment of the present invention or technical scheme of the prior art, to embodiment or will show below
There is attached drawing needed in technology description to be briefly described, it should be apparent that, the accompanying drawings in the following description is only this
Some embodiments of invention, for those of ordinary skill in the art, without creative efforts, can be with
Other accompanying drawings are obtained according to these attached drawings.
Fig. 1 is the first realization flow chart of the call method of storing process provided in an embodiment of the present invention；
Fig. 2 is the second realization flow chart of the call method of storing process provided in an embodiment of the present invention；
Fig. 3 is that the third of the call method of storing process provided in an embodiment of the present invention realizes flow chart；
Fig. 4 is the 4th realization flow chart of the call method of storing process provided in an embodiment of the present invention；
Fig. 5 is the composition structure chart of the calling device of storing process provided in an embodiment of the present invention；
Fig. 6 is the schematic diagram of terminal provided in an embodiment of the present invention.
Specific embodiment
In order to make the purpose , technical scheme and advantage of the present invention be clearer, with reference to the accompanying drawings and embodiments, it is right
The present invention is further elaborated.It should be appreciated that the specific embodiments described herein are merely illustrative of the present invention, and
It is not used in the restriction present invention.
In the prior art, Pentaho reporting systems mainly use HSQLDB databases as data bank, daily only to money
Expect that library update is primary.When user on Pentaho reporting systems when checking data, since the update efficiency of HSQLDB is slow, user
Newest data can not be got in time.Oracle database is processed data by storing process, data update effect
Rate is faster.However Pentaho reporting systems are a report query tools, Interworking Data table, are not supported in existing capability
To the calling of the storing process in oracle database.In order to realize that user's dynamic checks the demand of latest data, this hair is proposed
The call method of storing process described in bright embodiment.
Embodiment 1
Fig. 1 shows that the first of the call method of storing process provided in an embodiment of the present invention realizes flow.
In embodiments of the present invention, the call method of the storing process be applied to terminal, including but not limited to computer,
Server etc..
Refering to Fig. 1, the call method of the storing process includes：
In step S101, report receptance function is created in oracle database, the report receptance function is used to ring
Answer the storing process in the call request calling oracle database of reporting system.
In embodiments of the present invention, the reporting system is Pentaho reporting systems.The oracle database for institute
The relevant database of Pentaho reporting systems is stated, there are many table information and table data for the inside storage.In oracle database usually
Have multiple primary storing process, these storing process refer to one group to complete the SQL statement collection of specific energy, by first
It is called again after secondary compiling and is not required to compile again, the name of storing process is specified by function and provides parameter to perform it.
In the embodiment of the present invention, the report receptance function is by responding the call requests of Pentaho reporting systems, to call Oracle
Storing process in database is handled the data mart modeling in Pentaho reporting systems with realizing.
Optionally, to realize that the response to Pentaho reporting systems is needed in oracle database and in Pentaho reports
Two aspects of system are encoded.Wherein, it in oracle database, needs to dispose a response on oracle server
The program of Pentaho reports, i.e. report receptance function described in step S101.In Pentaho reporting systems, then increasing please
It seeks the function of starting the report receptance function and starts mark, arrange parameter input interface；And it is returned to oracle server
Return the daily record in calling process.It is alternatively possible to the data exchange tool Kettle that increases income is introduced on Pentaho reporting systems,
To realize the function that storing process is dispatched from report level.
In step s 102, it when the data request information for getting reporting system transmission, parses the request of data and disappears
Breath obtains required parameter.
Herein, user can identify to ask when checking report on Pentaho reporting systems by triggering described start
It asks and starts the report receptance function, and input required parameter.Pentaho reporting systems obtain described start and identify asking for triggering
Instruction and required parameter are asked, the data request information is generated, and be sent to the Oracle data based on the required parameter
Library.
The oracle database receives and parses through the data request information, obtains required parameter.Optionally, it is described to ask
Parameter is asked to include but not limited to storing process name to be called, dimensional information to be asked, request date, timing query time.
Wherein, the name loadtable, such as Defaultvalue=PRG_APV_ of the entitled storing process to be called of the storing process
REPORT_V2.PERSONAL_REPORT_EN_STATIC.The dimensional information is to treat request field in report to be asked, by
Generation, name field, age field including but not limited to such as in report, ID is configured in user on Pentaho reporting systems
Field, identification card number field, with the parameter value of all displays of character string combinations, such as
concatenate([start_date]；"；"；[end_tate]；"；"；CSVTEXT([id]；0；","；"")).
The timing query time calls the time of storing process for report receptance function, and storage when is called for report receptance function
Process carries out data update.User self-defined can be read by setting the timing query time from oracle database
The time interval and frequency of data.
In step s 103, the required parameter is passed to the report receptance function, is opened by the report receptance function
Move the corresponding storing process of the required parameter.
After required parameter is got, storage function name of the report receptance function in the required parameter obtains mesh
Dimensional information to be asked is passed to the object procedure by mark process, to start the object procedure, so as to fulfill
The storing process in oracle database is called on Pentaho reporting systems, BI report tools is realized and Oracle was stored
The calling of journey.Herein, the storing process is storing process primary in oracle database, can be according to service logic pair
Data in oracle database are processed, for example are increased, deleted, changing operation.Oracle database can pass through the side of table
Formula records all storing process, and the report receptance function then reads corresponding storage according to required parameter from the table
Process is triggered.
In step S104, the storing process is performed to be processed to the data in oracle database, is read
The data after working process are taken, to respond the request of data of the reporting system.
Oracle database performs the object procedure, that is, calls storing process, is asked by the storing process according to described
Parameter is asked to be processed the data in oracle database, is then read from the report that oracle database is stored
Data after working process, to complete the response to the request of data of Pentaho reporting systems.Number is completed in oracle database
After reading, user can be checked in Pentaho reporting systems.
In conclusion since oracle database self-service can update the data, and stored, and independent of
Pentaho reporting systems.The embodiment of the present invention is by the report receptance function, in the existing capability of Pentaho reporting systems
In increase calling to the storing process in oracle database, to be processed to data, so that user can
To get newest report data from oracle database by the function of newly increasing on Pentaho reporting systems,
The slow caused user's dynamic that can not meet of data updating efficiency for solving reporting system in the prior art checks latest data
Problem.
Further, on the basis of the first realization flow of the call method based on Fig. 1 storing process provided, this is proposed
The second of the call method for the storing process that inventive embodiments provide realizes flow.
As shown in Fig. 2, be the second realization flow chart of the call method of storing process provided in an embodiment of the present invention, it is described
Step S104 performs the storing process to be processed to the data in oracle database, and after reading working process
Data, included with the request of data for responding the reporting system：
In step S1041, the storing process is performed to be processed to the data in oracle database.
In step S1042, main table to be read is obtained from oracle database according to the required parameter.
As previously mentioned, the required parameter in the data request information include but not limited to storing process name to be called,
Dimensional information to be asked, request date, timing query time.When Oracle performs storing process, according to described to be asked
Dimensional information determines relevant table information, obtains main table to be read.
In step S1043, target data is read from the main table, read target data is written to from table
In, generation is suitable for the report data of the reporting system.
Herein, the storing process searched from the main table using select sentences described in dimensional information to be asked
Corresponding field value, obtains target data, creates from table, preserves the result set of return, i.e., by the target data copy to from
In table.It is finally based on the report data being applicable in from table generation Pentaho reporting systems.The Pentaho reporting systems are fitted
Report data should be understood to that the Pentaho reporting systems can parse and call the displaying report data.
In step S1044, the report data is sent to the reporting system, so that the reporting system receives
And show the report data.
The report data is sent to Pentaho reporting systems, is checked for user, it is achieved thereby that
The storing process in oracle database is supported and called in Pentaho reporting systems.It should be noted that during ground, the embodiment of the present invention
It is the update and reading that data are completed based on oracle database, based on data are checked in Pentaho reporting systems, utilizes
The renewal frequency of oracle database is fast, is newest field value in oracle database from the target data that table is written so that
Pentaho reporting systems after improvement disclosure satisfy that user's dynamic checks the demand of the latest data in reporting system.
Further, on the basis of the second realization flow of the call method based on Fig. 2 storing process provided, this is proposed
The third of the call method for the storing process that inventive embodiments provide realizes flow.
As shown in figure 3, be the third realization flow chart of the call method of storing process provided in an embodiment of the present invention, it is described
Step S104 performs the storing process to be processed to the data in oracle database, and after reading working process
Data, included with the request of data for responding the reporting system：
In step S104a, the storing process is performed to be processed to the data in oracle database.
In step S104b, main table to be read is obtained from oracle database according to the required parameter.
In step S104c, target data is read from the main table, read target data is written to from table
In, generate the report data that the reporting system is applicable in.
Wherein, step S104a to step S104c is identical to step S1043 with the step S1041 described in Fig. 2 embodiments,
The specific narration for referring to above-described embodiment, details are not described herein again.
It is further included after the step S104c：
In step S104d, storing process name is obtained from the required parameter, institute is obtained according to the storing process name
State the structured query language SQL code of storing process.
After storing process name is got, deposit corresponding with the storing process name is filtered out from oracle server
Storage process, and pass through standard interface and obtain the corresponding SQL code of the storing process.
In step S104e, checking command is generated based on the SQL code.
The SQL code is parsed, identifies keyword, the master described in including but not limited to described SQL code
Table, from table, dimensional information.Checking command is generated based on the keyword.
In step S104f, the note of the content and the main table in the report data is verified according to the checking command
Whether record is consistent.
Herein, verify content in the report data and the main table record information whether can be unanimously：
The summation of field length is done in main table and report data to each record, is then compared according to major key, judged from every in table
Whether item record consistent with the record information in main table, so as to check copied to from main table it is whether correct from the data of table, i.e., really
Whether the every record determined in report data is correct.Optionally, field length summation may be used lengthb methods into
Row.
After by verification, if every record is consistent with the record of main table from table, the report may thereby determine that
Table data are correct, perform step S104g.Otherwise, it if described be present in the different record of main table from table, holds again
Row step S104a carries out meter reading and writes table handling again.
In step S104g, the report data is sent to the reporting system, so that the reporting system receives
And show the report data.
Wherein, step S104g is identical with the step S1044 described in Fig. 2 embodiments, specifically refers to above-described embodiment
Narration, details are not described herein again.
The embodiment of the present invention is by before output report data to Pentaho reporting systems, increasing to being replicated from main table
The data to come over are verified, and be ensure that the accuracy of the report data exported on Pentaho reporting systems, are improved user's body
Test sense.
Further, on the basis of the first realization flow of the call method based on Fig. 1 storing process provided, this is proposed
The 4th of the call method for the storing process that inventive embodiments provide realizes flow.
As shown in figure 4, it is the 4th realization flow chart of the call method of storing process provided in an embodiment of the present invention.It is described
Call method includes：
In step S401, report receptance function is created in oracle database, the report receptance function is used to ring
Answer the storing process in the call request calling oracle database of reporting system.
In step S402, when the data request information for getting reporting system transmission, parse the request of data and disappear
Breath.
Wherein, step S401 to step S402 is identical to step S102 with the step S101 described in Fig. 1 embodiments, specifically
The narration of above-described embodiment is referred to, details are not described herein again.
The call method further includes：
In step S403, the user account is obtained.
In embodiments of the present invention, the user account logs in for user and uses the voucher of oracle database.Wherein,
The user of execution storing process, which has certain data manipulation permission, could use storing process, without the use of data manipulation permission
Family can only indirectly access data at the control.
In embodiments of the present invention, user account can also be included in the data request information.As previously mentioned, user can
It to check report on Pentaho reporting systems, is identified by the startup for triggering the report receptance function, input request ginseng
Number.Pentaho reporting systems obtain the request instruction and required parameter for starting mark and triggering, and obtain the user in institute
The user account on Pentaho reporting systems is stated, the data request information is generated based on the required parameter, user account,
And it is sent to the oracle database.It after oracle database receives the data request information, is parsed, obtains and use
Family account.
In step s 404, verify whether the user account has processing authority based on preset authorization list.
Herein, the user account is both on user credential and the Pentaho reporting systems on oracle database
User credential.The embodiment of the present invention is in advance by the user with data manipulation permission specified on Pentaho reporting systems
Voucher is directed into the oracle database.
In the oracle database by way of authorization list, the user account collection with data manipulation permission maintain
It closes.The user account recorded in the authorization list is provided with triggering the permission of the report receptance function, is used so as to have
The permission of storing process in oracle database.
The step S404 can be by inquiring whether preset authorization list includes the user account, to judge the user
Whether account has processing authority.If so, perform step S405；Otherwise, step S408 is performed.
In step S405, required parameter is obtained from the data request information.
Include the user account of active user and if only if the authorization list, i.e., described user account has processing authority
When, the embodiment of the present invention obtains required parameter from the data request information.
In step S406, the required parameter is passed to the report receptance function, is opened by the report receptance function
Move the corresponding storing process of the required parameter.
In step S 407, the storing process is performed to be processed to the data in oracle database, is read
Data after working process are taken, to respond the request of data of the reporting system.
Wherein, step S406 to step S407 is identical to step S104 with the step S103 described in Fig. 1 embodiments, specifically
The narration of above-described embodiment is referred to, details are not described herein again.
In step S408, unauthorized prompting message is generated, the unauthorized prompting message is sent to the report system
System.
If not including the user account of active user in the authorization list, show that the user account does not have disposal right
Limit, at this point, the embodiment of the present invention generates unauthorized prompting message according to the user account, and to the Pentaho reports system
System returns to the unauthorized prompting message, so that the Pentaho reporting systems are exported according to the unauthorized prompting message
Warning information, and cut off this data query or data update operation.
The embodiment of the present invention by safeguarding authorization list in oracle database, to the access right of report receptance function into
Row limits, and further improves the safety that storing process is called on Pentaho reporting systems.
It should be understood that in the above-described embodiments, the size of the serial number of each step is not meant to the priority of execution sequence, it is each to walk
Rapid execution sequence should determine that the implementation process without coping with the embodiment of the present invention forms any limit with its function and internal logic
It is fixed.
Embodiment 2
Fig. 5 shows the composition structure chart of the calling device of storing process provided in an embodiment of the present invention, for the ease of saying
It is bright, it illustrates only and the relevant part of the embodiment of the present invention.
In embodiments of the present invention, it is real to be used to implement above-mentioned Fig. 1, Fig. 2, Fig. 3, Fig. 4 for the calling device of the storing process
The call method of the storing process described in example is applied, can be the software unit for being built in server, hardware cell, software and hardware knot
The unit of conjunction.
Refering to Fig. 5, the calling device of the storing process includes：
Creation module 51, for creating report receptance function in oracle database, the report receptance function is used for
Respond the storing process in the call request calling oracle database of reporting system；
Acquisition module 52, for when getting the data request information that reporting system is sent, parsing the request of data
Message obtains required parameter；
Starting module 53, for the required parameter to be passed to the report receptance function, by the report receptance function
Start the corresponding storing process of the required parameter；
Execution module 54, for performing the storing process to be processed to the data in oracle database,
The data after working process are read, to respond the request of data of the reporting system.
Optionally, the execution module 54 includes：
Unit 541 is processed, for performing the storing process to be processed to the data in oracle database；
First acquisition unit 542, for obtaining main table to be read from oracle database according to the required parameter；
First generation unit 543, for reading target data from the main table, by read target data be written to
From table, generation is suitable for the report data of the reporting system；
Transmitting element 544, for the report data to be sent to the reporting system, so that the reporting system connects
It receives and shows the report data.
Optionally, storing process name to be called, dimension to be asked are included but not limited in the data request information
Information, request date, timing query time.
Optionally, the execution module 54 further includes：
Second acquisition unit 545, for obtaining storing process name from the required parameter, according to the storing process name
Obtain the structured query language SQL code of the storing process；
Second generation unit 546, for being based on the SQL code generation checking command；
Verification unit 547, for verifying the content in the report data and the main table according to the checking command
Whether record is consistent, if unanimously, the report data is back to the reporting system.
Optionally, user account can also be included in the data request information；The calling device further includes：
Whether correction verification module 55 for obtaining the user account, the user account is verified based on preset authorization list
Has processing authority；
The acquisition module 52 is additionally operable to the check results in correction verification module when being, to be obtained from the data request information
Take required parameter；
Reminding module 56, for when the check results of correction verification module are no, generating unauthorized prompting message, by described in not
Prompting message is authorized to be sent to the reporting system.
It should be noted that each module/unit in the embodiment of the present invention can be used to implement in above method embodiment
Whole technical solutions, specific work process can refer to the corresponding process in preceding method embodiment, no longer superfluous herein
It states.
In the above-described embodiments, it all emphasizes particularly on different fields to the description of each embodiment, is not described in detail or remembers in some embodiment
The part of load may refer to the associated description of other embodiments.
Embodiment 3
The present embodiment provides a computer readable storage medium, computer journey is stored on the computer readable storage medium
Sequence is realized the call method of storing process in embodiment 1, is repeated to avoid, here when the computer program is executed by processor
It repeats no more.Alternatively, when the computer program is executed by processor realize embodiment 2 in storing process calling device in each mould
The function of block/unit is repeated to avoid, and which is not described herein again.
Embodiment 4
Fig. 6 is a kind of schematic diagram of terminal provided in an embodiment of the present invention, and the terminal includes but not limited to server, moves
Dynamic terminal.As shown in fig. 6, the terminal 6 of the embodiment includes：Processor 60, memory 61 and it is stored in the memory 61
In and the computer program 62 that can be run on the processor 60.The processor 60 performs real during the computer program 62
Step in the call method embodiment of existing above-mentioned storing process, such as step S101 shown in FIG. 1 is to S104, Fig. 2 embodiment
Described in step S1041 to S1044, Fig. 3 embodiment described in step S104a to S104g, Fig. 4 embodiment described in
Step S401 to S408；Alternatively, the processor 60 realizes the calling of above-mentioned storing process when performing the computer program 62
The function of each module/unit in device embodiment, such as the function of module 51 to 56 shown in Fig. 5.
Illustratively, the computer program 62 can be divided into one or more module/units, it is one or
Multiple module/units are stored in the memory 61, and are performed by the processor 60, to complete the present invention.Described one
A or multiple module/units can be the series of computation machine program instruction section that can complete specific function, which is used for
Implementation procedure of the computer program 62 in the terminal 6 is described.For example, the computer program 62 can be divided into
Creation module, acquisition module, calling module, execution module, each module concrete function are as follows：
Creation module, for creating report receptance function in oracle database, the report receptance function is used to ring
Answer the storing process in the call request calling oracle database of reporting system；
Acquisition module, for when getting the data request information that reporting system is sent, parsing the request of data and disappearing
Breath obtains required parameter；
Starting module for the required parameter to be passed to the report receptance function, is opened by the report receptance function
Move the corresponding storing process of the required parameter；
Execution module for performing the storing process to be processed to the data in oracle database, is read
The data after working process are taken, to respond the request of data of the reporting system.
The terminal 6 can be the computing devices such as desktop PC, notebook, palm PC and cloud server.Institute
Stating terminal may include, but be not limited only to, processor 60, memory 61.It will be understood by those skilled in the art that Fig. 6 is only eventually
The restriction of the example, not structure paired terminal 6 at end 6 can be included than illustrating more or fewer components or combining certain portions
Part or different components, such as the terminal can also include input-output equipment, network access equipment, bus etc..
Alleged processor 60 can be central processing unit (Central Processing Unit, CPU), can also be
Other general processors, digital signal processor (Digital Signal Processor, DSP), application-specific integrated circuit
(Application Specific Integrated Circuit, ASIC), field programmable gate array (Field-
Programmable Gate Array, FPGA) either other programmable logic device, discrete gate or transistor logic,
Discrete hardware components etc..General processor can be microprocessor or the processor can also be any conventional processor
Deng the processor is the control centre of the terminal, utilizes various interfaces and the various pieces of the entire terminal of connection.
The memory 61 can be used for storing the computer program and/or module, and the processor is by running or holding
The computer program and/or module and call the data being stored in memory that row is stored in the memory, realize institute
State the various functions of terminal.The memory can mainly include storing program area and storage data field, wherein, storing program area can
Application program (such as sound-playing function, image player function etc.) needed for storage program area, at least one function etc.；It deposits
Storage data field can be stored uses created data etc. according to terminal.In addition, memory can be deposited including high random access
Reservoir can also include nonvolatile memory, such as hard disk, memory, plug-in type hard disk, intelligent memory card (Smart Media
Card, SMC), safe digital card (Secure Digital, SD), flash card (Flash Card), at least one magnetic disk storage
Part, flush memory device or other volatile solid-state parts.
In addition, each functional unit in each embodiment of the present invention can be integrated in a processing unit, it can also
That each unit is individually physically present, can also two or more units integrate in a unit.Above-mentioned integrated list
The form that hardware had both may be used in member is realized, can also be realized in the form of SFU software functional unit.
If the integrated module/unit realized in the form of SFU software functional unit and be independent product sale or
In use, it can be stored in a computer readable storage medium.Based on such understanding, the present invention realizes above-described embodiment
All or part of flow in method can also instruct relevant hardware to complete, the calculating by computer program
Machine program can be stored in a computer readable storage medium, and the computer program is when being executed by processor, it can be achieved that above-mentioned
The step of each embodiment of the method.Wherein, the computer program includes computer program code, the computer program code
Can be source code form, object identification code form, executable file or certain intermediate forms etc..The computer-readable storage medium
Matter can include：Can carry the computer program code any entity or device, recording medium, USB flash disk, mobile hard disk,
Magnetic disc, CD, computer storage, read-only memory (ROM, Read-Only Memory), random access memory (RAM,
Random Access Memory), electric carrier signal, telecommunication signal and software distribution medium etc..It is it should be noted that described
It is appropriate that the content that computer readable storage medium includes can be carried out according to legislation in jurisdiction and the requirement of patent practice
Increase and decrease, such as in certain jurisdictions, according to legislation and patent practice, it is electric load that computer readable storage medium, which does not include,
Wave signal and telecommunication signal.
Embodiment described above is merely illustrative of the technical solution of the present invention, rather than its limitations；Although with reference to aforementioned reality
Example is applied the present invention is described in detail, it will be understood by those of ordinary skill in the art that：It still can be to aforementioned each
Technical solution recorded in embodiment modifies or carries out equivalent replacement to which part technical characteristic；And these are changed
Or replace, the spirit and scope for various embodiments of the present invention technical solution that it does not separate the essence of the corresponding technical solution should all
It is included within protection scope of the present invention.
Claims (10)
1. a kind of call method of storing process, which is characterized in that the call method includes：
Report receptance function is created in oracle database, the calling that the report receptance function is used to respond reporting system please
Seek the storing process called in oracle database；
When the data request information for getting reporting system transmission, the data request information is parsed, obtains required parameter；
The required parameter is passed to the report receptance function, starting the required parameter by the report receptance function corresponds to
Storing process；
The storing process is performed to be processed to the data in oracle database, reads the number after working process
According to respond the request of data of the reporting system.
2. the call method of storing process as described in claim 1, which is characterized in that described to perform the storing process with right
Data in oracle database are processed, and the data after working process are read, to respond the number of the reporting system
Include according to request：
The storing process is performed to be processed to the data in oracle database；
Main table to be read is obtained from oracle database according to the required parameter；
Target data is read from the main table, read target data is written to from table, generation is suitable for the report
The report data of table system；
The report data is sent to the reporting system, so that the reporting system receives and shows the report number
According to.
3. the call method of storing process as claimed in claim 2, which is characterized in that the data request information includes treating
The storing process name of calling, dimensional information to be asked, request date, timing query time.
4. the call method of storing process as claimed in claim 3, which is characterized in that described to read target from the main table
Read target data is written to from table data, and generation is also wrapped later suitable for the report data of the reporting system
It includes：
Storing process name is obtained from the required parameter, the structuring of the storing process is obtained according to the storing process name
Query language SQL code；
Checking command is generated based on the SQL code；
Whether the content verified according to the checking command in the report data is consistent with the record of the main table, if unanimously,
The report data is then back to the reporting system.
5. such as the call method of Claims 1-4 any one of them storing process, which is characterized in that the request of data disappears
User account is further included in breath；
It is described when get reporting system transmission data request information when, parse the data request information, further include later：
Obtain the user account；
Verify whether the user account has processing authority based on preset authorization list；
If so, obtain required parameter from the data request information；
If it is not, then generating unauthorized prompting message, the unauthorized prompting message is sent to the reporting system.
6. a kind of calling device of storing process, which is characterized in that the calling device includes：
Creation module, for creating report receptance function in oracle database, the report receptance function is reported for responding
The storing process in oracle database is called in the call request of table system；
Acquisition module, for when getting the data request information that reporting system is sent, parsing the data request information, obtaining
Take required parameter；
Starting module for the required parameter to be passed to the report receptance function, starts institute by the report receptance function
State the corresponding storing process of required parameter；
Execution module for performing the storing process to be processed to the data in oracle database, reads and adds
Work treated data, to respond the request of data of the reporting system.
7. the calling device of storing process as claimed in claim 6, which is characterized in that the execution module includes：
Unit is processed, for performing the storing process to be processed to the data in oracle database；
First acquisition unit, for obtaining main table to be read from oracle database according to the required parameter；
For reading target data from the main table, read target data is written to from table for first generation unit,
Generation is suitable for the report data of the reporting system；
Transmitting element, for the report data to be sent to the reporting system, so that the reporting system is received and opened up
Show the report data.
8. the calling device of storing process as claimed in claims 6 or 7, which is characterized in that in the data request information also
Including user account；
The calling device further includes：
Correction verification module for obtaining the user account, verifies whether the user account has place based on preset authorization list
Manage permission；
The acquisition module is additionally operable to the check results in correction verification module as when being, request is obtained from the data request information
Parameter；
Reminding module, for when the check results of correction verification module are no, generating unauthorized prompting message, the unauthorized being carried
Show that message is sent to the reporting system.
9. a kind of computer readable storage medium, is stored thereon with computer program, which is characterized in that the program is held by processor
The step described in the call method of storing process described in any one of claim 1 to 5 is realized during row.
10. a kind of terminal, what the terminal included memory, processor and storage on a memory and can run on a processor
Computer program, which is characterized in that the processor realizes such as the claims 1 to 5 when performing the computer program
Step described in the call method of storing process described in one.
Priority Applications (2)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201711431187.0A CN108255967B (en) | 2017-12-26 | 2017-12-26 | Method and device for calling storage process, storage medium and terminal |
| PCT/CN2018/081037 WO2019127956A1 (en) | 2017-12-26 | 2018-03-29 | Calling method and device for storage process, and storage medium and terminal |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201711431187.0A CN108255967B (en) | 2017-12-26 | 2017-12-26 | Method and device for calling storage process, storage medium and terminal |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN108255967A true CN108255967A (en) | 2018-07-06 |
| CN108255967B CN108255967B (en) | 2021-03-02 |
Family
ID=62723882
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201711431187.0A Active CN108255967B (en) | 2017-12-26 | 2017-12-26 | Method and device for calling storage process, storage medium and terminal |
Country Status (2)
| Country | Link |
|---|---|
| CN (1) | CN108255967B (en) |
| WO (1) | WO2019127956A1 (en) |
Cited By (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109992259A (en) * | 2019-04-15 | 2019-07-09 | 成都四方伟业软件股份有限公司 | Function dynamic creation method, apparatus and electronic equipment |
| CN110968625A (en) * | 2019-10-10 | 2020-04-07 | 望海康信(北京)科技股份公司 | Method and system for interaction between SQLserver database and third-party platform |
| CN112131846A (en) * | 2020-09-07 | 2020-12-25 | 北京思特奇信息技术股份有限公司 | Method and system for parameter transmission based on mapping relation, electronic device and storage medium |
| CN113765876A (en) * | 2020-11-30 | 2021-12-07 | 北京沃东天骏信息技术有限公司 | Report processing software access method and device |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US8516062B2 (en) * | 2010-10-01 | 2013-08-20 | @Pay Ip Holdings Llc | Storage, communication, and display of task-related data |
| CN104461531A (en) * | 2014-12-02 | 2015-03-25 | 福建工程学院 | Implementing method for self-defined functions of reporting system |
| CN105069134A (en) * | 2015-08-18 | 2015-11-18 | 上海新炬网络信息技术有限公司 | Method for automatically collecting Oracle statistical information |
| CN106951483A (en) * | 2017-03-10 | 2017-07-14 | 国网江苏省电力公司电力科学研究院 | Based on storing process realize across logic isolate by force and security audit communication means |
Family Cites Families (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1588369A (en) * | 2004-09-06 | 2005-03-02 | 杭州恒生电子股份有限公司 | Relation type data base system and its search and report method |
| CN100580662C (en) * | 2007-12-29 | 2010-01-13 | 中国建设银行股份有限公司 | Heterogeneous report form integration and centralized management device and system |
| CN105636071A (en) * | 2014-11-04 | 2016-06-01 | 中兴通讯股份有限公司 | System capacity prediction method and apparatus |
-
2017
- 2017-12-26 CN CN201711431187.0A patent/CN108255967B/en active Active
-
2018
- 2018-03-29 WO PCT/CN2018/081037 patent/WO2019127956A1/en active Application Filing
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US8516062B2 (en) * | 2010-10-01 | 2013-08-20 | @Pay Ip Holdings Llc | Storage, communication, and display of task-related data |
| CN104461531A (en) * | 2014-12-02 | 2015-03-25 | 福建工程学院 | Implementing method for self-defined functions of reporting system |
| CN105069134A (en) * | 2015-08-18 | 2015-11-18 | 上海新炬网络信息技术有限公司 | Method for automatically collecting Oracle statistical information |
| CN106951483A (en) * | 2017-03-10 | 2017-07-14 | 国网江苏省电力公司电力科学研究院 | Based on storing process realize across logic isolate by force and security audit communication means |
Cited By (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109992259A (en) * | 2019-04-15 | 2019-07-09 | 成都四方伟业软件股份有限公司 | Function dynamic creation method, apparatus and electronic equipment |
| CN109992259B (en) * | 2019-04-15 | 2020-10-30 | 成都四方伟业软件股份有限公司 | Function dynamic creating method and device and electronic equipment |
| CN110968625A (en) * | 2019-10-10 | 2020-04-07 | 望海康信(北京)科技股份公司 | Method and system for interaction between SQLserver database and third-party platform |
| CN112131846A (en) * | 2020-09-07 | 2020-12-25 | 北京思特奇信息技术股份有限公司 | Method and system for parameter transmission based on mapping relation, electronic device and storage medium |
| CN112131846B (en) * | 2020-09-07 | 2024-06-04 | 北京思特奇信息技术股份有限公司 | Method and system for transmitting parameters based on mapping relation, electronic device and storage medium |
| CN113765876A (en) * | 2020-11-30 | 2021-12-07 | 北京沃东天骏信息技术有限公司 | Report processing software access method and device |
| CN113765876B (en) * | 2020-11-30 | 2023-09-26 | 北京沃东天骏信息技术有限公司 | Report processing software access method and device |
Also Published As
| Publication number | Publication date |
|---|---|
| WO2019127956A1 (en) | 2019-07-04 |
| CN108255967B (en) | 2021-03-02 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN108268253B (en) | Interface code generation method and terminal equipment | |
| CN109791591B (en) | Method and system for identity and credential protection and verification via blockchain | |
| CN108255967A (en) | Call method, device, storage medium and the terminal of storing process | |
| CN109308285A (en) | Database script management method, device, computer equipment and storage medium | |
| CN109829327A (en) | Sensitive information processing method, device, electronic equipment and storage medium | |
| CN107798037A (en) | The acquisition methods and server of user characteristic data | |
| CN111124917B (en) | Method, device, equipment and storage medium for managing and controlling public test cases | |
| CN112597762B (en) | Blockchain system with intelligent contract data supervision function and supervision method | |
| CN111414739B (en) | Excel data entry component, entry method and device | |
| CN108053088A (en) | A kind of Subscriber Management System, method and apparatus | |
| CN107528912A (en) | A kind of automatic method, system and relevant apparatus for realizing distributing real time system | |
| CN112800066A (en) | Index management method, related device and storage medium | |
| CN108170860A (en) | Data query method, apparatus, electronic equipment and computer readable storage medium | |
| CN114895879B (en) | Management system design scheme determining method, device, equipment and storage medium | |
| CN110347657A (en) | Data creation method, device, electronic equipment and storage medium | |
| CN110059081A (en) | Data output method, device and the computer equipment shown based on data | |
| CN115017240A (en) | Data providing method and device, processor and electronic equipment | |
| CN114357032A (en) | Data quality monitoring method and device, electronic equipment and storage medium | |
| CN113987574A (en) | Block chain private transaction method, device, equipment and readable storage medium | |
| CN110221952B (en) | Service data processing method and device and service data processing system | |
| CN109471849B (en) | Model processing method and device, storage medium and electronic equipment | |
| CN112286881A (en) | Document authentication and tracing method and device | |
| KR20210027011A (en) | Peer node, method for processing information executed on peer node and blockchain platform system | |
| KR101866826B1 (en) | Method for calling operational aspect of game server | |
| CN116701522B (en) | File cabinet classified data visualization method and device 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 | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |