ΒΑΣΕΙΣ ΔΕΔΟΜΕΝΩΝ - ΤΜΗΜΑ Ι (A-Λ)
Περίγραμμα
Περιεχόμενο Μαθήματος
ΠΕΡΙΕΧΟΜΕΝΟ ΜΑΘΗΜΑΤΟΣ
• Data Bases - Introduction
Database-System Applications, Database Languages, Relational Databases,
Database Design, Object-Based and Semi-structured, Databases, Data
Storage and Querying, Transaction Management, Data Mining and Analysis,
Database Architecture, Database Users and Administrators
• Relational Model : Fundamental Relational-Algebra, Operations, Null Values, Modification of the Database.
• SQL: Data Definition, Basic Structure of SQL Queries, Set Operations,
Aggregate Functions, Null Values, Nested Subqueries, Complex Queries,
Views, Modification of the Database, Joined Relations, Integrity
Constraints, Embedded SQL , Recursive Queries.
• Database Design: Constraints, Weak Entity Sets, Extended E-R
Features, Reduction to Relational Schemas, Unified Modeling Language
elements
• Indexing and Hashing: Ordered Indices, B+-Tree Index Files, B-Tree
Index Files, Multiple-Key Access, Static Hashing, Dynamic Hashing,
Index Definition in SQL.
• Query Processing & Optimization Measures of Query Cost, Selection
Operation, Sorting Join Operation, Other Operations, Transformation of
Relational Expressions, Estimating Statistics of Expression Results,
Choice of Evaluation Plans
• Advanced web data base interfaces: Architectural design, PHP, MYSQL,
Apache, Paging, Form Validation, user authentication, content
management systems
• Advanced data base topics - Data Warehousing - OLAP, Data Mining (KDD process, basic algorithms)
ΧΡΟΝΙΚΗ ΔΙΑΡΘΡΩΣΗ ΔΙΑΛΕΞΕΩΝ ΤΟΥ ΜΑΘΗΜΑΤΟΣ
W1. Introduction to data bases
W2. Relational Model
W3. SQL1
W4. SQL2
W5. Database Design I
W6. Database Design II
W7. XML (by V. Vassalos)
W8. Indexing and Hashing
W9. Advanced web data base interfaces
W10. Advanced web data base interfaces
W11. Query Processing & Optimization
W12. Data Warehousing/mining intro
ΕΝΟΤΗΤΕΣ ΕΡΓΑΣΤΗΡΙΩΝ
i. Relational Algebra (~2 Διαλέξεις, Βοηθός: Νίκος Σαλαμάνος)
ii. SQL (~2 Διαλέξεις, Βοηθός: Νίκος Σαλαμάνος)
iii. Database Design (~1 Διάλεξη, Βοηθός: Μαργαρίτα Καρκαλή)
iv. PHP - MySQL (~3 Διαλέξεις, Βοηθός: Μαργαρίτα Καρκαλή)
v. Query Optimization (~1 Διάλεξη, Βοηθός: Νίκος Σαλαμάνος)
vi. B+ Trees (~1 Διάλεξη, Βοηθός: Μαργαρίτα Καρκαλή)
Ανθρώπινο Δυναμικό
Διδάσκων: Μιχάλης Βαζιργιάννης( http://www.db-net.aueb.gr/michalis/ ).
Υπεύθυνοι εργαστηρίων/φροντιστηρίων
Τρόποι αξιολόγησης / εξέτασης
Η βαθμολογία προκύπτει από τις εξετάσεις (Ε) και τις ασκήσεις (Α).