The Database Management System (DBMS) is defined as a software system that allows the user to define, create and maintain the database and provide control access to the data.It is a collection of programs used for managing data and simultaneously it supports different types of users to create, manage, retrieve, update and store information.PurposeThe purpose of DBMS is to transform the following −Data into information.Information into knowledge.Knowledge to the action.The diagram given below explains the process as to how the transformation of data to information to knowledge to action happens respectively in the DBMS −Previously, the database applications were built ... Read More

A file system is a method of storing and organizing the computer files and the data they contain to make it easy to find and access them.Characteristics of file systemThe characteristics of file system are as follows −It is a group of files for storing the data of an organization.Each file is independent from one another.Each file is called a flat file.Files are designed by using the program written in programming languages such as C, C++.Disadvantages of file processing systemThere are so many disadvantages in the file processing system. These are explained below −Separated and isolated data.Duplication of data − ... Read More

Before understanding the difference between data and information, let’s have a look at the definitions of data and information with an example.DataData is the raw material that can be processed for any computing machine.For example − Employee name, Product name, Name of the student, Marks of the student, Mobile number, Image etc.InformationInformation is the data that has been converted into more useful or intelligent form.For example: Report card sheet.The information is needed for the following reasons −To gain knowledge about the surroundings.To keep the system up to date.To know about the rules and regulations of the society.KnowledgeThe human mind purposefully ... Read More

Let’s discuss flat and database definition before understanding the difference between flat files and databases.Flat filesA flat file contains records which have no structured interrelationship. They are typically called as a text file, where all word processing, structure characters and markup have been removed. A flat file represents a table with a single record per line. Generally, it is a type of database that stores data in a plain text format.DatabaseThe related information when placed in an organized form that makes a database or an organized collection of related information is called a database.For example − Dictionary, Telephone directory etc.DifferencesFollowing ... Read More

In this post, we will understand the difference between ROLAP and MOLAP.ROLAPIt stands for Relational Online Analytical Processing.It is used for large volumes of data.The access time in ROLAP is slow.It stores data in the form of relation tables.The data in ROLAP is fetched from a data warehouse.It uses complex SQL queries.A static multidimensional view of the data is created in ROLAP.MOLAPIt stands for Multidimensional Online Analytical Processing.It is used for less/limited volumes of data.The access time is quick in MOLAP.Data is stored in a multidimensional array.Data is fetched from the MDDBs database.A sparse matrix is used in MOLAP.Dynamic multidimensional ... Read More

In this post, we will understand the difference between WHERE clause and HAVING clause in SQL.WHERE ClauseIt is used to filter the records from the table based on a specific condition.It can be used without the ‘GROUP BY’ clause.It can be used with row operations.It can’t contain the aggregate functions.It can be used with the ‘SELECT’, ‘UPDATE’, and ‘DELETE’ statements.It is used before the ‘GROUP BY’ clause if required.It is used with a single row function such as ‘UPPER’, ‘LOWER’.HAVING ClauseIt is used to filter out records from the groups based on a specific condition.It can’t be used without the ... Read More

In this post, we will understand the difference between T-SQL and PL-SQL.T-SQLIt is a Microsoft product.It is known as Transact Structure Query language.It gives a high degree of control to the developers/programmers.It works its best, and provides good performance with Microsoft SQL server.It is easy.It is simple to understand.It allows the insertion of multiple rows into a table.This is done with the help of the ‘BULK INSERT’ statement.The ‘SELECT INTO’ statement is used in T-SQLIn this, the ‘NOT EXISTS’ clause can be used with the ‘SELECT’ statements.PL-SQLIt is an Oracle product.It is known as Procedural Language Structural Query Language.It is ... Read More

In this post, we will understand the difference between COMMIT and ROLLBACK in SQL.COMMITIt validates the modifications that are made by the current transaction.Once the COMMIT statement has been executed, the transaction can’t be rolled back using ROLLBACK.It occurs when the transaction is successfully executed.SyntaxCOMMIT;ROLLBACKIt removes the modifications that were made by the current transaction.Once ROLLBACK is executed, the database would reach its previous state.This is the state where the first statement of the transaction would be in execution.ROLLBACK happens when the transaction is aborted in between its execution.SyntaxROLLBACK;

Problem: How will the COBOL-DB2 program behave when there is a mismatch between the host variable and number of columns in the SELECT statement?SolutionIn case there is a mismatch in the number of columns and number of host variables, the query will fail. For example, if we have used the below query in a COBOL-DB2 program which processes the ORDERS DB2 table.ExampleEXEC SQL    SELECT ORDER_ID,       ORDER_AMOUNT,       ORDER_DATE,       ORDER_STATUS    INTO :WS-ORDER-ID,       :WS-ORDER-AMOUNT,       :WS-ORDER-DATE,    FROM ORDERS WHERE ORDER_DATE = ‘2020-09-15’ END-EXECThere is a mismatch ... Read More

Problem: What is the purpose of the "FOR UPDATE OF" clause in a cursor? What will happen if we fire an UPDATE statement without using this clause in a COBOL-DB2 program?SolutionThe “FOR UPDATE OF” clause is given in the cursor declaration and it is used when we want to update the table. All the columns which need to be updated should be given in the cursor declaration.The “FOR UPDATE OF” clause will place the exclusive lock on all the qualifying rows once the cursor is open. We can also update the table without using “FOR UPDATE CLAUSE” but in that ... Read More