BI503 Enabling a New World Market: Business Intelligence on the Web

1. BI503Enabling a New World Market:Business Intelligenceon the Web • Frank Teklitz • Senior Group Product Manager • Sybase, Inc. • teklitz@sybase.com

2. Business Intelligence Overview IQ-M Applications and Success Competitive Overview Agenda

3. Sybase Business Intelligence Strategy Move from infrastructure to applications “Industry” Warehouse Studios End User Applications Applications Business Intelligence Solutions Information Content Database Designs Data Acquisition Warehouse Studio Data Warehouse Infrastructure Database Platform Adaptive Server IQ major RDBMS’S

4. Data Warehousing Software Market In the Year 2001 - $17.1 Billion Business Intelligence Tools DBMS • Query & Reporting • OLAP • Data Mining • Data Visualization • Data Warehouse • Data Mart Business Intelligence Tools $4.6 Billion DBMS $6.7 Billion z Vertical Applications $2.5 Billion Vertical Applications DW Management Software DW Mgmt Software $3.3 Billion • Government • Retail • Insurance • Telecom • Banking/Security • Data Acquisition • Data Transformation • Data Quality • Data Replication Source: Palo Alto Management Group

5. Data Warehousing Meets the Web Top Issue for 2000: Executives make plans to analyze and manage e-business in 2000 Data Warehousing and the Web driving business in 2000 Web’s 7 by 24 needs also driving High Availability expectations Will you be ready for the opportunities and challenges of data warehousing meeting the Web? Information Week Research Priorities of 250 IT Executives

6. High Performance • Lightning Fast Ad-hoc Access • Fast Load & Backup • Unlimited Maneuverability • Any Query - any Time • Ad-Hoc - Any Schema • Any Number of Nodes • Simple Maintenance • Easy to Learn • Data Compression • Versus Data Explosion • Great Economics • Little Tuning Needed • Data & User Scalability • Linear User Scalability 10s to 100s to 1,000s of Users • From Gigabytes to Terabytes of data The Solution:Adaptive Server IQ12 with MultiplexOptimized Analytic DSS

7. Business Intelligence Overview IQ-M Applications and Success Competitive Overview Agenda

8. Market Overview Data Warehouse for Customer Personalization VLDB 2001 & 10? Web-enabled Data Warehousing Entrepreneurial Data Warehousing 2nd Generation Business Analysis Traditional Data Warehousing 2000 & 02 80s & 90s

9. AS/IQ - Multiplex Key Application Areas

10. Need Closed-Loop Analysis Capabilities Fast Results for Decision Making Information Sharing Analyze more and more data Benefit Closer communications Better Understanding of Customer needs Stronger Customer Loyalty New customer growth Sybase Successes Bank of Montreal ATT Banque International a Luxembourg KeySpan Energy Market Market Customer Customer Segmentation Segmentation Analysis Analysis One-to-one One-to-one Marketing Marketing Event Event Modeling Modeling Business Intelligence Dynamic Business Analysis

11. Sybase Market Leadership in Data Warehousing with IQ-M Adaptive Server IQ Customer Sites 1200 1000 800 Far East Europe 600 North Amer 400 200 0 1995 2Q96 4Q96 2Q97 4Q97 2Q98 4Q98 2Q99 Q499

12. CITIBANK Adaptive Server IQ (Simplex)(TM) Sampling Of Customers National Semiconductors • AT&T • America Online, Inc. • Anchor Computer • AIG • Bank of New York • Bank of Montreal • Bear Stearns • Bell Atlantic • Boston Chicken • CS First Boston • Chase Manhattan Bank • Citibank • CodeBank, Inc. • E.M. Warburg, Pincus & Co., Inc. • Excel Telecommunications • Fleet Financial Services • Fox Broadcasting, Co. • GE Capital • Goldman Sachs • Group Health Cooperative of Puget Sound • Hilton Hotels Corporation • Hughes Aircraft • Indiana University • Intellect Technologies • Internal Revenue Service • JP Morgan & Co., Inc. • Johns Hopkins University • Kaiser Permanente • Matthew Bender Co., Inc. • MCI • Merril Lynch • Metropolitan Life Insurance Co. • National Securities Clearing Corp. • National Semiconductor Corp • NationsBank • Network General Corp. • Niagara Mohawk Power Corp • Paine Webber • Prudential • Public Service Company of Colorado • ReliaStar Financial Corp. • Republic Mortgage Insurance Corp. • Reynolds & Reynolds • Royal Insurance PLC • Salomon Bros. • Schering-Plough Corp. • Scudder Stevens & Clark • Societe Generale • Space Telescope Science Institute • State of New York • Statistics Canada • Teleport Communications • Texaco Ltd. • U.S. West • Union Electric • United Prov. • University of California • Universal City Studios, Inc. AIG IRS GE Capital AT&T

13. 10101010101010111101010101010 10101010101010011101010101010 01010101010101111010101010100 10101010101011010101010101001 10101010101010110101010101001 00101010101000110101010101000 10101010101111010101010000100 10101010100000010101010100101 00101010100011010101010000100 10001010100011010101010100101 10001010100011010101010100101 00101010010001101010101000010 10101010010001101010101000010 11101010010000101010101000010 00101010010000101010101000010 00111010010000100010101000010 01101010011100101010101000010 11101010011100101010101000010 01111010011100101010101000010 01011010010100111010101000010 01011010010100111010101000010 Exclusive Tuning Free Bit-Wise Indexes designed for Data Warehousing Bytes in a Row Bits in a Column IQ - Multiplex indexes quickly zips through bits in a column Competitionhas to chug through every byte in a row - Clogging I/O channels, memory, and disk 1 0 1 0 1 0 0 1 0 1 0 1 0 0 1 0 1 0 0 1 0 0 1 0 1 0 1 0 1 0 0 1 1 0 1 0 1 0 0 1 0 1 0 1 0 0 1 0 0 1 0 1 1 0 1 0 1 0 0 1 0 1 0 1 0 1 0 1 0 0 1 0 1 1 0 1 0 1 0 0 1 0 1 0 1 0 1 0 0 1 0 1 0 1 0 1 0 0 1 0 1 0 1 0 0 1 0 0 0 1 0 1 0 1 0

14. Business Issues Identify and retain most profitable customers Increase effectiveness of marketing programs Attract new customers Access to multiple information systems and “touch points” Cutting edge technology and architecture Business Results IRR over 100% Average Credit Card volume up 59% Average Credit Card balances up 129% Market Share up 60 basis points System up in 4 months Component architecture enables flexibility 250 GB Data Warehouse Bank of Montreal Grows Profits with Sybase “We felt you should develop the data warehouse component by component because that allows you to apply what you learn.” “Sybase was truly committed to ensuring that we used technology in a way that really impacted the business.” Carl A. Touchie Sr. Manager Electronic Financial Services Bank of Montreal

15. Need New way to deliver data and application e-services to your value chain of customers, suppliers, partners and business analysts Improve Customer Service Enable Customer Self-Service via Web Performance, Reliability, Availability, Security Benefit Internet enabled productivity Zero cost deployment Stronger Customer Loyalty Lower Customer Service Costs Sybase Customers Polk Marketing PHH Vehicle Managemet MovieFone Web Portals Web-enables Data Warehousing

16. With low unemployment, productivity is key to business growth without inflation - companies must do more with less Companies today are investing in technology solutions (hardware, software and services) to get the most productivity from their value chain of labor, management, suppliers, distributors and partners Thanks to the efficiencies of the Internet, productivity growth has been dramatic in 1999 - this will continue in 2000 A key area for increasing productivity in 2000 is Web-enabled Data Warehouse Economic Drivers for Web-enabled Data Warehousing Will your current Data Warehouse be able to handle the Internet?

17. IQ with Multiplex 98% Scalability Node Utilization Parallel Databases # Nodes 50 to 60% Scalability 99+% Scalability for IQ with Multiplex To Web-enable your data warehouse you need linear user scalability to effectively support the 100s and 1000s of Internet users Only IQ with Multiplex can offer the linear user scalability needed to support Web-enabled Data Warehousing

18. Business Issues E-business based on extremely reliable, high performance, scalable, user-friendly and cost-effective database technology Serve up, monitor and analyze market data for rapidly grow business Customers need access information via Web Business Results Attract new customers with services 100% uptime Web-based reporting available in near real time Competitive advantage in market place Polk Marketing Delivers on the Web Polk Marketing “Everything we’re been able to do to make our systems attractive to customers has been done with Sybase.” “Thanks to Sybase, our business is growing rapidly, and we’re quickly approaching new milestones.” Dominic Clair Software Development Polk Marketing

19. Need Query performance Flexible data access Large number of users Ease of maintenance Benefit See the entire business - global view Better understanding of product / market relationships lever large volumes of clickstream data generated by web Sybase Success IRS Bank of Montreal American Airlines High Performance VLDB “It doesn’t take long to accumulate a terabyte of clickstream data” Richard Winter Leading VLDB Analyst

20. 5 to 10 Times the Cost of IQ-M Exclusive Data Compression vs. Data Explosion You Save$500K to $1Million per 1 TB Raw Data

21. “The primary technology challenge was to build a system that could manage such large volumes of dataand yet was sufficiently open to facilitate queries from various off-the-shelf products. We selected Sybase AS/IQ as the data-management server, based on its strength with decision support type queries.” Jeff Kmonk Manager, Office of Research Compliance Research Division Internal Revenue Service Internal Revenue Service ManagesVLDB for Large Numbers of Ad-hoc Users • Business Issues • Analysis virtually impossible • Lost productivity • Loss of potential billions in revenue • VLDB management • Results • Modeled entire population of commercial tax returns • Supports advanced analysis like data mining • Revenue protection & fraud detection • ROI of $250 Million • 1.1 Tb Raw data • Compressed to 650 Gb • 120 ad-hoc analysis users

22. Need Survive with limited resources Low Budget - NT & Linux Limited Training Limited Time - Midnight Project Need Enterprise Capabilities - Availability, Reliability, Functionality Benefit Start Small, Grow big - Fast Seamless Scalability Economical End-to-end performance Connectivity Sybase Successes MovieFone Polk Marketing / CompuSearch Entrepreneurial Data Warehousing

23. SUN/ HP / IBM / NCR,Oracle / IBM / InformixData Warehouse IQ with Multiplex Delivers Real Price Performance on NT Compaq / Dell / GatewayIQ Multiplex NT Data Warehouse 3 to 9 Times Price Performance Advantage Scalability Availability Security $ 100s of Thousands of Dollars $ 3 to 10 Million Dollars

24. Business Issues Make Information more easily available Deliver a new information service Manage large amounts of data(70 million calls per year) Must support NT technology and budget Must be low maintenance Business Results New source of revenue Dramatic increase in marketing capabilities Fast, flexible analysis on NT System developed quickly Data compression cuts costs Beyond weekly loads, system is maintenance free MovieFone Gets Economical Results MovieFone “Because of the complex nature of their inquiries and the sheer amount of the data involved, we were convinced that Sybase IQ was the ideal solution. Sybase IQ is an excellent tool when companies are doing queries and trying to return counts.” Glen Peipert Senior VP CSI Consulting, Inc.

25. Need Uncompromising Performance Large Numbers of Users Large Amounts of Data Brains behind Portal Benefit Leverage the Data Warehouse to personalize the Web Experience Sybase Successes Sybase Enterprise Solutions Division Front Office Back Office Data Warehouse Customer Personalization Engine Enterprise Portals “In fact, it may be critical to reconfigure the “e-store” the customer is visiting based on information that can be pieced together from something the customer did a moment ago, combined with something he or she did at the site last month or last year.” Richard Winter, Leading VLDB Analyst

26. Front Office Warehouse Information Data Wireless Telephony Transformed Back Office Feedback Back Office Front Office Convergence Enterprise Portal Real Time Knowledge With the Convergence of Devices Personalization must be integrated across ALL Devices Enterprise Portals Require Personalized Dynamic Data Access and Integration Warehouse Enterprise Portal Information Interactive TV Data PDA & Pagers Traditional Data Warehousing: Transformation is a Wall between Business Operations and Analysis

27. E-business Issues Need for personalized Internet experience Personalization a competitive advantage Enterprise data and e-application integration “Hodge-Podge” of Client/Server systems Host high-volume / high-availability Bottem Line: Stay close to customer Business Results One-to-one relationships Clear competitive advantage Leverage corporate information assets Pre-build components for business management Takes advantage of AS/IQ’s industry leading engine Sybase EP - an e-business leader “Enterprise Portals clearly will make quite an impact on the Internet industry by creating a compelling new vision of corporate computing.” Summit Strategies “Of the software vendors that have thus far announced product plans for EP - Sybase’s strategy and product set are by far the most comprehensive.” Phil Russom, Director Hurwitz Group

28. Need New Application Paradigm Fan out “swarms” of 100s and 1,000s of queries Build dynamic new analysis capabilities Support new schema configurations Benefit Enables analysis of 100s and 1000s of pieces of data Incredible analytical flexibility Empower powerful personalization IQ delivers high volume, low maintenance solution IQ supports advanced schema designs Second Generation Business Analysis Fan Out Extension enables users and applications to deliver “swarms” of queries and quickly obtain results for analysis and customer personalization

29. E-business Issues One of the largest Entertainment Centers in the world Customer Loyalty database has hundreds of thousands of members 2,500 Slot Machines and 320 Gaming Tables Difficult to determine utilization and profitability of hotel’s gaming facilities Business Results Visualize performance of individual machines, banks of machines or entire complex Visualize relationship between customers and hotel by geographies, demographics and life style characteristics See trends for last 10 minutes, hours, days or weeks Huge improvement in revenue generation from property Could not perform this analysis without IQ-M Crown Entertainment gains new analytical capabilities with IQ A WORLD OF ENTERTAINMENT “Compudigm is delivering an entirely new way to see our business. Our marketing managers can now easily see revenue trends on the casino floor as well as across the entire business - world wide. This kind of analysis was impossible before Compudigm.” Jerry Reed Crown Entertainment Compudigm International

30. E-business Issues Needed a database that could handle the volume and density of queries generated by their industry leading visualization tools Oracle 8i and Microsoft SQL Server broke under the load of the visualization application Needed database that could handle flexibility of “flat schema” models - star schema was too slow and inflexible Business Results Compudigm’s visualization tools are delivering the performance their customers need thanks to IQ-M IQ-M’s data compression, data load and column based Bit-wise indexes enable revolutionary “flat schema” support With IQ-M Compudigm can deliver new ways for businesses to see trends and analyze performance Compudigm - Leadership in Business Intelligence Compudigm International “Only IQ-M could handle the volume and density of queries needed to support our business visualization application. All other relational databases we tested broke under the load.” Andrew Cardno, Managing Director Compudigm International

31. BI Tool FOX Enabled Environment Query Result New Application Development Paradigm - FOX (Fan Out Extension) capabilities With Fan Out Extension: Today: One User One Question One Answer One Portal One Customer Personalization One User Many Questions Many Answers Only IQ - Multiplex can unleash the flexibility and functionality needed to enable a new generation of analysis and personalization Swarms of Questions Swarms of Answers SUN/ HP / IBM / NCR,Oracle / IBM / InformixData Warehouse Compaq / Dell / GatewayIQ Multiplex NT Data Warehouse

32. Business Intelligence Overview IQ-M Applications and Success Competitive Overview Agenda

33. Adaptive Server IQ with Multiplex Exclusive Value Benefits for Web-enabled Data Warehouse “Vertical” data organization • High Performance Ad-hoc Access • Start Small, grow to VLDB • Data Compression versus Data Explosion • Linear User Scalability • Linear Query Scalability • Minimal Administration • UNIX and NT together Index everything Patented Bit Wise indexing Design for end user Column Oriented Multiplexing

34. Sybase IQ with Multiplex vs Competition

35. PLATFORM Sun Solaris Compaq / Digital True UNIX HP - UX IBM AIX (Simplex) SGI (Simplex)Multiplex - Q2,2000 NT Platform Environments for IQ - Multiplex 12 TOOLS Business Objects Cognos Brio Micro Strategy English Wizard Whitelight SAS Group 1 MineSet (SGI)

36. Customer Success Compudigm

37. Enabling a New World Market: Business Intelligence on the Web