Database Management Articles
Listen to a group of database professionals talk for awhile and someone will eventually bring up the topic of data deduplication. Data deduplication is a means to eliminate redundant data, either through hardware or software technologies. To illustrate, imagine you've drafted a new project plan and sent it to five teammates asking for input. That single file has now been reproduced, in identical bits and bytes, on a total of six computers. If everyone's email inbox is backed up every night, that's another six copies backed up on the email backup server. Through data deduplication technology, only a single instance of your project plan would be backed up, and all other instances of the identical file would simply be tiny on-disk pointers to the original.
Posted December 14, 2009
As per my regular custom, this final DBA Corner column of the year is a review of the most significant data and database-related events of the year. Of course, to meet my deadlines, it is October 2009 as I write this, so please excuse any significant news that may have happened late in the year!
Posted December 14, 2009
Rocket Software recently completed the purchase of the UniData and UniVerse Servers and Tools assets from IBM. Susie Siegesmund, now vice president and general manager for the U2 brand under Rocket, talks with Database Trends and Applications about why the timing was right for this move and what U2 customers and partners can expect under the new ownership.
Posted December 14, 2009
Ian Abramson, president of the Independent Oracle Users Group, is traveling to Belgium in order to present the IOUG position on the pending acquisition of Sun by Oracle to the European Union's Competition Committee. Abramson, who will arrive in Brussels on Wednesday, was asked by Oracle, on behalf of the IOUG, to be a part of the company's presentation this week to the EU.
Posted December 08, 2009
Oracle has announced the availability of Oracle Audit Vault Release 10.2.3.2, including key new reporting and alerting capabilities that streamline and help reduce the cost of the database audit process. To help ensure that the new Oracle Audit Vault entitlements and compliance-specific reports contain the information needed to pass real-world database audits, Oracle consulted with IT auditors, notes Vipin Samar, vice president of database security, Oracle. "This new release of Oracle Audit Vault will allow organizations to further automate their database activity monitoring and auditing processes, reducing the overall cost of meeting regulatory requirements and securing critical data."
Posted December 02, 2009
Infobright, an open source data warehousing company, and Talend, an open source data integration company, have announced the availability of two integrated virtual machines for data warehousing and business intelligence. The first virtual machine combines the Infobright Community Edition analytic database with the Talend data integration tool, Talend Open Studio. The second virtual machine bundles these same two products with Jaspersoft's open source report server, JasperServer Community Edition, to deliver an end-to-end business intelligence solution.
Posted December 01, 2009
Calpont Corporation is a database software company that provides column-oriented technology optimized to handle analytics, business intelligence and read-intensive application deployments. Recently, Calpont announced the availability of its open source database software, InfiniDB Community Edition. Enabled via MySQL and purpose-built for an analytic workload with column-oriented technology at its core, InfiniDB Community Edition delivers a full-feature scale-up solution that supports the rapidly increasing demand for open source analytics databases solutions.
Posted December 01, 2009
Ntirety has launched a new, entry-level database service plan that offers 24x7 crash alerts and troubleshooting to quickly get businesses and databases back up and running, along with continuous backup monitoring and extensive reporting services. The new service plan is called NsureDB and delivers immediate alerts of down databases and dispatches Ntirety's experts to quickly remedy the problem.
Posted December 01, 2009
Continuent, Inc., a provider of software solutions for continuous data availability, advanced database replication, backup, and database performance scalability, recently announced the availability of Continuent Tungsten 1.2. Tungsten 1.2 Community Edition is available free of charge, while customers who want more advanced features and on-call technical support are encouraged to purchase the commercial Tungsten Enterprise 1.2 edition.
Posted December 01, 2009
The Independent Oracle Users Group has released a letter opposing the recent European Commission objection to the Oracle acquisition of Sun Microsystems.
Posted November 18, 2009
Oracle has announced the new release of Oracle Berkeley DB Java Edition 4.0 including significant new features for high availability, scalability, and performance.
Posted November 18, 2009
Altova has announced the availability of Version 2010 of the Altova MissionKit, an integrated suite of XML, database, and UML tools. Version 2010 delivers a large number of new features across the product line for XML editing, data mapping, visual stylesheet designing, UML modeling, database schema analysis, and comparing and merging XML and database content.
Posted November 18, 2009
Integrating technology from its acquisition of GoldenGate Software into the Oracle Data Integration suite of solutions, Oracle has announced Oracle GoldenGate, which delivers low-impact real-time data integration and replication technology to Oracle Fusion Middleware and provides a comprehensive, heterogeneous data integration platform.
Posted November 17, 2009
Idera, a Microsoft Gold Certified Partner and leading provider of management and administration solutions for Microsoft SQL Server, recently announced SQL virtual database, a new product for accessing and extracting data from SQL Server backup files.
Posted November 17, 2009
SharePoint360 recently announced that it has been accepted into a Microsoft early adoption program for new upcoming business intelligence products. While early adoption programs span many technologies and generally only engage Microsoft customers, SharePoint360 says it was selected as a result of its work in highlighting Microsoft SQL Server 2008 R2 within Microsoft SharePoint Server.
Posted November 17, 2009
Panorama Software, a provider of proactive Business Intelligence (BI) solutions, has announced its plans for the next release of its flagship product suite NovaView. Panorama's next release will extend its Microsoft SQL Server Analysis Services support to natively support Microsoft's new PowerPivot technology (formerly known as Project Gemini). SQL Server Analysis Services (SSAS) is Microsoft's online analytical processing (OLAP) technology, and PowerPivot is the name for Microsoft's next major update to SSAS.
Posted November 17, 2009
The pervasive nature of data continues unabated, leaving organizations more awash in data than ever before. Technology has enabled the access and leveraging of information to heights undreamed of a generation ago. Between corporate dashboards and internet Googling, vast quantities of information are truly at one's finger tips. Data-driven, domain-driven, model-driven … the data itself is a force to be met and managed. When managed well, users never explicitly think about the databases that persist all that data.
Posted November 11, 2009
If you've read the IT press at all these days, you know that SQL Injection (SI) attacks are very common and can be devastatingly effective. In fact, SI attacks-equally easy to execute against Oracle, MySQL, IBM DB2, or Microsoft SQL Server-are among the most common hacks on the Internet today. If a web application runs a relational database on the backend, it can be subject to an SI attack, which ironically, is among the easiest web hacks to prevent.
Posted November 11, 2009
How many times have you been surfing the web only to encounter a form that requests a slew of personal information before you can continue on? You know what I'm talking about. A company markets a white paper or poll results or something else that intrigues you, so you click on the link, and bang, there you are. You don't have the information you wanted yet, but if you just fill out this form then you'll be redirected to the information.
Posted November 11, 2009
A modern architecture, system stability and strong behind-the-scenes support are key attributes to consider when evaluating new database technology. In December 2008, Brasher's initiated a phased roll-out of its enterprise applications on the InterSystems CACHÉ high-performance database with MultiValue technology, concluding the implementation in January 2009. In all, the migration involved more than 8,000 programs and cataloged procedures ranging from accounting applications through real-time bid processing systems in auction venues. In going live with CACHÉ at each location, says Ty Brewer, Brasher's CIO, "our goal was for people to go home on a Friday and come back on a Monday and not notice anything different, other than things being faster. By and large, that's exactly what happened."
Posted November 11, 2009
Performance bottlenecks have the potential to effectively cripple an entire organization, which can spell disaster for the enterprise. The lengthy downtime caused by poor database performance interrupts business continuity and reduces end-user productivity, and can cause a direct, negative impact on the organization's bottom line.
Posted November 11, 2009
Oracle has announced the new release of Oracle Berkeley DB Java Edition 4.0 including significant new features for high availability, scalability, and performance.
Posted November 10, 2009
Quest Software announced two significant product releases in the SQL Server performance management space at PASS Summit last week in Seattle. The latest release of Spotlight on SQL Server Enterprise, Quest's monitoring and diagnostics tool, now featuring business intelligence monitoring, coupled with the debut of Foglight for SQL Server, enables database administrators to proactively detect, diagnose and resolve SQL Server performance issues.
Posted November 10, 2009
Oracle issued a statement Monday that its acquisition of Sun is essential for competition in the high-end server market, for revitalizing Sparc and Solaris and for strengthening the Java development platform. The company also said it plans to "vigorously oppose" the European Commission's Statement of Objections and that the evidence against the Commission's position is "overwhelming."
Posted November 10, 2009
Aster Data, a provider of data warehousing solutions for "big data" applications, yesterday announced Aster Data Version 4.0, which the company describes as the industry's first "Massively Parallel Data-Application Server." Aster Data 4.0 allows companies to embed applications inside Aster Data's MPP (massively parallel processing) data warehouse, so businesses can now store, analyze and speed processing of terabytes to petabytes of data. The ability to push applications down into the MPP database also opens a new opportunity for companies to deliver new interactive, big data applications.
Posted November 03, 2009
Attunity, a provider of real-time data integration and event capture software, has introduced a suite of Operational Data Replication (ODR) solutions integrated with Microsoft SQL Server Integration Services (SSIS) which is designed to enable customers to replicate data in real-time across a set of heterogeneous data sources at an affordable price point. The solutions are designed to enhance business intelligence, improve business operations, and reduce total costs.
Posted November 03, 2009
Altova has announced the availability of Version 2010 of the Altova MissionKit, an integrated suite of XML, database, and UML tools. Version 2010 delivers a large number of new features across the product line for XML editing, data mapping, visual stylesheet designing, UML modeling, database schema analysis, and comparing and merging XML and database content.
Posted November 03, 2009
EnterpriseDB, a commercial software company supporting the PostgreSQL open source database, announced that Red Hat, an open source products and services vendor, has made a financial investment in EnterpriseDB. The company also said it is releasing a new version of Postgres Plus Standard Server.
Posted November 02, 2009
Sybase, Inc. last week reported financial results for the third quarter ended September 30, 2009. "The team continued to execute very well and enabled us to deliver our best-ever third quarter results in the company history," John Chen, chairman, CEO and president of Sybase, said during an earnings call announcing the results. The company achieved third quarter records in total revenue, operating income, operating margin, net income, EPS, and cash flow from operations.
Posted October 29, 2009
Altova, a data integration vendor, has included Health Level Seven (HL7) and Extensible Business Reporting Language (XBRL) standards support within MapForce Version 2009, an integrated suite of XML, database, and UML tools.
Posted October 28, 2009
Southeast Community College is using Informer, decreasing the time required for data evaluation and collection, Entrinsik has announced.
Posted October 28, 2009
David Roper has been named vice president of sales at Kore Technologies. Kore provides a range of professional services and applications for the Rocket Software U2 and Microsoft SQL Server databases. Key products include KommerceServer, an advanced framework for building e-commerce web solutions, and Kourier Integrator, an application designed for system integration and business automation.
Posted October 28, 2009
Just days after Rocket Software completed the purchase of the UniData and UniVerse Servers and Tools assets from IBM, Susie Siegesmund, now vice president and general manager for the U2 brand under Rocket, took time to talk about why the timing was right for this move and what customers and partners can expect under the new ownership. Here, some excerpts from that interview. Read the full interview in the December issue of Database Trends and Applications.
Posted October 28, 2009
Embarcadero, a provider of multi-platform database tools, is adding more graphical capabilities to DB Optimizer to make it easier for developers and DBAs to do SQL profiling and tuning. DB Optimizer, which supports IBM DB2 for LUW, Oracle, Microsoft SQL Server and Sybase, helps eliminate performance bottlenecks by identifying data-intensive or frequently executed queries, focusing on specific SQL statements through query statistics (CPU, I/O, wait times), and fine-tuning problematic statements
Posted October 27, 2009
HiT Software, a provider of products for database access, integration and replication, has announced Allora 6.0, the newest version of the company's data transformation product.
Posted October 27, 2009
SpringSource, a division of VMware, Inc. and a provider of Java application infrastructure and management software, has introduced SpringSource tc Server Developer Edition, an Apache Tomcat-compatible platform that gives developers deep visibility and relevant information for debugging and improving the performance of their Spring applications.
Posted October 27, 2009
At the recent Oracle OpenWorld event, Oracle announced a series of new enhancements to its Java middleware stack, which incorporates application server and Java tools from last year's BEA acquisition. Dubbed the Oracle Fusion Middleware Application Grid, the offerings are intended to enable faster development and deployments within the Java framework. At the core of Oracle's offerings is WebLogic application server, acquired from BEA, which integrates some functionality of the now discontinued Oracle Application Server. "The foundation of our middleware stack is to enable greater efficiency," Mike Pietch, senior director of product marketing, said in a press conference.
Posted October 21, 2009
Quest Software, a provider of database management tools, announced the next generation of Toad for Oracle, a solution designed to enhance Oracle database development and administration. The new toolset, Toad for Oracle 10, offers enhancements in usability, automation, and education, the vendor says.
Posted October 21, 2009
Attunity Ltd., a provider of real-time data integration and event data capture software, introduced a set of solutions based on a new concept coined ‘Operational Data Replication' (ODR), designed to enable the large market of Oracle customers to replicate data in real-time to and from Oracle databases, at an affordable price point. The solutions, designed to enhance business intelligence (BI), improve business operations and reduce total costs, were presented at last week's Oracle Open World conference.
Posted October 21, 2009
EnterpriseDB, the commercial software company supporting the PostgreSQL open source database, recently announced the release of Postgres Plus Standard Server 8.4, an advanced open source database product that combines the price and performance benefits of a community-developed open source technology, with the full support of a stable commercial entity. PostgreSQL adoption is growing rapidly, and many organizations are now viewing it as an alternative to proprietary database offerings. With this version of Postgres Plus Standard Server, EnterpriseDB is advancing this adoption by giving enterprises the cost benefits of an open source database platform, the performance benefits of a community-developed product, and the reassurance of proven vendor support.
Posted October 20, 2009
At the recent Oracle OpenWorld event, Oracle announced a series of new enhancements to its Java middleware stack, which incorporates application server and Java tools from last year's BEA acquisition. Dubbed the Oracle Fusion Middleware Application Grid, the offerings are intended to enable faster development and deployments within the Java framework. At the core of Oracle's offerings is WebLogic application server, acquired from BEA, which integrates some functionality of the now discontinued Oracle Application Server.
Posted October 19, 2009
IBM had mixed news for the most recent earnings quarter—some segments were down, and others keep growing. Overall, the company grew slightly from last quarter, but was down from a year ago. Total revenues for the third quarter of 2009 were $23.6 billion, up a percent from the second quarter of 2009, and down 7% from the third quarter of 2008.
Posted October 19, 2009
BlueFinity International has introduced the latest enhancement to its .NET development toolset for MultiValue databases, mv.NET with Solution Objects. mv.NET provides a 100% native .NET interface to all major MultiValue databases, allowing .NET developers to access all aspects of their MultiValue systems. The new Solution Objects component set for mv.NET builds upon this existing infrastructure to provide strongly-typed, class-based access to MultiValue databases via the generation of an advanced data abstraction layer.
Posted October 13, 2009
Robert Catalano, Director of Sales, Revelation Software, Discusses New Features in OpenInsight 9.1
Posted October 13, 2009
IBM recently completed the sale of its worldwide U2 database and tools assets to Rocket Software, a global software development firm, based in Newton, Mass. "The entire U2 team worldwide is moving from IBM to Rocket," Susie Siegesmund, director, IBM U2 Data Servers and Tools, IBM Information Management Software, tells DBTA, reiterating sentiments expressed in a letter to customers when the sale was announced, in which she assured them that the change of ownership will be a benefit to U2's product line as well as customers and business partners and will not affect relationships with the U2 business.
Posted October 13, 2009
In this season of recession and financial meltdowns, a common question seems to be, "How big is ‘too big to fail'?" Titans of the financial industry made big bets with lots of risk and, when they didn't pan out, American society overall has to pay the price. But, that aside, the very scale of our financial system, by just about every metric, has reached amazing heights, be that number of financial transactions per second, number of traders, number of funds traded, amount of money changing hands—you name it. This might seem like a tangent to the point of databases in general and SQL Server in particular, but there are actually quite a few similarities in my mind.
Posted October 13, 2009
As my regular readers know, I am an avid reader, especially of technology books. And every now and then I review some of the more interesting database-related books in the DBA Corner column.
Posted October 13, 2009
The art of building software solutions is comprised of many moving parts. There are project managers coordinating tasks; business analysts gathering requirements; architects establishing standards and designs; developers assembling processes; DBAs building database structures; quality assurance staff testing components for compliance to requirements; and an array of supporting roles providing for functional environments, infrastructure, security, etc. A common task that everyone must perform is estimating the effort necessary to deliver results. Certainly for simple and/or repetitive tasks there is no need for recurrent estimating, since applicable values are based on past known metrics. For example, creating the third or fourth version of the same database within the same environment should allow a DBA to incorporate costs experienced previously as a guide. And unless something unusual occurs, such estimates should be on target. However for creative tasks, such as designing new structures, or building new kinds of processes, there will be no previous documented events to refer to. Faced with these circumstances, individuals usually are not allowed to shrug and say, "it will take as long as it takes," and be left alone.
Posted October 13, 2009
The Sarbanes-Oxley Act of 2002 (SOX) can be considered the most significant compliance standard of our time. Since the passing of the legislation 7 years ago, companies have had to rethink the way they use technology to store company data. This transformation has been anything but an easy ride for companies today, and has significantly impacted the role of the CIO within an organization.
Posted October 13, 2009
In art, the expression "less is more" implies that simplicity of line and composition allow a viewer to better appreciate the individual elements of a piece and their relationship to each other to make a whole. In engineering, "less is more" when you accomplish the same work with fewer moving parts. And when dining out, "less is more" when the portions may be smaller, but the food is so much better and satisfying. In IT, the adage is more accurately stated today as "less does more." As IT increases in complexity, mainframe organizations are being asked to handle greater workloads, bigger databases, more applications, more system resources, and new initiatives. All this, without adding—and sometimes while cutting—staff. In addition, IT is undergoing a serious "mainframe brain drain," as the most experienced technicians retire, taking with them their skills and detailed knowledge of the mainframes' idiosyncrasies.
Posted October 13, 2009