Preface

• Who this book is for
• What this book covers
• To get the most out of this book
• Download the example code files
• Download the color images
• Conventions used
• Get in touch
• Share Your Thoughts

1. Part 1: Discovering Oracle Cloud

2. Chapter 1: Oracle Cloud Fundamentals FREE CHAPTER

• Oracle Cloud concepts
• Types of ADBs
• Understanding the deployment models
• Shared versus dedicated architecture
• Oracle Cloud terminology
• Database provisioning
• Connecting to the ADB
• Database system architecture overview
• Summary
• Questions
• Further reading

3. Chapter 2: Data Loading and Migration Perspectives

• Understanding SQL Loader
• Getting to know client-side import/export
• Examining server-side import/export using dump files
• Understanding Transportable Tablespace Data Pump
• Exploring migration techniques
• Summary
• Questions
• Further reading

4. Part 2: Understanding the Roots of Date and Time

5. Chapter 3: Date and Time Standardization Principles

• Understanding relational database integrity
• The ISO 8601 standard
• Date value definition
• Time element modeling and management
• Composite date and time value
• Periods of time
• Summary
• Questions
• Further reading

6. Chapter 4: Concepts of Temporality

• What is temporality?
• Introducing DST
• Introducing UTC
• Time zone perspective
• Gregorian versus Julian calendar
• Leap years in the Gregorian calendar
• Leap second
• Summary
• Questions
• Further reading

7. Part 3: Modeling, Storing, and Managing Date and Time

8. Chapter 5: Modeling and Storage Principles

• Exploring data types
• Exploring constructor functions
• Storing the date as an INTEGER value
• Getting the actual date and time values
• Getting to know DATE arithmetic
• Understanding the INTERVAL data type
• TIMESTAMP arithmetic
• Summary
• Questions
• Further reading

9. Chapter 6: Conversion Functions and Element Extraction

• Understanding the TO_CHAR and TO_DATE conversion functions
• Understanding the EXTRACT function
• Reliability and integrity issues
• Investigating the CAST function
• Validating conversions
• Summary
• Questions
• Further reading

10. Chapter 7: Date and Time Management Functions

• Getting to know the ADD_MONTHS function
• Identifying the number of days in a month using LAST_DAY
• Understanding the usage of the MONTHS_BETWEEN function
• Exploring the NEXT_DAY and NEXT_DATE functions
• Investigating the TRUNC function
• Understanding the usage of the ROUND function
• Understanding the PERSONAL_ID concept and birthday management
• Generating random dates
• Summary
• Questions
• Further reading

11. Chapter 8: Delving into National Language Support Parameters

• NLS parameter overview
• Exploring NLS parameters and their impact
• Embedding NLS parameters in the TO_CHAR function
• Other NLS parameters
• Summary
• Questions
• Further reading

12. Part 4: Modeling Validity Intervals

13. Chapter 9: Duration Modeling and Calculations

• What timepoint means and how to use it
• Deploying duration models using timepoint borders
• Modeling unlimited validity
• Summary
• Questions
• Further reading

14. Chapter 10: Interval Representation and Type Relationships

• Relationships between time interval representations
• Using positional relations in temporal space
• Modeling temporal validity using Oracle Database’s embedded PERIOD
• Summary
• Questions
• Further reading

15. Chapter 11: Temporal Database Concepts

• The origin and evolution of temporal models
• The object-oriented temporal approach
• The temporal aspect of management
• Temporal system requirements
• Exploring temporal dimensions
• The attribute-oriented approach
• The group-level temporal system
• Conventional table with time-delimited attributes
• Summary
• Questions
• Further reading

16. Chapter 12: Building Month Calendars Using SQL and PL/SQL

• Defining a calendar using PL/SQL
• Modeling a calendar using SQL
• Name day management
• Summary
• Questions
• Further reading

17. Part 5: Building Robust and Secure Temporal Solutions

18. Chapter 13: Flashback Management for Reconstructing the Database Image

• Transaction as a change vector source
• Transaction log structure and log types
• Reconstructing states using Flashback technology
• Summary
• Questions
• Further reading

19. Chapter 14: Building Reliable Solutions to Avoid SQL Injection

• Understanding SQL injection
• Solutions to limit SQL injection
• Summary
• Questions
• Further reading

20. Part 6: Expanding a Business Worldwide Using Oracle Cloud

21. Chapter 15: Timestamp Enhancements

• Applying time zones for the server and client sides
• TIMESTAMP and transformation across time zones
• Transforming DATE values across multiple time zones using the NEW_TIME function
• TIMESTAMP normalization
• Local value reflection using TIMESTAMP data type extensions
• Local versus global expansion
• Summary
• Questions
• Further reading

22. Chapter 16: Oracle Cloud Time Zone Reflection

• Summarizing time zone management
• Exploring SQL translation profiles
• Simplifying time zone management shift using SYSDATE_AT_DBTIMEZONE
• Summary
• Questions
• Further reading

23. Assessments

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

24. Index

• Why subscribe?

25. Other Books You May Enjoy

• Packt is searching for authors like you
• Share Your Thoughts
• Download a free PDF copy of this book