CN104516959A - 一种管理数据库日志的方法及装置 - Google Patents
一种管理数据库日志的方法及装置 Download PDFInfo
- Publication number
- CN104516959A CN104516959A CN201410791085.XA CN201410791085A CN104516959A CN 104516959 A CN104516959 A CN 104516959A CN 201410791085 A CN201410791085 A CN 201410791085A CN 104516959 A CN104516959 A CN 104516959A
- Authority
- CN
- China
- Prior art keywords
- database
- journal
- transaction
- affairs
- database journal
- 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 claims abstract description 57
- 238000011084 recovery Methods 0.000 claims description 18
- 238000010586 diagram Methods 0.000 description 5
- 230000002159 abnormal effect Effects 0.000 description 4
- 239000000203 mixture Substances 0.000 description 4
- 238000012217 deletion Methods 0.000 description 2
- 230000037430 deletion Effects 0.000 description 2
- 230000009977 dual effect Effects 0.000 description 2
- 230000002688 persistence Effects 0.000 description 2
- 238000012163 sequencing technique Methods 0.000 description 2
- 239000003990 capacitor Substances 0.000 description 1
- 238000005516 engineering process Methods 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
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
-
- 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/2308—Concurrency control
- G06F16/2315—Optimistic concurrency control
- G06F16/2329—Optimistic concurrency control using versioning
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
Description
Claims (12)
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201410791085.XA CN104516959B (zh) | 2014-12-18 | 2014-12-18 | 一种管理数据库日志的方法及装置 |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201410791085.XA CN104516959B (zh) | 2014-12-18 | 2014-12-18 | 一种管理数据库日志的方法及装置 |
Publications (2)
Publication Number | Publication Date |
---|---|
CN104516959A true CN104516959A (zh) | 2015-04-15 |
CN104516959B CN104516959B (zh) | 2018-01-02 |
Family
ID=52792258
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201410791085.XA Active CN104516959B (zh) | 2014-12-18 | 2014-12-18 | 一种管理数据库日志的方法及装置 |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN104516959B (zh) |
Cited By (11)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN105183628A (zh) * | 2015-10-22 | 2015-12-23 | 湖南国科微电子股份有限公司 | 一种嵌入式系统日志收集装置、记录系统及方法 |
CN106503020A (zh) * | 2015-09-08 | 2017-03-15 | 阿里巴巴集团控股有限公司 | 日志数据处理方法及装置 |
CN106843000A (zh) * | 2017-02-13 | 2017-06-13 | 华北电力大学(保定) | 攀爬机器人移动控制系统恢复方法 |
CN107480009A (zh) * | 2017-08-18 | 2017-12-15 | 北京中电普华信息技术有限公司 | 一种事务恢复方法及装置 |
CN107924362A (zh) * | 2015-09-08 | 2018-04-17 | 株式会社东芝 | 数据库系统、服务器装置、程序及信息处理方法 |
CN111290881A (zh) * | 2020-01-21 | 2020-06-16 | 上海达梦数据库有限公司 | 一种数据恢复方法、装置、设备及存储介质 |
CN111656325A (zh) * | 2018-02-23 | 2020-09-11 | 国际商业机器公司 | 在按时间排序的日志结构化键-值存储系统中从故障快速恢复 |
CN111737203A (zh) * | 2020-06-09 | 2020-10-02 | 阿里巴巴集团控股有限公司 | 数据库历史日志回溯方法、装置、系统、设备及存储介质 |
CN112035410A (zh) * | 2020-08-18 | 2020-12-04 | 腾讯科技(深圳)有限公司 | 日志存储方法、装置、节点设备及存储介质 |
CN112527759A (zh) * | 2021-02-09 | 2021-03-19 | 腾讯科技(深圳)有限公司 | 日志执行方法、装置、计算机设备及存储介质 |
CN115017223A (zh) * | 2022-08-04 | 2022-09-06 | 成都运荔枝科技有限公司 | 一种支持大数据量导入导出的系统 |
Citations (4)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US5799305A (en) * | 1995-11-02 | 1998-08-25 | Informix Software, Inc. | Method of commitment in a distributed database transaction |
US6131094A (en) * | 1998-04-24 | 2000-10-10 | Unisys Corp. | Method for performing asynchronous writes to database logs using multiple insertion points |
CN101625655A (zh) * | 2009-08-20 | 2010-01-13 | 华中科技大学 | 一种内存数据库的并行恢复方法 |
CN103577577A (zh) * | 2013-11-06 | 2014-02-12 | 北京京东尚科信息技术有限公司 | 一种保存数据库日志的方法、装置及系统 |
-
2014
- 2014-12-18 CN CN201410791085.XA patent/CN104516959B/zh active Active
Patent Citations (4)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US5799305A (en) * | 1995-11-02 | 1998-08-25 | Informix Software, Inc. | Method of commitment in a distributed database transaction |
US6131094A (en) * | 1998-04-24 | 2000-10-10 | Unisys Corp. | Method for performing asynchronous writes to database logs using multiple insertion points |
CN101625655A (zh) * | 2009-08-20 | 2010-01-13 | 华中科技大学 | 一种内存数据库的并行恢复方法 |
CN103577577A (zh) * | 2013-11-06 | 2014-02-12 | 北京京东尚科信息技术有限公司 | 一种保存数据库日志的方法、装置及系统 |
Cited By (18)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN106503020A (zh) * | 2015-09-08 | 2017-03-15 | 阿里巴巴集团控股有限公司 | 日志数据处理方法及装置 |
CN107924362A (zh) * | 2015-09-08 | 2018-04-17 | 株式会社东芝 | 数据库系统、服务器装置、程序及信息处理方法 |
CN107924362B (zh) * | 2015-09-08 | 2022-02-15 | 株式会社东芝 | 数据库系统、服务器装置、计算机可读取的记录介质及信息处理方法 |
CN105183628A (zh) * | 2015-10-22 | 2015-12-23 | 湖南国科微电子股份有限公司 | 一种嵌入式系统日志收集装置、记录系统及方法 |
CN105183628B (zh) * | 2015-10-22 | 2017-03-29 | 湖南国科微电子股份有限公司 | 一种嵌入式系统日志收集装置、记录系统及方法 |
CN106843000A (zh) * | 2017-02-13 | 2017-06-13 | 华北电力大学(保定) | 攀爬机器人移动控制系统恢复方法 |
CN106843000B (zh) * | 2017-02-13 | 2019-03-26 | 华北电力大学(保定) | 攀爬机器人移动控制系统恢复方法 |
CN107480009A (zh) * | 2017-08-18 | 2017-12-15 | 北京中电普华信息技术有限公司 | 一种事务恢复方法及装置 |
CN111656325A (zh) * | 2018-02-23 | 2020-09-11 | 国际商业机器公司 | 在按时间排序的日志结构化键-值存储系统中从故障快速恢复 |
CN111656325B (zh) * | 2018-02-23 | 2023-09-29 | 国际商业机器公司 | 在按时间排序的日志结构化键-值存储系统中从故障快速恢复 |
CN111290881A (zh) * | 2020-01-21 | 2020-06-16 | 上海达梦数据库有限公司 | 一种数据恢复方法、装置、设备及存储介质 |
CN111290881B (zh) * | 2020-01-21 | 2023-09-19 | 上海达梦数据库有限公司 | 一种数据恢复方法、装置、设备及存储介质 |
CN111737203A (zh) * | 2020-06-09 | 2020-10-02 | 阿里巴巴集团控股有限公司 | 数据库历史日志回溯方法、装置、系统、设备及存储介质 |
CN112035410A (zh) * | 2020-08-18 | 2020-12-04 | 腾讯科技(深圳)有限公司 | 日志存储方法、装置、节点设备及存储介质 |
CN112035410B (zh) * | 2020-08-18 | 2023-08-18 | 腾讯科技(深圳)有限公司 | 日志存储方法、装置、节点设备及存储介质 |
CN112527759A (zh) * | 2021-02-09 | 2021-03-19 | 腾讯科技(深圳)有限公司 | 日志执行方法、装置、计算机设备及存储介质 |
CN112527759B (zh) * | 2021-02-09 | 2021-06-11 | 腾讯科技(深圳)有限公司 | 日志执行方法、装置、计算机设备及存储介质 |
CN115017223A (zh) * | 2022-08-04 | 2022-09-06 | 成都运荔枝科技有限公司 | 一种支持大数据量导入导出的系统 |
Also Published As
Publication number | Publication date |
---|---|
CN104516959B (zh) | 2018-01-02 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN104516959A (zh) | 一种管理数据库日志的方法及装置 | |
CN101903866B (zh) | 非易失存储介质中的数据存储的方法和系统 | |
KR100843543B1 (ko) | 플래시 메모리 장치를 포함하는 시스템 및 그것의 데이터복구 방법 | |
US8171257B2 (en) | Determining an end of valid log in a log of write records using a next pointer and a far ahead pointer | |
US9075708B1 (en) | System and method for improving data integrity and power-on performance in storage devices | |
US20190369892A1 (en) | Method and Apparatus for Facilitating a Trim Process Using Auxiliary Tables | |
CN103646063B (zh) | 一种星载高速文件管理系统 | |
CN102063380B (zh) | 一种向非易失性存储器写入数据的方法及装置 | |
CN103577121A (zh) | 一种基于nand flash的高可靠线性文件存取方法 | |
CN101901189B (zh) | 更新用户数据的方法以及恢复用户数据的方法 | |
CN105122220A (zh) | 固态驱动器中的原子写入命令支持 | |
US20110185107A1 (en) | Memory system | |
JP2013061799A (ja) | 記憶装置、記憶装置の制御方法およびコントローラ | |
CN107665219B (zh) | 一种日志管理方法及装置 | |
TWI823504B (zh) | 非暫態電腦可讀取媒體、儲存裝置、及儲存方法 | |
US20150074336A1 (en) | Memory system, controller and method of controlling memory system | |
CN113785275A (zh) | Flash数据掉电保护方法及设备 | |
CN112035294A (zh) | 安全日志文件系统及其实现方法和介质 | |
CN111414320B (zh) | 基于日志文件系统的非易失内存构建磁盘cache的方法及系统 | |
TW202318209A (zh) | 條件更新,延遲查找 | |
US9268646B1 (en) | System and method for optimized management of operation data in a solid-state memory | |
CN111221750B (zh) | 固态储存装置的数据处理方法 | |
CN111124294B (zh) | 一种扇区映射信息的管理方法及装置、存储介质和设备 | |
KR100866513B1 (ko) | 플래시 메모리 기반 저널링 파일 시스템을 이용한 데이터처리 방법 | |
WO2010145967A1 (en) | Memory device for managing the recovery of a non volatile memory |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
C06 | Publication | ||
PB01 | Publication | ||
C10 | Entry into substantive examination | ||
SE01 | Entry into force of request for substantive examination | ||
GR01 | Patent grant | ||
GR01 | Patent grant | ||
TR01 | Transfer of patent right | ||
TR01 | Transfer of patent right |
Effective date of registration: 20200422 Address after: 518129 Bantian HUAWEI headquarters office building, Longgang District, Guangdong, Shenzhen Patentee after: HUAWEI TECHNOLOGIES Co.,Ltd. Address before: 301, A building, room 3, building 301, foreshore Road, No. 310052, Binjiang District, Zhejiang, Hangzhou Patentee before: Hangzhou Huawei Digital Technology Co.,Ltd. |
|
TR01 | Transfer of patent right | ||
TR01 | Transfer of patent right |
Effective date of registration: 20220218 Address after: 550025 Huawei cloud data center, jiaoxinggong Road, Qianzhong Avenue, Gui'an New District, Guiyang City, Guizhou Province Patentee after: Huawei Cloud Computing Technologies Co.,Ltd. Address before: 518129 Bantian HUAWEI headquarters office building, Longgang District, Guangdong, Shenzhen Patentee before: HUAWEI TECHNOLOGIES Co.,Ltd. |
|
TR01 | Transfer of patent right | ||
TR01 | Transfer of patent right |
Effective date of registration: 20221215 Address after: 518129 Huawei Headquarters Office Building 101, Wankecheng Community, Bantian Street, Longgang District, Shenzhen, Guangdong Patentee after: Shenzhen Huawei Cloud Computing Technology Co.,Ltd. Address before: 550025 Huawei cloud data center, jiaoxinggong Road, Qianzhong Avenue, Gui'an New District, Guiyang City, Guizhou Province Patentee before: Huawei Cloud Computing Technologies Co.,Ltd. |