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

Database Programming - New York
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, Ontario.
 
 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.
 
 Throughput (or Bandwidth) vs. Latency
This document uses the example of Bill Gates purchasing Google to explain the difference between bandwidth (or throughput) and latency.
 
 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?
 
 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.
 
 

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
* Albany, Albany County * Amsterdam, Montgomery County * Auburn, Cayuga County * Batavia, Genesee County * Beacon, Dutchess County * Binghamton, Broome County * Buffalo, Erie County * Canandaigua, Ontario County * Cohoes, Albany County * Corning, Steuben County * Cortland, Cortland County * Dunkirk, Chautauqua County * Elmira, Chemung County * Fulton, Oswego County * Geneva, Ontario County * Glen Cove, Nassau County * Glens Falls, Warren County * Gloversville, Fulton County * Hornell, Steuben County * Hudson, Columbia County * Ithaca, Tompkins County * Jamestown, Chautauqua County * Johnstown, Fulton County * Kingston, Ulster County * Lackawanna, Erie County * Little Falls, Herkimer County * Lockport, Niagara County * Long Beach, Nassau County * Mechanicville, Saratoga County * Middletown, Orange County * Mount Vernon, Westchester County * New Rochelle, Westchester County * New York City, New York, Bronx, Kings, Queens, and Richmond Counties * Newburgh, Orange County * Niagara Falls, Niagara County * North Tonawanda, Niagara County * Norwich, Chenango County * Ogdensburg, St. Lawrence County * Olean, Cattaraugus County * Oneida, Madison County * Oneonta, Otsego County * Oswego, Oswego County * Peekskill, Westchester County * Plattsburgh, Clinton County * Port Jervis, Orange County * Poughkeepsie, Dutchess County * Rensselaer, Rensselaer County * Rochester, Monroe County * Rome, Oneida County * Rye, Westchester County * Salamanca, Cattaraugus County * Saratoga Springs, Saratoga County * Schenectady, Schenectady County * Sherrill, Oneida County * Sodus Point, Wayne County * Syracuse, Onondaga County * Tonawanda, Erie County * Troy, Rensselaer County * Utica, Oneida County * Watertown, Jefferson County * Watervliet, Albany County * White Plains, Westchester County * Yonkers, Westchester County.