# 6.8.4 Database Terminology

Here are some brief introduction for database terminologies that we may used in Origin:

• ADO: Stands for ActiveX Data Objects, a set of COM objects for accessing database. By default, Origin connects database through ADO. (See also: ODBC)
• Connection String: A string that contains information for connecting a database. Such as, the name of the server, where the database is, the user ID and password needed to connect to the server, and so on.
• Database: A database is an organized collection of information, and is controlled by a Database Management System (DBMS) like Microsoft Access. A DBMS provides an efficient way to store and access data. Typically, data in a database is organized by tables.
• Derived table: The result of a query.
• Fields: Each column in a table is referred to as a field. A field is a collection of data on a particular parameter (for example all customer names, all addresses, all phone numbers, etc).
• ODBC: Stands for Open Database Connectivity. An application program interface for accessing database. (See also: ADO)
• ODS file: The Data Source file. The .ods file contains the Connection String that allows Origin to open a connection to database. The .ods file contains only one section, and stores no information about what the user wants to obtain from the database service (i.e. what query to run).
For example, the contents of an .ods file could be:
[DataSource]
Provider=Microsoft.Jet.OLEDB.4.0;Password="";Data Source=C:\stars.mdb;Persist Security Info=True
• ODQ file: The Data Query file. The .odq file contains all information to connect a database in Origin. Including the connection string and the SQL query which used to retrieve information from the database; And additional sections like scripts that executed before the query.
For example, the contents of an .odq file could be:
[DataSource]
select * from stars
SELECT name, email, phone FROM customers