This database is intended to be a simple state management database for the ingest tool. However, it may be expanded to assist in ID mapping between purl's, internal/short id's, and possible fedora id's or pid's. Much of that data is needed here anyway, so it would be minimal additional cost or complexity to add lookup/mapping functionality.

All access to this data from the IngestTool is in edu.indiana.dlib.server.ingestTool.IngestDB.
Password information is in IngestTool.properties.
A creation script is in cvs:/infrastructure/oracleCreateScript.sql

Database Layout:

Tables:

IngestRecords

Columns:

IngestStates

Columns:

ID is a Fixed List:

1) NEW – New ID Created
2) INGEST – Ingestion in progress
3) ERROR – Ingestion failed
4) DONE – Ingestion complete
5) TERMINATE – Termination requested
6) STOPPED – Ingestion prematurely terminated

IngestEvents

Columns:

IngestEventTypes

Columns:

ID is a Fixed List:

— standard state switches and operations —
1) NEW – New ID Created
2) INGEST – Initial ingestion started
3) ERROR – Ingestion terminated abnormally
4) DONE – Ingestion terminated normally
5) TERMINATE – Termination requested
6) STOPPED – Ingestion prematurely terminated

— non-state affecting commands —
100) STATUS – Current status requested

— errors and abnormal commands —
1000) INVALID_INGEST – An ingest process was started with an invalid ID
1001) INVALID_STATUS – A status request was made with an invalid ID
1002) CONCURRENT_INGEST – An ingest request was made while another ingest was in progress for this score
1003) REINGEST – An additional ingestion was started
1004) ACCESS_DENIED – An ingest request was made with an invalid access code

IngestItems

Columns:

IngestItemState

Columns:

ID is a Fixed List:

— standard state switches and operations —
1) NEW – New ID Created
2) INGEST – Initial ingestion started
3) ERROR – Ingestion terminated abnormally
4) DONE – Ingestion terminated normally