{"id":578,"date":"2021-02-16T00:00:00","date_gmt":"2021-02-16T00:00:00","guid":{"rendered":"https:\/\/en.pingcap.com\/blog\/how-to-efficiently-choose-the-right-database-for-your-applications\/"},"modified":"2024-06-14T19:21:58","modified_gmt":"2024-06-15T02:21:58","slug":"how-to-efficiently-choose-the-right-database-for-your-applications","status":"publish","type":"post","link":"https:\/\/www.pingcap.com\/ko\/blog\/how-to-efficiently-choose-the-right-database-for-your-applications\/","title":{"rendered":"How to Efficiently Choose the Right Database for Your Applications"},"content":{"rendered":"<p>Finding the right database solution for your application is not easy. At <a href=\"https:\/\/en.wikipedia.org\/wiki\/IQIYI\">iQIYI<\/a>, one of the largest online video sites in the world, we&#8217;re experienced in database selection across several fields: Online Transactional Processing (OLTP), Online Analytical Processing (OLAP), Hybrid Transaction\/Analytical Processing (HTAP), SQL, and NoSQL.<\/p>\n<p>Today, I&#8217;ll share with you:<\/p>\n<ul>\n<li><a href=\"#database-selection-criteria\">What criteria to use for selecting a database<\/a><\/li>\n<li><a href=\"#what-databases-we-use-at-iqiyi\">What databases we use at iQIYI<\/a><\/li>\n<li><a href=\"#practical-decision-trees-for-efficiently-choosing-a-database\">Some decision models to help you efficiently pick a database<\/a><\/li>\n<li><a href=\"#tips-for-choosing-a-database\">Tips for choosing your database<\/a><\/li>\n<\/ul>\n<p>I hope this post can help you easily find the right database for your applications.<\/p>\n<p style=\"text-align: center;\"><span style=\"color: #3366ff;\">&gt;&gt; <a style=\"color: #3366ff;\" href=\"https:\/\/cta-redirect.hubspot.com\/cta\/redirect\/4466002\/81dcfa9c-f7f6-41fb-9e12-071702b8b582\"><span style=\"text-decoration: underline;\"><strong>Download the IDC InfoBrief: New Engines for Enterprise Data Workloads<\/strong><\/span><\/a> &lt;&lt;<\/span><\/p>\n<pre style=\"text-align: center;\">\u00a0<\/pre>\n<h2 id=\"database-selection-criteria\"><span class=\"ez-toc-section\" id=\"Database_selection_criteria\"><\/span>Database selection criteria<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>When choosing a database, different people use different criteria:<\/p>\n<ul>\n<li>Database procurement staff pay more attention to <strong>purchase costs, including storage and network requirements<\/strong>.<\/li>\n<li>Database administrators (DBAs) care about:\n<ul>\n<li><strong>Operation and maintenance costs<\/strong>:\n<ul>\n<li>A reliable monitoring and alerting system<\/li>\n<li>Support for backup and restore<\/li>\n<li>Reasonable upgrade and migration costs<\/li>\n<li>An active support community<\/li>\n<li>Ease of performance tuning<\/li>\n<li>Ease of troubleshooting<\/li>\n<\/ul>\n<\/li>\n<li><strong>Service stability:<\/strong>\n<ul>\n<li>Support for multiple data replicas<\/li>\n<li>Highly available services<\/li>\n<li>Support for multiple writes and multi-active architecture<\/li>\n<\/ul>\n<\/li>\n<li><strong>Performance:<\/strong>\n<ul>\n<li>Latency<\/li>\n<li>Queries per second (QPS)<\/li>\n<li>Whether it supports more advanced hierarchical storage features<\/li>\n<\/ul>\n<\/li>\n<li><strong>Scalability:<\/strong> Whether it&#8217;s easy to scale horizontally and vertically<\/li>\n<li><strong>Security:<\/strong> Whether it meets audit requirements and prevents SQL injections and information leakage<\/li>\n<\/ul>\n<\/li>\n<li>Application developers care about:\n<ul>\n<li><strong>Stable services<\/strong><\/li>\n<li><strong>Performance<\/strong><\/li>\n<li><strong>Scalability<\/strong><\/li>\n<li><strong>Ease of developing database interface<\/strong><\/li>\n<li><strong>Ease of modifying the database schema<\/strong><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<pre style=\"text-align: center;\">\u00a0<\/pre>\n<h2 id=\"what-databases-we-use-at-iqiyi\"><span class=\"ez-toc-section\" id=\"What_databases_we_use_at_iQIYI\"><\/span>What databases we use at iQIYI<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>At iQIYI, we mainly use these databases:<\/p>\n<ul>\n<li>MySQL<\/li>\n<li><a href=\"https:\/\/docs.pingcap.com\/tidb\/stable\/overview\">TiDB<\/a><\/li>\n<li>Redis<\/li>\n<li>Couchbase<\/li>\n<li>Big data analytical systems, like Hive and Impala<\/li>\n<li>Other databases, like MongoDB, HiGraph, and TiKV<\/li>\n<\/ul>\n<p>Because there are so many types of databases at iQIYI, application developers might not know which database is suitable for their application scenario. Therefore, we categorized these databases by application scenario and database interface, and we built a matrix:<\/p>\n<ul>\n<li>The X-axis represents application scenarios: OLTP vs. OLAP.<\/li>\n<li>The Y-axis represents database interfaces: SQL vs. NoSQL.<\/li>\n<\/ul>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-7427 size-large\" src=\"https:\/\/en.pingcap.com\/wp-content\/uploads\/2022\/06\/databases-types-at-iqiyi-1024x629.jpeg\" alt=\"\" width=\"1024\" height=\"629\" srcset=\"https:\/\/static.pingcap.com\/files\/2022\/06\/databases-types-at-iqiyi-1024x629.jpeg 1024w, https:\/\/static.pingcap.com\/files\/2022\/06\/databases-types-at-iqiyi-300x184.jpeg 300w, https:\/\/static.pingcap.com\/files\/2022\/06\/databases-types-at-iqiyi-768x472.jpeg 768w, https:\/\/static.pingcap.com\/files\/2022\/06\/databases-types-at-iqiyi-1536x944.jpeg 1536w, https:\/\/static.pingcap.com\/files\/2022\/06\/databases-types-at-iqiyi-1440x885.jpeg 1440w, https:\/\/static.pingcap.com\/files\/2022\/06\/databases-types-at-iqiyi.jpeg 2000w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/>\n<div class=\"caption-center\" style=\"text-align: center;\">\u00a0 \u00a0 \u00a0 \u00a0 \u00a0<em> \u00a0 \u00a0 \u00a0All databases at iQIYI<\/em><\/div>\n<p>This matrix has these characteristics:<\/p>\n<ul>\n<li>On the left\n<ul>\n<li>In the upper left cornerDatabases support OLTP workloads and the SQL language. For example, MySQL supports different transaction isolation levels, high QPS, and low latency. We mainly use it to store transaction information and critical data, such as orders and VIP information.<\/li>\n<li>In the lower left cornerWe use NoSQL databases to optimize special scenarios. Generally, these databases have simple schemas or they are schemaless with high throughput and low latency. We mainly use them as caches or key-value (KV) databases.<\/li>\n<\/ul>\n<\/li>\n<li>On the rightAll are OLAP big data analytical systems, such as ClickHouse and Impala. Generally, they support the SQL language and don&#8217;t support transactions. They have good scalability and long response latency. We can add machines to enlarge data storage capacity, and the response delay is longer.<\/li>\n<li>Around the two axes&#8217; meeting pointThese databases are neutral, and we call them HTAP databases, such as TiDB. When the amount of data is small, they have good performance. When the data size is large or the queries are complex, their performance is not bad. Generally, to meet different application needs, we use different storage engines and query engines.<\/li>\n<\/ul>\n<h2 id=\"practical-decision-trees-for-efficiently-choosing-a-database\"><span class=\"ez-toc-section\" id=\"Practical_decision_trees_for_efficiently_choosing_a_database\"><\/span>Practical decision trees for efficiently choosing a database<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>I&#8217;d like to recommend our database selection trees. We developed these trees based on our DBAs&#8217; and application developers&#8217; experience.<\/p>\n<h3>How to efficiently choose a relational database<\/h3>\n<p>When you select a relational database, you can:<\/p>\n<ol>\n<li>Consider your data volume and database scalability.<\/li>\n<li>Make a decision based on:\n<ul>\n<li>Whether the database has a cold backup system<\/li>\n<li>Whether to use the TokuDB storage engine<\/li>\n<li>Whether to use a proxy<\/li>\n<\/ul>\n<\/li>\n<\/ol>\n<img loading=\"lazy\" decoding=\"async\" width=\"2000\" height=\"947\" class=\"wp-image-579\" src=\"https:\/\/en.pingcap.com\/wp-content\/uploads\/2021\/02\/efficiently-choosing-relational-database.jpg\" alt=\"Efficiently choosing a relational database\" srcset=\"https:\/\/static.pingcap.com\/files\/2021\/02\/efficiently-choosing-relational-database.jpg 2000w, https:\/\/static.pingcap.com\/files\/2021\/02\/efficiently-choosing-relational-database-300x142.jpg 300w, https:\/\/static.pingcap.com\/files\/2021\/02\/efficiently-choosing-relational-database-1024x485.jpg 1024w, https:\/\/static.pingcap.com\/files\/2021\/02\/efficiently-choosing-relational-database-768x364.jpg 768w, https:\/\/static.pingcap.com\/files\/2021\/02\/efficiently-choosing-relational-database-1536x727.jpg 1536w, https:\/\/static.pingcap.com\/files\/2021\/02\/efficiently-choosing-relational-database-1440x682.jpg 1440w\" sizes=\"auto, (max-width: 2000px) 100vw, 2000px\" \/>\n<div class=\"caption-center\" style=\"text-align: center;\"><em>Efficiently choosing a relational database<\/em><\/div>\n<h3>\u00a0<\/h3>\n<p><!--HubSpot Call-to-Action Code --><span id=\"hs-cta-wrapper-a8fbe162-f28b-41e6-88e3-8a69e70a66b9\" class=\"hs-cta-wrapper\"><span id=\"hs-cta-a8fbe162-f28b-41e6-88e3-8a69e70a66b9\" class=\"hs-cta-node hs-cta-a8fbe162-f28b-41e6-88e3-8a69e70a66b9\"><!-- [if lte IE 8]>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n<div id=\"hs-cta-ie-element\"><\/div>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n<![endif]--><a href=\"https:\/\/cta-redirect.hubspot.com\/cta\/redirect\/4466002\/a8fbe162-f28b-41e6-88e3-8a69e70a66b9\" target=\"_blank\" rel=\"noopener\" data-inline=\"true\"><img decoding=\"async\" id=\"hs-cta-img-a8fbe162-f28b-41e6-88e3-8a69e70a66b9\" class=\"hs-cta-img\" style=\"border-width: 0px;\" src=\"https:\/\/no-cache.hubspot.com\/cta\/default\/4466002\/a8fbe162-f28b-41e6-88e3-8a69e70a66b9.png\" alt=\"Contact Us\" \/><\/a><\/span><script charset=\"utf-8\" src=\"https:\/\/js.hscta.net\/cta\/current.js\"><\/script><script type=\"text\/javascript\"> hbspt.cta.load(4466002, 'a8fbe162-f28b-41e6-88e3-8a69e70a66b9', {\"useNewLoader\":\"true\",\"region\":\"na1\"}); <\/script> <\/span><span id=\"hs-cta-wrapper-e300fa89-16e5-4da7-aeaa-82b300b11b2f\" class=\"hs-cta-wrapper\"><span id=\"hs-cta-e300fa89-16e5-4da7-aeaa-82b300b11b2f\" class=\"hs-cta-node hs-cta-e300fa89-16e5-4da7-aeaa-82b300b11b2f\"><a href=\"https:\/\/cta-redirect.hubspot.com\/cta\/redirect\/4466002\/e300fa89-16e5-4da7-aeaa-82b300b11b2f\" target=\"_blank\" rel=\"noopener\" data-inline=\"true\"><img decoding=\"async\" id=\"hs-cta-img-e300fa89-16e5-4da7-aeaa-82b300b11b2f\" class=\"hs-cta-img\" style=\"border-width: 0px;\" src=\"https:\/\/no-cache.hubspot.com\/cta\/default\/4466002\/e300fa89-16e5-4da7-aeaa-82b300b11b2f.png\" alt=\"Try TiDB Cloud for Free\" \/><\/a><\/span><script charset=\"utf-8\" src=\"https:\/\/js.hscta.net\/cta\/current.js\"><\/script><script type=\"text\/javascript\"> hbspt.cta.load(4466002, 'e300fa89-16e5-4da7-aeaa-82b300b11b2f', {\"useNewLoader\":\"true\",\"region\":\"na1\"}); <\/script><\/span><!-- end HubSpot Call-to-Action Code --> <!--HubSpot Call-to-Action Code --><span id=\"hs-cta-wrapper-a1e9a6f7-ef82-4be2-aceb-43ed8c420fe1\" class=\"hs-cta-wrapper\"><span id=\"hs-cta-a1e9a6f7-ef82-4be2-aceb-43ed8c420fe1\" class=\"hs-cta-node hs-cta-a1e9a6f7-ef82-4be2-aceb-43ed8c420fe1\"><!-- [if lte IE 8]>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n<div id=\"hs-cta-ie-element\"><\/div>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n<![endif]--><a href=\"https:\/\/cta-redirect.hubspot.com\/cta\/redirect\/4466002\/a1e9a6f7-ef82-4be2-aceb-43ed8c420fe1\" target=\"_blank\" rel=\"noopener\" data-inline=\"true\"><img decoding=\"async\" id=\"hs-cta-img-a1e9a6f7-ef82-4be2-aceb-43ed8c420fe1\" class=\"hs-cta-img\" style=\"border-width: 0px;\" src=\"https:\/\/no-cache.hubspot.com\/cta\/default\/4466002\/a1e9a6f7-ef82-4be2-aceb-43ed8c420fe1.png\" alt=\"Subscribe to Blog\" \/><\/a><\/span><script charset=\"utf-8\" src=\"https:\/\/js.hscta.net\/cta\/current.js\"><\/script><script type=\"text\/javascript\"> hbspt.cta.load(4466002, 'a1e9a6f7-ef82-4be2-aceb-43ed8c420fe1', {\"useNewLoader\":\"true\",\"region\":\"na1\"}); <\/script><\/span><!-- end HubSpot Call-to-Action Code --><\/p>\n<h3>How to efficiently choose a NoSQL database<\/h3>\n<p>When we choose a NoSQL database, we must consider many factors to decide whether to use the primary-secondary framework, client sharding, distributed cluster, Couchbase, or TiKV.<\/p>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-7430 size-large\" src=\"https:\/\/en.pingcap.com\/wp-content\/uploads\/2021\/02\/efficiently-choosing-nosql-database-1024x558.jpeg\" alt=\"\" width=\"1024\" height=\"558\" srcset=\"https:\/\/static.pingcap.com\/files\/2021\/02\/efficiently-choosing-nosql-database-1024x558.jpeg 1024w, https:\/\/static.pingcap.com\/files\/2021\/02\/efficiently-choosing-nosql-database-300x164.jpeg 300w, https:\/\/static.pingcap.com\/files\/2021\/02\/efficiently-choosing-nosql-database-768x419.jpeg 768w, https:\/\/static.pingcap.com\/files\/2021\/02\/efficiently-choosing-nosql-database-1536x837.jpeg 1536w, https:\/\/static.pingcap.com\/files\/2021\/02\/efficiently-choosing-nosql-database-1440x785.jpeg 1440w, https:\/\/static.pingcap.com\/files\/2021\/02\/efficiently-choosing-nosql-database.jpeg 2000w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/>\n<div class=\"caption-center\" style=\"text-align: center;\"><em>Efficiently choosing a NoSQL database<\/em><\/div>\n<h2 id=\"tips-for-choosing-a-database\"><span class=\"ez-toc-section\" id=\"Tips_for_choosing_a_database\"><\/span>Tips for choosing a database<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>I&#8217;d like to share with you some tips for selecting a database:<\/p>\n<ul>\n<li><strong>Try to solve the problems without changing the database first.<\/strong> You can determine your requirements based on data volume, QPS, and latency, but are these the real requirements? Can you find a way to eliminate this requirement without involving the database? For example, if the data volume is high, you can encode or compress data first, and that may reduce the data size. Don&#8217;t push all your requirements down to the database level.<\/li>\n<li><strong>Consider what the real reason is for choosing a database.<\/strong> Do you choose it because it&#8217;s popular? Or because it&#8217;s advanced? The most important question is: can it really solve your problem? For example, if your data volume is not very large, you don&#8217;t need a system with a lot of storage.<\/li>\n<li><strong>Think carefully before you give up on a solution.<\/strong> Are you abandoning a system because it doesn&#8217;t work? Or because you&#8217;re not using it properly? It&#8217;s difficult to get rid of your solution, so be clear about why you&#8217;re giving up on it. For example, before you make a decision, compare your TPC-C or Sysbench benchmarks.<\/li>\n<li><strong>Keep a good attitude towards self-development.<\/strong> When you need to develop your own database, you can refer to and use some mature products. Don&#8217;t build things from scratch if you don&#8217;t need to.<\/li>\n<li><strong>Embrace open-source products.<\/strong> For example, <a href=\"https:\/\/docs.pingcap.com\/tidb\/stable\/overview\">TiDB<\/a> is an open-source, distributed SQL database. It has an active community, and currently has 26,000 stars on <a href=\"https:\/\/github.com\/pingcap\/tidb\">GitHub<\/a>. Our previous post described how TiDB helped us <a href=\"https:\/\/pingcap.com\/case-studies\/tidb-in-iqiyi\">scale out our database and achieve high availability<\/a>. Currently, in the production environment, we have 88 TiDB clusters, with more than 1,200 nodes. There&#8217;s no reason why you have to go it alone.<\/li>\n<\/ul>\n<p><strong>Keep reading:<\/strong><\/p>\n<p><a href=\"https:\/\/en.pingcap.com\/blog\/the-beauty-of-htap-tidb-and-alloydb-as-examples\/\" target=\"_blank\" rel=\"noopener\">The Beauty of HTAP: TiDB and AlloyDB as Examples<\/a><br \/><a href=\"https:\/\/en.pingcap.com\/blog\/the-long-expedition-toward-making-a-real-time-htap-database\/\" target=\"_blank\" rel=\"noopener\">The Long Expedition toward Making a Real-Time HTAP Database<\/a><br \/><a href=\"https:\/\/en.pingcap.com\/blog\/how-an-htap-database-handles-oltp-and-olap-workloads-at-the-same-time\/\" target=\"_blank\" rel=\"noopener\">How an HTAP Database Handles OLTP and OLAP Workloads at the Same Time<\/a><\/p>\n\n\n<p><\/p>\n\n\n<div class=\"ub_call_to_action wp-block-ub-call-to-action-block\"  id=\"ub_call_to_action_73bd6a97-5ead-4c0b-a909-7b3277529317\">\n                <div class=\"ub_call_to_action_headline\">\n                    <p class=\"ub_call_to_action_headline_text\">IDC InfoBrief: Competing in the Digital-First Economy \u2013 New Engines for Enterprise Data Workloads<\/p><\/div>\n                <div class=\"ub_call_to_action_content\">\n                    <p class=\"ub_cta_content_text\">This IDC InfoBrief discusses the challenges and key characteristics of data workloads in the digital-first economy. It also proposes how to get your business ready for the future through a unified data platform like TiDB from PingCAP.<\/p><\/div>\n                <div class=\"ub_call_to_action_button\">\n                    <a href=\"https:\/\/cta-redirect.hubspot.com\/cta\/redirect\/4466002\/81dcfa9c-f7f6-41fb-9e12-071702b8b582\" target=\"_self\" rel=\"noopener noreferrer\"\n                        class=\"ub_cta_button\">\n                        <p class=\"ub_cta_button_text\">Download It Now!<\/p><\/a><\/div><\/div>","protected":false},"excerpt":{"rendered":"<p>Learn how to efficiently find the right database for your applications.<\/p>","protected":false},"author":64,"featured_media":582,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"ub_ctt_via":"","footnotes":""},"categories":[199],"tags":[29],"class_list":["post-578","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-customer-stories","tag-tutorial"],"acf":[],"featured_image_src":"https:\/\/static.pingcap.com\/files\/2021\/02\/how-to-choose-database.jpg","author_info":{"display_name":"Leitao Guo","author_link":"https:\/\/www.pingcap.com\/ko\/blog\/author\/leitao-guo\/"},"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.9 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>How to Efficiently Choose the Right Database for Your Applications<\/title>\n<meta name=\"description\" content=\"In this post, we will share what criteria to use for selecting a database and some decision models to help you efficiently pick a database.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.pingcap.com\/ko\/blog\/how-to-efficiently-choose-the-right-database-for-your-applications\/\" \/>\n<meta property=\"og:locale\" content=\"ko_KR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to Efficiently Choose the Right Database for Your Applications\" \/>\n<meta property=\"og:description\" content=\"In this post, we will share what criteria to use for selecting a database and some decision models to help you efficiently pick a database.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.pingcap.com\/ko\/blog\/how-to-efficiently-choose-the-right-database-for-your-applications\/\" \/>\n<meta property=\"og:site_name\" content=\"TiDB\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/facebook.com\/pingcap2015\" \/>\n<meta property=\"article:published_time\" content=\"2021-02-16T00:00:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-06-15T02:21:58+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/static.pingcap.com\/files\/2021\/02\/how-to-choose-database.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1600\" \/>\n\t<meta property=\"og:image:height\" content=\"534\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Leitao Guo\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@PingCAP\" \/>\n<meta name=\"twitter:site\" content=\"@PingCAP\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Leitao Guo\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"6\ubd84\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.pingcap.com\/blog\/how-to-efficiently-choose-the-right-database-for-your-applications\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.pingcap.com\/blog\/how-to-efficiently-choose-the-right-database-for-your-applications\/\"},\"author\":{\"name\":\"Leitao Guo\",\"@id\":\"https:\/\/www.pingcap.com\/#\/schema\/person\/1e6bb98f1263790c168616f68317ff87\"},\"headline\":\"How to Efficiently Choose the Right Database for Your Applications\",\"datePublished\":\"2021-02-16T00:00:00+00:00\",\"dateModified\":\"2024-06-15T02:21:58+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.pingcap.com\/blog\/how-to-efficiently-choose-the-right-database-for-your-applications\/\"},\"wordCount\":1000,\"publisher\":{\"@id\":\"https:\/\/www.pingcap.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.pingcap.com\/blog\/how-to-efficiently-choose-the-right-database-for-your-applications\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/static.pingcap.com\/files\/2021\/02\/how-to-choose-database.jpg\",\"keywords\":[\"Tutorial\"],\"articleSection\":[\"Customer Story\"],\"inLanguage\":\"ko-KR\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.pingcap.com\/blog\/how-to-efficiently-choose-the-right-database-for-your-applications\/\",\"url\":\"https:\/\/www.pingcap.com\/blog\/how-to-efficiently-choose-the-right-database-for-your-applications\/\",\"name\":\"How to Efficiently Choose the Right Database for Your Applications\",\"isPartOf\":{\"@id\":\"https:\/\/www.pingcap.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.pingcap.com\/blog\/how-to-efficiently-choose-the-right-database-for-your-applications\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.pingcap.com\/blog\/how-to-efficiently-choose-the-right-database-for-your-applications\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/static.pingcap.com\/files\/2021\/02\/how-to-choose-database.jpg\",\"datePublished\":\"2021-02-16T00:00:00+00:00\",\"dateModified\":\"2024-06-15T02:21:58+00:00\",\"description\":\"In this post, we will share what criteria to use for selecting a database and some decision models to help you efficiently pick a database.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.pingcap.com\/blog\/how-to-efficiently-choose-the-right-database-for-your-applications\/#breadcrumb\"},\"inLanguage\":\"ko-KR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.pingcap.com\/blog\/how-to-efficiently-choose-the-right-database-for-your-applications\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"ko-KR\",\"@id\":\"https:\/\/www.pingcap.com\/blog\/how-to-efficiently-choose-the-right-database-for-your-applications\/#primaryimage\",\"url\":\"https:\/\/static.pingcap.com\/files\/2021\/02\/how-to-choose-database.jpg\",\"contentUrl\":\"https:\/\/static.pingcap.com\/files\/2021\/02\/how-to-choose-database.jpg\",\"width\":1600,\"height\":534},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.pingcap.com\/blog\/how-to-efficiently-choose-the-right-database-for-your-applications\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.pingcap.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to Efficiently Choose the Right Database for Your Applications\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.pingcap.com\/#website\",\"url\":\"https:\/\/www.pingcap.com\/\",\"name\":\"TiDB\",\"description\":\"TiDB | SQL at Scale\",\"publisher\":{\"@id\":\"https:\/\/www.pingcap.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.pingcap.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"ko-KR\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.pingcap.com\/#organization\",\"name\":\"PingCAP\",\"url\":\"https:\/\/www.pingcap.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"ko-KR\",\"@id\":\"https:\/\/www.pingcap.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/static.pingcap.com\/files\/2021\/11\/pingcap-logo.png\",\"contentUrl\":\"https:\/\/static.pingcap.com\/files\/2021\/11\/pingcap-logo.png\",\"width\":811,\"height\":232,\"caption\":\"PingCAP\"},\"image\":{\"@id\":\"https:\/\/www.pingcap.com\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/facebook.com\/pingcap2015\",\"https:\/\/x.com\/PingCAP\",\"https:\/\/linkedin.com\/company\/pingcap\",\"https:\/\/youtube.com\/channel\/UCuq4puT32DzHKT5rU1IZpIA\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.pingcap.com\/#\/schema\/person\/1e6bb98f1263790c168616f68317ff87\",\"name\":\"Leitao Guo\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"ko-KR\",\"@id\":\"https:\/\/www.pingcap.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/static.pingcap.com\/files\/2022\/10\/17234942\/avatar.jpg\",\"contentUrl\":\"https:\/\/static.pingcap.com\/files\/2022\/10\/17234942\/avatar.jpg\",\"caption\":\"Leitao Guo\"},\"description\":\"Database and Middleware Manager at iQIYI\",\"url\":\"https:\/\/www.pingcap.com\/ko\/blog\/author\/leitao-guo\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to Efficiently Choose the Right Database for Your Applications","description":"In this post, we will share what criteria to use for selecting a database and some decision models to help you efficiently pick a database.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.pingcap.com\/ko\/blog\/how-to-efficiently-choose-the-right-database-for-your-applications\/","og_locale":"ko_KR","og_type":"article","og_title":"How to Efficiently Choose the Right Database for Your Applications","og_description":"In this post, we will share what criteria to use for selecting a database and some decision models to help you efficiently pick a database.","og_url":"https:\/\/www.pingcap.com\/ko\/blog\/how-to-efficiently-choose-the-right-database-for-your-applications\/","og_site_name":"TiDB","article_publisher":"https:\/\/facebook.com\/pingcap2015","article_published_time":"2021-02-16T00:00:00+00:00","article_modified_time":"2024-06-15T02:21:58+00:00","og_image":[{"width":1600,"height":534,"url":"https:\/\/static.pingcap.com\/files\/2021\/02\/how-to-choose-database.jpg","type":"image\/jpeg"}],"author":"Leitao Guo","twitter_card":"summary_large_image","twitter_creator":"@PingCAP","twitter_site":"@PingCAP","twitter_misc":{"Written by":"Leitao Guo","Est. reading time":"6\ubd84"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.pingcap.com\/blog\/how-to-efficiently-choose-the-right-database-for-your-applications\/#article","isPartOf":{"@id":"https:\/\/www.pingcap.com\/blog\/how-to-efficiently-choose-the-right-database-for-your-applications\/"},"author":{"name":"Leitao Guo","@id":"https:\/\/www.pingcap.com\/#\/schema\/person\/1e6bb98f1263790c168616f68317ff87"},"headline":"How to Efficiently Choose the Right Database for Your Applications","datePublished":"2021-02-16T00:00:00+00:00","dateModified":"2024-06-15T02:21:58+00:00","mainEntityOfPage":{"@id":"https:\/\/www.pingcap.com\/blog\/how-to-efficiently-choose-the-right-database-for-your-applications\/"},"wordCount":1000,"publisher":{"@id":"https:\/\/www.pingcap.com\/#organization"},"image":{"@id":"https:\/\/www.pingcap.com\/blog\/how-to-efficiently-choose-the-right-database-for-your-applications\/#primaryimage"},"thumbnailUrl":"https:\/\/static.pingcap.com\/files\/2021\/02\/how-to-choose-database.jpg","keywords":["Tutorial"],"articleSection":["Customer Story"],"inLanguage":"ko-KR"},{"@type":"WebPage","@id":"https:\/\/www.pingcap.com\/blog\/how-to-efficiently-choose-the-right-database-for-your-applications\/","url":"https:\/\/www.pingcap.com\/blog\/how-to-efficiently-choose-the-right-database-for-your-applications\/","name":"How to Efficiently Choose the Right Database for Your Applications","isPartOf":{"@id":"https:\/\/www.pingcap.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.pingcap.com\/blog\/how-to-efficiently-choose-the-right-database-for-your-applications\/#primaryimage"},"image":{"@id":"https:\/\/www.pingcap.com\/blog\/how-to-efficiently-choose-the-right-database-for-your-applications\/#primaryimage"},"thumbnailUrl":"https:\/\/static.pingcap.com\/files\/2021\/02\/how-to-choose-database.jpg","datePublished":"2021-02-16T00:00:00+00:00","dateModified":"2024-06-15T02:21:58+00:00","description":"In this post, we will share what criteria to use for selecting a database and some decision models to help you efficiently pick a database.","breadcrumb":{"@id":"https:\/\/www.pingcap.com\/blog\/how-to-efficiently-choose-the-right-database-for-your-applications\/#breadcrumb"},"inLanguage":"ko-KR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.pingcap.com\/blog\/how-to-efficiently-choose-the-right-database-for-your-applications\/"]}]},{"@type":"ImageObject","inLanguage":"ko-KR","@id":"https:\/\/www.pingcap.com\/blog\/how-to-efficiently-choose-the-right-database-for-your-applications\/#primaryimage","url":"https:\/\/static.pingcap.com\/files\/2021\/02\/how-to-choose-database.jpg","contentUrl":"https:\/\/static.pingcap.com\/files\/2021\/02\/how-to-choose-database.jpg","width":1600,"height":534},{"@type":"BreadcrumbList","@id":"https:\/\/www.pingcap.com\/blog\/how-to-efficiently-choose-the-right-database-for-your-applications\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.pingcap.com\/"},{"@type":"ListItem","position":2,"name":"How to Efficiently Choose the Right Database for Your Applications"}]},{"@type":"WebSite","@id":"https:\/\/www.pingcap.com\/#website","url":"https:\/\/www.pingcap.com\/","name":"\ud2f0DB","description":"TiDB | SQL at Scale","publisher":{"@id":"https:\/\/www.pingcap.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.pingcap.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"ko-KR"},{"@type":"Organization","@id":"https:\/\/www.pingcap.com\/#organization","name":"PingCAP","url":"https:\/\/www.pingcap.com\/","logo":{"@type":"ImageObject","inLanguage":"ko-KR","@id":"https:\/\/www.pingcap.com\/#\/schema\/logo\/image\/","url":"https:\/\/static.pingcap.com\/files\/2021\/11\/pingcap-logo.png","contentUrl":"https:\/\/static.pingcap.com\/files\/2021\/11\/pingcap-logo.png","width":811,"height":232,"caption":"PingCAP"},"image":{"@id":"https:\/\/www.pingcap.com\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/facebook.com\/pingcap2015","https:\/\/x.com\/PingCAP","https:\/\/linkedin.com\/company\/pingcap","https:\/\/youtube.com\/channel\/UCuq4puT32DzHKT5rU1IZpIA"]},{"@type":"Person","@id":"https:\/\/www.pingcap.com\/#\/schema\/person\/1e6bb98f1263790c168616f68317ff87","name":"Leitao Guo","image":{"@type":"ImageObject","inLanguage":"ko-KR","@id":"https:\/\/www.pingcap.com\/#\/schema\/person\/image\/","url":"https:\/\/static.pingcap.com\/files\/2022\/10\/17234942\/avatar.jpg","contentUrl":"https:\/\/static.pingcap.com\/files\/2022\/10\/17234942\/avatar.jpg","caption":"Leitao Guo"},"description":"Database and Middleware Manager at iQIYI","url":"https:\/\/www.pingcap.com\/ko\/blog\/author\/leitao-guo\/"}]}},"grav_blocks":[{"acf_fc_layout":"resources","block_title":"Related Resources","block_title_desc":"","view_all_enabled":false,"view_all_text":"View All","view_all_link_type":"","relationship_source":"custom","num_results":3,"custom_tag":false,"custom_category":false,"custom_resource_ids":[9173,289,7506],"fill_remaining_resources":true,"block_background":"block-bg-none","block_background_video_type":"url","block_background_video_url":"","block_background_video_file":false,"block_background_image":false,"block_background_overlay":false,"unique_id":"","block_option_custom_class":"","block_option_padding":[],"block_option_hide":[],"block_add_top_arc":false,"block_increase_bottom_padding":false}],"card_markup":"<a class=\"card-resource bg-white\" href=\"https:\/\/www.pingcap.com\/ko\/blog\/how-to-efficiently-choose-the-right-database-for-your-applications\/\"><div class=\"card-resource__image-container\"><img class=\"card-resource__image\" alt=\"how-to-choose-database.jpg\" src=\"https:\/\/static.pingcap.com\/files\/2021\/02\/how-to-choose-database.jpg\" loading=\"lazy\" width=1600 height=534 \/><\/div><div class=\"card-resource__content-container\"><div class=\"card-resource__content-head\"><div class=\"card-resource__category\">Customer Story<\/div><\/div><h5 class=\"card-resource__title\">How to Efficiently Choose the Right Database for Your Applications<\/h5><\/div><\/a>","_links":{"self":[{"href":"https:\/\/www.pingcap.com\/ko\/wp-json\/wp\/v2\/posts\/578","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.pingcap.com\/ko\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.pingcap.com\/ko\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.pingcap.com\/ko\/wp-json\/wp\/v2\/users\/64"}],"replies":[{"embeddable":true,"href":"https:\/\/www.pingcap.com\/ko\/wp-json\/wp\/v2\/comments?post=578"}],"version-history":[{"count":28,"href":"https:\/\/www.pingcap.com\/ko\/wp-json\/wp\/v2\/posts\/578\/revisions"}],"predecessor-version":[{"id":17681,"href":"https:\/\/www.pingcap.com\/ko\/wp-json\/wp\/v2\/posts\/578\/revisions\/17681"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.pingcap.com\/ko\/wp-json\/wp\/v2\/media\/582"}],"wp:attachment":[{"href":"https:\/\/www.pingcap.com\/ko\/wp-json\/wp\/v2\/media?parent=578"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.pingcap.com\/ko\/wp-json\/wp\/v2\/categories?post=578"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.pingcap.com\/ko\/wp-json\/wp\/v2\/tags?post=578"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}