TWI809956B - Business process control system with gray release and method thereof - Google Patents

Abstract

A business process control system with gray release and method thereof is disclosed. By executing a virtual machine on a host, and executing a dispatch program on the virtual machine, the dispatch program is connected to a first database through a first business process control service, and is connected to a second database through a second business process control service. Next, the dispatch program queries an identification code according to a serial number of a board, and then queries a corresponding path according to the identification code, and then selects one of the first business process control service and the second business process control service through the found path, so as to be able to execute a store program in a supported database.

Description

Business process control system and method with gray scale publishing

The invention relates to a business process control system and method thereof, in particular to a business process control system and method with gray scale publishing.

Generally speaking, traditional business process control services can only configure one database. When the system version is upgraded, such as: "PCA 1.0" is upgraded to "PCA 2.0", the old version will not be able to continue to be used, because the old and new versions use The databases are different, and one business process control service can only configure one database, so there is a problem that the new version and the old version cannot coexist.

In view of this, some manufacturers have proposed a technical means of directly modifying the database link relationship, which determines the ownership of the current board, and then directly modifies the link relationship to connect to the corresponding database to execute the stored program. However, this method may affect the current board test process when it is modified, and there is a risk of production line shutdown, that is to say, it cannot support the test of the old and new versions at the same time, so it is impossible to achieve splitting and gray release (Gray release) ) question.

To sum up, it can be seen that there has been a problem in the prior art for a long time that it is impossible to realize splitting and grayscale release, so it is necessary to propose improved technical means to solve this problem.

The invention discloses a business process control system and method with gray-scale publishing.

Firstly, the present invention discloses a business process control system with gray-scale release, which is applied in the environment of testing printed circuit devices. The system includes: a first database, a second database and a host. Among them, the first database is connected to the old business process control service and the first business process control service to allow the printed circuit device to execute the stored program; the second database is connected to the second business process control service to allow the printed circuit device to execute the stored program program; the host includes: a processing unit, a selection module and a scheduling module. Wherein, the processing unit is used to execute the virtual machine, and execute the scheduler on the virtual machine, wherein the scheduler is respectively connected to the first business process control service and the second business process control service, and allows receiving paths and service requests from upstream running terminals ; Select the module connection processing unit to query the identification code corresponding to the board serial number when the service request received by the scheduler contains the board serial number, and find out the corresponding path from the second database according to the identification code , and then select one of the first business process control service and the second business process control service through the detected path; and the scheduling module is connected to the selection module, used when the scheduling program selects the first business process control service , allowing the printed circuit device corresponding to the serial number of the board to connect to the first database through the first business process control service to execute the stored program. When the scheduler selects the second business process control service, the printed circuit device is allowed to pass the second business process control service The service is connected to the second database to execute the stored procedure.

In addition, the present invention also discloses a business process control method with grayscale release, which is applied in the environment of testing printed circuit devices, and the steps include: providing a host, which is connected to the first database and the second database, and executes Legacy business process control service; the host machine executes a virtual machine and executes a scheduler on the virtual machine, wherein the scheduler is connected to the first business process control service and the second business process control service respectively and allows the receiving path and from the upstream to run When the service request received by the scheduler includes the serial number of the board, query the identification code corresponding to the serial number of the board, and find out the corresponding path from the second database according to the identification code, and then check the The route selects one of the first business process control service and the second business process control service; and when the scheduler selects the first business process control service, allows the printed circuit device corresponding to the serial number of the board to pass through the first business process control service The process control service is connected to the first database to execute the stored program, and when the scheduler selects the second business process control service, the printed circuit device is allowed to connect to the second database to execute the stored program through the second business process control service.

The system and method disclosed in the present invention are as above, and the difference from the prior art is that the present invention executes a virtual machine on the host, and executes a scheduler on the virtual machine, and the scheduler is connected to the first data through the first business process control service Library, and connected to the second database through the second business process control service, then, the scheduler queries the identification code according to the serial number of the board, and then queries the corresponding path according to the identification code, and then uses the found path in the first business process control Select one of the service and the second business process control service to be able to execute stored procedures in the supported database.

Through the above-mentioned technical means, the present invention can achieve the technical effect of improving the feasibility of splitting and grayscale publishing.

The implementation of the present invention will be described in detail below in conjunction with the drawings and examples, so as to fully understand and implement the implementation process of how the present invention uses technical means to solve technical problems and achieve technical effects.

Please refer to "Figure 1" first, "Figure 1" is a system block diagram of the business process control system with grayscale distribution of the present invention, which is applied in the environment of testing printed circuit devices (or "boards"), here The system includes: a first database 111 , a second database 112 and a host 120 . Wherein, the first database 111 is connected to the old business process control service and the first business process control service to allow the printed circuit device to execute the stored program. In actual implementation, the first database 111 is a database that supports the old version such as: "PCA 1.0" system. When testing printed circuit devices, the old business process control service and the first business process control service can be connected to the first A database 111 is used to execute corresponding storage procedures, such as uploading test results.

The second database 112 is connected to the second business process control service for allowing the printed circuit device to execute the stored program. In actual implementation, the second database 112 is a database used by a system supporting new versions such as "PCA 2.0". Likewise, when testing the printed circuit device, the second database 112 can be connected to the second database 112 through the second business process control service to execute corresponding storage procedures, for example, upload test results. In addition, the information of the printed circuit device can also be obtained, such as: identification code, model, path, attribute value and so on. Wherein, the attribute value may include text, symbol, numerical value or a combination thereof, such as "CP70", "CP72" and so on.

The host 120 includes: a processing unit 121 , a selection module 122 and a scheduling module 123 . Wherein, the processing unit 121 is used to execute a virtual machine (Virtual Machine, VM), and execute a scheduler on the virtual machine, wherein the scheduler is respectively connected to the first business process control service and the second business process control service, and allows the receiving path And service requests from upstream runtimes. In practical implementation, the first database 111 can be connected through the first business process control service; the second database 112 can be connected through the second business process control service. In addition, when the virtual machine runs successfully, the old business process control service executed by the host will be disabled, and the upstream running end will route the service request (Routing) to the scheduler, and when the scheduler stops executing, it will be enabled The old business process control service of the host 120 makes the upstream running end route the service request to the old business process control service to achieve high availability (High Availability, HA). In addition, the scheduling program has the same port number as the old business process control service, so that when the upstream running end switches between the host and the virtual machine, it only needs to change the network address without changing the port number to be able to connect normally.

The selection module 122 is connected to the processing unit 121, and is used for inquiring about the identification code corresponding to the serial number of the board when the service request received by the scheduler includes the serial number of the board, and according to the identification code from the pre-stored configuration file or the second The database 112 finds out the corresponding path, and then selects one of the first business process control service and the second business process control service through the found path. In other words, the scheduler will obtain the identification code (Identifier, Id) corresponding to the serial number (Serial Number, SN) of the board, and then, according to the identification code, select the configuration file stored in the selection module 122 or the database Find out the corresponding path (Uniform Resource Locator, URL), and then use the corresponding first business process control service or the second business process control service to connect to the corresponding database through the found out path, such as: the first database 111 ( support "PCA 1.0") or the second database 112 (support "PCA 2.0"). In actual implementation, the virtual machine can also query the corresponding model from the second database 112 according to the serial number of the board. , the scheduler selects the second business process control service, and when the attribute value is a default value (such as "CP70" or "CP72"), the scheduler selects the first business process control service, and when the attribute value is not preset for this value, the scheduler selects the second business process control service.

The scheduling module 123 is connected to the selection module 122, so that when the scheduling program selects the first business process control service, the printed circuit device corresponding to the serial number of the board is allowed to connect to the first database 111 through the first business process control service to perform storage The program, when the scheduler selects the second business process control service, allows the printed circuit device to connect to the second database 112 to execute the stored program through the second business process control service. In this way, the grayscale release can be completed, so that the old version of the printed circuit board device can use the first database 111, while the new version of the printed circuit board device can use the second database 112, and the new version and the old version can be separated and smoothed. over.

In particular, it should be noted that in actual implementation, the modules described in the present invention can be implemented in various ways, including software, hardware or any combination thereof. For example, in some implementations, each module can use software and hardware or one of them. In addition, the present invention can also be realized partially or completely based on hardware. For example, one or more modules in the system can be implemented through integrated circuit chips, system Single chip, complex programmable logic device (Complex Programmable Logic Device, CPLD), field programmable logic gate array (Field Programmable Gate Array, FPGA) and so on. The present invention can be a system, method and/or computer program. The computer program may include a computer-readable storage medium loaded with computer-readable program instructions for causing a processor to implement various aspects of the present invention, the computer-readable storage medium may be a tangible and equipment. A computer readable storage medium may be, but is not limited to, an electrical storage device, a magnetic storage device, an optical storage device, an electromagnetic storage device, a semiconductor storage device, or any suitable combination of the foregoing. More specific examples (non-exhaustive list) of computer-readable storage media include hard disks, random access memory, read-only memory, flash memory, optical disks, floppy disks, and any suitable combination of the foregoing. As used herein, computer-readable storage media are not to be construed as transient signals per se, such as radio waves or other freely propagating electromagnetic waves, electromagnetic waves propagating through waveguides or other transmission media (for example, optical signals through fiber optic cables), or transmitted electrical signals. Additionally, the computer-readable program instructions described herein may be downloaded from a computer-readable storage medium to various computing/processing devices, or downloaded over a network, such as the Internet, local area network, wide area network, and/or wireless network to an external computer device or external storage device. The network may include copper transmission cables, fiber optic transmission, wireless transmission, routers, firewalls, switches, hubs and/or gateways. The network card or network interface in each computing/processing device receives computer-readable program instructions from the network and forwards the computer-readable program instructions for storage in computer-readable storage media in each computing/processing device middle. The computer program instructions for performing the operations of the present invention may be assembly language instructions, instruction set architecture instructions, machine instructions, machine-related instructions, micro instructions, firmware instructions, or source code or object code written in any combination of one or more programming languages (Object Code), the programming language includes object-oriented programming languages, such as: Common Lisp, Python, C++, Objective-C, Smalltalk, Delphi, Java, Swift, C#, Perl, Ruby and PHP, etc., as well as conventional programs Procedural programming language, such as: C language or similar programming language. The computer program instructions may be executed entirely on the computer, partly on the computer, as a stand-alone piece of software, partly on the client computer and partly on the remote computer, or entirely on the remote computer or server to execute.

Please refer to "Figure 2A" and "Figure 2B". "Figure 2A" and "Figure 2B" are the method flow charts of the business process control method with grayscale publishing of the present invention, which are applied in the environment of testing printed circuit devices , the steps include: providing a host 120, which is connected to the first database 111 and the second database 112, and executes the old business process control service; (step 210); the host 120 executes a virtual machine, and on the virtual machine Executing a scheduler, wherein the scheduler is respectively connected to the first business process control service and the second business process control service, and allows receiving paths and service requests from the upstream running end (step 220); when the scheduler receives the service request When including the serial number of the board card, query the identification code corresponding to the serial number of the board card, and find out the corresponding path from the second database 112 according to the identification code, and then use the found path in the first business process control service and the second Select one of the two business process control services (step 230); and when the scheduler selects the first business process control service, allow the printed circuit device corresponding to the board serial number to connect to the first business process control service through the first business process control service The database 111 executes the stored program, and when the scheduler selects the second business process control service, the printed circuit device is allowed to connect to the second database 112 to execute the stored program through the second business process control service (step 240 ). In this way, by executing the virtual machine on the host 120 and executing the scheduler on the virtual machine, the scheduler is connected to the first database 111 through the first business process control service, and connected to the database 111 through the second business process control service. to the second database 112, then, the scheduler queries the identification code according to the serial number of the board, and then queries the corresponding path according to the identification code, and then passes the found path between the first business process control service and the second business process control service Select one of these to be able to execute stored procedures on supported databases.

In addition, after step 230, the virtual machine can query the corresponding model from the second database 112 according to the serial number of the board (step 231); when the model is found and its corresponding attribute value enables the new version , the scheduler selects the second business process control service (step 232); and when the attribute value is a preset value, the scheduler selects the first business process control service, and when the attribute value is not a preset value, the scheduler selects the second Business process control service (step 233). In other words, in addition to querying the identification code according to the board serial number, you can also query the corresponding model, and choose between the first business process control service and the second business process control service according to the attribute value corresponding to the model one.

The following description will be made in the form of an embodiment in conjunction with "Figure 3" and "Figure 4". Please refer to "Figure 3" first. Firstly, in the traditional way, the upstream running end 310 connects to the first database 111 supporting the old version (such as "PCA 1.0") via the old business process control service 300 to execute the stored program. However, when upgrading from an old version to a new version (such as "PCA 2.0"), since the databases used by the two are different, and one business process control service can only be configured with one database, the old and new versions cannot be supported at the same time. Therefore, the host machine 120 applying the present invention will execute the virtual machine 320, and execute the scheduler 321 on the virtual machine. The scheduler 321 is respectively connected to the first business process control service 331 and the second business process control service 332, and allows The path and the service request from the upstream running end 310 are received from the second database 112 . Assuming that the service request received by the dispatcher 321 contains the serial number of the board, and finds out that the identification code corresponding to the serial number of the board is "204", at this time, the corresponding path will be found from the second database 112 according to the identification code. , such as: "http://127.0.0.1:8888/pcabiz", assuming that this path is the path of the first database 111, then the scheduler 321 will select the first business process control service 331, and then allow the The printed circuit device is connected to the first database 111 through the first business process control service 331 to execute the stored program. On the contrary, suppose that the identification code corresponding to the serial number of the board card is found to be "166", at this time, the corresponding path will be found from the second database 112 according to the identification code, such as: "http://127.0.0.1:6666 /pcabiz", assuming that this path is the path of the second database 112, the scheduler 321 will select the second business process control service 332, and then allow the printed circuit device corresponding to the board serial number to be connected through the second business process control service 332 To the second database 112 to execute the stored procedure. So far, the old and new versions are supported at the same time, and splitting and grayscale release are realized.

As shown in "Fig. 4", "Fig. 4" is a schematic diagram of the service scheduling method of the present invention. In actual implementation, the selection of the first business process control service 331 or the second business process control service 332 is determined according to the routing logic 400, and the routing logic 400 can be pre-stored in the configuration file of the selection module 122 or the second data In library 112, it is used to record the corresponding relationship between the current identification code and the path. Assuming that the identified identification code is "204", the scheduler 321 will obtain its corresponding path according to the routing logic 400 "http://127.0.0.1:8888 /pcabiz", when the first database 111 of this path supports the old version (PCA 1.0), the scheduler 321 will select the first business process control service 331 to allow the printed circuit device to connect through the first business process control service 331 Go to the first database 111 to execute the stored program. Assuming that the queried identification code is "166", the scheduler 321 will obtain its corresponding path "http://127.0.0.1:6666/pcabiz" according to the routing logic 400, when the second database 112 of this path supports the new version (PCA 2.0), the scheduler 321 will select the second business process control service 332 to allow the printed circuit device to connect to the second database 112 through the second business process control service 332 to execute the stored program. In addition, a query window 410 can also be provided, allowing the user to input the serial number of the board in the input block 411, and then click the button, such as: query the identification code 412 of the serial number of the temporarily stored board to query the identification code , so as to be used as a reference for editing (eg adding, deleting or modifying) the routing logic 400 .

In summary, it can be seen that the difference between the present invention and the prior art lies in that by executing a virtual machine on the host, and executing a scheduler on the virtual machine, the scheduler is connected to the first database through the first business process control service, and Connect to the second database through the second business process control service, then, the scheduler queries the identification code according to the serial number of the board, and then queries the corresponding path according to the identification code, and then uses the found path in the first business process control service and the second database Choose one of the two business process control services, so that the storage program can be executed in the supported database. This technical means can solve the problems existing in the previous technology, and then achieve the feasibility of improving distribution and grayscale release. Technical efficacy.

Although the present invention is disclosed above with the aforementioned embodiments, it is not intended to limit the present invention. Any person familiar with similar skills may make some changes and modifications without departing from the spirit and scope of the present invention. Therefore, the present invention The scope of patent protection shall be subject to what is defined in the scope of patent application attached to this specification.

111: First database 112:Second database 120: Host 121: Processing unit 122:Select module 123: Scheduling module 300: Legacy Business Process Control Services 310: upstream running end 320:Virtual machine 321:Scheduler 331:First business process control service 332:Second business process control service 400: Routing logic 410: query window 411: Input block 412: Query the identification code of the temporarily stored board serial number Step 210: Provide a host, the host is interconnected with a first database and a second database, and executes an old business process control service Step 220: The host executes a virtual machine, and executes a scheduler on the virtual machine, wherein the scheduler is respectively connected to a first business process control service and a second business process control service, and is allowed to receive a path and A service request from an upstream operator Step 230: When the dispatcher receives a board serial number included in the service request, query an identification code corresponding to the board serial number, and select from a pre-stored configuration file or the second data according to the identification code The library finds out the corresponding path, and then selects one of the first business process control service and the second business process control service through the found path Step 231: the virtual machine queries a corresponding model from the second database according to the serial number of the board Step 232: When the model is found and its corresponding attribute value is a new version enabled, the scheduler selects the second business process control service Step 233: When the attribute value is a preset value, the scheduler selects the first business process control service, and when the attribute value is not the preset value, the scheduler selects the second business process control service Step 240: When the scheduler selects the first business process control service, allow the printed circuit device corresponding to the board serial number to connect to the first database through the first business process control service to execute a stored program. When the scheduler selects the second business process control service, allowing the printed circuit device to connect to the second database through the second business process control service to execute the stored program

Fig. 1 is a system block diagram of the business process control system with gray scale publishing in the present invention. FIG. 2A and FIG. 2B are method flow charts of the business process control method with grayscale publishing in the present invention. Fig. 3 is a schematic diagram of implementing the offloading of business process control services by applying the present invention. FIG. 4 is a schematic diagram of a service scheduling method applying the present invention.

111: First database

112:Second database

120: Host

121: Processing unit

122:Select module

123: Scheduling module

Claims (10)

A business process control system with grayscale release, applied in the environment of testing a printed circuit device, the system includes: a first database connected to a legacy business process control service and a first business process control service for allowing the printed circuit device to execute a stored program; a second database connected to a second business process control service for allowing the printed circuit device to execute the stored procedure; and A host, the host is connected to the first database and the second database, and executes the old business process control service, the host includes: a processing unit, configured to execute a virtual machine, and execute a scheduler on the virtual machine, wherein the scheduler is respectively connected to the first business process control service and the second business process control service, and is allowed to receive a path and a service request from an upstream operator; A selection module, connected to the processing unit, is used for inquiring an identification code corresponding to the serial number of the board when the service request received by the dispatcher includes a serial number of the board, and according to the identification code from pre-stored Find the corresponding path from a configuration file or the second database, and select one of the first business process control service and the second business process control service through the found path; and a dispatching module, connected to the selection module, for allowing the printed circuit device corresponding to the serial number of the board to be connected to the first business process control service when the dispatcher selects the first business process control service The first database executes the stored program, and when the dispatcher selects the second business process control service, the printed circuit device is allowed to connect to the second database through the second business process control service to execute the stored program. As for the business process control system with gray-scale release of claim 1, wherein the scheduler has the same port number as the old business process control service, so that when the upstream running terminal is switched between the host and the virtual machine, There is no need to change the port number. Such as the business process control system with gray-scale release of claim item 1, wherein the virtual machine queries a corresponding model from the second database according to the serial number of the board, when the model is found and its corresponding attribute value To enable a new version, the dispatcher selects the second business process control service, and when the property value is a default value, the dispatcher selects the first business process control service, and when the property value is not When the preset value is selected, the scheduler selects the second business process control service. As in the business process control system with gray-scale publishing of claim item 1, when the virtual machine runs successfully, disable the old business process control service executed by the host, and make the upstream running end route the service request to the dispatcher A program for enabling the old business process control service of the host and routing the service request to the old business process control service at the upstream running end when the scheduler stops executing. For example, the business process control system with grayscale release of claim 3, wherein the attribute value includes text, symbol, numerical value or a combination thereof. A business process control method with grayscale release, applied in the environment of testing a printed circuit device, the steps include: providing a host, the host is interconnected with a first database and a second database, and executes a legacy business process control service; The host executes a virtual machine, and executes a scheduler on the virtual machine, wherein the scheduler is respectively connected to a first business process control service and a second business process control service, and allows receiving a path and an upstream A service request from the running side; When the dispatcher receives a board serial number contained in the service request, query an identification code corresponding to the board serial number, and search out from a pre-stored configuration file or the second database according to the identification code Corresponding to the path, and selecting one of the first business process control service and the second business process control service through the found path; and When the dispatcher selects the first business process control service, the printed circuit device corresponding to the serial number of the board is allowed to connect to the first database through the first business process control service to execute a stored procedure, when the dispatcher When the second business process control service is selected, the printed circuit device is allowed to connect to the second database through the second business process control service to execute the stored program. As for the business process control method with gray-scale release of claim 6, wherein the scheduler has the same port number as the old business process control service, so that when the upstream running terminal is switched between the host and the virtual machine, There is no need to change the port number. For example, the business process control method with grayscale release of claim 6, wherein the method further includes: The virtual machine queries a corresponding model from the second database according to the serial number of the board; When the model is found and its corresponding attribute value is enable a new version, the scheduler selects the second business process control service; and When the attribute value is a preset value, the dispatcher selects the first business process control service, and when the attribute value is not the preset value, the dispatcher selects the second business process control service. The business process control method with gray-scale publishing as in claim 6, wherein when the virtual machine runs successfully, disable the old business process control service executed by the host, and make the upstream running end route the service request to the dispatcher A program for enabling the old business process control service of the host and routing the service request to the old business process control service at the upstream running end when the scheduler stops executing. For example, the business process control method with grayscale publishing according to claim 8, wherein the attribute value includes text, symbol, numerical value or a combination thereof.

Images