NuoDB Docs
NuoDB
NuoDB

NuoDB Docs

      • NuoDB At a Glance
      • Docker
      • Kubernetes
        • RPM Package Install
        • TAR File Install
      • New Features
      • Changes
      • Resolved Issues
      • Preview Features
      • Known Issues
      • Deprecated Features
      • End Of Life Features
        • NuoDB COMMUNITY EDITION SOFTWARE LICENSE AGREEMENT
          • Appendix A
        • NuoDB PROFESSIONAL SERVICES ADDENDUM
      • Legal Notices
        • Admin Platform
        • Networking
        • Atoms
        • Data Access and Replication
        • Archive Synchronization
        • Data Partitioning
      • Data Caching
        • Visibility
        • Commit Protocol
        • Vectorized Execution Engine
        • High-level SQL Pipeline
        • Data-To-Code Execution
        • Transactional DDL
        • System Requirements
          • Obtaining and Installing an Enterprise Edition License
            • Using the RedHat Package Manager to Install or Upgrade NuoDB
            • Using a Linux TAR File to Install NuoDB
            • Resolving Warnings About Previously Used NuoDB IDs
            • Post-Installation Tasks on Linux
            • Disabling Transparent HugePage (THP)
            • Using an EXE File to Install NuoDB on Windows
            • Using a ZIP File to Install NuoDB on Windows
            • Preparing to Upgrade
              • Upgrading With Databases Down
              • Rolling Upgrade: Databases Remain Available
            • Upgrading the Database Protocol
            • After You Upgrade
          • Downgrading to a Previous Release
            • Uninstalling NuoDB on Linux
            • Uninstalling NuoDB on Windows
          • Configuring NuoDB Admin
            • Generating Keystores and Truststores: Shared Admin Key
            • Generating Keystores and Truststores: Unique Admin Key
            • Using Certificates Signed by a Public Certificate Authority
            • Rotating Key Pair Certificates
            • Managing TLS Security
          • Creating the Domain and Adding Hosts
          • Starting and Stopping NuoDB Admin
            • Displaying Domain, Database, and Archive Status
            • Displaying Durable Domain Configuration Information
            • Displaying Database Process Information
            • Displaying Database Engine Attributes
          • Performing Health Checks on Domain and Database Status
          • Resetting the NuoDB Domain State
            • Determining if Admin Process (AP) Quorum Exists
            • Handling Unreachable Processes
            • Removing an Unreachable Admin Server from the Durable Domain
            • Re-establishing Admin Process (AP) Quorum
            • Creating an Archive
            • Creating a Database
            • Validating Database Archives
          • Confirming Domain and Database Status
          • Shutting down a Database
          • Restarting a Database
          • Starting a Storage Manager (SM)
          • Starting a Transaction Engine (TE)
          • Extending the Database Across Multiple Hosts (Scaling Out)
          • Adding and Shutting Down a Redundant Storage Manager (SM)
          • Restoring a Database Using an Archive
          • Deprovisioning Hosts in a Multi-Host Configuration (Scaling In)
            • General Steps for Backing Up Databases
                • Copying the Archive and Journal of the Shutdown Storage Manager (SM)
              • Using Hot Copy Successfully
              • Using Simple Hotcopy
              • Using Backup Sets
              • Using Full Hot Copy
              • Using Incremental Hot Copy
              • Using Journal Hot Copy
              • Hot Copy Command Formats
              • Restoring Data From Backup Sets
              • Example of Hot Copy Running
              • Example of Hot Copy Log Message
              • Examples of Hotcopy Errors
              • Example of Hotcopy Success
          • Deleting Databases
          • Database Management - A Working Example
          • Connection Properties
          • Default Ports (NuoDB Admin)
          • REST API Reference (NuoDB Admin)
        • System Requirements
        • Installing NuoDB
        • Enabling TLS in Containerized Environments
        • Automatic Management of NuoDB State
        • Scaling Down the Admin Layer without Kubernetes-Aware Admin
      • Durable Domain Configuration
      • Domain Credentials
      • Admin Process (AP)
      • Admin Process (AP) Quorum
      • Maintaining Admin Process (AP) Quorum
      • User Authentication and Authorization
        • Configuring Transparent Data Encryption
        • Transparent Data Encryption Error Codes
        • Privileges of the Database Administrator
        • Connect to a database Using TLS and LDAP
        • User Authentication Using LDAP
        • Users and Roles
        • Schema Access Levels
        • Assign Database Access Levels
        • Examples of Assigning Database Access Levels
        • Manage Database Schemas
        • Manage Database Tables
        • Manage Other Database Objects
        • About Commit Protocols
        • About Commit Protocols and Recoverability
        • About the Safe Commit Protocol
      • Database Journaling
        • Introduction to Table Partitions and Storage Groups
        • Use Cases for Table Partitions and Storage Groups
        • Storage Group Rules
        • Table Partition Rules
          • Rules for Adding and Removing Storage Groups
          • Adding a Storage Group to an Archive
          • Removing a Storage Group from an Archive
          • Deleting a Storage Group from a Database
        • Managing Table Partitions
        • Example of Using Storage Groups and Table Partitions
      • Restoring a Database Using an Archive
        • Terminology
        • Pros and Cons
        • Setup
        • Normal Operation
        • Disaster Recovery
        • Disaster Recovery Using Handoff - Example
      • Reducing Memory Pressure on Transaction Engines (TEs)
      • Setting Client Connection Limits for Transaction Engines (TEs)
      • pynuoadmin Management Client Package Setup
      • Validating Database Archives
      • Useful SQL Metrics Related to Database Operation
      • Useful System Tables Related to Database Operation
      • Load Balancer Policies
        • Drivers in the NuoDB Client Package
        • NuoDB Community Drivers
        • NuoDB Drivers Available at Other Public Sites
        • Database Operations Using C++ Driver
        • Enabling TLS in the C++ Driver
        • Notes for Using C++ Driver
        • Examples of Using C++ Driver
        • C++ Driver API Reference
        • Database Operations Using Java JDBC Driver
        • Enabling TLS in the JDBC Driver
          • Specifying Properties on the Connection URL
          • Configuring a NuoDB DataSource
          • Third Party DataSources
          • Using try-with-resources
          • JDBC Transaction Isolation Levels Supported by NuoDB
          • Canceling a Statement
          • Working with Timeouts
          • Logging
          • Exception Handling
          • ResultSet Shelf Life
          • Setting Result Set Holdability
          • LOB Streaming
          • JDBC and XA Transactions Using NuoDB
          • Direct Transaction Engine Connection
          • Using Timestamps and Time Zones
        • Examples of Using Java JDBC Driver
        • Java DataSource API Reference
        • Hibernate Dialect Considerations
        • Connecting to a Database Using Java Hibernate Driver
        • Using JNDI
        • Example of Using Java Hibernate Driver
        • Using ADO.NET Driver Objects Directly
        • Database Operations Using ODBC Driver
        • Notes for Using ODBC Driver
        • Enabling TLS in the C Driver
        • Database Operations Using C Driver
        • Notes for Using C Driver
        • Example of Using C Driver
        • C Driver API Reference
      • Sample NuoDB Programs on GitHub
      • Rules for Specifying NuoDB Identifier Names
          • Changing Default Transaction Behavior
          • Overriding Default Transaction Behavior
        • About Lock Behavior
          • About Implicit Transactions
          • About Explicit Transactions
        • Transaction Behavior in SQL Stored Procedures
        • Explicit Transactions and Rollback Modes
          • Description of NuoDB Transaction Isolation Levels
          • Examples of Reading Data After a Concurrent Transaction Updates Data
          • Examples of Selecting Data for Update After a Concurrent Transaction Updates Data
          • Examples of Updating a Row That is Being Updated by a Concurrent Transaction
          • Examples of Concurrent Updates That Do Not Overlap
          • JDBC Transaction Isolation Levels Supported by NuoDB
          • Behavior If Connection to a Database is Lost
          • Behavior If NuoDB Throws an Exception
        • About INNER Join Operations
        • About LEFT OUTER Join Operations
        • About CROSS Join Operations
        • About Multiple Join Operations
        • Using Conditions to Control the Flow of Execution
        • Using Loops to Control the Flow of Execution
          • Variables
          • SQL Procedural Conditional Statements
          • Control Flow
          • Dynamic SQL
          • Comments
        • Creating Database Objects in Stored Procedures
          • DECLARE Cursor
          • OPEN Cursor
          • FETCH Cursor
          • FETCH_STATUS
          • Update and Delete Using WHERE CURRENT OF
          • CLOSE Cursor
          • DEALLOCATE Cursor
          • Examples Using Cursors
        • Using a Result Set as Input to a Stored Procedure
          • Returning a Result Set from a Stored Procedure
          • Returning Multiple Result Sets from a Stored Procedure
          • Using Embedded Java Stored Procedures
          • Using Embedded Java Triggers
          • Using Embedded Java User Defined Functions
          • Unsupported Methods in Embedded Java API
        • About the SELECT List of an Updatable View
        • About the FROM Clause of an Updatable View
        • About the WHERE Clause of an Updatable View
        • Examples of Creating and Updating Views
      • Investigating Hung Queries
      • Understanding EXPLAIN Command Output
        • Identifying Historical Slow Queries Using System Tables
        • Identifying Currently Running Slow Queries Using System Tables
        • Obtaining SQL Elapsed Time Report
        • Running ANALYZE to Obtain Index Statistics
          • Identifying Index Usage (EXPLAIN)
          • Obtaining NuoDB Optimizer Estimates
          • Obtaining Index Use Statistics
        • Using Optimizer Hints
        • Configuring NuoDB SQL
        • Command Line Editing With NuoDB SQL
          • About the NuoDB SQL Configuration File
          • About the NuoDB SQL History File
          • Using the NuoDB SQL Init File
        • Using Command Line History in NuoDB SQL
        • Paginating NuoDB SQL Output
        • Displaying NuoDB SQL Output Vertically
        • Batch Processing with NuoDB SQL
        • Examples with NuoDB SQL
      • Internationalization and Localization
      • Tuning Tips for System Configuration
      • Tuning Tips for NuoDB Configuration
      • Tuning Tips for Database Design
      • Tuning Tips for Journal Performance
      • Troubleshooting with NuoDB Command
        • Connection Timed Out with Java IOException
        • No Such Database Name Error
        • No Available Nodes Error
      • Identifying and Killing Long-Running Queries
      • Messages Displayed in Relation to Connections Supported
        • About Log Entry Format
        • About Dynamic or On-Demand Logging
        • About Default Logging
        • About NuoDB Admin Logging
        • Description of Logging Options
        • Cannot Start Transaction Engine (TE) Without a Storage Manager (SM)
        • Inconsistent Statistic for Index
        • Insufficient Storage Managers (SMs) to Start Transaction
        • Storage Manager (SM) Startup Failure: Attempt to Initialize Exisiting Archive
        • Transaction Engine (TE) or Storage Manager (SM) Quits Unexpectedly
      • Basic Regular Expression Constructs
        • Host Properties (nuoadmin.conf)
        • Data Type Mappings (nuodb-types.config)
        • Database Configuration for a Particular Host (nuodb.config)
        • JVM Options (jvm-options)
          • NuoDB Archive - Checking
          • NuoDB Archive - Restoring
          • NuoDB Command Reference
          • Docker-specific NuoDB Command Reference
        • NuoDB Loader
          • Downloading NuoDB Migrator Source Code
          • NuoDB Migrator Properties File
          • About NuoDB Migrator Commands
            • NuoDB Migrator Mappings for DEFAULT Values
            • NuoDB Migrator Mappings for MySQL Unsigned Types
            • NuoDB Migrator Mappings for Unsupported Types
            • NuoDB Migrator Mappings for Supported Types
            • Dumping a Source Database to be Migrated
            • Loading Dumped Files into NuoDB Target Database
            • Generating DDL SQL Statement Scripts for Migrated Data
            • Example of Migrating From IBM DB2
            • Example of Migrating From MSSQL
            • Example of Migrating From MySQL
            • Example of Migrating From Oracle
            • Example of Migrating From PostgreSQL
          • Using NuoDB Migrator to Copy NuoDB Databases
            • Overriding NuoDB Migrator Type Mappings
            • Examples of NuoDB Migrator Schema Command
            • Troubleshooting Migration Metadata Error During Schema Generation
          • NuoDB Migrator Dump Command
          • NuoDB Migrator Load Command
        • NuoDB SQL
      • Database Options
      • Environment Variables
        • NuoDB Admin Log Description
        • NuoDB Admin Event Log
        • NuoDB Admin Audit Log
        • SQL Connections Log
        • Crash Directory Description
        • Engine Stop Log Description
      • Metrics Published by Database Processes
        • SQL Internationalization and Localization
          • SQL String and Character Types
          • SQL Numeric Types
          • SQL Date and Time Types
          • SQL Boolean Types
          • SQL Binary Types
          • Implicit Conversions for INSERT and UPDATE Statements
        • SQL Error Codes
          • SQL Aggregate Functions
          • SQL Comparison Operators
          • SQL Conditional Expressions
          • SQL Data Type Conversion Functions
          • SQL Date and Time Functions and Operators
          • SQL JSON String Functions
          • SQL Logical Operators
          • SQL Mathematical Functions and Operators
          • SQL Pattern Matching
          • SQL String Functions and Operators
          • SQL System Information Functions
          • SQL Window Functions
        • SQL Keywords
        • SQL Standard Compliance
          • ALTER DATABASE
          • ALTER FUNCTION
          • ALTER PROCEDURE
          • ALTER SEQUENCE
          • ALTER TABLE
          • ALTER TRIGGER
          • ALTER USER
          • ALTER VIEW
          • ANALYZE
          • CALL
          • COMMIT
          • CREATE FUNCTION
          • CREATE INDEX
          • CREATE PROCEDURE
          • CREATE ROLE
          • CREATE SCHEMA
          • CREATE SEQUENCE
          • CREATE TABLE
          • CREATE TRIGGER
          • CREATE USER
          • CREATE VIEW
          • DELETE
          • DROP FUNCTION
          • DROP INDEX
          • DROP PROCEDURE
          • DROP ROLE
          • DROP SCHEMA
          • DROP SEQUENCE
          • DROP TABLE
          • DROP TRIGGER
          • DROP USER
          • DROP VIEW
          • EXECUTE
          • EXPLAIN
          • GRANT
          • HELP
          • INSERT
          • KILL CONNECTION
          • KILL STATEMENT
          • LOCK
          • MAP PARTITION
          • RELEASE SAVEPOINT
          • RENAME TABLE
          • REPLACE
          • REVOKE
          • ROLLBACK
          • SAVEPOINT
          • SELECT
          • SET
          • SHOW
          • START TRANSACTION
          • TRUNCATE
          • UNMAP PARTITION
          • UPDATE
          • USE
        • SQL System Properties
          • ALLSYSTEMFIELDS System Table Description
          • ALLSYSTEMTABLES System Table Description
          • CONNECTIONS System Table Description
          • CONNECTIONSTATEMENTS System Table Description
          • DATATYPES System Table Description
          • DEFAULTSTORAGEGROUPS System Table Description
          • DUAL System Table Description
          • FIELDS System Table Description
          • FOREIGNKEYS System Table Description
          • FORMATS System Table Description
          • FUNCTIONCOLUMNS System Table Description
          • FUNCTIONS System Table Description
          • GLOBALATOMS System Table Description
          • INDEXES System Table Description
          • INDEXFIELDS System Table Description
          • INDEXHISTOGRAMBUCKETS System Table Description
          • INDEXHISTOGRAMS System Table Description
          • INDEXPREFIXSTATISTICS System Table Description
          • INDEXSTATISTICS System Table Description
          • JAVACLASSES System Table Description
          • LASTSTATEMENT System Table Description
          • LOCALATOMS System Table Description
          • LOCALATOMSEQUENCES System Table Description
          • LOCALCONNECTIONS System Table Description
          • LOCALINDEXATOMS System Table Description
          • LOCALQUERYTIMEOUTS System Table Description
          • LOCALSTATEMENTS System Table Description
          • LOCALTABLEATOMFIELDS System Table Description
          • LOCALTABLEATOMS System Table Description
          • LOCALTRANSACTIONALLOCKS System Table Description
          • LOCALTRANSACTIONS System Table Description
          • MEMPROPERTIES System Table Description
          • NODES System Table Description
          • NODESTORAGEGROUPS System Table Description
          • OPENRESULTS System Table Description
          • PARTITIONCRITERIA System Table Description
          • PARTITIONEDTABLES System Table Description
          • PARTITIONIDS System Table Description
          • PASSWORDS System Table Description
          • PRIVILEGES System Table Description
          • PRIVTYPES System Table Description
          • PROCEDURECOLUMNS System Table Description
          • PROCEDURES System Table Description
          • PROPERTIES System Table Description
          • PSEUDOTABLEFIELDS System Table Description
          • PSEUDOTABLES System Table Description
          • QUERYBUFFERSTATS System Table Description
          • QUERYSTATS System Table Description
          • ROLES System Table Description
          • SCHEMAS System Table Description
          • SEQUENCES System Table Description
          • STATSCACHE System Table Description
          • STORAGEGROUPS System Table Description
          • TABLECONSTRAINTS System Table Description
          • TABLES System Table Description
          • TEMPFIELDS System Table Description
          • TEMPINDEXES System Table Description
          • TEMPINDEXFIELDS System Table Description
          • TEMPTABLES System Table Description
          • TRANSACTIONALLOCKS System Table Description
          • TRANSACTIONS System Table Description
          • TRIGGERCLASSES System Table Description
          • TRIGGERS System Table Description
          • USERROLES System Table Description
          • USERS System Table Description
          • VERSIONS System Table Description
          • VIEW_TABLES System Table Description
        • Using DbVisualizer
        • Using SQL Workbench/J
        • Using SQuirreL Universal SQL
        • Using MySQL mysqldump Utility
        • Logging
        • Privileges
        • Network Encryption
        • About the Remote Commit Protocol
        • About the Region Commit Protocol
        • About the Local Commit Protocol
            • SQL Enumerated Types
      • REST API
      • Java DataSource API
      • C Driver API
      • C++ Driver API
    • Glossary
  • NuoDB Docs
    • 5.0.x
    • 4.3.x
    • 4.2.x
  • Architecture and Feature Overview

Architecture and Feature Overview

This section provides a general overview of NuoDB, its process architecture and unique features. Most of the topics covered here are described in more detail elsewhere in the documentation.

NuoDB PROFESSIONAL SERVICES ADDENDUM NuoDB System Architecture

All content © 2020 NuoDB.

Site built with Antora and the Antora default ui.