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 147 of 547
Difference Between Cardinality and Modality
For understanding the information domain of a problem, there are two data modelling concepts, namely, cardinality and modality. Cardinality and modality are very important for analyzing the data objects, attributes, and relationship structures. The most basic difference between cardinality and modality is that the cardinality is a metric that specifies the number of occurrences of a data object with respect to the number of occurrences of another data object, whereas, the modality specifies whether a data object must participate in a relationship or not. In this article, we will discuss the important differences between cardinality and modality. Let's start with ...
Read MoreDifference between Business Continuity and Disaster Recovery
The world we now inhabit is not perfect. The news is constantly filled with stories of natural disasters like hurricanes, tornadoes, and tsunamis that wipe away entire towns and put a halt to human economic activity when they pass through our globe. Natural disasters have a devastating impact on business operations across the world, in addition to disrupting the lives of ordinary people. The need for organizations and service providers to prepare for the likelihood of disruptions to their operations and the services offered by technology has consequently increased dramatically. Having a number of different contingency plans available might ...
Read MoreDifference between Anonymity and Confidentiality
Humans go through different stages in their personal and professional lives during which they undergo situations or experiences after which privacy and information security becomes a vital requirement for them. For example, a person approaching someone from the medical profession would much appreciate his medical data remain protected from others so that he/she doesn’t face discrimination at home or work. Similarly, a company tasked with conducting surveys and running research activities is obliged to maintain strong anonymity and confidentiality measures in regard to their survey pool. In some sectors-- such as medicine, religion, and politics, to mention a ...
Read MoreDifference between Normalization and Denormalization
The process to alter the structure of a database is basically categorized into two ways, one is Normalization and the other is Denormalization. The basic difference between normalization and denormalization is that the database normalization removes the redundancy of data and anomalies in a poorly designed table, while denormalization combines multiple table data into one so that it can be queried quickly. Read through this article to find out more about normalization and denormalization and how they are different from each other. What is Normalization? Normalization is used to remove redundant data from the database and to store non-redundant and ...
Read MoreDifference between localhost and 127.0.0.1?
On almost every machine, the localhost and 127.0.0.1 are functionally the same. But, they are not exactly the same. This article is meant for explain the important differences between localhost and 127.0.01. What is Localhost? "localhost" is the machine name or IP address of the host server. You can think of it as the domain name for "127.0.0.1". The localhost allows a network connection to loop back on itself. It is a communication port that is connected to the local server. It helps us in spoofing the network connections when such a network does not exist. We tend to use ...
Read MoreDifference between GDPR and Privacy Shield
Online information is vulnerable to third parties' abuse, such as identity theft, fraud, and phishing schemes. The internet has provided countless new avenues for commerce and communication, but it has also made it simpler for identity thieves to target their victims. Thus, it is important to protect the sensitive data that many businesses, nonprofits, and governments have on file, such as loyalty program information, customer data, data collection, transaction details, and employee information. Several rules and regulations, like the General Data Protection Regulation and the Privacy Shield, have been adopted in various regions of the world to ensure this is ...
Read MoreDifference between Centralized Data Storage and Distributed Data Storage
The capacity to retain data is rapidly emerging as one of the most crucial features of contemporary business, government, and even personal life. Most successful companies have data storage systems that are properly organized, secure, and easy to access when necessary. Accounting records, policy documents, and human resources information, to mention a few examples, must be kept in a safe system that provides security against data loss and theft and has a reliable recovery method in place. Saving space and money through effective data storage is preferable to maintaining data in files or on a computer. Centralized data storage ...
Read MoreHow to customize the Result of JPA Queries with Aggregation Functions?
Most of the time when we use JPA queries, the result obtained is mapped to an object/particular data type. But When we use aggregate function in queries, handling the result sometimes require us to customize our JPA query. Let’s understand this with help of an example (Department, Employee) − Dept.java @Entity public class Dept { @Id private Long id; private String name; @OneToMany(mappedBy = "dep") private List emp; //Getters //Setters } A department can have one or more ...
Read MoreHow to connect hibernate with MySQL Database?
In this article, we will see how we can connect to MySQL database using an ORM (object relational mapping) framework like hibernate. First of all, we need to add maven dependency for hibernate in our pom.xml file − org.hibernate hibernate-core 5.6.2.Final Now, let us define an entity class that will be mapped to a database table using hibernate. @Entity @Table( name = " Employee") public class Employee { @Id @GeneratedValue(strategy = GenerationType.AUTO) Long id; @Column(name = ...
Read MoreHow does Hibernate Second Level Cache Works?
Caching helps to reduce database network call, for executing queries. First level cache is linked with a session. It is implemented implicitly. First level cache exist only till the session object is there. Once session object is terminated/closed, there will be no cache objects. Second level cache works across multiple sessions objects. It is linked with a session factory. Second level cache objects are available to all the session in a single session factory. These cache objects are terminated when that particular session factory is closed. Implementing second level caching We need to add the following dependencies in order to ...
Read More