Rocket UniData

Key characteristics and architectural components of Rocket UniData include:

1. MultiValue Nested Data Architecture:

   • Stores complex hierarchies with variable-length records, multivalues, and subvalues, reducing normalization overhead and boosting transaction speeds.

2. UniBasic (UniData BASIC) Programming:

   • Native high-level business programming language supporting modern programming constructs like Try/Catch structured error handling and Dynamic Objects with native JSON support.

3. Python Integration (u2py):

   • Directly interact with the UniData database using Python scripting and the native u2py API, enabling developers to build modern services and AI workflows.

4. Dynamic Hashing & File Optimization:

   • Advanced hashing algorithms with automatic and manual file resizing (udtpm, resize parameters) to maintain optimal disk modulo and eliminate lock contention.

5. UniData SQL & UniQuery / ECL:

   • Comprehensive query capabilities allowing developers to query MultiValue data structures using standard ANSI SQL or native ECL/UniQuery commands.

6. Modern Connectivity & U2 REST Services:

   • Expose database subroutines and files as RESTful web services via U2 REST, UniObjects (UO, UOJ for Java, UONET for .NET), and External Data Access (EDA) to relational databases.

7. High Availability & Disaster Recovery (HA/DR):

   • Robust hot-standby replication and transaction logging capabilities to ensure near-zero downtime and enterprise business continuity.

8. Enterprise Security & Observability:

   • Includes Automatic Data Encryption (ADE), TLS 1.3, SHA3 cryptography, audit logging, OpenTelemetry integration, and Rocket MV BASIC for VS Code development.

Rocket UniData plays a critical role in enterprise ERP systems (including Epicor Eclipse and Ellucian), healthcare platforms, and global distribution logistics, enabling organizations to modernize while maximizing existing MultiValue database investments.

Before beginning your Rocket UniData training, having foundational knowledge in database concepts and general programming is beneficial. Recommended prerequisites include:

1. Fundamental Database Concepts:

   • A basic understanding of data structures, record management, indexing, and basic relational or NoSQL database concepts.

2. Basic Programming Logic:

   • Familiarity with fundamental coding concepts in languages such as BASIC, Python, C, C#, or Java.

3. Operating System Basics:

   • Comfort working with basic command-line environments in UNIX, Linux, or Microsoft Windows Server.

4. Web & API Essentials:

   • High-level understanding of data formats such as JSON, XML, and basic RESTful API communication protocols.

Our training program starts from foundational MultiValue architecture concepts and progresses systematically to advanced UniBasic programming, u2py Python integration, schema management, and administration.

Completing our Rocket UniData training equips you with an in-demand skill set for developing, modernizing, and administering enterprise MultiValue databases:

1. MultiValue Database Design & Architecture:

   • Expertise in structuring nested MultiValue files, DICT/VOC definitions, indices, and configuring dynamic hash tables.

2. UniBasic & Modern Python Development:

   • Mastery in writing UniBasic subroutines, triggers, Dynamic Objects with JSON, and integrating Python via the u2py module.

3. UniData SQL & UniQuery Reporting:

   • Proficiency in querying and manipulating complex datasets using UniData SQL queries and native UniQuery/ECL statements.

4. API Integration & Modernization:

   • Building RESTful web service endpoints using U2 REST and connecting external applications using UniObjects (UOJ / UONET).

5. Database Administration, Security & HA/DR:

   • Hands-on skills in configuring hot-standby replication, Automatic Data Encryption (ADE), TLS security, file resizing, and performance monitoring with udtpm and OpenTelemetry.

With these competencies, you will be prepared to handle high-performance database administration, application development, and system modernization in enterprise environments worldwide.