# Presentation: 355057

## Attribute Model & Method

**SDTS Attribute Model**
**Modules Involved**
**Attribute Table Design Process**

## SDTS Attribute Model

**ENTITY - ATTRIBUTE - VALUE**
**Examples**
**LAKE  - NATURAL - YES**
**DATASET - PRODUCER - USGS**
**POINT - ENTITY_LABEL - SPRING**

- SDTS Part 1, 4.1.3.6-4.1.3.7 Attributes

## SDTS Attribute Model

**Relational Structure**
**table structures**
**Attributes as column headings**
**Values in table cells**
**joinable**

## SDTS Attribute Model

**NOT Hierarchical**
**No Superclass/subclass of entities**
**No Attributes Hierarchies**

## SDTS Attribute Model

## Table to Module Equivalence

**TABLE**

**ATTRIBUTE MODULE**

## SDTS Attribute Model

**Most other models are convertible to relational**
**Relational is most common in commercial implementations**
**SDTS also allows network model connections**
**Foreign ID can be a table cell value**

## SDTS Attribute Modules

**Data Dictionary/Schema**
**describes entity to attribute links; describe attribute tables**
**Attribute Primary**
**module records represent attribute table rows; backward pointer to owner**
**Attribute Secondary**
**module records represent attribute table rows**

## SDTS Attribute Modules

**Links Between the Modules**
**Fig 1: Generic Module Links ****(next)**
**Fig 2: Foreign Id & Join**
**Fig 3: Many Joins**
**Fig 4: Schema Defines Attribute Modules**
***(example from FIPS173 Annex B)***
***Figures 2,3, and 4 are full page graphics that are included at the end of this section***

## SDTS Attribute Module Links

**Schema Module**

**d e f i n e s**** **

**j o i n s**** **

**foreign id**** **

**Fig. 1 Generic Links**

## Attribute Table Design Process

**The Attribute Modules are not completely defined by the standard**
**The user ****(i.e., data encoder) ****of SDTS must complete the specification of these modules**
**How is this done?**

## Attribute Table Design Process

**Requirements come from**
**native data model**
**profile    ***** (TVP 4.6,4.8,4.9,Annex B & C)***
**database design guidelines**
**Design as many types of attribute modules as needed**
**All records in the same module instance have the same record layout**

## Attribute Table Design Process

**Native data model**
***What are the entities? What are the attributes?***
**spatial object has unordered list of descriptive codes**
**feature has set of attribute and value pairs**
**file header contains descriptive fields**
**any information from the collection/processing environment**

## Attribute Table Design Process

**Profile Guidelines/Reqrs**
**TVP: Each entity shall have its own attribute table**
**If no attributes then use ENTITY_LABEL as the attribute **
**(TVP 4.9, Annex C)**

## Attribute Table Design Process

**Relational Database Design Guidelines**
**Normalization**
**Multi-valued attributes**
**TVP 4.8, Annex B**
**Functional dependencies**

## Attribute Table Design Process

**What are the deliverables?**
**Specifications for attribute tables**
**how many types of tables**
**which columns in each**
**units, formats, etc.**
**Set of Schema Module Records**
**one schema module record for each table column**

## Attribute Exercise

**What would the Schema Records be for this table?**

**Table: ARDS**

## Attribute Exercise

**The Schema records are:**

**WORKSHEET**

## Attribute Exercise

**What would the Tables be for this schema?**

## Atttribute Exercise

**The Tables are:**

**WORKSHEET**

## Attribute Model & Method

**SDTS Attribute Model**
**ENTITY-ATTRIBUTE-VALUE**
**Modules Involved**
***DD/Schema, Attribute Primary, Attribute Secondary***
**Attribute Table Design Process**
**Requirements from native data model,**
**profile guidelines, and**
**relational database design**

- S
- U
- M
- M
- A
- R
- Y

## Solutions

**Solutions on following page**

## Attribute Exercise

**The Schema records are:**

**NAME**

- ARDS
- ARDS
- ARDS

**TYPE**

- ATPR
- ATPR
- ATPR

**ETLB**

- ROAD
- ROAD
- ROAD

**ATLB**

- TYPE
- DESIGNATOR
- MAINTAINER

**FMT**

- A
- A
- A

**SOLUTION**

## Attribute Exercise

**The Tables are:**

- AHYD: ATPR
- NATURAL  ELEVATION   FEATID

- ABOUN: ATPR
- POSACC   FIPS

- BTRAN: ATSC
- FEATID

**SOLUTION**