<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2 Final//EN"> <!--Converted with LaTeX2HTML 2008 (1.71) original version by: Nikos Drakos, CBLU, University of Leeds * revised and updated by: Marcus Hennecke, Ross Moore, Herb Swan * with significant contributions from: Jens Lippmann, Marek Rouchal, Martin Wilck and others --> <HTML> <HEAD> <TITLE>Sequence of Creation of Records for a Save Job</TITLE> <META NAME="description" CONTENT="Sequence of Creation of Records for a Save Job"> <META NAME="keywords" CONTENT="developers"> <META NAME="resource-type" CONTENT="document"> <META NAME="distribution" CONTENT="global"> <META NAME="Generator" CONTENT="LaTeX2HTML v2008"> <META HTTP-EQUIV="Content-Style-Type" CONTENT="text/css"> <LINK REL="STYLESHEET" HREF="developers.css"> <LINK REL="next" HREF="Database_Tables.html"> <LINK REL="previous" HREF="General.html"> <LINK REL="up" HREF="Catalog_Services.html"> <LINK REL="next" HREF="Database_Tables.html"> </HEAD> <BODY > <!--Navigation Panel--> <A NAME="tex2html1022" HREF="Database_Tables.html"> <IMG WIDTH="37" HEIGHT="24" ALIGN="BOTTOM" BORDER="0" ALT="next" SRC="next.png"></A> <A NAME="tex2html1016" HREF="Catalog_Services.html"> <IMG WIDTH="26" HEIGHT="24" ALIGN="BOTTOM" BORDER="0" ALT="up" SRC="up.png"></A> <A NAME="tex2html1010" HREF="General.html"> <IMG WIDTH="63" HEIGHT="24" ALIGN="BOTTOM" BORDER="0" ALT="previous" SRC="prev.png"></A> <A NAME="tex2html1018" HREF="Contents.html"> <IMG WIDTH="65" HEIGHT="24" ALIGN="BOTTOM" BORDER="0" ALT="contents" SRC="contents.png"></A> <A NAME="tex2html1020" HREF="GNU_Free_Documentation_Lice.html"> <IMG WIDTH="43" HEIGHT="24" ALIGN="BOTTOM" BORDER="0" ALT="index" SRC="index.png"></A> <BR> <B> Next:</B> <A NAME="tex2html1023" HREF="Database_Tables.html">Database Tables</A> <B> Up:</B> <A NAME="tex2html1017" HREF="Catalog_Services.html">Catalog Services</A> <B> Previous:</B> <A NAME="tex2html1011" HREF="General.html">Database Table Design</A> <B> <A NAME="tex2html1019" HREF="Contents.html">Contents</A></B> <B> <A NAME="tex2html1021" HREF="GNU_Free_Documentation_Lice.html">Index</A></B> <BR> <BR> <!--End of Navigation Panel--> <H1><A NAME="SECTION001020000000000000000"> Sequence of Creation of Records for a Save Job</A> </H1> <A NAME="2495"></A> <A NAME="2496"></A> <P> Start with StartDate, ClientName, Filename, Path, Attributes, MediaName, MediaCoordinates. (PartNumber, NumParts). In the steps below, ``Create new'' means to create a new record whether or not it is unique. ``Create unique'' means each record in the database should be unique. Thus, one must first search to see if the record exists, and only if not should a new one be created, otherwise the existing RecordId should be used. <P> <OL> <LI>Create new Job record with StartDate; save JobId </LI> <LI>Create unique Media record; save MediaId </LI> <LI>Create unique Client record; save ClientId </LI> <LI>Create unique Filename record; save FilenameId </LI> <LI>Create unique Path record; save PathId </LI> <LI>Create unique Attribute record; save AttributeId store ClientId, FilenameId, PathId, and Attributes </LI> <LI>Create new File record store JobId, AttributeId, MediaCoordinates, etc </LI> <LI>Repeat steps 4 through 8 for each file </LI> <LI>Create a JobMedia record; save MediaId </LI> <LI>Update Job record filling in EndDate and other Job statistics </LI> </OL> <P> <HR> <!--Navigation Panel--> <A NAME="tex2html1022" HREF="Database_Tables.html"> <IMG WIDTH="37" HEIGHT="24" ALIGN="BOTTOM" BORDER="0" ALT="next" SRC="next.png"></A> <A NAME="tex2html1016" HREF="Catalog_Services.html"> <IMG WIDTH="26" HEIGHT="24" ALIGN="BOTTOM" BORDER="0" ALT="up" SRC="up.png"></A> <A NAME="tex2html1010" HREF="General.html"> <IMG WIDTH="63" HEIGHT="24" ALIGN="BOTTOM" BORDER="0" ALT="previous" SRC="prev.png"></A> <A NAME="tex2html1018" HREF="Contents.html"> <IMG WIDTH="65" HEIGHT="24" ALIGN="BOTTOM" BORDER="0" ALT="contents" SRC="contents.png"></A> <A NAME="tex2html1020" HREF="GNU_Free_Documentation_Lice.html"> <IMG WIDTH="43" HEIGHT="24" ALIGN="BOTTOM" BORDER="0" ALT="index" SRC="index.png"></A> <BR> <B> Next:</B> <A NAME="tex2html1023" HREF="Database_Tables.html">Database Tables</A> <B> Up:</B> <A NAME="tex2html1017" HREF="Catalog_Services.html">Catalog Services</A> <B> Previous:</B> <A NAME="tex2html1011" HREF="General.html">Database Table Design</A> <B> <A NAME="tex2html1019" HREF="Contents.html">Contents</A></B> <B> <A NAME="tex2html1021" HREF="GNU_Free_Documentation_Lice.html">Index</A></B> <!--End of Navigation Panel--> <ADDRESS> 2010-06-14 </ADDRESS> </BODY> </HTML>