OriginLab Corporation - Data Analysis and Graphing Software - 2D graphs, 3D graphs, Contour Plots, Statistical Charts, Data Exploration, Statistics, Curve Fitting, Signal Processing, and Peak Analysis                     
 

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]
    Provider=Microsoft.Jet.OLEDB.4.0;Password="";Data Source=C:\stars.mdb;Persist Security Info=True
    [SQL]
    select * from stars
  • Query: A request of information from a database using a query language, such as Structured Query Language (SQL).
  • Records: Each row in a table is referred to as a record. Records contain information relating to a particular item (for example, a customer name + an address + a phone number, etc).
  • SQL: Stands for Structured Query Language. A computer language that has evolved for accessing data from a variety of databases. SQL is used to select particular pieces of information from a data source. The result of an SQL query can be saved as a view, or read into another application for examination.
    For example, a typical SQL statement could be:
    SELECT name, email, phone FROM customers
  • Table: A virtual structure that organizes the information in a database. A table is characterized by Records and Fields.
 

© OriginLab Corporation. All rights reserved.