IP 4 COMPUTERS AND INFO

Running head : IP 4 COMPUTERS AND INFO

IP 4 COMPUTERS AND INFO Which database is being used (MS Access , DB2 , Oracle , MS Sequel , etc

The database used in the organization Acunix Technologies ' is Oracle 11G . It is extensively used to store data of the departments of the organization in processing the various business compliances to achieve the objective

Who is the manufacturer or the distributor of the database software

The manufacturer is Oracle Ltd and it is distributed by Oracle India Pvt Ltd as a sole distributor . They distribute the software as

a release and offers patches for updations and any extensions . The licenses obtained are for a price and it is required for validation of the system . Fresh licenses are obtained every 2 years

How the business uses the database

The Oracle database is used by the organization in the following ways

Storing data of the various lower end processes to be further processed for making crucial decisions

Mapping associations , checking and establishing constraints and relationships for capturing the business data for making crucial decisions for the business

Storing project information and metrics data which dynamically produces reports and manages the basic synchronization of project budgets and time resources

Conversion of the data into MIS reports and organizing them into various data marts for faster fetching of the data

Periodic reports for fetching the right scenario or snapshot of the databases

How long has it been in use

The business has recently upgraded to the new database from the manual system to automate its business data storage . The need was crucial as they were planning to store large data for data mining purpose and make critical analysis to fetch large scale decisions for the business growth and continuity

Major advantages (3 ) and disadvantages (3 ) of the database

The major advantages are as follows

Ensures security of data and protection against harmful viruses and other forms of malware programs . The data encryption feature is quite strong in Oracle which makes it less vulnerable to tap data in the process of filling up application forms and online payment facilities The centralized feature of data would debar unintentional users and would force them to use secured login access

The OLAP feature of the Oracle facilities planning , forecasting budgeting , optimization of queries , faster data access and lot more (Oracle .com , 2008

The partitioning feature of the Oracle database makes sure that the large information base is successfully divided for security and accessibility reasons

Oracle Remote Access Control makes sure that a number of users work for a variety of purposes at the same time . It facilities high availability and scalability of performance

Oracle is quite robust in maintenance and performance

Oracle is also susceptible to great recovery options and disaster management

Efficient data dictionary for strong user information , integrity constraints , names and data types , space allocation sizes

It monitors job queue processes , log writer processes , remote server and shared server techniques

Offers an efficient recovery manager . Provides for guarding of data and...