Information Management News

Sponsors

Using Control Theory to Automate Database Operations

There's been a lot of discussion recently about autonomous databases, which offer the promise of keeping database systems stable and performant while alleviating much of the tuning and configuration drudgery that DBAs must typically slog through. It is important to note that an autonomous database needs to strike a balance between giving administrators too much and too little control. Too much control takes the form of endless configuration and tuning parameters that place the burden of performance and stability on the operator. Too little control takes the form of automated behaviors that reduce the predictability of the system to an unacceptable level. Read More

Managing a Data Warehouse in the Cloud: 5 Challenges

One of the most important shifts in data warehousing in recent times has been the emergence of the cloud data warehouse. Previously, setting up a data warehouse required a huge investment in IT resources to build and manage a specially designed on-premise data center. Now, several cloud computing vendors offer data warehousing functions as a service (DWaaS), accessible via an Internet connection. This model negates the costly capital expenditure and management required for an on-premise data warehouse. Read More

Tricks to Speed Up Your Database

As the industry embraces artificial intelligence and marches toward autonomous systems, some enterprises will still need to rely on traditional databases that must be managed, tuned, and secured to ensure the best performance. And while not all organizations will be able to make the autonomous transition quickly due to internal processes, there are a few tricks to optimize your old database with terabytes of data at speeds needed for everything from e-commerce to IoT and music streaming services on a global scale. Read More

Ensuring Optimal Database Performance in the New Cloud World

Today, data management environments are highly complex and often span multiple vendors with deployments across on-premise data centers, clouds, and hybrid installations. In addition to the heterogeneity of systems, the processes surrounding database development and management have also changed. DevOps, a methodology for data scientists, developers, database administrators (DBAs) and others to participate in an Agile workflow, puts a premium on speed and also means that DBAs do not wield the firm control they did in the past. Read More

Newsletters


Columnists

Todd Schraml

Database Elaborations

Todd Schraml

  • Two Key Questions When Planning a Staging Area for a Data Lake In establishing a staging or landing area for a data lake, a data hub, or a quaint data warehouse environment, structures need to be established that will mimic source data in support of two very basic queries. The first is: "What does the current source dataset look like?" And the second: "What change activity has occurred against the source since the last time it was interrogated?"
Recent articles by Todd Schraml
Craig S. Mullins

DBA Corner

Craig S. Mullins

  • DevOps and the Database The current trend for software development teams is to adopt a continuous delivery approach based upon DevOps and agile development techniques. DevOps is relatively a new term, coined in 2009, defining software engineering practices that combine software development (Dev) and software operations (Ops). The general idea is not really all that new, but the adoption of agile techniques and modern tooling to automate software delivery is. The goal of DevOps is for developers and operations personnel to collaborate throughout the entire service lifecycle, from design through development and into production.
Recent articles by Craig S. Mullins
Kevin Kline

SQL Server Drill Down

Kevin Kline

Recent articles by Kevin Kline
Guy Harrison

MongoDB Matters

Guy Harrison

  • Limitations in MongoDB Transactions The MongoDB 4.0 release introduced multi-document transactions to the popular open source NoSQL DB.  The lack of a transactional capability has been a key limiting factor in MongoDB uptake, so it's not surprising that the company, it's users and the technology press have been enthusiastic about this latest release. However, it's worth remembering that the transactional capabilities of MongoDB have been commonplace for many decades.
Recent articles by Guy Harrison
Rob Mandeville

Next-Gen Data Management

Rob Mandeville

  • Correlation Versus Causation: Why Should a DBA Care? Shark attacks and ice cream sales follow the very same trajectory when charted. When ice cream sales go up, so do shark attacks. When ice cream sales decrease, shark attacks decrease. With a correlation coefficient of very close to 1, we can deduce that sharks like to attack after we've recently had ice cream!
Recent articles by Rob Mandeville

Trends and Applications