No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
I want to model a situation where you can have multiple children of an element, and the children can be different types and in any order. A simple example of what I mean is at [1]. I am trying to make a schema to define this document, my attempted schema … | |
What are the performance implications of storing some data across 2 databases instead of duplicating this data in both databases? ie. is example 1 significantly slower than example 2: Example 1: SELECT Users.User.*, Transactions.Sales.date FROM Users.User, Transactions.Sales WHERE Users.User.id=Transactions.Sales.userid; Example 2: SELECT Users.User.*, Users.Sales.date FROM Users.User, Users.Sales WHERE Users.User.id=Users.Sales.userid; Note … | |
I am a looking for recomendations for a book on database design. I have tried searching this site, and not found any good answers though I am sure this has been asked before. My situation is that I start a new job in a couple of weeks and I want … |