Reality V14

1
Reality V14
2
Reality V14.0 - Goals

• Further reduce cost of ownership
• Greater data security and extended resilience
• Simplify and extend integration and
  interoperability
• Smooth migration from other MV implementations

3
Reality V14 - Headlines

• Data Encryption at Rest
• Automated Disaster Recovery
• Increased Transaction Log Sizes
• Configurable Frame size
• ENGLISH output as HTML
• Improved Active X Interface
• Enhanced TCL Stacker
• New TCL Logger
• MV compatibility enhancements
• Microsoft Vista Support

4
Data Encryption at Rest

• Why ?
• Protect data, against internal threats
• By Own Staff
• Operations staff
• Development staff
• Data Deposited Offsite
• Backup tapes, Failed disks
• Unauthorised access into system
• Hacking
• Recent legislation, HIPAA etc

5
Data Encryption at Rest

• What is it
• Transparently Encrypts the data written to your
  Database and other media
• Access Management
• Defines who is allowed access to encrypted data
• Secure Management of encryption keys
• Advantages
• Selectively limits access to sensitive data
• Reduced Security Boundary

6
Reduced Security Boundary
Traditional Model
7
Reduced Security Boundary
Reduced Security Boundary Model
8
Data Encryption at Rest

• Transparently Encrypts the data written to your
  Database and other media
• Fully Encrypted Files
• Indexes associated with encrypted files are also
  encrypted
• Save/Restore
• Data is saved as it is stored within the database
• Encrypted data remains encrypted
• Encrypted Save / Restore
• Encrypts all data saved to a device
• Encrypt/Decrypt Verbs
• For one off database file encryption
• Enhanced DataBasic
• DECRYPT and ENCRYPT Statements

9
Data Encryption at Rest

• Access Management

10
Data Encryption at Rest

• Secure Management of encryption keys
• Create a new Encryption Reference
• User defines a 128 Bit key
• All keys are fully protected
• Encrypted by a combination of
• System specific key, generated by Northgate
• Customer defined key, generated by Database
  Administrator
• Copying your system will NOT copy the keys
• Secure access to utilities
• Restricted To Database Administrator
• Transfer of keys to other systems
• Protected by user defined key

11
Reality Automated DR

• Maintains remote disaster recovery systems
• Further extends resilience options to support
• Remote hot backup systems
• Operation over slow or intermittent communication
  links
• Sourced from one or more machines
• Secured upto the last completed transaction

12
Reality Automated DR

• Key Features
• Auto starts from system boot
• Unattended operation
• Auto recovery from network issues
• Source data from primary system or standalone
  system
• Synchronisation up to last completed transaction
• Simple to use configuration utility

13
Increased Transaction Log Sizes

• Increased Transaction log size to 200GB or 4
  billion individual updates
• Reduce the cost of managing Reality systems
• Reduce the number of tapes used for archiving
• Simplify system restore
• Requires fewer logs/tapes
• Reduce system recovery time
• Reduce the frequency of log switching
• Some sites switched every 5 minutes (with a 2GB
  log)

14
Configurable Frame Size

• Reality now supports a 1, 2, 4 or 8K frame sizes
• Increasing performance of data access
• Simplifying migration to Reality
• Set when the database is created
• Tools provided to choose an optimum frame size
• Utility to calculate new file sizes, based on new
  frame size
• Enable Auto File Sizing by default for all files
• Available on all supported platforms

15
HTML output from ENGLISH

• Create HTML output from ENGLISH statements
• Increased reporting flexibility
• No third party tools required
• Driven by simple to produce HTML templates

16
HTML output from ENGLISH
LIST EMP TITLE EMPNO ID-SUPP WITH EMPNO "02"
17
HTML output from ENGLISH
Page is generated via template and the verb GENML
lt!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0
//EN"gt ltHTMLgtltHEADgt ltTITLEgtReality HTML Output
from Englishlt/TITLEgt lt/HEADgt ltBODYgt ltH1gtHTML
Output from Englishlt/H1gt ltH2gtEmployee
Detailslt/H2gt ltGENMLTABLEgt lt/BODYgtlt/HTMLgt
ltGENMLTABLEgt indicates to GENML to insert
generated HTML detail (from dictionary items) at
this point
18
HTML Output from ENGLISH
The HTML detail is generated from the dictionary
items using a template to add in tag attributes
ltP stylefont-familylt1verdanagtcolorlt2black
gtgtlt0gtlt/pgt
19
HTML output from English
GENML EMP ID-SUPP TITLE EMPNO WITH EMPNO
02 (this will prompt for) Output file name
MYFILE (could be directory view onto web
server) Output item name myreport.htm Template
filename MYTEMPLATES Template item name
EMPTEMPLATE
20
Improved ActiveX Interface

• Call DataBasic Subroutines from ActiveX capable
  environments
• Access Reality MV Data via DataBasic
• Call DataBasic from
• VB
• VB.net
• C
• Delphi
• etc

21
Enhanced TCL Stacker

• Enhanced TCL stacker emulates other MV
  environments.
• Reduce training costs when migrating to Reality
• Fully backwards compatible with existing Reality
  TCL Stacker
• Emulates
• D3
• MVBase,
• MVEnterprise
• Key additions
• Single execution of multiple commands
• Embedded native command processor !cmd
• Can save PROC and EXECUTE commands on the stack

22
TCL Logger

• Logs commands input at TCL for audit or support
  purposes
• Enables administrators to investigate other users
  TCL command stacks
• Monitor progress of other users.
• View / run commands.
• Show what has been done at TCL for security and
  audit purposes.
• Be able to show what a user was doing prior to a
  system / application failure.

23
TCL Logger

• Audit Mode
• Logs TCL commands only
• Retains logs
• Support Mode
• Logs all commands
• Up to two logs per user
• Current/Previous session
• Audit and Support modes are not exclusive
• Logged Commands are time stamped
• Security Controlled
• Off (default)
• Disabled
• Enabled
• Can be manually started or stopped
• Auto Start
• Always on

24
MV compatibility enhancements

• Eases migration from other MV environments
• Key enhancements
• DataBasic EQU to statement.
• DataBasic Statements
• RAISE - Promotes any system delimiter (AM -gt SM)
• LOWER - Demotes any system delimiter (AM -gt VM)
• SORT - Sorts dynamic array fields
• COMPARE Compares two strings
• DataBasic Event Handling  
• PAUSE Sleeps until Wake received
• WAKE Wakes paused process
• Improved error handling within the DataBasic
  compiler

25
Supported Platforms

• Reality V14.0 adds Microsoft Vista support
• Supported Platforms
• SUN SPARC running Solaris 2.8, 9 or 10
• IBM P Series (RS 6000), running AIX 5L V5.2
  V5.3
• PC with Intel Pentium processor or equivalent
  running Red Hat Linux 7.2, RedHat 9,  Redhat ES
  2.1, ES 3.0 and  ES 4.0, Redhat ES3.0 (64bit)
• Windows  2000 SP1  or greater (Professional or
  Server), 
• Windows XP (Home or  Professional),
• Windows 2003 server.
• Windows VISTA.

26

• Questions?

27
For More Information on Reality
Northgate Information Solutions UK Ltd Email
reality_at_northgate-is.com 44(0) 1442 232
424 Northgate Inc Email realityusa_at_northgate-is.c
om Toll Free 866 473 2588 or 949 748
7300 www.northgate-is.com/realityy