Quick Facts about QD Technology's Quick Response Database Solution
View as PDF
| What is the Quick Response Database™? | QD Technology's Quick Response Database™ (QD™) is a relational database solution that enables business executives and data analysts to easily and conveniently obtain rapid responses to database queries from local copies of their database. Queries run faster than with other solutions and since they run on user PCs, they do not interfere with other users' activities, and can be run anywhere.
It's QD™, solving the problem of ‘too much data, too little access.' | |
| User Benefits |
On-Demand Access to Localized Data. Users can get responses to queries on their PCs at any time without negatively impacting IT operations since the entire database is compressed, encrypted, and copied onto their PC.
Fast Query Response Through Smart Compression. QD's query response performance can be as much as five times faster than traditional relational databases (depending on the nature of the data and query). Many factors are responsible for this remarkable speed enhancement, including smart compression and optimization strategies that balance compression levels with performance, the read-only nature of the database, the capture of metadata, and the absence of any interaction with a server. Automatic Updates Delivered to the User. When the master database changes, the updates can be automatically delivered to users' PCs, with no end-user intervention required. | |
| Enterprise Benefits |
Facilitates Innovation. Since QD can dramatically reduce query response times, users can ask more questions of their database and get more answers in less time. This additional insight will promote development of solutions to business questions and problems that may not otherwise be possible.
Reduced Computing Infrastructure. Because QD puts the database right on the user's PC, it requires no multi-tier infrastructure for queries, data cube management, or warehousing. As a result, QD is a tight, compact solution that optimizes the use of IT resources and holds down IT costs. Improved User Performance. Data analysts and field users can run the queries they want whenever they want to, without restrictions being placed on them by database administrators or other business users. Complete Solution. Many large database solutions can compress their data, but they lack:
| |
| Compression |
Improved Query Performance Through Smart Compression. QD's compression is designed to improve query performance while increasing storage capacity. Compression enables QD to fit more on a database page and process it faster. With QD, queries read more data with fewer I/O operations than traditional compression databases.
Faster Data Access Through Optimized Compression. QD optimizes compression in two ways. First, it applies a specially selected compression technique - one from a library of over a dozen such techniques – to each column in each table. Second, it does not compress tables or data as monoliths but instead compresses values based on content-based patterns. In addition, certain information, such as the number of rows in a table, is pre-calculated and stored in the tables for rapid access. | |
| Compatibility |
ODBC-Compliant. QD is compliant with the Open Data Base Connectivity, or ODBC, standard interface. As a result, QD is compatible with virtually any query-building tool or ODBC-compliant application. In addition, QD can compress data from virtually any traditional database solution that supports ODBC connectivity.
SQL-92 Compliant Queries. QD supports any query tool that is compliant with the SQL-92 standard. Data Stored in Rows and Columns. The QD Loader reads delimited and fixed length flat files, including e-mail logs, and files from virtually any ODBC-compliant data source. ASCII-based Data Only. QD does not handle images, PDFs, real-time data, or other binary data, or any freeform text. QD supports links to this data, but cannot store it directly in the database. | |
| Technology | Old Tables Never Die. QD compression is backwards-compatible with all previous QD releases. As we develop improved compression algorithms, old tables can still be read or recompressed if desired. The processes required to decompress the data are stored along with the table. | |
| Platform and Deployment |
Platform. The minimum configuration for the QD Server system is
The minimum required configuration for a QD query system (desktop or laptop) is:
Deployment Time. Initial installation and configuration of QD generally can be completed in less than 30 minutes. Skills Required. Because QD is ODBC-compliant, no special user-level training is required. | |
| Security |
Data on the PC. Data residing on a PC is protected through a hierarchical, role-based traditional user access control system that is set by the QD administrator during the load phase. The system can also lock down or wipe out the database on a preset expiration date, or if too many failed login attempts are made.
Encryption. QD supports full 256-bit encryption (AES-256) of all data for improved data security. | |