Hierarchical and recursive queries in SQL

Syntax Launches Mentorship Program to Empower the Next Generation of Technology Professionals

Retrieved on: 
Thursday, April 29, 2021

As a result, we are excited to launch a program virtually this year, having matched Syntax employee volunteers with interested Research Triangle High School students.

Key Points: 
  • As a result, we are excited to launch a program virtually this year, having matched Syntax employee volunteers with interested Research Triangle High School students.
  • "\nThe students will meet virtually with their Syntax employee match throughout the semester to receive one-on-one mentorship.
  • "\nSyntax Cares was founded in 2019 after Syntax acquired Freudenberg IT and EmeraldCube in the same year, unifying their CSR efforts into one program.
  • Syntax has offices worldwide, and partners with Oracle, SAP, AWS, Microsoft, IBM, HPE, and other global technology leaders.

CUBRID launches CUBRID 11, Open Source DBMS for OLTP

Retrieved on: 
Wednesday, February 3, 2021

SEOUL, South Korea, Feb. 3, 2021 /PRNewswire/ -- CUBRID is pleased to announce the release of CUBRID 11, the latest stable version of the CUBRID DB engine.

Key Points: 
  • SEOUL, South Korea, Feb. 3, 2021 /PRNewswire/ -- CUBRID is pleased to announce the release of CUBRID 11, the latest stable version of the CUBRID DB engine.
  • In the meantime, CUBRID 11.0 license has been changed from GPL to Apache License 2.0, while CUBRID 10.2 or lower versions still adopt GPL v2 or higher license.
  • The main features of the newly released CUBRID 11 version are as follows:
    Security Enhancement: By providing data encryption and packet encryption, CUBRID 11 improves security.
  • CUBRID is looking forward to improving their product performance and strengthening their market competitiveness with the open source culture's value and philosophy persistently.

PostgreSQL 13 Released: Performance Gains, Space Savings, Enhanced Security, Developer Experience

Retrieved on: 
Thursday, September 24, 2020

Building on work from the previous PostgreSQL release, PostgreSQL 13 can efficiently handle duplicate data in B-tree indexes, the standard database index.

Key Points: 
  • Building on work from the previous PostgreSQL release, PostgreSQL 13 can efficiently handle duplicate data in B-tree indexes, the standard database index.
  • This lowers the overall space usage that B-tree indexes require while improving overall query performance.
  • PostgreSQL 13 introduces incremental sorting, where sorted data from an earlier step in a query can accelerate sorting at a later step.
  • PostgreSQL 13 makes it even easier to work with PostgreSQL data types coming from different data sources.

MariaDB Gives the Power of Analytics to Millions for Free

Retrieved on: 
Wednesday, June 24, 2020

MariaDB is one of the top five most used databases globally with a user base of tens of millions.

Key Points: 
  • MariaDB is one of the top five most used databases globally with a user base of tens of millions.
  • Data analytics are a core component of any modern application, said Gregory Dorman, vice president of distributed systems and analytics, MariaDB Corporation.
  • MariaDB achieves high-performance analytics using MariaDB ColumnStore, which stores data in a columnar format for up to 10x data compression on disk and uses parallel query to perform interactive analytics in real time.
  • MariaDB Community Server 10.5 including ColumnStore is available immediately for free direct download on the MariaDB website now and through Docker Hub by the end of June.

Aqua Data Studio Version 20.5 Introduces Support for Amazon RDS

Retrieved on: 
Tuesday, January 14, 2020

AquaFold (an Idera, Inc. company), a provider of cross-platform database productivity tools, today announced the release of Aqua Data Studio version 20.5 with support for Amazon RDS databases.

Key Points: 
  • AquaFold (an Idera, Inc. company), a provider of cross-platform database productivity tools, today announced the release of Aqua Data Studio version 20.5 with support for Amazon RDS databases.
  • Aqua Data Studio (ADS) is a versatile IDE for databases and visual analytics.
  • Version 20.5 expands support to include multiple database systems hosted on Amazon Web Services (AWS) environments such as Amazon RDS, including Oracle, SQL Server, PostgreSQL, MySQL, and MariaDB.
  • This latest release of Aqua Data Studio streamlines database operations in Amazon RDS, providing a single tool to develop, access, and manage database systems across multiple platforms and data sources.

Aginity Launches Unique SQL Analytic Management Experience for IBM Db2

Retrieved on: 
Wednesday, October 23, 2019

As the leading enterprise in analytic management, Aginity builds next-generation solutions that empower data analysts, data engineers, and data scientists to work more efficiently and collaboratively.

Key Points: 
  • As the leading enterprise in analytic management, Aginity builds next-generation solutions that empower data analysts, data engineers, and data scientists to work more efficiently and collaboratively.
  • "We've worked closely with IBM for several years and are excited to be extending support for the IBM Db2 family of products in Aginity Pro and Aginity Team.
  • Developers using Aginity to write SQL for IBM Db2 will now be able to quickly author queries and take advantage of IBM Db2 features such as in-memory technology, storage optimization, workload management, actionable compression, and continuous data availability.
  • Changing the game for SQL analysts, Aginity provides a SQL coding experience that empowers data analysts, data engineers, and data scientists to find, manage, govern, share and re-use SQL rather than recode it.

PostgreSQL 12 Released! Highlights Include Improved Query Performance, Better Space Management, and Support for SQL/JSON Path Expressions

Retrieved on: 
Thursday, October 3, 2019

PostgreSQL 12 enhancements include notable improvements to query performance, particularly over larger data sets, and overall space utilization.

Key Points: 
  • PostgreSQL 12 enhancements include notable improvements to query performance, particularly over larger data sets, and overall space utilization.
  • The PostgreSQL community continues to support the extensibility and robustness of PostgreSQL, with further additions to internationalization, authentication, and providing easier ways to administrate PostgreSQL.
  • B-tree Indexes, the standard type of indexing in PostgreSQL, have been optimized in PostgreSQL 12 to better handle workloads where the indexes are frequently modified.
  • PostgreSQL 12 introduces the ability to run queries over JSON documents usingJSON path expressionsdefined in the SQL/JSON standard.

Top Independent Research Firm Names TIBCO a Leader in Data Preparation

Retrieved on: 
Thursday, November 8, 2018

Data wrangling with TIBCO Spotfire supports users in fixing data quality issues, inconsistencies, and deficiencies as they interact with their data.

Key Points: 
  • Data wrangling with TIBCO Spotfire supports users in fixing data quality issues, inconsistencies, and deficiencies as they interact with their data.
  • Spotfire seamlessly integrates with the soon-to-be-available TIBCO Spotfire Data Science platform and the TIBCO Data Virtualization product as part of the TIBCO Connected Intelligence platform, offering additional capabilities for the data prep process.
  • Through data functions, Spotfire allows access to TIBCO Spotfire Data Science, R, and Python for further augmentation of data prep capabilities.
  • TIBCO Data Virtualization addresses the needs of data engineers and data stewards for rapidly creating enterprise-ready data and optimized queries for Spotfire and other applications.

TIBCO Announces the AI-Powered A(X) Experience for Spotfire

Retrieved on: 
Tuesday, September 4, 2018

, a global leader in integration, API management, and analytics today announced the A(X) Experience for TIBCO Spotfire, an industry-first, AI-driven analytics experience that fuses agile data exploration with natural language processing (NLP), machine learning recommendations, and model-based authoring, adding native support for real-time streaming data.

Key Points: 
  • , a global leader in integration, API management, and analytics today announced the A(X) Experience for TIBCO Spotfire, an industry-first, AI-driven analytics experience that fuses agile data exploration with natural language processing (NLP), machine learning recommendations, and model-based authoring, adding native support for real-time streaming data.
  • Complementing the Spotfire product's familiar point-and-click, agile data exploration, the A(X) Experience seamlessly surfaces machine-learning-based guidance, recommending data relationships and uncovering patterns for users as they explore.
  • The A(X) Experience will be available this fall with the release of TIBCO Spotfire X.
  • Learn how TIBCO makes digital
    TIBCO, Spotfire, and the TIBCO logo are trademarks or registered trademarks of TIBCO Software Inc. and/or its subsidiaries in the United States and/or other countries.