Database Design

Running head : DATABASE DESIGN

Database Design What is a 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

The e-commerce websites deal with a variety of products and

services and requires their data to be stored in a database so that it can be successfully fetched and modified for performing a variety of functions .Oracle as an e-commerce database

Oracle stores data logically in the form of table spaces and physically in the form of s . The various options available by the oracle software which makes it quite suitable to an e-business

Advanced security : The combination of the network encryption transparent data encryption at the column and table space level and strong authentication makes the users secure and preserves their data privacy (Oracle .com , 2007b

Content database : The oracle software enables organizations to control and manage large volumes of unstructured content such as documents spreadsheets , images in a centralized repository which gets easy to access and maintain (Oracle .com , 2007c . The benefits can be summarized as follows

Centralized information access which makes sure that it replaces dispersed servers with a single repository

Lower administrative costs , rapid development and highly scalable

Database vault : It facilitates greater access only with authorization for any resource of the database . It prevents the following

Protection from inside threats

Restrict access to receptive information

Data mining : It enhances productivity and enhances better informed decisions , solves business problems faster and enables faster development environment Oracle .com (2007e

Label security : It ensures multilevel security capabilities to protect access of data . It can control access based on data sensitivity , quite easy to implement and enforce compliance (Oracle .com , 2007a

Business intelligence : It provides standards to grow with the business and keeps the users in mind for getting the job done (Oracle .com 2007d

OLAP : It supports the entire planning , budgeting , forecasting and sales It also provides mechanism to optimize queries accessing multi-dimensional data . It can allow providing decision makers with access to data in a faster and with lower costs (Oracle .com , 2007f

Partitioning : It improves manageability , performance and availability It can greatly simplify common admin tasks . It allows the database administrator to manage large scale information (Oracle .com , 2007g

The various database features make it possible to be integrated with the web application so that they are able to optimize resources . The various other features are as follows

The automatic workload repository feature provides monitoring capability of the oracle database

Data aggregation and consolidation feature manages data from legacy systems , consolidate data sources and cleanse raw data to make it complete information

MySQL

MySQL is used extensively in e-commerce websites for storage of information and...