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
Data Mining:Data Attributes and Quality
Data Mining The process of extracting the data from a huge dataset that can be used for analysis and benefit of the organisation. This process helps in identifying patterns and managing relationship among the data to predict business problems. Data attributes An attribute can be defined as characteristics or property of an object. Object is described by attributes set and is referred to as a record of entity. Entity is described by a fraction of data i.e. attributes. For Example:In a Student database. (Name, id, Roll_no, Marks) are the attributes in provided database. Types of Attributes Nominal Attribute It only ...
Read MoreAdvantages and Disadvantages of Three-tier Architecture
A 3−tier application architecture is a modular client−server architecture that consists of a presentation tier, an application tier, and a data tier. The presentation tier is a graphical user interface (GUI) that interacts with the other two tiers; the data tier stores information; the application tier manages logic. A 3−tier architecture has pros in terms of better horizontal scalability, performance, and availability. When there are three layers, each component can be produced concurrently by a separate team of programmers using a different programming language than the developers of the other levels. The 3−tier paradigm makes it simpler for an organization ...
Read MoreData Mining Process
The process of extracting the data from a huge dataset that can be used for analysis and benefit of the organization. Data mining process generally involves the following steps − Business understanding Business understanding and client objective is necessary. Clients needs are to be defined and then using the scenario, data mining goals are defined. Data understanding Data is collected from different sources and explored to understand the properties and characteristics of data. Data preparation The data that is being collected are now selected, cleaned, transformed, preprocessed and constructed so as to make it ready for analysis. This process takes ...
Read MoreLargest Component Size in a Graph Formed by Connecting Non-Co-Prime Nodes
Introduction In this tutorial, we discuss the problem of finding the largest component size in a graph generated by connecting non-co-prime nodes through C++. Graphs are formed by nodes connected by edges. The components of the graph are a subset of values that form nodes. There is an array a[] which forms graph G. The components of the graph are a subset of values that form nodes. The non-coprime numbers are the numbers that have a HCF (Highest Common Factor) other than 1, that means they have some other common factors. We solve the problem statement in this tutorial using ...
Read MoreData Mining multidimensional association rule
Association rule mining helps us to find relationships among large dataset. In Multidimensional association, Multidimensional association rule comprises of more than one aspect Numeric attributes should be discretized. Attributes can be unmitigated or quantitative. Quantitative characteristics are numeric and consolidate pecking order. Three approaches in mining multidimensional association rules are − Using static discretization of quantitative attributes Discretization happens earlier to mining and is static. Discretized attributes are treated as absolute and use an algorithm called apriori algorithm to search for all k-frequent predicate sets(k or k+1 table scans are required). Each subset of a frequent predicate set ...
Read MoreData Marts(storage component of HDFS)
Data mart is a storage component and only cares about some specific functional area of an organisation which are then taken care by a single department like marketing, sales, finance etc. Data Mart and Data Warehouse are both storage components of HDFS. Data Mart contains a subset of the data stored in the data warehouse. Frequently requested data can easily be accessed through data mart. Simple to Implement and cost is lower as compared to data warehouse. It is more open to change and its smaller size makes it quicker to build if any change in model occurs. ...
Read MoreData anomalies in DBMS
Anomalies means problems or inconsistency which happened during the operations performed on the table. There can be many reasons that anomaly occur for example, It occurs when data is stored multiple times unnecessarily in the database i.e. redundant data is present or it occur when all the data is stored in a single table. normalization is used to overcome the anomalies. the different type of anomalies are insertion, deletion and updation anomaly. Input The same input is used for all three anomalies. Student ID Name Age Branch Branch_Code Hod_name 1 A 17 Civil 101 Aman ...
Read MoreCurrent user function in SQL
It is used to return the name of the current user in sql database server. it does not accept any parameter. Syntax CURRENT_USER Current_user is the function used to get the name of current user Example 1 In this example, we are going to use the current_user function to get the current user name. Input Employee Emp_id Name Dept_name Salary 1 Monu IT 50000 2 Sonu HR 60000 3 Golu Security 70000 This database is currently used by amrendra. Code SELECT CURRENT_USER;#selected current user name Output Amrendra ...
Read MoreCreating materialised view using table definition in cassandra
A materialised is defined as a database object that contains the results of a particular query. It could be called as a subset of a table. Any changes in the base table would be reflected in the materialised view. Syntax CREATE MATERIALISED VIEW view_name AS SELECT * FROM table_name WHERE column_name IS NOT NULL PRIMARY KEY (provide_primary_key) Here, view_name is the name of the materialised view, table_name is the base table, column_name are the columns provide_primary_key are the primary keys for the base table. Example 1 In this example, we are gonna have a ...
Read MoreCreate, Alter & Drop schema
Create a schema Schema is basically the logical representation of the database. there is a default schema named dbo. Objects gets created inside a schema when ‘create schema’ statement is used. To provide access to other user after the schema is created, we need to impersoinate permissions. Syntax:The syntax to create a schema is − Create schema schema_name Here, we have created a schema named schema_name. Example 1: Granting permissions In this example, we are going to create a schema and grant permissions to have access to that. Algorithm Step 1 − Create a schema. Step 2 − ...
Read More