Database management system (DBMS) architecture, design and strategy
Top Stories
-
News
10 Feb 2022
ScyllaDB 5.0 set to advance NoSQL database capabilities
At Scylla Summit 2022, the open source NoSQL database vendor introduced upcoming services including a DBaaS as well as a new platform release, and a user outlined its application. Continue Reading
-
News
09 Feb 2022
Starburst brings in $250M to advance data mesh aspirations
The vendor continues on its path toward an initial public offering, as demand for its open source Trino-based data lake query engine platform grows. Continue Reading
-
Feature
27 Jun 2019
Data modeling techniques to overcome common business challenges
In this interview, author and data modeling instructor Steve Hoberman discusses techniques for dealing with challenges that may arise in the data modeling process. 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
-
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
23 May 2019
How to connect to a pluggable database in Oracle Multitenant
Once you've created pluggable databases in an Oracle Multitenant system, the next step is to connect applications to them so they can be used. Here's how to do that. 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
-
Tip
26 Apr 2019
Creating an Oracle Multitenant container database and PDBs
Database administrator Brian Peasland outlines how to create the container and pluggable databases that are at the heart of the Oracle Multitenant architecture. 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
-
News
17 Apr 2019
Google takes a run at enterprise cloud data management
New Google Cloud boss Thomas Kurian is putting databases and data management at the forefront at Google. The vendor has forged key data deals, showing a more mature Google Cloud. 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
-
Answer
05 Apr 2019
What is the difference between a database engineer, architect and administrator?
Expert Michael Hillenbrand explains the difference between a database engineer, a database architect and a database administrator. 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
-
News
25 Mar 2019
Facebook alumni forge own paths to big data analytics tools
Startups Interana and Rockset differ in their approaches to providing new query capabilities on fast-arriving big data. Both are led by technologists who started at Facebook. Continue Reading
-
News
15 Mar 2019
Big data management practices gain attention amid risks
Many data professionals have yet to solidify traditional data management practices, but they have a new set of challenges to overcome to ensure data privacy and avoid misuse. Continue Reading
-
Feature
13 Mar 2019
Oracle 19c database software promises stability, compatibility
Oracle Database 19c offers automatic indexing and support for external data partitions but carries upgrade issues like apps certification and index creation agreement. 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
11 Mar 2019
Data catalog software takes on data lakes, privacy laws
Data catalogs form a hub for managing enterprise data. New products focus on machine learning and AI add-ons that help automate aspects of data governance. 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
-
Feature
22 Feb 2019
First take on Oracle 19c: 6 useful enhancements for DBAs
Database administrator Brian Peasland lists some of the new and updated features coming in Oracle Database 19c that he thinks will be beneficial to Oracle users. Continue Reading
-
Feature
22 Feb 2019
What to consider when choosing big data file formats
While JSON may be the go-to data format for developers, Parquet, ORC or other options may be better for analytics apps. Learn more about big data file formats. 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
-
News
01 Feb 2019
Cloud data management, security top of mind for government
Federal government data officers grapple with cloud data management, weighing lower cost and efficiencies against security threats and vendor lock-in. Continue Reading
-
Feature
01 Feb 2019
Cloud data warehouse makes inroads as users spurn admin tasks
Overlooked in the run-up to Hadoop, data warehouses have found new life off premises. Cloud-based data warehouses find favor with teams that want to reduce warehouse administration. 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
29 Jan 2019
5 data management infrastructure technologies to evaluate
It's the start of a new year -- is your organization ready to face the data management challenges ahead? Here are five technologies to consider adopting. 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
-
News
22 Jan 2019
New Teradata CEO pursues cloud-based architecture
Cloud architecture, analytics and AI data processing are top innovation priorities for new Teradata CEO Oliver Ratzesberger. He talks about his goals in this Q&A. Continue Reading
-
News
21 Jan 2019
Data.gov shutdown shows limits of open data
The Data.gov shutdown shows that, as open data can be turned off, data professionals may need to consider alternative sources for the kinds of data the government offers. Continue Reading
-
Feature
27 Dec 2018
Key new features coming in Oracle Database 19c
With Oracle Database 19c, Oracle is aiming to boost the stability of its flagship software's latest generation. But 19c also offers DBAs a variety of added features. Continue Reading
-
Podcast
19 Dec 2018
Open source support was central to 2018 data deals
Mergers and acquisitions unsettled the big data status quo in 2018. Open source support made these couplings a bit different than those of the past, Talking Data podcasters said. 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
-
Opinion
14 Dec 2018
The real Oracle cloud strategy that may work vs. AWS and Azure
Oracle's database software is at the heart of its efforts to move users to its cloud. And that strategy might work, despite Oracle's inauspicious standing in the cloud now. 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
-
Feature
30 Nov 2018
Don't let blockchain complexity bog down business applications
Enterprise blockchain applications that run in a controlled environment don't require some of the components of cryptocurrency networks, explains expert David Teich. Continue Reading
-
News
30 Nov 2018
Amazon Timestream, QLDB aim to grab more DBMS users for AWS
Built-for-purpose databases target general ones, especially in the cloud. At re:Invent 2018, AWS added time-series and transaction ledger databases to expand its line. 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
-
Feature
01 Nov 2018
What the 3 versions of Oracle Cloud at Customer offer users
Oracle's Cloud at Customer service lets users run its cloud technologies in their data centers. Here's what users get in the different versions of the managed service. Continue Reading
-
Tip
31 Oct 2018
How to build a master data index: Static vs. dynamic indexing
Expert David Loshin explores the differences between static and dynamic indexing in master data management systems, and which queries each approach can support. Continue Reading
-
News
25 Oct 2018
Users look to Oracle Autonomous Database to lighten IT load
Early users are kicking the tires of Autonomous Database, attracted by Oracle's pledge that the cloud technology will automate database administration chores. 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
23 Oct 2018
Updated Oracle Gen 2 Cloud aims to challenge cloud leaders
With enhancements to its Autonomous Database technology and cloud infrastructure security services, Oracle is trying to gain ground on Amazon and other cloud rivals. 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
-
News
07 Sep 2018
Big data tooling rolls with the changing seas of analytics
Hadoop data tooling is expanding. A view holds that Hadoop is moving from alternate data warehousing to a full-fledged big data analytics offering. 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
-
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
-
News
09 Aug 2018
Oracle Autonomous Database Cloud gets transaction processing
Oracle launched a transaction processing version of Autonomous Database, a cloud-based platform that automates configuration and management of Oracle databases. 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
13 Jul 2018
How graph data modeling can help evaluate database tools
Mapping data to a graph model can be challenging, but these steps can help you create prototype applications -- which then can aid in evaluating graph databases. 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
06 Jul 2018
When to choose an S3 big data environment over HDFS storage
Selecting a storage service for big data in the cloud can be challenging. Expert David Loshin explains usage patterns that could lead organizations to Amazon Simple Storage Service. 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
-
Tip
02 Jul 2018
How Oracle DBA responsibilities change with Autonomous Database
Oracle's Autonomous Database automates basic tasks of database administrators. That may put some DBA jobs at risk, but many will shift to higher-level duties. 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
27 Apr 2018
Congolese health workers and patients benefit from Couchbase database
Belgian public health consulting firm AEDES has worked with a local partner in the Democratic Republic of Congo to deliver a health information management system based on Couchbase Continue Reading
-
News
26 Apr 2018
Cloud workloads see gradual uptake, but miles to go for databases
A picture of steady but not rapid migration to the cloud by Oracle users emerged at Collaborate 18, with database vets saying it's wise to be selective on what to move. 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
-
News
18 Apr 2018
Collaborate 18 to track progress of Oracle cloud database, apps
The Collaborate 18 conference will shine a light on Oracle cloud adoption and migration issues, and on the impact that such moves can have on the careers of DBAs and other IT professionals. Continue Reading
-
Feature
28 Feb 2018
Oracle sees Autonomous Database changing DBA roles for the good
The job duties of database administrators will likely change in organizations that use Oracle Autonomous Database Cloud, but in ways that are beneficial, according to Oracle. Continue Reading
-
Tip
20 Feb 2018
How to use Oracle DBSAT to do a database security assessment
The Oracle Database Security Assessment Tool is free software that checks the security of databases. Here are the steps involved in using DBSAT to collect data and create reports. 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
-
Tip
13 Feb 2018
Data analytics architecture must break down higher ed silos
Siloed data isn't only a problem for businesses. It's also a big issue for many large universities -- one that their data infrastructures need to resolve for effective analytics. 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
-
Tip
14 Jul 2017
Migrate an Oracle RAC database to new servers with zero downtime
Most organizations can't afford any downtime on their Oracle systems. Here's how to move RAC databases to new server nodes and still stay up and running in an Oracle cluster. Continue Reading
-
Answer
17 May 2017
Operational data store vs. data warehouse: How do they differ?
Operational data stores and data warehouses both store operational data, but the similarities between them end there -- and they both have a role to play in analytics architectures. 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
23 Jan 2017
Ten reasons to do an Oracle database upgrade
For every excuse made not to upgrade an Oracle database, there are overriding reasons to do so. Here are the top reasons organizations should move up to Oracle Database 12c. 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
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
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
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
-
Tip
18 May 2015
Relational database design tips to boost performance
As relational database management systems handle more and more data, a strategic approach to data modeling has become vital. Continue Reading
-
E-Zine
07 May 2015
Sort through types of database management systems before you buy
The database management system lies at the center of any organization's business activities. It houses the data that pumps life into operations and analytics applications and ensures that it's managed and manipulated securely. But the types of database management systems, or DBMSes, are numerous -- and organizations starting the evaluation process need to first examine the data they need to process, says data management consultant Craig S. Mullins in this special edition of Business Information. Is it traditional, structured data? Or is it a vast pool full of audio and video streams, social media data and other unstructured information?
First, Mullins surveys the database product landscape, detailing the advantages of the types of database management systems on the market, breaking them into three main categories: relational database management systems, NoSQL databases and in-memory databases. Next Mullins takes a close look at relational systems. Any organization shopping for a database system should begin here, he says, because relational databases are good for a wide range of uses -- traditional data management and analytical applications, batch processing and more. Finally, Mullins explores the relatively new world of NoSQL database systems, known for their able handling of big data. NoSQL has its own types of database management systems, falling into four categories: key-value, document, column and graph. Each is suitable for particular uses, so companies may want to consider mixing and matching, depending on their data needs. Continue Reading -
Opinion
01 May 2015
With database management tools, never settle
They're the heart of it all, pumping data to applications and business processes. But the sheer number of products on the market can boggle any mind. 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
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
-
Opinion
28 Apr 2014
Big data cloud is changing familiar database tech tune
New cloud database applications that increasingly fall into the "big-data-intensive" category are shaking up the usual build-or-buy soliloquy. Continue Reading
-
Podcast
20 Mar 2014
Handling database migrations, such as upgrading to Oracle 12c
IOUG President Michelle Malcher talks about database migrations, from finding downtime to test and upgrade, to maintaining patch sets after go-live. Continue Reading
-
News
09 Sep 2013
Survey: Execs buying into big data in a big way
TechTarget's Wayne Eckerson discusses survey results showing that two-thirds of respondents expect to spend more than $1 million on big data programs this year. Continue Reading
-
Feature
27 Feb 2013
How to manage the risk of the human factor in database administration
Fail to manage the risk of the human factor in database administration and you court disaster. DBAs, like air traffic controllers: work in pairs? Continue Reading
-
Definition
03 Aug 2012
in-memory database
An in-memory database is a type of analytic database designed to streamline the work involved in processing queries. Continue Reading
-
Photo Story
16 Feb 2012
Top six data management software stories of 2011
From the rise of "big data" to office politics hampering MDM projects to Hewlett-Packard giving Neoview the ax, and more, there were plenty of notable data management stories in 2011. Continue Reading