actian x and x100 · actian x with the release of actian x hybrid database, actian introduces an...
TRANSCRIPT
Introducing Operational Analytics for Actian XWith the release of Actian X Hybrid Database, Actian introduces an exciting, operational analytics capability. The X100 engine, from Actian’s analytic database ‘Vector’, brings to your Actian X instance the power of column-based data-storage, x86 vector-processing with in-cache direct decompression, and other notable technical advances. The result is that you can now harness this unique, innovative capability for incredibly fast and efficient reporting and analytics queries in your Ingres installation alongside OLTP.
A New Type of Application – Operational AnalyticsIntegrating X100 in Actian X enables a new class of application that can mix OLTP and analytic queries – with each query being directed to the appropriate execution engine. An X100 table can be created and populated with just the data needed for reporting or analytics. The X100 components are designed from the ground up for reporting and analytic performance, and to minimize the effect on OLTP operations. Query syntax and connections methods don’t change, so time to performance improvement is minimal.
Creating Hybrid Analytic/OLTP Ingres Applications is Surprisingly Simple
Harnessing the X100 capability in Actian X takes just a few steps:
■ Create analytics specific tables with STRUCTURE=x100 ■ Populate the X100 tables with just the data needed for analytics (subset
of OLTP data) ■ Create an external process to periodically update the tables (SQL, Actian
DataConnect) ■ Use the same queries and access methods as before. Actian X
automatically directs the queries (via the table structure) to send to the X100 engine for processing
■ Reporting and visualization tools will connect to the database instance as normal
Key BenefitsRecord breaking analytics combined with enterprise OLTP
Simple, incremental addition of analytic capability to existing Ingres applications
Integrated solution means time to value and TCO are very low
Big benefits with negligible load cost
Actian X and X100Combining Record Breaking Analytics with Enterprise OLTP
Data sheet
Actian X with X100 makes enabling operational analytics easy because:
■ Single vendor, integrated solution ■ Use existing hardware (Note: modern CPUs show best results), ■ Same vendor, same support contract, same dba skills ■ No special data model required – nor are indexes or constraints required for performance ■ Run the queries you have always run – only faster! ■ Take advantage of more standard syntax analytical capabilities ■ Virtually no tuning required
• No indexing• No materialized views• No pre-aggregated cubes• No compression configuration• No complex block size configuration• No complex table structure decisions
X100 Brings Record Breaking Performance to Actian X
Source: http://www.tpc.org/tpch/results/tpch_perf_results.asp?resulttype=noncluster
500,000 1,000,000 1,500,000 2,000,000 QphH 0
Actian Vector 5.0 2,140,307
SQL Server 2016 1,071,018
SQL Server 2016 969,504
SQL Server 2014
Sybase IQ
Jun ‘16
May ‘16
Mar ‘16
Jul ‘15
May ‘15
Apr ‘14
Oct ‘13
725,686
461,837
SQL Server 2014
SQL Server 2014
700,329
230,119
Twiceasfastasthenearestcompe1tor
TPC-H Scale Factor 3000GB
Huge Analytics Query Benefit/Negligible X100 Load Cost
X100 shows orders of magnitude performance improvements with medium complexity analytics queries compared to standard Ingres OLTP results. One time load cost to populate the X100 tables is negligible.
X100 – Analytic Technology InnovationX100 unlocks performance features in modern CPUs, removing the need for extensive or ongoing tuning by the DBA
Vector Processing
Patent pending Actian technology enabling the same operation to be performed on multiple data point simultaneously
Exploiting Chip Cache
Data processing on chip cache is 100x faster than in RAM
2nd Generation Column-based Storage
Positional Delta Trees enable online updates, minimize disk I/O and are less CPU intensive
Smarter Compression
Compression is performed in the CPU for maximum throughput
6.7M rows
33M rows
200M rows
1.86s 8.3s 52.5s
0
20
40
60
80
100
120
140
160
180
Query on 6.7M Rows Query on 33M Rows Query on 200M Rows Ingres 12 66 165.6 Vector 1 2.1 7.07
Tim
e in
Sec
onds
Medium Complexity Analytics Query against Ingres & X100
Vector Ingres
TimetoLoadX100TablesfromIngres
Tim
e / C
ycle
s to
Pro
cess
Data Processed
DISK
RAM
CHIP
10GB 2-3GB 40-400MB
2-20
15
0-25
0 M
illio
ns
www.actian.com | Toll Free +1 888 446 4737 | Tel +1 650 587 55002300 Geng Rd., Suite 150, Palo Alto, CA 94303
© 2017 Actian Corporation. Actian is a trademark of Actian Corporation and its subsidiaries. All other trademarks, trade names, service marks, and logos referenced herein belong to their respective companies. (DS39-0417)
Activate Your DataWith the new X100 capability, Actian X developers can easily improve reporting and BI performance and expand the value of their applications by adding analytic features. With the X100 capability integrated into Actian X, developers start by copying reporting and analytic data into X100 tables and using familiar queries, reporting and visualization tools - with no changes to the application. Results will be immediate and impressive – X100 technology is part of the world’s fastest analytics database from Actian. Adding complex analytics features to existing applications (for example, adding historical trending, averaging, change rates) will be almost as easy, and because of X100’s performance gains, many queries will run sub-second and have little to no effect on overall application performance.
It’s time to realize the future. Actian X. The hybrid database for next generation operational analytics.
Storage Indexes
Quickly identify candidate data blocks, minimize I/O
Multi-core Parallelism
Data is processed in parallel using any number (configurable?) of CPU cores, delivering optimal performance on commodity hardware
…