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

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

 
 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
 
 

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
* Abbott * Abilene * Addison * Alamo * Alamo Heights * Albany * Alice * Allen * Alpine * Alvarado * Alvin * Amarillo * Ames * Anahuac * Anderson Mill * Andrews * Angleton * Appleby * Aransas Pass * Archer City * Argyle * Arlington * Athens * Atlanta * Austin, the state capital * Austonio * Austwell * Avery * Azle * Bailey's Prairie * Baird * Balch Springs * Ballinger * Barrett * Bartonville * Bastrop * Bay City * Baytown * Beach City * Beaumont * Bedford * Bee Cave * Beeville * Bellaire * Bellmead * Bellville * Belton * Benbrook * Big Lake * Big Sandy * Big Spring * Blue Ridge * Boerne * Bogata * Bolivar Peninsula * Bonham * Booker * Borger * Brazos Bend * Brazos Country * Breckenridge * Bremond * Brenham * Bridge City * Bridgeport * Brookshire * Brookside Village * Brownsville * Brownwood * Bruceville-Eddy * Bryan * Buda * Buffalo * Bulverde * Burkburnett * Burleson * Burnet * Caldwell * Calvert * Camden * Cameron * Camp Wood * Canadian * Canton * Canyon * Carrollton * Carthage * Castroville * Cedar Hill * Cedar Park * Centerville * Chappell Hill * Chester * Chillicothe * Christoval * Cibolo * Cisco * Clear Lake * Cleburne * Cleveland * Clifton * Clute * Clyde * Cockrell Hill * Coldspring * College Station * Colleyville * Columbus * Comanche * Combine * Comfort * Commerce * Conroe * Converse * Coolidge * Coppell * Copperas Cove * Copper Canyon * Corinth * Corpus Christi * Corral City * Corrigan * Corsicana * Cove * Crane * Cresson * Crockett * Crosby * Cross Plains * Crowell * Crowley * Crystal Beach * Cuero * Cumings * Cuney * Cut and Shoot * Daingerfield * Daisetta * Dalhart * Dallas * Danbury * Dayton * Dayton Lakes * De Leon * Decatur * DeCordova * Deer Park * Del Rio * Denison * Denton * Denver City * DeSoto * Detroit * Devers * Diboll * Dickinson * Dime Box * Donna * Dripping Springs * Dublin * Dumas * Duncanville * Eagle Pass * Eden * Eola * Early * Eastland * Edinburg * El Campo * El Paso * Eldorado * Electra * Elgin * Elysian Fields * Emory * Ennis * Euless * Fairfield * Farmers Branch * Farmersville * Farwell * Flatonia * Flower Mound * Forney * Fort Davis * Fort Stockton * Fort Worth * Franklin * Fredericksburg * Freeport * Friendswood * Frisco * Fritch * Fulshear * Gainesville * Galveston * Garden Ridge * Garland * Gatesville * Georgetown * Giddings * Gilmer * Glenn Heights * Glen Rose * Goliad * Gonzales * Gordon * Graham * Granbury * Grand Prairie * Grape Creek * Grapeland * Grapevine * Groveton * Gruene * Gun Barrel City * Hale Center * Hallettsville * Hallsville * Haltom City * Hamilton * Hardin * Harker Heights * Harleton * Harlingen * Harriett * Haskell * Hearne * Hemphill * Hempstead * Hewitt * Hico * Hidalgo * Hideaway * Highland Village * Highlands * Hill Country Village * Hillsboro * Hilshire Village * Hondo * Houston * Huntington * Huntsville * Hurst * Hutto * Idalou * Impact * Independence * Indian Lake * Industry * Ingleside on the Bay, Texas * Ingleside * Ingram * Iowa Park * Iraan * Iredell * Irving * Italy * Itasca * Jacksboro * Jacksonville * Jamaica Beach * Jasper * Jefferson * Jewett * Johnson City * Junction * Karnack * Katy * Keller * Kemah * Kenefick * Kennedale * Kerens * Kerrville * Kilgore * Killeen * Kingsville * Kingwood * Kirbyville * Kosse * Krugerville * Krum * Kurten * Kyle * La Marque * La Porte * Lacy-Lakeview * LaGrange * Lake Brownwood * Lake Dallas * Lake Jackson * Lakeway * Lampasas * Lamesa * Lancaster * Laredo * League City * Leander * Leon Valley * Leonard * Levelland * Lewisville * Lindale * Littlefield * Live Oak * Livingston * Lockhart * Lolita * Longview * Lorenzo * Los Fresnos * Los Ybanez * Lubbock * Lucas * Luckenbach * Lueders * Lufkin * Lumberton * Malakoff * Mansfield * Marble Falls * Marlin * Marshall * Mason * Mathis * McAllen * McGregor * McKinney * McLeod * Menard * Merkel * Mesquite * Mexia * Midland * Midlothian * Midway * Miles * Millersview * Millican * Mineola * Mission * Missouri City * Mobile City * Monahans * Mont Belvieu * Moody * Moore Station * Morgan's Point * Moulton * Mount Pleasant * Murphy * Nacogdoches * Nassau Bay * Neiderwald * Nesbitt * New Boston * New Braunfels * Newton * Neylandville * North Cleveland * North Richland Hills * North Zulch * Oak Leaf * Oak Point * Odessa * Old River-Winfree * Onalaska * Orange * Overton * Paint Rock * Palestine * Pampa * Pana Maria * Paris * Parker * Pasadena * Pearland * Pecos * Perryton * Pflugerville * Pharr * Pineland * Pittsburg * Plainview * Plano * Plum Grove * Ponder * Port Aransas * Port Arthur * Port Lavaca * Portland * Post * Post Oak Bend City * Presidio * Prosper * Quanah * Queen City * Quinlan * Quitaque * Quitman * Ranger * Ravenna * Red Oak * Refugio * Reno * Richardson * Richland * Riesel * Rising Star * River Oaks * Roanoke * Robinson * Rockwall * Rosenberg * Rosser * Round Rock * Round Top * Rowena * Rowlett * Rusk * Sachse * Sadler * Saginaw * Salado * San Angelo * San Antonio * San Benito * San Marcos * San Saba * Sanctuary * Sanderson * Sanger * Santa Anna * Santa Fe * Savoy * Schertz * Scottsville * Scurry * Seabrook * Seagoville * Sealy * Seguin * Seminole * Seymour * Shallowater * Shamrock * Shavano Park * Shenandoah * Sheldon * Sherman * Shiner * Shoreacres * Silsbee * Slaton * Smithville * Snyder * Somerville * Sonora * Sour Lake * South Padre Island * Southlake * Southmayd * Spearman * Spring Valley * Springtown * Spur * Stafford * Stephenville * Stowell * Sugar Land * Sunnyvale * Sweeny * Sweetwater * Tahoka * Taylor * Teague * Temple * Tenaha * Terrell * Texarkana * Texas City * The Colony * The Woodlands * Tiki Island * Timpson * Tioga * Toco * Tom Bean * Tomball * Trophy Club * Troup * Turkey * Tyler * Uncertain * Universal City * University Park * Utopia * Van Alstyne * Vanderbilt * Van Horn * Venus * Vernon * Victoria * Vidor * Volente * Waco * Waskom * Watauga * Waxahachie * Weatherford * Webberville * Webster * Weslaco * West Columbia * West Lake Hills * West Orange * West University Place * Westlake * Wheeler * White Oak * White Settlement * Whitehouse * Wichita Falls * Willow Park * Wimberley * Windrest * Winnie * Winters * Wixon Valley * Wolfe City * Woodlake * Woodlawn * Woodville * Woodway * Wortham * Wylie * Yoakum * Zapata * Zavalla