Tag: data warehouse

Feed: Planet PostgreSQL. At PGCon 2020, I gave a presentation proposing that the PostgreSQL community could use better benchmarking tools to serve the open source developers.  Some of us continued discussing that during the unconference shortly after.  Here I describe a proof of concept for an open source framework to run, but not necessarily limited to, user defined benchmarks that follows the model of loading a database and running a series of queries.The goal of this framework is to have simpler way create, modify, and execute benchmarks.  I will try to demonstrate that by using dbgen and qgen provided by ... Read More

Feed: Matillion. Author: Ashley Lozito; Since launching in 2015, Matillion ETL has been used to provide faster time to value and increase data innovation for a wide range of users and across many industries. And as the number of users on our platform continues to increase, we see a handful of questions that always come up when data professionals evaluate and onboard Matillion ETL.To help our prospective users and new customers understand more about the capabilities of Matillion ETL and how the product works, our Solution Architects sat down to field some of the common questions we get asked about ... Read More

Feed: AWS Big Data Blog. Today, more data is created every hour than in an entire year just 20 years ago. Successful organizations are leveraging this data to deliver better service to their customers, improve their products, and run an efficient and effective business. As the importance of data and analytics continues to grow, the Amazon Redshift cloud data warehouse service is evolving to meet the needs of our customers. Amazon Redshift was the first data warehouse built for the cloud in 2012, and we’ve constantly listened to our customers to deliver on our promise of a fast, scalable, and ... Read More

Feed: AWS Big Data Blog. The continuous growth of data volumes combined with requirements to implement long-term retention (typically due to specific industry regulations) puts pressure on the storage costs of data warehouse solutions, even for cloud native data warehouse services such as Amazon Redshift. The introduction of the new Amazon Redshift RA3 node types helped in decoupling compute from storage growth. Integration points provided by Amazon Redshift Spectrum, Amazon Simple Storage Service (Amazon S3) storage classes, and other Amazon S3 features allow for compliance of retention policies while keeping costs under control. An enterprise customer in Italy asked the ... Read More

Feed: CIO. Author: . With more and more data at our fingertips, it’s getting harder to focus on the information relevant to our problems and present it in an actionable way. That’s what business intelligence is all about.BI tools make it simpler to corral the right data and visualize it in ways that enable us to understand what it means. But how simple that process gets, and how you can visualize the data depends on the tool: Picking the right one for your needs becomes important.Here we round up of a dozen popular, highly regarded BI tools to help you ... Read More

Feed: AWS Architecture Blog. Customers from startups to enterprises observe increased revenue when personalizing customer interactions. Still, many companies are not yet leveraging the power of personalization, or, are relying solely on rule-based strategies. Those strategies are effort-intensive to maintain and not effective. Common reasons for not launching machine learning (ML) based personalization projects include: the complexity of aggregating and preparing the datasets, gaps in data science expertise and the lack of trust regarding the quality of ML recommendations. This blog post demonstrates an approach for product recommendations to mitigate those concerns using historical datasets. To get started with your ... Read More

Feed: Matillion. Author: Ashley Lozito; Like most technology sectors, the data integration and data management spaces are an alphabet soup full of acronyms. Our Solution Architect team – the amazing members of Team Green that help our customers find success with Matillion products – are constantly being asked: “Which of these acronyms should we pay attention to, and why? These are a few of their answers to the most common questions.“Why choose ELT over ETL?”If you are considering  Matillion, you have a modern data platform built in the cloud. So you already know how quickly cloud data warehouses help companies ... Read More

Feed: Microsoft Azure Blog. Author: Ravi Krishnaswamy. Each new year introduces new opportunities and challenges, but 2020 was exceptional. The pandemic massively disrupted retail organizations due to ongoing shelter-in-place orders and social distancing requirements. Consumers adapted, driving nine years’ worth of e-commerce growth in 90 days. Retailers responded by dramatically accelerating their digital transformation journeys to focus on prioritizing customer health and safety, reimagining channel retail experiences, and enabling data-driven decision making. So, as we prepare for NRF 2021—the association’s first all-digital-event—we are reflecting on the industry’s incredible, ongoing adaptation to pandemic-driven trends and the impact in 2021 and beyond ... Read More

Feed: Matillion. Author: Julie Polito; Our data is scattered. Locked in different systems, separated in silos, data is all over the place, and it’s accumulating at a staggering rate. But data can be so much more valuable when we can get it all in the same place. When we have all of our data together, we can gain a 360-degree view of our organizations. We can then use information about our customers, products, and services to make faster, better, more informed business decisions.Data migration is now an essential component of data management and is the key to gaining this 360-degree ... Read More

Feed: The Connector by Workato. Author: Vijay Tella; Today, we announced $110M in Series D funding at a $1.7B valuation to automate the core operating workflows of companies. The round is led by Altimeter and joined by Insight Partners and our existing investors, Battery and Redpoint. We now have over 7,000 customers and our business is three times larger than at the time of our Series C a year ago. In a space as ‘real-world’ as automation, everything we’ve learned that really matters comes from working with our customers and partners. We are incredibly grateful to you! We also still ... Read More