Database Management Articles
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. O4W 1.0 was released earlier this year as part of the latest release of OpenInsight. "When we released O4W 1.0, which was within our OpenInsight 9.2 release, we received so much feedback - not only to the initial release but even during the beta testing phase," says Robert Catalano, director of sales at Revelation, that Revelation had to stop the development of O4W at a certain point in order to get the documentation in sync. This resulted in a backlog of features that needed to be included, "and they are showing up now in the 9.2.1 release," he tells 5 Minute Briefing.
Posted September 22, 2010
Rocket Software is offering two webinars in October. The first is an overview of the upcoming U2 University event, to be held in Denver, November 9-11. Registration is now open for Oct 6, 2010 9 am MDT and Oct 6, 2010 4 pm MDT.
Posted September 22, 2010
InterSystems Corporation will next week roll out a new version of its Caché high-performance object database. The new release targets the growing demand by CIOs for economical high availability by introducing database mirroring, while also now addressing Java developers' need for high-volume high-performance processing combined with persistent storage for event processing systems. Robert Nagle, InterSystems vice president for software development, recently chatted with 5 Minute Briefing about the release and the new features it offers. Commenting on the growing interest in NoSQL databases, Nagle observes that many of the beneficial characteristics people see in NoSQL are in fact true of Caché - a flexible data model and zero DBA cost. "But for us, what is unique is that it is not NoSQL, it is that it needs to be SQL - without the overhead of relational technology - because I think SQL is extremely important for almost every class of application that is deployed."
Posted September 22, 2010
Application Security, Inc., a provider of database security, risk and compliance (SRC) solutions for the enterprise, has announced the addition of Rights Management to its flagship enterprise platform, DbProtect. Determining who has rights to what data can be a laborious task and it is something that many organizations avoid because they think the task is impossible to complete, Josh Shaul, vice president of product management, AppSec, tells 5 Minute Briefing. "We realized we could solve the problem very effectively with software." The new Rights Management module allows information security analysts, business managers, and database administrators (DBAs) to automate user entitlement reviews in enterprise database environments, and also enables organizations to meet compliance regulations mandating the implementation of strong access control measures, such as those required by the Payment Card Industry - Data Security Standard (PCI-DSS.)
Posted September 21, 2010
EnterpriseDB, which provides products, services, support and training based on the PostgreSQL open source database project, has announced support for the newly released PostgreSQL 9.0 open source relational database. PostgreSQL 9.0 includes more than a dozen major improvements that enhance every aspect of database application design and performance, including built-in replication and hot standby capabilities that give PostgreSQL 9.0 the high availability required for the "scale out" and failover architectures that characterize cloud computing and other demanding application environments, as well as 64-bit Windows support. The new release also that simplifies major upgrades by removing the need for the "dump/load data" procedure required in prior versions and instead performs an in-place upgrade, which is much easier and faster.
Posted September 21, 2010
InterSystems Corporation will next week roll out a new version of its Caché high-performance object database. The new release targets the growing demand by CIOs for economical high availability by introducing database mirroring, while also addressing Java developers' need for high-volume high-performance processing combined with persistent storage for event processing systems. Robert Nagle, InterSystems vice president for software development, recently chatted with 5 Minute Briefing about the release and the new features it offers. Commenting on the growing interest in NoSQL databases, Nagle observes that many of the beneficial characteristics people see in NoSQL are in fact true of Caché - a flexible data model and zero DBA cost. "But for us, what is unique is that it is not NoSQL, it is that it needs to be SQL - without the overhead of relational technology - because I think SQL is extremely important for almost every class of application that is deployed."
Posted September 21, 2010
Symantec Corp. announced the availability of Symantec Enterprise Vault 9.0 and Enterprise Vault Discovery Collector, technology to help organizations store, manage and discover information across the enterprise. The vendor also announced NetBackup 5000 deduplication appliance and cloud storage for NetBackup and Backup Exec to help organizations reduce their data storage footprints and more effectively leverage cloud-based data storage services.
Posted September 20, 2010
Oracle has introduced Oracle GoldenGate 11g and Oracle Data Integrator Enterprise Edition 11g, new releases of the two products that form the foundation of Oracle's data integration product line. The new products, part of the Oracle Fusion Middleware product family, offer tighter integration with Oracle applications and technologies, support for additional heterogeneous systems, and improved performance.
Posted September 15, 2010
Enhancing its portfolio of desktop virtualization solutions, Oracle has announced Oracle Secure Global Desktop 4.6, a solution that delivers server-hosted applications and desktops to client devices, enabling businesses to manage applications centrally in the data center, resulting in higher security, decreased operational costs, and increased mobility.
Posted September 15, 2010
Idera, a provider of Microsoft SQL Server management and administration solutions, has announced the public beta of Idera SQL doctor 1.1, a new tool for database administrators (DBAs) and database developers that collects SQL Server configuration and run-time information, analyzes the results, pinpoints problems, and provides immediate prioritized recommendations to resolve identified SQL Server performance problems.
Posted September 14, 2010
Fewer than 30% of the 430 respondents to a new survey conducted by the Independent Oracle Users Group (IOUG) say their organizations are encrypting personally identifiable information in all their databases. Although that percentage is up slightly from last year, the finding is surprising given the number of existing data privacy and protection mandates that specifically call for data-at-rest encryption.
Posted September 09, 2010
The promises of public cloud computing - pay as you go, infinite scale and outsourced administration - are compelling. However, for most enterprises, security, geography and risk mitigation concerns make private cloud platforms more desirable. Enterprise customers like the idea of on-demand provisioning, but are often unwilling to take the performance, security and risk drawbacks of moving applications to remote hardware that is not under their direct control.
Posted September 07, 2010
Oracle is a fast-changing company, and in recent years, its pace has accelerated to blinding speed. The software giant has expanded well beyond its relational database roots to encompass applications, management tools, service-oriented architecture and middleware, and even hardware. There are now many components to Oracle - from three major databases, to enterprise resource applications, to web applications to development languages to open source desktop tools.
Posted September 07, 2010
Brent Ozar achieved SQL Server 2008 Master status earlier this year, becoming the fifth person in the U.S. outside of Microsoft to achieve the company's highest technical certification. A Quest Software SQL Server expert at the time, Ozar has since joined SQLskills.com, a provider of training and consulting focused on Microsoft SQL Server, as a principal consulting partner. In this issue, he provides an arcane gliimpse into the intense 3-week-long onsite program that include the most difficult exams he had ever seen.
Posted September 07, 2010
As databases are established, particularly databases intended to support analytics initiatives, responsibilities for the design must include articulating the planned approaches for enhancing and scaling the database over time. If a database is created to express a multidimensional data warehouse bus architecture, or a corporate information factory, or anything else, the explanation of this connection should exist somewhere. Such documentation should also expand on why things were decided as they were and the expected stylings to be associated with proposed enhancements. Descriptions involving anticipated processing patterns extend naturally from such architecture artifacts. Database and application design personnel should work together in the creation of such credentials to ensure these documents thoroughly cover the needs of the personnel involved in building and maintaining the solution.
Posted September 07, 2010
It's almost hard to believe I've been your columnist for Microsoft SQL Server topics for more than 5 years! As an analyst of Microsoft SQL Server, as well as one who's interested in the whole spectrum of database systems, I've tried to provide insight for the questions of "how" and "why" Microsoft has made the choices it has in crafting SQL Server. After all, understanding the context and motivation for a particular set of features-or a particular marketing strategy-can help you fully understand the best choices for your own internal IT strategies and projects.
Posted September 07, 2010
Database systems require data files to store the data under management. These files, or data sets, reside on storage media. So storage management should be a key part of the database operations required of a database administrator (DBA). Unfortunately, storage is sometimes relegated to an afterthought; after all, don't we have storage administrators who deal with our disk arrays? But this way of thinking is misguided. To succeed, database administration and storage administration need to cooperate and work together.
Posted September 07, 2010
Interest in and adoption of open source databases continues to dramatically increase. This truth was recently underscored for me when I sat down with one of the top industry analysts who covers the database market. Among the many interesting data points we discussed were the fact that his company has seen a 50% increase in open source database inquiries in the past 18 months and that more than 80% of corporations are looking to use open source databases in their infrastructures, including companies in the Fortune 100.
Posted September 07, 2010
Many organizations now have, in their possession, the sophisticated analysis tools and dashboards that connect to back-end systems and enable them to peer deeply into their businesses to assess progress on all fronts-from revenues to stock outs to employee performance. However, a recent survey of 279 Oracle applications managers reveals that when it comes to decision making, simple spreadsheets still remain the tool of choice. And business users still wait days, weeks, and months for their IT departments to deliver reports, despite significant investments in performance management systems.
Posted September 07, 2010
Oracle yesterday announced that Mark V. Hurd has joined Oracle as president and has been named to Oracle's board of directors. Hurd will report to Oracle CEO Larry Ellison. "Mark did a brilliant job at HP and I expect he'll do even better at Oracle," said Oracle CEO Larry Ellison, in a statement commenting on Hurd's hire. "There is no executive in the IT world with more relevant experience than Mark. Oracle's future is engineering complete and integrated hardware and software systems for the enterprise. Mark pioneered the integration of hardware with software when Teradata was a part of NCR."
Posted September 07, 2010
Quest Software, Inc. announced today that it has added Apache Cassandra, an open source NoSQL database, to its list of supported NoSQL platforms with the second beta release of Toad for Cloud Databases. Toad now supports data access and management for Apache Cassandra, Amazon SimpleDB, Microsoft Azure Table Services, Apache HBase, and any open database connectivity-enabled relational database.
Posted September 07, 2010
InterSystems Corporation, a leader in software for connected healthcare, has announced that its customer, LifePoint Informatics, has moved its flagship LifePoint InfoHub to the InterSystems Ensemble rapid integration and development platform. InterSystems' application partner LifePoint, based in Glen Rock, N.J., provides outreach business applications and electronic medical record and health information exchange integration. The migration to Ensemble has enabled LifePoint to grow its business an estimated 40% since 2008, according to the company.
Posted September 07, 2010
EnterpriseDB, which provides products, services, support and training based on the PostgreSQL open source database project, has received a strategic investment from KT (formerly Korea Telecom) and has accepted venture capital funding from new investment partner TransLink Capital. EnterpriseDB says the new funding will enable it to expand its product and marketing operations to capitalize on the upheaval in the database market caused by consolidation and an enterprise platform shift to virtualized and cloud infrastructure.
Posted September 07, 2010
MarkLogic Corporation has announced that MarkLogic Server has earned Common Criteria Certification from an unbiased independent evaluator. MarkLogic Server has been validated in accordance with the provisions of the National Information Assurance Partnership (NIAP) Common Criteria Evaluation and Validation Scheme (CCEVS) for IT Security, an IT security certification program.
Posted September 07, 2010
Mythics, Inc. has announced that it has been awarded a letter of supply to resell the Oracle Exadata platform from Oracle. Mythics is an Oracle PartnerNetwork Platinum Partner, Oracle GSA Schedule Holder (GS-35F-0153M), and Oracle Value Added Reseller (VAR). The letter of supply will allow Mythics to sell the Oracle Exadata platform via their own GSA Schedule contract.
Posted September 02, 2010
Oracle has announced a full line-up of partner events and activities at Oracle OpenWorld 2010 in San Francisco. The week kicks off with the Oracle PartnerNetwork (OPN) Forum, and will be followed by a series of Partner Pavilions and partner-only sessions, throughout the conference that will allow partners to share successes, showcase solutions and capabilities, increase customer and prospect visibility, and learn about new opportunities for business growth with Oracle.
Posted September 02, 2010
Oracle recently hosted a 6-hour online forum to showcase its strategy for virtualization. Oracle's Edward Screven, chief corporate architect, and John Fowler, executive vice president, Systems, kicked off the agenda of analyst, customer and product webcasts, by explaining how Oracle delivers a complete virtualization offering, all the way from desktop through the data center and why that approach provides more customer benefits than point solutions.
Posted September 02, 2010
The Rocket U2 Denver team is moving its offices. According to the company, customers should see minimal-to-no disruption in service during the relocation, as the U2BC system and U2 websites are hosted at another Rocket site. Starting Monday, August 30, the new address will be 4600 S. Ulster Street, Suite 1100, Denver, Colo., 80237. All phone numbers and email addresses remain the same.
Posted August 25, 2010
Entrinsik has announced that, at the recommendation of its solution provider, Progenixx, the Everett Housing Authority (EHA) has selected Entrinsik's Informer Web Reporting software. For over 60 years, EHA has served the housing needs of the people of Everett, Wash. Critical to supporting this commitment is the ability to provide its staff across four departments with information that is up-to-the-minute and easily accessible in order to optimize decision making without burdening IT with numerous custom report requests.
Posted August 25, 2010
The latest version of Sybase Unwired Platform, 1.5.2, that will enable enterprise developers to simply and quickly build applications that connect business data from more sources, including SAP applications, to mobile workers on any device, is now available.
Posted August 25, 2010
Sybase, Inc., an SAP company, recently announced the continued growth of the Sybase(R) IQ partner ecosystem. Through key relationships with companies such as Bradmark Technologies, Fuzzy Logix, ISYS Search Software, Kapow Technologies, SAS, Tableau Software, and Zend Technologies, Sybase IQ analytics server continues to support the demanding analytics environments of its more than 1,800 customers and 3,200 installs worldwide.
Posted August 25, 2010
At an event last week co-located in Boston and Frankfurt, company leaders from SAP AG and Sybase came together for the first time to share the strategy and joint product direction for the newly combined companies. SAP confirmed that Sybase will be run as a separate, independent unit - and that customer investments in Sybase products will be preserved and supported.
Posted August 24, 2010
Idera, a provider of Microsoft SQL Server management and administration solutions, has announced Idera SQL admin toolset 1.5, a set of 25 desktop tools for monitoring, troubleshooting, administering and reporting on SQL Server.
Posted August 24, 2010
Canonical Ltd., the company behind Ubuntu, has launched a virtual appliance of IBM's DB2 Express-C software running on the Ubuntu cloud computing platform in private and public cloud configurations. Canonical also announced that IBM has completed validation of the full version of DB2 software on Ubuntu 10.04 Long Term Support Server Edition.
Posted August 18, 2010
Furthering its commitment to desktop virtualization, Oracle announced the newly released Oracle Virtual Desktop Infrastructure 3.2. Oracle Virtual Desktop Infrastructure (VDI) is a complete management, hosting and access solution for virtualized desktops hosted in the data center. By enabling standardized virtual desktop images, Oracle Virtual Desktop Infrastructure helps reduce administration overhead, lover total cost of ownership and increase security.
Posted August 18, 2010
Oracle Database 11g Standard Edition One has delivered a world record price/performance result with the TPC-C benchmark, Oracle announced. Oracle Database 11g Standard Edition One running on an HP ProLiant ML350 G6 server with a single six-core Intel Xeon X5650 2.67 GHz processor with Oracle Enterprise Linux set a world record TPC-C price/performance result of $0.39/tpmC with a performance result of 290,040 tpmC.
Posted August 18, 2010
As part of its Power announcements yesterday, IBM introduced IBM Rational Power Appliance, a family of software appliances comprised of Power Express servers that are pre-loaded and pre-configured with IBM Rational software for AIX development. Available in a range of sizes and programming languages to suit specific user requirements, these ready-to-use systems provide customers a fully-enabled software development environment that can be put to use in a matter of hours.
Posted August 18, 2010
Continuity Software, a provider of disaster recovery (DR) and high availability (HA) management solutions, has announced the general availability of RecoverGuard version 5.2 (v5.2), featuring a Private Cloud Advisor designed to enable customers to ensure availability, recoverability and adherence to industry best practices in the private cloud. "Until about a year ago, no one really used private clouds in the mid and large enterprise for mission-critical systems, but in the last 12 months, we have started to see a shift toward people either deploying such systems or at least planning the deployment of private clouds in the medium and large data centers," Gil Hecht, founder and CEO of Continuity Software, tells 5 Minute Briefing.
Posted August 18, 2010
EnterpriseDB has announced the immediate availability of the latest version of its flagship Postgres Plus Advanced Server database. EnterpriseDB's Postgres Plus Advanced Server 8.4, which is built on the open source object relational Postgres database, is now fully compatible with all the features and functionality found in the most recent community distribution. The new release provides increased core functionality for the database as a whole, increased Oracle compatibility, increased manageability, and increased security, according to Robin Schumacher, EnterpriseDB's director of product strategy.
Posted August 11, 2010
Today, Sybase, Inc., an SAP company, also announced a new HP-Sybase BI (business intelligence) reference architecture that leverages the HP Converged Infrastructure. The joint solution optimizes query response and data loads with reduced overhead, storage costs and maintenance requirements. Featuring Sybase IQ 15 running on HP ProLiant DL785 servers, Sybase says the solution will help organizations looking for high performance, scalability and energy efficiency at a lower TCO than other analytics server offerings.
Posted August 10, 2010
CA Technologies announced new identity and access management (IAM) solutions intended to enhance security, ease compliance efforts, and automate IT processes within cloud computing environments. The company released a new version of CA Identity Manager, which extends identity management to cloud applications, as well as leverage CA SiteMinder portfolio to control access to its SaaS applications.
Posted August 10, 2010
Idera, a provider of Microsoft SQL Server management and administration tools, has announced the latest version of its SQL Server backup and recovery solutions: SQL safe 6.4, SQL safe lite 6.4 and SQL virtual database 1.4.
Posted August 10, 2010
First elected to Oracle Applications Users Group board of directors in 2009, David Ferguson became president of the OAUG this year. He talks with DBTA this month about how the users group is getting "back to basics" with educational sessions and networking opportunities as well as the new approaches it is taking to meet its members' evolving needs.
Posted August 10, 2010
Earlier this year, Andy Flower took over as president of the Independent Oracle Users Group from Ian Abramson. With Oracle OpenWorld right around the corner, Flower talks with DBTA about how the IOUG is changing to best meet the challenges and opportunities presented by the expanding Oracle ecosystem, despite what continues to be a difficult economy. For the IOUG, it is "the year of the member" and it all starts with the database, he says.
Posted August 10, 2010
Revelation Software has announced the availability of a significant new release of OpenInsight (OI) Development Suite, which continues Revelation's commitment to extend OpenInsight by embracing new technologies as well as providing seamless integration with external databases. OI 9.2, which the company has been working on for more than 2 years, includes the new OpenInsight for Web (O4W) and SQL Connector.
Posted August 10, 2010
Design should be an intention, preferably a planned intention. In that intention, design requires more groundwork than a simple thought-train such as the following, "I planned to write a module that functions; since the module functions, my designs are working." Some situations do exist where true design really is less important than successful functionality. Determining the appropriate level of design and preparation offers an interesting question to every architect. At the lowest level, standards and practices present suitable patterns that can serve as a design skeleton for those low-level or isolated items not requiring a heavy-handed blueprint.
Posted August 10, 2010
What is the most difficult thing about acquiring enterprise software? If you are like most IT technicians, your first inclination was probably something related to cost justification. Let's face it, enterprise software typically is very expensive ... and eventually, something will need to bring costs more in line with value.
Posted August 10, 2010
Extending its leadership in the enterprise tape market, Oracle announced high availability and capacity enhancements to its StorageTek tape libraries and drives. New features of the StorageTek SL8500 Modular Library System include an increase in scalable capacity from 70,000 to 100,000 tape slots and redundant electronics to help customers manage growth, increase availability and reduce risk. "Being able to scale to 150 petabytes with up to 100,000 tape slots under the management of a single library is a significant advantage for customers who are dealing with explosive data growth, as many companies are today," Tom Wultich, director of product management for tape at Oracle, tells 5 Minute Briefing.
Posted August 04, 2010
Revelation Software has announced the availability of a new release of OpenInsight (OI) Development Suite. The 9.2 release includes the SQL Connector, which allows SQL tables in relational database management systems including Oracle, SQL Server, and MySQL, to be seen as native tables to all components of OpenInsight, including forms, reports, popups, stored procedures and O4W. "What we have done is built intelligence into the connector so that programmers that have been doing work, not just in OpenInsight, but any flavor of MultiValue, can now use that same knowledge base that they have, and go against data that used to be fairly difficult for them to get at," Mike Ruane, president and CEO of Revelation Software, tells 5 Minute Briefing.
Posted August 04, 2010
Revelation Software has announced the availability of a new release of OpenInsight (OI) Development Suite, which continues Revelation's commitment to extend OpenInsight by embracing new technologies as well as providing seamless integration with external databases.
Posted August 03, 2010