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 137 of 547
How to Deploy a Bare Metal Cloud Server?
Introduction When it comes to cloud computing, there are two primary options: virtualized servers and bare metal servers. A virtual server runs on top of a hypervisor, which is essentially a layer of software that sits between the physical hardware and the operating system. In contrast, a bare metal server runs directly on the physical hardware without any intervening layers. A bare metal cloud server combines the benefits of both models. It provides dedicated hardware resources like a traditional bare metal server, but it's provisioned and managed through an API or web interface like a virtual server in ...
Read MoreDifference between Kerberos and RADIUS
In this article, we will understand the concept of Kerberos and Radius and the difference between them. The three main components of Kerberos are the computer that contains the database, the ticket−granting server, and the authentication server. RADIUS does not store data in a specific format but rather talks with a central database. Kerberos is used to verify the identity of users and services before allowing them to access sensitive information. The verification methods used by the application layer protocols of Kerberos are ticket−based encryption methods. What is Kerberos? Kerberos comes under the application layer which is the topmost layer ...
Read MoreDifference between Long Polling and Websocket
Long Polling and WebSocket are both technologies used for real−time data transfer between a client and a server. They provide a way for the client to receive updates from the server in real−time, allowing for more interactive and responsive web applications. The main difference between them is that long polling sends the request to the client or receiver and waits until a response is received which means one−way communication. On the other hand, WebSockets are used to send the data in both directions simultaneously. What is Long Polling? In long polling, until it has information to send back to the ...
Read MoreDifference Between Dataset.from_tensors and Dataset.from_tensor_slices
Dataset.from_tensors and Dataset.from_tensor_slices are methods in the TensorFlow library that are used to create datasets. Dataset.from_tensor creates a dataset from a single tensor whereas Dataset.from_tensor_slices creates data set by slicing a tensor along the first dimension. In this article, we will understand the difference between the two methods and how they are used in different use cases. from_tensor from_tensor_slices Creates a dataset from a single tensor Creates a dataset by slicing a tensor along the first dimension Useful for small datasets that can fit in memory Useful for large datasets that ...
Read MoreDifference between Structured, Semi-structured and Unstructured data
Data plays a crucial role in understanding the business trends. Many organizations generate and process huge volumes of data. This huge and complex data is referred to as "Big Data". Big data is of three types: structured data, semi structured data, and unstructured data. What is Structured Data? Structured data is generally stored in tables in the form of rows and columns. Structured data in these tables can form relations with another tables. Humans and machines can easily retrieve information from structured data. This data is meaningful and is used to develop data models. Structured data is used by ...
Read MoreObject Identity, and Objects versus Literals
DBMS supports object-oriented data. It ensures direct correspondence between real-world objects and their representations in the database. This correspondence ensures that objects retain their integrity and identity. It enables easy identification and manipulation. Object Data Management System (ODMS) assigns unique identity to each independent object stored in the database. This unique identity is implemented through a system-generated object identifier (OID). This OID serves as distinct value assigned to each object by the system. It is not visible to external users. However it is internally utilized by the system to ensure the unique identification of each object and to establish and ...
Read MoreOffset-Fetch in MS SQL Server
Offset-Fetch is feature in MS SQL Server. It helps to retrieve subset of rows from result set. It consists of two components: OFFSET and FETCH. The OFFSET clause specifies the number of rows to skip from the beginning of the result set. FETCH clause determines the number of rows to retrieve. Syntax SELECT column1, column2, ... FROM table ORDER BY column OFFSET {integer_value} {ROWS | ROWS ONLY} FETCH {FIRST | NEXT} {integer_value} {ROWS | ROWS ONLY} ONLY; Explanation of Syntax SELECT column1, column2, ...: Specifies the columns to be selected from the table. FROM table Specifies the table from ...
Read MoreHow to Install and Configure MySQL on a Windows Server?
MySQL is a popular open-source database management system that is widely used by businesses, organizations, and developers. It is known for its reliability, scalability, and ease of use. If you are running a Windows Server, you may want to install and configure MySQL to store and manage your data efficiently. In this article, we will guide you through process of installing and configuring MySQL on a Windows Server. Step 1: Download MySQL Installer The first step in installing MySQL on a Windows Server is to download MySQL Installer from official MySQL website. installer is a graphical tool that makes it ...
Read MoreExploring The Underlying OS in A Google Cloud Database Managed Service
Introduction One of the main objectives of any company is to look after the advancement of their services. For instance, Google Cloud is a widely known cloud service provider, and its services include SQL server engine, MYSQL, and PostgreSQL. Databases take too long to complete tasks such as patching OS systems. With the help of Google Databases, the backup configuration is also possible with the additional benefit of having security. It helps new businesses to build their product as per the business requirements. One of the most common queries a cloud database service provider gets is the ...
Read MoreHow to Import and Export MySQL Databases in Linux
If you are a Linux user and you work with MySQL databases, you might need to import or export databases from time to time. Importing a database means copying data from an external source into a MySQL database, while exporting means copying data from a MySQL database to an external source. This article will show you how to import and export MySQL databases in Linux using several different methods. Introduction to MySQL MySQL is a popular open-source relational database management system that uses SQL (Structured Query Language) to manage databases. It is widely used in web applications and is often ...
Read More