I saw a similar post on Stack Overflow already, but wasn't quite satisfied. Let's say I offer a Web service. http://foo.com/SERVICEID SERVICEID is a unique String ID used to reference the service...

I'm currently in the process of designing the database tables for a customer & website management application. My question is in regards to the use of primary keys as functional parts of a tabl...

We are creating a new database with 20+ tables, and our database supports: sequences. identity columns (generated always as identity/serial). So, the question is: should we use sequences or ide...

I have a single collection into which I am inserting documents of different types. I use the type parameter to distinguish between different datatypes in the collection. When I am inserting a docum...

I've read lots of DynamoDB docs on designing partition keys and sort keys, but I think I must be missing something fundamental. If you have a bad partition key design, what happens when the data f...

I've been reading a lot of articles about DDD and noticed that most are using GUID as their ID when persisting to a database. They say that GUID scales well and auto incrementing ID's are a big no-...

I'm trying to determine the best way to deal with a composite primary key in a mongo db. The main key for interacting with the data in this system is made up of 2 uuids. The combination of uuids is...

I understand what is primary key and unique clustered index my question is why primary key is required when we define unique clustered index. Just considering performance good database design. As ...

I have a requirement to store events generated by a user identified by userId. Each user belongs to a company which is identified by companyId. I have come up with a design for table in HBase as fo...

I have table 1 with a primary key user_id and table 2 where user_id is a foreign key. Only 1 record per user_id can exist in table 2, and no record can exist without it. QUESTION: Can user_id in ...