Newsletters




Database Management

Relational Database Management Systems (RDBMSs) continue to do the heavy lifting in data management, while newer database management systems are taking on prominent roles as well. NoSQL database systems such as Key-Value, Column Family, Graph, and Document databases, are gaining acceptance due to their ability to handle unstructured and semi-structured data. MultiValue, sometimes called the fifth NoSQL database, is also a well-established database management technology which continues to evolve to address new enterprise requirements.



Database Management Articles

Melissa Data, a provider of global contact data quality and data enrichment solutions, has added global email, global phone verification, and U.S. property data enrichment services to its flagship Data Quality Components for SQL Server Integration Services (SSIS), a suite of custom data cleansing transformation components for Microsoft SSIS.

Posted October 30, 2014

Cloudant, an IBM company, has introduced an on-premises version of Cloudant software that companies can install in their own data centers to run their own DBaaS. According to the company, the addition of Cloudant Local (IBM Cloudant Data Layer Local Edition), provides customers with a strategy for managing application data with any mix of infrastructure and deployment strategy.

Posted October 30, 2014

Percona, which provides enterprise-grade MySQL Support, consulting, training, managed services, and server development service, will be hosting Percona Live 2014 in London from November 3 to 4.

Posted October 29, 2014

VMware has acquired the assets of Continuent. The Continuent team is joining VMware's Hybrid Cloud Business Unit. The acquisition offers "concrete benefits" to Continuent customers, said Robert Hodges, CEO of Continuent.

Posted October 29, 2014

IBM and Microsoft are working together to provide their respective enterprise software on Microsoft Azure and IBM Cloud. As part of the deal, IBM and Microsoft will make key IBM middleware such as WebSphere Liberty, MQ, and DB2 available on Microsoft Azure. In turn, Windows Server and SQL Server will be offered on IBM Cloud.

Posted October 27, 2014

IBM announced that the third quarter of 2014 was a difficult one for the company, buffeted by both economic and technology forces. Net income for the period was down 17% from the same period in 2013, $3.5 billion compared with $4.1 billion. The declines were seen across all of IBM's product lines, including mainframes.

Posted October 27, 2014

At SAP TechEd & d-code, SAP announced new innovations for the latest release of SAP HANA, the fall update of SAP HANA Cloud Platform, and a new SAP API Management technology.

Posted October 22, 2014

SAP SE has announced the SAP Cloud for Planning solution, an enterprise performance management (EPM) solution designed around user experience and built for the cloud. The SAP Cloud for Planning solution will be built natively on SAP HANA Cloud Platform, the in-memory platform-as-a-service (PaaS) from SAP.

Posted October 22, 2014

SAP and BI provider Birst have formed a partnership to provide analytics in the cloud on the SAP HANA Cloud Platform. This collaboration intends to bring together the next-generation cloud platform from SAP with Birst's two-tier data architecture to provide instant access to an organization's data and help eliminate BI wait time.

Posted October 22, 2014

SolarWinds Database Performance Analyzer 9.0 (formerly Confio Ignite) provides database administrators and their IT teams with visibility across the application stack, and now covers storage resources, in addition to database, server, and virtualization resources, to speed identification of application performance bottlenecks and improve end user experience.

Posted October 22, 2014

Oracle Platinum Partner Data Intensity, a provider of Oracle-focused application management and cloud services, has acquired business analytics and database management specialist CLEAR MEASURES. According to Data Intensity, the acquisition will enable it to extend its database technology coverage and remote managed services, as well as enter the analytics and business intelligence services market with proven solutions that are already used in more than 200 customer implementations.

Posted October 22, 2014

At the most fundamental level, consider that at the end of the day NoSQL and SQL are essentially performing the same core task — storing data to a storage medium and providing a safe and efficient way to later retrieve said data. Sounds pretty simple — right? Well, it really is with a little planning and research. Here's a simple checklist of 5 steps to consider as you embark into the world of NoSQL databases.

Posted October 22, 2014

Apache Hadoop has been a great technology for storing large amounts of unstructured data, but to do analysis, users still need to reference data from existing RDBMS based systems. This topic was addressed in "From Oracle to Hadoop: Unlocking Hadoop for Your RDBMS with Apache Sqoop and Other Tools," a session at the Strata + Hadoop World conference, presented by Guy Harrison, executive director of Research and Development at Dell Software, David Robson, principal technologist at Dell Software, and Kathleen Ting, a technical account manager at Cloudera and a co-author of O'Reilly's Apache Sqoop Cookbook.

Posted October 22, 2014

In his presentation at the Strata + Hadoop World conference, titled "Unseating the Giants: How Big Data is Causing Big Problems for Traditional RDBMSs," Monte Zweben, CEO and co-founder of Splice Machine, addressed the topic of scale-up architectures as exemplified by traditional RDBMS technologies versus scale-out architectures, exemplified by SQL on Hadoop, NoSQL and NewSQL solutions.

Posted October 22, 2014

Today, many companies still have most of their transactional data in relational database management systems which support various business-critical applications, from order entry to financials. But in order to maintain processing performance, most companies limit the amount of data stored there, making it less useful for in-depth analysis. One alternative, according to a recent DBTA webcast presented by Bill Brunt, product manager, SharePlex, at Dell, and Unisphere Research analyst Elliot King, is moving the data to Hadoop to allow it to be inexpensively stored and analyzed for new business insight.

Posted October 22, 2014

Microsoft SQL Server 2014 finally went RTM (Released to Manufacturing) at the beginning of this month. Here's a look at the key new features within three major areas of enhancement: Mission-Critical Performance, Business Intelligence, and Hybrid Cloud.

Posted October 22, 2014

Share the tips and best practices you use in your work all the time—the code snippets and favorite queries you keep within easy reach. "Best practices" include acknowledged and sensible ways of carrying out an activity; "tips" illustrate how some activity could be done in a better way or reveal some undocumented or not-so-well-known feature.

Posted October 15, 2014

Oracle's new Zero Data Loss Recovery Appliance, unveiled by Oracle executive chairman and CTO Larry Ellison during his opening keynote, is touted as the world's first and only engineered system designed specifically for Oracle Database protection..

Posted October 15, 2014

DBI Software has introduced pureFeat V6.1 Performance Management Suite for IBM DB2 LUW which adds new capabilities for Stored Procedure Visibility and insight into Current Activity Functions. With Stored Procedure Visibility, DBI is "taking the lid off" the black box, and, with insight into Current Activity Functions, DBI allows users to quickly answer the question, "What's happening right now?" said Scott Hayes, president and founder of DBI Software.

Posted October 13, 2014

It is fair to say that relational theory is the only solid framework for establishing a rational expression of data that falls anywhere inside the boundaries of formal logic. As people continue to laud the "death of relational" by coming up with one or other "new" physical implementations of coding or data engines, from object-oriented, XML, columnar, or anything else one might name, the primary short-coming is that these are physical implementations that avoid having any formalized logic underpinning them.

Posted October 08, 2014

One feature of the big data revolution is the acknowledgement that a single database management system architecture cannot meet all needs. However, the Lambda Architecture provides a useful pattern for combining multiple big data technologies to achieve multiple enterprise objectives. First proposed by Nathan Marz, it attempts to provide a combination of technologies that together can provide the characteristics of a web-scale system that can satisfy requirements for availability, maintainability, and fault-tolerance.

Posted October 08, 2014

The PASS Summit, put on each fall by the Professional Association for SQL Server is the biggest SQL Server specific event in the world and it brings in many thousands of people from around the world. Its secret ingredient is the remarkable sense of comradery and overall friendliness of this professional association.

Posted October 08, 2014

Check constraints are supported in all of the major DBMS products, including DB2, Oracle, and SQL Server. But they are too-often ignored and not implemented in production databases. Properly defined, check constraints can provide enhanced data integrity without requiring procedural logic.

Posted October 08, 2014

Today, as never before, public sector agencies have had to become more proactive and operate more like private sector businesses and are required to maintain an immense amount of data in order to make "just in time" decisions as well as to forecast for the long term. This is where business intelligence (BI) tools come in handy—not only to provide systems that facilitate the collection of data, but more importantly, providing a means to sift through the vast amounts of information for which the public sector is custodian.

Posted October 08, 2014

Organizations have been collecting data for years, but never before has there been such urgency to have it immediately available. The business need is pressing—decision makers need up-to-the-minute situational awareness in a volatile global economy.

Posted October 08, 2014

The managers and professionals who dedicate their careers to fundamental database administration are a shrinking pool. Many are retiring, while others have career aspirations outside of the IT department. The data profession itself is splintering into an array of new specialties and tasks—away from database administration and programming and toward higher-level data science and business consulting tasks.

Posted October 08, 2014

A goal at many organizations is to make the data that matters more broadly accessible to more users in a timely fashion. However, at the same time, enterprise data environments are becoming more complex and costly, running on many platforms, supporting many applications, and handling growing volumes of data. IT is expected to respond quickly to new initiatives that can support the business but as IT environments become more unwieldy, agility is an elusive concept.

Posted October 08, 2014

Oracle CTO Larry Ellison took the stage at the Moscone Center to kick off the Oracle OpenWorld conference on Sunday evening. As he does each year, Ellison outlined major announcements for the week and explained the company's technology vision to set the tone for the conference. Confirming analysts' predictions that 2014 would be the year of the cloud for Oracle, Ellison said 2014 is an inflection point for the company. Ellison's key announcement was Oracle's upgraded platform-as-a-service capability: a fourth generation upward-compatible database.

Posted October 08, 2014

EnterpriseDB, a provider of enterprise-class Postgres products and database compatibility solutions, today introduced Enterprise DB (EDB) Backup and Recovery Tool (BART), a single tool to set up, manage and automate processes for backup and recovery. The new product is intended to replace the series of complex steps and coding that Postgres users have had to deploy in order to ensure databases back up on schedule, and can be rebuilt.

Posted October 07, 2014

Join DBTA for a webcast on Thursday, October 9, to learn about the key use cases, data replication strategies and methods for exploring data more efficiently through Hadoop.

Posted October 06, 2014

"Digital disruption" driven by technology is having an impact on the decisions IT organizations are making, Mark Hurd told the audience at the Moscone Center in his first OpenWorld keynote as Oracle CEO. Hurd described the dramatic impact cloud, exploding data volumes, social, business, consumer sophistication, and mobility are having on IT organizations, and then interviewed executives about the individual challenges faced by each, including Yael Cosset of dunnhumby; Stephen Little of Xerox; Jamie Miller of GE; Filippo Passerini of P&G; Kimberly S. Stevenson of Intel Corporation; and Tim Theriault of Walgreen Co.

Posted September 29, 2014

At Oracle OpenWorld, Continuent, a provider of open source database clustering and replication solutions, announced Continuent Tungsten 3.0, a new solution that combines both advanced clustering and replication technologies to meet the transaction processing and analytic needs of the entire business.

Posted September 29, 2014

At Oracle OpenWorld this week, Attunity is showcasing the next generation of Attunity Maestro, its global-scale information flow management platform, to enable management and monitoring of its updated Attunity Replicate for Oracle.

Posted September 29, 2014

Ron Bodkin founded Think Big Analytics to help organizations gain value from big data. Before that, he was vice president of engineering at Quantcast where he led the data science and engineering teams deploying Hadoop and NoSQL for batch and real-time decision making. In this interview, Bodkin who is CEO of Think Big, now a Teradata company, discusses the challenges organizations face in getting big data projects off the ground and what they need to consider when they embark on projects to leverage data from the Internet of Things and social media.

Posted September 25, 2014

In what is being heralded as an epic change at Oracle, Larry Ellison, the charismatic CEO of Oracle, is stepping down and will be succeeded by Safra Catz and Mark Hurd who will share the CEO position. Despite the widespread pronouncements that this is the end of an era and that Ellison is relinquishing his membership in the exclusive club of rock-star tech leaders that has included Apple's Steve Jobs and Microsoft's Bill Gates, some industry insiders believe that is simply not the case. Ellison, they say, will remain a force to be reckoned with at Oracle.

Posted September 25, 2014

In simpler times, businesses kept their data in one place. That made the data easy to access and control. Today, many large enterprises have a global component to daily business transactions, with customers, partners and employees located around the world. Given the distributed nature of an organization's users and increasing data location regulations, the traditional method of storing data on a central server to support worldwide stakeholders no longer meets business needs.

Posted September 25, 2014

A new survey of data managers and professionals who are subscribers to DBTA finds that, over the next 10 years, about two-fifths of respondents expect to leave the field - with about half of those people retiring and the other half moving on to other jobs in management or self-employment.

Posted September 25, 2014

Oracle made two new announcements around NoSQL. It is extending Oracle Enterprise Manager capabilities to MySQL databases. With this new offering, customers can manage complex deployments of Oracle technologies that include MySQL, either on-premise or in a cloud. In addition, Oracle announced a new development milestone release for MySQL 5.7 which extends performance, scalability, reliability and management capabilities. The company also announced several MySQL product releases and early access features, as well as the availability of MySQL source code on GitHub.com.

Posted September 25, 2014

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
31
32

Sponsors