Compare the characteristics of an operational database and a dimensional database - Essay Example

Add to wishlist

Summary

Operational databases are well designed and develop with recovery mechanism and concurrent control to ensure the integrity and consistency for the transactions. The operational databases are optimized for the…

Download full paper File format: .doc, available for editing

GRAB THE BEST PAPER97.6% of users find it useful

Compare the characteristics of an operational database and a dimensional database

Read Text Preview

Subject: Information Technology
Type: Essay
Level: Undergraduate
Pages: 1 (250 words)
Downloads: 2
Author: handrubye

Extract of sample "Compare the characteristics of an operational database and a dimensional database"

Compare the characteristics of an operational database and a dimensional database First Computer sciences and Information technology Instructor’s NameDatedCompare the characteristics of an operational database and a dimensional databaseOperational Database:Operational database supports for the information of the organization. Operational databases are well designed and develop with recovery mechanism and concurrent control to ensure the integrity and consistency for the transactions. The operational databases are optimized for the transaction processing for the daily business activities.

There is numerical use of data for the operational databases. The size of the operational database may range from megabytes to gigabytes. Key performance metric of operational database is the recovery and consistency for the transaction processes. The data normalization for the operational database is required at a very high level to avoid the data redundancy. This type of databases is also referred to the “On-Line Transaction Processing” OLPT. This type of database is updated after every transaction and also represents the snapshot of a very current business situation.

In an operation database, records are changed, updated, added and replaced. Relational model is used to compose operational systems with update and insert operations.Dimensional Database: Current databases are multidimensional, and technology is applied to distributed data. Large, complex, and high performance data is only facilitated by the dimensional database. For example, a sale manager wants to view the sale of a product for the particular region over a period. This is the dimensional view of data as higher dimensionality requires the high volume of data.

The “On-Line analytical processing” known as OLAP enables the managers, analysts and professional to gain insight in view of information. An OLAP server supports the structures of the dimensional database. For dimensional databases, the multidimensional model is used to model the system. A company has multidimensional database of products, sales, finance, and employees. (IBM 2000)Comparisons of operational database and dimensional database have been given with important points, which differentiate the two types of databases.

References:IBM (2000). Business Intelligence Certification Guide (1st Ed.). International Business Machines Corporation.

Cite this document

APA
MLA
CHICAGO

(“Compare the characteristics of an operational database and a Essay”, n.d.)
Retrieved from https://studentshare.org/information-technology/1609521-compare-the-characteristics-of-an-operational-database-and-a-dimensional-database

(Compare the Characteristics of an Operational Database and a Essay)
https://studentshare.org/information-technology/1609521-compare-the-characteristics-of-an-operational-database-and-a-dimensional-database.

“Compare the Characteristics of an Operational Database and a Essay”, n.d. https://studentshare.org/information-technology/1609521-compare-the-characteristics-of-an-operational-database-and-a-dimensional-database.

Cited: 0 times

CHECK THESE SAMPLES OF Compare the characteristics of an operational database and a dimensional database

Distributed Database

This project uses dimensional modeling, which is the name of the logical design technique often used for data warehouses.... Entity relationship modeling is a logical design technique that seeks to eliminate data redundancy while dimensional modeling seeks to present data in a standard framework that is intuitive and allows for high-performance access.... Every dimensional model is composed of one table with a multi part key, called the fact table, and a set of smaller tables called dimensional tables....

12 Pages (3000 words) Essay

Knowledge Management and Business Intelligence: trends and integration

Under these circumstances we are observing huge developments in the field of database technology.... So, the deployment of this technology in information systems and database provides support for the business, organizational record keeping and report generation based on some specific query.... However, with the enlargement in sizes and volumes of business and corporate operational data, we can see that latest and exciting issues are rising....

16 Pages (4000 words) Research Paper

Using a Star Database Schema

And it entails a set of technologies and techniques that are used in management of data (Michelle, 2007,… These data warehouses are made using a dimensional model such as the star schema diagram (SSD) or a relational model like the entity relationship model.... hese data warehouses are made using a dimensional model such as the star schema diagram (SSD) or a relational model like the entity relationship model.... The main aim of a marketing department adopting the use of a dimensional model is to help decision makers in making strategic decisions without the need of help and support from database experts thereby avoiding extra cost....

2 Pages (500 words) Research Paper

The Role of Operational Business Intelligence

This is increasingly essential as businesses rely on the capability to… late and analyze data for their survival, in return this propel the demand for operational business intelligence (Turban, Sharda, Delen & King, 2010). Operational analytics refer to the high availability of database computing environment made up of redundant components and These components are applied in operational management allowing the management to access up-to-date data in real-time.... operational BI (Business Intelligence) involves a combination of analytical processes within operating business structure in order to trigger real-time decision-making and collaboration in the business....

4 Pages (1000 words) Essay

Manage Information of Northampton Business School

nbsp; This report will focus on developing a suitable database for observing and identifying reasons behind the decreasing student attendance of the Northampton Business School.... From the report it is clear that the database making process has been developed considering not only the problem of reduced attendance of the students but will also provide an overall view of the factors that is contributing to the reduced rate of attendance in Northampton Business School....

11 Pages (2750 words) Essay

The Critical Success Factor of Data Warehousing Implementation: Key Challenges for a Company Like Offco

It integrates various data from different systems into one unified database and offers a single view of the entire business.... The present work will initially introduce two well-known approaches to developing data warehouses created by Kimball and Inmon before moving on to a comparison of the advantages and disadvantages of these approaches....

15 Pages (3750 words) Research Paper

Difference between Off Shoring and Outsourcing

Similarly in terms of outsourcing operational and managerial systems of IT, one should always consider the above mention theory.... f a company is likely to outsource operational services of IT then these services should include networking services, as these services are less likely to come under core services.... Moreover, these kinds of operational services should be outsourced by the company in terms of IT operations....

9 Pages (2250 words) Assignment

Geographical Information System

This was the spatial database management system (SDBM) which linked management capabilities from traditional database and those of computer mapping capabilities.... Formative years of GIS provided the platform for the basic organization of the company's processing structures and database which are still Since its growth in the 1960's GIS has evidently evolved both in practical expressions and its capabilities.... Formative years of GIS provided the platform for the basic organization of the company's processing structures and database which are still in use in the modern GIS....

7 Pages (1750 words) Essay