Configuring the nautical product library geodatabase (Maritime Charting)

This workflow provides steps for configuring log file tables and importing the preconfigured XML workspace that contains all the necessary feature classes and tables that can be used in an enterprise geodatabase in SQL Server to manage nautical data and products. It is highly recommended that you use it.

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 product library schema workspace

The XML workspace contains the standard product library tables. It is also preconfigured with a solution node (Nautical) and many class nodes (ENC, Chart, and so on) and has the unit conversion, Element, and VST tables.

步骤:
  1. Unzip the nautical product library file.

    The preconfigured workspace XML for ENC and Chart is available on the Resource Center. There is also one .gdb installed for DNC in the following location, based on your operating system.

    • On Windows XP, browse to <Installation location>\Documents and Settings\All Users\Application Data\Esri\Production10.2.2\Desktop\ProductLibraryFiles.
    • On Windows Vista, Windows 7, and Windows Server 2008, browse to <Installation location>\ProgramData\ESRI\Production10.2.2\Desktop\ProductLibraryFiles.
  2. Start ArcMap.
  3. In the Catalog window, expand Database Connections.
  4. Double-click the product library administrator connection geodatabase to connect to it.
  5. Right-click the geodatabase you just connected to and click Import > XML Workspace Document.
  6. Click the Data option if it is not already selected.
  7. Select the nautical product library located in the directory from step 1.
  8. 单击打开
  9. 单击下一步
  10. 单击完成

Versioning within product library

If you manually import the product library tables and feature classes, such as importing an XML file, you need to verify that all the tables and feature classes are registered as versioned. This allows the software to edit the tables as you create and work with your product library. However, you shouldn't create new versions of the product library tables; this can result in inconsistencies within the versions.

步骤:
  1. Click the Toggle Contents Panel button 切换内容面板 at the top of the window.

    The Toggle Contents Panel dialog box appears.

  2. Select every table feature stored in the product library with the exception of the following:

    • ELM_CATEGORIES
    • ELM_ELEMENTS
    • ELM_PRODUCTS
    • ELM_SOLUTIONS
    • PLTS_UCE_CONVERSIONS
    • PLTS_UCE_MAPPINGS
    • PLTS_UCE_ROUNDINGRULES
    • PL_CHART_AOI
    • PL_ENC_AOI
    • PL_NIS_AOI

    提示提示:

    Press SHIFT and/or CTRL, and then the tables to make multiple selections.

  3. Right-click within your selected tables and click Manage > Register as Versioned.

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

  4. 单击确定
  5. Select the following feature classes stored in your product library and click Manage > Register as Versioned.
    • PL_ENC_AOI
    • PL_NIS_AOI
    • PL_CHART_AOI

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

  6. 单击确定

Granting privileges to the database role

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

All features imported with the product library XML workspace need privileges.

All the tables in the product library need to have read/write privileges assigned to them, except the PL_Permission table. The PL_Permission table only needs read privileges assigned to it.

Grant the following privileges to the CKB_USERS database role.

Objects

Role

Privileges

PL_Permission

CKB_USERS

Select

All tables except PL_Permission

CKB_USERS

Select, Insert, Update, Delete

步骤:
  1. In the Toggle Contents Panel dialog box, select the PL_Permission table, right-click, then click Manage > Privileges.

    The Privileges dialog box appears.

  2. 单击添加
  3. Type CKB_USERS into the User/Role text box.
  4. Check the Select check box to assign view privileges to the CKB_USERS for the PL_Permission table.
    Privileges for viewers
  5. Click OK.

    The Toggle Contents Panel dialog box appears.

  6. Select every table stored in the product library with the exception of the following:
    • PL_PERMISSION
    • PL_CHART_AOI
    • PL_ENC_AOI
    • PL_NIS_AOI
  7. Right-click the selected tables and click Manage > Privileges.

    The Change Privileges dialog box appears.

  8. Type CKB_USERS in the User text box.
  9. Click the View (Select) (optional) drop-down arrow and choose GRANT.
  10. Click the Edit (Update/Insert/Delete) (optional) drop-down arrow and choose GRANT.
  11. 单击确定
  12. Select the following feature classes stored in the product library:
    • PL_CHART_AOI
    • PL_ENC_AOI
    • PL_NIS_AOI
  13. Right-click the selected feature classes and click Manage > Privileges.

    The Change Privileges dialog box appears.

  14. Type CKB_USERS 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. Close ArcMap.
4/27/2014