I Dislike Guid As Primary Keys
Damn, I'm currently pushing a small SQL Server application database to an Oracle datawarehouse.
There are guids everywhere, even for a two rows reference table.
This is just so unreadeable and unconfortable to work with.
Try co-working on that kind of database, where you have to dig into the datas to understand them, the design flaws, the weird things and stuff.
"Hey fellow, could you look at issue number 22503752-4A21-4959-9E3B-0008BB855495 ?"
Of course it can be sent by mail or chat, but when having to check douzen of keys per minutes it's faster - if not using guid - to just speak.
It's way easier to use surrogated key or codes :
"Hey fellow, could you look at issue number 5345 ?"
"Hey fellow, could you look at issue "ABCDEF" ?"
It's even funnier when you have many foreign keys in the same table :
PK1 FK1 FK2 FK3 FK4 FK5 Value
------------------------------------ ------------------------------------ ------------------------------------ ------------------------------------ ------------------------------------ ------------------------------------ -----------
64EAB463-0D6C-4754-810C-AC5422211C9E 022ACDFC-32C3-405F-B1F7-40ECBE2F2FDB DDDC5C32-5A56-4A6C-AFC3-18B96EC4FBE7 87A95F3B-AA6D-4ECA-A98A-0852BE6AAFF6 B94DF341-26EF-4401-A86A-F8997045C473 9D1A533E-58A9-4329-8244-3CF3174673B1 1
641D32D2-2D02-400D-B7BB-EEEF480942FF 8A2B5D84-65C6-4EDD-B3B7-8C15B0A0952D 7E0ECBD5-2D4A-4E40-B9C2-D5ADB783D4F0 BC707299-2B38-4280-B924-0CFD18F7A835 0D01648D-4B34-466C-84DC-68867071446E C4BF20C4-6D66-40C7-8FF4-9ACCD3123615 1
C772E1F9-1F8F-4054-A84F-7618EA53E655 49AAA3AD-9712-4C2F-A4E5-2F7DAEC9D7F0 627F44A1-9CE2-430F-AF44-32384E790C99 100EF1B4-98BF-459C-A353-2AA26BAF6481 865786EA-7443-46DF-AB7A-391832229E1F 93845C65-732A-4A41-A7B9-74E7A833E6C9 1
FD2A936D-B64E-4AE3-A607-A851685641A0 E1FC677D-E286-43B0-8F4E-A65BA943C26D 1AEB2CA7-7E20-4297-8430-59E4E28339DF 2EF24010-5227-4C08-B8DF-EFE232E7C5F7 03BCFD8B-F1E5-4C27-B454-BEE4B8BD30D0 8CD40989-89FC-455B-8F39-1C853A9AF0E9 1
4E49572A-3CD6-4D8A-91C5-31D1B21F34E8 6BC1D516-A498-4453-A09C-E78329827754 5E9108EE-AF97-46C1-A0C3-60ED8CB6BCA0 9FBE13BB-96BF-42F0-8437-57D036A6CC99 C6AF90AB-C36C-4AD0-B76B-E723D481E66B 6E8D3FBD-286D-4046-8016-407EE95E3806 1
7C6F61DB-5BA1-432D-83F7-7B6FCD50FC7B 7E63D566-05F7-47E9-9C43-A5A841B9FF0F 79AADE1B-4BD6-4BFC-8A65-731A2F053D47 1097439C-3CE4-4DAC-89D6-CC15A601B8EF 9F422EAD-B49B-4151-9B28-10525E457406 8CFB9731-38A9-4512-B691-B192038DBC1C 1
5BECCF93-53BF-424F-854B-D89057808C2D B9316BDF-29E5-4515-AB6F-EF6EB39BB310 6C3C685F-9598-4DB7-AFF5-F15615F17F6D EE3321C4-2F75-4D61-AD50-7D70A2A5EEF1 63A21FC1-FDBC-485C-8371-205251CC3398 30C540FD-7CDC-4E0F-80BF-3B7E47A78B48 1
F48EEDB5-5862-4689-8829-41DE9A4B7A97 D9C04677-616D-4B5E-B4EB-5F1D14CA85D6 74495194-3E15-4BB1-AB95-C6BCC35C82AE 880564C2-0BFE-485E-95AE-742286ECB5D4 638E2827-F49B-42FA-AA3C-806FC0210835 19221835-8BE9-4845-AA1F-AF13FC22DC4E 1
4E365F02-A7E8-4669-98B9-AD24BFE919F4 D09115CF-C9CE-40A4-BD29-801405C9B418 AC6708F5-1009-476C-B7B2-CD1A54C736DD 81996970-2BD8-48E2-B089-B511D2725DC9 DD865B41-9CEF-4F72-A648-478DAFEE043F E4B97884-1A71-4F00-A0F0-359FBE36FEA4 1
1F80E7A3-8E90-47C6-AB1C-43BE9A88C2F7 C73F8A6E-86DD-47A0-A2A7-E1B23C1A7ED5 E5218561-66FF-4F3E-AA42-B65FEC5D0CF1 7902F8E3-2C2F-40CF-9852-127D80296668 24BF2FBE-BA0C-4896-97D6-907348A0B649 A783BE75-B553-4B71-8FE1-24E9F8CBBDE2 1
DD98FBF1-A042-4C45-B103-D44FEB72F57A 1BA8F315-C61B-42FF-B3A2-F13D6D555605 B861E602-3E9E-44B7-B784-B5983C49ECCA 024AD039-627B-4E84-AB19-8434867E16DD CF1DF3BC-E3BB-4BF5-89D2-12853E0D7B90 67DC4455-30F6-48BE-B053-4895D0FCFCA0 1
DD045B47-60EE-486B-B100-CCDDA4C6B2B7 8EE0E4B7-3719-4C17-8E7F-92815E161FE3 81510728-51BC-4893-A5AB-18BA5AA90EC5 A0C3B40D-8C59-4AA4-BA40-595313628DAA 92594EEE-1F15-4ACD-86F1-F1115FFC4556 712C99D5-CC29-4CC7-9500-92050834A21F 1
F94A8691-608A-4A48-AF8C-53C93E2711CB 3B3634E1-D52D-4C01-A68B-79D284C0FB8C EB48B2A2-AC67-4EBD-8FAD-DE74DCADAFCA B2373D12-D1C9-4BC6-9BCE-12341DCBAD3D 92F8CA6D-8FE3-40D0-AEC4-035CC6D885A0 961023B5-17B6-486B-8AD7-49406B6D1C2A 1
A50D40B1-1664-45AD-A64E-0EEBFC52EA7D D87EEF1A-2AF9-403C-B092-40CE04377012 BEE7E91C-2A19-4D8B-A2EE-577583A9725D F06CDBA6-C3A9-451F-AE28-134CDC56AEA4 F28B690E-FDE6-4FFD-953F-88878D107B90 3E3FF488-1C63-4149-B116-7E527EE3AE86 1
36ACC8DE-0988-48C8-A202-650981B744F5 7296BB42-EAB6-490D-839C-B436ADA666C9 5E17D671-2B9B-4320-AB01-2206769D0DB5 538E76DD-C9DF-4D93-BBB3-C9BAAF3BD6EA 86079B22-5ACC-45BD-84E8-00EBE8F95CB1 84C138C7-A936-4549-BE70-06F0BD83BCBE 1
01504A76-793C-4248-8A84-248455EE5863 E52E1E08-CBDC-4637-AB10-88F3BEA13772 7B7E9F16-22AE-41D3-88A3-7F59852CD497 DCD67018-6816-4624-9930-F19BD77E27DD 32267BB7-534D-420A-860E-82971A2F9DB6 DCDA64DF-0EBA-4022-BDB6-7F899BBBD799 1
B174E576-B27C-4BEF-82D6-D7C6A2848482 F85BC677-71AC-4040-8EED-DB122CC1D054 4724D111-233E-4A51-92B1-C3E445CFB096 0426AEC4-1BDC-47E2-B2C0-99F57C7555A1 4058476D-B35F-4E54-8E10-769FF520AF1D 3AD22A4C-5D6F-4548-838A-4C4A34DF5329 1
310A7E47-D003-4B69-AD90-102CA8D36CE1 9507D289-2E3F-41ED-BB82-A4CE42A79ED6 9474EDFB-BD28-4635-BF21-3FE4963CC68C CA16F6FB-49BB-43AD-B98D-2D819336EB7A 427F9590-A197-4096-B0E9-45BF7C79C2AE FA5DCFE6-3B3B-46F4-8B9D-680A3E048025 1
FB636CAF-098E-4451-B026-5A1B6A896DAB D84E444E-2D49-4DBC-A807-B3170C50A054 6B40DC68-58BE-4F75-B2E2-FCB9E61B4F64 92C097B6-C1D9-4C1D-B40F-0FC89925BD37 4A7C4DEA-20D9-4E49-A544-72E5B85C81D9 92DBC3EB-108B-48F7-A297-215610D02532 1
FCA6DDB5-A1EE-4D36-91CD-50A20A6C2D63 E00044B4-AFD7-4CC7-B133-3E6344761958 361E6C60-4F2E-4BA7-99D2-58C3B50493D7 997A2604-9EC9-4AB7-B176-1CAA64F9B516 69A0F600-A18A-4B43-BD1A-3F4E87B99C35 B5E392C4-5C6A-41C9-AF96-C4AA7A8D2A99 1
10139C18-C3F0-49D0-90C4-5C68ED18AED0 015E186B-ECF8-47D0-A438-567CD1D533A6 47570DE8-87F9-45C8-AB5F-6C8FE391B2DB 414AB3B6-B35B-4D33-9268-0652BFD51FBF BC1846EF-CCC0-4833-8986-DA490FB68805 F662A883-589D-4667-ADC3-185D0ED2E04E 1
09D9235F-4C69-442D-AAE8-3CF77DA2F121 DDA9B2FA-D1AB-43CF-A58E-4FC6CE5DD557 EF6751D2-9249-4284-A35F-633CBF9D5E36 27EC06AE-DF39-4F11-9CE1-B516E3FB2B9E 371E931E-9751-4A78-A051-CCE2777512E6 206B727F-9470-475C-B938-EACD73547A28 1
A0C4AF10-A61A-4957-BA1D-34D732ED00A4 31590F4A-EC06-4CA4-A85A-92F23EC98FA9 F48C453D-8BD4-4042-B4F6-8DAC70362329 B46EBB6A-A5CA-4656-83D1-D591444C304D 04C0317D-6D72-49BB-9644-4FB0A7257995 DA7AB460-A108-4E99-BD42-B6BF2A39DA51 1
DD4543A0-B680-4D2C-A898-769BB329D0AF D2B60EA0-4B36-4AF8-8A00-0DB6E341B2DD 90C978A7-87AF-4367-A662-F93F694EA895 25637097-CB0D-43B8-9282-3C19104A5260 8E97A74E-B867-45C2-A4E5-97D0984553B3 8724ED02-C7D9-4E74-8396-148EBAE511A8 1
B0372EEE-0CDE-4C28-84CC-3727DF72B90B D8453F83-716D-4DD5-8B88-549FB2CFB9BA 35B4CCB1-FE24-47B8-9FC9-819675E29E17 513E2346-4406-498F-A95C-C8C0261664A5 9A019981-C1F2-4181-ADBA-9DB1D24330D4 9E147FA9-0B0F-4631-ABCB-31C2D535C2ED 1
49FBD4BA-D817-470C-94A3-F9F9491F8EF4 22156026-03A9-4A5A-90E4-67A9129D1133 690E9FC4-54F3-4806-B2E0-1516B01B6254 E9E2D065-6289-4E10-AA7E-8AB429F29BFB 2CF75D4E-117A-4D97-BA1C-274C3D365CE3 973F83A0-0C23-4992-9D2A-BE57847AFF14 1
9823B9A6-F95B-4576-9FB9-6E7A2FC30549 AC12A8A4-B729-4E17-B677-EAAE48A5DCE3 8042678D-85C7-4387-8B03-EE69FD32FE1C 914B4CC1-289C-4C01-9428-58339C8F66AE 5931610B-0394-423F-AD3D-4FBEB71AF582 01D34DD7-DB47-4D4E-B5DD-F5B3E038B354 1
84689597-DDA8-42E9-9B9C-13E33D01647E 0C0167BD-FE53-4B0C-923E-2DA32A80E43A A43B80BF-0804-4C3C-9777-FBF3C7B419AE E9A5EC39-FBD9-4F04-A13C-F42D72C924F3 5DD488B9-0F49-44DB-B2B9-D2A9F8E4E25E 49885B75-4636-40E8-8718-903010E640F1 1
E6DC9D41-D535-45DA-9245-0A05C13529AF C491ABE8-1018-47EB-B07D-55BD5B62F72C 6AA80299-384C-457A-911B-CC4529885C2E 112B3657-B32A-41C0-BBBA-1194D71AB68C 336C600A-D9FB-4C53-9816-FF0FFD56CB38 04D64383-8004-4CDF-8E4F-14D3EC1D9BB5 1
B9B3056A-BD14-4A09-BAB7-69B42BD50AC1 EFA53AF7-DF8F-41A9-BC5E-70BFBC6AE704 3EC1FC26-AAF3-4870-9957-B354C8D23AB9 2CCEA291-802C-4277-910E-B79749042343 F2EE219E-92BC-4CBD-B4E6-8E63B67F2C72 27547897-35C2-436E-AF8E-EB641C66A82E 1
05C3EDDD-78DF-41BB-A007-3B18B7B64A9F 6C102A0F-870D-46CC-8FDC-4FB629A2CD8C 64194AF3-755F-43E3-8062-3042F69E588C 0FA74C28-D80A-4A2D-9400-24517FE94642 5AE3EADB-82F2-41E1-824C-083163C38ED1 EA3C13EB-4F0C-4806-8BBC-599A2A81425F 1
That's so uncool. Don't use guid for any local application. Please.
This entry is filed under Serious. And tagged with Datawarehouse, Guid, Oracle, primary key, SQL Server, surrogated. You can follow any responses to this entry through RSS 2.0. You can leave a response, or trackback from your own site.