Research And Application Of Self-healing Database In Barter Trader System

With the rapid development of Internet technology, people become more and more dependent on the e-commerce system. Traditional e-commerce platforms tend to rely on B2C business models, namely people through this platform for electronic transactions, but under the rapid development of e-commerce technology, single business model has been unable to meet the economic development. It needs a new business model for economic development to meet the multifaceted demands of consumers, and barter transactions are just made up for this vacancy. Barter transactions generally refer to companies or individuals finish the equivalent exchange of goods and services without cash. Barter system is a barter-based e-commerce platform. With the increase in the number of consumers and transactions, it has to put forward higher requirements for the sustainable access to databases in the barter system.Self-healing technology is a technology that can automatically fix intrusion caused by malicious transactions. When an intrusion occurs, traditional database systems require a database administrator to manually repair, which is inefficient and requires database administrators have a deep understanding of business logic. Self-healing database is a database which has the ability to automatically fix all the affected transactions based on transaction dependency when a database intrusion occurs. Therefore, applying self-healing database technology into the barter system, on the one hand can ensure the continued accessibility of databases, on the other hand can reduce the security risks of manual repair and improve system efficiency.Beginning with the demand analysis of self-healing database, it gives the detailed design of the database in the batter system based on theory and technology of self-healing database. Combined with the characteristics of the e-commerce platform, some features of the original self-healing database module have been improved so that it can be better adapted to the barter system. Finally according to the design, implement some self-healing database modules, and interact with the barter system. At the same time, the innovations perform in the following three aspects: 1) Architecture improvement:by detaching the database service and self-healing services, improve the original architecture of the self-healing database, so that it does not need to stop the database services while keeping self-healing feature, and the self-healing function minimizes the impact on the whole system.2) Transaction dependency improvement:through the analysis of existing transaction dependency mechanism, using a reverse-dependent mechanism to greatly improve the generating efficiency of Undo Transaction Set.3) Transaction repair improvement:according to the e-commerce platform features, improve repair methods by increasing the records table, ensuring the correctness of self-healing and data consistency in business logic layer.