DBTA E-EDITION

Subscribe to the DBTA E-Edition email newsletter




DBTA E-EDITION
July 2013

Subscribe to the online version of Database Trends and Applications magazine. DBTA will send occasional notices about new and/or updated DBTA.com content.


Trends and Applications

The Oracle database provides intriguing possibilities for the storing, manipulating and streaming of multimedia data in enterprise class environments. However, knowledge of why and how the Oracle database can be used for multimedia applications is essential if one is to justify and maximize the ROI.

SAP AG and Esri, a geographic information system (GIS) and location analytics provider, are joining forces to more deeply integrate GIS solutions with platforms and enterprise applications from SAP in order to improve business efficiency and decision-making. The ability to combine the added dimension of location information with enterprise data, in real time is aimed at giving businesses greater immediacy in their decision-making capabilities. "We are partnering with the leading GIS vendor in the marketplace, Esri, to provide much deeper integration. We see GIS-related information becoming more important in the future," David Jonker, senior director, Big Data Product Marketing, Technology & Innovation Platform, SAP Labs, tells DBTA.

In the realm of 21st century data organization, the business function comes first. The form of the data and the tools to manage that data will be created and maintained for the singular purpose of maximizing a business's capability of leveraging its data. Initially, this seems like an obvious statement but when examining the manner in which IT has treated data over the past four decades it becomes painfully obvious that the opposite idea has been predominant.

Oracle Database 12c is available for download from Oracle Technology Network (OTN). First announced by Oracle CEO Larry Ellison during his keynote at Oracle OpenWorld 2012, Oracle Database 12c introduces a new multi-tenant architecture that simplifies the process of consolidating databases onto the cloud; enabling customers to manage many databases as one - without changing their applications. During the OpenWorld keynote, Ellison described Oracle Database 12c as "the first multi-tenant database in the world" and said it provides "a fundamentally new architecture" to "introduce the notion of a container database" with the ability to plug in multiple separate, private databases into that single container.

Storage Area Networks (SANs) and Network-Attached Storage (NAS) owe their popularity to some compelling advantages in scalability, utilization and data management. But achieving high performance for some applications with a SAN or NAS can come at a premium price. In those database applications where performance is critical, direct-attached storage (DAS) offers a cost-effective high-performance solution. This is true for both dedicated and virtualized servers, and derives from the way high-speed flash memory storage options can be integrated seamlessly into a DAS configuration. There are three primary reasons now for the renewed interest in NAS.


Columns - Applications Insight

Like many of my generation, my early visions of the future were influenced by films like "2001: A Space Odyssey" and the original "Star Trek" TV series. In each of these, humans interact with computers using conversational English, posing complex questions and getting intelligent relevant responses. So, you can imagine how primed someone like me is to hear that Google has been explicitly trying to create that Star Trek computer. At the Google IO conference in San Francisco in May, Amit Singhal, Google senior vice president, spoke of his early childhood experiences watching "Star Trek," and his dreams of one day building that computer.


Columns - Database Elaborations

One of the principles within relational theory is that each entity's row or tuple be uniquely identifiable. This means the defined structure includes some combination of attributes whose populated values serve to identify an individual row within the table/relation. This, or these, attribute(s) are the candidate key(s) for the structure. The candidate key is also known as the primary key, or if a structure has multiple candidate keys, then one of them is designated as the primary key. When building up a logical design, primary keys should be identified by the actual data points in play.


Columns - DBA Corner

Perhaps the most common question I am asked by readers is "How can I become a DBA?" The question is actually not as simple as it seems and there are many different aspects to the answer. Sometimes it is an application programmer who wants to become a DBA. Sometimes a DBA for one DBMS wants to support a different DBMS; for example, a SQL Server DBA wants to move to become an Oracle DBA. And other times someone with no IT background at all asks the question. The answer is different for all of these folks.


Columns - SQL Server Drill Down

In the last several articles, I've been describing the benefits of reading and analyzing the benchmarking case studies released by the Transaction Processing Council. I've given you from a broad overview of the TPC benchmarks and shown ways that the vendor-published TPC benchmarks can help you save money and how the vendor-published TPC benchmarks must explain in disclaimers how they tweak their workloads. I have described how to run your own benchmarks and explained how to properly prepare your environment for a benchmark test. Now, it is time to show you where the rubber really hits the road, testing and benchmarking tools that can run highly scalable benchmarking workloads against your database servers.


MV Community

Temenos, a provider of software to the financial services industry, has announced that Cairo Amman Bank, a full service bank with 106 branches in Jordan and Palestine, has gone live with T24, Temenos' core banking system based on jBASE technology. The deployment of T24 replaced the bank's legacy core banking system and consolidates multiple banking modules, helping the company achieve improvements in operational efficiency including automation of real time gross settlement payments and laying the infrastructure to support sustained growth in income and profitability.

Kore Technologies, a provider of enterprise integration and e-commerce web solutions for MultiValue and Microsoft SQL Server databases has announced the availability of Kourier Integrator - Release 4. According to Keith Lambert, vice president of marketing and business development at Kore, "increased connectivity" is the theme for this new release, which includes enhancements for connecting with more data sources.

Revelation Software has announced the availability of the latest release of OpenInsight Development Suite (OI) 9.4, including a new release of OpenInsight for Web (O4W v1.5) and enhancements to the OEngineServer that reduce memory usage.

Rocket Software has announced the availability of System Builder Extensible Architecture (SB/XA) which allows users to rapidly build robust business solutions. By applying SB/XA Designer default styles, users indicate mandatory fields and where intuitive help is available. In addition, Outlook-style menus can be included to create an environment that feels familiar to users. Data can be reported out to Microsoft Excel, Microsoft Word or XML formats, giving users access to their data in their preferred business application.

Sponsors