Undrop objects and dependent objects in a database system

A database and object technology, applied in the field of computer systems, can solve the problem that the database cannot exclude new transactions, time-consuming, etc.

Active Publication Date: 2014-01-15
ORACLE INT CORP
View PDF5 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0005] Although this scheme can retrieve cleared objects, it has the disadvantage of being relatively time-consuming
More importantly, it also has the following disadvantages: during the rollback and rollforward of the database, the database generally cannot exclude new transactions

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
  • Undrop objects and dependent objects in a database system
  • Undrop objects and dependent objects in a database system
  • Undrop objects and dependent objects in a database system

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0020] In the following description, the invention will be described with reference to an embodiment that restores objects and dependent objects in a database environment. However, embodiments of the invention are not limited to any particular architecture, environment, application or implementation. For example, although an exemplary three-tier architecture for a database management system will be described, the present invention can be readily applied to database applications or architectures as well. Accordingly, the following description of the embodiments is for purposes of illustration and not limitation.

[0021] A very common database management system architecture is as follows figure 1 The three-tier architecture shown. At the heart of the database management system is the central storage device 1 which stores the database 3 . The database 3 is typically stored on one or more hard disks, and the database 3 is typically part of a larger computer system. Informati...

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

The present invention provides techniques for restoring objects (eg, tables) and dependent objects in a database. When an object is discarded, the object is moved to the recycle bin, where the object resides until the user restores the object or the object is cleared. Dependent objects are also moved to the recycle bin along with the object they are dependent on. Objects can be cleared from the recycle bin explicitly by the user, or when more storage space is needed. Slave object and partition cleanup can be delayed if there is no need to acquire more storage space.

Description

technical field [0001] The present invention relates generally to computer systems. More specifically, the present invention relates to providing the ability to restore objects and dependent objects in a database system Background technique [0002] In general, a database management system (DBMS) is computer software that controls the integrity, organization, storage, retrieval and security of information in a database. Information in a database can be stored using several types of objects. For example, information can be stored in tables, and indexes can be used to facilitate access to the tables. Other common objects include nested tables, partial tables, index-organized tables (IOTs), large objects (LOBs), constraints, triggers, and more. [0003] Users may decide to clear or delete objects for a variety of reasons. For example, the user may feel that the object is no longer needed, that more storage space is available, or by chance. Regardless of the reason for the ...

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 Patents(China)
IPC IPC(8): G06F17/30
CPCG06F2216/09G06F16/2379
Inventor 韦尼特·玛瓦
Owner ORACLE INT CORP
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products

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

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap