The HireTrack NX server is database server application built up on the NexusDB database engine.
"Why do you use NexusDB? Why don't you use standards like Oracle, MSSQL, ..?"
The reason why people want "standard" databases is so they can "minimize risk". They "minimize risk" by using a product that they are comfortable with, rather than use the best tool for the job.
Oracle and MSSQL are both fine databases, but they are too bloated and too pricey for many of the applications that use them.
Licensing costs for either database will cost several thousands of pounds and either will require a trained database administrator (DBA) to install and keep running optimally.
For vertical applications, such as HireTrack NX, the NexusDB engine completely removes the need for a DBA, it is extremely easy to install and maintain and is included free of charge with the client application license.
There are several reasons, in no particular order, why the NexusDB engine was selected as our engine of choice:
SQL Support
| • | Standard SQL:2003 - statements supported |
| • | Triggers, Stored Procedures and Functions - fully implemented. |
| • | SQL/PSM Procedure Language - for server side programming. |
| • | Transaction Management and Referential Integrity - for professional data handling. |
| • | Fulltext Index Support - for fast data lookups. |
| • | ODBC Driver - access your data through industry standard ODBC |
Extraordinary Performance
| • | Multi-Threaded Engine - utilizes Symmetric Multi-Processor systems to the fullest extent |
| • | New Memory Manager - maximizes allocation speed and minimizes fragmentation |
| • | Interchangeable data transports - optimized for deployment topology |
| • | Memory Tables - for the fastest possible data access |
Client/Server Architecture
| • | More Robust - server insulates physical data files from clients to prevent corruption |
| • | Increased Performance - server optimizes overall throughput |
| • | Better Scalability - can handle more simultaneous clients than file-based databases |
Stability with Transaction Support
| • | Snapshot Transactions - Unique to NexusDB, these transactions ensure that writers do not block readers |
| • | Fail-Safe Transactions - preserves the consistency of your data under the harshest of conditions with a complete two phase commit implementation |
| • | Nested Transactions - enables greater flexibility, clarity and encapsulation when using transactions |
Scalability
| • | User connections - capable of hundreds of concurrent connections |
| • | Massive Data capacity - only limited by your OS and disk space; supports gigabytes of data comfortably |
| • | Record capacity - store millions of records effortlessly |
Low Total Cost of Ownership
| • | Online Backup - operates seamlessly in a 24/7 environment |
| • | Powerful Administration Tools - easy to use GUI management utilities included |
| • | Maintenance free - reuses buffers and automatically balances indexes |
Transport connectivity
| • | Real-Time Communication System - provide an advanced messaging system over any network |
| • | Multiple Protocols Supported - TCP/IP and Named Pipes implementations make choosing the right protocol easy |
Security
| • | Login Security/Rights - server based rights makes sure your data is secure |
| • | Encryption - advanced interchangeable encryption algorithms keep your data safe on the server and over your network |