Realizing Generic Data Warehouses by Generic SQL Programming: SQL Server Edition (In the Age of Big Data: Generically Data Warehousing) - Softcover

Jiang, Bin; Zheng, Yuelin; Wu, Xiyan; Wang, Dongjuan

Softcover

ISBN 10: 1530731070 ISBN 13: 9781530731077

Publisher: CreateSpace Independent Publishing Platform, 2016

Synopsis

This book is unique. It is the only one on the market that treats generic SQL Server 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 SQL Server. 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."

About this title

About the Author

Dr. Bin Jiang received his master's degree in Computer Science from the University of Dortmund/Germany in 1986. In 1992, he received his doctorate in Computer Science from ETH Zurich/Switzerland. During the research period, two of his publications in the field of database management systems were awarded as the best student papers at the IEEE Conference on Data Engineering in 1990 and 1992. Afterward, he worked for several major Swiss banks and insurance companies, and with one of the largest international data warehousing consulting firms as a system engineer, software developer and application analyst in the early years, and then as a senior data warehouse consultant and architect for more than twenty years. Last but not least, Dr. Jiang is one of the first Certified Teradata Masters of the world and a Distinguished Professor of China Three Gorges University.

Edition details

• Publisher: CreateSpace Independent Publishing Platform
• Publication date: 2016
• Language: English
• ISBN 10: 1530731070
• ISBN 13: 9781530731077
• Binding: Paperback
• Number of pages: 694