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 Toronto ( ; or ) is the capital city of the Canadian province of Ontario. With a recorded population of 2,794,356 in 2021, it is the most populous city in Canada and the fourth most populous city in North America. The city is the anch ...

Ontario Ontario ( ; ) is one of the thirteen provinces and territories of Canada.Ontario is located in the geographic eastern half of Canada, but it has historically and politically been considered to be part of Central Canada. Located in Central C ...

, Canada. Most of its research and development is based in

Warsaw Warsaw ( pl, Warszawa, ), officially the Capital City of Warsaw,, abbreviation: ''m.st. Warszawa'' is the capital and largest city of Poland. The metropolis stands on the River Vistula in east-central Poland, and its population is officia ...

Poland Poland, officially the Republic of Poland, is a country in Central Europe. It is divided into 16 administrative provinces called voivodeships, covering an area of . Poland has a population of over 38 million and is the fifth-most populou ...

. Support personnel are located in various offices around the world.

History

Infobright was founded in 2005. It became an open source company in September 2008, when it issued the first free release of its software. At the same time its community site was launched. The company is funded by

venture capital Venture capital (often abbreviated as VC) is a form of private equity financing that is provided by venture capital firms or funds to start-up company, startups, early-stage, and emerging companies that have been deemed to have high growth poten ...

investors

Flybridge Capital Partners Flybridge Capital Partners is an early stage venture capital firm with offices in Boston and New York City. History In 2001, Flybridge Capital was founded under the name IDG Ventures Boston, an international venture investment branch of the Int ...

and Information Venture Partners. In 2009, Infobright was recognized as MySQL's Partner of the Year, and a

Gartner Gartner, Inc is a technological research and consulting firm based in Stamford, Connecticut that conducts research on technology and shares this research both through private consulting as well as executive programs and conferences. Its client ...

Cool Vendor in Data Management and Integration. It is also certified for use with Sun's Unified Storage product line. It is the assignee of published patent applications on data compression, query optimization, and data organization. In July 2016, Infobright officially transitioned away from its open source community edition to focus on their

OEM An original equipment manufacturer (OEM) is generally perceived as a company that produces non-aftermarket parts and equipment that may be marketed by another manufacturer. It is a common industry term recognized and used by many professional or ...

and direct customer markets.

Technology

Infobright Enterprise Edition (IEE)

Infobright's database software is integrated with

MySQL MySQL () is an open-source relational database management system (RDBMS). Its name is a combination of "My", the name of co-founder Michael Widenius's daughter My, and "SQL", the acronym for Structured Query Language. A relational database ...

, but with its own proprietary data storage and query optimization layers. Infobright uses a columnar approach to database design. When data is loaded into a table, it is broken into the groups of 2¹⁶ rows, further decomposed into separate data packs for each of the columns. By breaking each column by the same number of rows, it maintains its integrity with other columns for the same entry. For example, row 1, column 1 is the first entry in the first datapack for column 1. Row 1 in column 2 is the first entry in the first datapack for column 2. Each data pack is separately compressed to approximately 20:1 on average. Infobright Enterprise Edition is available in PostgreSQL and MySQL. Knowledge Grid A metadata layer (called the Database Knowledge Grid) stores compact information about the contents and relationships between the data packs, replacing the concept of a traditional

database index A database index is a data structure that improves the speed of data retrieval operations on a database table at the cost of additional writes and storage space to maintain the index data structure. Indexes are used to quickly locate data without ...

. Query execution The optimizer uses theories of rough sets and

Granular Computing Granular computing (GrC) is an emerging computing paradigm of information processing that concerns the processing of complex information entities called "information granules", which arise in the process of data abstraction and derivation of knowl ...

by categorizing which data packs need to be decompressed and by refining such categorization using partial results obtained from the Knowledge Grid and already decompressed data packs.Rough Sets in Data Warehousing
RSCTC 2008 invited talk

References

Software companies of Canada Free database management systems MySQL 2005 establishments in Canada Software companies established in 2005 Companies established in 2005