infobright.org
Joinutility seperatorLogin utility separator Infobright.com
Home  > Data Warehousing

Data Warehousing

15
Sep

MySQL CheatSheets Helpful

Bob Zurek's photo
by Bob Zurek     Tue, Sep 15, 2009

OK, so most of you know that I lived in the world of PostgreSQL for several years before moving into the world of Infobright and MySQL. With that in mind, I've been determined to continue to hone my skills around MySQL as it serves as the primary interface on top of our open source columnar data warehousing engine. Yes, I've hacked around with MySQL for many years and was of the first OEM'rs of MySQL when I was at Ascential. I even created a website on the side called www.MyCollegeFAQ.com that is based on MySQL. It is  a free (no advertising) and open site that is used to help high school and college students get answers to their frequent asked questions about getting into college. Always had an affinity towards the MySQL database but other efforts led me to PostgreSQL. One tool that I've found helpful these days is the MySQL Cheat Sheet that is installed on my iPod Touch. It was developed by the folks at Concentric Sky. This handy reference tools is a great companion reference for all the various commands, data types, sql formats, etc. for MySQL. They say that if you study something for 10,000 hours, you become an expert. Let me say, I'm not quite 10,000 hours into MySQL, thus the Cheat Sheet. If you are interested in getting the Cheat Sheet, it is on the Apple App Store. This is not just a reference to a website tuned for Safari on the iPod Touch or iPhone, it is a simple and easy to use application that is a growing dictionary for MySQL reference information that is continually updated. It's 0.99 and well worth it. Enjoy. 

Infobright   Comments (0)
Infobright     Tags: 10,000+hours, concentric+sky, infobright, iphone, ipod+touch, mysql, mysql+cheat+sheets
11
Sep

Infobright On The Cloud

Bob Zurek's photo
by Bob Zurek     Fri, Sep 11, 2009

Cloud computing to Infobright is somewhat analogous to supporting an operating platform and yes, we support the deployment of our market leading open source columnar database on the cloud and more specifically using an open cloud manifesto approach. The good news is that Amazon has continued to lead the way when it comes to supporting a businesses (whether small, medium or large) cloud initiative and Infobright is happy to support our open source columnar database on the Amazon cloud.

These days some data warehouse solutions in the market put proprietary and complex wrappers around their cloud offering. With their approach, you are not in control, they are in control and with a proprietary approach, they end up locking you in and who knows who is going to touch or view your highly sensitive data. At Infobright, we take the opposite approach. We believe strongly in openness and also believe that the customer should be in control of their cloud data warehouse efforts, especially with the types of critically important and sometimes highly sensitive data stored in the warehouse or mart. For us, it is a matter of guiding our customers on how to take advantage of cloud infrastructure and solutions and putting you in control with information to assist in your efforts. If cloud solutions such as monitoring, management, deployment technologies are truly open, then they should easily integrate with other open technologies such as Infobright. To assist you, we have developed a document containing instructions on how to get Infobright running on the Amazon cloud. With this approach, you are totally in control. What follows is a link to these instructions. If Cloud is a consideration, we believe you should consider an open and unrestricted approach, not one that involves a lock-in and proprietary approach. 

http://www.infobright.org/downloads/contributions/Amazon_Cloud_EC2_Instructions.pdf

Infobright   Comments (1)
Infobright     Tags: amazon, cloud, data+warehouse, ec2, infobright