320 likes | 810 Views
CS2032 DATA WAREHOUSING AND DATA MINING. UNIT II BUSINESS ANALYSIS. Contents. Reporting and Query tools and Applications Tool Categories The Need for Applications Cognos Impromptu Online Analytical Processing (OLAP) Need –Multidimensional Data Model OLAP Guidelines
E N D
CS2032 DATA WAREHOUSING AND DATA MINING UNIT II BUSINESS ANALYSIS
Contents • Reporting and Query tools and Applications • Tool Categories • The Need for Applications • Cognos Impromptu • Online Analytical Processing (OLAP) • Need –Multidimensional Data Model • OLAP Guidelines • Multidimensional versus Multirelational OLAP • Categories of Tools • OLAP Tools and the Internet
Reporting and Query Tools and Applications • Tool Categories • Reporting Tools • Managed Query Tools • Executive Information System Tools • OLAP Tools • Data Mining Tools • The Need for Applications • CognosImpromtu • Applications • PowerBuilder • Forte • Information Builder
Reporting Tools • Production Reporting Tools • Let companies generate regular operational reports • Support high volume batch jobs • Calculating and Printing Paychecks(3GL) • COBOL, Information Builders, Inc.’s Focus(4GL) • MITI’s SQR(High-end Client/Server Tools) • Desktop Report Writers • Let users design and run reports • Graphical Interfaces and Built-in charting functions • Crystal Reports, Actuate Reporting System, IQ objects
Managed Query Tools • Shield end users from the complexities of SQL and database structures • Meta layer • Support asynchronous query execution • Integrate with web servers • Embed OLAP and Data Mining Features
Executive Information System Tools • Predate report writers and managed query tools • First deployed on Mainframes • Allow to build customized, graphical decision support applications • Gives managers and executives a high level view of business and access to external sources • Eg: Pilot Software, Forest and Trees, Comshare, Oracle’s Express Analyzer
OLAP Tools • Provide and intuitive way to view corporate data • Aggregate data along common business objects • Users can drill down, across, or up levels in each dimension
Data Mining Tools • User variety of statistical and artificial-intelligence algorithms • Analyze the correlation of variables in the data and ferret out interesting patterns and relationships to investigate • Example • IBM’s Intelligent Miner • DataMind • Pilot’s Discovery Server • Offers simple UI’s – plug in directly to existing OLAP
The Need for Applications • Access Types to the data • Simple tabular from reporting • Ad hoc user-specified queries • Predefined repeatable queries • Complex queries • Ranking • Multivariable analysis • Time series analysis • Data visualization, graphing, charting, and pivoting • Complex textual search • Statistical analysis
Cognos Impromptu • Overview • The impromptu Information Catalog • Object-oriented architecture • Reporting • Impromptu Request Server • Supported Databases
CognosImpromtu: Overview • Enterprise solution for interactive database reporting • Object oriented architecture • Ensures control and administrative consistency across all users and reports • GUI • Database reporting tool • Supports single user reporting / multi users reporting
CognosImpromtu: Information Catalog • LAN based repository of business knowledge and data access rules • Insulates users from db technical aspects • Protects database • Presents the database in a easy way • Administrators are free to organize database items
CognosImpromtu: OO Architecture • Drives inheritance based administration and distributed catalogs • Governors • Activities of Governors • Query activity • Processing location • Database connections • Reporting permissions • User profiles • Client/Server Balancing • Database Transactions • Security by value • Filed and table security
CognosImpromtu: Reporting • Picklists and prompts • Custom templates • Exception reporting • Conditional filters • Conditional highlighting • Conditional display • Interactive reporting • Frames • List frame • Form frame • Cross-tab frame • Chart frame • Text Frame • Picture Frame • OLE Frame
CognosImpromtu: Request Server • Allows client to off-load the query process to the server • Scheduling regular and recurring standard reports • Reducing network traffic • Runs on HP/UX 9.X, IBM AIX 4.X, Sun Solaris 2.4 • Support data maintain in ORACLE 7.x and SYBASE System 10/11
On-Line Analytical Processing(OLAP)(1) • Need for OLAP • Multidimensional Data Model • OLAP Guidelines • Multidimensional versus Multirelational OLAP • Categorization of OLAP Tools • MOLAP • ROLAP • Managed Query Environment(MQE)
On-Line Analytical Processing(OLAP)(2) • State of the Market • CognosPowerPlay • IBI FOCUS Fusion • Pilot Software • OLAP Tools and the Internet
Multidimensional Data Model • Viewing data as in a cube
OLAP Guidelines • Multidimensional conceptual view • Transparency • Accessibility • Consistent reporting performance • Client/server architecture • Generic dimensionality • Dynamic sparse matrix handling • Multiuser support • Unrestricted cross-dimensional operations
Categorization of OLAP Tools • MOLAP • ROLAP
State of the Market • CognosPowerPlay • IBI FOCUS Fusion • Pilot Software