Categories for Database Management System

Constraints of E-R Modeling

September 17, 2016

An E-R enterprise schema may define certain constraints to which the contents of a database system must conform. Mapping Cardinalities... View Article

Data Models

September 17, 2016

Entity relationship model Keywords: Entity, Relationship, Attributes Advantages: Easy to develop, Mapping cardinalities, primary key, generalization and specialization Disadvantages: not... View Article

Database Administrator

September 17, 2016

A person who has central control over the system is called a Database Administrator (DBA). The functions of DBA include:... View Article

Database Languages

September 17, 2016

A database system provides a data definition language to specify the database schema and a data manipulation language to express... View Article

Views of Data

September 17, 2016

A major purpose of DBMS is to provide users with an abstract view of the data. There are 3 levels... View Article

Join Introduction [MySQL]

September 15, 2016

Joins tables Many forms: INNER JOIN (include only matching columns) OUTER JOIN (include all columns) LEFT OUTER JOIN NATURAL JOIN... View Article

NoSQL Performance Tuning

September 13, 2016

Source: OS Tuning : Try “tuned” – best when used in staging/load testing environment under realistic load. Storage Tuning... View Article