DBTA E-EDITION
October 2015

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

There's unrelenting pressure on businesses to compete on analytics and to be able to anticipate customer needs and trends ahead of the curve. Enterprises are looking to expand BI and analytics capabilities as far and wide as technologies and budgets will allow them to go. As a result, the continuing advance of analytic capabilities across the enterprise has reached a "tipping point."

IT suppliers and data management managers are experiencing a major pain point with efficient data logging management. The availability of NoSQL open source software has enabled enterprises to collect large volumes of data from different sources, and software companies have implemented "call back home" features that allow their software to send information to data collection centers within various parameters, creating additional run time configurations and data traffic. And as the Internet of Things and a "connected everything" approach to businesses become increasingly popular, more and more data will flow in and out of data management systems, leaving IT managers muddled with millions of pieces of data they must properly manage and store.


Columns - Big Data Notes

There are quite a few databases competing to be "king" of NoSQL. MongoDB claims to have the fastest-growing NoSQL database ecosystem, MarkLogic claims to be the only Enterprise NoSQL database, while other databases claim to be the fastest or most scalable system.


Columns - Database Elaborations

The Agile methodology is great for getting turgid development teams to start working faster and more coherently. With Agile, which focuses on more rapid, incremental deliverables and cross-departmental collaboration, the bureaucratic plaque is flushed from the information technology groups' arteries. But there is a dark side to Agile approaches.


Columns - DBA Corner

Too little emphasis overall is placed on the integrity and recoverability of the data—and too much is placed on performance. Yes, performance is probably the most visible aspect of database systems, at least from the perspective of the end user. But the underlying assumption of the end user is always that they want to access accurate and, usually, up-to-date data. But what good does it do to quickly access the wrong data? Anybody can provide rapid access to the wrong data!


Columns - IOUG Insight

The topics of resilience and change have been on my mind a lot lately for a variety of reasons. First, IT is always at the center of technology change, so that's nothing new. We must continually learn and keep abreast of new technology and trends before they even materialize. Second, I am an IT leader in the energy industry, and when one is at the mercy of natural resource supply and demand, there will be peaks and valleys in production and financial performance over the years. With this latest dip in energy prices, I sense a different perspective—one of working smarter and more efficiently, emphasizing innovation, and analyzing decisions with an enterprise perspective of what is right for the company at this time, not just IT.


Columns - SQL Server Drill Down

Prior to SQL Server 2016, currently in CTP, your main method for encrypting a SQL Server application was to use a feature called Transparent Data Encryption. TDE provides strong encryption, but with some shortcomings. First, you have to encrypt an entire database. No granularity is offered at a lower level, such as encrypting specific tables or certain data within a table. Second, TDE encrypts only data at rest, in files. Data in memory or in-flight between the application and server are unencrypted. Enter Always Encrypted.


Columns - Next-Gen Data Management

Ever since Linux became a viable server operating system, organizations have been looking to all kinds of open source software (OSS) to save on license and maintenance costs and to enjoy the benefits of an open platform that invites innovation. If you're considering MySQL or another open source DBMS as either your primary database or to, perhaps, operate alongside your existing commercial systems, such as Oracle or Microsoft SQL Server, for one reason or another, here are seven things to keep in mind.


MV Community

Kore Technologies showed off the 5.4 release of KommerceServer at the Eclipse Users Group's annual Encounter conference. The KommerceServer eCommerce Suite encompasses the webStoreFront, webPortal, webAdminstration and Mobile Editions. It contains significant out-of-the-box functionality for business-to-business (B2B) and business-to-consumer (B2C) e-commerce environments.

Sponsors