Search code examples
Table design for an ordered tree with composite keys...


databasedatabase-normalizationcomposite-keysurrogate-key

Read More
How to populate fact table with Surrogate keys from dimensions...


data-warehousedimensionsstar-schemasurrogate-key

Read More
Should primary key be auto_increment?...


databasedatabase-designprimary-keyauto-incrementsurrogate-key

Read More
Lookup Table -- Natural or Surrogate key as primary key?...


sqljoinlookupsurrogate-keynatural-key

Read More
Is it possible to have a natural and surrogate multicolumn primary key?...


sql-servert-sqlprimary-keysurrogate-keynatural-key

Read More
ID Best Practices for Databases...


sqllanguage-agnosticidentityauto-incrementsurrogate-key

Read More
How to replace primary key with surrogate keys during ETL?...


sqletlprimary-keysurrogate-keysql-data-warehouse

Read More
Formatting the surrogate key based on other columns...


sqlsql-servert-sqlsurrogate-key

Read More
What are the disadvantages in using IDs suffixed by a table identifying number?...


postgresqldatabase-designprimary-keysurrogate-key

Read More
Using Surrogate Keys in Data Warehouse Pros and Cons...


sqlperformanceetldata-warehousesurrogate-key

Read More
Nginx caching: tag-based cache-busting like Varnish Hashtwo...


cachingnginxvarnishsurrogate-key

Read More
Surrogate key 'preference' explanation...


sqldatabase-designsurrogate-keynatural-key

Read More
How to avoid mistakes at Primary Key...


mysqlsqldatabase-designprimary-keysurrogate-key

Read More
Use index or replace values by surrogate ids and add a separate table?...


mysqlsqlnormalizationdatabase-normalizationsurrogate-key

Read More
Surrogate Keys in a Data Warehouse...


data-warehousedimensionalsurrogate-keyrolap

Read More
What are the type of data problems that relational databases have when they are designed using natur...


indexingdatabase-designrelational-databasesurrogate-keynatural-key

Read More
Thoughts on using email addresses as primary key...


mysqldatabasepostgresqlprimary-keysurrogate-key

Read More
Using single column table...


sqlpostgresqldatabase-designsurrogate-key

Read More
Relational database design question - Surrogate-key or Natural-key?...


sqldatabase-designdata-modelingsurrogate-keynatural-key

Read More
Avoiding Polymorphic Associations in Rails...


ruby-on-railspolymorphic-associationssurrogate-key

Read More
join between two many-to-many tables...


javajpadatabase-designsurrogate-key

Read More
Are Varnish Hashtwo/Xkey and Fastly's "Surrogate Keys" the same?...


varnishsurrogate-keyfastly

Read More
Database design - children of join tables key choice...


sqlforeign-key-relationshipsurrogate-key

Read More
nature key vs auto_increment key as the primary key...


primary-keyauto-incrementsurrogate-key

Read More
Handling Database History for Banking Accounts...


mysqldatabaserdbmssurrogate-key

Read More
Surrogate Keys complicate insertion?...


database-designforeign-keyskeyrelational-databasesurrogate-key

Read More
MySQL - Trigger - Before Insert and using the SK (Auto Increment)...


mysqltriggerssurrogate-key

Read More
Adding Existing Index in a table (which is made of two fields) as Primary Index? ax 2012...


primary-keyaxaptadynamics-ax-2012surrogate-keydynamics-ax-2012-r3

Read More
JPA, Mixed surrogate key with foreign key and sequence number...


jpaforeign-keyssequencecomposite-keysurrogate-key

Read More
LEFT OUTER JOIN causing violation of unique key constraint...


sqlsql-serverouter-joinunique-keysurrogate-key

Read More
BackNext