InfoQ Homepage Data Access Content on InfoQ
-
JLINQ: Runtime JDBC Generator for Eclipse
Azadeh Ahadian of IBM has published an article introducing JLINQ on IBM's developerWorks site. Despite the name, JLINQ does not have much in common with Microsoft's LINQ, rather it is an Eclipse plugin providing integration with a database and runtime DAO code generation. The plugin is part of IBM's Developer Workbench that is coming with Viper, the next release of DB2.
-
LLBLGen Updates O/R Mapper and Code Generator
Solutions Design has recently released LLBLGen Pro v2.5, an O/R mapper and code generator that boasts many new features including auditing, authorization, dependency injection mechanism, super fast and compact serialization (XML and binary), SQLServer CE Desktop support, Sybase support and much more.
-
Book Excerpt and Review: Hitchhiker's Guide to Visual Studio and SQL Server
With SQL Server 2000's hitting its end of life date next April, many shops that have been delaying the upgrade to SQL Server 2005 need to start looking at it seriously. This is why we have chosen to review the seventh edition of William Vaughn's Hitchhiker's Guide to Visual Studio and SQL Server.
-
Interview: OpenJPA & the JPA spec with Patrick Linskey
OpenJPA is an implementation of the Java Persistence API (JPA) which can be used as a stand-alone POJO persistence layer, or it can be integrated into any EJB3.0 compliant container and many lightweight frameworks. In this interview, Patrick Linskey explains where OpenJPA came from, how it fits into the O/R Mapping space, the JPA specification, and future plans for OpenJPA.
-
CodeSmith's PLINQO: Replace & Extend LINQ to SQL
CodeSmith released Professional LINQ to Objects, a set of templates to be used with CodeSmith and Visual Studio 2008 that supplement Microsoft's upcoming LINQ to SQL and have many great features including the ability ot generate or update a LINQ to SQL dbml file from a db schema, generation of LINQ to SQL entity manager & entity classes as well as the DataContext class.
-
Do You Need a Data Layer?
With LINQ nearing release, the need for a separate data access layer needs to be reevaluated. Is it still an essential part of an application's design? Or has it become an appendix of the past?
-
Data normalization, is it really that good?
Normalization is one of the corner-stones of database design. Recently some discussion emerged on the need for normalization suggesting denormalization as a more scalable solution.
-
Using SSIS in a Team Setting
Jamie Tomson talks about his experiences trying to use SQL Server Integration Services in a team environment.
-
Digging Deeper Into JBoss MetaMatrix
JBoss' Sacha Labourey has provided a detailed description of development uses of the MetaMatrix technology JBoss acquired in April.
-
Gemstone OODB to support JRuby, Rubinius
Gemstone is working on Ruby support for their Object Database products, starting off with JRuby. We talked to Alan McKean from Gemstone about what's to come, technical details and Gemstone's plans with Rubinius.
-
Google Base vs. Microsoft's Astoria
Dare Obasanjo has done a comparison of two new protocols for access database style data via HTTP. These protocols, based on REST, are the Google Base and Microsoft's Astoria.
-
Kevin Halverson: How to implement IQueryable
In a two-part series, Kevin Halverson has demonstrated how to create a LINQ provider by implementing the IQueryable and IQueryProvider interfaces. Specifically he uses the Windows Desktop Search as a data source.
-
MERGE Syntax for SQL Server 2008
SQL Server 2008 will include new syntax for merging data between two rowsets. The MERGE statement allows developers to use one command to perform deterministic inserts, updates, and deletes on a table based on a source table.
-
Opinion: SOA doesn’t need a Common Information Model
Loose coupling is not just about using a common syntax and protocols, it is also about creating and managing a set of shared semantics. Let’s take a quick look at the differences between a common information model and shared semantics and decide which one you are more likely to use in a service oriented architecture.
-
XQuery Java API JSR 225 Available for Public Review
The first public review draft of JSR 225: XQuery API for Java has been posted for review. The spec (being led by Oracle) aims to provide ubiquitous programmatic access for XQuery implementations in Java.