Integration technology of BPM process engine and domestic database

Abstract

The invention relates to the technical field of business process management, and discloses an integration technology of a BPM (business process management) process engine and a domestic database, the core of the integration technology is as follows: summarizing and integrating SQL (structured query language) grammar for creating, querying, inserting, updating, deleting and the like of various domestic databases on the basis of defined specifications such as execution semantics and description formats to form a set of unified SQL grammar; therefore, various domestic databases can be adapted; and then calling JDBC to load a database drive by using an SPI mechanism, obtaining a database connection object Consection, and establishing a Socket connection with common domestic databases such as vast, dreaminess, Shentong and Jinbin. By means of the capacity of a BPM process engine, through visual design and configuration, a demander rapidly constructs an informatization system meeting the service requirements of the demander, adjustment can be conducted at any time along with changes of the service requirements, and a user can meet the construction requirement of service digitization in a unit only through dragging and click operation modes.

Description

Technical Field

[0001] The present invention relates to the technical field of business process management, and in particular to the integration technology of a BPM process engine and a domestic database. Background Art

[0002] Currently, BPM process engines are widely used in various industries, but they also have some disadvantages:

[0003] 1. Most of the existing BPM process engines are designed based on non-domestic relational databases such as MySQL, Oracle, and SQLserver, and are not compatible with domestic databases.

[0004] 2. Some of the existing BPM process engines are compatible with domestic databases, but they are mainly adapted to a single domestic database and have not been fully integrated with domestic databases.

[0005] 3. The existing BPM process engine does not integrate the underlying SQL language, resulting in data migration failure or data loss due to SQL syntax issues when migrating data across database types, especially domestic databases.

[0006] The emergence of "BPM process engine and domestic database integration technology" perfectly solves the above problems. The integration of BPM process engine and domestic database based on BPMN2.0 international standardized process engine architecture redefines the standardized execution semantics and description format, and uses standard graphics to model the real business process, ensuring that the same process has the same execution results in different process engines. Its advantages are as follows:

[0007] 1. It is fully compatible with commonly used domestic databases such as Hangao, Dameng, Shentong, and Jincang;

[0008] 2. Through the defined execution semantics and description format specifications, the BPM process engine can perform complete and lossless data migration in commonly used domestic databases;

[0009] 3. Through distributed deployment and process clustering, the BPM process engine can integrate processes across systems and database types to create a secure, stable and easy-to-use BPM business flow platform;

[0010] 4. Provide flexible secondary development capabilities, so that the BPM process engine can quickly access individual niche database types and have strong scalability.

[0011] At present, due to the relatively low recognition of domestic databases in the market, BPM process engine products on the market generally give priority to more mature and widely used database products, such as Oracle, SQLserver, MySQL and other non-domestic databases; domestic databases may have differences in support for SQL standards, especially for support for some advanced SQL features or extended functions. BPM process engine products on the market generally rely on specific SQL features or functions, which may be limited in function or errors due to the lack of support from domestic databases; different database systems may use different data types and storage formats. When processing process data, BPM process engine products on the market may be incompatible with the data types and storage formats of domestic databases, resulting in data conversion errors or performance degradation.

[0012] Therefore, there is an urgent need to integrate BPM process engines with domestic databases to solve the above technical problems. Summary of the invention

[0013] The purpose of the present invention is to provide an integration technology of a BPM process engine and a domestic database to solve the problems raised in the above background technology.

[0014] To achieve the above object, the present invention provides the following technical solutions:

[0015] The integration technology of BPM process engine and domestic database, the core of this integration technology lies in:

[0016] S1. Based on the defined execution semantics and description format specifications, the SQL syntax for creation, query, insertion, update, and deletion of various domestic databases is summarized and integrated to form a unified SQL syntax to adapt to various domestic databases;

[0017] S2, then use the SPI mechanism to call JDBC to load the database driver, obtain the database connection object Connection, and establish a Socket connection with commonly used domestic databases such as Hangao, Dameng, Shentong, and Jincang;

[0018] S3, write and read BPM process form data in the form of binary data through Socket connection, and finally encapsulate it in Resultset object;

[0019] S4. The BPM process engine includes components for interacting with third-party systems, integrated syntax and customized SQL and code components. Through process orchestration and combined with business scenarios, the activiti process designer is used for visual process design. The data structure is maintained through the visual BO storage management page. Form forms are customized based on BO storage and mounted into the Process process. The form data generated by the operation of the process engine is written into the BO storage. The DW data window is used to call the BO storage data for customized data view display, which supports tracking the operation records of business processes in process instance monitoring.

[0020] Preferably, the integration technology of BPM process engine and domestic database is applied to government services, survey and design, health care, business operations, supply chain management, human resources, and archives management.

[0021] Preferably, the error information resource pool is used to store unique error information detected in multiple concurrent requests to prevent the same error from being prompted to the user multiple times. When a network request fails, the system checks whether the error information is already in the resource pool. If not, the error information is added to the resource pool and an error prompt is displayed to the user. If it already exists, the error is ignored and not displayed repeatedly.

[0022] Preferably, the integration technology of BPM process engine and domestic database fully decouples the process engine based on microservice architecture, and encapsulates the BPM process engine using containerization technology, thereby achieving elastic scaling of service-level resources. Through standardized interfaces and protocols, the BPM process engine is built to provide interfaces and drivers that are compatible with domestic databases.

[0023] Preferably, the BPM process engine adopts an ORM framework to map data tables in the database into objects, thereby ignoring the differences between different domestic databases, being compatible with a variety of different domestic databases, and enabling the BPM process engine to quickly migrate on different domestic databases.

[0024] Preferably, the integration technology leverages the capabilities of the BPM process engine to enable the demand side to quickly build an information system that meets their business needs through visual design and configuration, and can be adjusted at any time as business needs change.

[0025] Compared with the prior art, the present invention has the following beneficial effects:

[0026] 1. It has strong compatibility and can adapt to the common domestic databases on the market;

[0027] 2. Optimize access to domestic databases, including query optimization, index optimization, etc., so that the BPM engine still has strong reliability and stability after integrating the domestic database.

[0028] 3. A unified SQL syntax is integrated at the service layer, which enables fast switching between different database types, ensuring fast and convenient data migration while taking into account data integrity and accuracy;

[0029] 4. The deployment environment is adapted to the domestic information innovation environment and does not rely on a specific operating system environment and database type;

[0030] 5. It is scalable and provides flexible secondary development capabilities through standardized interfaces, so that the BPM process engine can quickly access emerging domestic database types that may appear in the future. BRIEF DESCRIPTION OF THE DRAWINGS

[0031] Other features, objects and advantages of the present application will become more apparent by reading the detailed description of non-limiting embodiments made with reference to the following drawings:

[0032] Figure 1 It is a schematic diagram of the integration technology framework of the BPM process engine and the domestic database of the present invention;

[0033] Figure 2 This is a page display diagram of the integrated technical system of the BPM process engine and the domestic database of the present invention. DETAILED DESCRIPTION

[0034] The present application is further described in detail below in conjunction with the accompanying drawings and embodiments. It is understood that the specific embodiments described herein are only used to explain the relevant invention, rather than to limit the invention. It should also be noted that, for ease of description, only the parts related to the invention are shown in the accompanying drawings. The different types of section lines in the drawings in the embodiments of the present invention are not marked according to the national standard, nor are there any requirements for the materials of the components, but are used to distinguish the cross-sectional views of the components in the drawings.

[0035] See also Figure 1-2 , the integration technology of BPM process engine and domestic database, the core of this integration technology lies in:

[0036] S1. Based on the defined execution semantics and description format specifications, the SQL syntax for creation, query, insertion, update, and deletion of various domestic databases is summarized and integrated to form a unified SQL syntax to adapt to various domestic databases;

[0037] S2, then use the SPI mechanism to call JDBC to load the database driver, obtain the database connection object Connection, and establish a Socket connection with commonly used domestic databases such as Hangao, Dameng, Shentong, and Jincang;

[0038] S3, write and read BPM process form data in the form of binary data through Socket connection, and finally encapsulate it in Resultset object;

[0039] S4. The BPM process engine includes components for interacting with third-party systems, integrated syntax and customized SQL and code components. Through process orchestration and combined with business scenarios, the activiti process designer is used for visual process design. The data structure is maintained through the visual BO storage management page. Form forms are customized based on BO storage and mounted into the Process process. The form data generated by the operation of the process engine is written into the BO storage. The DW data window is used to call the BO storage data for customized data view display, which supports tracking the operation records of business processes in process instance monitoring.

[0040] Among them, the integration technology of BPM process engine and domestic database is applied to government services, survey and design, health care, business operations, supply chain management, human resources, and archives management.

[0041] Among them, the error information resource pool is used to store unique error information detected in multiple concurrent requests to prevent the same error from being prompted to the user multiple times. When a network request fails, the system will check whether the error information is already in the resource pool. If not, the error information will be added to the resource pool and the error prompt will be displayed to the user; if it already exists, the error will be ignored and will not be displayed repeatedly.

[0042] Among them, the integration technology of BPM process engine and domestic database fully decouples the process engine based on the microservice architecture, and uses containerization technology to encapsulate the BPM process engine, thereby achieving elastic scaling of service-level resources. Through standardized interfaces and protocols, the BPM process engine is built to provide interfaces and drivers compatible with domestic databases.

[0043] Among them, the BPM process engine adopts the ORM framework to map the data tables in the database into objects, thereby ignoring the differences between different domestic databases, being compatible with a variety of different domestic databases, and enabling the BPM process engine to quickly migrate on different domestic databases.

[0044] Among them, this integration technology leverages the capabilities of the BPM process engine, through visual design and configuration, allowing the demand side to quickly build an information system that meets their own business needs, and can be adjusted at any time as business needs change.

[0045] It should be noted that the core of the integration technology of BPM process engine and domestic database is to summarize and integrate the SQL syntax of creation, query, insertion, update, deletion and other domestic databases based on the defined execution semantics and description format specifications to form a unified SQL syntax, so as to adapt to various domestic databases. Then use the SPI mechanism to call JDBC to load the database driver, obtain the database connection object Connection, establish a Socket connection with commonly used domestic databases such as Hangao, Dameng, Shentong, and Jincang, and use the Socket connection to write and read the BPM process form data in the form of binary data, and finally encapsulate it in the Resultset object. The BPM process engine contains components that interact with third-party systems, integrated syntax and customized SQL and code components. Through process arrangement and combined with business scenarios, the activiti process designer is used for visual process design. The data structure is maintained through the visual BO storage management page, the Form form is customized based on the BO storage, and mounted in the Process process. The form data generated by the operation of the process engine is written into the BO storage, and the DW data window is used to call the BO storage data for customized data view display, which supports tracking the operation record of the business process in the process instance monitoring.

[0046] The integration technology of BPM process engine and domestic database is widely used in various industries and scenarios, including government services, survey and design, healthcare, business operation, supply chain management, human resources, archives management, etc. The integration technology of BPM process engine and domestic database is mainly based on the microservice architecture to fully decouple the process engine, and use containerization technology to encapsulate the BPM process engine, so as to achieve elastic scaling of service-level resources, and build BPM process engine to provide interfaces and drivers compatible with domestic databases through standardized interfaces and protocols.

[0047] Taking the domestic databases currently common in the market, such as DAMO, Hangao, Shentong, and Renmin University of China Kingdee, as examples, when implementing integration with domestic databases, the BPM process engine adopts the ORM framework, which can map the data tables in the database as objects, thereby ignoring the differences between different domestic databases, and being compatible with a variety of different domestic databases, enabling the BPM process engine to quickly migrate on different domestic databases.

[0048] With the help of the BPM process engine, through visual design and configuration, the demand side can quickly build an information system that meets its own business needs, and can adjust it at any time as business needs change. Users only need to drag and click to realize the construction needs of digital business within the unit. At the same time, the BPM process engine provides powerful data integration capabilities, which can integrate the user's built information system, help users eliminate information islands, and realize the flow of data within and outside the unit. The BPM process engine simplifies complex codes into stable and reliable products, with a mature application framework, powerful business models, rich business templates, and an open component system. It comprehensively covers various business scenarios, providing organizations with an intelligent, platform-based, and electronic collaborative platform, and quickly helping users build Web applications that suit their own development needs.

[0049] The contents not described in detail in this specification belong to the prior art known to professionals in this field.

[0050] The above description is only a preferred embodiment of the present application and an explanation of the technical principles used. Those skilled in the art should understand that the scope of the invention involved in the present application is not limited to the technical solution formed by a specific combination of the above technical features, but should also cover other technical solutions formed by any combination of the above technical features or their equivalent features without departing from the inventive concept. For example, the above features are replaced with (but not limited to) technical features with similar functions disclosed in the present application.

Claims

1. Integration technology of BPM process engine and domestic database, characterized by: The core of this integrated technology is: S1. Based on the defined execution semantics and description format specifications, the SQL syntax for creation, query, insertion, update, and deletion of various domestic databases is summarized and integrated to form a unified SQL syntax to adapt to various domestic databases; S2, then use the SPI mechanism to call JDBC to load the database driver, obtain the database connection object Connection, and establish a Socket connection with commonly used domestic databases such as Hangao, Dameng, Shentong, and Jincang; S3, write and read BPM process form data in the form of binary data through Socket connection, and finally encapsulate it in Resultset object; S4. The BPM process engine includes components for interacting with third-party systems, integrated syntax and customized SQL and code components. Through process orchestration and combined with business scenarios, the activiti process designer is used for visual process design. The data structure is maintained through the visual BO storage management page. Form forms are customized based on BO storage and mounted into the Process process. The form data generated by the operation of the process engine is written into the BO storage. The DW data window is used to call the BO storage data for customized data view display, which supports tracking the operation records of business processes in process instance monitoring.

2. The integration technology of the BPM process engine and the domestic database according to claim 1 is characterized in that: The integration technology of BPM process engine and domestic database is applied in government services, survey and design, health care, business operations, supply chain management, human resources, and archives management.

3. The integration technology of the BPM process engine and the domestic database according to claim 1 is characterized in that: The error information resource pool is used to store unique error information detected in multiple concurrent requests to prevent the same error from being prompted to the user multiple times. When a network request fails, the system checks whether the error information is already in the resource pool. If not, the error information is added to the resource pool and the error prompt is displayed to the user. If it already exists, ignore this error and do not display it again.

4. The integration technology of the BPM process engine and the domestic database according to claim 1 is characterized in that: The integration technology of BPM process engine and domestic database fully decouples the process engine based on the microservice architecture, and encapsulates the BPM process engine using containerization technology, thereby achieving elastic scaling of service-level resources. Through standardized interfaces and protocols, the BPM process engine is built to provide interfaces and drivers that are compatible with domestic databases.

5. The integration technology of the BPM process engine and the domestic database according to claim 1 is characterized in that: The BPM process engine uses the ORM framework to map the data tables in the database into objects, thereby ignoring the differences between different domestic databases and being compatible with a variety of different domestic databases, allowing the BPM process engine to quickly migrate on different domestic databases.

6. The integration technology of the BPM process engine and the domestic database according to claim 1 is characterized in that: This integration technology leverages the capabilities of the BPM process engine, through visual design and configuration, to enable the demand side to quickly build an information system that meets their own business needs, and can be adjusted at any time as business needs change.

Images