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 are the techniques for Data Cube Computations?
The following are general optimization techniques for efficient computation of data cubes which as follows −Sorting, hashing, and grouping − Sorting, hashing, and grouping operations must be used to the dimension attributes to reorder and cluster associated tuples. In cube computation, aggregation is implemented on the tuples that share the similar set of dimension values. Therefore, it is essential to analyse sorting, hashing, and grouping services to access and group such data to support evaluation of such aggregates.It can calculate total sales by branch, day, and item. It can be more effective to sort tuples or cells by branch, and ...
Read MoreHow does data mining relate to information processing and online analytical processing?
There are three kinds of data warehouse applications such as information processing, analytical processing, and data mining.Information processing − It provides querying, basic numerical analysis, and documenting using crosstabs, tables, charts, or graphs. A modern trend in data warehouse data processing is to make low-cost web-based accessing tools that it is integrated with web browsers.Analytical processing − It provides basic OLAP operations, such as slice-and-dice, drilldown, roll-up, and pivoting. It usually works on historic information in both summarized and detailed forms. The major area of online analytical processing over information processing is the multidimensional information analysis of data warehouse data.Data ...
Read MoreHow are organizations using the information from data warehouses?
Data Warehousing is an approach that can collect and manage data from multiple sources to provide the business a significant business insight. A data warehouse is specifically designed to provide 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 support data processing by providing a solid platform of consolidated, historical data for analysis.A data warehouse is a semantically consistent data save that handle as a physical execution of a decision support data model. It saves the data an enterprise ...
Read MoreReturn True if two Numpy arrays are element-wise equal within a tolerance
To return True if two arrays are element-wise equal within a tolerance, use the ma.allclose() method in Python Numpy. This function is equivalent to allclose except that masked values are treated as equal (default) or unequal, depending on the masked_equal argument. The "masked_values" parameter is used to set the masked values in both the arrays are considered equal (True) or not (False).Returns True if the two arrays are equal within the given tolerance, False otherwise. If either array contains NaN, then False is returned.A masked array is the combination of a standard numpy.ndarray and a mask. A mask is either ...
Read MoreWhat are the methods for the generation of concept hierarchies for nominal data?
There are various methods for the generation of concept hierarchies for nominal data as follows −Specification of a partial ordering of attributes explicitly at the schema level by users or professionals − Concept hierarchies for nominal attributes or dimensions generally contains a set of attributes. A user or professionals can simply represent a concept hierarchy by defining a partial or total governing of the attributes at the schema level.For instance, suppose that a relational database includes the following set of attributes such as street, city, province or state, and country. A data warehouse location dimension can include the same attributes. ...
Read MoreOut-GridView in PowerShell
DescriptionOut-GridView in a PowerShell is the output format in the GUI format. Generally, we get the output on the console using the Format-Table or Format-List command. Similarly, Out-GridView is also the output format but we can interact with it because of the GUI format.Moreover, it provides us options to select single or multiple rows and we can store the selected output and can utilize them in the script.Out-Gridview with PipelineYou can pipeline output to the Gridview in a similar way as Format-Table or Format-List commands.Example1 − With Pipeline outputGet-Service | where{$_.StartType -eq 'Disabled'} | Out-GridViewOutputThe above command will get all ...
Read MoreException handling in PowerShell
In this article, we will go through the below points.What is an Exception in PowerShell?Terminating and Non-Terminating errors.Using Try / Catch block.Converting Non-Terminating error to Terminating Errors.Handling actual exception messages.What is the exception in PowerShell?Exception in PowerShell or other programming languages is the error or unexpected result that can be handled. For example, File not found while executing, dividing a number by zero.The exception can stop script execution if not handled properly.Terminating Errors and Non-Terminating ErrorsNon-Terminating errors don't halt script execution and it continuously runs script even if it is detected in the script. Below is an example of the ...
Read MoreImporting / Exporting CSV file in PowerShell
In this article, we will work with CSV files in PowerShell which is considered one of the most efficient ways to deal with data.We have considered the below points for this article.Exporting data to the CSV file using PowerShell.Importing data from the CSV file using PowerShell.Let’s get started.Exporting data to the CSV file using PowerShellUsing Direct command outputTo export data to the csv file in PowerShell we can use Out-File which is the common cmdlet for storing the output to the file. The below command will get the top 10 CPU-consuming processes in the csv file.ExampleGet-Process | Sort-Object CPU -Descending ...
Read MorePowerShell Desired State Configuration
OverviewPowerShell DSC is different than PowerShell scripting which ensures the remote windows systems are in the desired state and it is the declarative method unlike PowerShell Scripting and other programming languages which are considered imperative methods.In this article, we will go through the Push Method of the DSC which is a commonly used method for beginners and doesn’t require the Pull server. Pull server which polls the remote servers at some intervals and set the desired configuration for them and it is kind of automated.For the Push configuration, we will consider the below aspects.Get the DSC resource to Configure.Create the ...
Read MoreAzure DSC node configuration using PowerShell
What is Azure State DSC?Azure State DSC is nothing but the DSC (Desired State Configuration) for the Azure VMs and can be configured from the Azure Automation Account. For the DSC there are two methods Push and Pull configuration but Azure is by default using the Pull server which constantly polls the target nodes and sends the configuration to the nodes.Azure DSC is itself a vast topic, in this article we will try the below configuration using PowerShell.Compose / Upload Node Configuration file.Compile node configuration.Attach compiled node configuration to the nodes.PrerequisiteAzure SubscriptionAzure Automation AccountConfiguration file (That we will create in ...
Read More