Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: ESRI ArcSDE application

RE: ESRI ArcSDE application

From: <Paula_Stankus_at_doh.state.fl.us>
Date: Fri, 4 Jun 2004 13:02:39 -0400
Message-ID: <80D4A99A2715674EB2D256DAD89219F6044E8628@dohsmail02.doh.ad.state.fl.us>


Still think that having ArcIMS on a separate server is best.  

Also, we do have ArcSDe installed on the same server as Oracle - SDE is the user for ArcSDE and Oracle - is the owner of the database. That is quite manageable. However, I also have taken on the role of ArcSDe ADmin. - makes life easier.    

-----Original Message-----

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Tom Brown Sent: Friday, June 04, 2004 12:52 PM
To: fuadar_at_yahoo.com
Cc: oracle-l_at_freelists.org
Subject: RE: ESRI ArcSDE application

In response to Tom Mercadante's posting, ArcSDE can support various configurations -  

  1. Installing ArcSDE on the same node as the database server,
  2. Installing ArcSDE on an application server,
  3. Using a form of direct connect, where the SDE process is embedded as a DLL on the client (requires installing Oracle client on each workstation).

Each configuration provides various pros and cons.  

In respect to 1) - It does not require an additional Oracle home. The software is installed as its own system user with its own executables. Does not require any access to the Oracle system user. All ArcSDE requires is an Oracle schema named SDE to create and manage a data dictionary.  

You can find additional information, discussion forums, white papers, etc. http://support.esri.com/  

Good luck.  

Tom

-----Original Message-----

From: Fuad Arshad [mailto:fuadar_at_yahoo.com] Sent: Friday, June 04, 2004 9:39 AM
To: oracle-l_at_freelists.org
Subject: RE: ESRI ArcSDE application

paula any specific init.ora changes .
i know the dbtune defines tablespaces but other than that any thing specific to this application.

Paula_Stankus_at_doh.state.fl.us wrote:

Right on Tom!!!!! ARcSDE by the way is ESRI's (vendor name) middle-tier that basically does "spatial" queries on geodatabases. It is for supporting databases that have geographic components - like points, polygons, various type of shapes stored in your back-end RDBMS and on Oracle this is how it does it:  

-You take a table with geographic coordinates - they call it a business table - it is basically a normal table with data elements that you can directly query (say list of streets in all of Florida) - it also has a shape_id.
-The shape-id is used to do a primary key join to a shape table called S999 that corresponds to the business table. It is basically an index table between the "business table" and the "feature table"
-There is also a F999 table that relates to the business table which has
FID NOT NULL NUMBER(38) NUMOFPTS NOT NULL NUMBER(38) ENTITY NOT NULL NUMBER(38) EMINX NOT NULL FLOAT(64) EMINY NOT NULL FLOAT(64) EMAXX NOT NULL FLOAT(64) EMAXY NOT NULL FLOAT(64) EMINZ FLOAT(64) EMAXZ FLOAT(64) MIN_MEASURE FLOAT(64) MAX_MEASURE FLOAT(64) AREA NOT NULL FLOAT(64) LEN NOT NULL FLOAT(64) POINTS LONG RAW The FID above is a primary key feature id - it defines the "envelope" on which the "shape" will be drawn, - basically the "size" or your shape.  

-Then you have a number of indexes.
 

-When you load a "shapefile", "personal geodatabase", "coverage" into the Oracle database using ArcSde command line or the various ESRI tools you get 4 tables for the price of 1 and associated indexes.
 

-These tables are then used by the ArcSDE instance and its processes on your server to prepare a "secondary" query on the database for fast access.
 

-There are a number of tools like ArcCatalog (very helpful) that can help you managing your ESRI geodatabase.
 

-Permissions - watch out for that. There is a good starting manual called something like "ArcSde optimization for Oracle" - good place to start - read the whole thing.
   

-----Original Message-----

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Mercadante, Thomas F Sent: Friday, June 04, 2004 11:47 AM
To: 'oracle-l_at_freelists.org'
Subject: RE: ESRI ArcSDE application

Never heard or ArcSDE. But I would not let them install apps on the database server. No real reason to do so. It would force multiple Oracle homes, would open up the door to allowing them access to the server (you *know* they will want full access to the server), and just complicate managing the server.  

You have an app server machine. Force them to use it.  

just my 2 cents.  

Tom Mercadante
Oracle Certified Professional

-----Original Message-----

From: Fuad Arshad [mailto:fuadar_at_yahoo.com] Sent: Friday, June 04, 2004 11:42 AM
To: oracle-l_at_freelists.org
Subject: ESRI ArcSDE application

We're working on an ArcSde migration from sqlserver to oracle. i believe the version is 8.2 i was wondering if anyone had any gotchas or any information that we shoudl know. mind you the consultant we have has no clue of either unix nor oracle. Also the consultants are recommending installing app on the database server instead of an app server. This is something i dont like and if anyone has done so reason why is it necessary ?.      

Thanks  

Fuad Arshad



Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
Received on Fri Jun 04 2004 - 12:01:29 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US