|
|
|
|
Important notice: The CSA web site was re-designed in August of 2010. Some documents then available were out of date; so they were not included in the re-design and were not updated. This is one of those documents. Information about dates of posting and revision remains here, but there will be no revision of any kind after August, 2010.
This database is the result of an attempt to replicate, as nearly as possible, the catalog portion of Professor Jeremy B. Rutter's book, The Pottery of Lerna IV (The American School of Classical Studies at Athens, Princeton, NJ, 1995). We did this to provide an example of a pottery catalog in computer database form since concerns about the utility of computer databases had been raised in the session on pottery catalogs held at the 1996 annual meeting of the Archaeological Institute of America. We intended to produce something that would both demonstrate the potential of the database in general and, at the same time, demonstrate its use in a particular setting. Therefore, we urge readers to consider this system for the Lerna material and how this system might be used in different ways to assist with differently organized data.
We had neither the time nor the resources to duplicate the entire catalog, but we did create a catalog of the first 365 items (all the items from Phase I). The result was demonstrated at the workshop hosted by Mr. Eiteljorg at the 1997 annual meeting of the AIA.
Mr. Rutter and the publisher of The Pottery of Lerna IV, the American School of Classical Studies at Athens, have agreed to permit us to offer the database to our readers to see how it functions with the Lerna data and, by extension, how a different database might function with different data. Several forms of the database are available to be downloaded. Comments and reactions will be appreciated by us and by Mr. Rutter and Ms. Kerri Cox, Editor-in-Chief, American School of Classical Studies at Athens Publications. Please address your comments to Harrison Eiteljorg, II or Susan Jones. We will forward them to Mr. Rutter and Ms. Cox.
We ask users to remember that the data have not been reviewed for accuracy by Mr. Rutter, and the system is not truly comprehensive. It was as nearly so as we could make it in time for the AIA meetings, and we believe it illustrates well the potential of a database management system for this type of scholarship. However, it is not a completely finished work. Not only does the database include only the material from phase 1, only a few illustrations have been included, in fact only enough to show the effect.
The data included concern the 365 vessels found in Phase I, Level IV. Not all graphics associated with vessels, patterns, and thin sections are available in this database. Even without all the illustrations, several of these tables/files are very large. For a complete definition of all terms used in the database, see the appropriate pages of The Pottery of Lerna IV.
The information about the pottery was organized into tabular form by us. To the best of our ability, we have adopted the organizational scheme set up by Mr. Rutter in his book. This organization provides a primary table that presents most of the data from an individual catalog entry as a single record or row. Some data items, such as findspots and Lerna inventory numbers, may require multiple entries for a single catalog item, but such multiple entries (called "repeating" fields) create a variety of problems, and we did not wish to use them. Therefore, there are related subsidiary tables for data such as findspots and Lerna inventory numbers, each table containing at least one entry per catalog item and possibly many entries per catalog item. Together, the catalog table and these subsidiary tables provide all the information from the paper catalog entries.
There is another group of tables -- tables that provide auxiliary information to define terms in the catalog. An example would be the Morphology table -- a table whose individual records contain the descriptive terms that define standard morphological types, such as rim-handled tankards (defined by body shape, handle number and position, etc.). Thus, any rim-handled tankard is described by the entry for rim-handled tankard in the morphology table. We have included a representative sample of such auxiliary material, but certainly not all the ancillary information that Mr. Rutter makes available in his book. In general, we created a structure that can be easily expanded to incorporate data not already included. For example, information linking findspots to architectural features of Lerna IV, phase I, is not present in this sample data base, but it is included in Mr. Rutter's analysis. With the inclusion of this group of auxiliary tables, essentially all of the data provided in the book could be included within the data base.
The resulting design comprised a set of 14 separate tables with the links connecting them. These tables were then placed into a computer database form, using the program called Access (Access 97, a Microsoft® product). Once more or less complete, the data were transferred into another database program, FileMaker Pro (FileMaker Pro 4.0, a Claris® product). As a result, full database systems are available for users of either database management system, Access or FileMaker Pro. Either database may be downloaded for use and experimentation. Users will need to read the following, though, to learn more about the way the data have been organized and to know how best to use the systems.
To permit wider access to the information and the database experiment, we are also providing the data in a more open format - ASCII (comma delimited). The ASCII files, however, will require users to understand how the different data tables are to be used; so they will need to attend very carefully to the following information about the data tables. The users of these files must also download the images separately and re-establish links to include images in their database. The image files are in TIFF format and are provided in a separate compressed file. We had originally planned to provide a set of DBF-formatted files; after starting to generate them, however, we discovered that this format was producing files too large to handle conveniently. The ASCII files may be utilized if you have software that requires DBF formatted files. We will be examining the issues behind the relative file sizes, and will report on it in a later CSA Newsletter.
There are fourteen separate data tables that make up the Lerna IV pottery database. Each is a separate computer file in FileMaker, and each is also its own ASCII file. In Access, however, all tables are included in the single Access file. Each table contains information regarding a limited subject area. Each table is also related to one or more other tables, and the relationships are crucial to the functioning of the whole. In the following sections, the tables and the fields in them are explained, as are the relationships. Because PC file names may be restricted to 8 characters, Filemaker and ASCII file names are included in parentheses after each Access table name. Please let us know if the explanations of either the tables or of the relationships are unclear.
The Catalog1 table (CATALOG1 in FileMaker and ASCII files) contains the basic information from the entries for the individual catalogued items. Each actual catalog entry, in text form, is included, but the information has also been tabularized, as can be seen from the following description of the contents of this table.
| Catalog1 (CATALOG1) - Basic catalog entries as they appear in the paper catalog | ||
|---|---|---|
| Field Name | Field Type | Field Description |
| CatNo | Text | Catalog Number |
| CatEntry | Memo | Actual catalog entry from paper version |
| Phase | Text | Phase to which vessel is assigned. Phases are described on pp. 3-10 of The Pottery of Lerna IV |
| CatEnID | Number (Long) | Index Key (assigned by us, not found in the catalog) |
| Class | Text | Class as defined in CLASSES table |
| Ht | Number (Single) | Height in cm. |
| HtRemarks | Text | Explanation of Ht number (e.g., est. or range of values) |
| RimDiam | Number (Single) | Rim diameter in cm. |
| RimRemarks | Text | Explanation of RimDiam number (e.g., est. or range of values) |
| MaxDiam | Number (Single) | Max. diameter of vessel in cm. |
| DiamRemarks | Text | Explanation of MaxDaim number (e.g., est. or range of values) |
| BaseFoot | Number (Single) | Base or foot diameter in cm. |
| BaseRemarks | Text | Explanation of BaseFoot number (e.g., est. or range of values) |
| FormShape | Text | Form as defined in MORPHOLOGY table |
| FormRemarks | Text | Remarks about uncertainty of shape assignment |
| FormType | Text | Form type as defined in MORPHOLOGY table |
| FormDetail | Text | Remarks about uncertainty of type assignment |
| Syntax | Text | Syntax code as defined in SYNTAX table |
| SyntaxRemarks | Text | Remarks about uncertainty of syntax assignment |
| TopOfLid | Text | Description of decoration on top of lid, including pattern as defined in PATTERN table |
| SideOfLid | Text | Description of decoration on side of lid, including pattern as defined in PATTERN table |
| InteriorRim | Text | Description of decoration on interior of vessel or rim, including pattern as defined in PATTERN table |
| ExteriorRim | Text | Description of decoration on exterior of vessel of rim, including pattern as defined in PATTERN table |
| Neck | Text | Description of decoration on neck, including pattern as defined in PATTERN table |
| Shoulder | Text | Description of decoration on shoulder, including pattern as defined in PATTERN table |
| Handle | Text | Description of decoration on handle, including pattern as defined in PATTERN table |
| LowerBody | Text | Description of decoration on lower body, including pattern as defined in PATTERN table |
| UndersideBase | Text | Description of decoration on underside of base, including pattern as defined in PATTERN table |
| Foot | Text | Description of decoration on foot, including pattern as defined in PATTERN table |
| DecorativeDesc | Text | Description of decoration on other areas |
| Figure | Text | Figure number in paper version |
| Plate | Text | Plate number in paper version |
| FitchLabSampleNo | Number (Integer) | Sample number assigned by Fitch Lab (chemical analysis) |
| TempleLabSampleNo | Text | Sample number assigned by Temple Lab (petrographic analysis) |
| Clay | Text | Description of clay grade and inclusions |
| Fracture | Text | Munsell number and description of clay color at fractures |
| UnpaintedInt | Text | Munsell number and description of clay color on interior |
| UnpaintedExt | Text | Munsell number and description of clay color on exterior |
| Paint | Text | Munsell number and description of paint color |
| Profile | Text | Description of type of profile |
| Conservation | Text | Conservation work done on vessel |
| WearPattern | Text | Description of wear seen on sherds |
| Incrustations | Text | Description of incrustations found on sherds |
| FigLink | OLE Object | Drawing of vessel |
| PlateLink | OLE Object | Photograph of vessel |
| Relationships with Catalog1 (CATALOG1) | ||
| Field Name | Related tables/files | Linked Field Names |
| CatNo | Sherds | CatNo |
| CatNo | LernaInvNo | CatNo |
| CatNo | PotContext | CatNo |
| CatNo | PrevPub | CatNo |
| Class | Classes | Class |
| FormShape | Morphology | FormShape |
| FormType | Morphology | FormType |
| Syntax | Syntax | Syntax |
| TopOfLid | Pattern | Pattern |
| SideOfLid | Pattern | Pattern |
| InteriorRim | Pattern | Pattern |
| ExteriorRim | Pattern | Pattern |
| Neck | Pattern | Pattern |
| Shoulder | Pattern | Pattern |
| Handle | Pattern | Pattern |
| LowerBody | Pattern | Pattern |
| UndersideBase | Pattern | Pattern |
| Foot | Pattern | Pattern |
| FitchLabSampleNo | FitchAnalsis | FitchLabSampleNo |
| TempleLabSampleNo | ThinSection | TempleLabSampleNo |
The Classes table (CLASSES in FileMaker and ASCII files) contains the information from the classification tree on p. 13 of The Pottery of Lerna IV. This table contains Mr. Rutter's classes of the traditionally used term ware. Each class is defined exclusively in terms of decorative treatment, fabric, surface treatment and color; two to four attributes may define a class. Even the rare imported sherds that are included in this database are fitted into this classification scheme.
| Classes (CLASSES) - The classes of pottery, a description including decorative treatment, fabric, surface treatment, and color | ||
|---|---|---|
| Field Name | Field Type | Field Description |
| Class | Text | Class as defined on pp. 13-29 of The Pottery of Lerna IV |
| Fabric | Text | Description of fabric (applied only to unpainted pottery) |
| ClassID | Number (Long) | Index Key (assigned by us, not in catalog) |
| IsPainted | Text | Yes or No answer to "Is vessel painted?" |
| IsPatterned | Text | Yes if vessel is patterned, no if solidly painted. |
| IsLightOnDark | Text | Yes if pattern is light-on-dark; no if dark-on-light. |
| IsBurnished | Text | Yes/No. |
| IsGray | Text | Yes/No. (The alternatives - brown, black or mottled - are classified together in The Pottery of Lerna IV |
| Relationships with Classes (CLASSES) | ||
| Field Name | Related tables/files | Linked Field Names |
| Class | Catalog1 | Class |
The Context table (CONTEXT in Filemaker and ASCII files) contains the basic information about site contexts - the phase(s) to which they belong and plans or elevations that show their relationships to other contexts and the site itself. Due to time and computer file constraints no links to plans or elevations were included. Additional information about contexts is available in the publication (pp.3-10, 655-662) but was not included in this table because of time constraints.
| Context (CONTEXT) - Descriptions of the findspots | ||
|---|---|---|
| Field Name | Field Type | Field Description |
| Findspot | Text | Code for findspot: Lot Number/Group/Trench/Bothros Number |
| Phase | Text | Phase to which findspot is assigned. Phases are described on pp. 3-10 of The Pottery of Lerna IV |
| Illustration | OLE Object | Included for link to plan or elevation but not currently utilized |
| ContextID | Number (Long) | Index key (supplied by us, not from catalog) |
| Relationships with Context (CONTEXT) | ||
| Field Name | Related tables/files | Linked Field Names |
| Findspot | PotContext | Findspot |
The FitchAnalysis table (FITCHANA in Filemaker and ASCII files) contains results from two different forms of chemical analysis (neutron activation and atomic absorption spectrometry) performed by the Fitch Laboratory, British School, Athens, Greece. Once the chemical compositions of the samples were determined, these compositions were subject to cluster analysis. It is only the results of the cluster analysis that are recorded here. Of course, the full chemical compositions could have been recorded.
| FitchAnalysis (FITCHANA) - The results of the analyses done at the Fitch Laboratory | ||
|---|---|---|
| Field Name | Field Type | Field Description |
| FitchLabSampleNo | Number (Integer) | Sample Number assigned by Fitch Lab |
| NeutronCluster | Text | Cluster assigned by neutron activation analysis, described on pp. 711-22 of The Pottery of Lerna IV |
| SpectrometryCluster | Text | Cluster assigned by atomic absorption spectrometry, described on pp. 722-31 of The Pottery of Lerna IV |
| FitchID | Number (Long) | Index Key (supplied by us, not from catalog) |
| Relationships with FitchAnalysis | ||
| Field Name | Related tables/files | Linked Field Names |
| FitchLabSampleNo | Catalog1 | FitchLabSampleNo |
The LernaInvNo table (LERNAINV in Filemaker and ASCII files) contains inventory numbers assigned to the vessels during the original excavations. In general, inventoried vessels have more completely restored profiles and more detailed catalog entries. Due to joins made after inventory numbers were assigned, a single catalog entry may have multiple inventory numbers.
| LernaInvNo (LERNAINV) - The table of Lerna inventory numbers | ||
|---|---|---|
| Field Name | Field Type | Field Description |
| CatNo | Text | Catalog Number |
| LernaInv | Text | Lerna inventory number originally assigned during excavation |
| InvId | Number (Long) | Index Key (supplied by us, not from catalog) |
| Relationships with LernaInvNo | ||
| Field Name | Related tables/files | Linked Field Names |
| CatNo | Catalog1 | CatNo |
The Morphology table (MORPHOLO in Filemaker and ASCII files) contains information describing the range of vessel forms and types current during the EH III period at Lerna. Form is the broadest descriptor (e.g., "shoulder-handled tankard") while type (e.g., "single strap handle") refines this general classification. Illustrations of the forms and types are found in this table; illustrations of the profiles of vessels are found in the profile terminology table. (Mr. Rutter used the term subtype in his text but treated types and subtypes together as types in the table defining forms, p. 30. We have therefore concerned ourselves only with forms and types.)
| Morphology (MORPHOLO) - The morphology, a description of the shape of the vessels with illustrations | ||
|---|---|---|
| Field Name | Field Type | Field Description |
| FormShape | Text | The form/shape number (Roman numeral) as described on pp. 30-32 and 270-477 of The Pottery of Lerna IV |
| IsOpen | Text | Yes or No answer to "Is this an open shape?" |
| FormName | Text | Name of the form/shape |
| NumbHandles | Number (Integer) | The number of handles or lugs on the vessel |
| HandleForm | Text | Description of the handle form as defined in PROFILET |
| HandleAttach | Text | Description of where handles or lugs are attached |
| RimForm | Text | Description of the rim form as defined in PROFILET |
| NeckForm | Text | Description of the neck form as defined in PROFILET |
| BaseForm | Text | Description of the base or foot form as defined in PROFILET |
| BodyForm | Text | Description of the body form |
| FormDesc | Text | Detailed description of form |
| FormType | Text | Type number (Arabic numeral and letter) as described on pp. 30-32 and 270-477 of The Pottery of Lerna IV |
| TypeDesc | Text | Detailed description of type |
| Illustration | OLE Object | Drawing of form prototype |
| FormID | Number (Long) | Index Key |
| Relationships with Morphology | ||
| Field Name | Related tables/files | Linked Field Names |
| FormShape | Catalog1 | FormShape |
| FormType | Catalog1 | FormType |
| RimForm | ProfileT | Nomenclature field in a "Rim" row/record |
| NeckForm | ProfileT | Nomenclature field in a "Neck" row/record |
| HandleForm | ProfileT | Nomenclature field in a "Handle" Lug" row/record |
| BodyForm | ProfileT | Nomenclature field in a "Body" row/record |
| BaseForm | ProfileT | Nomenclature field in a "Base" Foot" row/record |
The pattern table (PATTERN in Filemaker and ASCII files) contains descriptors of painted decorations found on Light-On-Dark and Dark-On-Light painted ware, along with some illustrations. The patterns have a two level descriptive scheme - pattern (e.g., "triangles") and a motif (e.g., "hatched").
| Pattern (PATTERN) - The patterns, a description and illustration of standard patterns found on the pottery | ||
|---|---|---|
| Field Name | Field Type | Field Description |
| Pattern | Text | Code (Roman numeral) for pattern, as defined on pp 37-38 of The Pottery of Lerna IV |
| PatternSort | Number (Integer) | Pattern Code as an Arabic numeral |
| PatternDesc | Text | Description of pattern |
| Motif | Text | Motif (variant of pattern type) as defined on pp 37-38 of The Pottery of Lerna IV |
| MotifDesc | Text | Description of motif |
| PatternIll | OLE Object | Illustration of pattern and motif |
| PatternID | Number (Long) | Index Key |
| UseDarkOnLt | Text | Yes or No answer to "Is pattern used in Dark-on-light ware?" |
| UseLtOnDark | Text | Yes or No answer to "Is pattern used in Light-on-dark ware?" |
| Relationships with Pattern | ||
| Field Name | Related tables/files | Linked Field Names |
| Pattern | Catalog1 | InteriorRim |
| Pattern | Catalog1 | ExteriorRim |
| Pattern | Catalog1 | Neck |
| Pattern | Catalog1 | Shoulder |
| Pattern | Catalog1 | LowerBody |
| Pattern | Catalog1 | UndersideBase |
| Pattern | Catalog1 | TopOfLid |
| Pattern | Catalog1 | SideOfLid |
| Pattern | Catalog1 | Foot |
| Pattern | Catalog1 | Handle |
The PlanElevation table (PLANELEV in Filemaker and ASCII files) contains plans and elevations of Lerna IV, phase I. Note that only some findspots are indicated on these particular drawings.
| PlanElevation (PLANELEV) - Plans and elevations of the Lerna IV, with indications of some findspots | ||
|---|---|---|
| Field Name | Field Type | Field Description |
| PlanID | Number (Long) | Index Key |
| Description | Text | Description of plan or elevation |
| Image | OLE Object | Drawing |
| There are no linked tables/files | ||
The PotContext table (POTCONTE in Filemaker and ASCII files) contains data on the findspots of the catalog entries. There may be several findspots per vessel because sherds from a single pot may have been scattered over the site.
| PotContext (POTCONTE) -The findspot(s) for each catalog entry | ||
|---|---|---|
| Field Name | Field Type | Field Description |
| CatNo | Text | Catalog number |
| Findspot | Text | Code for findspot: Lot Number/Group/Trench/Bothros Number |
| FindID | Number (Long) | Index Key (supplied by us, not in catalog) |
| Relationships with PotContext | ||
| Field Name | Related tables/files | Linked Field Names |
| CatNo | Catalog1 | CatNo |
| Findspot | Context | Findspot |
The PrevPub table (PREVPUB in Filemaker and ASCII files) contains references to other publications which mention specific catalog entries. Abbreviations for those publications may be found on pp. xxvii-xxxvi of The Pottery of Lerna IV
| PrevPub (PREVPUB) - Previous publications of individual catalog entries Note that there may be more than a single previous publication. | ||
|---|---|---|
| Field Name | Field Type | Field Description |
| CatNo | Text | Catalog Number |
| Publication | Text | Previous publication of vessel |
| PubID | Number (Long) | Index Key (supplied by us, not in catalog) |
| Relationships with PrevPub | ||
| Field Name | Related tables/files | Linked Field Names |
| CatNo | Catalog1 | CatNo |
The ProfileTerminology table (PROFILET in Filemaker and ASCII files) contains links to illustrations of the various profile descriptors (e.g., "thickened everted" ) used in the Morphology table.
| ProfileTerminology (PROFILET) - The terminology used to describe the vessels' profiles with illustrations | ||
|---|---|---|
| Field Name | Field Type | Field Description |
| Area | Text | Area of vessel to which term applies: rim, neck, base, foot, handle, lug, lid |
| Nomenclature | Text | Descriptive term as defined on pp. 58-66 of The Pottery of Lerna IV |
| Image | OLE Object | Illustration of profile |
| DescID | Number (Long) | Index Key (supplied by us, not in catalog) |
| Relationships with ProfileTerminology | ||
| Field Name | Related tables/files | Linked Field Names |
| Nomenclature in a "Rim" row/record | Morphology | RimForm |
| Nomenclature in a "Neck" row/record | Morphology | NeckForm |
| Nomenclature in a "Shoulder" row/record | Morphology | ShoulderForm |
| Nomenclature in a "Handle" row/record | Morphology | HandleForm |
| Nomenclature in a "Lug" row/record | Morphology | HandleForm |
| Nomenclature in a "Base" row/record | Morphology | BaseForm |
| Nomenclature in a "Foot" row/record | Morphology | BaseForm |
The Sherds table (SHERDS in Filemaker and ASCII files) contains descriptions of existing sherd types from each catalog entry, for example "rim", "shoulder with handle," etc. There may be multiple sherd types found for any given vessel.
| Sherds (SHERDS) - The sherd types found for each catalog entry (SHERDS) | ||
|---|---|---|
| Field Name | Field Type | Field Description |
| CatNo | Text | Catalog number |
| FragmentType | Text | Sherd types found |
| FragID | Number (Long) | Index Key |
| Relationships with Sherds | ||
| Field Name | Related tables/files | Linked Field Names |
| CatNo | Catalog1 | CatNo |
The Syntax table (SYNTAX in Filemaker and ASCII files) contains a number of standard decorative schemes which are used in the Lerna IV pottery. The patterns used and their placement on individual pots both change in Lerna IV from the preceding EHII examples.
| Syntax (SYNTAX) - The syntax of the decorative schema, a description of the manner in which decorative patterns are distributed on portions of the vases | ||
|---|---|---|
| Field Name | Field Type | Field Description |
| Syntax | Text | Syntax code (Roman numeral and letter) as defined on p. 35 of The Pottery of Lerna IV |
| InteriorRim | Text | Description of pattern found in this area |
| ExteriorRim | Text | Description of pattern found in this area |
| Neck | Text | Description of pattern found in this area |
| Shoulder | Text | Description of pattern found in this area |
| LowerBody | Text | Description of pattern found in this area |
| UndersideBase | Text | Description of pattern found in this area |
| Foot | Text | Description of pattern found in this area |
| SyntaxId | Number (Long) | Index Key (supplied by us, not in catalog) |
| Relationships with Syntax | ||
| Field Name | Related tables/files | Linked Field Names |
| Syntax | Catalog1 | Syntax |
The ThinSection table (THINSECT in Filemaker and ASCII files) contains photographs of the thin section petrography done at the by the Mineralogy Laboratory, Department of Geology, Temple University, Philadelphia, PA. Only two of the available photographs are presented in this table.
| ThinSection (THINSECT) - The photographs and results of thin section analyses done by the Temple University | ||
|---|---|---|
| Field Name | Field Type | Field Description |
| TempleLabSampleNo | Text | Laboratory Sample NUmber |
| Image | OLE Object | Link to photograph of thin section |
| TempleID | Number (Long) | Index Key (supplied by us, not in catalog) |
| Description | Text | Description of sample |
| Relationships with ThinSection | ||
| Field Name | Related tables/files | Linked Field Names |
| TempleLabSampleNo | Catalog1 | TempleLabSampleNo |
This database was originally designed in Access, so that the greatest number of sample forms, predefined queries, and reports are found in this version. No forms are available in the ASCII version of the database; the available Filemaker layouts are listed below. The greater number of forms and queries available under Access is only a comment on our limited resources, not on the flexibility of other data bases.
The primary data table, i.e. the catalog entries, is presented in four different forms. Only one form, AllData, provides all possible data related to a given catalog entry on a single screen with data from all subsidiary and auxiliary tables. The other three forms illustrate various ways of presenting basic catalog entries as found in The Pottery of Lerna IV; these forms include only the data from the subsidiary tables and, in one case, illustrations. The data in subsidiary and auxiliary tables are present in subforms (an Access term) which are included in the main forms.
There are no individual input forms for the various tables, because we found it easiest to do all data entry from AllData. If you wish to see data from individual tables, you will find that the subforms used by AllData do not usually display the complete set of data contained in the subsidiary tables. For example, fields such as CatNo that provide links between tables are not repeated in the subforms. You should, therefore, open and browse the appropriate table rather than using the subform.
A limited number of images has been included in this database. A list of those images may be found below.
| Sample Forms Available in Access | |||
|---|---|---|---|
| Name | Description | SubForms Used | |
| AllData | All Data Included in the Database | SubClasses SubContext SubFitchClusters SubLernaInvNo SubMorphologyIll SubPattern SubPlanElev SubPrevPub SubProfile SubSherds SubSyntax SubThinSection | |
| BasCat | Basic catalog entries without images and auxiliary tables | SubContext SubLernaInvNo SubPrevPub SubSherds | |
| BasCatCondensed | Basic catalog entries without images and auxiliary tables, but in a condensed form | SubContext SubLernaInvNo SubPrevPub SubSherds | |
| BasCatPlsImages | Basic catalog entries with images, but without auxiliary tables | SubContext SubThinSection SubLernaInvNo SubPrevPub SubSherds | |
The queries and reports mentioned below are available for for the Access version; no queries or reports are available in the ASCII version of the database, while in FileMaker, only a version of the report RimVIII is available.
| Sample Queries and Reports Available in Access | |||
|---|---|---|---|
| Query/Report | Name | Description | |
| Query | PotsByFindspot | A query to select vessels found in a given findspot ("GR2") | |
| Query | PotsByPhaseBothrosAndMorph | Selects all vessels found in Phase I bothroi and displays their morphological types | |
| Query | PrevPublications | Selects all vessels which were published prior to their appearance in The Pottery of Lerna IV | |
| Query and Report | RimVIII | A query and report to generate the statistical distribution of rim diameters for all types of Ouzo Cups (Form VIII) | |
| Query | SampleSentToEitherLab | A query to select vessels sent to either the Fitch or Temple Laboratory | |
| Query | SampleSentToFitchLab | A query to select vessels sent to the Fitch Laboratory | |
| Query | SampleSentToTempleLab | A query to select vessels sent to the Temple Laboratory | |
| Query | SherdsByMorphAndType | A query to select all rim sherds belonging to rim-handled tankards (Form I) | |
| Query | ShoulderLozenge | A query to select all catalog entries with lozenge decorations (pattern XI or described as "lozenge") on the shoulder | |
| Query | ShoulderXI | A query to select all catalog entries with pattern XI on the shoulder | |
| Query | ShoulderXIwithFindspot | As above but with findspot included in display | |
The FileMaker database has the same fundamental design as the Access one. There is not, however, a single layout (analogous to the Access form) that includes the data on all 14 tables. The one most inclusive layout, MasterQuerySmall, contains all data that can be easily linked to Catalog1 records. (By "easily linked," we mean linked via a one-to-many relationship between an auxiliary table and the catalog table. Some auxiliary tables required many-to-many links which we could approximate in Access but not FileMaker.) As with the Access version, if you wish to examine a specific data file, you must open and browse that individual file.
The following table lists the specialized layouts available with the FileMaker version of the Lerna IV Pottery database. Standard layouts that Filemaker automatically generates for every file are not included.
The RimStatistics layout was created to calculate the average rim diameter for Ouzo Cups, Formshape = "VIII". To view this report, find all formshapes = "VIII" and rimdiam > 0, then sort the output by formshape and formtype. Finally, you must view the Rimstatistics layout in Preview mode to see the finished report on screen.
| Sample Layouts Available in Filemaker | |||
|---|---|---|---|
| File | Name of Layout | Description | Cross references to Other Layouts |
| Catalog1.FP3 | MasterQuerySmall | A master screen that shows a basic catalog entry and some related files | PrevPub.FP3 Sherds.FP3 Potconte.FP3 Thinsect.FP3 Fitchana.FP3 Lernainv.FP3 Morpholo.FP3 |
| Catalog1.FP3 | RimStatistics | A report that selects all Form VIII and calculates statistics for rim diameters | None |
four (4) different data file formats are available in compressed (ZIP) form through FTP downloads:
The number of records and positions of the fields in each table/file are the same in all formats. The Access database file, LERNAIV.mdb, is 68.2 MBytes uncompressed. Not all dbf tables have a dbt files associated with them. The record count for FileMaker files (all ASCII files have 1 additional record containing field names) and approximate uncompressed file sizes for other formats are given in the following table:
| Table/File | Record Count | FileMaker file size | ASCII file size | DBF file size (DBF/DBT/MDX/INF) |
|---|---|---|---|---|
| CATALOG1 | 365 | 2.7 Mbytes | 267 Kbytes | 1.9/0.24/0.14/0.001 Mbytes |
| LERNAINV | 73 | 18 Kbytes | 2 Kbytes | 2/N.A./12/1 Kbytes |
| CLASSES | 11 | 17 Kbytes | 1 Kbyte | 2/N.A./8/1 Kbytes |
| MORPHOLO | 67 | 8.4 Mbyte | 18 Kbytes | 40/1/16/1 Kbytes |
| SYNTAX | 9 | 19 Kbytes | 2 Kbytes | 5/N.A./8/1 Kbytes |
| PATTERN | 27 | 1.3 Mbytes | 2 Kbytes | 5/1/6/1 Kbytes |
| PREVPUB | 47 | 20 Kbytes | 2 Kbytes | 4/N.A./8/1 Kbytes |
| SHERDS | 423 | 43 Kbytes | 11 Kbytes | 29/N.A./40/1 Kbytes |
| POTCONTE | 488 | 35 Kbytes | 11 Kbytes | 28/N.A./45/1 Kbytes |
| PLANELEV | 2 | 10.9 Mbytes | 1 Kbyte | 1/1/6/1 Kbytes |
| CONTEXT | 131 | 25 Kbytes | 4 Kbytes | 9/24/22/1 Kbytes |
| PROFILET | 26 | 6.4 Mbytes | 1 Kbyte | 3/1/6/1 Kbytes |
| THINSECT | 1 | 122 Kbytes | 1 Kbyte | 1/1/6/1/ Kbytes |
| FITCHANA | 112 | 16 Kbytes | 2 Kbytes | 4/N.A./12/1 Kbytes |
The following formats have been made available to down load using FTP. All files have been compressed using PKZIP software and will be transmitted in .ZIP format. Please note that the comma delimited ASCII formatted files and dbf/dbt/mdx/inf files do not contain image references, although the fields which were formated to contain the images were included. You must download the images separately and establish links to them yourself if you desire to see the images. Neither the ASCII nor dbf/dbt/mdx/inf versions contain any forms, queries, layouts or reports.
Download lernamdb.zip, MicroSoft Accesstm format. The zipped file size is 5.2 Mbytes.
Download lernafp3.zip, Claris Filemaker Pro® format. The zipped file size is 3.3 Mbytes.
Download lernaasc.zip, ASCII format, comma delimited with field names stored in the first line. The zipped file size is 65 kbytes.
Download lernadbf.zip, dbf 5 format. The zipped file size is 138 kbytes.
Download lernaimg.zip, TIFF formatted images. The zipped file size is 1.2 Mbytes, included in this zip file is an ASCII text file, IMAGES.TXT, that gives the linkages that must be established for the 120 images included.