Maintaining Multimedia Data in a Geospatial Database.

摘要

This thesis resulted from a project in which imagery was captured and automatically stored. Historical data were integrated with it and made available through the network to permit a TIVO-style replay of events anywhere within a city limit, with higher spatial and temporal resolution on hotspots. The purpose was to allow law enforcement personnel to go back in time to a location and recover imagery/video of interest in a timely manner. While working on the project, the question of database performance arose. Choosing an open-source relational database management system (RDBMS) -- MySQL or PostgreSQL -- to handle a spatial database of this magnitude was a decision that had to be made. There was no doubt that both were admirable database systems, but how would they perform against each other. Would multimedia data add any additional complexity to their performance. The goal of this thesis was to compare and analyze the use of two database options, PostgreSQL and MySQL, as spatial databases in a practical situation. The thesis did not do what it was intended to do, which was to prove that one database would outperform the other. In the end, both databases excelled at certain tasks and fell short on others.