Navigation:  Introduction >

Introduction

Previous pageReturn to chapter overviewNext page

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