Results 1 to 7 of 7

Thread: How STSDB Works, and the technologies and stuff behind it.

  1. #1
    Junior Member
    Join Date
    Apr 2011
    Posts
    28

    Default How STSDB Works, and the technologies and stuff behind it.

    Please tell, how STSDB works, what it contains, and what are the technologies behind it. Is STSDB related to the technology of Google's BigTable?

  2. #2

    Default

    Hello,
    we are now extensively working on version 4 of the database, which will include several new layers, significant improvements and capabilities. After release we will prepare detailed documentation, which will reveal the internal database conception. For now to get an idea of some sides of database core, look at the following links:

    http://stssoft.com/forum/showthread.php?94-Internal-FileSystem-layer
    http://stssoft.com/forum/showthread.php?99-Can-t-delete-File-stored-in-Records-in-XTables-error-comes-up!
    http://stssoft.com/forum/showthread.php?100-DB-File-sizes
    http://stssoft.com/forum/showthread.php?67-STSdb-Access-Time#poststop

  3. #3

    Default

    Hello,

    Are you planning implement second indexes? It would be great improvement.

    My suggestion is:
    1. Store internally indexes as B+tree (or similar). Binary tree because to have possibility speed up interval search with "<, > .. etc".
    2. Select which class fields add to index with atribute. For example:

    Class Record
    {
    public int ID;
    double price;
    [Index]
    int clientCode;
    }
    
    3. Implement LINQ extended methods like "Where .. etc" to use indexes

    Second good improvement would be Thread safe data access in DB layer.

    And last one PLINQ

    And one disadvantage, which would be good to solve, is size of small transactions:
    http://stssoft.com/forum/showthread.php?100-DB-File-sizes

    Anyway, You did great job with STSDB!

    Best Regards,
    Saulius

  4. #4

    Default

    Are you planning implement second indexes?
    This is one of the high-priority tasks in the new version. The secondary indexes will be two types. The first type will be kept in sync with every change of the data. The second type will be built on demand.

    And one disadvantage, which would be good to solve, is size of small transactions
    This problem will be solved by the new garbage-collection layer. In version W4 it will have fully automatic compacting of database plus logical and physical defragmentation. Physical defragmentation will be responsible for the merging of free space blocks in large areas and respectively logical defragmentation will take into consideration the order in tables. All of these operations will be executed transparently without any impact on the normal workings of database.
    Last edited by k.dimova; 13.06.2013 at 17:47.

  5. #5
    Junior Member
    Join Date
    Apr 2011
    Posts
    28

    Default

    When will STSDB Version 4 be released?

  6. #6

    Default

    Quote Originally Posted by aroratushar View Post
    When will STSDB Version 4 be released?
    After several months.

  7. #7
    Junior Member
    Join Date
    Apr 2011
    Posts
    28

    Default Please include full support for storing Dictionary, HashTable

    Quote Originally Posted by Tronkov View Post
    After several months.
    I was having problem storing HashTable and Dictionary objects in the Database in Version 3.5.9. So please include full support for storing serializable, non-serializable Dictionary, HashTable objects into the Database, in the upcoming STSDB Version 4!

    Thanks,
    Tushar

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
2002 - 2014 STS Soft SC. All Rights reserved.
STSdb, Waterfall Tree and WTree are registered trademarks of STS Soft SC.