Realizing Generic Data Warehouses by Generic SQL Programming: Oracle Edition

Автор:  Bin Jiang
Издательство: CreateSpace Independent

Год: July 8, 2016
Страниц: 644
Язык: английский
ISBN: 1530509254


 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 enthusiastically welcome this latest stepping stone in the evolution that started a few decades ago."


Скачать книгу из интернета:

Вас заинтересует / Intresting for you:

SQL для чайников
SQL для чайников 5596 просмотров Алексей Вятский Tue, 21 Nov 2017, 13:26:01
T-SQL Fundamentals - 3rd Editi...
T-SQL Fundamentals - 3rd Editi... 1659 просмотров Алексей Вятский Mon, 05 Aug 2019, 05:39:41
Jump Start MySQL
Jump Start MySQL 1090 просмотров Алексей Вятский Thu, 17 Sep 2020, 13:11:06
MySQL Explained: Your Step By ...
MySQL Explained: Your Step By ... 1217 просмотров Алексей Вятский Sun, 04 Aug 2019, 11:57:44
Войдите чтобы комментировать