Linter is a Russian DBMS [1] that implements the SQL: 2003 standard (with the exception of non-scalar data types and object-oriented features) [2] and supports major operating systems , including the Windows family, various versions of UNIX , and real-time QNX operating systems and etc.
| Linter | |
|---|---|
 | |
| Type of | DBMS |
| Developer |  Russia : RELEX |
| operating system | Cross-platform software |
| Latest version | BASTION, STANDARD |
| License | a commercial |
| Website | www.linter.ru |
Content
- 1 History
- 1.1 Linter and differences from Linter-VS
- 1.2 Current state of Linter
- 2 Hardware and software platforms
- 3 DBMS Linter Technical Specifications
- 4 Editions
- 5 notes
- 6 References
History
The history of DBMS Linter [3] begins in 1980. The system had its own domestic predecessors, in the development of which the creators of DBMS Linter took a direct part. By 1983, in the Voronezh SKTB "Systemprograms", as part of the state order, a relational DBMS BARS [4] project was developed and successfully completed under the control of the RAFOS real-time operating system (prototype RT-11 ) for machines of the SM computer family.
Since 1985, the developers of the system [5] adopted the concept of mobility, compatibility and openness, the implementation of which led to the creation of the DBMS INTEREAL [6] . This system covered a wide range of software and hardware platforms [7] : from the Electronics-85 computer and control modules based on Intel 8086 to computing systems based on CM1702, Electronics 82, and their prototypes of the VAX family.
In 1990, the DBMS development team founded the RELEX (Relational Expert Systems) research and production enterprise. It was then that the DBMS Linter appeared. [8]
The main applications of DBMS LINTER [9] : government projects, real-time systems, embedded systems [10] , etc. For DBMS LINTER, there are software interfaces for most popular development tools. DBMS Linter is the only one in its class that has certificates [11] for compliance with Class 2 of information protection against unauthorized access [12] and Level 2 of the control of the absence of undeclared capabilities [13] for CBT.
On June 2, 2015, the Ministry of Telecommunications and Communications of Russia publishes the “Protocol for the peer review of projects for import substitution of infrastructure software”, in which the project “Creating an independent stack of domestic technologies DBMS Linter, which provides effective substitution of corporate solutions from third-party manufacturers and the implementation of a full range of new generation automated systems”, takes 2nd place in the direction of "Database Management Systems". Among domestic organizations admitted to the implementation of works, RTC “RELEX”, LLC “Diasoft Platform”, “Technoserv” Group, etc. are indicated [14]
On March 18, 2016, by decision of the Expert Council for Software under the Ministry of Communications of Russia, DBMS Linter was included in the unified register of Russian programs for electronic computers and databases (Russian software registry). The corresponding order was signed by the head of the Ministry of Communications of Russia Nikolai Nikiforov. [fifteen]
Linter and differences from Linter-VS
Linter and Linter-VS are different DBMS .
In the late 90s, as part of the projects of the Ministry of Defense of the Russian Federation, NPP RELEX CJSC, the Linter-VS 6.0 system was developed. The prototype of this system was the commercial version of DBMS Linter 5.7 of the 1999 sample, also developed at RELEX .
It should not be confused with the DBMS “Linter-VS” (starting from version 6.0.1) developed by VNIINS JSC for the MSWS OS based on PostgreSQL 7.4, 8.4, and 9.2 [16] .
Linter-VS 6.0 [17] works only under the control of the MSVS operating system.
The current state of Linter
The current stable version is 6.0.17.53. Release Date: 02.15.2018
Hardware and software platforms
|
|
|
|
DBMS Linter Technical Specifications
| Feature Name | Value |
| Database size | Up to 65535 tables each up to 12 TB |
| The number of rows in one table | Up to 2³⁰ (~ 1 billion) |
| The number of rows selected by one query | Up to 2³⁰ (~ 1 billion) |
| Row size (not counting BLOB fields) | Up to 64K |
| String value size (except BLOB and UNICODE) | Up to 4000 characters (4000 bytes) |
| UNICODE value size | Up to 2000 characters (4000 bytes) |
| Blob Size | Up to 2³¹ (~ 2 billion bytes) |
| The number of fields in a row | Up to 250 |
| The minimum amount of memory occupied by the DBMS kernel | 3 Mb (for specialized versions - from 800K) |
| Data Protection [22] | 2 class of data protection against unauthorized access and 2 level of control of the absence of undeclared capabilities. Mandatory control of data access at the level of tables, columns, rows and individual row fields. Control access to workstations and storage devices. Scheduled access control to the DBMS. Management of logging operations on the database (audit). Authentication of users through LDAP, Kerberos, means of the operating system. Password hashing using the FIPS 180-2 SHA-224 algorithm [23] . |
| Full Text Indexing Formats | TXT, XML, HTML, PDF, DOC, DOCX, XLS, XLSX, PPT, PPTX, Open Office, PS |
| Software interfaces | ODBC 3.x (including 3.8), JDBC (1, 2, 3, 4, 4.1, 4.2), Hibernate, Hibernate Spatial, Apache Cayenne, EclipseLink, OLE DB, ADO.NET 2.0 / 3.x / 4.x ( including support for LINQ and Entity Framework; support up to Visual Studio 2017 inclusive), dbExpress, Perl (including DBI), PHP (including PDO), Python (including Django), Ruby on Rails, Tcl / Tk, Qt (4.x. 5 . x ), Mono, Embedded SQL. |
| Converting data from other DBMS | Conversion utilities working through ODBC and ADO.NET. Converter from DBF format. Data Model Converter (from ERwin to Linter) |
| Hot standby | The hot standby system operates in conjunction with DBMS LINTER on computers with operating systems such as Unix or Windows, the same software and hardware architecture, and the TCP / IP protocol. The hot standby system provides a higher degree of reliability of DBMS LINTER functioning in the event of a failure of computing equipment or software |
| Administration | Pseudographic and graphical utilities for Windows and UNIX - desktop, database archiver, database converter, database testing and recovery, database migration, debugger of stored procedures and triggers |
| Archiving | Full, selective, incremental, scheduled, according to the script, the ability to archive to tape |
| Replication | Asynchronous (including bidirectional), replication with other databases through ODBC is possible |
| Synchronization | With various DBMSs via ODBC via online TCP / IP protocols (including via SSL), HTTP, HTTPS and offline transports - ActiveSync, ftp, e-mail, etc. |
| Development tools | Any development tools that support ODBC, JDBC, OLE DB, ADO.NET, dbExpress, Qt, etc. |
| Supported Platforms | Linux (various versions and hardware platforms, including Embedded Linux and 64-bit versions of Linux), MSVS, Solaris (various versions and platforms), Mac OS X, BSD (OpenBSD, FreeBSD, BSDI, NetBSD various versions), UnixWare, IRIX, AIX, SINIX, QNX (including QNX 6), USIX, VxWorks, OS-9, OS-9000, OS RV, INTROS, VMS, OpenVMS, Windows (XP, NT4, Vista, Windows7, Windows Server 2008, Windows Server 2012, Windows Server 2016), Android, Maemo, Windows CE |
| Support for internationalization tools | Support for SQL CHARACTER SET and TRANSLATION objects. Support for Cyrillic encodings (CP866, CP1251, KOI8-R), European encodings CP437, CP850, CP1252, CP8859-1 ... CP8859-15, multibyte encodings (CP932, CP946, CP949, CP950, 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 | According to the OpenGIS specification: POINT, LINESTRING, POLYGON, MULTIPOINT, MULTILINESTRING, MULTIPOLYGON, GEOMETRYCOLLECTION For compatibility with PostgreSQL: BOX, LINE, CIRCLE |
| Geometric functions | According to the OpenGIS specification:
|
| Supported Network Protocols | TCP / IP (including SSL) |
| SQL language standard support | Support for the SQL: 2003 standard, with the exception of non-scalar data types and object-oriented features. |
| SQL Procedural Extensions | Native syntax for stored procedures and triggers. Debugging tools for stored procedures and triggers. |
Editions
DBMS Linter comes in two editions.
| Title | Features | Operating platforms |
|---|---|---|
| Linter BASTION | provides the degree of protection of the processed information to the level of state secret "top secret" inclusive | Windows Linux QNX [24] |
| Linter STANDARD | solving the main problems facing a modern DBMS | Windows Linux |
Notes
- ↑ Natalia Elmanova, “A few words about the DBMS of Russian manufacturers”, “Computer Press” No. 7/2002
- ↑ Technical overview of DBMS Linter .
- ↑ S. P. Markin , I. A. Boychenko , V. E. Maksimov , L. A. Kozlenko “Protected relational DBMS Linter” “Open Systems” No. 11-12 / 1999
- ↑ Director of RELEX Igor Boychenko: “Voronezh can become the center of a DBMS building” , Abireg (09/28/2012).
- ↑ Database management system with relational type interface (INTEREAL) (inaccessible link)
- ↑ M. R. Kogalovsky "Encyclopedia of Database Technologies" -M.: Finance and Statistics, 800 pp. Excerpt from the book
- ↑ DBMS INTERAL (inaccessible link)
- ↑ RELEX History
- ↑ BELTIM-Complex information protection systems - Specialized DBMS - DBMS Linter
- ↑ Examples of embeded system on Linter
- ↑ State Register of Certified Information Security Tools FSTEC xls, March 12, 2008
- ↑ RD "Indicators of security against unauthorized access to information" (inaccessible link) . Date of treatment March 24, 2008. Archived March 31, 2008.
- ↑ RD "Classification according to the level of control of the absence of undeclared opportunities" (inaccessible link) . Date of treatment July 27, 2008. Archived March 15, 2008.
- ↑ Ministry of Communications of Russia. Protocol of expert evaluation of projects on import substitution of infrastructure software in accordance with paragraphs 4-8 of the plan for import substitution of software (June 2, 2015).
- ↑ Ministry of Communications of Russia. The Russian software registry is supplemented by 155 software products (March 18, 2016).
- ↑ NIIFI and VT (inaccessible link)
- ↑ DBMS for specialized systems
- ↑ Securitylab
- ↑ Elbrus
- ↑ SWD Software, QNX, Embedded Database Management Systems
- ↑ DBMS Linter BASTION successfully tested on ReactOS
- ↑ Information Security in Modern Database Management Systems
- ↑ Information Technology Laboratory National Institute of Standards and Technology. FIPS PUB 180-4 FEDERAL INFORMATION PROCESSING STANDARDS PUBLICATION Secure Hash Standard (SHS ) . NIST (March 2012). - - current version of the standard for May 2015; also see https://www.ietf.org/rfc/rfc3874.txt.+ Date accessed May 23, 2015.
- ↑ DBMS Linter on the QNX distributor’s website .
- ↑ Astra Linux (inaccessible link) . Date of treatment September 13, 2012. Archived April 15, 2011.
- ↑ SVD Embedded Systems