Linter SQL RDBMS: Difference between revisions

Revision as of 12:54, 21 May 2007

Latest revision as of 00:34, 13 June 2025

(86 intermediate revisions by 49 users not shown)

Line 1:

{{Short description|Russian proprietary database system}}

{{Notability|date=April 2007}}

{{Infobox software

{{Unreferenced|date=April 2007}}

| name = Linter SQL

[[Image:BoxLinterEng.jpg|right]]

| logo = Linter.svg

| genre = [[RDBMS]]

| developer = [[RELEX Group]]

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

| license = [[Proprietary software|Proprietary]]

| website = {{URL|linter.ru/en/}}

}}

'''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]], [[QNX]], 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==

'''Linter''' SQL RDBMS is the main product of [[Relex Incorporated|Relex]]. Relex Linter was based off of a design created by now-Relex engineers over 15 years ago. Linter is implemented in [[Sony]] products, including a Linter phone ([[Sony Ericsson SO903i]]), [[Kenwood]] systems, [[ADIC]] systems, [[Thomson Corporation|Thomson]] systems, and [[NASA]] systems.{{Fact|date=February 2007}}

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.

Linter is a cross-platform system which operates on [[Win32]] (including [[Windows СE]]), [[NetWare]], various versions of [[Unix]], [[OS9/9000]], [[QNX]], and [[VxWorks]]. The system enables transparent interaction between the client applications and the database server functioning in different hardware and software environments.

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>

Linter is equipped with multiple service facilities, including various utilities and program interfaces:

==References==

- interactive/package SQL interface – Inl;

<references/>

- administration utilities (graphic, pseudographic, command line utilities) providing the user with a set of database administration and information processing tools;

- PCI - embedded SQL for C and C++;

- ODBC – ODBC 3.x interface;

- OLE DB – interface for accessing data in the Windows environment;

- Perl – interface for accessing Linter resources from Perl programs (supports DBI specifications and native developments);

- Php – interface for accessing Linter resources from programs written in PHP (v. 3.х, 4.х, 5.х);

- dbExpress – interface for accessing Linter from Delphi/Kylix/C++ Builder;

- Jdbc - interface supporting JDBC 1.0, 2.0, 3.0;

- Lintcl - interface supporting Tcl/Tk;

- LinPy - interface for accessing data from Python programs;

- Oralin - interface for using Linter in programs developed using the OCI interface of Oracle;

- LinAPI (Linter Application Program Interface) – high-level interface for developing complex programs in C;

- Call – low-level program interface.

Linter supports asynchronous mode, query processing by priority, the use of pre-translated queries, which makes it possible to work with real-time operating systems.

Linter supports geometric data types allowing the user to create, store and process geographical data.

'''Technical Characteristics of Linter SQL Server'''

- SQL-92 support;

- a variety of functions providing compatibility with Oracle and PostgreSQL at the SQL level;

- query optimizer;

- stored procedure and trigger language;

- real-time application support facilities;

- hierarchical transaction support;

- full-text indexing for varoius document types (including indexation of XML documents);

- ANSI levels of transaction isolation;

- support of national encodings and UNICODE;

- high data security;

- a wide variety of hardware and software platforms supported;

- a wide variety of program interfaces;

- guaranteed main memory space;

- a wide range of administration utilities (for UNIX and WIN32);

- highly developed database archiving tools (including tools for incremental archiving);

- Oracle extension support (SEQUENCE, JOIN etc.);

- possibility to synchronize data between databases (including pocket computers);

- bidirectional replication with rich conflict resolution capabilities;

- hot backup copying system;

- reliability.

'''Technical Parameters:'''

{| class="wikitable"

|-

| 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, TXT, XLS, XML, PS, PPT

|-

|Interaction with user tasks

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

|-

|Program Interfaces

| ODBC 3.х, JDBC(1,2,3), DBExpress, Embedded SQL, OLEDB, PERL, PERL/DBI, TCL/TK, PHP, Python, OCI, ADO.NET

|-

|Administration

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

|-

|Archiving

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

|-

|Replication

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

|-

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

For compatibility with PostgreSQL: BOX, LINE, CIRCLE

|-

|Geometric Functions

| OpenGIS specifications:

functions for creating geometric type values in binary and text views (GeomFromText, GeomFromWKB etc.);

functions for processing geometric data properties (general – Dimension, Envelope, Boundary etc., and special – 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

|}

==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 }}

[[Category:Proprietary database management systems]]

{{database-software-stub}}

[[Category: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]]

{{software-stub}}

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