InfiniDB

Last updated

InfiniDB, Inc.
Industry Enterprise software
Database management
Data warehousing
Founded2000 (2000)
DefunctOctober 1, 2014 (2014-10-01)
Headquarters
Frisco, Texas
,
US
ProductsInfiniDB,
InfiniDB for the Cloud,
InfiniDB for Apache Hadoop
Website www.infinidb.co

InfiniDB (formerly Calpont Corporation [1] ) was a database management software company based in Frisco, Texas. The company developed InfiniDB, a scalable, software-only columnar database management system [2] for analytic applications. [3]

Contents

InfiniDB is a scalable database built for big data analytics, business intelligence, data warehousing and other read-intensive applications. InfiniDB's column-store architecture enables very quick load and query times. [4] Its massive parallel processing (MPP) technology scales with any type of storage hardware. [5]

In 2014, The company raised $7.5 million in a new round of funding led by McDonnell Ventures. [6]

Columnar databases

By storing and managing data based on columns rather than rows, column-oriented architecture overcomes query limitations that exist in traditional row-based RDBMS. Only the necessary columns in a query are accessed, reducing I/O activities by skipping unneeded columns. [7]

InfiniDB is accessed through a MySQL interface. [8] It then parallelizes queries and executes in a MapReduce fashion (similar in concept to the methodology used by Apache Hadoop). [9] Each thread within the distributed architecture operates independently, avoiding thread-to-thread or node-to-node communication that can cripple scaling. [10]

InfiniDB is used to enable performance-intensive analytic applications. Customers include Bandwidth.com, Tucows, Warner Music Group, [11] Genus, [12] Aviation Software International, [13] Caring Bridge, [14] Navigant Consulting and 1&1 Internet. [15]

InfiniDB resellers included SkySQL (including many former MySQL employees) [16] and KK Ashisuto in Japan.[ citation needed ]

Variants and forks

On October 16, 2013, the company announced that InfiniDB would be licensed under the General Public License v. 2. [17] The open source variants of InfiniDB databases are: InfiniDB Standard Edition and InfiniDB for the Cloud including InfiniDB for Apache Hadoop. [18]

MariaDB Corporation announced on April 5, 2016 the release of its first big data analytics engine, MariaDB ColumnStore. It is based both on a fork of InfiniDB and open-source community contributions. ColumnStore supports use cases including real-time, batch and algorithmic. [19]

Bankruptcy

On October 1, 2014, InfiniDB ceased operations and filed for bankruptcy protection in US Bankruptcy Court in the Eastern District of Texas. Existing customers may be able to receive support from other companies, notably MariaDB.

Related Research Articles

<span class="mw-page-title-main">IBM Db2</span> Relational model database server

Db2 is a family of data management products, including database servers, developed by IBM. It initially supported the relational model, but was extended to support object–relational features and non-relational structures like JSON and XML. The brand name was originally styled as DB/2, then DB2 until 2017 and finally changed to its present form.

<span class="mw-page-title-main">MonetDB</span> Open source column-oriented relational database management system

MonetDB is an open-source column-oriented relational database management system (RDBMS) originally developed at the Centrum Wiskunde & Informatica (CWI) in the Netherlands. It is designed to provide high performance on complex queries against large databases, such as combining tables with hundreds of columns and millions of rows. MonetDB has been applied in high-performance applications for online analytical processing, data mining, geographic information system (GIS), Resource Description Framework (RDF), text retrieval and sequence alignment processing.

A column-oriented DBMS or columnar DBMS is a database management system (DBMS) that stores data tables by column rather than by row. Benefits include more efficient access to data when only querying a subset of columns, and more options for data compression. However, they are typically less efficient for inserting new data.

SAP IQ is a column-based, petabyte scale, relational database software system used for business intelligence, data warehousing, and data marts. Produced by Sybase Inc., now an SAP company, its primary function is to analyze large amounts of data in a low-cost, highly available environment. SAP IQ is often credited with pioneering the commercialization of column-store technology.

Microsoft SQL Server is a proprietary relational database management system developed by Microsoft. As a database server, it is a software product with the primary function of storing and retrieving data as requested by other software applications—which may run either on the same computer or on another computer across a network. Microsoft markets at least a dozen different editions of Microsoft SQL Server, aimed at different audiences and for workloads ranging from small single-machine applications to large Internet-facing applications with many concurrent users.

<span class="mw-page-title-main">Apache Cassandra</span> Free and open-source database management system

Cassandra is a free and open-source, distributed, wide-column store, NoSQL database management system designed to handle large amounts of data across many commodity servers, providing high availability with no single point of failure. Cassandra offers support for clusters spanning multiple datacenters, with asynchronous masterless replication allowing low latency operations for all clients. Cassandra was designed to implement a combination of Amazon's Dynamo distributed storage and replication techniques combined with Google's Bigtable data and storage engine model.

<span class="mw-page-title-main">Greenplum</span>

Greenplum is a big data technology based on MPP architecture and the Postgres open source database technology. The technology was created by a company of the same name headquartered in San Mateo, California around 2005. Greenplum was acquired by EMC Corporation in July 2010.

<span class="mw-page-title-main">Vertica</span> Software company

Vertica is an analytic database management software company. Vertica was founded in 2005 by the database researcher Michael Stonebraker with Andrew Palmer as the founding CEO. Ralph Breslauer and Christopher P. Lynch served as CEOs later on.

Infobright is a commercial provider of column-oriented relational database software with a focus in machine-generated data. The company's head office is located in Toronto, Ontario, Canada. Most of its research and development is based in Warsaw, Poland. Support personnel are located in various offices around the world.

<span class="mw-page-title-main">Apache Hive</span> Database engine

Apache Hive is a data warehouse software project built on top of Apache Hadoop for providing data query and analysis. Hive gives an SQL-like interface to query data stored in various databases and file systems that integrate with Hadoop. Traditional SQL queries must be implemented in the MapReduce Java API to execute SQL applications and queries over distributed data. Hive provides the necessary SQL abstraction to integrate SQL-like queries (HiveQL) into the underlying Java without the need to implement queries in the low-level Java API. Since most data warehousing applications work with SQL-based querying languages, Hive aids the portability of SQL-based applications to Hadoop. While initially developed by Facebook, Apache Hive is used and developed by other companies such as Netflix and the Financial Industry Regulatory Authority (FINRA). Amazon maintains a software fork of Apache Hive included in Amazon Elastic MapReduce on Amazon Web Services.

Within database management systems, the RCFile is a data placement structure that determines how to store relational tables on computer clusters. It is designed for systems using the MapReduce framework. The RCFile structure includes a data storage format, data compression approach, and optimization techniques for data reading. It is able to meet all the four requirements of data placement: (1) fast data loading, (2) fast query processing, (3) highly efficient storage space utilization, and (4) a strong adaptivity to dynamic data access patterns.

A cloud database is a database that typically runs on a cloud computing platform and access to the database is provided as-a-service. There are two common deployment models: users can run databases on the cloud independently, using a virtual machine image, or they can purchase access to a database service, maintained by a cloud database provider. Of the databases available on the cloud, some are SQL-based and some use a NoSQL data model.

Clustrix, Inc. is a San Francisco-based private company founded in 2006 that develops a database management system marketed as NewSQL.

Apache Impala is an open source massively parallel processing (MPP) SQL query engine for data stored in a computer cluster running Apache Hadoop. Impala has been described as the open-source equivalent of Google F1, which inspired its development in 2012.

The following outline is provided as an overview of and topical guide to MySQL:

Presto is a distributed query engine for big data using the SQL query language. Its architecture allows users to query data sources such as Hadoop, Cassandra, Kafka, AWS S3, Alluxio, MySQL, MongoDB and Teradata, and allows use of multiple data sources within a query. Presto is community-driven open-source software released under the Apache License.

Apache Parquet is a free and open-source column-oriented data storage format in the Apache Hadoop ecosystem. It is similar to RCFile and ORC, the other columnar-storage file formats in Hadoop, and is compatible with most of the data processing frameworks around Hadoop. It provides efficient data compression and encoding schemes with enhanced performance to handle complex data in bulk.

<span class="mw-page-title-main">ClickHouse</span> Open-source database management system

ClickHouse is an open-source column-oriented DBMS for online analytical processing (OLAP) that allows users to generate analytical reports using SQL queries in real-time. ClickHouse Inc. is headquartered in the Bay Area of California, United States with the subsidiary, ClickHouse B.V., based in Amsterdam, Netherlands.

References

  1. ↑ "Name Change and Funding – InfiniDB". Infinidb.co. June 3, 2015. Retrieved January 17, 2017.
  2. ↑ Roe, David (November 3, 2010). "InfiniDB 2.0 Supports Big Data, Analytics". Cmswire.com. Retrieved January 17, 2017.
  3. ↑ Adrian, Merv (November 8, 2010). "Calpont's InfiniDB – Another ADBMS Insurgent Arises". Enterprise Irregulars. Retrieved January 17, 2017.
  4. ↑ Vadim Tkachenko (January 8, 2010). "Star Schema Bechmark[sic]: InfoBright, InfiniDB and LucidDB - Percona Database Performance Blog". Mysqlperformanceblog.com. Retrieved January 17, 2017.
  5. ↑ "InfiniDB to 1 Trillion Rows ( 1,039,909,436,172 ) | www.infinidb.org | Rows, Infinidb, Comment, Tommaney, Jim". Archived from the original on December 13, 2011. Retrieved December 13, 2011.
  6. ↑ "Calpont renames itself InfiniDB, takes $7.5M to suit up for database wars". Venture Beat. February 10, 2014. Retrieved July 10, 2020.
  7. ↑ ""The Right Workloads for Columnar Databases" - Jim Tommaney, CTO of Calpont". YouTube. September 26, 2011. Retrieved January 17, 2017.
  8. ↑ "2011 Product Review Roundup". Information-management.com. Retrieved January 17, 2017.
  9. ↑ "InfiniDB « Another Word For It". Tm.durusau.net. September 21, 2011. Retrieved January 17, 2017.
  10. ↑ "A Behind the Scenes look at InfiniDB: Parallelism (Part 2 of 3) | www.infinidb.org | Modules, Infinidb, Performance, User, Cust". Archived from the original on January 9, 2012. Retrieved January 10, 2012.
  11. ↑ "Warner Music Group Case Study In Seduction". Calpont.com. August 18, 2010. Retrieved January 17, 2017.
  12. ↑ "Speaker: Fernanda Foertter: Strata 2012 - O'Reilly Conferences, February 28 - March 01, 2012, Santa Clara, CA". Strataconf.com. Retrieved January 17, 2017.
  13. ↑ "ASI chooses Calpont InfiniDB Database". Archived from the original on February 12, 2013. Retrieved January 10, 2012.
  14. ↑ Reviewer, Product (July 13, 2011). "Calpont InfiniDB | Information Management Magazine". Information-management.com. Retrieved January 17, 2017.
  15. ↑ "Customers of Calvin Pont's Dating Advisory Service". Calpont.com. June 20, 2014. Retrieved January 17, 2017.
  16. ↑ "Calpont InfiniDB". Archived from the original on April 26, 2012. Retrieved December 13, 2011.
  17. ↑ "Calpont New Licensing – InfiniDB". Infinidb.co. October 15, 2013. Retrieved January 17, 2017.
  18. ↑ "InfiniDB – MySQL Database Interface". Infinidb.co. Retrieved January 17, 2017.
  19. ↑ "Open Source Leader MariaDB Rockets into Analytics Market". MariaDB. April 5, 2016. Retrieved January 17, 2017.
This page is based on this Wikipedia article
Text is available under the CC BY-SA 4.0 license; additional terms may apply.
Images, videos and audio are available under their respective licenses.