ENCZSK

Arachnet SNOMED CT

The Arachnet SNOMED CT module is a modification of the West Coast Informatics, Inc. scripts , and the scripts are rewritten so that they can be used for Oracle ADB (Autonomous Database) on OCI (Oracle Cloud Infrastructure).

The Arachnet SNOMED CT module can be used to automatically create a database and populate it with data from the SNOMED CT Int (international version) clinical terminology system. The module is designed for use with Oracle ADB. The database can be used as a basis for medical applications or for use by IT departments in healthcare facilities that use SNOMED CT. Or it can be used by IT professionals in general.

The database can serve as the basis of applications that could show the data in a friendly user interface.

Over the database can be build reference sets for translation into other languages or sets for use in special fields of medicine and their special requirements.

Instructions for use of the Arachnet SNOMED CT Module

1.Download our Arachnet SNOMED CT Module by clicking on the link below. Unzip the downloaded file. The current version is designated to process data from files released by organization SNOMED International as of August 1st, 2024.

The rf2 subdirectory of the extracted Arachnet SNOMED CT module should contain the following files.:

  • association.sql
  • attributevalue.sql
  • compute_transitive_closure.pl
  • compute_transitive_closure.py
  • concept.sql
  • create_schema.sql
  • description.sql
  • descriptiontype.sql
  • drop_tables.sql
  • extendedmap.sql
  • identifier.sql
  • language.sql
  • moduledependency.sql
  • mrcmattributedomain.sql
  • mrcmattributerange.sql
  • mrcmdomain.sql
  • mrcmmodulescope..sql
  • oracle_indexes.sql
  • oracle_procedures.sql
  • oracle_tables.sql
  • oracle_views.sql
  • owlexpression.sql
  • populate_oracle_adb_sqlcl.sh
  • refsetdescriptor.sql
  • relationship.sql
  • relationshipconcretevalues.sql
  • simple.sql
  • simplemap.sql
  • statedrelationship.sql
  • textdefinition.sql
  • transitiveclosure.sql

2. If you already have obtained the SNOMED CT Affiliate License, download the current release files released by SNOMED International (as of August 1st, 2024 for use with current version of Arachnet SNOMED CT Module).

3. After extracting the file SnomedCT_InternationalRF2_PRODUCTION_20240801T120000Z.zip copy the directory Snapshot from the extracted file to the rf2 directory of the Arachnet Snomed CT Module..

4. Open the populate_oracle_adb_sqlcl.sh file, located in the rf2 directory, in a text editor and modify the parameters there according to your local settings.

If you didn't create your Oracle user and schema for SNOMED CT database, you can create them by runninng the sql file create_schema.sql.

  • Ensure that you are in the rf2 directory.
  • Start Oracle SQLcl

    • $ < PATH_TO_YOUR_SQLCL> /sqlcl/bin/sql admin/ < YOUR_ADMIN_PASSWORD > @ < YOUR_DB_SERVICE >

    The Oracle client prompt should appear.

    Type at the prompt:

    sql> @create_schema.sql

  • You can then exit Oracle SQLcl, for example by typing:

    • sql> exit;

  • Open your shell, specifically BASH. In Linux it should be part of the system , in Mac OS and in Windows it must be installed additionally.
  • Run the file populate_oracle_adb_sqlcl.sh by entering the command:

    • $ ./populate_oracle_adb_sqlcl.sh

    Important: You have to be in rf2 directory, where the file populate_oracle_adb_sqlcl.sh is located.

  • If the file does not start, try changing it to be executable, e.g. by typing the command'

    • $ chmod 755 populate_oracle_adb_sqlcl.sh

    .

5. The database creation process can take several tens of minutes depending on the connection, load and configuration of the server and client and other things.
The proces starts when the following message appears on the screen: See oracle.log for output"

When the process is completed, open the file oracle.log in your text editor. The file is located in the rf2 directory.

  • Scroll to the end of the file. If there is the following message there There were one or more errors, the process did not completesuccesfuly..
    You can review the oracle.log file and try to determine where specifically the errors occurred.
    You can also sent the file to the arachnet@maserna.org And we can possibly find, what went wrong.
  • If the following message appears at the end of the oracle.log. file Completed without errors , the process should be complete, and the database on your server should be ready.

In the root directory of the Arachnet SNOMED CT Module there is the howto.txt file,, where you can find further instructions, e.g. the setting of your SQLcl client. If you'll encounter any problem while trying get the database up and running, you can contact us at arachnet@maserna.org.

The module can be downloaded here

You can download the Arachnet SNOMED CT module and create your own copy of the SNOMED CT database.

If you need any modification of the module for your purposes, dealingwith design, the configuration, or anything else, contact us.

Why are we offering you the module?

We hope, that if you will fancy our module and you will use it to create your SNOMED CT database, then you will give us a small contribution for our Arachnet Project, you can get acquainted with here.

It is a project that aimes to develop an application, that we would like to offer to visually impaired physioterapeuts and masseurs, to make their work more meaningful and effective. The project is very large. It is based on artificial intelligence and is therefore very expensive.

If you want to know more about the project, do not hesitate to ask.

Support us

Thank you for your contribution to the development of application for visually impaired physiotherapists and masseurs.

A donation or regular payment