Skip to main content

Heading 1

Heading 2

Heading 3

Italicized Bold

image - assetSchema

Data By Design

Our database schema is designed following the third normal form pattern (3NF). This structure provides the smallest footprint by ensuring that no data is duplicated and that in itself guarantees data integrity by avoiding inconsistent data across raw and aggregate data tables.

All data is constructed using primary and foreign key relationships, that further ensures integrity by preventing orphaned records, and by linking records using integers, provides critically fast queries using built-in table indexes and binary tree search algorithms. In addition, we further optimized the database by tuning it against the most common long running queries, using the information gained to construct additional indexes to allow even faster record retrieval.

kanoa-ops

kanoa-ops