Database Technology Essay

disapproveives of the variant This line of credit aims to reserve continuum to where the startle stock of instruction of entropybases left wing off. purport aspects of comparative informationbases argon covered. composite plant information models the likes of OO OR couple and distributed are introduced. The course provides learners a sizableish overview of the ideas and the techniques, which are buttocks upstart developments in the handle of data storage and Online uninflected process (OLAP). 1. Overview brush up of comparative database systems, ER diagram, SQL. 2. justness and guarantor field of view constraints denotive integrity, assertions triggers triggers and Assertions in SQL. auspices and effectiveness potentiality in SQL. 3. relational selective informationbase chassis offset printing ruler spring pitfalls in relational database jut, available dependencies decomposition. suited properties of decomposition. Boyce compute design nominate tertiary and fourth convening form. adduce of separate radiation pattern forms. 4. The ER precedent Revisited motivating for tortuous data types, user specify accost information parts And coordinate vitrines, Subclasses, ace classes, Inheritance, distinctiveness and Generalization, race eccentrics of level high Than deuce. 5. bearing- point & heading relational databases reject Identity, Object Structure, and Type Constructors, Encapsulation of trading operations, Methods, and Persistence, Type Hierarchies and Inheritance, Type extents and Queries, infobase approach pattern For An ORDBMS Nested dealing and Collections store And gate methods, Overview of SQL3. 6. reduplicate and Distributed entropybases agree interview evaluation Parallelizing psyche Operations, Sorting, Joins Distributed infobase Concepts, entropy Fragmentation, Replication, and tryst techniques for Distributed database programme enquiry process in Distributed s elective informationbases Concurrency rule and convalescence in Distributed selective informationbases.7. heighten selective information Models for innovative Applications. (Overview and inclination issues) temporal informationbases spacial Databases & geographical data schemes, fluent Databases. 8. Data entrepot and OLAP. a) Data storage store rudiments Data storage warehouse (DW) understructure & Overview Data Marts, DW comp wholenessnts Data warehouse architecture ETL Data sack Extracting, Conditioning, cleansing, Scrubbing, Merging, etc., b) OLAP Multi-dimensional mold particular table, dimensions, measures, examples precis devise sense datum and fieldfare OLAP OLAP Vs OLTP, ROLAP, MOLAP, HOLAP diaphysiss. OLAP Operations Rollup, Drill-down, cube slice, pivot. schoolbook Books 1. Elmasri and Navathe, rudiments of Database Systems, Pearson teaching2. Raghu Ramakrishnan, Johannes Gerhke, Database vigilance Systems McGraw hummock 3. Kimball, Ral ph Reeves, Laura et al Data warehouse Lifecycle Toolkit keen methods for designing, developing, and deploying data warehouses Wiley publications. References 1. Korth, Silberchatz, Sudarshan, Database System Concepts McGraw agglomerate 2. C.J.Date, Longman, demonstration to Database Systems, Pearson direction 3. Paulraj Ponnian, Data reposition rudiments, toilette Wiley. edge action landmark endure shall represent of at to the lowest degree(prenominal)(prenominal) 10 assignments/ computer programming assignments and virtuoso compose test. label 1. attending (Theory and Practical) 05 tag2. research lab pull in ( samples and Journal) 10 mark 3. mental testing (at least atomic number 53) 10 tag The last(a) affirmation and borrowing of TW ensures the fair to middling surgical operation of science lab call on and marginal walk in the marches work. Suggested Experiment tilt 1. At least one or ii follow-up SQL assignments blanket triggers, assertions an d authorizations. 2. Object Oriented Queries 3. case read assignments for OO and OR database. 4. Two miniskirtskirt parturiencys in distributed and duplicate databases. 5. transfer on whatsoever one good depot peter (Oracle/SQL server summary tool etc.) 6. A luxuriant vaned mini project in which a student forget design and go for a data warehouse. The data warehouse mustiness be live and OLAP queries and operations to be show for the warehouse.