PROIV

Last updated

PROIV (pronounced "pro-four"), also known as 'Pro-IV', [1] is a low code development platform owned by Zellis Holdings, [2] a British HR services company. [3]

Contents

PROIV was originally developed as a fourth-generation programming language (4GLs). PROIV and other 4GL are aiming to simplify and reduce efforts to create and develop computer programs compared to third-generation programming languages (3GLs) such as Cobol and Fortran. [4]

PROIV's usual application domain is database-centric business applications.[ citation needed ]

PROIV programs consist of declarative/non-procedural specifications that control the overall structure of the program and database access and that have an implicit sequence of execution (which PROIV programmers refer to as the timing cycle). Procedural subroutines can be added by the programmer; these are written in a 3GL-like language, which PROIV calls "Logic".

History

PROIV was developed by Sushil K. Garg, working in Hawaii in 1976 on a General Automation System. In the early 1980s, it was licensed to McDonnell Information Systems (MDIS).

MDIS converted PROIV to run on their Pick-based systems, and this spin-off was known as ALL (Application Language Liberator).

PROIV was ported to several different platforms by separate teams. Garg brought these ports together as one company, Pro Computer Sciences (PCS), headquartered in Laguna Hills, California. PCS was subsequently acquired by MDIS in 1988.

During the second half of the 1980s, a PROIV team entered the 4GL Grand Prix contests in1987, 1988, and 1990 and the product finished second on each occasion.

In 2000, McDonnell Information Systems changed its name to Northgate Information Solutions.

Implementation

PROIV runs OS-independent application code in an OS-specific virtual machine, allowing a user application to run unaltered on different computing platforms. [5] As of August 2021, Zellis claims support for PROIV on Microsoft Windows (workstation and server), Red Hat Linux, IBM AIX, and Oracle Solaris; with Oracle, SQL Server, PostgreSQL, and IBM C-ISAM as the database backend. [6] [lower-alpha 1] [lower-alpha 2]

The PROIV-supplied "GUI client", which renders the rich-client UI for applications written in PROIV, is based around ActiveX technology and works only on Windows client platforms. Consequently, the programmers' development environments supplied with more-recent PROIV releases also work only on a Windows client platform. [8]

Major applications

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.

Structured Query Language (SQL) is a domain-specific language used to manage data, especially in a relational database management system (RDBMS). It is particularly useful in handling structured data, i.e., data incorporating relations among entities and variables.

<span class="mw-page-title-main">IBM Db2</span> Relational model database server

Db2 is a family of data management products, including database servers, developed by IBM. It initially supported the relational model, but was extended to support object–relational features and non-relational structures like JSON and XML. The brand name was originally styled as DB2 until 2017, when it changed to its present form.

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">Baan Corporation</span> Dutch software vendor

Baan was a vendor of enterprise resource planning (ERP) software that is now owned by Infor Global Solutions. Baan or Baan ERP, was also the name of the ERP product created by this company.

Adabas, a contraction of “adaptable database system," is a database package that was developed by Software AG to run on IBM mainframes. It was launched in 1971 as a non-relational database. As of 2019, Adabas is marketed for use on a wider range of platforms, including Linux, Unix, and Windows.

DataFlex is an object-oriented high-level programming language and a fourth generation visual tool for developing Windows, web and mobile software applications on one framework-based platform. It was introduced and developed by Data Access Corporation beginning in 1982.

FOCUS is a fourth-generation programming language (4GL) computer programming language and development environment that is used to build database queries. Produced by Information Builders Inc., it was originally developed for data handling and analysis on the IBM mainframe. Subsequently versions for minicomputers and such as the VAX and other platforms were implemented. FOCUS was later extended to personal computers and to the World Wide Web: the WebFOCUS product.

Dataphor is an open-source truly-relational database management system (RDBMS) and its accompanying user interface technologies, which together are designed to provide highly declarative software application development. The Dataphor Server has its own storage engine or it can be a virtual, or federated, DBMS, meaning that it can utilize other database engines for storage.

<span class="mw-page-title-main">OpenEdge Advanced Business Language</span> Business application development language

OpenEdge Advanced Business Language, or OpenEdge ABL for short, is a business application development language created and maintained by Progress Software Corporation. Typically classified as a fourth-generation programming language, it utilizes an English-like syntax to simplify software development. The language was called PROGRESS or Progress 4GL up until version 9, but in 2006 PSC changed the name to OpenEdge Advanced Business Language in order to overcome a presumed industry perception that 4GLs were less capable than other languages.

<span class="mw-page-title-main">LAMP (software bundle)</span> Acronym for a common web hosting solution

A LAMP is one of the most common software stacks for the web's most popular applications. Its generic software stack model has largely interchangeable components.

NOMAD is a relational database and fourth-generation language (4GL), originally developed in the 1970s by time-sharing vendor National CSS. While it is still in use today, its widest use was in the 1970s and 1980s. NOMAD supports both the relational and hierarchical database models.

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

PowerHouse is a byte-compiled fourth-generation programming language originally produced by Quasar Corporation for the Hewlett-Packard HP3000 mini-computer, as well as Data General and DEC VAX/VMS systems. It was initially composed of five components:

IBM Informix C-ISAM is an X/Open standards-compliant Application programming interface (API) to an Indexed Sequential Access Method or ISAM.

Embedded SQL is a method of combining the computing power of a programming language and the database manipulation capabilities of SQL. Embedded SQL statements are SQL statements written inline with the program source code, of the host language. The embedded SQL statements are parsed by an embedded SQL preprocessor and replaced by host-language calls to a code library. The output from the preprocessor is then compiled by the host compiler. This allows programmers to embed SQL statements in programs written in any number of languages such as C/C++, COBOL and Fortran. This differs from SQL-derived programming languages that don't go through discrete preprocessors, such as PL/SQL and T-SQL.

<span class="mw-page-title-main">Britton Lee, Inc.</span> American relational database company

Britton Lee Inc. was a pioneering relational database company. Renamed ShareBase, it was acquired by Teradata in June, 1990.

PL/SQL is Oracle Corporation's procedural extension for SQL and the Oracle relational database. PL/SQL is available in Oracle Database, Times Ten in-memory database, and IBM Db2. Oracle Corporation usually extends PL/SQL functionality with each successive release of the Oracle Database.

References

Notes

  1. Only very specific combinations of operating system and database versions are supported
  2. A different and wider range of operating systems were claimed to be supported by earlier PROIV versions, for example IBM mainframe operating systems in 1986. [7]

Footnotes

  1. https://www.omega-cs.nl/what-is-pro-iv/
  2. "About". PROIV. September 27, 2016.
  3. "About us | The Zellis story".
  4. Harsant 1989, p. 5.
  5. "Interactions with the PROIV Virtual Machine". proiv.com.
  6. Zellis 2021, p. 12.
  7. Garg 1986.
  8. "PROIV Virtual Machine and the Windows Front End (PROIV Client)". proiv.com.
  9. "Pro People to help alleviate congestion" (Press release). 24 August 2004. Archived from the original on 2007-03-05. Retrieved 2007-09-18.

Sources