SQL-vs-NoSQL-diagram.excalidraw

==⚠ Switch to EXCALIDRAW VIEW in the MORE OPTIONS menu of this document. ⚠==

SQL vs NoSQL — Data Store Selection Diagram

Text Elements

Data Store Selection ^title SQL / Relational ^sqlLabel ACID, schema-on-write, joins, normalized ^sqlProps PostgreSQL, MySQL ^sqlExamples Best for: Transactions, complex queries, relationships ^sqlBestFor Document ^docLabel MongoDB, CouchDB ^docExamples Flexible schema, nested objects ^docProps Key-Value ^kvLabel Redis, DynamoDB ^kvExamples Simple lookups, cache, session ^kvProps Wide-Column ^wcLabel Cassandra, HBase ^wcExamples Time-series, high write throughput ^wcProps Graph ^graphLabel Neo4j, Neptune ^graphExamples Relationships, traversals ^graphProps Choose based on: access patterns, consistency needs, scale requirements ^decision

Excalidraw Data

Text Elements

Data Store Selection ^title

SQL / Relational ^XbAuQMas

rows | columns ^1CvCcUyJ

ACID, schema-on-write joins, normalized ^VMFopldZ

PostgreSQL, MySQL ^x960nufF

Best for: Transactions, complex queries, relationships ^1Utp2aRn

Document ^uivTOBCT

MongoDB, CouchDB ^alBS3KUF

Flexible schema, nested objects ^LtyfSfZs

Key-Value ^kv-label

Redis, DynamoDB ^okDeLs8c

Simple lookups, cache, session ^kv-props

Wide-Column ^wc-label

Cassandra, HBase ^Hdtmmd6a

Time-series, high write throughput ^wc-props

Graph ^Ub1HAhUB

Neo4j, Neptune ^Wnhm7V4d

Relationships, traversals ^8NbLZ66k

Choose based on: access patterns, consistency needs, scale requirements ^QE3ZDZ4Z

%%

Drawing

N4KAkARALgngDgUwgLgAQQQDwMYEMA2AlgCYBOuA7hADTgQBuCpAzoQPYB2KqATLZMzYBXUtiRoIACyhQ4zZAHoFAc0JRJQgEYA6bGwC2CgF7N6hbEcK4OCtptbErHALRY8RMpWdx8Q1TdIEfARcZgRmBShcZQUebR4ARniaOiCEfQQOKGZuAG1wMFAwYogSbmg1YJTiyFhEcqgsKGqSzG4eHgAGfhKYdu6CyAoSdXaEgGZtToBOaYB2ADYE6YWe
 
AA5pztWeyEkEQmVpdoBWHegm8oARXCjUAGUoNkD7tOwodi4zgDNOKDvCIziXgDGoQH5ZABiuH0hHwfTQCTOjUwUAAgkRlFwJGIskwWpBGKR3u50QcsehHnB8RBmFBSGwANYIADCbHwT3KAGIEggeTzqZpcNgGcp6UIOMRWezSA1yBxmHBcIEstSvrD8A8YFUJIIPNTafSmQB1EaSbiIwYQMWHDjhHIIs5sRXYNTw1AJTogkp6LK4Qi20gASWI3A4
 
Qnw+EdpAO/oIABULhJrrcHk8EC9gm8PtTcEJHgAlcIAoF0oQIM5EW0ACX2h2aCPip0thNYnHaZxbHwAcpwxNwFtNxgkACw8Y6JM7+4hYcq4TrUwjMS5pRohtBfAhhM4GxkITXa9C6spnazKA9egQIBBr91nUXCODB+2oXIAXW+5AywdD4cjlrFEq2swz5hhGZyaMIEoAKLBBkWTPm+ZxCHAxA3Ne5pzHMw7DscCRzCOazDhaoKVgyP5gZakihAmK
 
IADL+mR66buWlrssK6FMfgW7/pQNH1ugEAFAAvj0RQlGUOoAI74M4EFtEi8BAlaCBvKeVRnG0aDDheEBunMOnDMQoxoB0Ol7AcRwmV0250ruUochI3LzAk2A8AKQoigBkpsg56CcggcxfMcXxfKq6r7kpR4hjZhoICaRlmmg4xnNakhAc+xElE6QquuanodkwrbknwzaFd2vZAmsaxzOM0zHOMuGThKM4SLgCQLkuK4cagG5cSxoI7kyEXlFFOYc
 
GeQI6WE3WZZA97IU+eTvpaXyfgg35oKBf6gl56XkdtJQQeKxAwekmTZEtSEoWhN54VhOF4QRREVgx+1nFRzB8fRHCMT1zEVmw7E3r1YTCaJloSegAAamiokIACKACyoTUnUSnIs0GncMcTagm6awGaa5rjHEawkzwmwLMO0xEdpCzvbWlnAkiiboHc8O0agCioIW+A3B8BCqr8/yAua9Mrb8UIwnC5osyipKYuUOKNDKBVEuYBAK+S0BOvqtlMvZ
 
MqOcs+Gue5wrzRKhuytYCpKudYURsNOpsselqDXFRMOv+wg2nasuWtlLqwHlOk+lE/pMBtqBbVGMYcPGrMQOznPc7z/OcILJ55mwhasKLaClv1JSVggNYWfxSRjmrRXtqVLDlRwfYInM44jrhExNdOmnoLgbmTp1wSrtwIPFwI+t7rAB40q70WWmpk3blet13mKj7EAhy2gqt0LrTesc+8de2bb+4GQSdsHnZvV2ocPLf3bh+HDoRs0QKRb2UdRT
 
Tfb9o8A0DI9/o8QoHxcogligiQKGJSAkMaTSWcFETQ6lLRo3KIEVS41kGgh7gTM4boEgJHFqCQyxl3TaQZhXbg2EYp2R8kbPyJsXL90tIKC2XlraOWIJ0BAmgQqOw1FPSKs89axXiqQ1+qVj63kDs6XKCJ8r11riZGujdm7unGJ6VuCw5jTFflOFqvdxgdWXEPbqf93YT2doeYRJ5MGL3dsvAOoJ5rr2vitNa0cD47XPlIrxh1z6nTghdNAiFLTI
 
VvjNTC2FH5PVfu/E+FFQQfS+q9Ti3ESKAyZMDZiYMoEQxvBABIzJ6DMmwAAVRgAAKVRopBoFwsZoE2Hg80PAiElBIYlVAaw4iejWMcSm0xumjmWBQus5pcYlAxmgtgFBmCoAAD6oD0L4fQ8ohZZBFkCBIJVt6S2hLCfBcs0QYm1srPEatiSaxOeUGExBiBYJKB7DhDDnJm3Ah5S23lpQ23lIqZUmMVrhUESNGxFjRFe2kd4vwaV/be1BEHOR7oFG
 
gnDn6AMnjT6B2jP4ROKJpmzIWUstkQhVk5GzgWIsBdUBFxetWRmldGwqLbMoxRqigT6SIscNYEw5hdwMRAXAw5jFdWyX1GhQ1gUuz1LYia3ApqOLhSUFxi0QlbxKDvL8+9MVQsArCmO2r/HHUCVfS6YTrp33dFEh6T8X60t+n43YX86KpL+mK1imSzFAJ2rxJO4CwCQOKNA0oBSABqiMIROnwMQAAWjU+oEgpkNNQDjZpLcdntIhRMJImEKadHGN
 
hHg4xulrFGUzDRRzyiomZIGS41BUDMGwHsfQuBnCcGcBQaMjQAA6HAABWbB/TMDrRwJ4zaiCAjnrsjZxYWnfD2dLQ5KCmhayVudc59dLn4BXQm3W4qWR0K5Iwt5LCPnsIPQmuUdt/n8KsTPaVYLdxiM6RI32MLgJOKyrIkO8iw6/DRVHLViSsrYtjPgUBEgq01rrQ2ptLa20drUAgHt/bB3DtHQQYsk6Si5gpfnEspAyy0rLvS80jLWXMt4EyjgP
 
Ym5AmHKsY4nQuXJQhs1HuArjjCtMaK9JjzLGSusfe0EC85VLxmqvB8KqXxqsgBqveH8dXEF8QayAR1oKX3gqa0E4SboYQfo9Z+z1WIuodVIJ1UAf6ALdRkgBaSx5Wh9XiiQfqA2FHyeUTAKxOhhi+BCON6N6mWh7imy0bpEjDjOB080CRjjaG0sORYgz5j0ZmBFyiJGEQTNqEnAACmwWkoo9wczrYjGAKd1l/BnQidNsn50HI/dl+W1zsRrtVhuj
 
WW7msUl3Q+g256Xmm2YaCVhnlz7POgJev5DtvhAq1EIoTfHwUJQa1aV9UjX4Iu/Ui39vpI5BkAwdSATx464v4hAPLBXAgpxK2VjmOYc55yq9Sgj9nS7lzGQ2au5HipUZo2oiYrSi14QnKx7us4FhcYQBa8xA1+NzZBQtyAIm0DyvE5aZVG8tPqo8QdlKPi9WmbUxfM6mnVU310/faJBnbXGZ+gpkoyTv4uphyXD1PH7PkBAb63Jgb3MSASGU2QPB
 
cD5k+Cg2pCbAvYOxll3S7RyGWii5lhY2hxgLCB/VToixgelv4jwOY2hZdTIkAAIXCFAHqTw0BxkvUKd4nAh09r0PoHwWBUCSTLNGcIdbAh83t/KSQhA5AVc2dFudkJ9ky0VY145ZJV24ja6CQkm7t3dapHu8bTlBvm1G8dcbdJbZTZVDNp2Am71u1h0t8RePoXrcdF+/ByLvR/r2xioDR2QMJzA0nM3tJLekGt7brMDvqBO4MK7zA7vPeEG96gX3
 
GcA9B7JfPB7lL8OEdp8Ryhn3ZedgozVhgZVOB/aBAOHCcwKYjNB/y3AcxIfQ69Yt3ct7RoyvPGJle6O15SdCdvHH9PIBdoCcVMIAidjVSdpNycLU7oqcbUjMSITMQDGdnU6c7N/4skrNeNADHMzsXNwZQRYFiBAZZI2B5Jxd410B0Eog7FqQe4SYdI9JCZlsTIm9dgMtUAVgM9+sIBOQeAvhpgEBsIc9PlM8eEvhNArwb0y9X9etPZmDKND4/Z31
 
o8IBNtG8dI98ftvsT8WkRwFgFhOgEsWMCC2NZw1h79PVrMn8JV4cpUK9sMaCUcP8VsMc3E/9d429DtVsj5gD29QCAkNNglICzUIlborUYlDM4lEC/DkCLNmdH9IA2IMC7Mec3MCCCkhBCB6A4wAB5E3ZkOMfzOpPFJNcYctULbgXBRXCFKmbQVYcYLCaqHRCmBYKqXXDCQ3CtJMQGElabCWadKlEccPKAKWerFQjGVPCAM5RPEoZPDrSYykERWhb
 
5RyPggQoQ95NhMbbggvX5e2YvQFUvWwwTew8eKvZ9GvJQjKevHKLbD0HbCOdFXHLFE7bvJzdAS4HooJe7XDJ7GlTfd7JmKuXfI/LQpPUEnQ6rFYRjMmaYPldjXAaYCw9nPdF/UFYTRw1AVHT/Zxb/THMndxDw54xTZTPwsAwItwkoHTaA8I6neAkuaIrw2IyzNA91WzV1LAhzLnd4iAPAvJdI2cfAE3O4cYAAaTKT8wUgoPOBKKC24DKIYLyjaSG
 
EzW2UN00VWEHBpnqm2XaMyy6PQERk4GUDYEuBNzrVZCEEbTNJDye11P6JGMj0XVBAmK6ymNa2pDmJJDdMWK4JWL8jWMEKFU2Nzyth2Mm32IBW3lm2nhkMr0fUzUuLfWuJkVuPULOFRVb2JOA1ePA0NONNNPNNQEtOtJNx+NzjX24H+IQLpW33dDI3BIbn31+wqn7E6G6VmBmF5WvwRNRGRMwPsw9jRMRwFUxOxJcLxMpNk3/wSS8KAOUP1TJICJJ
 
yCN/ypPNUiX0zgKiNQMXKZPMxZI5NezZwHJShwLAVSKDVgVolgC+DuC+GjWXxdIlwpCl1aHlPKLxmJiYPEQHEN2WAHE2BWG0XmD1PUW0FbgNIgAhGCEwEICQXTBg3SFwGHXN2vFQDsF7RUgumGNDwRFfnBEdIXRW1dLjxawT09KYBTx9J63jL639J4MDI2JPS2Lz3DML0jKkOOPLywzOITPkJfVrz1Q2wb1DgzJbyeIANUM71O3KBgqwHguCHrUb
 
WQtQtpHQswuwqfOw1XzwyrJeyI0BIZS+0bKUQUNMrZX7CWGaISDJnhNnDLIHhMSh0sM5KHOkPRIcNlScIcTR1xMk3xOCPcM1SkvnJAhAPJJXKnIgGpM3NgNiTtSkuZPiKsMSJPNZO9W5NwMvL53QAZHoBILIOfOlKoJE1KOsgqIRG6UiwhS6DMnYM4NkNEO0X0nnBDJEO4M5BCn4OIE0C4tjM8r4uNFqqTLr1TODnTO+zrgsuP1bMy1wi6Bi0HHs
 
tamZH7IyusMnm4rjK8vf18pxKVUnKx2nKJNCvxwXMJ2XKCWitirCK3IStp3tSQIPJSs5KSNcoQByoFIkHyucD5gkPwCKMl1lOlySk/N6HNGmAPyV1QFqNHEwgJhiwmG0SvySXYLwk6KXR5NFIQBgGcBDQIDLFtMGLSynSIrGMhUmWXTdOmMovVm9LIrTyWPot8h4IQBas9GELPQYt2KvT6OjKOIGpHI9ifRW0kWEpuImrEstEzMktnLjhxTeLOxx
 
rxoJt8CQHJQrL0sLgMoBPRobNmNBOmsNqbOozmstVqiwnbOqhWt7kuHWqPNRI8pHORyxOcJUNcOOrBBnL3Jr11QuoiqupNQJO0w3LuvisiMSvls/k+iZ13JZzSvZITq5LzN5K+vEgKUZGXFomYDWGwCBtfJBvfLBsVJMlspqoEs9DqIJjPy5U0W5QP3Mg+3dCNyTkLEcCHVQEuBgATn0ELOJq2QP0ItGKj0ppj0mNpouXmJovTyas6vZswk5vau5
 
tZt5qLyjPVRjPm1OJpAnlFpUPFoXJErTOlpRQkoAykuO0VtTvbsXDrW7t7v7s1seypWrIZNrObuBKo2NoJAhPNsIUIg0QmAaNtoFSggduTvcu2sGtHO8rdv2onICuirk08L9qU18K8Miuuq9tur0wjppxrKepiJevjoSLfnSsduAVTr5N52+ryoKrgHpGDylICyLsgDoPBsgDC1HArvES5SmAagboaOaNAvSzrImAgtbp5P+BdyUvZEZGQk7rwBU
 
ugztGzFwrtIIrq1HtflIsVnIpVjpuosZp1lnrov3QYv8g5rapYtDK+VXojOvRLwEWgeFr3sTMUOTJWzUNPub12zlt9peOvqThkdd1QHkYZEUbrWUb2FUeAnUZX1+Nft1prK30/oNt/tNp/sP1NshPUVaW0jWAHFl30QRMlIhkHhcpRNkOHJ3tdvHI9qOpDux1OujpJIwbPiNQpJwbDrwetQesIaSpId/jIfeuqcyuofTpgQKQoGwEKoLuUgwVlXK
 
tLt4Bpl4c6TqrAsavMcz20SImICROXu2Msa+HGC+E6D4Wcdqd4t3vOOycPpTPhVEp/W/pZRmrNto0huAvzWqmMPElMNagAHEIGyGoGha6mxz3ax6IBPbmmTqQq2mSgwqpKsHg6gr1zQi+mIiCH36iH9zY6UCRnUryGk6ckIF8CM7yhZm/rcAAaFnE05SS7U1UANFSaM15C5g1g6jBx8I819cnp2W2DxGDcpGzt4oEBnApQSUxcya8KyFhiR7nSqa
 
msTHJ72sGb9Gma/TWbOR9mEhDmuaTmHGOKnHDiXGIXbmRaPGoUrjvGXnttxL/GL6kWO9cyk4JWpXiVVlyyX719XtI4jLSMTKTazKD9NC8nqZmNC1hx/mYFAXe4qxQWSXwXt7bn6noXX44WMWEX5NXXvD/bwqlyumoqemsXKd+nI7HqhnCW4jSGSWxnTyqHucKX+SqWJAqwjJ9B9BiAFhcAGW3z2GPzVmFSNm8oDcimmjsIRwtgQ3hXP6xXyhmRQh
 
mBrBPA60qwTdQgNaHT5X7SyalWSLqa1WPSp7NXtZfS57LH9XDXjm2KebHH+bN7Ba03ma5Dq9PGxrnmT7XmZbz79tL6ZKlal2V213yAN2t2whfXKydaN9Umg2d83nzLQ3LK0BrLMJlhlqezZxAxk23K4dLWxo4GGmYXs21zc3UHD5C3UWg6IDyOYremK2cX6TEjGT3phmm2bNkjKGJmW3/VKXpnqW5nGGnRtLagXyZSN6h3mXKrWXjghWIAYbbKkg
 
DCintktgmN6M2ixHP7JhIKsazs4xCAMhnAwgvdO7A9DhUAENGhqVJBUo4A8wB6w8HTD3xjj2tX3SKKz2rkTHL3dnOqb2jnbGOqH3TWn3ZMt6Ecd7rWBLRqJbxrEV7inXHiXXAn4UgPU6jOTOzOZ8LOLJrPO10x1AHOnPn6YPns4P360mgSMmcmw2Wyvm0BcJaoGj5gSmE2BVqknKRVOPNqbmiO9qBoFVSOmmc3vbWn0vkXzqi3MHaPVyZMGPy3LV
 
7qq3Bn83kr623qKHk7OdJnW3aH230BRRcA4BJB5mWG0FsKyqmXWWKqvytItgx2WD6q6ydnNrM9sAoa+5+272wzTmQpgpONrnnaYv3H5CD9Hn7Wf3HWpr3mUPZqmvk1Wiqo6oKZQHcBRS8PByCPX2397Fhu/LDqkGvaUHszACZuaOS3sH4WluKcVv8GWO342OY6UktvjyyW+opng1ygylNAEgqxURJAylHLyDWGpOIAOHVmiJlTFOIVtJ4hEhCJW5
 
808IVg4SdOgTRWoKgXyAzvnOEQFPh6nSj3VXPP1XGzjHPP/OPvOqvvhdhcjX72TW9izWBaLW8fZD96YWoeVCfHf2z7nWAP82r7QNU7dfTuzRyvtbKuA2P7au536vsx4fMmio8nZg2Wao7LsPWpaJsenbXHIXiPM2JMFpAr6OyezqfCA7i31NS3afcGmO6Sdz8X2Pa3Dzk7G2NrsCsqLyDu0ijuIAjQOBJB9A5gQ1hxbnUFgaJepeWWC1nuukDclh
 
WkZgimSYG7Zcm6gTF2JAuwEA2Bhxe0619+4AoBxQd25W7Sh7tHlXx6abT2NXfPrfaLbfLH7efunf/uXe+aDj3eBu903vQSnaz94Otkuf7IPpRwy7useS+/Q/sf1QCn9z+toaDjHzfqsd4+xlEElkxT5J9Ee/2bSBhwRodcwcrURGPnxqag902ULBBo0xJ609K++bFFvmzRZ0dFujfBnpW1xYYDW+rPOOsS226c9OSe3Pjq5ivIFI1gXYTQLRGjT6
 
EyIl3GfrQWHbz99Ci/CYMOCmA4xZg7XLlP0iLRgUJG+nF0m3SCAL5mAgeOQHWgLwthNwBvd0FowjzEV3OZvU5I/0t7T0/Or/IahY11Yf9Hef3exvQgmzhc/+z7D3tFytbg8P2trLxqAJh7gDA+qXYPlNzdbBMeS6cf3OYKXxWDyANgriKgL+IpNquCHeson00LZMI2/9VpIsC7Ko0AWpA3uF2AoHmMAB88GgYTwOpzQxuFfH2qZmYEpD/C1PdFvR
 
w4EwEuBTPeJAMM24CCOe3HXbueWczc9YESoekBQFM7wIR0zAaSAsxWEzIlBJkAwiyzHA/lOkXKMClNAniZ5jg2AYKPoS/6BCfkv/CXmqBfYRC323vSHmtgS7fspaAfEoHAAHR0dBgYAfIDUGKAXhwRwImTCCOBFgAzhsIzoFCMGCLdaQSoNEKQFWF7BcA5PDABKFRAYiZkWIgpLsKoBIdw2f9JHvVHwjq4i0JAm/DkWaH9cqBg3Ano8hG5Ztuhi3
 
RgQMP6GXUhhbAqAnFXGEt8a2bPGYegQ+o2Q0RJuKcP6GUBSVMgxAGURKDlH7QlhBSeGFBHGDRpLg0aYcLGgUGF1Z+VCVZprkX6xs9OywAhKsA9C8st+6NXfugGZCSA2A+WdMIKDCDEAMKHANAEKDEDARUAioGQEwHlDRMHci4RoE3BgAxxl4ndBtAQHTCBAPchAQINgw0aDEb+jgimrow86uDvOT/TrJ4LMZv9dW1w24RDgCH55H2oQyLq8LsKRD
 
7mB9L4UfUlpJdWCUxf9lAJzJpCzszo10WEFQAeiNKPo1AH6LtCBibgKsUMUSnlARjMg2AaMbaGvBxj3AiYhAMmNTEmpo+hQqrhgJq5YCyRjXNRAOCWC6Ii0cbUoJ11wA5ZGR3g1oRiWL60DRu9A8btyL6GU8WB83G6ox04HMcRRG3Djt31JZzCyGIgnki5nABbwBUcAOAA8DQjcAxI0AJtEpAxBHAegDAGfBQC3asVv+QQrqt1SuYFApiIgf5IGE
 
aD6AHgsUTPHyF5CX9IA2AEiedDInpBsJdjKsSEI3rESMRTE8iRCCi71iWgXE0ieRMon8VSE6aISTxPSCiSbChHdCQxO4lZBmJ+gfMM2Keb0TGJSk8iTkTAFN5JJWk9IBGizGj0Jk+kqAMpKMmVYqU93DSYpPMnkS+IkxYIF8E4kKThJ0kqIESHxGYiQg2ZMycpKgh4iCRFAIkbOGCmCS3JUk/QN5JmRxgJOXkCKZpPsmGS1oqkg8H4hpDYB6QEYK
 
GNFmmDaACYF+QZGTEYwNFao6EhtNlPwAABNbgM4BVy2VRwuELzHmhqjwiSgRgV0foAQnNhCaWyQ3BsAaLHBUi/k8iapOr7PgC2WGWFtGGIDysbJM0kgA8AQBUhmu6E0UCQCNLThApdLYIOMy6EkBnkQaE3GyAKSkBlAgoAABSJBeUvAPCHWhul1pOghuAAJTUhCwygcMEqDQQXTcA108tLwABmFpugWJV6TQ1sn/IZJCAHSZkPpwTcMghYZqNGHG
 
g9TQQmQXad1HQFTEiAq02PmcF7r+tHQeYUuPpV3EQBm0pAJkKQC7C7xSZ9mCmVTJ2kIUbwRcEaZpTeDMA7gCcOAFtIQBMy9pfXAVFmEYBxhXRgNNAEGmn6HhXg/uakAxNpAGA4pFBUzF3x47Y4DAdwGWcnzVmJFQgaIYWQgFFlsg1R/fCAB3QxmshcQKIRGJkCECCzNAso8aDlkCBfAmA84pSOjOZmCTFwyoxwONH5mYyihpQZgIjBIAAj/Qfwbm
 
XADlEByWZL2cAAGjBCwhwgCEoSCACEhAA===

%%