Installing RMD Server

Modulus Financial Engineering
RMD Server™

RMD Server Database System

RMD Server uses a new generation of data storage specially optimized for the financial industry. The heart of RMD Server is our patent-pending search algorithm, JADE™, which is a complex triangulation algorithm based on Julian dates for time series data. RMD Server is capable of scanning through terabytes of data in search of specific records at up to 200 times faster than the fastest known RDBMS. What makes this possible lies in our innovative use of Julian dates as the primary key field in RMD Server tables. Our technology allows RMD Server to store and locate data quickly with minimal file IO operations.

Tick Tables

A tick table is the most basic type of table, and it is the only type of table that RMD Server will insert real time data into. When you create a new tick table you are essentially creating the master table for the specified symbol. Tick tables may grow to several terabytes in size and may be accessed by thousands of clients. Tick tables have triggers that rebroadcast real time data to all clients that are subscribed to that tick table or symbol. Tick tables are created by the CreateTickTable method. These tables may have any number of custom fields of integer, long, double, or variable-length string data types, however it is strongly recommend to use only the minimum number of fields possible when creating tick tables for performance reasons, as these tables may be accessed thousands of times per second and extra or unnecessary fields will slow performance. Tick tables require at minimum a "Last" and "Volume" field. Timestamp fields are automatically added to all tables.

Bar Tables
Bar tables can be thought of as temporary or intermediate tables for requesting historic data. These tables are created by individual clients on a as-needed basis using the CompressTicks method. These tables are used to request historic data from RMD Server in either secondly, minutely, hourly, daily, weekly, monthly, or yearly bar format. After you request historic data, you may subscribe to a tick table for real time updates. Using the Bar Update Manager, you may keep your local copy of the bar data up to date. After using a bar table you may drop it, or reuse it.

Administration

RMD Server has four built-in login types with varying permissions: Read Only, Read and Write, Administrator, and Super Administrator. Logins may be set to expire at certain times and may be restricted to certain groups of symbols. For more information about logins and permission types, see RMD Server Administration.