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
Data Storage Articles
Page 13 of 50
Difference between Hard Drive and Memory
Hard Drive and Memory are both used for the same purpose of storing data. For long-term data retention, we need to use the Hard Drive storage device. On the other hand, the memory storage device is used for short-term data retention. Hard Drive or HDD is slower than the memory but it stores more data. Memory or RAM (Random Access Memory) is faster as compared to the Hard Drive but data will be lost when the power supply is switched off. Read this article to find out more about Hard Drive and Memory and how they are different from each ...
Read MoreDifference between GoFlex and FreeAgent
GoFlex and FreeAgent are two models of external hard drives by Seagate. GoFlex has 2 terabytes of storage capacity, while FreeAgent has 1.5 terabytes. GoFlex is an older model, while FreeAgent is an entirely new edition. In GoFlex, you may add more adapters than in Free Agent. GoFlex is a family storage drive that is simple to use and plug and play. It is connected to cables to provide speed and performance; presently, it is also kept in the interface based on customer multimedia streaming and personal libraries. Go Flex hard disc drive (HDD) may be turned into a ...
Read MoreDifference between Cache and Buffer
Cache and Buffer are types data storage layers that are used to store the data temporarily. A buffer is an area of main memory that stores data during input and output data transfers. When moving data between processes on a computer, a buffer is useful. Cache memory is used to reduce memory access time and increase computer speed. Read this article to find out more about Cache and Buffer and how they are different from each other. What is Cache? Cache memory temporarily stores information, data, and programmes that the CPU frequently uses. When data is needed, the CPU will automatically ...
Read MoreDifference between Row oriented and column oriented database
There are two ways of organizing data in a DBMS − one is row-oriented database and another is column-oriented database. The basic difference between the two is that a row-oriented database stores the data tables by rows, whereas a column-oriented database stores the data tables by columns. Read this article to learn more about row-oriented database and column-oriented database and how they are different from each other. What is Row-Oriented Database? A Roworiented database is a traditional database like Oracle, MySQL, etc. It stores data tables by rows and the common method of storing a table is to serialize each ...
Read MoreHow Can Hackers Destroy Cloud Server Databases?
Cloud server databases are the most important parts of a cloud network. It carries around all the data regarding any sensitive information, login credentials and workflow of the cloud. These server databases are the data storage systems that are hosted on remote services. To access the data from anywhere on the earth, officials constantly organise and maintain these databases. Hence their security is a very big vulnerable feature, and to maintain their integrity, cloud databases must have high security. But still, some hackers manage to steal information or else destroy cloud server databases. What Is Information Stored in Cloud Server ...
Read MoreDNS Resource Records
Overview DNS records (short for "Domain Name System records") are types of data that are stored in the DNS database and used to specify information about a domain, such as its IP address and the servers that handle its email. There are several different types of DNS records, including A records, MX records, CNAME records, and others, each with its own specific purpose. A record (short for "address record") maps a domain or subdomain to an IP address. For example, the domain "example.com" might have an A record that maps it to the IP address "192.0.2.1". When someone types "example.com" ...
Read MoreDomain Resource Records
Domain Resource Records (DNS records) are entries in the Domain Name System (DNS) that specify the location of a server, the mail server responsible for a domain, or other information about a domain. There are several types of DNS records, including − A records − A records map a domain name to an IP address. CNAME records − CNAME records allow you to specify an alias for a domain name. MX records − MX records specify the mail server responsible for a domain. NS records − NS records specify the name servers for a domain. TXT records − TXT ...
Read MoreStrategies For Migrating From SQL to NoSQL Database?
Introduction Migrating from a SQL to a NoSQL database is a significant undertaking that requires careful planning and strategizing. It's important to understand the differences between these two types of databases and to identify the specific use cases for which you will be using the NoSQL database. There are several different tools and techniques available for migrating data from a SQL to a NoSQL database, and it's important to carefully evaluate the pros and cons of each option to determine the best fit for your needs. Migrating from a SQL to a NoSQL database can be a significant undertaking and ...
Read MoreSQL Server Query to Find All Permissions/Access for All Users in a Database
Introduction In SQL Server, permissions are used to control access to database objects, such as tables and views. Each user in a database has a set of permissions that determine what they are able to do within the database, such as SELECT, INSERT, UPDATE, DELETE, and EXECUTE. To view the permissions that a user has been granted in a database, you can use the sys.database_permissions view. This view provides information about the permissions that have been granted or denied on database-level securables for a specific database. The sys.objects view contains information about all the objects in a database, and the ...
Read MoreSQL Query to Demonstrate Deletion Anomaly in Referential Integrity in a Table
Introduction A SQL query is a request for data from a database. In the context of demonstrating a deletion anomaly in a table with referential integrity, a SQL query would be used to delete a record from the parent table and observe the impact on the related records in the child table. To demonstrate a deletion anomaly, we can create two tables with a foreign key constraint, insert some sample data, and then use a `DELETE` statement to delete a record from the parent table. We can then use a `SELECT` statement to retrieve the data from the child table ...
Read More