Turn Desktop View Off
You are here:   HomeDatabase System
by Dinesh Thakur Category: Advanced Database Tech.

The definition of and DDBMS defines that the system should make the distribution transparent to the user. Transparent hides implementation details from the user. For example, in a centralized DBMS, data independence is a form of transparency it hides changes in the definition and organization of the data from the user. A DDBMS may provide a variousĀ· levels of transparency. However, they all participate in the same overall objective: to make the use of the distributed database, equivalent to that of a centralized database.

by Dinesh Thakur Category: Advanced Database Tech.

Online Analytical Processing is used to answer the complex queries posted on data warehouse. In order to solve the queries of nature 'who?' and 'what?' we can use the simple tools but to answer the advanced queries like 'what if?' and 'why?', we require special tool that can support online analytical processing (OLAP).

by Dinesh Thakur Category: Advanced Database Tech.

The storing information in a data warehouse does not provide the benefits an organization is seeking. To realize the value of a data warehouse, it is necessary to extract the knowledge hidden within the warehouse. However, as the amount and complexity of the data in a data warehouse grows, it becomes increasingly difficult, if not impossible, for business analysts to identify trends and relationships in the data using simple query and reporting tools.

by Dinesh Thakur Category: Advanced Database Tech.

Function of a DDBMS

We expect a DDBMS to have at least the functionality for a centralized DBMS. In addition, we expect a DDBMS to have the following functionality:

by Dinesh Thakur Category: Advanced Database Tech.

The acronym DBTG refers to the Data Base Task Group of the Conference on Data Systems Languages (CODASYL), the group responsible for standardization of the programming language COBOL. The DBTG final report appeared in Apri1971, it introduced a new distinct and self-contained language. The DBTG is intended to meet the requirements of many distinct programming languages, not just COBOL, the user in a DBTG system is considered to be an ordinary application programmer and the language therefore is not biased toward any single specific programming language.

by Dinesh Thakur Category: Advanced Database Tech.

There are many different types of failure that can affect database processing, each of which has to be dealt with in a different manner. Some failures affect main memory only, while others involve non-volatile (secondary) storage. Among the causes of failure are:

by Dinesh Thakur Category: Advanced Database Tech.

A DBMS can use encryption to protect information in certain situations where the normal security mechanisms of the DBMS are not adequate. For example, an intruder may steal tapes containing some data or tap a communication line. By storing and transmitting data in an encrypted form, the DBMS ensures that such stolen data is not intelligible to the intruder. Thus, encryption is a technique to provide privacy of data.

by Dinesh Thakur Category: Advanced Database Tech.

Security is an important issue in database management because information stored in a database is very valuable and many time, very sensitive commodity. So the data in a database management system need to be protected from abuse and should be protected from unauthorized access and updates. It is popular belief that hackers cause most security breaches, but in reality 80% of data loss is to insiders.

by Dinesh Thakur Category: Advanced Database Tech.

The lack of standard definition and framework for an OODBMS led to the design of first Object-Oriented Database System manifesto that was published in the Proceedings of the

First International Conference on Deductive and Object-Oriented Databases, Kyoto, Japan, December 1989. The manifesto included a set of features that a DBMS mustĀ· have to be referred as an OODBMS. The features framed were subdivided in three categories:

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.


Page 4 of 5

Subscribe To Free Daily Newsletter!

Get Free News Updates Delivered Directly To Your Inbox
About Dinesh Thakur

Dinesh ThakurDinesh Thakur holds an B.SC (Computer Science), MCSE, MCDBA, CCNA, CCNP, A+, SCJP certifications. Dinesh authors the hugely popular Computer Notes 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.

What's New and Popular

Search Content

Advance Courses

Basic Courses

Advertise with Us