Products

TanaDB - In-memory nosql database

Make your own in-memory database in client or server easily.
With TanaDB you can speed up your buseiness easily,
You don't have to buy expensive and special hardware, you can use your own and if you need more memory the memory nowadays is not expensive.
Create your own in memory database and deploy it to any windows server/s
which anyone from your organization can consume it,
Or create local database in any windows coumputer.
Follow documentation

TanaCache - Autonomous cache

TanaCache is an autonomous cache server for your database.
It caches your database queries or stored procedures requests.
How it works?
Conect to your database, choose tables or stored procedures. Execute and deploy.
You can consume data from your database via rest services. For example: Get user by id http://TanaCacheUrl/users/id/12345 Get user by id from stored procedure: http://TanaCacheUrl/sp/getUser/12345
Follow documentation

TanaNQ - Nosql database

Tananq is nosql approach for your database.
It gives you a simple way to consume data from your database via rest services with no sql approach.
How it works?
Conect to your database, choose tables and stored procedures. Execute and deploy.
You can consume data from your database via rest services.
Follow documentation

Solutions

Performence

Get faster performence

Simplicity data use

Simplify your organization by using data easily

Nosql approach

Get data via rest service with nosql approach

Security

Secure by group or user each entity

Scale

Increase or reduce activity as necessary

Accessibility

Everyone at your organization should be able to improve the business using data

Consolidation

Consolidate your IT infrastructure to improve responsiveness, reduce costs, and increase performance

Fetch data from any device

Get data from deskop applications, mobile applications, server applications

Documentation

Data manipulation by crud operations via rest services(used for all products)

How to retrieve data?

  • table
    • get rest operation : url / entity / column / value
      example : http://myUrl/user/id/1
      (get the user details by id 1)
      result (json): [{"id":1,"name":"john doe"}]
    • get rest operation : url / entity / column / GT / value
      example : http://myUrl/user/id/GT/1
      (get the user details when id greater then 1)
    • get rest operation : url / entity / column / Contains / value
      example : http://myUrl/user/name/Contains/abc
      (get the user details that conatins value abc)
    • get rest operation : url / entity / Query / expression
      example : http://myUrl/user/Query/id gteq 1 and name like abc
      (get the user details when id greater then 1 and conatins value abc)
    • All funcionalities :
      • Contains - search for specific characters that contains a given value (only for string values).
        example - http://myUrl/user/name/Contains/Jane
      • Sound - search for characters without regard to uppercase or lowercase letters (only for string values).
        example - http://myUrl/user/name/Sound/jane
      • SW - search for characters that starts with without regard to uppercase or lowercase letters (Start with - only for string values).
        example - http://myUrl/user/name/SW/jane
      • EW - search for characters that ends with without regard to uppercase or lowercase letters(End with - only for string values).
        example - http://myUrl/user/name/EW/doe
      • GT - search for values that greater than a numeric or date values (only for numeric values).
        example - http://myUrl/user/age/GT/20
      • GTEQ - search for values that equal and greater than a numeric or date values (only for numeric values).
        example - http://myUrl/user/age/GTEQ/20
      • LT - search for values that less than a numeric or date values (only for numeric values).
        example - http://myUrl/user/age/LT/20
      • LTEQ - search for values that equal and less than a numeric or date values (only for numeric values).
        example - http://myUrl/user/age/LTEQ/20
      • NOT - search for values that is differnent from a given value (only for numeric values).
        example - http://myUrl/user/age/NOT/20
      • Order by
        Asccending - get all the users with id greater equal to 1 order by id in asccending way
        example - http:/myUrl/user/id/GTEQ/1/order/asc
        Decending - get all the users with id greater equal to 1 order by id in decending way
        example - http:/myUrl/user/id/GTEQ/1/order/desc
      • Paging
        get all the users with id greater equal to 1 first page with 20 rows
        example - http:/myUrl/user/id/GTEQ/1/page=1/size=20
        get all the users with id greater equal to 1 second page with 20 rows
        example - http:/myUrl/user/id/GTEQ/1/page=2/size=20
        Paging with asccending order by- get all the users with id greater equal to 1 order by id in asccending way
        example - http:/myUrl/user/id/GTEQ/1/order/asc/page=1/size=20
        Paging with aecending order by - get all the users with id greater equal to 1 order by id in decending way
        example - http:/myUrl/user/id/GTEQ/1/order/desc/page=1/size=20
      • Sum
        get all the users with id greater equal to 1 sum value
        example - http:/myUrl/user/id/SUM/GTEQ/1
      • Count
        get all the users with id greater equal to 1 count value
        example - http:/myUrl/user/id/COUNT/GTEQ/1
      • Max
        get all the users with id greater equal to 1 max value
        example - http:/myUrl/user/id/MAX/GTEQ/1
      • Min
        get all the users with id greater equal to 1 min value
        example - http:/myUrl/user/id/MIN/GTEQ/1
      • Average
        get all the users with id greater equal to 1 average value
        example - http:/myUrl/user/id/AVG/GTEQ/1
  • key value(used for In-memory database)
    • get rest operation : url / entity / getvalue / value
      example : http://myUrl/user/getvalue/1

How to insert data?(used for In-memory database)

  • table
      post rest operation : url / Postentity
      example : http://myUrl/Postuser
      json data : {id : 1,user : 'john'}
  • key value
      post rest operation : url / entity
      example : http://myUrl/Postuser
      json data : {id : 1,user : 'john'}

How to update data?(used for In-memory database)

  • table
      put rest operation : url / Putentity
      example : http://myUrl/Putuser
      json data : {id : 1,user : 'john'}
  • key value
      put rest operation : url / entity
      example : http://myUrl/Putuser
      json data : {id : 1,user : 'john'}

How to delete data?(used for In-memory database)

  • table
      delete rest operation : url / Deleteentity
      example : http://myUrl/Deleteuser
      json data : {id : 1,user : 'john'}
  • key value
      put rest operation : url / entity
      delete : http://myUrl/Deleteuser
      json data : {id : 1,user : 'john'}

Manipulate data from anywhere
  • Manipulate data by using rest services
  • Access database from any operating system that uses http
  • Access database from any developing language (like c#,java,go,php,pyton,node.js,angular,react,jquery,native js etc.)
  • Access database from any database that uses http
How to Create database (Gui - used for In-memory database)
  • Menu - Database - New Database Show video
    • Specify database name and click "add" button
    • A new window "Create new table" will popup Show video
      • Insert table name
      • Insert column name, column type and click "Add column" button"
        (if you want the column to be primary key click the checkbox)
      • The column will be added to the grid below (you can update the column by clicking the grid header column)
      • You can add data to rows in each column
      • Click "Save" button to save the table
        • The table will be added to a tree view under "Entities > Tables"
        • You can edit table by right clicking the table name and choose "Edit"
        • You can delete table by right clicking the table name and choose "Remove"
        • You can add stored procedure to table by right clicking the table name and choose "Add stored procedure"
    • Choose "Entity type" from combo box table / key-value
      • If you choose "table" repeat the above instrucions Show video
      • If you choose "key-value" new window will popup Show video
        • Specify "key-value" name
        • Choose "key-value" type
        • Click "Save" button
        • The "key-value" will be added to a tree view under "Entities > keyVal"
        • You can edit "key-value" by right clicking the table name and choose "Edit"
        • You can delete "key-value" by right clicking the table name and choose "Remove"
How to secure database
  • Click secure tab
  • Add allowed admin by group : you can add one or more windows group(this group will have all permissions in system)
  • Add blocked by group : you can block one or more groups (black list)
  • Add allowed by group : you can add allowed one or more groups (white list)
  • Add blocked by ip : you can block one or more ip (black list)
  • Add allowed by ip : you can add allowed one or more ip (white list)
  • Add blocked by user : you can block one or more windows user (black list)
  • Add allowed by user : you can add allowed one or more windows user (white list)
  • (All users and groups belong to windows operating system)
How to backup database(used for In-memory database)
  • Click Backup tab
  • Check the Minutes or Hours checkbox
  • When choose Minutes select the minutes from select box
  • When choose Hours select the hour from select box
  • Data will be backup to disk file each time you selected only if there was a change in data
How to create cluster with replication and auto recovery(used for In-memory database)
  • Click Data management tab
  • Choose application type from radio buttons(Web server, self host, windows service)
  • Insert valid directory path to physical target text box
  • Click Replication tab
  • Check "Is replicate" check box
  • Check "balancer" check box
  • Add master url(maximum 2)
  • Add slaves urls(no limit)
  • Insert valid directory path to shared folder text box
  • Click Execute button
  • Master, slave, balancer Directories were created under physical target path(for each master and slave)
  • In case you choosed web server :
    • You need iis one server or more
    • You need to copy the directories which were created(master,slave and balancer) under physical target path to iis web servers
      (you can use publish link in the success box were created - a window will pop up)
    • Create application pool for each master,slave and balancer
  • In case you choosed windows service :
    • You need to copy the directories which were created(master,slave and balancer) under physical target path to web servers
      (you can use publish link in the success box were created - a window will pop up)
    • You need to install the window services were created under the directories master, slave, balancer by clicking installWindowsService.bat
    • After the service is installed click startWindowsService.bat to start serveice
  • In case you choosed self host :
    • You need to copy the directories which were created(master,slave and balancer) under physical target path to web servers
      (you can use publish link in the success box were created - a window will pop up)
    • Click the exe file under each directory to activate the self host
    • A console application will be apear
    • When closing the console application the self host will stop working

contact us

For more information or any other question please contact us.


Mail: Tana@TanaSoftware.com
   LinkedIn