January 10, 2012 | Jim Tommaney
A Behind the Scenes look at InfiniDB: Ease of Use (Part 3 of 3)
When we set out to design InfiniDB, we wanted to build a database that was extremely easy-to-use. Historically, companies have required DBAs and enterprise IT to be closely engaged to enable analytics within their organizations.
We wanted analysts and data scientists to be able to use InfiniDB without a significant burden on precious DBA resources. As such, we designed InfiniDB with the hugely popular MySQL interface, index-free, and with features that extend MySQL for analytics. Let’s examine each of these.
Of the many database solutions on the market, InfiniDB is the only MPP columnar database tightly integrated with MySQL. This means that, for tens of thousands of MySQL applications that have large-scale data, InfiniDB is the tool-of-choice for structured Big Data analytics. No need to learn a new language or rewrite code: just install InfiniDB and you can be executing complex commands on massive datasets in minutes.
InfiniDB is designed to minimize performance tuning. Gone are the days when DBAs have to create indexes or other materialized views to get blazing-fast performance. Through its unique Extent Map architecture, paired with automatic horizontal and vertical partitioning, InfiniDB scales effortlessly without technical tweaking.
In fact, we’ve even added features that make MySQL easier to use for analytics. For example, InfiniDB fully supports online DDL (i.e. one session can be adding columns to a table while another session is querying that table) using calonlinealter. This is a feature that’s currently not supported in standard MySQL.
With enhanced I/O, record parallelism and unparalleled ease-of-use, InfiniDB is the top choice for helping take control of your data for deep analytics.
Coming soon is InfiniDB 3, which will feature greater storage architecture flexibility, enabling it for massive cloud deployments. 2012 will be a tremendous year for Big Data analytics and InfiniDB!