1 / 12

Web-Based Data Access & Reporting Tools in BI Technology

Explore the convergence of web and DW/BI technology facilitated by open environments. Learn about Thin Client computing, SQL, ODBC, and more. Discover how WebFocus powers interactive reporting tools.

eghent
Download Presentation

Web-Based Data Access & Reporting Tools in BI Technology

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. The Multidimensional Model & OLAP (IV) Developed by: Dr Eddie Ip Modified by : Dr Arif Ansari

  2. 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

  3. 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

  4. 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)

  5. 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

  6. 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

  7. middleware Web client API , CGI Application server Html, javascript java ODBC (window) JDBC (java) DB Server SQL

  8. DB Queries • Queries : content rich, IT-oriented • Reports : format rich, business-oriented • Static versus Interactive

  9. 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

  10. Features of reporting tools • SQL-based & OLAP-based • Friendly user interface • Format rich • Often web-enabled • Interactive reporting : get most current results from database

  11. Summary • Web-based Data Access • Data Base Queries • Features of reporting tools

  12. 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

More Related