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

Method and system for building a database from backup data images

一种数据库、数据的技术,应用在从存储的备份数据映像建立数据库领域

Inactive Publication Date: 2007-08-01
INT BUSINESS MASCH CORP
View PDF0 Cites 12 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

One reason for not being able to restore a full database is that two different tablespace backup images were typically backed up at different times, and there is no existing method to restore a single tablespace to a consistent point in time
For efficiency, many data backups are performed at the tablespace level, so this can be a serious limitation; it would require a system administrator to perform a full database backup if one wishes to restore the entire database at a future date
[0007] Furthermore, it is not possible with existing systems to build database-level databases by restoring only a subset of the database consisting of tablespaces

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
  • Method and system for building a database from backup data images
  • Method and system for building a database from backup data images
  • Method and system for building a database from backup data images

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0018] This invention relates to computer database systems, and more particularly to building databases from stored backup data images. The following description is intended to enable one skilled in the art to make and use the invention, and is provided in the context of a patent application and its claims. Various modifications to the preferred embodiment and the general principles and properties described herein will be readily apparent to those skilled in the art. Thus, the present invention should not be limited to the embodiments shown, but is to be accorded the widest scope consistent with the principles and properties described herein.

[0019] The invention is primarily described in terms of particular systems provided in particular implementations. However, those skilled in the art will readily recognize that such systems and methods will operate effectively in other implementations. For example, system implementations that may be used with the present invention may...

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

Building a database from stored backup data images. In one aspect, an identification of a target image is received, the target image including a copy of a logical storage unit of data from a previous database and description information that describes the previous database. The target image holds a copy of a subset of the data of the previous database. A received list has at least one desired logical storage unit of data from the previous database to be included in a built database. The desired logical storage unit is restored from at least one stored data image to the built database using the description information in the target image. Other aspects include the target image being a database image, and the desired logical storage units of data being a subset of database data.

Description

technical field [0001] This invention relates to computer database systems, and more particularly to building databases from stored backup data images. Background technique [0002] A database management system stores large amounts of organized information for users of the system to access. In the context of a database system, the system responds to specific queries from users as to what data to provide from the database. Based on the criteria and criteria of their query, users can specify the kind and type of data to be retrieved from the database. Typically, a user provides a query in a particular syntax, such as Structured Query Language (SQL) format, of the particular database language used by the system. [0003] Data in a relational database is typically organized in multiple tables or data files, and logical groupings of these tables or files are stored in logical storage units or groupings of data, referred to herein as "tablespaces." Each tablespace stores a subs...

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): G06F17/30G06F11/14
CPCG06F11/1469G06F11/1448G06F11/1456G06F11/1471
Inventor 迈克尔·罗肯凯利·D.·罗格戴维·M.·穆尼
Owner INT BUSINESS MASCH CORP
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