Technical
Database Design for Multi-Language Applications
24 Mar 2022
While some software systems are used by a limited number of users speaking the same language, most organizations need to unify and centralize their applications to be used by people speaking different languages all around the world. Multilanguage databases present an additional level of difficulty in designing and implementing data models. In this article, we suggest some approaches for dealing with this challenge.
What Information Do We Need to Store in Multiple Languages?
Technical
4 Tips for Troubleshooting DDL Import in Vertabelo
22 Mar 2022
Read these troubleshooting tips before using the DDL import option to generate data models in Vertabelo. Avoid running into potential errors that waste your valuable designing time.
Few data modeling tasks start from a blank sheet of paper. More often, we work on a pre-existing database.
You don't want to draw an ERD of an existing database from scratch. But I don’t have to tell you that. This task is much simpler and infinitely faster with a modeling tool that can load the database structure using a DDL import feature.
Technical
What Logical Models Data Types Are Available in Vertabelo?
17 Mar 2022
Logical models define the initial blueprint of your database. Read along to learn how to create them and what attribute data types are available in Vertabelo.
In this article, we’ll introduce the logical model. It essentially illustrates the structure of entities, attributes, and relationships in your database. Also, you’ll see the difference between logical and physical models. In the end, we’ll create a logical model in Vertabelo, which will include creating entities with attributes of specific data types.
Technical
Vertabelo Database Designer: The New UI Design and UX Improvement, Part I
15 Mar 2022
Have you already noticed the Vertabelo Database Modeler has a new look now? The entire graphic design changed significantly at the end of January.
Over the past few years, we have been observing how the previous interface worked and paying great attention to the experience of our users. Equipped with the knowledge we have gathered, we developed a completely new graphic design of our ERD tool and implemented several ergonomic improvements to individual functional elements.
Technical
Using Text Notes in Data Modeling
10 Mar 2022
Including notes in your data model improves communication, clarity, and ultimately productivity. We look at several ways to use notes in the Vertabelo data modeler.
In data modeling, it’s often vital to document essential parts by leaving messages for team members or creating a list of tasks that need to be done in a particular part of the model. To achieve this goal, Vertabelo provides the Notes feature. This feature allows you to place small annotations in the model without affecting its structure.
Technical
Vertabelo’s Document Structure: How Documents and Models Are Organized
8 Mar 2022
Make data modeling even easier by understanding Vertabelo’s document structure and how the program organizes documents and models.
To feel comfortable when modeling data, you must be familiar with your data modeling tool. In this case, it’s Vertabelo.
For starters, it’s important that you know how the main structure of documents works and what it looks like in Vertabelo. This includes knowing what types of documents are available, how they can be organized, and the purpose of every folder.
Technical
Best Practices for Multi-Language Database Design
3 Mar 2022
To implement multi-language support in your data model, you don’t need to reinvent the wheel. This article will show you the different ways to do it and help you choose the one that works best for you.
The concept of localization is vital to the development of a software application, particularly when that application’s scope is global. Support for multiple languages is the main aspect to consider; a database design that supports a multi-language application allows you to diversify your target markets and thus reach many more customers.
Technical
Data Modeling Basics in 10 Minutes
1 Mar 2022
Every software developer should know how to design a basic data solution to store application data. In this article, we’ll take you step by step through the basics of data modeling.
By the end of the article, you‘ll understand the main phases of database modeling and the types of questions you need to ask when designing a data solution. This introduction to data modeling basics will hopefully spark your curiosity and show you that database modeling is an exciting challenge.
Technical
Working With Vertabelo Editor Features
24 Feb 2022
Vertabelo lets you be productive in data modeling by providing a good view of the entire data model. For situations when the screen real estate is not sufficient or just not enough to see the entire data model, the Vertabelo editor features adjustable UI elements to help you no matter what screen size you use.
Whether you’re a seasoned database designer/architect or you’re just beginning, your tool belt has a data modeling tool.
Technical
5 Important Database Concepts for the Software Engineer
22 Feb 2022
If you have this guide at hand at all times, you don’t need to distract your database experts every time a data need arises during a software development process.
Software engineering jobs are a good fit for people capable of dealing with diverse concepts. These concepts range from requirements analysis, team leadership, project management, scripting languages, testing techniques, to continuous integration, just to name a few. Then, there are a bunch of important database concepts for a software engineer to know: normalization, denormalization, SQL, No-SQL, ERDs, query optimization, etc.
