Data Definition Language(DDL) is used for describing data and its relationship in a database. It is also used to define the database schema. The commands only affect the database structure and not the data. The main DDL commands are create, alter, drop and truncate. Create Statement It is used to ... Read More

DCL(Data Control Language) work is to deal with sql commands that are used to permit a user to access, modify and work on a database. it is used to access stored data. It gives access, revoke access and change the permission to the owner of the database as per the ... Read More

Data replication means copying the data at multiple locations to improve the availability of data. It is used to remove the inconsistency between the same data which results in a distributed database so that users can do their own task without interrupting the work of other users. There are various ... Read More

Data preprocessing is an important process of data mining. In this process, raw data is converted into an understandable format and made ready for further analysis. The motive is to improve data quality and make it up to mark for specific tasks. Tasks in Data Preprocessing Data cleaning Data ... Read More

Data Objects Data objects refers to a collection of various attributes which are combined to make it understandable. Data object values have their own unique id, attribute and data types. The most common type is the data table. Data objects are mostly represented in data models, which resolve with the ... Read More

Data Models Data models refers to how the logical structure of a database is made. Data model acts as a conceptual tool that describes the data relationship, data semantics and data constraints. Database uses three tier architecture so we need to design the database at physical, logical and view level. ... Read More

Data modeling refers to the process of handling and designing the data model within a data warehouse platform. It consists of making an appropriate database schema so as to transfer the data that can be stored and of useful to user. Data warehouse modeling is used for two reasons, first ... Read More

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 ... Read More

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, ... Read More

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 ... Read More