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

These days, many companies recognize that there are severe repercussions to ignoring or undervaluing data security, and a sizable segment of organizations-at least one-third in many cases-have been taking additional measures to bolster their data security.

Posted November 30, 2010

There comes a point in technology evolution when the question of adoption moves from "why implement" to "when to implement." Typically, we reach this inflection point when technology has developed sufficient functionality to represent a mature solution. In data virtualization, we have recently reached this inflection point of "When data virtualization?" Its functionality has matured to a fitness for both project-level and enterprise-scale implementations in a variety of use cases.

Posted November 30, 2010

As Revelation Software completes its internal testing of OpenInsight 9.2.1, the company is inviting any member of its WORKS subscription program to participate in beta testing. OpenInsight 9.2.1 includes numerous new features, enhancements and fixes in a range of categories, including Basic +; OIPI.net/OIPI; Form Designer; System Editor ++; Source Code Management (SCM); TCL; Arev32; Character To OpenInsight (CTO); OpenInsight for Web (O4W); and OpenInsight for U2.

Posted November 30, 2010

Kore Technologies has announced Release 3.0 of Kourier Integrator for U2, Kore's enterprise integration suite which provides extract, transform, and load (ETL) and enterprise application integration (EAI) capabilities for connecting UniData/UniVerse (U2) applications to Microsoft SQL Server and other best-in-class applications.

Posted November 30, 2010

The fourth annual U2 University conference was held last month in Denver, providing 3 days of hands-on instruction covering the latest best practices in the database and servers industry. "Attendance was up by at least 30% over last year, so we were bursting at the seams at the Warwick hotel in Denver," Susie Siegesmund, vice president and general manager, Rocket U2, tells DBTA.

Posted November 30, 2010

The year 2010 brought many new challenges and opportunities to data managers' jobs everywhere. Companies, still recovering from a savage recession, increasingly turned to the power of analytics to turn data stores into actionable insights, and hopefully gain an edge over less data-savvy competitors. At the same time, data managers and administrators alike found themselves tasked with managing and maintaining the integrity of rapidly multiplying volumes of data, often presented in a dizzying array of formats and structures. New tools and approaches were sought; and the market churning with promising new offerings embracing virtualization, consolidation and information lifecycle management. Where will this lead in the year ahead? Can we expect an acceleration of these initiatives and more? DBTA looked at new industry research, and spoke with leading experts in the data management space, to identify the top trends for 2011.

Posted November 30, 2010

There has been a lot of interest lately in NoSQL databases and, of course, many of us have strong backgrounds and experience in traditional relational "SQL" databases. For application developers this raises questions concerning the best way to go. One recurring truth that eventually surfaces with all new software technologies is that "one size does not fit all."

Posted November 23, 2010

To simplify hardware management in traditional, virtualized and cloud-based data center environments, Oracle last week unveiled Oracle Enterprise Manager 11g Ops Center.

Posted November 17, 2010

Helping organizations meet expanding requirements for archiving, e-discovery and regulatory compliance, Open Text will embed Oracle technology to deliver a new set of enterprise content solutions.

Posted November 17, 2010

Oracle has unveiled Oracle Tutor 14, the latest version of its process documentation tool. Oracle Tutor is a single, user-friendly repository for documenting and sharing business processes that streamlines training, facilitates information sharing and improves document consistency by enabling organizations to easily create, deploy and maintain enterprise policies and procedures.

Posted November 17, 2010

Sentrigo, Inc., a provider of database security software, has announced that Sentrigo Hedgehog Enterprise and vPatch solutions are now available on Amazon Elastic Compute Cloud (Amazon EC2) for database audit, protection and breach prevention. Sentrigo's database compliance and security solutions allow organizations to more easily run applications subject to PCI-DSS, HIPAA, SEC regulations and more on Amazon EC2.

Posted November 17, 2010

Sybase has announced a new release of Sybase Liquidity Management Suite (LMS), providing the global financial services industry with new modules enabling native support for Sybase's relational database management system and analytics platform. Sybase LMS consolidates payment and transaction information in real-time, across multiple systems, to provide a comprehensive enterprise-wide capability for managing operational liquidity, supporting optimal use of operating capital while minimizing operation risk.

Posted November 17, 2010

Sybase has issued the third and final installment of results from a study on the business impacts of effective data. The study benchmarked some of the world's leading companies across a range of vertical industries by measuring the direct correlation between a company's IT investments and overall business performance.

Posted November 17, 2010

Onsystex, which helps companies extend the reach and effectiveness of MultiValue applications, has announced the appointment of Ian Sandler as director of professional services.

Posted November 17, 2010

Queplix Corp., a provider of data virtualization software, has announced that its new Virtual Data Viewer is available for free download. The new product aims to streamline preliminary steps to implementing any type of data migration, management, integration or similar data initiative.

Posted November 16, 2010

Attunity Ltd., a provider of real-time data integration and event capture software, announced major enhancements to its CDC Suite for SSIS, providing a comprehensive solution for replicating data in real-time across a wide range of heterogeneous data sources at an affordable price point. The product suite is used by customers worldwide to enable real-time business intelligence (BI) and designed to improve business operations and reduce costs.

Posted November 16, 2010

Progress Software has announced the availability of database drivers for the Microsoft SQL Server 2008 R2 Parallel Data Warehouse. Available for pre-sales registration immediately with shipment in Q2 2011, the Progress DataDirect Connect drivers enable companies using UNIX-, Linux- and Java-based applications to connect to Microsoft SQL Server 2008 R2 Parallel Data Warehouse.

Posted November 16, 2010

At the PASS Summit in Seattle last week, Idera announced SQL doctor 1.1 and SQL diagnostic manager 6.5. The solutions help DBAs anticipate SQL performance problems and offer remedies before they become serious issues.

Posted November 16, 2010

The Professional Association for SQL Server (PASS) held the annual PASS Summit last week drawing 2,814 delegates and 993 pre/post-conference attendees for a total of 3,807 registrations. It is the largest turnout since the inception of the conference, and represents a 25% increase in attendance over 2009. The SQL Server community is growing "and we are very much a part of that community," Rick Heiges, vice president of marketing, PASS, told 5 Minute Briefing. The record conference attendance was not a surprise, he added. "Last year, our numbers were down about 10% but that was actually fantastic because a lot of other shows were down as much as 50%. We knew that we had a strong base to build upon. We saw signs of the economy coming back so when we started to budget for this year we had a good feeling that we would be able to have record attendance because our community is just so passionate about being here and getting together each and every year."

Posted November 16, 2010

It has been widely documented - data is growing at astronomical rates. The amount of data your organization has is less important than how the data is being used. Is data growth hindering your business or is it providing a better understanding of the direction you need to go?

Posted November 09, 2010

Psychiatrists report play is important for keeping our minds and bodies healthy and happy. It has been uncovered that without at least some play, we mentally and physically deteriorate. Lack of play can lead to depression. Our brains are so hardwired in their need for playful activities that without such expressions we loose focus. Play enhances the creativity and imagination within us. Likewise, play has a proper role within our work. And not just for the psychological benefit to the individual, but for the overall health of the organization. For an IT development group, play is essential for finding better ways to approach problems. Within an IT context, play involves evaluating new ways to handle old problems. Prototyping, at times, constitutes play. Prototypes can be used for more than just the practicalities of the user interface; sometimes a prototype of specific functions is necessary for comparisons in order to judge how non-obvious techniques may perform. Such prototype endeavors can involve not only new algorithms, but potentially variant data structures. Ideally, such prototypes will improve team understanding of the data structures and offer insights into potential new and innovative approaches.

Posted November 09, 2010

SQL is the lingua franca for modifying and reading database data and any DBA worth his (or her) paycheck should be proficient in writing SQL queries. But SQL is a flexible and feature-rich language, so there are always things that can be learned - even by senior technicians. As such, this month's column discusses several interesting SQL queries that you can put in your bag of tricks for future use.

Posted November 09, 2010

I am attending my first Professional Association for SQL Server (PASS) Summit in Seattle this month. A lot of DBAs I meet are very keen to attend these events as the standard of speakers and quality of content is so high. Travel, accommodation and attendance costs are often prohibitive, however, let alone getting the time away from the office. Getting managers' approval to attend and justifying the cost can be difficult, especially for those of us based outside the U.S. PASS also runs a European event in April each year in Germany and, in the U.K., we have the SQL Bits conference. Those who wish to attend can still run into the same objections, however.

Posted November 09, 2010

Application Security, Inc.(AppSec), a provider of database security, risk and compliance solutions (SRC) for the enterprise, and Unisphere Research have announced a new database security report, "Data in the Dark: Organizational Disconnect Hampers Information Security." The report, based on research conducted among 761 members of the Professional Association for SQL Server (PASS), reveals that companies suffer from a false sense of security.

Posted November 09, 2010

At PASS Summit 2010, Quest Software today announced a new user-driven feature of Quest SQLServerPedia, code-named "Project Lucy." Project Lucy analyzes SQL Server trace files securely uploaded by community members. In return, it provides them with an understanding of their instance performance, and how it stacks up against their peers' environments and Microsoft best practices, while keeping their individual user information confidential.

Posted November 09, 2010

While public clouds have gotten much of the cloud computing attention over the past years, a new Independent Oracle Users Group (IOUG) survey, conducted by Unisphere Research, finds that private cloud formations are growing in many companies, often outpacing adoption of public cloud services.

Posted November 03, 2010

Quest Software, Inc. has announced new initiatives around SharePlex for Oracle, its Oracle data replication solution, in order to put real-time replication within reach of organizations with small IT departments and tight budgets.

Posted November 03, 2010

Sentrigo, Inc., a provider of database security software, has announced that Sentrigo Hedgehog Enterprise and vPatch solutions are now available on Amazon Elastic Compute Cloud (Amazon EC2) for database audit, protection and breach prevention. Sentrigo's database compliance and security solutions allow organizations to more easily run applications subject to PCI-DSS, HIPAA, SEC regulations and more on Amazon EC2.

Posted November 02, 2010

Sybase, Inc., an SAP company, says it is seeing significant adoption momentum of Sybase CEP, a complex event processing (CEP) technology for performing analytics on high speed streaming data.

Posted October 27, 2010

Bradmark Technologies, Inc., has announced the maintenance releases of Surveillance for Sybase that 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 October 27, 2010

MENTIS Software, a provider of Sensitive Information Management solutions for enterprise applications and databases, has announced the availability of its latest release - MENTIS 7. The new release provides advanced Sensitive Data Discovery capabilities to help customers document and manage sensitive data locations as well as program and user access levels. Scan results of the discovery process are maintained in the MENTIS 7 metadata repository, providing critical information to IT managers responsible for security and audit management.

Posted October 27, 2010

Sybase, Inc., an SAP company, has announced the Sybase Mobile Sales for SAP CRM for BlackBerry smartphones - a new "super app" that delivers an integrated application experience on BlackBerry smartphones.

Posted October 27, 2010

Altova has announced the availability of version 2011 of the Altova MissionKit, its integrated suite of XML, database, and UML tools.

Posted October 27, 2010

ClickSoftware Technologies Ltd., a provider of automated workforce management and optimization solutions for the service industry, has announced that its Mobility Suite will run on key components of the Sybase mobility platform - SQL Anywhere embedded database and synchronization and Afaria mobile device management and security - by the end of 2010.

Posted October 27, 2010

Onsystex Corporation, which helps companies extend the reach and effectiveness of MultiValue applications, has announced that it has extended its operations by acquiring the development and outsourcing business of EuphoriaNET, a global IT services company, to expand its outsourcing offering to include offshore development in Latin America.

Posted October 27, 2010

At this week's Teradata Partners' users conference, Teradata Corporation announced it is shipping a new version of its data warehouse solution, providing new analytic features to support customers working with complex big data. Teradata Database 13.10 includes temporal capabilities, which enable companies to recreate information from selected points in time. Other new features include advanced and flexible data compression options that provide as much as 20 times more data, as well as analytic functions and expanded capabilities within the Teradata Open Parallel Framework.

Posted October 26, 2010

Quest Software, Inc. has announced new initiatives around SharePlex for Oracle, its Oracle data replication solution, in order to put real-time replication within reach of organizations with small IT departments and tight budgets.

Posted October 26, 2010

HiT Software, Inc., a provider of data integration, and change data capture products for heterogeneous database environments, has released HiT ODBC/400 v9.0 and HiT OLEDB/400 v5.0.

Posted October 26, 2010

Oracle has announced a world record non-clustered TPC-H 3TB benchmark result demonstrating the scalability of Oracle Database 11g running on Oracle's Sun SPARC Enterprise M9000 server.

Posted October 20, 2010

Altova has announced the availability of version 2011 of the Altova MissionKit, its integrated suite of XML, database, and UML tools.

Posted October 20, 2010

This Thursday, October 21, Database Trends and Applications (DBTA) will host the first in a series of educational webcasts on NoSQL database technology.This first webcast will explain what NoSQL is, and how these databases meet new requirements created by surging data growth and the demand for speed and analytics. The webcast will also cover important considerations when evaluating a NoSQL implementation for production environments, as well as how to obtain training and support for NoSQL deployments.

Posted October 19, 2010

Ingres Database 10, the latest version of Ingres Corporation's flagship open source database product is now generally available. Developed at Ingres and with input from the open source community, Ingres Database 10 now supports multi-versioning, column encryption, partitioning and faster bulk loading.

Posted October 19, 2010

The latest version of IBM Informix, codenamed "Panther," became generally available today. According to Martin Wildberger, vice president, World Wide Development, IBM, the new IBM Informix 11.7 software version helps clients and IBM partners streamline their business processes and access critical data faster to make smarter business decisions. Combined with new Informix Editions, the new software also allows clients and partners to accelerate the deployment of critical business solutions at lower cost, Wildberger adds.

Posted October 12, 2010

When IBM developers set out to build the next version of Informix their goal was to build on the foundation of one of the more mature, effective and reliable pieces of information management software in the industry. With the 10th anniversary of the IBM acquisition of Informix fast approaching, they knew that the 11.7 release would be closely watched by clients and partners alike.

Posted October 12, 2010

As a consultant, I get to meet many varied SQL Server professionals on a regular basis. One of the most common conversations we've had over the last few years surrounds the loss of control the DBA has experienced due to a couple of advances in technology.

Posted October 12, 2010

As bizarre as it seems, no one sabotages our efforts more easily than ourselves. We often leave ourselves vulnerable to failure whenever we respond to requests for project estimates. Like "A Tale of Two Cities" estimating can bring our best and our worst. In offering estimates, individuals may undercut their own efforts. For example, a developer may only consider time coding, and fail to include enough headroom for testing, rework, or documentation. While some aspects of these estimating attempts might suggest a passive-aggressive approach to avoid tasks, much of this estimate-short-sheeting often results from a desire to please and provide a number to make management "happy." There is always a desire from management to have more things done, and to do things quickly on every project. Even when not stated, this unspoken desire colors the responses of the individuals doing the estimating.

Posted October 12, 2010

If you are a DBA, or a database performance analyst, chances are that you deal with performance-related issues regarding your database systems every day of the week. But have you ever stopped for a moment and tried to define what you mean when you say "database performance"? Doing so can be a worthwhile exercise, if only to organize your thoughts on the matter. Think about it; don't we need a firm definition of database performance before we can attempt to manage the performance of our databases?

Posted October 12, 2010

Revelation Software has announced that OpenInsight 9.2.1 is now in development and will include a new Version Control module, as well as O4W (OpenInsight for Web) release 1.1.

Posted October 12, 2010

Oracle introduced the Oracle Exadata Database Machine X2-8 at Oracle OpenWorld. The new configuration extends the Oracle Exadata Database Machine product family with a high-capacity system for large OLTP, data warehousing and consolidated workloads. "The data volumes now are huge, and they are going to keep getting bigger and as they grow rapidly, you will need more and more power," said Oracle president Mark Hurd, commenting on the release during a keynote at the Oracle conference.

Posted October 06, 2010

5 Minute Briefing: Oracle had the opportunity to meet and speak with Pythian chief technology officer Alexander Gorbachev during Oracle OpenWorld about the company's achievement of four specializations under the OPN (Oracle PartnerNetwork) Specialized Program. Pythian, already a Platinum member of the OPN, has met a series of demanding technical and business requirements to earn the specializations in Oracle Database 11g, Real Application Clusters (RAC), Database Performance Tuning, and Oracle Linux.

Posted October 06, 2010

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

Sponsors