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:
 
Emil Drkušić 17th Apr 2019

SaaS (Software as a Service) is one of the three main components of Cloud computing. Usually, SaaS applications are web-based and can handle many different users at one time. Subscription-based solutions are very popular SaaS offerings. Some well-known SaaS products include Microsoft Office 365, Amazon Web Services (AWS), Slack, Jira, Stripe, and (of course) Vertabelo! Today we’ll take a look at a data model that would allow us to manage SaaS subscriptions.

 
Emil Drkušić 3rd Apr 2019

Are you forgetting something? A data model to help you remember important dates – before they happen.

 
Emil Drkušić 6th Mar 2019

Producing a great wine is a really complex process, one that takes many years to master. Offering and selling wines to customers is another complicated process. There are many stores specializing in only one product. If you want that product, you’ll go to that store. Wine stores are an example of what I’m talking about. What would be the data background of a wine store? Let’s find out.

 
Vertabelo Team 20th Feb 2019

There are many online portals which allow investors to lend money directly to individual borrowers – with no banks acting as intermediaries. What data model might underlie such a site?

 
Emil Drkušić 6th Feb 2019

Running an automobile/car repair shop is a really complex business. You’ll need to make appointments while some customers will drive in and you don’t want to have them wait for hours. Also, you’ll need to organize employees, track repairs, materials, charge customers, etc. You’ll definitely need an IT solution and, of course, a data model in the background. Today we’ll talk about one such model.

 
Emil Drkušić 24th Jan 2019

Smart homes used to be strictly in the future; now they are a reality. Most of us have heard about them, but they are not so widespread as they will be in the near future. Managing your home the ‘smart’ way will definitely produce a lot of data. Today, we’ll analyze a data model we could use to store smart home data.

 
Emil Drkušić 21st Dec 2018

Freelancing is becoming more and more popular these days. While most freelancers are a one-man band, that’s not the only option. You could be a part of a collective and collaborate on larger and more complex projects. A data model that could power a freelancers collective’s app is the topic of today’s article.

 
Emil Drkušić 12th Dec 2018

You’ve probably made some of these mistakes when you were starting your database design career. Maybe you’re still making them, or you’ll make some in the future. We can’t go back in time and help you undo your errors, but we can save you from some future (or present) headaches.

 
Emil Drkušić 15th Nov 2018

In the previous two parts, we’ve presented the live database model for a subscription-based business and a data warehouse (DWH) we could use for reporting. While it’s obvious that they should work together, there was no connection between these two models. Today, we’ll take that next step and write the code to transfer data from the live database into our DWH.

 
Emil Drkušić 24th Oct 2018

Can you design an OLAP database model from an OLTP model? In this article, we’ll show you how!