• chevron_right

      Overhauling Apache Kylin for the cloud

      pubsub.slavino.sk / infoworldcom · Thursday, 18 November, 2021 - 18:00 edit

    Recently, the Apache Kylin community released a major update with the general availability of Kylin 4. Kylin 4 continues the mission to provide a unified, high-performance, cloud-friendly, open source OLAP (online analytical processing) platform. Kylin 4 upgrades the Kylin architecture to make it easy to deploy and scale in the cloud. The new release features three major platform updates and myriad other improvements.

    First, Kylin 4 replaces its previous HBase storage engine with Apache Parquet, making it possible to decouple compute and storage for unlimited independent scalability. Second, Kylin 4 unifies the compute engine and removes any previous dependencies on the Hadoop ecosystem. This makes resource allocation much more flexible, resulting in a significant reduction in total cloud resource usage and associated costs. Third, by introducing a brand new, fully distributed query engine, Kylin 4 makes cubing duration and query latency much more performant compared to previous releases.

    To read this article in full, please click here

    Značky: #SQL, #Analytics, #Rozne, #Database

    • chevron_right

      Oracle accelerates MySQL HeatWave queries with machine learning

      pubsub.slavino.sk / infoworldcom · Tuesday, 10 August, 2021 - 19:18 edit

    Taking aim at competitors including Amazon Aurora and Snowflake , Oracle has enhanced the MySQL HeatWave in-memory query accelerator in the Oracle Cloud’s MySQL Database Service by leveraging advanced machine learning. But Oracle insists the improvements do not mean the MySQL Database Service is encroaching on its flagship Oracle Database .

    To read this article in full, please click here

    Značky: #Database, #Rozne, #MySQL

    • chevron_right

      The long, long reigns of popular databases

      pubsub.slavino.sk / infoworldcom · Tuesday, 10 August, 2021 - 10:00 edit

    Database habits die hard. Just ask Oracle, which continues to rake in billions in database revenue despite being one of developers’ “most dreaded” databases, according to Stack Overflow’s 2021 survey of 72,517 developers. But let’s not focus on the negative. Just like last year (and 2019, 2018, 2017, and 2016), Redis topped the charts as developers’ “most loved” database, followed closely by PostgreSQL and MongoDB. Go back to 2017 and the headliners on this database love-in are largely the same, though SQL Server has fallen down the rankings since then, and Google’s Firebase has climbed up.

    To read this article in full, please click here

    Značky: #Rozne, #Database

    • chevron_right

      The persistence of database time

      pubsub.slavino.sk / infoworldcom · Monday, 9 August, 2021 - 10:00 edit

    Database habits die hard. Just ask Oracle, which continues to rake in billions in database revenue despite being one of developers’ “most dreaded” databases, according to Stack Overflow’s 2021 survey of 72,517 developers. But let’s not focus on the negative. Just like last year (and 2019, 2018, 2017, and 2016), Redis topped the charts as developers’ “most loved” database, followed closely by PostgreSQL and MongoDB. Go back to 2017 and the headliners on this database love-in are largely the same, though SQL Server has fallen down the rankings since then, and Google’s Firebase has climbed up.

    To read this article in full, please click here

    Značky: #Rozne, #Database

    • chevron_right

      Cloud database and cloud infrastructure people need to talk

      pubsub.slavino.sk / infoworldcom · Tuesday, 3 August, 2021 - 10:00 edit

    Most development and deployment teams now work better than they did prior to cloud computing. The rise of agile and devops/devsecops set the framework for ops and dev teams to work more closely together. Dev now works well with ops, and the other way around.

    However, I’m noticing some flaws in the system. Namely, the cloud database designers who work with cloud-native and non-native databases don’t seem to be syncing up with the infrastructure designers/architects who provide important resources for a cloud database, including storage and compute.

    [ Also on InfoWorld: 8 databases supporting in-database machine learning ]

    This results in a few bad outcomes.

    To read this article in full, please click here

    Značky: #Rozne, #Database

    • chevron_right

      The shifting market for PostgreSQL

      pubsub.slavino.sk / infoworldcom · Monday, 1 February, 2021 - 11:00 edit

    PostgreSQL has been around in some form since 1986, yet somehow keeps getting younger and hipper with each year. Startups like Timescale have found old-school PostgreSQL to be key to building their new-school database products, joining companies like EnterpriseDB in deepening PostgreSQL’s popularity. In fact, EnterpriseDB just celebrated its 44th consecutive quarter of rising annual recurring revenue. That’s 11 years of PostgreSQL paying the bills (and growing the number of bills EnterpriseDB can afford to pay).

    As steady as PostgreSQL has been , however, its progress hasn’t been linear. I recently spoke with EnterpriseDB CEO Ed Boyajian, now in his 13th year at the helm of the company, who talked about the essential ingredients to PostgreSQL’s rise. The first? Developers. Yes, developers, who keep evolving PostgreSQL to meet new needs in the cloud, even as they optimize it to handle their oldest, on-premises requirements.

    To read this article in full, please click here

    Značky: #Analytics, #Database, #Rozne

    • chevron_right

      How to run Cassandra and Kubernetes together

      pubsub.slavino.sk / infoworldcom · Wednesday, 30 September, 2020 - 10:00 edit

    Containers have become increasingly popular for developers who want to deploy applications in the cloud. To manage these new applications, Kubernetes has become a de facto standard for container orchestration. Kubernetes enables developers to build distributed applications that automatically scale elastically, depending on demand.

    Kubernetes was developed to effortlessly deploy, scale, and manage stateless application workloads in production. When it comes to stateful, cloud-native data, there has been a need for the same ease of deployment and scale.

    To read this article in full, please click here

    Značky: #NoSQL, #Kubernetes, #Rozne, #Database

    • chevron_right

      The year of PostgreSQL is every year

      pubsub.slavino.sk / infoworldcom · Monday, 28 September, 2020 - 10:00 edit

    PostgreSQL really has no right to be cool. PostgreSQL development began during the Reagan administration — in 1986! Although shepherded by “exceptional early leadership,” according to open source luminary Mike Olson , the project was later superseded in popularity by its Eurovision-esque cousin, MySQL, which launched in 1995.

    Yet over the past decade PostgreSQL has become hip with startups and enterprises alike, surging in popularity to become the world’s fourth-most-popular database , steadily gaining on MySQL, Microsoft SQL Server, and Oracle.

    To read this article in full, please click here

    Značky: #SQL, #Database, #Rozne

    • chevron_right

      Do we need so many databases?

      Matt Asay · pubsub.slavino.sk / infoworldcom · Monday, 29 June, 2020 - 10:00 edit

    The world used to get by on just a smattering of databases. You know, trusty relational workhorses like Oracle, Microsoft SQL Server, Ingres, and IBM DB2. Soon enough, however, open source crashed the party with MySQL and PostgreSQL. A bit later, NoSQL databases hit the market, with the likes of MongoDB, Redis, and Apache Cassandra growing in popularity. In terms of numbers, by January 2013 DB-Engines, which ranks database popularity, listed 109 databases. Today? DB-Engines catalogs 356 databases, more than triple the number just seven years ago.

    To read this article in full, please click here

    Značky: #Database, #Rozne