02
Sat, Nov
2 New Articles

Cloudscape: Both Sides Now

Commentary
Typography
  • Smaller Small Medium Big Bigger
  • Default Helvetica Segoe Georgia Times

I've looked at clouds from both sides now
From up and down, and still somehow
It's cloud illusions I recall
I really don't know clouds at all

--Joni Mitchell, " Both Sides Now"

In 1999, Informix bought a small company called Cloudscape with an exchange of stock reportedly worth $85 million. Cloudscape was a small, two-year-old startup company that specialized in developing a mobile relational database written entirely in Java. The purpose of Cloudscape was to allow mobile users or branch-office employees to connect to headquarters, download the latest data, work offline, and dial in again to update and sync up with the corporate database. From such simple beginnings, often major initiatives can germinate.

Origins of Cloudscape's Distributed Technology

Cloudscape had some significant obstacles to overcome in order to reach its goal of being a distributed RDMS. To enable the kind of database synchronization that Cloudscape designers envisioned, the code running Cloudscape had to be self-contained and exceptionally small--small enough to download the database structure and access path modalities with the data itself. This kind of distributed database architecture was somewhat new: Previously, each standalone application needed to handle data internally using its own data areas, or it needed to connect to a massive external database, sending code strings through an API.

Cloudscape was designed to be highly optimized Java code that could be embedded into the application itself. This code would exist in a JAR file that was downloaded with the application across the Internet.

Informix's Role with Cloudscape

Informix, which had fallen behind with its own relational database technology, needed a distributed database strategy, and Cloudscape was the perfect candidate. However, Informix was hampered by a lot of marketing problems. First, Sybase already owned 55% of the market, and Oracle owned 22%. Second, Informix was just emerging from lawsuits in which customers sued the company for broken promises regarding its database products. In that climate of distrust, many analysts saw Informix's purchase of Cloudscape as too little too late. In 2001, IBM finally bought all of Informix Software's database assets, including Cloudscape, with a cash transaction estimated to be $1 billion.

Cloudscape Goes Open Source

The big question on everyone's mind was "What will IBM do with Cloudscape?" The database technology was too advanced to discard, yet IBM was not about to confuse its customers by creating a branding conflict with its own DB2 database brand. In addition, IBM wanted to use Cloudscape for its IBM Workplace products to enable fast and easy synchronization to a central server, similar to what Lotus provides with its Notes replication functions. The advantages of using Cloudscape were that it was even smaller than the Notes document database, it was a relational database (not a "containment" document database), and it was written in pure 100% Pure Java. The answer to the dilemma, from IBM's perspective, was to give Cloudscape a new life as an open source project.

In the summer of 2004, IBM turned over to the Apache Software Foundation (ASF) about 500,000 lines of source code for Derby, the source code name given to Cloudscape. IBM released the Derby code to encourage the Java development community to begin writing applications using the code. IBM promised to bring out its own commercial version later and to provide support for the open source project.

Why did IBM open source a database at the low end of the market?

IBM says that it did so because there is an emerging market opportunity in small distributed database technology. Unlike some other products in that market, Cloudscape applications have an advantage in that the Cloudscape RDMS can be distributed with applications at no cost. At the same time, Cloudscape performance is more than "good enough."

An open source Cloudscape had other advantages as well. For example, Cloudscape would now be a major IBM initiative, backed and supported commercially by IBM. That means developers, ISVs, and Business Partners could deploy and sell Cloudscape-based solutions with confidence.

IBM's Cloudscape V10.0

In September of 2004, IBM finally released its commercial version of Cloudscape, called Cloudscape V10.0, based upon the Derby open source code. Today, the Cloudscape V10.0 database is a 100% Pure Java RDMS that runs in 4 MB of space on the J2SE or J2EE platforms, V1.3.1 or later.

Despite its small core, Cloudscape V10.0 has tremendous capability. The table size and the number of rows per table are limited only by available disk space, and there is no built-in limit on the number of tables per instance: If you have the disk space, Cloudscape will store the data. There is a maximum of 1,012 columns per table and no more than 32,767 indexes per table--both well beyond the needs of even the most pathological database.

Features of Cloudscape V10.0

Cloudscape offers a wide variety of appealing features.

Zero Administration

IBM Cloudscape can be deployed in unsupervised environments and does not require database administration or resource management. This eliminates the need for a database administrator at each client installation site. An application enabled with IBM Cloudscape is transparent to nontechnical end users.

Multiple Platform Compatibility

IBM Cloudscape fully supports Sun Microsystems Java technology standards and runs on any standard JVM V1.3 or later. It supports Java 2 and J2EE.

Full-Featured Database in Compact Design

IBM Cloudscape is fine-tuned for efficient use of resources and a high number of concurrent users. Other features and benefits include these:

  • Read-committed, read-uncommitted, serializable, and repeatable-read isolation levels
  • Row-level locking
  • Optimal transaction performance
  • Low memory overhead for connections
  • Fast access time and space reclamation for long rows
  • Cost-based optimizer that supports hash joins, sort avoidance, and row- or table-level locking based on percent of data selected
  • Fast query compilation
  • Bulk load
  • Multiple user support
  • Built-in performance diagnostics: query statistics, locks, and space usage

Advanced Security Features

  • Signed Java Archive (JAR) files
  • LDAP or application-defined secure user authentication
  • Configurable disk encryption, supporting both diverse encryption algorithms and encryption providers other than the default Java Cryptography Extension (JCE) provider

Internationalization and Localization Support

IBM Cloudscape supports international characters and formats without requiring special accommodations for various locations around the globe. IBM Cloudscape offers the following:

  • Unicode support
  • Per-database locale for character string collation
  • Localized installers, tools, user interfaces, error messages, and documents for Spanish, Japanese, German, Italian, Chinese (simplified and traditional), French, Korean, and Brazilian Portuguese

SQL Features

  • SQL-92E compliance and support for key features for SQL-99 standards
  • Triggers
  • Foreign key and check constraints
  • Multicolumn B-Tree indexes
  • Transaction commit and rollback
  • Transactional isolation
  • Crash recovery
  • Multithreaded connections
  • Online backup
  • Cost-based query optimization
  • Data import/export
  • Support for complex SQL transactions and JDBC to speed migration to UDB

Java Features

  • JDBC driver certified for use with Java-compatible, J2EE-branded products
  • Java stored procedures and functions
  • Storage of jar files in the database, including signed jars
  • Type 4 JDBC 3.0 driver integrated with the WebSphere solutions, including WebSphere Application Server

Cloudscape V10.0 Is Cheap!

Considering the full-function footprint of Cloudscape V10.0, you would think that IBM would charge an appropriately full-function price. However, IBM is selling Cloudscape V10.0 with a $0 license fee and an option to purchase maintenance starting at $499 per machine. Why?

IBM's wants to make this Java-based RDMS that is maintained by IBM and the open source community so cost-effective that it can rapidly become a standard. Then, as IBM continues pressing on with its on demand strategy, issues of database compatibility between computing systems and architectures will be standards-based and won't default to the Microsoft .NET or Oracle proprietary database structures. In other words, by making Cloudscape an open source project and keeping the licensing fee at $0, IBM hopes to develop the market in a standards-based mode, allowing it to further its on demand strategies.

Cloudscape's Future

If IBM's strategy for Cloudscape is successful, the open source Java developer community will continue to download Derby source code and proceed with the advancement of the small RDMS. In addition, IBM Business Partners will use the Cloudscape V10.0 database in their standalone applications. IBM, for its part, has promised to continue the development of Cloudscape through the ASF, providing support with new products as Derby evolves.

What started out as a small company called Cloudscape has now become a fully supported IBM open source project managed by the ASF. At the same time, developers now have an excellent means of standardizing application data access methodologies around a highly advanced and sophisticated RDMS for a cost that is next to nothing.

For more information about Cloudscape, click here!

For more information about the Apache Software Foundation's Derby project, click here!

Thomas M. Stockwell is Editor in Chief of MC Press Online, LP.

Thomas Stockwell

Thomas M. Stockwell is an independent IT analyst and writer. He is the former Editor in Chief of MC Press Online and Midrange Computing magazine and has over 20 years of experience as a programmer, systems engineer, IT director, industry analyst, author, speaker, consultant, and editor.  

 

Tom works from his home in the Napa Valley in California. He can be reached at ITincendiary.com.

 

 

BLOG COMMENTS POWERED BY DISQUS

LATEST COMMENTS

Support MC Press Online

$

Book Reviews

Resource Center

  • SB Profound WC 5536 Have you been wondering about Node.js? Our free Node.js Webinar Series takes you from total beginner to creating a fully-functional IBM i Node.js business application. You can find Part 1 here. In Part 2 of our free Node.js Webinar Series, Brian May teaches you the different tooling options available for writing code, debugging, and using Git for version control. Brian will briefly discuss the different tools available, and demonstrate his preferred setup for Node development on IBM i or any platform. Attend this webinar to learn:

  • SB Profound WP 5539More than ever, there is a demand for IT to deliver innovation. Your IBM i has been an essential part of your business operations for years. However, your organization may struggle to maintain the current system and implement new projects. The thousands of customers we've worked with and surveyed state that expectations regarding the digital footprint and vision of the company are not aligned with the current IT environment.

  • SB HelpSystems ROBOT Generic IBM announced the E1080 servers using the latest Power10 processor in September 2021. The most powerful processor from IBM to date, Power10 is designed to handle the demands of doing business in today’s high-tech atmosphere, including running cloud applications, supporting big data, and managing AI workloads. But what does Power10 mean for your data center? In this recorded webinar, IBMers Dan Sundt and Dylan Boday join IBM Power Champion Tom Huntington for a discussion on why Power10 technology is the right strategic investment if you run IBM i, AIX, or Linux. In this action-packed hour, Tom will share trends from the IBM i and AIX user communities while Dan and Dylan dive into the tech specs for key hardware, including:

  • Magic MarkTRY the one package that solves all your document design and printing challenges on all your platforms. Produce bar code labels, electronic forms, ad hoc reports, and RFID tags – without programming! MarkMagic is the only document design and print solution that combines report writing, WYSIWYG label and forms design, and conditional printing in one integrated product. Make sure your data survives when catastrophe hits. Request your trial now!  Request Now.

  • SB HelpSystems ROBOT GenericForms of ransomware has been around for over 30 years, and with more and more organizations suffering attacks each year, it continues to endure. What has made ransomware such a durable threat and what is the best way to combat it? In order to prevent ransomware, organizations must first understand how it works.

  • SB HelpSystems ROBOT GenericIT security is a top priority for businesses around the world, but most IBM i pros don’t know where to begin—and most cybersecurity experts don’t know IBM i. In this session, Robin Tatam explores the business impact of lax IBM i security, the top vulnerabilities putting IBM i at risk, and the steps you can take to protect your organization. If you’re looking to avoid unexpected downtime or corrupted data, you don’t want to miss this session.

  • SB HelpSystems ROBOT GenericCan you trust all of your users all of the time? A typical end user receives 16 malicious emails each month, but only 17 percent of these phishing campaigns are reported to IT. Once an attack is underway, most organizations won’t discover the breach until six months later. A staggering amount of damage can occur in that time. Despite these risks, 93 percent of organizations are leaving their IBM i systems vulnerable to cybercrime. In this on-demand webinar, IBM i security experts Robin Tatam and Sandi Moore will reveal:

  • FORTRA Disaster protection is vital to every business. Yet, it often consists of patched together procedures that are prone to error. From automatic backups to data encryption to media management, Robot automates the routine (yet often complex) tasks of iSeries backup and recovery, saving you time and money and making the process safer and more reliable. Automate your backups with the Robot Backup and Recovery Solution. Key features include:

  • FORTRAManaging messages on your IBM i can be more than a full-time job if you have to do it manually. Messages need a response and resources must be monitored—often over multiple systems and across platforms. How can you be sure you won’t miss important system events? Automate your message center with the Robot Message Management Solution. Key features include:

  • FORTRAThe thought of printing, distributing, and storing iSeries reports manually may reduce you to tears. Paper and labor costs associated with report generation can spiral out of control. Mountains of paper threaten to swamp your files. Robot automates report bursting, distribution, bundling, and archiving, and offers secure, selective online report viewing. Manage your reports with the Robot Report Management Solution. Key features include:

  • FORTRAFor over 30 years, Robot has been a leader in systems management for IBM i. With batch job creation and scheduling at its core, the Robot Job Scheduling Solution reduces the opportunity for human error and helps you maintain service levels, automating even the biggest, most complex runbooks. Manage your job schedule with the Robot Job Scheduling Solution. Key features include:

  • LANSA Business users want new applications now. Market and regulatory pressures require faster application updates and delivery into production. Your IBM i developers may be approaching retirement, and you see no sure way to fill their positions with experienced developers. In addition, you may be caught between maintaining your existing applications and the uncertainty of moving to something new.

  • LANSAWhen it comes to creating your business applications, there are hundreds of coding platforms and programming languages to choose from. These options range from very complex traditional programming languages to Low-Code platforms where sometimes no traditional coding experience is needed. Download our whitepaper, The Power of Writing Code in a Low-Code Solution, and:

  • LANSASupply Chain is becoming increasingly complex and unpredictable. From raw materials for manufacturing to food supply chains, the journey from source to production to delivery to consumers is marred with inefficiencies, manual processes, shortages, recalls, counterfeits, and scandals. In this webinar, we discuss how:

  • The MC Resource Centers bring you the widest selection of white papers, trial software, and on-demand webcasts for you to choose from. >> Review the list of White Papers, Trial Software or On-Demand Webcast at the MC Press Resource Center. >> Add the items to yru Cart and complet he checkout process and submit

  • Profound Logic Have you been wondering about Node.js? Our free Node.js Webinar Series takes you from total beginner to creating a fully-functional IBM i Node.js business application.

  • SB Profound WC 5536Join us for this hour-long webcast that will explore:

  • Fortra IT managers hoping to find new IBM i talent are discovering that the pool of experienced RPG programmers and operators or administrators with intimate knowledge of the operating system and the applications that run on it is small. This begs the question: How will you manage the platform that supports such a big part of your business? This guide offers strategies and software suggestions to help you plan IT staffing and resources and smooth the transition after your AS/400 talent retires. Read on to learn: