Reality V 14 Nick Kelly Reality Product Manager

Reality V 14 Nick Kelly – Reality Product Manager Mark Fuller – Reality Support Manager

Reality V 14. 0 - Goals 2 • Further reduce cost of ownership • Greater data security and extended resilience • Simplify and extend integration and interoperability • Smooth migration from other MV implementations

Reality V 14 - Headlines • • • 3 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

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 ► ► 4 Hacking Recent legislation, HIPAA etc

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

Reduced Security Boundary Traditional Model Firewall Network User Authentication Development User Operations User Database Backups Reality Application 6 User Reality Database Server Security Boundary Reality Hacker

Reduced Security Boundary Model Firewall Network User Authentication Development User Operations User Database Backups Reality Application User Reality Database Server Security Boundary 7 Reality Hacker

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

Data Encryption at Rest • Access Management File . User . Application Next Release File . Security Profile Encryption Key Reference Encryption Key Definition Encrypted by System Specific and User defined key 9 Tape Deck . Encrypt/Decrypt Verb Encrypt/Decrypt Data. Basic

Data Encryption at Rest • Secure Management of encryption keys ► Create a new Encryption Reference ► ► 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 ► ► User defines a 128 Bit key Restricted To Database Administrator Transfer of keys to other systems ► 10 Protected by user defined key

Reality Automated DR • Maintains remote disaster recovery systems ► Further extends resilience options to support: Reality Environment Remote hot backup systems Remote ► Operation over slow or intermittent communication links standby ► Sourced from one or more machines system(s) ► Secured upto the last completed transaction ► Reality Environment Reality Failsafe Environment or Standalone System 11

Reality Automated DR • 12 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

Increased Transaction Log Sizes • • Increased Transaction log size to 200 GB 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 ► 13 Some sites switched every 5 minutes (with a 2 GB log)

Configurable Frame Size • 14 Reality now supports a 1, 2, 4 or 8 K 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

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

HTML output from ENGLISH LIST EMP TITLE EMPNO ID-SUPP WITH EMPNO = "02]" 16

HTML output from ENGLISH Page is generated via template and the verb GENML <!DOCTYPE HTML PUBLIC "-//W 3 C//DTD HTML 4. 0 //EN"> <HTML><HEAD> <TITLE>Reality HTML Output from English</TITLE> </HEAD> <BODY> <H 1>HTML Output from English</H 1> <H 2>Employee Details</H 2> <%GENMLTABLE%> </BODY></HTML> <%GENMLTABLE%> indicates to GENML to insert generated HTML detail (from dictionary items) at this point 17

HTML Output from ENGLISH The HTML detail is generated from the dictionary items using a template to add in tag attributes <P style=“font-family: <%1: verdana%>; color<%2: black%>”><%0%></p> Generated data value from dictionary EMPNO 001 A 002 0 003 Employee 004 005 006 007 XT; HTM; T 1 008 009 R 010 6 18 New conversion code XT. HTM refers to the file holding the template and T 1 is the item id of the template TITLE 001 A 002 2 003 Title 004 005 006 007 XT; HTM; T 1; ; RED 008 009 L 010 10

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 19

Improved Active. X Interface • • Reality Active X Client driver Reality Environment 20 • Call Data. Basic Subroutines from Active. X capable environments Access Reality MV Data via Data. Basic Call Data. Basic from: ► VB. net ► C++ ► Delphi ► etc

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 D 3 ► MVBase, ► MVEnterprise ► ► Key additions Single execution of multiple commands ► Embedded native command processor ‘!cmd’ ► Can save PROC and EXECUTE commands on the stack ► 21

TCL Logger • • 22 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.

TCL Logger • • Audit Mode ► Logs TCL commands only ► Retains logs Support Mode ► Logs all commands ► Up to two logs per user ► • • • 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 ► 23 Current/Previous session Always on

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

Supported Platforms • • 25 Reality V 14. 0 adds Microsoft Vista support Supported Platforms ► SUN SPARC running Solaris 2. 8, 9 or 10 ► IBM P Series (RS 6000), running AIX 5 L V 5. 2 & V 5. 3; ► PC with Intel Pentium processor or equivalent running Red Hat Linux 7. 2, Red. Hat 9, Redhat ES 2. 1, ES 3. 0 and ES 4. 0, Redhat ES 3. 0 (64 bit) ► Windows 2000 + SP 1 or greater (Professional or Server), ► Windows XP (Home or Professional), ► Windows 2003 server. ► Windows VISTA.

Questions? 26

Reality V 12

Reality V 12 • • • 28 Web Services & XML External File Integration Fast Backup and Recovery Windows Printer Support Reality DR Data. Basic Profiler System Alerts Database Isolation 2 TB files 64 -bit Linux support Striping Across Filing Systems Compatibility Enhancements

Web Services & XML • With Reality see how easy it is to expose Data. Basic routines as Web Services ► Offer your services across: ► ► Machine, Intranet & Internet Integrate disparate applications Seamless integration for GUI applications Can communicate with any language supporting web services JAVA ► Microsoft suite via. net (office, VB C# etc) ► etc ► Platform independent Easily create and extract data from XML documents ► Very simple to create queries and build documents ► • 29

External File Integration • Reality Environment Transparently Integrate with external Data stores ► Tables in local or remote relational Databases ► ► Oracle, SQLserver, My. SQL, etc. CSV, Tab Separated, etc. Reality File 1 2 O/S File ODBC DB 1, 2, 3 A, B, C 1 2 3 A B C 31 1^2^3 A^B^C

Fast Backup and Recovery • 33 Backup & Restore your Database at near Media Speed. ► Supports selective restore ► Backup while the system is still in use ► In practice ‘near media speed’ is estimated to be up to 30 times faster than the current logical backup.

Windows Printer Support • Print directly to Windows specific printers ► Support low cost printers ► Allows printing directly to third party pseudo printers PDF generators ► And many others ► 35

Data. Basic Profiler • • 36 Optimise your Data. Basic code ► See where your application has been. ► How much time is spent in each routine. Troubleshoot your application ► Easily access the Data. Basic return stack

System Alerts • Act before your system is put at risk ► Email & SMS interface to report system exceptions ► Appends exceptions to an HTML page ► Configurable notification destinations and levels ► Supports alerts generated from your applications Reality Environment 38

Database Isolation • 40 Run completely independent Reality Database’s on a single system, separate logs, licence keys.

Compatibility Enhancements • Numerous compatibility enhancements to further simplify your migration to Reality: ► New Verbs ► • • • 41 ISELECT, ICOUNT Data. Basic ► BREAK, EXIT, CONTINUE (in loops), SENTENCE(n), READNEXT KEY, READPREV KEY, EXECUTE (full Syntax) Enhanced Account restore for mv. Enterprise and j. BASE tapes. Number of Proc file and select buffers increased to 47

Reality V 12 • • 42 Other ► 2 TB files ► Striping Across Filing Systems ► Large Tape Block Size ► Multi-reel Tape Images ► Multi Clean Log Tape Backup / Restore Additional Platforms ► Solaris 10 ► Linux ES 4 ► Linux ES 3 (64 -bit) ► Aix 5. 2

Don’t forget! additions from previous Reality releases • 43 Reality V 12 – Feb 2006 ► Web Services & XML ► External File Integration ► Fast Backup and Recovery ► Windows Printer Support ► Data. Basic Profiler ► System Alerts ► Database Isolation ► 2 TB files ► 64 -bit Linux support ► Striping Across Filing Systems ► Compatibility Enhancements

Don’t forget! additions from previous Reality releases • Reality V 11 – Oct 2004 ► Automatic File Sizing (AFS) ► Data. Basic from Dictionary ► SQL, Stored Procedures, Binary Data Type Remapping of User Exits ► User Defined User Exits – written in Data. Basic ► Multivalue migration enhancements & Migrate Account Utility ► Identifiable Item locks – owner ► Graphical Administration Reality V 10 – July 2003 ► Large Database Support, 2 TB + Raw log to 4 TB ► TCP/IP Sockets ► Triggers ► SQL-VIEW ► Foreign Database support ► • 44

Questions? 45

For More Information on Reality Stop by at the booth and explore what Reality can offer! Northgate Information Solutions UK Ltd Email: reality@northgate-is. com +44(0) 1442 232 424 Northgate Inc Email: realityusa@northgate-is. com Toll Free: 866 473 2588 or 949 748 7300 www. northgate-is. com/reality 46