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 RAM Requirements: User-configurable, minimum 50 kb Code Footprint: Starting at ~270 kb, depending on OS and database features Data Types Supported Time Series BLOBs Character Widechar Varchar DBADDR (ROWID) Floating Point – 32 bit and 64 bit Integer – 8 bit, 16 bit, 32 bit and 64 bit C Struct (Core only) Data/Time/Timestamp BCD (SQL Decimal) – Binary-code-decimal is a standard database representation for financial applications. GUID Product features in depth Database Design Language (DDL) Non-SQL (core) DDL Features: C struct-like record type (table) declarations. Network model set declarations for defining 1-many inter-record relationships. Support for direct, B-tree, and hashed record access. In-memory database or file declarations. A database can be designed to be either on-disk or in-memory, or a hybrid where some parts reside in-memory while others are stored on disk. Circular record types (tables). Circular tables store a user-specified maximum number of records (rows). When that maximum has been reached, newly inserted records are stored in the location occupied by the oldest one. Circular tables are important for storing status data on resource-restricted devices. Supported datatypes: 8, 16, 32, and 64 bit signed or unsigned integers, float, double, decimal (BCD), fixed or variable-length character or wide character, binary or character large objects (blobs), date, time, timestamp, guid/uuid, and db_addr (database address—aka, rowid). Support for struct and array data fields. Optional user control over database file organization and page sizes. SQL DDL Features: Declared referential integrity support automatically implemented using RDM's network model sets. Support for direct, B-tree, and hashed row access. In-memory database or table declarations. Circular tables. Virtual tables declarations that provide SQL access to external data sources (e.g., real-time sensor data). Supported data types: boolean, tinyint, smallint, integer, bigint, decimal, real, float/double, binary/varbinary, long varbinary, char/varchar, wchar/wvarchar, long varchar, long wvarchar, date, time, timestamp, guid/uuid, rowid (foreign and primary keys). Domain declarations. Transactional File Server The RDM Transactional File Server (TFS) specializes in the serving and managing of database files on a given medium. The TFS is a set of functions called by the RDM runtime to manage the sharing of database files among