


Source | Xinyan Technology
文 | Jia Ningyu
On December 20, VLDB2024, the top international database conference, announced a new batch of papers. Alibaba Cloud's new technology PilotScope was successfully shortlisted. This platform technology can realize "one-click deployment" of AI algorithms in the database, greatly reducing the number of AI algorithms in the database. The application threshold has opened up a new path for database intelligence. On December 20th, the international top conference for databases VLDB2024 announced a new batch of papers, and Alibaba Cloud's new technology PilotScope successfully made it to the list. The platform's technology can achieve "one-click deployment" of AI algorithms in databases, greatly reducing the application threshold of AI algorithms in databases and opening up a brand new path for database intelligence.
Alibaba Cloud announced that it will open source all PilotScope technologies for free on the same day
Why is it difficult to make database intelligent?
Database is a basic software technology that is crucial to the national economy and people's lives. The continuous updating of database technology has an important impact on all walks of life in the digital era. One of the frontier areas is database intelligence (AI4DB, i.e. database intelligence)
The current database system is very complex and has very high stability requirements. Even just matching and debugging an AI algorithm with a database requires engineers from both parties to work closely for weeks or even months, which is inefficient and results in poor results

The more common situation is that AI engineers don’t understand the details of databases, database developers don’t understand AI, and the two fields don’t even know the programming language (AI development mostly uses Python, databases mostly use C/Java), it’s very difficult Easy to cause rupture.
Generally speaking, companies in the industry usually choose to embed some AI algorithms directly into the database to replace certain functional modules of the database, such as intelligent query optimization modules. However, this customized approach results in very high development, maintenance, and upgrade costs. Every time the AI algorithm is upgraded and replaced, the development process needs to be redone. At the same time, changing the code base of the database will also bring additional risks
Because of this, despite the rapid development of artificial intelligence, the practical application of related results has not yet become popular in the database field
Is there a common platform technology that can more effectively apply artificial intelligence algorithms to databases?
This became the starting point for the thinking of the Alibaba PilotScope project team
PilotScope project leader Zhu Rong said: "AI4DB, AI and DB are both done by people, but the bridge at this connection, But it has never been done well. We want to build a public bridge between AI algorithms and databases to make communication between the two parties smoother."
Cross-tech innovation from 0 to 1
Zhu Rong described PilotScope as the "super administrator" of database AI. Through the PilotScope platform, AI engineers only need to focus on designing general AI algorithms to implement the deployment and application of different databases; while database users can call APIs like Likewise, the idea of using AI conveniently and efficiently took about 2 years from conception to implementation. Zhu Rong said: "It involves the intersection of algorithms and systems, the intersection of AI and databases, the intersection of research and development, and the intersection of academia and industry. It is a true intersection of technology."
According to his introduction, the project After many rounds of polishing, the team finally developed a brand new middleware system platform. By abstracting and generalizing module and interface definitions at the database and AI system levels, the AI algorithm can be implemented in the database within hours or even minutes. Key deployment", this is the current PilotScope
The rewritten content is as follows: Annotation of the Alibaba Cloud PilotScope architecture diagram

PilotScope is useful for parameter tuning, index recommendation, cardinality estimation, and query It provides more than 10 AI algorithms for mainstream database tasks such as optimization, and has successfully adapted to two mainstream open source databases such as PostgreSQL and Spark
According to experimental data, using PilotScope to embed AI algorithms into the database is faster than traditional The "hard implant" method can speed up tasks such as query optimization by 1 to 2 times. In addition, the additional cost of deployment caused by PilotScope itself is basically negligible, and the performance is excellent
Image description: PilotScope rendering

PilotScope performs "micro-intrusion" on the database and introduces Intelligent detection, rollback, isolation and other mechanisms to reduce the risk of AI hallucinations and achieve intelligent improvement while ensuring database stability
Zhu Rong said that in the past, artificial intelligence engineers and database developers needed to continuously collaborate and refine, and it might take weeks or even months to ensure stability. "With the help of our PilotScope, it only takes a few hours or even dozens of minutes to go online for testing directly. This zero-to-one technological innovation greatly improves development efficiency."
Open source drives the industrialization of AI4DB Process
PilotScope paper results have been included in VLDB. The VLDB review believes that PilotScope's pioneering system design based on application scenarios will open up a new direction of database intelligence.
According to our understanding, VLDB is one of the three top international database conferences, and only includes reports on academia and industry every year. Practice new results that have important impact. It is an authoritative indicator of database technology. The 50th VLDB Conference is planned to be held in Guangzhou, China in August 2024.

Picture Note: Top Database Conference VLDB2024
Zhu Rong said, PilotScope related technologies have been freely open sourced on GitHub and Modelscope communities. The team hopes to incorporate more AI algorithms and a wider range of databases into PilotScope through the power of the open source community, and explore more AI4DB innovations with developers
At the same time, PilotScope has begun to deploy on Alibaba Cloud Conduct pilot applications internally to conduct corresponding tests for industrial deployment
Zhu Rong said that AI4DB can only generate value in a real production environment. We hope that PilotScope can truly realize this and help people from all walks of life. Improve the efficiency and effect of database intelligence
Please attach the open source address:
https://github.com/alibaba/pilotscope
The above is the detailed content of Databases usher in the AI fast lane, Alibaba Cloud releases new open source technology PilotScope. For more information, please follow other related articles on the PHP Chinese website!

ai合并图层的快捷键是“Ctrl+Shift+E”,它的作用是把目前所有处在显示状态的图层合并,在隐藏状态的图层则不作变动。也可以选中要合并的图层,在菜单栏中依次点击“窗口”-“路径查找器”,点击“合并”按钮。

ai橡皮擦擦不掉东西是因为AI是矢量图软件,用橡皮擦不能擦位图的,其解决办法就是用蒙板工具以及钢笔勾好路径再建立蒙板即可实现擦掉东西。

虽然谷歌早在2020年,就在自家的数据中心上部署了当时最强的AI芯片——TPU v4。但直到今年的4月4日,谷歌才首次公布了这台AI超算的技术细节。论文地址:https://arxiv.org/abs/2304.01433相比于TPU v3,TPU v4的性能要高出2.1倍,而在整合4096个芯片之后,超算的性能更是提升了10倍。另外,谷歌还声称,自家芯片要比英伟达A100更快、更节能。与A100对打,速度快1.7倍论文中,谷歌表示,对于规模相当的系统,TPU v4可以提供比英伟达A100强1.

ai可以转成psd格式。转换方法:1、打开Adobe Illustrator软件,依次点击顶部菜单栏的“文件”-“打开”,选择所需的ai文件;2、点击右侧功能面板中的“图层”,点击三杠图标,在弹出的选项中选择“释放到图层(顺序)”;3、依次点击顶部菜单栏的“文件”-“导出”-“导出为”;4、在弹出的“导出”对话框中,将“保存类型”设置为“PSD格式”,点击“导出”即可;

Yann LeCun 这个观点的确有些大胆。 「从现在起 5 年内,没有哪个头脑正常的人会使用自回归模型。」最近,图灵奖得主 Yann LeCun 给一场辩论做了个特别的开场。而他口中的自回归,正是当前爆红的 GPT 家族模型所依赖的学习范式。当然,被 Yann LeCun 指出问题的不只是自回归模型。在他看来,当前整个的机器学习领域都面临巨大挑战。这场辩论的主题为「Do large language models need sensory grounding for meaning and u

ai顶部属性栏不见了的解决办法:1、开启Ai新建画布,进入绘图页面;2、在Ai顶部菜单栏中点击“窗口”;3、在系统弹出的窗口菜单页面中点击“控制”,然后开启“控制”窗口即可显示出属性栏。

引入密集强化学习,用 AI 验证 AI。 自动驾驶汽车 (AV) 技术的快速发展,使得我们正处于交通革命的风口浪尖,其规模是自一个世纪前汽车问世以来从未见过的。自动驾驶技术具有显着提高交通安全性、机动性和可持续性的潜力,因此引起了工业界、政府机构、专业组织和学术机构的共同关注。过去 20 年里,自动驾驶汽车的发展取得了长足的进步,尤其是随着深度学习的出现更是如此。到 2015 年,开始有公司宣布他们将在 2020 之前量产 AV。不过到目前为止,并且没有 level 4 级别的 AV 可以在市场

ai移动不了东西的解决办法:1、打开ai软件,打开空白文档;2、选择矩形工具,在文档中绘制矩形;3、点击选择工具,移动文档中的矩形;4、点击图层按钮,弹出图层面板对话框,解锁图层;5、点击选择工具,移动矩形即可。


Hot AI Tools

Undresser.AI Undress
AI-powered app for creating realistic nude photos

AI Clothes Remover
Online AI tool for removing clothes from photos.

Undress AI Tool
Undress images for free

Clothoff.io
AI clothes remover

AI Hentai Generator
Generate AI Hentai for free.

Hot Article

Hot Tools

DVWA
Damn Vulnerable Web App (DVWA) is a PHP/MySQL web application that is very vulnerable. Its main goals are to be an aid for security professionals to test their skills and tools in a legal environment, to help web developers better understand the process of securing web applications, and to help teachers/students teach/learn in a classroom environment Web application security. The goal of DVWA is to practice some of the most common web vulnerabilities through a simple and straightforward interface, with varying degrees of difficulty. Please note that this software

SublimeText3 Mac version
God-level code editing software (SublimeText3)

PhpStorm Mac version
The latest (2018.2.1) professional PHP integrated development tool

Safe Exam Browser
Safe Exam Browser is a secure browser environment for taking online exams securely. This software turns any computer into a secure workstation. It controls access to any utility and prevents students from using unauthorized resources.

Zend Studio 13.0.1
Powerful PHP integrated development environment
