1 / 12

Sybase IQ

Sybase IQ. By: Nathan Bazyk , Casey Jo Burnett, Giezi Nunez. What is Sybase IQ ?. Sybase IQ is an optimized analytic server designed to deliver faster results. What does it do? It allows a business to search information in their data warehouse faster. How is it better?

uriah-hale
Télécharger la présentation

Sybase IQ

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. Sybase IQ By: Nathan Bazyk, Casey Jo Burnett, Giezi Nunez

  2. What is Sybase IQ ? • Sybase IQ is an optimized analytic server designed to deliver faster results. • What does it do? • It allows a business to search information in their data warehouse faster. • How is it better? • It can answer queries, create reports and search a database much faster than a traditional row based data storage especially with large amounts of data. • Reduces wait time from 20 min to a few sec or a min at the most.

  3. How Sybase IQ Started? • The program was developed by Sybase Incorporated team on Sun Microsystems hardware. • It took 10 years of engineering, specializing queries, etc. • Currently, it has 100 patents, 9 unique indexes and 6 different table joins • It already has 1500 clients

  4. Sybase IQ Target Market • Data Aggregators • Business with unpredictable queries • Business with centralized warehouses

  5. Functionality of Sybase IQ • How does it work? • Columns vs. Rows • Compresses size of database • 1 petabyte(1,000 Terabytes) of structured and Unstructured data. • Importance: • Large amounts of info take forever to access. Ideal for all business where speed is a necessity. (Finances/Stock Market) • Criticism: • Slows down writing data • Instead of just the last data object requiring updating one date object per data column must be updated.

  6. Row Based Data Most recent Data was input at the end. When running queries, the entire table would be searched in order to provide accurate results. Column Based Data While the process increases the amount of time required to insert data it makes up for it in query results. Update information in column rather than at the end of the data. Column Based vs. Row Based Data

  7. Entry Examples • Row Based Entry • 1, Smith, John, Accounting,45000; 2, Jones, Ann, Finance, 50000; 3, Brown, Joe, Marketing, 40000 • Column Based Entry • 1,2,3;Smith, John, Jones, Ann, Brown, Joe; Accounting, Finance, Marketing; 45000, 50000, 40000

  8. Benefits of Sybase IQ • It gives a competitive advantage to the business: • By reducing up to 90% of storage cost. • Through High Performance • Easy to use, so it don’t require any outside training. • It helps businesses analyze customer profitability, market penetration, and sales effectiveness.

  9. Sybase IQ Recognitions • Guinness Book of World Records • largest data warehouse at one petabyte • Infosizing Report: • Latest Top Ten Program • Leading Industry on the best price performance.

  10. Sybase IQ Users • Acxiom Corporation • US Department of Transportation • Shopzilla (www.shopzilla.com) • LG Card • Internal Revenue System (IRS) • American Airlines

  11. Sybase IQ Competitors • Competition: • Teredata: IQ’s primary competitor • Vertica: IQ’s leading column based competitors

  12. Conclusion • Useful, faster, and cheaper alternative to traditional methodology. • It gives competitive advantage to the business through higher performance • It’s a practical solution to excess amounts of information that take forever to access or interpret.

More Related