database management & data warehousing founded 2005 headquarters toronto canada products infobright enterprise edition formerly brighthouse infobright community edition website www.infobright.com infobright is a commercial provider of column oriented relational database software with a focus in machine generated data . the company will bring to market a new data analytics product in the latter half of 2016 . the company s head office is located in toronto canada . most of its research and development is based in warsaw poland . support personnel are located in various offices around the world . contents 1 history 2 technology 2.1 infobright enterprise edition iee 2.2 infobright approximate query iaq 3 see also 4 references 5 external links history edit 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 . 1 the company is funded by venture capital investors flybridge capital partners and information venture partners . in 2009 infobright was recognized as mysql s partner of the year 2 and a gartner cool vendor in data management and integration . 3 it is also certified for use with sun s unified storage product line . 4 it is the assignee of published patent applications on data compression 5 query optimization 6 and data organization . 7 in february 2016 gartner recognized infobright as a challenger in the data warehouse and data management solutions for analytics space alongside hpe amazon web services 1010data and marklogic . in july 2016 infobright officially transitioned away from its open source community edition to focus on their oem and direct customer markets . technology edit infobright enterprise edition iee edit infobright s database software is integrated with mysql 8 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 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 . 9 query execution the optimizer uses theories of rough sets and granular computing 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 . 10 infobright approximate query iaq edit iaq is infobright s newest product announced as of feb 2016 . leveraging iee s statistical foundation iaq is purpose built to provide rapid insight for organizations with multi terabytes to petabytes of data with minimal infrastructure . it utilizes statistical modelling to ingest interrogate and materialize data without the need to store atomic data and therefore significantly reduce query time . iaq uses ingest agents modeled after iee s data load processor dlp technology . see also edit this section is empty . you can help by adding to it . january 2015 references edit open source data warehouse column database software improve sql performance . community website . retrieved october 17 2011 . 2009 mysql partners of the year sun presents 2009 mysql awards cool vendors in data management and integration 2009 . gartner report g00165365 infobright editions secure sun certification . tmcnet.com april 23 2009 method and system for data compression in a relational database . patent application us 2008 0071818 a1 method and system for storing organizing and processing data in a relational database . patent application us 2008 0071748 a1 methods and systems for database organization . patent application us 2009 0106210 a1 infobright data warehouse . mysql september 2008 brighthouse an analytic data warehouse for ad hoc queries . vldb 2008 industry paper rough sets in data warehousing . rsctc 2008 invited talk external links edit infobright official website retrieved from https en.wikipedia.org w index.php title infobright & oldid 742712810 categories software companies of canadafree database management systemsmysqlhidden categories articles to be expanded from january 2015all articles to be expandedarticles with empty sections from january 2015all articles with empty sectionsarticles using small message boxesofficial website different in wikidata and wikipedia navigation menu personal tools not logged intalkcontributionscreate accountlog in namespaces article talk variants views read edit view history more search navigation main pagecontentsfeatured contentcurrent eventsrandom articledonate to wikipediawikipedia store interaction helpabout wikipediacommunity portalrecent changescontact page tools what links hererelated changesupload filespecial pagespermanent linkpage informationwikidata itemcite this page print export create a bookdownload as pdfprintable version languages espa olfran aisitaliano edit links this page was last modified on 5 october 2016 at 09 27 . text is available under the creative commons attribution sharealike license ; additional terms may apply . by using this site you agree to the terms of use and privacy policy . wikipedia is a registered trademark of the wikimedia foundation inc. a non profit organization . privacy policy about wikipedia disclaimers contact wikipedia developers cookie statement mobile view