Mark Pick Vice President Reality - PowerPoint PPT Presentation


PPT – Mark Pick Vice President Reality PowerPoint presentation | free to download - id: 133888-ZGMwN


The Adobe Flash plugin is needed to view this content

Get the plugin now

View by Category
About This Presentation

Mark Pick Vice President Reality


Slide 1. Mark Pick Vice President Reality. Mark Fuller Reality Development ... Alistair Darling says taxman lost disks containing the detailed child benefit ... – PowerPoint PPT presentation

Number of Views:77
Avg rating:3.0/5.0
Slides: 76
Provided by: bwi92
Learn more at:


Write a Comment
User Comments (0)
Transcript and Presenter's Notes

Title: Mark Pick Vice President Reality

Texas MultiValue User Group June 2009
  • Mark Pick Vice President Reality
  • Mark Fuller Reality Development
  • Gail Lawrence Customer Development

  • Welcome Mark Pick
  • Is your data safe and secure? Mark Fuller
  • Web Services Mark Fuller

Who is Northgate?
  • You might remember…..
  • Microdata
  • McDonnell Douglas

Dick Pick circa 1973
……..All part of
Northgates history!
Slide 3
Its the REALITY you remember.
But much more.
Slide 4
Continuous Enhancements
  • REALITY V1.0 First commercial PICK
    release 1974
  • REALITY V7.2 Last proprietary O/S
    release 1990
  • Reality X V2.0 First UNIX release
  • Reality X V5.0 Last UNIX (only) release 1996
  • Reality X V8.0 First Windows NT release 1998
  • Reality V9.0 Windows 2000 Support 2001
  • Reality V9.1 AIX, Linux, Sockets 2002
  • Reality V10.0 GUI Admin, Rapid
    Recovery 2003
  • File System, 2TB database,
  • SQL View, Foreign Database
  • Reality V11.0 Auto File Sizing, GUI
  • Databasic from English 2004
  • Reality V12.0 Web Services,
    XML Parser
  • Fast Backup and Restore 2006
  • Reality V14.0 Data Encryption at Rest, DR
  • Reality V14.1 Case
    insensitivity D3 flavor 2009

Slide 5
About Northgate
  • Reality the first commercial Multivalue release
  • 38 years experience (company established in
  • 07/08 revenue of 1.1 billion
  • Company worth 2 billion
  • Approximately 8,000 staff
  • 46 locations worldwide
  • Head Office Hemel Hempstead, UK

Slide 6
Northgate has three major divisions
  • Northgate HR is the specialist HRS division of
    Northgate Information Solutions. We are the UK
    and Irelands leading supplier of HR, Payroll and
    Pensions software solutions and services to all
    market sectors. Moorepay is Northgates small HR
    Payroll specialist division.
  • Northgate Public Services is the number one
    provider of community justice technology
    solutions. Our task is to enhance public sector
    value through the intelligent use of information
    technology and to share in the economic and
    social benefits that this brings.
  • Northgate Managed Services provides
    infrastructure solutions to organisations across
    the public, private and not-for-profit sectors,
    and specialist ICT managed service solutions in
    education, local government and utilities.

Slide 7
Reality Core Characteristics
  • Proven, Industrial Strength, Standards-Based
  • Exceptional Resilience and Recovery
  • No loss of data
  • Rich, Web-Enabled Application Development Tools
  • Exceptional Interoperability
  • Excellent MultiValue Compatibility

Slide 8
Heritage with a Future
  • Back to Reality
  • Where are we going? The skys the limit!
  • Future
  • Continual development and commitment to the
    Reality product and to MultiValue.
  • Third Party Vendors
  • DesignBais
  • MITS
  • Sierra Bravo


Why Choose Reality ?
  • Questions?

Is Your Business Safe and Secure?
  • Mark Fuller Reality Development Team

(No Transcript)
  • Investigate what is meant by the terms Disaster
    Recovery Business Continuity Plan
  • What is a disaster?
  • What is their effect?
  • What techniques can reduce the risk?
  • How can Northgates Reality Help?

What is disaster recovery?
  • (DR) is a coordinated activity to enable the
    recovery of IT/business systems due to a
  • DR can be achieved by
  • Restoring IT/business operations at an alternate
  • Recovering IT/business operations using alternate
  • Performing some or all of the affected business
    processes using manual methods.

What is Business Continuity Planning?
  • BCP - All encompassing term covering both
    disaster recovery planning and business
    resumption planning.
  • Set of procedures for sustaining essential
    business operations while recovering from a
    significant disruption.
  • This umbrella term also refers to other aspects
    of disaster recovery
  • Emergency management,
  • Human resources,
  • Media or press relations,
  • Building Control

Disaster Recovery Business Continuity
  • Business Continuity/Organisational Resilience has
    gained in importance over the last five years.
  • Interest Focus is at International Level
  • UK - Civil Contingencies Act 2004 National Risk
    Register 2008
  • NFPA1600 (North America), HB221 HB292
  • 2008 saw the launch of a new BSI Standard (BSI
  • Insurance Companies now take preparedness into
  • Weather in particular has shown events happen
  • Pandemic hot topic
  • Organisations have become more complex, more

Which one is a potential disaster and may cause
you to implement your DR/BCP plan or parts of it?
  • Security Breach
  • Dishonest Member of Staff
  • Stolen Data
  • Stolen/Loss of Computer System
  • Loss of Service
  • Fire/Flood/Tornado/Earthquake/Explosion etc.
  • Hardware Failure
  • Complete server failure
  • Disk Crash
  • Network failure
  • Power fail

Security Breach - Impact
  • Incident Cost
  • Management time
  • Operational effort
  • Legal Compliance Issue
  • Breach of Data Protection Act
  • Breach of HIPPA
  • Breach of Contract
  • Reputation
  • Negative press attention … seen as a blunder
  • Are we a safe pair of hands?

Security Breach - Examples
Cost 500,000!
  •   ID theft concerns over Eden Project stolen
  • IT Pro UK Fri, 15 Jun 2007 1245 
  • ...identity theft. The laptop was looked after by
    an employee of XXXXXX , a company the Cornish
    tourist attraction uses to handle its payroll . 

UK Chancellor admits HMRC lost 25 million
people's data Alistair Darling says taxman lost
disks containing the detailed child benefit
information of 25 million individuals
Cost potentially billions! (Compensation up to
600 per record, total 15 billion (UK)
Security Breach - Examples
94 of large enterprises Had a security breach
within the last 12 months
40 Million Credit card numbers stolen from TJX
Hotel chain falls victim To 14,000 data-stealing
Database Security
  • Is your Database secure?
  • Can you control access?
  • By user, location, time or type of connection?
  • Can you detect inappropriate access?
  • Do you know who is accessing your database and

Database Security Reducing the Risk
  • MV Account Based Security
  • Many users share the same user
  • name and password
  • Advantages
  • Simple to Administer
  • Disadvantages
  • Cant identify individuals
  • Hard to Audit
  • Difficult to tell if the security has been
  • Passwords are difficult to secure

Database Security Reducing the Risk
  • User Based Security
  • Each user has unique user name
  • and password
  • Advantages
  • Simple to Administer
  • Can Identify the individuals
  • Auditable
  • Individuals can change their passwords
  • You should be able control how often, length and
    password history
  • Disadvantages
  • Identities can be conveyed to others or
    commandeered by others

Database Security Reducing the Risk
  • Location Based Security
  • Extends User based security
  • Limit individuals to pre-defined locations
  • Individuals can have multiple security profiles
  • Dependent on their location
  • Disadvantages
  • Have to define acceptable locations

Database Security Reducing the Risk
  • Time Based Security
  • Extends User based security
  • Logins are restricted to defined time periods
  • Advantages
  • Tighter control of User based security
  • Pre-defines allowable login times per user
  • Disadvantages
  • Have to define acceptable time windows

Database Security Reducing the Risk
  • Server Based Security (linked to user based
  • Allows same user different access rights to
    different services
  • (Remote File, Web, SQL)
  • Advantages over User based security
  • Server processes can have different security
    profiles than associated users
  • Disadvantages
  • Have to define more access rights

Database Security Using Reality
  • Reality is used in security critical systems
  • Police, Government, Health, Military
  • Supports
  • Account Security
  • User Security
  • Location based security
  • Time Based
  • Server Based

Data Security
  • Is your Data secure?
  • Can you prevent un-authorized access to the
    information on your media?
  • Disk Tape
  • Can you control access to the data?
  • You may want to give file access but not the
    ability to understand the data

Data Security Reducing the Risk
  • Encrypt any data leaving site
  • Advantages
  • Protects backups held off-site
  • Disadvantages
  • Managing the encryption keys

Data Security Reducing the Risk
  • Data stored in an encrypted form
  • Data Encryption at Rest
  • Advantages
  • Protects data at source
  • Transparent to the application
  • Disadvantages
  • Possible performance implications
  • Need to manage the keys

Data Security Using Realitys Data Encryption
at Rest
  • What is it
  • Transparently encrypts the data written to your
    database and any other media
  • Access Management
  • Defines who is allowed access to encrypted data
  • Secure Management of encryption keys
  • Advantages
  • Selectively limits access to sensitive data

Loss of Service

Loss of Service- Entire Regions May Be Vulnerable
Northeast Power Blackout August 2003
Loss of Service- Nature is full of surprises
Primary Data Center New Orleans
DR Site Houston
Katrina August 29th 2005
Rita September 24th 2005
Loss of Service - Impact
  • Incident Cost
  • Management time
  • Operational effort
  • Contractual SLAs
  • Breach of Contract?
  • Reputation
  • Negative press attention …
  • Are we a safe pair of hands?
  • Loss of business
  • Companies that arent able to resume operations
    within 10 days of a disaster are not likely to
    survive (source Strategic Research Institute,
    Jan 2002.).
  • Problems with IT cost small and medium
    enterprises (SMEs) 100 billion in lost turnover
    each year according to the London Business
    School. Computer crashes are estimated to cause
    losses of 31 million each year.

Loss of Service - Causes
  • Loss of
  • Data
  • Hardware
  • Network infrastructure
  • Site
  • Business!
  • Forced to cease trading and wind company up!
  • Staff!
  • May lose key staff members

Loss of Service Reducing the Risk
  • Business Continuity Disaster Recovery Planning
  • Put a BCP DR plan in place above all test it!
  • Some things to consider
  • Emergency Management Team
  • names, numbers, meeting venues, con. call numbers
  • Business Recovery Actions
  • an ordered list of the actions to be taken by the
  • Site Details
  • site plan, departments, services delivered, key
    suppliers, tenants
  • IT Recovery
  • the site's IT facilities, switchboard lines, DR
    arrangements for these
  • Office Space Recovery
  • teams on site, contacts, numbers, alternate
    office locations
  • Site Management
  • site protection, salvage, security and safety
  • Support Services
  • from HR, int/ext communications, finance,
    property security
  • Longer Term Recovery Actions
  • the task of returning to "business as usual"

Loss of Service Reducing the Risk
  • Resilient Hardware
  • Duplicate key hardware components
  • Disk Mirroring
  • Redundant power supplies, processors etc.
  • Redundant Networks
  • Hot Swappable Components
  • Advantages
  • Quick recovery
  • Little Admin
  • Disadvantages
  • Can still cause the system to fail and need to be
  • Only protects individual machines

Loss of Service Reducing the Risk
  • Regular backups (Offsite!)
  • Backup key data to removable media
  • Tape, Disk
  • Advantages
  • You do have a copy of your data
  • Can be kept offsite
  • Disadvantages
  • Media deteriorates over time
  • Slow!
  • Costly!
  • Only protects individual machines

Loss of Service Reducing the Risk
  • Resilient File System
  • Journaling file system, allows the file system
    and database to recover to the last completed
    transaction when the machine unrepentantly stops
  • Advantages
  • Recovery can be to last completed transaction
  • Can be very quick to recover
  • Disadvantages
  • Additional load on system
  • Relies on storage devices being intact

Loss of Service Reducing the Risk
  • Hot standby systems
  • Second machine is maintained
  • as a near real-time copy of the
  • live running system
  • Advantages
  • No loss of service
  • Disadvantages
  • Normally closely coupled Requires real time
    data link
  • Can still lose both systems
  • Additional hardware costs

Loss of Service Reducing the Risk
  • Remote Hot Standby systems
  • A remotely hosted machine is maintained as a near
    real-time copy of the live running system
  • Advantages
  • Data copied off-site at the end of each
  • Off-site machine can be ready to run
  • Disadvantages
  • Dependant on external communications link
  • Requires a communications link which can handle
    the throughput of the system
  • Can be costly depending on options taken

Loss of Service -Reality Resilience
Loss of Service - Reality Automated DR
  • Maintains remote disaster recovery systems
  • Further extends resilience options to support
  • Remote hot backup systems
  • Operation over slow or intermittent communication
  • Sourced from one or more machines
  • Secured up to the last completed transaction

Loss of Service - Fast Backup and Recovery
  • Backup Restore your Database at near Media
  • 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
  • Point in time backup
  • Examples
  • MOD
  • from 4 days to 9 hours
  • Wolseley
  • from 2 hours to six minutes (50GB)

Loss of Service Using Reality
  • Reality Supports
  • Fast backup Restore
  • Backup Restore your database at media speed
  • Journaling
  • Rapid Recovery
  • If hardware survives crash, quickly recovers
  • Offline backup databases
  • Shadow Database
  • Stored on same machine, separate offline disks
  • Hot backup standby systems
  • Failsafe Heartbeat
  • No loss of service
  • Automatically switches to secondary system
  • Remote Disaster Recovery systems
  • RealityDR
  • Low Cost, Offsite system kept up to date in real

  • Plan in advance
  • Create Business Continuity Disaster Recovery
    plans (NOW)
  • Be aware of the Risks
  • Security Breach
  • Loss of Service
  • Data,
  • Hardware,
  • Network infrastructure,
  • Site, Business,
  • Staff!

  • Deploy techniques to mitigate those risks
  • Security Methods
  • Database Security
  • Data Security
  • Protect Your Service
  • Resilient Hardware
  • Regular backups
  • Resilient File System
  • Hot standby systems
  • Remote Hot Standby systems
  • Move to Reality
  • Northgate and Reality have the tools to protect
    your business

Thank You
  • Questions?

Reality Web Services Texas User Group June 2009
  • Mark Fuller Reality Development Team

Web Services XML
  • What are they?
  • Technologies involved
  • Examples of them being used today
  • Why Web Services?
  • Making your services available to a wider
  • Greater efficiency
  • Greater interoperability
  • Reduced integration costs
  • Simplified Business communication protocols
  • Demo of Reality Web Services using C to produce
    a GUI application.
  • Realitys XML capabilities
  • Parsing
  • Generating

Web Services They are not…
  • Not exclusive to Web Browsers!
  • Not exclusive to web based applications!
  • Web - Is used in the name purely because they
    typically use HTTP as their transport mechanism
    and are served by a web server.

Web Services - What are they?

A software system designed to support
interoperable machine-to-machine interaction ...
Web Services - What are they?

A Web service is an evolutionary technology
that allows businesses to integrate their
internal/external computer systems, leverage
legacy systems, and automate communication with
their business partners in ways never before
Web Services - What are they?
  • Web Services are standards driven
  • Key standards
  • Based on Extensible Markup Language (XML)
  • Simple Object Access Protocol (SOAP)
  • Universal Discovery, Description and Integration
  • Web Services Description Language (WSDL)
  • Have standard communication mechanisms
  • Enables interoperability of applications
  • Different languages
  • Different platforms

Web Services - What are they?
.net Application Java App Others
Web Services - What are they?
Web Services - Why?

  • Key Business Drivers
  • Greater efficiency
  • Allows IT departments to grow organically by
    hooking into third party software systems rather
    than building from scratch.
  • Greater interoperability
  • Allows greater communication between systems that
    would benefit from more automation.

Dramatically reduces the 1 cost to IT
departments Application Integration!
Web Services - Why?

  • Service Orientated Architecture market place
    estimated at 43bn by 2010
  • We must allow you to work in a SOA
  • Expose existing applications as Web Services
  • Calling Web Services

Web Services Statistics (eBay)

  • As of December 2005, the eBay Developers Program
    had more than 25,000 members who created 1,900
    live applications
  • Approximately 47 of listings are
    through eBay Web Services
  • Nearly 50 are from third-party developer tools
    created by companies.
  • Q4 2005, the eBay Platform handled more than 8
    bln Web service requests
  • The number of eBay Web Services transactions
    through APIs increased 84 annually

Reality Web Services
  • Convergence of Northgate Technologies
  • Inbound
  • Ability to expose Reality DataBasic Subroutines
    as Web Services
  • Very simple interface to create a web service.
  • Outbound (future release)
  • Ability to call Web Services from within your
    Reality application
  • DataBasic API to call an external web service.

Reality Web Services Advantages
  • No Knowledge of Web Technologies required by
  • WSDL
  • XML
  • SOAP
  • HTTP/S
  • You focus on Business Rules and we do the

Reality Web Services In use today!
  • Challenge
  • The Northgate Integrated Incident Management
    Framework integrates disparate control room
    applications into a single user interface.

Reality Web Services In use today!

Reality Web Services In use today!
  • Challenge
  • Reduce error rate of picking and packing exam
  • Integration with warehouse hand-held devices
  • Behaviour
  • Real-time
  • Fast response
  • Simple to implement
  • Target System
  • Handheld WiFi Barcode readers
  • Interface
  • Web Services

Reality Web Services In use today!
Reality Web Services Demo
  • Reality Web Services from Microsoft Office
  • Integrate your Reality applications into Office
  • Reality Web Services from Visual Studio .net
  • C
  • See just how simple it is!

Reality XML Parser
Reality XML Parser
  • Numerous applications exchange information in XML
  • Reality supports an XML parser,
  • create XML
  • simple data extraction from an XML document using
    a query template.

Reality XML Parser Example
Reality XML Parser Example
Reality XML Generator Example
Web Services XML - Summary
  • What are they?
  • Technologies involved
  • Examples of them being used today
  • Why Web Services?
  • Making your services available to a wider
  • Greater efficiency
  • Greater interoperability
  • Reduced integration costs
  • Simplified Business communication protocols
  • Demo of Reality Web Services using C to produce
    a GUI application.
  • Realitys XML capabilities
  • Parsing
  • Generating

Thank You
  • Questions?