surrogate-key_开发者

Should I use a surrogate key or use the natural keys?

I am building a list type to let users make lists of various things in my system. The list elements therefore need references to both the type and identifier of the things they will be pointing at.[详细]

2023-03-18 15:20 分类：问答

Linq2SQL database design: mapping composite/surrogate keys

Image that I have a huge database which stores threads and posts from different datasources like two different forums. For each datasource, the Id of the entity (e.g. ThreadId, PostId...) is unique bu[详细]

2023-02-23 04:59 分类：问答

Choosing a primary key,surrogate key, index in the mysql stock trading database

Database type: mysql Columns: Date,time,price1,qty1,price2,qty2 time will be in milliseconds number of records approx 5.5 million for a month.[详细]

2023-02-01 15:32 分类：问答

Surrogate key in 'User' / 'Role' tables for desktop app? Whats the purpose?

I have to add some security for a C#/.NET WinForms/Desktop application. I am using Oracle DB back-end.[详细]

2023-01-31 07:05 分类：问答

JPA, Mixed surrogate key with foreign key and sequence number

I\'ve got two tables: DOCU开发者_Python百科MENT -------- DOC_ID (PK) . . . SECTION ------- DOC_ID (FK, PK)[详细]

2023-01-27 07:12 分类：问答

MD5 hash as artificial keys

I\'m seeing lots of applications using hashes as surrogate keys instead of plain integ开发者_如何学Cers. I can\'t see any good reason for this kind of design.[详细]

2023-01-25 14:02 分类：问答

Database Design - How to enforce a foreign key constraint on a table with a Surrogate Key

My table schema is something like this 1. Master table : Clause Columns ClauseID = surrogate pk (identity)[详细]

2023-01-18 08:30 分类：问答

Relational database design question - Surrogate-key or Natural-key?

Which one is the best practice and Why? a) Type Table, Surrogate/Ar开发者_如何学Pythontificial Key[详细]

2023-01-16 15:24 分类：问答

Can I use an assigned, natural-key identifier while still allowing NHibernate to identify transient instances?

Object A has a one-to-many association: many object B. When I look in the database -- TableB -- I\'d like to see the unique, readable string A.Name instead of having always to join or subselect on a[详细]

2023-01-04 07:27 分类：问答

Loading Fact Table + Lookup / UnionAll for SK lookups

I got to populate FactTable with 12 lookups to dimension table to get SK\'s, of which 6 are t开发者_如何学JAVAo different Dim Tables and rest 6 are lookup to same DimTable (type II) doing lookup to sa[详细]

2022-12-29 02:10 分类：问答