tag:blogger.com,1999:blog-51812849699762515612009-04-07T02:24:24.233-04:00<b>Welcome to the <a href="http://www.data-conn.com">Data-Conn.com</a> network.</b> <b> <br><a href="http://www.odbc-connection.com">ODBC-Connection</a> <br><a href="http://www.jdbc-connection.com">JDBC-Connection</a> <br><a href="http://www.dotNET-connection.com">dotNET-Connection</a> <br><a href="http://www.xml-connection.com">XML-Connection</a> <br><a href="http://www.mainframe-connection.com">Mainframe-Connection</a> <br><a href="http://www.datadirect.com">DataDirect.com</a></b>Royce Willmschenhttp://www.blogger.com/profile/04461449457465158979noreply@blogger.comBlogger5125tag:blogger.com,1999:blog-5181284969976251561.post-35885026650702042222007-07-31T14:19:00.000-04:002007-07-31T15:58:27.879-04:00Looking at the technologies applications use for standards-based data access, the conceptual model hasn’t changed much in over a decade. Microsoft basically kicked it off with ODBC, which provided a standard way for Windows applications, like Excel, to get to a variety of databases from different vendors. JDBC followed with a Java-based, OO model for database access, but the fundamental client-server, fully-connected, statement-based programming model essentially mimicked ODBC. Microsoft, always tinkering with their development platform, introduced OLE DB for COM and, after that, ADO.NET. Neither was a radical paradigm shift, although ADO.NET did break the mold, somewhat, by adding capabilities for disconnected data processing. (Go <a href="http://blogs.msdn.com/data/archive/2006/12/05/data-access-api-of-the-day-part-i.aspx">here </a>for a good history of Microsoft data access technologies.)<br /><br />Now, as the software industry moves towards more web-based, Rich Internet Applications (RIAs), the usual methods for data access don’t necessarily fit very well. The internet forces us to think about database access differently. It’s inherently a disconnected, stateless model – at least from a transport (http) perspective. There are also significant issues around performance, reliability (transactions are hard when you’re not connected), and security. So, what's next?<br /><br />One possibility is data access via <a href="http://www.datadirect.com/products/mainframe-integration/shadow-rte/soa-zservices/index.ssp">web services</a>. In the right context – interactive, web-based apps with short, quick, isolated data needs – web services makes a lot of sense. For apps with big and complex data access requirements, web services may not work so well (for the reasons already mentioned). Have we reached a point where data access standards will fork – one for web-based apps, another for “backoffice” apps. Maybe?<br /><br />Watch this space for further discussion on this and related topics.<br /><br /><strong>Technorati Tags</strong>: <a class="techtag" href="http://technorati.com/tag/data+access" rel="tag">data+access</a> <a class="techtag" href="http://technorati.com/tag/ria" rel="tag">ria</a> <a class="techtag" href="http://technorati.com/tag/odbc" rel="tag">odbc</a> <a class="techtag" href="http://technorati.com/tag/jdbc" rel="tag">jdbc</a> <a class="techtag" href="http://technorati.com/tag/ado.net" rel="tag">ado.net</a> <a class="techtag" href="http://technorati.com/tag/web-based+applications" rel="tag">web-based+applications</a> <a class="techtag" href="http://technorati.com/tag/web+services" rel="tag">web+services</a><div class="blogger-post-footer"><img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/5181284969976251561-3588502665070204222?l=www.data-conn.com'/></div>Royce Willmschenhttp://www.blogger.com/profile/04461449457465158979noreply@blogger.com0tag:blogger.com,1999:blog-5181284969976251561.post-383033662883638822007-07-12T11:50:00.000-04:002007-07-12T11:53:03.204-04:00<script type="text/javascript" src="http://app.feeddigest.com/digest3/CTYVBNWIF2.js"><noscript><a href="http://app.feeddigest.com/digest3/CTYVBNWIF2.html">Click for &quot;XML Connection&quot;.</a> Powered by <a href="http://www.feeddigest.com/">RSS Feed Digest</a></noscript></script><div class="blogger-post-footer"><img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/5181284969976251561-38303366288363882?l=www.data-conn.com'/></div>Royce Willmschenhttp://www.blogger.com/profile/04461449457465158979noreply@blogger.com0tag:blogger.com,1999:blog-5181284969976251561.post-56849033988273577512007-07-12T11:46:00.000-04:002007-07-12T11:47:43.930-04:00<script type="text/javascript" src="http://app.feeddigest.com/digest3/LUCLQHPUWN.js"><noscript><a href="http://app.feeddigest.com/digest3/LUCLQHPUWN.html">Click for &quot;dotNET Connection&quot;.</a> Powered by <a href="http://www.feeddigest.com/">RSS Feed Digest</a></noscript></script><div class="blogger-post-footer"><img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/5181284969976251561-5684903398827357751?l=www.data-conn.com'/></div>Royce Willmschenhttp://www.blogger.com/profile/04461449457465158979noreply@blogger.com0tag:blogger.com,1999:blog-5181284969976251561.post-24117614637776404722007-07-12T11:32:00.001-04:002007-07-12T11:39:49.416-04:00<script type="text/javascript" src="http://app.feeddigest.com/digest3/SOB60ZLZSO.js"><noscript><a href="http://app.feeddigest.com/digest3/SOB60ZLZSO.html">Click for &quot;JDBC-Connection&quot;.</a> Powered by <a href="http://www.feeddigest.com/">RSS Feed Digest</a></noscript></script><div class="blogger-post-footer"><img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/5181284969976251561-2411761463777640472?l=www.data-conn.com'/></div>Royce Willmschenhttp://www.blogger.com/profile/04461449457465158979noreply@blogger.com0tag:blogger.com,1999:blog-5181284969976251561.post-57230935049673003052007-07-12T11:01:00.001-04:002007-07-12T11:41:40.228-04:00<script type="text/javascript" src="http://app.feeddigest.com/digest3/JEUZKOERSB.js"><noscript><a href="http://app.feeddigest.com/digest3/JEUZKOERSB.html">Click for &quot;ODBC Connection&quot;.</a> Powered by <a href="http://www.feeddigest.com/">RSS Feed Digest</a></noscript></script><div class="blogger-post-footer"><img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/5181284969976251561-5723093504967300305?l=www.data-conn.com'/></div>Royce Willmschenhttp://www.blogger.com/profile/04461449457465158979noreply@blogger.com0