Infobright

<h2 id="history">History</h2>
Infobright was founded in 2005. It launched an <a href="/facts/Open-source_model/uDWVYJ4V">open source</a> version of its innovative columnar database product in September 2008, while also at the same time launching its community site.<a class="footnote-ref" id="fnref:1" href="#fn:1">1</a>
The company was spun out of technology developed by and within the Royal Bank of Canada (RBC) and funded by <a href="/facts/Venture_capital/yeH3m7zo">venture capital</a> investors Flybridge Capital Partners and Information Venture Partners.
In 2009, Infobright was recognized as MySQL's Partner of the Year,<a class="footnote-ref" id="fnref:2" href="#fn:2">2</a> and a <a href="/facts/Gartner/9hd9zakC">Gartner</a> Cool Vendor in Data Management and Integration.<a class="footnote-ref" id="fnref:3" href="#fn:3">3</a> It is also certified for use with Sun's Unified Storage product line.<a class="footnote-ref" id="fnref:4" href="#fn:4">4</a> It was the innovator and developer of multiple proprietary patents including data compression,<a class="footnote-ref" id="fnref:5" href="#fn:5">5</a> query optimization,<a class="footnote-ref" id="fnref:6" href="#fn:6">6</a> and data organization,<a class="footnote-ref" id="fnref:7" href="#fn:7">7</a> a total of six distinct awarded patents.
In July 2016, Infobright officially transitioned away from its open source community edition to focus on their <a href="/facts/OEM/hmUhIWaS">OEM</a> and direct customer markets.
In 2017 Infobright and its assets including IP and source code were acquired by Security On-Demand Inc (SOD)., a managed security services provider (MSSP) based in San Diego, California. The company heavily invested in expanding the technology base to support cyber-security detection capabilities utilizing a new innovation in the analysis of large data sets using Approximate Query (AQ) techniques and Machine Learning. 
In 2019, the SOD owners spun out the company to become an independent company becoming AQ Technologies S.P. Z.oo (AQT) headquartered in Warsaw Poland. The mission and focus of the newly organized was to provide research and development technology and services for improved real-time analysis and detection of cyber-security threats within massive amounts of log data.
In late 2019, AQ Technologies, was awarded grant funding from National Centre for Research and Development (NCBR) <a href="https://archiwum.ncbr.gov.pl/en/">https://archiwum.ncbr.gov.pl/en/</a> by the government of Poland with the purpose of expanding Approximate Query analysis beyond structured numeric data the ability to analyze alpha-numeric and unstructured log data. In 2020, the company was awarded a second grant from the NCBR to further develop the capability to detect anomalies in unstructured data utilizing Artificial Intelligence techniques to enable cyber-security analysts to find "hidden" attackers within massive amounts of log data.
Today, AQ Technologies along with many of its original founding team members continues in its mission in helping solve complex big data analysis problems.

<h2 id="technology">Technology</h2>
<h3>Infobright Enterprise Edition (IEE)</h3>
Infobright's database software is integrated with <a href="/facts/MySQL/QEEDNBDP">MySQL</a>,<a class="footnote-ref" id="fnref:8" href="#fn:8">8</a> 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 216 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 <a href="/facts/Data_compression/gMFuY4FT">compressed</a> to approximately 20:1 on average. Infobright Enterprise Edition was designed to support PostgreSQL and MySQL.

<h4>Knowledge Grid</h4>
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 <a href="/facts/Index_(database)/TRqmk9It">database index</a>.<a class="footnote-ref" id="fnref:9" href="#fn:9">9</a>

<h4>Query execution</h4>
The optimizer uses theories of <a href="/facts/Rough_set/7pRxKzxx">rough sets</a> and <a href="/facts/Granular_Computing/Fmk0ERmK">Granular Computing</a> 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.<a class="footnote-ref" id="fnref:10" href="#fn:10">10</a>

<h2 id="references">References</h2>

<ol>
<li id="fn:1">"Open Source Data Warehouse, Column Database Software, Improve SQL Performance". Community website. Archived from the original on October 19, 2011. Retrieved October 17, 2011. <a href="https://web.archive.org/web/20111019034305/http://www.infobright.org/" target="_blank">https://web.archive.org/web/20111019034305/http://www.infobright.org/</a> <a href="#fnref:1" class="footnote-back-ref">↩</a></li>
<li id="fn:2">2009 MySQL Partners of the Year Archived 2009-05-01 at the Wayback Machine Sun Presents 2009 MySQL Awards <a href="http://www.mysql.com/news-and-events/generate-article.php?id=2009_08" target="_blank">http://www.mysql.com/news-and-events/generate-article.php?id=2009_08</a> <a href="#fnref:2" class="footnote-back-ref">↩</a></li>
<li id="fn:3">Cool Vendors in Data Management and Integration, 2009. Gartner Report G00165365 <a href="#fnref:3" class="footnote-back-ref">↩</a></li>
<li id="fn:4">Infobright Editions Secure Sun Certification. TMCNet.com, April 23, 2009 <a href="http://asterisk.tmcnet.com/topics/open-source/articles/54783-infobright-editions-secure-sun-certification.htm" target="_blank">http://asterisk.tmcnet.com/topics/open-source/articles/54783-infobright-editions-secure-sun-certification.htm</a> <a href="#fnref:4" class="footnote-back-ref">↩</a></li>
<li id="fn:5">Method and system for data compression in a relational database. Patent Application US 2008/0071818 A1 <a href="https://archive.today/20120913015855/http://www.patentlens.net/patentlens/structured.cgi?patnum=US_2008/0071818_A1%23show" target="_blank">https://archive.today/20120913015855/http://www.patentlens.net/patentlens/structured.cgi?patnum=US_2008/0071818_A1%23show</a> <a href="#fnref:5" class="footnote-back-ref">↩</a></li>
<li id="fn:6">Method and system for storing, organizing and processing data in a relational database. Patent Application US 2008/0071748 A1 <a href="https://archive.today/20120909222643/http://www.patentlens.net/patentlens/structured.cgi?patnum=US_2008/0071748_A1%23show" target="_blank">https://archive.today/20120909222643/http://www.patentlens.net/patentlens/structured.cgi?patnum=US_2008/0071748_A1%23show</a> <a href="#fnref:6" class="footnote-back-ref">↩</a></li>
<li id="fn:7">Methods and systems for database organization. Patent Application US 2009/0106210 A1 <a href="https://archive.today/20120907193810/http://www.patentlens.net/patentlens/structured.cgi?patnum=US_2009/0106210_A1%23show" target="_blank">https://archive.today/20120907193810/http://www.patentlens.net/patentlens/structured.cgi?patnum=US_2009/0106210_A1%23show</a> <a href="#fnref:7" class="footnote-back-ref">↩</a></li>
<li id="fn:8">Infobright Data Warehouse Archived 2009-05-08 at the Wayback Machine. MySQL, September, 2008 <a href="http://www.mysql.com/products/dw/infobright.html" target="_blank">http://www.mysql.com/products/dw/infobright.html</a> <a href="#fnref:8" class="footnote-back-ref">↩</a></li>
<li id="fn:9">Brighthouse: an analytic data warehouse for ad hoc queries Archived 2016-05-07 at the Wayback Machine. VLDB 2008 industry paper <a href="http://www.vldb.org/pvldb/1/1454174.pdf" target="_blank">http://www.vldb.org/pvldb/1/1454174.pdf</a> <a href="#fnref:9" class="footnote-back-ref">↩</a></li>
<li id="fn:10">Rough Sets in Data Warehousing. RSCTC 2008 invited talk <a href="http://rsctc2008.cs.uakron.edu/Invited%20Speakers/Presentations/Slezak%20Revised%20RSCTC%20Presentation.ppt" target="_blank">http://rsctc2008.cs.uakron.edu/Invited%20Speakers/Presentations/Slezak%20Revised%20RSCTC%20Presentation.ppt</a> <a href="#fnref:10" class="footnote-back-ref">↩</a></li>
</ol>

Infobright open-in-new

Infobright