Configuring the NIS geodatabase (Maritime Charting)

If you will be working with an enterprise production environment, you can implement any central database or load the Nautical Information System (NIS) XML workspace available with ArcGIS for Maritime:Charting and use this implementation in an enterprise geodatabase in SQL Server.

Configuring log file tables

企业级地理数据库使用日志文件表来维护所选记录的列表。每次选择指定大小的内容时会将记录写入日志文件表以供应用程序之后使用,对版本化数据库执行协调或提交,或者在客户端应用程序中完成离线编辑检出。日志文件表中存储了所选要素的 ObjectID,这样便可重新显示这些要素。支持信息的更快速分析和处理。

在 ArcGIS 中,默认情况下,如果选择集包含 100 或 100 条以上记录,则会使用日志文件表。100 个要素这个阈值可在注册表中设置。可对此阈值进行更改;但 Esri 不建议进行此操作。没有任何证据表明更改此阈值可改善性能,对其进行更改可能造成性能问题。

可使用 SDE_server_config 和 SDE_dbtune 表中的特定参数对日志文件选项进行设置。

这些表中的参数分别通过 sdeconfig 和 sdedbtune 命令进行更改。这些命令和其他 ArcSDE 管理命令行工具必须通过 ArcSDE 应用程序服务器从 Esri 客户关怀中心门户下载。随 ArcSDE 应用程序服务器安装提供的《ArcSDE 管理命令参考》中提供了如何使用这些命令的语法和示例。

对于 SQL Server,默认日志文件配置是在临时数据库 (tempdb) 中创建的基于会话的日志文件。

根据默认设置,将在 tempdb 中以 ##SDE_SESSION<SDE_ID>_<DBID> 格式创建一个表。<SDE_ID> 是来自 SDE_process_information 表的唯一会话 ID。<dbid> 是来自 SQL Server 的数据库 ID。当连接中的应用程序删除其日志文件时,此表将被截断;当会话断开连接时,此表将被丢弃。如果将推荐的 SQL Server 设置用于预置数据库,则用户只需要连接到该数据库的能力,而不需要 CREATE TABLE 权限。

在大多数情况下,数据库管理系统 (DBMS) 的默认 ArcSDE 日志文件表配置应足以满足需要,并且使用推荐的设置。

有关日志文件表的详细信息,请参阅 SQL Server 中地理数据库的日志文件表配置选项

Importing the NIS schema workspace

The NIS XML workspace includes one Nautical feature dataset, three delete feature classes that store the deleted features, one ClosingLinesL feature class that can be used to generate depth areas, collections and FREL tables that store spatial relationship information, and other tables.

步骤:
  1. Start ArcMap.
  2. In the Catalog window, expand Database Connections.
  3. Double-click the NIS owner connection geodatabase to connect to it.
  4. Right-click the geodatabase you just connected to and click Import > XML Workspace Document.
  5. Click the Data option if it is not already selected.
  6. Browse to one of the following locations to open the XML file:
    • For 32-bit Windows operating systems—<Install directory>\Program Files\ArcGIS\MaritimeCharting\Desktop10.2.2\Nis\Schemas\Workspace
    • For 64-bit Windows operating systems—<Install directory>\Program Files (x86)\ArcGIS\MaritimeCharting\Desktop10.2.2\Nis\Schemas\Workspace
  7. Select NAUTICAL_NIS_TEMPLATE_GX.XML.
  8. 单击打开
  9. 单击下一步
  10. 单击完成

Versioning and archiving on the NIS database

Register the following objects as versioned and enable archiving.

Object type

Name

Dataset

Nautical feature dataset

Feature classes

  • ClosingLinesL
  • PLTS_NAUTICAL_DELETES_A
  • PLTS_NAUTICAL_DELETES_L
  • PLTS_NAUTICAL_DELETES_P

Tables

  • PLTS_COLLECTIONS
  • PLTS_FREL
  • PLTS_PRODUCT
  • PLTS_SREL

步骤:
  1. In the Catalog window, click the Toggle Contents Panel button 切换内容面板 at the top.

    The Toggle Contents Panel dialog box appears.

  2. Select the Nautical feature dataset, right-click, then click Manage > Register As Versioned.

    Do not check the Register the selected objects with the option to move edits to base check box.

  3. 单击确定
  4. Select the Nautical feature dataset, right-click, then click Manage > Enable Archiving.
  5. Select the feature classes listed above, right-click the selection, and click Manage > Register As Versioned.

    Do not check the Register the selected objects with the option to move edits to base check box.

  6. 单击确定
  7. Right-click the selected feature classes and click Manage > Enable Archiving.
  8. Select the tables listed above, right-click the selection, and click Manage > Register As Versioned.

    Do not check the Register the selected objects with the option to move edits to base check box.

  9. 单击确定
  10. Right-click the selected tables and click Manage > Enable Archiving.

Defining the NIS database as the production workspace

When creating products using the product library, the production workspace should be pointing to your NIS database so the different processes in the product library can access the central database (NIS) to extract data and create the replica connections from the NIS database to the production database.

步骤:
  1. If necessary, open the Product Library window by clicking Customize > Production > Product Library on the main menu.

    A tree view of the product library appears.

  2. Right-click Product Library and click Select Product Library.

    The Choose Product Library Workspace dialog box appears.

  3. Navigate to the product library database (product library owner connection file).
  4. 单击打开
  5. Click the Add Data button 添加数据 on the Standard toolbar and add any table or feature class from your NIS database.
    提示提示:

    Alternatively, you can drag and drop a table or feature class in the Catalog window from your NIS database into the Table Of Contents window.

  6. In the Product Library tree view, right-click the NIS database and click Create Production Database.
    Product Library tree view for NIS

    The Select Extensions dialog box appears.

  7. Click the Nautical extension and click OK.
  8. Click the drop-down arrow in the Select Configuration Keyword area and choose an option.

    Options may vary based on whether the database is a personal, file, or ArcSDE geodatabase. For an ArcSDE geodatabase, you can choose DEFAULTS unless you have configured a different ArcSDE configuration keyword.

    • DEFAULTS—Stores data up to 1 TB in size; text is stored in UTF8 format.
    • TEXT_UTF16—Stores data up to 1 TB in size; text is stored in UTF16 format.
    • MAX_FILE_SIZE_4GB—Limits data size to 4 GB; text is stored in UTF8 format.
    • MAX_FILE_SIZE_256TB—Stores data up to 256 TB in size; text is stored in UTF8 format.
  9. Click OK.

    The Creating Production Database Workspace dialog box appears with the progress.

  10. Click OK when the process completes.
  11. On the main menu, click Customize > Production > Production Properties.

    The Production Properties dialog box appears.

  12. Click Nautical Properties.
  13. In the Nautical Information System (NIS) section, click the Click to edit property cell next to Workspace and click the ellipsis (...) that appears.
  14. Browse to the location of your NIS database (NIS owner connection file).
  15. Click Open.

    The NIS workspace location is added to the property.

  16. Click OK to close the Production Properties dialog box.
  17. Right-click Product Library and click Configure > Set NIS Owner Workspace.

    A message appears asking if you want to set the NIS Owner Workspace.

  18. Click Yes.

    A message appears saying the NIS Owner Workspace was set successfully.

  19. 单击确定

Associating the NIS data model version

The NIS data model version in the product library represents the schema of the database and the product class version that will contain the configuration files. To ensure that the correct schema and configuration files are used when editing a production database, you need to associate the NIS data model version in the product library to the NIS database.

步骤:
  1. Right-click the NIS database and click Choose Data Model Versions.

    The Choose Data Model Versions dialog box appears.

  2. Check the check box next to the NIS data model you want to associate with this NIS database.
  3. 单击确定
  4. If there is only one data model version, this will be set as the active one; if there is more than one data model version, follow the rest of the steps to set the current one.

  5. If necessary, expand the NIS database and Data Models.
  6. Right-click the data model version and click Set As Active.

    The data model version font changes to bold to indicate that it is the current data model version for the production database.

Granting privileges to the database role

You need to assign privileges to the components in the enterprise geodatabase in SQL Server.

Grant the following privileges to the CDR_EDITOR and CDR_VIEWER database roles for the Nautical feature dataset, all feature classes, and all tables (including the CDR and Prod tables).

Role

Privileges

CDR_EDITOR

Select, Insert, Update, Delete

CDR_VIEWER

Select

步骤:
  1. In the Catalog window, click the Toggle Contents Panel button 切换内容面板 at the top.

    The Toggle Contents Panel dialog box appears.

  2. Select the Nautical feature dataset, right-click, then click Manage > Privileges.

    The Privileges dialog box appears.

  3. 单击添加
  4. Type CDR_EDITOR in the User/Role text box.
  5. 单击确定
  6. 单击添加
  7. Type CDR_VIEWER in the User/Role text box.
  8. 单击确定
  9. Check the Select, Insert, Update, and Delete check boxes for CDR_EDITOR.
  10. Check the Select check box for CDR_VIEWER.

    The privileges should look something like the following.

    Privileges for NIS editors and viewers
  11. 单击确定
  12. Select every table stored in the NIS with the exception of the following:
    • Nautical feature dataset
    • ClosingLinesL
    • PLTS_NAUTICAL_DELETES_A
    • PLTS_NAUTICAL_DELETES_L
    • PLTS_NAUTICAL_DELETES_P
  13. Right-click the selected tables and click Manage > Privileges.

    The Change Privileges dialog box appears.

  14. Type CDR_EDITOR in the User text box.
  15. Click the View (Select) (optional) drop-down arrow and choose GRANT.
  16. Click the Edit (Update/Insert/Delete) (optional) drop-down arrow and choose GRANT.
  17. 单击确定
  18. Right-click the selected tables and click Manage > Privileges.

    The Change Privileges dialog box appears.

  19. Type CDR_VIEWER in the User text box.
  20. Click the View (Select) (optional) drop-down arrow and choose GRANT.
  21. 单击确定
  22. Select the following feature classes stored in the NIS:
    • ClosingLinesL
    • PLTS_NAUTICAL_DELETES_A
    • PLTS_NAUTICAL_DELETES_L
    • PLTS_NAUTICAL_DELETES_P
  23. Right-click the selected feature classes and click Manage > Privileges.

    The Change Privileges dialog box appears.

  24. Type CDR_EDITOR in the User text box.
  25. Click the View (Select) (optional) drop-down arrow and choose GRANT.
  26. Click the Edit (Update/Insert/Delete) (optional) drop-down arrow and choose GRANT.
  27. 单击确定
  28. Right-click the selected feature classes and click Manage > Privileges.

    The Change Privileges dialog box appears.

  29. Type CDR_VIEWER in the User text box.
  30. Click the View (Select) (optional) drop-down arrow and choose GRANT.
  31. 单击确定
  32. Close ArcMap.
4/27/2014