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
MySQL Articles
Page 8 of 355
Data Preprocessing in Data Mining
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 cleaning help us remove inaccurate, incomplete and incorrect data from the dataset. Some techniques used in data cleaning are − Handling missing values This type of scenario occurs when some data is missing. Standard values can be used to fill up the missing values in a manual way but ...
Read MoreData Objects, Attributes and Relationship in DBMS
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 relationship among the data objects. Types of Data Objects Array is a one-dimension data object. i.e, can be a single column in a table. Example Student Name Aman Naman Monu Records Records refers to a single row for every ...
Read MoreData Modeling for Data Warehouse
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 is that relationship within the warehouse data can be visualised through the schema and second is that the cost is reduced and efficiency is increased with the help of well-designed schema which allow effective data warehouse structure to occur. Data modeling is different in data warehouse than in operational database ...
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 MoreHow To Optimize MySQL Tables?
Optimizing MySQL tables is a crucial step in improving the performance and efficiency of your database. By employing effective optimization techniques, you can enhance query execution speed, reduce storage requirements, and optimize resource utilization. This article explores various strategies and best practices to optimize MySQL tables, allowing you to maximize the performance of your database-driven applications. In this guide, we will discuss the importance of analyzing table structure and design, selecting appropriate data types, and normalizing the database schema. We will also delve into indexing strategies, including identifying indexing opportunities and optimizing indexes for query performance. Additionally, we will explore ...
Read MoreHow to Monitor MySQL_MariaDB Databases using Netdata on CentOS 8?
In today's data-driven world, monitoring the performance and health of databases is crucial for ensuring the smooth operation of applications and the overall efficiency of your infrastructure. When it comes to monitoring MySQL or MariaDB databases on CentOS 8, Netdata emerges as a powerful and user-friendly tool. Netdata provides real-time insights into various metrics and performance indicators, allowing you to proactively identify bottlenecks, optimize resource utilization, and ensure the reliability of your database environment. In this blog post, we will explore how to set up and configure Netdata to monitor MySQL/MariaDB databases on CentOS 8. We will walk you through ...
Read MoreSetting Up LAMP (Linux, Apache, MySQL/MariaDB, PHP) and PhpMyAdmin on Ubuntu 15.04 Server
LAMP is one of the most widely used Open source technology stacks which is used in the development of web applications. In this combination, Linux acts as the operating system, while PHP is the server side programming language. MySQL or MariaDB acts as the database management system along with apache as web server. In this article, we’ll cover how to set up the LAMP stack with PhpMyAdmin on an Ubuntu 15.04 server. With the use of LAMP (Linux, Apache, MySQL/MariaDB, PHP) components, we can build interactive and engaging Web applications. Let's understand each component of the LAMP stack: Linux ...
Read MoreSetting Up LEMP Linux, Nginx, MySQL/MariaDB, PHP) and PhpMyAdmin on Ubuntu 15.04 Server
LEMP stack is a powerful combination of open source technology used for Web development and hosting. LEMP comprises Linux, which is the operating system in the combination, Nginx (pronounced as engine x) is a web server software, used to handle HTTP requests from servers, it helps the delivery of static and dynamic content. MySQL or MariaDB are used for efficient data storage and retrieval and PHP is used to construct dynamic web applications, enabling developers to communicate with databases and integrate dynamic information into HTML pages. Installing and configuring each component of LEMP, one at a time is required to ...
Read MoreHow to Concatenate Column Values of a MySQL Table Using Python?
MySQL is an open−source relational database management system that is widely used to store, manage, and organize data. When working with MySQL tables, it is common to require the combination of multiple column values into a single string for reporting and analysis purposes. Python, a high−level programming language, offers several libraries that enable connection to MySQL databases and execution of SQL queries. In this article, we'll dive into the process of concatenating column values of a MySQL table using Python and the PyMySQL library. A step−by−step guide is provided on how to connect to a MySQL database, execute a SQL ...
Read MoreHow to Compute the Average of a Column of a MySQL Table Using Python?
In today's data−driven world, for businesses and organizations efficiently analyzing and manipulating large data sets is difficult. MySQL, as a popular open−source relational database management system, and Python, as a versatile programming language, are two latest and trending technologies that when combined, can help achieve this goal. In this article, we will guide you through the process of computing the average of a column of a MySQL table using Python. From establishing a connection to your MySQL database, executing an SQL query to compute the average of a column, and fetching the result, we will provide a step−by−step guide ...
Read More