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

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

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

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

According to a recent survey of 315 data managers and professionals, SLAs are getting more demanding and application owners are struggling to keep pace. Close to one-fourth of the survey respondents have SLAs of four nines of availability or greater, meaning they require less than 52 minutes of downtime per year. Unfortunately, unplanned downtime does occur for many reasons. That's when a trusted backup solution can come to the rescue. Here are the winners of the 2014 DBTA Readers' Choice Awards for Best Database Backup Solution.

Posted August 04, 2014

Today, there are tools that help optimize database performance by quickly identifying performance problems that might impact user experience, correlating response times with other metrics, and helping managers visualize trends and analysis of database performance over specified periods of time. Automated capabilities free up data experts from routine jobs, and allow them to focus their efforts on higher value tasks that will help transform their organizations into dynamic data-driven enterprises. Here are the winners of the 2014 DBTA Readers' Choice Awards for Best Database Performance Solution.

Posted August 04, 2014

Database development solutions provide the necessary support to help database development teams achieve success by avoiding the risks posed by a range of potential problems—from software bugs, to geographically dispersed development teams, to varied code standards and skill sets. Here are the winners of the 2014 DBTA Readers' Choice Awards for Best Database Development Solution.

Posted August 04, 2014

Today, organizations are looking for database administration solutions that can provide assistance with both managing routine day-to-day operations as well as provide alerts and insight when something has gone drastically wrong with mission-critical database applications. Here are the winners of the 2014 DBTA Readers' Choice Awards for Best Database Administration Solution.

Posted August 04, 2014

With modular designs that allow companies to start small and add capacity as needed, the database appliance approach, contend its advocates, allows organizations to bypass the usual hardware upgrade headaches. Along with the often mentioned advantages of fast deployment and the proverbial "one throat to choke" if a problem occurs, database appliances seek to give organizations something they desperately need today: simplicity. Here are the winners of the 2014 DBTA Readers' Choice Awards for Best Database Appliance.

Posted August 04, 2014

To succeed today, organizations need to become analytics-focused enterprises. Like the emerging category of in in-memory database technologies, columnar databases are deployed in market segments where speed of data analysis is paramount, such as financial services, retail, healthcare, and telecommunications. Here are the winners of the 2014 DBTA Readers' Choice Awards for Best Columnar Database.

Posted August 04, 2014

With new and varied sources of data, including unstructured human-generated data from sources such as social media and weblogs, to IoT data coming from sensors, machines and user devices, a radical shift is taking place in the world of business and analytics. Here are the winners of the 2014 DBTA Readers' Choice Awards for Best Analytical Platform (Overall).

Posted August 04, 2014

MultiValue database technology has maintained a strong following of loyal supporters. The technology is rooted in many industry verticals, including retail, travel industry, oil & gas, healthcare, government, banking, and education. Over the years, these systems have become highly customized to support specific business requirements, and so are deeply entrenched in organizations. Here are the winners of the 2014 DBTA Readers' Choice Awards for Best MultiValue Database.

Posted August 04, 2014

A new class of databases called NewSQL has emerged, leveraging the best of NoSQL and SQL. With the ability to ingest large amounts of data quickly and scale to meet growing demand, NewSQL data systems support rapid analytics and decision making, helping organizations leverage their data for business advantage. Here are the winners of the 2014 DBTA Readers' Choice Awards for Best NewSQL Database.

Posted August 04, 2014

Critical to the success of any data management system is the ecosystem surrounding the technology. Because of its longevity, the relational database has a rich, multi-layered and highly evolved support network of applications for security, business intelligence and analytics, data integration, master data management and data quality, from which customers can choose. Here are the winners of the 2014 DBTA Readers' Choice Awards for Best Relational Database.

Posted August 04, 2014

NoSQL, NewSQL, in-memory databases, and cloud database—or database as a service approaches—are increasingly coming to the fore to address a dizzying array of new requirements posed by the massive influx of unstructured,the Internet of Things, and the new demands posed by e-commerce and mobile applications. Here are the winners of the 2014 DBTA Readers' Choice Awards for Best Database (Overall).

Posted August 04, 2014

The consumerization of IT, coupled with online services like social media, creates a need for flexibility and performance improvements within current data centers without the associated costs. And, as the cost of flash declines, data center managers are seeing flash as an attractive alternative to traditional hard-disk methods. By some estimates, flash memory prices have fallen at an average of 35% per year over the last few years.

Posted August 04, 2014

Data protection and recovery software provider Arcserve has begun operations as a standalone company following the completion of the sale of the business from CA to investment firm Marlin Equity Partners.

Posted August 04, 2014

Continuity Software Launches New Channel Partner ProgramContinuity Software, a provider of service availability risk management solutions, has created a new program for channel partners, enabling them to offer the AvailabilityGuard software suite that provides high availability (HA) and disaster recoverability (DR), across physical, virtual and cloud environments.

Posted July 29, 2014

Many database administrators now feel that the best way to preserve database reliability may be to take over the job of backing up their own databases. Just as end users are happier when they can do their own password resets or restore an accidentally deleted file, DBAs want greater control over their backups, restores and recoveries, and also the peace of mind of knowing that it is done to their standards. The key to making this work is integrating database applications with purpose built backup appliances (PBBAs).

Posted July 23, 2014

How do you catch the next big wave - not the wave everyone's already riding, but the one on the horizon? When it comes to big data, the next big wave is in-memory technologies, which accelerate data processing for faster, more accurate decisions.

Posted July 23, 2014

Through a strategic partnership with BOS, Advanced will be providing its customers with tcVISION and tcACCESS from BOS, both of which are used by organizations to leverage the value of mainframe platforms and data. tcVISION is a mainframe data replication and synchronization system and tcACCESS enables the real-time bi-directional exchange of information between IBM mainframes and Linux, Microsoft Windows and UNIX based systems.

Posted July 21, 2014

InfiniDB has released version 4.6 of its fourth generation columnar data platform, which includes enhanced support for large-scale join operations and support for additional data load commands to speed the extraction, transformation, and load (ETL) process. The company also introduced a new 60-day enterprise trial that includes InfiniDB Enterprise Manager, a management console to simplify the administration of InfiniDB, and provide real-time visibility into the performance and availability of users' InfiniDB servers.

Posted July 15, 2014

Oracle today introduced Oracle Big Data SQL, which allows customers to run one SQL query across Hadoop, NoSQL, and Oracle Database, minimizing data movement while overcoming data silos. According to Oracle the new solution helps customers gain a competitive advantage by making it easier to uncover insights faster, and allows them to leverage existing SQL skills while protecting data security and enforcing governance. Oracle Big Data SQL runs on Oracle Big Data Appliance and can work in conjunction with Oracle Exadata Database Machine.

Posted July 15, 2014

To meet emerging challenges in the enterprise fueled by the expansion of cloud, mobile and IoT, Oracle has introduced SOA Suite 12c with simplified integration capabilities. "We are seeing a lot of demand for any-to-any integration," said Amit Zavery, group vice president, Fusion Middleware, Oracle. "We have more than 5,000 customers using SOA Suite today," he said, adding that this release moves the needle even further and allows Oracle to differentiate against the competition more starkly. "The cloud and mobile capabilities will be very useful for customers looking for one, out-of-the-box solution for any kind of integration."

Posted July 09, 2014

Enterprise data growth is coming from unstructured, social media, and machine-generated data. The resulting storage issues are impacting the performance of associated applications and systems. How and where is this data going to be stored—and how can it be made available, on demand, to users and applications that need information right away?

Posted July 08, 2014

IBM DB2 V10.1 introduced Row and Column Access Control (RCAC) as a new feature for securing data within a DB2 table. In Row and Column Access Control, permissions are defined on a table to restrict rows that are exposed. Rows being exposed means that they are available to be returned in the result set, or can be inserted, or can be updated or deleted, with the limitation of the authorities the user has on the table.

Posted July 03, 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