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
Database Articles
Page 144 of 547
B*-Trees implementation in C++
B*-Trees: An Optimized Data Structure for Fast Data Retrieval in C++ A B*-tree is a self-balancing tree data structure that is optimized for fast data retrieval. It is a variant of the B-tree, which is a tree data structure that is designed to keep its data sorted and balanced. A B-tree is characterized by the fact that it has a high degree of order, meaning that its nodes are kept sorted in a specific manner. A B*-tree is similar to a B-tree, but it is optimized for even better performance. This is achieved through the use of a number of ...
Read MoreCatalog Information Used in Cost Functions
Introduction When it comes to creating cost functions, catalog information is a crucial piece of data that can be used to optimize the performance of a model. In this article, we will explore how catalog information can be used in cost functions, the different types of catalog information available, and how to implement this in your code. What is Catalog Information? Catalog information refers to data that describes the products or items that are being sold by a company. This information can include things like product names, descriptions, pricing, and images. This data is often stored in a database and ...
Read MoreCAST function in Cassandra
Introduction to the CAST Function in Cassandra Cassandra is a highly scalable and distributed NoSQL database that is well-suited for storing and managing large amounts of data. One of the key features of Cassandra is its powerful query language, CQL (Cassandra Query Language), which allows you to easily retrieve and manipulate data stored in Cassandra. One useful function in CQL is the CAST function, which allows you to change the data type of a column or expression. This function is particularly useful when you need to perform calculations or comparisons on data that have different data types. In this article, ...
Read MoreCascadeless in DBMS
Cascadeless in DBMS: Understanding and Implementing the Concept A database management system (DBMS) is a software that is used to store, organize, and manage data in a structured manner. One of the key concepts in DBMS is cascading, which refers to the automatic propagation of changes made to the data in one table to the related data in other tables. While cascading can be convenient in many cases, it can also lead to unintended consequences, such as data loss. To mitigate this, many DBMSs allow for the use of cascadeless operations, which prevent cascading from taking place. In this article, ...
Read MoreCalculation of Serial and Non-Serial Schedules in DBMS
Introduction In a database management system (DBMS), the scheduler is responsible for managing the execution of concurrent transactions. The scheduler uses a schedule, which is a sequence of actions that the DBMS must execute, to ensure that the system remains in a consistent state and that concurrent transactions do not interfere with each other. There are two types of schedules: serial schedules and non-serial schedules. In this article, we will discuss the calculation of both types of schedules in a DBMS. Serial Schedules A serial schedule is a schedule in which all transactions are executed one after another, without any ...
Read MoreDifference between Fundamental data types and derived Data Types
In computer programming, a datatype represents the type and nature of data that is to be used by the user. It is the data type that tells the compiler or interpreter how to deal with the data and provide corresponding storing location in computer memory. According to the nature of data, the data types can be of two types namely Fundamental Datatype and Derived Datatype. Both these datatypes are extensively used in computer programming. They are equally important when we require to implement the business logic over the data. Read this tutorial to find out more about Fundamental and Derived ...
Read MoreDifference between Data Warehouse and Operational Database
A data warehouse is a repository for structured, filtered data that has already been processed for a specific purpose. It collects the data from multiple sources and transforms the data using ETL process, then loads it to the Data Warehouse for business purpose. An operational database, on the other hand, is a database where the data changes frequently. They are mainly designed for high volume of data transaction. They are the source database for the data warehouse. Operational databases are used for recording online transactions and maintaining integrity in multi-access environments. Read this article to learn more about data warehouses ...
Read MoreDifference between Data Scientist, Data Engineer, Data Analyst
Data scientists, data engineers, and data analysts are all professionals who work with data in some way. However, they have different roles and responsibilities. Read this article to find out more the job profiles of data scientists, data engineers, and data analysts and how you can distinguish among them. Who is a Data Scientist? A Data Scientist is one who analyses and interprets complex data in digital form. Data scientists are responsible for extracting insights and knowledge from data. They use a variety of techniques, including machine learning, to analyze data and communicate their findings to stakeholders. There are several ...
Read MoreBulk Reading in Cassandra
Introduction Bulk reading is a common operation when working with Cassandra, a popular NoSQL database known for its scalability and high performance. It allows you to efficiently retrieve large amounts of data from a Cassandra cluster by making use of the database's distributed architecture. In this article, we'll explore the various ways you can perform bulk reading in Cassandra and the considerations you should keep in mind when doing so. What is Cassandra? Before diving into the specifics of bulk reading, let's first take a step back and talk about Cassandra itself. Cassandra is a distributed database management system designed ...
Read MoreBuilding blocks of a Data Model
Introduction A data model is a blueprint that represents the organization of data and the relationships between different data entities. It is an essential component of any software system as it defines how data is stored, accessed, and modified. In this article, we will explore the building blocks of a data model and how they work together to form a cohesive whole. Data Entities The first building block of a data model is data entities, which represent the objects or concepts that are relevant to the system. For example, in an e-commerce system, data entities might include products, customers, orders, ...
Read More