{"id":16940,"date":"2024-05-19T22:58:15","date_gmt":"2024-05-20T05:58:15","guid":{"rendered":"https:\/\/www.pingcap.com\/?post_type=article&#038;p=16940"},"modified":"2025-08-18T05:38:43","modified_gmt":"2025-08-18T12:38:43","slug":"revolutionizing-mysql-with-vector-similarity-search","status":"publish","type":"article","link":"https:\/\/www.pingcap.com\/ko\/article\/revolutionizing-mysql-with-vector-similarity-search\/","title":{"rendered":"Revolutionizing MySQL with Vector Similarity Search"},"content":{"rendered":"<p>TiDB Cloud Starter revolutionizes MySQL databases with its cutting-edge vector similarity search feature. By seamlessly integrating vector search capabilities, developers can now efficiently compare machine learning embeddings within their SQL environment. This innovative approach eliminates redundancy by storing vector embeddings alongside MySQL data directly, streamlining data management processes. The importance of this integration lies in enhancing AI applications through simplified data handling and leveraging SQL for advanced semantic searches.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"What_is_Vector_Similarity_Search\"><\/span>What is Vector Similarity Search?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Similarity Search is a fundamental method in data science for efficiently retrieving relevant information within extensive datasets. It enables the quick identification and ranking of similar vectors based on their underlying meaning rather than exact matches. This approach is crucial for tasks like image retrieval, recommendation systems, and fraud detection.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Advantages and Limitations of Similarity Search<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Efficient Retrieval<\/strong>: Similarity search allows for quick and accurate retrieval of semantically similar data.<\/li>\n\n\n\n<li><strong>\ud655\uc7a5\uc131<\/strong>: It enables efficient processing of large-scale datasets, making it ideal for applications with massive amounts of information.<\/li>\n\n\n\n<li><strong>Accuracy<\/strong>: By using distance metrics like cosine similarity or Euclidean distance, similarity search ensures precise results.<\/li>\n\n\n\n<li><strong>Limitations<\/strong>: While powerful, similarity search may face challenges with high-dimensional data due to the curse of dimensionality.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">Use Cases for Vector Similarity Search<\/h3>\n\n\n\n<p><strong>Image Search<\/strong><\/p>\n\n\n\n<p>Vector similarity search is widely used in image search engines to find visually similar images. By representing images as vectors, the system can quickly identify matching patterns or features.<\/p>\n\n\n\n<p><strong>Intelligent Recommendation<\/strong><\/p>\n\n\n\n<p>E-commerce platforms leverage vector similarity search to provide personalized recommendations to users. By analyzing user preferences as vectors, the system can suggest items that align with their tastes.<\/p>\n\n\n\n<p><strong>Fraud Detection<\/strong><\/p>\n\n\n\n<p>In finance and cybersecurity, vector similarity search plays a vital role in fraud detection. By comparing transaction patterns or user behavior as vectors, anomalies can be detected efficiently.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"TiDB_Cloud_Starter_and_Vector_Similarity_Search\"><\/span>TiDB Cloud Starter and Vector Similarity Search<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p><a href=\"\/ko\/tidb-cloud-starter\/\">TiDB Cloud \uc2a4\ud0c0\ud130<\/a> seamlessly integrates vector search capabilities into the MySQL landscape, empowering developers to harness the best of both worlds. By combining the reliability of MySQL with advanced functionalities of vector search, TiDB Cloud Starter opens up a world of possibilities for innovative AI applications.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Integration<\/h3>\n\n\n\n<h4 class=\"wp-block-heading\">How TiDB Cloud Starter integrates vector search<\/h4>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Effortless Integration<\/strong>: TiDB Cloud Starter smoothly incorporates vector search functionalities directly into the familiar MySQL environment. This integration simplifies the process for developers, allowing them to leverage advanced AI capabilities without extensive modifications to their existing systems.<\/li>\n\n\n\n<li><strong>Seamless Functionality<\/strong>: The integration of vector search into TiDB Cloud Starter ensures that developers can easily access and utilize these powerful features within their SQL workflows. This seamless functionality streamlines the development process and enhances productivity in building AI applications.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">Features<\/h3>\n\n\n\n<h4 class=\"wp-block-heading\">Built-in vector search capabilities<\/h4>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Advanced Search Capabilities<\/strong>: TiDB Cloud Starter offers built-in vector search capabilities that enable developers to perform complex similarity searches within their databases. This feature empowers users to efficiently compare machine learning embeddings and retrieve relevant information with precision.<\/li>\n\n\n\n<li><strong>Enhanced Data Retrieval<\/strong>: With its built-in vector search capabilities, TiDB Cloud Starter simplifies data retrieval processes by allowing users to quickly identify similar vectors based on underlying patterns or features. This functionality enhances the efficiency of searching through large datasets.<\/li>\n<\/ul>\n\n\n\n<p>\ud83d\udc49 <strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-vivid-cyan-blue-color\">Build AI applications confidently with SQL you already know well. <\/mark><\/strong><a href=\"https:\/\/tidb.cloud\/ai\/\" class=\"button button--secondary\" target=\"_blank\" data-gtag=\"event:go_to_lead_form_page,product_type:serverless,button_name:Join the Waitlist,position:blog_middle\" rel=\"noopener\">Join the Waitlist<\/a><br><\/p>\n\n\n\n<h3 class=\"wp-block-heading\">\uc0ac\uc6a9 \uc0ac\ub840<\/h3>\n\n\n\n<h4 class=\"wp-block-heading\">Examples of applications using TiDB Cloud Starter<\/h4>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Image Search Applications<\/strong>: Developers can leverage TiDB Cloud Starter for image search applications, where visual similarity plays a crucial role in retrieving relevant images. By representing images as vectors, this solution enables quick and accurate matching based on visual patterns.<\/li>\n\n\n\n<li><strong>RAG Applications<\/strong>: TiDB Cloud Starter is ideal for applications requiring semantic searches, such as RAG (Retrieval-Augmented Generation) models. By integrating vector search capabilities, developers can enhance the performance of RAG applications by efficiently retrieving semantically similar data.<\/li>\n\n\n\n<li><strong>Chat Applications<\/strong>: In chat applications where understanding context is essential, TiDB Cloud Starter with vector similarity search proves invaluable. By analyzing text inputs as vectors, developers can implement intelligent chatbots that provide relevant responses based on semantic similarities.<\/li>\n<\/ul>\n\n\n\n<p>By seamlessly integrating vector search capabilities into the MySQL ecosystem, TiDB Cloud Starter empowers developers to unlock the potential of innovative AI applications while maintaining the simplicity and familiarity of SQL-based environments.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Benefits_of_TiDB_Cloud_Starter\"><\/span>Benefits of TiDB Cloud Starter<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">Simplified Data Management<\/h3>\n\n\n\n<p>Storing vector embeddings alongside MySQL data simplifies the process of managing information in TiDB Cloud Starter. By integrating vector search capabilities directly into the database, developers can efficiently handle both operational and vector data within a single environment. This streamlined approach eliminates the need for separate storage solutions, reducing redundancy and enhancing overall data organization.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Enhanced AI Capabilities<\/h4>\n\n\n\n<p>Leveraging SQL for AI applications is a key advantage of TiDB Cloud Starter. Developers can harness the power of familiar SQL commands to access and manipulate vector data seamlessly. This integration enables the creation of advanced AI models that leverage both structured and unstructured information for enhanced decision-making processes.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Compatibility<\/h3>\n\n\n\n<p>Integration with popular AI platforms further enhances the versatility of TiDB Cloud Starter. By seamlessly connecting with platforms like OpenAI, Hugging Face, <a href=\"https:\/\/python.langchain.com\/v0.1\/docs\/integrations\/memory\/tidb_chat_message_history\/\" target=\"_blank\" rel=\"noreferrer noopener\">LangChain<\/a>, \uadf8\ub9ac\uace0 <a href=\"https:\/\/docs.llamaindex.ai\/en\/stable\/examples\/vector_stores\/TiDBVector\/\" target=\"_blank\" rel=\"noreferrer noopener\">LlamaIndex<\/a>, developers gain access to a wide range of tools and resources for building innovative AI applications. This compatibility ensures that TiDB Cloud Starter remains at the forefront of AI technology advancements.<\/p>\n\n\n\n<p>TiDB Cloud Starter offers a seamless solution for developers and companies, <a href=\"https:\/\/www.pingcap.com\/ko\/blog\/low-code-development-backend-apps-tidb-cloud-data-services\/\" target=\"_blank\" rel=\"noreferrer noopener\">enhancing productivity<\/a>, accelerating time-to-market, and making innovation more accessible. By combining traditional database functionality with advanced vector search capabilities, TiDB Cloud Starter <a href=\"\/ko\/blog\/integrating-vector-search-into-tidb-for-ai-applications\/\" target=\"_blank\" rel=\"noreferrer noopener\">provides scalability<\/a> to meet the demands of various AI applications. The platform facilitates easier onboarding, lowers collaboration expenses, and guarantees agile project development. With an AI-assisted SQL Editor and support for high-performance analytics, TiDB Cloud Starter empowers developers to <a href=\"\/ko\/article\/unlocking-semantic-search-with-tidb-serverless\/\" target=\"_blank\" rel=\"noreferrer noopener\">enhance productivity<\/a> and derive real-time data insights.<\/p>","protected":false},"excerpt":{"rendered":"<p>TiDB Cloud Starter revolutionizes MySQL databases with its cutting-edge vector similarity search feature. By seamlessly integrating vector search capabilities, developers can now efficiently compare machine learning embeddings within their SQL environment. This innovative approach eliminates redundancy by storing vector embeddings alongside MySQL data directly, streamlining data management processes. The importance of this integration lies in [&hellip;]<\/p>\n","protected":false},"author":8,"featured_media":0,"template":"","class_list":["post-16940","article","type-article","status-publish","hentry"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.9 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Revolutionizing MySQL with Vector Similarity Search | TiDB<\/title>\n<meta name=\"description\" content=\"Discover how TiDB Cloud Starter redefines MySQL with advanced Similarity Search capabilities. Explore the future of Modern Databases.\" \/>\n<meta name=\"robots\" content=\"noindex, follow\" \/>\n<meta property=\"og:locale\" content=\"ko_KR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Revolutionizing MySQL with Vector Similarity Search | TiDB\" \/>\n<meta property=\"og:description\" content=\"Discover how TiDB Cloud Starter redefines MySQL with advanced Similarity Search capabilities. Explore the future of Modern Databases.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.pingcap.com\/ko\/article\/revolutionizing-mysql-with-vector-similarity-search\/\" \/>\n<meta property=\"og:site_name\" content=\"TiDB\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/facebook.com\/pingcap2015\" \/>\n<meta property=\"article:modified_time\" content=\"2025-08-18T12:38:43+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/static.pingcap.com\/files\/2024\/09\/11005522\/Homepage-Ad.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1440\" \/>\n\t<meta property=\"og:image:height\" content=\"714\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:site\" content=\"@PingCAP\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"5\ubd84\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.pingcap.com\/article\/revolutionizing-mysql-with-vector-similarity-search\/\",\"url\":\"https:\/\/www.pingcap.com\/article\/revolutionizing-mysql-with-vector-similarity-search\/\",\"name\":\"Revolutionizing MySQL with Vector Similarity Search | TiDB\",\"isPartOf\":{\"@id\":\"https:\/\/www.pingcap.com\/#website\"},\"datePublished\":\"2024-05-20T05:58:15+00:00\",\"dateModified\":\"2025-08-18T12:38:43+00:00\",\"description\":\"Discover how TiDB Cloud Starter redefines MySQL with advanced Similarity Search capabilities. Explore the future of Modern Databases.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.pingcap.com\/article\/revolutionizing-mysql-with-vector-similarity-search\/#breadcrumb\"},\"inLanguage\":\"ko-KR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.pingcap.com\/article\/revolutionizing-mysql-with-vector-similarity-search\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.pingcap.com\/article\/revolutionizing-mysql-with-vector-similarity-search\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.pingcap.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Articles\",\"item\":\"https:\/\/www.pingcap.com\/article\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Revolutionizing MySQL with Vector Similarity Search\"}]},{\"@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\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Revolutionizing MySQL with Vector Similarity Search | TiDB","description":"Discover how TiDB Cloud Starter redefines MySQL with advanced Similarity Search capabilities. Explore the future of Modern Databases.","robots":{"index":"noindex","follow":"follow"},"og_locale":"ko_KR","og_type":"article","og_title":"Revolutionizing MySQL with Vector Similarity Search | TiDB","og_description":"Discover how TiDB Cloud Starter redefines MySQL with advanced Similarity Search capabilities. Explore the future of Modern Databases.","og_url":"https:\/\/www.pingcap.com\/ko\/article\/revolutionizing-mysql-with-vector-similarity-search\/","og_site_name":"TiDB","article_publisher":"https:\/\/facebook.com\/pingcap2015","article_modified_time":"2025-08-18T12:38:43+00:00","og_image":[{"width":1440,"height":714,"url":"https:\/\/static.pingcap.com\/files\/2024\/09\/11005522\/Homepage-Ad.png","type":"image\/png"}],"twitter_card":"summary_large_image","twitter_site":"@PingCAP","twitter_misc":{"Est. reading time":"5\ubd84"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.pingcap.com\/article\/revolutionizing-mysql-with-vector-similarity-search\/","url":"https:\/\/www.pingcap.com\/article\/revolutionizing-mysql-with-vector-similarity-search\/","name":"Revolutionizing MySQL with Vector Similarity Search | TiDB","isPartOf":{"@id":"https:\/\/www.pingcap.com\/#website"},"datePublished":"2024-05-20T05:58:15+00:00","dateModified":"2025-08-18T12:38:43+00:00","description":"Discover how TiDB Cloud Starter redefines MySQL with advanced Similarity Search capabilities. Explore the future of Modern Databases.","breadcrumb":{"@id":"https:\/\/www.pingcap.com\/article\/revolutionizing-mysql-with-vector-similarity-search\/#breadcrumb"},"inLanguage":"ko-KR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.pingcap.com\/article\/revolutionizing-mysql-with-vector-similarity-search\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.pingcap.com\/article\/revolutionizing-mysql-with-vector-similarity-search\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.pingcap.com\/"},{"@type":"ListItem","position":2,"name":"Articles","item":"https:\/\/www.pingcap.com\/article\/"},{"@type":"ListItem","position":3,"name":"Revolutionizing MySQL with Vector Similarity Search"}]},{"@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"]}]}},"card_markup":"        <a class=\"card-article\" href=\"https:\/\/www.pingcap.com\/ko\/article\/revolutionizing-mysql-with-vector-similarity-search\/\">            <h3>Revolutionizing MySQL with Vector Similarity Search<\/h3>            <p>TiDB Cloud Starter revolutionizes MySQL databases with its cutting-edge vector similarity search feature. By seamlessly integrating vector search capabilities, developers can now efficiently compare machine learning embeddings within their SQL environment. This innovative approach eliminates redundancy by storing vector embeddings alongside MySQL data directly, streamlining data management processes. The importance of this integration lies in [&hellip;]<\/p>        <\/a>","_links":{"self":[{"href":"https:\/\/www.pingcap.com\/ko\/wp-json\/wp\/v2\/article\/16940","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.pingcap.com\/ko\/wp-json\/wp\/v2\/article"}],"about":[{"href":"https:\/\/www.pingcap.com\/ko\/wp-json\/wp\/v2\/types\/article"}],"author":[{"embeddable":true,"href":"https:\/\/www.pingcap.com\/ko\/wp-json\/wp\/v2\/users\/8"}],"wp:attachment":[{"href":"https:\/\/www.pingcap.com\/ko\/wp-json\/wp\/v2\/media?parent=16940"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}