DBMS | Future Works in Geographic Information System
In the past ten years, there is a rapid increase in the development of GIS field. Due to this growing interest, new applications will continue… Read More »
Category Archives: DBMS
DBMS | Data Management issues in Mobile database
Data management technology that can support easy data access from and to mobile devices is among the main concerns in mobile information systems. Mobile computing… Read More »
Difficulties of Implementing Data Warehouses
Prerequisites – Data Warehousing, Data Warehouse Architecture, Characteristics and Functions of Data warehouse Here are some of the difficulties of Implementing Data Warehouses: Implementing a… Read More »
DBMS | Data Marts
Datawarehouse and Data Mart, both are storage components of HDFS. Data mart is such a storage component which is concerned on a specific department of… Read More »
Difference between Structured, Semi-structured and Unstructured data
Big Data includes huge valume, high velocity, and extensible variaty of data. These are 3 types: Structured data, Semi-structured data, and Unstructured data. Structured data… Read More »
Use of DBMS in System Software
Here we are going to discuss about how a user interacts with a DBMS, and how the DBMS is related to system software. Using a… Read More »
Data Warehouse Architecture
A data-warehouse is a heterogeneous collection of different data sources organised under a unified schema. There are 2 approaches for constructing data-warehouse: Top-down approach and… Read More »
Difference between SQL and NoSQL
Prerequisites – SQL, NoSQL When it comes to choosing a database the biggest decisions is picking a relational (SQL) or non-relational (NoSQL) data structure. While… Read More »
The Problem of redundancy in Database
Redundancy means having multiple copies of same data in the database. This problem arises when a database is not normalized. Suppose a table of student… Read More »
SQL | Triggers
Trigger is a statement that a system executes automatically when there is any modification to the database. In a trigger, we first specify when the… Read More »
Apache HBase
Prerequisite – Introduction to Hadoop HBase is a data model that is similar to Google’s big table. It is an open source, distributed database developed… Read More »
Difference between Where and Group By
Prerequisite – WHERE Clause, GROUP BY, Having vs Where Clause Where and Gropb By clauses are used to filter rows returned by the query based… Read More »
Characteristics and Functions of Data warehouse
Prerequisite – Data Warehousing Data warehouse can be controlled when the user has a shared way of explaining the trends that are introduced as specific… Read More »
Dimensional Data Modeling
Popular Schema – Star Schema, Snow Flake Schema Dimensional Data Modeling is one of the data modeling techniques used in data warehouse design. Goal: Improve… Read More »
DBMS | Network attached storage
With the phenomenal growth in digital data, particularly generated from multi-media and other enterprise application the need for high-performance storage solution at low cost has… Read More »
