SingleStoreDB中的7个关键新特性

2023-02-01 12:54 知识科普 0阅读 投稿:小七
SingleStoreDB中的7个关键新特性图1

szhzxw.cn/cxounion.org

SingleStoreDB是一个分布式、高度可扩展的SQL数据库,使软件工程师和他们的公司能够建立快速、互动、现代的SaaS应用程序,并更有效地扩展,同时降低成本和复杂性。它为事务性和分析性工作负载提供了高性能。

SingleStoreDB的最新功能增强了数据密集型应用程序,使开发人员和应用程序所有者能够提供实时数据体验。这些新的增强功能是任何企业的理想选择,因为它们需要一个能够确保应用开发简便、企业级功能和快速分析的数据库--都在一个引擎中。

SingleStoreDB将交易和分析统一在一个引擎中,以提供高性能的数据摄取、低延迟的查询性能和实时互动的用户体验,同时尽量减少或消除对数据移动的需求。它是为实时应用程序建立的,它可以处理任何类型的数据。

一、工作空间

SingleStoreDB的主要新功能之一是工作空间,补充了SingleStore去年宣布的交易和分析工作负载的存储和计算分离能力。工作空间使用户能够有效地动态扩展工作负载,以便用相同的数据支持多个应用程序。

工作空间的用户可以为不同类型的工作负载采用孤立的工作空间。用户可以选择一个工作空间用于写入数据,多个工作空间用于读取数据,以支持API、面向客户的应用、运营应用和实时数据分析。

工作区可以根据需要进行连接和分离,以适应应用程序的需要。Workspaces所提供的应用程序之间的隔离和细粒度的可扩展性,通过为按需应用程序动态扩展计算,可以实现更好的单位经济性。此外,Workspaces允许在不影响客户SLA的情况下实现这种隔离和可扩展性。

二、带有Wasm的代码引擎

SingleStore还加强了SingleStoreDB,增加了Wasm的代码引擎。现在,用户可以利用WebAssembly,在数据库引擎中引入外部数据和计算算法来支持新的实时用例。有了Wasm的代码引擎,开发人员可以在数据库中使用他们选择的编程语言安全、自然、高效地执行丰富的计算。

对于不容易用SQL表达的计算和算法,SingleStoreDB中的Wasm支持将算法带到数据中,而不必将数据移到数据库之外。有了SingleStoreDB通用语言的支持,企业现在可以快速将机器学习整合到实时应用程序和仪表盘中。这可以加快推出引人注目的应用程序和功能,这些功能在SQL中不容易表达。

三、数据API

SingleStoreDB的最新版本还包括数据API,实现了与应用程序的无缝集成。开发人员可以使用Data API来构建无服务器应用程序,包括Web和移动应用程序。

数据API使用HTTP来运行针对数据库的SQL操作,而不是维持一个持久的TCP连接。连接是动态重新配置的,每个请求-响应是它自己的连接。企业不需要做任何安装,也不需要浪费时间和资源来应对数据库连接池的人工管理。

JSON有效载荷可用于用户偏好的编程语言和工具。

四、Dbt连接器

SingleStoreDB现在包括一个Dbt连接器。正如Analytics Insight所报告的那样,这是对dbt是当今最广泛使用的数据工程工具之一的认可。

SingleStoreDB dbt连接器允许数据工程师和分析师快速和轻松地建立和管理数据管道。它使转换比使用Apache Spark更容易、更强大。虽然许多分析数据库和数据仓库都有与dbt的连接器,但SingleStoreDB可以与dbt集成,为数据转换提供服务,以支持低延迟的应用程序,这需要在同一个引擎中的操作和分析能力。

五、灵活的并行性

新的灵活并行功能使企业能够使用其机器上的所有内核来处理一个查询,从而显著提高查询性能的倍数。灵活并行有助于企业从其硬件中获得最大效率和性能,并产生更好的CPU利用率。华东CIO大会、华东CIO联盟、CDLC中国数字化灯塔大会、CXO数字化研学之旅、数字化江湖-讲武堂,数字化江湖-大侠传、数字化江湖-论剑、CXO系列管理论坛(陆家嘴CXO管理论坛、宁波东钱湖CXO管理论坛等)、数字化转型网,走进灯塔工厂系列、ECIO大会等

六、新的SSO集成

虽然 "安全设计 "一直是SingleStoreDB的一个关键原则,但在这个版本中,SingleStore增加了数据库的安全集成。SingleStoreDB现在支持通过OAuth 2.0对Azure SSO、GCP SSO和AWS SSO进行单点登录。

七、客户管理的加密密钥

SingleStoreDB使用SingleStoreDB管理的加密密钥自动对静态数据进行加密。而这个新版本将这些加密功能提升到一个新的水平,提供更多的控制。SingleStoreDB现在支持客户管理的加密密钥(CMEK)与专用版。这对于需要满足零信任政策或特定合规性或监管要求以保护数据的企业至关重要。

SingleStoreDB将交易和分析统一在同一引擎中,以支持数据密集型应用,并提供卓越的实时数据体验。全球有100多家SaaS供应商依赖SingleStoreDB,与其他替代方案相比,其整体性能提高了20倍至100倍。

像Hulu、Uber和Comcast这样的数字巨头,以及像Fathom Analytics、DailyVest、Armis、IEX Cloud、Bitwyre、Factors.ai和Heylink这样的客户,都使用SingleStore为他们的现代数据密集型应用提供超强动力。

数据是做出正确的商业决策、提供卓越的客户体验和保持竞争优势的关键。这种对数据的依赖带来了对简单性、速度和规模的需求。

"SingleStore使我们的交易引擎能够以一毫秒的延迟或往返时间扩展到每秒一百万个订单。Bitwyre首席执行官兼联合创始人Dendi Suhubdy说:"SingleStore能够提供这种水平的延迟,即使在支持多个pod、并行读取和并行写入的情况下。

Shireesh Thota是IDG公司工程部的高级副总裁。 单一存储该公司为数据密集型应用提供全球最快的分布式SQL数据库SingleStoreDB。通过结合交易和分析工作负载,SingleStore消除了性能瓶颈和不必要的数据移动,以支持不断增长、要求苛刻的工作负载。

原文:

SingleStoreDB is a distributed, highly scalable SQL database that allows software engineers and their companies to build fast, interactive, modern SaaS applications and scale more effectively, all while lowering costs and complexity. It delivers high performance for both transactional and analytical workloads.

The newest features in SingleStoreDB supercharge data-intensive applications and enable developers and application owners to deliver real-time data experiences. These new enhancements are ideal for any enterprise that wants a database that can ensure easy app development, enterprise-grade capabilities, and fast analytics—all in one engine.

SingleStoreDB unifies transactions and analytics in that one engine to deliver high-performance data ingest, low-latency query performance, and real-time interactive user experiences, while minimizing or eliminating the need for data movement. It is built for real-time applications, and it can handle any type of data.

Workspaces

Among the key new SingleStoreDB features is Workspaces, complementing the separation of storage and compute for both transactional and analytical workloads capability that SingleStore announced last year. Workspaces enable users to efficiently scale workloads dynamically to power multiple applications with the same data.

Users of Workspaces can employ isolated workspaces for different types of workloads. A user might elect to have one workspace for writing data and multiple workspaces for reading data to power APIs, customer-facing applications, operational apps, and real-time data analytics.

Workspaces can be attached and detached on demand to fit the needs of applications. The isolation between applications and granular scalability that Workspaces provides allows for better unit economics by scaling compute dynamically for on-demand applications. Further, Workspaces allows for this isolation and scalability without impacting customer SLAs.

Code Engine with Wasm

SingleStore has also enhanced SingleStoreDB with the addition of Code Engine with Wasm. Now users can bring external data and compute algorithms to power new real-time use cases within the database engine, drawing on WebAssembly. With Code Engine with Wasm, developers can securely, natively, and efficiently execute rich computation in the database using their programming language of choice.

For computations and algorithms that are not easily expressed in SQL, Wasm support in SingleStoreDB brings algorithms to the data without having to move that data outside of the database. With SingleStoreDB Universal Language support, enterprises can now quickly integrate machine learning into real-time applications and dashboards. This can expedite the launch of compelling applications and functionality that are not easily expressible in SQL.

Data API

The latest release of SingleStoreDB also includes Data API, enabling seamless integrations with applications. Developers can use Data API to build serverless applications including web and mobile apps.

Data API uses HTTP to run SQL operations against the database rather than maintaining a persistent TCP connection. The connection is dynamically reconfigured, and each request-response is its own connection. Enterprises don’t have to do any installations, and they don’t have to waste time and resources on contending with manual administration of database connection pools.

The JSON payload is usable with users’ preferred programming languages and tools.

Dbt connector

SingleStoreDB now includes a dbt connector. This is in recognition that dbt is one of the most widely used data engineering tools today, as Analytics Insight reports.

The SingleStoreDB dbt connector allows data engineers and analysts to build and manage data pipelines quickly and easily. It makes transformations easier and more robust than using Apache Spark. And while many analytical databases and data warehouses have connectors to dbt, SingleStoreDB can integrate with dbt to serve data transformations to power low-latency applications, which require operational and analytical capabilities in the same engine.

Flexible Parallelism

The new Flexible Parallelism feature lets enterprises use all the cores on their machines to process a single query, significantly improving query performance by multiples. Flexible Parallelism helps enterprises to drive maximum efficiency and performance from their hardware and produces better CPU utilization.

New SSO integrations

While “secure by design” has always been a key tenet of SingleStoreDB, with this release SingleStore has increased the database’s security integrations. SingleStoreDB now supports single sign-on via OAuth 2.0 for Azure SSO, GCP SSO, and AWS SSO.

Customer-managed encryption keys

SingleStoreDB automatically encrypts data at rest using encryption keys managed by SingleStoreDB. And this new release takes those encryption capabilities to a new level, offering greater control. SingleStoreDB now supports customer-managed encryption keys (CMEK) with the dedicated edition. This is critical for enterprises that need to meet zero trust policy or specific compliance or regulatory requirements to protect data.

SingleStoreDB unifies transactions and analytics in the same engine to power data-intensive applications and deliver superior real-time data experiences. More than 100 SaaS providers globally rely on SingleStoreDB, which delivers a 20x to 100x improvement in overall performance compared to alternatives.

Digital giants like Hulu, Uber, and Comcast, as well as customers like Fathom Analytics, DailyVest, Armis, IEX Cloud, Bitwyre, Factors.ai, and Heylink, use SingleStore to supercharge their modern, data-intensive applications.

Data is key to making the right business decisions, delivering exceptional customer experiences, and staying ahead of the competition. This reliance on data brings with it a need for simplicity, speed, and scale.

“SingleStore enabled us to scale our trading engine to one million orders per second with one millisecond latency, or round-trip time. SingleStore is able to deliver this level of latency even while supporting multiple pods, parallel reads, and parallel writes,” said Dendi Suhubdy, CEO and co-founder, Bitwyre.

Shireesh Thota is senior vice president of engineering with SingleStore, which delivers the world’s fastest distributed SQL database for data-intensive applications, SingleStoreDB. By combining transactional and analytical workloads, SingleStore eliminates performance bottlenecks and unnecessary data movement to support constantly growing, demanding workloads.

本文主要内容转载出自InfoWorld,原作者为Shireesh Thota,仅供广大读者参考,如有侵犯您的知识产权或者权益,请联系我提供证据,我会予以删除。

CXO联盟(CXO union)是一家聚焦于CIO,CDO,cto,ciso,cfo,coo,chro,cpo,ceo等人群的平台组织,其中在CIO会议领域的领头羊,目前举办了大量的CIO大会、CIO论坛、CIO活动、CIO会议、CIO峰会、CIO会展。如华东CIO会议、华南cio会议、华北cio会议、中国cio会议、西部CIO会议。在这里,你可以参加大量的IT大会、IT行业会议、IT行业论坛、IT行业会展、数字化论坛、数字化转型论坛,在这里你可以认识很多的首席信息官、首席数字官、首席财务官、首席技术官、首席人力资源官、首席运营官、首席执行官、IT总监、财务总监、信息总监、运营总监、采购总监、供应链总监。

数字化转型网(资讯媒体,是企业数字化转型的必读参考,在这里你可以学习大量的知识,如财务数字化转型、供应链数字化转型、运营数字化转型、生产数字化转型、人力资源数字化转型、市场营销数字化转型。通过关注我们的公众号,你就知道如何实现企业数字化转型?数字化转型如何做?

【CXO UNION部分社群会员】际华CISO、CISO、电信CISO、中车CISO、力帆CISO、晶科CISO、光大证券CISO、宁波建工CISO、蓝科高新CISO、星宇CISO、交建CISO、皖新CISO、中海油服CISO、新华文轩CISO、京沪高铁CISO、光大银行CISO、沪农商行CISO、三峰CISO、美凯龙CISO、成都银行CISO、石油CISO、科传CISO、紫金银行CISO、福莱特CISO、中远海发CISO、长飞光纤CISO、招商轮船CISO、正泰CISO、浙商证券CISO、辽港CISO、银河CISO、海天精工CISO、江河CISO、中免CISO、亚星锚链CISO、中煤CISO、紫金矿业CISO、南方CISO、方正证券CISO、京运通CISO、浙商银行CISO、新集CISO、中远海控CISO、浙版CISO、凤凰CISO、吉视CISO、永辉超市CISO、建设银行CISO、出版CISO、苏垦农发CISO、东贝CISO、金钼CISO、重庆银行CISO、汽研CISO、玲珑轮胎CISO、宝钢包装CISO、海南矿业CISO、招商南油CISO、核电CISO、银行CISO、重工CISO、南京证券CISO、大唐发电CISO、金隅CISO、中金CISO、丰林CISO、贵阳银行CISO、中信银行CISO、出版CISO、人民网CISO、奥康CISO、宏昌CISO、龙宇燃油CISO、晶方CISO、联明CISO、花王CISO、喜临门CISO、北特CISO、万盛CISO、合锻智能CISO、创力CISO、亚普CISO、弘讯CISO、新宏泰CISO、中衡设计CISO、华设CISO、中科曙光CISO、爱普CISO、山东华鹏CISO、新通联CISO、威帝CISO、大豪CISO、石大胜华CISO、千禾味业CISO、赛福天CISO、天鹅CISO、全筑CISO、安德利CISO、德新CISO、三维CISO、常熟汽饰CISO、如通CISO、凯众CISO、华立CISO、泛微CISO等

声明:若水百科所有作品(图文、音视频)均由用户自行上传分享,仅供网友学习交流。若您的权利被侵害,请联系youzivr@vip.qq.com