DBTA E-EDITION
March 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
As more businesses leverage applications that are hosted in the cloud, the lines between corporate networks and the internet become blurred. Accordingly, enterprises need to develop an effective strategy for ensuring security. The problem is, many of today's most common approaches simply don't work in this new cloud-based environment.
MySQL is a popular open source database and one of the top relational databases—and with good reason. It is an extremely feature-rich and powerful database platform. With all its positives, however, MySQL has a number of challenges that can limit its ability to perform with the agility and performance businesses increasingly require. Here's a quick look at how to optimize MySQL for your ever-changing environment.
The world of IT operations has always had a big data problem. Instrumentation of end users, servers, application components, logs, clickstreams, generated events and incidents, executed notifications and runbooks, CMDBs, Gantt charts—you name it, people in the IT operations area have had to cope with mountains of data. And yet the scope of the problem has been enlarged once again, thanks to industry-wide trends such as bring-your-own-device, the Internet of Things, microservices, cloud-native applications, and social/mobile interaction.
Columns - Applications Insight
Few of us working in the software industry would dispute that agile methodologies represent a superior approach to older waterfall-style development methods. However, many software developers would agree that older enterprise-level processes often interact poorly with the agile methodology, and long for agility at the enterprise level. The Scaled Agile Framework (SAFe) provides a recipe for adopting agile principles at the enterprise level.
Columns - Database Elaborations
When it comes to operational, third normal form approaches, too many database models today have very low levels of business veracity. This is because current IT trends work against incorporating too much truth inside the entity-relationship diagram. Instead, development teams center on the finished product and excessively worry about describing a solution rather than describing the actual organization.
Columns - DBA Corner
Every DBA should take advantage of the mechanisms provided by the DBMS to ensure data integrity. When DBMS-provided methods are used, fewer data integrity problems are likely to be found. Fewer data integrity problems mean higher quality databases and more proficient end users.
Columns - SQL Server Drill Down
Microsoft first truly disrupted the ETL marketplace with the introduction of SQL Server Integration Services (SSIS) back with the release of SQL Server 2005. Microsoft has upped the ante yet again by bringing to market powerful ETL features to the cloud via the Azure Data Factory, which enables IT shops to integrate a multitude of data sources, both on-premises and in the cloud, via a workflow (called a "pipeline) that utilizes Hive, Pig, and customized C# programs.
MV Community
On March 15th Kore will be hosting an informative and interactive presentation on real-time enterprise application integration best practices and implementation strategies using RESTful Web Services (REST). Kore also attended the California Community College Chief Information Systems Officers Association (CISOA) and Ellucian Banner users' group conference.
Revelation will be hosting its user conference from April 18 through April 21, at the Omni Orlando Resort at Championsgate in Orlando, Florida. "We always want to choose a popular vacation destination to do our conferences. Orlando is a great convention city. We even moved our conference schedule up by a day, so that gives everyone an extra day on the weekend to take in the Orlando sights," noted Robert Catalano, director of sales with Revelation Software.
Rocket has just released version 6.4.0 of Rocket wIntegrate, a user interface for MultiValue databases, which adds enhanced features for IoT, file sharing, and security. The new release also allows for improved user experience with comprehensive integration between character applications and the desktop.