Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

Transaction consistent copy-on-write database

A database and transaction technology, applied in the field of database systems

Inactive Publication Date: 2005-02-09
MICROSOFT TECH LICENSING LLC
View PDF0 Cites 5 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

Also, this versioning no longer persists across database server restarts

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 more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Transaction consistent copy-on-write database
  • Transaction consistent copy-on-write database
  • Transaction consistent copy-on-write database

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0019] Exemplary Computing Environment

[0020] Figure 1 shows an exemplary computing environment in which certain aspects of the invention may be implemented. Computing system environment 100 is only one example of a suitable computing environment and is not intended to limit the scope of use or functionality of the invention. Neither should the computing system 100 be interpreted as having any dependency or requirement relating to any one or combination of components described in the exemplary operating environment 100 .

[0021] The invention is operational with numerous other general purpose or special purpose computing system environments or configurations. There are many well-known computing systems, environments, and / or configurations suitable for use with the present invention, including, for example, but not limited to: personal computers, server computers, palm or laptop devices, multiprocessor systems, microprocessor-based systems , set-top boxes, programmable c...

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

No PUM Login to View More

Abstract

A database view of a database is created which provides a transaction-consistent view of an existing database at a previous time. Each database view contains all the information needed to, along with the primary database, determine the contents of the primary database at a previous time. The database view consists of a side file corresponding to each data file in the primary database. The side files contain a copy of all data from the corresponding data file which has been changed since the database view was created. Sparse files may be used for the side files in order to conserve space. Page table data is kept in order to allow a quick determination as to whether the page from the primary database has been modified and the old version stored in the database view side file.

Description

technical field [0001] The present invention generally relates to the field of database systems. In particular, the invention relates to creating transactionally compliant copies of databases. Background technique [0002] Today, the use of databases and database products is widespread. A database stores information in the form of objects such as logs, tables, and indexes. In addition to the latest version of information stored in the database, previous versions of information may also be available to users. [0003] One way to provide information about previous versions of data is to make a full copy of the database at some point in time that might be of interest to the user. When making a copy, all database-related files will be stored. But this technique consumes a considerable amount of storage space, because for a database stored with a certain amount of storage space, each copy of it will also require the same amount of storage space. This approach can also be tim...

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
no application Login to View More
Patent Type & Authority Applications(China)
IPC IPC(8): G06F12/00G06F11/14G06F12/16G06F17/30G06F17/40
CPCG06F17/30551G06F11/1451Y10S707/99952G06F2201/80Y10S707/99953G06F11/1471G06F11/1402G06F17/30595G06F16/284G06F16/24557G06F16/2477G06F17/40G06F12/16
Inventor M·J·泽维灵L·S·布鲁克S·H·艾加瓦尔言康荣
Owner MICROSOFT TECH LICENSING LLC
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic, Popular Technical Reports.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com