{"id":8258,"date":"2020-03-06T09:17:24","date_gmt":"2020-03-06T17:17:24","guid":{"rendered":"https:\/\/www.couchbase.com\/blog\/?p=8258"},"modified":"2025-06-13T18:44:29","modified_gmt":"2025-06-14T01:44:29","slug":"sql-to-nosql-7-metrics-to-compare-query-language","status":"publish","type":"post","link":"https:\/\/www.couchbase.com\/blog\/pt\/sql-to-nosql-7-metrics-to-compare-query-language\/","title":{"rendered":"Uma compara\u00e7\u00e3o de 3 linguagens de consulta NoSQL em 7 m\u00e9tricas"},"content":{"rendered":"<p><span style=\"font-weight: 400\">As organiza\u00e7\u00f5es que desejam aproveitar os muitos benef\u00edcios dos bancos de dados de documentos NoSQL geralmente se deparam com dois desafios:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Como converter seus esquemas de RDBMS para aproveitar o modelo de documento sem esquema.<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Aprenda uma nova API\/Query para acessar os dados.<\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400\">Algumas pessoas tamb\u00e9m se confundem com o nome NoSQL. A abrevia\u00e7\u00e3o significa \"Not only SQL\" (N\u00e3o apenas SQL), mas tamb\u00e9m pode ser mal interpretada como \"No to SQL\" (N\u00e3o ao SQL), aceitando assim que, para usar um <a href=\"https:\/\/www.couchbase.com\/blog\/pt\/resources\/why-nosql\/\">Banco de dados NoSQL<\/a>Se o banco de dados NoSQL for selecionado, as organiza\u00e7\u00f5es n\u00e3o s\u00f3 ter\u00e3o que converter seu modelo de dados relacional em um modelo de documento, mas tamb\u00e9m receber\u00e3o treinamento sobre as APIs do banco de dados NoSQL que selecionar\u00e3o.<\/span><\/p>\n<p><span style=\"font-weight: 400\">Na realidade, o setor de bancos de dados NoSQL nunca abandonou o acesso a dados mais popular para bancos de dados. Muitos fornecedores de NoSQL ainda est\u00e3o usando uma varia\u00e7\u00e3o do SQL. <\/span><a href=\"https:\/\/docs.microsoft.com\/en-us\/azure\/cosmos-db\/sql-query-getting-started\"><span style=\"font-weight: 400\">Cosmos DB<\/span><\/a><span style=\"font-weight: 400\">, <\/span><a href=\"https:\/\/cassandra.apache.org\/doc\/latest\/cql\/\"><span style=\"font-weight: 400\">Cassandra CQL<\/span><\/a><span style=\"font-weight: 400\">, <\/span><a href=\"https:\/\/www.elastic.co\/guide\/en\/elasticsearch\/reference\/current\/sql-overview.html\"><span style=\"font-weight: 400\">Elasticsearch SQL<\/span><\/a><span style=\"font-weight: 400\">, <\/span><a href=\"https:\/\/www.cockroachlabs.com\/docs\/stable\/learn-cockroachdb-sql.html\"><span style=\"font-weight: 400\">Laborat\u00f3rios Cockroach<\/span><\/a><span style=\"font-weight: 400\">. Mesmo com <\/span><a href=\"https:\/\/docs.mongodb.com\/manual\/reference\/operator\/query\/\"><span style=\"font-weight: 400\">Consulta ao Mongodb<\/span><\/a><span style=\"font-weight: 400\"> voc\u00ea ver\u00e1 que ela se baseia na constru\u00e7\u00e3o select-join-project, que \u00e9 a base da \u00e1lgebra relacional usada no SQL.<\/span><\/p>\n<p><span style=\"font-weight: 400\">Uma empresa de banco de dados no espa\u00e7o NoSQL que abordou totalmente essa quest\u00e3o da linguagem de consulta \u00e9 a <a href=\"https:\/\/www.couchbase.com\/blog\/pt\/\">Couchbase<\/a>. Embora o Couchbase armazene os dados no formato JSON nativo, o modelo de dados que ele suporta pode ser uma estrutura relacional ou hier\u00e1rquica, que \u00e9 frequentemente usada no modelo baseado em documentos por sua flexibilidade e extensibilidade de esquema. Isso \u00e9 poss\u00edvel porque o Couchbase fornece um <a href=\"https:\/\/www.couchbase.com\/blog\/pt\/products\/n1ql\/\">SQL<\/a>-linguagem de consulta semelhante \u00e0 SQL - N1QL, que amplia a linguagem SQL para permitir que os usu\u00e1rios manipulem a natureza hier\u00e1rquica do modelo de documento. Tudo isso \u00e9 constru\u00eddo sobre o servi\u00e7o de dados de alto desempenho do Couchbase com suas APIs de valor-chave.<\/span><\/p>\n<p>As organiza\u00e7\u00f5es que desejam garantir que seus investimentos em bancos de dados aproveitem os benef\u00edcios atualmente dispon\u00edveis com <strong><a href=\"https:\/\/www.couchbase.com\/blog\/pt\/resources\/why-nosql\/\">Tecnologia NoSQL<\/a><\/strong> devem ser observados:<\/p>\n<ul>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">O suporte de dados estruturados e n\u00e3o estruturados\u00a0<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Escalabilidade horizontal<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Evolu\u00e7\u00e3o do esquema f\u00e1cil de gerenciar<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Talvez a mais importante de todas seja a op\u00e7\u00e3o de escolha de fornecedor, al\u00e9m dos atuais fornecedores de RDBMS que dominaram o mercado de bancos de dados nas \u00faltimas tr\u00eas d\u00e9cadas.<\/span><\/li>\n<\/ul>\n<p>Para ajudar os clientes em sua decis\u00e3o, a Altoros - uma empresa que se concentra em ajudar as empresas a mudar de seu sistema de TI legado para o futuro - publicou um <a href=\"https:\/\/resources.couchbase.com\/c\/altoros-database-query-report?x=N-I_ik\">relat\u00f3rio<\/a> para comparar a linguagem de consulta nos bancos de dados mais populares da atualidade. Ele optou por se concentrar em <a href=\"https:\/\/www.mysql.com\/\">MySQL\/SQL<\/a>, <a href=\"https:\/\/www.couchbase.com\/blog\/pt\/products\/n1ql\/\">Couchbase N1QL<\/a>e <a href=\"https:\/\/docs.mongodb.com\/manual\/reference\/operator\/query\/\">Consulta ao MongoDB<\/a> linguagens. Cada linguagem de consulta foi avaliada quanto \u00e0s suas implementa\u00e7\u00f5es para atender aos diferentes cen\u00e1rios de consulta usando as seguintes m\u00e9tricas.<\/p>\n<ol>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Simplicidade<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Legibilidade<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Expressividade<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Flexibilidade<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Disponibilidade de habilidades<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Linha de c\u00f3digos<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">O n\u00famero de viagens do aplicativo para o servidor<\/span><\/li>\n<\/ol>\n<p><span style=\"font-weight: 400\">Voc\u00ea pode obter mais detalhes sobre esse relat\u00f3rio no site <\/span><a href=\"https:\/\/www.altoros.com\/search?s=Couchbase&amp;src=blog\"><span style=\"font-weight: 400\">Site da Altoros<\/span><\/a>e tamb\u00e9m est\u00e1 dispon\u00edvel aqui em <a href=\"https:\/\/resources.couchbase.com\/c\/altoros-database-query-report\"><strong>o que est\u00e1 na coluna \"Novo\".<\/strong><\/a><\/p>\n<p>Todos os exemplos de consultas e despejos de banco de dados em linguagem NoSQL que podem ajudar a implementar e executar todos os cen\u00e1rios deste relat\u00f3rio podem ser encontrados neste reposit\u00f3rio do GitHub.<\/p>\n<h2><b>A metodologia do relat\u00f3rio da Altoros<\/b><\/h2>\n<p><span style=\"font-weight: 400\">O objetivo do relat\u00f3rio \u00e9 comparar as linguagens de consulta sob a perspectiva dos aplicativos RDBMS tradicionais. Para isso, foram selecionadas:<\/span><\/p>\n<p><span style=\"font-weight: 400\">Um modo de aplicativo de gerenciamento de atividades, geralmente encontrado em muitos dos sistemas de CRM que gerenciam as atividades de vendas, servi\u00e7os e marketing. A configura\u00e7\u00e3o do relat\u00f3rio inclui o modelo relacional e o modelo de documento que s\u00e3o usados pelo Couchbase e pelo MongoDB<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-8259\" src=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2020\/03\/Screen-Shot-2020-03-06-at-7.24.02-AM.png\" alt=\"\" width=\"1088\" height=\"543\" srcset=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2020\/03\/Screen-Shot-2020-03-06-at-7.24.02-AM.png 1586w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2020\/03\/Screen-Shot-2020-03-06-at-7.24.02-AM-300x150.png 300w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2020\/03\/Screen-Shot-2020-03-06-at-7.24.02-AM-1024x511.png 1024w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2020\/03\/Screen-Shot-2020-03-06-at-7.24.02-AM-768x384.png 768w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2020\/03\/Screen-Shot-2020-03-06-at-7.24.02-AM-1536x767.png 1536w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2020\/03\/Screen-Shot-2020-03-06-at-7.24.02-AM-20x10.png 20w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2020\/03\/Screen-Shot-2020-03-06-at-7.24.02-AM-1320x659.png 1320w\" sizes=\"auto, (max-width: 1088px) 100vw, 1088px\" \/><\/p>\n<p><span style=\"font-weight: 400\">Ele tamb\u00e9m usa um conjunto de cen\u00e1rios de consulta que a maioria dos usu\u00e1rios desses sistemas reconheceria.\u00a0<\/span><\/p>\n<table>\n<tbody>\n<tr>\n<td><b>Cen\u00e1rio<\/b><\/td>\n<td><b>Descri\u00e7\u00e3o<\/b><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400\">1. Relat\u00f3rio de reuni\u00e3o de clientes<\/span><\/td>\n<td><span style=\"font-weight: 400\">Para me preparar para as reuni\u00f5es com clientes que participarei na pr\u00f3xima semana, quero obter uma lista de todos os clientes que participar\u00e3o das reuni\u00f5es e seus contatos.<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400\">2. Relat\u00f3rio de territ\u00f3rio de vendas regional<\/span><\/td>\n<td><span style=\"font-weight: 400\">Sou gerente regional de vendas do territ\u00f3rio de C-Suite Sellers. Quero obter todas as contas atribu\u00eddas a esse territ\u00f3rio e os membros da equipe de contas.<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400\">3. Os 10 principais setores dos clientes<\/span><\/td>\n<td><span style=\"font-weight: 400\">Determinar os 10 principais setores de nossos clientes com base nas atividades de vendas de 2018.<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400\">4. Organiza\u00e7\u00f5es de vendas<\/span><\/td>\n<td><span style=\"font-weight: 400\">Quero saber quanto tempo gastamos conversando com as contas atribu\u00eddas ao meu territ\u00f3rio no terceiro trimestre do ano fiscal de 2019.<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400\">5. Um relat\u00f3rio de atividade de vendas<\/span><\/td>\n<td><span style=\"font-weight: 400\">Como o n\u00famero de tarefas relacionadas a vendas mudou de um m\u00eas para outro durante o ano de 2018.<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400\">6. Conjunto de habilidades da equipe de vendas<\/span><\/td>\n<td><span style=\"font-weight: 400\">Uma an\u00e1lise dos conjuntos de habilidades\/fun\u00e7\u00f5es da equipe de vendas na organiza\u00e7\u00e3o de vendas atual<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400\">7. Relat\u00f3rio de intera\u00e7\u00f5es com clientes<\/span><\/td>\n<td><span style=\"font-weight: 400\">Uma consulta para revisar todas as apresenta\u00e7\u00f5es que realizamos com os clientes no CY19Q4 com m\u00e9tricas detalhadas sobre o tempo gasto para cada cliente e a efic\u00e1cia da reuni\u00e3o.<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400\">8. Analisar o sentimento das avalia\u00e7\u00f5es de hot\u00e9is<\/span><\/td>\n<td><span style=\"font-weight: 400\">Chamada da API de linguagem natural do Google para classificar todas as avalia\u00e7\u00f5es com base na pontua\u00e7\u00e3o de sentimento<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400\">9. Um relat\u00f3rio de pesquisa de texto para identificar reuni\u00f5es de clientes<\/span><\/td>\n<td><span style=\"font-weight: 400\">Identificar as contas de clientes e seus contatos relacionados, onde um determinado t\u00f3pico foi discutido. Os crit\u00e9rios de pesquisa podem incluir as seguintes informa\u00e7\u00f5es, parcial ou totalmente: um t\u00edtulo de reuni\u00e3o, um intervalo de datas de reuni\u00e3o, detalhes de contato do cliente, detalhes de membros da equipe de vendas (participantes) e um nome de cliente.<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p><span style=\"font-weight: 400\">Para cada cen\u00e1rio, o relat\u00f3rio fornece as solu\u00e7\u00f5es correspondentes escritas em linguagem de consulta SQL, N1QL e MongoDB.<\/span><\/p>\n<ol>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">O relat\u00f3rio fornece uma classifica\u00e7\u00e3o para cada linguagem de consulta com base nos seguintes crit\u00e9rios.<\/span>\n<ul>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Simplicidade<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Legibilidade<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Expressividade<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Flexibilidade<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Disponibilidade de habilidades<\/span><\/li>\n<\/ul>\n<\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">O relat\u00f3rio tamb\u00e9m tabula duas m\u00e9tricas adicionais para o n\u00famero de linhas de c\u00f3digo e o n\u00famero de viagens cliente-servidor exigidas por cada linguagem de consulta em cada solu\u00e7\u00e3o dos nove cen\u00e1rios.\u00a0<\/span><\/li>\n<\/ol>\n<h2><b>Os resultados dos crit\u00e9rios de avalia\u00e7\u00e3o<\/b><\/h2>\n<p><span style=\"font-weight: 400\">A tabela abaixo \u00e9 um resumo de todas as classifica\u00e7\u00f5es de todos os cen\u00e1rios de consulta. Consulte o relat\u00f3rio para obter a avalia\u00e7\u00e3o individual de cada um dos cen\u00e1rios de consulta.\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400\">Usando o MySQL-SQL como ponto de refer\u00eancia, o relat\u00f3rio avalia o Couchbase N1QL e a linguagem de consulta do MongoDB com base em v\u00e1rios crit\u00e9rios.\u00a0<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-8260\" src=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2020\/03\/Screen-Shot-2020-03-06-at-7.25.21-AM.png\" alt=\"\" width=\"1566\" height=\"692\" srcset=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2020\/03\/Screen-Shot-2020-03-06-at-7.25.21-AM.png 1566w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2020\/03\/Screen-Shot-2020-03-06-at-7.25.21-AM-300x133.png 300w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2020\/03\/Screen-Shot-2020-03-06-at-7.25.21-AM-1024x452.png 1024w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2020\/03\/Screen-Shot-2020-03-06-at-7.25.21-AM-768x339.png 768w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2020\/03\/Screen-Shot-2020-03-06-at-7.25.21-AM-1536x679.png 1536w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2020\/03\/Screen-Shot-2020-03-06-at-7.25.21-AM-20x9.png 20w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2020\/03\/Screen-Shot-2020-03-06-at-7.25.21-AM-1320x583.png 1320w\" sizes=\"auto, (max-width: 1566px) 100vw, 1566px\" \/><\/p>\n<h5><span style=\"font-weight: 400\">Observa\u00e7\u00f5es:<\/span><\/h5>\n<ol>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">A Altoros, que trabalhou com MongoDB, Cassandra e RedisLab, descobriu que o N1QL \u00e9 muito semelhante ao SQL e, de forma consistente, deu a ele uma classifica\u00e7\u00e3o mais favor\u00e1vel do que a linguagem de consulta do MongoDB.<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">O c\u00f3digo de amostra para o cen\u00e1rio #3 mostra que as tr\u00eas linguagens de consulta s\u00e3o relativamente semelhantes para os cen\u00e1rios de consulta simples e t\u00eam classifica\u00e7\u00f5es de crit\u00e9rios de avalia\u00e7\u00e3o semelhantes.\u00a0<\/span><\/li>\n<\/ol>\n<h3><b>O n\u00famero de linhas de c\u00f3digo<\/b><\/h3>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-8261\" src=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2020\/03\/Screen-Shot-2020-03-06-at-7.25.50-AM.png\" alt=\"\" width=\"1606\" height=\"974\" srcset=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2020\/03\/Screen-Shot-2020-03-06-at-7.25.50-AM.png 1606w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2020\/03\/Screen-Shot-2020-03-06-at-7.25.50-AM-300x182.png 300w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2020\/03\/Screen-Shot-2020-03-06-at-7.25.50-AM-1024x621.png 1024w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2020\/03\/Screen-Shot-2020-03-06-at-7.25.50-AM-768x466.png 768w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2020\/03\/Screen-Shot-2020-03-06-at-7.25.50-AM-1536x932.png 1536w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2020\/03\/Screen-Shot-2020-03-06-at-7.25.50-AM-20x12.png 20w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2020\/03\/Screen-Shot-2020-03-06-at-7.25.50-AM-1320x801.png 1320w\" sizes=\"auto, (max-width: 1606px) 100vw, 1606px\" \/><\/p>\n<p><span style=\"font-weight: 400\">O gr\u00e1fico mostra o n\u00famero de linhas de c\u00f3digo para cada consulta. Embora essa m\u00e9trica possa estar sujeita a deturpa\u00e7\u00f5es, pois todas as linguagens de consulta t\u00eam sua pr\u00f3pria formata\u00e7\u00e3o recomendada, ela pode fornecer um guia simples sobre a complexidade envolvida.\u00a0\u00a0<\/span><\/p>\n<h5><span style=\"font-weight: 400\">Observa\u00e7\u00f5es:<\/span><\/h5>\n<ul>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">A linguagem de consulta N1QL NoSQL tem aproximadamente o mesmo n\u00famero de linhas de c\u00f3digo que o SQL.<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">A linguagem de consulta do MongoDB tem consistentemente mais linhas de c\u00f3digo.<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Para o cen\u00e1rio #7, a equipe da Altoros teve que escrever 347 linhas para a linguagem de consulta do MongoDB, em compara\u00e7\u00e3o com 21 linhas do N1QL. Essa diferen\u00e7a reflete as limita\u00e7\u00f5es da linguagem de consulta do MongoDB para computar agrega\u00e7\u00f5es complexas e express\u00f5es de tabela comuns (<\/span><a href=\"https:\/\/docs.couchbase.com\/server\/current\/n1ql\/n1ql-language-reference\/with.html\"><span style=\"font-weight: 400\">CTE<\/span><\/a><span style=\"font-weight: 400\">) que o SQL, e agora o N1QL, sempre foram os principais pontos fortes da tecnologia de banco de dados relacional nas \u00faltimas d\u00e9cadas.<\/span><\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-8266\" src=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2020\/03\/Screen-Shot-2020-03-06-at-7.41.13-AM.png\" alt=\"\" width=\"468\" height=\"403\" srcset=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2020\/03\/Screen-Shot-2020-03-06-at-7.41.13-AM.png 744w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2020\/03\/Screen-Shot-2020-03-06-at-7.41.13-AM-300x258.png 300w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2020\/03\/Screen-Shot-2020-03-06-at-7.41.13-AM-20x17.png 20w\" sizes=\"auto, (max-width: 468px) 100vw, 468px\" \/><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-8262\" src=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2020\/03\/Screen-Shot-2020-03-06-at-7.26.19-AM.png\" alt=\"\" width=\"879\" height=\"644\" srcset=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2020\/03\/Screen-Shot-2020-03-06-at-7.26.19-AM.png 1602w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2020\/03\/Screen-Shot-2020-03-06-at-7.26.19-AM-300x220.png 300w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2020\/03\/Screen-Shot-2020-03-06-at-7.26.19-AM-1024x750.png 1024w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2020\/03\/Screen-Shot-2020-03-06-at-7.26.19-AM-768x563.png 768w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2020\/03\/Screen-Shot-2020-03-06-at-7.26.19-AM-1536x1126.png 1536w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2020\/03\/Screen-Shot-2020-03-06-at-7.26.19-AM-20x15.png 20w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2020\/03\/Screen-Shot-2020-03-06-at-7.26.19-AM-1320x967.png 1320w\" sizes=\"auto, (max-width: 879px) 100vw, 879px\" \/><\/p>\n<h3><b>O n\u00famero de viagens cliente-servidor<\/b><\/h3>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-8263\" src=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2020\/03\/Screen-Shot-2020-03-06-at-7.26.48-AM.png\" alt=\"\" width=\"889\" height=\"557\" srcset=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2020\/03\/Screen-Shot-2020-03-06-at-7.26.48-AM.png 1550w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2020\/03\/Screen-Shot-2020-03-06-at-7.26.48-AM-300x188.png 300w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2020\/03\/Screen-Shot-2020-03-06-at-7.26.48-AM-1024x642.png 1024w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2020\/03\/Screen-Shot-2020-03-06-at-7.26.48-AM-768x482.png 768w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2020\/03\/Screen-Shot-2020-03-06-at-7.26.48-AM-1536x963.png 1536w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2020\/03\/Screen-Shot-2020-03-06-at-7.26.48-AM-20x13.png 20w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2020\/03\/Screen-Shot-2020-03-06-at-7.26.48-AM-1320x828.png 1320w\" sizes=\"auto, (max-width: 889px) 100vw, 889px\" \/><\/p>\n<p><span style=\"font-weight: 400\">O gr\u00e1fico mostra o n\u00famero de viagens que o aplicativo precisa enviar ao servidor de banco de dados.\u00a0<\/span><\/p>\n<h5><span style=\"font-weight: 400\">Observa\u00e7\u00f5es:<\/span><\/h5>\n<ol>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Na maioria dos cen\u00e1rios, o SQL\/N1QL exige apenas um \u00fanico envio de consulta ao servidor, enquanto a consulta do MongoDB exige v\u00e1rias viagens. Isso se deve \u00e0 expressividade do SQL\/N1QL, em que os desenvolvedores de aplicativos s\u00f3 precisam declarar a sa\u00edda desejada, e cabe ao servidor processar e retornar os resultados.<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">A falta de suporte \u00e0 agrega\u00e7\u00e3o complexa exige que o MongoDB execute seu c\u00e1lculo em v\u00e1rias fases. Isso \u00e9 semelhante \u00e0 abordagem de subconsulta SQL padr\u00e3o. A diferen\u00e7a aqui \u00e9 que os conjuntos de resultados das subconsultas precisam ser mantidos nos aplicativos clientes, que s\u00e3o posteriormente passados para outra consulta.<\/span><\/li>\n<\/ol>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-8264\" src=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2020\/03\/Screen-Shot-2020-03-06-at-7.27.43-AM.png\" alt=\"\" width=\"821\" height=\"868\" srcset=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2020\/03\/Screen-Shot-2020-03-06-at-7.27.43-AM.png 1298w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2020\/03\/Screen-Shot-2020-03-06-at-7.27.43-AM-284x300.png 284w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2020\/03\/Screen-Shot-2020-03-06-at-7.27.43-AM-969x1024.png 969w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2020\/03\/Screen-Shot-2020-03-06-at-7.27.43-AM-768x812.png 768w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2020\/03\/Screen-Shot-2020-03-06-at-7.27.43-AM-300x317.png 300w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2020\/03\/Screen-Shot-2020-03-06-at-7.27.43-AM-20x20.png 20w\" sizes=\"auto, (max-width: 821px) 100vw, 821px\" \/><\/p>\n<h2><b>Principais conclus\u00f5es do relat\u00f3rio<\/b><\/h2>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-8265\" src=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2020\/03\/Screen-Shot-2020-03-06-at-7.28.07-AM.png\" alt=\"\" width=\"1282\" height=\"592\" srcset=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2020\/03\/Screen-Shot-2020-03-06-at-7.28.07-AM.png 1282w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2020\/03\/Screen-Shot-2020-03-06-at-7.28.07-AM-300x139.png 300w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2020\/03\/Screen-Shot-2020-03-06-at-7.28.07-AM-1024x473.png 1024w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2020\/03\/Screen-Shot-2020-03-06-at-7.28.07-AM-768x355.png 768w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2020\/03\/Screen-Shot-2020-03-06-at-7.28.07-AM-20x9.png 20w\" sizes=\"auto, (max-width: 1282px) 100vw, 1282px\" \/><\/p>","protected":false},"excerpt":{"rendered":"<p>Organizations who want to take advantage of the many benefits of NoSQL document databases, often find that they have two challenges: How to convert their RDBMS schemas to leverage the schema-less document model. Learn a new API\/Query to access the [&hellip;]<\/p>","protected":false},"author":26326,"featured_media":10645,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"inline_featured_image":false,"footnotes":""},"categories":[1814,1819,1812],"tags":[1261,1309,1725],"ppma_author":[8919],"class_list":["post-8258","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-application-design","category-data-modeling","category-n1ql-query","tag-json","tag-mongodb","tag-nosql-database"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v26.3 (Yoast SEO v26.3) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>A Comparison of 3 NoSQL Query Languages Across 7 Metrics<\/title>\n<meta name=\"description\" content=\"See how Couchbase N1QL, MongoDB query, and MySQL\/SQL compare across 7 key metrics here. We summarize the findings of Altoros&#039; report on resilient IT.\" \/>\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.couchbase.com\/blog\/pt\/sql-to-nosql-7-metrics-to-compare-query-language\/\" \/>\n<meta property=\"og:locale\" content=\"pt_BR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"A Comparison of 3 NoSQL Query Languages Across 7 Metrics\" \/>\n<meta property=\"og:description\" content=\"See how Couchbase N1QL, MongoDB query, and MySQL\/SQL compare across 7 key metrics here. We summarize the findings of Altoros&#039; report on resilient IT.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.couchbase.com\/blog\/pt\/sql-to-nosql-7-metrics-to-compare-query-language\/\" \/>\n<meta property=\"og:site_name\" content=\"The Couchbase Blog\" \/>\n<meta property=\"article:published_time\" content=\"2020-03-06T17:17:24+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-06-14T01:44:29+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2020\/03\/Screen-Shot-2020-03-06-at-7.49.11-AM_RESIZED.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1750\" \/>\n\t<meta property=\"og:image:height\" content=\"647\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Binh Le\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Binh Le\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"8 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/sql-to-nosql-7-metrics-to-compare-query-language\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/sql-to-nosql-7-metrics-to-compare-query-language\/\"},\"author\":{\"name\":\"Binh Le\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/f89064928e262c71eb43bee996c48c63\"},\"headline\":\"A Comparison of 3 NoSQL Query Languages Across 7 Metrics\",\"datePublished\":\"2020-03-06T17:17:24+00:00\",\"dateModified\":\"2025-06-14T01:44:29+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/sql-to-nosql-7-metrics-to-compare-query-language\/\"},\"wordCount\":1284,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/sql-to-nosql-7-metrics-to-compare-query-language\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2020\/03\/Screen-Shot-2020-03-06-at-7.49.11-AM_RESIZED.png\",\"keywords\":[\"JSON\",\"mongodb\",\"NoSQL Database\"],\"articleSection\":[\"Application Design\",\"Data Modeling\",\"SQL++ \/ N1QL Query\"],\"inLanguage\":\"pt-BR\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.couchbase.com\/blog\/sql-to-nosql-7-metrics-to-compare-query-language\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/sql-to-nosql-7-metrics-to-compare-query-language\/\",\"url\":\"https:\/\/www.couchbase.com\/blog\/sql-to-nosql-7-metrics-to-compare-query-language\/\",\"name\":\"A Comparison of 3 NoSQL Query Languages Across 7 Metrics\",\"isPartOf\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/sql-to-nosql-7-metrics-to-compare-query-language\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/sql-to-nosql-7-metrics-to-compare-query-language\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2020\/03\/Screen-Shot-2020-03-06-at-7.49.11-AM_RESIZED.png\",\"datePublished\":\"2020-03-06T17:17:24+00:00\",\"dateModified\":\"2025-06-14T01:44:29+00:00\",\"description\":\"See how Couchbase N1QL, MongoDB query, and MySQL\/SQL compare across 7 key metrics here. We summarize the findings of Altoros' report on resilient IT.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/sql-to-nosql-7-metrics-to-compare-query-language\/#breadcrumb\"},\"inLanguage\":\"pt-BR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.couchbase.com\/blog\/sql-to-nosql-7-metrics-to-compare-query-language\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-BR\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/sql-to-nosql-7-metrics-to-compare-query-language\/#primaryimage\",\"url\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2020\/03\/Screen-Shot-2020-03-06-at-7.49.11-AM_RESIZED.png\",\"contentUrl\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2020\/03\/Screen-Shot-2020-03-06-at-7.49.11-AM_RESIZED.png\",\"width\":1750,\"height\":647,\"caption\":\"A spreadsheet comparing values of database query capabilities\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/sql-to-nosql-7-metrics-to-compare-query-language\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.couchbase.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"A Comparison of 3 NoSQL Query Languages Across 7 Metrics\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/#website\",\"url\":\"https:\/\/www.couchbase.com\/blog\/\",\"name\":\"The Couchbase Blog\",\"description\":\"Couchbase, the NoSQL Database\",\"publisher\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.couchbase.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"pt-BR\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/#organization\",\"name\":\"The Couchbase Blog\",\"url\":\"https:\/\/www.couchbase.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-BR\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2023\/04\/admin-logo.png\",\"contentUrl\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2023\/04\/admin-logo.png\",\"width\":218,\"height\":34,\"caption\":\"The Couchbase Blog\"},\"image\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/f89064928e262c71eb43bee996c48c63\",\"name\":\"Binh Le\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-BR\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/image\/5b68c37e30928a9d7b2c8470b1a303b7\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/a939f48df6447844a8780bec264bb3be21d589336f3915fabc557075a68fa374?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/a939f48df6447844a8780bec264bb3be21d589336f3915fabc557075a68fa374?s=96&d=mm&r=g\",\"caption\":\"Binh Le\"},\"description\":\"Binh Le is a Principal Product Manager for Couchbase Query service. Prior to Couchbase, he worked at Oracle and led the product management team for Sales Cloud Analytics and CRM OnDemand. Binh holds a Bachelor's Degree in Computer Science from the University of Brighton, UK.\",\"url\":\"https:\/\/www.couchbase.com\/blog\/pt\/author\/binh-le-2\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Uma compara\u00e7\u00e3o de 3 linguagens de consulta NoSQL em 7 m\u00e9tricas","description":"See how Couchbase N1QL, MongoDB query, and MySQL\/SQL compare across 7 key metrics here. We summarize the findings of Altoros' report on resilient IT.","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.couchbase.com\/blog\/pt\/sql-to-nosql-7-metrics-to-compare-query-language\/","og_locale":"pt_BR","og_type":"article","og_title":"A Comparison of 3 NoSQL Query Languages Across 7 Metrics","og_description":"See how Couchbase N1QL, MongoDB query, and MySQL\/SQL compare across 7 key metrics here. We summarize the findings of Altoros' report on resilient IT.","og_url":"https:\/\/www.couchbase.com\/blog\/pt\/sql-to-nosql-7-metrics-to-compare-query-language\/","og_site_name":"The Couchbase Blog","article_published_time":"2020-03-06T17:17:24+00:00","article_modified_time":"2025-06-14T01:44:29+00:00","og_image":[{"width":1750,"height":647,"url":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2020\/03\/Screen-Shot-2020-03-06-at-7.49.11-AM_RESIZED.png","type":"image\/png"}],"author":"Binh Le","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Binh Le","Est. reading time":"8 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.couchbase.com\/blog\/sql-to-nosql-7-metrics-to-compare-query-language\/#article","isPartOf":{"@id":"https:\/\/www.couchbase.com\/blog\/sql-to-nosql-7-metrics-to-compare-query-language\/"},"author":{"name":"Binh Le","@id":"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/f89064928e262c71eb43bee996c48c63"},"headline":"A Comparison of 3 NoSQL Query Languages Across 7 Metrics","datePublished":"2020-03-06T17:17:24+00:00","dateModified":"2025-06-14T01:44:29+00:00","mainEntityOfPage":{"@id":"https:\/\/www.couchbase.com\/blog\/sql-to-nosql-7-metrics-to-compare-query-language\/"},"wordCount":1284,"commentCount":0,"publisher":{"@id":"https:\/\/www.couchbase.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.couchbase.com\/blog\/sql-to-nosql-7-metrics-to-compare-query-language\/#primaryimage"},"thumbnailUrl":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2020\/03\/Screen-Shot-2020-03-06-at-7.49.11-AM_RESIZED.png","keywords":["JSON","mongodb","NoSQL Database"],"articleSection":["Application Design","Data Modeling","SQL++ \/ N1QL Query"],"inLanguage":"pt-BR","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.couchbase.com\/blog\/sql-to-nosql-7-metrics-to-compare-query-language\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.couchbase.com\/blog\/sql-to-nosql-7-metrics-to-compare-query-language\/","url":"https:\/\/www.couchbase.com\/blog\/sql-to-nosql-7-metrics-to-compare-query-language\/","name":"Uma compara\u00e7\u00e3o de 3 linguagens de consulta NoSQL em 7 m\u00e9tricas","isPartOf":{"@id":"https:\/\/www.couchbase.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.couchbase.com\/blog\/sql-to-nosql-7-metrics-to-compare-query-language\/#primaryimage"},"image":{"@id":"https:\/\/www.couchbase.com\/blog\/sql-to-nosql-7-metrics-to-compare-query-language\/#primaryimage"},"thumbnailUrl":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2020\/03\/Screen-Shot-2020-03-06-at-7.49.11-AM_RESIZED.png","datePublished":"2020-03-06T17:17:24+00:00","dateModified":"2025-06-14T01:44:29+00:00","description":"See how Couchbase N1QL, MongoDB query, and MySQL\/SQL compare across 7 key metrics here. We summarize the findings of Altoros' report on resilient IT.","breadcrumb":{"@id":"https:\/\/www.couchbase.com\/blog\/sql-to-nosql-7-metrics-to-compare-query-language\/#breadcrumb"},"inLanguage":"pt-BR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.couchbase.com\/blog\/sql-to-nosql-7-metrics-to-compare-query-language\/"]}]},{"@type":"ImageObject","inLanguage":"pt-BR","@id":"https:\/\/www.couchbase.com\/blog\/sql-to-nosql-7-metrics-to-compare-query-language\/#primaryimage","url":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2020\/03\/Screen-Shot-2020-03-06-at-7.49.11-AM_RESIZED.png","contentUrl":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2020\/03\/Screen-Shot-2020-03-06-at-7.49.11-AM_RESIZED.png","width":1750,"height":647,"caption":"A spreadsheet comparing values of database query capabilities"},{"@type":"BreadcrumbList","@id":"https:\/\/www.couchbase.com\/blog\/sql-to-nosql-7-metrics-to-compare-query-language\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.couchbase.com\/blog\/"},{"@type":"ListItem","position":2,"name":"A Comparison of 3 NoSQL Query Languages Across 7 Metrics"}]},{"@type":"WebSite","@id":"https:\/\/www.couchbase.com\/blog\/#website","url":"https:\/\/www.couchbase.com\/blog\/","name":"Blog do Couchbase","description":"Couchbase, o banco de dados NoSQL","publisher":{"@id":"https:\/\/www.couchbase.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.couchbase.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"pt-BR"},{"@type":"Organization","@id":"https:\/\/www.couchbase.com\/blog\/#organization","name":"Blog do Couchbase","url":"https:\/\/www.couchbase.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"pt-BR","@id":"https:\/\/www.couchbase.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2023\/04\/admin-logo.png","contentUrl":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2023\/04\/admin-logo.png","width":218,"height":34,"caption":"The Couchbase Blog"},"image":{"@id":"https:\/\/www.couchbase.com\/blog\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/f89064928e262c71eb43bee996c48c63","name":"Binh Le","image":{"@type":"ImageObject","inLanguage":"pt-BR","@id":"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/image\/5b68c37e30928a9d7b2c8470b1a303b7","url":"https:\/\/secure.gravatar.com\/avatar\/a939f48df6447844a8780bec264bb3be21d589336f3915fabc557075a68fa374?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/a939f48df6447844a8780bec264bb3be21d589336f3915fabc557075a68fa374?s=96&d=mm&r=g","caption":"Binh Le"},"description":"Binh Le \u00e9 gerente de produto principal do servi\u00e7o Couchbase Query. Antes da Couchbase, ele trabalhou na Oracle e liderou a equipe de gerenciamento de produtos para Sales Cloud Analytics e CRM OnDemand. Binh \u00e9 bacharel em Ci\u00eancia da Computa\u00e7\u00e3o pela Universidade de Brighton, no Reino Unido.","url":"https:\/\/www.couchbase.com\/blog\/pt\/author\/binh-le-2\/"}]}},"authors":[{"term_id":8919,"user_id":26326,"is_guest":0,"slug":"binh-le-2","display_name":"Binh Le","avatar_url":"https:\/\/secure.gravatar.com\/avatar\/a939f48df6447844a8780bec264bb3be21d589336f3915fabc557075a68fa374?s=96&d=mm&r=g","author_category":"","last_name":"Le","first_name":"Binh","job_title":"","user_url":"","description":"Binh Le \u00e9 gerente de produto principal do servi\u00e7o de consulta do Couchbase. Antes da Couchbase, ele trabalhou na Oracle e liderou a equipe de gerenciamento de produtos para Sales Clould Analytics e CRM OnDemand. Binh \u00e9 bacharel em Ci\u00eancia da Computa\u00e7\u00e3o pela Universidade de Brighton, no Reino Unido."}],"_links":{"self":[{"href":"https:\/\/www.couchbase.com\/blog\/pt\/wp-json\/wp\/v2\/posts\/8258","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.couchbase.com\/blog\/pt\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.couchbase.com\/blog\/pt\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/pt\/wp-json\/wp\/v2\/users\/26326"}],"replies":[{"embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/pt\/wp-json\/wp\/v2\/comments?post=8258"}],"version-history":[{"count":0,"href":"https:\/\/www.couchbase.com\/blog\/pt\/wp-json\/wp\/v2\/posts\/8258\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/pt\/wp-json\/wp\/v2\/media\/10645"}],"wp:attachment":[{"href":"https:\/\/www.couchbase.com\/blog\/pt\/wp-json\/wp\/v2\/media?parent=8258"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/pt\/wp-json\/wp\/v2\/categories?post=8258"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/pt\/wp-json\/wp\/v2\/tags?post=8258"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/pt\/wp-json\/wp\/v2\/ppma_author?post=8258"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}