Tag: use case

Feed: Featured Blog Posts - Big Data News Author: Ayush Among the major reasons we created our Data is the fact that there just are not a ton of open datasets that are great out there for startups, small businesses, and professors to do on work. We consider that open data should become the newest source that is open; we presume clean, enriched big data that is shared is among the essential elements to initiation that is actual. That is why we were very pleased to learn exactly what the people around at MonkeyLearn are doing with a few of the ... Read More

Postgres-BDR: 2 Years in Production → The right answer is of course “Use PostgreSQL”. It’s the main distro and we want you to use that as often as possible. The Postgres-BDR and Postgres-XL projects are also fully open source projects, using the same copyright and licence as the main PostgreSQL project. So if you’re using PostgreSQL, they are also options to consider if you want extended functionality. What does Postgres-BDR do? BDR allows you to have a widely distributed cluster of nodes that give you multiple full copies of a database. So you can have copies of the database in ... Read More

Developing multi-tenant applications with Row-Level Security (RLS) just got a little easier. This post makes available a script that will automatically apply an RLS predicate to all tables in a database. Applications with multi-tenant databases, including those using Elastic Scale for sharding, commonly have a “TenantId” column in every table to indicate which rows belong to each tenant. As described in Building More Secure Middle-Tier Applications with Azure SQL Database using Row-Level Security, the recommended approach for filtering out rows that don’t belong to a tenant querying the database is to create an RLS security policy that filters out rows ... Read More

Feed: AWS Compute Blog. Author: Bryan Liston. Ronald Widha @ronaldwidhaPartner Solutions Architect Redirection is neither a success nor an error response. You return redirection when the requested resource resides either temporarily or permanently under a different URI. The client needs to issue subsequent calls to the new location in order to retrieve the requested resource. Even though you typically see 302 and 301 redirects when requesting text/html, these response types also apply to REST JSON endpoints. Many of you are already familiar how to return success and error responses. Amazon API Gateway and AWS Lambda help development teams to build ... Read More

New in Big SQL 4.2 is the capability to allow an expression to be specified in the CREATE HADOOP TABLE statement in the PARTITIONED BY clause. This feature is very flexible, you can choose to partition based on any allowed expression. For an overview of this feature, please look at the following post. This blog will focus on transformations for time and date analysis, as it is a common use case, but you can tailor this feature to your needs. This feature is especially attractive for time and date analysis because: Partitioning on timestamps is not allowed but with this ... Read More

Feed: Hortonworks Blog – Hortonworks Author: Kenneth Smith Baker Hughes CEO Martin Craighead says: “If a typical deep water well is like going to the moon, then the Gulf of Mexico ultra-deep water frontier is like going to Mars.”* Safely performing these kinds of complex and high risk operations requires many people to collaborate, share information and make informed decisions quickly.  When great distance separates those performing work from those in supporting roles the challenges are even greater. NASA pioneered the technologies necessary deal with such remote operating challenges during the early space program. The basic principles NASA developed are ... Read More

Feed: Microsoft Azure Blog. Author: Jovan Popovic. We are happy to announce that you can now query and store both relational and textual data formatted in JavaScript Object Notation (JSON) using Azure SQL Database. Azure SQL Database provides simple built-in functions that read data from JSON text, transform JSON text into table, and format data from SQL tables as JSON. You can use JSON functions that enable you to extract value from JSON text (JSON_VALUE), extract object from JSON (JSON_QUERY), update some value in JSON text (JSON_MODIFY), and verify that JSON text is properly formatted (ISJSON). OPENJSON function enables you ... Read More

Imagine that you were tasked with indexing (categorizing and summarizing) the contents of a large collection of randomly formatted text documents to make them easily accessible throughout your company. Perhaps this use case contains legal documents as well as medical records (with various levels of sensitivity). Suppose that the size of this collection contained over 100 million documents that you had to analyze. Besides categorizing each document as medical or legal, you must also assign them to subcategories like cardiology or probate. Finally, you must capture the meaning of each document for reporting and analytics. Besides setting aside the rest ... Read More

Reviewed by Panagiotis Antonopoulos, Jakub Szymaszek, Raghav Kaushik Always Encrypted is one of the compelling features in SQL Server 2016 and in Azure SQL DB which provides a unique guarantee that data in the database cannot be viewed, accidentally or intentionally by users who do not have the ‘master key’ required to decrypt that data. If you want to know more about this feature, please review the product documentation at the previous link or watch the Channel 9 video on this topic. Customer Scenario In a recent case, we were working with a customer who was trying to use Table ... Read More

← PostgreSQL Solutions Roadmap PostgreSQL 10 Roadmap → An Uber technical blog of July 2016 described the perception of “many Postgres limitations”. Regrettably, a number of important technical points are either not correct or not wholly correct because they overlook many optimizations in PostgreSQL that were added specifically to address the cases discussed. In most cases, those limitations were actually true in the distant past of 5-10 years ago, so that leaves us with the impression of comparing MySQL as it is now with PostgreSQL as it was a decade ago. This is no doubt because the post was actually ... Read More