DDH Software, LLC Making a big world smaller






Return to Knowledgebase Home
Glossary of Terms
Product: General HanDBase TopicArticle Number: 244Creation Date: 09/25/2003
Term Definition
ActiveSync Software from Microsoft that controls the communication between a Pocket PC handheld and a Windows desktop computer. ActiveSync will normally constantly monitor the Pocket PC device for changes and synchronize files with file level synchronization.
ActiveSync Conduit Software added to Microsoft ActiveSync to control the synchronization of specific types of files on a Pocket PC handheld. The HanDBase Conduit controls how HanDBase databases on a Pocket PC device are synchronized. Without the HanDBase Conduit, HanDBase databases are backed up to the desktop computer like all other files on a Pocket PC device, with no special consideration for merging changes between the handheld and desktop, and without placing the files in a location that HanDBase Desktop can see the HanDBase databases. Conduits added to ActiveSync do not necessarily monitor files to see when a sync is necessary, but instead will need to be run manually.
Applet A solution created with and for HanDBase. An applet can refer to just a single HanDBase database, or a set of HanDBase databases that work together through relationships.
Bi-directional synchronization Synchronization that merges changes between two sources. For example, if a change occurs in a database on the handheld and on the desktop at the same time, a bi-directional synchronization will merge the changes from both the handheld and the desktop together.
BlackBerry Device A mobile phone device manufactured by Research in Motion, RIM, running the BlackBerry OS.
Cross-grade Moving your purchased license from one mobile platform to another. For example, if you have HanDBase Plus for Palm OS, and wish to move to HanDBase Plus for Pocket PC, this is a cross-grade
CSV file A plain text file that stores data in a structured format, separated by commas. A typical CSV file will look like this:

firstname,lastname
john,doe
jane,doe

Data Exchange HanDBase Data Exchange allows the import and export of data between HanDBase and another source. For example, Data Exchange for MS Access allows you to import data from an Access table to a new or existing HanDBase database. Data Exchange also allows you to export data from a HanDBase database to a new or existing table in Access. An import or an export will not pay attention to the records that already exist. You will have the option of adding (appending) the records to the existing source. However, if some records exist in both the HanDBase database and the Access table, this will result in duplicates of those records. If you do not choose to append the records during import or export, the existing records will be replaced by the incoming records.
Database A set of data, containing fields and records. In HanDBase, a single database does not contain separate tables.
Decryption The process of unscrambling data that has been encrypted. Requires the encryption password. This is not the same as the normal security password in HanDBase.
Download The process of getting a file from a website and storing that file on your desktop computer. For example, when you download an installation file from the DDH Software website, you are obtaining a copy of that file and placing that copy on your desktop computer. This is not to be confused with synchronization between a handheld and a desktop computer.
Encryption The process of scrambling data so that it cannot be read by a user who does not have the decryption password. HanDBase supports 128 bit encryption, which is very secure. When using encryption, you will be asked for an encryption password. This is not the same as the normal security password in HanDBase.
Export The process of sending all of the data from one source to another source. An export will normally not descriminate between data that already exists in the source it is sending the data to. For example, if you export from a HanDBase database to a text file, the export will not pay attention to whether or not a record already exists in that text file, and so you can have duplicates if exporting to an existing data source.
External memory Memory cards or memory sticks that are used with handheld devices. These can typically be removed from the device and used between different handheld devices.
Field A single category of data in a database. A database will contain more than one field, such as a text field or a date field. HanDBase 3 databases can have up to 100 fields in a single database.
Field level synchronization Field level synchronization means that changes to different fields in the same record will be synchronized. For example, if a change is made to different fields in the same record in a database on a handheld device and a desktop device prior to a synchronization, changes made to each individual field on both platforms will be merged together. This is different from file level synchronization and record level synchronization. The HanDBase Conduit and Sync Exchange do not offer field level synchronization, but use record level synchronization. If the same exact record is modified in two locations, then the most recently modified copy of that record will win in a synchronization.
File level synchronization File level synchronization means that changes made to the same file will be synchronized. Only the full file itself is synchronized, not the content within the file. For example, if a file exists on a handheld and a desktop, and any change is made to that file on the handheld, a one-direction synchronization will copy the entire file to the desktop, overwriting the entire desktop file with the copy from the handheld, destroying any changes made on the desktop. The standard Palm OS and Pocket PC synchronization software products use file level synchronization. The HanDBase Conduit and Sync Exchange offer bi-directional record level synchronization.
Form A representation of the fields in your database. A form does not actually contain data, and is not a location for creating new fields. A form is a representation of how the fields of data actually appear to you when you open a record. Forms for a HanDBase database are kept in a separate file from the data. Forms are currently supported in the Palm OS, Windows Mobile and Windows Desktop versions of HanDBase.
HanDBase Forms The program that is used to create custom forms for a HanDBase database. You do not need to have HanDBase Forms installed on a handheld or desktop in order to use a custom form that has been created, and you do not use the HanDBase Forms program to view your data. HanDBase Forms is used specifically for creating new forms or modifying existing forms.
HanDBase ODBC driver A file that allows a HanDBase database to be used as an ODBC data source. This could be used, for example, to create a linked table from Microsoft Access to a HanDBase database file. Using Sync Exchange, HanDBase connects to MS Access, using MS Access as an ODBC data source. The HanDBase ODBC driver would allow the opposite to happen, allowing Access to connect to a HanDBase database.
HanDBase Plugin An application added to the Palm or Pocket PC that can be used with the External field type in HanDBase. Plugins add functionality that is not built in to HanDBase. This will typically be used for something that only some users would need, in order to keep the size of the HanDBase application as small as possible, but still giving users a way to get extended functionality for HanDBase. To date, no plugins have been created officially by DDH Software, but have been created by third party developers.
Hard reset The act of bringing a handheld device back to factory configurations. This is a destructive reset, meaning that any data or applications that have been added to the handheld will be lost, returning the handheld software to factory condition. Different models of handheld require different things to perform a hard reset. Refer to the documentation for any given handheld for information on how to do this.
HotSync Same as HotSync Process.
HotSync Conduit Software added to the HotSync Manager to control the synchronization for specific types of files on a Palm OS handheld. The HanDBase Conduit controls how HanDBase databases on a Palm OS device are synchronized. Without the HanDBase Conduit, HanDBase databases are backed up to the desktop computer with the default System conduit of the HotSync Manager.
HotSync Manager The software from Palm, Inc. that controls the HotSync Process. All communication between a Palm OS handheld and a desktop computer is controlled by the HotSync Manager. Other programs can be added to HotSync Manager to extend the functionality of the HotSync Process. Any file on a Palm OS handheld that does not have its own conduit will be synchronized with the System conduit of the HotSync Manager, using file level synchronization.
HotSync process The synchronization process used with a Palm OS device to back up data from a Palm OS handheld to a desktop computer.
Import The process of getting all of the data from one source into another source. An import normally will not descriminate between data that already exists in the source you are importing to. For example, if you import a text file into a HanDBase database that already exists, all of the data from that data source will be imported, even if this creates duplicate records in the HanDBase database.
Installation file Typically a Windows .exe file that is run on a desktop computer that start the installation of software. To run an .exe file, just double-click that file.
Internal memory The built in memory on a handheld device. This normally does not mean flash memory, and definitely does not include SD cards or memory sticks.
iPhone This is a mobile phone device manufactured by Apple running the iPhone OS.
iPod touch This is a PDA type device manufactured by Apple running the iPhone OS.
License agreement A legal agreement to use software that you purchase only within the intended guidelines. Such guidelines normally include how many desktop or handheld computers software can be installed to, a promise not to try to obtain proprietary information about the software through reverse engineering, etc.
License key Normally synonymous with registration code, this is the set of numbers and/or characters that are given to the registered version of a program when first installing the program.
Main memory See Internal memory
ODBC Open Database Connectivity. A standard set up by Microsoft to provide connections between different database applications, often made by different manufacturers. For example, HanDBase databases are proprietary to DDH Software, and MS Access databases are proprietary to Microsoft. ODBC offers a way for HanDBase to communicate with an Access database, without needing to have any proprietary information about how MS Access works.
ODBC Data Source A database that is available through ODBC. This typically will require adding the database to the Data Sources control panel in Windows.
ODBC driver Normally, a single file that needs to be installed in Windows, which will allow a database application to be used as an ODBC data source. ODBC drivers will normally be obtained from the manufacturer of the database software that you want to connect to.
One to Many relationship A type of link between two tables or two databases. If you have two databases, A and B, with a one to many relationship from A to B, this means that each record in database A can be connected to more than one record in database B, such as one person (database A) can have more than one phone number (records in database B).
One to one relationship A type of link between two tables or two databases. If you have two databases, A and B, with a one to one relationship, each record in database A will have only one record in database B that is connected, such as a person record in database A having just one social security record in database B.
Palm Desktop The Palm Desktop software that installs with the Palm HotSync Manager, and which is used to view your ToDo, Memos, Datebook, Address Book, etc, on your desktop computer. This is not to be confused with HanDBase Desktop.
Palm OS device A device that uses the Palm operating system. In the past Palm OS devices were manufactured by Palm, Handspring, Sony and a number of other companies. The current verison of HanDBase will generally only work on devices manufactured by Palm, Inc or PalmOne. Some Sony Clie devices running the Palm OS do have the right configuration to support the current version of HanDBase. Most of our other Palm OS software will run on many of the older devices manufactured by other companies. Palm, Inc does currently manufacture devices that use the Windows Mobile operating system. While these are Palm devices they are not Palm OS devices. These devices will require a version of the software for Windows Mobile. Palm OS is not the same as the WebOS operating system on the Palm Pre and Palm Pixi devices. These devices won't natively run any software from our website. However using the Classic software from MotionApps for the Palm Pre and Pixi you can run Palm OS apps on devices using the WebOS.
Plugin See HanDBase Plugin
Pocket PC device See Windows Mobile Classic Devices
Pocket PC Phone See Windows Mobile Professional Device
Real memory See Internal memory
Record A single piece of data in a database. Records contain one or more fields of data. Handbase 3 databases can have up to 65,000 records in a single database.
Record level synchronization Record level synchronization means that changes to different records in the same database will be synchronized. For example, if a change is made to different records in a database on a handheld device and a desktop device prior to a synchronization, changes made to each individual record on both platforms will be merged together. This is different from file level synchronization and field level synchronization. The HanDBase Conduit and Sync Exchange both offer record level synchronization. If the same exact record is modified in two locations, then the most recently modified copy of that record will win in a synchronization.
Registration code Normally synonymous with license key, this is the set of numbers and/or characters that are given to the registered version of a program when first installing the program.
Relational database In short, a database applications that supports links between two tables in a database or between two databases.
Removeable memory See External memory
Runtime application A HanDBase database or set of HanDBase databases that have been turned into a standalone application. A runtime application can be used on the handheld without having HanDBase itself installed.
Smartphone A Smartphone is generally recognized as any mobile/cell phone device that has PDA capabilities. Examples include the Palm Treo 650, Motorola Q, Nokia E71, HTC Touch Pro, iPhone, BlackBerry Bold. However a few years back Microsoft created Windows Mobile phone devices without a touchscreen that they branded Windows Mobile Smartphone, see Windows Mobile Standard.
Soft reset Restarting a handheld device, similar to turning off a desktop computer and then turning back on a desktop computer. Handheld devices normally do not reboot like a desktop computer does. Handheld devices normally just reduce power when not being used. As with all computers, handheld devices sometimes just need to reboot, and the way to do this is through a soft reset. A soft reset will normally not affect the data on the handheld. You may need to refer to the documentation for any particular handheld device to find information on how to perform a soft reset.
Symbian Series 60 device See Symbian S60 device.
Symbian S60 device This is a mobile phone device using the Symbian S60 operating system. Most devices with this OS are manufactured by Nokia however there are some other companies producing phones with this OS as well. However, not all Nokia Phones use the Symbian S60 OS. Some use other flavors of the Symbian OS, such as S40 or UIQ. Software on our website will only work on Symbian S60 devices that are 3rd edition or 5th edition.
Sync Exchange Sync Exchange merges data between HanDBase and another source. For example, Sync Exchange for MS Access allows you to synchronize the data between a table in Access and a database in HanDBase. This means that changes to existing records in either Access or HanDBase will be reflected in the other source after Sync Exchange runs. This will include additions of new records or deletions of existing records. This differs from an import or an export because Sync Exchange keeps track of the records that already exist, and watches for changes to the existing records. If a change occurs to an existing record in HanDBase, then Sync Exchange modifies the other data source, and vice versa.
System Tray The small area in Windows that is normally in the lower right corner of the screen, and which normally shows the time. The small icons listed next to the time in this area of the screen are normally programs that are currently running, even though those programs may not have windows on the screen. Both the Palm OS HotSync Manager and the Microsoft ActiveSync software have icons that appear in the System Tray, even when the programs are not active.
Table A set of data, containing fields and records. Some database applications have more than one table in a single database, eg MS Access. HanDBase databases are self-contained, and can be considered to be single-table databases.
Update Installing a newer version of a program to replace an outdated version. This differs from from an upgrade in that if you have HanDBase 3.0h and are installing HanDBase 3.0i, this would be considered an update. You are not moving to a different platform (from HanDBase 2 to HanDBase 3), but rather you are updating the existing application files for HanDBase 3.
Upgrade (1) Changing your purchased license from one package to a more expensive package. For example, if you have HanDBase Plus for Palm OS, and wish to move to HanDBase Professional for Palm OS, this would be an upgrade to HanDBase Professional for Palm OS.
Upgrade (2) Installing a newer version of a program to replace an older version. For example, if you have HanDBase 3.0, and are installing HanDBase 4.0 to replace HanDBase 3.0, this is an upgrade.
Upload The process of sending a file to a website from your desktop computer. For example, when you add a HanDBase database to the Applet Gallery on our website, you are uploading a file to the website. This is not to be confused with a synchronization between a handheld and a desktop computer.
WebOS This is the new Operating System on Palm Inc. devices, such as the Palm Pre and Palm Pixi. While these are Palm devices they are not Palm OS devices. The software you find on our website will not run natively on these devices. However MotionApps has created a software product called Classic that lets you run most all Palm OS application on a WebOS device.
Windows Mobile Classic Device A touchscreen device that uses Windows Mobile 2003SE, 5, 6 or 6.5. Some devices use operating systems similar to Windows Mobile, but these are not Windows Mobile Classic devices. For example, any device called a Handheld PC, Tablet PC or a Windows CE .net device by the manufacturer is not a Windows Mobile Professional device. HanDBase is supported on Windows Mobile Classic devices, not Handheld PC or Tablet PC or Windows CE .net devices. Software on our website that indicates it is for Windows Mobile Classic/Professional won't work on Windows Mobile Standard devices, which do not have a touchscreen. Windows Mobile Classic devices were previously known as Pocket PCs.
Windows Mobile Device Center The Windows Mobile device center is the Synchronization software for Windows Mobile devices for computers using Windows Vista or Windows 7. This is similar to Microsoft Activesync in functionality but Activesync cannot be used on Vista or Windows 7.
Windows Mobile Professional Device A touchscreen device that is also a phone that uses Windows Mobile 2003SE, 5, 6 or 6.5. Some devices use operating systems similar to Windows Mobile, but these are not Windows Mobile Professional devices. For example, any device called a Handheld PC, Tablet PC or a Windows CE .net device by the manufacturer is not a Windows Mobile Professional device. HanDBase is supported on Windows Mobile Professional devices, not Handheld PC or Tablet PC or Windows CE .net devices. Software on our website that indicates it is for Windows Mobile Classic/Professional won't work on Windows Mobile Standard devices, which do not have a touchscreen. Windows Mobile Professional devices were previously known as Pocket PCs or Pocket PC Phones.
Windows Mobile Smartphone See Windows Mobile Standard Device
Windows Mobile Standard Device A non-touchscreen device that uses Windows Mobile 5, 6 or 6.5. Software on our website that indicates it is for Windows Mobile Standard won't work on Windows Mobile Classic or Professional devices, which have a touchscreen. Windows Mobile Standard devices were previously known as Windows Mobile Smartphones.

This article has been viewed 1 times.

Return to Knowledgebase Home