Attribute Data Types and Database Models in GIS

What are table functions in databases?

Functions for loading, editing, outputting, re-ordering, sorting, searching, and subsetting data.

What are aggregate functions in SQL?

Functions like Sum, Average, Count for given conditions.

What is a Database Management System (DBMS)?

Software for managing databases, providing indexing, security, and transaction handling.

What does Real data represent?

A floating-point number, e.g., 1.11, 2.12.

What is Structured Query Language (SQL)?

A language for querying databases, including commands for search and calculations.

What is a String in attribute data?

A sequence of characters, e.g., 'alphabet'.

What is indexing in databases?

A technique to speed up searches.

What is an Integer in attribute data?

A whole number, e.g., 1, 2, 3.

What is an unordered list in data files?

Easy to add data but slow for searches.

What is the purpose of locking in databases?

To manage transactions and ensure data integrity.

What is a hierarchical database?

Data is linked in a tree structure, easy to search but may have duplicate data.

What is a relational database?

Data stored as tuples in tables, minimizes duplicate storage and is more flexible.

What are geographic databases?

Databases that store data by geographic type and often include a geometry column.

What are field definitions in databases?

Defines the type, format, and range for each cell.

What is an ordered data list?

Slower to add data but faster for searches.

What is attribute data?

Descriptive property linked to a place.

What are some logical functions in SQL?

=, <>, <, >, <=, >=, AND, OR, XOR.

What does Boolean data represent?

A binary value, either true/false or 0/1.

What is a database?

A collection of multiple tables/lists for efficient data storage and access.

What is a Blob in attribute data?

Binary Large Object, typically used for images.

What are the types of attribute data?

Integer, Real, Date, String, Boolean, Blob.

What is an indexed list in databases?

Maintains order for faster searches but slower to add data.

What is a Date attribute?

Represents date and time.