Architecture of the Distributed Database System

Architecture of the Distributed database System, ANSI/SPARC Architecture, Reference Architecture for DDBMS, Dimensions of implementation, Issues with DDBMS, Fragmentation, Replication, Database Links, Oracle Replication, Types of Replication, Creating Snapshots.


Microsoft SQL Server Vs Oracle

Difference between Microsoft SQL Server and Oracle on the basis of language, transaction control, organization of database objects, platform dependency, locking and concurrency control, performance & tuning and other. – notes, knowledge, learn, teach, tutorial, request for notes, share, lessons, chapter, science, computer,tuition, online class

Welcome to

We’re so thankful for your interest in sharing your knowledge among others and are excited to tell you how much support we are getting through many other sources. By seeing the enthusiasm in people about, we are proud to say that people are very much excited to get a platform to share their knowledge among others who are actually in requirement of it.

We have tried initiating a noble way to share what we know and to request others to share what they know. It is a mutual way to let everyone learn and let everyone teach. Each and every knowsher is responsible to take care of other knowshers and provide the help what they required.

We’d love for you to become a member of the Knowledge Sharing team and become a knowsher: stay in touch and interact with us through our Facebook, spread the word about what we do and to know what your role as an individual knowsher is. If you’d like to learn more about how you can support us or if you have any query, please send us a message. We are so grateful to have you as a knowsher and we will seek for your support in near future.

We hope you will enjoy being an active knowsher and you will help other knowshers as well. To understand the details of how, when and what, please check FAQ.

Knowsh Team.

Architecture Of DDBMS

Architecture DDBMS, Dimensions of implementation, Issues with DDBMS, Fragmentation, Allocation, Replication, Optimization – Query Plan, Transparencies in a DDBMS, Date 12 Rules, Distributed Transaction Management.

Advanced SQL – Temporary Tables, Cursors, Creating and Using Stored Procedures, Designing and Using Triggers, Using SELECT Commands with UPDATE and DELETE, Embedded SQL, Programming with SQL

Temporary Tables, Cursors, Creating and Using Stored Procedures, Designing and Using Triggers, Using SELECT Commands with UPDATE and DELETE, Embedded SQL, Programming with SQL,-Cursors,-Creating-and-Using-Stored-Procedures,-Designing-and-Using-Triggers,-Using-SELECT-Commands-with-UPDATE-and-DELETE,-Embedded-SQL,-Programming-with-SQL

SQL Database Security – Database Administrator, Database Products and Security, Personal Oracle7 and Security, Using Synonyms in Place of Views, Using the WITH GRANT OPTION Clause

Database Administrator, Popular Database Products and Security, How Does a Database Become Secure?, Personal Oracle7 and Security, Creating Roles, User Privileges, User Access to Views, Using Views for Security Purposes, Using Synonyms in Place of Views, Using Views to Solve Security Problems, Using the WITH GRANT OPTION Clause.,-Database-Products-and-Security,-Personal-Oracle7-and-Security,-Using-Synonyms-in-Place-of-Views,-Using-the-WITH-GRANT-OPTION-Clause

SQL Server – Creating Views And Indexes

Using Views, A Simple View, Renaming Columns, SQL View Processing, Restrictions on Using SELECT, Modifying Data in a View, Problems with Modifying Data Using Views, Common Applications of Views, Views and Security, Using Views to Convert Units, Simplifying Complex Queries Using Views, The DROP VIEW Statement, Using Indexes, What Are Indexes?, Indexing Tips, Indexing on More than One Field, Using the UNIQUE Keyword with CREATE INDEX, Indexes and Joins, Using Clusters.,-View-Processing,-Security,-Indexes,-UNIQUE-Keyword,-Indexes-and-Joins,-Clusters

SQL Server – Creating and Maintaining Tables

Creating and Maintaining Tables, Objectives, The CREATE DATABASE Statement, CREATE DATABASE Options, Database Design, Creating a Data Dictionary, Creating Key Fields, The CREATE TABLE Statement, The Table Name, The Field Name, The Field’s Data Type, The NULL Value, Table Storage and Sizing, Creating a Table from an Existing Table, The ALTER TABLE Statement, The DROP TABLE Statement, The DROP DATABASE Statement.,-Create,-Alter-and-Drop-Tables,-Select,-Insert,-Update,-Delete-Commands