Relational Database Optimized For Online Transactions

Submitted By Phense
Words: 998
Pages: 4
Open Document
A relational database optimized for online transactions is designed to automate transaction processing, record keeping, and simple business report transactions (Power, 2000, pg. 8). The data in a relational transaction system usually require a normalized structure with many tables, each containing a minimum of attributes and emphasizing data integrity. Query activity in the relational database tends to be low for additional processing cycles. A data warehouse focuses on querying capabilities and tends to be non-normalized, including few tables which contain large numbers of attributes. The queries in the data warehouse are usually broad in scope and complex. A data warehouse is also inclined to very large amounts of data, which is stored in non-normalized tables housing many redundancies (Coronel, Morris, and Rob, 2013, pg. 552).
A decision support database is a specialized database management system tailored to provide fast answers to complex queries. There are three main requirements for a decision support database, which are the database schema, data extraction and filtering, and the size of the database. The decision support database schema must support complex data representations and must be able to extract multidimensional time slices (Coronel, Morris, and Rob, 2013, pg. 553). The schema must also be optimized for query retrievals. Decision support data is created mainly from extracting data from an operational database and using additional data from external sources, which means the database management system needs to support advanced data extraction and data-filtering tools, the decision support database’s filtering capabilities must include the ability to check for inconsistent data or validation rules. A decision support database is usually very large in size; therefore, the database management system must be capable of supporting very large databases (Coronel, Morris, and Rob, 2013, pg. 554). An operational database consists of system-specific reference data and event data that belongs to a transaction-update system. It is the source of data for the decision support data and data warehouse, containing detailed data used to run day to day operations. The data is continuously changing and being updated (What is Operational Database, 2007). Requirements for operational data include integrated subject oriented data, volatile data, current data, and detailed data. Operational data will usually contain several weeks or months worth of data while decision support data will contain large historical data (Bowman). Operational data is usually stored in a relational database and tends to be heavily normalized and optimized to support daily operations. Operational data represents individual transactions within many tables while decision support data encompasses transactions over time in very few tables (Coronel, Morris, and Rob, 2013, pg. 550).
The U.S. Air force used databases to analyze the impact of various base closure scenarios. The software used a multi-layer, hierarchical filtering process to evaluate the impact of closing the bases. Those that were of minimum strategic, operational, social, and economic impact were placed at the top of the list. This information focused on elements that impacted operational effectiveness, such as alternate airfield availability, weather, and facility capacity. In this example, the committee for closing the bases could easily bring up the information in an orderly manner and make a decision based on the data provided for closing a particular base (Power, 2000, pg. 20). Another example is ShopKo, which created a data warehouse to collect daily statistics on every stock unit in every store. The data collected helps ShopKo in determining the right merchandise to sell in a specific area during a specific time while remaining current with changing demands due to seasons, trends, and many other factors (Power, 2000, pg. 20-21). The last example is of Federal Express, which created a
Show More

Related Documents: Relational Database Optimized For Online Transactions

Data Warehouse and Data Essay

Data warehousing plays a vital role and important area of information technology infrastructure Data warehousing is a structure that holds data in a précised manner and data can be retrieved based on the business requirements of a company. There are many different kinds of data ware housing systems that a data is stored in a company and will be vary based on the storage like star flex schema data ware house, snow flake data ware house, metadata ware house and enterprise data warehouse systems…

Words 2814 - Pages 12

Data Warehouses and Databases Essay

Data Warehouses and Databases Northern Alberta Institute of Technology Introduction Keeping track of information and knowing where it is at all times is a challenge for any organization. The need to be able to access and find information is extremely important. Above being able to find the information it needs to be useful and simplified for the users. Being able to turn data into information and storing the data in an accessible place is a huge need to organizations of any magnitude. This paper…

Words 653 - Pages 3

A Case Study: Opening Up The Data Warehouse '

________________________________________________________________ Opening up the data warehouse ________________________________________________________________ ________________________________________________________________ INFT13-320 Advanced Database Assignment 2 – Semester 122 ________________________________________________________________ Prepared by: Ryan Mouritz Prepared for: Bruce Vanstone Due Date: Friday 29 June 2012, 16:00 ________________________________________________________________…

Words 2523 - Pages 11

Data Warehouse and Business Intelligence Essay

community easy access to business data”. Business Intelligence Roadmap by L. T. Moss and S. Atre, Addison Wesley. Requirements: (1) Three definitions for “Business Intelligence” with source information. Include at least one definition found from a journal article. If website resources were used, include not only the web link/address but also information such as company name, author, page title, etc. 1. “BI is an umbrella term that combines architectures, tools, data bases, applications, practices…

Words 345 - Pages 2

Dimensional Modeling Fact Tables Essay

Dimensional Modeling ISYS637 Vocabulary Fact Table Dimension Table Star Schema Snowflake Schema 3/4/15 ISYS 637: DATA WAREHOUSE 2 Figure: Generating Reports from facts and dimensional attributes 3/4/15 ISYS 637: DATA WAREHOUSE 3 Dimensional Design Process (Source: “The Data Warehouse Toolkit” by Kimball and Ross, 2013) 1. Select the business process to model ◦ E.g. a dimensional model to capture order process 2. Declare the grain of the business process ◦ Specify exactly what an individual…

Words 1396 - Pages 6

Real Time Business Intelligence at Continental Airlines Essay

Describe “active” data warehousing as it is applied at Continental Airlines. Does Continental apply active or real-time warehousing differently than this concept is Normally described? Explain your answer. Answer: as shown in the case Continental senior management decided to invest in enterprise data warehouse that all employees could use for quick access to key information about the business and its customers. The data warehouse initial focus was to provide accurate integrated data revenue management…

Words 1686 - Pages 7

Essay On Data Warehousing

Data warehousing can greatly benefit and help any organization. In the book “Databases Illuminated”, data warehousing is described as a storage place of a company’s historical data that is often collected from various departments or sections of a company that belong to the company as a whole (Ricardo, 2012). With the scope and range of data that is stored this can at times include massive amounts of data. Such a “warehouse” of data can be invaluable to a company. I am sure that once anyone understands…

Words 2252 - Pages 10

Database: Database and Information Essay

Chapter 7 Databases and Data Warehouses 7.1 Databases * <<Introduction>> * The ability to understand, digest, analyze, and filter data and information is key to success for any professional in any industry. * Data are raw facts that describe the characteristics of an event. * E.g., characteristics for a sales event can include a date, item number, item description, quantity ordered, customer name, or shipping details. * Information is data converted into a meaningful…

Words 2716 - Pages 11

Nt1310 Unit 3 Data Derivation

the design). • Verifying the data within the transforming stage (making sure that the workflow is correct by testing and evaluating) • Execute the transforming stage. • Replacing the clean data with dirty data from original sources in order to improve data consistency and avoiding re-cleansing data for future extraction. 2.2.3 Data Derivation Data derivation is the process of creating a data value from many contributing data values through derivation algorithm. Data derivation is very vital because…

Words 1464 - Pages 6

Mis Chapter 5 Essay

paragraph on each article, including: (1)Data, data everywhere -The world contains a vast amount of digital information that can make it possible to do many things, the data should be managed well that can be used to new sources of economic value, provide fresh insights into science and hold governments to account. -The interesting part of this article that I found out is the business of information management is helping organizations to make sense of their data, such as IBM, Microsoft. (2)All too…

Words 880 - Pages 4