Preface

Hi, developers, database managers, administrators, and anyone interested in expanding the knowledge of proper database date and time modeling.

Data processing is an inseparable part of information technology. The relational paradigm is currently widespread, based on the entities and relationships powered by relational algebra. In this environment, two significant streams and structures can be identified – operational data, defined by transactions, and data analytics, defined by data warehouses. Thus, it is necessary to store and evaluate not only current valid data but also states that were valid in the past and future plans, right? Proper decision-making is based on complex data, reflecting the history and evolution of the object states, and future prognoses of the object values. Evidently, database object states must be timeline-referenced, and this is exactly the area that I aim at with this book.

In this book, I offer my many years of experience with Oracle Database, from the on-premises world to current cloud solutions. Oracle Database provides sophisticated solutions for large data tuple management, ensuring performance, optimization, security, and reliable data storage.

This book is a practical guide on how to define, manage, and operate date and time-delimited data, operated by the Oracle Database. I will drive you through a definition of temporality, the evolution of date and time management, and its specifics. All the chapters are practically oriented, focusing on the functions and conversions available, as well as limitations.

By understanding the principles of date and time modeling, definitions, and processing, extended by regional rules and habits, as well as time-zone references, you will get the opportunity to grow your business faster and spread your applications and information systems worldwide.

Enjoy reading and get inspired!