Geo Database System detail syllabus for Geoinformatics Engineering (Geo), 2017 regulation is taken from Anna University official website and presented for students of Anna University. The details of the course are: course code (GI8403), Category (PC), Contact Periods/week (3), Teaching hours/week (3), Practical Hours/week (0). The total course credits are given in combined syllabus.
For all other geo 4th sem syllabus for be 2017 regulation anna univ you can visit Geo 4th Sem syllabus for BE 2017 regulation Anna Univ Subjects. The detail syllabus for geo database system is as follows.”
Course Objective:
- To introduce the students to the concepts of DBMS, Spatial Database Management System (SDBMS), Spatial Database design, basic application program development and user interfaces.
Unit I
For complete syllabus and results, class timetable and more pls download iStudy. Its a light weight, easy to use, no images, no pdfs platform to make students life easier.
Unit II
Spatial Concepts and Data Models
Field based model – object based model – spatial data types – operations on spatial objects –
Entity Relationship Model (ER Model) – Relational Model – Constraints and Normal forms of Relational Model – mapping ER model to Relational model – ER model with spatial concepts -Object-oriented data modeling with Unified Modeling Language (UML)
Unit III
Query Language
SQL – Data Definition – Data Manipulation – Basic structure of SQL – Set operations – Aggregate Functions -Simple queries -spatial Vs non spatial- Nested sub queries – Complex queries -Views – Trigger – OGIS standard for extending SQL – example spatial SQL queries – Object relational SQL.
Unit IV
For complete syllabus and results, class timetable and more pls download iStudy. Its a light weight, easy to use, no images, no pdfs platform to make students life easier.
Unit V
Design and Development of Spatial Data Base System
Exploring Spatial Geometry, Organizing spatial data, Spatial data relationships and functionalities SDBMS – Customization – Big Data and Analytics – Tools.
Course Outcome:
At the end of the course the student will be able to understand
- Concepts and architecture of SDBMS
- Concepts of SQL and generation of queries
- Concepts of spatial data storage and design of SDBMS
Text Books:
- Shashi Shekhar, Sanjay Chawla, ||Spatial Databases a Tour|| Prentice Hall, 2003.
- Philippe Rigaux, Michel Scholl, Agnes Voisard Spatial Databases|| Morgan Kaufmann, ISBN13: 9781558605886, ISBN10: 1558605886,2002
References:
- Abraham Silberschatz, Henry F. Korth and S.Sudharshan, Database System Concepts| , Sixth edition, McGraw Hill, 2011
- Ravi Kothuri, Albert Godfrind, Euro Beinat Pro Oracle Spatial for Oracle Database 11g| , Apress , ISBN13 : 9788181288882, 2007
- Regina, Leo Hsu PostGIS in Action| , Oreilly and Associates Inc., ISBN-13: 9781935182269, ISBN-10: 1935182269, 2011
For detail syllabus of all other subjects of BE Geo, 2017 regulation do visit Geo 4th Sem syllabus for 2017 Regulation.
Dont forget to download iStudy for latest syllabus and results, class timetable and more.