Define atomicity and aggregation, Database Management System

 

Atomicity: Either all functions are laid out or none are. Users could not have to think about the effect of incomplete operations. DBMS ensures this by undoing the functions of incomplete operations.

 Aggregation: A concept which is needed to model a relationship between relationships and a collection of entities. It is used when we require express a relationship among relationships.

Name the three major groups of files on disk that devolve a database in Oracle There are three major groups of files on disk that devolve a database.

  • Database files
  • Control files
  • Redo logs

 The most important of these are the database folders where the actual data insides. The control files and the redo logs support the properties of the architecture itself. All three groups of files must be open, present, and available to Oracle for any data on the database to be utilized. Without these files, you cannot operate the database, and the database administrator has to answer some or the entire database needs a backup, if there is one.

 

Posted Date: 7/30/2012 2:30:22 AM | Location : United States







Related Discussions:- Define atomicity and aggregation, Assignment Help, Ask Question on Define atomicity and aggregation, Get Answer, Expert's Help, Define atomicity and aggregation Discussions

Write discussion on Define atomicity and aggregation
Your posts are moderated
Related Questions
Attributes having a one value for a particular entity. For instance, Age is a single valued attribute of a student entity. Attributes  that  have  more  than  single  values

Describe Embedded Query Language? Embedded Query Language - A query language (e.g., SQL) can be implemented in two ways. It can be used interactively or embedded within a host

OBJECTIVES After going through this unit you should be capable to: Explain the File Based system and its limitations; Explain the structure of DBMS; Explain the


The need for three level architecture The aim of the three level architecture is to divide each user's view of the database from the way the database is physically shown.

What is DBMS and what are functions of DBMS? DBMS consist of collection of integrated data and set of program to admission those data. The functions performed by a typical

Our company hires independent contractors to install equipment at precise locations across North America. We want to track the installation data and generate reports. The compan

explain exhaustively the problems associated with ER diagrams. include illustrations in your answer

Suppose that in an organisation, an employee may do different roles in dissimilar projects. Say, RAM is doing coding in one project and doing designing in another. Suppose that the

Operator Precedence The basic operators used in SQL are * /   - + Operators of the similar priority are evaluated From Left to right Parentheses are used to force priorit