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

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