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
-
News
02 Dec 2024
Couchbase unveils suite of services for developing AI
The new services include access to LLMs and unstructured data transformation aimed at enabling customers to build AI tools. Continue Reading
-
News
22 Nov 2024
OpenText bolsters AI agents, analytics; previews roadmap
OpenText users get a passel of AI in the latest Cloud Editions release -- but also analytics and CCM tools. Continue Reading
-
Video
19 Nov 2024
Java, JDBC and SQL Server tutorial
This tutorial shows how to create a JDBC connection to Microsoft's SQL Server, and get started creating Java-based applications that are scalable and secure. Continue Reading
-
News
19 Nov 2024
With new Fabric features, Microsoft aims at AI development
New data management and analytics suite features include databases and a data catalog to enable enterprises to develop and operationalize advanced applications. Continue Reading
-
Tip
14 Nov 2024
MySQL vs. PostgreSQL: Compare popular open source databases
This deep dive compares two popular open source database options, MySQL vs. PostgreSQL, across key categories including performance, compliance, security, scalability and more. Continue Reading
-
Video
01 Nov 2024
SQLite tutorial for beginners
SQLite has an incredibly small footprint. That's one of the reasons why it's the most used database engine in the world. If you've never used it before, here's your chance. Continue Reading
-
Video
01 Nov 2024
Java, JDBC and Postgres
Postgres has become popular in the Java community for many reasons. The ease of integration with Java apps through JDBC is one of the biggest. Here's how it works. Continue Reading
-
Definition
31 Oct 2024
What is dimensionality reduction?
Dimensionality reduction is a process and technique to reduce the number of dimensions -- or features -- in a data set. Continue Reading
-
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
-
Definition
24 Oct 2024
What is Microsoft Visual FoxPro (VFP)?
Microsoft Visual FoxPro (VFP) is an object-oriented programming (OOP) environment with a built-in relational database engine. 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
-
Definition
10 Oct 2024
What is Oracle?
Oracle is one of the largest vendors in the enterprise IT market and the shorthand name of its flagship product, a relational database management system (RDBMS) that's formally called Oracle Database. Continue Reading
-
News
01 Oct 2024
Vast unveils InsightEngine, a move to support enterprise AI
Vast released InsightEngine to bring real-time retrieval-augmented generation into its data platform as it prepares for growing enterprise adoption of AI. Continue Reading
-
Definition
13 Sep 2024
What is NoSQL (Not Only SQL database)?
NoSQL is an approach to database management that can accommodate a wide variety of data models, including key-value, document, columnar and graph formats. Continue Reading
-
Definition
12 Sep 2024
What is a data fabric?
A data fabric is an architecture and software offering a unified collection of data assets, databases and database architectures within an enterprise. Continue Reading
-
News
10 Sep 2024
AWS joins Microsoft, Google Cloud in offering Oracle database
AWS joined Microsoft Azure and Google Cloud in offering the Oracle Database, an indication that enterprises want to use Oracle alongside the cloud providers' AI services. Continue Reading
-
Definition
27 Aug 2024
What is Structured Query Language (SQL)?
Structured Query Language (SQL) is a standardized programming language that is used to manage relational databases and perform various operations on the data in them. Continue Reading
-
Tip
08 Aug 2024
10 top vector database options for similarity searches
Vector databases excel in different areas of vector searches, including sophisticated text and visual options. Choose the platform that best fits organizational needs. Continue Reading
-
News
01 Aug 2024
New features make Google's Spanner a database for AI
The introduction of graph processing, vector search and full-text search optimize Spanner for developing and managing modern applications and models, including GenAI. Continue Reading
-
Tip
24 Jul 2024
Cloud database comparison: AWS, Microsoft, Google and Oracle
Here's a look at the rival cloud database offerings from AWS, Google, Microsoft and Oracle based on their product breadth, migration capabilities and pricing models. Continue Reading
-
Video
17 Jul 2024
How to install MySQL on Windows
Need a well-maintained, open-source, standards-based database to test your Java apps and Spring Boot microservices? Here's how to download and install the MySQL Community Edition. Continue Reading
-
Definition
17 Jul 2024
What is a vector database?
A vector database is a type of database technology that's used to store, manage and search vector embeddings, numerical representations of unstructured data that are also referred to simply as vectors. Continue Reading
-
Definition
02 Jul 2024
data structure
A data structure is a specialized format for organizing, processing, retrieving and storing data. Continue Reading
-
Tip
28 Jun 2024
The 3-level DBMS schema architecture
The three-level DBMS architecture makes database design more secure, extensible and accessible for client applications. Learn the basics of how it works, with examples. Continue Reading
-
Opinion
27 Jun 2024
Databricks bids to marry AI and BI
At its recent Data+AI Summit, data platform provider Databricks introduced a product that might be a harbinger of a new wave of AI-backed Business Intelligence Continue Reading
-
Definition
25 Jun 2024
Open Database Connectivity (ODBC)
Open Database Connectivity (ODBC) is an open standard application programming interface (API) that allows application programmers to easily access data stored in a database. Continue Reading
-
Definition
25 Jun 2024
database management system (DBMS)
A database management system (DBMS) is a software system for creating and managing databases. Continue Reading
-
Definition
21 Jun 2024
relational database
A relational database is a type of database that organizes data points with defined relationships for easy access. Continue Reading
-
Feature
14 Jun 2024
Graph database vs. relational database: Key differences
Graph databases offer plenty of advantages for enterprises, but relational databases still top the market. Both emphasize relationships between data, but how do they compare? Continue Reading
-
Tip
12 Jun 2024
Multi-cloud databases: How to deploy and manage them
Deploying databases on different cloud platforms offers various benefits. Here's a set of 10 best practices for building a multi-cloud database architecture. Continue Reading
-
Definition
06 Jun 2024
RDBMS (relational database management system)
A relational database management system (RDBMS) is a collection of programs and capabilities that enable IT teams and others to create, update, administer and otherwise interact with a relational database. Continue Reading
-
Definition
31 May 2024
graph database
A graph database, also referred to as a semantic database, is a software application designed to store, query and modify network graphs. Continue Reading
-
Definition
28 May 2024
database (DB)
A database is a collection of information that is organized so that it can be easily accessed, managed and updated. Continue Reading
-
Tip
23 May 2024
Managing databases in a hybrid cloud: 10 key considerations
To manage hybrid cloud database environments, consider business and application goals, consistency, configuration management, synchronization, latency, security and stability. Continue Reading
-
Tip
21 May 2024
10 best practices for managing data in microservices
Data architects managing loosely coupled microservices applications need to make the right decisions about databases, data ownership, sharing, consistency and failure recovery. Continue Reading
-
Definition
17 May 2024
hashing
Hashing is the process of transforming any given key or a string of characters into another value. Continue Reading
-
Tip
03 May 2024
Compare NoSQL database types in the cloud
NoSQL systems are increasingly common in the cloud. Read about the different types of NoSQL databases that are available from major cloud providers and other vendors. Continue Reading
-
Definition
02 May 2024
What are masked language models (MLMs)?
Masked language models (MLMs) are used in natural language processing (NLP) tasks for training language models. Continue Reading
-
Definition
01 May 2024
database administrator (DBA)
A database administrator (DBA) is the information technician responsible for directing and performing all activities related to maintaining and securing a successful database environment. Continue Reading
-
Feature
01 May 2024
12 top open source databases to consider
Open source databases are viable alternatives to proprietary ones. Here's information on 12 open source and source available technologies for weighing database options. Continue Reading
-
Definition
16 Apr 2024
What is a cloud database? An in-depth cloud DBMS guide
A cloud database is an organized and managed collection of data in an IT system that resides on a public, private or hybrid cloud computing platform. Continue Reading
-
Definition
15 Apr 2024
database as a service (DBaaS)
Database as a service (DBaaS) is a cloud computing managed service offering that provides access to a database without requiring the setup of physical hardware, the installation of software or the need to configure the database. Continue Reading
-
Definition
15 Apr 2024
data classification
Data classification is the process of organizing data into categories that make it easy to retrieve, sort and store for future use. Continue Reading
-
Definition
10 Apr 2024
schema
In computer programming, a schema (pronounced SKEE-mah) is the organization or structure for a database, while in artificial intelligence (AI), a schema is a formal expression of an inference rule. Continue Reading
-
Tip
10 Apr 2024
Cloud database security: Best practices, challenges and threats
If your company is using a cloud database, it's critical to stay on top of security. Review the security features offered by top cloud providers, plus some best practices. Continue Reading
-
News
09 Apr 2024
Google Cloud to inject Gemini into data, analytics tools
The tech giant unveiled integrations between its LLM and BigQuery, Looker and its databases to provide customers with a foundation for developing GenAI models and applications. Continue Reading
-
Tip
03 Apr 2024
Vector vs. graph vs. relational database: Which to choose?
Vector databases enhance the use of generative AI. Organizations should consider how vector capabilities stack up vs. graph and relational databases before deciding which to use. Continue Reading
-
Definition
02 Apr 2024
serverless database
A serverless database is a type of cloud database that is fully managed for an organization by a cloud service provider and runs on demand as needed to support applications. Continue Reading
-
Feature
26 Mar 2024
Different types of database management systems explained
The various types of database software come with advantages, limitations and optimal uses that prospective buyers should be aware of before choosing a DBMS. Continue Reading
-
Definition
21 Mar 2024
big data management
Big data management is the organization, administration and governance of large volumes of both structured and unstructured data. Continue Reading
-
Tip
15 Mar 2024
Cloud DBA: How cloud changes database administrator's role
Cloud databases change the duties and responsibilities of database administrators. Here's how the job of a cloud DBA differs from what an on-premises one does. Continue Reading
-
Definition
15 Mar 2024
Microsoft SQL Server
Microsoft SQL Server is a relational database management system (RDBMS) that supports a wide variety of transaction processing, business intelligence (BI) and data analytics applications in corporate IT environments. Continue Reading
-
Tip
14 Mar 2024
Data management trends: GenAI, governance and lakehouses
The top data management trends of 2023 -- generative AI, data governance, observability and a shift toward data lakehouses -- are major factors for maximizing data value in 2024. Continue Reading
-
Feature
11 Mar 2024
Should you run your database on premises or in the cloud?
Use of cloud databases is surging, but there are still reasons for on-premises ones. Here's a comparison of cloud and local database architectures to help you choose. Continue Reading
-
News
29 Feb 2024
Snowflake CEO Slootman steps down, Ramaswamy takes over
Slootman resigns after five years at the helm of the data cloud vendor. Revenues grew fivefold under him and the company went public in a record-setting initial public offering. Continue Reading
-
Feature
07 Feb 2024
Treating data as a product a method to grow analytics use
Treating BI assets such as models and dashboards as commodities is an emerging trend as organizations continue to seek new ways of making analytics use more widespread. Continue Reading
-
Definition
25 Jan 2024
Google Bigtable
Google Bigtable is a distributed, column-oriented data store created by Google Inc. to handle very large amounts of structured data associated with the company's Internet search and Web services operations. Continue Reading
-
Definition
22 Jan 2024
transactional data
In computing, transactional data is the information collected from transactions. Continue Reading
-
Feature
09 Jan 2024
Companies still grappling with building modern data platforms
Data platforms are crucial for managing and delivering data efficiently, but a recent survey from Enterprise Strategy Group showed that companies still struggle to implement them. Continue Reading
-
News
06 Dec 2023
New MongoDB tools enable generative AI development
The independent database vendor added vector search and workload management tools that work together to enable developers to build and run cutting-edge analytics applications. Continue Reading
-
Definition
17 Nov 2023
5V's of big data
The 5 V's of big data -- velocity, volume, value, variety and veracity -- are the five main and innate characteristics of big data. Continue Reading
-
Definition
13 Nov 2023
vector search
Vector search, sometimes referred to as vector similarity search, is a technique that uses vectors -- numerical representations of data -- as the basis to conduct searches and identify relevance. Continue Reading
-
Tip
08 Nov 2023
Assemble the 6 layers of big data stack architecture
Assemble the six layers of a big data stack architecture to address the challenges organizations face with big data, which include increases in data size, speed and structure. Continue Reading
-
Definition
27 Oct 2023
OLAP (online analytical processing)
OLAP (online analytical processing) is a computing method that enables users to easily and selectively extract and query data in order to analyze it from different points of view. Continue Reading
-
Feature
17 Oct 2023
Do traditional data stacks have a use versus modern options?
Traditional data stacks differ from modern data stacks in the use of cloud and advanced analytics tools. Update on-premises data stacks to gain niche advantages over cloud options. Continue Reading
-
News
26 Sep 2023
MongoDB reveals new generative AI, vector search tools
After unveiling an integration with Google's LLM suite in June, the vendor moved a set of NLP tools into preview and introduced new data migration and vector search capabilities. Continue Reading
-
Opinion
20 Sep 2023
GenAI, Vector AI Search, multi-cloud top Oracle CloudWorld
Oracle CEO paints a bright picture of the future with generative AI, shares integration plans and expands Microsoft partnership. Continue Reading
-
News
14 Sep 2023
Dremio launches updated SQL query acceleration capabilities
The data lakehouse specialist's new version of its SQL query acceleration tool, Reflections, includes automated recommendations and automatic data refresh capabilities. Continue Reading
-
News
06 Sep 2023
InfluxData launches new database for self-managed users
The time series database vendor completed the InfluxDB 3.0 product line with the release of InfluxDB Clustered, a version tailored for private cloud and on-premises deployments. Continue Reading
-
News
30 Aug 2023
Couchbase intros generative AI feature for its Capella DBaaS
The database vendor's new tool -- now in private preview -- uses LLM technology to make application developers more efficient by helping them more easily generate code. Continue Reading
-
Definition
15 Aug 2023
C++
C++ is an object-oriented programming (OOP) language that is viewed by many as the best language for creating large-scale applications. C++ is a superset of the C language. Continue Reading
-
News
03 Aug 2023
SnapLogic launches generative AI tool for data integration
The vendor released SnapGPT, a generative AI tool that lets data engineers more efficiently develop data pipelines by using natural language. An early user is Barnard College. Continue Reading
-
News
24 Jul 2023
Oracle targets speed with launch of MySQL HeatWave Lakehouse
The tech giant's new lakehouse enables users of its database management suite to combine structured and unstructured data to develop a more complete view of their operations. Continue Reading
-
Feature
22 Jun 2023
Use knowledge graphs with databases to uncover new insights
Knowledge graphs work with graph databases to offer different data storage options than a traditional database, particularly in the biomedical, financial and product sectors. Continue Reading
-
News
22 Jun 2023
MongoDB unveils new AI, migration tools for database
The vendor, with its latest slate of new and updated capabilities, is adding generative AI with its partnership with Google Cloud and launching a new data migration tool. Continue Reading
-
News
20 Jun 2023
Starburst Galaxy update targets governance, data access
The vendor's latest update includes the public preview of Gravity, a centralized access and governance layer that enables users to better control and connect data across clouds. Continue Reading
-
News
15 Jun 2023
Monte Carlo boosts data observability with generative AI
The vendor unveiled tools aimed at improving engineering efficiency, one enabling data engineers to more easily fix code and another enabling code generation with natural language. Continue Reading
-
Tip
15 Jun 2023
When and how to run databases on Kubernetes
Deciding whether to move your database onto Kubernetes requires careful consideration, especially when choosing among deployment options. Here's what to keep in mind. Continue Reading
-
Feature
02 Jun 2023
Data mesh helping fuel Sloan Kettering's cancer research
The cancer hospital and research center began using tools from data management vendor Dremio two years ago to decentralize its data operations and improve speed-to-insight. Continue Reading
-
Definition
31 May 2023
data lakehouse
A data lakehouse is a data management architecture that combines the key features and the benefits of a data lake and a data warehouse. Continue Reading
-
Definition
31 May 2023
tuple
A tuple, pronounced TUH-pul, is an ordered and finite list of elements in various fields of interest, including computing. Continue Reading
-
Tip
22 May 2023
Blockchain vs. database: Similarities, differences explained
Choosing between blockchain and traditional databases -- or using them together -- requires knowing how each one handles data management and the skills needed to make them work. Continue Reading
-
Definition
22 May 2023
core banking system
A core banking system is the software that banks use to manage their most critical processes, such as customer accounts, transactions and risk management. Continue Reading
-
Feature
17 May 2023
Peloton rides, runs, rows with AWS for data management
The connected fitness company has long used AWS tools. When its data volume surged during COVID-19, Redshift was critical -- and still is as the company attempts a fiscal comeback. Continue Reading
-
Tip
15 May 2023
Mainframe databases teach an old dog new survival tricks
Long predicted to fade away in favor of more modern architectures, mainframes still play an integral role in corporate IT strategies, thanks to advances in database software. Continue Reading
-
News
24 Apr 2023
IBM acquires Ahana, steward of open source PrestoDB
The purchase not only gives IBM a managed SaaS and AWS marketplace version of the popular open-source Presto database, but membership in the Presto Foundation as well. Continue Reading
-
Definition
14 Mar 2023
transaction
In computing, a transaction is a set of related tasks treated as a single action. Continue Reading
- Definition 07 Mar 2023
-
Opinion
13 Feb 2023
Avoid data sprawl with a single source of truth
Enterprise Strategy Group research shows organizations are struggling with real-time data insights. A single source of truth can make operations more efficient and more accurate. Continue Reading
-
Feature
19 Jan 2023
Data management trends: Convergence and more money
The past year focused heavily on data intelligence, lakehouse development and observability as vendors innovated to help enterprises make effective use of converged data and technologies. Continue Reading
-
News
19 Jan 2023
DataStax acquires ML vendor as part of AI evolution
The acquisition will let customers apply machine learning to real-time events. It is a natural step toward AI technology for the vendor as it looks to stay competitive. Continue Reading
-
Definition
04 Jan 2023
structured data
Structured data is data that has been organized into a formatted repository, typically a database. Continue Reading
-
Definition
29 Dec 2022
database replication
Database replication is the frequent electronic copying of data from a database in one computer or server to a database in another -- so that all users share the same level of information. Continue Reading
-
Answer
28 Dec 2022
Comparing DBMS vs. RDBMS: Key differences
A relational database management system is the most popular type of DBMS for business uses. Find out how RDBMS software differs from other DBMS technologies. Continue Reading
-
Definition
21 Dec 2022
data source name (DSN)
A data source name (DSN) is a data structure containing information about a specific database to which an Open Database Connectivity (ODBC) driver needs to connect. Continue Reading
-
News
15 Dec 2022
Apache Cassandra 4.1 extends open source NoSQL database
The open source Cassandra database is out with its first major update in 18 months, bringing with it an improved consensus protocol to boost transaction performance. Continue Reading
-
News
13 Dec 2022
Aiven launches managed ClickHouse database as a service
The open source database cloud services vendor continues to expand the number of technologies it supports, adding new analytics capabilities in a managed offering. Continue Reading
-
News
13 Dec 2022
SingleStoreDB 8.0 brings WebAssembly to unified database
The database vendor updates its hybrid transactional and analytical database with new JSON data query acceleration technology and developer support for WebAssembly. Continue Reading
-
News
08 Dec 2022
CockroachDB brings user-defined functions to distributed SQL
User-defined functions land in Cockroach Labs' new database update aiming to improve application development. The release also adds Intelligent Insights for performance monitoring. Continue Reading
-
News
02 Dec 2022
EDB brings new tools to open source PostgreSQL database
The database vendor released new extensions designed to help PostgreSQL users with best practices for storage, user access and performance optimizations for database operations. Continue Reading
-
News
30 Nov 2022
AWS adds data quality, scalability services for cloud data
The cloud giant expanded its data portfolio with a series of features designed to help organizations more easily scale database and data warehouse deployments. Continue Reading
-
Definition
30 Nov 2022
OPAC (Online Public Access Catalog)
An OPAC (Online Public Access Catalog) is an online bibliography of a library collection that is available to the public Continue Reading