Acronym's used in SQL quering
Their are bunch of Acronym's which are in some way related during SQL quering, which are good to know as it makes life eaiser.
SQL
Structure Query Language
SSMS
SQL Server Managment Studio
Alias
A suedo name for a database object
CTE
Common Table Expression
ACID
The acronym ACID (Atomicity, Consistency, Isolation, Durability) is related to the transactions. Most database management systems allow atomic, coherent, isolated and durable transactions.
ASE
Sybase ASE or Sybase Adaptive Server Enterprise is the historic transactional engine of the Sybase editor, suitable for atomic transactions in a highly competitive environment.
AWK
awk is a row processing language for complex find, replace, and transform operations. The acronym is the names of the three authors of this language (Alfred Aho, Peter Weinberger, Brian Kernighan).
awk, nawk and gawk utilities - Tutorial - November 2nd, 2020
BCP
BCP (Business Continuity Plan) is the term for business continuity plan. The BCP plan consists of resuming IT systems activity as soon as possible after a disaster (fires, floods, etc.) . bcp (bulk copy) is also a utility in Sybase and Microsoft SQL Server clients to export/import data from a database.
CIS
CIS (Component Integration Services) are Sybase technologies allowing access to data external to a Sybase Adaptive Server Enterprise server and querying them as if they were local (remote ASE servers, other engines like IQ, Oracle, DB2, MS SQL…, files).
Cluster
In network and systems, a cluster is a cluster of servers made up of at least two servers (also called nodes) and sharing a common disk bay, to ensure service continuity and/or to distribute the computational load and/or the network load.
CRUD
In computer programming, CRUD (Create, Read, Update, Delete/Destroy) are the four basic functions of persistent storage.
Datamart
A Datamart or data store is a subset of a relational database containing aggregated informations or targeted data for a specific business. Datamarts are decision support or management tools and are part of business intelligence.
DBCC
DBCC (DataBase Consistency Checker) is a set of commands available in Sybase and SQL Server engines to diagnose or verify the integrity of databases (pages read, allocations checks, traces on processes, etc.).
DBMS
DBMS means Database Management System. The acronym RDBMS meaning Relational Database Management System is one variant.
DDL
DDL (Data Definition Language) is the acronym that designates all the SQL commands to structurally modify a database and its objects (creation of tables, indexes, views…, alterations…). For example, the CREATE TABLE, ALTER TABLE, DROP TABLE commands are commands in the DDL language.
DML
The acronym DML (Data Manipulation Language) is the set of all the SQL commands handling data in a database: reading, writing, sorting, etc. For example : INSERT, UPDATE, DELETE, SELECT, ORDER BY, GROUP BY.
DSS
DSS (Decision Support Systems) refers to the tools or methods to collect, consolidate, model and restore a company's data in order to provide decision support. DSS applications are generally based on data warehouses, data coming from several heterogeneous sources.
DTS
DTS (Data Transformation Services) is the Microsoft proprietary technical layer for data flows design (extraction, transformation, loading).
ETL
ETL means Extract Transform Load. An ETL tool performs data flows from and to databases or files. Some of the most popular ETL tools :
Extent
An extent is a contiguous storage area reserved for a database object (tables, indexes, partitions, etc.). An extent reduces or eliminates fragmentation.
FTP
FTP (File Transfer Protocol) is a protocol for file transfers. ftp is also a Unix/Linux and Windows utility that uses this protocol.
HA
HA (High Availability) systems are high availability environments : if one component fails, another system takes over. High availability manages fault tolerance. Almost all database engines offer high availability solutions.
LDAP
Lightweight Directory Active Protocol (LDAP) is the protocol for querying and modifying a company’s directory services (groups, organizations, countries, accounts, etc.).
OLAP
OLAP means Online Analytical Processing. OLAP applications analyze instantly data along several axes to produce summary reports and provide decision-making support.
OLTP
The acronym OLTP means On-Line Transactional Processing and is related to online transaction processing in a database (INSERT / UPDATE / DELETE). So-called OLTP databases support well a large number of concurrent atomic transactions.
PL/SQL
PL/SQL (Procedural Language / Structured Query Language) is the proprietary procedural language in Oracle databases.
RAC
RAC (Real Application Clusters) is the Oracle product for high availability solutions with clustered Oracle instances.
REST
REST (REpresentational State Transfer) is a software architectural style that defines a set of constraints to be used for creating Web services. Used mainly in HTTP requests, available operations are : GET, HEAD, POST, PUT, PATCH, DELETE, CONNECT, OPTIONS and TRACE
RPC
RPC (Remote Procedure Call) is a network protocol for calling procedures on a remote computer. For databases, RPC runs a routine located on a remote database server.
RTDS
RTDS means Real Time Data Services and corresponds to the technologies developed by Sybase to set up real time gateways between the Sybase Adaptive Server Enterprise databases or the Sybase Replication Server engine to message bus such as MQ Series or Tibco.
SED
Sed (Stream Editor) is a powerful Unix command for handling text. Sed reads input data line by line and the lines are modified with rules specified in its own language (sed program).
SEO
SEO (Search Optimization Engine) is a set of techniques designed to promote the understanding of the topic and the content of one or all pages of a website by search engines.
SOAP
SOAP means Simple Object Access Protocol. Built with XML, SOAP is a remote procedure call protocol for exchanging information within a distributed architecture.
SSO
SSO (Single Sign On) refers to single sign-on. This method allows a user to perform only one authentication to access corporate applications. The SSO method is generally based on querying the company’s LDAP directories and avoids the tedious multiplication of passwords to remember for the user. Most databases support SSO to perform authentication, unfortunately often through a licensed option.
T-SQL
T-SQL (Transact Structured Query Language) is a proprietary extension from Microsoft and Sybase to the SQL language. Compared to SQL language, T-SQL adds procedural programming (loops, triggers, stored procedures…), local variables and system functions for handling strings, dates, mathematical expressions…
UDF
UDF (User Defined Functions) in a database engine are functions defined by users in T-SQL, PL/SQL etc… The user functions are, like the system functions, evaluated in SQL commands. Scalar functions return a single value while tabular functions return a table with a result set.
XML
XML (eXtensible Markup Language) is an extension of the HTML language. The term extensible for this language comes from the ability for the user to define custom tags and attributes through namespaces.
YAML
YAML - Ain’t Markup Language. It is not a markup language. Data is represented as scalars, lists and arrays with possible nestings. The YAML format is much simpler than XML, and even more human readable than the JSON format.
Next Stop: SQL Commands