Resources

White Papers

  • InfiniDB® for Apache Hadoop™ Technical NotesDOWNLOAD
  • InfiniDB® for Apache Hadoop™ Performance BenchmarkDOWNLOAD
  • Best practices in the use of Columnar DatabasesDOWNLOAD
  • Online Marketing Analytics Managing Big Data is Not EnoughDOWNLOAD
  • Data Warehouse Benchmark: Comparing InfiniDB® and a Row-based DatabaseDOWNLOAD
  • Why Choose a Column Database for Business Intelligence?DOWNLOAD
  • Divide and Conquer - Why MPP is Best for BI DatabasesDOWNLOAD
  • Lowering the Total Cost of Ownership for Business Intelligence DatabasesDOWNLOAD
  • InfiniDB® Technical Overview (Concepts Guide)DOWNLOAD
  • How to Use Microsoft Excel with InfiniDBDOWNLOAD
  • How to Use OpenOffice with InfiniDBDOWNLOAD
  • Migrating from MySQL to InfiniDBDOWNLOAD
  • Big Data Analytics primerDOWNLOAD

Datasheets

  • InfiniDB® ‐ Analytic Data Platform OverviewDOWNLOAD
  • InfiniDB® Quick Start Guide for RDOWNLOAD
  • InfiniDB® 4.5 - What's NewDOWNLOAD
  • InfiniDB® 4.5 - FAQDOWNLOAD
  • InfiniDB® High Availability GuideDOWNLOAD

Webinars

    Speeding Big Data Analytics in Amazon EC2

    Thank you for your interest in Calpont’s on-demand webinar Speeding Big Data Analytics in Amazon EC2. In this session, Calpont’s CTO, Jim Tommaney discusses the latest features and capabilities in InfiniDB 3. You will learn how the new capabilities enable you to deploy a fast, massive scaling data solution for your Big Data analytics.

    This webinar is best suited to Systems Architects, DBAs, Data Scientists, Engineers, and Technology Executives who want to learn

    • How InfiniDB is architected for Big Data analytics
    • How InfiniDB is provisioned for Amazon EC2
    • How to quickly create a small or large cluster
    • How InfiniDB’s parallel load capabilities deliver linear load scaling
    VIEW WEBINAR

    Where the Rubber Meets the Road - Analytic Platforms in the Real World

    Join Matt Aslett, Research Manager of the 451 Group, and Bob Wilkinson, Calpont VP of Engineering, for a discussion on the emergence of analytic platforms and their role in the evolving data management landscape.

    This webinar is best suited for DBAs, analysts, data warehousing, business intelligence, data scientists, information managers, IT and business executives who want to learn

    •     How the analytic platform emerged and its place in the data management ecosystem
    •     Trends in analytic platforms and what to look for when considering one
    •     Real world use cases of InfiniDB, Calpont’s analytic platform, in telecommunications and online advertising.
    VIEW WEBINAR

    Real-time Analytics for Big Data Sales Warehouse Improves Spend at Warner Music Group

    Join Senior Data Management Consultant Art Rebekale, as he speaks about how Warner Music Group leverages InfiniDB to solve their analytics issues with BigData.

    Presenter:

    • Art Rebekale - Senior Data Management Consultant
    VIEW WEBINAR

    Aviation Software Group makes Analytics Fly with Columnar Data Technology

    WHICH DATABASE TECHNOLOGY SHOULD YOU BE LOOKING AT FOR YOUR ANALYTICS?

    Join industry expert William McKnight and Gordon Rosen, founder and president of Aviation Software Group, to learn about the application of new data technologies and the best practices of leveraging the power of columnar database technology for analytics.

    In this 30 minute web presentation, system analysts, data technologists, analytic / BI managers will learn about:

    • When and why you should look at columnar databases
    • How columnar databases fit into your enterprise systems and complement other data technologies
    • How columnar databases can improve your analytic infrastructure
    • How ASI Group leverages Calpont’s columnar database InfiniDB so airlines can maximize productivity and efficiency across their daily operations


    Presenters:

    • William McKnight, President, McKnight Consulting Group
    • Gordon Rosen, President, ASI Group
    VIEW WEBINAR

    Diving Deeper Into the Analytics Ocean

    Find out why Calpont InfiniDB was named a 2011 SIIA CODiE Finalist for Best Database Solution

    In this 30 minute webinar, Jim Tommaney of Calpont provides an overview of the latest InfiniDB capabilities and some best practices in deploying this columnar engine for scalable analytics environments.

    Presenter:

    • Jim Tommaney, CTO, Calpont
    VIEW WEBINAR

    Taming the Data Tsunami: Next-Gen Analytics Enable Effective Relationship Marketing

    In this webinar, James Taylor discusses the market trends impacting web analytics and their underlying data infrastructures, and provides direction for improving analytic performance as web data grows. Martin Smith discusses how TruEffect™ is lifting media performance for its customers through its next-generation media analytics, and how it has prepared to scale for the data tsunami by using the high-performance columnar database, Calpont InfiniDB, for its data warehouse.

    Presenters:

    • James Taylor, Decisioning and Analytics expert, CEO, Decision Management Solutions
    • Martin Smith, CTO, TruEffect
    VIEW WEBINAR

    Cognitive Match Drives Relevance and Conversion Results with InfiniDB

    Learn how Cognitive Match solved their client challenges of achieving conversion decisions with the Calpont InfiniDB database.

    VIEW WEBINAR

    InfiniDB Scaling MySQL Data Performance

    Learn how to reduce project time, effort and ownership costs of your MySQL deployments. By perserving proven integration between your applications and MySQL, InfiniDB is the ideal solution for scalable analytics, business intelligence and data warehousing. John Weber, VP Product Management shows how InfiniDB massively scales MySQL data and user concurrency while delivering 10 to 100 times faster performance to meet your business demands, now and into the future.

    VIEW WEBINAR

Videos

Presentations

    Ad Targeting Presentation

    by Jim Sterne, Target Marketing and Jim Tommaney, Calpont

    This presentations provides a glimpse at the challenges of leveraging online attributes, as well as the needs one must fulfill from Big Data in order to achieve ad targeting success. 

    DOWNLOAD

    Building High-Performance MySQL Query Systems and Analytic Applications

    by Robin Schumacher

    This though-provoking, industry-leading document details the importance of query and analytic applications, provides core recommendations for building fast query / analytic applications and shares practical techniques for creating high-performance query / analytic systems.

    Concludes by detailing how a columnar database structure like InfiniDB can help achieve the goals put forth by the core recommendations for high performance analytics.

    DOWNLOAD

    Making MySQL Great for Business Intelligence

    by Robin Schumacher, VP Products, Calpont

    This presentation provides a wealth of information on how to best make MySQL work for your business intelligence needs, including:

    • A quick overview of BI
    • A look at the right technology foundation
    • General physical MySQL design decisions that impact success
    • A look at row vs. column MySQL databases
    DOWNLOAD

InfiniDB Software

    InfiniDB for the Cloud
  • InfiniDB on Amazon Web Services® (AWS)VIEW DETAILS
  • InfiniDB for Apache Hadoop Amazon Web Services® (AWS)VIEW DETAILS

InfiniDB Documentation

BI Quick Start Guides

    R Statistical Computing Quick Start Guide

    This quick start guide covers using InfiniDB with R, CRAN (Comprehensive R Archive Network) project’s open-source statistical computing and data visualization environment. It details the steps needed to connect the two platforms and highlights simple statistical analyses. Please refer to the installation documents of both products for the proper procedures to get the products installed.

    The quick start guide contains the following implementation sections:

    1. Installation Requirements
    2. Starting R
    3. Connecting to InfiniDB
    4. Querying data
    5. Statistical Analysis in R
    6. Conclusion

    DOWNLOAD

    Pentaho Report Designer Quick Start Guide

    This quick start guide covers use of InfiniDB with Pentaho's community edition Report Designer by detailing the steps needed to connect the two platforms and the subsequent creation of a simple report. Please refer to the installation documents of both products for the proper procedures to get the products installed.

    This quick start guide contains the following sections to walk you through the process to quickly implement the Pentaho Report Designer with the ultra‐fast Calpont InfiniDB analytic database:

    1. Start Pentaho Report Designer
    2. Connect to InfiniDB
    3. Enter Query
    4. Select data for report
    5. Preview Data
    6. Preview Report
    7. Appendix 1: Data and MySQL Permissions

    DOWNLOAD

    JasperSoft Report Designer QuickStart Guide

    Please take a moment to fill out the form to access the InfiniDB with Jaspersoft's community edition iReport documentation.

    This quick start guide covers use of InfiniDB with Jaspersoft's community edition of iReport by detailing the steps needed to connect the two products and the subsequent creation of a simple report. Please refer to the installation documents of both products for the proper procedures to get the products installed. You will need to download the software before beginning the process documented in this guide.

    The quick start guide contains the following implementation sections:

    1. Start iReport
    2. Connect to InfiniDB
    3. Configure the datasource
    4. Create a report
    5. Create and load query
    6. Select fields for report
    7. Grouping data
    8. Preview Report
    9. Appendix ‐ Data and MySQL Permission

    DOWNLOAD

    Pentaho Spoon QuickStart Guide

    Please take a moment to fill out the form to access the InfiniDB with Pentaho's community edition of Spoon documentation.

    This quick start guide covers using InfiniDB with Pentaho's community edition of Spoon by detailing the steps needed to connect the two platforms and the subsequent creation of a simple report. Please refer to the installation documents of both products for the proper procedures to get the products installed.

    This Pentaho Spoon Quick Start Guide covers the steps using Spoon to start with a comma separated data file, moving it to the bulk data import directory used by cpimport, and then loading the data using cpimport into an InfiniDB instance.

    Sections covered:

    1. Create comma separated data file
    2. Start Pentaho Spoon
    3. Connect to InfiniDB
    4. Enter Query
    4. Select data for report
    5. Preview Data
    6. Preview Report
    7. Appendix 1: Data and MySQL Permissions

    DOWNLOAD

    InfiniDB Quick Start for BIRT

    Please take a moment to fill out the form to access the InfiniDB with Birt documentation.

    This quick start guide covers use of InfiniDB with BIRT by detailing the steps needed to connect the two together and creation of a simple report. Please refer to the installation documents of both products for the proper procedures to get the products installed.

    This quick start guide contains the following sections to walk you through the process to quickly implement the BIRT with the ultra‐fast Calpont InfiniDB analytic database:

    1. Start eclipse
    2. Open a New Project
    3. Select the Business Intelligence and Reporting Tools
    4. New Project Report
    5. New Project
    6. Data
    7. Data Sets

    DOWNLOAD

Analyst Reports

  • Open Source SQL-on-Hadoop Performance, Radiant AdvisorsDOWNLOAD