How can I find all connections in a mesh network/graph?
Suppose I have a mesh of relationships, such as
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 […]
Database model for keeping track of likes/shares/comments on blog posts over time
My goal is to keep track of the popular posts on different blog sites based on social network activity at any given time. The goal is not to simply get the most popular now, but instead find posts that are popular compared to other posts on the same blog.
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?
Should uniqueness validation be on the database level or backend codebase level in data import
There is a kinda ETL task of importing data from csv to the database in project with legacy codebase with legacy database. The data should be validated before persisting to database.
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.
Object-oriented programming design with relational database tables
I want to understand what is considered best-practice to better align with OOP when handling relational databases. I cannot find any online examples where classes and a more maintainable/re-usable design is implemented for relational databases.
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.