Book Image

Developing Robust Date and Time Oriented Applications in Oracle Cloud

By : Michal Kvet
Book Image

Developing Robust Date and Time Oriented Applications in Oracle Cloud

By: Michal Kvet

Overview of this book

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.
Table of Contents (26 chapters)
1
Part 1: Discovering Oracle Cloud
4
Part 2: Understanding the Roots of Date and Time
7
Part 3: Modeling, Storing, and Managing Date and Time
12
Part 4: Modeling Validity Intervals
17
Part 5: Building Robust and Secure Temporal Solutions
20
Part 6: Expanding a Business Worldwide Using Oracle Cloud

Understanding the PERSONAL_ID concept and birthday management

PERSONAL_ID refers to a specific value assigned to people in Slovakia and the Czech Republic. It is a unique personal identification number formed of the person’s date of birth, gender, and a terminal number, which is a differentiating number for people born on the same day. In total, it consists of six digits followed by the slash symbol and another four digits.

The first two digits of PERSONAL_ID are the last two digits of the person’s year of birth. The second two digits express the numeric designation of the person’s month of birth (the value is increased by 50 for women). The third two-digit set represents the numerical designation of the person’s day of birth. This is an example of a man and woman:

--> 90 06 23 / 1234				90 56 23 / 1239
--> MAN						WOMAN
--> Year = 90					Year = 90
--> Month = 6					Month = 6
--> Day = 23					Day = 23

The whole personal identifier...