Glossary

ACL List

A Network Access Control List is a set of rules or permissions that define what network traffic is allowed to pass through a network device, such as a router, firewall, or gateway. ACLs are used to control and filter incoming and outgoing traffic based on various criteria such as IP addresses, port numbers, and protocols. They play a crucial role in network security by enabling administrators to manage and restrict network traffic to prevent unauthorized access, potential attacks, and data breaches.

ADMIN

A role that provides the highest level of access. You must have this role to create and manage database users, grant privileges, perform other administrative tasks, and manage the overall security and configuration of the database. This role grants full control over the database.

Bucket

Buckets are logical containers for storing objects. Users or systems create buckets as needed within a region. A bucket is associated with a single compartment that has policies that determine what actions a user can perform on a bucket and on all the objects in the bucket.

Client Server Architecture

In the Oracle Database system environment, the database application and the database are separated into two parts: a front-end or client portion, and a back-end or server portion. Therefore, the term client server architecture. The client runs the database application that accesses database information and interacts with a user. The server runs the Oracle software and handles the functions required for concurrent, shared data access to an Oracle database.

Conda

Conda is a cross-platform package and environment management system. It is used to install python and R packages in OML notebooks.

DBA

A predefined DBA role is automatically created with every Oracle Database installation. This role contains most database system privileges. Therefore, you should grant the DBA role only to actual database administrators. The DBA role does not include the SYSDBA or SYSOPER system privileges.

Module

A module is a python library or extension that typically gets installed through an OML notebook using the conda utility.

Object

Any type of data, regardless of content type, is stored as an object. An object is composed of the object itself and metadata about the object. Each object is stored in a bucket.

Object Storage

Object Storage is part of OCI (Oracle Cloud Infrastructure). It is an internet-scale, high-performance storage platform that offers reliable and cost-efficient data durability. The Object Storage service can store a large amount of unstructured data of any content type, including analytic data and rich content, like images and videos.

Object Storage is a regional service and is not tied to any specific compute instance. You can access data from anywhere inside or outside the context of the Oracle Cloud Infrastructure, as long you have internet connectivity and can access one of the Object Storage endpoints.

PQADMIN

A database role that allows you to store and manage user-defined Python functions in the OML4Py script repository.

PSUTIL

A cross-platform library for retrieving information on running processes and system utilization, such as CPU, memory, disks, network, and sensors, in Python. It is useful for system monitoring, profiling, limiting process resources, and the management of running processes.

Root user

The root user has unrestricted access to all files and directories on the system, allowing it to perform any action, including system administration tasks.

RQADMIN

A database role that allows you to create and manage user-defined R functions for embedded R execution.

SYS

When you create an Oracle database, the SYS user is automatically created and granted the DBA role.

• The SYS user is the most powerful user and should only be used for critical tasks, typically with the SYSDBA privilege.
• The SYS user owns the data dictionary and contains the core internal tables that the database needs to function.

All base tables and views for the database data dictionary are stored in the schema SYS. These base tables and views are critical for the operation of Oracle Database. To maintain the integrity of the data dictionary, tables in the SYS schema are manipulated only by the database. They should never be modified by any user or database administrator. Also, you should not create any tables in the schema of user SYS, although you can change the storage parameters of the data dictionary settings if necessary.

SYSDBA

A system privilege assigned to the SYS user. It allows high-level administrative tasks like starting and shutting down the database.

SYSTEM

When you create an Oracle Database, the user SYSTEM is also automatically created and granted the DBA role.

• The SYSTEM user can create additional tables and views that display administrative information as well as internal tables and views used by various Oracle Database options and tools.
• The SYSTEM user also has DBA privileges but is intended for administrative tasks like creating user-defined tables and views.
• Unlike SYS, the SYSTEM role is considered safe for routine DBA work.

Never use the SYSTEM schema to store tables of interest to nonadministrative users. A predefined DBA role is automatically created with every Oracle Database installation. This role contains most database system privileges. Therefore, you should grant the DBA role only to actual database administrators. The DBA role does not include the SYSDBA or SYSOPER system privileges.

Note:

SYSDBA and SYSOPER are administrative privileges required to perform basic database operations such as creating the database and instance startup and shutdown. Depending upon the level of authorization you require, you must have one of these privileges granted to you.

Wallet

A wallet is a secure password-protected container that provides a simple and easy way to manage database credentials across multiple domains. It allows you to update database credentials by updating the Wallet instead of having to change individual datasource definitions.

Wallet Manager

Oracle Wallet Manager is an application that wallet owners use to manage and edit the security credentials in their Oracle wallets. A wallet is a password-protected container used to store authentication and signing credentials, including private keys, certificates, and trusted certificates needed by SSL.