- SQL support;
- a variety of functions providing compatibility with Oracle and PostgreSQL at the SQL level;
- query optimizer;
- rich 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;
- easy integration and embeddability in user applications;
- high performance;
- 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:
|
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
|
|
