Skip to main content

Home/ BI-TAGS/ Group items tagged infobright

Rss Feed Group items tagged

cezarovidiu

Connecting Infobright and Talend - 1 views

  • These instructions assume that you have Infobright installed and running.   First and foremost, download Talend.  In this example, we will download Talend Open Source Data Integrator v5.0. (http://www.talend.com/download.php)  Once fully installed, download the Talend/Infobright Connector.  Ensure you download the right connector; instructions are on the download page (http://www.infobright.org/Downloads/Contributed-Software/) If you download Talend 4.0+, you’ll want the latest connector For older versions of Talend, you’ll want the 3.7 connector and lower. Once downloaded, perform the following actions: [For Windows] Copy the infobright_jni([_32|_64])bit.dll to C:\Windows\infobright_jni.dll Copy the zipped “tInfobrightOutput” directory to this directory: [Install Root of Talend] \plugins\org.talend.designer.components.localprovider_5.0.1.r74687\components\tInfobrightOutput Copy “infobright-core-3.4.jar” to [Install Root of Talend]\lib\java Running Talend in Windows If using Windows, run talend as Administrator.  If you don’t, you will see odd “Access Denied” or “Accesse Refuse” error messages when trying to use the connector.
  • You need to do some work on these instructions. Version 5 is not like version 4. You must run Talend 5 before the “lib\java\” folder appears.  Once it does appear, it no longer contains the .jar files like version 4; just a file “index.xml” that you have to edit to point to the infobright jar file in the components folder.
cezarovidiu

Star Schema Bechmark: InfoBright, InfiniDB and LucidDB - MySQL Performance Blog - 0 views

  • Queries time
  • InfoBright was fully 1 CPU bound during all queries.
  • InfiniDB is otherwise was IO-bound, and processed data fully utilizing sequential reads and reading data with speed 120MB/s. I think it allowed InfiniDB to get the best time in the most queries.
  • ...1 more annotation...
  • LucidDB on this stage is also can utilize only singe thread with results sometime better, sometime worse than InfoBright.
  •  
    "Star Schema Bechmark: InfoBright, InfiniDB and LucidDB"
cezarovidiu

BI Tools, their SQL Generators, and Infobright - 1 views

  • The greatest benefit of columnar is to avoid disk I/O.  By choosing “select *”, you run the risk of losing that benefit. 
  • BI tools are here to stay, and they really help make visualization of analytics easy.  When working with Infobright, always take an extra second to review the generated queries.  The extra few seconds could mean seconds or minutes in saved query times.
  •  
    " The greatest benefit of columnar is to avoid disk I/O.  By choosing "select *", you run the risk of losing that benefit. "
cezarovidiu

InfiniDB - the high performance, column oriented analytic database - 0 views

  •  
    "Contributed by Calpont, InfiniDB Community Edition is an open source, scale-up analytics database engine for your data warehousing, business intelligence and read-intensive application needs. Enabled via MySQL® and purpose-built for an analytical workload with column-oriented technology at its core, the multi-threaded capabilities of InfiniDB Community Edition fully encompass query, transactional support and bulk load operations.  So come on in, grab a download and get started."
1 - 5 of 5
Showing 20 items per page