180 likes | 264 Vues
Learn how to address database challenges with tools like T1000, TimeMap, and Google Maps. Create web-accessible databases easily for effective data management and accessibility. Discover solutions for creating clean, well-designed databases and web pages.
E N D
The five minute database: Building Online Participatory Spatial Databases with T1000, TimeMap and Google Maps Ian JohnsonArchaeological Computing Laboratory Spatial Science Innovation Unit University of Sydney
Problem with databases • Lack of skills result in: • Barriers to entry • Use of available systems (Access, FMPro, Excel) • Ad hoc databases • Inappropriate design • Poor field definitions (d-m-s, text for #, uncontrolled categories) • Lack of normalisation, redundant data • Standalone desktop databases • Backup and sustainability • No reuse, no web accessibility
Solution • A tool which makes it as easy to create a web-accessible, server-based database as a standalone desktop database • A wizard which builds a clean, well-designed database and populates lookup tables where possible • A wizard which builds a set of web pages which can simply be edited for appearance