RSS Feed

Databases

DSN (Data Source Name)

DSN (Data Source Name)

A DSN (Data Source Name) is an identifier that is used to store information relating to a database connection. DSNs can store a database’s name and server location, the directory that is used to store offline content, the database driver, and the user’s ID and password.

MOLAP

MOLAP

MOLAP is the term used to refer to multidimensional online analytical processing. It extends traditional OLAP processing through indexing directly into a multidimensional database. This allows users to view various data aggregates in different manners without the added overhead required to conduct similar operations with a relational database.

DBMS (Database Management System)

DBMS (Database Management System)

A database management system (DBMS) is a collection of computer programs that controls databases in every way–creation, maintenance and use of the database. Specifically, it enables an organization to hand power and control of the database into the hands of the administrators and other specialists who understand the database.

Data Mart

Data Mart

Most people are familiar with terms like data warehousing, data mining, and data cleansing, but fewer people are familiar with data mart. A data mart is a subsection of a data warehouse that deals with specific information.

OLAP Cube

OLAP Cube

When a company or organization wants to combine all of their information and resources into one stockpile for easier analysis and research, they use the OLAP cube to comprehensively link and find the information that they need.

Flat File

Flat File

A computer, in its most simplified definition, is nothing more than a device that stores, processes, communicates, and manipulates data. Data is at the heart of every computer program, every web site, and even every video game.

SQL (Structured Query Language)

SQL (Structured Query Language)

SQL (Structured Query Language) is the most common standardized database language used to create, retrieve, access, modify, controland manage relational databases. SQL is a querying language exclusively designed for controlling data and managing databases effectively.

BLOB (Binary Large OBject)

BLOB (Binary Large OBject)

A BLOB (Binary Large OBject) is a large chunk of data which is stored in a database.
A BLOB differs from regular database data in that it is not forced into a certain structure. A normal database field might be structured to be 14 characters long and only accept lowercase letters.

ODBC (Open Database Connectivity)

ODBC (Open Database Connectivity)

ODBC (Open Database Connectivity) is an interface to access databases via SQL queries. ODBC can be used as an access tool to various databases such as MS-Access, dBase, DB2, Excel, and Text.

JDBC (Java Data Base Connectivity)

JDBC (Java Data Base Connectivity)

JDBC (Java Data Base Connectivity) is an API (Application Programming Interface) for connecting to databases from the Java environment.
JDBC is an alternative to ODBC. JDBC's Java interface is more comfortable to Java programmers than ODBC's C language interface.
JDBC is included with both J2SE and J2EE.