Relative Content

Tag Archive for relational-database

Why many designs ignore normalization in RDBMS?

Want to improve this post? Provide detailed answers to this question, including citations and an explanation of why your answer is correct. Answers without enough detail may be edited or deleted. I got to see many designs that normalization wasn’t the first consideration in decision making phase. In many cases those designs included more than […]

Why many designs ignore normalization in RDBMS?

Want to improve this post? Provide detailed answers to this question, including citations and an explanation of why your answer is correct. Answers without enough detail may be edited or deleted. I got to see many designs that normalization wasn’t the first consideration in decision making phase. In many cases those designs included more than […]

Does it ever make sense to have a one-to-one obligatory relationship in a relational database?

To kind of illustrate what I mean, say that you have a group of students and a group of professors in some kind of a traineeship. Every professor is to mentor one student and every student has to be mentored by one and only one professor. Thus, we have an obligatory one-to-one relationship. Let’s furthermore say that you every student has a studentID (primary key), name and a phone number, and every professor has a professorID, name and a phone number. In this scenario, would it make sense to have a single table where you list all the attributes for a single entity (that is, studentID, their name, phone number, the ID of their mentor and then their name and phone number)? My first thought is that this kind of scheme breaks the 3rd normalization form, as the professor’s name and phone number are dependent on the professorID, and that perhaps splitting the table into two, having a Professor table that contains the professor’s name and phone number and putting the professorID into the student table as a foreign key is the proper way of going about it. At the same time, since it’s an obligatory one-to-one relationship, would that even matter?

Does it make sense to use a graph database (Neo4j) for a diagramming app?

I am developing a diagramming application and want to optimize operations with the Nodes and Relations of the diagram. Currently, I am using a relational database with tables for diagrams and nodes. Each node entity has a field children containing the IDs of its child nodes, which forms the relationships. This architecture seems far from ideal to me, so I am curious whether I would gain a performance boost in operations with the diagram elements by using a graph database. I am referring to operations such as retrieving all nodes for a specific diagram, modifying nodes, relationships, etc.

Mixing up UML and non-UML diagrams

When designing a data-intensive software, or any kind of software, regardless of the platform, is it appropriate to mix UML and non-UML diagrams together in the design document of the software?

Would it be bad to use two different database engines for location history?

I’m building an analytics and storage platform for entity location history. I’m a bit hung up on the database engine, though. On the one hand a graph database fits really well for the entity relationships. On the other hand, queries around the time based dimension (e.g. entity history and the history of a defined area) seem to fit better in an RDBMS.