Newsletters




Data Warehousing

Hardware and software that support the efficient consolidation of data from multiple sources in a Data Warehouse for Reporting and Analytics include ETL (Extract, Transform, Load), EAI (Enterprise Application Integration), CDC (Change Data Capture), Data Replication, Data Deduplication, Compression, Big Data technologies such as Hadoop and MapReduce, and Data Warehouse Appliances.



Data Warehousing Articles

Analytics and the platforms that support big data are constantly evolving, being shaped by the need to deliver data faster to users and gain effective insights throughout the organization. Hadoop, Spark, Kafka, and the cloud are some of the technologies that can handle the demand the future will bring, according to Kevin Petrie, senior director at Attunity.

Posted March 14, 2016

In a new book titled "Next Generation Databases," Guy Harrison, an executive director of R&D at Dell, shares what every data professional needs to know about the future of databases in a world of NoSQL and big data.

Posted March 08, 2016

Data discovery is changing as result of new data usage patterns and requirements, and is increasingly breaking out on its own as a separate and distinct discipline, according to John O'Brien, principal advisor and CEO, Radiant Advisors, who will present a talk at Data Summit 2016 titled "Enabling Governed Data Discovery in Modern Data Architectures."

Posted March 08, 2016

MapR Technologies has added new features in the MapR Converged Data Platform, including the ability to run stateful, containerized applications. There is a big issue today in that many organizations are limiting Docker to applications that don't require state and don't requirement storage access, said Jack Norris, SVP data and applications, MapR.

Posted March 08, 2016

MySQL is a popular open source database and one of the top relational databases—and with good reason. It is an extremely feature-rich and powerful database platform. With all its positives, however, MySQL has a number of challenges that can limit its ability to perform with the agility and performance businesses increasingly require. Here's a quick look at how to optimize MySQL for your ever-changing environment.

Posted March 03, 2016

The world of IT operations has always had a big data problem. Instrumentation of end users, servers, application components, logs, clickstreams, generated events and incidents, executed notifications and runbooks, CMDBs, Gantt charts—you name it, people in the IT operations area have had to cope with mountains of data. And yet the scope of the problem has been enlarged once again, thanks to industry-wide trends such as bring-your-own-device, the Internet of Things, microservices, cloud-native applications, and social/mobile interaction.

Posted March 03, 2016

Every DBA should take advantage of the mechanisms provided by the DBMS to ensure data integrity. When DBMS-provided methods are used, fewer data integrity problems are likely to be found. Fewer data integrity problems mean higher quality databases and more proficient end users.

Posted March 03, 2016

Microsoft first truly disrupted the ETL marketplace with the introduction of SQL Server Integration Services (SSIS) back with the release of SQL Server 2005. Microsoft has upped the ante yet again by bringing to market powerful ETL features to the cloud via the Azure Data Factory, which enables IT shops to integrate a multitude of data sources, both on-premises and in the cloud, via a workflow (called a "pipeline) that utilizes Hive, Pig, and customized C# programs.

Posted March 03, 2016

To spread the word on the best information management solutions in the marketplace, Database Trends and Applications has launched the 2016 DBTA Readers' Choice Awards, a program in which the winners will be selected by the experts whose opinions count above all others - you. Time is running out so make your nomination now.

Posted March 02, 2016

Attunity Ltd. is releasing an enhanced version of its Attunity Compose platform to eliminate pitfalls in data warehousing and accelerate big data analytics.

Posted March 02, 2016

Embarcadero Technologies, provider of database lifecycle management solutions, is enhancing its ER/Studio platform, focusing on better collaboration and communication within enterprises.

Posted February 24, 2016

The promise of the data lake is an enduring repository of raw data that can be accessed now and in the future for different purposes. To help companies on their journey to the data lake, Information Builders has unveiled the iWay Hadoop Data Manager, a new solution that provides an interface to generate portable, reusable code for data integration tasks in Hadoop.

Posted February 23, 2016

Vormetric, a provider of data security solutions, has introduced new security solutions for the Vormetric Data Security Platform that expand the supported data-at-rest security use cases and simplify the operations of deploying encryption.

Posted February 23, 2016

DBmaestro, a provider of DevOps for database solutions, has released TeamWork version 5.0 which includes a new pipeline builder that enables users to visually describe the database environment and the deployment flow. DBmaestro has also introduced stronger compliance and audit capabilities for the database.

Posted February 17, 2016

Over the last half decade, we've watched SQL purists butt heads with NoSQL upstarts, Hadoop triumphalists clash with Hadump pessimists, database geeks war with application developers, and so on. In the midst of all this warring, we've tried to fit—and, in many cases, to cram—the new into the old, the old into the new, with the result that at one time or another, we've asked the impossible of all of the components in our ever-expanding technology portfolios.

Posted February 16, 2016

Enterprises can't seem to pack enough big data and analytics solutions into their data centers, executive suites, and everywhere else across their organizations. Just about every venture-capital-cash-fueled startup from Silicon Valley to Boston has an analytics component to it. As these firms rapidly gain traction, they are being scarfed up by larger vendors looking to solidify their leadership of the analytics space.

Posted February 16, 2016

Hewlett Packard Enterprise (HPE) has selected RedPoint Data Management platform as the underlying platform for a new HPE Risk Data Aggregation and Reporting (RDAR) integrated solution to support financial institutions' compliance with BDBS 239.

Posted February 16, 2016

The Data Summit 2016 conference schedule of sessions and speakers is now available online. Presented by Database Trends and Applications and Big Data Quarterly, the 2-day event (Tuesday, May 10, and Wednesday, May 11) will bring together IT managers, data architects, application developers, data analysts, project managers, and business managers for a deep dive into the key technologies and strategies for becoming a data-informed business.

Posted February 12, 2016

The Internet of Things holds great promise for everything from better healthcare to decreased traffic accidents and more efficient manufacturing processes. Michael Morton is currently CTO at Dell Boomi, which he joined in 2013 after a career with IBM where he became an IBM Master Inventor and worked directly with Fortune 100 companies. Recently, Morton talked with BDQ about some of the opportunities and challenges and the role that Boomi plays in the emerging IoT market.

Posted February 11, 2016

The ability to stand up and voice your opinion about a solution or technology that will not solve a business problem is critical. At times, choices are made for budgetary reasons, and other times, it may be organizational pressure. But regardless of the reason, as IT professionals, we need to be courageous and do the right thing, whatever that is.

Posted February 10, 2016

Storage requirements are growing by leaps and bounds, and more organizations are turning to cloud computing to manage the load. However, cloud isn't necessarily seen as the best approach to data storage bursting—rather, it's mainly being used for backup and for hosting development and test environments, according to a new survey.

Posted February 10, 2016

Oracle has a new PartnerNetwork (OPN) Cloud Program that is aimed at helping organizations accelerate the growth of their Oracle Cloud business. Providing technical and go-to-market support, Oracle says the new four-tier program will provide Oracle partners with the tools they need to help Oracle customers navigate their transition to the cloud.

Posted February 10, 2016

SolarWinds, a provider of hybrid IT infrastructure management software, is adding improved support for Oracle Database 12c Enterprise Edition in the latest release of SolarWinds Database Performance Analyzer. With the additional support for Oracle Database 12c, the SolarWinds tool now pinpoints efficiency issues and optimizes performance of Oracle pluggable databases in a multitenant environment through tuning, metric visibility and resource correlation to help ensure the availability and speed of business-critical applications.

Posted February 10, 2016

Oracle has introduced a new Big Data Preparation Cloud Service. Despite the increasing talk about the need for companies to become "data-driven," and the perception that people who work with business data spend most of their time on analytics, Oracle contends that in reality many organizations devote much more time and effort on importing, profiling, cleansing, repairing, standardizing, and enriching their data.

Posted February 10, 2016

Looker, provider of a BI platform, has added support for Presto and Spark SQL as well as updates to its support for Impala and Hive.

Posted February 09, 2016

Deep Information Sciences is unveiling a new solution that combines a MySQL-compliant database with cloud- and resource-awareness.

Posted February 04, 2016

The development of a functional and practical quantum computing system has been "pending" for some decades now, but there are some real signs that this technology may become decisive soon. The implications of cryptography are encouraging major government investment - both the U.S. and China, in particular, are heavily investing in quantum computing technology. The arms race to develop functional quantum computing has begun.

Posted February 03, 2016

With Hadoop marking its 10th anniversary this year, Sean Suchter, CEO of Pepperdata, recently reflected on his experience with the platform and speculated on what the next 10 years may bring.

Posted February 03, 2016

Hewlett Packard Enterprise (HPE) has announced the availability of HPE Investigative Analytics, a new software solution to enable financial institutions and other organizations in highly regulated industries to use big data technologies to detect patterns, relationships, behaviors, and anomalies across structured and unstructured data stores. The software is aimed at helping companies reduce risk by proactively preventing fraudulent actions.

Posted February 02, 2016

The business world continues to shortchange a critical step between storing and analyzing the explosion of new data expected over the coming years. A business can quickly move from the old world of siloed, unusable data to a new one where stakeholders around the globe can find information in a few minutes from their local access points. The "findability" of data is particularly important for Global 1000 companies pursuing Industrial Internet-related innovation.

Posted February 02, 2016

Snowflake Computing, a cloud data warehousing company, has formed a technology and go-to-market partnership with Looker, which provides a data exploration and business intelligence platform.

Posted February 01, 2016

Paxata's Winter '15 release allows administrators to deploy the data prep platform in heterogeneous environments including the Hortonworks Data Platform on YARN and with multiple versions of Apache Spark. The latest release also improves the way business analysts find, access, and apply data by delivering additional ease of use capabilities supported by machine learning innovations, and provides enterprise-grade security and a multi-tenant governance model.

Posted January 27, 2016

Data Summit, a comprehensive educational experience designed to guide attendees through the key issues in data management and analysis, is coming to the New York Hilton Midtown. Data Summit also features two co-located events: Hadoop Day and Virtualization Day. In addition, the IOUG will participate in Data Summit again this year presenting a track focused on big data in the cloud and the evolution of the data warehouse.

Posted January 26, 2016

For decades, the enterprise data warehouse (EDW) has been the aspirational analytic system for just about every organization. It has taken many forms throughout the enterprise, but all share the same core concepts of integration/consolidation of data from disparate sources, governing that data to provide reliability and trust, and enabling reporting and analytics. The last few years, however, have been very disruptive to the data management landscape. The "big data" era has introduced new technologies and techniques that provide alternatives to the traditional EDW approach, and in many cases, exceeding its capabilities. Many claim we are now in a post-EDW era and the concept itself is legacy.

Posted January 19, 2016

Rackspace has added three key enhancements spanning data storage, security, and DR to the ObjectRocket offering for MongoDB to address requirements in mission-critical enterprise scenarios. The new capabilities were announced in a blog post by Kyle Hunter, product marketing manager for ObjectRocket solutions at Rackspace. The database market is growing strongly and the biggest growth area is open source databases, according to Chris Lalonde, CEO and co-founder of ObjectRocket.

Posted January 19, 2016

The year 2015 started out with people recognizing that the Hadoop ecosystem is here to stay, and ended as the year in which organizations achieved real success within the Hadoop ecosystem. Today, more projects are popping up within the Hadoop ecosystem that can run both with and without Hadoop. The great thing about this trend is that it lowers the barrier to entry for people to get started with these technologies. More importantly, all of these new technologies work best at large scale within the rest of the Hadoop ecosystem, while Hadoop MapReduce has begun its ride off into the sunset.

Posted January 19, 2016

Join IT practitioners and business stakeholders alike for the third annual Data Summit conference at the New York Hilton, May 9-11, 2016. Discounted pricing is available for a limited time.

Posted January 08, 2016

Data modelers must look at the big picture of an organization's data ecosystem to ensure additions and changes fit in properly. Simultaneously, each data modeler must be focused on the minute details, adhering to naming standards, domain rules, data type practices, still remaining ever vigilant for instilling consistency across everything they do. And while focused on all of the above, their efforts must culminate in a practical model that serves the individual project's requirements while also being implementable, maintainable, and extensible.

Posted January 07, 2016

If you are a working DBA, the actual work you do these days is probably significantly different than it was when you first began work as a DBA. So is the term DBA really accurate any longer? Or has the job grown into something more?

Posted January 07, 2016

Today, the success of many startups hinges upon the ability to gain insights from rapidly growing data. Yet startups and smaller businesses often don't have the resources to hire a full-scale data science team, especially considering the painful data scientist shortage that's making it difficult for even large enterprises to find qualified candidates. Here are three approaches companies can adopt to deal with their big and complex data analytics challenges in 2016.

Posted January 07, 2016

The continual evolution in technology has allowed for more data sources than previously thought possible. The growth of SaaS tools provides many benefits, but there is a downside as well. Bringing these cloud data sources into a coherent system for reporting is perpetually a challenge for IT and business intelligence teams. A recent DBTA roundtable webcast covered the issues of combining different SaaS applications into a cloud based enterprise data and leveraging the simple data pipe. Presenters included with Sarah Maston, solution architect with IBM Cloud Data Services, and Erin Franz, alliances data analyst with Looker.

Posted January 04, 2016

We can expect to see every year within the next 5 years be "The Year of IoT." IoT promises to unlock value and rapidly transform how organizations manage, operationalize, and monetize their assets. With IoT, physical assets become liquid, easily indexed and tracked, enabling identification of idle capacity or over utilization.

Posted December 22, 2015

Pages
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30

Sponsors