Tag: data warehouse

Feed: Cloudera Blog. Author: Bill Zhang. Posted in Business | July 16, 2021 6 min read Did you know Cloudera customers, such as SMG and Geisinger, offloaded their legacy DW environment to Cloudera Data Warehouse (CDW) to take advantage of CDW’s modern architecture and best-in-class performance?  In addition to substantial cost savings upon moving to CDW, Geisinger is also able to search through hundreds of million patient note records in seconds providing better treatment to their patients. CDW customers provided valuable feedback that stored procedures should be supported to accelerate offloading legacy DW environments to CDW. Legacy DWs, often built ... Read More

Feed: Actian. Author: Lewis Carr. Data warehouse vs database should you choose one or the other – or, in some cases, would you need both? Each has a purpose and a value for your organization. Each can be simple or complex; both support organizational decisions. In general, they are complementary.  The question becomes which one do I need based on what outcome the organization is trying to achieve for a given process or project. Knowing the difference can help avoid mistakes that could jeopardize the success of using either technology to support the needs of the business. Be careful not ... Read More

Feed: AWS Big Data Blog. This is the fourth in a series of posts. We’re excited to share dozens of new features to automate your schema conversion; preserve your investment in existing scripts, reports, and applications; accelerate query performance; and potentially reduce your overall cost to migrate to Amazon Redshift. Amazon Redshift is the leading cloud data warehouse. No other data warehouse makes it as easy to gain new insights from your data. With Amazon Redshift, you can query exabytes of data across your data warehouse, operational data stores, and data lake using standard SQL. You can also integrate other ... Read More

Feed: AWS Big Data Blog. This is the third post in a multi-part series. We’re excited to share dozens of new features to automate your schema conversion; preserve your investment in existing scripts, reports, and applications; accelerate query performance; and reduce your overall cost to migrate to Amazon Redshift. Amazon Redshift is the leading cloud data warehouse. No other data warehouse makes it as easy to gain new insights from your data. With Amazon Redshift, you can query exabytes of data across your data warehouse, operational data stores, and data lake using standard SQL. You can also integrate other services ... Read More

Feed: Actian. Author: Pradeep Bhanot. The previous blogs in this series discussed the top 5 pitfalls of traditional operational data warehouses and defined the Operational Data Warehouse (ODW) as a potential solution.  Below is a list of my Top 10 desirable benefits of an effective ODW:Current. Continuous data updates via “micro-batches” or streamed singleton updates throughout the day provide the most current information for analytics-based decision-making. Fast. Changes to ODW data need to be made with the lowest performance penalty. Columnar data blocks that maintain their min-max value metadata eliminate the overhead of creating indexes that need to be updated ... Read More

Feed: Actian. Author: Teresa Wingfield. Part 2: Cloud Service SecurityIn my previous post on modern data warehouse security, we looked at issues related to database security. This post will focus on the separate, but related issue of cloud service security, which is increasingly important since nearly half of all data warehouses are hosted in the cloud.[1] The economics of the cloud, the agility with which you can build out and modify services, and the potential to scale almost infinitely continue to accelerate the adoption of cloud data warehouses. As I did in my database security post, I’ll run through some ... Read More

Feed: Actian. Author: Teresa Wingfield. Database Security: Part 1Did you know that security breaches involving the cloud now surpass breaches involving on-premise infrastructure? According to the Verizon 2021 Data Breach Investigation Report, 73% of cybersecurity incidents involved external cloud assets—compared with 27% only one year ago.[1] Having just joined Actian from a cloud security provider, even I was surprised by this tremendous surge. This new insight has motivated me to review the security requirements for a modern cloud data warehouse. The topic turns out to be broad, so I’m writing this blog in two parts: part 1 focuses on database ... Read More

Feed: SingleStore Blog. Author: . Across industries, nearly every business is in the data business—which creates enormous dependencies on popular data warehouses like Teradata, Snowflake, Google BigQuery and Amazon RedShift. Unfortunately, whether built with ported-over legacy technology or born in the cloud, these data warehouses typically depend on rigid, batch-oriented ETL/ELT technologies to capture, ingest, cleanse and transform data before it is available for analysis and reporting. Sure, these traditional workflows can strong-arm data into a structured format that fits a predefined schema. But they are poorly suited for the data-intensive applications that form the heart and soul of today’s enterprises.  ... Read More

Feed: AWS Big Data Blog. This is the second post in a multi-part series. We’re excited to shared dozens of new features to automate your schema conversion; preserve your investment in existing scripts, reports, and applications; accelerate query performance; and potentially reduce your overall cost to migrate to Amazon Redshift. Check out the first post Accelerate your data warehouse migration to Amazon Redshift – Part 1 to learn more about automated macro conversion, case-insensitive string comparison, case-sensitive identifiers, and other exciting new features. Amazon Redshift is the leading cloud data warehouse. No other data warehouse makes it as easy to ... Read More

Feed: CIO. Author: . CMDB definitionA configuration management database (CMDB) is a data repository that stores information about all hardware and software assets in your IT environment. This critical component of the ITIL framework allows for efficient oversight and management of organizational assets, known as configuration items (CI), and delivers greater insight into how they relate to one other across the company.Assets logged in a CMDB include products, facilities, software, systems, and even key stakeholders in a process. As a centralized log of all the business’ assets, a CMDB can assist in making important business decisions and in running more ... Read More