Malcolm Crowe

Last updated

Malcolm Kenneth Crowe
Born (1948-01-13) January 13, 1948 (age 75)[ citation needed ]
Dublin, Ireland
NationalityIrish
Occupationcomputer scientist
Known forPyrrho RDBMS
Academic work
DisciplineComputer science
Main interestsPhilosophy [1]
Notable worksPyrrho DBMS[ citation needed ]
Website Official website OOjs UI icon edit-ltr-progressive.svg

Malcolm Kenneth Crowe is an Irish computer scientist and mathematician who retired to become professor emeritus at the University of West of Scotland after 46 years of service. [2] [ citation needed ]

Contents

Biography

So when I consider why academics do research, I think of participation in the joy of discovery and debate, the creation of new knowledge, and the timeless academe.

Crowe, Malcolm [1]

Crowe was born in Dublin on 13 January 1948.[ citation needed ] Studies in the final year of school encouraged an interest in philosophy. [1] He gained a 1st class honours degree from Trinity College Dublin in 1969. [3] [ citation needed ]

Crowe gained employment as a lecturer at Paisley College of Technology in Scotland in 1972, remaining with the institution through its transition to Paisley University in 1992 and finally to the University of the West of Scotland (UWS) in 2007.[ citation needed ]

His D. Phil in Mathematics was awarded from Oxford University in 1979. [4]

Although trained as a mathematician Crowe's interest turned increasingly towards computing.[ citation needed ] He became Head of Computing in Paisley in 1985, introducing an interpretivist degree in information systems, resulting in a "culture clash". [4]

Crowe was involved in the European Strategic Program on Research in Information Technology (ESPIRIT) in the 1980s and 1990s.[ citation needed ]

2006 saw him develop the Pyrrho lightweight database management system. [5] [6] UWS set up licensing so it could be commercially exploited but in practice has been utilised in an educational role, with the European sponsored DBTechNET initiative and as an addendum to the 5th edition of UWS's Connolly and Begg book "Database Systems, A Practical Approach to Design, Implementation, and Management". [7] [8] [9] Crowe retired from UWS in 2018 after a working life of 46 years at the same institution. [2] He has continued his participation in computer science with 2019 seeing a version 7 of his PyrrhoDB having an alpha release, development of a new Database Management System, StrongDBMS.

Pyrrho DBMS

Crowe developed the Pyrrho Database Management System (DBMS) in the 2000s to explore optimistic concurrency control and other features applicable to relational databases. [5]

Bibliography

Related Research Articles

<span class="mw-page-title-main">Database</span> Organized collection of data in computing

In computing, a database is an organized collection of data or a type of data store based on the use of a database management system (DBMS), the software that interacts with end users, applications, and the database itself to capture and analyze the data. The DBMS additionally encompasses the core facilities provided to administer the database. The sum total of the database, the DBMS and the associated applications can be referred to as a database system. Often the term "database" is also used loosely to refer to any of the DBMS, the database system or an application associated with the database.

<span class="mw-page-title-main">Object database</span> Type of database management system

An object database or object-oriented database is a database management system in which information is represented in the form of objects as used in object-oriented programming. Object databases are different from relational databases which are table-oriented. A third type, object–relational databases, is a hybrid of both approaches. Object databases have been considered since the early 1980s.

A relational database is a database based on the relational model of data, as proposed by E. F. Codd in 1970. A system used to maintain relational databases is a relational database management system (RDBMS). Many relational database systems are equipped with the option of using SQL for querying and updating the database.

Structured Query Language (SQL) is a domain-specific language used in programming and designed for managing data held in a relational database management system (RDBMS), or for stream processing in a relational data stream management system (RDSMS). It is particularly useful in handling structured data, i.e., data incorporating relations among entities and variables.

<span class="mw-page-title-main">Object–relational database</span> Database management system

An object–relational database (ORD), or object–relational database management system (ORDBMS), is a database management system (DBMS) similar to a relational database, but with an object-oriented database model: objects, classes and inheritance are directly supported in database schemas and in the query language. In addition, just as with pure relational systems, it supports extension of the data model with custom data types and methods.

<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 DB/2, then DB2 until 2017 and finally 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.

Oracle Database is a proprietary multi-model database management system produced and marketed by Oracle Corporation.

<span class="mw-page-title-main">University of the West of Scotland</span> Public research university in south-western Scotland

The University of the West of Scotland, formerly the University of Paisley, is a public university with four campuses in south-western Scotland, in the towns of Paisley, Blantyre, Dumfries and Ayr, as well as a campus in London, England.

InterSystems Caché is a commercial operational database management system from InterSystems, used to develop software applications for healthcare management, banking and financial services, government, and other sectors. Customer software can use the database with object and SQL code. Caché also allows developers to directly manipulate its underlying data structures: hierarchical arrays known as M technology.

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">Physical schema</span> Representation of a data design

A physical data model is a representation of a data design as implemented, or intended to be implemented, in a database management system. In the lifecycle of a project it typically derives from a logical data model, though it may be reverse-engineered from a given database implementation. A complete physical data model will include all the database artifacts required to create relationships between tables or to achieve performance goals, such as indexes, constraint definitions, linking tables, partitioned tables or clusters. Analysts can usually use a physical data model to calculate storage estimates; it may include specific storage allocation details for a given database system.

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.

Database administration is the function of managing and maintaining database management systems (DBMS) software. Mainstream DBMS software such as Oracle, IBM Db2 and Microsoft SQL Server need ongoing management. As such, corporations that use DBMS software often hire specialized information technology personnel called database administrators or DBAs.

An embedded database system is a database management system (DBMS) which is deeply integrated with an application software; it is built into the software or an application. It is a broad term which includes:

The Base One Foundation Component Library (BFC) is a rapid application development toolkit for building secure, fault-tolerant, database applications on Windows and ASP.NET. In conjunction with Microsoft's Visual Studio integrated development environment, BFC provides a general-purpose web application framework for working with databases from Microsoft, Oracle, IBM, Sybase, and MySQL, running under Windows, Linux/Unix, or IBM iSeries or z/OS. BFC includes facilities for distributed computing, batch processing, queuing, and database command scripting, and these run under Windows or Linux with Wine.

Polyhedra is a family of relational database management systems offered by ENEA AB, a Swedish company. The original version of Polyhedra was an in-memory database management system which could be used in high availability configurations; in 2006 Polyhedra Flash DBMS was introduced to allow databases to be stored in flash memory. All versions employ the client–server model to ensure the data are protected from misbehaving application software, and they use the same SQL, ODBC and type-4 JDBC interfaces. Polyhedra is targeted primarily for embedded use by Original Equipment Manufacturers (OEMs), and big-name customers include Ericsson, ABB, Emerson, Lockheed Martin, United Utilities and Siemens AG.

Database preservation usually involves converting the information stored in a database to a form likely to be accessible in the long term as technology changes, without losing the initial characteristics of the data.

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

XLeratorDB is a suite of database function libraries that enable Microsoft SQL Server to perform a wide range of additional (non-native) business intelligence and ad hoc analytics. The libraries, which are embedded and run centrally on the database, include more than 450 individual functions similar to those found in Microsoft Excel spreadsheets. The individual functions are grouped and sold as six separate libraries based on usage: finance, statistics, math, engineering, unit conversions and strings. WestClinTech, the company that developed XLeratorDB, claims it is "the first commercial function package add-in for Microsoft SQL Server."

The following outline is provided as an overview of and topical guide to MySQL:

References

  1. 1 2 3 "Academe". cis.uws.ac.uk. Archived from the original on 26 May 2015. Retrieved 23 October 2019.
  2. 1 2 "University of the West of Scotland". Facebook. 1 July 2018. Archived from the original on 21 October 2019. Retrieved 21 October 2019.
  3. ↑ "Malcolm Crowe's Home Page". cis.uws.ac.uk. Archived from the original on 2 August 2016. Retrieved 23 October 2019.
  4. 1 2 Atkinson & Crowe (2006), p. vii.
  5. 1 2 Laiho, Martti; Laux, Fritz (5 October 2011). On SQL Concurrency Technologies — - for Application Developers (PDF). DBTechNet (Report). p. 50. Archived (PDF) from the original on 29 November 2019. Retrieved 29 November 2019.
  6. ↑ "The Pyrrho DBMS". pyrrhodb.uws.ac.uk. Archived from the original on 1 October 2018. Retrieved 23 October 2019.
  7. ↑ Laiho, Martti; Laux, Fritz; Petrov, Ilia; Dervos, Dimitris (9 September 2017). "2.6 Pyrrho DBMS". SQL Stored Routines - Procedural Extensions of SQL and External Routines in Transactional Context (PDF). DBTechNet (Report). Archived (PDF) from the original on 19 February 2018. Retrieved 22 October 2019.
  8. ↑ "DBTechNet". DBTechNet. Archived from the original on 7 May 2018. Retrieved 22 October 2019.
  9. ↑ Connolly, Thomas M.; Begg, Carolyn E. (2010) [1995]. Database Systems: A Practical Approach to Design, Implementation and Management (5 ed.). Pearson. ISBN   9780321523068. E. Introduction to Pyrrho—A Liteweight RDBMS.
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.