The benefits of the enterprise geodatabase
Although an enterprise geodatabase requires you to invest in the management and administration, the benefits can be highly rewarding. Enterprise geodatabases are built on top of relational database management systems such as Microsoft SQL Server, Oracle, and DB2. These systems are powerful and are wired to sustain constant editing and multiple accesses. With enterprise geodatabases, you can do the following tasks:
- Set up access control
- Build a centralized geodatabase which can be accessed from multiple terminals
- Restrict certain users from viewing a feature class or table
- Restrict certain users from editing a feature class or table
- Restrict users from changing the geodatabase schema
- Edit tracking to know who added a new feature or edited an existing one
In the next section, we will start with the installation of Microsoft SQL Server Express 2012 Service Pack 1.