Share it!moreAlthough 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!moreIn 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!moreInternet-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!moreWhen 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!moreSearch 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!moreWhat 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!moreMongoDB (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 →
© 2021 IMELGRAT.ME
Theme by Iván Melgrati — Top ↑