technical
A Database Model for a Hotel Reservation Booking App and Channel Manager
4 Sep 2019
Everybody books into a hotel at some point. In this article, we’ll look at a data model that could power a hotel reservations system and channel manager.
Faster, cheaper transportation options allow us to travel across the world in a matter of hours. And people have more disposable income than ever before. Is it any surprise that tourism is growing rapidly? In addition to traditional hotel booking channels, we also have newer options – like Airbnb and Booking.
technical
A Data Model for Online Concert Ticket Sales
10 Jul 2019
What kind of data model makes online concert ticketing work?
Have you ever been to a concert? I'm sure you have. And I bet you purchased your ticket online. Online shops let us buy tickets to concerts by our favorite artists without leaving our comfortable homes. We can find a venue or a location (even one that’s not near us), choose a seat, and get our tickets delivered instantly through email – or maybe we’ll wait several days and get the tickets delivered.
others
Using Python and MySQL in the ETL Process: Using Python and SQLAlchemy
26 Jun 2019
In the previous two articles of this series, we discussed how to use Python and SQLAlchemy to perform the ETL process. Today we’ll do the same, but this time using Python and SQL Alchemy without SQL commands in textual format. This will enable us to use SQLAlchemy regardless of the database engine we’re connected to. So, let’s start. Today we’ll discuss how to perform the ETL process using Python and SQLAlchemy.
others
Using Python and MySQL in the ETL Process: SQLAlchemy
12 Jun 2019
SQLAlchemy helps you work with databases in Python. In this post, we tell you everything you need to know to get started with this module.
In the previous article, we talked about how to use Python in the ETL process. We focused on getting the job done by executing stored procedures and SQL queries. In this article and the next, we’ll use a different approach. Instead of writing SQL code, we’ll use the SQLAlchemy toolkit.
others
Using Python and MySQL in the ETL Process
22 May 2019
Python is very popular these days. Since Python is a general-purpose programming language, it can also be used to perform the Extract, Transform, Load (ETL) process. Different ETL modules are available, but today we’ll stick with the combination of Python and MySQL. We’ll use Python to invoke stored procedures and prepare and execute SQL statements. We’ll use two similar-but-different approaches. First, we’ll invoke stored procedures that will do the whole job, and after that we’ll analyze how we could do the same process without stored procedures by using MySQL code in Python.
design_patterns
Designing a Database for a Recruitment System
8 May 2019
Do you want to learn how to design a database system and map a business process to a data model? Then this post is for you. In this article, you’ll see how to design a simple database schema for a recruitment company. After reading this tutorial, you will be able to understand how database schemas are designed for real-world applications. The Recruitment System Business Process Before designing any database or data model, it is imperative to understand the basic business process for that system.
example_models
A SaaS Subscription Data Model
17 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.
design_patterns
The Important Dates Data Model
3 Apr 2019
Are you forgetting something? A data model to help you remember important dates – before they happen. Have you ever forgotten an important date – your mom’s birthday or your anniversary? Or that you’re giving a lecture? Yup, things like that happen in real life. Maybe not to all of us, but to some of us (including me), they certainly do. To prevent such disasters, we’ll create a data model you could use as the background for an application that will notify you right on time.
example_models
A Data Model for an Online Musical Equipment Shop
20 Mar 2019
What kind of data model supports an online musical equipment store?Musical equipment shops used to be one of those old-fashioned industries, one that you wouldn’t expect could (or should) adapt to the online world. It wasn’t unreasonable to paint such a picture. After all, you can’t choose your ideal guitar based solely on magazine pictures, can you? Musicians and wannabe-musicians need to try various instruments, hearing and feeling how each one responds when played.
example_models
A Data Model for a Wine Store
6 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.In many ways, a wine store is like any other store. So, you can expect this data model to have most of the tables common to any other retail business. Still, there will be some details that will distinguish this model from others.
