InfoQ Homepage Data Access Content on InfoQ
-
InfoQ Interview: Jimmy Nilsson on LINQ to SQL
Floyd interviews Jimmy Nilsson on Microsoft's data access mechanism, LINQ to SQL.
-
Presentation: Managing a high performance rails app without tearing your hair out
Rails has gained popularity for its clean implementation of MVC and slick APIs. But what happens when your Rails app grows up, gets popular but can't keep up with requests? This presentation by James Cox will get you started with optimizing web applications by giving practical tips and pointing out common bottlenecks.
-
LINQ Grouping Techniques
For the most part LINQ works very much like SQL. Sources, joins, selects, and where clauses are all pretty standard fare. The Group/By/Into clause is where this breaks down. Unlike SQL, which always returns a rectangular dataset, LINQ is capable of returning hierarchical data. This brings new challenges of its own.
-
Microsoft Releases December CTP of Project Astoria
Microsoft has announced the December CTP of Project Astoria, whose new name is the ADO.NET Data Services Framework, is available now as part of the ASP.NET 3.5 Extensions preview release.
-
DB40 v7 and Increasing Popularity of ODBMS
db4o has been growing fast lately, having recently released v7.0 beta of their flagship db4o embedded OODBMS, and claiming over 30,000 deployments of their open source ODBMS. Is this a sign of changing times reflecting the ODBMS landscape?
-
Vendors Line Up Behind ADO.NET Entity Framework
Eight vendors have are planning to release drivers for ADO.NET Entity Framework within three months of RTM. IBM, MySQL AB, and a host for 3rd party vendors are targeting databases such as DB2, MySQL, and Oracle.
-
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.