Database Management Articles
Oracle recently completed a benchmark test of Oracle Insurance Policy Administration for Life and Annuity Version 9.3 running on Oracle Exadata Database Machine X2-2 and Sun SPARC Enterprise M9000 application servers. The benchmark included 100 million policies and more than 2,000 concurrent users.
Posted May 26, 2011
Oracle has announced the availability of Oracle SQL Developer 3.0. The new release focuses on ease of migration, improving development and database administrator (DBA) tasks, and introduces support for Oracle Data Mining and Oracle Spatial. A free graphical tool for database development, Oracle SQL Developer Release 3.0 is downloadable from the Oracle Technology Network (OTN).
Posted May 26, 2011
The Oracle Exadata Database Machine X2-2 and X2-8 with the Solaris option began shipping just this month. Now in its third generation, the Database Machine combines all the components to create what the company describes as the best platform for running the Oracle Database. Here, Tim Shetler, vice president of Product Management, Oracle, talks about the performance innovations that differentiate Oracle's offering, how customers are using the system today for business advantage, and also — what's ahead.
Posted May 26, 2011
SAP AG and Sybase, Inc., an SAP company, have announced plans to make the enterprise resource planning (ERP) application SAP ERP the first SAP Business Suite application running on Sybase Adaptive Server Enterprise (ASE). The announcement was made at SAPPHIRE NOW in Orlando where pilot customers also showcased how they are using SAP ERP on Sybase ASE. In combining SAP applications with Sybase technology, along with "harmonized" customer services and support, the companies say they will be able to offer organizations a new database option for running SAP applications and accessing critical information, providing efficiency gains and cost reductions.
Posted May 25, 2011
TechWave 2011 will be co-located with SAP TechEd, September 12-16 at the Venetian Hotel in Las Vegas, NV. TechWave will continue to deliver targeted training on Sybase products, plus offer attendees access to TechEd keynote sessions, exhibits, special event and other networking functions. Sybase TechWave is the only event that provides in-depth training and education across the range of Sybase products, access to key Sybase partners, and fun and entertaining opportunities for networking and increasing knowledge. The agenda will feature over 150 breakout sessions covering enterprise mobility, data management, application development tools, business intelligence & analytics, mobile commerce and mobile messaging.
Posted May 25, 2011
SAP AG and Sybase, Inc., an SAP company, have announced plans to make the enterprise resource planning (ERP) application SAP ERP the first SAP Business Suite application running on Sybase Adaptive Server Enterprise (ASE). The announcement was made at SAPPHIRE NOW in Orlando where pilot customers also showcased how they are using SAP ERP on Sybase ASE. In combining SAP applications with Sybase technology, along with "harmonized" customer services and support, the companies say they will be able to offer organizations a new database option for running SAP applications and accessing critical information, providing efficiency gains and cost reductions.
Posted May 25, 2011
HiT Software, a provider of data integration and change data capture products for heterogeneous database environments, has announced DBMoto version 7.1, the newest version of its change data capture product. This release adds IBM Informix log reading, open APIs to embed DBMoto in applications and systems, and a replication activity viewer to monitor replication jobs. "A number of customers have asked us to develop log reading for Informix," Carolyn Hughes, director of marketing, tells 5 Minute Briefing. "A lot of the Informix installed base deals with high-transaction businesses, such as retail and telco, and so being able to read the transaction logs as opposed to relying on triggers will enable a huge time savings."
Posted May 24, 2011
Symantec Corp. has signed a definitive agreement to acquire Clearwell Systems, Inc., a privately held vendor in the e-discovery market for a purchase price of approximately $390 million, net of Clearwell's existing cash balance of approximately $20 million. "As information continues to grow at unprecedented rates, the biggest challenge for customers is to protect, manage and backup this information as well as have the ability to categorize and discover it efficiently," said Deepak Mohan, senior vice president, Information Management Group, Symantec. The acquisition is expected to close in the September quarter.
Posted May 19, 2011
After 5 years in Seattle, PASS (the Professional Association for SQL Server) will hold its annual SQL Server and BI conference in Charlotte, NC, in 2013, bringing the event closer to database professionals in the eastern U.S. who may not have been able to make the cross-country trip in the past, as well as making it more convenient for international travelers. PASS Summit 2007 in Denver was the last Summit held outside Seattle.
Posted May 18, 2011
Through the many changes in IT over the years, one constant has always been a concern for performance. With database systems there is especially true. Even with the many advances in relational database technology, SQL performance still remains a key concern for IT professionals and management. Writing SQL for performance is one of the single biggest opportunities for professionals to contribute efficient, effective, cost saving deliverables to projects. Writing SQL for performance can also avoid having to respond to an urgent problem with performance in a production environment. To a considerable extent, a person can choose whether they are running because it is lunch or whether they are running because they are lunch, by following a few simple techniques for writing SQL for performance.
Posted May 12, 2011
Design reviews are an important facet of the system development lifecycle for database applications. It is during the design review that all aspects of the database and application code are reviewed for efficiency, effectiveness, and accuracy. It is imperative that all database applications, regardless of their size, are reviewed to assure that the application was design properly, efficient coding techniques were used, and the database is accessed and modified correctly and efficiently. The design review is an important process for checking the validity of design decisions and correcting errors before applications and databases are promoted to production status.
Posted May 12, 2011
Tables within a database management system (DBMS) need primary keys and defined indexes in order for the DBMS to have the opportunity to provide good query performance. Without indexing, the worst possible query performance is guaranteed. The content of these non-keyed tables remains unknown to the DBMS, a black box, where the only possible approach for query execution is to read every row one-by-one. Under such scenarios, the DBMS is little more than a file server that operates more slowly than usual. Without the primary key and indexing, the DBMS may expend even more processor cycles in moving data in and out of the DBMS proprietary storage areas than a file server uses in opening files.
Posted May 12, 2011
I have been working with SQL Server for more than 10 years now, and my time with Quest has been spent as a consultant visiting hundreds of customer sites, and discussing their environments and matching products to their issues. This has given me a fairly unique insight into how SQL Server is changing. It has also been intriguing to work closely with colleagues from the Oracle world, and seeing how their opinion of SQL Server has changed. They now take it very seriously, something I like to think I have played a positive part in! The most striking trend I have noticed is the lack of expertise in some environments when using SQL Server. I can confidently say you are extremely unlikely to run an Oracle database without an Oracle DBA. However, in the SQL Server world this practice seems to be commonplace.
Posted May 12, 2011
The PostgreSQL project has released the first beta of version 9.1. This beta release contains all of the features which will be in the final release, which is expected to be released 2 to 4 months from now, sometime between July and September. According to the PostgreSQL project team, PostgreSQL 9.1 contains a "huge volume" of new features, possibly more than any single release of PostgreSQL before. The overarching theme of the new release is innovation - "not just new to us but new to anybody," Josh Berkus, PostgreSQL core team member, tells 5 Minute Briefing.
Posted May 03, 2011
Red Gate Software, a provider of tools for Microsoft technology professionals, says it will provide free perpetual licenses for current .NET Reflector 6.x users who upgrade to version 6.8. The free version of .NET Reflector was previously planned to expire at the end of May.
Posted May 03, 2011
Representing a continuation of a long-running partnership between the two companies, IBM and Sybase have introduced a new workload-optimized server appliance aimed at financial institutions, mobile operators and enterprises called the IBM mCommerce Appliance Solution. The hardware and software appliance features IBM POWER7-based Power 750 servers running IBM DB2 information management software and IBM WebSphere software application server, IBM System Storage DS5300 and the Sybase mCommerce 365 solution. Specifically, the appliance is targeted at financial institutions and mobile operators but it is not limited to those customers or verticals, Charlie Chen, vice president of platform alliances, Sybase, tells 5 Minute Briefing.
Posted April 29, 2011
Sybase has announced plans for the release of new functionality connecting Sybase Replication Server to Sybase Aleri Streaming Platform. This new functionality will enable data events from heterogeneous databases to be propagated in real-time, via complex event processing (CEP), addressing challenges such as reference data management and risk aggregation.
Posted April 29, 2011
Sybase has announced that the Call for Papers is now open. TechWave 2011 will be co-located with SAP TechEd, September 12-16 at the Venetian Hotel in Las Vegas, NV. TechWave will continue to deliver training on Sybase products, as well as keynote sessions, exhibits, special event and other networking functions.
Posted April 29, 2011
InterSystems Corporation, which develops and markets advanced integration, database and business intelligence technologies, has announced the winners of its 2011 Innovator Awards, which recognize those who use InterSystems technologies in new ways to create innovative applications and integration solutions. Winners were recognized at the InterSystems Global Summit 2011 conference.
Posted April 27, 2011
DBI (Database-Brothers, Inc.) has released Brother-Panther for DB2 LUW 5.1. "Brother-Panther is all about performance monitoring, analysis, tuning and trending. Our customers are very successful at using Brother-Panther to understand what costs the most and what hurts the most in the database. And in a couple of more mouse clicks we are usually able to hand them a solution that will make all that pain go away," Scott Hayes, president and CEO of DBI, tells 5 Minute Briefing. With this release, says Hayes, Brother-Panther now can now help people understand the big picture and the details regarding the consequences of change.
Posted April 26, 2011
Full 360 Inc., a New York-based systems integrator, has introduced a new release of its elasticBI platform-as-a-service (PaaS). elasticBI pairs Jaspersoft4, the open source BI application, with the Vertica Analytic Database in a PaaS offering that is tightly integrated via the Opscode Chef framework. The platform is offered by Full 360 on Amazon Web Services, the Amazon cloud. According to Full 360, elasticBI provides a complete BI-data warehouse platform that is accessible from a cost and technical perspective for small and mid-market companies, as well as enterprise departments.
Posted April 26, 2011
Oracle yesterday announced a major new version of the NetBeans integrated development environment (IDE), NetBeans IDE 7.0, allowing developers to take advantage of the newest developments in Java Platform, Standard Edition (Java SE). NetBeans IDE 7.0 introduces language support for the upcoming JDK 7 release, currently available as a Developer Preview.
Posted April 21, 2011
Clerity Solutions, a provider of mainframe migration, modernization and optimization solutions, announced that it has certified its UniKix Mainframe Rehosting software to work with Oracle Exadata Database Machine and Oracle Exalogic Elastic Cloud engineered systems. Explaining Clerity's motivation for certifying with Oracle Exalogic and Exadata, Wendy Williams, director of marketing, Clerity, tells 5 Minute Briefing, "We are starting to see a greater interest in cloud-based initiatives from our customers. They are looking for ways not only to move their file-sharing and basic applications to the cloud but they are also starting to talk about how they can move some of their critical business-imperative applications to the cloud as well."
Posted April 21, 2011
Quest Software has unveiled Quest Backup Reporter for Oracle, a new desktop solution that offers DBAs a dashboard view of all of the Oracle backups across the enterprise that they are managing and also provides drill-down views into a single database for more detailed reporting. In addition to simplifying and cutting the time needed to report on the status of Oracle backups, the new solution is also aimed at reducing the risk associated with failed or poorly performing backups.
Posted April 21, 2011
Database Trends and Applications (DBTA) met with Oracle Applications Users Group (OAUG) president Mark C. Clark during last week's COLLABORATE 11 conference in Orlando, Florida. Now, more than 2 years following the financial meltdown of late 2008, it is clear that more users are again out attending COLLABORATE. "We have gone through a period of very tight IT budgets, a 2-to-4 year phase of maintenance. Everybody I am talking to is looking at opportunities to do projects this year. And if they aren't doing it this year, they are planning for it next year," said Clark, commenting on the renewed enthusiasm for attending the conference.
Posted April 19, 2011
SQL Sentry, Inc., a developer of software products that optimize the performance of Microsoft SQL Server environments, and DBSophic, a provider of performance management products for database-centric applications, have announced a new product bundle, the "Power Suite + Qure Quick Start Pack," to help SQL Server DBAs monitor, manage, troubleshoot and tune database server performance.
Posted April 19, 2011
BMC Software has announced database management solutions to help customers exploit the cost savings advantages enabled by DB2 10 for z/OS. Customers are moving more aggressively to DB2 10 than BMC has seen in the past when new versions of DB2 have been released, Robin Reddick, director, MSM Solutions Marketing at BMC Software, tells 5 Minute Briefing. The primary motivation that BMC is hearing from its customers is that they can achieve cost savings with the new release. According to Reddick, about 50% of BMC's customers say they will have moved to DB2 10 within 18 months of the release of the latest version, and about 25% say that they are going to skip version 9 and go right from version 8 to version 10.
Posted April 18, 2011
Platform Computing, a provider of cluster, grid and cloud management software, has announced support for the Apache Hadoop MapReduce programming model to bring enterprise-class distributed computing to business analytics applications that process big data.
Posted April 12, 2011
HP has updated its Information Management portfolio to enable organizations to reduce risk, increase efficiency and simplify the way they manage their business information. By bringing a holistic approach to information management, HP says the solutions and services will help executives harness the power of their information to make better decisions, manage for cost and compliance, and deliver the right information to the right users at the right time.
Posted April 12, 2011
EMC has announced three new additions to its EMC Greenplum Data Computing Appliance (DCA) line of products - the High Capacity DCA, the High Performance DCA, and the Data Integration Accelerator - as well as version 4.1 of Greenplum Database.
Posted April 12, 2011
HiT Software, Inc., a BackOffice Associates, LLC company and provider of data management products, has released HiT ODBC/DB2 v6.2 and HiT OLE DB/DB2 v4.2, the newest versions of its high-performance connectivity products specifically for application access to IBM DB2 for z/OS and IBM DB2 for Linux, UNIX, Windows (LUW) databases.
Posted April 12, 2011
With the annual Oracle users conference COLLABORATE about to begin, Andy Flower, president of the IOUG, spoke with 5 Minute Briefing about the IOUG's strong areas of focus in terms of overall conference content, and how the addition of the MySQL user base into the Oracle community is evolving. Citing a MySQL keynote, 75 sessions at COLLABORATE focused on MySQL, and a new MySQL Council headed by Sarah Novotny, Flower says the IOUG is making strides in giving voice to the MySQL community within the IOUG and setting a stage for positive interaction with Oracle.
Posted April 06, 2011
Oracle has announced three new integrations in support of its open and integrated technology stack. Enhancing its backup and recovery capabilities for Oracle Exadata Database Machine, Oracle's Sun ZFS Storage Appliance now directly connects to the Oracle Exadata InfiniBand fabric to simplify deployments and accelerate backup and recovery time by more than 50% compared to traditional NAS systems. Oracle Virtual Desktop Infrastructure now provides integration with the Sun ZFS Storage Appliance with rapid iSCSI provisioning that automates desktop provisioning and accelerates virtual desktop deployments. Additionally, Oracle Secure Backup is qualified for Sun ZFS Storage Appliance backup and recovery with Oracle's scalable StorageTek tape libraries.
Posted April 06, 2011
DBAs and IT operational teams, pressured by the unabated flow of data streaming in from an ever wider range of sources, require proactive self-managing and automated systems to supplement or replace manual techniques and processes which are no longer scalable given the rate of data growth, according to the results of a new Independent Oracle Users Group (IOUG) study on database manageability.
Posted April 05, 2011
Red Gate has added support for eight source control systems - Vault Standard, Vault Professional, Kiln (Hg), Mercurial (Hg), Git, Perforce, CVS and Bazaar - to SQL Source Control, the company's unique tool for controlling all database elements from within SQL Server Management Studio (SSMS). As a result, developers are now able to bring their database development in line with their application development processes no matter what source control system they use. Previous versions provided support for Team Foundation Server (TFS) and Subversion (SVN).
Posted April 05, 2011
Big data is one of those terms that is quickly gaining momentum among technologists. If you watch closely, you'll notice that everyone seems to have an opinion on what "big data" means and wants to own the term. As industry experts discuss what to name this problem, in 2011, companies will be tasked with bringing big data from back office offline analytics to customer-facing 24x7 production systems. Customers are paying attention and they need solutions that support not only massive data sets but also mixed information types, extended feature sets, real-time processing, and technical teams that have not hand-coded these systems from the ground up. Here are five big data solution trends we see developing as our customers work hard to solve "big data" or "big information" problems.
Posted April 05, 2011
Dates are important. Without dates how can anything be planned? However, due dates have been know to increase in importance in the delivery of software solutions. Sometimes the due date becomes such an overwhelming creature of importance that the date is more important than following best practices, more important than verifying that what is built is correct, more important than the solution team gaining a proper understanding of the work they are attempting to perform.
Posted April 05, 2011
What will you do when you find out you're about to acquire or consolidate with another firm or division? Are you aware of the risks you may be inheriting? What data is going to demand the highest availability? What IT regulations will you have to address and how do you know if existing controls already address them? Here are 10 "data health" checks you can conduct to answer help these questions before giving a green light to an M&A or consolidation.
Posted April 05, 2011
When I meet SQL Server professionals, I am always interested to find out if they have deployed the latest version of SQL Server into production yet, if they are using Enterprise Edition, and, if so, which new features they are using and why. Nothing beats real world implementation scenarios to help get a better understanding of a feature in SQL Server. The most common Enterprise Edition SQL Server Engine features deployed (and this is not a scientific survey, by any means) appear to be Table Partitioning, Backup Compression (now in Standard Edition) and Resource Governor. The Resource Governor was the feature DBAs working with large-scale SQL Server environments seemed most excited about when SQL 2008 was first announced.
Posted April 05, 2011
In what is being hailed as an optimistic sign for the tech sector overall, Oracle announced strong results for its fiscal third quarter, including new software license revenues that were up 29%. Oracle's fiscal 2011 Q3 GAAP total revenues were up 37% to $8.8 billion, while non-GAAP total revenues were up 36% to $8.8 billion. Both GAAP and non-GAAP new software license revenues were up 29% to $2.2 billion.
Posted March 31, 2011
DBAs and IT operational teams, pressured by the unabated flow of data streaming in from an ever wider range of sources, require proactive self-managing and automated systems to supplement or replace manual techniques and processes which are no longer scalable given the rate of data growth, according to the results of a new Independent Oracle Users Group (IOUG) study on database manageability. With input from 445 member respondents from within the IOUG community, the survey finds that forward-looking companies, led by Oracle technologists and DBAs, are meeting their growing data management challenges by employing more advanced database management policies. This survey was conducted by Unisphere Research, a division of Information Today, Inc., in partnership with Oracle Corporation. Among the key findings are that more than one-third of respondents indicate their companies' data stores are increasing at a rate greater than 20% a year, and, the survey finds, this growth is a main contributor to many of the difficulties DBAs currently face.
Posted March 31, 2011
Oracle has announced a new world record non-clustered TPC-H 3TB benchmark result demonstrating the scalability of Oracle Database 11g Release 2 running on Oracle's SPARC Enterprise M9000 server. "This result demonstrates the outstanding performance and scalability of the SPARC Enterprise M9000 platform," states Juan Loaiza, senior vice president, Systems Technology, Oracle. "Overall, Oracle has delivered a remarkable portfolio of benchmark results showcasing our continued efforts to create an industry standard for performance, scalability and price/performance."
Posted March 31, 2011
Tokutek has announced TokuDB v5.0, which adds hot indexing and hot column addition/deletion as well as full MVCC (multiversion concurrency control) support. TokuDB, the company's flagship product, is a scalable MySQL Storage Engine. According to the company, with the new release, customers can now speed the time to build targeted queries or revise their data model, in order to perform near real-time analysis on live production data and take advantage of dynamic business opportunities.
Posted March 31, 2011
Continuent, Inc., a provider of replication and clustering solutions for open source databases, has announced the next version of Tungsten Enterprise, a replication and data management solution for MySQL and PostgreSQL.
Posted March 31, 2011
UC4, an IT automation provider, has announced a new line of IT automation tools that supports a range of environments across enterprises. The company simultaneously announced it is shipping ONE Automation, a new solution for cross-platform automation, along with UC4 Automation Platform version 9, designed to provide end-to-end enterprise automation.
Posted March 29, 2011
Continuent, Inc., a provider of replication and clustering solutions for open source databases, announced the next version of Tungsten Enterprise, a replication and data management solution for MySQL and PostgreSQL. This latest version of Tungsten Enterprise includes a number of features to improve the management, performance, flexibility and reliability of Tungsten clusters. The new release also includes architectural changes to Tungsten Replicator, as well as connectivity improvements, upgrades to MySQL binlog parsing, and PostgreSQL replication.
Posted March 29, 2011
InterSystems Corporation, which develops and markets advanced integration, database and business intelligence technologies, has announced the winners of its 2011 Innovator Awards, which recognize those who use InterSystems technologies in new ways to create innovative applications and integration solutions. Winners were recognized at the InterSystems Global Summit 2011 conference.
Posted March 29, 2011