by Dinesh Thakur Category: Advanced Database Tech.

A Database Systems have been used traditionally for online transaction processing (OLTP). OLTP systems are designed to maximize the transaction processing capacity It is commonly used in clerical data processing tasks, structured repetitive tasks, read update a few records. In OLTP isolation, recovery and integrity are critical. It is based on operational systems.

 
by Dinesh Thakur Category: Advanced Database Tech.

There are the three fundamentals components that are supported by data warehouse as shown in figure. These are:

 

• Load Manager

• Warehouse Manager

• Data Access Manger

 
by Dinesh Thakur Category: Advanced Database Tech.

In-order to recover the system after these failures we need to identify the failure modes of those devices used for storage of data. Next, we must consider how these failure modes affect the contents of the database. Then we can propose the recovery algorithms to recover the database. Every Recovery algorithm performs two types of actions. These are:



 
by Dinesh Thakur Category: Advanced Database Tech.

Authorization is permission given "to user, program, or process to access an object or set of objects. The type of data access granted to a user can be read-only, or read and write. Privileges specify the type of Data Manipulation Language (DML) operations like SELECT, INSERT, UPDATE, DELETE, etc., which the user can perform upon data.

 
by Dinesh Thakur Category: Advanced Database Tech.

A simple, flat-file database has only a single table, which means it has one set of records with fields. Each record within the table contains the same fields with the same type of information in each field, although of course the specific information you enter into each separate field is different. For instance, you might have a "Last Name" field on every record, but the actual last name on each record is different.



 

Page 5 of 5



About Dinesh Thakur

Dinesh ThakurDinesh Thakur holds an B.SC (Computer Science), MCSE, MCDBA, CCNA, CCNP, A+, SCJP certifications. Dinesh authors the hugely popular blog. Where he writes how-to guides around Computer fundamental , computer software, Computer programming, and web apps. For any type of query or something that you think is missing, please feel free to Contact us.