Category

Data Warehouse

Category

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…

Snowflake and Anodot announced a strategic partnership that brings predictive analytics to Snowflake’s enterprise data warehouse. With this integration, customers can discover anomalies in data streams and raise alerts in real-time. Snowflake Computing, a San Mateo-based startup, is one of the first few companies to realize the potential of building a native, cloud-based data warehouse. Founded in 2012, Snowflake exploited the capabilities of the cloud to design a SQL data warehouse from the ground up. Snowflake’s data…

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.…

As technology evolves at a rapid rate – especially technology that incorporates artificial intelligence (AI) capabilities – so too does the potential for bias, disconnect, misuse of data, and the automation of impersonal actions or decisions. With the vast amounts of data collected, stored, and exchanged, capitalist societies risk the commoditization of personal data at the expense of the individual, instead of using personal data to foster valuable individual and societal relationships. In business, AI…

Digital transformations often require real-time business processes driven by data from operational, historical and streaming sources. I’ve noticed that data and analytics leaders often use the terms “data warehouses,” “data lakes” and “data hubs” interchangeably, which can confuse nonspecialists seeking to understand their differences and the roles they play in digitally transformed businesses. Vendors often contribute to this confusion by positioning them as competing approaches, which can lead to deploying the wrong technology for an…