DATABASE DESIGN – Telegram
DATABASE DESIGN
1.41K subscribers
2.08K photos
3 videos
5.35K links
Лучшие материалы по работе с хранилищами данных на русском и английском языке

Разместить рекламу: @tproger_sales_bot

Правила общения: https://tprg.ru/rules

Другие каналы: @tproger_channels

Другие наши проекты: https://tprg.ru/media
Download Telegram
Leading Industry Analysts Comment on the Database Announcement at Oracle CloudWorld 2023

During CloudWorld 2023, Oracle announced its plans to add semantic search capabilities using AI vectors to Oracle Database 23c. The collection of features, called AI Vector Search, includes a new vector data type, vector indexes, and vector search SQL operators. In addition, the announcement includes the latest updates to Oracle Database services and products.

Read: https://blogs.oracle.com/database/post/leading-industry-analysts-comment-on-ocw2023-database-announcement
Oracle Database 23c: The Next Long Term Support Release

We are pleased to announce that the new version of the world’s most powerful database, Oracle Database 23c, is now Generally Available on OCI Oracle Base Database Service. We’ve also taken the opportunity to update the popular Oracle Database Free version, available for download here. Releases for Oracle Database On-premises, Exadata, Exadata Database Service, Exadata Cloud at Customer (ExaC@C), and Autonomous Database (ADB) will follow later.

Read: https://blogs.oracle.com/database/post/oracle-database-23c-the-next-long-term-support-release
Introducing Oracle Database 23c Free

Oracle Database 23c Free, a free offering of the industry-leading Oracle Database that enterprises rely on every day, is now generally available.

Read: https://blogs.oracle.com/database/post/database-23c-free-ga
Latest Autonomous Database Innovation Announcements at Oracle CloudWorld

Autonomous Database continues to simplify customer innovations and reduce operational costs with several new feature announcements: 1) with Select AI, Autonomous Database now speaks “human”, letting you query your data using natural language, 2) developers have a new free and offline app dev option with Autonomous Database Free Container Image and 3) organizations save operational costs by consolidating compute resources in Elastic Resource Pools.

Read: https://blogs.oracle.com/datawarehousing/post/latest-autonomous-database-innovation-announcements-at-oracle-cloudworld
Autonomous Database speaks “human”

Meet Autonomous Database Select AI – the simplified way for your users to get answers about your business. They can use their natural language to query data and gain insights, without the need to understand where and how your data is stored. It’s that simple. Discover how Select AI simplifies the use of natural language to query your data.

Read: https://blogs.oracle.com/datawarehousing/post/autonomous-database-speaks-human
Introducing Autonomous Database Free Container Image

Learn how to take advantage of Autonomous Database free container image for your development and test use cases.

Read: https://blogs.oracle.com/datawarehousing/post/autonomous-database-free-container-image
How to Achieve up to 87% Compute Cost Savings with Elastic Resource Pools on Autonomous Database

Learn how you can achieve up to 87% compute cost savings with the elastic resource pools on Autonomous Database.

Read: https://blogs.oracle.com/datawarehousing/post/elastic-resource-pools-autonomous-database
Achieve data residency, availability, and scale with Oracle Globally Distributed Autonomous Database

Store and manage large volumes of data with remarkable performance and reliability and design data application architectures that address critical enterprise use cases.

Read: https://blogs.oracle.com/database/post/globally-distributed-autonomous-database
Oracle Database Appliance X10 – Much More Powerful Database-Optimized Entry-Level Engineered Systems

We are excited to announce the next generation Oracle Database Appliance X10.

Read: https://blogs.oracle.com/oda/post/oracle-database-appliance-x10
You Asked, We Listened. It's Here - Dark Mode for Atlas is Now Available in Public Preview



Read: https://www.mongodb.com/blog/post/dark-mode-for-atlas-now-available-public-preview
Enhanced Resource Usage Tracking in Oracle Autonomous Database on Dedicated Exadata Infrastructure and Cloud@Customer

Blog describes resource usage tracking across Autonomous Database on Dedicated Exadata Infrastructure and Cloud@Customer

Read: https://blogs.oracle.com/database/post/enhanced-resource-usage-tracking-in-adbd-and-adbcc
Essential tools for migrating to the Oracle Autonomous Database

An overview of three essential Oracle tools that will help you migrate to the Oracle Autonomous Database: Estate Explorer, Cloud Premigration Advisor, and Real Application Testing

Read: https://blogs.oracle.com/cloud-infrastructure/post/migrate-autonomous-db-estate-explorer-cpat-rat
Unveiling the Power of Oracle Globally Distributed Database: Oracle Database 23c Advancements

This blog sets the stage for exploring these enhancements, offering insights into how Oracle Database 23c elevates the capabilities of the Oracle Globally Distributed Database, propelling it into a new era of excellence.

Read: https://blogs.oracle.com/database/post/oracle-globally-distributed-database-23c
Oracle DatabaseWorld at CloudWorld 2023 – It’s a wrap!

So it’s been a few weeks since we wrapped up our inaugural Oracle DatabaseWorld at CloudWorld in Vegas, and I’m still working through the long list of follow-ups from all of the customer and partner meetings I had. In addition, the product announcements we made at the event have piqued the interest of industry analysts and media, resulting in requests for briefings and article reviews – more items to add to my to-do list.

Read: https://blogs.oracle.com/undefined/post/oracle-databaseworld-at-cloudworld-2023-its-a-wrap
Try the Oracle APEX 23.2 Preview on apex.oracle.com!

Oracle APEX 23.2 preview is now available on apex.oracle.com

Read: https://blogs.oracle.com/apex/post/try-oracle-apex-232-on-apex-oracle-com
Learn about Oracle Text

Oracle Text has been described as "Oracle's best-kept secret". A powerful full-text search engine, built in to the Oracle Database.

Read: https://blogs.oracle.com/database/post/learn-about-oracle-text
Fourth Quarterly Update on Oracle Graph (2023)

Oracle Graph Server and Client 23.4 is now available. This release includes a PGQL function to validate the vertices and edges of a graph a PGQL function to aggregate values into a JSON array, the ability to create a new graph from an existing one, and more.

Read: https://blogs.oracle.com/database/post/fourth-quarterly-update-on-oracle-graph-2023
Powering Network Topology Planning and Administration with Oracle Graph

Modeling network topologies as a graph enhances performance and enable many different kinds of applications.

Read: https://blogs.oracle.com/database/post/powering-network-topology-planning-and-administration-with-oracle-graph
Как автоматизировать проверки данных в Airflow с Great Expectations

В приведённой ниже статье подробно описывается, как настроить интеграцию инструмента Great Expectations для проверки качества данных с платформой Apache Airflow. Вы узнаете о различных методах запуска проверок с использованием  Airflow, о том, как хранить конфигурационные файлы Great Expectations, а также о потенциальных сложностях, с которыми вы можете столкнуться при первоначальной настройке.

Автор делится ценным практическим опытом, полученным в процессе внедрения этих решений в одном из крупных российских банков.

Читать: https://habr.com/ru/companies/banki/articles/773884/
1
Трансляция графических HANA Calculation View в SQL, или как переехать так, чтобы ничего не поменялось

Повинуясь всеобщей тенденции и следуя духу времени, мы в Норникеле переводим расчёты нашего хранилища на уровень БД. Так мы ускоряем обработку данных и формирование отчётности, да и система работает стабильнее.

Но пока мы оптимизируем и переносим "классический" код в базу, запрашиваемые заказчиком алгоритмы усложняются, а обрабатываемых данных становится больше. Чтобы склонить чашу весов на нашу сторону в этом извечном противостоянии мы решили применить новый метод!


Читать: https://habr.com/ru/companies/nornickel/articles/774566/
Обзор Чипа Внешней I2C Памяти AT24Cхх

AT24C02M5/TR это EEPROM на 256 байт с доступом по двухпроводному проводному синхронному последовательному интерфейсу I2C.

В разработке электронных плат часто надо подписывать электронные платы каким-то серийным номером. Это нужно для идентификации платы при серийном производстве.

Внешние чипы памяти особенно важны так как прошивку могут полностью стереть. В связи с этим хранить серийный номер на микроконтроллере внутри on-chip NOR-Flash самого микроконтроллера ненадежно.


Читать: https://habr.com/ru/articles/774624/