CIS 764 Database Systems DesignSlide 2Slide 3Slide 4Slide 5Slide 6Slide 7Slide 8Slide 9Fall 2008http://www.cis.ksu.edu1CIS 764 Database Systems Design L18.3 Business Intelligence Aspects (aka Decision support systems) (Slides support from Tomas Bartos, 2006)Fall 2008http://www.cis.ksu.edu2CIS 764 Database Systems DesignProducts (technologies and applications)used for collecting, analyzing and interpreting data – analyze and report data off-line and real-time – assist / suggest decisions – improve business processes http://en.wikipedia.org/wiki/Business_intelligenceFall 2008http://www.cis.ksu.edu3CIS 764 Database Systems Design● Data mining● Dashboards● OLAP (Online Analytical Processing)● Reporting software● BPM (Bussiness Performance Management)● DSS (Decision Support System)● Data WarehousingFall 2008http://www.cis.ksu.edu4CIS 764 Database Systems DesignOracle BI Standard Edition (SE)Oracle BI Standard Edition OneOracle BI Suite Enterprise Edition (EE) Plus● Business Intelligence Server – business model and layer of abstraction● Business Intelligence Interactive Dashboards – accessing content of applications● Business Intelligence Answers – querring and analyzing tool● Bussiness Intelligence Publisher – reporting toolFall 2008http://www.cis.ksu.edu5CIS 764 Database Systems DesignFall 2008http://www.cis.ksu.edu6CIS 764 Database Systems Design data warehouse a repository of an organization's electronically stored data. … designed to facilitate reporting and analysis data might be transformed to be suitable for analysis http://en.wikipedia.org/wiki/Data_warehouse vs transaction databaseFall 2008http://www.cis.ksu.edu7CIS 764 Database Systems Design● ETL (Extract, Transform and Load)● OLAP – MOLAP (Multidimensional OLAP) – ROLAP (Relational OLAP) – HOLAP (Hybrid OLAP)● Reporting (presentation layer)Fall 2008http://www.cis.ksu.edu8CIS 764 Database Systems Design● Oracle Warehouse Builder – management, transformation, optimization – design ETL processes – more data sources supported● Oracle Data Mining (ODM) – optional to Oracle DB 11g – Oracle Data Mining JDeveloper and SQLDeveloper Extensions● Oracle OLAPFall 2008http://www.cis.ksu.edu9CIS 764 Database Systems Design
View Full Document