Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

DB2 database static embedded SQL binding elegant deployment method

An embedded and database technology, applied in the field of data processing, can solve problems such as prolonging business interruption time, affecting customer experience, and damaging corporate reputation, and achieves the effects of ensuring smooth transition, reducing deployment risks, and ensuring business continuity

Pending Publication Date: 2020-12-08
CHINA CITIC BANK
View PDF0 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

Especially for some business systems that require 7*24 hours of no downtime window, they can only choose the system service low frequency period for downtime deployment, and at the same time, it is required to shorten the deployment time as far as possible from the deployment process to reduce the impact on the business, but for banking and other services Industries with high quality requirements not only need to interrupt the business, but once there is a deployment problem, it will prolong the business interruption time, affect the customer experience and damage the reputation of the enterprise, so there is still a large deployment risk

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • DB2 database static embedded SQL binding elegant deployment method

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0023] In order to understand the content of the present invention more clearly, it will be described in detail with reference to the drawings and embodiments.

[0024] Static embedded SQL programming in C language, writing .sqc source code files, connecting to the database through cataloging on the database client side, and compiling, the compilation process roughly went through several processes such as SQL analysis, semantic inspection, rewriting and optimization, and generation of execution plans .

[0025] After the SQC file is precompiled, a file with a bnd suffix will be generated. After the .bnd file is subjected to the bind operation, a package package can be generated in the database. During the process of creating the program package, the database manager will call these program packages when executing the program. SQL execution provides access to the database strategy; each compiled .bnd will generate a new time stamp, and it must be ensured that the time stamp of ...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

PUM

No PUM Login to View More

Abstract

The invention relates to a DB2 database static embedded SQL binding elegant deployment method. The method can automatically generate . bnd files with different attributes according to edited files submitted by developers, so that elegant deployment is realized during application server cluster deployment, and stock package in a database is not influenced during binding. According to the scheme, the problem of deployment failure caused by the fact that the package corresponding to the bound file is being used is solved, unnecessary shutdown of the whole cluster is avoided, the service continuity is ensured, and the deployment risk is reduced.

Description

technical field [0001] The invention relates to the technical field of data processing, in particular to an elegant deployment method for static embedded SQL binding of a DB2 database. Background technique [0002] DB2 is a relational database produced by IBM, which is widely used in finance, communication and other fields; DB2 database system provides users with various programming interfaces to meet various application requirements. SQL statements can be divided into two types from the perspective of compilation and operation, static SQL and dynamic SQL. Static SQL is widely favored by real-time transaction systems due to its stability and high performance, such as real-time payment transaction systems of banks; currently DB2 After the static SQL of the database is updated, the packages it depends on need to be bound. To avoid binding failures caused by the bound package being used, it is necessary to stop the application service for deployment. Especially for some busine...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

Application Information

Patent Timeline
no application Login to View More
Patent Type & Authority Applications(China)
IPC IPC(8): G06F16/16G06F16/14G06F8/65G06F8/41
CPCG06F16/16G06F16/164G06F16/148G06F16/152G06F16/166G06F8/65G06F8/41
Inventor 宋利国孙瑞浩潘杰黄柏超崔瑛石
Owner CHINA CITIC BANK
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products

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