SAP IQ: Difference between revisions
formatting punctuation |
→Features: add description of IQ offering with Microstrategy BI |
||
| Line 10: | Line 10: | ||
Since databases with limited [[domain]]s (e.g., one that contains state names like VA, MD, WV, NJ, etc.) and high row counts are incidentally [[Data compression|compressed]] by storage in column form (as only one example of each value in the domain is stored), those types of databases can be stored using less space than those employing more traditional row storage. Sybase claimed that in the case of the BMMSoft data warehouse, their one [[petabyte]] of raw transactional data (or 500 [[terabyte]]s of transactional and 72 terabytes of [[multimedia]]) was represented using only 260 terabytes of storage. |
Since databases with limited [[domain]]s (e.g., one that contains state names like VA, MD, WV, NJ, etc.) and high row counts are incidentally [[Data compression|compressed]] by storage in column form (as only one example of each value in the domain is stored), those types of databases can be stored using less space than those employing more traditional row storage. Sybase claimed that in the case of the BMMSoft data warehouse, their one [[petabyte]] of raw transactional data (or 500 [[terabyte]]s of transactional and 72 terabytes of [[multimedia]]) was represented using only 260 terabytes of storage. |
||
Sybase also has implementations for [[business intelligence]] through a package offering of the Sybase IQ analytics server. In 2009, Sybase announced their package offering of Sybase IQ with [[MicroStrategy]]'s business intelligence (BI) software. The [[International Data Corporation|IDC]] has noted that Sybase's close partnership with MicroStrategy allows Sybase to expand its BI services and support. Dan Vesset, vice president of business analytics at the IDC, has stated, "business intelligence and [[data warehousing]] offerings are expected to take on an increasing value in the present economic environment."<ref>{{cite web |url=http://reseller.co.nz/reseller.nsf/news/114680025FD536DCCC2575B5000E78E7 |title=Sybase touts MicroStrategy BI offerings |date=13 May 2009 |work=Reseller News }}</ref> Sybase [[Chief marketing officer|CMO]] Dr. Raj Nathan has expressed that this continued collaboration between the two companies will drive down deployment costs of [[Report|reporting]] and [[analytics]] solutions for their [[enterprise software]] customers.<ref>{{cite press release |url=http://www.sybase.com/detail?id=1063281 |title=Sybase and MicroStrategy Team Up to Dramatically Reduce Time for Implementation of Business Analytics |publisher=Sybase |date=MAY 12, 2009}}</ref> |
|||
==Operating System Compatibility== |
==Operating System Compatibility== |
||
Revision as of 14:55, 3 November 2010
Sybase IQ is a relational database software system used for business intelligence and data warehousing, produced by Sybase.
Features
As a column-oriented DBMS, Sybase IQ stores data tables as sections of columns of data rather than as rows of data. This has a number of advantages; if a search is being done for items matching a particular value in a column of data, only the storage objects corresponding to that data column within the table need to be accessed. A traditional row-based database would have to read the whole table top to bottom.
Additionally, the column-based storage enables IQ to compress data efficiently on the fly; as each column is made up of a number of records of the same data type and size, compression can be very efficient and rapid. [1]
In July 2007, at Sun Microsystems' request, InfoSizing verified the population and performance[2] of the world's largest data warehouse implemented in history; consisting of over one petabyte (1,000 terabytes) of structured and unstructured data, designed and implemented by BMMSoft using Solaris 10 OS and Sybase IQ. Sun Microsystems and Sybase claim that the system architecture used in this benchmark is highly efficient, yielding a reduction in equipment and processing needed and thus a reduction in energy consumption[3][4].
Since databases with limited domains (e.g., one that contains state names like VA, MD, WV, NJ, etc.) and high row counts are incidentally compressed by storage in column form (as only one example of each value in the domain is stored), those types of databases can be stored using less space than those employing more traditional row storage. Sybase claimed that in the case of the BMMSoft data warehouse, their one petabyte of raw transactional data (or 500 terabytes of transactional and 72 terabytes of multimedia) was represented using only 260 terabytes of storage.
Sybase also has implementations for business intelligence through a package offering of the Sybase IQ analytics server. In 2009, Sybase announced their package offering of Sybase IQ with MicroStrategy's business intelligence (BI) software. The IDC has noted that Sybase's close partnership with MicroStrategy allows Sybase to expand its BI services and support. Dan Vesset, vice president of business analytics at the IDC, has stated, "business intelligence and data warehousing offerings are expected to take on an increasing value in the present economic environment."[5] Sybase CMO Dr. Raj Nathan has expressed that this continued collaboration between the two companies will drive down deployment costs of reporting and analytics solutions for their enterprise software customers.[6]
Operating System Compatibility
Sybase IQ has been certified on:
- Sun Solaris 64 bit
- Red Hat Linux 64/32 bit
- SuSE Linux 64/32 bit
- HP-UX 64 bit
- HP-UX Itanium 64 bit
- IBM-AIX 64 bit
- Windows 64/32 bit
Customers
Sybase IQ currently has over 1,700 customers and more than 3,100 installations worldwide. Sybase IQ is supporting thousands of users concurrently in analytics and data warehousing environments.
Criticisms
Sybase IQ is optimized for data warehouse type applications, where data is added to databases but typically not modified much if at all, and the typical access is to search through the data. The column based storage which enables good performance for reading through data somewhat slows down writing data (instead of just the last data object requiring updating with a row object, one data object per table column must be updated). Large volume data imports can still be reasonably efficient.
Prior to version 15, Sybase IQ didn’t have automatic queues for requests of changing its objects, like other RDBMSes (SQL Server, Oracle, ASE, ASA, MYSQL, DB2, etc) do. Therefore, a DDL/DML statement may return an error if the target object is in use. Sybase IQ provides explicit lock table statement support that will allow behavior similar to traditional RDBMS, although the locking scheme is less granular.[7] Since version 15, this behavior is configurable. A DDL/DML operation can wait until other active operations on the same object are complete.
External links
References
- ^ http://www.sybase.com/content/1035804/SybaseIQ-12.7-010407-wp.pdf accessed September 11, 2007
- ^ http://www.sun.com/service/refarch/datawarehouse/Ready-Time-Report_R1.2.pdf | Sun-Sybase-BMSoft solution Auditing
- ^ http://www.sybase.com/detail?id=1054047 | Sybase IQ Powers World's Largest Green Data Warehouse Including Unstructured Data
- ^ http://www.sun.com/service/refarch/datawarehouse/WLDWSolutionBrief.pdf | World's Largest Data Warehouse Solution Brief
- ^ "Sybase touts MicroStrategy BI offerings". Reseller News. 13 May 2009.
- ^ "Sybase and MicroStrategy Team Up to Dramatically Reduce Time for Implementation of Business Analytics" (Press release). Sybase. MAY 12, 2009.
{{cite press release}}: Check date values in:|date=(help) - ^ http://www.sybase.com/detail?id=1056545