CN102682069A - 管理数据库恢复时间 - Google Patents
管理数据库恢复时间 Download PDFInfo
- Publication number
- CN102682069A CN102682069A CN201210052936XA CN201210052936A CN102682069A CN 102682069 A CN102682069 A CN 102682069A CN 201210052936X A CN201210052936X A CN 201210052936XA CN 201210052936 A CN201210052936 A CN 201210052936A CN 102682069 A CN102682069 A CN 102682069A
- Authority
- CN
- China
- Prior art keywords
- leaf
- database
- recovery
- page
- dirty
- 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
Images
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/21—Design, administration or maintenance of databases
- G06F16/215—Improving data quality; Data cleansing, e.g. de-duplication, removing invalid entries or correcting typographical errors
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F11/00—Error detection; Error correction; Monitoring
- G06F11/07—Responding to the occurrence of a fault, e.g. fault tolerance
- G06F11/14—Error detection or correction of the data by redundancy in operation
- G06F11/1402—Saving, restoring, recovering or retrying
- G06F11/1471—Saving, restoring, recovering or retrying involving logging of persistent data for recovery
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F2201/00—Indexing scheme relating to error detection, to error correction, and to monitoring
- G06F2201/80—Database-specific techniques
Abstract
Description
Claims (15)
Applications Claiming Priority (2)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
US13/041,091 | 2011-03-04 | ||
US13/041,091 US8370310B2 (en) | 2011-03-04 | 2011-03-04 | Managing database recovery time |
Publications (2)
Publication Number | Publication Date |
---|---|
CN102682069A true CN102682069A (zh) | 2012-09-19 |
CN102682069B CN102682069B (zh) | 2017-04-12 |
Family
ID=46753930
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201210052936.XA Active CN102682069B (zh) | 2011-03-04 | 2012-03-02 | 管理数据库恢复时间 |
Country Status (2)
Country | Link |
---|---|
US (2) | US8370310B2 (zh) |
CN (1) | CN102682069B (zh) |
Cited By (6)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN103092955A (zh) * | 2013-01-17 | 2013-05-08 | 华为技术有限公司 | 检查点操作方法、装置及系统 |
CN103218430A (zh) * | 2013-04-11 | 2013-07-24 | 华为技术有限公司 | 控制数据写入的方法、系统及设备 |
CN105144158A (zh) * | 2013-03-28 | 2015-12-09 | 微软技术许可有限责任公司 | 使用拆毁写检测的恢复处理 |
CN105659214A (zh) * | 2013-10-21 | 2016-06-08 | 起元科技有限公司 | 数据单元集合的检查点设置 |
CN112182010A (zh) * | 2020-11-30 | 2021-01-05 | 北京金山云网络技术有限公司 | 脏页刷新方法和装置、存储介质和电子设备 |
CN111033471B (zh) * | 2017-06-30 | 2023-05-16 | 伊夫塔奇·舒尔曼 | 用于控制只追加文件的方法、系统以及介质 |
Families Citing this family (24)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US8819208B2 (en) | 2010-03-05 | 2014-08-26 | Solidfire, Inc. | Data deletion in a distributed data storage system |
US9442948B2 (en) * | 2011-06-15 | 2016-09-13 | Sap Se | Resource-specific control blocks for database cache |
US9054992B2 (en) | 2011-12-27 | 2015-06-09 | Solidfire, Inc. | Quality of service policy sets |
US9838269B2 (en) | 2011-12-27 | 2017-12-05 | Netapp, Inc. | Proportional quality of service based on client usage and system metrics |
US9449032B2 (en) * | 2013-04-22 | 2016-09-20 | Sap Se | Multi-buffering system supporting read/write access to different data source type |
US9471632B2 (en) * | 2013-10-18 | 2016-10-18 | International Business Machines Corporation | Query optimization considering virtual machine mirroring costs |
US20150244795A1 (en) | 2014-02-21 | 2015-08-27 | Solidfire, Inc. | Data syncing in a distributed system |
JP2016057876A (ja) * | 2014-09-10 | 2016-04-21 | 富士通株式会社 | 情報処理装置、入出力制御プログラム、及び入出力制御方法 |
US9804935B1 (en) * | 2015-01-26 | 2017-10-31 | Intel Corporation | Methods for repairing a corrupted database to a new, correct state by selectively using redo and undo operations |
US10684994B2 (en) * | 2015-09-25 | 2020-06-16 | Netapp Inc. | Data synchronization |
US10204130B2 (en) | 2016-03-23 | 2019-02-12 | International Business Machines Corporation | Transactional table truncation for concurrent transactions |
US10929022B2 (en) | 2016-04-25 | 2021-02-23 | Netapp. Inc. | Space savings reporting for storage system supporting snapshot and clones |
US10642763B2 (en) | 2016-09-20 | 2020-05-05 | Netapp, Inc. | Quality of service policy sets |
US10474541B2 (en) * | 2017-03-07 | 2019-11-12 | Sap Se | Optimized savepoint during database recovery |
US10387398B2 (en) * | 2017-03-07 | 2019-08-20 | Sap Se | Continuous database page flusher |
US10310946B2 (en) * | 2017-04-07 | 2019-06-04 | Sap Se | Parallel database page flusher |
US10409695B2 (en) * | 2017-04-25 | 2019-09-10 | Sap Se | Self-adaptive continuous flushing of pages to disk |
US10360111B2 (en) * | 2017-05-03 | 2019-07-23 | Sap Se | Self-adaptive parallel database page flusher |
US10579613B2 (en) | 2017-08-08 | 2020-03-03 | International Business Machines Corporation | Database recovery using persistent address spaces |
US11288251B2 (en) * | 2018-05-25 | 2022-03-29 | Microsoft Technology Licensing, Llc | Supporting concurrent updates to a database page |
CN112100141A (zh) * | 2020-09-11 | 2020-12-18 | 北京金山云网络技术有限公司 | 一种数据页处理方法、装置及系统 |
US20230195582A1 (en) * | 2021-12-16 | 2023-06-22 | International Business Machines Corporation | Rolling back a database transaction |
CN115061858B (zh) * | 2022-08-19 | 2022-12-06 | 湖南视拓信息技术股份有限公司 | 数据持久化方法、装置、计算机设备及存储介质 |
CN116010430B (zh) * | 2023-03-24 | 2023-06-20 | 杭州趣链科技有限公司 | 数据恢复方法、数据库系统、计算机设备和存储介质 |
Family Cites Families (11)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US5043866A (en) | 1988-04-08 | 1991-08-27 | International Business Machines Corporation | Soft checkpointing system using log sequence numbers derived from stored data pages and log records for database recovery |
US5574902A (en) | 1994-05-02 | 1996-11-12 | International Business Machines Corporation | Efficient destaging of updated local cache pages for a transaction in a multisystem and multiprocess database management system with a high-speed shared electronic store |
GB2369693B (en) | 2000-11-29 | 2002-10-16 | Sun Microsystems Inc | Protection for memory modification tracking |
US7711713B2 (en) * | 2004-10-21 | 2010-05-04 | International Business Machines Corporation | System for deterministic database recovery time |
US7260681B2 (en) | 2005-06-02 | 2007-08-21 | Seagate Technology Llc | Stripe buffer list |
US7694091B2 (en) * | 2006-10-23 | 2010-04-06 | Hewlett-Packard Development Company, L.P. | Non-volatile storage for backing up volatile storage |
US7765361B2 (en) * | 2006-11-21 | 2010-07-27 | Microsoft Corporation | Enforced transaction system recoverability on media without write-through |
US7711712B2 (en) * | 2007-03-12 | 2010-05-04 | Hitachi, Ltd. | System and method for managing consistency among volumes based on application information |
KR20100133710A (ko) | 2009-06-12 | 2010-12-22 | 삼성전자주식회사 | 메모리 시스템 및 그것의 코드 데이터 로딩 방법 |
CN101706736B (zh) * | 2009-12-22 | 2012-10-10 | 北京大学 | 一种高效的脏页获取方法 |
US8402226B1 (en) * | 2010-06-18 | 2013-03-19 | Emc Corporation | Rate proportional cache write-back in a storage server |
-
2011
- 2011-03-04 US US13/041,091 patent/US8370310B2/en not_active Expired - Fee Related
-
2012
- 2012-03-02 CN CN201210052936.XA patent/CN102682069B/zh active Active
-
2013
- 2013-02-04 US US13/758,699 patent/US9424286B2/en active Active
Cited By (15)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN103092955A (zh) * | 2013-01-17 | 2013-05-08 | 华为技术有限公司 | 检查点操作方法、装置及系统 |
CN103092955B (zh) * | 2013-01-17 | 2016-08-03 | 华为技术有限公司 | 检查点操作方法、装置及系统 |
CN105164679A (zh) * | 2013-03-28 | 2015-12-16 | 微软技术许可有限责任公司 | 使用拆毁写检测的事务处理 |
CN105144158A (zh) * | 2013-03-28 | 2015-12-09 | 微软技术许可有限责任公司 | 使用拆毁写检测的恢复处理 |
CN105144158B (zh) * | 2013-03-28 | 2019-02-26 | 微软技术许可有限责任公司 | 使用拆毁写检测的恢复处理方法和系统 |
US10261869B2 (en) | 2013-03-28 | 2019-04-16 | Microsoft Technology Licensing, Llc | Transaction processing using torn write detection |
CN105164679B (zh) * | 2013-03-28 | 2019-07-23 | 微软技术许可有限责任公司 | 使用拆毁写检测的事务处理 |
US10664362B2 (en) | 2013-03-28 | 2020-05-26 | Microsoft Technology Licensing, Llc | Recovery processing for database in persistent system |
CN103218430B (zh) * | 2013-04-11 | 2016-03-02 | 华为技术有限公司 | 控制数据写入的方法、系统及设备 |
CN103218430A (zh) * | 2013-04-11 | 2013-07-24 | 华为技术有限公司 | 控制数据写入的方法、系统及设备 |
CN105659214A (zh) * | 2013-10-21 | 2016-06-08 | 起元科技有限公司 | 数据单元集合的检查点设置 |
CN105659214B (zh) * | 2013-10-21 | 2019-01-15 | 起元科技有限公司 | 数据单元集合的检查点设置 |
CN111033471B (zh) * | 2017-06-30 | 2023-05-16 | 伊夫塔奇·舒尔曼 | 用于控制只追加文件的方法、系统以及介质 |
CN112182010A (zh) * | 2020-11-30 | 2021-01-05 | 北京金山云网络技术有限公司 | 脏页刷新方法和装置、存储介质和电子设备 |
CN112182010B (zh) * | 2020-11-30 | 2021-03-12 | 北京金山云网络技术有限公司 | 脏页刷新方法和装置、存储介质和电子设备 |
Also Published As
Publication number | Publication date |
---|---|
US20120226668A1 (en) | 2012-09-06 |
US9424286B2 (en) | 2016-08-23 |
US8370310B2 (en) | 2013-02-05 |
CN102682069B (zh) | 2017-04-12 |
US20130151480A1 (en) | 2013-06-13 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN102682069A (zh) | 管理数据库恢复时间 | |
US10762108B2 (en) | Query dispatching system and method | |
Kraska et al. | Consistency rationing in the cloud: Pay only when it matters | |
CN103544153B (zh) | 一种基于数据库的数据更新方法和系统 | |
CN106662981A (zh) | 存储设备、程序和信息处理方法 | |
CN104040481A (zh) | 用于融合、存储和检索增量式备份数据的方法和系统 | |
CN103092903A (zh) | 数据库日志并行化 | |
CN102906743A (zh) | 混合oltp和olap高性能数据库系统 | |
US20070260908A1 (en) | Method and System for Transaction Recovery Time Estimation | |
CN102667720A (zh) | 没有排序依赖的一致性 | |
EP3396560B1 (en) | Database operating method and device | |
US11704216B2 (en) | Dynamically adjusting statistics collection time in a database management system | |
US11223528B2 (en) | Management of cloud-based shared content using predictive cost modeling | |
US11650922B2 (en) | Cache coherency engine | |
US9665438B2 (en) | System and method for the production of job level pre-processed backup of critical data and/or datasets in a mainframe computing environment | |
US10261718B1 (en) | Adaptively controlling data copy operations that copy data in an electronic environment | |
US10025639B2 (en) | Energy efficient supercomputer job allocation | |
EP3411799B1 (en) | Systems and methods for mixed consistency in computing systems | |
Burke | Designing and Developing Interactive Big Data Decision Support Systems for Performance, Scalability, Availability and Consistency | |
KR101375794B1 (ko) | 데이터베이스의 성능을 향상하기 위한 방법 및 장치 | |
CN113495896A (zh) | 事务处理系统的管理方法、装置、设备及介质 | |
TH60125B (th) | การอ้างอิงเชื่อมโยงไปยังโปรแกรมประยุกต์ที่เกี่ยวข้อง | |
TH104757A (th) | การอ้างอิงเชื่อมโยงไปยังโปรแกรมประยุกต์ที่เกี่ยวข้อง |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
C06 | Publication | ||
PB01 | Publication | ||
REG | Reference to a national code |
Ref country code: HK Ref legal event code: DE Ref document number: 1176133 Country of ref document: HK |
|
SE01 | Entry into force of request for substantive examination | ||
SE01 | Entry into force of request for substantive examination | ||
ASS | Succession or assignment of patent right |
Owner name: MICROSOFT TECHNOLOGY LICENSING LLC Free format text: FORMER OWNER: MICROSOFT CORP. Effective date: 20150722 |
|
C41 | Transfer of patent application or patent right or utility model | ||
TA01 | Transfer of patent application right |
Effective date of registration: 20150722 Address after: Washington State Applicant after: Micro soft technique license Co., Ltd Address before: Washington State Applicant before: Microsoft Corp. |
|
GR01 | Patent grant | ||
GR01 | Patent grant | ||
REG | Reference to a national code |
Ref country code: HK Ref legal event code: WD Ref document number: 1176133 Country of ref document: HK |