CN102708143B - 在页级跟踪重做完成 - Google Patents
在页级跟踪重做完成 Download PDFInfo
- Publication number
- CN102708143B CN102708143B CN201210071285.9A CN201210071285A CN102708143B CN 102708143 B CN102708143 B CN 102708143B CN 201210071285 A CN201210071285 A CN 201210071285A CN 102708143 B CN102708143 B CN 102708143B
- Authority
- CN
- China
- Prior art keywords
- stage
- page
- database
- dirty pages
- containing 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.)
- Active
Links
Classifications
-
- 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/1446—Point-in-time backing up or restoration of persistent data
- G06F11/1458—Management of the backup or restore process
- G06F11/1469—Backup restoration techniques
-
- 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/217—Database tuning
-
- 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/24—Querying
- G06F16/245—Query processing
- G06F16/2455—Query execution
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Databases & Information Systems (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Data Mining & Analysis (AREA)
- Computational Linguistics (AREA)
- Quality & Reliability (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
Description
Claims (12)
Applications Claiming Priority (2)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
US13/051,970 | 2011-03-18 | ||
US13/051,970 US8818960B2 (en) | 2011-03-18 | 2011-03-18 | Tracking redo completion at a page level |
Publications (2)
Publication Number | Publication Date |
---|---|
CN102708143A CN102708143A (zh) | 2012-10-03 |
CN102708143B true CN102708143B (zh) | 2018-05-15 |
Family
ID=46829291
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201210071285.9A Active CN102708143B (zh) | 2011-03-18 | 2012-03-16 | 在页级跟踪重做完成 |
Country Status (2)
Country | Link |
---|---|
US (2) | US8818960B2 (zh) |
CN (1) | CN102708143B (zh) |
Families Citing this family (5)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US9053024B2 (en) * | 2012-11-30 | 2015-06-09 | Hewlett-Packard Development Company, L. P. | Transactions and failure |
EP2951694B1 (en) * | 2013-01-30 | 2017-08-16 | Hewlett-Packard Enterprise Development LP | Recovering pages of a database |
CN106610876B (zh) * | 2015-10-23 | 2020-11-03 | 中兴通讯股份有限公司 | 数据快照的恢复方法及装置 |
CN105741121B (zh) * | 2016-02-15 | 2019-04-05 | 深圳市我家网络科技有限公司 | 一种基于条目引用的产品溯源信息的编写与存储方法 |
US11003549B2 (en) | 2018-07-25 | 2021-05-11 | Microsoft Technology Licensing, Llc | Constant time database recovery |
Citations (4)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US5333303A (en) * | 1991-03-28 | 1994-07-26 | International Business Machines Corporation | Method for providing data availability in a transaction-oriented system during restart after a failure |
CN1454349A (zh) * | 2000-06-07 | 2003-11-05 | 处理存储器有限公司 | 主存储器事务处理系统中的高度并行日志和恢复操作的方法和系统 |
CN1784677A (zh) * | 2004-03-31 | 2006-06-07 | 微软公司 | 用于数据库备份的一致性检验的系统和方法 |
CN101794247A (zh) * | 2010-03-26 | 2010-08-04 | 天津理工大学 | 嵌套事务模型下实时数据库故障恢复方法 |
Family Cites Families (14)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US6000020A (en) | 1997-04-01 | 1999-12-07 | Gadzoox Networks, Inc. | Hierarchical storage management from a mirrored file system on a storage network segmented by a bridge |
US6185699B1 (en) | 1998-01-05 | 2001-02-06 | International Business Machines Corporation | Method and apparatus providing system availability during DBMS restart recovery |
US6289357B1 (en) | 1998-04-24 | 2001-09-11 | Platinum Technology Ip, Inc. | Method of automatically synchronizing mirrored database objects |
CA2322603C (en) | 2000-10-06 | 2005-04-12 | Ibm Canada Limited-Ibm Canada Limitee | Optimizing updatable scrollable cursors in database systems |
US6751636B1 (en) | 2000-12-05 | 2004-06-15 | Silicon Graphics, Inc. | System and method for maintaining and recovering data consistency across multiple instances of a database |
US6721739B1 (en) | 2000-12-05 | 2004-04-13 | Silicon Graphics, Inc. | System and method for maintaining and recovering data consistency across multiple pages |
US7051052B1 (en) | 2002-06-20 | 2006-05-23 | Unisys Corporation | Method for reading audit data from a remote mirrored disk for application to remote database backup copy |
GB0219909D0 (en) | 2002-08-28 | 2002-10-02 | Koninkl Philips Electronics Nv | Secure logging of transactions |
US6910106B2 (en) * | 2002-10-04 | 2005-06-21 | Microsoft Corporation | Methods and mechanisms for proactive memory management |
US7290015B1 (en) | 2003-10-02 | 2007-10-30 | Progress Software Corporation | High availability via data services |
US6859811B1 (en) | 2004-01-15 | 2005-02-22 | Oracle International Corporation | Cluster database with remote data mirroring |
US20050203974A1 (en) | 2004-03-09 | 2005-09-15 | Smith Gary S. | Checkpoint methods and systems utilizing non-disk persistent memory |
US20050235017A1 (en) | 2004-04-15 | 2005-10-20 | Jeff Ashman | System and method for high availability of data in a disaster recovery system |
US7689607B2 (en) * | 2005-04-15 | 2010-03-30 | Microsoft Corporation | Database page mirroring |
-
2011
- 2011-03-18 US US13/051,970 patent/US8818960B2/en active Active
-
2012
- 2012-03-16 CN CN201210071285.9A patent/CN102708143B/zh active Active
-
2014
- 2014-08-26 US US14/468,556 patent/US9384100B2/en active Active
Patent Citations (4)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US5333303A (en) * | 1991-03-28 | 1994-07-26 | International Business Machines Corporation | Method for providing data availability in a transaction-oriented system during restart after a failure |
CN1454349A (zh) * | 2000-06-07 | 2003-11-05 | 处理存储器有限公司 | 主存储器事务处理系统中的高度并行日志和恢复操作的方法和系统 |
CN1784677A (zh) * | 2004-03-31 | 2006-06-07 | 微软公司 | 用于数据库备份的一致性检验的系统和方法 |
CN101794247A (zh) * | 2010-03-26 | 2010-08-04 | 天津理工大学 | 嵌套事务模型下实时数据库故障恢复方法 |
Also Published As
Publication number | Publication date |
---|---|
US8818960B2 (en) | 2014-08-26 |
US20140365444A1 (en) | 2014-12-11 |
US20120239628A1 (en) | 2012-09-20 |
US9384100B2 (en) | 2016-07-05 |
CN102708143A (zh) | 2012-10-03 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
Engin et al. | Algorithmic government: Automating public services and supporting civil servants in using data science technologies | |
EP3113037B1 (en) | Adaptive adjustment of network responses to client requests in digital networks | |
CN102708143B (zh) | 在页级跟踪重做完成 | |
US20220035845A1 (en) | Search indexing using discourse trees | |
US7685152B2 (en) | Method and apparatus for loading data from a spreadsheet to a relational database table | |
US8843646B2 (en) | Multi-desktop interaction using nested remote desktop sessions | |
US11238231B2 (en) | Data relationships in a question-answering environment | |
WO2011080772A1 (en) | Method and system for ranking affinity degree among functional blocks | |
US20140279803A1 (en) | Disambiguating data using contextual and historical information | |
US20200089586A1 (en) | Cognitively triggering recovery actions during a component disruption in a production environment | |
US8898126B1 (en) | Method and apparatus for providing concurrent data insertion and updating | |
CN111782809A (zh) | 国际收支网申数据处理方法、装置、电子设备及存储介质 | |
CN110705235A (zh) | 业务办理的信息录入方法、装置、存储介质及电子设备 | |
US20190163838A1 (en) | Method and system for processing multimodal user queries | |
US10489728B1 (en) | Generating and publishing a problem ticket | |
US20200042940A1 (en) | Interactive apparatus, control apparatus, interactive system, interactive method, and control method | |
US20130185112A1 (en) | Optimizing benefits of community development with reference to resources through multiple time periods for multiple cooperating and competing entities with reference to multiple dimensions | |
US20130332369A1 (en) | Leveraging analytics to propose context sensitive workflows for case management solutions | |
US7783588B2 (en) | Context modeling architecture and framework | |
CN112019675A (zh) | 通讯录联系人的排序方法、装置及电子设备 | |
CN112100187A (zh) | 一种基于VueJS的学生学习数据存储方法及装置 | |
CN115859964B (zh) | 基于教育云平台的教育资源共享方法及系统 | |
WO2019036040A1 (en) | COMPUTERIZED TEACHING SYSTEM OF AGREEMENT ANALYSIS | |
CN110780996B (zh) | 进程优化方法、装置、存储介质和计算机设备 | |
US8972939B1 (en) | Systems and methods for processing and producing content for web sites |
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: 1174994 Country of ref document: HK |
|
C10 | Entry into 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: 20150728 |
|
C41 | Transfer of patent application or patent right or utility model | ||
TA01 | Transfer of patent application right |
Effective date of registration: 20150728 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: GR Ref document number: 1174994 Country of ref document: HK |