Search icon CANCEL
Subscription
0
Cart icon
Your Cart (0 item)
Close icon
You have no products in your basket yet
Save more on your purchases! discount-offer-chevron-icon
Savings automatically calculated. No voucher code required.
Arrow left icon
Explore Products
Best Sellers
New Releases
Books
Videos
Audiobooks
Learning Hub
Free Learning
Arrow right icon
Arrow up icon
GO TO TOP
Developing Robust Date and Time Oriented Applications in Oracle Cloud

You're reading from   Developing Robust Date and Time Oriented Applications in Oracle Cloud A comprehensive guide to efficient date and time management in Oracle Cloud

Arrow left icon
Product type Paperback
Published in May 2023
Publisher Packt
ISBN-13 9781804611869
Length 464 pages
Edition 1st Edition
Languages
Concepts
Arrow right icon
Author (1):
Arrow left icon
Michal Kvet Michal Kvet
Author Profile Icon Michal Kvet
Michal Kvet
Arrow right icon
View More author details
Toc

Table of Contents (26) Chapters Close

Preface 1. Part 1: Discovering Oracle Cloud
2. Chapter 1: Oracle Cloud Fundamentals FREE CHAPTER 3. Chapter 2: Data Loading and Migration Perspectives 4. Part 2: Understanding the Roots of Date and Time
5. Chapter 3: Date and Time Standardization Principles 6. Chapter 4: Concepts of Temporality 7. Part 3: Modeling, Storing, and Managing Date and Time
8. Chapter 5: Modeling and Storage Principles 9. Chapter 6: Conversion Functions and Element Extraction 10. Chapter 7: Date and Time Management Functions 11. Chapter 8: Delving into National Language Support Parameters 12. Part 4: Modeling Validity Intervals
13. Chapter 9: Duration Modeling and Calculations 14. Chapter 10: Interval Representation and Type Relationships 15. Chapter 11: Temporal Database Concepts 16. Chapter 12: Building Month Calendars Using SQL and PL/SQL 17. Part 5: Building Robust and Secure Temporal Solutions
18. Chapter 13: Flashback Management for Reconstructing the Database Image 19. Chapter 14: Building Reliable Solutions to Avoid SQL Injection 20. Part 6: Expanding a Business Worldwide Using Oracle Cloud
21. Chapter 15: Timestamp Enhancements 22. Chapter 16: Oracle Cloud Time Zone Reflection 23. Assessments 24. Index 25. Other Books You May Enjoy

Oracle Cloud Fundamentals

In the past, data was stored in a local server room with limited expansion opportunities. Each server had a specific hardware capability. Upgrades were often costly and technically demanding, resulting in the need to buy new equipment. Later, distributed architectures were created to ensure robustness and resilience, but one way or another, the solution was not so complex and robust. Scalability can partially be achieved by dynamically reacting to the current and expected workload; however, cloud storage and databases provide the technical foundation needed for easy scalability. In terms of Oracle Cloud databases, autonomous management and technologies are a significant milestone.

Automation is now present almost everywhere, whether in smart devices and smartphones, modern cars full of sensors that are partially operated autonomously, or smart homes and cities, including advanced functions associated with Machine Learning (ML), Artificial Intelligence (AI), or the Internet of Things (IoT). Autonomous Databases (ADBs) go even further by providing a complex environment for your data handling, apps, and services to produce effective outcomes, reducing the costs and time required to set parameters, optimize the configuration, and so on.

As a business expands, the amount of data to be handled grows exponentially. It will no longer be sufficient to only cover current valid data. Historical data needs to be stored, manipulated, and evaluated, either in an original form or analytically aggregated in data warehouses, marts, or other analytical structures. As the data quantity grows, it cannot be managed manually by one local machine. It is necessary to ensure availability in an error-prone environment. Thus, additional servers must be employed to serve as backups, standby, and so on. The whole environment needs to be secured and properly interconnected over networks.

Managers and administrators have also realized that putting whole structures in one building is neither suitable nor secure, resulting in the need to rent other server rooms, usually geographically distributed rooms. That’s exactly where the cloud comes into play. The entire administration, securing, distribution, and backup strategies are moved to the cloud environment, so we arrive at the concept of autonomous processing here again.

In this chapter, we’re going to cover the following main topics:

  • Oracle Cloud core concepts and the Always Free option
  • Defining Oracle ADBs and their types and principles
  • Deployment models and database architectures
  • Process of database provisioning and connecting
  • Database system architecture overview – database and instance levels

Note that the source code can be found in the GitHub repository accessible via this web address: https://github.com/PacktPublishing/Developing-Robust-Date-and-Time-Oriented-Applications-in-Oracle-Cloud/tree/main/chapter%2001.

Alternatively, you can scan the following QR code as well:

You have been reading a chapter from
Developing Robust Date and Time Oriented Applications in Oracle Cloud
Published in: May 2023
Publisher: Packt
ISBN-13: 9781804611869
Register for a free Packt account to unlock a world of extra content!
A free Packt account unlocks extra newsletters, articles, discounted offers, and much more. Start advancing your knowledge today.
Unlock this book and the full library FREE for 7 days
Get unlimited access to 7000+ expert-authored eBooks and videos courses covering every tech area you can think of
Renews at $19.99/month. Cancel anytime
Banner background image