Database management
As the volume of business data has grown, database management has become vital to data optimization and security. Database management are processes that ensure proper application performance, avoid compliance risk and protect valuable business data. Read database management strategies to make sure data is controlled throughout its lifecycle, from creation to deletion.
Top Stories
-
Tip
28 Oct 2024
NoSQL database types explained: Column-oriented databases
Learn about the uses of column-oriented databases and the large data model, data warehouses and high-performance querying benefits the NoSQL database brings to organizations. Continue Reading
-
Tip
23 Oct 2024
NoSQL database types explained: Key-value store
Utilizing a key-value store can improve data processing speeds and scalability for data operations that do not require complex queries or analytics. Continue Reading
-
News
16 Sep 2019
New cloud and on-premises options for Oracle Autonomous Database
Oracle introduced new cloud and on-premises deployment options for its namesake database and automated cloud service as Oracle OpenWorld 2019 got underway. Continue Reading
-
Definition
11 Sep 2019
T-SQL (Transact-SQL)
T-SQL (Transact-SQL) is a set of programming extensions from Sybase and Microsoft that add several features to the Structured Query Language (SQL), including transaction control, exception and error handling, row processing and declared variables. Continue Reading
-
Definition
11 Sep 2019
What is database normalization?
Database normalization is intrinsic to most relational database schemes. It is a process that organizes data into tables so that results are always unambiguous. Continue Reading
-
News
22 Aug 2019
ArangoDB 3.5 update improves multi-model database platform
ArangoDB 3.5 accelerates its database platform with improved query performance and enhanced data security capabilities, as market demand for multi-model platforms builds. Continue Reading
-
News
20 Aug 2019
DigitalOcean Managed Databases add MySQL, Redis support
Expanding its database management system offerings, cloud computing vendor DigitalOcean added Managed Databases support for MySQL and Redis. Continue Reading
-
Definition
16 Aug 2019
What is Azure SQL Data Warehouse?
Azure SQL Data Warehouse is a managed Data Warehouse-as-a Service (DWaaS) offering provided by Microsoft Azure. Continue Reading
-
Definition
16 Aug 2019
What is SQL Server Reporting Services (SSRS)?
SQL Server Reporting Services (SSRS) is a SQL Server subsystem that enables the creation of graphical, mobile and printed reports using SQL Server and other data sources. Continue Reading
-
Definition
08 Aug 2019
What is a pivot table?
A pivot table is a statistics tool that summarizes and reorganizes selected columns and rows of data in a spreadsheet or database table to obtain a desired report. Continue Reading
-
News
01 Aug 2019
Startup Dgraph Labs growing graph database technology
Dgraph Labs looks expand its graph database platform, which offers the promise of reducing isolated data sources and speeding up queries. Continue Reading
-
News
31 Jul 2019
NuoDB 4.0 improves cloud-native database capabilities
Support for multiple clouds, tighter integration with Kubernetes and indexing enhancements that accelerate database performance highlight the new NuoDB release. Continue Reading
-
Tip
30 Jul 2019
SQL Server database design best practices and tips for DBAs
Good database design is a must to meet processing needs in SQL Server systems. In a webinar, consultant Koen Verbeeck offered advice on how to make that happen. Continue Reading
-
Tip
29 Jul 2019
SQL Server in Azure database choices and what they offer users
SQL Server databases can be moved to the Azure cloud in several different ways. Here's what you'll get from each of the options for migrating SQL Server to Azure. Continue Reading
-
Tip
23 Jul 2019
10 cloud database migration mistakes to avoid
Database expert Chris Foot lists the top 10 oversights IT teams commonly make when undertaking a cloud database migration and offers tips on how to avoid them. Continue Reading
-
News
03 Jul 2019
RavenDB Cloud automates database management
RavenDB's managed cloud database service, RavenDB Cloud, intends to automate security processes, reduce overhead and cater to businesses of all sizes. Continue Reading
-
Feature
02 Jul 2019
Container technologies promise more agility for big data apps
Along with the ability to provide greater agility and flexibility for big data applications, containers can play a role in IT strategy that drives real-time decision-making. Continue Reading
-
Feature
02 Jul 2019
Using a LEFT OUTER JOIN vs. RIGHT OUTER JOIN in SQL
In this book excerpt, you'll learn LEFT OUTER JOIN vs. RIGHT OUTER JOIN techniques and find various examples for creating SQL queries that incorporate OUTER JOINs. Continue Reading
-
News
28 Jun 2019
PostgreSQL database specialist EnterpriseDB gets new backing
EnterpriseDB is looking to push its database further with help from new financial backers. The deal sees Postgres originator Michael Stonebraker coming onboard as technical adviser. Continue Reading
-
News
18 Jun 2019
MongoDB Atlas cloud service adds data lake, touts multi-cloud
MongoDB released an S3-compatible data lake its developer legions can quickly query. But, word of MongoDB Atlas use on Google's cloud shows there are clouds to sow beyond AWS. Continue Reading
-
News
04 Jun 2019
IBM Db2 update aims to simplify use with AI
IBM's new Db2 release adds a host of AI-powered enhancements, including a range of automated error reporting capabilities and tools to more easily create AI algorithms. Continue Reading
-
Tip
31 May 2019
Key features to create a SQL Server audit trail in databases
SQL Server offers a set of built-in auditing tools that can help make the process of tracking logins and other database activities easier for database administrators. Continue Reading
-
Tip
20 May 2019
Check SQL Server Query Store performance impact before using
Many IT teams hesitate to use SQL Server Query Store due to performance concerns. Consultant Andy Warren offers tips on how to test and get started with Query Store. Continue Reading
-
News
07 May 2019
ProvenDB brings blockchain applications to world of MongoDB
Blockchain is intriguing technology, but carries with it high system overhead. ProvenDB adds blockchain to MongoDB in an effort to gain acceptable performance. Continue Reading
-
News
25 Apr 2019
MongoDB buys Realm database to boost mobile chops
MongoDB is buying Realm, the maker of an open source database for cross-platform mobile applications, to boost its Atlas cloud platform and Stitch backend as a service. Continue Reading
-
Tip
22 Apr 2019
SQL Server performance tuning best practices for DBAs
Tuning database performance is a complex process, but consultant Joey D'Antoni details a list of SQL Server performance tuning best practices that can make it easier. Continue Reading
-
Tip
09 Apr 2019
Pros and cons of using SQL Server audit triggers for DBAs
Using triggers to capture audit information in SQL Server can be instrumental in keeping track of database use and changes. But they aren't a perfect fit for all cases. Continue Reading
-
Tip
29 Mar 2019
Google Cloud Spanner overview: 4 features to consider
Cloud Spanner's ability to offer data consistency and horizontal scalability has helped the relational database service gain traction. Learn more about its architecture. Continue Reading
-
Tip
27 Mar 2019
How to resolve and avoid deadlocks in SQL Server databases
Deadlocks are a real hindrance to SQL Server users, but database administrators can avoid them by taking steps to limit them and stop them from recurring. Continue Reading
-
News
12 Mar 2019
Aerospike database garners Spark, Kafka connectors
Apache Kafka and Apache Spark connectors ease use of the Aerospike NoSQL data store in high-speed applications such as analytics that are becoming more broadly supported. Continue Reading
-
News
26 Feb 2019
Hazelcast grid tunes for data scalability tradeoffs
An in-memory data grid (IMDG) from Hazelcast lets designers tune subsystems to support consistency over availability, or the reverse, depending on what designers want. Continue Reading
-
Tip
21 Feb 2019
SQL Server auditing best practices: 3 key questions for DBAs
Acing a SQL Server database audit starts with careful monitoring of how sensitive data is accessed and used so you can answer the top questions that auditors ask. Continue Reading
-
News
01 Feb 2019
Open source cloud databases battle software 'strip mining'
Cloud giants like AWS have adopted open source databases, causing Confluent, MongoDB and others to guard their assets the best way they know how: licensing. Continue Reading
-
Feature
01 Feb 2019
5 trends for SQL Server environments as SQL Server 2019 looms
SQL Server is undergoing new changes, as Microsoft prepares to release the 2019 version of the database software. Other changes are also on tap for SQL Server users. Continue Reading
-
Feature
23 Jan 2019
Advantages of graph databases: Easier data modeling, analytics
Graph databases are finding a place in analytics applications at organizations that need to be able to map and understand the connections in large and varied data sets. Continue Reading
-
Tip
17 Dec 2018
SQL Server 2019 improves Linux, container support
The SQL Server 2019 release includes new big data integration features, a collection of database engine enhancements and improved Linux and container support. Continue Reading
-
News
14 Dec 2018
Data companies vie to fill spots in AWS cloud data lineup
Third-party vendors that offer data platforms to AWS users tout hedges against cloud lock-in. But they must both compete and collaborate with the cloud leader. Continue Reading
-
Feature
10 Dec 2018
FaunaDB distributed cloud database hunts transactional NoSQL
Startup Fauna has built a "relational NoSQL" database for distributed transaction processing. Data consistency and speedy builds attracted early user ShiftX. Continue Reading
-
Podcast
27 Nov 2018
Microsoft Azure SQL Database and Oracle 19c start to rev
A new Microsoft Azure SQL Database Managed Instance service seeks to span the gap between cloud and on-premises systems. Meanwhile, Oracle also has cloud plans of the data kind. Continue Reading
-
Tip
15 Nov 2018
5 FAQs on SQL Server containers and how to manage them
Running SQL Server in containers creates new challenges for database administrators. The answers to these questions can guide you through some of them. Continue Reading
-
Tip
15 Nov 2018
The Power BI-PowerShell cmdlet cheat sheet
DBAs can manage Power BI data sets, workspaces and reports with PowerShell. Using the two tools together makes for a more efficient and effective workflow. Continue Reading
-
Definition
13 Nov 2018
Azure Data Studio (formerly SQL Operations Studio)
Azure Data Studio is a Microsoft tool, originally named SQL Operations Studio, for managing SQL Server databases and cloud-based Azure SQL Database and Azure SQL Data Warehouse systems. Continue Reading
-
Feature
31 Oct 2018
The most useful new features in Microsoft SQL Server 2019
SQL Server 2019 includes welcome new features, particularly updates to its indexing and high availability capabilities and added SQL Server on Linux functionality. Continue Reading
-
Quiz
30 Oct 2018
SQL vs. NoSQL: What do you know about the database designs?
The decision to use a SQL database or a NoSQL database can be made wisely only if the ins and outs of both are understood. See how well you know the database architectures. Continue Reading
-
Feature
23 Oct 2018
Neo4j graph database targets AI use cases, performance
The Neo4j graph database is poised for use in AI applications, in which understanding data can stymie efforts. Recent updates target AI needs and performance issues. Continue Reading
-
News
12 Oct 2018
MarkLogic Data Hub Service aims to ease cloud use of NoSQL DBMS
MarkLogic rolled out a cloud-service version of its NoSQL database management system, a move designed to make the technology more cost-effective for cloud users. Continue Reading
-
Tip
17 Sep 2018
4 strategies to beat the SQL Server 2008 support cutoff
The looming end of SQL Server 2008 extended support should spur database teams into action. Consider these four options to extend security updates or migrate your aging SQL Server systems. Continue Reading
-
News
04 Sep 2018
Graph processing gives credit analysis firms an edge
A graph database startup's parallel loading, processing and querying combine to deliver real-time data for fintech firms that offer fast credit evaluations online. Continue Reading
-
Tip
30 Aug 2018
SQL Server high availability best practices in the cloud
The cloud isn't immune to system failures. You can increase database uptime and prevent data losses with these high availability best practices for SQL Server in the cloud. Continue Reading
-
Feature
16 Aug 2018
Open source RDBMS uses spurred by lower costs, cloud options
Open source technologies have become more capable alternatives to mainstream relational databases for cost-conscious users -- and the cloud makes them more accessible. Continue Reading
-
Tip
16 Aug 2018
2 ways to attach SQL Server database files to Linux containers
SQL Server files can be stored outside of Docker containers in host directories or volumes. Here's how to set up SQL Server on Linux databases and attach them to containers. Continue Reading
-
Feature
02 Aug 2018
Open source DBMS software gains foothold in enterprise IT
Open source databases are increasingly making their way into corporate IT environments, says Gartner analyst Merv Adrian in a Q&A. But some care is required. Continue Reading
-
Tip
24 Jul 2018
How to attach databases to custom SQL Server containers
Deploying SQL Server in Docker containers for production applications typically requires custom containers. Here are guidelines on how to attach databases to them. Continue Reading
-
Tip
17 Jul 2018
Six sample databases for SQL Server and how to find them
SQL Server sample databases are useful for test and dev, but they can be difficult to parse. Use this SQL database sample overview to decide which to use and how to access them. Continue Reading
-
Tip
16 Jul 2018
A quick tutorial on SQL Server maintenance plans
SQL Server maintenance plans get a bad rap, but for DBAs who need a simple way to maintain databases, Microsoft's built-in tools are a good place to start. Continue Reading
-
Feature
09 Jul 2018
eHarmony hooks up with Redis NoSQL database for hot storage
The Redis key-value store finds use in a system to match would-be romantic partners on dating site eHarmony, which employs a variety of NoSQL databases to make love click online. Continue Reading
-
Tip
02 Jul 2018
The benefits of columnar storage and the Parquet file format
What's behind Apache Parquet's growing popularity? It may be the file format's columnar storage orientation, which leads to benefits including improved query performance. Continue Reading
-
News
27 Jun 2018
MongoDB 4.0, Stitch aim to grow NoSQL apps in cloud, on-prem
NoSQL vendor MongoDB upgraded its database software with ACID support, while also releasing a serverless platform intended to simplify application development. Continue Reading
-
Answer
26 Jun 2018
What's the difference between DDL and DML?
What's the difference between DDL and DML? Get the answer and see examples of data manipulation language and data definition language commands for SQL databases. Continue Reading
-
Feature
11 May 2018
GPU databases bring greater parallelism to big data processing
GPU databases offer a new way to process data. 451 Research analyst James Curtis discusses where they fit in big data applications, particularly for parallel processing. Continue Reading
-
Feature
08 May 2018
CockroachDB database wagered on for scalability boost, GDPR
CockroachDB is an open source distributed database designed for processing on a global scale, a need that online gambling company Kindred Group hopes it can meet. Continue Reading
-
Tip
19 Apr 2018
Why running SQL Server on Docker is no longer frowned upon
Microsoft now lets SQL Server databases run in Docker containers, a capability that depends on using volumes to store data in a persistent way outside the containers. Continue Reading
-
Feature
18 Apr 2018
What the Microsoft GDPR compliance toolkit offers for SQL Server
The set of GDPR compliance tools that Microsoft offers for SQL Server is designed to make it easier for users of the database software to adhere to the EU's new data rules. Continue Reading
- 09 Apr 2018
-
Definition
01 Mar 2018
U-SQL
U-SQL is a Microsoft query language that combines a declarative SQL-like syntax with C# programming, enabling it to be used to process both structured and unstructured data in big data environments. Continue Reading
-
Feature
16 Feb 2018
Hyperledger Fabric offers path to enterprise blockchain future
Blockchain arose from bitcoin, but it's looking to find a place in the enterprise. Frameworks like Hyperledger Fabric could smooth out the technology's rough side for business uses. Continue Reading
-
News
16 Feb 2018
MongoDB 4.0 takes ACID transactions to multi-document level
MongoDB is taking a deeper step into SQL-style processing waters with a 4.0 update that brings increased support for ACID-compliant transactions to its NoSQL database. Continue Reading
-
Definition
11 Jan 2018
MariaDB
MariaDB is an open source relational database management system (DBMS) that is a compatible drop-in replacement for the widely used MySQL database technology. Continue Reading
-
Feature
21 Dec 2017
How SQL Server containers in Docker can ease database deployment
Docker containers can make the SQL Server deployment process more efficient and flexible. Here's what they are and how to get started on creating containers for SQL Server databases. Continue Reading
-
Feature
19 Oct 2017
NewSQL databases rise anew -- MemSQL, Spanner among contenders
The NewSQL database was almost hidden when Hadoop and NoSQL arose. Now, as more big data teams move toward production uses, MemSQL, Cloud Spanner and similar products may get a second look. Continue Reading
-
Definition
25 Jul 2017
Microsoft SSIS (SQL Server Integration Services)
Microsoft SSIS (SQL Server Integration Services) is an enterprise data integration, data transformation and data migration tool built into Microsoft's SQL Server database. Continue Reading
-
Definition
20 Feb 2017
Microsoft SQL Server Management Studio (SSMS)
Microsoft SQL Server Management Studio (SSMS) is an integrated environment to manage a SQL Server infrastructure. Continue Reading
-
Buyer's Guide
13 Feb 2017
How to select the best DBMS software: A buyer's guide
Learn how to evaluate and buy the best DBMS software for your organization. Continue Reading
-
Feature
10 Feb 2017
A look at the leading operational database management systems
The market for operational DBMS products can be confusing, especially with so many choices. But knowing your application requirements can help point you in the right direction. Continue Reading
-
Tip
19 Jan 2017
Options for scaling out SQL Server applications to boost workloads
Scaling out a database to meet the needs of a heavy processing workload can be a challenge. Here are details on the SQL Server scalability methods available to ease the process. Continue Reading
-
Feature
05 Dec 2016
Microsoft SQL Server 2016 relational DBMS overview
Microsoft SQL Server 2016 for Windows comes in four editions, with updates that include a new stretch database feature, Polybase, dynamic data masking and more. Continue Reading
-
Feature
08 Jul 2016
Exploring the features of Oracle Enterprise Manager 13c
Cloud Control, a feature of Oracle Enterprise Manager 13c, can be used to monitor and manage databases, middleware, infrastructure and hardware running on-premises or in the cloud. Continue Reading
-
Feature
06 Jul 2016
Inside BMC's database performance tools for DB2 for z/OS
BMC offers several tools to help DBAs manage and prevent critical performance issues in DB2 for z/OS, as well as monitoring options for other vital mainframe subsystems. Continue Reading
-
Feature
17 Jun 2016
Examining the functions and features of database performance tools
To help you determine which tools your organization needs, it's important to review the primary features and functionality of the three database performance tools categories. Continue Reading
-
Feature
08 Jun 2016
Three indicators that could signal database performance issues
Database performance monitoring and management tools can be used to mitigate issues and help organizations be more proactive, so they can avoid performance problems and outages. Continue Reading
-
Feature
12 May 2016
What you need to know about database performance software
Database performance software identifies bottlenecks and points of contention, monitors workload and throughput, and manages system and DBMS resource usage. Continue Reading
-
Feature
14 Aug 2015
Types of NoSQL databases and key criteria for choosing them
In a book excerpt, consultant Dan Sullivan offers insights into how to select the right type of NoSQL database for the right application in your organization. Continue Reading
-
Feature
07 Aug 2015
SAP HANA in-memory DBMS overview
SAP HANA is an in-memory DBMS and application platform designed to handle high transaction rates and complex queries using one data copy. Continue Reading
-
Feature
31 Jul 2015
Redis open source DBMS overview
The Redis open source DBMS provides a highly scalable data store that can be shared by multiple processes, applications or servers. Continue Reading
-
Feature
27 Jul 2015
MySQL open source RDBMS overview
Developers, database administrators and DevOps teams use MySQL open source RDBMS to more easily operate next-generation applications in the cloud. Continue Reading
-
Feature
11 Jun 2015
Which in-memory DBMS best fits your company's needs?
Database expert Craig S. Mullins examines some top in-memory DBMS software offerings to help you determine which is the best fit for your organization. Continue Reading
-
Feature
04 Jun 2015
Oracle Database 12c relational database management system overview
Oracle Database 12c delivers strong performance for mission-critical workloads, with features and functionality for diverse processing needs and requirements. Continue Reading
-
Feature
30 Apr 2015
Which relational DBMS is best for your company?
Database expert Craig S. Mullins examines the top relational database management system software to determine which best fits your organization. Continue Reading
-
Feature
17 Apr 2015
How to determine if an in-memory DBMS is right for your company
Database expert Craig S. Mullins examines the pros and cons of the in-memory database management system, and the criteria you should consider during the request-for-proposal and evaluation period. Continue Reading
-
Feature
27 Mar 2015
Key considerations for determining if a NoSQL DBMS meets your IT needs
NoSQL represents the fastest-growing type of DBMS being adopted today. Is it right for you? Continue Reading
-
Feature
24 Feb 2015
Key criteria for deciding if a relational DBMS meets your IT needs
For many organizations, a relational database management system will get the job done; others need to keep looking to fulfill their needs. Continue Reading
-
Quiz
30 May 2014
Quiz: How do relational databases and NoSQL technologies compare?
Take this quiz to see what you know about the recent developments in the world of RDBMS and NoSQL databases technologies. Continue Reading
-
Feature
22 May 2014
Former shadow IT worker helps bring analytics data into the light
Ryan Fenner worked in a shadow IT unit at Union Bank for years. Now he's helping lead an IT effort to better manage BI data created in those shadows. Continue Reading
-
News
13 Apr 2011
From the Editors: Database consolidation and standardization 101
If you’re thinking about embarking on a database consolidation or standardization project, make sure you know the technical, cultural and skill-set issues that can arise. Continue Reading
-
News
26 Nov 2010
Creating a database strategy that can adapt to changing business needs
Crafting a successful database strategy requires technology flexibility, the right skill sets and a strong focus on application requirements, according to IT pros and analysts. Continue Reading
-
News
10 Nov 2010
Emerging database technologies hit DBMS mainstream, add to choices
Emerging database technologies such as column-based database software, NoSQL databases and Database as a Service (DaaS) platforms are starting to make a splash in the IT market. Continue Reading
-
Answer
24 Mar 2010
What are aggregate tables and aggregate fact tables?
Here you'll see examples and read definitions of aggregate tables and aggregate fact tables. You'll also learn how to use aggregate tables in data warehouses and databases. Continue Reading
-
Answer
24 Mar 2010
Data warehouse concepts: Data flow and sending data to source systems
Learn about a data warehouse concept: data flow. And find out if it's a good idea to flow data from your data warehouse or data marts back to source systems. Continue Reading
-
Answer
07 Oct 2009
What is the difference between a logical and physical warehouse design?
What's the difference between logical design and physical design? Get an expert's take, plus learn about three data warehouse models -- the user model, physical model and logical model -- and how they differ. Continue Reading
-
Feature
27 Jul 2009
Executing SQL statements using prepared statements and statement pooling
In this database tutorial, find out about executing SQL statements using prepared statements and statement pooling. Learn what a statement pool is and how to retrieve long data types efficiently. Continue Reading
-
Feature
27 Jul 2009
Static SQL vs. dynamic SQL for database application performance
Learn the difference between static SQL vs. dynamic SQL and the benefits and drawbacks of each for database application performance. Get a definition of stored procedure, find out about database drivers and wire protocol database drivers and how the network affects database performance. Continue Reading
-
Answer
24 Jun 2009
How to select an MPP database: DB2 vs. Teradata
Should you run a massively parallel processing (MPP) database with DB2 or Teradata? Find out how to compare DB2 vs. Teradata and how to choose a database system and with advice from a data warehouse expert. Continue Reading