During 2009 we have posted a lot of article related to Data Warehouse, especially Oracle BIEE and Greenplum in this blog. In the end of this 2009, we would like to list the best of the best article according to user pageview. Here’s the top 7 article in the Data Warehouse Solutions blog:
1. Green Plum Features and Benefits
Greenplum Database provides many advantages over traditional data warehousing systems:
- Open Source
- Commodity Hardware
- Shared Nothing Architecture
- High Availability
- Workload Management
- Scalability and Flexibility
2. Greenplum: Open Source Data Warehouse
In 2005, Greenplum released an enterprise-level massively parallel processing (MPP) version of PostgreSQL called Greenplum Database. Greenplum Database is the industry’s first massively parallel processing (MPP) database server based on open-source technology. It is explicitly designed to support business intelligence (BI) applications and large, multi-terabyte data warehouses.
3. The Compelling Need For Data Warehousing
Why are companies rushing into data warehousing? Why is there a tremendous surge in interest? Data warehousing is no longer a purely novel idea just for research and experimentation. It has become a mainstream phenomenon. True, the data warehouse is not in every doctor’s office yet, but neither is it confined to only high-end businesses. More than half of all U.S. companies and a large percentage of worldwide businesses have made a commitment to data warehousing.
4. Pentaho as Open Source Business Intelligence
Pentaho is an open-source reporting application, with several enterprise capabilities such as chart generation, dashboards, data mining, and pivot table analysis. Pentaho is a 100% Java application, based on the JBOSS application server and JBOSS Portal for advanced user customization of dashboards.
5. Oracle BIEE Solution
The Most Comprehensive BI from the Worldwide Leader in Business Analytics Oracle Business Intelligence (BI) is the most comprehensive portfolio of technology and applications for enabling the insight-driven organization, including leading BI applications, BI platform technology, and data warehousing. With the #1 market share in business analytics, Oracle BI enables organizations to gain complete and timely insight, distribute intelligence pervasively, and drive more effective actions and processes.
6. How to Install Greenplum Database 3.3
We got the how to install Greenplum 3.3 from the Greenplum Documentation. Here are the steps to install and initialize Greenplum Database system.
7. Greenplum Database and PostgreSQL
The object-relational database management system known as PostgreSQL is derived from the POSTGRES package written at the University of California at Berkeley. With almost three decades of development behind it, PostgreSQL is now the most advanced open-source database available.