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

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

 
 Timing Upgrades - Factors Affecting Time Between Purchases for Tech Toys
It is possible to understand client purchase decisions by performing a regression analysis. By forming strategies based on the results, companies can optimize strategic programs to maximize profits.
 
 Personal Shopping Assistants - Turning the Table Against Merchant Databases
Consumers can use technology to watch the merchants who already have been watching them. But to do this, they need a champion.
 
 Operations Research
Links to pages related to Operations Research, which is the methodical study of how to do things better.
 
 Operations Research: Avoiding the Taint of Corporate Espionage
A $200M corporate espionage lawsuit against Westjet uncovers the possibility that Operations Research firms may not fully protect client data. A mechanism is suggested to ensure two competitors do not share the same Operations Research team.
 
 Reviewing the Audit of Management Consulting Engagements in Government
Review of Audit of Management Consulting Engagements in Government (2000/01 Report 4), as well as the 2002 and 2003 follow-ups from the Office of the Auditor General of British Columbia.
 
 Competition in Content Distribution Raises Value of Creativity
Content distributors facing competition on all sides turn to creative types for product differentiation. Using stable cash flow, distributors might acquire creative teams. Instead, a risk mitigating joint venture alternative is proposed.
 
 Adaptive Management
How the Forest Practices Branch of the British Columbia Ministry of Forests describes Adaptive Management, with links to further information about business process optimization.
 
 Macintosh Technical Support
Transparen provides remote technical support for Macintosh, Apple, iBook, and PowerBook.
 
 Linux-based Web Service Solutions
Integrate disparate systems using Web Services, where such services are available in other than XML.
 
 Save Money With Thin Clients on Linux
Advantages of using Linux to provide thin inexpensive desktops or kiosks.
 
 

E C M | © 2003-2007 Transparen Corp.      

Standardized Services: Data Recovery Service / Creative Services / Premium Web Hosting Services / System Administration Tech Support Services
Recent Projects: Full-Service Mortgage and Financing Company / System to manage flights from Vancouver to Tofino
Arctic Bay, Arviat, Baker Lake, Bathurst Inlet, Cambridge Bay, Cape Dorset, Chesterfield Inlet, Clyde River, Coral Harbour, Gjoa Haven, Grise Fiord, Hall Beach, Igloolik, Iqaluit, Frobisher Bay, Kimmirut, Lake Harbour, Kugaaruk, Pelly Bay, Kugluktuk, Coppermine, Pangnirtung, Pond Inlet, Qikiqtarjuaq, Rankin Inlet, Repulse Bay, Resolute, Sanikiluaq, Taloyoak, Spence Bay, Whale Cove, * Bernard Harbour (PIN-C), on the mainland * Bray Island (FOX-A) * Brevoort Island (BAF-3) * Broughton Island (FOX-5) * Byron Bay (PIN-4) * Cambridge Bay (CAM-MAIN) * Cape Dyer (DYE-MAIN), on Baffin Island * Cape Hooper (FOX-4) * Cape Mcloughlin (CAM-5A) * Cape Mercy (BAF-2) * Cape Peel West (PIN-EB) * Cape Young (PIN-2) * Clifton Point (PIN-B) * Clinton Point (PIN-1) * Croker River (PIN 1BG) * Dewar Lakes (FOX-3) * Durban Island (FOX-E) * Edinburgh Island (PIN-DA) * Ekalugad (FOX-C) * Gjoa Haven (CAM-CB) * Gladman Point (CAM-2) * Hall Beach (FOX.MAIN) * Harding River (PIN-2A) * Hat Island (CAM-B) * Jenny Lind Island (CAM-1) * Kangok Fjord (FOX-CA) * Keats Point (PIN-1BD) * Keith Bay (CAM-E) * Kivitoo, (FOX-D) * Lady Franklin Point (PIN-3) * Lailor River (CAM-FA) * Loks Land (BAF-4A) * Longstaff Bluff (FOX-2) * Mackar Inlet (CAM-5) * Matheson Point (CAM-C) * Nudluardjuk Lake (FOX-B) * Pelly Bay (CAM-4) * Resolution Island (BAF-5) * Ross Point (PIN-D) * Rowley Island (FOX-1) * Scarpa Lake (CAM-F) * Shepherd Bay (CAM-3) * Simpson Lake (CAM-D) * Sturt Point (CAM-A3A) * Alert * Ennadai, at Ennadai Lake * Eureka, on Ellesmere Island * Fox Five * Isachsen, on Ellef Ringnes Island * Jericho Diamond Mine * Little Cornwallis Island * Lupin Mine * Nanisivik (), on Baffin Island * Craig Harbour, on Ellesmere Island * Dundas Harbour, on Devon Island * Nuwata, on Baffin Island * Padlei, on the mainland * Tavani, on the mainland * Umingmaktok (Umingmaktuuq , formerly Bay Chimo), on the mainland * Wager Bay, (Ukkusiksalik ) on the mainland