{"id":9649974,"date":"2019-06-01T00:20:00","date_gmt":"2019-05-31T21:20:00","guid":{"rendered":"http:\/\/iee.it.teithe.gr\/course\/%cf%84%ce%b5%cf%87%ce%bd%ce%bf%ce%bb%ce%bf%ce%b3%ce%af%ce%b1-%ce%b2%ce%ac%cf%83%ce%b5%cf%89%ce%bd-%ce%b4%ce%b5%ce%b4%ce%bf%ce%bc%ce%ad%ce%bd%cf%89%ce%bd\/"},"modified":"2025-02-08T15:09:53","modified_gmt":"2025-02-08T12:09:53","slug":"1743","status":"publish","type":"course","link":"https:\/\/www.iee.ihu.gr\/en\/course\/1743\/","title":{"rendered":"Database Technology"},"content":{"rendered":"<p><\/p>\n<ul>\n<li>Embedding SQL code in third generation programming environments.<\/li>\n<li>The Open Access Architecture using JDBC. Create integrated applications using popular DBMSs, such as Oracle, PostgreSQL, Microsoft SQL Server and MySQL.<\/li>\n<li>Frameworks and Object Connection APIs, created in an object-oriented programming language such as Java, with relational database systems or other forms of information management, such as Hybernate, Spring, JPA, JDO and more.<\/li>\n<li>Stored procedures and triggers on the database server.<\/li>\n<li>Online data management services: Explain the design of data web services, their implementation through stored SQL procedures and SQL commands.<\/li>\n<li>Designing databases for an object-relational database system, extending the relational model, embedded collections, the SQL3 query language, and in particular its object-relational extensions, implementing a complete example in Oracle.<\/li>\n<li>Study of the main types of NoSQL databases and their most popular implementations, such as google firebase, mongo db, Neo4j, db4o and more.<\/li>\n<li>Semi-structured data organization technologies such as XML, XML Schema, SQL2008, XQuery, Xpath. Support XML formatting and management of corresponding data in ORDBMS and in native XML environments such as BaseX.<\/li>\n<li>Transaction as a logical unit of work in the DBMS client \/ server environment.<\/li>\n<li>Errors and diagnostics when executing SQL code.<\/li>\n<li>SQL error and exception handling<\/li>\n<li>Transaction anomalies: lost update, dirty read, non-repeatable read, phantoms\/ghosts.<\/li>\n<li>ACID properties, the ideal transaction.<\/li>\n<li>Transaction isolation levels.<\/li>\n<li>Technologies \/ mechanisms for implementing simultaneous control of transaction execution: Multi-Granular Locking Concurrency Control (MGLCC), Multi-Versioning Concurrency Control (MVCC), Optimistic Concurrency Control (OCC).<\/li>\n<\/ul>\n<p><\/p>","protected":false},"author":1,"template":"","meta":{"_acf_changed":false,"inline_featured_image":false,"footnotes":""},"class_list":["post-9649974","course","type-course","status-publish","hentry"],"acf":[],"aioseo_notices":[],"post-meta-fields":{"course-semester":["7"],"_course-semester":["field_5d132f2c14d55"],"course-id":["1743"],"_course-id":["field_5d132b9c78b6e"],"course-group":["\u03a0\u0394\u03a4\u039d"],"_course-group":["field_5d14e905fe59a"],"course-type":["\u0395\u039e"],"_course-type":["field_5d133c6ba1599"],"course-compulsory":["\u0395\u03a0"],"_course-compulsory":["field_5d146d39805a6"],"course-field":["\u0394\u0394\u03a4\u039d"],"_course-field":["field_5d146e248f2b3"],"course-ects":["6"],"_course-ects":["field_5d13518794761"],"course-hours-theory":["4"],"_course-hours-theory":["field_5d13521894762"],"course-hours-lab":[""],"_course-hours-lab":["field_5d1468d18a11f"],"_edit_lock":["1739016556:1"],"_edit_last":["1"],"course-school":["School of Engineering"],"_course-school":["field_5d132bf078b70"],"course-dept":["Department of Information and Electronic Engineering"],"_course-dept":["field_5d132c3a78b71"],"course-level":["1"],"_course-level":["field_5d132c5878b72"],"course-lang":["a:1:{i:0;s:2:\"el\";}"],"_course-lang":["field_5d133e246f04b"],"course-erasmus":["1"],"_course-erasmus":["field_5d133e8e6f04c"],"course-url":["https:\/\/exams-iee.the.ihu.gr\/course\/view.php?id=26"],"_course-url":["field_5d133f9b5c292"],"course-prerequisites":["a:1:{i:0;s:7:\"9649945\";}"],"_course-prerequisites":["field_5d13405189c17"],"course-aim":["The course is a sequel to the course 'Database Management Systems' and focuses on: (a) database management through programming languages, (b) database server programming, (c) transaction programming and concurrency control, (d)  query optimization in the relational model, and (e) non-relational database models. Upon successful completion of the course the student will be able to:"],"_course-aim":["field_5d1353f985af8"],"course-goal-1":["Apply SQL code embedding techniques to programming language code using JDBC technology, software frameworks such as Hybernate, Spring, and object-binding APIs such as JPA, JDO"],"_course-goal-1":["field_5d13546e85af9"],"course-goal-2":["Defines and manage stored procedures and triggers in the database server"],"_course-goal-2":["field_5d1354f885afa"],"course-goal-3":["Design and implement online data management services using stored procedures"],"_course-goal-3":["field_5d13550085afb"],"course-goal-4":["Explain concepts and practices related to modern non-relational models, such as Object Relational Model (SQL3) and NoSQL databases, recognizes the basic concepts and practices of organization, management and processing technologies of semi-structured data and related technologies (XML, XPath, XML Schema , XQuery, SQL2008)"],"_course-goal-4":["field_5d13550e85afc"],"course-goal-5":["Analyze and compare different database models and select the appropriate solution for each data management case"],"_course-goal-5":["field_5d13551485afd"],"course-goal-6":["Explain concepts and practices related to the implementation and application of a simultaneous transaction control policy in the modern DBMS. It also recognizes and distinguishes the different implementation technologies of concurrency control in popular DBMS environments like MySQL\/MariaDB, Oracle, IBM DB2, MS SQLServer, and PostgreSQL"],"_course-goal-6":["field_5d13551b85afe"],"course-goal-7":["Write a programming code with emphasis on transaction management and, through it, ensuring that database content is properly updated. It also simulates and explains problems related to the lack of simultaneous execution of transactions. Also, the extent to which these problems are addressed by imposing levels of isolation on transactions and the use of good practice in developing the relevant programming code, taking advantage of the capabilities offered \/ supported by the modern BAS environment."],"_course-goal-7":["field_5d13552385aff"],"course-skills":["Search, analyze and synthesize data and information, using the necessary technologies\r\nDecision making\r\nIndependent work\r\nTeamwork\r\nExercising criticism and self-criticism\r\nPromoting free, creative and inductive thinking"],"_course-skills":["field_5d1355c25aeb4"],"course-teaching-method":["Person to person theoretical teaching (lecture, discussion, problem solving)."],"_course-teaching-method":["field_5d1383ec75a23"],"course-it-methods":["Using slide show software.\r\nUsing an online learning platform (moodle).\r\nDigital communication with students.\r\nAvailability of selected course lectures in digital video formatting, via the department Video on Demand server.\r\nUse of Virtual Machine Interface of International partnership DBTechNet, with various pre-installed RDBMS software: IBM DB2 Express-C, Oracle Express, PostgreSQL, MySQL. Using the educational content of the course \"Transactions in SQL\" of the DBTechNet International Partnership (http:\/\/dbtech.uom.gr\/mod\/resource\/view.php?id=1064)."],"_course-it-methods":["field_5d1384b975a24"],"course-activity-1":["Lectures"],"_course-activity-1":["field_5d1387d7cba43"],"course-activity-workload-1":["52"],"_course-activity-workload-1":["field_5d1388b2cba46"],"course-activity-2":["Writing and presenting bibliographic work"],"_course-activity-2":["field_5d13886ccba44"],"course-activity-workload-2":["25"],"_course-activity-workload-2":["field_5d1388e9cba47"],"course-activity-3":["\u0395\u03ba\u03c0\u03cc\u03bd\u03b7\u03c3\u03b7 \u03bc\u03b5\u03bb\u03ad\u03c4\u03b7\u03c2 \u03ba\u03b1\u03b9 \u03c5\u03bb\u03bf\u03c0\u03bf\u03af\u03b7\u03c3\u03b7\u03c2 \u03bb\u03bf\u03b3\u03b9\u03c3\u03bc\u03b9\u03ba\u03bf\u03cd"],"_course-activity-3":["field_5d138878cba45"],"course-activity-workload-3":["40"],"_course-activity-workload-3":["field_5d13890dcba49"],"course-activity-4":["Individual study and analysis of literature"],"_course-activity-4":["field_5d138947cba4b"],"course-activity-workload-4":["63"],"_course-activity-workload-4":["field_5d13891dcba4a"],"course-activity-5":[""],"_course-activity-5":["field_5d14ed2508982"],"course-activity-workload-5":[""],"_course-activity-workload-5":["field_5d14ed3708983"],"course-student-evaluation":["Student assessment is based on final written examination and assignments. Assessment criteria are accessible to students on the course web site."],"_course-student-evaluation":["field_5d1389cff8c01"],"course-eudoxus-bib":["R. Elmasri \u03ba\u03b1\u03b9 S.B. Navathe, 2016. \u201c\u0398\u03b5\u03bc\u03b5\u03bb\u03b9\u03ce\u03b4\u03b5\u03b9\u03c2 \u0391\u03c1\u03c7\u03ad\u03c2 \u03a3\u03c5\u03c3\u03c4\u03b7\u03bc\u03ac\u03c4\u03c9\u03bd \u0392\u03ac\u03c3\u03b5\u03c9\u03bd \u0394\u03b5\u03b4\u03bf\u03bc\u03ad\u03bd\u03c9\u03bd\u201d, (7\u03b7 \u03ad\u03ba\u03b4\u03bf\u03c3\u03b7), \u0395\u03ba\u03b4\u03cc\u03c3\u03b5\u03b9\u03c2 \u0394\u03af\u03b1\u03c5\u03bb\u03bf\u03c2, ISBN 978-960-531-343-2, \u039a\u03c9\u03b4\u03b9\u03ba\u03cc\u03c2 \u0392\u03b9\u03b2\u03bb\u03af\u03bf\u03c5 \u03c3\u03c4\u03bf\u03bd \u0395\u03cd\u03b4\u03bf\u03be\u03bf: 50662846.\r\nJ. Hoffer, V, Ramesh, Heiki Topi, 2017. \u201c\u0392\u0391\u03a3\u0395\u0399\u03a3 \u0394\u0395\u0394\u039f\u039c\u0395\u039d\u03a9\u039d: \u03a3\u03a5\u0393\u03a7\u03a1\u039f\u039d\u0397 \u0394\u0399\u0391\u03a7\u0395\u0399\u03a1\u0399\u03a3\u0397\u201d, (11\u03b7 \u0388\u03ba\u03b4\u03bf\u03c3\u03b7), \u0395\u03ba\u03b4\u03cc\u03c3\u03b5\u03b9\u03c2 \u03a4\u03b6\u03b9\u03cc\u03bb\u03b1, ISBN 978-960-418-502-3, \u039a\u03c9\u03b4\u03b9\u03ba\u03cc\u03c2 \u0392\u03b9\u03b2\u03bb\u03af\u03bf\u03c5 \u03c3\u03c4\u03bf\u03bd \u0395\u03cd\u03b4\u03bf\u03be\u03bf: 50656016. \r\nR. Ramakrishnan \u03ba\u03b1\u03b9 J. Gehrke, 2012. \u201c\u03a3\u03c5\u03c3\u03c4\u03ae\u03bc\u03b1\u03c4\u03b1 \u0394\u03b9\u03b1\u03c7\u03b5\u03af\u03c1\u03b9\u03c3\u03b7\u03c2 \u0392\u03ac\u03c3\u03b5\u03c9\u03bd \u0394\u03b5\u03b4\u03bf\u03bc\u03ad\u03bd\u03c9\u03bd\u201d, (3\u03b7  \u03ad\u03ba\u03b4\u03bf\u03c3\u03b7), \u0395\u03ba\u03b4\u03cc\u03c3\u03b5\u03b9\u03c2 \u03a4\u03b6\u03b9\u03cc\u03bb\u03b1, ISBN 978-960-418-411-8, \u039a\u03c9\u03b4\u03b9\u03ba\u03cc\u03c2 \u0392\u03b9\u03b2\u03bb\u03af\u03bf\u03c5 \u03c3\u03c4\u03bf\u03bd \u0395\u03cd\u03b4\u03bf\u03be\u03bf: 22694245."],"_course-eudoxus-bib":["field_5d138e0af441c"],"course-greek-bib":["J.D. Ullman, J. Widom, \u0392\u03b1\u03c3\u03b9\u03ba\u03ad\u03c2 \u0391\u03c1\u03c7\u03ad\u03c2 \u03b3\u03b9\u03b1 \u03c4\u03b1 \u03a3\u03c5\u03c3\u03c4\u03ae\u03bc\u03b1\u03c4\u03b1 \u0392\u03ac\u03c3\u03b5\u03c9\u03bd \u0394\u03b5\u03b4\u03bf\u03bc\u03ad\u03bd\u03c9\u03bd, \u0395\u03ba\u03b4\u03cc\u03c3\u03b5\u03b9\u03c2 '\u039a\u03bb\u03b5\u03b9\u03b4\u03ac\u03c1\u03b9\u03b8\u03bc\u03bf\u03c2', \u0391\u03b8\u03ae\u03bd\u03b1 2008\r\n\u0399. \u039c\u03b1\u03bd\u03c9\u03bb\u03cc\u03c0\u03bf\u03c5\u03bb\u03bf\u03c2, \u0391. \u03a0\u03b1\u03c0\u03b1\u03b4\u03cc\u03c0\u03bf\u03c5\u03bb\u03bf\u03c2, \u03a3\u03c5\u03c3\u03c4\u03ae\u03bc\u03b1\u03c4\u03b1 \u0392\u03ac\u03c3\u03b5\u03c9\u03bd \u0394\u03b5\u03b4\u03bf\u03bc\u03ad\u03bd\u03c9\u03bd: \u0398\u03b5\u03c9\u03c1\u03af\u03b1 \u03ba\u03b1\u03b9 \u03a0\u03c1\u03b1\u03ba\u03c4\u03b9\u03ba\u03ae \u0395\u03c6\u03b1\u03c1\u03bc\u03bf\u03b3\u03ae, \u0395\u03ba\u03b4\u03cc\u03c3\u03b5\u03b9\u03c2 \u039d\u03ad\u03c9\u03bd \u03a4\u03b5\u03c7\u03bd\u03bf\u03bb\u03bf\u03b3\u03b9\u03ce\u03bd, \u0391\u03b8\u03ae\u03bd\u03b1 2006\r\nT. Connolly, C. Begg, \u03ba\u03b1\u03b9 A. Strachan, \u03a3\u03c5\u03c3\u03c4\u03ae\u03bc\u03b1\u03c4\u03b1 \u0392\u03ac\u03c3\u03b5\u03c9\u03bd \u0394\u03b5\u03b4\u03bf\u03bc\u03ad\u03bd\u03c9\u03bd: \u039c\u03b9\u03b1 \u03c0\u03c1\u03b1\u03ba\u03c4\u03b9\u03ba\u03ae \u03c0\u03c1\u03bf\u03c3\u03ad\u03b3\u03b3\u03b9\u03c3\u03b7 \u03c3\u03c4\u03bf \u03c3\u03c7\u03b5\u03b4\u03b9\u03b1\u03c3\u03bc\u03cc, \u03c5\u03bb\u03bf\u03c0\u03bf\u03af\u03b7\u03c3\u03b7 \u03ba\u03b1\u03b9 \u03b4\u03b9\u03b5\u03cd\u03b8\u03c5\u03bd\u03c3\u03b7, \u03c4\u03cc\u03bc\u03bf\u03b9 \u0391 \u03ba\u03b1\u03b9 \u0392, \u0395\u03ba\u03b4\u03cc\u03c3\u03b5\u03b9\u03c2 \u038a\u03c9\u03bd, \u0391\u03b8\u03ae\u03bd\u03b1 2001\r\n\u03a7. \u03a3\u03ba\u03bf\u03c5\u03c1\u03bb\u03ac\u03c2, \u03a3\u03c7\u03b5\u03c3\u03b9\u03b1\u03ba\u03ad\u03c2 \u0392\u03ac\u03c3\u03b5\u03b9\u03c2 \u0394\u03b5\u03b4\u03bf\u03bc\u03ad\u03bd\u03c9\u03bd, \u0395\u03ba\u03b4\u03cc\u03c3\u03b5\u03b9\u03c2 \u039d\u03ad\u03c9\u03bd \u03a4\u03b5\u03c7\u03bd\u03bf\u03bb\u03bf\u03b3\u03b9\u03ce\u03bd, \u0391\u03b8\u03ae\u03bd\u03b1 2000\r\nM. Laiho, D.A. Dervos, K. Silpio, SQL Transactions: \u0398\u03b5\u03c9\u03c1\u03af\u03b1 \u03ba\u03b1\u03b9 \u0391\u03c3\u03ba\u03ae\u03c3\u03b5\u03b9\u03c2 \u03a0\u03c1\u03b1\u03ba\u03c4\u03b9\u03ba\u03ae\u03c2 \u0395\u03c6\u03b1\u03c1\u03bc\u03bf\u03b3\u03ae\u03c2, \u0388\u03ba\u03b4\u03bf\u03c3\u03b7 DBTechNet, ISBN 978-952-93-2421-7, \u0391\u03bd\u03ac\u03ba\u03c4\u03b7\u03c3\u03b7 \u03b1\u03c0\u03cc (30\/6\/2019): http:\/\/150.214.214.5\/DBTechVETProd\/sites\/default\/files\/sql-transactions_handbook_gr_2014-11-12.pdf \r\n\u0391. \u03a3\u03c4\u03b1\u03c5\u03c1\u03b1\u03ba\u03bf\u03cd\u03b4\u03b7\u03c2, \u0392\u03bb\u03b1\u03c3\u03b5\u03b9\u03c2 \u0394\u03b5\u03b4\u03bf\u03bc\u03ad\u03bd\u03c9\u03bd \u03ba\u03b1\u03b9 SQL: \u039c\u03af\u03b1 \u03a0\u03c1\u03b1\u03ba\u03c4\u03b9\u03ba\u03ae \u03a0\u03c1\u03bf\u03c3\u03ad\u03b3\u03b3\u03b9\u03c3\u03b7, 2\u03b7 \u0388\u03ba\u03b4\u03bf\u03c3\u03b7, \u0395\u03ba\u03b4\u03cc\u03c3\u03b5\u03b9\u03c2 \u039a\u03bb\u03b5\u03b9\u03b4\u03ac\u03c1\u03b9\u03b8\u03bc\u03bf\u03c2, \u0391\u03b8\u03ae\u03bd\u03b1 2015"],"_course-greek-bib":["field_5d138e3cf441d"],"course-intl-bib":["W. Lemahieu, S. Van Den Broucke, B. Baesens, Principles of Database Management: The Practical Guide to Storing, Managing, and Analyzing Big and Small Data, Cambridge University Press, 2018\r\nT. Connolly, C. Begg, Database Systems: A Practical Approach to design, Implementation, and Management, 5th Edition, Addison Wesley, 2010\r\nR. Elmasri \u03ba\u03b1\u03b9 S.B. Navathe, Fundamentals of Database Systems, 5th Edition, Addison-Wesley 2006\r\nR. Ramakrishnan \u03ba\u03b1\u03b9 J. Gehrke, Database Management Systems, 3rd Edition, Mc Graw-Hill, 2002\r\nJ.D. Ullman, J. Widom, A First Course in Database Systems, Prentice-Hall, 2007"],"_course-intl-bib":["field_5d138e74f441e"],"course-rel-journals":[""],"_course-rel-journals":["field_5d138ec4f441f"],"course-teachers":["a:1:{i:0;s:7:\"9650980\";}"],"_course-teachers":["field_5d3aa2923f803"],"_wp_old_slug":["%cf%84%ce%b5%cf%87%ce%bd%ce%bf%ce%bb%ce%bf%ce%b3%ce%af%ce%b1-%ce%b2%ce%ac%cf%83%ce%b5%cf%89%ce%bd-%ce%b4%ce%b5%ce%b4%ce%bf%ce%bc%ce%ad%ce%bd%cf%89%ce%bd"],"course-coordinator":["a:1:{i:0;s:7:\"9650980\";}"],"_course-coordinator":["field_5faa4466f1b87"],"_aioseo_title":[null],"_aioseo_description":[null],"_aioseo_keywords":["a:0:{}"],"_aioseo_og_title":[null],"_aioseo_og_description":[null],"_aioseo_og_article_section":[""],"_aioseo_og_article_tags":["a:0:{}"],"_aioseo_twitter_title":[null],"_aioseo_twitter_description":[null]},"_links":{"self":[{"href":"https:\/\/www.iee.ihu.gr\/en\/wp-json\/wp\/v2\/course\/9649974","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.iee.ihu.gr\/en\/wp-json\/wp\/v2\/course"}],"about":[{"href":"https:\/\/www.iee.ihu.gr\/en\/wp-json\/wp\/v2\/types\/course"}],"author":[{"embeddable":true,"href":"https:\/\/www.iee.ihu.gr\/en\/wp-json\/wp\/v2\/users\/1"}],"version-history":[{"count":2,"href":"https:\/\/www.iee.ihu.gr\/en\/wp-json\/wp\/v2\/course\/9649974\/revisions"}],"predecessor-version":[{"id":9673107,"href":"https:\/\/www.iee.ihu.gr\/en\/wp-json\/wp\/v2\/course\/9649974\/revisions\/9673107"}],"wp:attachment":[{"href":"https:\/\/www.iee.ihu.gr\/en\/wp-json\/wp\/v2\/media?parent=9649974"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}