The versatile server and desktop database.
Server and Desktop Database Overview
RDM Workgroup Edition is a high-performance, database management system optimized for the operating systems commonly used within the desktop and server environments.
It is ideal for standalone and networked applications such as those commonly found on today’s desktop and laptop computers. Multiple APIs provide developers a multitude of programming options and functionality.
In addition RDM Workgroup includes an ADO.Net 4.0 provider, JDBC 4 Type 4 driver and an ODBC 3.5 driver. Using these drivers managed code applications can easily be created using popular languages like C# and Java.
The ACID compliant desktop database engine supports B-tree and hash indexes; the B-tree indices can support simple and/or compound keys. Additionally the desktop database engine has been developed to fully utilize multi-core processors, run within minimal memory, and support both in-memory and on-disk storage. Implemented as a linkable library the database is allowed to become an embedded part of your applications.
The Plus package includes extra features for optimal performance.
New Feature: Performance Benchmarks and Database Functionality Tutorials
Our Database Performance Popcorn Samples let you test in-memory, on-disk performance and other configurations within your app’s environment. You can also view quick database tutorials that show you how to configure different features within our database. Each sample takes less than 5 minutes.
RDM Workgroup Technical Specifications
- Maximum Databases Open Simultaneously: No Limit
- Maximum Records Per Database: No Limit
- Maximum Size of Database File: Limited only by file system
- Maximum Tables Per Database: No Limit
- Maximum Records Per Table: No Limit
- Maximum Record Size: 32 kb (excluding BLOB or VARCHAR)
- Maximum Fields Per Table: No Limit
- Maximum Keys Per Database: No Limit
- Maximum Size of Keys: 242 bytes
- RAM Requirements: User configurable, minimum 50 kilo bytes
- Code Footprint: Starting at ~270 kb, depending on OS and database features
Modes of Operation
- Application Linked
- Mixed Execution Mode
Data Types Supported
- DBADDR (ROWID)
- Floating Point – 32bit and 64bit
- Integer – 8bit, 16bit, 32bit and 64bit
- C struct
Additional SQL Data Types:
Data Providers and Drivers: Interoperability
- ADO.Net 4.0 Data Provider
- JDBC 4 Type 4 Driver
- ODBC 3.5 Driver
Multiple APIs: for Enhanced Usability
Navigational C API
For well over 25 years developers have been using RDM’s low-level C API of over 200 intuitive easy to use functions provides application developers with ultimate control of the database.
Comprehensive SQL API
RDM’s SQL is accessed internally through an easy-to-use API designed by Raima. This non-standard API is simpler than ODBC. In fact, our ODBC API is based on this one.
Standards Based ODBC API
Following the ODBC standards Raima developed the ODBC API to provide developers with a familiar way to utilize the power of the RDM database engine.
Object Oriented C++ API
The C++ API was designed with ease of use as its primary requirement while still providing developers with full access and control to both RDM’s network and relational functionality.
Objective C API
The Objective-C 2.0 interface to RDM Workgroup is designed to augment the RDM navigation on the Mac OS X platforms by creating custom objects to represent records and interface with the database. This combines the performance of RDM Workgroup with the intuitiveness of an object oriented interface, making it easy to integrate with Cocoa applications.