.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
david stephan
Gaurav Pal
Post New Web Links

Semantic standards support in SQL Server

Posted By:      Posted Date: September 21, 2010    Points: 0   Category :Sql Server

Will SQL server support semantic standards such as RDF, OWL, SPARQL similarly to Oracle 11g?  Thank you.

"Oracle Database 11g Semantic Technologies is an open, standards-based, scalable, secure, reliable and performant RDF management platform. Based on a graph data model, RDF data (triples) are persisted, indexed and queried, like other object-relational data types.

  • Stores rich, real-world relationships in the data beyond columns, table joins and Boolean to obtain more semantically complete query results.
  • Enables machine-driven discovery of new relationships using the native Oracle Database inference engine, ontologies, and RDFS /SKOS/OWL semantics and user defined rules. Inferred data is persisted in the database for faster querying.
  • Queries relationship patterns using either direct SPARQL access to Oracle Database 11g via Jena, Sesame or Joseki, or SQL with SPARQL-like clauses.
  • Supports W3C standards for the representation, vocabulary, inferencing and querying of relationships, including RDF, SKOS, RDFS, OWL, and SPARQL.
  • Supports key open source technologies, including Jena, Joseki, ARQ, Sesame, Pellet, D2RQ, Jetty, Cytoscape, GATE, and Protégé.
  • Secures RDF data at the graph and/or the triple level with declarative constraints on RDF classes and properties or EAL4+ multi-level sec

    View Complete Post

More Related Resource Links

deploying to msdeploy does not support a proxy server


I am trying to deploy through webmatrix but my system Proxy server configuration is not being used. I assume that webmatrix would detect the proxy server settings and use that for the msdeploy calls under the hood. Can anyone confirm this is a know issue? 

Under The Table: Spatial Data Support In SQL Server 2008


New spatial data support in SQL Server 2008 opens the door to mapping and querying geometric and geographic data, allowing you to build exciting new applications.

Bob Beauchemin

MSDN Magazine February 2009

Data Points: SQL Server 2005 XML Support, Exception Handling, and More


SQL Server 2005 includes several important improvements to the Transact-SQL (T-SQL) language. One added feature is a new kind of trigger that fires when data definition language (DDL) statements run.

John Papa

MSDN Magazine May 2006

SQLXML 3.0: Build Data-Driven Web Services with Updated XML Support for SQL Server 2000


XML is becoming the ubiquitous data format on the Web, and XML support in SQL Server is evolving to meet the additional demand. Using XML, SOAP, HTTP, and SQL Server, you can now build powerful Web Services easily. To show just how simple it is with SQLXML 3.0, this article walks the reader through the process step by step, from setting up a virtual directory enabling data access via HTTP to executing queries and building Web Services. Finally, the author illustrates the creation of two Web Services clients-one with C# that works with the Microsoft .NET Framework and one with the SOAP Toolkit 2.0 for anyone still using earlier development tools.

Christian Thilmany

MSDN Magazine May 2002

SQL Server Express 2008 Setup fails. Support Rule "Restart Computer" Failed

Hi, I have been trying to install SQL Server Express for most of the day now without any luck.  Whatever I do setup fails at the stage of Setup Support Rules, Rule "Restart Computer" - Failed.  Needles to say I have restarted (several times!) and I have tried downloading  and installing the "Advanced", "Tools" and "Basic" versions, all give the same error.  Trying a repair does the same.  I have been searching the net for an answer without success, any help would be MUCH appreciated. Further info: I am trying to install a stand-alone installation on to a single PC running under XP SP 3 with .NET 3.5 SP1 installed.  The PC did have some earler versions of SQL server installed but I (?hopefully?) removed all of these through Control Panel.  Before trying the first SQL install I installed Windows installer 4.5 and PowerShell 1.0 as per the Microsoft Instructions. Running SQL Server Configuration Manager results in an error (MMC could not create the snap-in. The snap in might not have been installed correctly).  A directory structure for SQL server exists in "Program Files".  Services MSC shows SQL Server (SQLEXPRESS) as Automatic Statup (not running).  Trying to start this manually gives error 14001: "application configuration incorrect - re-install to fix" .......... Which is precisely what I'm trying to do.........:(

Does MOSS 2007 Support SQL Server 2008 R2 RTM version?

Hi, We have MOSS 2007 SP1 databases in SQL Server 2005 EE x64 with SP3. Now, we want to upgrade the SQL Server 2005 to SQL server 2008 R2 EE x64 RTM version. Does MOSS 2007 Support SQL Server 2008 R2 RTM version? If yes, please take me to the MS link where I can find this information. Thanks

VS 2010: no Entity Framework or LINQ support for SQL Server 2000 SQLOLEDB connection?

Hello, I'm working with Visual Studio 2010 and for Data Connections am connecting to a SQL Server 2000 production database. When I try to drag a table to a .dbml file, the Object Relational Designer says, "The selected object(s) use an unsupported data provider."If I try to create an .edmx file via Generate from database, then the alert is, "This server version is not supported. You must have Microsoft SQL Server 2005 or later."So VS 2010 has no support for the Data Entity Framework or LINQ when connecting to a SQL Server 2000 database? If that is the case, what is the best data access strategy for this scenario?  

sql server doesn't support version

The database DATABASE.MDF cannot be opened because it is version 655. This server supports version 611 and earlier.  A downgrade path is not supported.Could not open new database 'DATABASE.MDF'. CREATE DATABASE is aborted. 

Max RAM Support for SQL Server 2008 R2

Hi All, I am little bit confused with the MAX RAM support by SQL Server 2008 R2 SQL Serve 2008 Std support MAX RAM as per the Host MAX RAM Support, but in R2, they have changed it to 64GB for Standard Edition. Is it true? If yes, they why Microsoft has restricted RAM support for R2 Std to 64 GB? We have server with 128 GB of RAM... How can we go ahead with the setup? Thanks, Ashish K India

No support for SQL Server Authentication and SSIS !!!!

Hi I want to manage my servers from a central location and have the ability to manage my packges too.  Unfortunatley my servers are across domains which means I have to use SQL Server Login, which isn't a bad thing.  However for some bizzare reason I can't connect to Integration Services using this method, only windows authentication which is a complete pain in the butt from a management stand point as I have to copy packages to various servers rather than add them from a central point. Does anyone know if this bug/feature or what ever Microsoft is calling it will be fixed or know of any workarounds.  Thanks    

MS Message Queueing 4.0 HTTP Support - 500 Internal Server Error

Hi all,   I've been trying to set up MSMQ 4.0 with HTTP Support to allow one of our partners to send messages to us. However, whenever I make any call to the msmq page I get an internal server error 500 (See below). My platform is Windows 2008 SE (64-bit) running as a DC (though MSMQ is running in workgroup mode).   Any hints on what might be causing this or how I can investigate further? Are there any log files for the ISAPI extension, or the MQISE.dll, or the MSMQ service that might help me shed light on this problem?   I've seen blogs about an issue with MSMQ 3.0 where the machine name can't be 15 characters long, is this still the case with MSMQ 4.0?   The error details are as below,     Server Error in Application "WWW.MYDOMAIN.COM/MSMQ" Internet Information Services 7.0 HTTP Error 500.0 - Internal Server Error There is a problem with the resource you are looking for, so it cannot be displayed. Detailed Error Information  Module IsapiModule Notification ExecuteRequestHandler Handler AboMapperCustom-113521 Error Code 0x8007007e Requested URL http://www.mydomain.com:80/msmq Physical Path c:\inetpub\www.mydomain.com\msmq Logon Method Anonymous Logon User Anonymous The path to the ISAPI Filter is incorrect. IIS received the request; however, an internal error occurred during the processing

Does SQL Server 2008 R2 Express Reporting Service support Shared Datasets?

I have spent a few hours trying to get this to work. I am using Report Builder 3.0 (locally), with SQL Server 2008 R2 Express Edition on a remote web server. I am running Report Builder as an Admin under Win7 64bit. All is OK until I attempt a Save of a newly created shared dataset. The error message is: Failed to save dataset "mydataset.rsd" The feature "Shared dataset" is not supported in this edition of Reporting Services. Details: The feature: "Shared dataset" is not supported in this edition of Reporting Services. ---> Microsoft.ReportingServices.Diagnostics.Utilities.OperationNotSupportedException: The feature: "Shared dataset" is not supported in this edition of Reporting Services. I have researched the web, and the list of features for Express Edition does not list this feature as not being supported, although it does list "Shared component library" as being missing. Could anyone please confirm the situation please. If it is  a bug, is there any fix or workaround?  John Walton  

Arabic Language Support in SQL Server 2005

ummary: Microsoft SQL Server 2005 supports Arabic data in Unicode and non-Unicode formats. Get information about the Arabic language code page, collations, components, and functions, as well as feature-specific information concerning set up, administration, replication, data transformation, and more.

Entity Framework: No support for server-generated keys and server-generated values

HelloI tried the Beta 1 of the service pack 1 to .net 3.5. If I try to add an entity (and try to save this), I get the Exception "No support for server-generated keys and server-generated values".How can I add entities to my Sqlce- database?I tried to give the id- column (primary key) in the database an identity, another time without identity, only primary key --> none of them worked. I always get the same error.What do I have to change to make successfully a SaveChanges()?Thanks for your help,Gerald

does the sql server 2008 R2 support movable columns in a tablix (in Reports)



is there a way to build a report with a tablix and let the columns movable for the users?
from another post i figured out, that this feature is not supported in sql server 2008.
is it featured in  2008 R2 or in 2010? :)

thanks Johnny


Does a SQL Server Compact 4.0 database support simultaneous access from different computers?


For example, if an sdf file is on a network server, could two network clients running SQL Server Compact 4.0 access the file at the same time?

This was not possible using SQLCE 3.5. I'm wondering if it's been added to 4.0 (so that it brings back the one advantage of using an Access db.)

SQL Server Support


What is the latest Service Pack that Microsoft will support?  I have servers that are SQL 2005 SP2, in case of an emergency will they support this?

What about SQL 2000?

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend