Tag: INDEX

Feed: Planet PostgreSQL. SQL extract provides access to the components of temporal data types—i.e. date, time, timestamp, and interval.SQL extract uses the keyword from to separate the field name from the value.EXTRACT( FROM )The field names are SQL keywords too—you must not put them in double or single quotes.SQL extract returns an exact numeric value. For second, it also includes fractions. The following table lists the extract fields defined by the SQL standard.Meaningextract fieldYearYEARMonthMONTHDay of monthDAY24 hourHOURMinuteMINUTESeconds (including fractions)SECONDTime zone hourTIMEZONE_HOURTime zone minuteTIMEZONE_MINUTERelated FeaturesExtract can only get single fields. To extract the full date (year, month, day) or time (hour, ... Read More

Feed: R-bloggers. Author: hrbrmstr. International Code Talk Like A Pirate Day almost slipped by without me noticing (September has been a crazy busy month), but it popped up in the calendar notifications today and I was glad that I had prepped the meat of a post a few weeks back. There will be no ‘rrrrrr’ abuse in this post, I’m afraid, but there will be plenty of R code. We’re going to combine pirate day with “pirating” data, in the sense that I’m going to show one way on how to use the web scraping powers of R responsibly to ... Read More

Feed: R-bloggers. Author: Troy Walters. Many of the methods used in time series analysis and forecasting have been around for quite some time but have taken a back seat to machine learning techniques in recent years. Nevertheless, time series analysis and forecasting are useful tools in any data scientist’s toolkit. Some recent time series-based competitions have recently appeared on kaggle, such as one hosted by Wikipedia where competitors are asked to forecast web traffic to various pages of the site. As an economist, I have been working with time series data for many years; however, I was largely unfamiliar with ... Read More

Feed: SAS Blogs. Author: Jim Harris. Data preparation is the task of blending, shaping and cleansing data to get it ready for analytics or other business purposes. Data preparation begins with attempting to find the data best-suited for a specific purpose – an exercise that many users cite as frustrating and time-consuming. With so much data available from numerous sources in various formats, it's crucial to be able to discover the right data quickly. Only then can you expedite the process of getting value out of the vast data assets from across your enterprise. Creating and maintaining a comprehensive, well-documented data catalog ... Read More

Feed: R-bloggers. Author: Christoph Safferling. Q: What has 8 legs, 8 arms and 8 eyes?A: 8 pirates. Avast, ye scurvy scum! Today be September 19, the International Talk Like A Pirate Day. While it’s a silly “holiday”, it’s a great chance to switch your Facebook to Pirate English (“Arr, this be pleasing to me eye!”). Also, it’s as good a reason as any to go sailing the Internet Main, scouring for booty (data)! Well, any excuse, y’know… What is today known (more or less) as “Pirate English” (the bit with all the “arrr!”, “ahoy, ye matey!”, etc) is in fact ... Read More

Feed: All - O'Reilly Media. Author: Lu Niu, Peng Du, Zhenxiao Luo. Uber’s Presto architecture (source: Courtesy of Zhenxiao Luo) For more on efficient geospatial analysis, check out Zhenxiao Luo and Wei Yan’s session, “Geospatial big data analysis at Uber,” at the Strata NYC Data Conference in NYC, September 25-28, 2017. From determining the most convenient rider pickup points to predicting the fastest routes, Uber aims to use data-driven analytics to create seamless trip experiences. Within engineering, analytics inform decision-making processes across the board. One of the distinct challenges for Uber is analyzing geospatial big data. City locations, trips, and ... Read More

Feed: Actian. Author: Emma McGrattan. Today we announce the introduction of the next release of Actian Vector in Hadoop, extending our support of Apache Spark to include direct access to native Hadoop file formats and tighter integration with Spark SQL and Spark R applications. In this release, we also incorporate performance improvements, integration with Hadoop security frameworks, and administrative enhancements. I’ll cover each of these in greater detail below.Combine Native Hadoop Tables with Vector Tables In previous releases, Vector in Hadoop required data to be stored in a proprietary format which optimized analytics performance and deliver great compression to reduce ... Read More

Feed: SAS Blogs. Author: Warren F. Kuhfeld. A customer asks if it is possible to put one graph inside of another. The question states that this format is sometimes used in the New England Journal of Medicine. Click here to see the original question in SAS Communities and the graph. There are several ways of inserting graphs into graphs. I will illustrate three. See Lelia McConnell's blog Picture-in-Picture for a fourth method. The three methods that I show all have in common that you can store a graph in an image file and then use SG Annotation (or its GTL ... Read More

Feed: Planet big data. Author: Joana van den Brink-Quintanilha. The CX leadership gapGet an exclusive look at the 2017 CX Index results and discover how to create breakaway CX. Register for the webinar    Why is journey analytics such a hot topic? Because it can help firms move the needle on customer obsession. That’s why after months of research — including in-depth briefings, demos, and customer references — we’re excited to announce the release of not one but two Forrester Wave’s focused on customer journey analytics platforms! Customer journey analytics is: An analytics practice that combines quantitative and qualitative data to ... Read More

Feed: Planet MySQL; Author: The Pythian Group; This edition of Log Buffer covers Cloud, Oracle, SQL Server and MySQL and much more.Cloud:Introducing managed SSL for Google App EngineUsing Cloud Foundry CUPS to inject Spring Security credentials into a Spring Boot ApplicationClusterControl in the Cloud – All Our ResourcesMonitoring Amazon Aurora Audit Events with Amazon CloudWatchIntegrating Teradata with Amazon Redshift Using the AWS Schema Conversion ToolOracle:Demo App for REST enabled SQLThe Insurance of Oracle APEX – Can Your Low Code Framework Do This?Oracle GoldenGate is now avaliable on Docker! All the details you need to get up and running on an ... Read More