Jump to content

Linter SQL RDBMS

From Wikipedia, the free encyclopedia
This is an old revision of this page, as edited by Intgr (talk | contribs) at 09:09, 1 June 2015 (→Technical parameters: Needs a rewrite). The present address (URL) is a permanent link to this revision, which may differ significantly from the current revision.
Linter SQL
Developer(s)RELEX Group
Written inC, C++
Operating systemCross-platform
TypeRDBMS
LicenseProprietary
Websitehttp://lintersql.com

Linter SQL RDBMS is the main product of RELEX Group. Linter is a Russian DBMS compliant with the SQL:2003 standard[1] and supporting the majority of operating systems, among them Windows, various versions of Unix, Mac OS X, OS9, QNX, VxWorks, iOS, Android and others. The system enables transparent interaction between the client applications and the database server functioning in different hardware and software environments. DBMS Linter includes program 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 Defense, 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.
RelX Embedded, a compact American/Japanese-developed version of Linter is implemented in Sony products, including a Linter phone (Sony Ericsson SO903i),[2] as well as a Kenwood Navigation System ("HDD[Smá:t]Navi Emotional Sound" HDV-990 and HDV-790).[3]

Technical parameters

Parameter [4] 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[5][6] Class 2 (Completely Secret) of data protection from unauthorized access and Level 2 of undeclared capabilities absence 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 TXT, XML, HTML, PDF, DOC, DOCX, XLS, XLSX, PPT, PPTX, OpenDocument, 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
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 (including Django; support up to version Python 3.4 inclusive), Ruby (support Ruby 2), Tcl/Tk, Qt (3.x, 4.x. 5.x), Mono, OCI (compatibility interface with Oracle), Embedded SQL.
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.
Administration Pseudographic and graphic utilities for 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 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),
  • Windows (different versions and hardware platforms including XP, Vista, Windows7, Windows8, Windows Server 2011),
  • Mac OS X,
  • MSVS,
  • 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.


For compatibility with PostgreSQL: BOX, LINE, CIRCLE.

Geometric functions OpenGIS specification:
  • 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

  1. ^ http://linter.ru/en/review/characteristics/
  2. ^ "組込みシステム向けRDB「Linter」、ソニー・エリクソン製携帯電話「SO903i」「SO703i」に採用 : Linter.jp". Brycen Company Inc. 2007-05-21. Retrieved 2007-07-09.
  3. ^ "Company/FAQ - RelX:". RelXUS Inc. 2007-02-06. Archived from the original on 2007-05-03. Retrieved 2007-07-09.
  4. ^ http://linter.ru/en/review/characteristics/
  5. ^ Classified information in Russia
  6. ^ Classified information
Retrieved from "https://en.wikipedia.org/w/index.php?title=Linter_SQL_RDBMS&oldid=664993044"