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
Describe Query evaluation engine? Query Evaluation engine: Vehicle executes low-level instructions obtained through the DML compiler. The Storage Manager Components gives in

differences between a classified catalog and a dictionary catalog

What is primary Key Explain? Primary Key - Primary key is one of the candidate keys. It should be selected such in which its attribute values are never, or very rarely, chang

Define Database layer? The database layer defines the data formats used in the database.

Explain ODBC? ODBC - Open DataBase Connectivity (ODBC) enable the integration of SQL along with a general-reasons programming language.

Define Aggregate functions and what aggregate functions supported by the MySQL To calculate a summary value from a set of individual values and uses one of the functions known

What is a recovery scheme? An integral part of a database system is a recovery scheme that can restore the database to the reliable state that existed before the failure.

Create a view emp_dep containing e_name and number of dependents from the tables employee and dependent of (i) CREATE VIEW emp_dept AS SELECT ename, COUNT(*) FROM employee, dep

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

Conversion of entity sets: I)   For  every  strong  entity  type  E  in  the  ER  diagram,  we  make  a  relation  R containing all the easy attributes of E. The relation R pri