Product Overview Information 

Database & Operating Environment  – high performance, functionally rich MultiValue scalable database management system, interoperable with ever changing needs using embedded interfaces.

DataBasic – a highly evolved application programming language, not to be confused with other derivatives of BASIC as it is designed for efficient handling of real-world data; including string and numeric, with direct access to MultiValue and SQL databases. Interface examples include: a web interface API, direct access to TCP/IP Sockets and calls to/from local/remote systems using C/code, Web Services (incoming & outgoing), native object orientated language syntax and library access using the DBO (DataBasic Object) Language Servers…

English – a powerful but simple data retrieval and reporting language using dictionary items to describe and manipulate data – with or without indexes. DataBasic code can be accessed by the Call Conversion or further pre/post data processing. Comes with an ENGLISH-TUTORIAL account, refer to the Documentation Index. To compare a typical enquiry with SQL refer to the What is Reality page.

RealWeb – simple to complex Web Interface for application programing, using little or no knowledge of HTML using 300 high level API calls. 

Terminal Control Language(TCL), Proc, Editors, Spooler…
.. for these and other areas the link refers you to the Contents in the Documentation.

• TCL is a low level command interface, similar to UNIX shells
• Proc is a procedural language used to construct simple to complex conditional Reality command scripts
• Editors (line, screen and web based) are used for program, English dictionary and raw data editing.
• Spooler provides for text and HTML based report file spool job control and host file creation.  

 Pick/MV Migration – Reality provides a proven migration path from other MultiValue products

Interoperability – integrate with almost any other DBMS environment.
Covers built-in technology for Reality application access:

• DataBasic Object Server
  For native object orientated language syntax accessing features written in object languages. This includes Java syntax within the DataBasic compiler, including examples of how the many open and commercial external Java Apps can be accessed. Working with customers RESTful Web Services, JSON, .NET Language Server V15.2 is introducing ongoing required interfaces as business needs demand.
• SQL-VIEW – DIR-VIEW – CSV-VIEW … read/write directly from local and remote SQL databases and native host directory files or mapping to comma separated value files. Refer to SQL information below.
• Web page creation from English reporting.
• Foreign Database Support, allows Reality to access any ODBC compliant Database to store data.
• Sequential File Access, for simple but high performance access to host files.
• XML Parser, to extract and build MultiValue data to/from Reality.
• Web Services, to expose and publish DataBasic routines as Web Services.
• jReal, to instantiate DataBasic subroutines as a Java Class.
• RealWeb, for producing a web-based user interface to existing and new Reality applications.
• ActiveX, to enable non-Reality applications to efficiently call DataBasic from Microsoft .NET, C++, C#, Visual Basic, Office VBA…
• Program to Program Connections, for low level data communication between all  programming languages. 

SQL – Structured Query Language; the established standard for DBMS.
To compare standard SQL with Reality/Multi-Value refer to the SQL and MV Query example.

Web Services & XML Parsing
Web Services provide both incoming and outgoing inter-process connection, independent of program language and systems. The XML Parser enables Reality and XML data exchange, including constructing XML documents and extracting data from them.

Data Encryption at Rest can be enabled at the file level including associated indexes, with access via a user’s profile. There’s also use within the enhanced string function, ENCRYPT. 

Reality has Transaction logging, i.e. efficient logging of all database updates to a log file, built in with other options available to improve data and runtime resilience. Transaction Handling, i.e. being able to define database updates into logical transactions that can be committed or aborted in a defined boundary, is configured as part of the Reality Windows [Demo] load option, refer to the Details of the Demo.

Resilience – from realtime transaction logging, offline shadow databases, rapid recovery from dirty shutdowns to fully redundant separate FailSafe and remote Disaster Recovery Systems.

Heartbeat – FailSafe Systems that can continue processing from a predefined point.
(Requires FailSafe and Oracle Sun/SPARC host platform for the highest resilient option)

Safe & Secure – protecting your Application and Data with Encryption at Rest options.