Skip to main content

DBMS Slides...

By

Chapter
Formats
Last Updated
1. Introduction
ppt, pdf
July 23, 2008
Part 1: Relational Databases
2. Relational Model
ppt, pdf
July 25, 2008
3. SQL
ppt, pdf
August 6, 2008
4. Advanced SQL
ppt, pdf
August 10, 2008
5. Other Relational Languages
ppt, pdf
September 2006
Part 2: Database Design
6. Database Design: The Entity-Relationship Approach
ppt, pdf
September 2006
7. Relational Database Design
ppt, pdf
October 2006
8. Application Design
ppt, pdf
August 9, 2005
Part 3: Object-Based Databases and XML
9. Object-Based Databases
ppt, pdf
September 20, 2005
10. XML
ppt, pdf
July, 2006
Part 4: Data Storage and Querying
11. Storage and File Structure
ppt, pdf
Aug 2006
12. Indexing and Hashing
ppt, pdf
Aug 2006
13. Query Processing
ppt, pdf
Aug 2006
14. Query Optimization
ppt, pdf
Aug 2006
Part 5: Transaction Management
15. Transactions
ppt, pdf
September 2006
16. Concurrency Control
ppt, pdf
October 5, 2006
17. Recovery System
ppt, pdf
October 5, 2006
Part 6: Data Mining and Analysis
18. Data Analysis and Mining
ppt, pdf
August 27, 2005
19. Information Retrieval
ppt, pdf
September 2, 2005
Part 7: System Architecture
20. Database System Architectures
ppt, pdf
October 5, 2006
21. Parallel Databases
ppt, pdf
August 22, 2005
22. Distributed Databases
ppt, pdf
August 22, 2005
Part 7: Other Topics
23. Advanced Application Development
ppt, pdf
Preliminary version
24. Advanced Data Types
ppt, pdf
Preliminary version
25. Advanced Transaction Processing
ppt, pdf
Preliminary version
Part 8: Case Studies
26. PostgreSQL
ppt, pdf
Not available
27. Oracle
ppt, pdf
Not available
28. IBM DB2 Universal Database
ppt, pdf
Not available
29. Microsoft SQL Server
ppt, pdf
Not available
Appendices
A. Network Model
ppt, pdf
August 23, 2005
B. Hierarchical Model
ppt, pdf
August 23, 2005
C. Advanced Relational Database Design
ppt, pdf
August 23, 2005



Comments

Post a Comment

Popular posts from this blog

AngularJs call one method of controller in another controller .

By Upendra
I have seen many question about calling one method of one controller in another controller or extending scope of one controller in another controller.so here are the ways. if you want to call one controller into another or extending scope of controllers there are four methods available $rootScope.$emit() and $rootScope.$broadcast() If Second controller is child ,you can use Parent child communication . Use Services Kind of hack - with the help of angular.element() 1. $rootScope.$emit() and $rootScope.$broadcast() Controller and its scope can get destroyed, but the $rootScope remains across the application, that's why we are taking $rootScope because $rootScope is parent of all scopes . If you are performing communication from parent to child and even child wants to communicate with its siblings, you can use $broadcast If you are performing communication from child to parent ,no siblings invovled then you can use $rootScope.$emit HTML <body ng-app = ...
7 comments
Read more

Closures in javascript and how do they work ?

By Upendra
JavaScript Closures for Dummies  Closures Are Not Magic This page explains closures so that a programmer can understand them — using working JavaScript code. It is not for gurus or functional programmers. Closures are  not hard  to understand once the core concept is grokked. However, they are impossible to understand by reading any academic papers or academically oriented information about them! This article is intended for programmers with some programming experience in a mainstream language, and who can read the following JavaScript function: function sayHello ( name ) { var text = 'Hello ' + name ; var sayAlert = function () { alert ( text ); } sayAlert (); } An Example of a Closure Two one sentence summaries: a closure is the local variables for a function — kept alive  after  the function has returned, or a closure is a stack-frame which is  not deallocated  when the function returns (as if a 'stack-fr...
Post a Comment
Read more

Working with $scope.$emit , $scope.$broadcast and $scope.$on

By Upendra
First of all, parent-child scope relation does matter. You have two possibilities to emit some event: $broadcast  -- dispatches the event downwards to all child scopes, $emit  -- dispatches the event upwards through the scope hierarchy. If scope of  firstCtrl  is parent of the  secondCtrl  scope, your code should work by replacing  $emit  by  $broadcast  in  firstCtrl : function firstCtrl ( $scope ) { $scope . $broadcast ( 'someEvent' , [ 1 , 2 , 3 ]); } function secondCtrl ( $scope ) { $scope . $on ( 'someEvent' , function ( event , mass ) { console . log ( mass ); }); } In case there is no parent-child relation between your scopes you can inject  $rootScope  into the controller and broadcast the event to all child scopes (i.e. also  secondCtrl ). function firstCtrl ( $rootScope ) { $rootScope . $broadcast ( 'someEvent' , [ 1 , 2 , 3 ]); } Finally, when you need to ...
Post a Comment
Read more