ArcCatalog > Building the Catalog
Creating and accessing geodatabases |
|
|
Release 9.1
Last modified April 17, 2007 |
Print all topics in : "Building the Catalog" |
To manage your own spatial database, you can create a personal geodatabase. If you do this, your data will be stored in a Microsoft Access database. For a multiuser spatial database, use ArcSDE, which lets many people in an organization simultaneously update data stored in a centrally located RDBMS. SDE for Coverages lets you access coverage, ArcStorm, or ArcInfo Librarian databases just as you would an RDBMS.
Learn more about geodatabases and their contents
You can access personal geodatabases directly in ArcCatalog, but to access data stored in an RDBMS ,you must add a database connection. You can create either a spatial database connection or an OLE DB database connection. You'll be prompted for information, such as your username, password, and the database to which you want to connect.
In general, when you create a database connection, you choose the data provider that will retrieve your data from the database. For multiuser spatial databases, ArcSDE is the data provider. OLE DB providers generally retrieve nonspatial data only. You can preview these tables in ArcCatalog and join their values to spatial data. If an OLE DB provider can retrieve spatial data and present it in OGC format, you can preview that data in ArcCatalog. Data accessed through an OLE DB database connection is read-only in ArcGIS.
All database connections are stored in the Database Connections folder by default, but they can be moved elsewhere. For example, you can place a connection that has read-only access to the database in a shared folder where others can access it; they can use it to view the database's contents in ArcCatalog without having to know the details of how to connect to the database.
The first time you attempt to access the contents of a database connection, ArcCatalog tries to connect to the database. If the connection attempt is successful, ArcCatalog will list the items contained in the database. When you see a small red x on the database connection's icon, it is disconnected; until you have reestablished the connection, you can't access data stored in the database.
Items in an RDBMS are owned by the user who created them. When ArcCatalog lists the contents of an ArcSDE geodatabase, the owner's name appears before the item's name. For example, a feature class named "valves" that is owned by the user "admin" would appear in the Catalog as "admin.valves". If the RDBMS supports databases, such as SQL Server, the database name will appear between the owner's name and the object's name. For example, if the valves feature class was stored in a database named "city", it would appear in the Catalog as "admin.city.valves".