Database Management Systems

Module I - Slides

Data models - schemas and instances - Three-schema architecture and data independence - Database languages and interfaces - The database system environment - Centralized and client-server architectures - Classification of Database Management systems, Entity-Relationship Model - Entity Types, Entity Sets, Attributes and Keys - Relationship types, Relationship Sets, Roles and Structural Constraints - Weak Entity Types - Refining the ER Design - ER Diagrams and Naming Conventions - Example of Other Notation: UML Class Diagrams

Module II - Slides

Relational Model and Relational Algebra Relational Model Concepts - Constraints - Relational Database Schemas, Relational Algebra: Unary Operations - Set Theoretic operations - Binary Operations - Aggregate functions and grouping – Outer Join and Outer Union - Examples of Queries - The Tuple Relational Calculus - The Domain Relational Calculus.
SQL - Data Definition and Data Types - Specifying constraints - Schema change statements - Basic queries – Aggregate functions and grouping - Insert, Delete and Update statements - Assertions and Triggers - View
Database Design - Informal Design Guidelines for Relation Schemas - Functional Dependencies - Normal Forms Based on Primary Keys (Up to BCNF), Properties of Relational Decompositions - Algorithms for Relational Database Schema Design. The Database Design and Implementation Process - Use of UML Diagrams in database design.

Module III - Slides

Parallelizing Disk Access Using RAID Technology - New Storage Systems, Indexing Structures for Files - Types of Single-Level Ordered Indexes - Multilevel Indexes - Dynamic Multilevel Indexes Using B-Trees and B+ Trees - Indexes on Multiple Keys

Module IV - Slides

Transaction Management - Transaction and System Concepts – ACID Properties - Schedules - Characterizing Schedules Based on Recoverability and Serializability - Transaction Support in SQL
Concurrency Control Techniques - Locking Techniques - Timestamp Ordering - Multiversion Concurrency Control - Optimistic Concurrency Control - Using Locks for Concurrency Control in Indexes
Database Recovery Techniques - Recovery Concepts - Recovery Techniques Based on Deferred and Immediate Updates - Shadow Paging - Recovery in Multidatabase Systems - Backup and Recovery from Catastrophic Failures.

Trigger Example on Oracle

Question:
Calculate fine in a library management system using following condition.
For the first 3 days of delay 10 RS per day; for following 3 days 20 RS per day and after 6
days fine of 30 RS per day.

Click Here to Download 

Software Architecture and Project Management

Module I - Slides

Component-and-Connector Viewtype, Styles of Component-and-Connector Viewtype, Allocation Viewtype and Styles, Documenting Software Interfaces, Documenting Behavior, Building the Documentation Package, IS2000 The Advanced Imaging Solution, Global Analysis

Module II - Slides

Archetypes and Archetype Patterns, Model Driven Architecture with Archetype Patterns, Literate Modeling, Customer Relationship Management Archetype Pattern, Product Archetype Pattern, Quantity Archetype Pattern, Rule Archetype Pattern

Module IV - Slides

Module IV - Part 1.

Defining EAI, Data-Level EAI, Application Interface-Level EAI, Method- Level EAI, User Interface-Level EAI, The EAI Process, An Introduction to EAI and Middleware, Transactional Middleware and EAI, RPCs Messaging and EAI, Distributed Objects and EAI, Database Oriented Middleware and EAI, Java Middleware and EAI, Message Brokers—The Preferred EAI Engine, Process Automation and EAI, Implementing and Integrating Packaged Applications—The General Idea, XML and EAI

Module IV - Part 2.

Layering, Organizing Domain Logic & Domain Logic Patterns, Data Source Architectural Patterns, Object-Relational Behavioral Patterns, Object-Relational Behavioral Patterns, Mapping to Relational Databases, Object-Relational Metadata Mapping Patterns, Offline Concurrency Patterns

Set Operations in Java

Set Operations in Java: What is a Set Mathematically, a set is just a collection of objects, for example let set=["apple","orange","banan...

To Enable Append operations on Hadoop

    Open the file on the path  ${HADOOP_HOME}/conf/hdfs-site.xml
    copy the following code into the file between the <configuration> tag

  <property>
       <name>dfs.support.append</name>
       <value>true</value>
       <description>Does HDFS allow appends to files?
          This is currently set to false because there are bugs in the
          "append code" and is not supported in any prodction cluster.
       </description>
  </property>

[Ref: http://hadoop4mapreduce.blogspot.in/2012/08/two-methods-to-append-content-to-file.html ]

Linux Commands I Used

• cat /proc/cpuinfo
• cat /proc/meminfo
• du -b $(find -type f) // To list all files (including all sub directories) along with its size in bytes. Enter into the directory on which you need to run this and then type the command.

Google Password Update on android phones after password change through web.

Click on Play Store icon - this will bring up a prompt that says your password has changed.  When you change it on the market, it will change it for gmail as well...

Ref: http://productforums.google.com/forum/#!topic/gmail/jtnMOvWSOtY