IMELGRAT.ME

Resources for Developers

Category

Database

On this page, you will find posts about managing and taking advantage of a database, schemas, tables, queries, reports, views, and other objects. 

 

Using Random Numbers in MySQL – A few use cases

Share it!

Share it!Although you might not expect it, random numbers are used in databases quite often, especially when generating dummy data, providing randomized lists of products, to name just a couple. For instance, let’s say you have a table named “productData”… Continue Reading →


Share it!

Big Data, MapReduce and Julius Caesar

Share it!

Share it!In today’s data-driven market, MapReduce is one the of the hottest technologies, along with BigData, Hadoop and NoSQL database engines. But what if I told you that MapReduce really was invented by Julius Caesar, the famous Roman emperor? Julius… Continue Reading →


Share it!

ACID or BASE databases? Consistency versus Scalability

Share it!

Share it!Internet-based systems have grown in popularity over the last few years. Whether you are building an application for end users or an enterprise-level one, if the application grows (either in user or transactions count) and the relies upon persistence,… Continue Reading →


Share it!

Left, Right or Cross? Different types of SQL joins explained

Share it!

Share it!When working with databases, SQL joins (Structured Query Language table joins) are used to combine rows from two or more tables, based on a related set of columns between them. In this article, we’ll take a look at the different… Continue Reading →


Share it!

Spatial indexes to speed coordinate-based searches

Share it!

Share it!Search operations in databases are usually optimized using indexes as well as careful data modeling. This is also true for coordinate-based databases by using spatial indexes. Optimizing spatial searches is possible with the aid of a great variety of… Continue Reading →


Share it!

Composite indexes – When should you use them in MySQL?

Share it!

Share it!What are composite indexes? Database engines (e.g. MySQL, PostgreSQL, etc.) can create composite indexes on table data. That is, indexes on multiple columns at once, instead of indexing a single column. For instance, MySQL allows indexes of up to… Continue Reading →


Share it!

Beyond SQL. Benefits of MongoDB and NoSQL databases

Share it!

Share it!MongoDB (derived from humongous) is a cross-platform, high performance, high availability, and easy scalability document-oriented database. MongoDB is released under a released under a mix of the GNU Affero General Public License and the Apache License. Classified as a… Continue Reading →


Share it!

© 2019 IMELGRAT.ME

Theme by Iván MelgratiTop ↑