DB2-RDF-Project MONC GROUP

General Project Description: Supply Chain Ontology

This project involves the creation of an ontology to model concepts and relationships within a supply chain. The ontology is a formal, semantic representation of the supply chain domain using the OWL (Web Ontology Language) to structure and define entities relevant to supply chain management.

Project Objective

The primary goal is to provide a clear and semantic framework to represent different elements involved in a supply chain, such as supply chain projects, shipments, vendors, products, countries, etc. This ontology enhances understanding and interoperability among systems dealing with supply chain-related information.

Project Files

Source Code and Ontology

• InsightfulQueries.txt: Contains insightful SPARQL queries for the supply chain ontology.

• populateSupplyChainRDFdb.ipynb: A Jupyter Notebook file for populating the RDF database with supply chain data.

Dataset

• SCMS_Delivery_History_Dataset(FOR USE).xlsx: An Excel file containing the supply chain delivery history dataset for use in the project.

• SCMS_Delivery_History_Dataset(ORIGINAL).csv: The original CSV version of the supply chain delivery history dataset.

Ontology and RDF Data

• SupplyChain.rdf: The RDF file representing the supply chain ontology.

Visualization

• visualization.svg: SVG file depicting a visualization related to the supply chain project.

Serialization files

• countries.ttl: The Turtle file with the serialization of countries data.
• pq.ttl: The Turtle file with the serialization of PQ Supply Chain data.
• products.ttl: The Turtle file with the serialization of products data.
• projects.ttl: The Turtle file with the serialization of projects data.
• shipment.ttl: The Turtle file with the serialization of shipment data.
• vendors.ttl: The Turtle file with the serialization of vendors data.
• proj-cnt.ttl: The Turtle file with the joins of project and countries data.
• proj-pq.ttl: The Turtle file with the joins of project and PQ Supply Chain data.
• proj-prod.ttl: The Turtle file with the joins of project and product data.
• proj-ship.ttl: The Turtle file with the joins of project and shipment data.
• proj-ven.ttl: The Turtle file with the joins of project and vendor data.

Documentation

• README.md: Project documentation providing an overview, objectives, instructions on how to use the ontology, software installation, key components, queries execution, and a disclaimer.
• analytics.pdf: Analytics analyzes the result of the queries and give some analysis of the data based on the queries result.

How to Use

To utilize the ontology, follow these steps:

1. Clone the repository.
2. Open the ontology in Protegé, an ontology editing tool.
3. Add instances, define relationships, and save your changes.

Installing the software

1. Download Protégé Desktop for your OS from the Protégé website.
2. Extract the compressed file to a location of your choice.
3. Run the executable or shell script.
4. If prompted, install the Snap SPARQL Query Plugin.

Opening Ontology Files

• Open an ontology file in your system (e.g., .ttl, .owl) by clicking File -> Open.
• Open an ontology file on the web by copying its URL, then click File -> Open by URL and paste the URL into the URI text box.

Key Components

The main classes in the ontology include:

• Project: Represents specific projects related to the supply chain.
• Shipment: Represents the physical shipment of products.
• Vendor: Represents suppliers or sellers.
• Product: Represents specific products.
• Country: Represents countries.
• PQSupplyChain: Represents PQ-related data.

Properties such as hasShipment, hasProduct, hasVendor, hasCountry, hasPQSupplyChain are used to define specific relationships and attributes.

Queries Execution

Configuring Protégé to Run SPARQL Queries

To execute SPARQL queries: Ensure you've installed the Snap SPARQL Query Plugin.

1. Open Protégé with an ontology.
2. Go to Window -> Tabs -> SPARQL Query and enable it.
3. Click the SPARQL Query tab.
4. Remove the view by clicking the tiny rightmost box marked with an X.
5. Enable Window -> Views -> Query views -> Snap SPARQL Query.
6. Click the empty view.
7. Start your reasoner (ensure HermiT is selected).
8. Type your query and click Execute.

Disclaimer

This project is a conceptual representation and not intended for ready-to-use implementation. Adaptations may be required based on user needs.

We hope this ontology serves as a valuable tool for modeling and understanding supply chain processes, promoting interoperability, and facilitating communication among systems dealing with supply chain information.