StudentShare solutions
Triangle menu

Database Technology - Essay Example

Not dowloaded yet

Extract of sample
Database Technology

Object oriented databases have now become very popular as they provide a greater degree of flexibility in data storage and also provide a resource efficient storage mechanism. The data storage in the object oriented databases is in the form of objects instead of storing as rows and columns.
The integration and connectivity of individual systems provide support to connect stand alone machines. In the current environment, the databases are all linked at the backend. This provides for client-server database architecture which gives a whole new dimension to existing database structure.
The databases today are based on client-server architecture and provide support for multimedia content. They are huge in size as storage costs are not of much concern today. Data warehouses act as archives and analytical tool for the historical data.
Relational database was a revolution in the field of databases. The idea of having a tabular structure composed of rows and columns was a ground breaking proposition to make storage and retrieval easier than ever before.
Peter Rob in his book describes the relational database in terms of storage and representation. The relational database model allows the designer to focus on the logical representation of the data and its relationships than the physical storage details. The tables are all logical, having the similar physical storage mechanisms at the backend.

The relational databases are based on a row-column structure, each column being an attribute and a row as record. Each record or row can have a number of attributes for a particular record.

Each table is referred to as relation, and hence called relational database, having a unique attribute(s) which make up the primary key. Each table is linked to one or more tables through the primary key and foreign key architecture.

By structure, the relational database does not have any cap on storage limit, but due to storage limitations, they may act as constraints to the system.

The relational databases use the concept of indexing for making the search faster and easier. The indexes are not the keys, but are attributes used for faster searching. They are the attributes which are frequently used for searching.

The structure of relational databases can be seen in the following Entity Relationship Diagram and Relational Schema showing the entities and their attributes along with the relationships among them.


Relational Databases Vs Other Databases
The relational database is different from other databases in that the storage mechanism of relational databases is based on tables.
1. The flat file uses different files to store data
2. Object-oriented uses objects as storage units
3. Hierarchical makes and traces data based on their hierarchies
4. Network is similar to hierarchical but the hierarchies are in both directions, that is many parents can have a common child
5. Hybrid or Object-Relational Databases are becoming popular too. They have a mixed structure with the features of both the relational and object-oriented databases

Theory
E F Codd was a researcher at IBM. He proposed the model for the modern relational Database Management System. He presented the twelve points that any ideal relational ...Show more

Summary

Database technology started from flat file storages and over the years evolved into electronic data storages in the form of records and tables to complete relational and object-oriented databases. Today, the databases are not just restricted to objects, but they have also gone to the level of media support in the form of multimedia databases which support multimedia content to be stored in the databases.
Author : zelda46
Database Technology essay example
Read Text Preview
Save Your Time for More Important Things
Let us write or edit the essay on your topic
"Database Technology"
with a personal 20% discount.
Grab the best paper

Related Essays

Data Server Technology - Database Modeling and Implementation For International Parcel Deliveries
The purpose of this research is to investigate the relationships defined: customer/order; customer/invoice; order/shipment; cost/shipment. The research is designed based on the assumption: All the fields entered by the user in the web application are validated for invalid input errors before storing it in the database.
20 pages (5000 words) Essay
An Introduction to Database Technology and Database Management
Data is a collection of raw and unrefined pieces of information that do not give any meaning, in their present state. It is normally used for analytical purposes and must be organized in a certain manner so as to become useful (Dixon, 2000). It is mostly comprised of facts and figures about certain events and occurrences that require being organized, analyzed and interpreted to give rise to some required information about this events and occurrences.
3 pages (750 words) Essay
Object Database Management System
A database is a set of records stored in a computer in an organized way, so that a computer program is able to consult it to answer questions. For better recovery and sorting, each record is generally organized as a set of data elements. The objects retrieved in reply to queries become information that can be used to make decisions. The computer program used to control and query a database is known as a database management system.
8 pages (2000 words) Essay
Managing Information Technology Globally (I need someone with a good backgroud about IT and Database for this case analysis)
Then, Dell thought to establish the business online. Online sale of dell products were giving a firm business. Not only this but also the orders for the products, their customer services, and other services which includes developing Premier Pages easy to optimize by small companies.
2 pages (500 words) Essay
Images and Database Technology
Graphical abilities of today's media and computers impress: digital imaging allows not only to store and process digital images but also to develop and design new graphical objects and solve different graphical modeling tasks. Digital images are widely used instead of traditional pictures, photographs, movies, etc.
11 pages (2750 words) Essay
Database Management. MSSQL Server Database
Navathe (2003) defines database as a collection of programs that enables users to create and maintain a database. It can also be defined as general purpose software for defining, creating, fetching and sharing databases among various users. The flavors of the databases used for e-commerce websites follow a different pattern set for storing data and offer various storage patterns and features to enable it to be distinguished from the competitor.
3 pages (750 words) Essay
Relational Database
Today, with the increasing data requirements and storage needs, the databases have gone a step further. The emergence of data warehouses or advanced
8 pages (2000 words) Essay
Database Applications
In particular computer-based IS are corresponding networks of software/hardware that people and businesses utilize to filter, collect, create, process and distribute data. Nowadays, computer
8 pages (2000 words) Essay
Database Design Project
When any damage to this business resource occurs then the whole business can go down or may function improperly. Through seeing this huge development in technology and its potential advantages to the business “Mayo Clinic Medical
8 pages (2000 words) Essay
Relational database solution
For businesses or organizations information is not only relevant today but can be helpful in the coming future. Information helps in the planning as well as forecasting for the future in a business
2 pages (500 words) Essay
Get a custom paper written
by a pro under your requirements!
Win a special DISCOUNT!
Put in your e-mail and click the button with your lucky finger
Your email
YOUR PRIZE:
Apply my DISCOUNT
Comments (0)
Rate this paper:
Thank you! Your comment has been sent and will be posted after moderation