Linter SQL RDBMS: Difference between revisions

Revision as of 09:09, 1 June 2015

Latest revision as of 00:34, 13 June 2025

(19 intermediate revisions by 13 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: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|Windows]], various versions of [[Unix]], [[Mac OS X]], [[OS-9|OS9]], [[QNX]], [[VxWorks]], [[iOS]], [[Android (operating system)|Android]] 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 many 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==

{{Prose|date=May 2015}}

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 | access-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 |access-date=2007-07-09 |archive-url=https://web.archive.org/web/20070503005640/http://www.relexus.com/pr/pr_020907.shtml |archive-date=2007-05-03 |url-status=dead }}</ref>

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

|-

| '''Parameter''' <ref>http://linter.ru/en/review/characteristics/</ref>

| '''Value'''

|-

|Database size

|Up to 65535 tables up to 12Tb each.

|-

|Number of rows in a table

|Up to 2^30 (~1 billion).

|-

|Number of rows selected by a single query

|Up to 2^29 (~500 million).

|-

|Row size (not counting [[BLOB]] fields)

|Up to 64К.

|-

|String value size (except [[BLOB]] and [[UNICODE]])

|Up to 4000 characters (4000 bytes).

|-

|UNICODE value size

|Up to 2000 characters (4000 bytes).

|-

|BLOB value size

|Up to 2^31 (~ 2 billion bytes).

|-

|Number of fields in a row

|Up to 250.

|-

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

|3Mb (for special-purpose versions – from 800К).

|-

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

|Class 2 (Completely Secret) of data protection from unauthorized access and Level 2 of undeclared capabilities absence control. [[Mandatory access control|Mandatory]] [[access control]] to data at the level of tables, columns, records, and records of individual fields. Control of access to worksations and storage devices. Control of access to the database on a schedule. Manage logging operations on the database (audit). User authentication via LDAP, Kerberos, the operating system. Password hashing algorithm FIPS 180-2 SSA-224.

|-

|Full text indexing formats

|[[Text file|TXT]], [[XML]], [[HTML]], [[PDF]], [[DOC]], [[DOCX]], [[Microsoft Excel file format|XLS]], [[Microsoft Excel file format|XLSX]], [[Microsoft PowerPoint|PPT]], [[Microsoft PowerPoint|PPTX]], [[OpenDocument]], [[PostScript|PS]].

|-

|Data conversion from other DBMSs

|Conversion utilities working via [[ODBC]] and [[ADO.NET]]. [[DBF]] converter. Data model converter (from ERwin to Linter). The possibility of converting stored procedures from [[PL/SQL]] syntax

|-

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

|[[ODBC]] 3.х (including 3.8), [[JDBC]] (1,2,3, 4; support up to [[JDK]] 1.7 inclusive), [[OLE DB]], [[ADO.NET]] 1.x/2.x/3.x/4.x (including support of LINQ and Entity Framework; support up to Visual Studio 2012/2013 inclusive), dbExpress, [[Perl]] (including DBI), [[PHP]] (including PDO), [[Python (programming language)|Python]] (including [[Django (Web framework)|Django]]; support up to version Python 3.4 inclusive), [[Ruby (programming language)|Ruby]] (support Ruby 2), [[Tcl|Tcl/Tk]], [[Qt (framework)|Qt]] (3.x, 4.x. 5.x), [[Mono (software)|Mono]], [[Oracle Call Interface|OCI]] (compatibility interface with Oracle), [[Embedded SQL]].

|-

|[[Hot standby|Hot Standby]] System

|Hot Standby System operates in conjunction with Linter DBMS on computers with operating systems such as Unix, the same software and hardware architecture and protocol TCP/IP, provides a higher degree of reliability of the Linter DBMS in case of crash of computer equipment or software.

|-

|[[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, by script, archiving to tape.

|-

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

|Asynchronous (including bi-directional, multi-node with conflict resolution), replication with other databases via [[ODBC]] is possible.

|-

|Synchronization

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

|-

|Development tools

|Any development tools supporting [[ODBC]], [[JDBC]], [[OLE DB]], [[ADO.NET]], dbExpress, Qt etc.

|-

|Supported platforms

|* [[Linux]] (different versions and hardware platforms including Embedded Linux and 64-bit versions of Linux),

* [[Microsoft Windows|Windows]] (different versions and hardware platforms including XP, Vista, Windows7, Windows8, Windows Server 2011),

* [[Mac OS X]],

* MSVS,

* [[Solaris (operating system)|Solaris]] (different versions and hardware platforms),

* [[BSD]] (OpenBSD, FreeBSD, BSDI, NetBSD of different versions),

* [[AIX]],

* [[QNX]] (including QNX 6),

* [[VxWorks]],

* [[OS-9]],

* OS RV,

* INTROS,

* [[OpenVMS]],

* [[Android]],

* [[iOS]] etc.

|-

|Internationalization facilities support

|Support of CHARACTER SET and TRANSLATION objects of [[SQL]] standard. Supporting Cyrillic codepages (CP866, CP1251, KOI8-R), European codepages CP437, CP850, CP1252, CP8859-1 ... CP8859-15, multibyte codepages (CP932, CP946, CP949, СP950, EUC_JP), UTF-8. UNICODE support (for all versions).

|-

|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]] specification:<br />

*functions for creating geometric-type values using text and binary representation (GeomFromText, GeomFromWKB etc.);

*functions for analyzing properties of geometric data (general, i.e. Dimension, Envelope, Boundary etc., and special functions for each geometric data type, i.e. Length, Area, Centroid etc.);

*geometric operators (Union, Intersection etc.);

*functions describing relations between two geometric-type values (Distance, Equals, Intersects etc.).

|-

|Supported network protocols

|[[TCP/IP]] (including [[SSL]]), SPX, NetBios, Named Pipes.

|-

|SQL Standards Supported

|Support of [[SQL:2003]] standards, with the exception of non-scalar data types and object-oriented features

|-

|SQL Procedural Language Extensions

|Own syntax of stored procedures and triggers. Debugging tools of stored procedures and triggers. Possibility of converting stored procedures from syntax [[PL/SQL]].

|-

|}

==References==

Line 130 ⟶ 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:OS XMacOS database-related software]]

[[Category:Solaris software]]

[[Category:Unix software]]

[[Category:RDBMSRelational database management software for Linux]]

[[Category:Windows database-related software]]