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
Articles on Trending Technologies
Technical articles with clear explanations and examples
What is Backup and recovery in data warehouses?
Backup and recovery define the process of backing up records in the method of a loss and setting up systems that enable that data recovery because of data loss. Backing up data needed copying and archiving computer information, so that it is applicable in case of data deletion or corruption.The goal of the backup is to make a copy of data that can be renewed in the event of a primary data failure. Primary data failures can be the outcome of hardware or software failure, data corruption, or a human-caused event, including a malicious attack (virus or malware), or accidental ...
Read MoreWhat are the security issues in a data warehouse?
Data Warehousing is an approach that is generally used to collect and handle data from multiple sources to give the business significant business insight. A data warehouse is specifically designed to support management decisions.In simple terms, a data warehouse defines a database that is maintained independently from an organization’s operational databases. Data warehouse systems enable the integration of multiple application systems. They provide data processing by offering a solid platform of consolidated, historical information for analysis.Data warehouses generalize and centralize data in multidimensional space. The construction of data warehouses contains data cleaning, data integration, and data transformation and can be ...
Read MoreWhat are the data mining interfaces?
Data mining is the process of finding useful new correlations, patterns, and trends by transferring through a high amount of data saved in repositories, using pattern recognition technologies including statistical and mathematical techniques.It is the analysis of factual datasets to discover unsuspected relationships and to summarize the records in novel methods that are both logical and helpful to the data owner.It is the procedure of selection, exploration, and modeling of high quantities of information to find regularities or relations that are at first unknown to obtain clear and beneficial results for the owner of the database.By outsourcing data mining, all ...
Read MoreWhat are the features of OLAP Servers?
There are various features of OLAP Servers which are as follows −Multidimensional conceptual view − A user view of the enterprise data is multidimensional. The conceptual view of OLAP models should be multidimensional. The multidimensional models can be manipulated more easily and intuitively than in the case of single-dimensional models.Transparency − A user should be able to get full value from an OLAP engine without regarding the source of the data. The OLAP system’s technology, underlying database, and computing architecture, and the heterogeneity of input data sources should be transparent to users to preserve their productivity and proficiency with familiar ...
Read MoreHow query operations can be improved by cascading the operations?
It is the process that manages the queries and speeds them up by directing queries to the most effective data source. This process also ensures that all the system resources are used most effectively, usually by scheduling the execution of queries. The query management process monitors the actual query profiles that are used to determine which aggregations to generate.This process services at all times that the data warehouse is created accessible to end-users. There are no major consecutive steps within this process, rather there are a set of facilities that are constantly in operations.OLAP is an element of software technology ...
Read MoreWhat are the OLAP tools in data mining?
There are three main categories of OLAP tools which are as follows −MOLAP − MOLAP represents Multidimensional OLAP. It supports tuples as the data storage unit. The MOLAP applies a dedicated n-dimensional array storage engine and OLAP middleware to handle data. Hence, OLAP queries are completed through direct addressing to the associated multidimensional views (data cubes).This structure focuses on the pre-computation of the transactional information into the aggregations, which results in fast query execution performance. Particularly, MOLAP pre-computes and stores aggregated measures at each hierarchy level at load time, and stores and indexes these values for immediate retrieval.The full pre-computation ...
Read MoreWhat is OLAP?
OLAP stands for On-Line Analytical Processing. OLAP is an element of software technology that authorizes analysts, managers, and executives to gain insight into data through fast, consistent, interactive access in a wide variety of possible views of information that has been changed from raw information to reflect the actual dimensionality of the enterprise as learned by the client.OLAP allows the users to generate online descriptive or comparative summaries of data and other analytics queries. It designates an element of software and technologies that allows the collection, storage manipulation, and reproduction of multidimensional records with the aim of analysis.It allows the ...
Read MoreWhat is the Query management process?
It is the process that manages the queries and speeds them up by directing queries to the most effective data source. This process also ensures that all the system resources are used most effectively, usually by scheduling the execution of queries. The query management process monitors the actual query profiles that are used to determine which aggregations to generate.This process operates at all times that the data warehouse is made available to endusers. There are no major consecutive steps within this process, rather there are a set of facilities that are constantly in operations.Directing queries − Data warehouses that contain ...
Read MoreWhat is Backpropagation Algorithm?
Backpropagation defines the whole process encompassing both the calculation of the gradient and its need in the stochastic gradient descent. Technically, backpropagation is used to calculate the gradient of the error of the network concerning the network’s modifiable weights.The characteristics of Backpropagation are the iterative, recursive and effective approach through which it computes the updated weight to increase the network until it is not able to implement the service for which it is being trained. Derivatives of the activation service to be known at network design time are needed for Backpropagation.Backpropagation is widely used in neural network training and calculates ...
Read MoreWhat is the difference between feed-forward and feedback systems in data mining?
Feed-forward networkFeed-forward neural networks enable signals to travel one method only, from input to output. There is no feedback (loops) i.e., the output of any layer does not affect that same layer. Feed-forward networks influence to be easy networks that relate inputs with outputs. They are extensively used in pattern recognition. This type of organization is also defined as bottom-up or top-down.Feed-forward neural networks enable signals to travel one method only, from input to output. There is no feedback (loops) i.e., the output of any layer does not affect that same layer. Feed-forward networks influence to be easy networks that ...
Read More