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

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 19, 2014

Oracle has signed an agreement to acquire Front Porch Digital, a Lafayette, Colorado-based provider of content storage management solutions that help companies migrate, manage and monetize large-scale media assets. According to John Fowler, executive vice president of Oracle Systems, Front Porch Digital's capabilities complement Oracle's existing engineered storage solutions.

Posted September 17, 2014

At Oracle OpenWorld 2014, Oracle executives, customers, and partners will participate in keynote presentations that examine how modern technologies such as cloud computing, big data, and engineered systems are having an impact on businesses globally and supporting innovation. The conference runs September 28 through October 2 at San Francisco's Moscone Center.

Posted September 17, 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 17, 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 16, 2014

To help customers to meet demanding data challenges, Embarcadero Technologies has announced a major new XE6 release of its portfolio of database tools, including ER/Studio, DBArtisan and Rapid SQL.

Posted September 16, 2014

Recognizing that it is the startups that need enterprise features and high level support more than anyone else, but are least equipped to pay for it, Aerospike Inc. has announced a startup special to attract new customers to its open source flash optimized, in-memory open source NoSQL database. In addition, Aerospike has also announced a new trade-in program, that allows enterprises to swap out certain existing technology for Aerospike Enterprise Edition, for no cost throughout the duration of their standing software and support licenses.

Posted September 16, 2014

In their many years of existence, in-memory databases and technologies have meant one thing to most observers: running applications and serving up data at lightning-fast speeds. Now, as data increasingly evolves into a strategic enterprise asset, in-memory databases have implications beyond blazing bits and bytes. They are opening new opportunities for business innovation and growth.

Posted September 11, 2014

In the first annual 2014 Readers' Choice Awards, Database Trends and Applications (DBTA) magazine announced that Oracle Enterprise Manager 12c has won two awards for "Best Database Administration Solution" and "Best Database Performance Solution."

Posted September 10, 2014

When should you scale your database? The short answer often is: Don't scale until you have to. It is important to understand—and exhaust—all of your options for improving database performance first. Here is a look at the common options available.

Posted September 10, 2014

"On occasion, the inmates actually do take over the asylum. Similarly, business personnel can be defeated by their IT peers," writes Todd Schraml. Although some might argue that such an unexpected role reversal cannot happen, it may indeed occur when data architects skilled in their craft can identify the options that help achieve the business goals, versus those alternatives that stifle the business goals. "A good data architect must also be a very good business analyst," he notes.

Posted September 10, 2014

Recounting the evolution of IBM's relational database technology DB2, Craig S. Mullins goes back a full 3 decades in his latest column, starting with the wild and woolly 1980s and ending with DB2 10 and 11 for z/OS as the currently supported versions of DB2, which have added important new functionality.

Posted September 10, 2014

Skimming the newspaper on a recent summer morning, Kevin Kline was astounded to read about Russian hackers' success in grabbing 4.5 million records by way of good, ol' fashioned SQL injection attacks. "This is like saying a bunch of robbers rummaged through 450,000 houses because none of the home owners knew about locking doors and windows. It is that serious and that elementary of a mistake," writes Kline, who outlines security steps that all developers should implement.

Posted September 10, 2014

DataStax, a data management company that provides an enterprise distribution of Apache Cassandra, has scored $106 million in Series E financing. With this new round of funding, DataStax says it plans to continue to drive enterprise adoption and innovation in Apache Cassandra, and will further invest in the developer community, which now spans over 80 countries. DataStax also plans to continue its momentum in Europe, Asia and Japan by rapidly growing engineering, sales and marketing teams in those regions.

Posted September 04, 2014

Broadening the range of tools at its disposal to help customers who are grappling with emerging technologies for leveraging unstructured data, Teradata this week announced its acquisition of Think Big Analytics, a consulting and solutions company that is focused exclusively on Hadoop and open source big data solutions.

Posted September 04, 2014

A new integration service from Jitterbit is aimed at SAP customers who find difficulty with integration of their existing solutions to be the biggest obstacle to incorporating new cloud technologies. The new Jitterbit Harmony SAP Connector helps organizations streamline crucial business processes with SAP integration between SAP ECC, CRM, vertical applications, and more than a thousand enterprise endpoints, ranging from legacy on-premise software to new cloud-based solutions.

Posted September 03, 2014

Providing the opportunity to breathe new life into existing Windows applications, Embarcadero Technologies has launched RAD Studio XE7, a complete solution to build connected apps for Windows, Android, iOS, Mac OS X, gadgets, and wearables.

Posted September 02, 2014

Managing business-critical databases is no easy task even for experienced DBAs, so for IT pros who might be new to the role—and likely already wear multiple other hats within their organization—it can be a challenging endeavor to say the least. Here are the 5 key areas that IT pros who have found themselves in the position of accidental DBAs should focus on.

Posted August 27, 2014

Why do tens of thousands of Oracle customers, partners, and consultants descend on Moscone Center in San Francisco for the annual Oracle OpenWorld conference? Despite the proliferation of conferences and online events competing for attention, OpenWorld remains the single, central place for all things Oracle. Here, DBTA presents the annual Who to See @ Oracle OpenWorld special section.

Posted August 27, 2014

With the opportunities and obstacles presented by developments such as big data, cloud, and mobility, the challenges of managing and extracting value from data have never been greater. At the same time, the array of technology options for storing, protecting, integrating, enhancing and analyzing data has exploded. To help add perspective and acknowledge the products and services that have been deemed to provide unique value to customers, DBTA created this new competition. Here are the winners of the 2014 DBTA Readers' Choice Awards.

Posted August 27, 2014

The deluge of big data available for analysis presents great opportunity, but many organizations are having difficulty managing it. This has led to companies not being able to process valuable data, or having to delete sets of data to clear room for the massive amounts of new data.

Posted August 26, 2014

Idera, a provider of application and server management solutions, has updated its SQL Compliance Manager, SQL Diagnostic Manager and SQL Safe Backup products with features that improve ease of use, efficiency and performance for database administrators. Idera has also added new support for Microsoft Hyper-V in SQL Diagnostic Manager so that customers can monitor the performance of physical and virtual server environment across both VMware and Microsoft.

Posted August 26, 2014

Many data integration use cases only require simple transformations—and others don't require any transformations at all. For these scenarios, traditional ETL tools are overly complicated and can't deliver data updates as rapidly as business users need. The priority isn't on the T, but rather on the L—expediting data delivery—so users have fresh, accurate data to make business decisions.

Posted August 19, 2014

Just months after the massive data breaches of the 2013 holiday season, a newly discovered data breach is again shining a spotlight on the need for better enterprise data security and the fact that not enough is being done to secure critical customer data. The most recent headlines involve a Russian crime ring and 1.2 billion user names and passwords as well as at least 500 million email addresses. Against this backdrop, Oracle announced Oracle Key Vault, a software appliance designed to securely manage encryption keys and credential files in the enterprise data center.

Posted August 19, 2014

At the summer 2014 SHARE conference in Pittsburgh, Brian Peterson, who has been president of SHARE for the past two years, spoke about the challenges facing companies today as they deal with emerging IT requirements and the successful approaches for dealing with the mainframe skills shortage. With SHARE's 60th anniversary coming up, Peterson also reflected on the role SHARE has played in the world economy by supporting technology that is critical to industries such as banking, transportation, and manufacturing.

Posted August 18, 2014

Oracle's Exadata Database Machine X4-8 has been enhanced to provide large performance and memory increases compared to the previous generation. Hardware enhancements include 50% more database compute cores, using the Intel Xeon E7 v2 15-core processors, and up to 6TB of memory per compute node for a total of 12TB per rack. The result, says Oracle, is that the Exadata Database Machine X4-8 can consolidate hundreds of databases and can run massive databases entirely in-memory.

Posted August 13, 2014

The Oracle Exastack program is being extended to include the Oracle Big Data Appliance and Oracle Database Appliance, enabling Oracle partners to demonstrate that they have the right infrastructure to manage challenging data environments.

Posted August 13, 2014

The latest release of Oracle Database 12c - 12.1.0.2 - is generally available, and includes the new Database In-Memory technology, an option designed to support faster business decisions by accelerating the performance of Oracle Database applications. According to Andrew Mendelsohn, executive vice president, Oracle Database Server Technologies, the new in-memory option enables customers to gain the competitive advantage of the real-time enterprise "with the flip of a switch."

Posted August 13, 2014

VoltDB, provider of an in-memory NewSQL database, is now participating in the IBM Cloud Marketplace, which combines IBM's capabilities-as-a-service and those of partners and third-party vendors. The vendors say that, according to a recent benchmark, VoltDB running in the SoftLayer cloud delivers faster application performance than Amazon Web Services.

Posted August 12, 2014

A healthy data warehouse environment can self-correct to accomplish the right things. And that self-correction is crucial, for no process is likely to be perfect from the start.

Posted August 05, 2014

If you've ever worked with a packaged product, such as a CRM system, that includes reporting and querying features, then you know how inflexible they are. It can be infuriatingly difficult to get data out of these systems, systems for which you paid big money, without losing sleep, hair, and peace of mind. Enter PowerBI.

Posted August 05, 2014

Programs that read database data can access numerous rows and are therefore susceptible to concurrency problems. To get around this issue, most major RDBMS products support read-through locks, also known as "dirty read" or "uncommitted read," to help overcome concurrency problems. When might you want to consider using dirty reads in your applications?

Posted August 05, 2014

As demand for IT services and data volumes grow, so do the challenges with managing databases. For Oracle's vast and growing network of independent software vendors, value-added resellers, systems integrators, and consultants, these are fast-changing times. With Oracle OpenWorld rapidly approaching, DBTA examines Oracle's current product line-up and evolving ecosystem.

Posted August 05, 2014

Quest International Users Group (Quest) supports JD Edwards, PeopleSoft, Fusion, and many other Oracle edge application customers, and is comprised of 55,000 members in 95 countries. Throughout Oracle OpenWorld 2014, you'll find members of the Quest team speaking at various breakout sessions, hosting SIG meetings and networking with members, Oracle personnel, and other customers. We will be answering questions and sharing information on how our members use and work with their Oracle products.

Posted August 04, 2014

Members of the Independent Oracle Users Group (IOUG), which represents the independent voice of Oracle technology and database professionals, will be out in force at OpenWorld 2014—presenting more than 40 sessions on the topics you want to learn about most.

Posted August 04, 2014

The converging forces of open source, with its rapid crowd-sourced innovation, cloud, with its unlimited capacity and on-demand deployment options, and NoSQL database technologies, with their ability to handle unstructured data, are helping companies address the new challenges and opportunities presented by big data. Here are the winners of the 2014 DBTA Readers' Choice Awards for Best Big Data Solution.

Posted August 04, 2014

Query and reporting solutions are part of a comprehensive business intelligence approach, and increasingly modern query and reporting solutions provide capabilities for self-service reports so users can get answers independently, include visualizations that support better understanding of data, and enable users to easily share insights with others. Here are the winners of the 2014 DBTA Readers' Choice Awards for Best Query and Reporting Solution.

Posted August 04, 2014

Organizations see data as a treasure trove from which they can extract valuable insights. Data mining solutions provide the tools that enable them to view those hidden gems and better address new opportunities and challenges. Here are the winners of the 2014 DBTA Readers' Choice Awards for Best Data Mining Solution.

Posted August 04, 2014

Data replication is used as part of many different enterprise scenarios. Whether companies need to share information as part of their BI and reporting processes, support high availability and disaster recovery, or arrange a no-downtime migration, data replication can help them achieve their goals. Here are the winners of the 2014 DBTA Readers' Choice Awards for Best Data Replication Solution.

Posted August 04, 2014

Data governance is growing in importance along with the recognition of the game-changing potential posed by big data. As more data is amassed within organizations, effective data governance enables them to have confidence in the quality of that data for a variety of tasks as well adhere to security and privacy standards. Here are the winners of the 2014 DBTA Readers' Choice Awards for Best Data Governance Solution.

Posted August 04, 2014

Effective data modeling solutions help organizations construct high quality data models, modify existing structures as well as produce detailed documentation. And today, data modeling solutions also help companies visualize and manage business data across more platforms than ever before and extend that data to users with varying job roles and skill levels across geographies and time zones. Here are the winners of the 2014 DBTA Readers' Choice Awards for Best Data Modeling Solution.

Posted August 04, 2014

Although data is increasingly being viewed as a valuable asset and progress in data security is being made, advancements are not being implemented as quickly or as vigorously as they should, according to a recent Unisphere Research survey of 322 data managers and professionals. Among the salient data points from the study are the fact that close to two-thirds of respondents indicated that the bulk of their resources go toward protecting against network intrusions although they feel a breach at the database layer would cause the greatest harm. An aggressive stance with preventive security measures, the report states, is critical. Here are the winners of the 2014 DBTA Readers' Choice Awards for Best Database Security Solution

Posted August 04, 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

Sponsors