{"id":79702,"date":"2021-12-08T23:33:01","date_gmt":"2021-12-09T05:03:01","guid":{"rendered":"https:\/\/www.whizlabs.com\/blog\/?p=79702"},"modified":"2021-12-20T06:57:24","modified_gmt":"2021-12-20T12:27:24","slug":"what-is-a-bigtable","status":"publish","type":"post","link":"https:\/\/www.whizlabs.com\/blog\/what-is-a-bigtable\/","title":{"rendered":"What is a BigTable?"},"content":{"rendered":"<p><span style=\"font-weight: 400;\">Storing data within a database is a necessity for organizations. You might have the urge to store a mass amount of data for organizational operations. But you might miss out on an ideal resource for the same! Therefore, Cloud\u00a0<\/span><b>BigTable<\/b><span style=\"font-weight: 400;\">\u00a0is a one-of-a-kind table that can be scaled to over thousands of columns and billions of rows. It allows you to store around terabytes and petabytes of data seamlessly.\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">One value within each row gets indexed within this table, and that is known as the \u2018row key.\u2019 The latency is really low over BigTable but has a high potential of storing a large amount of data. It offers supportability for reading and writing throughput! Moreover, it acts as a prominent data source for all of the MapReduce operations. BigTable is accessible by other Google Cloud applications, with the use of multiple client libraries.\u00a0<\/span><\/p>\n<p>In this article, you will get a clear insight into what BigTable is and how it can help organizations thrive.<\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_76 ez-toc-wrap-left counter-hierarchy ez-toc-counter ez-toc-custom ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #ea7e02;color:#ea7e02\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #ea7e02;color:#ea7e02\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/www.whizlabs.com\/blog\/what-is-a-bigtable\/#Overview_of_BigTable\" >Overview of BigTable<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/www.whizlabs.com\/blog\/what-is-a-bigtable\/#Working_Potential_of_BigTable\" >Working Potential of BigTable<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/www.whizlabs.com\/blog\/what-is-a-bigtable\/#The_Architecture_of_BigTable\" >The Architecture of BigTable<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/www.whizlabs.com\/blog\/what-is-a-bigtable\/#BigTable_Nodes_and_Tablets\" >BigTable Nodes and Tablets<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/www.whizlabs.com\/blog\/what-is-a-bigtable\/#Key_Capabilities_of_BigTable\" >Key Capabilities of BigTable<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/www.whizlabs.com\/blog\/what-is-a-bigtable\/#1_Large-Scale_Storage\" >1. Large-Scale Storage<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/www.whizlabs.com\/blog\/what-is-a-bigtable\/#2_Integration_with_ML_Tools\" >2. Integration with ML Tools<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/www.whizlabs.com\/blog\/what-is-a-bigtable\/#3_High_Throughput\" >3. High Throughput<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/www.whizlabs.com\/blog\/what-is-a-bigtable\/#4_Latency_is_Low\" >4. Latency is Low<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/www.whizlabs.com\/blog\/what-is-a-bigtable\/#5_High_Availability\" >5. High Availability<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-11\" href=\"https:\/\/www.whizlabs.com\/blog\/what-is-a-bigtable\/#6_High_Scalability\" >6. High Scalability<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-12\" href=\"https:\/\/www.whizlabs.com\/blog\/what-is-a-bigtable\/#7_Fully-Managed_Database\" >7. Fully-Managed Database<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-13\" href=\"https:\/\/www.whizlabs.com\/blog\/what-is-a-bigtable\/#Purpose_of_Rows_Columns_and_Cells_within_3D_Map_Structure\" >Purpose of Rows, Columns, and Cells within 3D Map Structure<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-14\" href=\"https:\/\/www.whizlabs.com\/blog\/what-is-a-bigtable\/#1st_Dimension-_Rows\" >1st Dimension- Rows<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-15\" href=\"https:\/\/www.whizlabs.com\/blog\/what-is-a-bigtable\/#2nd_Dimension-_Columns\" >2nd Dimension- Columns<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-16\" href=\"https:\/\/www.whizlabs.com\/blog\/what-is-a-bigtable\/#3rd_Dimension-_Cells\" >3rd Dimension- Cells<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-17\" href=\"https:\/\/www.whizlabs.com\/blog\/what-is-a-bigtable\/#Final_Words\" >Final Words\u00a0<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-18\" href=\"https:\/\/www.whizlabs.com\/blog\/what-is-a-bigtable\/#Assess_your_knowledge_Now_%E2%80%93_Click_Here\" >Assess your knowledge Now &#8211; Click Here<\/a><\/li><\/ul><\/nav><\/div>\n<h2><span class=\"ez-toc-section\" id=\"Overview_of_BigTable\"><\/span><b>Overview of BigTable<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400;\">BigTable is the data storing hub, which is preferable for applications that demand high scalability and throughput for value or key data. Each of the values should be less than 10MB to be stored over\u00a0<\/span><b>BigTable<\/b><span style=\"font-weight: 400;\">\u00a0assembly. It also consists of a storage engine responsible for streamlining the MapReduce operations, machine-learning applications, and stream analytics or processing aspects.\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">BigTable is a prominent database for several applications such as Google Personalized Search, App Engine Datastore, Google Analytics, Google Earth, and others. It has the potential of increasing the cluster size for a certain period of time to make it able to handle larger loads. After the job is done, the cluster size can be reversed or reduced again. All of this can be done without experiencing any organizational downtime.\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Google has prioritized maintaining the software as an in-house technology. And this software has implemented a great impact on the NoSQL database architecture. Google has explained detailed working aspects of BigTable and has elaborated its internal process of operation. As a result, the bigger organizations and development teams started to look for ways to create BigTable derivatives. Some of the examples for the same are Hypertable, Cassandra, Apache HBase database, and others.\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Even with all of the derivatives out in the play, BigTable stood strong and made its appeal loud and clear to the organizations. BigTable allows you to store time-series data, financial data, IoT data, graph data, and marketing data as well. It is a huge set of feasibility that helps organizations utilize data in better ways!\u00a0<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Working_Potential_of_BigTable\"><\/span><b>Working Potential of BigTable<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400;\">Google\u00a0<\/span><b>BigTable<\/b><span style=\"font-weight: 400;\">\u00a0is a column-specific data store that can handle structured data with respect to the web services operations and the company\u2019s internet searches. The original integration of BigTable was for offering support to the applications that demand high scalability. The design of this database was meant to be deployed within clustered systems to make use of a simpler data model.\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">The data within\u00a0<\/span><b>BigTable<\/b><span style=\"font-weight: 400;\">\u00a0undergoes an assembling process with the use of a row key. The indexing of the map is then arranged as per the timestamps, row key, and column key. It also makes use of compression algorithms to help leverage high capacity. Data compression is a form of reduction of the number of bits that are essential for representing data. Compressing data intends to save some amount of storage.\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">BigTable consists of impactful back-end servers that offer enhanced perks than that of the self-managed HBase installation aspects. Scalability is the most important benefit of BigTable that allows it to scale in direct proportion to that of the number of machines within the cluster. The HBase installation consists of a loophole within its technology that limited the performance after a certain threshold was achieved.\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">But it is not the case with BigTable, as there are no limitations with it. You can potentially scale the clusters as per your needs to handle more read &amp; write thresholds. Moreover, BigTable also maintains durability for the data automatically, without manual assistance. If you want to replicate the existing data within BigTable, you just have to create another cluster to the existing instance. The data replication will begin automatically!\u00a0<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"The_Architecture_of_BigTable\"><\/span><b>The Architecture of BigTable<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><img decoding=\"async\" class=\"aligncenter size-full wp-image-79705\" src=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/09\/Bigtable-architecture.png\" alt=\"Bigtable architecture\" width=\"1680\" height=\"1400\" srcset=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/09\/Bigtable-architecture.png 1680w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/09\/Bigtable-architecture-300x250.png 300w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/09\/Bigtable-architecture-1024x853.png 1024w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/09\/Bigtable-architecture-768x640.png 768w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/09\/Bigtable-architecture-1536x1280.png 1536w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/09\/Bigtable-architecture-504x420.png 504w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/09\/Bigtable-architecture-640x533.png 640w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/09\/Bigtable-architecture-681x568.png 681w\" sizes=\"(max-width: 1680px) 100vw, 1680px\" \/><\/p>\n<p><span style=\"font-weight: 400;\">The architecture of BigTable is simple and sorted! First, the requests that come from the client\u2019s send passes through the front-end servers. It is mandatory for all of the requests to pass through the front-end server pool before they can reach the specific BigTable node. As of the original revelation of BigTable, the BigTable nodes were referred to as \u2018tablet servers.\u2019 If you want to check out the original BigTable paper, then\u00a0<\/span><a href=\"https:\/\/static.googleusercontent.com\/media\/research.google.com\/en\/archive\/bigtable-osdi06.pdf\" target=\"_blank\" rel=\"noopener\"><span style=\"font-weight: 400;\">refer to this link<\/span><\/a><span style=\"font-weight: 400;\">!\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">The nodes are organized in the form of a\u00a0<\/span><b>BigTable<\/b><span style=\"font-weight: 400;\"> cluster that belongs to a specific BigTable instance, which is also a cluster container. Each node within the cluster is responsible for handling the subset of all the requests that enter the cluster. By adding more nodes to a specific cluster, you can plan on increasing the potential of the cluster upon handling more requests. Moreover, the maximum throughput potential will also increase for the cluster.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">If you intend to replicate the data within the existing cluster, you will have to create a second cluster within the same instance. On replicating data to another cluster, you can also direct different traffics to each of the clusters. A BigTable consists of several blocks of rows that share the same border. They are termed \u2018tablets\u2019! They will help you in balancing the query workloads.\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">All of the tablets are stored over a file system by Google, Colossus. These tablets are stored within SSTable format. If you are keen to learn more about SSTable, you can\u00a0<\/span><a href=\"https:\/\/www.igvita.com\/2012\/02\/06\/sstable-and-log-structured-storage-leveldb\/\" target=\"_blank\" rel=\"noopener\"><span style=\"font-weight: 400;\">visit this documentation page<\/span><\/a><span style=\"font-weight: 400;\">\u00a0for the same. The role of the SSTable format is to offer a persistent &amp; immutable map. Each tablet has a specific node! Along with SSTable files, all the write throughput operations embedded within BigTable are also stored over the shared log of Colossus. It is to offer enhanced durability to the data!\u00a0<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"BigTable_Nodes_and_Tablets\"><\/span><b>BigTable Nodes and Tablets<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400;\">Firstly, you need to understand that no data is ever stored over BigTable nodes. As soon as BigTable identifies the data, each node directs its pointers to a certain set of tablets. And the data is passed onto them! Now, these tablets are then stored over the Colossus. The rebalancing of tablets from one node to the other is seamless and fast. It is because the actual data is not at all copied. Instead, BigTable just updates its node pointers to respective tablets.\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">The recovery potential in case of BigTable node failure is also streamlined and fast. In such a situation of node failures, the metadata is the only aspect that needs migration to that of the replacement node. You can be assured of losing no data on Bigdata node failure. Instances, nodes, and clusters are the fundamental blocks that build this entire database of BigTable. <\/span><a href=\"https:\/\/cloud.google.com\/bigtable\/docs\/instances-clusters-nodes\" target=\"_blank\" rel=\"noopener\"><span style=\"font-weight: 400;\">Redirect yourself to this documentation<\/span><\/a><span style=\"font-weight: 400;\">, and learn more about the working potential of instances, nodes, and clusters.<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Key_Capabilities_of_BigTable\"><\/span><b>Key Capabilities of BigTable<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400;\">The organizations demand the use of the database for achieving and maintaining their growth with ideal analytic implementations. And for that, the databases you use should have some high-end potential and capabilities. BigTable comprises the 7 key capabilities that are essential for a business to thrive. BigTable offers you the scope of personalization, speed, and automation.\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Apart from that, the key capabilities include:<\/span><\/p>\n<h3><span class=\"ez-toc-section\" id=\"1_Large-Scale_Storage\"><\/span><b>1. Large-Scale Storage<\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><b>BigTable<\/b><span style=\"font-weight: 400;\">\u00a0offers you the potential for capturing high amounts of data and use it for machine learning and analytics.\u00a0<\/span><\/p>\n<h3><span class=\"ez-toc-section\" id=\"2_Integration_with_ML_Tools\"><\/span><b>2. Integration with ML Tools<\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-weight: 400;\">With BigTable, you can run Machine Learning algorithms for deriving recommendations and predictions.\u00a0<\/span><\/p>\n<h3><span class=\"ez-toc-section\" id=\"3_High_Throughput\"><\/span><b>3. High Throughput<\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-weight: 400;\">All the data that intends to change rapidly can be accommodated with a high count of reading and write throughputs.\u00a0<\/span><\/p>\n<h3><span class=\"ez-toc-section\" id=\"4_Latency_is_Low\"><\/span><b>4. Latency is Low<\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-weight: 400;\">Low latency resembles high-speed on-site performance. You will get the response for lookups or data searches in a matter of milliseconds.\u00a0<\/span><\/p>\n<h3><span class=\"ez-toc-section\" id=\"5_High_Availability\"><\/span><b>5. High Availability<\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-weight: 400;\">BigTable can constantly operate without downtime or breakdown to serve the customers without fail.\u00a0<\/span><\/p>\n<h3><span class=\"ez-toc-section\" id=\"6_High_Scalability\"><\/span><b>6. High Scalability<\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-weight: 400;\">BigTable is scalable to cater to many requests and users automatically without any overloading aspect.\u00a0<\/span><\/p>\n<h3><span class=\"ez-toc-section\" id=\"7_Fully-Managed_Database\"><\/span><b>7. Fully-Managed Database<\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-weight: 400;\">BigTable, being fully managed, allows the developers to direct their focus upon app development aspects instead of giving their attention to databases. Google BigTable is handling that part seamlessly!\u00a0<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Purpose_of_Rows_Columns_and_Cells_within_3D_Map_Structure\"><\/span><b>Purpose of Rows, Columns, and Cells within 3D Map Structure<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><img decoding=\"async\" class=\"aligncenter size-full wp-image-79706\" src=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/09\/Purpose-of-Rows-Columns-and-Cells-within-3D-Map-Structure-in-Bigtable.png\" alt=\"\" width=\"2280\" height=\"800\" srcset=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/09\/Purpose-of-Rows-Columns-and-Cells-within-3D-Map-Structure-in-Bigtable.png 2280w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/09\/Purpose-of-Rows-Columns-and-Cells-within-3D-Map-Structure-in-Bigtable-300x105.png 300w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/09\/Purpose-of-Rows-Columns-and-Cells-within-3D-Map-Structure-in-Bigtable-1024x359.png 1024w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/09\/Purpose-of-Rows-Columns-and-Cells-within-3D-Map-Structure-in-Bigtable-768x269.png 768w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/09\/Purpose-of-Rows-Columns-and-Cells-within-3D-Map-Structure-in-Bigtable-1536x539.png 1536w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/09\/Purpose-of-Rows-Columns-and-Cells-within-3D-Map-Structure-in-Bigtable-2048x719.png 2048w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/09\/Purpose-of-Rows-Columns-and-Cells-within-3D-Map-Structure-in-Bigtable-1197x420.png 1197w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/09\/Purpose-of-Rows-Columns-and-Cells-within-3D-Map-Structure-in-Bigtable-640x225.png 640w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/09\/Purpose-of-Rows-Columns-and-Cells-within-3D-Map-Structure-in-Bigtable-681x239.png 681w\" sizes=\"(max-width: 2280px) 100vw, 2280px\" \/><\/p>\n<p><span style=\"font-weight: 400;\">The data within BigTable is stored in the form of 2 dimensions, which are rows and columns. But this is not similar to that of the relational databases, as there are slight complications within BigTable that make it different and better.\u00a0<\/span><\/p>\n<h3><span class=\"ez-toc-section\" id=\"1st_Dimension-_Rows\"><\/span><b>1st Dimension- Rows<\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-weight: 400;\">Each row has a unique identification or index that is stated as a single row key. The data that is stored within\u00a0<\/span><b>BigTable<\/b><span style=\"font-weight: 400;\">\u00a0undergoes automatic sorting with respect to row keys in alphabetical order. This sorting technique is also known as lexicographical sorting, making scans &amp; searches fast and easy across the table.\u00a0<\/span><\/p>\n<h3><span class=\"ez-toc-section\" id=\"2nd_Dimension-_Columns\"><\/span><b>2nd Dimension- Columns<\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-weight: 400;\">Now, the related data is then grouped within column families. For instance, basic profile details such as name, mobile number, and email address can be grouped on a select column family. In contrast, the comments given by the users can be grouped in another column family. The sole purpose of columns is to gather all the possible information that might be frequently retrieved together. Hence, this will make it easy and fast for the users to look for their selected data.\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Each of the columns within the same family consists of a specific column qualifier. Column qualifiers are similar to row keys, which helps in column identification. Column identification is carried out by the combination of family name and qualifier. The column qualifiers are in alphabetical order for increasing the query speed. Keep in mind that two-column families within one table should not have the same name. Moreover, two columns should also prohibit having the same column qualifiers.\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">In case any of the columns are empty, without any data over it, then that column is not consuming any storage or space. Therefore, BigTable is accountable for being titled a sparse database.\u00a0\u00a0<\/span><\/p>\n<h3><span class=\"ez-toc-section\" id=\"3rd_Dimension-_Cells\"><\/span><b>3rd Dimension- Cells<\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><img decoding=\"async\" class=\"aligncenter size-full wp-image-79707\" src=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/09\/3rd-Dimension-Cells-in-Bigtable.png\" alt=\"\" width=\"2280\" height=\"960\" srcset=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/09\/3rd-Dimension-Cells-in-Bigtable.png 2280w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/09\/3rd-Dimension-Cells-in-Bigtable-300x126.png 300w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/09\/3rd-Dimension-Cells-in-Bigtable-1024x431.png 1024w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/09\/3rd-Dimension-Cells-in-Bigtable-768x323.png 768w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/09\/3rd-Dimension-Cells-in-Bigtable-1536x647.png 1536w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/09\/3rd-Dimension-Cells-in-Bigtable-2048x862.png 2048w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/09\/3rd-Dimension-Cells-in-Bigtable-998x420.png 998w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/09\/3rd-Dimension-Cells-in-Bigtable-640x269.png 640w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/09\/3rd-Dimension-Cells-in-Bigtable-681x287.png 681w\" sizes=\"(max-width: 2280px) 100vw, 2280px\" \/><\/p>\n<p><span style=\"font-weight: 400;\">Now that you know the basic fundamentals of storing data over BigTable, it is time to introduce the third dimension. This dimension is responsible for making it different from other relational databases.\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">When you look for a row key and zoom to get insight into a particular column, you would generally expect to see a single value. But within BigTable, you will eventually see variable versions of that particular column value in different time points. Each of the timestamp versions is termed a cell. And it is the third dimension within this 3D map structure of BigTable.\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">The third dimension is optional for the organizations to implement. But with this positive complication, the data storage and retrieval will become more efficient in the long run with the use of BigTable.\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">You need this dimension because the data stored with BigTable intends to change very fast in the long run. For instance, one customer can choose to view one product and then switch to another immediately. Similarly, a user might be listening to any particular song, but the mood didn\u2019t match, so they changed to another in just 20 seconds. Hence, you can now relate to how data changes rapidly.\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Therefore, adding the third dimension of cells is important to help you see the history of data within a row. You will be able to view the products that your customer checked last week or the songs your customers listened to the day before. It will help you implement better data analytics and will lead you to know your customers well. Knowing the customers will help improve the business services.\u00a0<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Final_Words\"><\/span><b>Final Words\u00a0<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400;\">These are a few of the things that you need to keep in mind about BigTable. It is not just any ordinary database but a special business tool. It can literally help you go back in time to know the best interactions for ideal analysis. Cloud BigTable is a powerful database that has the ability to power mobile sites and apps with personalization and speed.\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">So, if you are convinced about the potential of this Google database, BigTable, then go ahead and get some hands-on experience. It will help you improve your approach towards your targeted audience.\u00a0<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Assess_your_knowledge_Now_%E2%80%93_Click_Here\"><\/span><strong>Assess your knowledge Now &#8211; <a href=\"https:\/\/docs.google.com\/forms\/d\/1VbyvD8hNxYlpPAdcVrSHtC0eqQBAUO82ZFTXmiBiHDg\/edit\" target=\"_blank\" rel=\"noopener\">Click Here<\/a><\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><strong><em>No Credit Card Required<\/em><\/strong><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Storing data within a database is a necessity for organizations. You might have the urge to store a mass amount of data for organizational operations. But you might miss out on an ideal resource for the same! Therefore, Cloud\u00a0BigTable\u00a0is a one-of-a-kind table that can be scaled to over thousands of columns and billions of rows. It allows you to store around terabytes and petabytes of data seamlessly.\u00a0 One value within each row gets indexed within this table, and that is known as the \u2018row key.\u2019 The latency is really low over BigTable but has a high potential of storing a [&hellip;]<\/p>\n","protected":false},"author":169,"featured_media":79708,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_uag_custom_page_level_css":"","site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[12],"tags":[4690,4688,4691,4696,4694,4692,4693,4689],"class_list":["post-79702","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-google-cloud","tag-architecture-of-bigtable","tag-big-table","tag-bigtable-nodes-and-tablets","tag-cells-within-3d-map-structure","tag-columns","tag-key-capabilities-of-bigtable","tag-purpose-of-rows","tag-working-potential-of-bigtable"],"uagb_featured_image_src":{"full":["https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/09\/What-is-a-BigTable.png",560,320,false],"thumbnail":["https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/09\/What-is-a-BigTable-150x150.png",150,150,true],"medium":["https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/09\/What-is-a-BigTable-300x171.png",300,171,true],"medium_large":["https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/09\/What-is-a-BigTable.png",560,320,false],"large":["https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/09\/What-is-a-BigTable.png",560,320,false],"1536x1536":["https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/09\/What-is-a-BigTable.png",560,320,false],"2048x2048":["https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/09\/What-is-a-BigTable.png",560,320,false],"profile_24":["https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/09\/What-is-a-BigTable.png",24,14,false],"profile_48":["https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/09\/What-is-a-BigTable.png",48,27,false],"profile_96":["https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/09\/What-is-a-BigTable.png",96,55,false],"profile_150":["https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/09\/What-is-a-BigTable.png",150,86,false],"profile_300":["https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/09\/What-is-a-BigTable.png",300,171,false],"tptn_thumbnail":["https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/09\/What-is-a-BigTable-250x250.png",250,250,true],"web-stories-poster-portrait":["https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/09\/What-is-a-BigTable.png",560,320,false],"web-stories-publisher-logo":["https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/09\/What-is-a-BigTable.png",96,55,false],"web-stories-thumbnail":["https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2021\/09\/What-is-a-BigTable.png",150,86,false]},"uagb_author_info":{"display_name":"Girdharee Saran","author_link":"https:\/\/www.whizlabs.com\/blog\/author\/girdharee\/"},"uagb_comment_info":8,"uagb_excerpt":"Storing data within a database is a necessity for organizations. You might have the urge to store a mass amount of data for organizational operations. But you might miss out on an ideal resource for the same! Therefore, Cloud\u00a0BigTable\u00a0is a one-of-a-kind table that can be scaled to over thousands of columns and billions of rows.&hellip;","_links":{"self":[{"href":"https:\/\/www.whizlabs.com\/blog\/wp-json\/wp\/v2\/posts\/79702","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.whizlabs.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.whizlabs.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.whizlabs.com\/blog\/wp-json\/wp\/v2\/users\/169"}],"replies":[{"embeddable":true,"href":"https:\/\/www.whizlabs.com\/blog\/wp-json\/wp\/v2\/comments?post=79702"}],"version-history":[{"count":5,"href":"https:\/\/www.whizlabs.com\/blog\/wp-json\/wp\/v2\/posts\/79702\/revisions"}],"predecessor-version":[{"id":80508,"href":"https:\/\/www.whizlabs.com\/blog\/wp-json\/wp\/v2\/posts\/79702\/revisions\/80508"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.whizlabs.com\/blog\/wp-json\/wp\/v2\/media\/79708"}],"wp:attachment":[{"href":"https:\/\/www.whizlabs.com\/blog\/wp-json\/wp\/v2\/media?parent=79702"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.whizlabs.com\/blog\/wp-json\/wp\/v2\/categories?post=79702"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.whizlabs.com\/blog\/wp-json\/wp\/v2\/tags?post=79702"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}