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

Database Programming - Ontario
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

 
 Transparen Toronto Office Locations
Addresses of Transparen Corporation offices in Toronto, Ontario.
 
 Ontario Supports Innovation
McGuinty Government Accelerates Support For New Technology Start-Ups
 
 Prime Minister Harper And Premier McGuinty Announce Financial Support For The Auto Industry
Canadian automakers will receive conditional financial support to help them with their Canadian operations.
 
 Expanding Dental Services For Low Income Children
McGuinty Government Implementing Poverty Reduction Strategy
 
 Ontario Strengthens Home Care Services
McGuinty Government Sets Standards For High Quality Of Care
 
 Ontario To Make Schools Even Safer
McGuinty Government To Introduce Mandatory Reporting Legislation In 2009
 
 09/01/2009: The Wasted Vigil by Nadeem Aslam
Today on the podcast, author Nadeem Aslam talks about his latest novel "The Wasted Vigil" ... a fictionalized account of contemporary life in Afghanistan and one many say reveals a remarkable amount of truth.
 
 08/01/2009: How to Divorce and Not Wreck the Kids
For years, divorce has pitted couples against each other, fueling conflict and concerns about the children caught in the middle of it. Now, unhappy couples with children are looking for ways to end their marriage, but not end the family. Today on the podast, we'll hear from a couple trying to do that and the director of a CBC TV documentary called "How To Divorce and Not Wreck The Kids".
 
 07/01/2009: A Death in the Family - Documentary
Today on the podcast, the story of Paul Johnson and Bill Mullins-Johnson, two brothers from Sault Saint Marie, Ontario whose lives were torn apart after the murder of Paul's four-year-old daughter ... a crime that turned the two men against each other even though neither of them had committed it.
 
 06/01/2009: The Threatening Sea
Today on the podcast, we continue our Watershed series with a trip to Vanuatu, a nation of 83 islands in the South Pacific that is slowly but surely sinking into the sea.
 
 05/01/2009: Australia Drought
Dispatches from The Big Dry. Current producer Kathleen Goldhar brings us a report from Australia's enduring drought and the economy it's spawned, where rainless communities unravel, only the adaptable prosper and water is the new gold standard.
 
 02/02/2009: Economy Panel - 2009 Forecast
With the annus horibilis of 2008 in the rear view mirror, and 2009 lying in the wait, The Current organized an economy panel to give us their forecast for the new year.
 
 31/12/2008: Looking at Israel
Israel is a country where history is never really past, and where politics leeches into all quarters of society. No historian is merely an academic or a chronicler of the times. What he or she writes, in some cases, becomes the starting point of painful and contentious self-examiniation. In this podcast you will hear from a controvesial Israel professor and an author and intellectual counterpart to our first guest.
 
 

E C M | © 2003-2007 Transparen Corp.