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

Datical, Inc. has emerged from stealth mode and introduced Datical DB which uses a patent-pending, data model approach for automating, simplifying and managing database schema change, configuration and complex dependencies as part of the application release process. The solution provides a graphical user interface and wizards for creating a model of schema from an existing database which can be simultaneously migrated to any environment and database such as Oracle, DB2, MySQL, SQL Server, and Postgres.

Posted October 16, 2013

NuoDB, a provider of distributed database technology, today announced the general availability of NuoDB 'Blackbirds' Release 2.0. NuoDB targeted four key areas for improvement in this release, Seth Proctor, CTO, NuoDB, said in an interview.

Posted October 16, 2013

Clustrix, provider of a scale-out SQL database engineered for the cloud, has been granted two new patents for systems and methods for redistributing and slicing data in relational databases from the United States Patent and Trademark Office. "For years, people have been trying to figure out how to take a relational database and make sure that you can use it across multiple distributed servers and get linear, better performance and that is at essence of what these patents do," said Robin Purohit, CEO, Clustrix in an interview.

Posted October 15, 2013

SolarWinds, a provider of IT management software, has acquired Confio Software, which provides database performance management software. The Boulder, Colorado-based software company was purchased for $103 million in cash. Confio's flagship product, Confio Ignite, improves software development and service delivery for systems based on Microsoft SQL Server, Oracle, IBM DB2, and SAP Sybase databases, running on VMware virtual servers as well as physical servers.

Posted October 15, 2013

A successful DBA must understand application development and the issues involved in programming and design. Here are some things that every DBA must know about application development and the design projects of their organization.

Posted October 09, 2013

To augment its product and service offerings both within and outside of the cloud, TransLattice, a provider of a geographically distributed database management system for enterprise, cloud and hybrid environments, has acquired Red Bank, NJ-based StormDB, Inc. The StormDB database is based on PostgreSQL, and TransLattice expects to incorporate proprietary StormDB capabilities and elements of the open source Postgres-XC into the TransLattice Elastic Database.

Posted October 09, 2013

Percona Server 5.6, based on MySQL 5.6 Community Edition, is now generally available. Percona says the latest version of Percona Server offers all the improvements found in MySQL Community Edition as well as additional features for enhanced scalability, availability, backup, and security features found in the enterprise edition. The free download of Percona Server 5.6 also includes new diagnostics and improved integration with other Percona software.

Posted October 08, 2013

Oracle OpenWorld, the company's annual Oracle event for business decision-makers, IT management, partners and end users, introduced a flurry of new and updated products and technologies. Here, a round-up of some of the major announcements unveiled at the conference.

Posted October 02, 2013

Oracle CEO Larry Ellison made three key announcements in his opening keynote at Oracle OpenWorld, the company's annual conference for customers and partners in San Francisco. Ellison unveiled the Oracle Database In-Memory Option to Oracle Database 12c which he said speeds up query processing by "orders of magnitude," the M6 Big Memory Machine, and the new Oracle Database Backup Logging Recovery Appliance. Explaining Oracle's goals with the new in-memory option, Ellison noted that in the past there have been row-format databases, and column-format databases that are intended to speed up query processing. "We had a better idea. What if we store data in both formats simultaneously?"

Posted October 02, 2013

In a tightly contested match for the three seats up for election on the PASS Board of Directors, members of the Professional Association for SQL Server selected directors for two new regional seats and an open seat for the 2014/2015 term. This year, the PASS Board converted two seats to regional director-at-large seats, designating one for EMEA to bring more international perspective as PASS continues to grow globally and one for the US/Canada. An open director-at-large seat, without regional restrictions, was also up for election.

Posted October 02, 2013

Tokutek, a provider of big data performance solutions, has introduced TokuMX Enterprise Edition with hot backup. This new edition is designed to eliminate backup-related downtime for non-stop big data applications. TokuMX is an open source database and a performance engine for MongoDB. TokuMX delivers support for ACID transactions without any changes to an application, 20x performance improvements and, on the compression side, a 90% reduction in database size. When databases get extremely large, this is a significant money saver, explained Coco Jaenicke, vice president of marketing, Tokutek, in an interview.

Posted October 01, 2013

Revolution Analytics, which provides production-grade analytics software built upon the open source R statistics language, and Teradata, a provider of analytic data solutions, recently announced that as a result of a deepened partnership, Teradata is now offering in-database R Analytics that are fully parallel and scalable. David Smith, Revolution Analytics' vice president of marketing and community, talks about what's ahead for the companies' joint customers.

Posted September 30, 2013

A recent DBTA webcast provided insight on how new technologies are revolutionizing the database world. The webcast, sponsored by Progress Software and TransLattice, is now available on demand. Today's businesses are being challenged on many levels with the demand for access to more data. Data growth which is impacting the size and number or data stores across organizations as well as the variety of data sources and types are factors that are fueling this growth.

Posted September 24, 2013

Featuring a multi-tenant architecture that streamlines the process of consolidating databases onto the cloud and enables organizations to manage many databases as one, Oracle Database 12c is a next-generation database. To avoid confusion, however, here are 10 things that Oracle Database 12c is not.

Posted September 24, 2013

On Thursday, September 19, at 11 am PT / 2 pm ET, DBTA will present a special webcast to provide a deeper understanding of the key technologies that are changing the database world - from NoSQL and NewSQL databases, to in-memory processing and virtualization. Sponsored by Progress Software and TransLattice, the webcast titled, "New Technologies Revolutionizing the Database World," will provide in-depth information about game-changing database technologies.

Posted September 18, 2013

Oracle holds an enviable position in the IT marketplace with a wide array of database systems, development tools, languages, platforms, enterprise applications, and servers. Riding the coattails of this industry giant is a healthy and far-flung ecosystem of software developers, integrators, consultants, and OEMs. These are the partners that will help make or break Oracle's struggle with new forces disrupting the very foundations of IT. And lately, Oracle—long known for its own brand of xenophobia and disdain for direct competitors—has been making a lot of waves by forging new alliances with old foes. This is opening up potentially lucrative new frontiers for business partners at all levels.

Posted September 16, 2013

Database management systems support numerous unique date and time functions - and while the date-related functions are many, they do not go far enough. One date-driven circumstance often encountered has to do with objects having a type of date range that needs to be associated with it. While there are some exceptions, this date range need generally ends up implemented via two distinct date columns—one signaling the "start" and the other designating the "end." Maybe, should the creative juices of DBMS builders' flow, such things as numeric-range-datatypes could be created in addition to a date-range data-type. Who knows where things could end up?

Posted September 11, 2013

Many of the new features coming in SQL Server 2014, now available in Community Technology Preview, are encapsulated within broader and rather intuitive categories. The major categories for new features in SQL Server 2014 are Mission-Critical Performance Enhancements, Business Intelligence Insights, and Hybrid Cloud Enhancements. In addition, one of the interesting knock-on effects of retooling SQL Server to run in the cloud is that the code has tightened up a lot.

Posted September 11, 2013

DBAs need to make many different types of changes to a database over its lifetime. Some will be simple and easy to implement, others much more difficult and complex. It is the DBA's job to understand the best way to implement any type of database change, but often, simple changes become more difficult in the real world. Database change management tools help to make this job easier and is one of the first tools acquired by many organizations when they implement a database of any size.

Posted September 11, 2013

Oracle has introduced its latest ZFS Storage Appliances, the ZS3 Series, aimed at enabling customers to improve operational efficiencies, reduce data center costs, and increase business application performance.

Posted September 11, 2013

Independent Oracle Users Group (IOUG) members will be out in force at OpenWorld 2013 - presenting more than 40 sessions on the topics you want to learn about most. Celebrating its 20th anniversary this year, the IOUG represents the independent voice of Oracle technology and database professionals and allows them to be more productive in their business and careers through context-rich education, sharing best practices, and providing technology direction and networking opportunities.

Posted September 10, 2013

EnterpriseDB, provider of enterprise-class PostgreSQL products and Oracle database compatibility solutions, has formed a partnership with Zmanda, a provider of open source and cloud backup solutions. Through the partnership, Zmanda has created and certified a NetBackup agent for EnterpriseDB's flagship Postgres Plus Advanced Server.

Posted September 10, 2013

The PostgreSQL Global Development Group has announced the release of the open source relational database system PostgreSQL 9.3 which expands PostgreSQL's reliability, availability, as well as its ability to integrate with other databases.

Posted September 10, 2013

Confio Software, which offers the Ignite line of database performance monitoring tools, has secured the Certificate of Networthiness (CoN) from the United States Department of Defense. Confio's CoN applies to all Ignite solutions for Oracle, Microsoft SQL Server, VMware, DB2 and Sybase.

Posted September 10, 2013

Oracle has announced the Oracle executive keynote schedule for Oracle OpenWorld. CEO Larry Ellison leads the keynote lineup with a welcome presentation, "Oracle Database 12c In-Memory Database and M6 Big Memory Machine," on Sunday evening, Sept. 22, at 5 pm. Ellison will also present a second keynote during OpenWorld titled, "The Oracle Cloud Platform: Database as a Service. Java as a Service," on Tuesday, September 24, at 1:30 pm.

Posted September 04, 2013

Raima, a provider of database management system technology for both in-memory database usage and persistent storage devices, has announced the availability of Raima Database Manager (RDM) version 12.0, optimized for embedded, real-time, in memory and mobile applications.

Posted September 03, 2013

SAP AG introduced new high availability and disaster recovery functionality with SAP Sybase Replication Server for SAP Business Suite software running on SAP Sybase Adaptive Server Enterprise (SAP Sybase ASE). "After only a year and a quarter supporting the Business Suite, ASE has already garnered about 2,000 customer installations. This easily provides that near zero-downtime for HA/DR that is non-intrusive to the system using Replication Server as the key enabling technology," said Dan Lahl, vice president, Database Product Marketing, SAP, in an interview.

Posted August 31, 2013

SAP has launched Sybase ASE (Adaptive Server Enterprise) 15.7 service pack 100 (SP100) to provide higher performance and scalability as well as improved monitoring and diagnostic capabilities for very large database environments. "The new release adds features in three areas to drive transactional environments to even more extreme levels. We really see ASE moving increasingly into extreme transactions and to do that we have organized the feature set around the three areas," said Dan Lahl, vice president, Database Product Marketing, SAP, in an interview with 5 Minute Briefing.

Posted August 31, 2013

In the last several articles, I've been describing the benefits of reading and analyzing the benchmarking case studies released by the Transaction Processing Council. I've given you from a broad overview of the TPC benchmarks and shown ways that the vendor-published TPC benchmarks can help you save money and how the vendor-published TPC benchmarks must explain in disclaimers how they tweak their workloads. I have described how to run your own benchmarks and explained how to properly prepare your environment for a benchmark test. Now, it is time to show you where the rubber really hits the road, testing and benchmarking tools that can run highly scalable benchmarking workloads against your database servers.

Posted August 31, 2013

Ramping up for Oracle OpenWorld 2013, Oracle today announced the Oracle executive keynote schedule. Leading the lineup, CEO Larry Ellison will present the welcome keynote, "Oracle Database 12c In-Memory Database and M6 Big Memory Machine," on Sunday evening, Sept. 22, at 5 pm. Oracle OpenWorld 2013 takes place September 22 - September 26, 2013 at Moscone Center in San Francisco.

Posted August 27, 2013

To help developers and administrators better manage their dynamic data environments, Oracle has released MySQL Workbench 6.0. MySQL Workbench is a unified visual tool that provides data modeling, SQL development, and comprehensive administration for server configuration, user administration, and migration. The new release is a major update that addresses over 200 inputs and requests from the community and is intended to make it easier for administrators and developers to design, develop, and manage their MySQL databases.

Posted August 21, 2013

GenieDB has announced the launch of the GenieDB Globally Distributed MySQL-as-a-Service. The DBaaS offering allows organizations to take advantage of GenieDB's automated platform to build web-scale applications that gain the benefits of geographical database distribution, continuous availability during regional outages, and better application response time for globally distributed users.

Posted August 20, 2013

NuoDB has announced the last release of its current product version and a technology preview of some upcoming second-generation features available later in 2013. The preview is contained in the free download of the new NuoDB Starlings Release 1.2. The NewSQL approach is gaining greater acceptance, said Barry Morris, founder and CEO of NuoDB, in an interview. "What people are saying back to us is that they are getting all of the features of NoSQL without throwing SQL or transactions away. And that concept is becoming the popular notion of what NewSQL is."

Posted August 13, 2013

Database Trends and Applications has launched a special "Who to See at Oracle OpenWorld" section online where you can find information on what to expect at this year's conference and premium vendors that offer products and services to serve your needs as an Oracle technology professional.

Posted August 09, 2013

Just about every company with a DBMS has that binder full of corporate and/or IT standards. That one over there in the corner with the cobwebs on it — the one that you only use when you need an excuse to avoid work. Okay, well, maybe it's not quite that bad. Your standards documents could be on the company intranet or some other online mechanism (but chances are there will be virtual cobwebs on your online standards manuals, too).

Posted August 07, 2013

I was recently chatting with a good friend of mine who's very highly placed in the Microsoft SQL Server team. Our conversation was wide ranging and covered a lot of topics, such as internal features and upcoming announcements. (I'm under at least three different NDA's. So don't expect me to give up anything too juicy or gossipy.) For example, we spent quite a while discussing the ton of great new features and improvements just over the horizon with the recent release of SQL Server 2014 CTP1.

Posted August 07, 2013

A former colleague is looking for a database server to embed into an important new factory automation application his company is building. The application will manage data from a large number of sensor readings emanating from each new piece of industrial equipment his company manufactures. These values, such as operating temperature, material thickness, cutting depth, etc., fit into the data category commonly called "SCADA" - supervisory control and data acquisition. Storing, managing and analyzing this SCADA data is a critical enhancement to this colleague's new application. His large customers may have multiple locations worldwide and must be able to view and analyze the readings, both current and historical, from each piece of machinery across their enterprise.

Posted August 07, 2013

Consider a professional baseball game or any other popular professional sporting event. When a fan sits in the upper deck of Dodger Stadium in Los Angeles, or any other sporting arena on earth, the fan is happily distracted from the real world. Ultimately, professional sports constitutes a trillion dollar industry - an industry whose product is on the surface entertainment but when one barely pierces that thin veneer it quickly becomes clear that the more significant product produced is data. A fan sitting in the upper deck does not think of it as such but the data scientist recognizes the innate value of the varied manifestations of the different forms of data being continuously produced. Much of this data is being used now but it will require a true Unified Data Strategy to fully exploit the data as a whole.

Posted August 07, 2013

One of the principles within relational theory is that each entity's row or tuple be uniquely identifiable. This means the defined structure includes some combination of attributes whose populated values serve to identify an individual row within the table/relation. This, or these, attribute(s) are the candidate key(s) for the structure. The candidate key is also known as the primary key, or if a structure has multiple candidate keys, then one of them is designated as the primary key. When building up a logical design, primary keys should be identified by the actual data points in play.

Posted August 06, 2013

Just about every company with a DBMS has that binder full of corporate and/or IT standards. That one over there in the corner with the cobwebs on it - the one that you only use when you need an excuse to avoid work. Okay, well, maybe it's not quite that bad. Your standards documents could be on the company intranet or some other online mechanism (but chances are there will be virtual cobwebs on your online standards manuals, too).

Posted August 05, 2013

NuoDB, provider of a NewSQL database, has announced the beta program for a new tool that facilitates migration from MySQL, Microsoft SQL Server, IBM DB2, PostgreSQL and Oracle RDBMSs. The migration tool is open source and available for free download on the NuoDB DevCenter or on GitHub.

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

Sponsors