Feed: SAS BlogsRSS – SAS Blogs. Author: Anne Milley. Galit Shmueli, National Tsing Hua University’s Distinguished Professor of Service Science, will be visiting the SAS campus this month for an interview for an Analytically Speaking webcast. Her research interests span a number of interesting topics, most notably her acclaimed research, To Explain or Predict, as well as noteworthy research on statistical strategy, bio-surveillance, online auctions, count data models, quality control and more. In the Analytically Speaking interview, we’ll focus on her most interesting Explain or Predict work as well as her research on Information Quality and Behavioral Big Data, which ... Read More

Feed: Planet MySQL. Author: Fernando Ipar. read Ok, maybe evil is too strong a word, but MySQL can certainly be deceiving. To some extent, and in some circles, MySQL still suffers from a bad reputation as a database. In fact, I have personally tried to fight that reputation in the past. However, I'll be honest and say that, sometimes, it deserves it. As an example, take the ASC|DESC keyword in index creation. MySQL 8.0 support those, thanks for that! But what happens in older versions? Let me quote the Fine Manual: An index_col_name specification can end with ASC or DESC ... Read More

Feed: All Oracle Press Releases. Contact Info About Oracle Oracle offers a comprehensive and fully integrated stack of cloud applications and platform services. For more information about Oracle (NYSE:ORCL), visit www.oracle.com. Trademarks Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners. Additional Information This communication does not constitute an offer to buy or solicitation of an offer to sell any securities. This communication is for informational purposes only. The tender offer is not being made to, nor will tenders be accepted from, or ... Read More

Feed: SQL Server Release Services. Author: Parikshit Savjani. The SQL Product team has identified an issue with .Net 4.6.2 framework client driver for Always Encrypted enabled database on SQL Server 2016 and Azure SQL Database. The issue can lead to intermittent failure while trying to decrypt the records from the Always Encrypted enabled database with following error message Decryption failed. The last 10 bytes of the encrypted column encryption key are: ‘7E-0B-E6-D3-39-CE-35-86-2F-AA’.The first 10 bytes of ciphertext are: ’01-C3-D7-39-33-2F-E6-44-C3-B1′.Specified ciphertext has an invalid authentication tag.  The above failure to decrypt may potentially lead to incorrect query results which in turn ... Read More

Feed: Planet PostgreSQL. It’s a common misconception that high volume read-write workloads in PostgreSQL inevitably causes database inefficiency. We’ve heard of cases where users encounter slowdowns doing only a few hundred writes per second and turn to systems like Dynamo or Cassandra out of frustration. However PostgreSQL can handle these workloads without a problem as long as it is configured correctly. The problems stem from what’s known as “bloat,” a phenomenon of PostgreSQL and other MVCC databases which causes increased space usage and decreased performance. We’ll see how autovacuum, a tool to combat bloat, is typically misunderstood and misconfigured. By ... Read More

Feed: AWS Compute Blog. Author: Bryan Liston. Sunil MallyaSolutions ArchitectBig data processing solutions have been using AWS Lambda more lately; customers have been creating solutions such as building metadata indexes for Amazon S3 using Lambda and Amazon DynamoDB and stream processing of data in S3. In this post, I discuss a serverless architecture to run MapReduce jobs using Lambda and S3. Lambda launched in 2015, enabling customers to execute code on demand without any dedicated infrastructure. Since then, customers have successfully used Lambda for various use cases like event-driven processing for data ingested into S3 or Amazon Kinesis, web API ... Read More

Feed: Planet MySQL. Author: Pinterest Engineering. Pinterest’s stateful online systems process tens of petabytes of data every day. As we build products and scale billions of Pins to 150 million people, we need new applications that work in a way where computation co-locates with data. That’s why we adopted RocksDB. It’s adaptable, supports basic and advanced database operations with high performance and meets the majority of requirements for building large-scale, production-strength distributed stateful services. Yet two critical pieces were missing for us: real-time data replication and cluster management for RocksDB-based stateful services. To fill this gap, we built a RocksDB ... Read More

Feed: AWS Big Data Blog. Craig Foster is a Big Data Engineer with Amazon EMRApache Flink is a parallel data processing engine that customers are using to build real time, big data applications. Flink enables you to perform transformations on many different data sources, such as Amazon Kinesis Streams or the Apache Cassandra database.  It provides both batch and streaming APIs. Also, Flink has some SQL support for these stream and batch datasets. Most of Flink’s API actions are very similar to the transformations on distributed object collections found in Apache Hadoop or Apache Spark. Flink’s API is categorized into ... Read More

Feed: Planet big data. Author: Hong Ooi. This post is to announce some new features for the dplyrXdf package, which provides useful tools for manipulating Xdf data files for use with the RevoScaleR library included with Microsoft R Client and Microsoft R Server. Extraction operators Sometimes it's useful to be able to extract variables from an Xdf file. With a data frame, you can do this with the $ and [[ operators: for example iris$Species and iris[["Species"]] both return the Species column (as a vector) from the iris dataset. This update to dplyrXdf implements the same functionality for Xdf files: ... Read More

Feed: Microsoft Dynamics 365 Blog. Author: Tricia Morris. The exponential pace of disruptive innovation is fundamentally changing the way we do business. For brands and organizations, digital transformation - defined by Constellation Research as the methodology in which organizations transform and create new business models and culture with digital technologies - is vital to long-term success. In a recent interview, Ray Wang (Principal Analyst, Founder, and Chairman of Constellation Research and author of the best-selling book Disrupting Digital Business) gave his insights on the impact of digital transformation on key business processes. In a previous post, we explored digital transformation’s ... Read More