120 likes | 135 Views
The Multidimensional Model & OLAP (IV). Developed by: Dr Eddie Ip Modified by : Dr Arif Ansari. Outline. Demo : Websites powered by BI tools http://www.nasdaq.com (powered by Impromptu) http://www.informationbuilders.com/applications/powered_bywf.html (powered by WebFocus)
E N D
The Multidimensional Model & OLAP (IV) Developed by: Dr Eddie Ip Modified by : Dr Arif Ansari
Outline • Demo : Websites powered by BI tools • http://www.nasdaq.com (powered by Impromptu) http://www.informationbuilders.com/applications/powered_bywf.html (powered by WebFocus) • Basic Web Terms & Concepts • Illustration by WebFocus
Web-based Data Access • Convergence of web and DW/BI technology • Facilitated by open environment : SQL , ODBC • Thin client based (e.g. Web browser) applications • Robust architecture to support thin client computing
Basic Terms & Concepts • Thin client : client/server model where computing burden is on server • CGI-based programs used to access databases from the Web and display thro’ browser • e.g. Oracle’s Web Application Server (the in-between tier in a 3-tier structure)
Thin Client • CGI programs manages all phases in sequence • huge overhead for CGI (client not sharing load) • Application Programming Interface (API) from Web servers (e.g. NSAPI from Netscape,ISAPI from MS) reduces CGI overhead
Thin Client • Thin client has limited presentation capabilities (tradeoff- speed & security) • Java or ActiveX programs (applets) downloaded “just-in-time” (sandbox idea) • Demo: • http:www-rcf.usc.edu/~mvmwt • Provide interactive capability on client side • Better security than plug-ins
middleware Web client API , CGI Application server Html, javascript java ODBC (window) JDBC (java) DB Server SQL
DB Queries • Queries : content rich, IT-oriented • Reports : format rich, business-oriented • Static versus Interactive
DB Queries • Underlying technology of information retrieval : SQL and OLAP • Example of Web-based reporting tool: WebFocus • Alternative: Build Web-interface. E.g. nasdaq.com, driven by Impromptu
Features of reporting tools • SQL-based & OLAP-based • Friendly user interface • Format rich • Often web-enabled • Interactive reporting : get most current results from database
Summary • Web-based Data Access • Data Base Queries • Features of reporting tools
Glossary • CGI: Common Gateway Interface • API : Application programming interface • ODBC: Open Database Connectivity • JDBC: Java Database Connectivity • SQL : Structured query language • OLAP: Online Analytical Processing