Developing Robust Date and Time Oriented Applications in Oracle Cloud: A comprehensive guide to efficient date and time management in Oracle Cloud

by Michal Kvet

Overview

Proper date and time management is critical for the development and reliability of Oracle Databases and cloud environments, which are among the most rapidly expanding technologies today. This knowledge can be applied to cloud technology, on premises, application development, and integration to emphasize regional settings, UTC coordination, or different time zones. This practical book focuses on code snippets and discusses the existing functionalities and limitations, along with covering data migration to the cloud by emphasizing the importance of proper date and time management. This book helps you understand the historical background and evolution of ANSI standards. You’ll get to grips with data types, constructor principles, and existing functionalities, and focus on the limitations of regional parameters and time zones, which help in expanding business to other parts of the world. You’ll also explore SQL injection threats, temporal database architecture, using Flashback Technology to reconstruct valid database images from the past, time zone management, and UTC synchronization across regions. By the end of this book, you’ll be able to create and manage temporal systems, prevent SQL injection attacks, use existing functionalities and define your own robust solutions for date management, and apply time zone and region rules.

Product Details

ISBN-13:	9781804619360
Publisher:	Packt Publishing
Publication date:	05/12/2023
Sold by:	Barnes & Noble
Format:	eBook
Pages:	464
File size:	12 MB
Note:	This product may take a few minutes to download.

About the Author

Michal Kvet is a researcher, educator, and database expert at the University of Žilina in Slovakia. His primary focus areas are databases, analytics, performance, and cloud computing. He works closely with Oracle and Oracle Academy. He is the co-author of multiple textbooks (a SQL and PL/SQL cookbook, a book on APEX application development, a book on temporal databases, and a MySQL cookbook), coordinates multiple Erasmus+ projects and co-organizes several research conferences and database workshops. Besides this, he supervises engineering projects and bachelor’s, master’s, and doctoral theses. Over the years, his research has been associated with date and time management and temporal databases. He has Oracle’s SQL, PL/SQL, Cloud, Analytics, and Administration certifications. His core knowledge of temporality is provided to you in this book.

Table of Contents

Table of Contents

1. Oracle Cloud Fundamentals
2. Data Loading and Migration Perspectives
3. Date and Time Standardization Principles
4. Concepts of Temporality
5. Modeling and Storage Principles
6. Conversion Functions and Element Extraction
7. Date and Time Management Functions
8. Delving into National Language Support Parameters
9. Duration Modeling and Calculations
10. Interval Representation and Type Relationships
11. Temporal Database Concepts
12. Building Month Calendars Using SQL and PL/SQL
13. Flashback Management for Reconstructing the Database Image
14. Building Reliable Solutions to Avoid SQL Injection
15. Timestamp Enhancements
16. Oracle Cloud Time-Zone Reflection