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

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 my last column (published in the February e-edition and the March print edition of DBTA), I reviewed the overall coding landscape for SQL Server with special focus on LINQ to SQL, a new technology introduced by Microsoft in late 2008. LINQ to SQL promised to make developers' lives much easier by allowing them to focus on writing programs in their favorite Visual Studio language and letting LINQ to SQL write all the Transact-SQL code. The problem is that LINQ to SQL writes very bad Transact-SQL code.

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

Despite the bleak economic picture, there are bright spots. Sybase reported its best quarter and full year in the company's history, driven by factors such as database license revenues which increased 38% year over year in Q408 and 28% for the full year, ended Dec. 31, 2008. David Jonker, a senior product marketing manager at Sybase focused on market strategy for the Sybase ASE, SQL Anywhere and Mirror Activator product lines, shared some thoughts on the results.

Posted February 24, 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

IBM announced it is teaming up with Amazon Web services to provide software developers with pay-as-you-go access to development and production versions of IBM Information Management database servers, IBM Lotus content management, and IBM WebSphere portal and middleware products, all running on Novell's SUSE Linux on Amazon EC2 (Elastic Cloud Computing).

Posted February 17, 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

Complex Event Processing is only a few years old, but it is rapidly entering the mainstream in a large number of fields that require continuous analysis of large volumes of real-time data.

Posted January 15, 2009

Database administrators are critically important contributors in modern enterprises, ensuring that key infrastructure is performing optimally in support of the organization's goals. Like employees in every department, the best DBAs are constantly seeking to increase the value of their contributions and, correspondingly, to increase their compensation and to advance in their organizations. Increasing knowledge and skills and taking more important responsibilities are time-honored methods for career advancement. Here are 10 concrete suggestions for DBAs looking to get ahead.

Posted January 15, 2009

Enterprise IT departments deal with a conflicting set of priorities and constraints in data centers. The number of IT systems identified as critical to core business processes continues to increase as enterprises seek higher levels of operational efficiency and business growth, and because of increasing awareness about the costs of downtime. IT departments are being required to ensure the continuous operation of a growing number of these critical IT systems. Traditional solutions to these demands typically call for adding more servers to the data center.

Posted January 15, 2009

Netezza, a leader in data warehouse and analytic appliance, has announced its collaboration with Microsoft and the first part of its high-performance data integration strategy for Microsoft Business Intelligence As a result, according to the vendors, Microsoft customers can now take advantage of Netezza's high-speed terascale analytic capabilities and extend the value of their existing Microsoft BI investment, and Netezza customers will now have more choice through tighter integration and technology compatibility with Microsoft's SQL Server 2008.

Posted January 13, 2009

Oracle has announced world record multi-node SPECjAppServer2004 benchmark results for Oracle Fusion Middleware. The combination of Oracle WebLogic Server, a component of Oracle Fusion Middleware, together with Oracle Database 11g on mission-critical HP Integrity server blades running HP-UX 11i v3 delivered the record-breaking results.

Posted January 06, 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

Sponsors