Working With the PIX/PDQ Manager

ProcedureTo Create the PIX/PDQ Database Tables

Before You Begin

Complete To Create the Master Index Database.

  1. Navigate to the directory to which you downloaded the PIX/PDQ projects during installation, and then navigate to the SQL folder.

  2. Open pixpdq_configuration_data.sql in a text editor, and add any systems you added to the systems.sql file in To Create the Master Index Database.

    You need to insert the corresponding namespace ID, universal ID, and encoding scheme for each new system; for example:

    insert into PIX_PDQ_SYSTEMS (NAMESPACEID, UNIVERSALID, ENCODINGSCHEME) values ('HOSPITAL1', '1.4.5.2.6.2.23455', 'ISO')

  3. Save and close the file.

  4. Log in to the midm schema as the user you created in To Create the Master Index Database.

  5. Run the following scripts against the midm schema in the order given.

    • create_pixpdq_configuration.sql

    • pixpdq_configuration_data.sql

  6. Continue to To Create the ATNA Repository Database.