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

5 Minute Briefing: Data Integration had a chance to visit the COLLABORATE 09 conference for Oracle users in Orlando during the week of May 4. We conducted interviews with both Ian Abramson, the president of the Independent Oracle Users Group (IOUG), and later with Raymond Payne, president of the Oracle Applications Users Group (OAUG).

Posted May 19, 2009

An inherent awkwardness exists in every many-to-many relationship between entities. Ambiguity causes this persistent awkwardness, primarily because a many-to-many relationship is such a fuzzy thing. In data discovery, encountering many-to-many relationships may actually expose a level of disregard about details by the subject matter experts.

Posted May 15, 2009

The economy is a wreck and things will likely get worse before they improve. Unemployment is even worse; almost 600,000 jobs were lost in January 2009, sending the unemployment rate to 7.6%, the highest it has been in 16 years. So many data professionals are out there looking for their next challenge … and more probably will be job hunting before the year is out.

Posted May 15, 2009

Sybase last week reported financial results for the first quarter ended March 31, 2009. Total revenue for the first quarter of 2009 increased to $267.5 million from $260.1 million in the first quarter of 2008. License revenue grew to $89.3 million compared to $78.1 million in the first quarter of 2008. Services revenue was $135.0 million, and messaging revenue was $43.3 million in the 2009 first quarter.

Posted April 28, 2009

EnterpriseDB, an open source database vendor, announced that IBM has licensed its technology to make it easier to deploy applications on DB2 9.7, the upcoming release of IBM's enterprise relational database. The solution is intended to make it easier to migrate applications from Oracle environments into open source or DB2 environments.

Posted April 28, 2009

IBM has announced version 9.7 of DB2 and InfoSphere Warehouse software, focused on transactional performance improvements in the DB2 database, and on expansion of analytics to XML data in the InfoSphere Data Warehouse. Both new products also reduce an even greater amount of space needed to store data, helping clients to gain significant savings on related costs including energy. This offering is also the industry's first database software that will deliver business analytics capabilities for both relational and XML data at the same time, according to IBM.

Posted April 28, 2009

EnterpriseDB, an open source database vendor, announced that IBM has licensed its technology to make it easier to deploy applications on DB2 9.7, the upcoming release of IBM's enterprise relational database. The solution is intended to make it easier to migrate applications from Oracle environments into open source or DB2 environments.

Posted April 27, 2009

Embarcadero Technologies, a database tools and developer software company, has introduced new and enhanced performance optimization tools to help companies detect, fix and prevent costly software errors. The tools include DB Optimizer 1.5 for SQL profiling and tuning, Performance Center for automated 24/7 database monitoring, and J Optimizer 2009 for Java profiling and optimization.

Posted April 23, 2009

Sybase yesterday reported financial results for the first quarter ended March 31, 2009. Total revenue for the first quarter of 2009 increased to $267.5 million from $260.1 million in the first quarter of 2008. License revenue grew to $89.3 million compared to $78.1 million in the first quarter of 2008. Services revenue was $135.0 million, and messaging revenue was $43.3 million in the 2009 first quarter.

Posted April 23, 2009

Bradmark Technologies, Inc., an established provider of enterprise monitoring and database administration tools, announced the release of Surveillance version 4.2 for Sybase Adaptive Server Enterprise (ASE) Cluster Edition. This release bolsters Bradmark's continuing development of its premier monitoring solution for Sybase data management products, enabling customers-including many that manage the world's most critical data-to cost-effectively maintain unprecedented performance and reliability.

Posted April 23, 2009

Visual Expert 6.0 now supports Sybase ASE, MS SQL Server, Oracle and PowerBuilder Code.It provides impact analysis and code exploration for all of these types of code.

Posted April 23, 2009

Sybase, Inc., announced that Sybase IQ 15, combined with Sun Microsystems' Sun Fire X4540 storage server and running the Solaris 10 Operating System (OS), recorded the best price/performance result in the TPC-H benchmark at 3000 GB scale factor for all non-clustered systems. The benchmark simulates decision support systems that analyze large volumes of data, executes queries with a high degree of complexity, and gives answers to critical business questions. Sybase says that the achievement illustrates the effectiveness of Sybase IQ 15 in helping to optimize IT asset utilization and significantly reduce ownership costs.

Posted April 23, 2009

The Independent Oracle Users Group (IOUG) will hold two networking and education events for women in technology at the upcoming annual Oracle users group conference COLLABORATE 09. The Women in Technology Luncheon will take place from 11:45 a.m. to 1 p.m. on Monday, May 4. This will be an opportunity to network, and for Oracle users, male and female, to learn firsthand about the experiences of women working in IT. The luncheon will feature speaker Cindy Novotny, a worldwide training and consulting leader, and the session will cover delegating, time management and taking personal responsibility for your own results.

Posted April 21, 2009

The Oracle Applications Users Group, the world's largest user knowledgebase for Oracle Applications users, is co-hosting COLLABORATE 09: Technology and Applications Forum for the Oracle Community conference with the Independent Oracle Users Group (IOUG) and Quest International Users Group, May 3-7, at the Orange County Convention Center West in Orlando, Fla.

Posted April 21, 2009

Ingres Corporation, a leading open source database management company, has announced that it has joined the Open Source Channel Alliance, a group founded by Red Hat and SYNNEX Corporation to extend the value of open source to a broad set of customers through SYNNEX's 15,000 resellers. Ingres joins as a charter member and has signed a distribution agreement with SYNNEX.

Posted April 21, 2009

Oracle announced yesterday morning that it has entered into an agreement to acquire Sun Microsystems, on the heels of a breakdown of a proposed acquisition by IBM. The transaction is valued at approximately $7.4 billion, or $5.6 billion net of Sun's cash and debt.

Posted April 21, 2009

Oracle announced this morning that it has entered into an agreement to acquire Sun Microsystems, on the heels of a breakdown of a proposed acquisition by IBM. The transaction is valued at approximately $7.4 billion, or $5.6 billion net of Sun's cash and debt.

Posted April 20, 2009

Embarcadero Technologies, a database tools and developer software company, has introduced new and enhanced performance optimization tools to help companies detect, fix and prevent costly software errors. The tools include DB Optimizer 1.5 for SQL profiling and tuning, Performance Center for automated 24/7 database monitoring, and J Optimizer 2009 for Java profiling and optimization.

Posted April 16, 2009

DBI (Database-Brothers, Inc.), a software company providing professional grade database performance management tools, has announced the availability of release 7.1 of Brother-Owl—a tool to capture, analyze, and fix Oracle application SQL and indexes.

Posted April 16, 2009

BEZ Systems, a provider of predictive performance management (PPM) solutions for databases, has announced the availability of a new Performance as a Service (PaaS) program. Performance as a Service combines the BEZVision predictive performance software with in-depth knowledge and advice from database and performance experts to deliver advanced database performance intelligence. This combination allows IT departments to be more proactive in providing service delivery to their organizations, reduce costs, and improve IT efficiency so they can shift their focus toward providing business solutions and away from firefighting performance crises.

Posted April 16, 2009

In a relational database approach, regardless of whether one is considering persisted data or transitory query results, almost everything is viewed as a logical table. Associations between these envisioned tables are based on data values, versus the alternative to the pre-relational idea of linking multiple data structures via "hidden" pointers maintained by the system. Relationships among objects are ultimately derived from the semantics of a situation.

Posted April 15, 2009

Although the most important aspect of DBA tool selection is functionality and the way it satisfies your needs, the stability of the vendor that provides the product is also important

Posted April 15, 2009

The idea of "SQL Server in the cloud" is all the rage as I write this article. Many SQL Server experts already predict the demise of the IT data center and a complete upending of the current state of our industry, in which large enterprises can spend millions of dollars on SQL Server licenses, hardware and staff. I have to admit, when I first heard about this idea, I was ecstatic. What could be better for an enterprise than to have all the goodness of a SQL Server database with none of the hardware or staffing issues? However, on deeper examination, there is much about which to be cautious.

Posted April 15, 2009

Ed Boyajian joined EnterpriseDB, the open source database company whose products and services are based on PostgreSQL, in June, 2008, as president and CEO. Before that, he spent six years in sales leadership roles at Red Hat, including vice president and general manager for North American sales, and vice president, worldwide OEM and North American channels. Recently Boyajian chatted with DBTA about the looming challenges and opportunities for open source in general as well as for EnterpriseDB's Postgres Plus product family.

Posted April 15, 2009

Microsoft has announced that SQL Server 2008 Service Pack 1 is now available via free download to current SQL Server 2008 customers. According to the company, SP1 for SQL Server 2008 is primarily a roll-up of previous cumulative updates and offers increased supportability and stability. Microsoft is encouraging enterprise customers who are currently running SQL Server 2008 to download SP1 via the SQL Server 2008 Web site to take advantage of these improvements.

Posted April 14, 2009

Embarcadero Technologies, a database tools and developer software company, has introduced new and enhanced performance optimization tools to help companies detect, fix and prevent costly software errors. The tools include DB Optimizer 1.5 for SQL profiling and tuning, Performance Center for automated 24/7 database monitoring, and J Optimizer 2009 for Java profiling and optimization.

Posted April 14, 2009

DataDirect Technologies, a provider of data connectivity and mainframe integration, has released a new suite of 32-bit and 64-bit ODBC drivers that offer new enhancements intended to streamline application development, boost performance and reduce application certification costs. The updated suite, DataDirect Connect for ODBC version 6.0, integrates with the DataDirect Bulk Load and DataDirect Application Failover products.

Posted March 31, 2009

Embarcadero Technologies recently held DataRage, three days of online technical sessions and a virtual trade show targeted at DBAs, data architects, database developers, security experts, and other database professionals, and found that the virtual approach was the right one for the times, according Greg Keller, chief evangelist, at the company. The online event was held March 17 through March 19.

Posted March 31, 2009

DataDirect Technologies, a provider of data connectivity and mainframe integration, has released a new suite of 32-bit and 64-bit ODBC drivers that offer new enhancements intended to streamline application development, boost performance and reduce application certification costs. The updated suite, DataDirect Connect for ODBC version 6.0, integrates with the DataDirect Bulk Load and DataDirect Application Failover products.

Posted March 30, 2009

Have you noticed that dynamic SQL is more popular today than ever before? There are a number of factors contributing to the success of dynamic SQL. Commercial off-the-shelf applications, such as SAP, Siebel, and PeopleSoft, utilize dynamic SQL exclusively. In many cases, too, dynamic SQL is the default choice for in-house application development.

Posted March 15, 2009

In formulating the tenets of relational theory, issues anent to order were explicitly addressed. These relational theory tenets included defining a relational database so that it need have no concern with the order of columns in a row, or with the order of rows in a table. And yet, such a stance seems counter-intuitive since the database brings structure and organization to content. Chaos is the primordial soup from which all things originated. Thus it seems only reasonable that a relational database, being the best and brightest of its kind, should abhor such chaos and bring ever more order instead, right?

Posted March 15, 2009

The time is past when the unique attributes of the MultiValue database model alone provided sufficient justification for the use of the technology, according to Pete Loveless. He explains why MV companies must support interoperability and integration from the ground up, in order to meet the challenges presented by the market now, and in the future.

Posted March 15, 2009

OpenTech Systems, Inc., a leading provider of IBM z/OS Disaster Recovery and Storage Management solutions to automate IT processes and ensure business continuity for IBM z/OS-centric data centers, has announced a new release of DR/Xpert for DB2 which automates the backup and recovery for DB2 system objects including the directory and catalog as well as user data.

Posted March 10, 2009

IBM has released new Informix database software to help companies make decisions more intelligently and maximize sales opportunities while reducing expenses. With the new software, known as the Informix Warehouse Feature, global companies can both warehouse their data and conduct fast online transactions with a simplified software platform. The combination of the two capabilities in one offering can help deliver new results and insights to grow businesses and lower costs by making it easier to use existing Informix infrastructures to help clients work more efficiently.

Posted March 10, 2009

Quest Software recently made a joint announcement with Microsoft, indicating that it will offer an Oracle Database Schema Provider for the upcoming release of Microsoft Visual Studio Team System (VSTS) 2010. Quest's new tool provides Oracle support for VSTS, enabling Oracle developers to fully participate with other VSTS team members throughout the entire application lifecycle. Previous to this, Oracle professionals could not benefit from the improvements in communication and workflow that VSTS offers. Oracle development in VSTS was limited, involved time-consuming manual processes, and did not support the system's new offline database development and design paradigm. With Quest's new tool, VSTS can now support both Oracle and SQL Server databases.

Posted March 04, 2009

Quest Software made a joint announcement with Microsoft at the recent VSLive! Conference in San Francisco, indicating that it will offer an Oracle Database Schema Provider for the upcoming release of Microsoft Visual Studio Team System (VSTS) 2010. Quest's new tool provides Oracle support for VSTS, enabling Oracle developers to fully participate with other VSTS team members throughout the entire application lifecycle. Previous to this, Oracle professionals could not benefit from the improvements in communication and workflow that VSTS offers. Oracle development in VSTS was limited, involved time-consuming manual processes, and did not support the system's new offline database development and design paradigm. With Quest's new tool, VSTS can now support both Oracle and SQL Server databases.

Posted March 03, 2009

Embarcadero Technologies plans to hold DataRage, three full days of online technical sessions and a virtual trade show targeted at DBAs, data architects, database developers, security experts, and other database professionals, from March 17 through March 19. "We needed a conference tuned to the massive user base that we have—and beyond," Greg Keller, chief evangelist at Embarcadero, tells 5 Minute Briefing.

Posted March 03, 2009

The Oracle Applications Users Group (OAUG), the world's largest user knowledgebase for Oracle Applications users, announced the 2009 list of associate member organizations participating in the OAUG Star Partner Program.

Posted February 24, 2009

GoldenGate Software Inc., a leading provider of high availability and real-time data integration solutions across heterogeneous enterprise IT environments, held a webinar last week to showcase the results of a joint survey conducted with Unisphere Research, the research arm of Database Trends and Applications (DBTA). The survey results indicated the continued importance of the DBA role within the enterprise IT group. "Surveying the Role of Today's DBA" uncovered the realities faced by many DBAs today, driven by changing database environments and evolving responsibilities, in addition to their top priorities identified for 2009.

Posted February 24, 2009

Quest Software Inc. has announced the newest edition of Spotlight on Oracle, a desktop-based monitoring and diagnostics tool that provides visibility into Oracle database processes and performance. Spotlight exposes current and future performance problems, ensuring that database administrators (DBAs) remain a step ahead of database issues that can negatively impact applications, users, customers, and business operations.

Posted February 19, 2009

GridApp Systems, a leading provider of out-of-the-box database automation software and solutions, has announced the release of GridApp Clarity 5.1, the next-generation version of its database automation software. The two primary new features in Clarity 5.1 are support for databases deployed on cloud computing infrastructures, and management of database license compliance.

Posted February 17, 2009

Embarcadero Technologies Inc., a database tools and developer software company, plans to announce tomorrow Embarcadero All-Access, a software development solution that provides application developers, architects, and database professionals with cost-effective, on-demand access to all the tools they need to design, build, and run software applications and data systems for all of their platforms and programming languages.

Posted February 17, 2009

Alvion Technologies provides a web-enabled platform that allows compilers, resellers and managers of marketing lists to easily deliver their product to end-users in support of targeted marketing efforts. Individual customers submit their data and then Alvion runs customer-specific data transformation and uploads the data to production servers, for access by end-users who are the customers of the data owners. If you need, for example, to find consumers within a 35-mile radius of your business that meet a certain profile, you can go online and find lists within Alvion, put in the criteria you are looking for, and those names will be provided to you, via electronic delivery, be it email or download.

Posted February 15, 2009

Increased governmental oversight has amplified organizational attention concerning the tracking of content changes made to application database tables. Database log reading tools do not always provide the most useful means of reviewing specific changes for all organizational purposes. Fortunately, other reviewing options do exist.

Posted February 15, 2009

The optimizer is the heart and soul of a relational DBMS. It analyzes SQL statements and determines the most efficient access plan for satisfying each statement. The optimizer accomplishes this by parsing the SQL statement to determine which tables and columns must be accessed. It then queries system information and statistics stored in the system catalog and directory to determine the best method of accomplishing the tasks necessary to satisfy the request.

Posted February 15, 2009

Quest Software Inc. has announced the newest edition of Spotlight on Oracle, a desktop-based monitoring and diagnostics tool that provides visibility into Oracle database processes and performance. Spotlight exposes current and future performance problems, ensuring that database administrators (DBAs) remain a step ahead of database issues that can negatively impact applications, users, customers, and business operations.

Posted February 10, 2009

Altova, creator of XMLSpy, the industry-leading XML editor, announced the availability of Version 2009 of the Altova MissionKit, an integrated suite of XML, database, data integration, and UML tools.

Posted February 10, 2009

Occasionally the database under design becomes more than a one-off project. For example, the data mart or data warehouse might act as a profit center for the organization, and as a solution sold to many customers. The possibility exists to capture a basic truth for a given industry in a simple universal design exactly suiting everyone. But unless the situation really qualifies as a valid "one-size-fits-all" circumstance, one needs a level of customization within the architecture.

Posted January 15, 2009

Staffing the DBA organization is not a simple matter. Several non trivial considerations must be addressed, including the size of the DBA staff and the reporting structure for the DBAs.

Posted January 15, 2009

SQL Server has supported VLDBs (very large databases) for some time now. Back in the SQL Server 2000 days, I recall hearing multi-terabyte databases were unusual but doable. Now, they are commonplace, while databases in the hundreds of terabytes inhabit the part of the map that says "there be dragons." While VLDBs are quite common on SQL Server today, highly scalable systems that can be flexibly extended in the same fashion as Oracle/RAC are less so. So, how do you design a highly available architecture for SQL Server if it's not like Oracle/RAC.

Posted January 15, 2009

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
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162

Sponsors