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 : Création de diagrammes and use this implementation in an enterprise geodatabase in SQL Server.

Configuring log file tables

Les géodatabases d'enterprise utilisent des tables de fichiers journaux pour maintenir des listes d'enregistrements sélectionnés. Les enregistrements sont écrits dans les tables de fichiers journaux pour être utilisés ultérieurement par l'application à chaque sélection d'une taille spécifique, lors d'une réconciliation ou d'une réinjection dans une base de données versionnée ou encore lors d'une extraction de mise à jour en mode déconnecté dans une application cliente. Les tables de fichiers journaux stockent les identifiants ObjectID des entités sélectionnées pour qu'ils puissent être réaffichés. Ceci permet une analyse et un traitement plus rapides des informations.

Dans ArcGIS, par défaut, les tables de fichiers journaux sont utilisées si l'ensemble de sélection contient 100 enregistrements ou plus. Cette limite de sélection de 100 entités est définie dans le registre. Vous pouvez modifier cette limite, mais cela n'est pas recommandé. Rien ne prouve que cela améliore les performances et cela risquerait d'entraîner des problèmes de performances.

Des paramètres spécifiques dans les tables SDE_server_config et SDE_dbtune permettent de définir les options de fichiers journaux.

Vous pouvez modifier les paramètres de ces tables à l'aide des commandes sdeconfig et sdedbtune, respectivement. Ces commandes et les autres outils de la ligne de commande d'administration ArcSDE doivent être téléchargés à partir du Portail d'assistance client Esri avec le serveur d'applications ArcSDE. La syntaxe et des exemples d'utilisation des commandes sont inclus dans le manuel ArcSDE Administration Command Reference, fourni avec le programme d'installation du serveur d'applications ArcSDE.

Pour SQL Server, les fichiers journaux de session créés dans la base de données temporaire (tempdb) constituent la configuration de fichier journal par défaut.

With the default settings, one table is created in the tempdb in the format ##SDE_SESSION<SDE_ID>_<DBID>. The <SDE_ID> is the unique session ID from the SDE_process_information table. The <dbid> is the database ID from SQL Server. This table is truncated when the connecting application deletes its log files, and the table is dropped when the session disconnects. If you use the recommended SQL Server settings for on-premises databases, users only require the ability to connect to the database and do not require CREATE TABLE privileges.

Dans la plupart des cas, la configuration des tables de fichiers journaux ArcSDE par défaut de votre SGBD (système de gestion de bases de données) est suffisante, et même recommandée.

For more information on log file tables, see Log file table configuration options for geodatabases in 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.

Etapes :

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. Cliquez sur Ouvrir.
9. Cliquez sur Suivant.
10. Cliquez sur Terminer.

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

Etapes :

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. Cliquez sur OK.
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. Cliquez sur OK.
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. Cliquez sur OK.
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.

Etapes :

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. Cliquez sur Ouvrir.
5. Click the Add Data button on the Standard toolbar and add any table or feature class from your NIS database.
   Astuce:

   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.

   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. Cliquez sur OK.

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.

Etapes :

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. Cliquez sur OK.

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.

4. If necessary, expand the NIS database and Data Models.
5. 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

Etapes :

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. Cliquez sur Ajouter.
4. Type CDR_EDITOR in the User/Role text box.
5. Cliquez sur OK.
6. Cliquez sur Ajouter.
7. Type CDR_VIEWER in the User/Role text box.
8. Cliquez sur OK.
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.
11. Cliquez sur OK.
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. Cliquez sur OK.
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. Cliquez sur OK.
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. Cliquez sur OK.
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. Cliquez sur OK.
32. Close ArcMap.