Linter SQL RDBMS: Difference between revisions

Revision as of 09:38, 18 November 2009

Latest revision as of 00:34, 13 June 2025

(58 intermediate revisions by 35 users not shown)

Line 1:

{{Short description|Russian proprietary database system}}

{{infobox OS

{{Infobox software

| name = Linter SQL

| logo = [[Image:BoxLinterEngLinter.jpg]]svg

| genre = [[RDBMS]]

| developer = [[RELEX Group]]

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

| operating_system = [[cross-platform system]]

| license = commercial[[Proprietary software|Proprietary]]

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

}}

'''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. Steph Loves Aidan .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}}</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 of Linter SQL RDBMS==

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

|-

| '''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]]

| Class 2

|-

| Full-text indexing formats

| [[PDF]], [[DOC (computing)|DOC]], [[TXT]], [[XLS]], [[XML]], [[PS]], [[PPT]]

|-

| 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]], [[PHP]], [[Python (programming language)|Python]], [[OCI]], [[ADO.NET]]

|-

| [[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]] (various versions and platforms), [[Mac OS X]], [[BSD]] (various versions of OpenBSD, FreeBSD, BSDI, NetBSD), [[UnixWare]], [[IRIX]], [[AIX]], [[SINIX]], [[QNX]], [[USIX]], [[VxWorks]], [[OS-9]], [[OS-9000]], [[OC2000]], ИНТРОС , [[VMS]], [[Microsoft Windows|Windows]] (95, 98, Me, 2000, XP, NT4), [[WindowsCE]]

|-

| 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 [[SSL]]), [[SPX]], [[NetBios]], [[Named Pipes]]

|-

|}

==References==

Line 82 ⟶ 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/ RELEX Group] {{Webarchive|url=https://web.archive.org/web/20160403064405/http://relex.ru/en/ |date=2016-04-03 }}

* [http://relex.ru/main_eng.php Relex Group]

* [http://www.relexus.com/ RelexUS]

[[Category:Proprietary database management systems]]

[[Category:OS/2 software]]

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

[[Category:Solaris software]]

[[Category:Unix software]]

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

[[Category:Windows database-related software]]

{{database-software-stub}}

[[ru:ЛИНТЕР]]