|
|
| GeoCommunity Mailing List |
| |
| Mailing List Archives |
| Subject: | Re: [gislist] SDE Geodatabase tables defined? |
| Date: |
05/13/2005 12:05:01 AM |
| From: |
Thomas Lee |
|
|
Smith Travis G Civ 56 RMO/GIS wrote:
> Hi Listers,
>
> I wonder if someone could give me a quick education on names and definitions
> of tables within an SDE Geodatabase. I've searched the ESRI books and Google
> to no avail No longer are the days of simple "catch all" terms such as
> feature attribute table. Could you please give me a definition or
> explanation of each of the following and how they differ from one another?
>
> 1. Object Class
Object Oriented design terminology. Can find in most OO book. A group of object
you with common features that you think are important and highlighted to be used
to act as the main criteria for classification. Object can be any intangible
things (concept) or tangible (linear feature such as major road) things.
>
> 2. Business Table
Special term in SDE. Normal not from in RDBMS domain. Table in RDBMS to store
business related information. Try to model the business operation using
business object but try to model in RDBMS table approach
>
> 3. Table w/in each feature class (Are they simply referred to as the
> feature class table?)
Special term in SDE. Normal not from in RDBMS domain. But could be find in
ORACLE SPATIAL.
Table in RDBMS to store spatial or geographic object such as point, line,
polygon, multi-point, multi-line, multi-polygon and etc. By puting series or
coodinate plus header information such as minX, minY, maxX and maxY of the
geometry of the object (geographic or spatial feature). Still using the same
RDBMS modell to conform the unique "table" approach.
>
> 4. Relationship Class
A kind of class to model/represent relationship. As class (things) can be
modlled in table. This can be in table form exactly same as Relational Databae
concept where we have relate table such as many-to-many relationship table.
>
> 5. SDE Table
Table to store SDE object (class, feature, relationship, attribute, system table
and etc)
>
> 6. Others?
>
Others - to what extent and direction? What is not Others (that you don't want
to know?). such as other tables where they are tables to store something that
you want to store, you want to model, you want to represent from the real world
- but in form of table. Why all in tables, because, SDE using RDBMS concept to
represent information in table form. RDB is derived mathematically from set
theory.
Thomas Lee
GIS and remote sensing consultant
Star Vision Ltd.
www.starvision.com.hk
Visiting Lecturer, Hong Kong Polytechnic University
_______________________________________________
gislist mailing list
gislist@lists.geocomm.com
http://lists.geocomm.com/mailman/listinfo/gislist
_________________________________
This list is brought to you by
The GeoCommunity
http://www.geocomm.com/
|
|
Sponsored by:
For information
regarding
advertising rates
Click Here!
|
