 |
|
CopperEye IndexingTM
CopperEye's core intellectual property is a new, patented, disk-optimized general-purpose indexing technology for scalar data that outperforms conventional indexing techniques by several orders of magnitude. Where CopperEye's other products specifically target unchanging transaction data, our core indexing technology has no such restriction and can be used wherever indexing is required.
|
- Appropriate as a complete replacement for traditional B-tree indexes
- Uses 99% less disk I/O for index maintenance than other indexing approaches
- Query performance is every bit as good as the B-tree
- Available as a software developer's kit (SDK) for developers creating custom database solutions requiring extreme performance
- Does not rely on memory, caching or CPU-intensive gimmicks to achieve performance
Indexes are used in database and data storage/retrieval applications to enable fast access to stored data. Without indexes, applications are forced to scan entire data sets to find the required data. But while indexes speed up data retrieval, they incur a significant overhead for index maintenance operations and a compromise must often be struck between data retrieval performance and data loading performance. CopperEye indexing effectively eliminates the disk I/O bottleneck inherent in other indexing approaches, creating unprecedented freedom for applications to store and utilize huge volumes of data.
| Operation |
Average B-Tree Disk I/Os (per Key) |
Average CopperEye Disk I/Os (per Key) |
Average Benefit |
| Insert Multiple Keys |
2 |
<1 |
Up to 100 fold |
| Delete Multiple Keys |
2 |
<1 |
Up to 100 fold |
| Update Multiple Keys |
2 to 4 |
<1 |
Up to 100 fold |
| Query Range of Multiple Keys |
<1 |
<1 |
Similar Performance |
| Create Index on Multiple Keys |
<1 |
<1 |
Similar Performance |
Note: The above figures assume large indexes, randomly distributed keys and moderate to high cardinality
The CopperEye Software Developers Kit (SDK) provides application developers with an innovative way to create high performance, custom-built data repositories suitable for extremely high transaction volumes and large stores of historical data. Built upon CopperEye's patented indexing technology, the CopperEye SDK is a robust, functionally complete set of software components that provides all operations necessary to create and manage a database index as part of a comprehensive database system.
Unlike CopperEye Search and CopperEye Greenwich, which focus on immutable data, CopperEye's core indexing and the SDK have no such limitation, and are appropriate for use wherever data indexing is required. The SDK is designed for use by independent software vendors, systems integration firms and end-user customers who develop their own enterprise applications. Applications that leverage the CopperEye SDK offer significant advantages over applications that rely exclusively on standard indexing approaches available with a relational database management system.
|
