PassiveDNS database schema v3
The DB schema v2 was developed to allow data collection and processing
from many heterogeneous data sources, especially to support DNS
transaction collection from network perimeter interface probes. This
never materialized and now the schema is a burden for performance, for
information presentation and for several planned use cases.
The DB schema should be changed once more, to better accommodate current
requirements. The schema v2 was not in vain, the lessons learned were
worth the work and some valuable features, allowing us to offer
world-leading services in PassiveDNS, such as complete transaction
details, should be transferred over to the new schema.
Author: Radko Krkoš krkos@cesnet.cz