What type of database does Urchin use

What type of database does Urchin use?

Urchin uses a proprietary flat file database for report data storage. The high-performance database architecture handles very high traffic sites efficiently. Some of the benefits of the data base architecture include:

  • Small database footprint – approximately 5-10% of raw logfile size
  • Small number of database files required per profile (9 per month of historical reporting)
  • Support for parallel processing of load-balanced webserver logs for increased performance
  • Databases are standard files that are easy to back up and restore using native operating system utilitiesv

Because the database files are simple flat files there is complete portability between Windows ans Unix platforms. This means that:

  • Reporting engine can read data crunched on any platform
  • No data migration necessary if Urchin platform is changed