Archive for the ‘data’ Category

Database schema visualization is an essential process during the initial project design phase. Also, it can be useful when you need to reverse engineer a big schema and need to understand the various relationships between different tables. Below are given various database diagramming and visualization tools that will help you make sense of your complex […]

CSV files are ubiquitous in the programming world and most data interchange is done using the CSV format. One problem however is that you cannot quickly check for certain rows depending on a particular field criteria. As an example, say you need to find all the rows from a CSV file that has a particular […]

One of the important tasks in any web application is proper sanitization and standardization of data. Any data stored in a database should be in a standardized format, specially data that comes from a variety of sources. Scrubbers or data cleaners are an important part of the data transformation process. Whenever you are involved in […]

Descriptive statistics can be quite useful for simple analysis of records in a database. For example, to calculate average numbers of sales or products for a particular duration, or the Variance of sales for a month etc. We can easily calculate standard descriptive statistic measures in MySQL such as MEAN, SUM, STANDARD DEVIATION, VARIANCE, MIN […]

With an increasing number of users migrating to WordPress, moving data from an existing CMS to WordPress has become an essential process in the transition. Although migrating small databases from another CMS can be done in a few hours, large databases can take days or even weeks. In one of my recent endeavors of the […]

Sign up for fresh content in your email