LIS674 Database Design & Creation
LIS 674 - CRN 89092 (Spring 2011)
Note: do not confuse this class with LIS647 System Analysis for Information Management (given the similarity of the codes)
Course Description (from UH catalog)
LIS 674 - CRN 89092 (Spring 2011)
Note: do not confuse this class with LIS647 System Analysis for Information Management (given the similarity of the codes)
Designing and creating textual and/or directory databases from the viewpoint of information specialists and content providers. Needs analysis, file design, record content and structuring, software choice. Students implement prototype database.
Detailed Course Description
Behind most computerized information system there is a backend database; the performance of the system depends of how well designed the database is; understanding how a database is structured will give you knowledge to present diagrams (ER diagrams) with specifications of the data, metadata, standards, relationships, queries and reports needed.
Structuring information is the purpose of the semantic web project, one of the most important works for the future web. This project is being conducted by the inventor of the web, Tim Berners-Lee, as a way to bring order and improve finding information in the web. You will be aware of how many of the ideas in this project seem to be expansion of LIS principles for cataloging, indexing, and retrieval, applied to organization of any kind of information (e.g. booking flights, shopping, administration, health, entertainment, education, etc.)
Students will gain practical experience and will be able to:
Structuring information is the purpose of the semantic web project, one of the most important works for the future web. This project is being conducted by the inventor of the web, Tim Berners-Lee, as a way to bring order and improve finding information in the web. You will be aware of how many of the ideas in this project seem to be expansion of LIS principles for cataloging, indexing, and retrieval, applied to organization of any kind of information (e.g. booking flights, shopping, administration, health, entertainment, education, etc.)
Students will gain practical experience and will be able to:
- Act as a contributing member of a database analysis and design team; act as a designer, building a bridge between users and database developers, programmers
- Apply various software tools for database design: e.g. MS VISIO diagramming tool
- Implement a database prototype which meets users requirements (DBMS: MS Access or MySQL)
- Understand the role of back-end databases in the implementation of online catalogs, digital libraries systems, dynamic websites, and content management systems.
- Apply organization of information principles (metadata / cataloging, taxonomies; relationships; ontologies, thesauri, indexing) as basis for structuring a database to facilitate query formulation and retrieval.
Topics Covered
- Basic data modeling principles (from free text to files and structured data)
- General architecture for database systems - The ANSI-SPARC three level architecture (external, internal and conceptual level)
- Object oriented analysis and design. Theories of categorization and Information organization.
- Phases of database design: conceptual, logical and physical database design
- The relational model and languages
- The Entity Relationship (ER) model; UML notation
- Meta-languages, semantic metadata, standards: e.g. XML; DC (Dublin Core), EAD (Encoded Archival Description), RDF (Resource Description Framework), MARC format)
- Tools and systems: e.g. MS Visio diagramming software, MS Access, MySQL
- Data base driven websites; DBMS (DataBase Management Systems)
- The semantic web project of the World Wide Web Consortium (W3C): Toward a common framework for data structuring to allow sharing and reuse.
Prerequisites
For LIS students: LIS670
For more information, go to http://www2.hawaii.edu/~lquiroga/courses/lis674/lis674.htm
For more information, go to http://www2.hawaii.edu/~lquiroga/courses/lis674/lis674.htm