1 / 20

Digital Media Technology

Digital Media Technology. Week 12. Today. Recapitulation The Semantic Web Semantic Publishing. Terms. Tables, Rows, Columns, Records, Fields Relational data model Data redundancy SQL. Steps. Database Design (Entity Relationship Diagrams) Implementation Data entry Data retrieval.

bella
Download Presentation

Digital Media Technology

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  1. Digital Media Technology Week 12

  2. Today • Recapitulation • The Semantic Web • Semantic Publishing

  3. Terms • Tables, Rows, Columns, Records, Fields • Relational data model • Data redundancy • SQL

  4. Steps • Database Design (Entity Relationship Diagrams) • Implementation • Data entry • Data retrieval

  5. Interpretation continuum Data: relatively unstructured Information: very structured Source: Obrst and Liu, Knowledge representation, Ontological Engineering and Topic Maps, in: XML Topic Maps, 2003

  6. SQL: Structured Query Language • Supported by most RDBMSs. • Makes use of regular English words

  7. SQL for data entry INSERT INTO BOOK VALUES ( '0', 'A Village Commune' , 'OUID', 'CHAT', 'NL HAA', 'eng', '1881' ) ;

  8. Creating tables CREATE TABLE PERSON( P_ID CHAR(4) NOT NULL, NAME_FIRST VARCHAR(200) NOT NULL, NAME_LAST VARCHAR(200) NOT NULL, YEAR_BORN INT(4) NOT NULL, YEAR_DIED INT(4) NOT NULL, NATIONALITY CHAR(2) NOT NULL, PRIMARY KEY ( P_ID ), FOREIGN KEY ( NATIONALITY ) REFERENCES COUNTRY ON DELETE RESTRICT ON UPDATE CASCADE ) ;

  9. Deleting tables or databases DROP DATABASE BOOKTRADE ; DROP TABLE PERSON ;

  10. Database and Narrative • Lev Manovich, The Language of New Media • Textual narrative: linearity and reliance on typography • Database: random access, non-linear, no form

  11. The Semantic web • Envisaged by Tim Berners-Lee as “a web of data that can be processed directly and indirectly by machines” • RDF-Triples • Examples: Subject: “Book-URI” Predicate: “hasISBN” Object: “978-0-252-07829-0”

  12. dbPedia

  13. Nano-Publications

  14. Semantic Publishing

  15. Semantic Publishing

More Related