Linter SQL RDBMS: Difference between revisions

Revision as of 13:04, 16 March 2013

Latest revision as of 00:34, 13 June 2025

(34 intermediate revisions by 21 users not shown)

Line 1:

{{Short description|Russian proprietary database system}}

{{Infobox software

| name = Linter SQL

| logo = [[File:Linter.svg|200px]]

| genre = [[RDBMS]]

| developer = [[RELEX Group]]

| programming language = [[C (programming language)|C]], [[C++]]{{Citation needed|date=August 2017}}

| operating_system = [[Cross-platform]]

| programming language = [[C (programming language)|C]], [[C++]]

| Platform = Cross-platform

| license = [[Proprietary software|Proprietary]]

| website = [http://{{URL|linter.ru/en/main/ http://lintersql.com]}}

}}

'''Linter SQL RDBMS''' is the main product of [[RELEX Group]]. Linter is a Russian DBMS compliant with the [[SQL-92:2003]] standard<ref>{{Cite web|url=http://linter.ru/en/review/characteristics/|title = СУБД ЛИНТЕР — Авторизация}}</ref> and supporting the majority of operating systems, among them [[Microsoft Windows|Win32]] (including [[WinCE]]), [[NetWareWindows]], various versions of [[Unix]], [[OS9]], [[QNX]], [[VxWorks]] and others. The system enables transparent interaction between the client [[Application software|applications]] and the database server functioning in different [[Computer hardware|hardware]] and [[Computer software|software]] environments. DBMS Linter includes program [[Interface (computer science)|interfaces]] for the majority of popular development tools. The system provides a high [[data security]] level allowing the user to work with secret information. Linter is the only [[DBMS]] certified by FSTEC of Russia as compliant with Class 2 data security requirements and Level 2 of undeclared feature absence control. For more than tenmany years, Linter has been used by Russian [[Ministry of Defence (Russia)|Ministry of Defense]], [[Ministry of Foreign Affairs (Russia)|Ministry of Foreign Affairs]] and other government bodies.

==History==

The history of Linter dates back to 1980. The system has domestic predecessors whose developers later took direct part in the creation of Linter. By 1983, according to a state order, the [[Voronezh]] construction design office "Systemprogramm" had successfully completed the relational DBMS "BARS" under the [[real-time operating system]] "RAFOS" ([[RT-11]] prototype) for computers of the SM set. Since 1985, the system developers accepted the mobility, compatibility and openness concept. As a result, DBMS "INTEREAL" was implemented. The system covered a wide spectrum of hardware and software platforms, from "Electronika-85" and [[Intel 8086]] control modules to SM1702 and "Electronika-82" computer complexes and their [[VAX]] prototypes. In 1990, the DBMS development team founded the research-and-production company "RELEX" ("Relational Expert Systems"). At this time DBMS Linter was launched. In the late 1990s, Linter-VS 6.0 was developed as part of a project performed by RELEX for the Russian Ministry of Defense. The prototype of the system was Linter 5.7 (1999) developed by RELEX. Linter-VS 6.0 is available only for OS MSVS (mobile system of the armed forces). There also exists Linter-VS 6.0.1 developed in VNIINS based on [[PostgreSQL]] 7.2 This system is also available for OS MSVS.</br>

RelX Embedded, a compact American/Japanese-developed version of Linter is implemented in [[Sony]] products, including a Linter phone ([[Sony Ericsson SO903i]]),<ref>{{cite web | url=http://www.linter.jp/topics/20070521.html | title=組込みシステム向けRDB「Linter」、ソニー・エリクソン製携帯電話「SO903i」「SO703i」に採用 : Linter.jp | publisher = Brycen Company Inc | date = 2007-05-21 | accessdate=2007-07-09}}</ref> as well as a [[Kenwood Corporation|Kenwood]] Navigation System ("HDD[Smá:t]Navi Emotional Sound" HDV-990 and HDV-790).<ref>{{cite web | url=http://relexus.com/pr/pr_020907.shtml | title=Company/FAQ - RelX: | publisher = RelXUS Inc | date = 2007-02-06 | accessdate=2007-07-09 |archiveurl = http://web.archive.org/web/20070503005640/http://www.relexus.com/pr/pr_020907.shtml <!-- Bot retrieved archive --> |archivedate = 2007-05-03}}</ref>

The system covered a wide spectrum of hardware and software platforms, from "Electronika-85" and [[Intel 8086]] control modules to SM1702 and "Electronika-82" computer complexes and their [[VAX]] prototypes. In 1990, the DBMS development team founded the research-and-production company "RELEX" ("Relational Expert Systems"). At this time DBMS Linter was launched.

==Technical parameters==

{| class="wikitable" border="1"

In the late 1990s, Linter-VS 6.0 was developed as part of a project performed by RELEX for the Russian Ministry of Defense. The prototype of the system was Linter 5.7 (1999) developed by RELEX. Linter-VS 6.0 is available only for OS MSVS (mobile system of the armed forces). There also exists Linter-VS 6.0.1 developed in VNIINS based on [[PostgreSQL]] 7.2 This system is also available for OS MSVS.<br>RelX Embedded, a compact American/Japanese-developed version of Linter is implemented in [[Sony]] products, including a Linter phone ([[Sony Ericsson SO903i]]),<ref>{{cite web | url=http://www.linter.jp/topics/20070521.html | title=組込みシステム向けRDB「Linter」、ソニー・エリクソン製携帯電話「SO903i」「SO703i」に採用 : Linter.jp | publisher = Brycen Company Inc | date = 2007-05-21 | accessdateaccess-date=2007-07-09}}</ref> as well as a [[Kenwood Corporation|Kenwood]] Navigation System ("HDD[Smá:t]Navi Emotional Sound" HDV-990 and HDV-790).<ref>{{cite web | url=http://relexus.com/pr/pr_020907.shtml | title=Company/FAQ - RelX: | publisher = RelXUS Inc | date = 2007-02-06 | accessdateaccess-date=2007-07-09 |archiveurl archive-url= httphttps://web.archive.org/web/20070503005640/http://www.relexus.com/pr/pr_020907.shtml <!-- Bot retrieved |archive --> |archivedate date= 2007-05-03 |url-status=dead }}</ref>

|-

| '''Parameter'''

| '''Value'''

|-

| Database size

| up to 65535 tables up to 12 Тb each

|-

| Number of records in a table

| up to 1 billion

|-

| Record size

| up to 64 К (not counting [[BLOB]] fields)

|-

| Number of fields in a record

| up to 250

|-

| Minimum memory space occupied by the [[DBMS]] kernel

| 3 МB (for specialized versions – from 800 К)

|-

| [[Data security]]<ref>[[Classified information in Russia]]</ref><ref>[[Classified information]]</ref>

| Class 2 (Completely Secret)

|-

| [[Database security]]

| [[Discretionary access control|Discretionary]] and [[Mandatory access control|mandatory]] [[access control]], Physical security, [[Encryption]], [[Capability-based security|Capability-Based Protection]], Work Station Database Access Control, External Carrier Data Input/Output Security, etc.<ref>[http://lintersql.com/en/documentation/pdf/new_2012/architecture_eng.pdf Linters documentation]</ref>

|-

| Full-text indexing formats

| [[PDF]], [[DOC (computing)|DOC]], [[Text file|TXT]], [[Microsoft Excel file format|XLS]], [[XML]], [[PostScript|PS]], [[Microsoft PowerPoint|PPT]], [[OpenOffice]]

|-

| Interaction with user tasks

| Low-level (CALL) and high-level (LinАpi) program interfaces

|-

| [[Interface (computer science)|Program Interfaces]]

| [[ODBC]] 3.х, [[JDBC]](1,2,3), DBExpress, [[Embedded SQL]], [[OLEDB]], [[PERL]], [[PERL/DBI]], [[TCL/TK]], [[Java (programming language)|Java]] ([[Hibernate]]), [[PHP]], [[Python (programming language)|Python]] ([[Django (Web framework)|Django]]), [[Qt (framework)|QT]], [[Ruby (programming language)|Ruby]], [[Oracle Call Interface|OCI]], [[ADO.NET]] ([[LINQ]]), [[1.x]], [[2.x]], [[3.x]], [[4.x]], [[Mono (software)|Mono]]

|-

| [[System administrator|Administration]]

| Pseudographic and graphic utilities for [[Microsoft Windows|Windows]] and [[UNIX]]: desktop, database archiver, database converter, database testing and recovery, database migration, stored procedure and trigger debugger

|-

| Archiving

| full, selective, incremental, scheduled, according to script, archiving to tape

|-

| [[Replication (computer science)|Replication]]

| asynchronous (including bidirectional replication); replication with other databases via [[ODBC]]

|-

| [[Synchronization (computer science)|Synchronization]]

| synchronization with various DBMSs via [[ODBC]] using online protocols [[TCP/IP]] (including synchronization via SSL), [[HTTP]], [[HTTPS]] and offline transports – [[ActiveSync]], [[ftp]], [[e-mail]] etc.

|-

| Development Tools

| pseudographic development system [[LAKUNA]], any development tools supporting [[ODBC]], [[JDBC]], DBExpress etc.

|-

| Supported Platforms

| [[Linux]] (different versions and hardware platforms, including Embedded Linux), МСВС, [[Solaris (operating system)|Solaris]] (various versions and platforms), [[Mac OS X]], [[BSD]] (various versions of OpenBSD, FreeBSD, BSDI, NetBSD), [[UnixWare]], [[IRIX]], [[AIX]], [[SINIX]], [[QNX]] ([[QNX 4]], [[QNX 6]]), [[USIX]], [[VxWorks]], [[OS-9]], [[OS-9000]], [[OC2000]], ИНТРОС, [[OpenVMS|VMS]], [[Microsoft Windows|Windows]] (95, 98, Me, 2000, XP, NT4, Vista, 7), [[WindowsCE]], [[Android (operating system)|Android]], [[Maemo]]

|-

| Data Types

| Char, Varchar, Nchar, Nchar Varying, Byte, Varbyte, Boolean, Smallint, Integer, Bigint, Real, Double, Numeric, Date, Blob, Extfile

|-

| Geometric Data Types

| [[OpenGIS]] specification: POINT, LINESTRING, POLYGON, MULTIPOINT, MULTILINESTRING, MULTIPOLYGON, GEOMETRYCOLLECTION</br>For compatibility with [[PostgreSQL]]: BOX, LINE, CIRCLE

|-

| Geometric Functions

| [[OpenGIS]] specifications:</br>functions for creating geometric type values in binary and text views (GeomFromText, GeomFromWKB etc.);</br>functions for processing geometric data properties (general – Dimension, Envelope, Boundary etc., and special – Length, Area, Centroid etc.);</br>geometric operators (Union, Intersection etc.);</br>functions describing relations between two geometric type values (Distance, Equals, Intersects etc.).

|-

| Supported [[Network Protocols]]:

| [[TCP/IP]](including [[Secure Sockets Layer|SSL]]), [[IPX/SPX|SPX]], [[NetBios]], [[Named Pipes]]

|-

|}

==References==

Line 88 ⟶ 22:

==External links==

* {{enin iconlang|en}} [httphttps://www.lintersqllinter.comru/en/ Linter Official Website in English]

* {{ruin iconlang|ru}} [httphttps://www.lintersqllinter.ru Linter Official Website in Russian]

* {{jpin iconlang|ja}} [httphttps://www.linter.jp Linter Japanese Website] {{Webarchive|url=https://web.archive.org/web/20190425070238/https://www.linter.jp/ |date=2019-04-25 }}

* [http://www.sai.msu.su/sal/H/1/RDBMS_LINTER_SQL.html RDBMS Linter SQL] at SAL (Scientific Applications on Linux), [[Moscow State University|MSU]]

* [http://www.relex.ru/en/main/ RelexRELEX Group] {{Webarchive|url=https://web.archive.org/web/20160403064405/http://relex.ru/en/ |date=2016-04-03 }}

[[Category:Proprietary database management systems]]

[[Category:OS/2 software]]

[[Category:MacMacOS OS Xdatabase-related software]]

[[Category:Solaris software]]

[[Category:Unix software]]

[[Category:LinuxRelational database-related management software for Linux]]

[[Category:Windows database-related software]]

{{database-software-stub}}