Database Administrator
September 17, 2016A person who has central control over the system is called a Database Administrator (DBA). The functions of DBA include:... View Article
Tag Archive: Engineering
Database Languages
September 17, 2016A 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, 2016A major purpose of DBMS is to provide users with an abstract view of the data. There are 3 levels... View Article
Database Management System (DBMS)
September 17, 2016Introduction Database is a collection of data. It contains information about one particular enterprise. DBMS is a set of prewritten... View Article
Sparse Matrix (Introduction)
September 15, 2016A Sparse Matrix is a special type of matrix in which maximum number of Elements are “Zero Elements” or In... View Article
Algorithmic Problem Solving
September 15, 2016Understanding the problem Deciding on: Exact vs. approximate problem solving Appropriate data structure Design of algorithm Proving correctness Analyzing an... View Article
Introduction to Algorithm
September 15, 2016An algorithm is a sequence of unambiguous instructions for solving a computational problem, i.e., for obtaining a required output for... View Article
Join Introduction [MySQL]
September 15, 2016Joins 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, 2016Source: http://www.slideshare.net/ronwarshawsky/rw-nosql-2013presentatonv1 OS Tuning : Try “tuned” – best when used in staging/load testing environment under realistic load. Storage Tuning... View Article
ACID properties of transaction
September 13, 2016Source: sqlserverhelpdotcom Atomicity : Either all operations are executed or none of the operations are executed. Consistency : All the... View Article