Login  |  Register
E-mail:
Password:
Forgot your password?
E-Mail:

Authorization

Characteristics

The technical characteristics listed below are comon to all versions of the DBMS Linter family: BastionStandard irrespective of the OS.

Technical Characteristics:

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

Class 2 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 workstations 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, Open Office, 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,
- МСВС,
- Solaris (different versions and hardware platforms),
- BSD (OpenBSD, FreeBSD, BSDI, NetBSD of different versions),
- AIX,
- QNX (including QNX 6),
- VxWorks,
- OS-9,
- ОС РВ,
- ИНТРОС,
- 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.



ѕрокрутить вверх