Database Technology Essay

designives of the black market This course aims to provide continuum to where the graduation course of selective in takeationbases left off. concept aspects of comparative selective informationbases are covered. Complex data models desire OO OR parallel and distributed are introduced. The course provides students a good overview of the ideas and the techniques, which are female genitals recent developments in the fields of data warehousing and Online Analytical Processing (OLAP). 1. Overview come off of relational database systems, ER diagram, SQL. 2. Integrity and tribute Domain constraints referential integrity, assertions triggers triggers and Assertions in SQL. credentials and Authorization Authorization in SQL. 3. comparative informationbase formula First Normal form pitfalls in relational database design, functional dependencies decomposition. sought after properties of decomposition. Boyce Code normal form third and 4th normal form. Mention of other normal fo rms. 4. The ER Model Revisited pauperization for complex data types, User delimit Abstract info Types And Structured Types, Subclasses, crack classes, Inheritance, Specialization and Generalization, Relationship Types of Degree higher(prenominal) Than Two. 5. Object-Oriented & Object relational databases Object Identity, Object Structure, and Type Constructors, Encapsulation of Operations, Methods, and Persistence, Type Hierarchies and Inheritance, Type extents and Queries, Database Design For An ORDBMS Nested Relations and Collections Storage And Access methods, Overview of SQL3. 6. tally and Distributed Databases Parallel interrogatory Evaluation Parallelizing singular Operations, Sorting, Joins Distributed Database Concepts, Data Fragmentation, Replication, and Allocation techniques for Distributed Database Design Query Processing in Distributed Databases Concurrency Control and retrieval in Distributed Databases.7. Enhanced Data Models for advanced Applications. (Overvi ew and Design issues) Temporal Databases Spatial Databases & geographic Information Systems, Mobile Databases. 8. Data memory board and OLAP. a) Data Warehouse Basics Data Warehouse (DW) Introduction & Overview Data Marts, DW comp acents Data warehouse architecture ETL Data shifting Extracting, Conditioning, cleansing, Scrubbing, Merging, etc., b) OLAP Multi-dimensional modeling Fact table, dimensions, measures, examples Schema Design Star and Snowflake OLAP OLAP Vs OLTP, ROLAP, MOLAP, HOLAP barbs. OLAP Operations Rollup, Drill-down, cube slice, pivot. Text Books 1. Elmasri and Navathe, Fundamentals of Database Systems, Pearson Education2. Raghu Ramakrishnan, Johannes Gerhke, Database focus Systems McGraw pitcher 3. Kimball, Ralph Reeves, Laura et al Data warehouse Lifecycle Toolkit expert methods for designing, developing, and deploying data warehouses Wiley publications. References 1. Korth, Silberchatz, Sudarshan, Database System Concepts McGraw Hill 2. C.J.Date, Long man, Introduction to Database Systems, Pearson Education 3. Paulraj Ponnian, Data depot Fundamentals, John Wiley. Term pasture Term work shall consist of at least 10 assignments/programming assignments and unitary written test. attach 1. Attendance (Theory and Practical) 05 tag2. Laboratory work ( proves and Journal) 10 tag 3. Test (at least one) 10 Marks The final certification and acceptance of TW ensures the able performance of laboratory Work and stripped Passing in the term work. Suggested Experiment List 1. At least one or two review SQL assignments covert triggers, assertions and authorizations. 2. Object Oriented Queries 3. Case subject assignments for OO and OR database. 4. Two mini retchs in distributed and parallel databases. 5. Hands on both one good warehousing tool (Oracle/SQL server Analysis tool etc.) 6. A full fledged mini project in which a student entrust design and implement a data warehouse. The data warehouse must be populated and OLAP queries and op erations to be demo for the warehouse.