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

Database Trends and Applications introduces the inaugural "DBTA 100," a list of the companies that matter most in data. The past several years have transformed enterprise information management, creating challenges and opportunities for companies seeking to extract value from a sea of data assets. In response to this, established IT vendors as well as legions of newer solution providers have rushed to create the tools to do just that.

Posted June 26, 2013

RainStor, a provider of an enterprise database for managing and analyzing historical data, says it has combined the latest data security technologies in a comprehensive product update that has the potential to rapidly increase adoption of Apache Hadoop for banks, communications providers and government agencies.

Posted June 25, 2013

Dell Software has introduced the latest version of the Dell KACE K1000 Management Appliance, which now includes integrated software asset management to boost software license compliance, while helping lower IT costs. The K1000 adds automated software asset identification, tracking and optimization to its capabilities for managing the deployment, operation and retirement of software assets. The need for the appliance is being fueled by a range of factors, including the influx of new technologies such as cloud computing, virtualization, and BYOD, which are adding complexity in terms of systems management, Lisa Richardson, senior product marketing manager for Endpoint Systems Management, Dell Software, tells 5 Minute Briefing.

Posted June 25, 2013

Oracle announced the general availability of MySQL Cluster 7.3, which adds foreign key support, a new NoSQL JavaScript Connector for node.js, and an auto-installer to make setting up clusters easier. MySQL Cluster is an open source, auto-sharded, real-time, ACID-compliant transactional database with no single point of failure, designed for advanced web, cloud, social and mobile applications. "Foreign key support has been a longstanding feature request from day-one," Tomas Ulin, vice president of MySQL Engineering at Oracle, tells 5 Minute Briefing.

Posted June 19, 2013

Dell has released Toad for Oracle 12.0 which provides developers and DBAs with a key new capability - a seamless connection to the Toad World user community so they will no longer have to exit the tool and open a browser to gain access to the community. "The actual strength of the product has always been the input of users," John Whittaker, senior director of marketing for the Information Management Group at Dell Software, tells 5 Minute Briefing. The new ability to access the Toad World community from within Toad enables database professionals to browse, search, ask questions and start discussions directly in the Toad forums, all while using Toad.

Posted June 19, 2013

These are heady times for data products vendors and their enterprise customers. When business leaders talk about success these days, they often are alluding to a new-found appreciation for their data environments. It can even be said that the tech vendors that are making the biggest difference in today's business world are no longer software companies at all; rather, they are "data" companies, with all that implies. Enterprises are reaching out to vendors for help in navigating through the fast-moving, and often unforgiving, digital realm. The data vendors that are leading their respective markets are those that know how to provide the tools, techniques, and hand-holding needed to manage and sift through gigabytes', terabytes', and petabytes' worth of data to extract tiny but valuable nuggets of information to guide business leaders as to what they should do next.

Posted June 19, 2013

The grain of a fact table is derived by the dimensions with which the fact is associated. For example, should a fact have associations with a Day dimension, a Location dimension, a Customer dimension, and a Product dimension, then the usual assumption would be for the fact to be described as being at a "by Day," "by Location," "by Customer," "by Product" metrics level. Evidence of this specific level of granularity for the fact table is seen by the primary key of the fact being the composite of the Day dimension key, Location dimension key, Customer dimension key, and Product dimension key. However, this granularity and these relationships are easily disrupted.

Posted June 13, 2013

Although storage management can be an afterthought for the DBA, it really shouldn't be. Storage issues are vitally important and unless managed appropriately, it can be very costly. The cost of managing storage can be as much as 10 times higher than the initial cost of acquiring the storage—and the growth rate for disk storage was 37% between 1996 and 2007. Even so, it is common for storage-related issues to be relegated to the backburner by DBAs, but every database professional should understand modern storage basics.

Posted June 13, 2013

At the recent Oracle users conference COLLABORATE 13, IOUG hosted an evening hands-on lab for attendees. The turnout was great—even after a full day of conference sessions. What topic drew such a dedicated crowd? Two words: Performance Tuning.

Posted June 13, 2013

There is an emerging field of companies looking to take on the challenges presented by the roiling tide of big data. While their visions vary, each has identified a market need that it believes its technology uniquely addresses. Here, DBTA highlights the approaches of 10 companies we think are worth watching.

Posted June 13, 2013

Mike Ruane, president and CEO of Revelation Software will demonstrate O4W (OpenInsight for Web) Mobile at user group meetings and conferences across the country and the U.K. this summer and early fall. In the presentations, Ruane's team will show attendees how easy it is to build a mobile application with Revelation's software by actually allowing them to build a mobile pizza-ordering application, Robert Catalano, director of sales at Revelation, tells DBTA.

Posted June 13, 2013

Trillium Software, a provider of enterprise data quality software and services, and Collibra, a provider of data governance software, have formed an alliance to address the demand for data governance initiatives and enable customers to leverage data as a strategic asset.

Posted June 04, 2013

As a leader in the data modeling space, CA ERwin is privileged to be an integral part of organizations' key strategic initiatives such as business intelligence and analytics, data governance, or data quality—many of which revolve around data. At CA Technologies, we understand that data runs your business, and we've put a strong focus on developing a solution that can act as an "information hub" for these initiatives.

Posted June 03, 2013

Percona makes MySQL faster and more reliable for nearly 2,000 customers worldwide. Founded in 2006 to provide MySQL Consulting services, we've grown rapidly with the addition of MySQL Support, Remote DBA, Training, and Server Development services. Our global workforce of nearly 100 now provides 24x7, worldwide coverage to our customer base of leading MySQL users.

Posted June 03, 2013

For close to 30 years, I have been actively involved with the database community. From one of the first Oracle Database Administrators, to President of the Independent Oracle Users Group; from one of the Founders of the Professional Association of SQL Server, to one of the original Oracle*Press authors; from Oracle ACE to VMware vExpert for database virtualization, I have seen an amazing succession of changes take place in our industry.

Posted June 03, 2013

Embarcadero Technologies gives 97% of the world's top 2000 companies the tools needed to address the biggest challenges in data management. Facing significant growth in complexity, diversity and volume of enterprise data, companies worldwide are increasingly turning to data governance as a strategic solution. Helping our customers manage this complexity, and close the "governance gap" has been a major driver of innovation in our products.

Posted June 03, 2013

Scott Hayes is an IBM DB2 LUW Performance Expert, IBM DB2 GOLD Consultant, IBM Information Management Champion, US patent inventor, published author, blogger on DB2 LUW performance topics, and popular frequent speaker at IBM IOD and IDUG Conferences. He started DBI Software in July 2005 with one simple mission: "Help People!" Eight years later, this simple mission is still DBI's #1 core value, though Mr. Hayes admits, "We are better at helping people with DB2 than their marriages or cars."

Posted June 03, 2013

The business world depends on data. Continuent's Tungsten software offers a database-as-a-service that gives cost-effective MySQL databases the enterprise-class clustering and replication required by business-critical applications. Continuent Tungsten provides 24x7 data availability, performance scaling, and simple management without risky application changes or database upgrades. Continuent Tungsten operates at a fraction of the cost of commercial DBMS servers like Oracle and MS SQL Server.

Posted June 03, 2013

Clustrix is the leading scale-out SQL database engineered for the cloud. The combination of big data and cloud computing has broken the legacy database, creating an industry transition to new scale-out database platforms. Clustrix has delivered on a complete reinvention of the relational database, and the result is a highly differentiated platform that is ideal for the industry transition to cloud computing.

Posted June 03, 2013

Over the past year it has been great to see the "Big Data" moniker lose some of its glamour as a catch-all phrase. Fortunately, Hadoop's role is now well understood for processing massive amount of old data for analytics for use cases, which are not sensitive to latency. But, increasing numbers of companies are building new applications that are driving real competitive advantage and disrupting established markets—on the Web, over mobile, or in the Cloud—generating massive amounts of "Big Data." In these new cases, latency matters.

Posted June 03, 2013

NuoDB, Inc., a provider of a cloud data management system offering SQL compliance and guaranteed ACID transactions, has introduced the NuoDB Starlings Release 1.1. Following on from its 1.0 release in January, NuoDB's Starlings Release 1.1 focuses on overall usability in three key areas, Seth Proctor, NuoDB chief architect, tells DBTA. The enhancements focus on greater Microsoft Windows support, general performance and stability, and an improved development and management experience in the web console, says Proctor.

Posted May 23, 2013

Cloudant, a provider of a globally distributed database-as-a-service (DBaaS), has announced $12 million in series B funding from Devonshire Investors, the private equity firm affiliated with Fidelity Investments; RackspaceHosting, the open cloud leader; and Toba Capital. The company also announced that current investors — Avalon Ventures, In-Q-Tel, Samsung Venture Investment Corporation — purchased additional shares. The funding will be used to support Cloudant's global expansion and grow the company's support, service, and go-to-market strategies.

Posted May 21, 2013

Key findings from a new study, "Big Data Opportunities," will be presented at Big Data Boot Camp at the Hilton New York. Big Data Boot Camp will kick off at 9 am on Tuesday, May 21, with a keynote from John O'Brien, founder and principal of Radiant Advisors, on the dynamics and current issues being faced in today's big data analytic implementations. Directly after the opening address, David Jonker, senior director of Big Data Marketing, SAP, will showcase the results of the new big data survey, which revealed a variety of practical approaches that organizations are adopting to manage and capitalize on big data. The study was conducted by Unisphere Research, a division of Information Today, Inc., and sponsored by SAP.

Posted May 16, 2013

Data is not sedentary. Once data has been created, organizations tend to move it around to support many different purposes—different applications, different geographies, different users, different computing environments, and different DBMSs. Data is copied and transformed and cleansed and duplicated and stored many times throughout the organization. Different copies of the same data are used to support transaction processing and analysis; test, quality assurance, and operational systems; day-to-day operations and reporting; data warehouses, data marts, and data mining; and distributed databases. Controlling this vast sea of data falls on the DBA who uses many techniques and technologies to facilitate data movement and distribution.

Posted May 09, 2013

When you decide to undertake your own benchmarking project, it's a strongly recommended best practice to write up a benchmarking plan. A benchmark must produce results that are both reliable and repeatable so that we can foster conclusions that are predictable and actionable. Keeping the "reliable and repeatable" mantra in mind necessitates a few extra steps.

Posted May 09, 2013

Cloud computing has become a mainstream business technology strategy that is delivering the agility and flexibility that businesses need to move forward. To meet the requirements cloud brings to enterprises, new breeds of databases are emerging—either running in the cloud, or designed to optimize enterprise cloud computing.

Posted May 07, 2013

Confio Software released version 8.3 of its Ignite database performance monitoring software at COLLABORATE 13 this week. Ignite 8.3 enhancements were developed specifically to address the needs of DBAs with very large database deployments spread out geographically as well as enterprise-level requirements for security and compliance, Don Bergal, chief marketing officer of Confio, tells DBTA.

Posted April 25, 2013

Memory-based storage system provider Violin Memory Inc. and SAP AG have announced that Violin 6000 Series Flash Memory Arrays are now certified for interoperability with SAP Sybase Adaptive Server Enterprise (SAP Sybase ASE), providing reliability and increased performance across a range of enterprise applications. Together, these solutions will provide enhanced and simplified solutions that leverage the power of Violin Flash Memory Arrays and business-critical SAP applications to accelerate transaction-driven environments.

Posted April 24, 2013

Continuent, Inc., a provider of clustering and replication solutions , has announced the availability of completely open-sourced Tungsten Replicator 2.1. This release includes previously closed-source capabilities to extract data in real time from Oracle EE and SE servers, including RAC.

Posted April 22, 2013

"Big data" and the impact of analytics on large quantities of data is a persistent meme in today's Information Technology market. One of the big questions looming in IT departments about big data is what, exactly, does it mean in terms of management and administration. Will traditional data management concepts such as data modeling, database administration, data quality, data governance, and data stewardship apply in the new age of big data? According to analysts at Wikibon, big data refers to datasets whose size, type and speed of creation make it impractical to process and analyze with traditional tools . So, given that definition, it would seem that traditional concepts are at the very least "impractical," right?

Posted April 10, 2013

Oracle announced the availability of the Oracle Big Data Appliance X3-2 Starter Rack and Oracle Big Data Appliance X3-2 In-Rack Expansion. The new Oracle Big Data Appliance X3-2 Starter Rack is intended to help customers jump start their first big data projects and the new Oracle Big Data Appliance X3-2 In-Rack Expansion is aimed at helping them cost-effectively scale the system as their data grows. In addition, the Oracle Big Data Appliance X3-2 (Full Rack configuration) is now available through Oracle Infrastructure as a Service.

Posted April 10, 2013

GenieDB, a provider of distributed relational database technology, has announced the availability of its "Worldwide Database" in the Rackspace Cloud Tools Marketplace. GenieDB works alongside standard MySQL to provide a cloud-enabled platform, distributed across multiple geographies and clouds, and delivering high availability and local performance levels to users anywhere in the world.

Posted April 09, 2013

New technologies designed to help companies and governments tackle big data have been unveiled by IBM. The new technologies include the new IBM PureData System for Hadoop, designed to make it easier and faster to deploy Hadoop in the enterprise, and "BLU Acceleration," which is aimed at improving analytical performance in data management systems.

Posted April 05, 2013

Oracle CEO Larry Ellison announced a complete refresh of Oracle's midrange and high-end SPARC server lines. Unveiled during a live webcast, the new SPARC T5 and M5 servers join the SPARC T4 servers to complete Oracle's SPARC family, spanning entry-level, midrange and high-end.

Posted April 02, 2013

The Independent Oracle Users Group (IOUG) will celebrate its 20th anniversary at COLLABORATE 13, a conference on Oracle technology presented jointly by the IOUG, OAUG (Oracle Applications User Group) and the Quest International User Group. The event will be held April 7 to 11 at the Colorado Convention Center in Denver. As part of the conference, the IOUG will host the COLLABORATE 13-IOUG Forum with nearly 1,000 sessions providing user-driven content. The theme of this year's COLLABORATE 13-IOUG Forum is "Elevate - take control of your career and elevate your Oracle ecosystem knowledge and expertise," says IOUG president John Matelski.

Posted March 27, 2013

Embarcadero Technologies, a provider of software solutions for application and database development, has introduced DB PowerStudio XE3.5, the latest release of the company's database management and development platform. DB PowerStudio XE3.5 is a key component of Embarcadero's new metadata governance platform, which allows organizations to leverage diverse data across information management and the software development lifecycle for data governance initiatives.

Posted March 27, 2013

Two big questions are on the minds of data professionals these days. How are increasing complexity and the inevitable onslaught of big data shaping the future of database administrators and data architects? How will our roles change? In the interest of studying the evolving landscape of data, the Independent Oracle User's Group (IOUG) took the pulse of the community. The Big Data Skills for Success study polled numerous individuals in the IOUG Oracle technology community, to identify just how the responsibilities of handling data are changing and what the future of these roles looks like.

Posted March 27, 2013

When data professionals think about regulatory compliance we tend to consider only data in our production databases. After all, it is this data that runs our business and that must be protected. So we work to implement database auditing to know who did what to which data when; or we tackle database security and data protection initiatives to protect our data from prying eyes; or we focus on improving data quality to ensure the accuracy of our processes.

Posted March 27, 2013

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
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84

Sponsors