Data Warehousing Articles
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
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
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 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
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
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
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
In 2015, big data, mobility, IoT, expanding requirements for security and real-time analytics and the introduction of the Cognitive Era continued to place greater pressure on IT organizations. Linux and open source technologies are at the center of many of the most innovative software and hardware solutions that are addressing emerging enterprise requirements. Here's a look back at some of the most significant announcements in Linux and open source technology of 2015.
Posted December 16, 2015
Looking ahead to 2016 David Jonker, senior director of big data at SAP, offered six key business and technology trends that will take the market by storm, including a continued interest in in-memory processing, enablement of real-time data and analytics, and an increased focus on advanced analytics and machine learning.
Posted December 16, 2015
What's ahead for 2016 in terms of cloud, IoT, big data, analytics, and open source technologies? IT executives gaze into their crystal balls, and weigh in on the upcoming challenges and opportunities ahead in the next year - and beyond.
Posted December 16, 2015
The modern business landscape is a fast-moving, ever-changing, highly competitive environment. For companies to outpace the competition and build upon innovation, they must embrace a modern data architecture. It is necessary that this new architecture support today's new requirements such as mobile integration and advanced digital marketing.
Posted December 02, 2015
It's commonly asserted—and generally accepted—that the era of the "one-size-fits-all" database is over. We expect that enterprises will use a combination of database technologies to meet the distinct needs created by various application architectures.
Posted December 02, 2015
Hadoop distribution provider Cloudera has introduced Cloudera Enterprise 5.5, including Cloudera Navigator Optimizer, a new product targeted at helping organizations improve big data workload performance and efficiency. Cloudera Navigator Optimizer, now in beta, is expected to be generally available in 2016. The new release of Cloudera Enterprise has three main areas of focus, according to Anupam Singh, head of data management at Cloudera.
Posted November 19, 2015
There are many different ways to look at database administration. It can be done by task, by discipline, by DBMS, by server, and so on. But one useful way to look at database administration is in terms of the type of support being delivered to applications. You can paint a broad brush stroke across the duties of the DBA and divide them into two categories: those that support development work and those that support the production systems.
Posted November 09, 2015
Organizations are getting squeezed, said Mark Hurd, Oracle CEO, in his Monday morning keynote at Oracle OpenWorld 2015. They have old infrastructure; there is the need for innovation but also great pressure to do things such as increase security and adhere to governance mandates which are not innovative; and also pressure to keep costs flat, without increasing IT costs. "This is why the cloud is such a big deal," said Hurd, sharing his list of top 5 predictions for 2025.
Posted November 04, 2015
Informatica has introduced a new data management platform designed to handle data at any speed across today's hybrid IT environments, both cloud and on-premise. The new release, Informatica 10, provides enhancements across three core components - Informatica PowerCenter 10, Informatica Data Quality 10 and Informatica Data Integration Hub 10, and offers specific certified optimizations for Oracle Exadata, Oracle SuperCluster, SAP HANA, and HP Vertica.
Posted October 28, 2015
Attunity Ltd., a provider of data management software solutions, has introduced the latest version of its data replication and loading solution. Designed to accelerate enterprise big data analytics initiatives, Attunity Replicate 5.0 automates big data movement to, from and between databases, data warehouses, Hadoop and the cloud, reducing the time and labor, and ultimately the cost of making big data analytics available in real time.
Posted October 26, 2015