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 141 of 547
Difference 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 MoreDifference Between RAID 0 and RAID 1
RAID or Redundant Array of Independent Disk is a set of disk organization techniques developed to increase the reliability and performance of a system. There are various types of RAID techniques such as RAID 0, RAID 1, RAID 2, … RAID 5. Read this article to learn more about RAID 0 and RAID 1 and how they are different from each other. What is RAID 0? RAID 0 stands for Redundant Array of Independent Disk level 0. There is no redundant data stored here, so performance is very good. But the failure of any disk in the array results in loss of data. In RAID 0, ...
Read MoreDifference between Mirroring and Replication
In database management systems (DBMS), there are two terms namely mirroring and replication which are related to copying of data. Mirroring is defined as the process of copying a database to another location, while replication is defined as the process of copying the database objects from one database to another. Read this article to learn more about mirroring and replication and how they are different from each other. What is Mirroring? Mirroring refers to keeping a backup database server for a master database server. If for some reason, the master database is down, then the mirror database can be used ...
Read MoreDifference between Fuzzification and Defuzzification
Fuzzification is the process of converting a crisp quantity into a fuzzy quantity. On the other hand, defuzzification is the process of translating a fuzzy quantity into a crisp quantity. Read this article to learn more about fuzzification and defuzzification and how they are different from each other. What is Fuzzification? Fuzzification may be defined as the process of transforming a crisp set to a fuzzy set or a fuzzy set to fuzzier set. Basically, this operation translates accurate crisp input values into linguistic variables. In a number of engineering applications, it is necessary to defuzzify the result or rather "fuzzy ...
Read MoreDifference Between Descriptive and Predictive Data Mining
Descriptive data mining and predictive data mining are mining techniques that are used to find useful information and patterns in large datasets. Descriptive data mining is a data mining technique that analyzes the past data to provide latest information on past events, while predictive data mining is a data mining technique that is used to analyze past data and provides answers of future queries. Read this this article to learn more about descriptive and predictive data mining techniques and how they are different from each other. What is Descriptive Data Mining? Descriptive data mining is a data mining technique that ...
Read MoreDifference Between DELETE and DROP in SQL
DELETE is a Data Manipulation Language (DML) command. It is used to remove tuples/records from a relation/table. On the other hand, DROP is a Data Definition Language (DDL) command and is used to remove named elements of schema like relations/table, constraints or entire schema. Read this article to learn more about DELETE and DROP commands in SQL and how they are different from each other. What is DELETE in SQL? In SQL, the DELETE command is used to remove some or all the records from a database table. With the DELETE command, the WHERE clause is used to define the ...
Read MoreDifference between Data lake and Data warehouse
Data Lake and Data Warehouse both are used for storing big data. A Data Lake is a very big storage repository which is used to store raw unstructured data, machine to machine, logs flowing through in real-time. The purpose of the stored data is not defined in a data lake. They are stored for future analysis of the data. A data warehouse is a repository for structured, filtered data that has already been processed for a specific purpose. A Data warehouse collects the data from multiple sources and transforms the data using ETL process, then loads it to the Data ...
Read MoreDifference Between Abstraction and Data Hiding
In object oriented programming (OOP), abstraction and data hiding are two important concepts. Abstraction is a process of extracting important information without involving the complete detail of the system. On the other hand, data hiding is a process of wrapping the data in a single unit, i.e., to achieve data encapsulation. Read this article to learn more about abstraction and data hiding and how these two concepts are different from each other. What is Abstraction? Abstraction, or data abstraction, is one of the object-oriented methodologies. Abstraction is defined as the process of hiding the internal implementation and keeping the complicated ...
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 MoreDifference between OVID and PubMed
These two are mostly used bibliographic databases. There are a few key differences between OVID and PubMed. For one, OVID offers a much more intuitive interface than PubMed. This is because OVID is designed specifically for clinical researchers, while PubMed is designed for general biomedical researchers. Another key difference is that OVID offers better search filters than PubMed. This is because OVID includes filters for things like publication type, date range, and subject area. This means that you can really narrow down your search results to find exactly what you're looking for. Finally, OVID also offers a "My Bibliography" feature, ...
Read More