MSQL

Last updated
Mini SQL or mSQL
Developer(s) Hughes Technologies
Stable release
4.4 / October 20, 2021;2 years ago (2021-10-20) [1]
Written in C
Operating system Cross-platform
Available inEnglish
Type RDBMS
License Proprietary
Website www.hughestech.com.au/products/msql/

Mini SQL (abbreviated mSQL) is a lightweight database management system from Hughes Technologies.

Contents

History

In 1993–94 David Hughes developed a network monitoring and management system called Minerva. [2] The design of this system required a database management system to store its configuration and working data. To enable future portability, Hughes elected to use a Structured Query Language interface between the application and the database management system, despite the fact that at the time there was no free or inexpensive SQL database management implementation available. Hughes therefore developed a translation program which provided an SQL interface to the free Postgres DBMS (which did not use SQL [3] ). This product was named miniSQL,[ clarification needed ] or mSQL. In time it became clear that Postgres did not perform adequately on the low-specification systems used to run Minerva, so mSQL developed into a lightweight database management system in its own right, implementing a limited subset of the SQL standard, but performing well on minimally specified hardware. [4]

mSQL was the first low-cost SQL-based database management system.[ citation needed ] Combined with the free Linux operating system, the availability of relatively powerful low-cost PC hardware, and the development of World Wide Web standards and technologies, mSQL was an important factor in the early development of interactive, dynamic web applications, [5] particularly in the period 1994–1997, after which it was increasingly supplanted by the more highly featured MySQL. mSQL had a large and widespread install base by the late 1990s. [6]

License

Despite being offered in source code form, and being strongly associated with open source software, mSQL itself has never been offered under an open source license.

mSQL is provided free for non-commercial use. [6] A typical license for commercial use in 1997 would cost $170, [5] compared to a "five-digit purchase price" [7] for its full-featured competitors.

Current status

By 1996, development on mSQL began to stagnate and MySQL arose to fill that void. By 1999, MySQL had surpassed mSQL [6] in popularity and today mSQL has less visibility. At this time the database system is more often licensed by other companies for use in their products than used by end-users directly. mSQL is actively maintained and developed primarily to support its licensees and internal use within Hughes Technologies products and projects. It is still provided under a license that allows its use free of charge for non-commercial, educational and charitable activities. mSQL 4.4 was released in October 2021.

Host languages

mSQL originally supported several host languages:

See also

Related Research Articles

<span class="mw-page-title-main">MySQL</span> SQL database engine software

MySQL is an open-source relational database management system (RDBMS). Its name is a combination of "My", the name of co-founder Michael Widenius's daughter My, and "SQL", the acronym for Structured Query Language. A relational database organizes data into one or more data tables in which data may be related to each other; these relations help structure the data. SQL is a language that programmers use to create, modify and extract data from the relational database, as well as control user access to the database. In addition to relational databases and SQL, an RDBMS like MySQL works with an operating system to implement a relational database in a computer's storage system, manages users, allows for network access and facilitates testing database integrity and creation of backups.

<span class="mw-page-title-main">PostgreSQL</span> Free and open-source object relational database management system

PostgreSQL, also known as Postgres, is a free and open-source relational database management system (RDBMS) emphasizing extensibility and SQL compliance. PostgreSQL features transactions with atomicity, consistency, isolation, durability (ACID) properties, automatically updatable views, materialized views, triggers, foreign keys, and stored procedures. It is supported on all major operating systems, including Linux, FreeBSD, OpenBSD, macOS, and Windows, and handles a range of workloads from single machines to data warehouses or web services with many concurrent users.

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">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">Ingres (database)</span> Database software

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

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

<span class="mw-page-title-main">Data definition language</span> Syntax for defining data structures

In the context of SQL, data definition or data description language (DDL) is a syntax for creating and modifying database objects such as tables, indices, and users. DDL statements are similar to a computer programming language for defining data structures, especially database schemas. Common examples of DDL statements include CREATE, ALTER, and DROP. If you see a .ddl file, that means the file contains a statement to create a table. Oracle SQL Developer contains the ability to export from an ERD generated with Data Modeler to either a .sql file or a .ddl file.

The following tables compare general and technical information for a number of relational database management systems. Please see the individual products' articles for further information. Unless otherwise specified in footnotes, comparisons are based on the stable versions without any add-ons, extensions or external programs.

<span class="mw-page-title-main">Null (SQL)</span> Marker used in SQL databases to indicate a value does not exist

In SQL, null or NULL is a special marker used to indicate that a data value does not exist in the database. Introduced by the creator of the relational database model, E. F. Codd, SQL null serves to fulfil the requirement that all true relational database management systems (RDBMS) support a representation of "missing information and inapplicable information". Codd also introduced the use of the lowercase Greek omega (ω) symbol to represent null in database theory. In SQL, NULL is a reserved word used to identify this marker.

<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.

The acronyms BAPP and BAMP refer to a set of open-source software programs commonly used together to run dynamic websites or servers. This set is a solution stack, and an open source web platform.

A spatial database is a general-purpose database that has been enhanced to include spatial data that represents objects defined in a geometric space, along with tools for querying and analyzing such data.

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.

A hierarchical query is a type of SQL query that handles hierarchical model data. They are special cases of more general recursive fixpoint queries, which compute transitive closures.

<span class="mw-page-title-main">Michael Stonebraker</span> American computer scientist (born 1943)

Michael Ralph Stonebraker is a computer scientist specializing in database systems. Through a series of academic prototypes and commercial startups, Stonebraker's research and products are central to many relational databases. He is also the founder of many database companies, including Ingres Corporation, Illustra, Paradigm4, StreamBase Systems, Tamr, Vertica and VoltDB, and served as chief technical officer of Informix. For his contributions to database research, Stonebraker received the 2014 Turing Award, often described as "the Nobel Prize for computing."

Hyper Text Structured Query Language (HTSQL) is a schema-driven URI-to-SQL query language that takes a request over HTTP, converts it to a SQL query, executes the query against a database, and returns the results in a format best suited for the user agent The HTSQL language is implemented on "HTSQL servers," which use HTSQL to convert web requests into equivalent SQL, executes requests on a server-side database, and returns results in XML, HTML, CSV, JSON, or YAML formats. The current implementation as of April 2010 uses Python and works with PostgreSQL, MySQL, SQLite, Oracle, and Microsoft SQL Server databases.

Amazon Relational Database Service is a distributed relational database service by Amazon Web Services (AWS). It is a web service running "in the cloud" designed to simplify the setup, operation, and scaling of a relational database for use in applications. Administration processes like patching the database software, backing up databases and enabling point-in-time recovery are managed automatically. Scaling storage and compute resources can be performed by a single API call to the AWS control plane on-demand. AWS does not offer an SSH connection to the underlying virtual machine as part of the managed service.

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

<span class="mw-page-title-main">YugabyteDB</span> Transactional distributed SQL database

YugabyteDB is a high-performance transactional distributed SQL database for cloud-native applications, developed by Yugabyte.

References

  1. ↑ "Hughes Technologies : The home of mSQL and Network Knowledge". hughestech.com.au. Retrieved 2021-04-19.
  2. ↑ "Minerva : An Event Based Model For Extensible Network Management". CiteSeerX   10.1.1.48.4006 .
  3. ↑ Yarger, Randy Jay; Reese, George; King, Tim (1999). MySQL & mSQL. O'Reilly. p.  8. ISBN   1-56592-434-7.
    "Postgres, unfortunately, came with similar resource requirements as its commercial counterparts without the advantage of SQL as a query language. At the time, postgres used a variant of the QUEL language called PostQUEL"
  4. ↑ Yarger, Randy Jay; Reese, George; King, Tim (1999). MySQL & mSQL. O'Reilly. p.  9. ISBN   1-56592-434-7.
  5. 1 2 Burkett, Scott (1997). "Using mSQL in a Web-Based Production Environment". Linux Journal. Retrieved 29 May 2010.
  6. 1 2 3 Komarinski, Mark F.; Collett, Cary (2000). Red Hat Linux system administration handbook. Prentice Hall. p. 203. ISBN   978-0-13-025395-8.
  7. ↑ Lerner, Reuven (1999). "Review: MySQL & mSQL". Linux Journal. Retrieved 29 May 2010.
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.