Tech Differences

Normalization is a method that removes redundancy from a relation thereby minimizing the insertion, deletion and update anomalies that degrade the performance of databases. In this article, we will differentiate among two higher normal forms i.e. 3NF and BCNF. The basic difference between 3NF and BCNF is that 3NF eliminates the transitive dependency from a relation and a table to be in BCNF, the trivial functional dependency X->Y in a relation must hold, only if X is the super key. Let … [Read more...]

Earlier we have discussed the differences between Inner Join and Outer Join, where we have overviewed the types of Outer Join. Outer Join is the one who preserves the tuples in the result which would have been lost while Join operation. In this article; we are going to discuss the differences between the types of Outer Join. There are three types of Outer Join; Left Outer Join, Right Outer Join, and Full Outer Join. The Left, Right, and Full Outer Join differs in their execution plan, and the … [Read more...]

Keys are the crucial part of DBMS they are used to identify and establish a relation between the tables in a schema. Now, today we are going to discuss two very important keys of DBMS i.e. Primary key and Foreign key, and we will also discuss the difference between primary key and foreign key. On the way let me tell you the basic difference between primary and foreign key which is primary key is one of the chosen candidate keys by database designer whereas, a foreign key is a key that refers … [Read more...]

The Fact Table and Dimension Table, are the essential factors to create a schema. A fact table's  record is a combination of attributes from different dimension tables. Fact table helps the user to analyze the business dimensions which helps him in decision taking to improve his business. On the other hands, dimension tables help fact table to collect dimensions along which the measures has to be taken. The point that distinguishes Fact table and Dimension table is that the dimension table … [Read more...]

DELETE and TRUNCATE are the commands use to remove tuples from a relation, but they differ in many contexts. In SQL, DELETE command is a Data Manipulation Language command whereas, TRUNCATE command is a  Data Definition Language command. However, the point that allows us to differentiate between DELETE and TRUNCATE is that DELETE is able to remove specified tuples from a relation, Whereas, the TRUNCATE command removes entire tuples from a relation. We should not stop here, there are many … [Read more...]

Data Mining and Data Warehousing both are used to holds business intelligence and enable decision making. But both, data mining and data warehousing have different aspects of operating on an enterprise's data. On the one hand, the data warehouse is an environment where the data of an enterprise is gathering and stored in a aggregated and summarized manner. On the other hands, data mining is a process; that apply algorithms to extract knowledge from the data that you even don't know exist in … [Read more...]

Database is a common term in today's life. Many enterprises, firms, organisation, institutes, etc. requires a database to store their data in a well-formatted form so that it would be easy to retrieve useful information out of it. While designing a database, schema is specified that describes the structural view of a database which confirms the tables that would be involved in creating a database, the attributes for the table and their association. Schema has to to be specified during the … [Read more...]

Many people are confused between the concept of Data and Metadata. Though both are the form of data, they have their different use and different specifications. Where a Data can simply be a piece of information, a list of measurements, or observations, a story or a description of a certain thing. Metadata specifies the relevant information about the data which helps in identifying the nature and feature of the data. Though there are not many differences between data and metadata, but in this … [Read more...]

OLTP and OLAP both are the online processing systems. OLTP is a transactional processing while OLAP is an analytical processing system. OLTP is a system that manages transaction-oriented applications on the internet for example, ATM. OLAP is an online system that reports to multidimensional analytical queries like financial reporting, forecasting, etc. The basic difference between OLTP and OLAP is that OLTP is an online database modifying system, whereas, OLAP is an online database query … [Read more...]

Generalization and Specialization both the terms are more common in Object Oriented Technology, and they are also used in the Database with the same features. Generalization occurs when we ignore the differences and acknowledge the similarities between lower entities or child classes or relations (tables in DBMS) to form a higher entity. However, when we moved on to the specialization, it spilt a higher entity to form lower entities, then we discover the differences between those lower … [Read more...]