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

Database Programming - New Brunswick
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

 
 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.
 
 RFI (Request for Information) Response Service
Outsource your RFI response process to Transparen's technical writing team in Surrey, British Columbia, Canada.
 
 Respond to More RFPs (Requests for Proposals)
Respond to more proposals by outsourcing some of your RFP response processes to Transparen's technical writing team, and benefit from Canadian technical writers who understand technology and its business applications.
 
 Proposals
Transparen provides quality proposals, but they are usually not free.
 
 PHP Programming
A Commercial, Off-the-Shelf (COTS) product may be sufficient. Otherwise a custom application may be appropriate. Transparen provides experienced professional guidance in COTS product selection and integration, as well as custom PHP application development
 
 Business Process Optimization
Description of how Transparen Corp. supports clients engaged in optimization of business processes.
 
 The Power Of XML/DTD
The XML file format provides an open, transparent, and standard way to communicate between systems. Document type definition (or DTD) provides a way for two systems to see if they can "speak the same language".
 
 Bayesian Techniques Assist Automated Decision Tools
Centuries-old techniques developed by Thomas Bayes find modern applications because they are simple and effective.
 
 Our Role in Operations Optimization
Meet objectives more efficiently by improving operational effectiveness and profitability.
 
 Operations Research
Links to pages related to Operations Research, which is the methodical study of how to do things better.
 
 

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
* Alma * Aroostook * Atholville * Baker Brook * Balmoral * Bas Caraquet * Bath * Bathurst * Belledune * Beresford * Bertrand * Blacks Harbour * Blackville * Bouctouche * Bristol * Cambridge-Narrows * Campbellton * Canterbury * Cap Pélé * Caraquet * Centreville * Charlo * Chipman * Clair * Dalhousie * Dieppe * Doaktown * Dorchester * Drummond * Edmundston * Eel River Crossing * Florenceville * Fredericton * Fredericton Junction * Gagetown * Grand Bay-Westfield * Grand Falls * Grand Manan * Grande-Anse * Hampton * Hartland * Harvey * Hillsborough * Kedgwick * Lac Baker * Lameque * Le Goulet * Maisonnette * McAdam * Meductic * Memramcook * Millville * Minto * Miramichi * Moncton * Nackawic * Neguac * New Maryland * Nigadoo * Norton * Oromocto * Paquetville * Perth-Andover * Petitcodiac * Petit Rocher * Plaster Rock * Pointe-Verte * Port Elgin * Quispamsis * Rexton * Richibucto * Riverside-Albert * Riverview * Riviere-Verte * Rogersville * Rothesay * Sackville * Saint-Andre * Saint-Antoine * Saint-François-de-Madawaska * Saint-Hilaire * Saint-Isidore * Saint John * Saint-Leolin * Saint-Leonard * Saint-Louis-de-Kent * Saint-Quentin * Sainte-Anne-de-Madawaska * Sainte-Marie - Sainte-Raphael * Salisbury * Shediac * Shippagan * Stanley * St. Andrews * St. George * St. Martins * St. Stephen * Sussex * Sussex Corner * Tide Head * Tracadie-Sheila * Tracy * Woodstock * Aberdeen * Aboujagane * Acadie * Acadie Siding * Acadieville * Adams Gulch * Adamsville * Addington * Albert Mines * Albrights Corner * Alcida * Alderwood * Aldouane * Allainville * Allardville * Allison * Ammon * Anagance * Anderson Road * Anderson Settlement * Andersonville * Anfield * Anse-Bleue * Apohaqui * Arbeau Settlement * Armond * Arthurette * Ashland * Astle * Aulac * Avondale * Back Bay * Baie-Ste-Anne * Baie Verte * Barryville * Bartibog Bridge * Bates Settlement * Bay du Vin * Bayside * Beaubassin East * Beaverbrook * Beaver Dam * Bellefleur * Benjamin River * Berwick * Bettsburg * Big Hole * Big River * Black River * Black River Bridge * Blair Athol * Blissfield * Blissville * Bloomfield * Bloomfield Ridge * Boiestown * Bocabec * Brantville * Brockway * Browns Flat * Bull Lake * Burnsville * Burnt Church * Burton * Burtts Corner * Cains River * Campbell Settlement * Campobello Island * Canton des Basques * Caron Brook * Carrolls Crossing * Casillis * Caverhill * Chamcook * Chatham * Chatham Head * Chelmsford * Clarkville * Cloverdale * Cocagne * Coles Island * Collette * Connors * Cornhill * Coteau Road * Dalhousie Junction * Daulnay * Dawsonville * Debec * Deer Island * Derby * Devereaux * Douglas * Douglastown * Dugas * Duguayville * Dumfries * Dundee * Dunlop * Durham Bridge * Eel Ground * Elgin * Escuminac * Evandale * Évangéline * Fairisle * Fairvale * Five Fingers * Flatlands * Four Falls * Gauvreau * Geary * Glassville * Glencoe * Glen Levit * Glenwood * Gondola Point * Grafton * Grande-Digue * Gravel Hill * Gray Rapids * Hainesville * Hampstead * Hanwell * Hardwicke * Hartfield * Hatfield Point * Haut-Lamèque * Haut-Sheila * Havelock * Hawkshaw * Hazeldean * Head of Millstream * Health Steele * Hebron * Honeydale * Howard * Hoyt * Inkerman * Jacquet River * Janeville * Jemseg * Johnsville * Juniper * Keswick Ridge * Kingsclear * Kingston * Kouchibouguac * Lagacéville * Lake George * Lakeville * LaPlante * Lavillette * Lawrence Station * Limestone * Loggieville * Lorne * Losier Settlement * Lower Newcastle * Ludlow * Mactaquac * Madran * Magaguadavic Settlement * Magundy * Maltampec * Maple Ridge * Marysville * Maugerville * McGivney * McGraw Brook * McLeods * McNamee * Menneval * Millerton * Miramichi Bay * Miscou Island * Moulin-Morneault * Napadogan * Napan * Nash Creek * Nashwaak Bridge * Nashwaak Village * Nasonworth * Nauwigewauk * Nelson * Nelson Hollow * New Bandon * New Denmark * New Jersey * New Mills * Nicolas-Denys * Noonan * Nordin * North Head * North Tetagouche * Northampton * Notre-Dame * Notre-Dame-de-Lourdes * Notre-Dame-des-Érables * Oak Bay * Odell * Otis * Oxbow * Pabineau Falls * Parker Ridge * Pembroke * Penniac * Penobsquis * Petite-Lamèque * Petite-Rivière-de-l'Ile * Petite-Tracadie * Pigeon Hill * Pinder * Pocologan * Point La Nim * Pointe-à-Bouleau * Pointe-Alexandre * Pointe-Canot * Pointe-Sapin * Pokemouche * Pokeshaw * Pokesudie * Pokiok * Pont-Lafrance * Pont-Landry * Porten * Priceville * Prince William * Quarryville * Queensbury * Quisbis * Red Bank * Renforth * Renous * Richibouctou-Village * Riley Brook * Ripples * Riviere-du-Portage * Robertville * Robinsonville * Rosaireville * Rossville * Rough Waters * Saint-Arthur * Saint-Basile * Saint-Charles * Saint-Ignace * Saint-Irenée * Saint-Jacques * Saint-Jean-Baptiste-de-Restigouche * Saint-Joseph-de-Madawaska * Saint-Laurent * Saint-Martin-de-Restigouche * Saint-Maure * Saint-Sauveur * Saint-Simon * Sainte-Louise * Sainte-Marie-de-Kent * Sainte-Rose * Salmon Beach * Saumarez * Scotch Lake * Seal Cove * Sevogle * Shannonvale * Sheffield * Shemogue * Siegas * Sillikers * Sisson Ridge * Southampton * South Tetagouche * Springfield * Squaw Cap * St. Margarets * Stickney * Strathadam * Stonehaven * Sunny Corner * Tabusintac * Targettville * Taxis River * Taymouth * Temperance Vale * Tetagouche Falls * Tilley * Tracadie Beach * Tremblay * Upper Blackville * Upper Kent * Upper Queensbury * Upsalquitch * Val-Comeau * Val-d'Amour * Val-Doucet * Verret * Village-Blanchard * Village-Saint-Laurent * Waterville * Wayerton * Weaver Siding * Welsford * Westfield * White Rapids * Whites Cove * Wicklow * Williamstown * Wilsons Beach * Wirral * Zealand * Aberdeen * Acadieville * Addington * Allardville * Alma * Alnwick * Andover * Baker Brook * Balmoral * Bathurst * Beresford * Blackville * Blissfield * Blissville * Botsford * Bright * Brighton * Brunswick * Burton * Cambridge * Campobello * Canning * Canterbury * Caraquet * Cardwell * Carleton * Chatham * Chipman * Clair * Clarendon * Colborne * Coverdale * Dalhousie * Denmark * Derby * Dorchester * Douglas * Drummond * Dufferin * Dumbarton * Dumfries * Dundas * Durham * Eldon * Elgin * Gagetown * Gladstone * Glenelg * Gordon * Grand Falls * Grand Manan * Greenwich * Grimmer * Hammond * Hampstead * Hampton * Harcourt * Hardwicke * Harvey * Havelock * Hillsborough * Hopewell * Huskisson * Inkerman * Johnston * Kars * Kent * Kingsclear * Kingston * Lac-Baker * Lepreau * Lincoln * Lorne * Ludlow * Madawaska * Manners Sutton * Maugerville * McAdam * Moncton * Musquash * Nelson * New Bandon * New Maryland * Newcastle * North Lake * Northampton * Northesk * Northfield * Norton * Notre-Dame-de-Loudres * Paquetville * Peel * Pennfield * Perth * Petersville * Prince William * Queensbury * Richibucto * Richmond * Rivière-Verte * Rogersville * Rothesay * Sackville * Saint Andrews * Saint Croix * Saint David * Saint George * Saint James * Saint Martins * Saint Mary * Saint Marys * Saint Patrick * Saint Stephen * Saint-André * Saint-Basile * Saint-Charles * Saint-François * Saint-Hiliare * Saint-Isidore * Saint-Jacques * Saint-Joseph * Saint-Louis * Saint-Léonard * Saint-Paul * Saint-Quentin * Sainte-Anne * Salisbury * Saumarez * Shediac * Sheffield * Shippagan * Simonds, Carleton County * Simonds, Saint John County * Southampton * Southesk * Springfield * Stanley * Studholm * Sussex * Upham * Wakefield * Waterborough * Waterford * Weldford * Wellington * West Isles * Westfield * Westmorland * Wickham * Wicklow * Wilmot * Woodstock