Posts by
Redgate Data Modeler
Take a closer look at some new features introduced in Vertabelo database modeler in April 2015. Read more
Working on a project to create an application that is focused on analytics, reporting, and especially forecasting, has forced me to recognize the different requirements between transactional and analytical database design. Read more
When writing a blog post on database modeling, you must be prepared that your abstract model doesn't meet the needs of most readers. The reason is simple. Real-life database models are usually created in close relation to specific business and development requirements while the blog models are not. Read more
In the conclusion to Part 2 of this series of articles, I mentioned that I would be adding more advanced features, such as conditional ordering of questions in a survey, administration of the survey, reports and analytics. In this third article related to an online survey, I will extend the functionality to support conditional... Read more
There are books that you plan to read. Then, there are books that you actually started reading and then stopped. Then, there are books you started reading and you hope to finish sometime. The last database book I did read was "Concise Guide to Databases" by Peter Lake and Paul Crowther. Read more
Our users sometimes say to us: “Vertabelo is awesome but... how can I add the data?” That's why I decided to show you how to set up a simple PostgreSQL database in the Cloud using a database model created in Vertabelo, and cloud-based PostgreSQL server hosted by ElephantSQL. So let's dive into the Cloud! Read more
In part 1 of this article series, we discussed a basic design for an online survey. In the conclusion to that article, I mentioned part 2 would cover more advanced features for our survey. Let’s start by extending the functionality to support different types of questions. Read more
When you are designing a database model with hundreds of tables, you can make it more readable and comprehensible by coloring different groups of tables or subject areas. Learn how to do this quick and easy in Vertabelo. Read more
I need to create the design for a new database which will be the data layer for an application; the application will be an online survey or polling like Survey Monkey. My challenge is that the functionality that I require is not supported by existing survey sites, so I need to build my own.... Read more
Database design is the process of producing a detailed model of a database. This model contains the necessary logical (table names, column names) and physical (column datatypes, foreign keys) choices to translate the design into a data definition language (aka SQL), which can be used to create the actual physical database (...) Read more
Redgate Data Modeler