Cockroach Labs’ Post

I’m thrilled to share our latest blog post on Medium: JSON Search Indexes Come to Object Storage. https://lnkd.in/gphQVGq6 Discover how Oracle is adding full-text index capabilities over JSON files in Object Store. This new feature enhances data retrieval efficiency, enabling faster and more accurate searches within JSON documents. Thank you Hermann Baer for writing this blog! #oracle #autonomousdatabase #serverless on #oci

🚀 𝐔𝐧𝐥𝐨𝐜𝐤 𝐭𝐡𝐞 𝐏𝐨𝐰𝐞𝐫 𝐨𝐟 𝐃𝐚𝐭𝐚 𝐂𝐨𝐦𝐩𝐫𝐞𝐬𝐬𝐢𝐨𝐧 𝐢𝐧 𝐒𝐐𝐋 𝐒𝐞𝐫𝐯𝐞𝐫 🚀 Are you a SQL Server enthusiast looking to optimize your database's storage and performance? Check out this insightful article on data compression. 🔍 𝐊𝐞𝐲 𝐓𝐚𝐤𝐞𝐚𝐰𝐚𝐲𝐬: ✅ SQL Server offers two compression levels: row compression and page compression. Learn how each can benefit your database. ✅ Discover the factors to consider when deciding what to compress, including estimated space savings, data types, and your application workload. ✅ Get insights into the impact of compression on CPU utilization and I/O operations and how to make informed decisions based on workload metrics. #sqlserver #sqldatabase #databaseadministration #sqldba #rdbms

Traditionally, schema changes in relational databases, which are crucial for updates, often require scheduled downtime. This not only affects the end-user experience but also leads to increased cost of opportunity for critical applications. CockroachDB's approach to schema changes is noteworthy. It enables updates without the need for scheduled downtimes, maintaining operational continuity and data consistency. This translates to some 🌐 Key Advantages: 1️⃣ Continuous database operation during schema changes. 2️⃣ Application queries run smoothly, without latency impact. 3️⃣ Consistent and secure data state throughout the change. 4️⃣ Zero planned downtime. Yes, ZERO! For a detailed understanding of how CockroachDB achieves this, the blog below👇🏾 provides an insightful read. . . . . . . #cockroachdb #distributedsql #schema #nodowntime #techinnovation

Excited to share insights on KVDB, a new open-source project aimed at simplifying database management. The core idea is to provide developers with the flexibility to swap underlying key-value store database engines without altering their codebase. Dive into the article to understand its architecture and how it could be a valuable addition to your tech stack. #OpenSource #KVDB #Database #UnifiedInterface #NoSQL

Operational Reality - Updating a database schema with no downtime is what the customer expects. Learn how we do it in #cockroachdb https://lnkd.in/g4vxWa5a

Scaling databases making you sweat? 🥵 Let us take the load off, we're experts in database scaling This blog explains how we tackled MySQL scalability troubles for a banking client using TiDB's distributed awesomeness. 😎 Read here - https://lnkd.in/gU-D2wMt TiDB's horizontal scaling, always-on availability, and seamless OLAP integration helps establish a robust data warehouse. 👌 Database challenges got you down? Let Mafiree's experts architect the ideal solution! We specialize in tailored database services that scale and perform. 🚀 Get in touch today to get the best infrastructure for your system! ✉️ #MySQL #TiDB #database #scaling #distribution #availability #performance #OLAP #HTAP #replication #horizontallyscaling #datamanagement #datawarehouse #ETL #highconcurrency #datamodeling #databasedesign #dataservices #managedservices #databaseconsulting #techconsulting #databasetuning #databasescaling

Oracle True Cache in Oracle Database 23ai offers unparallel performance and efficient cached #data management. It helps to eliminate data staleness and the complexity of managing a separate caching layer and invalidations. Learn more about the different Oracle True Cache use cases and benefits. https://lnkd.in/ew47G7zM

Oracle True Cache in Oracle Database 23ai offers unparallel performance and efficient cached #data management. It helps to eliminate data staleness and the complexity of managing a separate caching layer and invalidations. Learn more about the different Oracle True Cache use cases and benefits. https://lnkd.in/g4-AK-_x

Databases are the backbone of any enterprise system—but is yours ready to scale? In today's data-driven world, ensuring your database can handle growing demands is crucial. Dive into our latest blog where we explore key techniques to optimize performance and scale seamlessly. From query optimization to advanced sharding and replication strategies, we've got the insights you need to keep your database running smoothly as your business grows. https://lnkd.in/eQFMEWtc #DatabaseOptimization #DataScaling #SQL #PerformanceEngineering #TechBlog #Database

Oracle True Cache in Oracle Database 23ai offers unparallel performance and efficient cached #data management. It helps to eliminate data staleness and the complexity of managing a separate caching layer and invalidations. Learn more about the different Oracle True Cache use cases and benefits. https://lnkd.in/dP8PGV-6