130 likes | 287 Views
Online Archaeological Repository. Ashwin Nathaniel , Dinesh Baiju , Gayatri Bakshi , Geetha Priyadharshini , Jithin Korah Jacob School Of Business & Information Technology, James Cook University, Townsville. Client Background. Nigel Chang
E N D
Online Archaeological Repository Ashwin Nathaniel , DineshBaiju , GayatriBakshi , GeethaPriyadharshini , Jithin Korah JacobSchool Of Business & Information Technology, James Cook University, Townsville.
Client Background • Nigel Chang Chief investigator and project leader for BNW (Ban Non Wat). Lecturer in Archaeology at JCU with over 20 years experience as field archaeologist in SE Asia. • Dianna Madden Technical lead (IT) for work on the Ban Non Wat archaeological project. Background as a programmer in web technologies. Currently a PhD student in IT.
Existing system • A standalone file-maker database that is currently in use. • Unorganized data, pictures are not easily identifiable • New System • Enhanced website • Hierarchical database • Fast retrieval of data • Simple management system • Image thumbnails • Stable and secure
Initial Scope • Added video links • Portability • Data security with a login screen • Thumbnails to identify image files • Data Migration • Synchronisation between the two databases • Offline system
Scope Completed • Enhanced Website • Secure Login • Dynamic Forms • Gallery management system • User management system • Simple CSS design to improve performance • Hierarchical Database – My SQL • Website validated with W3C Standards
Data Migration • FileMaker to Excel • Excel to Mysql • Using xls2mysql software • Converted MySQL schema to archaeology database schema • SQL scripts for transferring data
Top Ten Requirements • Search for artefacts based on context number or keywords. • Retrieve all information about artefacts including pictures, sketches and videos (additional). • Creating a management interface for the gallery. • Data editing in database with error correction and monitoring changes made to data by archaeologists. • Fine tuning of the data entry form.(uploads) • Thumbnails to identify image file. • Displaying data from previous database. • Creating the Offline Application. • Connecting offline application with the database. • Uploading data from offline application to the online database.
Offline App & Synchronization • Interface Design completed • Database Schema completed • Research on synchronization completed
Demo http://dunk2.jcu.edu.au/~cp5046/Final%20Version/Index.php