InfoQ Homepage Data Access Content on InfoQ
-
A Look inside LINQ
Writing LINQ Providers will become an essential skill for framework developers over the coming years. In the future all .NET libraries that expose a data store will be expected to have LINQ support, and with the recent release of .NET 3.5, the clock has started ticking.
-
New SQL Server Data Type: HierarchyId
Tree-like hierarchies has always a problem in relational databases. Microsoft's first attempt at addressing this was in SQL Server 2005 with the implementation of Common Table Expressions. While CTEs work over existing schema, Microsoft has sought a way to treat hierarchies as first-class concepts. To this effect, they have introduced the HierarchId data type in SQL Server 2008.
-
The RDBMS is not enough.
In a world of services, RDBMS are not the solution to every problem. Document Oriented Distributed Databases try to solve this and add a new way of storing documents. CouchDB (written in Erlang) is in its alpha stage and evolving on a regular basis. InfoQ caught up with Anthony Eden who is implementing the same concept in Ruby with RDDB.
-
J2flex - A Persistence Store for Flex applications
j2flex.com has started rolling out their j2flex product over the last month, blogging about a number of details, and putting the API documentation online. j2flex is a “Persistence Store for Flex applications,” similar in basic features to Hibernate or iBATIS from the Java community.
-
Java Collections, Skip Lists, and Google
While sometimes taken for granted the Java Collections API plays a large role in day to day Java software development. Several additions including a skip list were added in Java 6. Google has also been working an a companion Google Collections Library project.
-
Recursive Selects using Common Table Expressions
Relational databases are great for storing most forms of structured data. The most notable exception is recursive data. Tree-like structures, essential for menus, normally require awkward stored procedures to efficiently return. SQL Server 2005 does have an answer though.
-
Lucene Oracle Integration Looks to Surpass Oracle Text
New work to enhancement LUCENE-724 by Marcelo Ochoa allows for better integration of Lucene as a domain index from within the Oracle database. The updates allow greater flexibility than using Oracle Text.
-
Behind Microsoft's Astoria REST Framework
In Microsoft's Architecture Journal issue 13, Pablo Castro talked about several key features of the Microsoft’s REST Framework – Astoria.
-
Abstracting Data Query in Ruby with Ambition Ambition
The .NET community is familiar with the general purpose query facilities added to the .NET Framework by the project LINQ. Ruby was missing such an abstraction layer. Chris Wanstrath brings his own solution: Ambition.
-
Has JPA Killed the DAO?
Recent developer discussion has explored whether JPA has killed the DAO pattern. DAO supporters argue that it isn't going anywhere soon however.
-
Interview: Yahoo's Doug Cutting on MapReduce and the Future of Hadoop
In this special InfoQ interview, Hadoop project lead Doug Cutting discusses MapReduce, the benefits of open source, and the future direction of the project.
-
OpenJPA 1.0: Enterprise O/R Mapping with full JPA 1.0 compliance
Apache OpenJPA, an open-source implementation of the Java Persistence API (JPA), recently released version 1.0.0. InfoQ spoke with OpenJPA project lead Patrick Linskey to learn more about this release.
-
Michael Stonebraker: Major RDBMSes are legacy technology
Michael Stonebraker, co-founder of the Ingres and Postgres relational database management systems (RDBMS) and CTO of Vertica Systems, laid the framework for a debate in the database community by declaring that most major databases should be considered legacy technology.
-
Eclipse Business Intelligence Reporting Tools Version 2.2 Adds MSOffice File Type Output Support
BIRT 2.2 has been recently released with major enhancements as a part of Eclipse Europa release. BIRT is an Eclipse-based open source reporting system for Java and JEE based web applications. Among the new features of 2.2 are enhanced charting featuring and support for XLS, Word, Power Point and Post Script formats.
-
Microsoft Entity Framework Beta 2 and Entity Framework Tools Beta 1 CTP Released
The Microsoft Entity Framework allows developers to close the gap between objects and our data stores. The second beta of the Microsoft Entity Framework is available now for developers to get a jump-start on exposing your data models as objects. This release also comes with the first beta of the Entity Framework Tools providing a graphical front-end to your entity data objects.