Search This Blog

Wednesday, March 9, 2011

Outlook, ACT!, Goldmine, QuickBooks, PDA, Blackberry? What Is the Common Denominator?

They are all relational databases.

I can take your QuickBooks data, migrate it to Excel, then to Access and create a Lost Business Report that can be used to recapture lost sales as well as measure the performance of each sales person. Or if you get a Blackberry and all of your contact data is in a Pocket PC, I can migrate the information safely into your Blackberry and also set up your phone to sync with a contact management program such as MS Outlook. I can work with the following Database sets: QuickBooks, MS Access, MS Excel, ACT!, SQL, Peachtree, TigerPaw, PeopleSoft, Outlook, Palm Pilot, Pocket PC, and Blackberry.

According to Wikipedia, a relational database is:

"A relational database matches data by using common characteristics found within the data set. The resulting groups of data are organized and are much easier for many people to understand.
For example, a data set containing all the real-estate transactions in a town can be grouped by the year each transaction occurred, the sale price, a buyer's last name and so on. Such a grouping uses the relational model (a technical term for this is schema). Hence, such a database is called a "relational database."
The software used to do this grouping is called a relational database management system (RDBMS). The term "relational database" often refers to this type of software.
Relational databases are currently the predominant choice in storing data like financial records, medical records, personal information and manufacturing and logistical data."

No comments:

Post a Comment