Database management
Terms related to databases, including definitions about relational databases and words and phrases about database management.LIS - SEG
- LISP (list processing) - LISP, an acronym for list processing, is a programming language that was designed for easy manipulation of data strings.
- lock - A lock is a mechanism for controlling access to something.
- machine learning - Machine learning (ML) is a type of artificial intelligence (AI) that allows software applications to become more accurate at predicting outcomes without being explicitly programmed to do so.
- managed file transfer (MFT) - Managed file transfer (MFT) is a type of software used to provide secure internal, external and ad-hoc data transfers through a network.
- 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.
- marketing encyclopedia - A marketing encyclopedia is an application with an online interface to a database of information that a sales person might want to help a customer make a purchase decision.
- master file table (MFT) - The master file table (MFT) is a database in which information about every file and directory on an NT File System (NTFS) volume is stored.
- Memcached - Memcached is an open source, distributed memory object caching system that alleviates database load to speed up dynamic Web applications.
- message-driven processing - Message-driven processing is an approach used within the client/server computing model in which a client (for example, your Web browser) sends a service request in the form of a specially-formatted message to a program that acts as a request broker, handling messages from many clients intended for many different server applications.
- meta - Metadata is a description of data.
- metabase (metadatabase or metadata repository) - A metabase (sometimes called a metadatabase or metadata repository) is a database for storing metadata (data that describes data) for a specific purpose.
- metadata repository - A metadata repository is a database of data about data (metadata).
- metainformation - Metainformation is information about information.
- Microsoft Office SharePoint Server (MOSS) - Microsoft Office SharePoint Server (MOSS) is the full version of a portal-based platform for collaboratively creating, managing and sharing documents and Web services.
- Microsoft SQL Server - Microsoft SQL Server is a relational database management system, or RDBMS, that supports a wide variety of transaction processing, business intelligence and analytics applications in corporate IT environments.
- Microsoft SQL Server Management Studio (SSMS) - Microsoft SQL Server Management Studio (SSMS) is an integrated environment to manage a SQL Server infrastructure.
- Microsoft SQL Server Parallel Data Warehouse (SQL Server PDW) - Microsoft SQL Server Parallel Data Warehouse (SQL Server PDW) is a pre-built data warehouse appliance that includes Microsoft SQL Server database software, third-party server hardware and networking components.
- 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.
- Microsoft Visual FoxPro (Microsoft VFP) - Microsoft Visual FoxPro (VFP) is an object-oriented programming environment with a built-in relational database engine.
- middleware - Middleware is software that is used to bridge the gap between applications and other tools or databases.
- MOLAP (multidimensional online analytical processing) - MOLAP (multidimensional online analytical processing) is online analytical processing (OLAP) that indexes directly into a multidimensional database.
- MongoDB - MongoDB is an open source NoSQL database management program.
- MPP database (massively parallel processing database) - An MPP database is a database that is optimized to be processed in parallel for many operations to be performed by many processing units at a time.
- multidimensional database (MDB) - A multidimensional database (MDB) is a type of database that is optimized for data warehouse and online analytical processing (OLAP) applications.
- multidimensional expressions (MDX) - multidimensional expressions (MDX).
- multimodel database - A multimodel database is a data processing platform that supports multiple data models, which define the parameters for how the information in a database is organized and arranged.
- MySQL Connector/ODBC (Connector ODBC or MyODBC) - MySQL Connector/ODBC (sometimes called just Connector ODBC or MyODBC) is a driver for connecting to a MySQL database server through the Open Database Connectivity (ODBC) application program interface (API), which is the standard means of connecting to any database.
- National Electronic Disease Surveillance System (NEDSS) - The National Electronic Disease Surveillance System (NEDSS) is a secure online framework that allows healthcare professionals and government agencies to communicate about disease patterns and coordinate national response to outbreaks.
- national identity card - A national identity card is a portable document, typically a plasticized card with digitally-embedded information, that someone is required or encouraged to carry as a means of confirming their identity.
- Neo4j - Neo4j is a NoSQL graph database management system.
- NewSQL - NewSQL is a term coined by the analyst firm The 451 Group as shorthand to describe vendors of new, scalable, high performance SQL databases.
- NoSQL (Not Only SQL database) - NoSQL is an approach to database design that can accommodate a wide variety of data models, including key-value, document, columnar and graph formats.
- NoSQL DBMS (Not only SQL database management system) - Understanding the types of NoSQL DBMSes that are available is an important requirement for modern application development.
- Ntdsutil - Ntdsutil.exe is a command-line tool for accessing and managing a Windows Active Directory database.
- NuoDB - NuoDB is a SQL-oriented transactional database management system designed for distributed deployment in the cloud.
- Object Management Group (OMG) - The OMG (Object Management Group) was formed in 1989 by a group of vendors for the purpose of creating a standard architecture for distributed objects (also known as "components") in networks.
- Object Request Broker (ORB) - Also see ORBS, a term easily confused with ORB.
- object-oriented database management system (OODBMS) - An object-oriented database management system (OODBMS), sometimes shortened to ODBMS for object database management system, is a database management system (DBMS) that supports the modelling and creation of data as objects.
- ODL (Open and Distance Learning) - Open and Distance Learning (ODL) is a general term for the use of telecommunication to provide or enhance learning.
- 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.
- OLAP cube - An OLAP cube is a multidimensional database that is optimized for data warehouse and online analytical processing (OLAP) applications.
- OLE DB (OLEDB or Object Linking and Embedding Database) - OLE DB is Microsoft's strategic low-level application program interface (API) for access to different data sources.
- online data backup (remote data backup) - Online data backup (remote data backup) is a method of off-site storage in which data is regularly backed up over a network on a remote server, typically hosted by a provider.
- 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.
- Open Database Connectivity (ODBC) - Open Database Connectivity (ODBC) is an open standard application programming interface (API) for accessing a database.
- operational data store (ODS) - An operational data store (ODS) is a type of database that's often used as an interim logical area for a data warehouse.
- 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.
- Oracle Autonomous Database - Oracle Autonomous Database is a cloud-based technology designed to automate many of the routine tasks required to manage Oracle databases, which Oracle says can free up database administrators (DBAs) to do higher-level and more strategic work.
- Oracle Critical Patch Update (Oracle CPU) - The Oracle Critical Patch Update (CPU) is an ongoing series of regularly issued fixes for security flaws in products made by or maintained by software giant Oracle Corp.
- Oracle Database 12c - The Oracle Database 12c is a high-performance, enterprise-class database.
- Oracle Database In-Memory - Oracle Database In-Memory is an optional add-on to Oracle Database 12c that enables Oracle's flagship relational software to function as an in-memory database.
- Oracle extents - Oracle extents are a set of contiguous blocks allocated in an Oracle database.
- Oracle NoSQL Database - The Oracle NoSQL Database is a nonrelational, horizontally scalable key-value database, with multiple higher-level data abstractions that support data management as binary key-value pairs, JSON objects, and SQL-like tables.
- Oracle RMAN (Oracle Recovery Manager) - Oracle RMAN (Oracle Recovery Manager) is a utility built into Oracle databases to automate backup and recovery; it includes features not available in third-party backup tools.
- Oracle TimesTen In-Memory Database - The Oracle TimesTen In-Memory Database is an in-memory relational database in which all data is located in random access memory (RAM).
- parallel processing software - Parallel processing software manages the execution of a program on parallel processing hardware with the objectives of obtaining unlimited scalability (being able to handle an increasing number of interactions at the same time) and reducing execution time.
- personal health record (PHR) - A personal health record (PHR) is a collection of health-related information that is documented and maintained by the individual it pertains to.
- phtml suffix (PHP) - A PHTML (or it's sometimes called a PHP) page is a Web page that includes a script written in PHP, a language comparable to JavaScript or Microsoft's VBScript.
- Pick - Pick is a data base management system (DMS) based on a business model of data and its organization and traditionally associated with minicomputer systems for small- to medium-size businesses.
- 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.
- PKZIP (or PKZip) - PKZIP (also capitalized as PKZip) is a program, originally written for the DOS operating system, that gathers multiple files into a single compressed file that can be stored in less space and transmitted more quickly from one place to another.
- PL/SQL (procedural language extension to Structured Query Language) - In Oracle database management, PL/SQL is a procedural language extension to Structured Query Language (SQL).
- PMML (Predictive Model Markup Language) - PMML (Predictive Model Markup Language) is an XML-based language that enables the definition and sharing of predictive models between applications.
- PostgreSQL - PostgreSQL (pronounced "post-gress-Q-L") is an open source relational database management system (DBMS) developed by a worldwide team of volunteers.
- predictive modeling - Predictive modeling, also called predictive analytics, is a mathematical process that seeks to predict future events or outcomes by analyzing patterns that are likely to forecast future results.
- presentation management - Presentation management is the supervised creation, distribution, updating and publishing of messages and visuals in presentations across an entire enterprise.
- Presto - Presto is a free and open source distributed SQL query engine designed for the demands of big data.
- primary key (primary keyword) - A primary key, also called a primary keyword, is a key in a relational database that is unique for each record.
- quad tree - A quad tree is a method of placing and locating files (called records or keys) in a database.
- query - A query is a question, often expressed in a formal way.
- Query by Example (QBE) - Query by Example (QBE) is a method of query creation that allows the user to search for documents based on an example in the form of a selected text string or in the form of a document name or a list of documents.
- querystring - A querystring is a set of characters input to a computer or Web browser and sent to a query program to recover specific information from a database.
- raw data (source data or atomic data) - Raw data (sometimes called source data or atomic data) is data that has not been processed for meaningful use.
- 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.
- read-only - Read-only is a file attribute which only allows a user to view a file, restricting any writing to the file.
- Real Application Cluster (RAC) - Real Application Cluster (RAC) is a component of the Oracle 9i database product that allows a database to be installed across multiple servers.
- record - In computer data processing, a record is a collection of data items arranged for processing by a program.
- record standardization - In data management, record standardization is a process in which files are first parsed (assigned to appropriate fields in a database record) and then translated to a common format.
- Redis - Redis is an open source key-value database that supports various data structures.
- refactoring - Refactoring is "the process of changing a software system in such a way that it does not alter the external behavior of the code yet improves its internal structure," according to Martin Fowler, the "father" of refactoring.
- relational database - A relational database is a collection of information that organizes data points with defined relationships for easy access.
- relational online analytical processing (ROLAP) - Relational online analytical processing (ROLAP) is a form of online analytical processing (OLAP) that performs dynamic multidimensional analysis of data stored in a relational database rather than in a multidimensional database (which is usually considered the OLAP standard).
- Remote Data Objects (RDO) - RDO (Remote Data Objects) is an application program interface (API) from Microsoft that lets programmers writing Windows applications get access to and from both Microsoft and other database providers.
- replication - Replication (pronounced rehp-lih-KA-shun) is the process of making a replica (a copy) of something.
- repository - In information technology, a repository (pronounced ree-PAHZ-ih-tor-i) is a central place in which an aggregation of data is kept and maintained in an organized way, usually in computer storage.
- responsibility - In an Oracle environment, a responsibility is a defined user right, similar to the word privilege in some other settings.
- RFM analysis (recency, frequency, monetary) - RFM (recency, frequency, monetary) analysis is a marketing technique used to determine which customers are the best ones by examining how often a customer buys (recency), how long it's been since their last purchase (frequency), and.
- rollback - A rollback is the undoing of partly completed database changes when a database transaction is determined to have failed.
- row - In a database, a row (sometimes called a record) is the set of fields within a table that are relevant to a specific entity.
- SAP Basis - Basis is a set of middleware programs and tools from SAP, the German company whose comprehensive R/3 product is used to help manage large corporations.
- SAP BW (Business Warehouse) - SAP Business Warehouse (BW) is a model-driven data warehousing product based on the SAP NetWeaver ABAP platform.
- SAP HANA - SAP HANA is an in-memory database and application development platform for processing high volumes of data in real time.
- SAP Integration Repository - SAP Integration Repository is the design configuration piece of the SAP Exchange Infrastructure (XI), the process integration layer of the NetWeaver component from SAP, the company that sells a widely-used enterprise application platform.
- SAP S/4HANA - SAP S/4HANA is an ERP business suite based on the SAP HANA in-memory database that allows companies to perform transactions and analyze business data in real-time.
- SAX (Simple API for XML) - SAX (Simple API for XML) is an application program interface (API) that allows a programmer to interpret a Web file that uses the Extensible Markup Language (XML) -- that is, a Web file that describes a collection of data.
- schema - In computer programming, a schema (pronounced SKEE-mah) is the organization or structure for a database.
- segment - A segment is a defined portion or section of something larger such as a database, geometric object, or network.