Process data generation method and device, process data visualization method and device, electronic equipment and computer readable medium
A process data and data generation technology, applied in computing, database models, relational databases, etc., can solve the problems of tight coupling between process management platforms and business systems, and high development costs, so as to reduce the cost of human and material resources and avoid tight coupling.
- Summary
- Abstract
- Description
- Claims
- Application Information
AI Technical Summary
Problems solved by technology
Method used
Image
Examples
no. 1 example
[0047] figure 2 is a schematic flowchart of the main flow of the process data generating method according to the first embodiment of the present invention. Such as figure 2 As shown, the method for generating process data in the embodiment of the present invention includes:
[0048] Step S201: Regularly query the rollback segment table space of the target business data table in the target database to obtain the intermediate process data of at least one sub-process of the target business within a preset time period.
[0049] A transaction is a sequence of database operations that access and possibly manipulate various data items. These operations are either all executed or not executed at all, and are an indivisible unit of work. Transactions have ACID properties, namely atomicity, consistency, isolation and durability. Most relational database systems provide a transaction rollback mechanism. Taking the oracle database as an example, the rollback tablespace parameter und...
no. 2 example
[0075] image 3 is a schematic flow chart of the process data visualization method according to the second embodiment of the present invention. Such as image 3 As shown, the process data visualization method in the embodiment of the present invention includes:
[0076] Step S301: Acquisition program initialization.
[0077] In the embodiment of the present invention, the collection program can be pre-deployed on the target database side or a separate terminal capable of connecting to the target database. After the collection program is deployed, the collection program is initialized, specifically including: reading the collection configuration information from the configuration table, and loading the collection configuration information into the memory. Wherein, the collection configuration information includes parameter information such as the table name and field name of the target business data table, and the time interval of scheduled polling (ie, the execution time in...
no. 3 example
[0118] Figure 4 is a schematic flow chart of the process data visualization method according to the third embodiment of the present invention. Such as Figure 4 As shown, the process data visualization method in the embodiment of the present invention includes:
[0119] Step S401: Regularly query the rollback segment table space of the target business data table in the target database to obtain the intermediate process data of at least one sub-process of the target business within a preset time period.
[0120] Exemplarily, step S401 includes: in response to the triggering of the timing task, generating rollback data query SQL according to the collection configuration information, and periodically querying the rollback segment tablespace of the target business data table in the target database according to the rollback data query SQL.
[0121]Exemplarily, the triggering of the scheduled task may be that the current time is not earlier than the sum of the execution time of t...
PUM
Abstract
Description
Claims
Application Information
- R&D Engineer
- R&D Manager
- IP Professional
- Industry Leading Data Capabilities
- Powerful AI technology
- Patent DNA Extraction
Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic, Popular Technical Reports.
© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com