CA2350721A1 - Method and apparatus for chunk based transaction logging with asynchronous input/output for a database management system - Google Patents
Method and apparatus for chunk based transaction logging with asynchronous input/output for a database management system Download PDFInfo
- Publication number
- CA2350721A1 CA2350721A1 CA002350721A CA2350721A CA2350721A1 CA 2350721 A1 CA2350721 A1 CA 2350721A1 CA 002350721 A CA002350721 A CA 002350721A CA 2350721 A CA2350721 A CA 2350721A CA 2350721 A1 CA2350721 A1 CA 2350721A1
- Authority
- CA
- Canada
- Prior art keywords
- database
- management system
- database management
- output
- based transaction
- 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.)
- Granted
Links
- 238000000034 method Methods 0.000 title abstract 2
- 239000003795 chemical substances by application Substances 0.000 abstract 4
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/23—Updating
- G06F16/2358—Change logging, detection, and notification
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
A method and apparatus are provided for storing transaction data for a plurality of database applications in a multiple access database management system having permanent storage and a transaction log buffer to store data for said database applications before transferring said data to said permanent storage, wherein database connection agents associated with said applications are used to store data in said transaction log buffer, includin g granting exclusive write access reservations in said transaction log buffer to a plurality of said database connection agents; and allowing database connection agents to write transaction data records to previously granted write access reservations while granting exclusive access reservatio ns to other database connection agents.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CA002350721A CA2350721C (en) | 2001-06-15 | 2001-06-15 | Method and apparatus for chunk based transaction logging with asynchronous input/output for a database management system |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CA002350721A CA2350721C (en) | 2001-06-15 | 2001-06-15 | Method and apparatus for chunk based transaction logging with asynchronous input/output for a database management system |
Publications (2)
Publication Number | Publication Date |
---|---|
CA2350721A1 true CA2350721A1 (en) | 2002-12-15 |
CA2350721C CA2350721C (en) | 2004-04-13 |
Family
ID=4169287
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CA002350721A Expired - Lifetime CA2350721C (en) | 2001-06-15 | 2001-06-15 | Method and apparatus for chunk based transaction logging with asynchronous input/output for a database management system |
Country Status (1)
Country | Link |
---|---|
CA (1) | CA2350721C (en) |
Cited By (2)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN116244041A (en) * | 2022-12-02 | 2023-06-09 | 湖南亚信安慧科技有限公司 | Performance optimization method for database sub-transaction |
CN116980641A (en) * | 2023-09-22 | 2023-10-31 | 江西云眼视界科技股份有限公司 | Asynchronous processing method, system, computer and storage medium for video migration |
-
2001
- 2001-06-15 CA CA002350721A patent/CA2350721C/en not_active Expired - Lifetime
Cited By (4)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN116244041A (en) * | 2022-12-02 | 2023-06-09 | 湖南亚信安慧科技有限公司 | Performance optimization method for database sub-transaction |
CN116244041B (en) * | 2022-12-02 | 2023-10-27 | 湖南亚信安慧科技有限公司 | Performance optimization method for database sub-transaction |
CN116980641A (en) * | 2023-09-22 | 2023-10-31 | 江西云眼视界科技股份有限公司 | Asynchronous processing method, system, computer and storage medium for video migration |
CN116980641B (en) * | 2023-09-22 | 2023-12-15 | 江西云眼视界科技股份有限公司 | Asynchronous processing method, system, computer and storage medium for video migration |
Also Published As
Publication number | Publication date |
---|---|
CA2350721C (en) | 2004-04-13 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
WO2006020711A3 (en) | System and method for variable block logging with log-ahead buffers | |
CA2209549C (en) | Method and apparatus for loading data into a database in a multiprocessor environment | |
AU2003250670A1 (en) | Data store management system and method for wireless devices | |
TW200508860A (en) | Systems and methods for storing data on computer systems | |
CA2320675A1 (en) | Method and system for storing and accessing data in a compound document using object linking | |
EP1158395A3 (en) | Data storage system and hierarchical management control method | |
WO2004034202A3 (en) | Method and system for facilitating data access and management on a secure token | |
WO2001013232A3 (en) | Self-healing computer system storage | |
WO2006026680A3 (en) | Systems and methods for organizing and mapping data | |
CA2172075A1 (en) | Computer method and apparatus for asynchronous ordered operations | |
GB2368422B (en) | Electronic settlement system, settlement management device, store device, client, data storage device, computer program, and storage medium | |
DE50004826D1 (en) | Integrated database system | |
CA2178376A1 (en) | Video data retrieval method for use in video server environments that use striped disks | |
WO2002013014A3 (en) | System and method for implementing a redundant data storage architecture | |
WO2005041045A3 (en) | Methods of reading and writing data | |
TW200708950A (en) | Memory management method and system | |
GB2442916A (en) | Securely storing and accessing data | |
WO2002050685A3 (en) | A system and method for ensuring data coherency for mirrored and striped disk writes | |
EP0259050A3 (en) | Multi-channel memory access circuit | |
WO2002019161A3 (en) | Temporary directory management | |
EP1600869A4 (en) | Content processing terminal, copy right management system, and method thereof | |
CA2285205A1 (en) | System and method for tracking records in a distributed computing system | |
Nodine et al. | Greed sort: Optimal deterministic sorting on parallel disks | |
US8589652B2 (en) | Reorganization of a fragmented directory of a storage data structure comprised of the fragmented directory and members | |
TW200504697A (en) | Magnetic tape data storage system buffer management |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
EEER | Examination request | ||
MKEX | Expiry |
Effective date: 20210615 |
|
MKEX | Expiry |
Effective date: 20210615 |