Oracle NoSQL Database

Oracle NoSQL

Oracle NoSQL Database is designed for today’s most demanding applications that require low latency responses, flexible data models, and elastic scaling for dynamic workloads. It supports JSON, Table and Key-Value datatypes running on-premise, or as a cloud service with on-demand throughput and storage based provisioning.

Oracle NoSQL Database Cloud Service is now a fully managed database service running on Gen 2 Oracle Cloud Infrastructure hardware.

Oracle NoSQL Database Cloud Service makes it easy for developers to build applications, delivering predictable single digit millisecond response times with data replication for high availability. The service offers ACID transactions, serverless scaling, comprehensive security, and low pay-per-use pricing for both on-demand and provisioned capacity modes, including 100% compatibility with on-premises Oracle NoSQL Database.

Oracle Nosql Examples

This repository stores a variety of examples demonstrating how to use the Oracle NoSQL Database.

Repo/Folder name Description
cluster_setup Deploying Oracle NoSQL Database on the Oracle Cloud Infrastructure deploy-nosql
examples-nosql-cluster-deployment Examples allowing you to learn how to deploy a NoSQL cluster/NoSQL store - the most popular topologies
examples-nosql-kvlocal example of Java Application embedding KVLocal
examples-nosql-java-direct-driver Examples using the nosql-java-direct-driver
examples-nosql-java-sdk Examples using the nosql-java-sdk
examples-nosql-node-sdk Examples using the nosql-node-sdk
examples-nosql-spring-sdk Examples using the nosql-spring-sdk
demo-livelab you can find the code used in our NoSQL LiveLabs workshops in this directory and more information here
demo-events The NoSQL team is delivering content in Webinars and Events around the world. You can also find the instructions for workshops showcased in NoSQL events and have more information here
SQL for Oracle NoSQL Database tutorial Getting started with SQL for Oracle NoSQL Database sql-for-nosql
terraform Provider for Oracle NoSQL Database tutorial This is a Terraform configuration that creates the NoSQL service on Oracle Cloud Infrastructure. nosql-cloud-devops

We also collected in this repository exciting content about How to use the Oracle NoSQL database with other OCI services - more information here. Source: Architecture Center Source: GitHub

NoSQL Developers 👨‍💻 👩‍💻

Tags: enhancement help wanted question idea show-and-tell

In the development world, practice makes the master. That is why you must find as many ways to practice as possible. Never stop learning.

We’ve enabled GitHub Discussions to provide a way for you to connect with other community members. We hope that you:

Ask questions.
Share ideas.
Engage with other community members.
Welcome others and are open-minded. Remember that this is a community we build together # Oracle NoSQL LiveLabs

NoSQL LiveLabs

Oracle LiveLabs gives you access to Oracle’s tools and technologies to run a wide variety of labs and workshops.

In the development world, practice makes master. That is why you must find as many ways to practice as possible. Never stop learning. Follow our LiveLabs

Those labs were specialled designed for Application Developers, Architects, Administrators and DevOps Engineers.

In the directory demo-livelab you can find the code used in our NoSQL LiveLabs workshops.

Oracle LiveLabs

Oracle LiveLabs gives you access to Oracle’s tools and technologies to run a wide variety of labs and workshops.

Experience Oracle’s best technology, live!

https://developer.oracle.com/livelabs

Oracle NoSQL Workshops and Examples

NoSQL Ideas

Oracle NoSQL Workshops

The NoSQL team is delivering content in Webinars and Events around the world.

You can find the code of workshops showcased in NoSQL events around the World (LiveLabs coming soon)

You can find also the instructions of workshops showcased in NoSQL events

Deploying Oracle NoSQL Database on the Oracle Cloud Infrastructure

Tags: deploy-nosql

See this script that simplifies the installation of Oracle NoSQL Database on the Oracle Cloud Infrastructure (OCI). This script lets a user set up a small cluster (1-10 machines) quickly, for use in proof-of-concepts, small on premise installations, and cluster installations in cloud environments (OCI, AWS, Azure). It’s easy to BYOL to the cloud environment of your choosing.

Read this whitepaper which explains how to easily install Oracle NoSQL Database on the Oracle Cloud Infrastructure (OCI).

Getting started with SQL for Oracle NoSQL Database

Tags: sql-for-nosql

Welcome to SQL for Oracle NoSQL Database tutorial.

The SQL for Oracle NoSQL Database data model supports flat relational data, hierarchical typed (schema-full) data, and schema-less JSON data. SQL for Oracle NoSQL Database is designed to handle all such data seamlessly without any impedance mismatch among the different sub-models. Impedance mismatch is the problem that occurs due to differences between the database model and the programming language model.

You have two different schemas ( with real-time scenarios) for learning various SQL concepts. These two schemas will include various data types that can be used in the Oracle NoSQL database.

Schema 1: BaggageInfo schema Using this schema you can handle a use case wherein passengers traveling on a flight can track the progress of their checked-in bags or luggage along the route to the final destination. This functionality can be made available as part of the airline’s mobile application. Once the passenger logs into the mobile application, the ticket number or reservation code of the current flight is displayed on the screen. Passengers can use this information to search for their baggage information. The mobile application is using NoSQL Database to store all the data related to the baggage. In the backend, the mobile application logic performs SQL queries to retrieve the required data.

Schema 2: Streaming Media Service - Persistent User Profile Store Consider a TV streaming application. It streams various shows that are watched by customers across the globe. Every show has a number of seasons and every season has multiple episodes. You need a persistent meta-data store that keeps track of the current activity of the customers using the TV streaming application. Using this schema you can provide useful information to the customer such as episodes they watched, the watch time per episode, the total number of seasons of the show they watched, etc. The data is stored in the NoSQL Database and the application performs SQL queries to retrieve the required data and make it available to the user.

The scripts allowing to run this tutorial are hosted in this Repository ( AcctStreamSchema and BaggageSchema ) but follow the instructions provided in the SQL for Oracle NoSQL Database tutorial

Terraform Provider for Oracle Cloud Infrastructure

Tags: nosql-cloud-devops

The Oracle Cloud Infrastructure (OCI) provider allows you to use Terraform to interact with Oracle Cloud Infrastructure resources. Wherever you use a Terraform distribution you can use the OCI Terraform provider, including Terraform Cloud and the OCI Resource Manager.

https://github.com/oracle/terraform-provider-oci

This is a Terraform configuration that creates the NoSQL service on Oracle Cloud Infrastructure.

https://github.com/oracle/terraform-provider-oci/tree/master/examples/nosql

Cloud Learning

NoSQL Developers 👨‍💻 👩‍💻

Tags: nosql-java-sdk nosql-node-sdk nosql-dotnet-sdk nosql-go-sdk nosql-python-sdk nosql-spring-sdk nosql-cloud-devops oci-functions oci-oke and more

Learn how to Develop Applications Fast and Effortlessly using our resources and videos in the Cloud Learning page

https://www.oracle.com/database/nosql/#rc30-cloud-learning

Other Examples and Resources

NoSQL Ideas

Process media by using serverless job management and ephemeral compute workers

Source: Architecture Center

Tags: nosql-python-sdk oci-functions

Processing large media files can be a resource intensive operation requiring large compute shapes for timely and efficient processing. In scenarios where media processing requests might be ad-hoc and on-demand, leaving instances idle while waiting for new work is not cost effective.

By utilizing Oracle Cloud Infrastructure’s (OCI) server-less capabilities, including OCI Functions and OCI NoSQL, we can quickly create a management system for processing media content using ephemeral OCI Compute workers.

https://docs.oracle.com/en/solutions/process-media-using-oci-services/index.html

Note: You can deploy this pattern using downloadable code or automated provisioning, as described in the Download or Deploy section in the link above.

oci wearable health app

Source: GitHub

Tags: nosql oci

The sample application is an IoT use-case, in which an application capturing health parameters running on a wearable device is sending health statistics to a device gateway (backend) hosted on OCI on regular intervals. The complete use-case can be split into 3 different parts:

https://github.com/oracle-devrel/oci-wearable-health-app

Oracle Cloud Infrastructure Data Flow Samples

Source: GitHub

Tags: nosql-python-sdk oci-data flow

Oracle Cloud Infrastructure (OCI) Data Flow is a cloud-based serverless platform with a rich user interface. It allows Spark developers and data scientists to create, edit, and run Spark jobs at any scale without the need for clusters, an operations team, or highly specialized Spark knowledge. Being serverless means there is no infrastructure for you to deploy or manage. It is entirely driven by REST APIs, giving you easy integration with applications or workflows

Oracle NoSQL Database cloud service : This application shows how to interface with Oracle NoSQL Database cloud service.

https://github.com/oracle-samples/oracle-dataflow-samples/

Train and deploy models from massive data sets: fraud detection use case

Source: Architecture Center

As your business goes through digital transformation and increasingly accepts online payment, effective methods to detect and eventually prevent credit card fraud are necessary to avoid losses. Since fraud is expected to account for a small fraction of all transactions, massive amounts of data are typically needed to build a robust and accurate model capable of alerting of fraud with minimal false positives.

https://docs.oracle.com/en/solutions/models-credit-card-fraud-detection/index.html

Employ anomaly detection for managing assets and predictive maintenance

Source: Architecture Center

Anomaly detection is the identification of rare items, events, or observations in data that greatly differ from expectations. This has uses in many industries for asset monitoring and maintenance.

Anomaly Detection Service helps you detect anomalies in time series data without the need for statisticians or machine learning experts. It provides prebuilt algorithms, and it addresses data issues automatically. It is a cloud-native service accessible over REST APIs and can connect to many data sources. The OCI Console, CLI, and SDK make it easy for use in end-to-end solutions.

https://docs.oracle.com/en/solutions/anomaly-detection/index.html

Oracle Architecture Center

Reference architectures and best practices

Leverage knowledge from Oracle experts. Use our reference architectures, solution playbooks, and customer stories to build and deploy your cloud, hybrid, and on-premises workloads.

Explore Oracle Architecture Center

Contributing

This project welcomes contributions from the community. Before submitting a pull request, please review our contribution guide

Security

Please consult the security guide for our responsible security vulnerability disclosure process

License

Copyright (c) 2018, 2023 Oracle and/or its affiliates.

Released under the Universal Permissive License v1.0 as shown at https://oss.oracle.com/licenses/upl/.