Technical

API

Application Program Interface - A set of routines, protocols, and tools for building software applications. The API specifies how software components should interact and APIs are used when programming graphical user interface (GUI) components. A good API makes it easier to develop a program by providing all the building blocks. A programmer then puts the blocks together.

BI

Business intelligence - A set of techniques and tools for the acquisition and transformation of raw data into meaningful and useful information for business analysis purposes. In our case, this can reference our work with Jaspersoft, Talend, and our BI Tool that allows our clients to create their own reports.

DB

Database - A collection of information that is organized so that it can easily be accessed, managed, and updated.

DDL

Data Definition Language - A standard for commands that define the different structures in a database. DDL statements create, modify, and remove database objects such as tables, indexes, and users. Common DDL statements are CREATE, ALTER, and DROP.

ETL

Extract, Transform and Load refers to a process in database usage and especially in data warehousing that: Extracts data from homogeneous or heterogeneous data sources. Transforms the data for storing it in the proper format or structure for the purposes of querying and analysis.

JSON

JavaScript Object Notation - An open-standard format that uses human-readable text to transmit data objects consisting of attribute–value pairs. It is the most common data format used for asynchronous browser/server communication.

JSS

Jaspersoft Studio - The report designer software the Reports team and our BI Tool users use to build and design prebuilt/BI reports.

LDAP

Lightweight Directory Access Protocol - An open, vendor-neutral, industry standard application protocol for accessing and maintaining distributed directory information services over an Internet Protocol (IP) network

PHP

Personal Home Page (original); PHP: Hypertext Preprocessor (current) - A server-side scripting language designed for web development but also used as a general-purpose programming language.

PostgreSQL (or Postgres)

An object-relational database management system (ORDBMS) with an emphasis on extensibility and standards-compliance. As a database server, its primary function is to store data securely, supporting best practices, and to allow for retrieval at the request of other software applications. It can handle workloads ranging from small single-machine applications to large Internet-facing applications with many concurrent users. For our purposes, ATD utilizes PostgresSQL for database administration.

Repo

Short for repository - A storage location. For our purposes, where we story our data (e.g. jrxml files).

URL

Uniform Resource Locator - A URL is one type of Uniform Resource Identifier (URI); the generic term for all types of names and addresses that refer to objects on the World Wide Web. The term "Web address" is a synonym for a URL that uses the HTTP or HTTPS protocol.

SQL

Structured Query Language - special-purpose programming language designed for managing data held in a relational database management system (RDBMS), or for stream processing in a relational data stream management system. For our purposes, we use PostgreSQL is what is used to create queries for most prebuilt reports, it is also utilized throughout ATD for database interactions.