GIT 214 > Data Management: Attribute Data > Flashcards

Data Management: Attribute Data Flashcards

Lecture 8 (39 cards)

Study These Flashcards
1
Q

What is Attribute data in a GIS?

A
  • In a GIS, attribute data are stored in attribute tables in .dbf files
  • An attribute table is organized by row and by column
  • Each row represents a spatial feature
  • Each column describes a characteristic
  • Intersect of row & column = Value of particular characteristic
    of a feature
  • A row is also called a record
  • A column is also called a field
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

What are Attribute data types?

A

Refers to how to GIS stores the attribute data.
*Number
*text
*character
*dates
*blob - binary large objects.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

What is measurement scale?

A

Categorical:
1. Nomial
2. Ordinal

Numeric:
3. Interval
4. Ratio

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

What is nominal?

A

No ranking used for naming

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

What is ordinal?

A

Ranking with no number [large>medium> small]

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

What is interval?

A

Have known numerical intervals but no absolute zero ie. there are negative numbers. (temp in farenheit or celcius)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

What is ratio?

A

Same as interval but has an absolute zero. (temp in Kelvin or rainfall)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

What is the measurement scale of attribute data types?

A

nominal > ordinal > interval > ratio
Increasing level of sophistication.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

2 types of attribute data

A

spatial attribute table
non spatial attribute table

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

Feature attribute table

A
  • FeatureID = feature’s geometry
  • Default
  • Geometry like shape, length..
  • 1 Row represents 1 spatial feature
  • Flat file (looks like an Excel spreadsheet)
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

non-spaital attribute table

A
  • No direct link to feature’s geometry
  • Can link to feature table
  • Aim: Efficient storage of attributes
  • Avoid duplication
  • Dbase file (Access, SQL, Oracle)
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

What is DBMS [database management system]?

A

Software package that allows us to manage and manipulate a database.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

What is a database?

A

A database is a collection of interrelated tables in digital format.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

What is the primary objective of a database?

A

collect and maintain information as well as to relate facts and situations that were previously unconnected.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

What are the 5 types of databases?

A
  1. Flat file
  2. Hierarchical
  3. Network
  4. Relational
  5. Object Orientated
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

What is the flat file database?
NB

Study These Flashcards
A
  • Most simple type of database consisting of a single table only
  • All data in one ‘spreadsheet’
  • Excel spreadsheet = .xls/.xlxs
  • Shapefile attribute table = * .dbf
  • Outdated in the GIS arena because it lacks any method of checking data integrity
17
Q

What is heirarchical database?

Study These Flashcards
A
  • Data organized in series similar to family tree
  • Hierarchical structure of records organized in files at differing logical levels … connections between levels
  • Branches comprise parent & child records
    ▪ Parent record can have multiple child records
    ▪ Each child record can have only 1 parent
    ▪ Parent record at top of database… root record
    ▪ There is a one-to-many relationship.
18
Q

What are the advantages of a heirarchical database?

Study These Flashcards
A
  • Easy to understand
  • Easy to search (fast)
  • Easy to expand
19
Q

What are the disadvantages of a heirarchical database?

Study These Flashcards
A
  • Need to explicitly define each relation in advance
  • Difficult to modify structure
  • Large index files requires extra storage space
  • No many-to-many relations
  • Restricted queries
  • Not much used in GIS
20
Q

What is the network database?

Study These Flashcards
A
  • Relationships not hierarchical (or nested)
  • Each table (element/collection of like records) can maintain connections to several tables at different levels
  • Child table can have more than one parent table!
21
Q

What are the advantages of network database?

Study These Flashcards
A
  • More flexible than hierarchical system
  • Many-to-many relation
22
Q

What are the disadvantages of the network database?

Study These Flashcards
A
  • Complex
  • Pointers must be explicitly defined
  • Many pointers = More storage space occupied
  • Limited application
23
Q

What is the Relational database?

Study These Flashcards
A
  • A RDBMS is a DBMS in which data AND the relationships among the data are stored in tables
  • Provide a flexible approach to linkages between records, comes
    close to modelling the complexity of spatial relationships between objects
  • More of a concept than a data structure
    ▪ Internal architecture varies substantially from one RDBMS to another
  • RDBMS structure is a collection of tables (or relations) that can be
    connected to each other by keys
  • Each table must contain a ‘key’ field for linkages.
  • A primary key represents one or more attributes whose values
    can uniquely identify a record in a table
    ▪ Value of the key is unique/ should not change e.g. phone
    number is a unique key in a phone directory
    ▪ Cannot be null
  • A foreign key is one or more attributes that refer to a primary
    key in another table
24
Q

What are the advantages of the relational database?

Study These Flashcards
A
  • Simple and flexible
  • Don’t have to have complete database design from outset
  • Each table independent with key field– only need to ink when run query or analysis
  • Ease of creation and maintenance
  • Efficient data management and data processing
  • Used in many GIS software packages.
25
What are the disadvantage of relational database?
* Can become large and complex
26
What is the object oriented database?
* Spatial data and all related attribute data for a feature is dealt with as an integrated entity * Unlike other systems object-oriented DBMS keep geometric & attribute data together (single unit) * Remember geodatabase example ?
27
What are the advantages of the object orientated database?
* Data is located in one place / stored centrally * Easier to update consistently * Geometry information is stored in the database, and attributes are stored in a single system! * Relational databases (RDBMS) are now often ‘replaced’ by object-oriented approaches due to some weaknesses of relational DBMS: * Inability to store complete objects directly in the database * Problem dealing with rich data types e.g., sound & video * Problem with some queries… limitations on geographic applications.
28
What are the disadvantages of the object oriented database?
* Maintaining values, connections, methods, and behaviour for each object complex.
29
How to link tables?
1. Join 2. Relate 3. Relational Class
30
What does a join do?
brings together two tables by using a common field (primary key and foreign key) - more permanent. ▪ Recommended for one-to-one or many-to-one ▪ Joined data added to original data table ▪ Not suitable for one-to-many, many-to-many (only first matching destination record is assigned to origin)
31
What does a relate do?
temporarily connects two tables, but keeps them separate. ▪ Can connect 3 or more tables simultaneously ▪ Particularly useful in Windows based package ▪ Appropriate for all four types of relationships ▪ Can be very slow, especially if data is in a remote database.
32
What does the relational class do?
Predefined relationships supported and stored in geo-database. ▪ When used for attribute data management a relationship is defined and stored as a relationship class ▪ Appropriate for all four types of relationships
33
What is cardinality?
1. one to one 2. one to many 3. many to one 4. many to many
34
what is one to one cardinality?
One record in join table relates to one and only one record in the input table
35
what is one to many cardinality?
One record in 1st table relates to many in the 2nd
36
what is many to many cardinality?
* E.g., Many owners own more than one property * I.e., A land parcel has many plant species and many plant species occur on many land parcels ▪ Not Join ▪ Relate table
37
What is cardinality?
linkage between data in a GIS database.
38
What is a primary key?
in the primary table
39
What is a foreign key?
in the secondary table
GIT 214
flashcards
Decks in class (17)
# Cards
Brainscape helps you reach your goals faster, through stronger study habits.
© 2026 Bold Learning Solutions. Terms and Conditions