Data Warehousing Articles
The need for data integration has never been more intense than it has been recently. The Internet of Things and its muscular sibling, the Industrial Internet of Things, are now being embraced as a way to better understand the status and working order of products, services, partners, and customers. Mobile technology is ubiquitous, pouring in a treasure trove of geolocation and usage data. Analytics has become the only way to compete, and with it comes a need for terabytes—and gigabytes—worth of data. The organization of 2016, in essence, has become a data machine, with an insatiable appetite for all the data that can be ingested.
Posted April 25, 2016
The core reason for implementing in-memory technology is to improve performance. To help accelerate adoption of in-memory technologies and provide a universal standard for columnar in-memory processing and interchange, the lead developers of 13 major open source big data projects have joined forces to create Apache Arrow, a new top level project within the Apache Software Foundation (ASF).
Posted April 24, 2016
The COLLABORATE 16 conference for Oracle users kicked off with a presentation by Unisphere Research analyst Joe McKendrick who shared insights from a ground-breaking study that examined future trends and technology among 690 members of three major Oracle users groups.
Posted April 20, 2016
To help organizations that are being held back from moving enterprise workloads to a public cloud because of business, legislative, or regulatory requirements that restrict where and how they handle data, Oracle has launched a new set of offerings. Introduced at Oracle CloudWorld in Washington, DC, by Thomas Kurian, president, Oracle, "Oracle Cloud at Customer" enables organizations to get the benefits of Oracle's cloud services but in their own data center.
Posted April 20, 2016
Dataguise, a provider of data security solutions, is making DgSecure available for the detection, monitoring, and protection of sensitive data across Amazon Web Services (AWS) Simple Storage Service (S3) and all Elastic MapReduce (EMR) platforms that use AWS S3.
Posted April 19, 2016
When users require access to multiple databases on multiple servers distributed across different physical locations, database security administration can become quite complicated. The commands must be repeated for each database, and there is no central repository for easily modifying and deleting user security settings on multiple databases simultaneously. At a high level, database security boils down to answering four questions.
Posted April 19, 2016
Sumo Logic, a provider of cloud-native, machine data analytics services, is unveiling a new platform that natively ingests, indexes, and analyzes structured metrics data, and unstructured log data together in real-time.
Posted April 18, 2016
Teradata, the big data analytics and marketing applications company, is making key investments in the Internet of Things (IoT) and the Analytics of Things (AoT), along with updating its signature platforms.
Posted April 18, 2016
Hortonworks is making several key updates to its platform along with furthering its mission as being a leading innovator of open and connected data solutions by enhancing partnerships with Pivotal and expanding upon established integrations with Syncsort.
Posted April 15, 2016
First created as part of a research project at UC Berkeley AMPLab, Spark is an open source project in the big data space, built for sophisticated analytics, speed, and ease of use. It unifies critical data analytics capabilities such as SQL, advanced analytics, and streaming in a single framework. Databricks is a company that was founded by the team that created and continues to lead both the development and training around Apache Spark.
Posted April 14, 2016
Lavastorm is releasing its Accelerators Library solution at no cost to users, offering an array of preconfigured components that make it easier and faster for all Lavastorm users to build analytic applications regardless of technical acumen.
Posted April 14, 2016
OpenText, a provider of enterprise information management (EIM) solutions, is releasing an enhanced version of its namesake platform, addressing key areas of the user experience, machine-to-machine integration, automation, and more.
Posted April 12, 2016
Magnitude Software, a provider of Enterprise Information Management (EIM) software, unveiled a new a master data management offering designed to fuel business processes with accurate customer data for informed decision making.
Posted April 08, 2016
Segment, which provides a customer data hub, has introduced a new platform that will give companies access to new types of cloud services data. The new platform, dubbed "Sources," allows users to now export, sync, and store data from CRM, marketing, and payments platforms and move it into Postgres or Amazon Redshift for analysis.
Posted April 07, 2016
PASS (the Professional Association for SQL Server) is planning its fourth conference focused on business analytics.
Posted April 04, 2016
Databricks, the company behind Apache Spark, is releasing a new set of APIs that will enable enterprises to automate their Spark infrastructure to accelerate the deployment of production data-driven applications.
Posted April 01, 2016
It's become almost a standard career path in Silicon Valley: A talented engineer creates a valuable open source software commodity inside of a larger organization, then leaves that company to create a new startup to commercialize the open source product. Indeed, this is virtually the plot line for the hilarious HBO comedy series, Silicon Valley. Jay Krepes, a well-known engineer at LinkedIn and creator of the NoSQL database system, Voldemort, has such a story.
Posted March 31, 2016
The traditional information engineering approach advocates the placement of as much business logic as possible inside the database management system (DBMS). But, more recently, under the umbrella of service-oriented architecture (SOA), folks are arguing for placement of that business logic in a layer of code outside the DBMS. Occasionally, those who favor locating business logic outside the DBMS have even gone so far as to say that this logic "naturally" belongs in a non-DBMS-supported layer.
Posted March 31, 2016
Microsoft has been on a tear for the past couple of years. It has been pushing forward with a very steady stream of powerful new features and capabilities, even entire product lines, within its Data Platform business. But while Microsoft has been hard at work on this deluge of new technologies, it would be completely forgivable if you haven't noticed. The reason it's OK is that Microsoft is advancing on multiple fronts, both in the on-premises product line and even more dramatically with the Azure cloud-based products.
Posted March 31, 2016
The pervasive corporate mindset to transition all levels of infrastructure to some cloud, somewhere, is accelerating the growth of the cloud industry with a rapidity so far unseen in the history of computing. This phenomenon has resulted in weighty pressure on CIOs to develop and deploy an effective and comprehensive cloud strategy or risk their organization falling behind this undeniable trend. The internet changed the information technology game, but now the cloud constitutes an entirely different league.
Posted March 31, 2016
Teradata has introduced a new "design pattern" approach for data lake deployment. The company says its concept of a data lake pattern leverages IP from its client engagements, as well as services and technology to help organizations more quickly and securely get to successful data lake deployment.
Posted March 28, 2016
The digital economy promises to redefine nearly every aspect of a company's operations—from raw material procurement through post-sale services. Yet, some of the most dramatic changes will be seen in how companies evolve their product portfolios and leverage digital capabilities.
Posted March 25, 2016
The rise of big data technologies in enterprise IT is now seen as an inevitability, but adoption has occurred at a slower pace than expected, according to Joe Caserta, president and CEO of Caserta Concepts, a firm focused on big data strategy consulting and technology implementation. Caserta recently discussed the trends in big data projects, the technologies that offer key advantages now, and why he thinks big data is reaching a turning point.
Posted March 23, 2016
SAP SE's newest in memory query engine, SAP HANA Vora, is now generally available, equipping enterprises with contextual analytics across all data stored in Hadoop, enterprise systems, and other distributed data sources.
Posted March 23, 2016
The Independent Oracle Users Group (IOUG) has represented the voice of Oracle technologists and professionals for more than 20 years, and we are so proud of how our community has not just grown but maintained its adaptive approach that centers on peer-to-peer education and know-how. We hope that you share our sense of pride as we celebrate the technology community's marquee event: COLLABORATE 16-IOUG Forum.
Posted March 23, 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 March 23, 2016
Quest International Users Group supports customers using JD Edwards or PeopleSoft ERP, as well as related Oracle edge applications—products that are important to the success for many companies in today's challenging business environment. At COLLABORATE 16 and throughout the year, Quest is your top resource!
Posted March 21, 2016
The OAUG volunteers planning COLLABORATE 16: Technology and Applications Forum for the Oracle Community (April 10-14 at Mandalay Bay in Las Vegas) are themselves Oracle users and technologists, understanding innately the myriad options and challenges faced by the wider user community in a period of rapid change and transformation. With participation and contributions from all corners of the user community, COLLABORATE offers the information and perspective to make sense of it all.
Posted March 21, 2016
Embarcadero Technologies, provider of database lifecycle management solutions, is enhancing its ER/Studio platform, focusing on better collaboration and communication within enterprises.
Posted March 16, 2016
Available now, Talend says its Integration Cloud Spring '16 release adds enhancements to help IT organizations execute big data and data integration projects running on AWS Redshift or AWS Elastic MapReduce (EMR) with greater ease - using fewer resources, and at a reduced cost.
Posted March 16, 2016
TIBCO Software Inc. is releasing an upgraded version of its TIBCO Spotfire data analytics platform, assisting users in their quest to discover insights quickly.
Posted March 15, 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
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
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
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