OpenROAD

Last updated
OpenROAD
Actian-Logo-RGB Vertical-Blue.jpg
Developer Actian Corporation
Stable release
OpenRoad 12.0 (Windows) / June 28, 2024
Implementation languageC, C++
Platform Cross-Platform
OS Windows, Linux, Solaris, AIX
License Proprietary
Website https://www.actian.com/data-management/openroad-rad-4gl-ide/

OpenROAD, which stands for "Open Rapid Object Application Development", is a fourth-generation programming language (4GL) and development suite from Actian Corporation.

Contents

It includes a suite of development tools, with built-in Integrated development environment (IDE) (Written in OpenROAD), and Code Repository.

History

The history of OpenROAD is closely tied to that of the Ingres relational database.

The Ingres Product set, (marketed by ASK Corporation, Computer Associates, Ingres Corporation and then Actian) was popular in the governments of North West Europe, and can be found in many government departments. OpenROAD appeared in beta form on the SUN platform in 1991 as Windows4GL 1.0, and was available to British Universities under a special license agreement. The development environment was known as the Sapphire Editor.

The Sapphire Editor allowed the creation of complex GUI interfaces using an IDE, rather than large volumes of Motif code / resource files. This was one of the first environments to enable rapid prototyping of GUI clients.

Windows4GL 2.0 introduced Microsoft Windows compatibility and the debugger.

The suite included applications-by-forms (ABF), an early 4GL computer programming language. It provided an ASCII form painter, which automatically bound form fields to a database using ABF, a programming language, with embedded SQL, simplifying the task of making a "CRUD" application for textual data. ABF source code was interpreted into a 3GL language (C or COBOL), which is then compiled so snippets of the native language may be directly embedded in the ABF code. ABF was deprecated by OpenROAD in the early nineties.[ citation needed ]

Nowadays, OpenROAD includes migration tools to modernize “green screen” Ingres ABF applications by converting ABF forms into OpenROAD frames. It also enables to transform OpenROAD thick-client applications to browser-based equivalents without the cost, resource, effort, and risk associated with rewriting or replacing code. Developers can then extend these applications for web and mobile deployment, using HTML5, JavaScript, and WebView2. [1]

Several other database vendors marketed comparable 4GLs at around the same time, such as Pick System Builder, Clipper, and DBASE III. ABF was deprecated by the OpenROAD business unit in the early nineties.

Version history

ReleaseGeneral availabilityEnd of Enterprise SupportEnd of Extended SupportEnd of Obsolescence SupportNotes
Old version, no longer maintained: OpenROAD 3.0May, 199531-Dec-0131-Dec-0631-Dec-11OpenROAD 3.0 was when it became stable on MS Windows.
Old version, no longer maintained: OpenROAD 3.5 (Windows)April, 199631-Jan-0831-Dec-1331-Dec-18OpenROAD 3.5(1) was when it became stable.
Old version, no longer maintained: OpenROAD 3.5 (Unix)September, 199731-Dec-0831-Dec-1331-Dec-18After 3.51, the UNIX environments used a Commercial PC emulator to give native capability, possibly one of the hurdles on the ROAD to its Open Source status across all platforms.

Variations in the distribution include FAT client (Requires Ingres NET for communication), Thin eClient (can be used without Ingres NET but needs to use the Application Server instead (DCOM)), and finally mClient for Mobile Windows Clients (HTTP services required to interface to the Application server).

It was possible to use images in any environment (Unix, VMS or MS Windows up to version 3.51), however portability issues between GUI environments (mostly related to FONT differences) made this difficult.

Old version, no longer maintained: OpenROAD 4.0)April, 199831-Mar-0931-Mar-1431-Mar-19
Old version, no longer maintained: OpenROAD 4.1)January, 200131-Mar-0931-Mar-1431-Mar-19It is an interpreted language that uses a runtime distributable client to process 'image' files, thus no DLL or .NET dependency issues under MS Windows (ActiveX aside).

There was a Macintosh Beta version produced.

Old version, no longer maintained: OpenROAD 2006 (5.0)December, 200631-Dec-1331-Dec-1831-Dec-23
Old version, yet still maintained: OpenROAD 5.1 (Windows and HP-UX)April, 201131-Dec-1531-Dec-2031-Dec-25The defining feature of the release was general-purpose system classes for XML support, to allow creation and parsing of arbitrary XML documents without the need to create additional user classes or to use external components (3GL Procedures or External Class Libraries). Providing an XML based export file format will that will be documented, human readable, produce clean differences between different revisions of a file, allow changes to be merged, will allow OpenROAD source components to be managed by many different Software Configuration Management (SCM) systems.
Old version, yet still maintained: OpenROAD 5.1 (Unix except HP-UX)August, 201231-Dec-1631-Dec-2031-Dec-25
Old version, yet still maintained: OpenROAD 6.0March, 201231-Mar-1731-Mar-2231-Mar-27OpenROAD 6.0 included the additional UNICODE support of OpenROAD 2006 5.5, a special limited release.
Old version, yet still maintained: OpenROAD 6.2 (All Platforms) and Ingres 10.2 Client only for support of OpenROAD as a clientNovember, 201431-Dec-2131-Dec-2631-Dec-31
Old version, yet still maintained: OpenROAD 11.0 (Solaris, Aix)Sep, 2020 31-Dec-2231-Dec-2431-Dec-2631-Dec-26
Old version, yet still maintained: OpenROAD 11.0 (Linux, Windows)Sep, 202031-Dec-2231-Dec-2431-Dec-26
Old version, yet still maintained: OpenROAD 11.2 (Solaris SPARC, IBM AIX)May-2131-Dec-2431-May-2931-May-33
Old version, yet still maintained: OpenROAD 11.2 (Linux)May-2131-Dec-2431-May-2931-May-33
Old version, yet still maintained: OpenROAD 11.2 (Windows)Aug, 202131-May-2531-May-2931-May-33
Current stable version:OpenROAD 12 (Linux)31-May-2431-May-2931-May-3431-May-39
Current stable version:OpenROAD 12 (Windows)28-Jun-2431-May-2931-May-3431-May-39
Legend:
Old version, not maintained
Old version, still maintained
Latest version
Latest preview version
Future release

The reason for the varying and shorter Lifecycle dates of latest versions is Actian is working to bring OpenROAD releases current to Actian X. The Lifecycle dates will re-align with the 11.2 release in 2021. [2]

Architecture

OpenRoad Architecture OpenRoad Architecture.png
OpenRoad Architecture

OpenROAD Server

The OpenROAD Server enables business logic written in the OpenROAD 4GL language to be accessed by client applications. The OpenROAD Server is multi-threaded and allows concurrent access from a number of client interfaces. These client interfaces include the following: [3]

Open Database Access

OpenRoad Server has built-in support for Ingres/X and Vector/Avalanche databases. On IBM z/OS mainframes, EDBC (a separate product) provides the same level of access to native VSAM, DB2, IMS, and Datacom/DB databases to enable you to access data from anywhere. [4]

Features needed (Q2 2008)

Related Research Articles

A fourth-generation programming language (4GL) is a high-level computer programming language that belongs to a class of languages envisioned as an advancement upon third-generation programming languages (3GL). Each of the programming language generations aims to provide a higher level of abstraction of the internal computer hardware details, making the language more programmer-friendly, powerful, and versatile. While the definition of 4GL has changed over time, it can be typified by operating more with large collections of information at once rather than focusing on just bits and bytes. Languages claimed to be 4GL may include support for database management, report generation, mathematical optimization, GUI development, or web development. Some researchers state that 4GLs are a subset of domain-specific languages.

<span class="mw-page-title-main">Informix</span> Database management software product family

Informix is a product family within IBM's Information Management division that is centered on several relational database management system (RDBMS) and multi-model database offerings. The Informix products were originally developed by Informix Corporation, whose Informix Software subsidiary was acquired by IBM in 2001.

<span class="mw-page-title-main">Ingres (database)</span> Database software

Ingres Database is a proprietary SQL relational database management system intended to support large commercial and government applications.

In computing, Open Database Connectivity (ODBC) is a standard application programming interface (API) for accessing database management systems (DBMS). The designers of ODBC aimed to make it independent of database systems and operating systems. An application written using ODBC can be ported to other platforms, both on the client and server side, with few changes to the data access code.

Informix-4GL is a 4GL programming language developed by Informix during the mid-1980s. At the time of its initial release in 1986, supported platforms included Microsoft Xenix, DEC Ultrix, Altos 2086, AT&T 3B2, AT&T 3B5, AT&T 3B20 and AT&T Unix PC.

<span class="mw-page-title-main">WebObjects</span> Java web application server and framework originally developed by NeXT Software

WebObjects is a discontinued Java web application server and a server-based web application framework originally developed by NeXT Software, Inc.

Btrieve is a transactional database software product. It is based on Indexed Sequential Access Method (ISAM), which is a way of storing data for fast retrieval. There have been several versions of the product for DOS, Linux, older versions of Microsoft Windows, 32-bit IBM OS/2 and for Novell NetWare.

Web development is the work involved in developing a website for the Internet or an intranet. Web development can range from developing a simple single static page of plain text to complex web applications, electronic businesses, and social network services. A more comprehensive list of tasks to which Web development commonly refers, may include Web engineering, Web design, Web content development, client liaison, client-side/server-side scripting, Web server and network security configuration, and e-commerce development.

PowerBuilder is an integrated development environment owned by SAP since the acquisition of Sybase in 2010. On July 5, 2016, SAP and Appeon entered into an agreement whereby Appeon, an independent company, would be responsible for developing, selling, and supporting PowerBuilder.

<span class="mw-page-title-main">Uniface (programming language)</span> Low-code development platform

Uniface is a low-code development and deployment platform for enterprise applications that can run in a large range of runtime environments, including mobile, mainframe, web, Service-oriented architecture (SOA), Windows, Java EE, and .NET. Uniface is used to create mission-critical applications.

Forté 4GL was a proprietary application server that was developed by Forté Software and used for developing scalable, highly available, enterprise applications.

LINC is a fourth-generation programming language, used mostly on Unisys computer systems.

<span class="mw-page-title-main">JADE (programming language)</span> Software development and deployment platform

JADE is a proprietary object-oriented software development and deployment platform product from the New Zealand-based Jade Software Corporation, first released in 1996. It consists of the JADE programming language, Integrated development environment and debugger, integrated application server and object database management system.

The SQuirreL SQL Client is a database administration tool. It uses JDBC to allow users to explore and interact with databases via a JDBC driver. It provides an editor that offers code completion and syntax highlighting for standard SQL. It also provides a plugin architecture that allows plugin writers to modify much of the application's behavior to provide database-specific functionality or features that are database-independent. As this desktop application is written entirely in Java with Swing UI components, it should run on any platform that has a JVM.

<span class="mw-page-title-main">Visual Studio</span> Code editor and IDE

Visual Studio is an integrated development environment (IDE) developed by Microsoft. It is used to develop computer programs including websites, web apps, web services and mobile apps. Visual Studio uses Microsoft software development platforms including Windows API, Windows Forms, Windows Presentation Foundation (WPF), Microsoft Store and Microsoft Silverlight. It can produce both native code and managed code.

An embedded database system is a database management system (DBMS) which is tightly integrated with an application software; it is embedded in the application. It is a broad technology category that includes:

<span class="mw-page-title-main">Db4o</span> Open source object database

db4o was an embeddable open-source object database for Java and .NET developers. It was developed, commercially licensed and supported by Actian. In October 2014, Actian declined to continue to actively pursue and promote the commercial db4o product offering for new customers.

<span class="mw-page-title-main">Actian NoSQL Object Database</span> Database management system

Actian NoSQL Database is an object database software product initially developed by Versant Corporation and currently owned by Actian.

<span class="mw-page-title-main">Actian Zen</span>

Actian Zen is an ACID-compliant, zero-DBA, embedded, nano-footprint, multi-model, Multi-Platform database management system (DBMS). It was originally developed by Pervasive Software, which was acquired by Actian Corporation in 2013.

Actian is an American software company headquartered in Santa Clara, California that provides analytics-related software, products, and services. The company sells database software and technology, cloud engineered systems, and data integration solutions.

References

  1. ↑ "Actian OpenROAD". Actian. Retrieved November 3, 2024.
  2. ↑ "Lifecycle Dates - Transactional Database - Actian OpenROAD". Actian. Retrieved 2023-04-14.
  3. ↑ "OpenROAD Server Overview". Actian. Retrieved 2023-04-14.
  4. ↑ "Accessing and Integrating Data with OpenROAD". Actian. Retrieved 2023-04-14.

Product links:

Community links:

Mailing Lists:

Webcasts:

This page is based on this Wikipedia article
Text is available under the CC BY-SA 4.0 license; additional terms may apply.
Images, videos and audio are available under their respective licenses.