Tag: SQL

Feed: AWS Big Data Blog. re:Invent 2018 is around the corner! This year, data and analytics tracks are bigger than ever.This blog post highlights the data and analytics sessions at re:Invent 2018. If you’re attending this year, you want to check out the sessions, workshops, chalk talks, and builder sessions that we have at the conference. As in previous years, you can find these events in various topic categories, such as Analytics, Deep Learning, AI Summit, Serverless, Architecture, and Databases. We have great sessions from Intuit, Nike, Intel, WuXi NextCODE, Warner Brothers, AutoDesk, NFL, SendGrid, McDonald, AirBnB, Hilton, Guardian Life, ... Read More

Feed: R-bloggers. Author: R on datawookie. Related To leave a comment for the author, please follow the link and comment on their blog: R on datawookie. R-bloggers.com offers daily e-mail updates about R news and tutorials on topics such as: Data science, Big Data, R jobs, visualization (ggplot2, Boxplots, maps, animation), programming (RStudio, Sweave, LaTeX, SQL, Eclipse, git, hadoop, Web Scraping) statistics (regression, PCA, time series, trading) and more... If you got this far, why not subscribe for updates from the site? Choose your flavor: e-mail, twitter, RSS, or facebook ... Read More

Feed: Planet PostgreSQL. Near the end of November, Packt published the book PostgreSQL 11 Server Side Programming Quick Start Guide, authored by me. *This post has the only aim of describing the book contents and the reason behind choices related to it.** Following a consolidated tradition, Packt is producing more and more books on PostgreSQL and related technologies, and this is the first one that covers aspects about the freshly released PostgreSQL 11 version. Nevertheless, this does not mean that the book is only for PostgreSQL 11 users and administrators: it covers topics, concepts and provide examples that can be ... Read More

Feed: Blog. Author: Peter V.; SQL queries are the primary mechanism to interact with databases. Therefore, ensuring that SQL queries perform well is essential. An important method to improve the performance of SQL queries is to use indexes properly to locate data quickly. To create useful indexes, it is essential to understand how databases store data versus what type of data SQL queries need to access.Visual SQL tuning refers to parsing an SQL query, analyzing the indexes and constraints on the tables in the SQL query, and displaying the SQL query represented as relational models in diagrams. Visual SQL tuning ... Read More

Feed: R-bloggers. Author: R on kieranhealy.org. Data Visualization: A Practical Introduction will begin shipping next week. I’ve written an R package that contains datasets, functions, and a course packet to go along with the book. The socviz package contains about twenty five datasets and a number of utility and convenience functions. The datasets range in size from things with just a few rows (used for purely illustrative purproses) to datasets with over 120,000 observations, for practicing with and exploring. A course packet is also included the package. This is a zipped file containing an R Studio project consisting of nine ... Read More

Feed: Blog. Author: Kim Brushaber; It seems like we hear about a new data breach on an almost daily basis.  This past week, we heard about two newsworthy data breaches that were caused/detected in some part by a Merger or Acquisition. The first worth mentioning is the Starwood/Marriott data breach which affected up to 500 million accounts.  It has been reported that an "unauthorized party" was able to copy and encrypt information from the Starwood guest systems.  There is also a possibility that some information may have been removed.  The breach was detected before Sept 10 but may date as far back ... Read More

Feed: Microsoft Azure Blog. Author: Ercenk Keresteci. This blog continues our coverage of the solution guide published by Microsoft’s Industry Experiences team. The guide includes the following components: Ingesting data Hot path processing Cold path processing Analytics clients We already covered the recommendation for processing data for an IoT application in the solution guide and suggested using Lambda architecture for data flow. To reiterate the data paths: A batch layer (cold path) stores all incoming data in its raw form and performs batch processing on the data. The result of this processing is stored as a batch view. It is ... Read More

Feed: R-bloggers. Author: Jakob Gepp. We at STATWORX work a lot with R and we often use the same little helper functions within our projects. These functions ease our daily work life by reducing repetitive code parts or by creating overviews of our projects. At first, there was no plan to make a package, but soon I realised, that it will be much easier to share and improve those functions, if they are within a package. Up till the 24th December I will present one function each day from helfRlein. So, on the 12th day of Christmas my true love ... Read More

Feed: Hadoop Dev. Author: Nagapriya Tiruthani. As we are wrapping up 2018 and looking ahead to the New Year, we are delighted to share some new capabilities added to our products and some details on events coming early next year.   Product news: Excited to announce the availability of IBM Db2 Big SQL v5.0.4 (on HDP 2.6) IBM Db2 Big SQL, an advanced SQL engine on Hadoop, has been making strides with the fast-evolving open source ecosystem by supercharging your analytical workloads on data lakes. The core capabilities of Big SQL focusses on data virtualization, SQL compatibility, scalability, performance, and of course ... Read More

Feed: Blog. Author: leopicasso; Today’s blog post concludes our four-part look into SQL performance and optimization. Part one introduced and explained relational optimization; part two reviewed query analysis and introduced single-table access path formulation; part three took a look at multi-table SQL optimization… and today we conclude with a quick overview of several additional aspects of SQL optimization that we have yet to discuss.Using Indexes to Avoid Sorts To satisfy certain types of SQL requests it may be necessary for the DBMS to sort data. But sorting is cost prohibitive and should be avoided if at all possible. The relational ... Read More