Found 1719 Articles for Big Data Analytics

What is shared memory architecture in parallel databases?

Bhanu Priya
Updated on 08-Jul-2021 08:33:27

2K+ Views

In parallel database system data processing performance is improved by using multiple resources in parallel. In this CPU, disks are used parallel to enhance the processing performance.Operations like data loading and query processing are performed parallel. Centralized and client server database systems are not powerful enough to handle applications that need fast processing.Parallel database systems have great advantages for online transaction processing and decision support applications. Parallel processing divides a large task into multiple tasks and each task is performed concurrently on several nodes. This gives a larger task to complete more quickly.Architectural ModelsThere are several architectural models for parallel ... Read More

What is a parallel database and explain how it works?

Bhanu Priya
Updated on 08-Jul-2021 08:30:48

9K+ Views

A parallel database is one which involves multiple processors and working in parallel on the database used to provide the services.A parallel database system seeks to improve performance through parallelization of various operations like loading data, building index and evaluating queries parallel systems improve processing and I/O speeds by using multiple CPU’s and disks in parallel.Working of parallel databaseLet us discuss how parallel database works in step by step manner −Step 1 − Parallel processing divides a large task into many smaller tasks and executes the smaller tasks concurrently on several CPU’s and completes it more quickly.Step 2 − The ... Read More

What are different database models? Explain their differences

Bhanu Priya
Updated on 08-Jul-2021 08:27:13

727 Views

The types of database models are explained below −Hierarchy DatabaseIt is almost the first good database we used to organize the data. It is developed by computer software development company IBM for IMS (Information Management system).The design of this model is very simple as we arrange the data in the tree-like structure.This tree model has nodes and branches which represent fields and different areas of data.This model is good if we have to store data in a linear fashion and the whole main directory of data is present at the root node.This model shows the parent-child relationship as we have ... Read More

What is data Abstraction in DBMS?

Bhanu Priya
Updated on 31-Oct-2023 04:55:25

79K+ Views

Data Abstraction is a process of hiding unwanted or irrelevant details from the end user. It provides a different view and helps in achieving data independence which is used to enhance the security of data.The database systems consist of complicated data structures and relations. For users to access the data easily, these complications are kept hidden, and only the relevant part of the database is made accessible to the users through data abstraction.Levels of abstraction for DBMSDatabase systems include complex data-structures. In terms of retrieval of data, reduce complexity in terms of usability of users and in order to make ... Read More

What are the capabilities of DBMS and why relational DBMS is powerful?

Bhanu Priya
Updated on 08-Jul-2021 08:21:34

3K+ Views

Database management system (DBMS) is a software or tool which can be used for managing and maintaining the data within the database.Major Capabilities of DBMSThe major capabilities of DBMS are listed below −Data StorageData RetrievalData UpdateSecurityData IndependenceExplanationGenerally a person has to work with a huge amount of information every day. In order to interact with the large amount of data we need a system where we can store, manipulate, security, sharing the information all over the world. It is a core reason the industries are maintaining database management tools.Powerful Relational DBMSThe relational DBMS is more powerful because of the reasons ... Read More

Explain the classification of database security

Bhanu Priya
Updated on 08-Jul-2021 08:19:43

1K+ Views

The database security is broadly classified into physical and logical security. Database recovery is the way of restoring a database to a correct state in the event of a failure.Physical security − Physical security refers to the security of the hardware that is associated with the system and the protection of the site where the computer resides. The natural events like fire, floods, and earthquakes can be considered as some of the physical threats. It is advisable to have backup copies of databases in the face of massive disasters.Logical security − Logical security refers to the security measures present in ... Read More

What is a hierarchical database and its elements?

Bhanu Priya
Updated on 08-Jul-2021 08:18:15

451 Views

In a hierarchical database, the information is composed in a tree-like structure. The individual information is put away in a field and the fields, thus, structure records. This information is obtained with the assistance of connections between them.In this structure, every one of the information records is connected at long last to a solitary parent record.It is additionally called as the owner of record. The connections between the records are regularly shown as parent-child relations.The best utilization of hierarchical databases is its sending in a library framework as it stores names or book numbers utilizing the Decimal System.This framework takes ... Read More

What are the steps of SQL Query processing in DBMS?

Bhanu Priya
Updated on 08-Jul-2021 08:16:16

14K+ Views

Query Processing is a translation of high-level queries into low-level expression. It is a step wise process that can be used at the physical level of the file system, query optimization and actual execution of the query to get the result.It requires the basic concepts of relational algebra and file structure. It refers to the range of activities that are involved in extracting data from the database. It includes translation of queries in high-level database languages into expressions that can be implemented at the physical level of the file system.Given below is the diagram that shows the steps of the ... Read More

What are the issues in database privacy?

Bhanu Priya
Updated on 08-Jul-2021 08:14:09

841 Views

First, we need to know about database privacy and later we will go for the issues regarding database privacy and the security measures regarding the issues.Database Privacy − It is nothing but the securing of data which is present in the database. Generally, we used to store a large amount of data in the database. For that important data to be secured we need to use some security measures like security firewalls, Antivirus, security encryption, etc.Encryption − It means that the data or information is to be encoded. It means that the format of the data is not at all ... Read More

Explain parallel and distributed database management system

Bhanu Priya
Updated on 08-Jul-2021 08:12:09

4K+ Views

In parallel database system data processing performance is improved by using multiple resources in parallel. In this CPU, the disk is used parallel to enhance the processing performance.Operations like data loading and query processing are performed parallel. The centralized and client server database systems are not powerful enough to handle applications which need fast processing.Parallel database systems have great advantages for online transaction processing and decision support applications. Parallel processing divides a large task into multiple tasks and each task is performed concurrently on several nodes. This gives a larger task to complete more quickly.Architectural ModelsThere are several architectural models ... Read More

Advertisements