Tech Differences

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...]

JDBC and ODBC, both are the API (Application Programming Interface) that help the applications on the client side to access the database on the server side. The RDBMS vendors provide ODBC or JDBC drivers so that their database can be accessed by the applications on client side. The point that fundamentally differentiates JDBC and ODBC is that JDBC is language dependent and it is Java specific whereas, the ODBC is a language independent. Let us see in how many aspects the does JDBC and ODBC … [Read more...]

Keys are the attribute, or a set of attributes that are used to access tuples from a table or they are also used to construct a relationship between two tables. In this article, we are going to discuss Primary and Candidate Key and the differences between them. Both Primary and Candidate Key uniquely identifies a tuple in a relation or table. But, the most important point that differentiates them is that there can be only one primary key in a relation. However, there can be more than one … [Read more...]

SQL is a standard that has been adopted by ANSI in 1986. It has been used as a base by many RDBMS (relational database management system) vendors. Both T_SQL and PL-SQL are relational database management system and are an extension to the Structured Query Language. The difference that separates T-SQL from PL-SQL is their proprietary. T-SQL is a Microsoft product whereas, the PL-SQL is a product of Oracle. In this article, I have tried to explain some more differences between T-SQL and PL-SQL … [Read more...]

COMMIT and ROLLBACK, are the two transactional statements that are used to, do or undo the transactions. A transaction can have a sequence of queries, or it may have the update statements that modifies the database. The fundamental difference between COMMIT and ROLLBACK lies in their working. If the transaction is successfully executed then, the COMMIT statement permits the modification made by the transaction in the database to become permanent. On the other hands, if the transaction due to … [Read more...]

DELETE and DROP are the commands used to remove the elements of the database. DELETE command is a Data Manipulation Language command whereas, DROP is a Data Definition Language Command. The point that distinguishes DELETE  and DROP command is that DELETE  is used to remove tuples from a table and DROP is used to remove entire schema, table, domain or constraints from the database. Let us discuss some more differences between DELETE  and DROP command in SQL with the help of comparison chart … [Read more...]

SQL allows to organize the data obtained by the query. We have two clauses for organizing the data obtained from the query that are Group By and Order By clause. The point that distinguishes Group By and Order By clause is that Group By clause is used when we want to apply the aggregate function to more than one set of tuples and Order By clause is used when we want to sort the data obtained by the query. Let us discuss some differences between Group By clause and Order By clause with the … [Read more...]

Inner Join and Outer Join both are the types of Join. Join compares and combines tuples from two relations or tables. Inner Join specifies the natural join i.e. if you write a Join clause without Inner keyword then it performs the natural join operation. The potential difference between Inner Join and Outer Join is that Inner Join returns only the matching tuples from both the table and the Outer Join returns all the tuples from both the compared tables. Let us discuss some other differences … [Read more...]