New ask Hacker News story: Ask HN: How do you decide what is a many-to-many vs. enums vs. array

Ask HN: How do you decide what is a many-to-many vs. enums vs. array
2 by erlich | 0 comments on Hacker News.
Whenever I'm designing a schema I always find myself wanting to just make everything a many-to-many relation because it makes things flexible and safe (referential integrity). But then there is always this feeling that these joins are going to make things complicated, verbose, and inefficient, when a simple enum or an array column would be simpler. My main gripe is that I hate having to impose constraints on my data model early on when I have no idea about how it will evolve over time. How do others deal with these decisions? Also, is there any product that would allow me to model the domain exactly as it is (i.e. like a semantic graph), and then have efficient and simple querying?

Comments

Post a Comment

Popular posts from this blog

How can Utilize Call Center Outsourcing for Increase your Business Income well?

Image
Call center outsourcing is not uncommon however, not every company can live up to the expectations of a great client. The service provider should have the ability to assist you obtain access to new abilities and competences in order to help you achieve efficiency and effectiveness in your company. Digital office providers assist business in providing unique, innovative solutions that are intended to custom-fit your personal small business needs. Some back office service providers also have fully-developed outbound calling and telemarketing services that you can utilize. The world has taken a huge leap with the technological revolution. What was impossible before now seems to be a matter of seconds. As we see more and more start-ups and digital companies emerging, we need to understand how we can account the rising number of BPO companies that can be helpful to us. Running a call center internally may be an expensive affair particularly when it...
Read more

New ask Hacker News story: Is someone trying to steal credit for inventing the eTicket?

Is someone trying to steal credit for inventing the eTicket? 2 by rexarex | 0 comments on Hacker News. The eTicket is what we use for flights today instead of physical, paper tickets printed on special paper. My understanding of the lore is that it was invented by Southwest Airlines or a company they acquired. That's what I heard on a How I Built This podcast episode with the founder of JetBlue. It's also mentioned in this research paper here https://ift.tt/RB63DSb Strangely, when I was googling I found what I suspect to be planted misinformation in a Bangkok Post article where someone named Joel Goheen claims to have invented the eTicket on JRG Airlines (https://ift.tt/bTyawJM). JRG Airlines does not exist, and appear to be just the initials of Joel R Goheen. However, he appears on a U.S. Patent for eTicketing for 1994 the same time they started using eTickets. (https://ift.tt/tzSTHf2) I think it's really strange. I did some googling of his name and eTicket and there ap...
Read more