Over a million developers have joined DZone.
{{announcement.body}}
{{announcement.title}}

Pilosa: A New Kind of Database Index [Interview]

DZone's Guide to

Pilosa: A New Kind of Database Index [Interview]

The open-source Pilosa includes production-tested features, including single and multi-node index support, replication, algorithm plugins, a data importer, and more.

· Database Zone
Free Resource

Whether you work in SQL Server Management Studio or Visual Studio, Redgate tools integrate with your existing infrastructure, enabling you to align DevOps for your applications with DevOps for your SQL Server databases. Discover true Database DevOps, brought to you in partnership with Redgate.

Chris speaks with H.O. Maycotte and Troy Lanier of Pilosa, a new kind of index — a distributed bitmap index — that aims to solve a major problem for everyone who works with data sets of 1TB or more.

Pilosa sits on top of, rather than within, data stores, and because it’s a bitmap index, it’s relatively small in volume, which means it can run in-memory rather than on disk. It executes queries on any persistent storage at breakneck speeds. We think it’s faster than anything else on earth.

As open-source software, Pilosa is available today on GitHub. The first version includes production-tested features, including single and multi-node index support, replication, algorithm plugins, a data importer, and basic cluster management.

It’s easier than you think to extend DevOps practices to SQL Server with Redgate tools. Discover how to introduce true Database DevOps, brought to you in partnership with Redgate

Topics:
database ,database indexes ,pilosa ,bitmap index

Opinions expressed by DZone contributors are their own.

{{ parent.title || parent.header.title}}

{{ parent.tldr }}

{{ parent.urlSource.name }}