September 2016

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

Data governance is sometimes viewed as a roadblock that keeps data scientists and analysts from turning data into business insights quickly and efficiently. Yet, in the enterprise data and analytics work that we've undertaken for clients across diverse industries, we've found that it's often a lack of sound data governance that prevents organizations from realizing the full value of their data.

Columns - Applications Insight

It is widely accepted that to realize the full potential of blockchain technology we will need a next-generation blockchain to supplement the one provided in the Bitcoin implementation. Ethereum represents just such a next-generation blockchain.

Columns - Database Elaborations

Programming is a literal sport. Code does exactly what it is configured to do, no compromises. When the definition of a task is fuzzy, it is up to the developer to do what they believe is correct. Does the code reflect what is desired? That answer is left open to interpretation. Sadly, developers may not have a clear understanding, and even the users requesting the solution may not be sure. The results can be very painful for an organization. Expectations may not align with the delivered solutions. Users will blame IT; IT will blame users.

Columns - DBA Corner

The current driving force for many IT projects is big data and analytics. So how will the job of DBA be impacted as their companies deploy big data analytics systems? The answer, is quite a bit, but don't forget everything you already know!

Columns - SQL Server Drill Down

As a heavy user of other RDBMS data platforms, I have long appreciated the extra effort that Microsoft put into their data management and administration tool, the SQL Server Management Studio (SSMS). While SSMS is an outstanding administration and T-SQL programming tool, it does have its minor qualms and quibbles.

MV Community

Revelation's OpenInsight solution continues to be enhanced, this time with new reporting tool upgrades and other updates. In conjunction with the Linear Hash Reporting and Resizing Tool released in March 2016, Revelation is publishing a sizelock administration tool called RTI_SET_SIZELOCK. This tool will enable OpenInsight system administrators to view linear hash statistics within an application and identify and modify the file sizelock parameter.

As the cloud continues to change the way people interact with data, one MultiValue company is helping its users get accustomed to all the new capabilities this new deployment model brings to long-established systems. "The cloud makes a level playing field for all companies regardless of size," said Mark Pick, president and CEO of Pick Cloud.