Free Trial

Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.

  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 10. DATABASES > RELATIONAL DATABASES

10.3. RELATIONAL DATABASES

Thus far, this chapter has described how F# programs can interrogate a variety of third party repositories of information in order to mine them for relevant data. Many of these repositories are actually stored in the form of relational databases exposed via web services. Relational database technology has many advantages such as simplifying and optimizing searches and, in particular, handling concurrent reads and writes by many different users or programs. This technology is ubiquitous in industry and is used to store everything from interactive data from company websites to client databases. Consequently, Microsoft have developed one of the world's most advanced database systems available, in the form of SQL Server. Moreover, this software is freely available in a largely-unrestricted form. So SQL Server can be a valuable tool for scientists wanting to maintain their own repositories of information.

This section describes how instances of SQL Server can be controlled from F# programs using Microsoft's ADO.NET interface. However, exactly the same ap-proach can be used to manipulate and interrogate many other relational database implementations including Firebird.NET, MySql and Oracle. There is a vast body of literature with more detailed information on relational databases [25, 15].


  

You are currently reading a PREVIEW of this book.

                                                                                                                    

Get instant access to over $1 million worth of books and videos.

  

Start a Free 10-Day Trial


  
  • Safari Books Online
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint