STSdb is fully embedded .NET database so there is zero administration needed and it has direct connection with the application.
STSdb is a flawless back-end for real time applications as: Finance, Industry Automation, Process Control, Building Automation, Supervisory Control and Data Acquisition, Human Machine Interface, OPC History, Data Access.
STSdb Engine is based on innovative file system. So by using a file system it provides an enumerable set of isolated sequential bytes to the database.
Implemented ACID (atomicity, consistency, isolation, durability) transactions are executing on a single table (single transaction) or table set (complex transaction) level.
STSdb owns the ability to set a complex primary key. In database design, a compound key is a key that consists of 2 or more attributes that uniquely identify an entity occurrence.
Instantaneous picture of the table that represents an isolated copy of the original data. In essence, the snapshot is a derived table that shares common records with a parental table.
STSdb provides unified infrastructure for the record access - XTable. That way we only have table with primary key and record without performance penalty.
STSdb defines hierarchy model of the scheme. The scheme hierarchy allows partitioning the data on a database level.
STSdb is implemented and inter-operate on Windows, Linux, BSD, UNIX, Mac OS X under the Mono platform.
STSdb works with LINQ. With LINQ, a query is now a first-class language construct, just like classes, methods, events and so on.
STSdb own integrated compression algorithms for all basic type of data and vertical data compression support for compressing columns of data.
The amount of records in a table exclusively depends on the key cardinality i. e. an arbitrary by size ordered space of keys can be generated.
Sections