The Design And Implementation Of Database Engine Trigger Mechanism For Process Manager

Since the21st century, the development of different industries is inseparable from the support of scheduling software. Financial securities trading or oil and gas exploitation, government agencies office system or the rapid development of digital media, all of which are relying on the high-performance load management platform. Therefore, how to make business decisions and intelligent, policy-driven scheduling strategy in product development is particularly important. And PM (Process Manager) in this kind of software, arises at the historic moment in order to meet the changes of different job scheduling way. To satisfy customer demand for the purpose, it is particularly important that how to design a better and more convenient engine triggering mechanism for job scheduling, so Platform Computing department puts forward to designing a new way of trigger.Papers with HPC (High Performance Computing) environment as the background, analyzes the current risk under complicated technology and the explosive growth of data. Through the PM job stream control which can significantly improve the quality of operation and reduce the risk greatly at the same time.As the important part of LSF (Load Sharing Facility), PM allows customers to process operation flow under a variety of different operating system environment, such as Windows, Unix, which provides different engine mechanism to trigger the running of the operation flow.In this paper, a new type of database engine triggering mechanism is developed with C++language, through the new mechanism to control and manage the job or job flow, the project mainly includes the following several modules: multi-threaded database polling module, SQL trigger storage module, SQL event generator module, SQL agent module. Multi-threaded database polling module explained how to use the polling thread under different database changes; SQL trigger storage module explained the SQL event trigger saving form; SQL event generator module, as the most important module, illustrates the SQL event in a series of process containing generation, running and end. SQL agent module to explain how the SQL event trigger events in the process of concrete process is triggered.Through actual cooperating with LSF running, the result proved that the function of database engine in PM, which can determine the change of job or job flow mechanism through the change of the database. It can be successful cooperation also with other engine, achieving the goal of final design work executed correctly. Not only it satisfy the functional requirements of the process manager, but also the trigger has reached the non-functional requirements at the same time, which would be applicability in the high performance computing environment.