mis6324introductionII - Click to edit Master subtitle style...

Info iconThis preview shows pages 1–5. Sign up to view the full content.

View Full Document Right Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Click to edit Master subtitle style 10/2/11 Business Intelligence Software and Techniques Syam Menon MIS 6324 10/2/11 Databases • Used to maintain and access data efficiently • Mostly applied for On-Line Transaction Processing (OLTP) • Designed and optimized for fast transactions • Inserts, updates, and deletes • Typically contains current, “active” data. • Old data are archived. • Have reporting capabilities • Can query database via a query language like SQL • Example: • List all student IDs and corresponding grades of students enrolled in MIS 6324 and whose grade is at least B. • Query result is: 22 ID Grade utd121 B utd124 A- utd126 B+ 10/2/11 Databases • Consist of flat, 2-dimensional tables • Some tables (e.g. pivot table in MS-Excel) can be multi-dimensional, but generation is manual • Can multi-dimensional tables be represented automatically? • Data Warehousing and O n L ine A nalytical P rocessing (OLAP) • Queries not intended for knowledge discovery • Business Intelligence 33 10/2/11 Data Warehouse • An application database is designed (and optimized) to record . • A data warehouse is designed (and optimized) to respond to analytical questions that are critical for a business....
View Full Document

This note was uploaded on 10/02/2011 for the course MIS 6312 taught by Professor Wiorkowski during the Spring '11 term at University of Texas at Dallas, Richardson.

Page1 / 14

mis6324introductionII - Click to edit Master subtitle style...

This preview shows document pages 1 - 5. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online