Database Management Articles
DBI Software has introduced pureFeat V6.1 Performance Management Suite for IBM DB2 LUW which adds new capabilities for Stored Procedure Visibility and insight into Current Activity Functions. With Stored Procedure Visibility, DBI is "taking the lid off" the black box, and, with insight into Current Activity Functions, DBI allows users to quickly answer the question, "What's happening right now?" said Scott Hayes, president and founder of DBI Software.
Posted October 13, 2014
SAP and BI provider Birst have formed a partnership to provide analytics in the cloud on the SAP HANA Cloud Platform. This collaboration intends to bring together the next-generation cloud platform from SAP with Birst's two-tier data architecture to provide instant access to an organization's data and help eliminate BI wait time.
Posted October 09, 2014
It is fair to say that relational theory is the only solid framework for establishing a rational expression of data that falls anywhere inside the boundaries of formal logic. As people continue to laud the "death of relational" by coming up with one or other "new" physical implementations of coding or data engines, from object-oriented, XML, columnar, or anything else one might name, the primary short-coming is that these are physical implementations that avoid having any formalized logic underpinning them.
Posted October 08, 2014
One feature of the big data revolution is the acknowledgement that a single database management system architecture cannot meet all needs. However, the Lambda Architecture provides a useful pattern for combining multiple big data technologies to achieve multiple enterprise objectives. First proposed by Nathan Marz, it attempts to provide a combination of technologies that together can provide the characteristics of a web-scale system that can satisfy requirements for availability, maintainability, and fault-tolerance.
Posted October 08, 2014
The PASS Summit, put on each fall by the Professional Association for SQL Server is the biggest SQL Server specific event in the world and it brings in many thousands of people from around the world. Its secret ingredient is the remarkable sense of comradery and overall friendliness of this professional association.
Posted October 08, 2014
Check constraints are supported in all of the major DBMS products, including DB2, Oracle, and SQL Server. But they are too-often ignored and not implemented in production databases. Properly defined, check constraints can provide enhanced data integrity without requiring procedural logic.
Posted October 08, 2014
Today, as never before, public sector agencies have had to become more proactive and operate more like private sector businesses and are required to maintain an immense amount of data in order to make "just in time" decisions as well as to forecast for the long term. This is where business intelligence (BI) tools come in handy—not only to provide systems that facilitate the collection of data, but more importantly, providing a means to sift through the vast amounts of information for which the public sector is custodian.
Posted October 08, 2014
Organizations have been collecting data for years, but never before has there been such urgency to have it immediately available. The business need is pressing—decision makers need up-to-the-minute situational awareness in a volatile global economy.
Posted October 08, 2014
A goal at many organizations is to make the data that matters more broadly accessible to more users in a timely fashion. However, at the same time, enterprise data environments are becoming more complex and costly, running on many platforms, supporting many applications, and handling growing volumes of data. IT is expected to respond quickly to new initiatives that can support the business but as IT environments become more unwieldy, agility is an elusive concept.
Posted October 08, 2014
Oracle CTO Larry Ellison took the stage at the Moscone Center to kick off the Oracle OpenWorld conference on Sunday evening. As he does each year, Ellison outlined major announcements for the week and explained the company's technology vision to set the tone for the conference. Confirming analysts' predictions that 2014 would be the year of the cloud for Oracle, Ellison said 2014 is an inflection point for the company. Ellison's key announcement was Oracle's upgraded platform-as-a-service capability: a fourth generation upward-compatible database.
Posted October 08, 2014
SolarWinds Database Performance Analyzer 9.0 (formerly Confio Ignite) provides database administrators and their IT teams with visibility across the application stack, and now covers storage resources, in addition to database, server, and virtualization resources, to speed identification of application performance bottlenecks and improve end user experience.
Posted October 07, 2014
EnterpriseDB, a provider of enterprise-class Postgres products and database compatibility solutions, today introduced Enterprise DB (EDB) Backup and Recovery Tool (BART), a single tool to set up, manage and automate processes for backup and recovery. The new product is intended to replace the series of complex steps and coding that Postgres users have had to deploy in order to ensure databases back up on schedule, and can be rebuilt.
Posted October 07, 2014
Oracle's new Zero Data Loss Recovery Appliance, unveiled by Oracle executive chairman and CTO Larry Ellison during his opening keynote, is touted as the world's first and only engineered system designed specifically for Oracle Database protection..
Posted September 30, 2014
"Digital disruption" driven by technology is having an impact on the decisions IT organizations are making, Mark Hurd told the audience at the Moscone Center in his first OpenWorld keynote as Oracle CEO. Hurd described the dramatic impact cloud, exploding data volumes, social, business, consumer sophistication, and mobility are having on IT organizations, and then interviewed executives about the individual challenges faced by each, including Yael Cosset of dunnhumby; Stephen Little of Xerox; Jamie Miller of GE; Filippo Passerini of P&G; Kimberly S. Stevenson of Intel Corporation; and Tim Theriault of Walgreen Co.
Posted September 29, 2014
At Oracle OpenWorld, Continuent, a provider of open source database clustering and replication solutions, announced Continuent Tungsten 3.0, a new solution that combines both advanced clustering and replication technologies to meet the transaction processing and analytic needs of the entire business.
Posted September 29, 2014
Attunity recently introduced the next generation of Attunity Maestro, its global-scale information flow management platform, to enable management and monitoring of its updated Attunity Replicate for Oracle.
Posted September 29, 2014
In what is being heralded as an epic change at Oracle, Larry Ellison, the charismatic CEO of Oracle, is stepping down and will be succeeded by Safra Catz and Mark Hurd who will share the CEO position. Despite the widespread pronouncements that this is the end of an era and that Ellison is relinquishing his membership in the exclusive club of rock-star tech leaders that has included Apple's Steve Jobs and Microsoft's Bill Gates, some industry insiders believe that is simply not the case. Ellison, they say, will remain a force to be reckoned with at Oracle.
Posted September 25, 2014
In simpler times, businesses kept their data in one place. That made the data easy to access and control. Today, many large enterprises have a global component to daily business transactions, with customers, partners and employees located around the world. Given the distributed nature of an organization's users and increasing data location regulations, the traditional method of storing data on a central server to support worldwide stakeholders no longer meets business needs.
Posted September 25, 2014
Oracle made two new announcements around NoSQL. It is extending Oracle Enterprise Manager capabilities to MySQL databases. With this new offering, customers can manage complex deployments of Oracle technologies that include MySQL, either on-premise or in a cloud. In addition, Oracle announced a new development milestone release for MySQL 5.7 which extends performance, scalability, reliability and management capabilities. The company also announced several MySQL product releases and early access features, as well as the availability of MySQL source code on GitHub.com.
Posted September 25, 2014
Bradmark Technologies has announced a new Readiness Assessment services program to support new and existing SAP database operations looking to grow or scale their IT infrastructure.
Posted September 24, 2014
Just after Oracle announced that Larry Ellison would take on the role of executive chairman and CTO, and be succeeded as CEO by Safra Catz and Mark Hurd, the three Oracle executives hosted the company's fiscal 2015 Q1 earnings call. Ellison noted that at Oracle OpenWorld, which starts September 27, 2014, the company will be rolling out its new database cloud service with its new multitenant DBaaS offerings. "Our customers and ISVs can move any of their existing applications and databases to the Oracle Cloud with the push of a button," said Ellison.
Posted September 24, 2014
To help customers to meet demanding data challenges, Embarcadero Technologies has announced a major new XE6 release of its portfolio of database tools, including ER/Studio, DBArtisan and Rapid SQL.
Posted September 24, 2014
NuoDB and Guardtime have formed an alliance to eliminate the confines and issues of sharing data on a global scale. According to Guardtime, its Keyless Signature Infrastructure (KSI) provides webscale, mathematical certainty that an enterprise's infrastructure is in the correct state and alerting when it is not. NuoDB is a distributed database designed for global application deployment.
Posted September 23, 2014
Oracle has signed an agreement to acquire Front Porch Digital, a Lafayette, Colorado-based provider of content storage management solutions that help companies migrate, manage and monetize large-scale media assets. According to John Fowler, executive vice president of Oracle Systems, Front Porch Digital's capabilities complement Oracle's existing engineered storage solutions.
Posted September 17, 2014
At Oracle OpenWorld 2014, Oracle executives, customers, and partners will participate in keynote presentations that examine how modern technologies such as cloud computing, big data, and engineered systems are having an impact on businesses globally and supporting innovation. The conference runs September 28 through October 2 at San Francisco's Moscone Center.
Posted September 17, 2014
Recognizing that it is the startups that need enterprise features and high level support more than anyone else, but are least equipped to pay for it, Aerospike Inc. has announced a startup special to attract new customers to its open source flash optimized, in-memory open source NoSQL database. In addition, Aerospike has also announced a new trade-in program, that allows enterprises to swap out certain existing technology for Aerospike Enterprise Edition, for no cost throughout the duration of their standing software and support licenses.
Posted September 16, 2014
When should you scale your database? The short answer often is: Don't scale until you have to. It is important to understand—and exhaust—all of your options for improving database performance first. Here is a look at the common options available.
Posted September 10, 2014
"On occasion, the inmates actually do take over the asylum. Similarly, business personnel can be defeated by their IT peers," writes Todd Schraml. Although some might argue that such an unexpected role reversal cannot happen, it may indeed occur when data architects skilled in their craft can identify the options that help achieve the business goals, versus those alternatives that stifle the business goals. "A good data architect must also be a very good business analyst," he notes.
Posted September 10, 2014
Recounting the evolution of IBM's relational database technology DB2, Craig S. Mullins goes back a full 3 decades in his latest column, starting with the wild and woolly 1980s and ending with DB2 10 and 11 for z/OS as the currently supported versions of DB2, which have added important new functionality.
Posted September 10, 2014
Skimming the newspaper on a recent summer morning, Kevin Kline was astounded to read about Russian hackers' success in grabbing 4.5 million records by way of good, ol' fashioned SQL injection attacks. "This is like saying a bunch of robbers rummaged through 450,000 houses because none of the home owners knew about locking doors and windows. It is that serious and that elementary of a mistake," writes Kline, who outlines security steps that all developers should implement.
Posted September 10, 2014
DataStax, a data management company that provides an enterprise distribution of Apache Cassandra, has scored $106 million in Series E financing. With this new round of funding, DataStax says it plans to continue to drive enterprise adoption and innovation in Apache Cassandra, and will further invest in the developer community, which now spans over 80 countries. DataStax also plans to continue its momentum in Europe, Asia and Japan by rapidly growing engineering, sales and marketing teams in those regions.
Posted September 04, 2014
Broadening the range of tools at its disposal to help customers who are grappling with emerging technologies for leveraging unstructured data, Teradata this week announced its acquisition of Think Big Analytics, a consulting and solutions company that is focused exclusively on Hadoop and open source big data solutions.
Posted September 04, 2014
A new integration service from Jitterbit is aimed at SAP customers who find difficulty with integration of their existing solutions to be the biggest obstacle to incorporating new cloud technologies. The new Jitterbit Harmony SAP Connector helps organizations streamline crucial business processes with SAP integration between SAP ECC, CRM, vertical applications, and more than a thousand enterprise endpoints, ranging from legacy on-premise software to new cloud-based solutions.
Posted September 03, 2014
Providing the opportunity to breathe new life into existing Windows applications, Embarcadero Technologies has launched RAD Studio XE7, a complete solution to build connected apps for Windows, Android, iOS, Mac OS X, gadgets, and wearables.
Posted September 02, 2014
Managing business-critical databases is no easy task even for experienced DBAs, so for IT pros who might be new to the role—and likely already wear multiple other hats within their organization—it can be a challenging endeavor to say the least. Here are the 5 key areas that IT pros who have found themselves in the position of accidental DBAs should focus on.
Posted August 27, 2014
Why do tens of thousands of Oracle customers, partners, and consultants descend on Moscone Center in San Francisco for the annual Oracle OpenWorld conference? Despite the proliferation of conferences and online events competing for attention, OpenWorld remains the single, central place for all things Oracle. Here, DBTA presents the annual Who to See @ Oracle OpenWorld special section.
Posted August 27, 2014
Idera, a provider of application and server management solutions, has updated its SQL Compliance Manager, SQL Diagnostic Manager and SQL Safe Backup products with features that improve ease of use, efficiency and performance for database administrators. Idera has also added new support for Microsoft Hyper-V in SQL Diagnostic Manager so that customers can monitor the performance of physical and virtual server environment across both VMware and Microsoft.
Posted August 26, 2014
Many data integration use cases only require simple transformations—and others don't require any transformations at all. For these scenarios, traditional ETL tools are overly complicated and can't deliver data updates as rapidly as business users need. The priority isn't on the T, but rather on the L—expediting data delivery—so users have fresh, accurate data to make business decisions.
Posted August 19, 2014
Just months after the massive data breaches of the 2013 holiday season, a newly discovered data breach is again shining a spotlight on the need for better enterprise data security and the fact that not enough is being done to secure critical customer data. The most recent headlines involve a Russian crime ring and 1.2 billion user names and passwords as well as at least 500 million email addresses. Against this backdrop, Oracle announced Oracle Key Vault, a software appliance designed to securely manage encryption keys and credential files in the enterprise data center.
Posted August 19, 2014
At the summer 2014 SHARE conference in Pittsburgh, Brian Peterson, who has been president of SHARE for the past two years, spoke about the challenges facing companies today as they deal with emerging IT requirements and the successful approaches for dealing with the mainframe skills shortage. With SHARE's 60th anniversary coming up, Peterson also reflected on the role SHARE has played in the world economy by supporting technology that is critical to industries such as banking, transportation, and manufacturing.
Posted August 18, 2014
Oracle's Exadata Database Machine X4-8 has been enhanced to provide large performance and memory increases compared to the previous generation. Hardware enhancements include 50% more database compute cores, using the Intel Xeon E7 v2 15-core processors, and up to 6TB of memory per compute node for a total of 12TB per rack. The result, says Oracle, is that the Exadata Database Machine X4-8 can consolidate hundreds of databases and can run massive databases entirely in-memory.
Posted August 13, 2014
The Oracle Exastack program is being extended to include the Oracle Big Data Appliance and Oracle Database Appliance, enabling Oracle partners to demonstrate that they have the right infrastructure to manage challenging data environments.
Posted August 13, 2014