In order to understand how foreign keys might interact with big data, we must first define what data do we consider being “big.” In many cases, big data would be considered any kind of data that holds more than, say, 50 or 100 million rows of data. Now let’s explore what happens when foreign keys are used together with big data. The SET NULL option offered by MySQL means that if a row in one table is updated or deleted, the column with the foreign key will have its values set to NULL.Īs you can probably tell by now, the FOREIGN KEY option available in MySQL lets us ensure that links between tables are left intact whatever happens.The CASCADE option offered by MySQL means that if a row in one table is updated or deleted, it will also be updated or deleted in another table too.data should not be updated nor deleted.) This option is a synonym to the RESTRICT option. The NO ACTION option offered by MySQL means that if a row in one table is the same as the row in the other table, no action should be performed (i.e.When working with foreign keys on MySQL, one should also note that MySQL offers a couple of reference options: In this example, we have used a different table ( demo_2 ) to create the foreign key on, but foreign keys can also refer to columns in the same table. You can create foreign keys in the following way (we are running queries with Arctype for this example): Creating Tables with Foreign Keys Generally, big data refers to a lot of rows – for a data set to be considered in the “big data” range, it should have at least a hundred million rows, and the values should be preferably distinct as well.įoreign keys, on the other hand, are columns that are used to link data between tables – in other words, foreign keys are used to link data existing in one table to another. Well, generally, everything in this space is very simple – big data refers to any data set that is so large that it is sometimes deemed unusable by a system. What is Big Data and What are Foreign Keys?īefore diving further into big data sets and its interaction with foreign keys, we would need to explain what big data is. In this blog, we will dive deeper into the correlation between big data and foreign keys on MySQL. If you’re reading this post, also chances are that you know a couple of things about storage engines, indexes, partitioning, normalization, search engines helping you secure your data, and whatnot. If you find yourself reading this post, there are very good chances that you find yourself in the shoes of a MySQL database administrator, a database-savvy developer, or even a sysadmin.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |