Category

Data Warehouse

Category

The global data lake market was valued at $7.6 billion in 2019 and is expected to grow more than 20.6% from 2020 to 2027. These powerful, cloud-based platforms offer a holistic view of marketing initiatives. They also aid exploration and research by utilizing advanced analytics, artificial intelligence (AI) and machine learning to comb through large amounts of information. But before brands, agencies, and publishers dive in, they need to understand the risks and rewards data lakes inherently bring. …

There are two words that that data industry loves to use today: complexity and simplification. The latter is obviously intended to counter the former… and the ultimate objective is the Holy Grail of Data Nirvana (HGDN) i.e. a so-called ‘single source’ of data where firms can look at every aspect of their business on one software platform. This is the rationale that SAP is currently keeping at front of mind as it develops what it…

Over 25 years ago, the average business was just becoming acquainted with how to effectively capture and store its data. Back then, data was used to help retail companies manage their inventories, enable commercial airlines to effectively maintain their flight schedules, and allow service-oriented businesses to capture and store their customer contact information. The pace was slower, and the information systems used to compute silo data queries were capable of delivering on time and on-premise.…

Over this series of four posts, I explore the keys to a successful data warehouse. Last time, I started with design—a reasonable place to begin! The topic of this post is, build, with operation and maintenance to follow. Even with a beautiful design model in your mind’s eye, the question of how to build the data warehouse raises its ugly head! Ugly, because no matter how lovely the model, implementation is always hobbled by the less…

The organic food and beverage market is expected to hit a mouth-watering $320 billion by 2025—more than four times the value of just a few years ago. For Santiveri, a Spanish company that’s been producing and selling organic products since 1885, that’s validation of its strategy. But it’s also an invitation for ever-rising competition, forcing Santiveri to defend its share against big brands eyeing this surging market. Santiveri sells a huge array of products you can…

As the saying goes, you can’t manage what you don’t measure. In a data-driven organization, the best tools for measuring the performance are business intelligence (BI) and analytics engines, which require data. And that explains why data warehouses continue to play such a crucial role in business. Data warehouses often provide the source of that data, by rolling up and summarizing key information from a variety of sources. Data warehouses, which are themselves relational databases,…

Both the data lake and the data warehouse within the cloud have their benefits. While data lakes consist of unorganised lagoons without categories, they are great for data scientists to analyse different kinds of data at once. The two kinds of data storage also differ in the tools that can be accessed. “In general, for the likes of Redshift, Snowflake, Azure, SQL Data Warehouse, one of the most important things when you talk about a…

Jim Czuprynski, an experienced database architect and published author on database troubleshooting, has spent a month hammering on the Oracle Autonomous Data Warehouse. His insights are worth noting, not only because Oracle Executive Chairman and CTO Larry Ellison has called the new “self-driving” technology one of the “most important things we’ve ever done,” but also because the leap to autonomous computing has many DBAs worried about losing their jobs. Czuprynski’s three-word summary of the new…

Gigamon, a company that provides network traffic intelligence to security tools, that I’ve profiled before, announced the acquisition of ICEBRG, a Seattle-based security startup. Now, I receive press releases about acquisitions and mergers all the time, but I took particular notice of this one because it suggests that a theory of mine is beginning to be born out in reality. Over the past few years, both in my Forbes columns and on my research site,…

Snowflake Computing Inc., a San Mateo-based company, announced the availability of its data warehousing platform on Microsoft Azure. The evolution of the public cloud has disrupted the traditional software industry. During the last decade, almost every mainstream enterprise software platform became available in the cloud. This paradigm shift created new opportunities for the independent software vendors to build born-in-the-cloud applications and platforms that challenge the incumbents. Snowflake Computing is one of the first few…