Tag: SQL

Feed: Recent Announcements. Amazon EMR integration with AWS Lake Formation allows you to define and enforce database, table, and column-level permissions when Apache Spark users access data in Amazon S3 through the Glue Data Catalog. Previously, with AWS Lake Formation integration is enabled, you were limited to only being able to read data using Spark SQL statements such as SHOW DATABASES and DESCRIBE TABLE. Now, you can also insert data into, or update the Glue Data Catalog tables with these statements: INSERT INTO, INSERT OVERWRITE, and ALTER TABLE. This feature is enabled on Amazon EMR 5.34 in the following AWS ... Read More

Feed: Recent Announcements. New minor versions of Microsoft SQL Server are now available on Amazon RDS for SQL Server, offering performance and security fixes. Amazon RDS for SQL Server supports the new minor versions for Microsoft SQL Server 2019 and 2017 on the Express, Web, Standard, and Enterprise Editions ... Read More

Feed: Planet PostgreSQL. pg_stat_statements can identify long queries, but are limited when we need to go further: the queries are normalized with values replaced by parameters. And the metrics gathered are cumulative, about time, with min, max, average, stddev, usually over a long time window. It is hard to catch the statements responsible for the activity at peak load, and when caught, not easy to reproduce the execution plan, know the user, or the application that ran it. pg_stat_activity holds this information and here is small script to sample it. The goal of sampling the running statements is to start ... Read More

Feed: Recent Announcements. AWS Launch Wizard now creates an AWS Service Catalog product when the SQL Server deployment is complete. You can then use the AWS Service Catalog product for repeated SQL Server deployments on EC2. This feature simplifies your subsequent SQL Server deployments, saves time by reusing associated configuration scripts, and makes the integration with your existing DevOps tools easier. AWS Launch Wizard enables you to easily size, configure, and deploy SQL Server workloads on EC2. You can enable the Service Catalog integration by selecting a check box and entering your S3 bucket location on the Launch Wizard console ... Read More

Feed: Recent Announcements. Amazon EMR Studio is an integrated development environment (IDE) that makes it easy for data scientists and data engineers to develop, visualize, and debug big data and analytics applications written in R, Python, Scala, and PySpark. Today, we are excited to introduce SQL Explorer, a feature in your EMR Studio Workspace that allows you to browse the data catalog and run SQL queries on EMR clusters from EMR Studio. This release of SQL Explorer in EMR Studio supports running SQL queries on Amazon EMR on EC2 clusters running Presto version 0.254.1 or higher.  Presto is a fast SQL query engine ... Read More

Feed: Recent Announcements. Amazon RDS for SQL Server now supports SQL Server Analysis Services (SSAS) in Multidimensional mode. There is no additional cost to install SSAS directly on your Amazon RDS for SQL Server DB instance ... Read More

Feed: James Serra's Blog. Author: James Serra. A very brief history of databases for online transaction processing (OLTP) workloads starts with relational databases (RDBMS), which worked well for many years. With the advent of the internet and the need for millions of transactions per second, NoSQL filled that need, but is modeled in means other than the tabular relations used in relational databases and uses eventual consistency instead of ACID (among other differences). Then came NewSQL, which is a class of RDBMS that seeks to provide the scalability of NoSQL systems for OLTP workloads while maintaining the ACID guarantees of a traditional database system. Now the latest technology for ... Read More

Feed: Planet NoSQL. Author: Keshav Murthy. Icons made by Freepik from www.flaticon.com(With SQL) Your app is sitting on a Ferrari-style compute engine.  — Lukas EderOver time, the database industry has realized text search and SQL are two sides of the same coin. Text search needs further query processing, query processing needs text search to efficiently filter for text patterns. The SQL databases have added text search within them, albeit for a single node SMP systems.Couchbase Full-Text Search (FTS) is created with three main motivations:Transparently search across multiple fields within a documentGo beyond the exact matching of values by providing language based stemming, ... Read More

Feed: Planet NoSQL. Author: Keshav Murthy.  AbstractCouchbase is a distributed JSON database. It provides distributed data processing, high-performance indexing, and declarative query language N1QL along with search index, eventing, and analytics.N1QL (Non First Normal Query Language) is SQL for JSON. N1QL is to JSON what SQL is to relations. Developers say what needs to be done and the N1QL engine will figure out the "how." Current N1QL optimizer is a rule-based optimizer. Cost-Based Optimizer (CBO) for SQL was invented at IBM some 40 years ago and has been critical to the success of RDBMS and the developer/DBA productivity. NoSQL databases were invented some ... Read More

Feed: Planet NoSQL. Author: Keshav Murthy. DZone published [Apr-16-2019]Two score and five years ago, two young IBM researchers brought forth databases; a new language conceived in relational and dedicated to the proposition that data can be manipulated declaratively and easily. In the years since Don Chamberlin and Ramond Boyce published SQL: A Structured English Query Language, relational models and SQL have been extended and adapted to a significant number of technologies: OLTP, OLAP, object databases, object-relational databases, and even NoSQL. SQL has inspired query language design for non-relational databases: SQL for object databases, SQL for object-relational, SQL for XML, SQL for spatial, ... Read More