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

Database Programming - Connecticut
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?
 
 Counties gear up on road funding
COLORADO SPRINGS, Colo. -- State and local officials blared warning sirens Wednesday over the potentially disastrous outcomes of not addressing Colorado's transportation needs soon.
 
 Jobless aid spread thin in Colo.
Rising job losses are starting to test a key safety net for unemployed workers in the state. The Colorado Department of Labor and Employment oversees a network of 52 workforce centers and another 18 satellite centers spread across the state.
 
 State education department seeks tax ruling
The Department of Education has asked the Colorado Supreme Court to decide by Friday whether it intends to throw out a 2007 property-tax measure so that school districts can set their mill levies for next year.
 
 Dip in smoking might mean a dip in revenue
The 2004 state tax increase on cigarettes and tobacco products had two goals: decrease smoking rates and increase funding for health care programs in Colorado.
 
 Binge drinking cited as one reason for Colorado's drop in health rankings
An upswing in binge drinking and in health disparities between races are two reasons why Colorado fell three spots to number 19 in the latest report of state-by-state health by America's Health Rankings.
 
 State freezes alleged fake charity fund
A Lakewood couple who collected thousands of dollars for needy veterans and homeless people were allegedly scamming kindhearted donors and using the money for their personal use, Colorado Attorney General John Suthers said Wednesday in announcing he was freezing their operations.
 
 Colorado, N.M., Texas warn bus riders of tuberculosis risk
People who rode an interstate bus on Aug. 3 or Aug. 9 are at a small risk of having contracted tuberculosis from an infected passenger, health departments from Colorado and two other states warned today.
 
 Colorado uranium mine woes run deep
Colorado uranium mining operations are being shut, postponed or scrapped as stock and commodity prices plummet and financing dries up.
 
 Metro State continues quest for graduate degrees
Metropolitan State College of Denver will continue to research whether it is feasible to offer master's degree programs after a 7-1 vote Wednesday by the board of trustees. The college must receive legislative approval before it can offer advanced degrees.
 
 Shifting economy keeps states guessing
A month from the start of many legislative sessions, state leaders still don’t know how much money they will have to cut from budgets.  
 
 Governors hopeful after Obama meeting
PHILADELPHIA — President-elect Barack Obama in an unprecedented gathering here yesterday (Dec. 2) enlisted the help of the nation’s governors to forge a national economic recovery plan with states as a centerpiece.
 
 Govs host historic meeting with Obama
In a historic meeting in Philadelphia today (Dec. 2), the nation’s governors are expected to make their case to President-elect Barack Obama for a massive infusion of federal dollars to help states weather a national recession that they fear will last for another year and a half.
 
 Sanford fights bailout for states
South Carolina Gov. Mark Sanford (R) is at odds with most of the nation’s governors: He is crusading against calls to send billions of dollars to cash-strapped states to help stimulate the economy.
 
 States ask feds for health care help
With the economy tanking and state budgets deep in the red, some states are cutting benefits or people from their Medicaid and other health insurance programs to save money. At the same time, the federal government and the new incoming administration are working with states on finding ways to help them avoid such measures.
 
 States eye their share of federal bailout
With President-elect Barack Obama and the Democratic Congress pledging quick action on a proposed multi-billion dollar fiscal package to boost the U.S. economy, states are banking they will get a cut of any federal rescue plan.
 
 States want Second Chance Act funded
With correctional facilities around the country teeming with repeat offenders, state and local officials are hoping the Second Chance Act — a federal law signed by President Bush in April to help keep former prisoners from committing new crimes — will be a priority under the incoming Obama administration.
 
 Youth vote: Democratic movement, or fad?
John McCain lost young voters on Election Day even in some of the nation’s reddest states. How big a problem is that for the future of the Republican Party?
 
 Visit the Stateline.org Colorado Page

 
 

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
* Ansonia * Bridgeport * Bristol * Danbury * Derby * Groton (city) * Hartford * Meriden * Middletown * Milford * New Britain * New Haven * New London * Norwalk * Norwich * Shelton * Stamford * Torrington * Waterbury * West Haven