view the presentation (new window)

jBASE Software Roadshow ‘99

jBASE SoftwareProduct Update

Dave BryantPresident

jBASE Software, Inc.

September, 1999


jBASE - The Product Compiles into executable code

Performance ImprovementsInteroperability Enhanced

Can access other databases from BASICDB2, Oracle, Sybase, Reality

Separated application from data High levels of compatibility

Reality, Unidata, uniVerse, Sequoia, R83/91 etc


jBASE Architecture

jBASEFiles

jBASEFiles

Operating SystemOperating System

BASIC Application

Code (.exe, .bin)

BASIC Application

Code (.exe, .bin)

HardwareHardware

RDBMSRDBMS UserDefined

UserDefined

jEDIjEDI

jBASE UtilitiesjBASE UtilitiesjSHELL PROC Queries

jBASEOBjEX

jBASEOBjEX

OLE DBODBCJDBC

OLE DBODBCJDBC

jBASE Library Functions

JavaOBjEX

JavaOBjEX


jBASE - The Product

All MultiValued functionality presentData logically held the same wayAll MV commands presentSpooler / debugger present (Reality)

Files and dictionaries held as separate file system objects

Data the same across all platforms


Platform Availability Microsoft Windows

95 / 98 NT Workstation NT Server

Digital Alpha Intel

Windows 2000

UNIX AIX HP-UX DG/UX Linux (RH 6.0) Solaris SCO & UnixWare Digital Unix Motorola SVR 4


jBASE Future Revisions Current Revision is 3.2.6 Revision 3.3

uniVerse & Unidata compatibility

Revision 4.0 (2H’00) GUI Admin New File System

Revision 5.0 (Future) Java National Language Support


jBASE

Release 3.34 major conversions have been done in the last

6 months, uniVerse, Unidata, PI/open, RealityAll these findings have been implemented in

this version of jBASE User defined functionsIf needed there will be a 3.4


jBASE Release 4.0

Position jBASE to attack the mainstream Graphical Admin New file system

No manual resizingNo file corruption

SQL DDLReferential integrityTriggers etc more associated with files

Indexing over jRFS


jBASE

Release 5 Java – JiniNational Language SupportMainframe support (S390, AS/400)Research being done now !!


Access to Other Data jEDI Technology

Provides ability to use other databases as if Multivalued

Oracle, Sybase, SQL Server, DB2Other applications

MSMQ Server, PC based products

Embedded SQL Access via ‘C’ API


jBASE Networking Networking is part of the product Data is accessible from any platforms j4 File system is network aware jRFS allows processing to be done on the

serverSelect across a network

Triggers executed where the data is


Distributed Files Allows a file to be spread over several parts based

on Value of a field User defined algorithm

File segments may be across a network A good example would be central system, several

regional servers Need regional figures and corporate figures.


Transaction Management

Transactions bracket atomic I/O processing units for example Credit – Debit pairs

Begin, commit, abort transactions Transactions support 2 phase commit Transaction Logging

Available over network to provide hot standby


Crash Resilience and Recovery with jBASE


Overview

J3 Secure files prevent file corruption. jBASE Journalling provides update

recording and play back in a number of configurations such as:Simple Item update recording and replay;Transaction update recording and replay;Hot Standby recording and replay;


J3 Secure Mode Files J3 secure file updates synched to

disk. J3 overflow and link updates

performed in SAFE order and synched to disk.

If a crash occurs you either get the update or you don’t.


Simple Item Update This simple

configuration will record any update to files you specify.

Offers an audit trail and simple recovery of lost items.

After disaster: Restore save; apply Journal.


Transaction Journalling

Updates are bounded by Transaction Boundaries.

Journal records start and end of boundary.

Journal replay recovers only complete transactions.

Recovery: Restore save and replay transactions.


Hot Standby Journalling Updates saved with or

without boundaries. Stored in journal and also

sent to remote systems. Journal lag time can be set

and/or synched. Recovery: Start journaller

on standby; switch to standby.


Features & Benefits

A configuration is available for the cautious to the paranoid - Allows an organization to choose the time to

recovery and the performance profile.

Two phase commit transactionsAllows network safe and distributed

transactions - all or none.


Features and Benefits

Mix, match and change configurations easily - allows the site to grow the

solution with the organization.

Use the journal as continuous On-line backup - Gives 24hour operation but with

secure up-to-the-minute backup.


Applications

Quick recovery from machine failure - switch to hot-standby.

Quick recovery without journalling high availability J3 secure system.

On-line duplication to second system (reporting, data mining, data export).

Jlogdup uses jEDI: log to Oracle, Sybase etc.


System Requirements Assume journalling uses 25% of machine

plan capacity accordingly.

Using J3 secure mode with full data sync requires high throughput disk write system for batch processes.

Configure fastest practical connection between hot-standby systems.

RAID arrays well over capacity is wise - Disk based Journals can be large.


Availability

Now on UNIX Systems Release 3.3 on NT Systems Not available on Windows 95 or 98


jBASE Desktop Integration


Desktop Integration

jBASE OBjEX ActiveX implementation of BASIC

jDP & jDCOLE DB interfaceProvides ODBC, JDBC, ADO, RDS


jBASE OBjEX Designed to write applications

Visual Basic, VBA, Delphi etc Integrated with VB

Will provide context sensitive help

Supports jBC constructs Common between jBC and OBjEX Uses same locking mechanism jBCCallback method

Allows VB to know something has happened in jBC


jDP & jDC

jDP – jBASE data provider jDC – jBASE dictionary configurator Part of jBASE Enterprise Version Used for standard interfaces

i.e. no customization except what the app gives you


jDP

Interface based on ISG NavigatorISG (NASDAQ:SISG)Navigator supports many other databases

DB2, Sybase, Oracle, SQL/Server

Embedded in Oracle 8i

We add the interface between jBASE and ISG


jDP

Looked at other products in our space Our impression was that they were slow and

difficult to use Design goals were to make it easy to use for

the Multivalued user/administrator and performant

We succeeded !!


jDC Problem has always been mapping

Multidimensional model onto flat ODBC/SQL model

jDC adds information to standard jBASE dictionary to allow adherence to the flat model SQL standard names Multivalue associations

Looks like a joined virtual table to ODBC


jBASE and Java

Current Products

and

New Development

Jim Idle – June ‘99


Introduction

The jBASE View of Java Current Products Java OBjEX Release 5.0 – Java Rewrite Summary


Current Products

The jBASE Data ProviderOLE/DB and ADOODBCJDBC

JDBCType II Partly NativeNOT an ODBC layer.


Current Products

The jBASE JDBC ProvidesStandard SQL views of multivalues (Chaptered

rowsets) to Java toolsStandard Interface to Java database controlsAllows application wizards and 3rd party tools

to be embedded in the application.Immediately usable by IDEs such as JBuilder,

Visual Café, et al.


javaOBjEX

Equivalent to our current OBjEX product Provides jBASE Object model to standard

Java Requires Java Native Interface (JNI) [now

available in all VMs] Requires Enterprise License


Release 5.0 – Java Rewrite

Begins this year Reuse some of Release 4.0 Java

Development Takes jBASE to the “World at Large” Talks underway with IBM and Sun

Enlisting business partners for this.


Release 5.0 – Java Rewrite Will take our customers with us, not leave them

behind. Java OBjEX Model supported so that current

development not wasted But deprecated in favor of business object oriented

model Will be 100% PURE Java. Will provide native code on some systems if it can

offer any performance advantage (not yet clear)



Will incorporate database security model Go forward from distributed (n-tier client

server) model provided in javaOBjEX Will allow distribution of business objects

definable from existing code Will allow users to convert jBC (BASIC) to

100% Java



Will allow corporations to retain current staff and their application knowledge

Therefore be able to keep current application

BUT! Move the application forward technologically, and therefore (hopefully) as a business solution



Feature SummaryDatabase security (Encryptable identifiers

JUID, JTID)Business objects should be exportable via

CORBA and/or JNIWill define distributable services via JINIWill allow 100% conversion to Java code.


Summary

Java is an intrinsic part of the future of jBASE.

Java OBjEX will be available shortly and will be immediately useful and reusable in release 5.0.


jADE

4 GL for jBASE Conversion to jADE from other 4GLs e.g.

System Builder + Ability to create Visual Basic directly from

jADE screens Full presentation and demo later today


jBASE & The Web


jBASE & The Web

No additional products are needed Simply connect jBASE products to

mainline productsIIS, Apache, etc

jBASE version of Coyote available soon Several customers live on the Web using

CGI Bin and ASP – Java soon.


jBASE Performance


Performance

Major Ardent VAR Needed ability to access the outside world Benchmarked jBASE and uniVerse Performance and throughput for large

numbers of users important Network of RS6000 systems

12 cpu S7A – 12 node RS6000 SP


Performance

IBM Local Area Netwrok

12 CPU S7ARS6000

Data Data

App ServerApp Server App Server App ServerApp Server App Server App Server App Server

Driver Driver Driver Driver


PerformancejBASE uniVerse

Concurrent Users 6000 2750

Transaction Type Average Response Time in Seconds

Funds Transfer 0.63 0.60

Statement Enquiry 0.60 0.60

Account Display 0.49 0.30

Customer Display 0.59 0.45

Transaction Throughput Transactions Processed in 15 minutes

Total transactions 53,470 20,655

Funds transfer 22,301 8,650

Statement Enquiry 13,385 5,140

Account Display 8,874 3,500

Customer Display 8,910 3,375

Peak transaction rate 3,919 per minute 1,723 per minute

Average transaction rate 3,564 per minute 1,378 per minute


Performance

Local Authority in UKUpgraded from MDIS X35M to RS6000 F50

Improve performance of system & supplier 200 concurrent users

Desire to save money $250,000+ savings per year was achieved

Maximize opportunities in ITY2K compliance


PerformanceTask RS 6000 F50 & jBASE MDIS X35M & Reality

BMS Analysis 9 hours 69 hours

Select CT Accounts 5 mins 180 mins

Bank Reconciliation 3 mins 60 mins

Debtors Analysis 4 mins 32 mins

Access Audit Trail 3 mins 19 mins

Electoral Roll 15 mins 90 mins

Select CT Payers 2 secs 259 secs

Select CT Property 9 secs 154 secs

PMS Count 4 secs 360 secs

CT Count 15 secs 1,500 secs


Conclusion

jBASE committed to MultiValued market Easy to do business with!! Architecture allows interoperability with

mainstream world Technologically advanced & moving

forwardAble to use state of the art tools

view the presentation (new window)

Documents

jbase journalling

jbase architecture jbase

jbase release

position jbase

jbase roadshow

jbase networking networking

queries jbase objex

jbase desktop integrat