Sybase IQ

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
Column Based vs. Row Based Data

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

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

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,3Smith, 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 dont 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 IQs primary competitor
• Vertica IQs leading column based competitors

12
Conclusion

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