Laserfiche WebLink
v�LRfJP rr <br /> Chapter 5 - Database Design and Setup <br /> In This Chapter <br /> Introduction 5. 1 <br /> N Logical Database Design 5-2 <br /> Logical Database Design Methodology 5-4 <br /> Logical Database Design Products 5-5 <br /> Physical Database Design 5-8 <br /> Data Migration 5. 11 <br /> Introduction <br /> It is highly recommended that Indian River County conduct a full database design . <br /> Although the Property Appraiser ' s Office has an enterprise geodatabase ( ArcSDE/Oracle) , <br /> the County will need to develop a full enterprise GIS database ( geodatabase ) to manage <br /> and maintain a variety of GIS data . In order to effectively address this need , the following <br /> components of the Database Design process are recommended for the County : <br /> 1 . Logical Database Design <br /> 2 . Physical Database Design <br /> 3. Data Migration <br /> 4. Database Setup and Administration <br /> Given the County ' s distributed management and maintenance of GIS data layers <br /> throughout various departments and offices, it is recommended that these GIS data layers <br /> be consolidated to a centralized database that can be accessed through the County ' s <br /> network. <br /> Consolidation and centralization of key GIS data layers, such as the County ' s base map <br /> layers (tax parcels , street centerlines , and aerial photography) will eliminate the use of <br /> duplicate, redundant GIS data layers (see Chapter 4: Base Map Layers for more <br /> information ) . A centralized GIS data environment will also streamline data maintenance <br /> efforts and ensure that control and access to the data can be managed more easily . <br /> Special consideration will be needed to ensure that the County ' s enterprise database <br /> integrates existing departmental databases as well as other enterprise databases as much <br /> as possible . In order to implement a hybrid centralized/decentralized GIS data maintenance <br /> model (see Chapter 2 : GIS Organizational Structure ) , it is recommended that departments <br /> that currently manage and maintain GIS data in enterprise databases ( e . g . , Property <br /> Appraiser ' s Office) should continue to have ownership of the data . Based on this model , it <br /> may be viable to have County departments access several enterprise-level databases <br /> ( geodatabases) through the County ' s network . However, if this model is not viable, it is <br /> recommended that a read-only copy of that data maintained in the recommended <br /> centralized enterprise database . <br /> " The " centralized access " model will require an automated mechanism that will aggregate <br /> distributed data and create read-only centralized copies on a regularly scheduled basis <br /> 5- 1 <br /> GIS Needs Assessment and Implementation Plan Chapter 5 - Database Design and Setup <br />