Actian Corp. (“Actian”), empresa líder en gestión de grandes volúmenes de datos de próxima generación y creadora del récord más innovador, la base de datos analítica Vectorwise, ha anunciado hoy la consecución de la operación para adquirir Versant Corporation(Nasdaq:VSNT), líder en el sector de la gestión de datos especializados. La combinación de la experiencia de Versant en soluciones para grandes datos de empresas contribuye al fortalecimiento de la oferta de análisis de grandes datos de Actian y amplía sus capacidades adentrándose en los mercados emergentes.
Ingres just published a TPC-H benchmark for VectorWise, an analytic database technology employing 1) SIMD processing (Intel SSE 4.2), 2) better memory optimizations to leverage on-chip cache, 3) compression, 4) Column-based storage.
Ingres originated as a research project at UC Berkeley (see Wikipedia) in the 1970s, and has since become a commercially supported, open source database system. Apparently, Ingres project people later founded Sybase. So Ingres in a sense, is the grandfather (or perhap grand-step-uncle?) to SQL Server. According to the Ingres whitepaper, VectorWise spun off from CWI in Amstersdam, with some roots in MonetDB? For the time being, Ingres VectorWise is not open-source. The interesting aspect of VectorWise among other column store database products is use of the SIMD, as in utilizing the special instructions and registers built into recent generation microprocessors. (In a previous blog, I proposed special SIMD instructions to improve the efficiency on accessing pages in traditional row-storage database engines.)
Below are TPC-H results at scale factor 100GB on HP ProLiant DL380 G7 with two Xeon 5680 six-core 3.33GHz processors for SQL Server 2008 R2 and Ingres VectorWise 1.5.
Overall, the VectorWise columnar database has about 2.5X higher score on Power, and 5X on Throughput. The glaring weak point of SQL Server is that the throughput is (almost 2X) lower than the power. The SQL Server parallel execution engine is very powerful running a single stream with no other concurrent queries competing for CPU. It does not have a good strategy for sharing compute resources with other concurrent long running queries.
The general expectation set by all the new technology, columnar storage, memory optimization and vector processing was 10X, not 3X. However, we should consider that the TPC-H benchmark score is a composite geometric mean of 22 individual queries. The individual query performance differences between SQL Server and VectorWise are shown below, on a logarithmic scale (base 2, not 10, a cool feature in Excel 2007?).
Visit the Solution Showcase, where you’ll learn about the latest cutting-edge solutions — from the best-of-breed providers and up-and-comers. Get the information you need from our exhibitors to make informed decisions.
FACE-TO-FACE SPONSOR MEETINGS
Gain insight on your pressing IT needs
Discuss your technology requirements with qualified solution providers at the event. Use Agenda Builder to schedule private 30-minute sponsor meetings that will bolster your projects and relationships, wherever you are in the buying cycle.
SOLUTION PROVIDER SESSIONS
Real success stories
These sponsor-led sessions feature some of the market’s most fascinating solutions. You’ll hear real-life examples from those who have deployed solutions successfully, including their strategies, challenges and results.
A pioneer in using column-based database technology to enable Information Lifecycle Management in SAP environments, PBS Software offers nearline storage solutions for SAP Business Warehouse (BW) and ERP installations. PBS solutions help SAP users to process large and complex data volumes by compressing and storing lesser-used data sets in column-based database architectures in order to free up SAP applications considerably. Thanks to column-based database technology, users have fast access to nearline stored data in order to conduct adhoc analyses. Working with Actian, PBS nearline storage solutions are now also available by using Actian Vectorwise as the column-based database server.
Actian and Numsight Sign Strategic Partnership
Agreement marks the launch of bundled solution for analysing large databases at a lower cost
Actian Corporation has signed a partnership agreement with Numsight, a French computer software and systems consultancy which provides hosted marketing database solutions to support data analytics in the retail sector. Covering technology solutions and marketing efforts, the agreement marks both companies’ commitment to provide customers with data analytics at the speed of thought.
EnvoiMoinsCher.com Boosts Customer Satisfaction and Service Delivery with Actian Vectorwise
rance’s first online shipping comparison site uses record-breaking analytic database
Boxtale, the firm behind the EnvoiMoinsCher.com website, is using the high-performance analytic database Actian Vectorwise to accelerate complex analytic query response times. Visitors to the online shipping price comparison website now benefit from a dramatically-improved user experience when searching for the best delivery prices from a selection of more than twenty shipping providers and when placing their order.
Actian Vectorwise has made rapid inroads in enabling savvy data-centric organizations such as EnvoiMoinsCher. com to successfully monetize the growing data volumes by providing real time analysis necessary for their business.