Data Warehousing Articles
As DBAs, we can get mired in the depths of performance tuning parameters and scripts, sometimes getting lost in all the details. It is a good idea to always have a set of goals and philosophies that you can lean on to keep you focused and working on the appropriate things. That is what I want to talk about in this month's DBA Corner column. Some high-level rules of thumb for achieving your DBMS-related performance goals and maintaining your sanity.
Posted May 05, 2017
Cloudera, which last week began trading on the New York Stock Exchange under the symbol "CLDR," has announced the general availability of the Cloudera Data Science Workbench, a self-service tool for data scientists. The workbench, which was announced in beta at Strata+Hadoop World San Jose 2017, enables fast, easy and secure self-service data science for the enterprise.
Posted May 02, 2017
Cloudera, a provider of a platform for machine learning and advanced analytics built on open source technologies including Hadoop, launched an IPO and is beginning public trading on the New York Stock Exchange under the symbol "CLDR."
Posted April 28, 2017
Blue Medora, a provider of IT operational analytics (ITOA) for enterprise cloud, database and infrastructure management, is expanding its SelectStar SaaS database performance solution to support Microsoft Azure and Azure SQL databases. SelectStar for Azure provides metric-based and deep-dive monitoring for Azure native database workloads, enabling users to see query-level metrics on their Azure SQL databases.
Posted April 27, 2017
Infor, a provider of business applications specialized by industry and built for the cloud, has reached an agreement to acquire Birst, Inc., a pioneer of cloud-native, business intelligence (BI), analytics, and data visualization. Birst provides a platform for sourcing, refining, and presenting standardized data insights at scale to drive business decisions. Terms of the agreement are not being disclosed.
Posted April 26, 2017
NTT DATA is expanding its existing relationship with Oracle to include end-to-end cloud capabilities for Oracle's Healthcare Foundation, a unified healthcare analytics platform. The platform provides data integration and warehousing of "clinical, financial, administrative, and -omics modules" in a cloud solution.
Posted April 25, 2017
Catalogic Software, a provider of software-defined copy data management, has announced the availability of a new version of its flagship software featuring expanded in-place database virtualization technology. Catalogic ECX 2.6 adds application-aware support for InterSystems Caché and Epic Electronic Health Record, SAP HANA, and extends Microsoft SQL Server support to physical hosts.
Posted April 25, 2017
IBM announced first-quarter earnings results, with traditional software and hardware solutions slumping, while next-generation offerings surged. The company's first-quarter cloud revenues increased 33% to $3.5 billion, totaling $14.6 billion for the last 12 months.
Posted April 24, 2017
Syntax Systems, a provider of cloud managed ERP services, has announced the acquisition of Core Services Corp., enabling Syntax to now offer cloud-based ERP services for both Oracle JD Edwards and Enterprise Business Suites throughout North America.
Posted April 20, 2017
While not the most media-hyped technology, databases are certainly one of the most crucial when it comes to our always-online, always-connected society. Databases power not just the applications and websites we use every day, but the businesses that generate revenue and fuel the economy. The internet relies on functioning and well-performing databases to operate.
Posted April 19, 2017
As mobile has pushed deeper into enterprises, there is a growing recognition that it may be possible to run significant parts of businesses from relatively small devices. While mobile devices may not be ready to run entire enterprises, in many cases, they certainly can run more limited functions.
Posted April 18, 2017
Today's enterprise database environments are growing in size and complexity, fueled by rising data volumes and new business demands. Many databases that have been at the heart of existing enterprises to power mission-critical applications are now being positioned to support new Digital Native businesses. As a result, 24x7 high availability is no longer a luxury for select applications; it's a necessity for the bulk of the business—many organizations can no longer afford downtime in their data environments—even for a minute.
Posted April 18, 2017
Fujitsu and Oracle jointly announced the launch of Fujitsu SPARC M12, a new lineup of enterprise servers available worldwide. Featuring Fujitsu's new SPARC64 XII processor, the companies say, the Fujitsu SPARC M12 servers achieve the world's highest per CPU core performance in arithmetic processing, offering improvements for a range of database workloads, from mission-critical systems on premises to big data processing in the cloud.
Posted April 12, 2017
The Oracle Public Cloud Offering has achieved a series of compliance certifications and attestations for for a number of core services.
Posted April 12, 2017
As the Internet of Things (IoT) revolution works its way through marketing hype and seeks its place of valuable contribution within companies and industries, you might pause to wonder how IoT can create opportunities for your company. Yet that assessment is difficult in part because the buzz does not always align with reality. In short, it's no simple task to discern the true potential of IoT today, leaving one to wonder: What is realistic, what difference could IoT make in my company, and how mature are other companies in embracing IoT potential?
Posted April 07, 2017
The concept of data lakes is a great one, but if not done correctly, this treasure trove of information can quickly turn into a black abyss for data analysts and scientists, let alone business users.
Posted April 07, 2017
Cohesity, a provider of hyperconverged secondary storage, is receiving its largest funding to date, raising over $90 million in a Series C round co-led by investors GV (formerly Google Ventures) and Sequoia Capital, to expand sales and marketing to meet explosive customer demand. The investment will accelerate Cohesity's research and development of additional secondary storage use cases beyond data protection, with a special focus on analytics, test/dev, file services and object services.
Posted April 04, 2017
EnterpriseDB (EDB) has released the EDB Postgres Ark Database-as-a-Service (DBaaS) framework to the Amazon Web Services Marketplace (AWS). EDB Postgres Ark enables customizable deployments of Postgres clusters to private and public clouds, such as AWS as well as Red Hat OpenStack.
Posted April 03, 2017
Oracle has announced that Hearst has selected Oracle Cloud to provide its businesses with a common platform to accelerate business growth and global expansion.
Posted March 29, 2017
The Independent Oracle Users Group (IOUG) has represented the voice of data technologists and professionals for more than 20 years, and we are excited about how our community continues to grow and focus on peer-to-peer education and know-how. With that focus we are excited for our premier yearly event: COLLABORATE 17 - IOUG Forum.
Posted March 29, 2017
MicroStrategy is releasing an enhanced version of its signature platform, delivering a new set of APIs that will allow users to connect to almost any data source. MicroStrategy 10.7 also adds integrations with Natural Language Generation (NLG) providers Automated Insights and Narrative Science, letting users add Intelligent Narratives to their dashboards alongside their reports, graphs, and visualizations.
Posted March 27, 2017
COLLABORATE 17: Technology & Applications Forum for the Oracle Community is set for April 2-6 in Las Vegas and, for Oracle users, there is simply nothing like being there. Packed with user-focused education and networking, COLLABORATE creates a welcoming atmosphere where participants can candidly share their ideas, challenges and questions.
Posted March 17, 2017
The rise of big data and the growing popularity of cloud is a combination that presents valuable new opportunities to leverage data with greater efficiency. But organizations also need to be aware of some key differences between on-premise and cloud deployments, says Charles Zedlewski, senior vice president, products, at Cloudera.
Posted March 15, 2017
MapR Technologies has added a small footprint edition of the MapR Converged Data Platform to address the need to capture, process, and analyze data generated by IoT devices close to the source. MapR Edge enables secure local processing, quick aggregation of insights on a global basis, and the ability to push intelligence back to the edge for faster business impact.
Posted March 14, 2017
Infoworks.io, Inc., which provides data warehousing on Hadoop, has closed $15 million in a Series B financing which it will use to scale go-to-market and customer success programs to meet customer demand.
Posted March 14, 2017
Cloudera, which provides an analytics platform built on Hadoop and other open source software, has unveiled the Cloudera Data Science Workbench, a new self-service tool for data science that is based on the company's recent acquisition of Sense.io. The Cloudera Data Science Workbench is currently in beta.
Posted March 14, 2017
Unravel Data, which provides an application performance management (APM) platform designed to simplify DataOps, has unveiled a new set of automated actions for improving big data operations and performance.
Posted March 10, 2017
Teradata is introducing a new platform in the open source space that will deliver unprecedented efficiencies for companies creating data lakes. Teradata is launching Kylo, a data lake management software platform built using the latest open source capabilities such as Apache Hadoop, Apache Spark, and Apache NiFi.
Posted March 09, 2017
GridGain Systems, provider of in-memory computing platform solutions based on Apache Ignite, is releasing GridGain Professional Edition 1.9, improving performance and automated benchmarking. This update version fully supports Apache Ignite 1.9 and introduces Kubernetes support for deploying containerized Ignite clusters, expands support for data manipulation language (DML), and more.
Posted March 09, 2017
The heart of any relational database management system is the system catalog that documents the database objects and system settings being used. The system catalog offers a wealth of information about your DBMS. You can think of it as the knowledge base of every piece of data known to the system. For this reason, it is important that DBAs understand what is in the system catalog, as well as how to access and manipulate the information it contains.
Posted March 02, 2017
OPTO Software, part of iTMS Software Services Pty Ltd., provides manufacturing inventory software, including ERP solutions, to a wide variety of industries. Customers span the fields of manufacturing, mining, civil, fabrication, and engineering as well as distribution, retail and wholesale, construction, and importing and exporting. A key differentiator for iTMS/OPTO is its deep understanding of the nuances of manufacturing. Revelation supports that agility, ensuring that OPTO platform is easily configured.
Posted March 02, 2017
Attunity Ltd., a provider of data integration and big data management software solutions, has introduced Attunity Compose 3.0, a new version of its agile data warehouse automation solution.
Posted March 01, 2017
Kong Yang, head geek at SolarWinds, believes the rise of the mobile workforce and the pressure to implement new technologies means that modern IT professionals must be able to quickly evolve beyond the confines of on-premises and shift into the realm of hybrid IT. Here, Yang reflects on some of the ways that IT professionals can begin that journey.
Posted February 24, 2017
Oracle has expanded the Oracle Cloud Platform's data integration offerings with the launch of Oracle Data Integrator Cloud. The new cloud service is aimed at speeding and simplifying cross-enterprise data integration to support real-time analytics.
Posted February 22, 2017
Are enterprises more or less secure than 5 years ago? That's the big question of the moment, especially with ongoing revelations about state-sponsored hacking, as well as an unending stream of reports about customer and employee data being compromised by even the most seemingly security-conscious organizations. Awareness of data security is running at a fever pitch at the highest levels of government and business organizations. There have been plenty of technology advances, and awareness has grown. Still, the wave of breaches and threats never seems to abate, and likely never will.
Posted February 22, 2017
Looker, which provides a platform for data analytics and exploration, is expanding its international operations with the opening of its new European headquarters in Dublin, Ireland.
Posted February 22, 2017
NoSQL database platform provider Couchbase has updated its product suite to support easier global application deployments, and provide additional security capabilities and greater flexibility of deployment.
Posted February 16, 2017
As businesses realize the importance of big data, adoption is on the rise. But big data is still not in full-scale production everywhere, and many companies say operational challenges hold them back. So what are the operational challenges that big data presents? It's a confluence of three key features of big data.
Posted February 08, 2017
Hortonworks, Inc, a provider of open and connected data platforms, is releasing its Enterprise Data Warehouse (EDW) Optimization Solution, partnering with Syncsort and AtScale to deliver a powerful solution. With the EDW Optimization Solution, customers can extend the value of existing EDW investments and overcome the challenges, risks, and costs of introducing new solutions into legacy infrastructure.
Posted February 07, 2017