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

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

 
 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
 
 Operations Research
Operations Research (frequently called OR), is the methodical study of how to do things better. It is also called Optimization Theory.
 
 Our Role in Operations Optimization
Meet objectives more efficiently by improving operational effectiveness and profitability.
 
 MAJOR PROJECTS INVENTORY SETS NEW CONSTRUCTION RECORD
VICTORIA ? The latest Major Projects Inventory shows that construction projects across B.C. have increased for the 21st consecutive quarter, with 863 major capital projects, worth an estimated $174.7 billion planned or underway, Technology, Trade and Economic Development Minister Ida Chong announced.
 
 LEGISLATION INTRODUCED TO MAINTAIN STRONG ECONOMY
VICTORIA ? Proposed legislative amendments introduced today will fulfil Premier Gordon Campbell?s 10-point economic plan and help ensure British Columbians have financial stability during the global financial crisis.
 
 SCHWARZENEGGER SUMMIT LOOKS TO KICKSTART GREEN ECONOMY
LOS ANGELES ? During the Governors? Global Climate Summit in California, B.C. joined more than eight U.S. states and representatives from 11 countries in signing a joint declaration agreeing to pursue collaborative action to reduce GHG emissions and create opportunities to grow green economies, announced Environment Minister Barry Penner.
 
 B.C. WOOD SALES IN CHINA SUPPORT B.C. JOBS
SHANGHAI, CHINA ? New orders for B.C. lumber in the world?s fastest growing market provide a boost for B.C.?s forest sector, Forests and Range Minister Pat Bell announced.
 
 B.C. WOOD SALES IN CHINA SUPPORT JOBS ON B.C.?S COAST
SHANGHAI, CHINA ? New orders for B.C. lumber help provide some stability for mill workers and loggers on Vancouver Island, Forests and Range Minister Pat Bell and Duncan Kerr, Chief Operating Officer of Western Forest Products, announced.
 
 B.C. WOOD ENHANCES CHINA?S LANDSCAPE
SHANGHAI ? Qingdao is the location of a new, $125,000 landscape project, which demonstrates creative new uses of B.C. hemlock and western red cedar products, Forests and Range Minister Pat Bell announced on his trade mission to China.
 
 B.C. WOOD TRUSS ROOFING TECHNOLOGY SUCCESSFUL IN CHINA
SHANGHAI, CHINA ? B.C. forest products and Canadian wood truss technology have experienced a breakthrough with three commercial projects providing new roofs to 38 apartment buildings in Shanghai, Forests and Range Minister Pat Bell announced while visiting a project site in the Putuo district.
 
 01/12/2008: The Big Three & the Future of the Auto Industry
One way or another, the Big Three automakers will have a huge impact on Windsor's future. But the future of those companies is being decided by forces well beyond this city's borders.
 
 28/11/2008: Greenpeace and the DRC
For more than a decade, the Democratic Republic of Congo has seen one humanitarian disaster after another. But there's an environmental catastrophe as well. And Greenpeace thinks it deserves our attention too.
 
 27/11/2008: The Agony of Stephen Harper
Stephen Harper got into politics to make government smaller. Now he's facing an economic crisis that seems to cry out for big time public intervention.
 
 26/11/2008: Albino Killings in Tanzania
A horrifying story of an underground trade in human body parts, one that allegedly targets albinos in Tanzania and is said to be fueled by witchdoctors.
 
 25/11/2008: Cyber Crime and Bullying
Today on the podcast, the tragic story of a young life cut short that shows there's nothing virtual about on-line bullying. Find out how social networking web sites are being used to promote bullying and hate and why some people think our real world laws are failing to keep up with these kinds of cyber crimes.
 
 

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
* Burnaby (City) * Campbell River (Town) * Chilliwack (City) * Comox (City) * Coquitlam * Cranbrook (City) * Delta (City) * Duncan (City) * Grand Forks (City) * Hope (Town) * Kamloops (City) * Kelowna (City) * Ladysmith (Town) * Langley (City) * Mission (City) * Nanaimo (City) * Nelson (City) * New Westminster (City) * North Vancouver (City) * Penticton (City) * Port Alberni * Prince George (City) * Prince Rupert (City) * Quesnel (City) * Saanich (City) * Sidney (City) * Sooke (City) * Steveston (City of Richmond) * Surrey (City) * Tofino * Ucluelet * Vancouver (City) * Vernon (City) * Victoria (City) * West Vancouver (City) * Whistler * White Rock