Edith Cowan University's School of Computer and Information Science, in cooperation with the State Records Office of Western Australia, will offer a professional development program on archival strategy for databases on Wednesday 6 August 2008. In a one day presentation/workshop (lab) format, two streams will be offered- a Level 100 foundations stream for records, archives and information systems professionals new to managing structured information sources for persistence; and a Level 200 stream for practitioners seeking to apply methods in an enterprise database context. Presentations and workshops will explore methods for managing databases for persistence, preservation planning for databases, migrating databases using eXtensible Markup Language (XML) and the consequences of strategy for accessibility and compliance.
Download our registration form for further details.
Program details:
| 08:30-09:00 |
Registration |
| 09:00-12:30 |
Foundations of archival strategy for databases
(L100) |
| |
Learning Outcomes:
- Describe concepts and frames of database archiving;
- Explain how digital preservation planning for structured information sources is different from unstructured sources;
- Describe business drivers for the archival management of databases;
- Distinguish methods of database preservation;
- Analyse preservation requirements for databases and apply a decision tree for method selection;
- Distinguish active and inactive database archiving solutions;
- Describe the components of a preservation plan for databases;
- Explain the consequences of XML migration for database semantics and structure;
- Describe issues in the enterprise application database archiving methods.
|
| 09:00-10:00 |
Relational databases and archival strategy |
| |
- What is meant by database archiving?
- How are databases appraised?
- What are the features of databases that can be preserved?
- What are the business drivers of database archiving?
- What is the database Information Life Cycle (ILC)?
- What are the components of a preservation plan for databases?
- What methods exist for database preservation?
|
| 10:00-10:30 |
Morning Tea |
| 10:30-11:30 |
Lab: Database migration |
| |
- XML and preserving data semantics and structure --What is XML?
- How is data organization in XML related to database semantics and structure?
- Task: Create a content model for an XML document.
- Task: Create a well formed XML document.
- How are databases migrated to XML?
- Task: Migrate an MS Access database to XML.
|
| 11:45-12:30 |
Preservation planning for databases |
| |
- Workshop review: XML migration and the preservation of database semantics and structure.
- What principles inform database preservation planning?
- Preservation planning: How is strategy selected?
- Preservation planning: What are the components of a database preservation plan?
- Preservation practice: Benchmark projects in database archiving
|
| 12:30-13:30 |
Lunch |
| 13:30-16:45 |
Building enterprise database archival solutions
(L200) |
| 13:30-14:15 |
Enterprise solutions for preserving databases |
| |
- What are the challenges of enterprise database archiving with XML?
- What is the relational conundrum?
- What is the idea of data fidelity?
- How is archival data recovered and what are the consequences of recovery for planning?
|
| 14:30-15:15 |
Lab: Active and non-active enterprise methods and tools |
| |
- Task: Implementing an active database archival strategy
- Task: Implementing non-active strategy: Migrating an SQL Server database to XML
|
| 15:15-16:00 |
Afternoon Tea |
| 16:00-16:45 |
Enterprise preservation planning: Understanding requirements and tools |
| |
- What format issues need to be considered?
- How do we manage archived databases for accessibility over the long term?
- Needle in the hay stack: How do we query active and non-active archival data?
- What are the consequences of strategy for compliance with business and legal requirements?
|
| 17:00 |
Refreshments and networking |
Pictures
Sampler
Download L100 Workshop 1 sampler (PDF, 312K)
