Advanced GIS – Flashcards
Unlock all answers in this set
Unlock answersData |
a collection of facts or figures that pertain to places, people, things, events, concepts |
Information |
processed or value added data that have certain perceived values to a user or a community of users |
Knowledge |
transformation of data into information is an explicit act by a user to raise their ___ to a level appropriate for specific decision making purposes |
Intelligence |
When a user deploys knowledge to perceive relationships, formulate principles, and introduce personal values |
System |
1. formed or constructed to achieve certain basic objectives or functions 2. their continuing existence depends on their ability to satisfy the intended objectives-if this ability fails or starts to decline, systems concerned must be upgraded or replaced 3. individual system is composed of many interrelated parts which may be operational systems by themselves 4. these parts operate individually and interact with one another according to certain rules of conduct such as procedures, laws, contractual agreements, and accepted behavior |
Information Systems |
1. is set up to achieve the specific objectives of collecting, storing, analyzing, and presenting information in a systematic manner. 2. structurally is made up of interrelated components that include a combination of data and technical and human resources 3. being made up of input, processing, and output systems, all working according to a well-defined set of operational procedures and protocols. 4. can be operated independently and at the same time linked with other information systems |
Information System Network |
|
Nonspatial Information systems |
those designed for processing data that are not referenced to any position in geographic space. For example, a system for accounting. |
Spatial Information Systems |
those designed for processing data pertaining to real-world features or phenomena that are described in terms of locations |
True/False
All Spatial information systems can be regarded as GIS |
False
CAD systems, CAM systems are also spatial information systems |
True/False
Only those spatial information systems that are ussed for processing and analyzing geospatial data or geographically referenced data can be labeled as a GIS |
True |
Geospatial Data |
|
Geographic Space |
data are registered to an accepted geographic coordinate system of Earth's system so that data from different sources can be spatially cross referenced |
Geographic Scale |
data are normally recorded at relatively small scales and must be generalized and symbolized |
Land Information Systems (LIS)
Land Related Information Systems (LRIS) |
focus of the system on land related activities such as ownership, tax assessment, land and water resources |
Geographic Information Science |
set of basic research issues raised by the handling of geographic information that include geographic data, problem solving, and using geographic information on society
Aims to provide the theoretical and organizational coherence for the scientific study of geographic information |
True/False
Canada produced the first ever GIS |
True |
True/False
GIS was application driven during the 1960's-70's- built to meet specific information needs of individual organizations |
True |
Topology |
refers to the spatial relationship of adjacenc, connectivity, and containment among topographic features |
Impacts of Topology |
|
ESRI |
|
GIS 1980s-1990s |
|
enterprise Computing environment |
integration of geographic data with other type of business data |
Information infrastructure |
|
Location Based Service (LBS) |
LBS makes use of the information about the location of the mobile computer to deliver personalized, localized, and real time geographic services to the user. |
Safety Services
|
enhanced 911 capable of identifying the location of the user in case of emergency |
information services |
traffic information, navigation assistance, yellow pages, and travel/tourism information |
Enterprise services |
vehicle tracking, logistic planning, utility asset inspection and management |
consumer portal services |
delivery of local news, weather report, and forecast, driving directions |
Telematics services |
using GPS technology to obtain real time location information to provide driving directions and vehicle tracking functionality in fleet management |
triggered location services |
including location senstive advertising, billing, and logistics |
Location Awareness |
obtaining location based information by means of coordinates |
Components of GIS |
|
Geospatial Data |
can be categorized into
|
Geodetic Control Network |
|
Topographic Base |
created as the result of a basic mapping program by national state/ provincial, and local government mapping agencies
land surveying and phtogrammetry |
Graphical Overlays |
|
Vector |
data that depict the real world by means of discrete points, lines, and polygons |
Raster |
Data depict the real world by means of a grid of cells with spectral or attribute values
not good for representing individually identifiable features but is ideal for a variety of spatial analysis functions |
Surface Data |
depict the real world by means of a set of selected points or continuous lines of equal vales and can be analyzed and displayed in two or three dimensions and are most suited for natural phenomena |
GIS Database |
can be formed by aggregating one or more geodatabases, usually organized into broad categories such as land use, transportation, hydrology, environment, and utility |
Hardware |
made up of a configuration of core and peripheral equipment that is used for the acquisition, storage, analysis, and display of geographic information. |
Central Processing Unit (CPU) |
perfoms all the data processing and analysis tasks and controls the input/output connectivity with data aquisition, storage, and display systems |
Conventionally GIS |
were developed as tand alone applications that ran on a single host computer, but todays GIS are mostly implemented in a network environment using the client/server model. |
Server |
the computer on which the data and software aer stored |
Client |
computer by which users access the server |
Software |
GIS conventionaly developed using a hybrid approach that handled graphical and descriptive components of geospatial data separately |
geographical data engine |
a proprietary of GIS software that handled graphical data |
Georelational datamodel |
connection between the graphical data engine and the database management system (DBMS) |
data mining |
allow users to identify facts about the real world and transform these facts into geographic objects useful for geospatial data processing and analysis |
The use of object oriented technologies |
has transformed GIS from automated filing cabinets of maps into smart machines for geographic knowledge |
toolbox approach |
allows for users to customize their applications by using scripting language to build software extensions |
component software |
software engineering methodolgy that has been evolving since the early 1990s, addresses the integration of separate computer based applications such as document imaging, optical character recognition, database query. |
GIS as a field of academic study |
|
GIS as a branch of information technology |
|
GIS as a data institution |
|
Geographic Scale |
Scales of interest to human activity/interaction. Refers to spaces concerning the Earth's surface or near-surface |
Spatial Scale |
Can refer to a theoretical or mathematical space and can thus be applied to all spaces and scales, real and otherwise |
Geographic Space |
The commonality of both the data and the problems that the systems are developed solve is geography, i.e. location, distribution, pattern and relationship within a specific geographical reference framework |
Geographic Scale
|
data usually recorded at relatively small scales and must thus be generalized and symbolized |
Define GIS |
GIS is a collection of hardware, software, data, policies, procedures, and people for the input, storage and retrieval, manipulation and analysis, output and modeling of spatially referenced data |
Pacel Based LIS |
emphasis on landownership and other castral applications. lands divided into parcels that have legal descriptions |
non-parcel bassed LIS |
natural resources IS, used for habitat/wildlife evaluation and management, flood hazard mitigation, conservation easement, etc. |
What is not a GIS? |
|
Types of GIS Software Packages
|
|
Computing planar distance using distance theorem |
d-v(x2-x1)^2 + (y2-y1)^2
where X2-x1 = difference in longitude
where y2-y1 = difference in latitude
D = distance between two points |
Communication Paradigm |
assumed that map itself was a final product designed to communicate a spatial pattern via symbols, class limit determinations etc. |
Analytical paradigm
|
maintains raaw data in computer storage device for subsequent analysis - GIS |
Map |
generalized view of an area as seen from above typically reduced in size |
cartography |
subfield of geography that focuses on map-making |
scale |
ratio of map units to ground units |
projection |
process of transforming spherical Earth to flat map |
Map Projections |
can be perspective or nonperspective |
Perspective Map projection |
strictly geometric, use of a point of origin, or viewpoint, and a surface of projection. viewpoint selected baased on a certain critieria |
Nonperspective Map Projection |
modifying the perspective projection to maintain desired properties - Ex. Mercator Map |
Map projections |
can be expressed according to generalized functional relationships between geographical coordinates of a point on the Earth's surface and the coordinates on the plane |
Properties of Globes |
parallels are always parallel to each other, meridian converge at poles and are evenly spaced along any parallel; distance between parallels decreases towards poles |
Map projection properties |
|
Shape |
|
Meridians |
intersect parallels at right angles |
Area |
|
true direction |
inherent property of azimuthal class projections since all meridians pass through the pole |
Conformal Projection |
naturally preserves shapes and true direction |
Mercator Projection |
|
Disadvantages of Mercator Projection |
midlatitude and poleword landmasses dramatically stretched
|
Classes of Projection |
|
Cylindrical Projection |
|
Conical Projections |
|
Planar or Azimuthal Projections |
|
Universal Transverse Mercator (UTM) |
|
Fuller Transformation |
|
Defining Projections in Arc/Info |
for coverages, tins and grids projection information is stored as a PRJ file within their subdirectory and store as a file name .prj |
Cover |
projection information is written to the PRJ of a coverage
|
Grid |
projection information is written to the PRJ of a grid |
File |
projection information is written to the PRJ of an ASCII text file |
TIN |
projection information is written to the PRJ of a tin |
;target; |
data set for which the projection information is being defined |
Georeferencing |
the representation of the location of real world features within the spatial framework of a particular coordinate system |
objective |
provide a rigid spatial framework by which the positions of real-world features are measured, computed, recorded, and analyzed |
geoid and ellipsoid |
deal iwth representing the physical shape of the Earth via a mathematical surface |
Ellipsoid |
|
f = (a-b)/ a |
Amount of polar flattening
where a and be are lengths of major and minor semi axes of the ellipse |
Eccentricity |
e2= (a2-b2)/ a2 |
Geoid |
|
equipotential surface |
surface on which the gravity potential is constant everywhere |
Datum |
model that describes the position, direction, and scale of relationships of a reference surface to positions on the surface of Earth |
Geodetic datums |
|
vertical datum |
|
Geocentric Datum |
|
Relation b/w Coordinate Systems and Map Projections |
|
Universal Transverse Mercator |
projection is used to define the horizontal positions into 6 degree zones, each mapped by the Transverse Mercator projection with a central meridian in the center of the zone |
Spatial Relationships |
|
Spatial attributes |
always interested in location |
Non-Spatial Attributes
|
easily handled by non-spatial databases
spatial attributes and relationships are not handled well by non-spatial databases |
Spatial Data Aquisition |
Land Surveying Remote Sensing Global Positioning System |
Geographic Data Collection |
|
Global Position Systems (GPS) |
|
Radio Frequency Identification (RFID) |
|
RFID |
|
Examples of GIS |
|
Non spatial Data for Thematic Mapping |
|
Non Spatial Levels of Measurement |
usually determined by the valid operations
|
Steven's Levels of Measurement |
|
Binary Scale |
presence or absence. frequently used to represent discrete data in raster systems |
Nominal Scale |
making distinctions in kind/class category |
Ordinal Scale |
|
Interval Scale
|
uses a relative scale, zero is arbitrary and can have negative values |
Ratio Scale |
uses an abosolute zero. zero represents the absence of phenomena |
Criticism of Steven's levels of measurement |
|
Data Dictionary |
defines our terms, levels of measurement, translates computer representation or attributes. |
Data entry |
|
Editing |
|
data management |
|
Analysis |
|
Output |
|
Cartography |
|
human computer interaction |
optimization of communication and presentation of geographic information |
Computational Steering |
user views intermediate results of spatial analysis and based on those results, the algorithmic parameters may be interactively changed |
Isarithmic Mapping |
|
Two forms of Isarithmic Maps |
Both involve the planimetric mapping of the traces of the intersections of horizontal planes with the 3-D surface |
Isometric Maps |
generated from point data
Actual - measure with instruments or other point sampling techniques
Derived- statistiacal measures and magnitudes |
Isoplethic Maps |
generated from mapping data that occured over geographic areas called unit series |
Isarithmic Map Construction |
|
When to use Isarithmic Maps |
|
Nearest Neighbor Interpoloation (Thiessen Polygons) |
|
Advantages of Nearest Neighbour Interpolation |
most appropriate for qualitative data (nominal in scale) |
Disadvantages |
|
Inverse Distance Weighted Interpolation |
|
Inverse Distance Weighted Method |
d= distance between given and observed z- observation point N = number of observations i = iteration z1 = weighted value at a given point T - weighting parameter |
What is the Relationship between r and nearby points in the Inverse Distance Weighted Method |
An increase in r means that the distance is more heavily weighted; thus, the predicted value will be more like closer values |
Inverse Distance Weighted IDW Interpolation summary
|
|
Inverse Distance Weighted Interpolation |
Advantages
Disadvantages
|
Design Process |
|
Criteria for a Good Decision |
|
Design of Symbols
|
|
Point |
conveys a positon |
Line |
exhibit directions as well as position |
Area |
exhibits exten, direction, and position - graphically uniform over the area; even color uniform repetition of a point or line symbols |
Shape |
regular or geometric shapes, irregular shapes as well |
Size |
different geometric dimensions |
Color |
hue, value, and saturation |
Pattern |
combination of basic reptitive graphic elements produces an aerial graphic effect |
Pattern |
Exhibits the characteristics of arrangemetn texture/spaceing and orientation |
Arrangement |
shape and configuration of component marks that make up a patter |
Texture |
size and spacing of component marks that make up a pattern, fine texture; closely spaced small marks |
Design Principles |
|
Map Composition and Layout |
title Map Legend Map scale Map symbols Credits
|
Golden Section |
|
Typography/Lettering |
|
Image Draping |
established technique in GIS. Draping a topographic or thematic map onto a 3-D terrain surface is effective but relies on abstract colors, shading, and symbols. Draping a satellite image such as a digital orthophoto, results in good surface texture and can produce visualizations suitable for depicting landscape-scale vegetation patterns |
Geometric Video Imaging |
combines video imaging techniques with geometric registration typically undertaken within a GIS. its rarely used on a production bases due to the difficulty in accurately geo-referencing the photographic video image with the 3-D perspective |
VRML (Virtual Reality Modeling Language) |
standard file format for representing 3-D interactive vector graphics designed particularly for use with the world wide web |
Moore's Law |
the number of transistors incorporated in a chip will approximately double every 24 months. |
Digital Representation of Geographic Data |
|
Object |
representation of reality, not the thing itself, it is a model |
Feature |
an entity being represented by an object. A defined entity and its oobject representation. this term does not make a distinction between the real thing or the model |
Entity |
A real world phenomneon; entities have relationships and attributes which can be spatial or non spatial |
Object |
discrete and definite |
phenomena |
distributed continuously over a large area |
Representing Geographic Space |
approaches to representation of real world in geographic databases;
|
Spatial Relationships |
|
Spatial Attributes |
always interested in location |
Time |
component of Berry's geographic matrix |
Temporal Relationships |
time, algebra, measurement, relationship |
Measurement of Time |
|
Relationship between Time and Space |
|
Temporarl Attributes of Geographic Process |
|
Logical Organization |
how data are classified and feature coded to facilitate identification of relationships between data items |
physical organization |
method by which data items are stored on a computer |
Data Classification/classification scheme |
purpose of classification scheme: provide an a priori standard with which individual observations can be observed and recorded during data collection process |
Two components of Classification Schemes |
|
Entity |
spatial object that has specific properties that categorically seperate it from other entities. These properties are known as attributes |
Entity class, entity type, or feature class |
collectively, entities that share common attributes |
Feature Codes |
process of encoding the values of the entities and attributes to graphical elements during the data collection process |
Feature Codes comprised of two components |
|
Major Code |
identifies the entity type to which a particular entity belongs |
Minor Code |
Identifies the attributes that an entity has, also referred to as a attribute code |
Feature codes may be |
alphabetic, numeric, or alphanumeric |
Precision |
function of the number of bits used |
Byte |
smallest addressable unit in the computer, an 8-bit data item |
Data Item |
basic building block of data organization in the computer, an occurence or instance of a certain characteristic pertaining to an entity |
Related Data Items |
data items are occurrences of different characteristics pertaining to the same entity |
Record |
a stored record, or tuple |
Data File |
formed by grouping a record together |
True/False
Computer processing is based on databases rather than data files
|
True |
Raster Data Representation |
Grid Cells representing areas of the same entity type have identical values or patterns of the values tend to be spatially clumped |
Raster Data |
run length encoding raster data compression algorithm |
Raster Data Representation Encoding |
Adjacent cells along a row wit hthe same values are treated as a group. Value is stored once together with the number of cells that comprise the run |
Clustering |
goal is to reduce seek and latency time in answering common large queries. For spatial databases this implies that objects are adjacent in space and are commonly requested jointly by queires should be stored physically together in secondary memory |
Three types of Clustering for SDBMS |
|
Internal Clustering |
to speed access to a single object, the complete representation of one object is stored in one disk page, assuming the size is smaller than the free space on the page. otherwise the object is stored on multiple, physically consecutive pages |
Local Clustering |
to speed access to several objects, a set of spatial objects is grouped onto one page |
Global clustering |
a set of spatially adjacent object is stored not on one but several physically consecutive pages that can be accessed by a single read request |
Clustering |
Design of spatial clustering techniques is more difficult than traditional clustering since there is no natural order in multi-dimensional space where spatial data resides. Also disk storage is logical and is only 1-D device |
Clustering |
regarding addressing systems, procedures exist to represent relative locations of the 2 or 3-D kind of 1-D sysstems |
Clustering |
|
Row order (TV) |
total longer path than row prime sequence, every other line is traversed in a reverse direction and have several placves in which neighbors on the path are not adjacent in space |
Diagonal and spiral orders |
like the row prime sequence in possessing the property of immediate adjacency |
Diagonal Sequence |
mixes up corner and side joins |
Spiral Order |
Terminates in the middle, making it impossible to connect other blocks of space |
Comparison of Paths |
|
Space Filling curves |
|
Paths as Space Filling Curves |
|
Peano or N ordering |
facilitates retrieving neighbors; while neighboring points in space are not always neighbors on the curver, they usually are |
Hilber Curve |
passes through all points in a set by means of single length steps only. it meets many of the criteria of an ideal curve, but does not enable the easy retrieval of neighbors. Unstable |
Algorithm for the Z curve (peano) |
|
Algorithm for the Hilbert Curve |
|
Disk access |
Hilbert curvbe method is slightly better than the Z-curve because it does not have any diagonal lines |
Block |
square region that is the result of one or more quadtree subdivisions of the original image. a quadtree recursively subdivides space into four equal parts |
Handling regions |
Each object can be uniquely representaed by the Z-values of its blocks, Each such z-Value can be treated as a primary key of a record of the form |
Space Filling curves for GIS systems |
|
Vector Data Representation |
|
Vector Data Representation Formats |
|
Vector Terminology |
|
Spaghetti data model |
|
Topological Data Model |
|
Spatial Data Transfer Standard (SDTS) |
robust way of transferring earth referenced spatial data between dissimilar computer systems with the potential for no information loss. it is a transfer standard that embraces the philosophy of self-contained transfers, spatial data, attribute, goereferencing, data quality report, data dictionary
|
Classification and intended use of objects in STPS |
|
Point |
|
Node |
zero dimensional object that is a topological junction of two or more links or chains, or an end point of a link or chain |
Line and Line Segment |
|
String |
connected nonbranching sequence of line segments specified as the ordered sequence of points between those line segments. A string may intersect itself or other strings |
Arc |
a locus of points that froms a curve that is defined by a mathematical expression |
Link |
a topological connection between two nodes. A link may be directed by ordering its nodes |
Chain |
|
Complete Chain |
chain that explicity references left and right polygons and start at the end of nodes it is a two dimensional manifold |
Network Chain |
chain that explicitly references start and end nodes and not left and right polygons |
Ring |
sequence of nonintersecting chains or strings and or arcs with closure. a ring represents a closed boundary, but not the interior area inside the close boundary |
Interior Area |
Area not including its boundary |
G-Polygon |
area consisting of an interior area, one outer G ring and zero or more non intersecting nonnested inner G-rings. No ring, inner or outer, must be collinear with or intersect any other ring of the same G-polygon |
GT polygon |
area that is two dimensional component and only one two dimensional maniforld |
Universe polygon |
defines the part of the universe that is outside the perimeter of the area covered by other GT-polygons. This polygon completes the adjacency relationships of the perimeter links |
Pixel |
two dimensional picture element that is the smallest nondivisible element of a digital image |
Grid Cell |
two dimensional object that represents the smallest nondivisible element of a grid |
Two dimensional aggregate spatial objects |
Certain two dimensional aggregate spatial objects must be defined to provide context for many of the simple objects defined above. these aggregate objects are necessary for the definition of raster objects, topology |
Digital Image |
Two dimensional array of regularly spaced picture elements (pixels) constituting a picture |
Grid |
two dimensional set of grid cells forming a regular tesselation of a surface |
Rectangle variant Grid |
Each row and column of the Grid may have independent thickness or width |
Layer |
an areally distributed set of spatial data representing entity instances within one theme, or having one common attribute or attribute value in an association of spatial objects. A layer is specifically a two, three, or N-dimensional array of attribute values associated with all or part of a grid, image, voxel space or any other type of raster data. |
Raster |
one or more related overlapping layers for the same grid, digital image, voxel space, or any other type of raster data. the corresponding cells between layers are registered to the same raster object scan reference system . The layers overlap but need not be of the same spatial extent |
Graph |
set of topologically interrelated zero-dimensional, one dimenional and sometimes two dimensional objects taht conform to a set of defined constraint rules |
Planar Graph |
node and link or chain objects of the graph occur or can be represented as though they occur upon a planar surface. Not more than one node may exist at any given point on the surface |
Network |
a graph without two dimensional objects. If projected onto a two-dimensional surface, a network can have either more than one noede at a point, and intersecting links or chains without corresponding nodes |
Voxel |
a three dimensional object that represents the smallest nondivisible unit of a voxel of space (volume) (think cube) |
Voxel Space |
3 D array of voxels in which the volumetric dataset resides. The volume represents some measurable properties or independent variables of a real object or phenomenon. |
MetaData/MetaInformation |
|
FGDC |
Federal Geographic Data Committe with the goal to provide a complete description of a data source |
ISO |
|
XML |
|
GIS |
A GIS is a collection of hardware, software, data, policies, procedures, and people for the input, sotrage, & retrieval, manipulation and analysis, output and modeling of spatially referenced data |
Relational DBMS |
|
GIS FAct |
Sometimes referred to as a scaleless system but it is not true because you are not changing the original scale that the data was originally collective |
Cognitive GIS |
deals with non-euclidean coordinates |
Error Propagation |
can amplify or cancel out your operations. Understanding how errors propagate is extremely important |
Digital Raster Graph (DRG) |
scanned hardcopy map that has been georeferenced |
Line |
Graphical |
Chain/arc |
topological |
Differential Post Processing |
Most accurate form of GPs |
Projection Surface |
|
Light Source Position |
|
Normal (regular Projection) |
|
Transverse Projection |
|
Oblique Projection |
Projection surface lies at an angle somewhere between the normal and transverse position |
Tangent Projection |
|
Secant Projection |
|
Standard Point |
|
Standard line (line of true scale) |
|
Geodemographics |
demographic information about a population that is spatially consolidated |
Exact Interpolators |
|
Approximate Interpolators |
|
Stoichastic Interpolators |
|
Deterministic Interpolators |
|
Fuzzy Math |
fuze up, precision up, knowledge up, and is easier to work with |
Toblers Law of Geography |
Things closer together in space tend to be more similar than things further apart |
Kriging Interpolation Method |
|
CAD Models |
RGB
Red + Green = Yellow Red + Blue = Magenta Green + Blue = Cyan Red + Green + Blue = white None = black |
HSV Model |
|
HSV Color Model |
|
RGB to HSV |
|
Intensity |
I = 1/3 (R+G+B) |
Hue |
H= cos-1{1/2 (r-g)+(r-b)/ [(r-g)2+(r-b)(g-b)]1/2} |
Saturation |
S = 1-3/ R+G+B [min(r,g,b)] |
Range of calculated saturation and intensity |
S and V [0,1] but can be rescaled down to [0,100] |
HSV to RGB |
|
.twf |
contians coordinate information |
Spatial Frequency |
same occurence in a certain feature |
Spatial Data in Raster Structure |
coordinate pair, cell size, orientation, orientation angle, matrix size # of rows, columns, projection info, scale |
|
|
Vector Data Organization |
|
Raster Facts |
|
Fully specified chain |
|
Nodes |
Id, Point ID, List of Chains |
Chains |
ID, from node to node
topological information, deep structure
Line ID, or point poly - graphical shape info element - surface sturcture |
Polygon |
ID, Label Point ID, Chain List |
SQL Structured Query Language |
syntax for defining and manipulating from a relational database management system |
ArcInfo |
Entity - Record, File, Database |
Record |
collection of individual fields, an entry in the database |
file |
collection of records |
Database |
collection of files |
Numeric Fields |
Stores Numbers |
Alphanumeric fields |
stores numbers and letters |
Kind of Number Fields |
|
Key fields |
|
Database Architecture |
|
Flat File |
|
Disadvantages of Flat Files
|
|
Relational Database |
|
Organize data into multiple relations |
|
Databases Need |
|
Management System (DBMS) |
system for providing efficient, convenient, and safe multi-user storage of and access to massive amounts of persistent data |
Persistent Data |
Data that outlives the software programs that were used to generate them |
DBMS |
|
Transaction Manager |
Enables Entry for new data or allow changes to the Database |
Data Model |
describes the conceptual structuring of the data stored in the database |
DBMS History |
object 5-7%, hierarchical rest of market |
2 main types of languages |
|
Data Manipulating Language |
Commands such as SELECT, INSERT, DELETE |
Data Definition Language |
Commands for creating the schema stored as metadata |
Levels at which DBs can be described |
|
Logical Level |
level at which users view the DB |
Conceptual Level |
concerned with infor design |
Research Area |
Middleware
|
Disk Drivers are Rated by
|
|
ArcSDE |
|
Entity |
like an object or thing |
Entity Set |
|
Attributes |
|
Relationship |
|
Multiway (n-ary) relationships |
|
Multiplicity of Relationships |
|
Beer Diagram |
All of these relationships are many to many (use a round arrow to denote that drinkers have exactly one"
|