 |
 |
EAI: |
An acronym for Enterprise Application
Integration. EAI allows for the integration of incompatible business
applications within and beyond enterprise applications to allow
them to talk to each other seamlessly and share data in real time.
|
|
|
ETL: |
Extraction, Transformation and Loading
(ETL) are three database functions that are combined into one tool
(like Convertabase's tools suite). The set of functions in ETL work
together to pull data out of source databases and place it into
target databases. ETL is used to
migrate data from one data repository to another, to form data
marts, data warehouses, and to convert databases from one
format or type to another.
|
|
|
Data Warehouse: |
A database designed to support decision
making in an organization. Data from the production databases are
copied to the data warehouse so that queries can be performed on
that data set without disturbing the performance or the stability
of the production systems.
|
|
|
Data Marts: |
Data warehouses can be enormous with
hundreds of gigabytes of transactions. As a result, subsets known
as "data marts" are often created for just one department or
product line.
|
|
|
Data Migration: |
The process of translating data from
one format to another. Data migration is necessary when an
organization decides to use a new computing system or database
management system that is incompatible with the current system.
Typically, data migration is performed by a set of customized
programs or scripts that automatically transfer the data.
|
|
|
Data Synchronization: |
The process of moving data between two
systems so that each system has the same data results for the
data being synchronized. The most recent data entered should be
preserved, with the older data being updated to reflect the new values.
|
|
|
One View: |
The goal of data warehousing and most
data synchronization operations, is to provide "One View" of the
companies' data to all departments.
|
|
|
|
For example, if accounting is notified that a customer's mailing
address has changed, shipping will also see the new address for the customer the
next time a package needs to be sent to that customer. (Archival operations
are not typically part of the "One View" goal).
|
|
|
One-Off Code: |
Code that is written for one specific
task. The programmer expects this code to be discarded upon
completion of that task. This code is seldom optimized, its
source code is often undocumented, and unarchived. "One-Off Code"
sometimes gets pushed into regular use once it works and the value
of its operation is understood--however, this undocumented code
will be difficult to support.
|
|
|
SQL: |
SQL is a standardized query language
for requesting information from a database. Although there are
different dialects of SQL, it is currently the closest thing we have to a standard
query language.
Click here
for a beginner's SQL course. (Convertabase has no
affiliation with this site)
|
|
|
Object: |
An object is a piece of computer code which is
extended from the definition of a class. An object has both code and
data storage. Convertabase has designed and patented an object
structure which allows data conversions to be a tree of objects.
The order of the objects allows for the user of the system to
control execution order by rearranging the objects. The property
editor that is part of the interface allows the end user to
set values on these objects (such as SQL) which will control the
behavior and capabilities of the objects.
Please see our section on objects
to learn more about the properties of each object. |
|
|
|
| Please email
us with any questions about terms you did not understand.
|
|
|