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 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.
"About this title" may belong to another edition of this title.
