Cloudscape

1

• Cloudscape
• by Michal Struhar
• Course Modern Software Tehnologies

2
What is Cloudscape?

• SQL compliant database implement in Java
• 100 Pure Java
• Runs on any platform that has a JVM
• Object/Relational
• Runs as embedded db or server

3
About Cloudscape Company

• Founded in June 1996 , Oakland, California
• Mixed development Team made from developers from
  Oracle, Sybase, Informix, Illustra
• First Cloudscape release in March 98 after 2
  years of development
• Acquired by Informix October, 1999
• Database Tool of the Year awards from JavaWorld
  and Java Developers Journal

4
Ways of deployement

• Embedded in a single-user Java application.
  Cloudscape can be practically invisible to the
  user, since it requires no administration and
  runs in the same Java virtual machine (JVM) as
  the application
• Embedded in a server framework

5
Ways of deployement

• Deployed in a distributed system in which
  multiple, occasionally connected users have their
  own copies of the database, the Cloudscape
  engine. Cloudscape can periodically connect to a
  central Cloudscape server (called Cloudsync) to
  submit and receive updates.

6
Cloudscape DBMS

• Engine is an embeddable Java class library
• 2.3M of class files
• zero-admin
• Standards
• SQL92 query language via JDBC
• Query optimizer
• Transactions and crash recovery
• Multiple connections

7
Other Database Features

• Transaction commit and rollback
• Multicolumn b-tree indexes
• Stored prepared statements
• Multiple concurrent connections
• Database encryption
• Import/Export
• Backup and restore
• Single data format for Cloudscape databases on
  all platforms

8
Java Stored Procedures

• Java Stored Procedures are Simply Java Methods
  Which Execute in the Database Engine
• Use JDBC to Access the Database

9
Classes in the Database

• JAR Files Can be Installed in a Database (than
  used as a part of applications)
• Especially Useful for Java Stored Procedures

10
Distributed system

• Source and Target Topology
• All communication through Source
• All administration at Source

11
Cloudsync

• Cloudscape synchronization (replication) is a
  process in which Cloudscape copies data from a
  source database to and from one or more target
  databases
• Targets request refresh
• Communication between source and target is only
  during refresh

12
Cloudsync Extensions

• Cloudsync can replicate any database object
• Tables, indexes, constraints, triggers,
• Cloudsync can replicate program code
• Cloudsync can replicate many operations
• DDL
• Administrative operations
• Work units (user-defined database events)

13
Work Units

• Operations represented by Java methods at source
  and target for handling replication conflicts.

14

• THE END

15
(No Transcript)