An old saw
Fast, reliable, cheap - Pick two. Reliable Referential Integrity is apparently not required by some users. So we can't have fast too?
The developers of MySQL Server have decided its Query Cache feature is a bottleneck and killed it off. Looking over the number of results (and the diversity of advice offered) if you search “tuning MySQL query cache”, it's not entirely surprising. The problem is scalability, as MySQL Server product manager Morgan Tocker …
Analysis Under Nevada's baking summer sunshine, Snowflake last week promised it would bring together two ways of working with data that mix about as well as oil and water.
The data warehouse vendor – well known for its stratospheric $120 billion post-IPO valuation – said it would support both analytics and transactional workloads in the same system.
Launched at the Snowflake Summit 2022 in Vegas, Unistore would be the "foundation for another wave of innovation in the Snowflake Data Cloud," said Christian Kleinerman, senior vice president of product. "Similar to how we redefined data lakes and data warehouses for our customers, Unistore is ushering in a renaissance of building and deploying a new generation of applications in the Data Cloud," he said.
YugabyteDB, the self-styled double-decker distributed relational database, has introduced a read-committed isolation level, allowing for more flexibility for devs and bringing it into step with its more established RDBMS rivals.
With the general availability of YugabyteDB 2.15, the company behind the PostgreSQL-compatible database, said to be inspired by Google Spanner, claims to be adding performance enhancements and dynamic workload optimization.
Speaking to The Register, CTO Karthik Ranganathan, a former Facebook technical lead, said Yugabyte was the first and only distributed SQL vendor to offer all three PostgreSQL isolation levels, making it that much easier to shift existing applications to a distributed database with advanced support for the default PostgreSQL isolation level.
Analysis At MongoDB's recent conference in New York, the company demonstrated its ambition in taking on workloads from other databases.
The company has made significant inroads into the database market with a developer-friendly distributed document database to help devs build modern, web-based, transactional systems.
Time series and search have become targets, with the promise of support for secondary indexes in the former, and Search Facets to help developers build search experiences more rapidly in the latter.
DataStax, the database company built around open-source wide-column Apache Cassandra, has launched a streaming platform as a service with backwards compatibility for messaging standards JMS, MQ, and Kafka.
The fully managed messaging and event streaming service, based on open-source Apache Pulsar, is a streaming technology built for the requirements of high-scale, real-time applications.
But DataStax wanted to help customers get data from their existing messaging platforms, as well as those who migrate to Pulsar, said Chris Latimer, vice president of product management.
DataStax, the database company based on the open-source Cassandra system, has secured $115 million in funding for a $1.6 billion valuation.
Led by the Growth Equity business within Goldman Sachs and backed by RCM Private Markets and EDB Investments, the latest round follows a strong first quarter based on the popularity of DataStax's Cassandra DBaaS Astra DB. Existing investors include Crosslink Capital, Meritech Capital Partners, OnePrime Capital, and others.
Cassandra is a distributed, wide-column store database suited to real-time use cases such as e-commerce and inventory management, personalization and recommendations, Internet of Things-related applications, and fraud detection. It is freely available on the Apache Version 2 license, although DataStax offers managed service Astra on a subscription model.
PostgreSQL co-creator and MIT computer science professor Michael Stonebraker has listed his top requests for features to add into the popular open-source database, including a time travel function he admits was implemented badly in the 1980s.
Speaking at Postgres Vision conference, Stonebreaker said the time-travel code was fundamentally a good idea, as it allows users to query data from the database’s history, and had introduced an implementation in the 1990s.
“The problem with time travel back in 1995 was that my implementation was absolutely awful. It was slow, slow, slow, slow. Whether or not time travel was a good idea, the implementation was too slow to be interesting, so it was rightfully deleted by the powers that be in the committee that has been dealing with Postgres since 1995,” he told attendees.
Oracle is planning to build a national database of individuals' health records for the whole United States following its $28.3 billion acquisition of electronic health records specialist Cerner.
In a presentation, CTO and founder Larry Ellison said electronic health records for individual patients were stored by hospitals and physicians, and not replicated or shared between providers.
"We're going to solve this problem by putting a unified national health records database on top of all of these thousands of separate hospital databases," Ellison said.
MongoDB, the company behind the document store database, has unveiled columnstore indexing designed to help developers build analytical queries into their applications.
Set to preview later this year, the feature is designed to allow developers to create a purpose-built index to accelerate analytical queries without requiring any changes to the document structure or having to move data to another system.
MongoDB chief product officer Sahir Azam told The Register the feature would be available in the database and Atlas DBaaS to support human-like decision making inside the application based on live data.
MySQL pioneer Peter Zaitsev, an early employee of MySQL AB under the original open source database author Michael "Monty" Widenius, once found it easy to identify the enemy.
"In the early days of MySQL AB, we were there to get Oracle's ass. Our CEO Mårten Mickos was always telling us how we were going to get out there and replace all those Oracle database installations," Zaitsev told The Register.
Speaking at Percona Live, the open source database event hosted by the services company Zaitsev founded in 2006 and runs as chief exec, he said that situation had changed since Oracle ended up owning MySQL in 2010. This was as a consequence of its acquisition that year of Sun Microsystems, which had bought MySQL AB just two years earlier.
Cockroach Labs has finally added a new command line tool with the release of version 22.1 of its eponymous database, out today.
Although it was possible to deploy CockroachDB using something like Terraform (for example, deployment on Oracle Cloud Infrastructure) the process is often not particularly elegant.
"Until this release we didn't have an API to control the database," Jim Walker, recovering developer and product evangelist at Cockroach Labs told The Register during 2022's EU Kubecon in Valencia, Spain.
Biting the hand that feeds IT © 1998–2022