Menu

#12 SQL-Ledger Ontology

open
nobody
None
5
2007-02-19
2007-02-19
No

Take the sql-ledger sql database and instrospect it.
extract all the tables, columns and indexes.
create an database ontology for the application.
create an perl script execution ontology.
create an html display ontology
create an http transfer ontology.
create an business ontology.
create an database core model ontology.
reference all ontologies to global ones.

Discussion

  • James Michael DuPont

    the core sql ledger tables in owl format

     
  • James Michael DuPont

    Logged In: YES
    user_id=147871
    Originator: YES

    Here is the beginnings of the database model. we will include other ontologies to define this one in as well.

    File Added: idb.owl

     
  • James Michael DuPont

    the introspector database model

     
  • James Michael DuPont

    introspector business model

     
  • James Michael DuPont

    Logged In: YES
    user_id=147871
    Originator: YES

    here is the start of the business model.
    there are entities like customers and employees.
    then there are relationships between things, transactions being also just a specialization of a relationship.
    then there are resource descriptors (including type descriptors) that can reference physical resources.

    File Added: ibm.owl

     
  • James Michael DuPont

    introspector business model applied to sql ledger

     
  • James Michael DuPont

    Logged In: YES
    user_id=147871
    Originator: YES

    here is the sql ledger ontology being fit into the business model.
    File Added: sql-ledger-ibm-0.2.owl

     
  • James Michael DuPont

    my db introspector extractor

     
  • James Michael DuPont

    Logged In: YES
    user_id=147871
    Originator: YES

    File Added: its.pl

     

Log in to post a comment.