Download
1 / 20
200 likes | 296 Views
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.
E N D
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
Interpretation continuum Data: relatively unstructured Information: very structured Source: Obrst and Liu, Knowledge representation, Ontological Engineering and Topic Maps, in: XML Topic Maps, 2003
SQL: Structured Query Language • Supported by most RDBMSs. • Makes use of regular English words
SQL for data entry INSERT INTO BOOK VALUES ( '0', 'A Village Commune' , 'OUID', 'CHAT', 'NL HAA', 'eng', '1881' ) ;
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 ) ;
Deleting tables or databases DROP DATABASE BOOKTRADE ; DROP TABLE PERSON ;
Database and Narrative • Lev Manovich, The Language of New Media • Textual narrative: linearity and reliance on typography • Database: random access, non-linear, no form
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”
