Database Management Articles
Delphix has introduced the latest release of its database virtualization software for agile data management, which adds new support for Oracle Exadata, and also extends support for legacy versions of Oracle databases to support customers who want to upgrade and migrate from old to new.
Posted April 18, 2012
Oracle plans to hold a MySQL conference on September 29 and 30, just prior to Oracle OpenWorld 2012, which will be held in San Francisco from September 30 to October 4. In addition, Oracle has announced a new Development Milestone Release (DMR) for MySQL 5.6.
Posted April 18, 2012
Oracle has announced StorageTek Tape Analytics, monitoring and management software for its StorageTek tape libraries. The software is intended to simplify tape management by eliminating manual intervention and help improve operational efficiency. It captures library, drive and media performance metrics and presents them in a single pane of glass, identifying potential problems while providing immediate recommendations to prevent data loss. StorageTek Tape Analytics software also allows rapid drill-down into detailed drive and media health specifics, enabling customers to make decisions about their tape infrastructure, and reduce downtime and data management resources.
Posted April 18, 2012
Organizations are populated with solutions entitled DW, EDW, BIC, ODS, EIW, IW, CIF, or BW. Why must every organization have a data warehousing or analytics solution identified by monikers from a very limited pool of choices? Why must every deployment of a database that is expected to function as an operational data store be called ODS? For internal solutions it seems that plain and dreary naming approaches are de rigueur. Two and three letter acronyms have long been a part of corporate-speak; but when it comes to IT systems, these TLAs have become exceedingly narrow and soul-less.
Posted April 18, 2012
Continuent, Inc., a provider of replication and clustering solutions for MySQL and Oracle, has introduced Continuent Tungsten Enterprise 1.5 to help manage increasing data volume, complexity, speed, and concurrency in the cloud or on-premise. "Tungsten Enterprise consolidates geo-clustering, archive, backup and disaster recovery through seamless integration with the cloud," says Robert Hodges, CEO at Continuent. "By combining multi-master, multi-site clustering with Amazon EC2, Tungsten Enterprise enables new levels of speed, simplicity and reliability for database clustering, backup and recovery while reducing costs."
Posted April 12, 2012
IBM introduced PureSystems, a new family of "expert integrated systems," with built-in expertise based on IBM's decades of experience running IT operations for tens of thousands of clients in 170 countries. With the aim of integrating all IT elements, both physical and virtual, IBM says the new systems offer clients an alternative to today's enterprise computing model, where multiple and disparate systems require significant resources to set up and maintain. According to IBM, PureSystems is the result of $2 billion in R&D and acquisitions over 4 years.
Posted April 11, 2012
Oracle addressed the need to make IT infrastructure and business analytics technologies simpler and more efficient in a presentation to OpenWorld Tokyo 2012 attendees that was also made available via live webcast. In addition to presenting its strategy and plans for business analytics, the company also unveiled new additions to its product portfolio. In his keynote address, Oracle president Mark Hurd explained how the business users of tomorrow will require faster and more comprehensive information access. "The true question with analytics is how to get the right information to the right person at the right time to make the right decision," he said.
Posted April 11, 2012
Oracle extended its Business Analytics portfolio, with the announcement of two new Oracle Business Intelligence Applications, Oracle Manufacturing Analytics and Oracle Enterprise Asset Management (EAM) Analytics. According to Oracle, these are the first and only analytic applications for manufacturing and asset management analysis and will enable customers and partners serving manufacturing, energy production, utilities and other asset-intensive industries to gain better insights and make decisions faster. Oracle says both solutions provide support for large numbers of concurrent users and are certified to run on Oracle Exalytics In-Memory Machine. Native support for tablet and mobile devices, such as the Apple iPad and iPhone is also provided.
Posted April 11, 2012
Oracle announced two x86 world record benchmark results delivered by its software and hardware. An x86 world record result was achieved on the SPECjEnterprise2010 benchmark, with Oracle WebLogic Server 12c, Oracle Database 11g Release 2, running Oracle Linux on Oracle's Sun Fire X4800 M2 server. In addition, an x86 world record TPC-C benchmark result was set with the Sun Fire X4800 M2 server, running Oracle Linux with the Unbreakable Enterprise Kernel Release 2, Oracle Tuxedo, and Oracle Database 11g Release 2.
Posted April 11, 2012
Last month, I told you about my favorite master-level blogs for the SQL Server professional. This month, I'm reviewing my favorite blogs for working SQL Server professionals who seriously want to grow their skills. What's the difference between a master-level blog and a practitioner-level blog, you ask?
Posted April 11, 2012
An important aspect of database security is designing your applications to avoid SQL injection attacks. SQL injection is a form of web hacking whereby SQL statements are specified in the fields of a web form to cause a poorly designed web application to dump database content to the attacker. Stories abound in the news where SQL injection was used for nefarious purposes. Several high-profile cases over the past few years impacted government websites, Microsoft in the U.K., a Swedish election, PBS (the Public Broadcasting System), and Lady Gaga's website (among many others).
Posted April 11, 2012
Attivio and TIBCO Software Inc. have announced that, as part of a new partnership agreement, the TIBCO Spotfire analytics platform has achieved the highest level of information access available within Attivio's Active Intelligence Engine (AIE). According to Attivio, its AIE ingests all types of structured data and unstructured content, and unlike a traditional data warehouse, does not require relationships between any data or content to be defined in advance prior to ingestion. In achieving platinum-level certification, Attivio says TIBCO Spotfire has been authenticated by Attivio to be able to present, analyze, access and leverage AIE's AI-SQL capabilities to provide data visualization, enhanced analytics of unstructured content and intuitive search and discovery, all in the same dashboard.
Posted April 10, 2012
IBM has introduced DB2 10 and InfoSphere Warehouse 10 software that integrates with big data systems, automatically compresses data into tighter spaces to prevent storage sprawl, and slices information from the past, present, and future to eliminate expensive application code. Over the past 4 years, more than 100 clients, 200 business partners, and hundreds of experts from IBM Research and Software Development Labs around the world collaborated to develop the new software.
Posted April 10, 2012
Oracle Corporation announced that GAAP total revenues for fiscal 2012 Q3, which ended Feb. 28, were up 3% to $9.0 billion, and non-GAAP total revenues were up 3% to $9.1 billion. Among the highlights for the quarter were Oracle's engineered systems. Hardware revenue for engineered systems grew 139% in the third quarter and bookings are strong going into the fourth quarter, said Oracle president Mark Hurd in a statement released by the company with the announcement of its quarterly financial results.
Posted April 04, 2012
Organizational focus has been placed on the emergence of "big data" - large-scale data sets that businesses and governments use to create new value with today's computing and communications power. Big data poses many opportunities, but managing the rapid growth adds challenges, including complexity and cost. Leaders must address the implications of big data, increasing volume and detail of information captured by enterprises, the rise of multimedia, social media, and the internet.
Posted April 04, 2012
For 2012, the traditional TechWave content will be incorporated into SAP TechEd, October 15-19 at the Venetian Hotel in Las Vegas, NV. There will continue to be targeted training on Sybase products, plus access to TechEd keynote sessions, exhibits, special event and other networking functions.
Posted March 29, 2012
Oracle Database 11g Release 2 (R2) and Oracle Fusion Middleware 11g Release 1 (R1) are immediately available on Oracle Linux 6 with the Unbreakable Enterprise Kernel. Oracle Database 11g R2 and Oracle Fusion Middleware 11g R1 will be available on Red Hat Enterprise Linux 6 (RHEL6) and Oracle Linux 6 with the Red Hat Compatible Kernel in 90 days.
Posted March 28, 2012
Oracle has announced that its Sun ZFS Storage 7320 appliance has extended its storage leadership by delivering outstanding performance on the SPECsfs2008_nfs benchmark. The Sun ZFS Storage 7320 appliance achieved 134,140 SPEC SFS2008_nfs ops/sec at an Overall Response Time of 1.51 milliseconds for file serving in a mixed workload environment. "This SPECsfs2008 result is further proof that the Sun ZFS Storage Appliance delivers a significant increase in performance at a fraction of the cost of competitive solutions,"says Phil Bullinger, senior vice president, Storage, Oracle.
Posted March 28, 2012
There's no question that cloud computing is a hot commodity these days. Companies of all types and sizes are embracing cloud computing-both internally and from external service providers - as a way to cost-effectively build new capabilities. With the rapid growth of cloud comes new questions about responsibility within organizations, in terms of how services will be paid for, who has ultimate say over cloud decisions, and how cloud fits into the overall strategic direction of the business.
Posted March 28, 2012
Citrusleaf, a real-time, distributed NoSQL database technology provider, has announced the immediate availability of Cross Datacenter Replication (XDR), a new product that enables flexibility for running real-time applications easily and seamlessly from different data centers. XDR runs on Citrusleaf 2.0, the company's flagship database platform for high-volume, data-intensive, web-scale and mobile businesses such as digital advertising.
Posted March 28, 2012
Clinical Data Management (CDM) is a company headquartered in Colorado that provides clinical information database software, enabling medical institutions to report and compile data on patient care. A longtime user of Revelation Software, dating back to Revelation G and continuing through OpenInsight, CDM was pleased with both the quality of the products and the service from Revelation. However, CDM had come to realize it needed to provide a web interface for data entry to better support its customers and also stay current with evolving technology requirements. That need was answered when Revelation launched the OpenInsight for Web (O4W) Development Toolkit, a web development toolkit that makes it possible for OpenInsight developers with limited or no HTML, XML or JavaScript experience to develop feature-rich web pages.
Posted March 28, 2012
Schooner Information Technology, Inc., a developer of high-availability, high-performance SQL database software, has released the latest version of its software cache and persistent data store, Membrain 4.0. Running on Dell, HP, and IBM x86 servers and optimized to take advantage of flash memory and modern multi-core processors, the latest release of Membrain aims to deliver 10x server consolidation, thus simplifying capacity and performance scale out in data centers.
Posted March 27, 2012
RainStor, a provider of big data management software, is joining with IBM in the big data market. RainStor will work with IBM to deliver a solution that combines IBM's enterprise-class, Hadoop-based product, InfoSphere BigInsights, with RainStor's Big Data Analytics on Hadoop product to enable faster, more flexible analytics on multi-structured data, without the need to move data out of the Hadoop environment. According to the vendors, the new combined solution can reduce the TCO for customers by significantly reducing physical storage, and also improving the performance of querying and analyzing big data sets across the enterprise.
Posted March 27, 2012
MarkLogic Corporation has joined the technology partner program of Hortonworks, a leading vendor promoting the development and support of Apache Hadoop. According to the vendors, by leveraging MarkLogic and Hortonworks, organizations will be able to seamlessly combine the power of MapReduce with MarkLogic's real-time, interactive analysis and indexing on a single, unified platform. There are two main reasons that MarkLogic has chosen to partner with Hortonworks, says Justin Makeig, senior product manager at MarkLogic. One is Hortenworks' extensive experience with Hadoop installations and the second is that its core product is 100% open source.
Posted March 21, 2012
As IT departments strive to lower costs while operating more efficiently organizations are seeking efficient ways to ensure that data in their VMware environments is properly protected, according to Quest Software and ExaGrid Systems, which are marketing a joint virtual data protection solution. Using Quest vRanger in tandem with ExaGrid's disk backup appliance, the vendors say, provides customers with an efficient, disk-based backup solution tailored to meet the specific needs of VMware virtual environments.
Posted March 20, 2012
For enterprises grappling with the onslaught of big data, a new platform has emerged from the open source world that promises to provide a cost-effective way to store and process petabytes and petabytes worth of information. Hadoop, an Apache project, is already being eagerly embraced by data managers and technologists as a way to manage and analyze mountains of data streaming in from websites and devices. Running data such as weblogs through traditional platforms such as data warehouses or standard analytical toolsets often cannot be cost-justified, as these solutions tend to have high overhead costs. However, organizations are beginning to recognize that such information ultimately can be of tremendous value to the business. Hadoop packages up such data and makes it digestible.
Posted March 19, 2012
Oracle has unveiled Oracle Airline Data Model, a standards-based, pre-built database schema to help airlines optimize the collection, storage, and analysis of passenger data from reservations, sales, operations, loyalty, customer service and finance in their data warehouse. Available as an option for Oracle Database 11g Enterprise Edition, the new Oracle Airline Data Model delivers a comprehensive database schema for passenger data, sophisticated analytics, trending and data mining capabilities.
Posted March 14, 2012
Oracle has announced the availability of Oracle Exalytics In-Memory Machine, a high-speed engineered system featuring in-memory business intelligence software and hardware. Oracle Exalytics features a new release of Oracle BI Foundation Suite and Oracle TimesTen In-Memory Database for Exalytics enhanced for an Oracle Sun server designed for in-memory analytics. According to Oracle, the interactive real-time analysis enabled by Oracle Exalytics, is intended to enable organizations to maximize profitability, increase revenues and market share, and react more quickly to changing business conditions.
Posted March 14, 2012
Quest Software said it has entered into definitive agreements with affiliates of Insight Venture Partners to become a private company. In the deal, stockholders would receive $23 per share in cash, valuing the company at approximately $2.0 billion. Upon closing, Quest will be a privately held company and will continue to be led by chairman and CEO Vinny Smith and the existing senior management team. "As a private company, we will have increased flexibility to drive innovation across our product lines and execute our long-term strategy," said Smith in a statement released by the company.
Posted March 09, 2012
Schooner Information Technology, Inc., which develops and markets high-performance SQL database software, and Ispirer Systems, a provider of multi-platform database migration solutions, have formed a partnership to facilitate migrations from other databases to SchoonerSQL. "Partnering with Ispirer removes the barrier of complexity from migrations to SchoonerSQL - allowing a broader range of database customers to consider Schooner either for net new deployments or wholesale migrations," says Pavan K. Venkatesh, Schooner information technology director of product management and strategy.
Posted March 09, 2012
MapR Technologies and Informatica have announced joint support for MapR's distribution for Hadoop with the Informatica Platform. In addition, Informatica HParser Community Edition which is available for free will be available for download as part of the MapR distribution from the MapR website. The MapR distribution is also available through the EMC Greenplum MR Edition and Cisco UCS.
Posted March 08, 2012
Continuent, Inc., a provider of replication and clustering solutions for open source databases, and SkySQL Ab, a provider of solutions for the MySQL database in the enterprise and cloud, have announced a strategic partnership. SkySQL will provide its MySQL database software, services and support to customers of Continuent's Tungsten Enterprise, a complete clustering and data management solution for MySQL, and Tungsten Replicator, an advanced data replication solution.
Posted March 08, 2012
As a DBA, it is almost inevitable that you will change jobs several times during your career. When making a job change, you will obviously consider requirements such as salary, bonus, benefits, frequency of reviews, and amount of vacation time. However, you also should consider how the company "treats" their DBAs. Different organizations place different value on the DBA job. It is imperative to your career development that you scout for progressive organizations that understand the complexity and ongoing learning requirements for the position.
Posted March 07, 2012
Datameer, Inc. has announced a relationship with Microsoft Corporation to support Datameer on the Apache Hadoop-based service on Windows Azure. The new relationship enables Windows Azure users to perform big data analytics with Datameer's BI platform, and Datameer's customers to run and deploy their solutions on Microsoft's Hadoop-based service on Windows Azure.
Posted February 29, 2012
At the Strata Conference today Calpont anounced InfiniDB 3, the latest release of its high performance analytic database. Designed from the ground up for large-scale, high-performance dimensional analytics, predictive analytics, and ad hoc business intelligence, the new release includes capabilities to capitalize on a variety of data structures and deployment variations to meet organizations' need for a flexible and scalable big data architecture.
Posted February 29, 2012
InterSystems Corporation, a provider of software for connected care, announced that LOGICARE Corp. has migrated its top-tier patient instruction software system to the InterSystems Ensemble rapid integration and development platform. The transition is the first phase of a corporate strategy to cut costs and provide seamless connectivity by using Ensemble to handle HL7 messaging for all customer deployments.
Posted February 28, 2012
Varonis Systems Inc., a provider of data governance solutions and metadata framework technology, is set to release a solution with Varonis DatAdvantage, DataPrivilege and IDU Classification Framework and HP IBRIX X9000 Storage Systems in March. The pairing of the Varonis solution with HP IBRIX X9000 will allow for greater visibility into permissions, safe removal of excessive permissions, detailed audit trails of files, data ownership identification, actionable intelligence on the location of sensitive data, and sensitive content analysis.
Posted February 28, 2012
Tableau Software, a provider of business intelligence software, and Cloudera Inc., a provider of Apache Hadoop-based data management software and services, have announced integration between the two companies that provides enterprises with capabilities to more easily extract business insights from their big data without needing the specific technical skills typically required to operate Hadoop. Tableau has developed a Certified Cloudera Connector that is licensed to work with Cloudera's Distribution Including Apache Hadoop (CDH). The new connector is part of the Tableau 7.0 release.
Posted February 24, 2012
Oracle has announced the availability of Oracle Advanced Analytics, a new option for Oracle Database 11g that combines Oracle R Enterprise with Oracle Data Mining. According to Oracle, Oracle R Enterprise delivers enterprise class performance for users of the R statistical programming language, increasing the scale of data that can be analyzed by orders of magnitude using Oracle Database 11g.
Posted February 23, 2012
BMMsoft Corporation, a provider of real-time analytic software that automates the storing, integration, management and analysis of big data, has announced the availability of high-speed EDMT 9 for large enterprises, which it says can be deployed instantly and without intensive programming needed by other big data systems. The combination of EDMT 9, Sybase IQ 15.4 and HP Proliant DL 980 Server and cloud, on-premise or hybrid deployment offers the big data functionality to large enterprises that need quick deployment and can't spend time on long development projects, according to Paul Krneta, CTO of BMMsoft.
Posted February 22, 2012
Sybase 365, a subsidiary of Sybase, Inc., has unveiled the 2012 edition of the Sybase Mobile Commerce Guide. "Mobile commerce is reaching a major inflection point," says John Sims, president, Sybase 365. "The developing world has quickly embraced mobile commerce based on a need to access financial services, and the developed world is catching up as regulators start to reform existing banking and transaction rules. Our guide captures practical, real-world depictions of mCommerce in action, which showcases the rapidly growing evolution of commerce within a robust and innovative mobile ecosystem."
Posted February 22, 2012
Like TechWave 2011, TechWave will be co-located with SAP TechEd in 2012. This year's conference will be held at the Venetian Hotel in Las Vegas, Nev., October 15 to 19.
Posted February 22, 2012
SAP AG has announced two new offerings that will offer the benefits of the SAP HANA platform to small businesses and midsize enterprises (SMEs). With analytics powered by SAP HANA for the SAP Business One application and SAP HANA, Edge edition, SMEs will be able to leverage in-memory technology from SAP. The new offerings from SAP aim to provide SMEs with real-time access to information tailored to their individual requirements.
Posted February 22, 2012