Reality V14

1

2

Reality V14

• Release Date Dec 2007

3
Reality V14.0 Goals Design Aims

• Greater security by extending resilience (Safe
  Secure)
• Further reduce cost of ownership
• Simplify and extend integration and
  interoperability
• Smooth migration from other MV implementations

4
Reality V14 - Headlines

• Data Encryption at Rest
• Automated Disaster Recovery
• Increased Transaction Log Sizes
• Configurable Frame size
• Logical Restore Performance Improvements
• ENGLISH output as HTML
• Improved Active X Interface
• Enhanced TCL Stacker
• New TCL Logger
• Utility Licensing
• Licence Expiry Warning
• MV compatibility enhancements
• Microsoft Vista Support

5
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

6
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

7
Reduced Security Boundary
Traditional Model
8
Reduced Security Boundary
Reduced Security Boundary Model
9
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
• Enhanced DataBasic
• DECRYPT and ENCRYPT Statements

10
Data Encryption at Rest

• Access Management

11
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

12
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 up to the last completed transaction

13
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
• Integrated with Heartbeat and Failsafe

14
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)

15
Utility Licensing

• Essential Reality Admin Functions Now Dont
  Consume a Licence
• Clean Log AutoSwitch
• Lack of free Licence will not prevent a switch
• TLMENU
• All utilities run from tlmenu no longer require a
  user licence
• Other Utilities
• Auto File Sizing Commands
• POVF
• Fast Backup
• TL Restore
• Licence Expiry Warning for general system
  licence
• Warnings given well in advance of expiry
• A grace period can be invoked after expiry, so no
  loss of access

16
Configurable Frame Size

• Reality now supports a 1, 2, 4 or 8K frame sizes
• Increasing performance of data access
• Application suited to larger frame size
• To match the operating system block size
• 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
• Available on all supported platforms

17
Logical Restore Performance Improvements

• Reduced data fragmentation after parallel restore
• Creating a more performant database
• About 35 faster for a subsequent logical save
• Reduced the Logical Restore Times
• Only selected when frame size matches operating
  system block size
• Significantly reduce disk reads!
• Benefits both single and parallel restores
• Faster to recover a system, reducing down time

18
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

19
HTML output from ENGLISH
LIST EMP TITLE EMPNO ID-SUPP WITH EMPNO "02"
20
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
21
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
22
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
23
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

24
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

25
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 securityand
  audit purposes
• Be able to show what a user was doing prior to
  asystem or application failure

26
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

27
XML Parser enhancements

• Performance improvements
• One query on 10MB xml document was taking 6
  minutesnow reduced to 1 second
• Improved parsing of documents which have
  repeatednodes with optional elements
• Ability to simply extract all node names in a
  document

28
Improved DataBasic Compiler

• DataBasic EQU to statement
• EQU DD TO DATE()
• Everywhere DD is used, will be substituted for an
  execution of DATE()
• DataBasic Statements
• RAISE - Promotes any system delimiter (VM -gt AM)
• 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 or time
  expires
• WAKE Wakes paused process
• Improved error handling within the DataBasic
  compiler
• Improved error handling of include files

29
Improved DataBasic Compiler (Continued)

• RECORDLOCKED function
• Report if an Item is locked, unlocked,you have
  it locked, someone else has it locked
• STATUS Function (enhancement)
• Returns the port number of who has an item
  locked,used after READU, READVU, MATREADU,
  RECORDLOCKED
• Auto Include
• Read specific include items from given location
• Globally or current source file
• You dont have to remember to manually include
  them at the start of each program!

30
ANALYZE/ANALYSE

• Displays information about processes being
  executedon a specified port
• Port status
• State of the virtual return stack
• State of the DataBasic return stack, if relevant
• Item locks waiting for and ones it has locked
• Group locks waiting for and ones it has locked
• Item deadlock detection
• Optional UNIX host level info for the process

31
ANALYZE/ANALYSE
32
Index enhancements

• Indexes can now be created directly from a data
  definition item
• Uses implicit BY clause
• Support data definition types of A, S or X
• CREATE-INDEX filename indexname (Opts)
• Where indexname can now be the index name and the
  data definition name that the index is based upon
• CREATE-INDEX MYFILE MYDICT
• Creates an index called MYDICT on file
  MYFILEusing dictionary item MYDICT
• New options to exclude null keys and only allow
  Unique keys
• On both CREATE-INDEX and DEFINE-INDEX

33
Other Enhancements

• Tandem PEEK, POKE
• PEEK
• Establishes a read only Tandem session to
  aspecified Reality portPEEK PortNumber
• POKE
• Executes a single TCL command on a specified
  Reality portPOKE PortNumber Command
• Port Range Logon
• Extends PLID to Port Mapping by specifyinga
  range of ports to logon to
• Enable Auto File Sizing by default for all files

34
DataBasic English Mask Decimal with
JustificationML MR L R conversion changes.
35
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.3
• Intel LinuxPentium processor or equivalent
  runningRed Hat Linux 7.2, RedHat 9, Redhat ES
  2.1, ES 3.0 andES 4.0, Redhat ES3.0 (64bit)
• Microsoft Windows2000 SP1 or greater
  (Professional or Server)XP (Home or
  Professional) 2003 ServerVista

36
Reality V14 - Headlines

• Data Encryption at Rest
• Automated Disaster Recovery
• Increased Transaction Log Sizes
• Configurable Frame size
• Logical Restore Performance Improvements
• ENGLISH output as HTML
• Improved Active X Interface
• Enhanced TCL Stacker
• New TCL Logger
• Utility Licensing
• Licence Expiry Warning
• MV compatibility enhancements
• Microsoft Vista Support

37
Developing New Partnerships

• Mits
• Reporting
• Decision
• MyViewpoint
• Reporting Tool
• DisignBais
• Web Based Development Tools

38

• Questions?
• Refer to Reality Websitewww.northgate-is.com/real
  ity
• Or Emailreality_at_northgate-is.com

39