Vertabelo Blog

Learn how to design and use database models
 
 
RSS
 
 
 
 
 
Master Python Online! This interactie online course is dedicated (but not limited) to data science beginners and business professionals performing data analysis with CSV files. Enroll In Other Python courses:
 
Tihomir Babic 20th Mar 2019

What kind of data model supports an online musical equipment store?

 
Emil Drkušić 8th Mar 2017

You might run an antique store because you love history, but you’ll need modern technology to keep everything organized! In this article, we discuss what an antique store’s database model would need.

 
Emil Drkušić 28th Dec 2016

What kind of database model does it take to run a gallery or museum? How can it be optimized to manage events, partnerships, and other activities?

 
Francisco Claria 21st Dec 2016

In this article, I’ll walk you through some fundamental considerations for working with date- and time-related data in MySQL. We’ll also look at how to handle multiple time zones and daylight saving time changes.

 
Emil Drkušić 14th Dec 2016

Project management is a booming field. In this article, we’ll examine a data model to support a project management app.

 
Dejan Sarka 7th Dec 2016

SQL Server R Services combine the power and flexibility of the open-source R language with enterprise-level tools for data storage and management, workflow development, and reporting and visualization. This article introduces SQL R Services and the R language.

 
Emil Drkušić 30th Nov 2016

In previous articles, we’ve discussed data model that could run card games, board games and even MMO games. Many of these were based off the board games data model; the simple tic-tac-toe game was developed using Spring Boot and AngularJS. In this article we’ll move to a next level and develop a model that should be able to store results of an “action” game.

 
Maria Alcaraz 11th Oct 2016

Sunny weatherJSON is a data interchange format that is designed to be lightweight and easy to work with. It’s quite popular in web applications, and it can be considerably more flexible than a traditional relational data model. PostgreSQL 9.3 and later versions support JSON, so you can store JSON data and use native Postgres functions to operate on it. This includes decomposing, transforming, or even creating JSON data from regular relational data.

 
Shantanu Kher 4th Oct 2016

A recurring event, by definition, is an event that recurs at an interval; it’s also called a periodic event. There are many applications which allow their users to setup recurring events. How does a database system manage recurring events? In this article, we’ll explore one way that they are handled.

 
Francisco Claria 23rd Aug 2016

Whenever you need to save datetime data, a question arises about what MySQL type to use. Do you go with a native MySQL DATE type or use an INT field to store date and time info as a plain number?