ORDBMS

Duration: 17 min

This video lesson is available to enrolled students.

Return to /learn/COGNIZANT-PREPARATION/dbms/ordbms/ordbms-introduction/asset-ordbms after enrolling

Inside: a video lesson and guided study material.

Module outline

  1. Communication Round: Vocabulary, Subject Verb Agreement (Verb Noun Agreement), Tenses, Comprehension / Reading Comprehension / Unseen Passages (Critical Reasoning) (Paragraph Questions), Cloze Test (Cloze Passage), Sentence Correction (Error Correction), Sentence Completion (Fill in the blanks), Sentence Re-arrangements (Para Jumbles) (Narrative Sequencing), Direct and Indirect Speech, Active Passive Voice (Voice), Verbal Analogy (Word Based Analogy), Articles, Preposition, Conjunction, Sentence Construction, English Writing Ability, Communication Assessment
  2. Quantitative Aptitude: Ratio and Proportion (Ratios), Divisibility Rules, Data Interpretation, Mixture and Alligation, Permutation and Combination, Logarithm, Number System, HCF LCM, Speed Time and Distance, Percentage, Average, Powers and Exponents (Surds and Indices), Time and Work, Mensuration and Geometry, Age Problems, Pipe and Cistern, Probability, Profit and Loss, Simple Interest and Compound Interest, Algebra
  3. Analytical and Logical Reasoning: Series (Number and Letter Series) (Numerical Relations and Reasoning), Coding Decoding, Data Sufficiency, Non Verbal Reasoning (Spatial Aptitude) (Spatial Reasoning) (Visual Reasoning), Directions (Direction Test), Ranking, Order and Sequence, Deductive and Inductive Reasoning (Logical Deduction and Induction) (Prepositional Reasoning), Selection Decision Table (Decision Making), Logical Sequence Of Words, Puzzle Solving (Puzzles), Syllogisms, Seating Arrangements, Calendar, Clock, Blood Relations, Cubes & Dices, Venn Diagram, Analytical Reasoning (Counting Figures Reasoning)
  4. Cognizant Gaming Aptitude: Gamified / Game Based Aptitude
  5. Java (Cluster 1): Java
  6. ANSI SQL MySQL (Cluster 1,2,3): SQL
  7. HTML, CSS, JavaScript (Cluster 1,3): HTML, CSS, JavaScript
  8. Python (Cluster 2): Python for Placements by Yash Sir
  9. Cloud Fundamentals (Cluster 2): Emerging Tech Trends
  10. C# (Cluster 3): C#
  11. OOPs: Object Oriented Programming (OOPS)
  12. Technical Assessment (Coding): Coding Questions by Yash Sir, C Programming by Yash Sir, Programming in C++, Pseudo Codes
  13. Data Structures: Introduction to DS, Array, Stack, Queue, Linked List, Tree, Graphs, Hashing
  14. DBMS: Basics of DBMS, ER Diagram, Relational Model & Functional Dependencies, Keys & Integrity Constraints, Normalization (1NF - BCNF), Decomposition Properties & 4NF, File Organization & Indexing, Relational Algebra, Relational Calculus, Transaction Management, Concurrency Control, Database Recovery, ORDBMS, Database Security & Authorization, Query Processing & Optimization, Enhanced Data Models, Data Warehousing & Mining, Big Data Systems, NoSQL
  15. Operating Systems: Introduction to OS, Process Management, CPU Scheduling, Process Synchronization, Deadlock, Threads & Process Creation, Memory Management, Virtual Memory, Disc Scheduling, File Management, Windows OS, Linux OS, Security, Distributed Systems, Virtual Machines
  16. Computer Networks: Introduction to CN, Data Communication, DLL: Access Control, DLL: Flow Control, DLL: Error Control, DLL: Framing, Data Link Layer - Ethernet, Net Layer: IPv4 & Proto, Net Layer: IP Addressing, Net Layer:Routing Protocol, Transport Layer Services, TL: Congestion & UDP, Application Layer, Hardware basics, Network Security, Mobile Technology, Cloud Computing and IoT, Cyber and Info Security
AI summary & chapters

AI Summary

An AI-generated summary of this video lecture.

The video provides a comprehensive lecture on Object-Relational Database Management Systems (ORDBMS). It begins by defining ORDBMS as an extension of conventional Relational Database Management Systems (RDBMS) that incorporates object-oriented features such as objects, classes, and inheritance. The lecture explains that while applications interface with the database using an object-oriented model, the underlying data is stored as rows and columns in a relational database, requiring a conversion process. The presentation then lists several advantages of ORDBMS, including enhanced modeling capabilities, extensibility, removal of impedance mismatch, and support for complex data types. A key diagram illustrates that ORDBMS is a hybrid model combining RDBMS concepts like transaction management and OOP concepts like encapsulation and inheritance. The video also covers the reasons for using ORDBMS over RDBMS, such as handling new data types like engineering designs and scientific experiments, and the reusability of objects. Finally, it discusses the advantages and disadvantages of ORDBMS, highlighting benefits like improved concurrency and scalability, while noting drawbacks such as increased complexity and cost.

Chapters

  1. 0:00 – 2:00 00:00-02:00

    The video opens with a slide titled 'Object Relational DBMS (ORDBMS)'. The instructor explains that an ORDBMS is an extension of a conventional RDBMS, adding new functionalities for storing and manipulating data in the form of objects. The text on the slide defines an object-relational database (ORD) as a database management system similar to a relational database but with direct support for objects, classes, and inheritance in its schemas and query language. It also describes how applications interface with the database using an object-oriented model, but the data is stored as rows and columns, requiring conversion. The slide lists IBM, Informix, and Oracle as examples of ORDBMSs.

  2. 2:00 – 5:00 02:00-05:00

    The video transitions to a slide titled 'Advantages of Object Oriented DBMSs (OODBMS)'. The instructor lists several benefits, including enhanced modeling capabilities, extensibility, removal of impedance mismatch, expressive power, support for schema evolution, support for long-duration transactions, applicability to advanced database applications, improved performance, and reusability. The instructor uses red ink to write 'Object' next to 'Enhanced modeling capabilities' and 'extensibility', and 'impedance mismatch' next to 'Removal of impedance mismatch', emphasizing these key concepts.

  3. 5:00 – 10:00 05:00-10:00

    The video returns to the 'Object Relational DBMS (ORDBMS)' slide. The instructor elaborates on the concept, writing 'Object' and 'classes' and 'inheritance' in red ink to highlight the object-oriented features. The instructor also writes 'RDBMS' and 'table' to reinforce the underlying relational structure. The slide text explains that the system converts object information into data tables for storage and reassembles simple data into complex objects upon retrieval, which is the core of the object-relational mapping.

  4. 10:00 – 15:00 10:00-15:00

    The video presents a slide that explains the combination of relational and object-oriented models. It states that combining the features of the relational model (transaction, concurrency, recovery) with object-oriented features (associative queries) results in an Object-Oriented Relational Database Management System (OORDBMS). A diagram shows two boxes: 'RDBMS Concepts' (e.g., secondary storage management, transaction management) and 'OOP Concepts' (e.g., complex objects, encapsulation, inheritance), which are added together to form 'ORDBMS'. The instructor writes 'ORDBMS' in red above the diagram.

  5. 15:00 – 17:18 15:00-17:18

    The video shows a slide titled 'Reasons for using ORDBMS over RDBMS'. It lists reasons such as handling storage requirements for newer applications (e.g., engineering designs, scientific experiments), handling data stored for newer applications, the ability to define user-defined data types, the reusability of objects, and database extensibility. The instructor writes 'AOT' (Application Object Technology) and 'GIS' (Geographic Information Systems) in red. The next slide, 'Advantages of ORDBMSs', lists benefits like being reusable and sharable, supporting large storage capacity, and scalability. The final slide, 'Disadvantages of ORDBMSs', lists complexity, increased cost, and the uncertainty of correctly mirroring the 'real world'.

The lecture systematically builds an understanding of ORDBMS by first defining it as a hybrid system that merges the strengths of RDBMS and OOP. It uses a clear diagram to illustrate this combination, showing how RDBMS concepts like transaction management are integrated with OOP concepts like inheritance and encapsulation. The presentation then logically progresses to justify the use of ORDBMS by highlighting its advantages in handling modern data types and its extensibility, while also acknowledging its drawbacks like complexity and cost. This structured approach provides a comprehensive overview of the model's rationale, benefits, and limitations.

Loading lesson…