Embedded-database-system-oriented no journaling transaction processing method
A transaction processing and database technology, applied in the field of database management, can solve problems affecting database performance, unbearable disk overhead, inapplicability, etc., and achieve the effect of simple commit and rollback operations and efficient transaction processing
Inactive Publication Date: 2012-04-04
北京人大金仓信息技术股份有限公司
View PDF2 Cites 12 Cited by
- Summary
- Abstract
- Description
- Claims
- Application Information
AI Technical Summary
Problems solved by technology
Access to the disk during transaction execution will inevitably affect the performance of the database, and saving log files on the disk also increases the storage overhead of the database on the embedded device
This kind of storage overhead can be basically ignored on PCs or servers, but on embedded devices with slow processors and tight disk resources, the increased disk overhead caused by running a database system that needs to record logs is often unbearable
Especially in embedded applications with high performance requirements, embedded databases that need to record logs are even more inapplicable
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 moreImage
Smart Image Click on the blue labels to locate them in the text.
Smart ImageViewing Examples
Examples
Experimental program
Comparison scheme
Effect test
Embodiment Construction
[0019] The no-log transaction processing method provided by the present invention proposes a transaction processing mechanism of a brand new concept. The feature of this transaction processing mechanism is to use two work areas to maintain data in the database and record user operations on the database. The two working areas are named "Current Area" and "Shadow Area" respectively. During the running of the transaction, the shadow area is used as the backup of the current area. With the running of the transaction, the content of the two workspaces will be inconsistent, and the inconsistent content is the change of data during the running process of the database. When committing a transaction, the content of the current zone shall prevail to make the change of the database content take effect. When rolling back a transaction, the content of the shadow area shall prevail, and the changes to the database content shall be canceled. The above transaction processing mechanism does...
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
Login to View More Abstract
The method provides an embedded-database-system-oriented no journaling transaction processing method. An embedded database comprises two work areas which are used for maintaining data in the database and recording the operation of a user on the database. The two work areas manage an identical data object and comprise identical quantity of object elements. Elements in the each work area are positioned through indexing. In an initial state at the beginning of a transaction, the object elements in the two work areas corresponding to an identical index value point to an identical data object, in a submission state or returning state of the transaction, object elements in the two work areas are compared, if the object elements in the two work areas are inconsistent, the data object is proved to be modified, and then the validation or the canceling of the modification is determined, and the whole object elements in the work areas are processed by the same method. The transaction processing mechanism provided by the invention has advantages of powerful functions, high efficiency and fewer occupied resources.
Description
technical field [0001] The invention relates to a database system transaction processing method, in particular to a log-free transaction processing method oriented to an embedded database system, and belongs to the technical field of database management. Background technique [0002] With the development of technology, embedded devices and mobile devices have been widely used in various industries, such as: handheld PDA, industrial computer, smart phone, etc. And almost all embedded devices and mobile devices will involve data management. It is impossible to run a large general-purpose database on embedded devices and mobile devices, so how to achieve stable and efficient data management has become a difficult problem for embedded application developers. [0003] Embedded database has been widely used in embedded devices because of its easy-to-use, small size, and strong data management capabilities. However, most of the current embedded databases all or partly follow the ...
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
Login to View More Patent Type & Authority Applications(China)
IPC IPC(8): G06F17/30
Inventor 陈东刘建立李恒杨经正寇立涛
Owner 北京人大金仓信息技术股份有限公司