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
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
-
News
29 Nov 2011
Creating an enterprise data strategy: Manage your data as an asset
In a BeyeNetwork.com research report, TechTarget’s Wayne Eckerson details the key elements of an enterprise data strategy, starting with executive buy-in to the idea that data is a corporate asset. Continue Reading
-
News
30 Dec 2010
Top seven data management stories of 2010
The top data management stories of 2010 include SaaS-based data integration, data warehouse appliances, the SAP-Sybase acquisition and more. 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
-
Tutorial
07 Oct 2010
Examples of decision support systems (DSS) aiding business decision-making
Learn how decision support systems can help the business decision-making process. Find out why decision support is needed and what IT skills business managers need for DSS. Continue Reading
-
Answer
02 Aug 2010
What is the difference between data definition language (DDL) and SQL?
Learn the difference between a data definition language (DDL), also known as data descriptive language, and the Structured Query Language (SQL). Find examples of both DDL and SQL. 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
An introduction to database transaction management
Find out the performance advantages of using one connection for multiple statements in this database tutorial. Get a definition of local vs. distributed transactions and learn how to manage database transactions. 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
-
Feature
10 Jun 2009
Advantages of the multidimensional database model and cube modeling
Discover the advantages of the multidimensional database model and find out how data warehouse cube modeling, data restricting and data slicing work. Learn the role meta-data plays and get a definition of functional dependency. Continue Reading
-
Feature
10 Jun 2009
Data warehouse architectures, concepts and phases: What you need to know
This tutorial explains the different types of data warehouse architecture including bus, federated and hub-and-spoke. Learn about ETL processes and data staging and data warehouse phases. Continue Reading
-
Answer
14 Apr 2009
Defining dimensional vs. normalized database design, dimension vs. fact tables
Find out if your existing database is in dimensional style or normalized database design style, learn the benefits and drawbacks of fact-dimension and normalized database schemas and read a comparison of dimension tables vs. fact tables. Continue Reading
-
Answer
23 Sep 2008
Definition of data abstraction and data abstraction layers
Data abstraction simplifies database design. Learn the definition of data abstraction and find out the three formal kinds of abstraction layers, from a database expert. Continue Reading
-
Answer
17 Apr 2008
Can a dimension table be a fact table for another data mart?
Find out if a dimension table can be a fact table for another data mart -- and get an explanation of the answer. Continue Reading
-
Feature
06 Sep 2007
Introduction to network analysis, architecture and design
Learn tha basics of network analysis, architecture and design, as well as various ways to characterize a network. Continue Reading
-
Feature
21 Nov 2005
Types of DBAs
DBAs can take on many different roles. This excerpt from the "Database administration: The complete guide to practices and procedures" takes a closer look at different types of DBAs. Continue Reading