Data Warehouses and Databases Essay

Submitted By mann0687
Words: 653
Pages: 3
Open Document
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 examines how databases turn data into useful information, what data warehouses do with this information, and how it is retrieved from data marts.

A database is a collection of data organized for simple search and retrieval. It can be something as simple as a class attendance list, or as complex as an online SQL database. In either instance, organizing information for quick access is the definite purpose.
Consisting of bytes (characters), rows (records), and columns (fields), databases are usually organized into tables (Kroenke, 2010). Students of business will have experience in creating databases from previous courses taken at NAIT. A form letter in Microsoft Word is a database, taking information such as name, address, job title, and giving it a specific record number. When the fields of data are input into the document, information is retrieved from the database and assigned to those fields. This creates the database.

A data warehouse uses the information from operational databases, other internal data, and external data to extract, clean, and prepare it to be stored in a data warehouse for the purpose of analyzing and decision making (Kroenke, 2010). This information becomes normalized and is given structure. This means that information going into the data warehouse is translated into different forms as needed so it becomes useful to the end user. As an example, a store product code from a sales database could be transformed into a UPC to be compared against information from an external database. A recent working example of a data warehouse can be found in IBM’s Watson Project. A supercomputer that stores a seemingly unlimited amount of data, Watson took on the two most successful Jeopardy contestants in history and won. For Watson, however, the decision making and interpretation was solely up to the computer. The famous line “What is leg?” is a perfect example of how the human element is still important in mining information. This is why a data warehouse is a staffed site where data is stored and catalogued by technical staff, and indexed and analyzed by business analysts to ensure content is relevant and operational.

A data mart can be
Show More

Related Documents: Data Warehouses and Databases Essay

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

Relational Database Optimized For Online Transactions

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…

Words 998 - Pages 4

Examples Of Online Transaction Processing

—Sales orders, accounts receivable, etc —Supported by operational databases & DBMSs •Online analytical processing (OLAP) manipulation of information to support decision making —Helps build business intelligence —Supported by data warehouses and data-mining tools RELATIONAL DATABASE MODEL: žDatabase – collection of information that you organize and access according to the logical structure of the information žRelational database – series of logically related two-dimensional tables or files…

Words 1401 - Pages 6

Database Essay

Chapter 03: Database Systems, Data Centers, and Business Intelligence TRUE/FALSE 1. A database, a database management system, and the application programs that use the data make up a database environment. ANS: T PTS: 1 REF: Why Learn About Database Systems, Data Centers, And Business Intelligence 2. A database scientist is a skilled and trained IS professional who directs all activities related to an organization’s database, including providing security from intruders. ANS: F PTS: 1 REF:…

Words 3288 - Pages 14

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

Systems: Sql and Database Management Systems Essay

making it a huge problem. Also it takes up tons of space which means money. 2. A database typically stores data values in tables. Databases offer a greater range of complexity in terms of data manipulation. With database management systems, several people can access the same data set. 3. Database management system is a software that manages database on a computer. Eg. Microsoft access, MySQL, oracle. Database are classified according to their organizational approach. 4. To help with problems…

Words 400 - Pages 2

Design Document: Compute Inc.: Change Record

Project Overview 4 1.2 Background including current process 4 1.3 Current Assessment 4 1.4 Best Practices. 5 1.4.1 Planning data warehouse design 5 1.4.2 Designing a logical data model 6 1.4.3 Implementing a physical data model 6 1.4.4 Designing an aggregation layer 6 1.4.5 Designing with new DB2 Version 10.1 features 6 1.5 Appendix 7 1.5.1 Database schema 7 1.5.2 Data Flow Diagram 8 1 Design Requirements 1.1 Project Overview ComPute Inc. is a leading internet technology company…

Words 1492 - Pages 6

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

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

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