145 relations: Access control, ActiveX Data Objects, Adaptive Server Enterprise, ADO.NET, Application programming interface, Application software, Ashton-Tate, Assembly (CLI), Asynchronous I/O, B-tree, Binary large object, BMP file format, Business intelligence, Business Intelligence Development Studio, C (programming language), C Sharp (programming language), C++, Checksum, Cloud computing, Comma-separated values, Common Language Runtime, Comparison of data modeling tools, Comparison of object-relational database management systems, Comparison of relational database management systems, Computer cluster, Computer data storage, Concurrency control, Concurrent computing, Concurrent user, Data buffer, Data integration, Data mining, Data Mining Extensions, Data warehouse, Database, Database index, Database schema, Database server, Database trigger, Deadlock, Debug code, Decision tree learning, Declarative programming, Docker (software), Encryption, Extract, transform, load, GIF, Git, Graphical user interface, Heap (data structure), ..., IFilter, Import and export of data, Input/output, Integrated development environment, Intelligent code completion, Internet protocol suite, Inverted index, Join (SQL), JPEG, Library (computing), Linux, List of CLI languages, List of relational database management systems, Managed code, Massively parallel, Message queue, Microsoft, Microsoft Access, Microsoft Analysis Services, Microsoft Azure, Microsoft Azure SQL Database, Microsoft Press, Microsoft Visual Studio, Microsoft Windows, Microsoft Word, MSDE, MultiDimensional eXpressions, Multiversion concurrency control, Mutual exclusion, Naive Bayes classifier, Named pipe, Neural network, Object composition, OLAP cube, OLE DB, Online analytical processing, Open Database Connectivity, Optimistic concurrency control, OS/2, PDF, Petabyte, Platform as a service, Portable Network Graphics, Primitive data type, Proprietary software, Query optimization, Query plan, Red Hat Enterprise Linux, Regression analysis, Relational database, Relational database management system, Report Definition Language, Revoscalepy, RevoScaleR, Rounding, Scripting language, Select (SQL), Shared memory, Software, SQL, SQL CLR, SQL compliance, SQL Server Compact, SQL Server Express, SQL Server Integration Services, SQL Server Management Studio, SQL Server Reporting Services, Standard Libraries (CLI), Stored procedure, SUSE Linux Enterprise, Sybase, Tabular Data Stream, Terabyte, Thesaurus, TIFF, Total cost of ownership, Transact-SQL, Type safety, Type system, Ubuntu (operating system), User interface, View (SQL), Visual Basic .NET, Web service, Windows Internal Database, Windows Metafile, Windows NT, Windows Server, Windows service, Workflow, World Wide Web, XML, XML for Analysis, XQuery, .NET Framework. Expand index (95 more) » « Shrink index
In the fields of physical security and information security, access control (AC) is the selective restriction of access to a place or other resource.
In computing, Microsoft's ActiveX Data Objects (ADO) comprises a set of Component Object Model (COM) objects for accessing data sources.
SAP ASE (Adaptive Server Enterprise), originally known as Sybase SQL Server, and also commonly known as Sybase DB or Sybase ASE, is a relational model database server product for businesses developed by Sybase Corporation which became part of SAP AG.
ADO.NET is a data access technology from the Microsoft.NET Framework that provides communication between relational and non-relational systems through a common set of components.
In computer programming, an application programming interface (API) is a set of subroutine definitions, protocols, and tools for building software.
An application software (app or application for short) is a computer software designed to perform a group of coordinated functions, tasks, or activities for the benefit of the user.
Ashton-Tate (Ashton-Tate Corporation) was a US-based software company best known for developing the popular dBASE database application.
Defined by Microsoft for use in recent versions of Windows, an assembly in the Common Language Infrastructure (CLI) is a compiled code library used for deployment, versioning, and security.
In computer science, asynchronous I/O (also non-sequential I/O) is a form of input/output processing that permits other processing to continue before the transmission has finished.
In computer science, a B-tree is a self-balancing tree data structure that keeps data sorted and allows searches, sequential access, insertions, and deletions in logarithmic time.
A Binary Large OBject (BLOB) is a collection of binary data stored as a single entity in a database management system.
The BMP file format, also known as bitmap image file or device independent bitmap (DIB) file format or simply a bitmap, is a raster graphics image file format used to store bitmap digital images, independently of the display device (such as a graphics adapter), especially on Microsoft Windows and OS/2 operating systems.
Business intelligence (BI) comprises the strategies and technologies used by enterprises for the data analysis of business information.
Business Intelligence Development Studio (BIDS) is the former IDE from Microsoft, and was used to develop data analysis and Business Intelligence solutions utilizing the Microsoft SQL Server Analysis Services, Reporting Services and Integration Services.
C (as in the letter ''c'') is a general-purpose, imperative computer programming language, supporting structured programming, lexical variable scope and recursion, while a static type system prevents many unintended operations.
C# (/si: ʃɑːrp/) is a multi-paradigm programming language encompassing strong typing, imperative, declarative, functional, generic, object-oriented (class-based), and component-oriented programming disciplines.
C++ ("see plus plus") is a general-purpose programming language.
A checksum is a small-sized datum derived from a block of digital data for the purpose of detecting errors which may have been introduced during its transmission or storage.
Cloud computing is an information technology (IT) paradigm that enables ubiquitous access to shared pools of configurable system resources and higher-level services that can be rapidly provisioned with minimal management effort, often over the Internet.
In computing, a comma-separated values (CSV) file is a delimited text file that uses a comma to separate values.
The Common Language Runtime (CLR), the virtual machine component of Microsoft's.NET framework, manages the execution of.NET programs.
This article is a comparison of data modeling tools which are notable, including standalone, conventional data modeling tools and modeling tools supporting data modeling as part of a larger modeling environment.
This is a comparison of object-relational database management systems (ORDBMSs).
The following tables compare general and technical information for a number of relational database management systems.
A computer cluster is a set of loosely or tightly connected computers that work together so that, in many respects, they can be viewed as a single system.
Computer data storage, often called storage or memory, is a technology consisting of computer components and recording media that are used to retain digital data.
In information technology and computer science, especially in the fields of computer programming, operating systems, multiprocessors, and databases, concurrency control ensures that correct results for concurrent operations are generated, while getting those results as quickly as possible.
Concurrent computing is a form of computing in which several computations are executed during overlapping time periods—concurrently—instead of sequentially (one completing before the next starts).
In computer science, the number of concurrent users for a resource in a location, with the location being a computing network or a single computer, refers to the total number of people using the resource within a predefined period of time.
In computer science, a data buffer (or just buffer) is a region of a physical memory storage used to temporarily store data while it is being moved from one place to another.
Data integration involves combining data residing in different sources and providing users with a unified view of them.
Data mining is the process of discovering patterns in large data sets involving methods at the intersection of machine learning, statistics, and database systems.
Data Mining Extensions (DMX) is a query language for data mining models supported by Microsoft's SQL Server Analysis Services product.
In computing, a data warehouse (DW or DWH), also known as an enterprise data warehouse (EDW), is a system used for reporting and data analysis, and is considered a core component of business intelligence.
A database is an organized collection of data, stored and accessed electronically.
A database index is a data structure that improves the speed of data retrieval operations on a database table at the cost of additional writes and storage space to maintain the index data structure.
The database schema of a database system is its structure described in a formal language supported by the database management system (DBMS).
A database server is a server which houses a database application that provides database services to other computer programs or to computers, as defined by the client–server model.
A database trigger is procedural code that is automatically executed in response to certain events on a particular table or view in a database.
In concurrent computing, a deadlock is a state in which each member of a group is waiting for some other member to take action, such as sending a message or more commonly releasing a lock.
Debug code is computer code introduced to a computer program to test for errors or to help determine the cause of an error.
Decision tree learning uses a decision tree (as a predictive model) to go from observations about an item (represented in the branches) to conclusions about the item's target value (represented in the leaves).
In computer science, declarative programming is a programming paradigm—a style of building the structure and elements of computer programs—that expresses the logic of a computation without describing its control flow.
Docker is a computer program that performs operating-system-level virtualization also known as containerization.
In cryptography, encryption is the process of encoding a message or information in such a way that only authorized parties can access it and those who are not authorized cannot.
In computing, extract, transform, load (ETL) refers to a process in database usage and especially in data warehousing.
The Graphics Interchange Format, better known by its acronym GIF, is a bitmap image format that was developed by a team at the bulletin board service (BBS) provider CompuServe led by American computer scientist Steve Wilhite on June 15, 1987.
Git is a version control system for tracking changes in computer files and coordinating work on those files among multiple people.
The graphical user interface (GUI), is a type of user interface that allows users to interact with electronic devices through graphical icons and visual indicators such as secondary notation, instead of text-based user interfaces, typed command labels or text navigation.
In computer science, a heap is a specialized tree-based data structure that satisfies the heap property: if P is a parent node of C, then the key (the value) of P is either greater than or equal to (in a max heap) or less than or equal to (in a min heap) the key of C. The node at the "top" of the heap (with no parents) is called the root node.
An IFilter is a plugin that allows Microsoft's search engines to index various file formats (as documents, email attachments, database records, audio metadata etc.) so that they become searchable.
The import and export of data is the automated or semi-automated input and output of data sets between different software applications.
In computing, input/output or I/O (or, informally, io or IO) is the communication between an information processing system, such as a computer, and the outside world, possibly a human or another information processing system.
An integrated development environment (IDE) is a software application that provides comprehensive facilities to computer programmers for software development.
Intelligent code completion is a context-aware code completion feature in some programming environments that speeds up the process of coding applications by reducing typos and other common mistakes.
The Internet protocol suite is the conceptual model and set of communications protocols used on the Internet and similar computer networks.
In computer science, an inverted index (also referred to as postings file or inverted file) is an index data structure storing a mapping from content, such as words or numbers, to its locations in a database file, or in a document or a set of documents (named in contrast to a forward index, which maps from documents to content).
An SQL join clause combines columns from one or more tables in a relational database.
JPEG is a commonly used method of lossy compression for digital images, particularly for those images produced by digital photography.
In computer science, a library is a collection of non-volatile resources used by computer programs, often for software development.
Linux is a family of free and open-source software operating systems built around the Linux kernel.
CLI Languages are computer programming languages that are used to produce libraries and programs that conform to the Common Language Infrastructure (CLI) specifications.
This is a list of relational database management systems.
Managed code is computer program code that requires and will execute only under the management of a Common Language Runtime virtual machine, typically the.NET Framework, or Mono.
In computing, massively parallel refers to the use of a large number of processors (or separate computers) to perform a set of coordinated computations in parallel (simultaneously).
In computer science, message queues and mailboxes are software-engineering components used for inter-process communication (IPC), or for inter-thread communication within the same process.
Microsoft Corporation (abbreviated as MS) is an American multinational technology company with headquarters in Redmond, Washington.
Microsoft Access is a database management system (DBMS) from Microsoft that combines the relational Microsoft Jet Database Engine with a graphical user interface and software-development tools.
Microsoft SQL Server Analysis Services, SSAS, is an online analytical processing (OLAP) and data mining tool in Microsoft SQL Server.
Microsoft Azure (formerly Windows Azure) is a cloud computing service created by Microsoft for building, testing, deploying, and managing applications and services through a global network of Microsoft-managed data centers.
Microsoft Azure SQL Database (formerly SQL Azure, SQL Server Data Services, SQL Services, and Windows Azure SQL Database) is a managed cloud database (SaaS) provided as part of Microsoft Azure.
Microsoft Press is the publishing arm of Microsoft, usually releasing books dealing with various current Microsoft technologies.
Microsoft Visual Studio is an integrated development environment (IDE) from Microsoft.
Microsoft Windows is a group of several graphical operating system families, all of which are developed, marketed, and sold by Microsoft.
Microsoft Word (or simply Word) is a word processor developed by Microsoft.
Microsoft SQL Server Data Engine (MSDE, also Microsoft Data Engine or Microsoft Desktop Engine) is a relational database management system developed by Microsoft.
Multidimensional Expressions (MDX) is a query language for online analytical processing (OLAP) using a database management system.
Multiversion concurrency control (MCC or MVCC), is a concurrency control method commonly used by database management systems to provide concurrent access to the database and in programming languages to implement transactional memory.
In computer science, mutual exclusion is a property of concurrency control, which is instituted for the purpose of preventing race conditions; it is the requirement that one thread of execution never enter its critical section at the same time that another concurrent thread of execution enters its own critical section.
In machine learning, naive Bayes classifiers are a family of simple "probabilistic classifiers" based on applying Bayes' theorem with strong (naive) independence assumptions between the features.
In computing, a named pipe (also known as a FIFO for its behavior) is an extension to the traditional pipe concept on Unix and Unix-like systems, and is one of the methods of inter-process communication (IPC).
The term neural network was traditionally used to refer to a network or circuit of neurons.
In computer science, object composition (not to be confused with function composition) is a way to combine simple objects or data types into more complex ones.
In database engineering in computing, OLAP cube is a term that typically refers to a multi-dimensional array of data.
OLE DB (Object Linking and Embedding, Database, sometimes written as OLEDB or OLE-DB), an API designed by Microsoft, allows accessing data from a variety of sources in a uniform manner.
Online analytical processing, or OLAP, is an approach to answering multi-dimensional analytical (MDA) queries swiftly in computing.
In computing, Open Database Connectivity (ODBC) is a standard application programming interface (API) for accessing database management systems (DBMS).
Optimistic concurrency control (OCC) is a concurrency control method applied to transactional systems such as relational database management systems and software transactional memory.
OS/2 is a series of computer operating systems, initially created by Microsoft and IBM under the leadership of IBM software designer Ed Iacobucci.
The Portable Document Format (PDF) is a file format developed in the 1990s to present documents, including text formatting and images, in a manner independent of application software, hardware, and operating systems.
The petabyte is a multiple of the unit byte for digital information.
Platform as a Service (PaaS) or application platform as a Service (aPaaS) or platform base service is a category of cloud computing services that provides a platform allowing customers to develop, run, and manage applications without the complexity of building and maintaining the infrastructure typically associated with developing and launching an app.
Portable Network Graphics (PNG, pronounced or) is a raster graphics file format that supports lossless data compression.
In computer science, primitive data type is either of the following.
Proprietary software is non-free computer software for which the software's publisher or another person retains intellectual property rights—usually copyright of the source code, but sometimes patent rights.
Query optimization is a function of many relational database management systems.
A query plan (or query execution plan) is an ordered set of steps used to access data in a SQL relational database management system.
Red Hat Enterprise Linux (RHEL) is a Linux distribution developed by Red Hat and targeted toward the commercial market.
In statistical modeling, regression analysis is a set of statistical processes for estimating the relationships among variables.
A relational database is a digital database based on the relational model of data, as proposed by E. F. Codd in 1970.
A relational database management system (RDBMS) is a database management system (DBMS) based on the relational model invented by Edgar F. Codd at IBM's San Jose Research Laboratory.
Report Definition Language (RDL) is a standard proposed by Microsoft for defining reports.
revoscalepy is a machine learning package in Python created by Microsoft.
RevoScaleR is a machine learning package in R created by Microsoft.
Rounding a numerical value means replacing it by another value that is approximately equal but has a shorter, simpler, or more explicit representation; for example, replacing $ with $, or the fraction 312/937 with 1/3, or the expression with.
A scripting or script language is a programming language that supports scripts: programs written for a special run-time environment that automate the execution of tasks that could alternatively be executed one-by-one by a human operator.
The SQL SELECT statement returns a result set of records from one or more tables.
In computer science, shared memory is memory that may be simultaneously accessed by multiple programs with an intent to provide communication among them or avoid redundant copies.
Computer software, or simply software, is a generic term that refers to a collection of data or computer instructions that tell the computer how to work, in contrast to the physical hardware from which the system is built, that actually performs the work.
SQL (S-Q-L, "sequel"; Structured Query Language) is a domain-specific language used in programming and designed for managing data held in a relational database management system (RDBMS), or for stream processing in a relational data stream management system (RDSMS).
SQL CLR or SQLCLR (SQL Common Language Runtime) is technology for hosting of the Microsoft.NET common language runtime engine within SQL Server.
|| |- ! F021 || Basic information schema || || || || || || || || |- | F021–01 || COLUMNS view || || || || || Also includes MySQL-specific extension columns || || || |- | F021–02 || TABLES view || || || || || || || || |- | F021–03 || VIEWS view || || || || || || || || |- | F021–04 || TABLE_CONSTRAINTS view || || || || || || || || |- | F021–05 || REFERENTIAL_CONSTRAINTS view || || || || || || || || |- | F021–06 || CHECK_CONSTRAINTS view || || || || || || || || |- ! F031 || Basic schema manipulation || || || || || || || || |- | F031–01 || CREATE TABLE statement to create persistent base tables || || || || || || || || |- | F031–02 || CREATE VIEW statement || || || || || || || || |- | F031–03 || GRANT statement || || || || || || || || |- | F031–04 || ALTER TABLE statement: ADD COLUMN clause || || || || || || || || |- | F031–13 || DROP TABLE statement: RESTRICT clause || || || || || || || || |- | F031–16 || DROP VIEW statement: RESTRICT clause || || || || || || || || |- | F031–19 || REVOKE statement: RESTRICT clause || || || || || || || || |- ! F041 || Basic joined table || || || || || || || || |- | F041–01 || Inner join (but not necessarily the INNER keyword) || || || || || || || || |- | F041–02 || INNER keyword || || || || || || || || |- | F041–03 || LEFT OUTER JOIN || || || || || || || || |- | F041–04 || RIGHT OUTER JOIN || || || || || || || || |- | F041–05 || Outer joins can be nested || || || || || || || || |- | F041–07 || The inner table in a left or right outer join can also be used in an inner join || || || || || || || || |- | F041–08 || All comparison operators are supported (rather than just.
Microsoft SQL Server Compact (SQL CE) is a compact relational database produced by Microsoft for applications that run on mobile devices and desktops.
Microsoft SQL Server Express is a version of Microsoft's SQL Server relational database management system that is free to download, distribute and use.
SQL Server Integration Services (SSIS) is a component of the Microsoft SQL Server database software that can be used to perform a broad range of data migration tasks.
SQL Server Management Studio (SSMS) is a software application first launched with Microsoft SQL Server 2005 that is used for configuring, managing, and administering all components within Microsoft SQL Server.
SQL Server Reporting Services (SSRS) is a server-based report generating software system from Microsoft.
The Common Language Infrastructure (CLI) includes the Standard Libraries in order to encapsulate a large number of common functions, such as file reading and writing, XML document manipulation, exception handling, application globalization, network communication, threading and reflection, which makes the programmer's job easier.
A stored procedure (also termed proc, storp, sproc, StoPro, StoredProc, StoreProc, sp, or SP) is a subroutine available to applications that access a relational database management system (RDBMS).
SUSE Linux Enterprise Server (SLES) is a Linux-based operating system developed by SUSE.
Sybase was an enterprise software and services company that produced software to manage and analyze information in relational databases.
Tabular Data Stream (TDS) is an application layer protocol, used to transfer data between a database server and a client.
The terabyte is a multiple of the unit byte for digital information.
In general usage, a thesaurus is a reference work that lists words grouped together according to similarity of meaning (containing synonyms and sometimes antonyms), in contrast to a dictionary, which provides definitions for words, and generally lists them in alphabetical order.
Tagged Image File Format, abbreviated TIFF or TIF, is a computer file format for storing raster graphics images, popular among graphic artists, the publishing industry, and photographers.
Total cost of ownership (TCO) is a financial estimate intended to help buyers and owners determine the direct and indirect costs of a product or system.
Transact-SQL (T-SQL) is Microsoft's and Sybase's proprietary extension to the SQL (Structured Query Language) used to interact with relational databases.
In computer science, type safety is the extent to which a programming language discourages or prevents type errors.
In programming languages, a type system is a set of rules that assigns a property called type to the various constructs of a computer program, such as variables, expressions, functions or modules.
Ubuntu (stylized as ubuntu) is a free and open source operating system and Linux distribution based on Debian.
The user interface (UI), in the industrial design field of human–computer interaction, is the space where interactions between humans and machines occur.
In a database, a view is the result set of a stored query on the data, which the database users can query just as they would in a persistent database collection object.
Visual Basic.NET (VB.NET) is a multi-paradigm, object-oriented programming language, implemented on the.NET Framework.
The term web service is either.
Windows Internal Database (codenamed WYukon, sometimes referred to as SQL Server Embedded Edition) is a variant of SQL Server Express 2005–2014 that is included with Windows Server 2008 (SQL 2005), Windows Server 2008 R2 (SQL 2005), Windows Server 2012 (SQL 2012), Windows Server 2012 R2 (SQL 2012) and Windows Server 2016 (SQL 2014) and is included with other free Microsoft products released after 2007 that require an SQL Server database backend.
Windows Metafile (WMF) is an image file format originally designed for Microsoft Windows in the 1990s.
Windows NT is a family of operating systems produced by Microsoft, the first version of which was released in July 1993.
Windows Server is a brand name for a group of server operating systems released by Microsoft.
In Windows NT operating systems, a Windows service is a computer program that operates in the background.
A workflow consists of an orchestrated and repeatable pattern of business activity enabled by the systematic organization of resources into processes that transform materials, provide services, or process information.
The World Wide Web (abbreviated WWW or the Web) is an information space where documents and other web resources are identified by Uniform Resource Locators (URLs), interlinked by hypertext links, and accessible via the Internet.
In computing, Extensible Markup Language (XML) is a markup language that defines a set of rules for encoding documents in a format that is both human-readable and machine-readable.
XML for Analysis (abbreviated as XMLA) is an industry standard for data access in analytical systems, such as OLAP and data mining.
XQuery (XML Query) is a query and functional programming language that queries and transforms collections of structured and unstructured data, usually in the form of XML, text and with vendor-specific extensions for other data formats (JSON, binary, etc.). The language is developed by the XML Query working group of the W3C.
.NET Framework (pronounced dot net) is a software framework developed by Microsoft that runs primarily on Microsoft Windows.
Data Source Views, MS SQL, MS SQL Server, MS-SQL, MSSQL, Microsoft SQL, Microsoft SQL Server 2000, Microsoft SQL Server 2005, Microsoft SQL Server 2008, Microsoft SQL Server 2008 R2, Microsoft SQL Server Compare Tools, Microsoft SQL server, Microsoft Sql Server, Microsoft sql server, Ms sql server, Mssql, Port 1433, Pubs (database), SQL 6.5, SQL 7.0, SQL Server 2000, SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, SQL Server 2012, SQL Server 2014, SQL Server 2014 CAB, SQL Server 2014 ISO, SQL Server 2016, Sql Server 2000, Sys.sysobjects.