Transcript MS PowerPoint

Reality V14
Nick Kelly – Reality Product Manager
Mark Fuller – Reality Support Manager
Reality V14.0 - Goals
Slide 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 V14 - Headlines
•
•
•
•
•
•
•
•
•
•
Slide 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
►
►
►
Unauthorised access into system
►
►
Slide 4
By Own Staff
► Operations staff
► Development staff
Data Deposited Offsite
► Backup tapes, Failed disks
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
►
•
Slide 5
Defines who is allowed access to encrypted data
Reduced Security Boundary
Traditional Model
Firewall
Network
User
Authentication
Development User
Reality
Application
Operations User
Database
Backups
Slide 6
User
Reality
Reality
Database
Server
Security Boundary
Reality
Hacker
Reduced Security Boundary
Reduced Security Boundary Model
Firewall
Network
User
Authentication
Development User
Reality
Application
Operations User
Database
Backups
User
Reality
Reality
Database
Server
Security Boundary
Slide 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 DataBasic
►
Slide 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
.
File
.
File
User
.
User
.
User
.
Application Next
Release
File
Security
Profile
Security
Profile
Security
Profile
Encryption Key
Reference
Encryption Key
Reference
Encryption Key
Reference
Encryption Key
Reference
Encryption Key
Definition
Encryption Key
Definition
Encryption Key
Definition
Encryption Key
Definition
Encrypted by System Specific
and User defined key
Slide 9
Tape Deck
.
Encrypt/Decrypt
Verb
Encrypt/Decrypt
DataBasic
.
.
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
►
Slide 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
Operation over slow or intermittent communication links Remote
standby
Sourced from one or more machines
system(s)
Secured upto the last completed transaction
Reality Environment
Reality Environment
Reality Failsafe Environment or Standalone System
Slide 11
Reality Automated DR
•
Slide 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 200GB or 4 billion
individual updates
Reduce the cost of managing Reality systems
►
Reduce the number of tapes used for archiving
►
Simplify system restore
►
►
►
Reduce the frequency of log switching
►
Slide 13
Requires fewer logs/tapes
Reduce system recovery time
Some sites switched every 5 minutes (with a 2GB log)
Configurable Frame Size
•
Slide 14
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
HTML output from ENGLISH
•
Slide 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]"
Slide 16
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
Slide 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;T1
008
009 R
010 6
Slide 18
New conversion code
XT. HTM refers to the
file holding the
template and T1 is
the item id of the
template
TITLE
001 A
002 2
003 Title
004
005
006
007 XT;HTM;T1;;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
Slide 19
Improved ActiveX Interface
•
Reality Active X
Client driver
Reality Environment
Slide 20
•
•
Call DataBasic Subroutines from
ActiveX capable environments
Access Reality MV Data via DataBasic
Call DataBasic from:
►
VB
►
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
►
►
►
►
Key additions
►
►
►
Slide 21
D3
MVBase,
MVEnterprise
Single execution of multiple commands
Embedded native command processor ‘!cmd’
Can save PROC and EXECUTE commands on the stack
TCL Logger
•
•
Slide 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
►
Slide 23
Current/Previous session
Always on
MV compatibility enhancements
•
Eases migration from other MV environments
►
Key enhancements
►
►
►
►
Slide 24
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
Supported Platforms
•
•
Slide 25
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.
Questions?
Slide 26
Reality V12
Reality V12
•
•
•
•
•
•
•
•
•
•
•
•
Slide 28
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
Web Services & XML
•
With Reality see how easy it is to expose DataBasic routines
as Web Services
►
Offer your services across:
►
►
►
►
Integrate disparate applications
Seamless integration for GUI applications
Can communicate with any language supporting web services
►
►
►
Slide 29
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
►
•
Machine, Intranet & Internet
External File Integration
•
Reality Environment
Transparently Integrate with
external Data stores
►
Tables in local or remote
relational Databases
►
►
Oracle, SQLserver, MySQL,
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
Slide 31
1^2^3
A^B^C
Fast Backup and Recovery
•
Slide 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
►
►
Slide 35
PDF generators
And many others
DataBasic Profiler
•
•
Slide 36
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
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
Slide 38
Database Isolation
•
Slide 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
►
•
•
•
Slide 41
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
Reality V12
•
•
Slide 42
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
Don’t forget! additions from previous Reality releases
•
Slide 43
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
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
►
•
Slide 44
Questions?
Slide 45
For More Information on Reality
Stop by at the booth and explore what Reality can offer!
Northgate Information Solutions UK Ltd
Email: [email protected]
+44(0) 1442 232 424
Northgate Inc
Email: [email protected]
Toll Free: 866 473 2588 or 949 748 7300
www.northgate-is.com/reality
Slide 46