Skip to main content
Have a personal or library account? Click to login
Developing Robust Date and Time Oriented Applications in Oracle Cloud Cover

Developing Robust Date and Time Oriented Applications in Oracle Cloud

A comprehensive guide to efficient date and time management in Oracle Cloud

Publisher:Packt Publishing Limited
By:   
Paid access
|Sep 2024
Product purchase options
This title is not yet available for download
Description

Create robust temporal solutions in Oracle Cloud and spread the solution worldwide by leveraging its regional properties and time zone synchronization
Purchase of the print or Kindle book includes a free PDF eBook

Key Features

  • Migrate existing on-premises applications to the Oracle Cloud environment using data migration techniques
  • Handle date and time values efficiently using Oracle database's available data types and duration modeling principles
  • Apply temporal database models in real-world systems to ensure robustness, security, and performance

Book Description

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.

What you will learn

  • Explore the fundamentals and terms related to Oracle Cloud Infrastructure (OCI) and data migration
  • Follow core principles and date and time element management supervised by ANSI standardization
  • Discover the limitations of existing functionalities and conversion methods
  • Build robust and secure temporal solutions that are resistant to SQL injection threats
  • Understand time zone management and regional settings by focusing on regional and national conventions and approaches
  • Use Flashback Technology to create temporal models in terms of historical and current states

Who this book is for

This book is for IT specialists, students, system developers, database administrators, and cloud integrators. With a hands-on approach, this book will help you to gain a comprehensive view of the issue of time processing and enable you to develop complex, robust applications that are usable and portable in any region.

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
https://github.com/PacktPublishing/Developing-Robust-Date-and-Time-Oriented-Applications-in-Oracle-Cloud
PDF ISBN: 978-1-80461-936-0
Publisher: Packt Publishing Limited
Copyright owner: © 2023 Packt Publishing Limited
Publication date: 2024
Language: English
Pages: 464
Related subjects:
Computer sciences,
Computer sciences, other
BISAC subjects:
COM021000,
TEC000000,
COM000000
Thema subjects:
UN,
TB,
UB

People also read