Information Builders : SmartMart

1. Information Builders : SmartMart Seon-Min Rhee (blue@ewha.ac.kr) Visualization & Simulation Lab Dept. of Computer Science & Engineering Ewha Womans University 2000.3.27 http://www.ibi.com

2. Contents SmartMart Copy Manager SmartModler Focus Fusion WebFocus Meta Directory Resource Analyzer Resource Governor

3. SmartMart A Complete, Fully Integrated Data Warehousing Suite Access Legacy and Packaged Applications Easiest-Ever Database Creation Powerful Web and Client/Server Reporting Environments Ensuring Warehouse Effectiveness Manage and Publish Metadata With Ease Outstanding Performance, Maximum Network Efficiency Automatic Report Distribution With Electronic "Bursting" Prevent Runaway Queries High-Speed Analytical Capabilities Other SmartMart Advantages Complete Scalability Service From 85 Offices Worldwide Choose From Three SmartMart Packages

4. SmartMart Copy Manager Smart Modeler Focus Fusion WebFocus Report Broker WebFocusManaged Reporting WebFocus Resource Governor Resource Analyzer Meta Directory

5. Smart Modeler Data Modeling tool for developing and maintaining high-quality, enterprise-strength data model. Supports all major relational databases as well as SmartMart Fusion

6. Copy Manager Extracts, Transforms, Load Data into a Data Mart Automated scheduling, bulk loads access to remote RPCs, and scalable to over 70 different databases and file systems

7. Copy Manager

8. Copy Manager Step2 Step1 -.End-to-End Automation Source Tool : creates SQL queries Target Tool : specify the target database to be loaded

9. Copy Manager Step4 Step3 -.End-to-End Automation Scheduler tool :letting you specify when the ETL process will run Transforms tool :defines rules for data cleansing

10. Focus Fusion Fusion High-Performance Database Multi-dimensional indexing delivers exceptional performance and is fully tunable Intelligent partitioning stores multiple periods of data in one volume for fast analysis Powerful enterprise solution for data analysis, warehousing, and modeling 500GB database capacity accommodates large volumes Accesses virtually all enterprise data via EDA middleware Available for Windows NT™, UNIX, and OS/390 VM and MVS Options for Web reporting using Java and ActiveX thin clients

11. Focus Fusion WebFocus Legacy Focus Fusion Administration Focus Fusion/DB Server Relational Parlay Fusion Database EDA client EDA JDBC Extender ERP Focus/EIS Source Data Dynamic ad hoc and managed reporting Graphical administration and management Java application Integration Server Open Client access via ANSI SQL,ODBC,JDBC and EDA API/SQL • Multidimensional database services • Transparent drill-through to operational data • Matadat management Integrated EIS, reporting and DSS package

12. Web Focus Decision support system combininb thin-client reporting and analysis, managed reporting, OLAT, and report distribution in one package • Web Focus Managed Reporting • A controller decision support environment with ad hoc • reporting and OLAP functionality • Web Focus Reporting Broker • A comprehensive report scheduling and distribution engine • for the Web, e-mail, or any network

13. Meta Directory Traditional Model : each tool manages its own metadata SmartMart Meta Directory Model : Enabled tools share their metadata via the SmartMart Meta Directory repository

14. Meta Directory SmartMart Meta Directory provides Support for repositories from multiple vendors Views of metadata in familiar business terms that users can understand Access to qualitative information about the available data ? its currency, when it was loaded, and any errors encountered during the load process Documentation on the purpose and format of available reports and queries A dynamic connection to warehouse management tools to keep metadata synchronized with the warehouse when the warehouse structure changes Versioning support An easy-to-use GUI for searching, editing, managing, and using the metadata stored in the repository Web browser access for searching and browsing available information

15. Meta Directory SmartMart Meta Directory Metadata Management System ( 5 component ) SmartMart Meta Directory Server : A repository-independent management system Meta Directory Repository: A repository-specific interface providing functional translation and interoperability between SmartMart Meta Directory and the underlying repository DriverInformation Delivery Agent (IDA) : To capture metadata dynamically, the IDA provides a communications link to the repository from SmartMart sergers.

16. Meta Directory SmartMart Meta Directory Metadata Management System (5 component - cond’) Administration Portal :Provides a single point of entry for the navigation, representation,understanding of, and access to, the repository and the information objects it describes The Administration Portal is modeled on the familiar Web search engine interface

17. Meta Directory SmartMart Meta Directory Metadata Management System (5 component - cond’) Administrator : Provides a single entry for the mantenance of the repository, including management of ccess capabilities, maintenance of security, and editing of metadata.

18. Resource Analyzer Monitoring Usage Helps Optimize Web Application Performance

19. Resource Governor Intelligent Query Governing Services for the Enterprise Preemptive Governing Saves Time and Money Automatically Adapts to Changing Usage Patterns Query Management Controls Provide Complete Flexibility