Open Source Data Warehousing and Business Intelligence is an all-in-one reference for developing open source based data warehousing (DW) and business intelligence (BI) solutions that are business-centric, cross-customer viable, cross-functional, cross-technology based, and enterprise-wide. Considering the entire lifecycle of an open source DW & BI implementation, its comprehensive coverage spans from basic concepts all the way through to customization. Highlighting the key differences between open source and vendor DW and BI technologies, the book identifies end-to-end solutions that are scalable, high performance, and stable. It illustrates the practical aspects of implementing and using open source DW and BI technologies to supply you with valuable on-the-project experience that can help you improve implementation and productivity. Emphasizing analysis, design, and programming, the text explains best-fit solutions as well as how to maximize ROI. Coverage includes data warehouse design, real-time processing, data integration, presentation services, and real-time reporting. With a focus on real-world applications, the author devotes an entire section to powerful implementation best practices that can help you build customer confidence while saving valuable time, effort, and resources.

Part I INTRODUCTORY CONCEPTS. Introduction. Embedded Programming-An Oracle-centric approach. Feature-Set and Solution-Set Enhancements. Part II BEST PRACTICES BY WAY OF DESIGN AND DEVELOPMENT. Programming Languages, Platforms and Solutions: Best Practices in terms of Choice and Suitability: How Best is the "Best?". Best Practices for Data Structure Management. Best Practices for Robust Error Detection and Handling. Best Practices for Data Management. Best Practices for Application Management. Part III APPLYING EMBEDDED PROGRAMMING IN THE REAL WORLD. Application Development Frameworks. Miscellaneous Best Practices. Best Practices for Troubleshooting. Embedded Programming Coding Standards.