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

1. Reality V14 Nick Kelly – Reality Product Manager Mark Fuller – Reality Support Manager

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. Firewall Network User Authentication Development User Reality User Reality Application Reality Operations User Reality Database Database Backups Hacker Server Security Boundary Reduced Security Boundary Traditional Model

7. Firewall Network User Authentication Development User Reality User Reality Application Reality Operations User Reality Database Database Backups Hacker Server Security Boundary 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. File . File . File . User . File . User . Encryption Key Reference User . Security Profile Encryption Key Reference Tape Deck . Security Profile Encryption Key Reference Application Next Release Security Profile Encryption Key Reference Encrypt/Decrypt Verb Encrypt/Decrypt DataBasic Encryption Key Definition Encryption Key Definition Encryption Key Definition Encryption Key Definition Encrypted by System Specific and User defined key 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 Environment Remote standby system(s) Reality Environment Reality Environment Reality Failsafe Environment or Standalone System 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 <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 //EN"> <HTML><HEAD> <TITLE>Reality HTML Output from English</TITLE> </HEAD> <BODY> <H1>HTML Output from English</H1> <H2>Employee Details</H2> <%GENMLTABLE%> </BODY></HTML> <%GENMLTABLE%>indicates to GENML to insert generated HTML detail (from dictionary items) at this point

18. Generated data value from dictionary EMPNO 001 A 002 0 003 Employee 004 005 006 007 XT;HTM;T1 008 009 R 010 6 TITLE 001 A 002 2 003 Title 004 005 006 007 XT;HTM;T1;;RED 008 009 L 010 10 New conversion code XT. HTM refers to the file holding the template and T1 is the item id of the template 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>

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. Reality Active X Client driver Reality Environment 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 -> SM) • LOWER - Demotes any system delimiter (AM -> 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. Reality V12

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

29. Web Services & XML • With Reality see how easy it is to expose DataBasic 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

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

31. Fast Backup and Recovery • 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.

32. 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

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

34. Reality Environment 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

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

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

37. Reality V12 • Other • 2TB files • Striping Across Filing Systems • Large Tape Block Size • Multi-reel Tape Images • Multi Clean Log Tape Backup / Restore • Additional Platforms • Solaris 10 • Linux ES4 • Linux ES3 (64-bit) • Aix 5.2

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

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

40. Questions?

41. 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