Database management
Terms related to databases, including definitions about relational databases and words and phrases about database management.SFX - ZON
- SFX (special effects) - SFX, an abbreviation for special effects, is a software product that makes it easy to create certain kinds of hypertext links within a collection of information such as the description of a library collection.
- sharding - Sharding is a type of database partitioning that is used to separate very large databases the into smaller, faster, more easily managed pieces called data shards.
- SOA repository - An SOA repository is a database containing the software and metadata that constitute an SOA registry.
- SPARQL - SPARQL is a declarative programming language and protocol used for analytics by graph databases.
- sparsity and density - Sparsity and density are terms used to describe the percentage of cells in a database table that are not populated and populated, respectively.
- splay tree - A splay tree is a self-adjusting search algorithm for placing and locating files (called records or keys) in a database.
- SQL (Structured Query Language) - SQL (Structured Query Language) is a standardized programming language that's used to manage relational databases and perform various operations on the data in them.
- SQL Azure - SQL Azure is Microsoft’s cloud database service.
- SQL injection - A SQL injection (SQLi) is a security exploit in which the attacker adds Structured Query Language (SQL) code to a Web form input box in order to gain access to unauthorized resources or make changes to sensitive data.
- SQL Server 2012 - Microsoft SQL Server 2012 is a relational database management system (RDBMS) designed for the enterprise environment.
- SQL Server 2014 - SQL Server 2014 is relational database management system (RDBMS) designed for the enterprise environment.
- SQL-on-Hadoop - SQL-on-Hadoop is a class of analytical application tools that combine established SQL-style querying with newer Hadoop data framework elements.
- SQLJ - SQLJ is a set of programming extensions that allow a programmer using the Java programming language to embed statements that provide SQL (Structured Query Language) database requests.
- stored procedure - A stored procedure is a group of statements with a specific name, which are stored inside a database, such as MySQL or Oracle.
- structured data - Structured data contrasts with unstructured and semi-structured data.
- Sybase - Sybase is a computer software company that develops and sells database management system (DBMS) and middleware products.
- system of record (SOR) - A system of record (SOR) is an ISRS (information storage and retrieval system) that is the authoritative source for a particular data element in a system containing multiple sources of the same element.
- 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.
- table - In computer programming, a table is a data structure used to organize information, just as it is on paper.
- tablespace - In a database management system (DBMS), a tablespace is a logical group of data files in a database.
- Teraplex (Teraplex Integration Center) - Teraplex (short for Teraplex Integration Center) is the name IBM has given to its 'real life' testing centers whose purpose is to allow IBM customers and business partners to test very large database (VLDB) applications on a full-scale basis by using.
- The Open Group - The Open Group is a software standards organization that is sponsored by a number of major software vendors.
- time series database (TSDB) - A time series database (TSDB) is a software system optimized to sort and organize information measured by time.
- tModel - A tModel is a data structure representing a service type (a generic representation of a registered service) in the UDDI (Universal Description, Discovery, and Integration) registry.
- Topic Map Query Language (TMQL) - Topic Map Query Language (TMQL) is an XML-based extension of Structured Query Language (SQL), a query language developed for use in meeting the specialized data access requirements of Topic Maps (TMs).
- transcription error - A transcription error is a specific type of data entry error that is commonly made by human operators or by optical character recognition (OCR) programs.
- tree structure - A tree structure is an algorithm for placing and locating files (called records or keys) in a database.
- trigger - A trigger (from the Dutch trekken, meaning to pull) is a lever which, when pulled by the finger, releases the hammer on a firearm.
- turnkey solution provider - A turnkey solution provider is a solution provider that offers limited consultation and one or more established product packages that allow only minimal configuration.
- Tuxedo (Transactions for UNIX, Enhanced for Distributed Operation) - Tuxedo (which stands for Transactions for UNIX, Enhanced for Distributed Operation) is a middleware product that uses a message-based communications system to distribute applications across various operating system platforms and databases.
- 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.
- UCCnet - UCCnet is a standards organization that provides an Internet-based supply chain management (SCM) data registry service for e-commerce companies and companies that have an e-commerce component.
- Universal Data Access (UDA) - Universal Data Access (UDA) is Microsoft's model or framework for a single uniform application program interface to different software makers' databases, both relational and nonrelational.
- Versioned Object Base (VOB) - A Versioned Object Base (VOB) is a centralized database that stores version information about the files and folders in a software configuration management (SCM) system.
- Very Large Database (VLDB) - While there is apparently no official or standard definition for the term Very Large Database (VLDB), it is sometimes used to describe databases occupying magnetic storage in the terabyte range and containing billions of table rows.
- view - In a database management system, a view is a way of portraying information in the database.
- virtual (federated) database - A virtual database, also called a federated database, is a system in which several databases appear to function as a single entity.
- virtual private database (VPD) - A Virtual Private Database (VPD) makes the database tables seem like they belong to one user when multiple users may actually be using that table.
- virtual storage area network (VSAN) - A virtual storage area network (VSAN) is a logical partition in a physical storage area network (SAN).
- VoltDB - VoltDB is an in-memory database.
- von Neumann bottleneck - The von Neumann bottleneck is a limitation on throughput caused by the standard personal computer architecture.
- Web services - Web services are a type of internet software that use standardized messaging protocols and are made available from an application service provider’s web server for use by a client or other web-based programs.
- Web-Braille - Web-Braille is a delivery system that allows content to be read on a Braille display or transmitted to a Braille embosser.
- WebLogic - BEA Systems' WebLogic is a server software application that runs on a middle tier, between back-end databases and related applications and browser-based thin clients.
- webMethods - webMethods is a company that specializes in business process integration software for the enterprise.
- What is data management and why is it important? - Data management is the process of ingesting, storing, organizing and maintaining the data created and collected by an organization, as explained in this in-depth look at the process.
- What is enterprise content management? Guide to ECM - Enterprise content management (ECM) is a set of defined processes, strategies and tools that allows a business to effectively obtain, organize, store and deliver critical information to its employees, business stakeholders and customers.
- wide-area file services (WAFS) - Wide-area file services (WAFS) is a storage technology that makes it possible to access a remote data center as though it were local.
- Windows Product Activation (WPA) - Windows Product Activation (WPA) is the mandatory product registration system included in Microsoft's Windows XP, Office XP, and recent Office products (such as Word 2002 or Excel 2002) as a means of enforcing compliance with the company's End User License Agreement (EULA).
- X - X# is the name that has been given to a "data-centric" programming language that Microsoft is said to be developing in order to make it easier for a programmer to specify XML-defined data and how it should be handled by the program.
- Xerces - Xerces (the name comes from the Xerces blue butterfly) is a set of parsers compatible with Extensible Markup Language (XML).
- XKeyscore - XKeyscore (XKS) is the front end search engine interface that interacts with all NSA federated databases for the collected Internet traffic, communicated data and phone metadata of private citizens.
- XQuery - XQuery is a specification for a query language that allows a user or programmer to extract information from an Extensible Markup Language (XML) file or any collection of data that can be XML-like.
- XSD (XML Schema Definition) - XSD is a W3C recommendation that defines the way to utilize the elements in an XML document.
- Yukon - Yukon is the code name used for the beta version of Microsoft's SQL Server 2005.
- Z39.50 - Z39.50 is a standard communications protocol for the search and retrieval of bibliographic data in online databases.
- zoning - In a storage area network (SAN), zoning is the allocation of resources for device load balancing and for selectively allowing access to data only to certain users.