Cursor – an accumulation rows grouped by typical requirements (key sequence, set account, CHOOSE result set) that may be navigated and updated.

Information Type – the fundamental sort of information that are kept in a column. The information kinds that are offered in RDM SQL are: char, wchar, varchar, wvarchar, binary, varbinary, boolean, tinyint, smallint, integer, bigint, real, float, dual, date, time, timestamp, long varbinary, long varchar, and long wvarchar.

Database Instance – an database that is independent stocks exactly the same schema as another database. Used only in RDM.

db_VISTA – initial title from 1984 for the Raima DBMS item now called RDM.

DDL – Database Definition Language.

Deadlock – a scenario for which resources (in other words. hair) take place by a couple of connections which are each needed because of the other connections in order that they are stuck in a wait loop that is infinite. As an example, connection 1 includes a lock on table1 and it is asking for a lock on table2 this is certainly presently held by connection 2, which will be additionally asking for a lock on table1. Development practices could be used to avoid deadlocks from occurring.

Debugger – something utilized to check and debug pc software. An average debugger that is remote on a bunch computer and connects to your target by way of a serial port or higher a community. Utilizing the debugger, you’ll download program towards the target for instant execution. You may set breakpoints within the rule and examine the articles of certain memory areas and registers.

Deterministic – a feature of a portion of rule whereby the restriction regarding the right time necessary to execute the code is well known, or determined, in advance. That is commonly connected with real-time computer computer software.

Distributed Database – A database by which information is distributed among numerous computer systems or products (nodes), permitting numerous computer systems to simultaneously access data living on separate nodes. The net of Things (IoT) is often considered a vast grid of information collection products, needing distributed database functionality to handle.

DLL – Dynamic Link Library. A library of associated functions which are not packed into memory until these are typically called by the application program. All RDM APIs are contained in DLLs on those systems that are operating help them ( e.g., MS-Windows). They are often called provided libraries on some systems.

DML – Database Manipulation Language. In SQL, such statements as MODIFY, INSERT and DELETE are thought DML.

Paperwork – All product-related materials, specifications, technical manuals, individual manuals, movement diagrams, file information, or any other written information either added to services and products or elsewhere. Raima’s paperwork is online.

Domain – an alternative name for a base information kind that is defined utilising the RDM SQL create domain statement.

Durability – The home of a deal where the DBMS guarantees that most transactions that are committed endure almost any system failure.

Dynamic DDL – The ability to replace the concept of a database (its schema) after information is kept into the database without the need to simply take the database off-line or restructure its files.

Edge Computing – Advantage computing is the computing infrastructure during the side of the system, near the sourced elements of information. Advantage computing reduces the communications bandwidth required between sensors in addition to datacenter. Databases with tiny footprints e.g RDM are optimized for side computing.

Embedded Database – An embedded database may be the mixture of a database and also the database pc computer pc software which typically resides within a credit card applicatoin. The database holds information while the pc pc software control the database to store or access information. The application form computer pc software, or the user-interface, then accesses the database and gift suggestions that information in a real method that will be easy for an individual to interpret and realize.

Encryption – The encoding of information such that it can’t be comprehended by a peoples audience. This frequently calls for the utilization of an encryption key. a typical encryption algorithm is called AES, which makes use of encryption tips of 128, 192 or 256 bits. See Wikipedia

End-User – An entity that licenses a credit card applicatoin for its use that is own from or its extra Reseller.

Fog Computing – An architecture that distributes computing, storage space, and networking nearer to users, and anywhere over the Cloud-to-Thing continuum. Fog computing is important to operate IoT, IIoT, 5G and applications that are AI.

Foreign Key – more than one columns in a dining table meant to contain only values that match the relevant primary/unique key column(s) into the referenced table. Foreign and keys that are primary determine the direct relationships between tables. Referential Integrity is maintained whenever every foreign key describes one and just one current key that is primary.

Geospatial datatypes – information kinds that are particularly optimized for storage space of geographical coordinate based data.

Grouped Lock Request – a operation that is single demands hair on a lot more than one dining dining table or rows at any given time. Either all or none for the requested locks will be issued. Issuing a grouped lock demand at the start of a deal that features most of the tables/rows that will possibly be accessed by the deal guarantees that the deadlock will likely not happen.

GUI – Graphical Interface.

Manage – an application identification adjustable that is employed to determine and handle the context related to a specific computing procedure or thread. For instance, SQL utilizes handles for every user connection (connection handle) and SQL statement (statement handle) among other activities.