IBM SystemBuilder

SystemBuilder is the name of a 4GL development and runtime environment originally written for the Pick family of computer databases/environments.The SystemBuilder environment comprises SB+ Server, often running on an IBM U2 database, and the SBClient fat client, which runs under Microsoft Windows. The development environment enables rapid development and deployment of applications and includes a rudimentary GUI application environment.

Early History

System Builder was started in a garden shed in South Africa by first cousins Neill and Derek Miller in 1982. The popularity of the Pick database system, combined with a lack of a good development framework led them to develop a standardised menu and screen building tool.

The System Builder Software company was incorporated in the Isle of Man when the brothers moved to Sydney, Australia in the early 1980's. The product was very successful and after expanding into international markets and after a few versions they began to re-develop the product from the ground up. This was to become SB+ and was released in early 1990.

Traditionally, up to this time, Pick systems were accessed using dumb green-screen terminals but with the rise of the PC a new paradigm presented itself and so around the end of 1991 the product was enhanced with the addition of a specialised terminal emulation client called Termulator!. This was able to tightly integrate the server and the PC to allow for facilities like downloads direct from the server into Lotus 1-2-3 or the new kid on the block, Microsoft Excel.

Shortly after, the client program was renamed SBClient and the ability to render the server 'green-screens' as client GUI screens was added with a clever set of driver interpreters. Unfortunately, even to the present day, the client GUI never lived up to the expectations of the rapidly changing world of the PC desktop. A few staunch supporters of the GUI layer still persist using it for systems but it remains a slow, staid, inflexible, standards-lite, curmudgeon of an interface. (As at the current time, IBM is rewriting the GUI interface as an SOA for release sometime in 2007. Hopefully it will live up to the potential of the concepts underlying the server.)

Having been bought by Unidata Corporation in 1996, and following Unidata's merger with VMark Software to form Ardent Software in 1998, the SystemBuilder product set came under the ownership of Informix in 2000 following their purchase of Ardent Software for its Datastage product. Subsequently in 2001 Informix themselves were bought by IBM, and the U2 and SystemBuilder products eventually found their way to become part of IBM's Data Management portfolio.

Development of the SystemBuilder and RedBack products continued in Sydney until 2005, when they were merged with the U2 development team located in Denver, USA.

The SystemBuilder Development Environment

The System Builder/SB+ server environment is based around a set of key tools and utilities. These leverage out to provide a powerful and comprehensive development environment which is, itself, built mainly from these tools. SB+ includes an application menuing system, screen generator, a 3GL programming language, an expression language, the GUI components and report writer tool.

Language:

*PICK BASIC - underlying database programming language.
*Paragraph Processes - small BASIC like functions.
*Expressions

Evolution

External links

* [http://www-306.ibm.com/software/data/u2/sb System Builder home page]