The Sun / Sybase iForce Solution forEconomical Data Management
Are you…. A Data Intense Small or Mid-market Business? • Process Server • Claims Processing • Medical Records • Bank Transactions • Insurance Processing • Business Processor • APSs for ERP, CRM, SCM • New add-on service • Data Services • Internet Transaction Management • Data Analysis Vendors • Application Provider • JD Edwards, SAP, Siebel, etc. • All “running to mid-market” • AS/400 Market • A lot of data – Retail, Manufacturing, Insurance • Value buyers • Digital Legacy Market • VMS & True Unix
Are you…... Small now, but Planning to grow? Data intensive? Hitting the wall already?
Introducing iForce Solution for Economical Data Management Enterprise strength at PC Prices Exclusively for small-mid range enterprises that are ready to take off!
From Sun and Sybase, who have already changed the Gamein large scale data management • Enterprise Data Warehouse Reference Architecture • Jointly Designed, Integrated, Tested, and Tuned Blueprint for VLDW • Dramatically Lowers Total Cost of Ownership • Delivers Performance, Scalability, Availability, and Flexibility • Sun iForce Ready Centers • Deliver Proof of the Promise of Efficient VLDW
Economical Data Management Powerful data management at 1/5 cost Simple - easy to manage, NO tuning needed Easily off-load transaction while leveraging data for analysis NOW -- Delivering Performance & Scalability to Small to Medium Sized Customers Business Issues Difficult to manage or analyze large amounts of data Complicated - extensive training and tuning As data stores grow, performance drops. Data Warehousing is complex and out of range of most small to mid-market customers. iForce Solution for Economical Data Management
Our promise is to help you... • LEVERAGE INFORMATION TO QUICKLY UNDERSTAND BUSINESS OPPORTUNITIES • Quickly get information into an industrial strength server • Delivers information 10 to 100, even 1000 times faster than traditional means • Supports sophisticated business queries by large numbers of users • MANAGE VALUABLE ENTERPRISE DATA AT PC PRICES • High performance, highly scalable data repository that is cost effective • Manage 100s of gigabytes to terabytes of information at a reasonable price • ENJOY A SIMPLE, MANAGEABLE ENVIRONMENT • IQ Multiplex bases on iAnywhere SQL • Learn in days versus weeks • Little or no tuning needed • Transactions only – few aggregates needed • BENEFIT FROM INVESTMENT PROTECTION OF CURRENT TECHNOLOGY • Leverage Microsoft technologies • Leverage current applications for ERP, CRM & SCM • Scaleability to the Enterprise when you are ready C U S T O M E R S U C C E S S Enterprise Strength at PC Prices
ERP Reporting Analysis OLAP Disaster Recovery Real Time Archiving How it works Operational Sources Users Extract, Transform and Load, BCP, FTP, etc CRM iForce Solution For Economical Data Management SCM 3rd party Other Transparent Archiving
Leveraging V480 and V880 • V480 Capabilities • Premier rack server at PC price point • Up to four 900 MHz UltraSPARC III • Sun Fireplace Interconnect • High-end RAS features • Remote System Control (RSC) • V880 Capabilities • Sun Fire tower server at PC price point • Up to eight 900 MHz UltraSPARC III • High-performance, fibre- Channel disk subsystem • 876GB disk capacity • Hot swappable components • High system availability • High-end RAS features • Remote System Control (RSC)
The Sybase IQ Multiplex Database Engine Designed to meet these goals … • Load Data Fast • Query Very Fast • Store Data Efficiently • Work with Common OLAP and ETL tools
Sybase IQ Multiplex – What’s Different? • Data is Stored Vertically • Tables are Logical, Not Physical • Permits Compression on Disk Optimized Column Stores • Based upon Cardinality and How Column is Used in Queries(Column Stores are the “Indexes”) Query Engine Retrieves Only Columns Used in the Query • Reduces System I/O Dramatically • Permits Better Data Manipulation
Small • V480 • 2 CPUs @ 900MHz • 4 GB Memory • 2 internal 36GB – 72 GB • IQ Multiplex • Target price soon Large • V480 • 4 CPUs @ 900MHz • 16 GB Memory • 2 internal 36GB – 72 GB • 1 T3 bundle – 1.6 TB • IQ Multiplex • Target price soon Medium • V480 • 2 CPUs @ 900MHz • 4 GB Memory • 2 internal 36GB – 72 GB • 1 T3 bundle – 1.6 TB • IQ Multiplex • Target price soon Ex Large • V880 • 8 CPUs @ 900MHz • 16 GB Memory • 2 internal 36GB – 72 GB • 1 T3 bundle – 1.6 TB • IQ Multiplex • Target price soon Enterprise Strength at PC Prices
BizRate gains Economical Data Management with Sun and Sybase Business Issues • Delivers analysis of internet utilization • Leading online customer survey producer • Cost and logistics becoming unwieldy • Microsoft SQL Server could not scale • Simplify data deliver and analysis for sellers Business Results • Sun / Sybase delivered Sun Fire V880 • Manage 15 million customer data sets • Tight integration through Reference Architecture • Scaleable solution that will grow Together, Sun and Sybase have created a solution that packs an extraordinary amount of data processing and analytical power into a small footprint that represents a realistic investment for small and mid-sized firms. Sybase’s tight architectural integration with Sun technology provides us with the assurance we need that the technology foundation of our data warehouse will scale to meet our growing needs in the future. Henri Asseily, Chief Technology Officer and Founder of BizRate.com
Nielsen Media Research gains VLDB with Sun and Sybase E-business Issues • Leader in TV ratings business • 5 to 10 years of TV viewer history • Cost and logistics becoming costly • Need same data on multiple databases to scale • Difficult to deliver new services to customers Business Results • Sun / Sybase delivered Reference Architecture • 35 terabyte best practices guide • Fast access and data load • Linear Scalability to 108 CPUs • Architected for 100s of TB on Hitachi SNA “The big advantage of the Sun Sybase Reference Architecture is that it provides the advance knowledge that this solution will work.” “We are able to deliver one data warehouse for all our applications, at one-third the storage of conventional technologies, while seeing performance gains as advertised with IQ Multiplex.” Kim Ross, CIO, Nielsen Media Research
iForce Solution for Economical Data Management Enterprise strength at PC Prices when you’re ready to take off!
Appendix Slides iForce Solution forEconomical Data Management
iForce Solution for Economical Data Management • Powerful Transaction Data Store • Offload transactions from MS SQL Server • Improve performance of operations • Source for data warehouses and data marts • Complete Analysis Store • Basic analysis without a lot of effort • Leverage transaction data with Microsoft analysis tools • 3rd Party tools – Business Objects, Cognos, ProClarity • Historical and near real-time information • Analysis 10 to 100, even 1000 times faster than MS SQL Server • Enable Sophisticated Data Warehouse or Mart • Store data for sophisticated market, sales, financial and operations analysis • Any schema, any query, any tool, any amount of data • Prudent Investment Protection of Microsoft technology • Operational Apps for ERP, CRM, SCM, Manufacturing • Analysis Services for multidimensional analysis • Data Transformation Services for data extracts and loads • Microsoft Data Analyzer for quick reports • The SQL Server 2000 for OLTP systems • Real Time Archiving • Maintain years of transaction history automatically and economically • Quick retrieval of information without no additional effort • Compress data by 50% • Cheaper and easier than tape • Indefinite data life • Simple Disaster Recovery • Keep your transactions safe • Fast backup and restore without impact on operations