Execute the batch file or the shell script updated with the correct password.
Otherwise, please remove then with the DROP command (during user creation / workspace Application Express, Oracle automatically creates EMP and DEPT example tables)
Please check that tables EMP e DEPT are not already present.
Modify the batch file or the shell script by replacing the keyword password by the password string defined during the Oracle XE installation and (only for the shell script) check the Oracle directory path.
#DATABASE MANAGEMENT SYSTEM PDF FILES DOWNLOAD#
Download the batch file Oracle-DB-import.bat ( for Windows) or the shell script Oracle-DB-import.sh ( for Linux) and save it in the same directory in which the empdb.dump file is stored.
#DATABASE MANAGEMENT SYSTEM PDF FILES ARCHIVE#
Download the following archive empdb2013.zip.
To import the database in Oracle on your personal Computer.
#DATABASE MANAGEMENT SYSTEM PDF FILES INSTALL#
To download and install Oracle Express Edition.
Installing Oracle 11g Express Edition at home.
Description of the execution plan operations.
Lab for Homework #4 on data mining with Rapidminer Remark: Write all queries from (a) to (f) DraftSolutionItalianHouseholdĭata warehouse design (SearchingYourHouse)Īdditional optional lab for students who have not completed Practice #1Īdditional optional lab for students who have not completed Homework #2Īdditional optional lab for students who have not completed Practice #3Īdditional optional lab for students who have not completed Practice #4 Material on prerequisites available at the following linksĮxercise 1 (Athlete ranking, Boat rental)ĭraftSolAthleteRanking DraftSolBoatRental ( timecondition)ĭata warehouse design (Italian household)
Clustering ( 2 slides per page, 6 slides per page) K-means parameter setting and Silhouette ( pdf).
Classification ( 2 slides per page, 6 slides per page).
Association rules ( 2 slides per page, 6 slides per page).
Data mining: Pre-processing ( 2 slides per page, 6 slides per page).
Data mining: Introduction ( 2 slides per page, 6 slides per page).
Extended SQL ( 2 slides per page, 6 slides per page).
Introduction to Big Data ( 2 slides per page , 6 slides per page).
Beyond relational databases ( 2 slides per page, 6 slides per page).
Distributed databases ( 2 slides per page, 6 slides per page).
Triggers ( 2 slides per page, 6 slides per page).
Reliability Management ( 2 slides per page, 6 slides per page).
Concurrency Control ( 2 slides per page, 6 slides per page).
Physical design ( 2 slides per page, 6 slides per page).
Query optimization ( 2 slides per page, 6 slides per page).
Physical access to data ( 2 slides per page, 6 slides per page).
Buffer Manager ( 2 slides per page, 6 slides per page).
Introduction to DBMS ( 2 slides per page, 6 slides per page).
In the e-mail body, specify StudentId (matricola), Surname and Name.
In the e-mail subject, specify DBMS – oral part.
Students who want to take the oral part should send an e-mail to Silvia Chiusano (silvia dot chiusano at polito dot it) by October 9, 2018 following these rules:.
NEW The orals will be scheduled on Wednesday Octoat 11am in Sala Colloqui DAUIN (4th floor).
All exam grades will be recorded. Students, who received a grade >= 18 in the written exam and want to reject it, have to send an e-mail to Silvia Chiusano (silvia dot chiusano at polito dot it) by October 10, 2018.
NEW Exam papers will be discussed on Monday Octoat 5pm in Sala Colloqui DAUIN (4th floor).
Exam rules Academic Year 2017-2018 ( pdf).
Summary of homework deliveries ( PDF) (only the students who have delivered at least one homework are in the list).
The results of the exam held on Septemare available in Section “Exams”.