Linter SQL RDBMS: Difference between revisions

Revision as of 08:58, 19 October 2012

Revision as of 01:28, 16 November 2012

Line 22:

| '''Value'''

|-

| Database size

| up to 65535 tables up to 12 Тb each

|-

| Number of records in a table

| up to 1 billion

|-

Line 34:

| up to 250

|-

| Minimum memory space occupied by the [[DBMS]] kernel

| 3 МB (for specialized versions – from 800 К)

|-

| [[Data security]] <ref>[[Classified information in Russia]]</ref> <ref>[[Classified information]]</ref>

| Class 2 (Completely Secret)

|-

| [[Database security]]

| [[Discretionary access control|Discretionary]] and [[Mandatory access control|mandatory]] [[Access control|access control]], Physical security, [[Encryption]], [[Capability-based security|Capability-Based Protection]], Work Station Database Access Control, External Carrier Data Input/Output Security, etc. <ref>[http://lintersql.com/en/documentation/pdf/new_2012/architecture_eng.pdf Linters documentation]</ref>

|-

| Full-text indexing formats

| [[PDF]], [[DOC (computing)|DOC]], [[Text file|TXT]], [[Microsoft Excel file format|XLS]], [[XML]], [[PostScript|PS]], [[Microsoft PowerPoint|PPT]], [[Open Office]]

|-

| 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]], [[Java (programming language)|Java]] ([[Hibernate]]), [[PHP]], [[Python (programming language)|Python]] ([[Django (Web framework)|Django]]), [[Qt (framework)|QT]], [[Ruby (programming language)|Ruby]], [[Oracle Call Interface|OCI]], [[ADO.NET]] ([[LINQ]]), [[1.x]], [[2.x]], [[3.x]], [[4.x]], [[Mono (software)|Mono]]

|-

Line 58:

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

|-

Line 71:

|-

| 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