Article Categories
- All Categories
-
Data Structure
-
Networking
-
RDBMS
-
Operating System
-
Java
-
MS Excel
-
iOS
-
HTML
-
CSS
-
Android
-
Python
-
C Programming
-
C++
-
C#
-
MongoDB
-
MySQL
-
Javascript
-
PHP
-
Economics & Finance
Articles on Trending Technologies
Technical articles with clear explanations and examples
Conceptual Database Design
Conceptual database design is the process of identifying the essential data elements, relationships, and constraints in a data model, which represents a particular organization's business requirements. The conceptual design stage is the first step in the database design process, which precedes the logical and physical design stages. In this article, we will discuss the conceptual database design, its objectives, its process, and the key components of a conceptual data model. Objectives of Conceptual Database Design The primary objective of conceptual database design is to create a high-level data model that reflects the business requirements and provides a clear understanding ...
Read MoreConcurrent execution and its problems
Several transactions can be carried out simultaneously in a shared database when using a database management system (DBMS). Concurrent execution can provide a number of benefits, including increased system capacity and quicker reaction times. To ensure accurate and dependable database functioning, there may be a number of issues that need to be resolved. We shall talk about concurrent execution in DBMSs and its issues in this post. Concurrent execution in a DBMS refers to the capacity to carry out numerous transactions simultaneously in a shared database. A collection of database activities known as a transaction, such as inserting, updating, or ...
Read MoreParallelism in Query in DBMS
Introduction Are you struggling with slow query execution in your Database Management System (DBMS)? Actually, the fact is, parallelism in DBMS can significantly enhance the performance and speed of your queries. In this article, we'll unravel the concept of parallel query execution, its types - intraquery and interquery parallelism, their benefits and how they can be implemented to optimize your DBMS operations. Intrigued? Let’s dive into the world of efficient data processing! Types of Parallelism in Query Execution in DBMS There are two types of parallelism in query execution in DBMS: intraquery parallelism and interquery parallelism. Intraquery Parallelism Intraquery ...
Read MoreWhat is shared memory architecture in parallel databases?
In parallel database system data processing performance is improved by using multiple resources in parallel. In this CPU, disks are used parallel to enhance the processing performance. Operations like data loading and query processing are performed parallel. Centralized and client server database systems are not powerful enough to handle applications that need fast processing. Parallel database systems have great advantages for online transaction processing and decision support applications. Parallel processing divides a large task into multiple tasks and each task is performed concurrently on several nodes. This gives a larger task to complete more quickly. Architectural Models There are several ...
Read MoreWhat is shared nothing architecture in parallel databases?
In parallel database system data processing performance is improved by using multiple resources in parallel. In this CPU, disks are used parallel to enhance the processing performance. Operations like data loading and query processing are performed parallel. Centralized and client server database systems are not powerful enough to handle applications that need fast processing. Parallel database systems have great advantages for online transaction processing and decision support applications. Parallel processing divides a large task into multiple tasks and each task is performed concurrently on several nodes. This gives a larger task to complete more quickly. Architectural Models For Parallel Database ...
Read MoreDifference between Frontend and Backend Languages
Frontend and backend are the parts of web development. The processes done at the backend are not visible to the users. They only work on the frontend. There are many differences between the frontend and backend languages and development. In this article, we will look into the difference between frontend and backend languages. But before that, we should know in detail about frontend and backend. Frontend The frontend is the visual aspect of a website or a webpage which is also known as the client-side of an application. Users work on the frontend by working on different components like text ...
Read MoreDifference between Procedural and Functional Programming Languages
Procedural programming is a type of programming in which different functions or routines are created which consists of a sequence of instructions. Functional programming is used to organize the functions. Each function has to be set in such a way that they can perform the required task. We will discuss the difference between procedural programming languages and functional programming languages. Procedural Programming Languages Procedural programming languages have functions which you have to define. These functions need to have a set of instructions which should be executed when the function is called. You have to think about each instruction that you ...
Read MoreDifference between Interpreted and Compiled Languages
Programming languages can be interpreted or compiled. The compiled languages are not interpreted and there is no need to compile the interpreted languages. In this article, we will discuss the difference between compiled and interpreted languages. Compiled Programming Languages Compiled programming languages are the languages in which the code has to be compiled to convert it into machine language. This helps the processor execute the code and provide the result. C, C++, C#, Java, etc. are some of the languages which have to be compiled and then executed. What is Compile? Compile is a process which is used to convert ...
Read MoreJava Program for Binary Insertion Sort
Binary insertion sort uses the binary search to find the right position to insert an element at a specific index at every iteration. First, the location where the element needs to be inserted is found. Then, the elements are shifted to the next right location. Now, the specific element is placed in the position. Problem Statement Given an integer of array implement binary insertion sort using Java to sort it. The algorithm should use binary search to determine the correct position for each element and to maintain the sorted order it will shift elements accordingly. Steps for Binary Insertion ...
Read MoreJava program to double the size of an array
In this article, we will learn how to double the size of an array in Java. This involves creating a new array with twice the length of the original array and copying the elements from the original array to the new, larger array. Problem Statement Create an initial array with predefined integer values and determine its length. Then, create a new array with double the length of the original array, copy the elements from the original array to the new one, and print the lengths of both the original and the new arrays to verify the resizing operation. Steps to ...
Read More