Database Management Articles
The shortage of skilled talent and data scientists in Western Europe and the U.S. has triggered the question of whether to outsource analytical activities. This need is further amplified by competitive pressure to reduce time to market and lower costs.
Posted May 19, 2015
As the excitement and opportunity provided by big data tools develop, many organizations find their big data initiatives originating outside existing data management policies. As a result, many concepts of formal data governance are either intentionally or unintentionally omitted as these enterprises race to ingest huge new data streams at a feverish pace in the hope of increased insight and new analytic value.
Posted May 19, 2015
Data-driven companies continue to explore data management technologies that better unify operational, analytical, and other disparate or siloed data in a way that offers tangible business value and data management relief.
Posted May 19, 2015
The demand for effective data management is intensifying. At the same time, the database market has expanded into a wide array of solutions—from traditional relational database management systems to alternative databases such as NoSQL, NewSQL, cloud, and in-memory offerings.
Posted May 19, 2015
Data preparation is gaining considerable visibility as a distinct aspect of data management and analytics work.
Posted May 19, 2015
Just when you thought NoSQL meant the end of SQL, think again, and realize why you need to hold on to your relational database administrator like it was 1999. NoSQL has proven to be a resilient next-generation database technology for increasingly common internet-era specialized workloads. Now approaching a decade after its arrival on the scene, NoSQL is moving beyond architectural marvels to practical tools in the software development toolkit and, in that process, unveiling tried-and-true capabilities formerly known to be the scalpels of the enterprise relational database. Let's go back to the future and take a look at how the DBA is becoming as relevant as ever while NoSQL evolves for the enterprise.
Posted May 19, 2015
With the influx of big data solutions and technologies comes a bevy of new problems, according to Data Summit 2015 panelists Miles Kehoe, search evangelist at Avalon Consulting, and Anne Buff, business solutions manager for SAS best practices at the SAS Institute. Kehoe and Buff opened the second day of Data Summit with a keynote discussion focusing on resolving data conundrums.
Posted May 14, 2015
The objects and relationships identified within any database design need to match with the very subjective realities considered true within a given organization. An optimal data model must incorporate the semantics of the business and provide for a structural arrangement supporting the necessary corporate instrumentality. And that model should do so, even if in the details things within the model are contrary to what other organizations may consider to be the nature of their reality.
Posted May 14, 2015
You would have to have been living under a rock for the past few years not to have heard of Bitcoin. Bitcoin is an electronic "crypto" currency which can be used like cash in many web transactions. At time of writing there are about 14 million bitcoins in circulation, trading at approximately $250 for a total value of about $3.5 billion.
Posted May 14, 2015
Every now and then, somebody will raise the age-old question "How can I measure the effectiveness and quality of my DBA staff?" This can be a difficult question to answer. And it almost always hides the actual question that is begging to be asked, which is "How many DBAs do we need?"
Posted May 14, 2015
With all the cheerleading and the steady drumbeat of new features being released to Azure, it's easy to lose track of the many cool and valuable new features released in the on-premises version of SQL Server. One of the crown jewels of SQL Server, the cardinality estimator (CE), underwent a large redesign for SQL Server 2014 to improve performance. Cardinality estimates are an extremely important part of query processing. In a nutshell, cardinality estimates are what the relation engine predicts for the number of rows affected by a given operation, including intermediate row sets like those created by filters, aggregations, joins and spool.
Posted May 14, 2015
RevCon is Revelation Software's conference that covers a wide array of topics on Revelation Software. Revelation Software users' conference this year focused on Revelation Software's flagship product, OpenInsight, and the new capabilities of version 10.0.
Posted May 14, 2015
Capgemini is extending its long-standing strategic partnership with SAP, allowing Capgemini to act as a single point of contact for customers globally, and delivering SAP products and support services through one consolidated framework. By signing a global value-added reseller (VAR) agreement with SAP, Capgemini is among a select group of global SAP partners that are part of the global program, which has specific entry requirements that include global reach, reseller capabilities and revenue targets.
Posted May 12, 2015
Splice Machine is partnering with Talend to enable customers to simplify data integration and streamline data workflows on Hadoop. Through this partnership, organizations building operational data lakes with Splice Machine can augment Talend's data integration technology with its data quality capabilities.
Posted May 12, 2015
IBM today announced a combined package of new servers and storage software and solutions in a move to accelerate the development of hybrid cloud computing. The company also revealed flexible software licensing of its middleware to help clients speed up their adoption of hybrid cloud environments.
Posted May 11, 2015
HP has made multiple contributions to the OpenStack Kilo release, including new converged storage management automation and new flash storage technologies to support flexible, enterprise-class clouds. HP's storage contributions to the OpenStack Kilo release focus on two strategic goals.
Posted May 11, 2015
Teradata has made enhancements to the Teradata Database's hybrid row and column capabilities to provide quicker access to data stored on columnar tables and drive faster query performance. Other relational database management systems store data tables in rows or columns, and each method offers benefits, depending on the application and type of data. However, they have been mutually exclusive. Teradata's new hybrid row and column capabilities allow the best of both worlds.
Posted May 08, 2015
Tableau's cloud analytic solution, Tableau Online, is being upgraded to version 9.0. The new release enables faster performance, and provides additional live database connection support, single sign-on, and other new features designed to help users do more with their data in the cloud. The new update brings a complete redesign of Tableau Online to deliver a faster, more scalable, resilient, and extensible platform with capabilities such as parallel queries, query fusion, vectorization and smarter query caches that will make Tableau Online as much as 10 times faster.
Posted May 07, 2015
Accenture and Oracle have launched a new business group to jointly deliver industry-specific solutions built on the Oracle Cloud, helping clients realize the benefits of the cloud faster and with reduced risk. The new group will bring solutions to market across a range of industries, with an initial focus on the public, financial and hospitality services sectors.
Posted May 06, 2015
Oracle has announced that Oracle SQL Developer version 4.1, Oracle SQL Developer Data Modeler 4.1, and Oracle REST Data Services version 3.0 are now generally available. A common theme across all three new releases is an emphasis on making developers lives easier, said Kris Rice, senior director of database tools, Oracle. "Everything revolves around the data."
Posted May 06, 2015
Oracle has introduced Oracle Secure Global Desktop (SGD) Release 5.2, the latest version of the company's secure remote access solution for cloud-hosted enterprise applications and hosted desktops running on not only Microsoft Windows, but also Linux, Solaris and mainframe servers. SGD allows users to work securely from any device and from any location, while providing administrators controlled access to applications and desktop environments resident in the data center, providing a key benefit to large companies in a BYOD world.
Posted May 06, 2015
When databases are built from a well-designed data model, the resulting structures provide increased value to the organization. The value derived from the data model exhibits itself in the form of minimized redundancy, maximized data integrity, increased stability, better data sharing, increased consistency, more timely access to data, and better usability.
Posted May 06, 2015
Pivotal has made updates to its big data suite that include upgrades to the Pivotal HD enterprise-grade Apache Hadoop distribution, which is now based on the Open Data Platform core, and performance improvements for Pivotal Greenplum Database.
Posted May 05, 2015
BackOffice Associates has unveiled an updated solution that will fully automate data quality maintenance without the level of manual research, validation, or updating previously required for most companies. Dubbed "dspCompose," the new application has been included in Version 6.2 of its Data Stewardship Platform (DSP), and is aimed at reducing the time and money spent resolving thousands of data issues.
Posted May 05, 2015
Deep Information Sciences has closed $8 million in Series A funding. The round brings the total invested in Deep to $18 million. The funding will assist in the growth of the Deep Engine, which break downs the performance, speed and scale limitations of databases to help businesses achieve new insights and opportunities from big data.
Posted May 05, 2015
The Pure Storage FlashArray 400 Series is now certified by SAP as an enterprise storage solution for the SAP HANA platform. The certification enables Pure Storage to participate in SAP's program for SAP HANA tailored data center integration using its certified solution.
Posted May 04, 2015
Cosentry, a provider of IT solutions in the Midwest, has extended its managed cloud to provide expertise in connecting to Microsoft Azure, with a focus on utilizing Azure for SQL Server testing and development, SQL Server backup and SQL Server disaster recovery environments.
Posted May 01, 2015
BackOffice Associates' HiT Software division, a provider of data replication and change data capture solutions for heterogeneous database environments, has announced the release of version 8.5 of its flagship product DBMoto.
Posted April 29, 2015
Embarcadero Technologies, a provider of software solutions for application and database development, has unveiled the new XE7 version of ER/Studio, its flagship data architecture suite.
Posted April 28, 2015
System z revenues - which doubled in the first quarter of 2015 - proved to be one of the few positive line items in IBM's latest spate of downward numbers. Revenues from System z mainframe server products increased 118% compared with the year-ago period. Total delivery of System z computing power, as measured in MIPS (millions of instructions per second), increased 95%.
Posted April 27, 2015
Cloud technology was a dominant focus at COLLABORATE 15, which took place earlier this month, according to Melissa English, president of the Oracle Applications Users Group (OAUG). "What's on top of everybody's mind is cloud strategy," English noted.
Posted April 27, 2015
With new industry-specific cloud data services and developer tools, IBM will expand on that expertise to help clients and partners integrate data from the growing number of IoT and traditional sources. These resources will be made available on an open platform to provide manufacturers with the ability to design and produce a new generation of connected devices that are better optimized for IoT, and to help business leaders across industries create systems that better fuse enterprise and IoT data to inform decision-making.
Posted April 23, 2015
The future will flourish with machines. We've been told this in pop culture for decades, from the helpful robots of the Jetsons, to the infamous Skynet of the Terminator movies, to the omniscient "computer" of Star Trek. Smart, connected devices will be ubiquitous and it's up to us, the humans, to decide what's next. But the Internet of Things (IoT) is about more than devices and data.
Posted April 23, 2015
Many DBAs are now tasked with managing multi-vendor environments, and handling a variety of data types. Increasingly, DBAs are turning to strategies such as database automation to be able to concentrate more on the big picture of moving their enterprises forward.
Posted April 23, 2015
Oracle has released Application Express 5, a new version of the popular tool for development and deployment of professional web-based applications for desktops and mobile devices using only a web browser. With the new release, the first since October 2012, not only did Oracle affect what can be produced but the development environment itself has been improved as well, according to Michael Hichwa, vice president of software development at Oracle, and Joel Kallman, director, software development at Oracle.
Posted April 22, 2015
MySQL has announced MySQL Server 5.7, release candidate 1 (5.7.7), which represents the first major release since the 5.6 GA release 2 years ago. MySQL 5.7 RC 1 adds enhancements in several important areas, which are targeted at both growing with existing customers and their current installed base and demands, as well as trying to enter into new market segments, according to Tomas Ulin, vice president for the MySQL engineering team at Oracle. In particular to broaden its use within enterprise environments, with this release, work has been done in areas such as security, GIS, and query optimization.
Posted April 22, 2015
There are actually many advantages to adopting or subscribing to a cloud-based data services infrastructure. For starters—and this may be the only reason companies need to make the move—there's the simplicity cloud and data as a service can offer. In many ways, cloud and data as a service free enterprises and their data teams from the technical intricacies of deploying systems and solutions.
Posted April 22, 2015
SAP SE has announced an Industry 4.0 implementation project with GEA to address condition monitoring and predictive maintenance. GEA, a supplier for the food processing industry and a wide range of process industries, will work with SAP to optimize the performance of its separator and decanter machinery with the SAP Predictive Maintenance and Service solution, cloud edition. Based on SAP HANA Cloud Platform, the solution aims to bring together technology, sensors, and machine data with business processes, applications, and practices.
Posted April 22, 2015
A new release of the HP Haven Big Data Enterprise and OnDemand Platform incorporates advanced analytics and predictive capabilities for enterprises working with large volumes and varieties of information.
Posted April 22, 2015
SAP has announced it has certified its products on Oracle Database 12c. "More than two-thirds of all SAP customers run their SAP applications on the Oracle Database today. There is a strong overlap," said Sohan DeMel, vice president, Product Strategy and Business Development, Oracle. "These joint customers are looking to leverage Oracle's best database technology."
Posted April 22, 2015
Rocket Software has announced the release of Rocket D3 Linux 10.1, as well as a training course on the fundamentals of U2. The Linux 10.1 release will provide an update to Rocket's MultiValue development environment, while the training course will give users that are new to Rocket's U2 technology a solid foundation to work with going forward.
Posted April 22, 2015
To help organizations answer questions with data spread across disparate analytics systems and data repositories, Teradata has expanded its QueryGrid technologies. "With this announcement we have our foot on the gas pedal," Imad Birouty, director of product marketing, Teradata. "We have seven updates. We are announcing new connectors that are on their way, announcing that we have delivered on the connectors that we previously announced, and we are refreshing previously-released connector versions of the technologies."
Posted April 20, 2015
Unstructured data types and new database management systems are playing an increasing role in the modern data ecosystem, but structured data in relational database management systems (RDBMS) remains the foundation of the information infrastructure in most companies. In fact, structured data still makes up 75% of data under management for more than two-thirds of organizations, with nearly one-third of organizations not yet actively managing unstructured data at all, according to a new survey commissioned by Dell Software and conducted by Unisphere Research, a division of Information Today, Inc.
Posted April 15, 2015
Percona, a company that makes MySQL and OpenStack faster and reliable for customers, is acquiring Tokutek, allowing Percona to design, service, and support remote management for both MySQL and the ACID-compliant NoSQL database. Tokutek is known for delivering big data processing power across two open source data management platforms, MySQL and MongoDB.
Posted April 14, 2015