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

 
 Transparen Toronto Office Locations
Addresses of Transparen Corporation offices in Toronto.
 
 Emergency Management Services
The prototypical emergency involves a shutdown of essential services for a finite period of time. What will your organization do when a world-wide financial crisis strikes?
 
 High Scalability - Large Systems Optimization
Transparen Corporation lends its expertise to clients experiencing rapid and sudden growth in traffic or server utilization, bottlenecks, systems instability, downtime during peak traffic, or which would like to plan to avoid such issues.
 
 Fast RAID Server Data Recovery Service
Transparen's Vancouver International Response Team provides the option in Canada and USA to get a raid server back running in hours - eliminating costly waiting associated with typical RAID recoveries.
 
 Data Recovery Service
Have you deleted a mission critical file? Accidentally dropped a computer, or formatted a hard drive? No recent backup? Mistakes can happen, but the data might still be there.
 
 About Transparen
Transparen is committed to serving its clients.
 
 Research Tools
Measure human resource allocation and collect data with the goal of determining patterns that will bring forward actionable insights which may lead to policy changes, saving money and improving quality of service.
 
 Process Evaluation Questions
Questions to help focus discussion about process improvement
 
 Power outages need to be investigated, opposition
Angry about power outages? There is one thing you can do. The last day to register as an intervenor at the Yukon’s Utilities Board hearing next May is Friday, December 5. The hearing will deal...full story
 
 Rapprochement — here at home
The greatest opportunity in the ongoing Parliamentary circus is the very thing we are being told to fear — engagement with the Bloc. For my entire adult life, I have lived with the reality that a large segment of...full story
 
 Who will pay for McLean Lake fight?
The court room is becoming a familiar place for Marianne Darragh, even though she has been following the rules. The city has appealed a Yukon Supreme Court decision forcing Whitehorse to accept her 2,654-person...full story
 
 Listening to the landscape
It wasn’t drinking caribou pee that changed Karsten Heuer’s life — although that may have played part in it. It was time spent in the wilds that forced the wildlife biologist-cum-park warden to...full story
 
 Policing Whitehorse’s rinks and diamonds
Although it was 30 years ago, Bud Arnold clearly remembers the first time he wore the black and white of a referee’s jersey. “I studied NHL hockey and I took quite an interest in the refereeing part of it...full story
 
 03/12/2008: Crime in Canada
The story of a long-standing family feud and what it says about the future of violent crime in Canada.
 
 02/12/2008: The Constitution and a Coalition Government
What does the Constitution say about coalitions? Today on the podcast, we'll conjure up the ghost of Mackenzie King to find the answers.
 
 

E C M | © 2003-2007 Transparen Corp.