
As an Amazon Associate and affiliate partner, Menrva Books earns from qualifying purchases. Learn more
This book is unique. It is the only one on the market that treats generic Oracle SQL programming extensively and exclusively. Moreover, it is the only one on the market that provides a sophisticated, directly executable, i.e., copy-paste-run, bitemporal generic data warehouse that is capable of living in a real production environment based on Oracle Database. Generic programming, also known as meta-programming, is an art of programming that makes programs that make programs. Essentially, generic programming aims at reducing manual programming by program generation. Generic SQL programming is based on the so-called dynamic SQL. That is, SQL programs are dynamically composed during the execution of the generic programs that are also based on SQL. If you do not like monotonous, repetitive manual work, this book should be your favorite. Generic data warehouses represent the highest degree of agile data warehouses, i.e., those that can be fast and inexpensively changed and extended. In principle, generic data warehouses work independently of structures like architectures or data models you hotly debate on. If you find that your data warehouse is not agile enough, this book is your must-read. By doing so, you will get your new real-life data warehouse at once and almost for free. This happens without any expensive and laborious commercial data warehousing tools whose maintenance itself already presents a significant challenge. The conceptual fundament of this book is my first book of the series, i.e., "Constructing Generic Data Warehouses with Metadata-driven Generic Operators." In his foreword, Mr Bill Inmon, "the father of data warehousing," wrote: "When I read Dr. Jiang's book I was impressed by three things. I was impressed by the book's - - Completeness - Practicality - Innovation. Dr. Jiang's book represents the latest and the most complete step in the ongoing evolution of data warehousing. This book belongs on the desk of every serious practitioner. I enthusiastica
This book presents a unique approach to building generic data warehouses using Oracle SQL programming. The author, Bin Jiang, focuses exclusively on generic Oracle SQL programming, offering a directly executable, bitemporal generic data warehouse solution suitable for production environments. The core concept of generic programming, or meta-programming, is explained as the art of creating programs that generate other programs, aiming to reduce manual coding through program generation, primarily utilizing dynamic SQL. This method allows for the creation of highly agile data warehouses that can be rapidly and cost-effectively modified and extended, independent of specific architectural or data model choices.
The book is presented as a unique and innovative contribution to the field of data warehousing, particularly for its exclusive focus on generic Oracle SQL programming. The description highlights its practicality and the direct executability of its solutions, aiming to reduce manual programming efforts. As noted in the foreword by Bill Inmon, the book is recognized for its completeness, practicality, and innovation, positioning it as a valuable resource for serious data warehousing practitioners. The approach promises to deliver agile data warehouses that are adaptable and cost-effective compared to traditional commercial tools.
Page Count:
644
Publication Date:
2016-07-08
Publisher:
CreateSpace Independent Publishing Platform
ISBN-10:
1530509254
ISBN-13:
9781530509256
No comments yet. Be the first to share your thoughts!