Select your font size  A  A  A 
 
about us products & services consulting & support news & events contact us

Database Programming - Yukon
print this article 
 

This page is about Transparen's capabilities with respect to databases. To learn about Transparen's capabilities with respect to general custom programming, click here.

Our experience with database programming includes:

  • Designing and developing an N-Tier COM web service application that interfaces with MS SQL Server for a government client
  • Creating an e-commerce site with MySQL database back-end for a financial services client
  • Database extraction from a large DB2 mainframe for data analysis
  • Migrating databases from one application to another
  • Systems integration between databases

Transparen Corporation provides database data recovery services as well, such as recovering after system tables have been damaged after a hard drive crash or near crash experience. Databases that we can recover from include:

  • MS Exchange
  • MS SQL Server
  • MySQL
  • Postgresql
  • DB2
  • MaxDB
  • Oracle
  • Access
  • Outlook's email database

Most modern programming involves some sort of interaction with a database, even if the database is as simple as plain text files in a directory structure (yes, even that can be considered a database!). For instance, companies often require the following types of database-enabled applications:

  • Client database - for maintaining a unique identity for people who do business with the company.
  • Transaction database - for keeping track of what transactions have been initiated or completed
  • Subscription database - for allowing current subscribers to have access to certain benefits
  • Support ticket database - this allows companies to see what kinds of issues come up more frequently, and allows technicians to share their knowledge

Transparen offers support for Open Source software, such as the following two popular Open Source databases:

  • MySQL
  • Postgresql

The main difference between MySQL and Postgresql is that MySQL is faster for development, but Postgresql contains more enterprise features such as ACID compliant transactions, the ability to write procedures, support for foreign keys, and more.

Other Open Source databases include:

  • Firebird (not to be confused with FireFox, the web browser)
  • Ingres

  

Most Recent Website and Regional Updates

 
 Conditional probability
Paul Meagher gives an example of calculating conditional probability using the set enumeration method.
 
 Understanding Bayes Using PHP
Paul Meagher introduces Bayesian inference by discussing the basic mathematical concepts and demonstrating how to implement the underlying conditional probability calculations using PHP.
 
 Transparen Corporation Canada Day Celebrations July 1, 2006
Transparen Corp. is proud of its Canadian heritage, and gladly celebrates Canada Day every year. Look back at previous Canada Days to learn about Transparen's history.
 
 Increase Reliability - Decrease SPAM and Viruses
Email is an essential service. Make email more effective by reducing spam, eliminating viruses, and improving flexibility and reliability.
 
 Linux Email Virus Protection
Transparen Corp. supports ClamAV, a GPL command-line virus scanner. Nevertheless, avoid opening attachments from strangers...
 
 Support for Mozilla and Firefox
Transparen Corporation provides technical support for companies migrating from Internet Explorer to Mozilla or Firefox.
 
 Supporting OpenOffice.org Office Productivity Software
Transparen Corporation provides technical support for companies migrating to OpenOffice.org
 
 Web Writing Attracts Positive Results
Out-do the competition through skillful and colorful writing, aimed at both searchers and search engines. An effective message is worth many times its cost.
 
 Orchestrated slaughter threatens Porcupine caribou
The scenery of the Dempster Highway is known for inspiring awe, not nausea. But what two Yukon men witnessed on the road this week made them feel ill. They saw as many as eight trucks of hunters from the...full story
 
 Three choices for the NDP
There’s more than four decades between the NDP’s oldest and youngest federal candidates for the Yukon. Robin Reid-Fraser, who’s 19, is running against long-time NDP spokesman Ken Bolton, 62, and...full story
 
 Greens in Liberal cast-offs
The Green Party of Canada is ready to go to court, if that’s what it takes to get Elizabeth May included in televised leaders’ debates during the upcoming election. The party claims it is eligible for...full story
 
 Marchuk, Ellis take singles titles at Yukon Tennis Championship
For the Yukon Tennis Championships, held over the last two weeks, the weather was as unforgiving as Roger Federer’s forehand. Beginning August 22, the tournament ran a week over schedule as matches were...full story
 
 Vandals trash mountain bike stunts
Mountain biker Bruce Thomson, flanked by his two dogs, rode up, and down the elevated plank — the last stunt remaining on the Lower Bogaloo trail. The rest of the sophisticated volunteer-built obstacles...full story
 
 Mastering the challenges of clay takes a lifetime
Artist Rich Claxton was setting up the solo showroom at the Yukon Artists at Work gallery, surrounded on all sides by dozens of his expertly crafted clay creations. Cups, vases and mugs stood perched in various stages...full story
 
 Alaska lost in haze of bygone days
If you want to measure how far Yukon society has advanced in the last couple of years, drive 90 minutes to Skagway, Alaska, and order an omelet. If you’re lucky, the eggs and sausage will be fine. Good even.full story
 
 

E C M | © 2003-2007 Transparen Corp.