Database design
-
Hello, I'll have to create a new database. It's a classic membership database. I need to create tables to allow my users to identify with Facebook, Google, Windows, ... I'm not the first one to create this kind of database. I would like to know if it exists a website with samples, helpers or pattern of classic database design (in UML or ERM). Thank you,
-
Hello, I'll have to create a new database. It's a classic membership database. I need to create tables to allow my users to identify with Facebook, Google, Windows, ... I'm not the first one to create this kind of database. I would like to know if it exists a website with samples, helpers or pattern of classic database design (in UML or ERM). Thank you,
Wrong is evil and must be defeated. - Jeff Ello[^]
-
Wrong is evil and must be defeated. - Jeff Ello[^]
Thank you. It's exactly what I'm looking for.
-
Thank you. It's exactly what I'm looking for.
You're welcome.
Wrong is evil and must be defeated. - Jeff Ello[^]
-
Hello, I'll have to create a new database. It's a classic membership database. I need to create tables to allow my users to identify with Facebook, Google, Windows, ... I'm not the first one to create this kind of database. I would like to know if it exists a website with samples, helpers or pattern of classic database design (in UML or ERM). Thank you,
There is not a straight answer to that question as there are many different forms of data warehouses. Also a data warehouse is a database so the question does not really make sense. The data warehouses I have worked with differ from non data warehouse databases in the following manner: A data warehouse keeps transactional data so that the state of a database at any point in time can be recreated. As a consequence data warehouses contain a lot of data as every single change, at the column level, illicits the creation of a new row. Data warehouses can contain raw, staging and warehouse schemas to enable the verifying of data before it is placed in the data warehouse. A data warehouse is generally used where one wants to be able to have an audit trail of the contents of the database. That's my t'penneth.
“That which can be asserted without evidence, can be dismissed without evidence.”
― Christopher Hitchens