CN114238521B - High-availability deployment method and device for bank core system database and electronic equipment - Google Patents

High-availability deployment method and device for bank core system database and electronic equipment Download PDF

Info

Publication number
CN114238521B
CN114238521B CN202210174104.9A CN202210174104A CN114238521B CN 114238521 B CN114238521 B CN 114238521B CN 202210174104 A CN202210174104 A CN 202210174104A CN 114238521 B CN114238521 B CN 114238521B
Authority
CN
China
Prior art keywords
database
main
core system
databases
oracle
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Active
Application number
CN202210174104.9A
Other languages
Chinese (zh)
Other versions
CN114238521A (en
Inventor
罗烨敏
陈景荣
何良玉
林锋
黄志刚
林炯怀
李林东
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Meizhou Merchants Bank Co ltd
Original Assignee
Meizhou Merchants Bank Co ltd
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by Meizhou Merchants Bank Co ltd filed Critical Meizhou Merchants Bank Co ltd
Priority to CN202210174104.9A priority Critical patent/CN114238521B/en
Publication of CN114238521A publication Critical patent/CN114238521A/en
Application granted granted Critical
Publication of CN114238521B publication Critical patent/CN114238521B/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Images

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/27Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F11/00Error detection; Error correction; Monitoring
    • G06F11/07Responding to the occurrence of a fault, e.g. fault tolerance
    • G06F11/14Error detection or correction of the data by redundancy in operation
    • G06F11/1402Saving, restoring, recovering or retrying
    • G06F11/1446Point-in-time backing up or restoration of persistent data
    • G06F11/1458Management of the backup or restore process
    • G06F11/1464Management of the backup or restore process for networked environments
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F11/00Error detection; Error correction; Monitoring
    • G06F11/07Responding to the occurrence of a fault, e.g. fault tolerance
    • G06F11/14Error detection or correction of the data by redundancy in operation
    • G06F11/1402Saving, restoring, recovering or retrying
    • G06F11/1446Point-in-time backing up or restoration of persistent data
    • G06F11/1458Management of the backup or restore process
    • G06F11/1469Backup restoration techniques
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/21Design, administration or maintenance of databases
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/28Databases characterised by their database models, e.g. relational or object models
    • G06F16/284Relational databases
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06QINFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
    • G06Q40/00Finance; Insurance; Tax strategies; Processing of corporate or income taxes
    • G06Q40/02Banking, e.g. interest calculation or account maintenance
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F2201/00Indexing scheme relating to error detection, to error correction, and to monitoring
    • G06F2201/80Database-specific techniques

Abstract

The invention discloses a high-availability deployment method and device for a bank core system database and electronic equipment. The method comprises the following steps: at least two types of main databases are arranged in the database of the bank core system; simultaneously constructing all database tables used by the bank core system in all the main databases, and selecting one main database as a main data source for each database table; establishing a configuration file of the corresponding relation between the database table and the main database according to a main data source of the database table; when a database table with a certain main database as a main data source is updated, the updated data is synchronized to other main databases by using a heterogeneous data synchronization tool. The invention simultaneously stores the same business data in at least two types of databases, when one type of database is unavailable in products or services, the other type of database can still be relied on to ensure the normal operation of a bank core system, and the invention has stability and high availability and can realize the free advance and retreat between different types of databases.

Description

High-availability deployment method and device for bank core system database and electronic equipment
Technical Field
The invention relates to the technical field of computers, in particular to a high-availability deployment method and device for a bank core system database and electronic equipment.
Background
The financial industry, especially the banking industry, is always at the front of informatization and digitization, and the particularity of the industry determines that the banking industry has very high requirements on the stability, safety and accuracy of an information system. The database is a data base for the normal operation of the bank core system, so that the stability and the safety of the database have very important significance in the bank informatization development process.
Currently, in the process of bank information system development, certain specific brands of databases are mainly relied on. The uniqueness of the database brand has great potential safety hazards and risks for the stability and safety of the banking system. For example, if the database product and technology of the brand cannot be obtained or the database of the specific brand cannot be used any more due to the technical obstacle, the bank core system will not operate normally.
Disclosure of Invention
In order to solve the problems in the prior art, the invention provides the following technical scheme.
The invention provides a high-availability deployment method of a bank core system database on one hand, which comprises the following steps:
at least two types of main databases are arranged in the bank core system database;
simultaneously constructing all database tables used by the bank core system in all the main databases, and selecting one main database as a main data source for each database table;
establishing a configuration file of the corresponding relation between the database table and the main database according to a main data source of the database table;
when a database table with a certain main database as a main data source is updated, the updated data is synchronized to other main databases by using a heterogeneous data synchronization tool.
Preferably, the master database includes an Oracle master database and a Damomeng master database.
Preferably, the heterogeneous data synchronization tool is dreams DHMS.
Preferably, the Oracle master database and the Dammame master database both adopt a cluster mode.
Preferably, the Oracle main database adopts an Oracle RAC cluster mode, and the Damemg main database adopts a Damemg DSC cluster mode.
Preferably, a standby database corresponding to the type of the main database is further arranged in the bank core system database, and data in the main database is synchronized to the standby database of the corresponding type.
Preferably, the standby database comprises an Oracle standby database and a Dameng standby database; the data of the Oracle main database is synchronized into the Oracle standby database through DataGuard, and the data of the dreamin main database is synchronized into the dreamin standby database through DataWatch.
The second aspect of the present invention provides a high-availability deployment apparatus for a bank core system database, including:
the main database setting module is used for setting at least two types of main databases in the database of the bank core system;
the database table construction module is used for simultaneously constructing all database tables used by the bank core system in all the main databases, and each database table selects one main database as a main data source;
the configuration file establishing module is used for establishing a configuration file of the corresponding relation between the database table and the main database according to the main data source of the database table;
and the updating synchronization module is used for synchronizing the updating data to other main databases by using a heterogeneous data synchronization tool when the database table taking a certain main database as a main data source is updated.
The invention also provides a memory storing a plurality of instructions for implementing the method as described above.
The invention also provides an electronic device comprising a processor and a memory connected to the processor, wherein the memory stores a plurality of instructions which can be loaded and executed by the processor to enable the processor to execute the method.
The invention has the beneficial effects that: the invention provides a high-availability deployment method, a high-availability deployment device and electronic equipment for a bank core system database. The invention simultaneously stores the same service data in at least two types of databases, when one type of database is unavailable in products or services, the other type of database can still be relied on, thereby ensuring the normal operation of a bank core system and the stability and high availability of the system; and the database can be moved in and out among different types of databases, and finally, the gradual replacement of the database of the new technology is realized. Therefore, the technical scheme provided by the invention has the characteristics of stability and innovation.
Drawings
Fig. 1 is a schematic flow chart of a high-availability deployment method for a bank core system database according to the present invention;
fig. 2 is a schematic diagram of a specific example of a high-availability deployment method of a bank core system database according to the present invention;
FIG. 3 is a schematic diagram of an exemplary application of a bank core system database according to the present invention;
fig. 4 is a schematic structural diagram of a high-availability deployment device of a bank core system database according to the present invention.
Detailed Description
In order to better understand the technical solution, the technical solution will be described in detail with reference to the drawings and the specific embodiments.
The method provided by the invention can be implemented in the following terminal environment, and the terminal can comprise one or more of the following components: a processor, a memory, and a display screen. Wherein the memory has stored therein at least one instruction that is loaded and executed by the processor to implement the methods described in the embodiments described below.
A processor may include one or more processing cores. The processor connects various parts within the overall terminal using various interfaces and lines, performs various functions of the terminal and processes data by executing or executing instructions, programs, code sets, or instruction sets stored in the memory, and calling data stored in the memory.
The Memory may include a Random Access Memory (RAM) or a Read-Only Memory (ROM). The memory may be used to store instructions, programs, code sets, or instructions.
The display screen is used for displaying user interfaces of all the application programs.
In addition, those skilled in the art will appreciate that the above-described terminal configurations are not intended to be limiting, and that the terminal may include more or fewer components, or some components may be combined, or a different arrangement of components. For example, the terminal further includes a radio frequency circuit, an input unit, a sensor, an audio circuit, a power supply, and other components, which are not described herein again.
Example one
As shown in fig. 1, an embodiment of the present invention provides a high-availability deployment method for a database of a bank core system, including:
s101, the bank core system database is provided with at least two types of main databases;
s102, simultaneously constructing all database tables used by the bank core system in all main databases, and selecting one main database as a main data source from all the database tables;
s103, establishing a configuration file of the corresponding relation between the database table and the main database according to the main data source of the database table;
and S104, when a database table with a certain main database as a main data source is updated, synchronizing the updated data to other main databases by using a heterogeneous data synchronization tool.
In the method, the various types of main databases are adopted to jointly form the database of the bank core system, the database tables of the same service data are simultaneously constructed in all the main databases, and the database tables are synchronized to other main databases in real time when data updating occurs, so that when one type of main database has problems, such as products or technologies are unavailable or unavailable, other types of main databases can be used, the bank core system can be ensured to normally operate, and the risk caused by excessive dependence on a certain brand of database in the prior art is avoided. Moreover, the method provided by the invention can realize seamless butt joint of the new database and the old database, and further replace the old database with the new database. Under the condition of capacity expansion of the bank core system service, the capacity expansion of the whole database can be well realized by expanding the new database. For example, in the early stage of use, more important database tables may be the primary data source for the old database (or mature database), and less non-important database tables may be the primary data source for the new database (or developing database). And when the operation of the new database is stable, taking the new database as a main data source for more database tables. Because the data of the bank core system is simultaneously stored in the new database and the old database, when the use scale needs to be enlarged, only the configuration file of the corresponding relation between the database table and the main database needs to be modified, more database tables or even all database tables can be used as the main data source by using the new database, and the complete replacement and smooth transition of the new database are realized. When the old database is not available, the data loss and the non-operation of the bank core system are not caused.
In step S101, the main database set in the bank core system database may include any type of database in the prior art, such as commonly used databases mysql, oracle, sqlserver, sqlite, etc., and a domestic dreams database, etc. At least two types of the databases may be deployed in the bank core system database, that is, at least two types of the databases are included in the bank core system database. For example, in a preferred embodiment of the present invention, an Oracle main database and a dreams main database (dreams database is abbreviated as DM) are provided in the bank core system database. When different types of databases are deployed in the database of the bank core system, corresponding heterogeneous data synchronization tools can be adopted to realize data synchronization, so that the same business data is guaranteed to be stored in all types of main databases. For example, in a preferred embodiment of the present invention, when the master database includes an Oracle master database and a dreams master database, the heterogeneous data Synchronization tool is dreams dhms (heterogeneous database Synchronization for dm). The Dameng DHMS is synchronous software of heterogeneous databases, and can realize data synchronization between the Dameng database and the Oracle database. For data synchronization between other types of databases, corresponding prior art methods may be employed.
In a preferred embodiment of the present invention, the Oracle master database and the dreams master database both use a cluster method. Wherein, the Oracle main database adopts an Oracle RAC (Real Application Cluster) clustering mode, and the Damamch main database adopts a Damamch DSC (data Shared Cluster) clustering mode. The Oracle RAC cluster technology can realize the functions of multi-node load balancing, fault tolerance and seamless switching. The Dameng DSC cluster technology can realize the functions of multi-node load balancing, fault tolerance and seamless switching.
In another preferred embodiment of the present invention, a backup database corresponding to a type of a primary database is further provided in the bank core system database, and data in the primary database is synchronized to the backup database of the corresponding type.
Wherein the standby database comprises an Oracle standby database and a Damomeng standby database; the Oracle standby database corresponds to the Oracle main database, and in the using process, the data of the Oracle main database is synchronized into the Oracle standby database through the DataGuard; the dreaming standby database corresponds to the dreaming master database, and during use, the data of the dreaming master database are synchronized into the dreaming standby database through DataWatch. Wherein, DataGuard is data synchronization software between Oracle main database and Oracle standby database. The method ensures the synchronization of data through log synchronization between the main node and the standby node, and can realize the quick switching and the catastrophic recovery of the database. DataWatch is data synchronization software between the dreams main database and the dreams standby database, and is used for realizing data synchronization between the main database and the standby database. The DataGuard and DataWatch data synchronization software are prior art and the principles and methods of use thereof are not described in detail herein.
In the embodiment of the invention, although the data synchronization is only performed between the heterogeneous main libraries, the data synchronization is performed between the homogeneous main libraries and the standby libraries, and the data synchronization is not performed between the heterogeneous main libraries and the standby libraries in the specific deployment method. For example, data synchronization is performed between the Oracle main library and the Dameng main library, data synchronization is performed between the Oracle main library and the Oracle standby library, and data synchronization is performed between the Dameng main library and the Dameng standby library. However, since the database tables are included in all the primary libraries, and the data of the primary libraries are synchronized to the backup libraries of the corresponding types, the same database tables are also stored in the primary libraries and the backup libraries of different types, that is, all the database tables used by the bank core system are also stored in the backup libraries.
In step S102, in order to store all the business data in all the main databases, when the databases are deployed, all the database tables used by the bank core system are simultaneously constructed in all the main databases, only the main data sources selected by the database tables are different, for example, one main database is selected as a main data source by some of the database tables, and the other main database is selected as a main data source by some of the database tables.
In one embodiment of the invention, the master databases include an Oracle master library and a Damomeng master library, wherein partial Table A1,A2,……,AnSelecting Oracle master library as a main data source and the other part of table B1,B2,……,BnSelects Dameng master library as main data source, all tables A1,A2,……,An,B1,B2,……,BnBoth in the Oracle master library and in the dreams master library, as shown in fig. 2.
In step S103, a configuration file may be established according to a primary data source of the database table, and a corresponding relationship between the database table and the primary database is determined, so as to find a primary database corresponding to the database table during application, and perform corresponding operations, such as query and update. As an example, database table A1The main data source is Oracle main library, and then in the configuration file, a database table A needs to be established1Correspondence to Oracle Master library, e.g. database Table A1Corresponding to the address of Oracle main library, the application program needs to have a database table A1When the operation is carried out, the operation can be simultaneously connected to the Oracle main library and the Dameng main library, and then the corresponding Oracle main library is found according to the address in the configuration file to carry out corresponding operation.
And step S104 is executed, when the database table with a certain main database as a main data source is updated, the updated data is synchronized to other main databases by using a heterogeneous data synchronization tool. Thereby ensuring that all the master databases store the same service data.
In one embodiment of the invention, such as in-line transfers at a bank, the transaction involves four tables, an account information table, an account balance table, a customer information table, a transaction flow meter, etc., as shown in FIG. 3. The main data source of the account information table and the account balance table is an Oracle main library, and the main data source of the customer information table and the transaction flow meter is a Dameng main library. The process of using the database deployed by the method provided by the invention to conduct the transfer transaction comprises the following steps:
1. inquiring an account information table according to an account number of a payer to obtain related information such as a client number; the master data source for retrieving the account information table through the configuration file is in the Oracle master library, and therefore, the query is performed in the Oracle master library.
2. Inquiring an account balance table according to an account number of a payer, acquiring related information such as account balance and the like, and checking whether the account balance is enough; the master data source that retrieves the account balance sheet via the configuration file is in the Oracle master library, and thus queries are made in the Oracle master library.
3. Inquiring an account information table according to an account number of a payee to obtain related information such as a customer number; the master data source for retrieving the account information table through the configuration file is in the Oracle master library, and therefore, the query is performed in the Oracle master library.
4. Inquiring an account balance table according to an account number of a payee to obtain related information such as account balance and the like; the main data source for retrieving the account balance table via the configuration file is in the Oracle master library, and thus, the query is made in the Oracle master library.
5. Inquiring a client information table according to the client number inquired in the step 1 to obtain the client related information of the payer; the main data source of the customer information table retrieved by the configuration file is in the dream master library, and therefore is queried in the dream master library.
6. Inquiring a customer information table according to the customer number inquired in the step 3 to obtain relevant information of the customer of the payee; the main data source of the customer information table retrieved by the configuration file is in the dream master library, and therefore is queried in the dream master library.
7. Updating the account balance of the payer; the main data source of the account balance table retrieved through the configuration file is in the Oracle main library, so that updating is performed in the Oracle main library, and after the updating of the Oracle main library is completed, the data synchronously reach the dream main library through the DHMS.
8. Updating the account balance of the payee; the main data source of the account balance table retrieved through the configuration file is in the Oracle main library, so that updating is performed in the Oracle main library, and after the updating of the Oracle main library is completed, the data synchronously reach the dream main library through the DHMS.
9. Updating fields such as the latest transaction date, the latest transaction time and the like of the account information table of the payer; the main data source for retrieving the account balance table through the configuration file is in the Oracle main library, so that the update is carried out in the Oracle main library, and the data is synchronized to the dream main library through the DHMS after the update of the Oracle database is completed.
10. Updating fields such as the latest transaction date and the latest transaction time of the account information table of the payee; the main data source of the account balance table retrieved through the configuration file is in the Oracle main library, so that updating is performed in the Oracle main library, and data are synchronized to the dream main library through the DHMS after the updating of the Oracle main library is completed.
11. Inserting a transaction flow meter of a payer; and retrieving the main data source of the transaction flow meter in the dream main library through the configuration file, inserting the main data source into the dream main library, and synchronizing the data to the Oracle main library through the DHMS after the dream main library is inserted.
12. Inserting a transaction flow meter of a payee; and retrieving the main data source of the transaction flow meter in the dream master library through the configuration file, so that the main data source is inserted in the dream master library, and synchronizing the data to the Oracle master library through the DHMS after the dream master library is inserted.
13. When the Oracle master library is unavailable, the application configuration is modified, and the application configures the address of the Oracle master library into the Oracle standby library.
14. When the Oracle main library and the Oracle standby library are unavailable, the application configuration is modified, and the address of the Oracle main library is configured to reach the dream main library.
15. When the dreaming master library is not available, the application configuration is modified, and the application configures the address of the dreaming master library into the dreaming standby library.
16. When neither the main dream library nor the standby dream library is available, the application configuration is modified, and the address of the main dream library is configured into an Oracle standby library.
Example two
As shown in fig. 2, another aspect of the present invention further includes a functional module architecture completely corresponding to the foregoing method flow, that is, an embodiment of the present invention further provides a highly available deployment apparatus for a bank core system database, including:
a master database setting module 401, configured to set at least two types of master databases in the database of the bank core system;
a database table construction module 402, configured to construct all database tables used by the bank core system in all the master databases at the same time, where each database table selects one master database as a master data source;
a configuration file establishing module 403, configured to establish a configuration file of a corresponding relationship between the database table and the main database according to the main data source of the database table;
and the update synchronization module 404 is configured to synchronize the update data to other primary databases by using a heterogeneous data synchronization tool when a database table that takes a primary database as a primary data source is updated.
Further, the master databases include an Oracle master database and a dreaming master database.
Wherein the heterogeneous data synchronization tool is Dameng DHMS.
The Oracle main database and the dreaming main database both adopt a cluster mode.
Furthermore, the Oracle main database adopts an Oracle RAC cluster mode, and the Dameng main database adopts a Dameng DSC cluster mode.
Further, a standby database corresponding to the type of the main database is also arranged in the database of the bank core system, and the data of the main database is synchronized to the standby database of the corresponding type.
Wherein the standby database comprises an Oracle standby database and a Damomeng standby database; the data of the Oracle main database is synchronized into the Oracle standby database through DataGuard, and the data of the dreaming main database is synchronized into the dreaming standby database through DataWatch.
The device can be implemented by the high-availability deployment method of the bank core system database provided in the first embodiment, and specific implementation methods can be referred to the description in the first embodiment, and are not described herein again.
The invention also provides a memory storing a plurality of instructions for implementing the method according to the first embodiment.
The invention also provides an electronic device comprising a processor and a memory connected to the processor, wherein the memory stores a plurality of instructions, and the instructions can be loaded and executed by the processor to enable the processor to execute the method according to the first embodiment.
While preferred embodiments of the present invention have been described, additional variations and modifications in those embodiments may occur to those skilled in the art once they learn of the basic inventive concepts. Therefore, it is intended that the appended claims be interpreted as including preferred embodiments and all such alterations and modifications as fall within the scope of the invention. It will be apparent to those skilled in the art that various changes and modifications may be made in the present invention without departing from the spirit and scope of the invention. Thus, if such modifications and variations of the present invention fall within the scope of the claims of the present invention and their equivalents, the present invention is also intended to include such modifications and variations.

Claims (10)

1. A high-availability deployment method for a bank core system database is characterized by comprising the following steps:
at least two types of main databases are arranged in the bank core system database;
simultaneously constructing all database tables used by the bank core system in all the main databases, selecting one main database as a main data source for each database table, simultaneously connecting the database tables to each main database when an application program needs to operate the database tables, and then performing corresponding operation in the main database corresponding to the database table;
establishing a configuration file of the corresponding relation between the database table and the main database according to a main data source of the database table;
when a database table with a certain main database as a main data source is updated, the updated data is synchronized to other main databases by using a heterogeneous data synchronization tool.
2. The method for high availability deployment of bank core system databases of claim 1, wherein the master database comprises an Oracle master database and a dreams master database.
3. The method for high availability deployment of bank core system databases of claim 2, wherein the heterogeneous data synchronization tool is dreams DHMS.
4. The method for high availability deployment of bank core system databases of claim 2, wherein the Oracle master database and the dreams master database are clustered.
5. The highly available deployment method of database of bank core system according to claim 4, characterized in that said Oracle host database is in Oracle RAC cluster mode, and said Dameng host database is in Dameng DSC cluster mode.
6. The high-availability deployment method of the bank core system database as claimed in claim 2, characterized in that a backup database corresponding to a type of a primary database is further provided in the bank core system database, and data of the primary database is synchronized to the backup database of the corresponding type.
7. The method for high availability deployment of bank core system databases of claim 6 wherein the backup database comprises an Oracle backup database and a dreams backup database; the data of the Oracle main database is synchronized into the Oracle standby database through DataGuard, and the data of the dreamin main database is synchronized into the dreamin standby database through DataWatch.
8. A high-availability deployment device for a bank core system database is characterized by comprising:
the main database setting module is used for setting at least two types of main databases in the database of the bank core system;
the database table construction module is used for simultaneously constructing all database tables used by the bank core system in all the main databases, each database table selects one main database as a main data source, and when an application program needs to operate the database tables, the database tables are simultaneously connected to each main database, and then corresponding operation is carried out in the main database corresponding to the database table;
the configuration file establishing module is used for establishing a configuration file of the corresponding relation between the database table and the main database according to the main data source of the database table;
and the updating synchronization module is used for synchronizing the updating data to other main databases by using a heterogeneous data synchronization tool when the database table taking a certain main database as a main data source is updated.
9. A memory storing a plurality of instructions for implementing the method of any one of claims 1-7.
10. An electronic device comprising a processor and a memory coupled to the processor, the memory storing a plurality of instructions that are loadable and executable by the processor to enable the processor to perform the method according to any of claims 1-7.
CN202210174104.9A 2022-02-25 2022-02-25 High-availability deployment method and device for bank core system database and electronic equipment Active CN114238521B (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN202210174104.9A CN114238521B (en) 2022-02-25 2022-02-25 High-availability deployment method and device for bank core system database and electronic equipment

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN202210174104.9A CN114238521B (en) 2022-02-25 2022-02-25 High-availability deployment method and device for bank core system database and electronic equipment

Publications (2)

Publication Number Publication Date
CN114238521A CN114238521A (en) 2022-03-25
CN114238521B true CN114238521B (en) 2022-06-24

Family

ID=80748132

Family Applications (1)

Application Number Title Priority Date Filing Date
CN202210174104.9A Active CN114238521B (en) 2022-02-25 2022-02-25 High-availability deployment method and device for bank core system database and electronic equipment

Country Status (1)

Country Link
CN (1) CN114238521B (en)

Citations (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN110069473A (en) * 2019-03-27 2019-07-30 北京中科朗思信息技术有限公司 The method of database object persistence is realized on domestic discretionary security trusted platform
CN110941666A (en) * 2019-11-01 2020-03-31 网联清算有限公司 Database multi-activity method and device
CN111400110A (en) * 2020-03-11 2020-07-10 中国建设银行股份有限公司 Database access management system
CN112732491A (en) * 2021-01-22 2021-04-30 中国人民财产保险股份有限公司 Data processing system and service data processing method based on data processing system
CN112732756A (en) * 2020-12-30 2021-04-30 北京奇艺世纪科技有限公司 Data query method, device, equipment and storage medium

Family Cites Families (6)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN101667181B (en) * 2008-09-05 2011-12-21 华为技术有限公司 Method, device and system for data disaster tolerance
US10025873B2 (en) * 2014-04-18 2018-07-17 Walmart Apollo, Llc System and method for storing and processing database requests
CN107220310A (en) * 2017-05-11 2017-09-29 中国联合网络通信集团有限公司 A kind of database data management system, method and device
CN112988702A (en) * 2019-12-12 2021-06-18 天翼电子商务有限公司 Heterogeneous data source real-time data transmission method and system, storage medium and terminal
WO2021142032A1 (en) * 2020-01-07 2021-07-15 Foote Brian Mclaren System and method for transferring currency using blockchainid50000116284555 ia body 2021-01-28 filing no.:10
CN111427608B (en) * 2020-03-20 2023-04-28 重庆富民银行股份有限公司 Gray scale release method for bank core system

Patent Citations (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN110069473A (en) * 2019-03-27 2019-07-30 北京中科朗思信息技术有限公司 The method of database object persistence is realized on domestic discretionary security trusted platform
CN110941666A (en) * 2019-11-01 2020-03-31 网联清算有限公司 Database multi-activity method and device
CN111400110A (en) * 2020-03-11 2020-07-10 中国建设银行股份有限公司 Database access management system
CN112732756A (en) * 2020-12-30 2021-04-30 北京奇艺世纪科技有限公司 Data query method, device, equipment and storage medium
CN112732491A (en) * 2021-01-22 2021-04-30 中国人民财产保险股份有限公司 Data processing system and service data processing method based on data processing system

Non-Patent Citations (4)

* Cited by examiner, † Cited by third party
Title
"Multi-level Generalized Clustering Approach and Algorithm for Anomaly Detection in Internal Banking Payment System";Emir Zunic,Zlatan Tucakovic;《IEEE EUROCON 2019 -18th International Conference on Smart Technologies》;20191010;论文第1-10页 *
"Oracle数据库高可用性研究与分析";袁勇、池兴颖、孙小林;《无线互联科技》;20180525;第15卷(第10期);第37-38页 *
"分布式关系型数据库研究与金融行业应用";朱哲哲 等;《计算机系统应用》;20210615;第30卷(第05期);第75-81页 *
"异地多活之架构与存储研究";胡宏娟;《江苏通信》;20210615;第37卷(第03期);第54-59页 *

Also Published As

Publication number Publication date
CN114238521A (en) 2022-03-25

Similar Documents

Publication Publication Date Title
US11308062B2 (en) Index update method and system, and related apparatus
US11100101B2 (en) Data operation method and data management server
EP0226734B1 (en) Method and apparatus for managing obsolescence of data objects
CN107430603A (en) The system and method for MPP database
US20180293257A1 (en) Method for accessing distributed database and distributed data service apparatus
CN109840251B (en) Big data aggregation query method
JP2001142766A (en) Data base exchange system
CN109977099A (en) Database portion arranging method, user equipment, storage medium and device
CN111544895B (en) Ranking list processing method and device, electronic equipment and storage medium
KR102174957B1 (en) Transaction control method to synchronize DML statements in relational database to NoSQL database
CN111782235A (en) Data upgrading and querying method and device
CN110427427B (en) Method for realizing global transaction distributed processing through pin bridging
CN115757616A (en) Data consistency checking method, device and medium based on binary log
CN114238521B (en) High-availability deployment method and device for bank core system database and electronic equipment
US20230252025A1 (en) Data Processing System, Blockchain-Based Data Processing Method, and Device
CN116701413A (en) Main data processing method and device
CN114265727A (en) Method and device for hybrid deployment of multiple databases of bank core system and electronic equipment
CN112395284A (en) Data processing method and device, database system, electronic equipment and storage medium
CN111444281B (en) Database parameter synchronization method and system
CN114328520A (en) Order query method and device, storage medium and electronic device
CN110325980A (en) The expansion technique of user interface rear end cluster for the application of database binding type
CN113761075A (en) Method, device, equipment and computer readable medium for switching databases
Marungo A primer on NoSQL databases for enterprise architects: The CAP theorem and transparent data access with MongoDB and Cassandra
CN111338682B (en) Continuous upgrade system service method based on load
CN116360920A (en) Stream data management method, database cluster, device and equipment

Legal Events

Date Code Title Description
PB01 Publication
PB01 Publication
SE01 Entry into force of request for substantive examination
SE01 Entry into force of request for substantive examination
GR01 Patent grant
GR01 Patent grant