www.infinidb.org

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 MySQLTM 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.

             | 

What’s the General Methodology for Migrating to InfiniDB from Other Databases?

Thursday, 22 October 2009 15:20 Levi
E-mail Print PDF

In general, the following roadmap is followed: 

Decide on the source database objects
Design InfiniDB objects
Move data from source system to InfiniDB
Transform code objects to InfiniDB (optional)

Moving schema structures over to InfiniDB isn’t normally a challenging task as InfiniDB supports most of the important datatypes.  For a complete description of datatype support in InfiniDB, see the InfiniDB SQL Syntax Guide. 
Once the source database metadata has been obtained and understood, the next step is to design the InfiniDB target database.  This involves translating the source objects and their properties (such as column datatypes) to InfiniDB complements.  
After the empty InfiniDB database has been created, you then can use a variety of methods to actually move the data from the source to the InfiniDB target.  Unloading data from the source can be done via the vendor’s supplied unload utilities/SQL interface, free/open source ETL tools, etc.