Wrox Programmer Forums
|
SQL Server 2000 General discussion of Microsoft SQL Server -- for topics that don't fit in one of the more specific SQL Server forums. version 2000 only. There's a new forum for SQL Server 2005.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the SQL Server 2000 section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old February 20th, 2006, 09:50 AM
Registered User
 
Join Date: Feb 2006
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default non-relational database

Hello,
I'm involved in the definition of the architecture of a new project.
My customer wants to use a non-relational database. I would like to know if I could use the XML technology for instance, to create my database model? I still collected a lot of articles talking about non-relational projects based on XML.
Do you have a wrox book which covers this topic?
Can I use Sql Server or Oracle as a non-relational container for a such database?
Best Regards
Michel Petrovic

Software research and development Engineer

MCSE 2003
MCSD.NET
 
Old February 20th, 2006, 12:04 PM
Friend of Wrox
 
Join Date: Dec 2005
Posts: 146
Thanks: 0
Thanked 1 Time in 1 Post
Default

Michel,
That's a pretty broad question. Why does your customer want to use a non-relational database? Why is the customer telling you that instead of giving you higher level requirements and letting you recommend how to do it and where to store the data?

David Lundell
Principal Consultant and Trainer
www.mutuallybeneficial.com
 
Old February 20th, 2006, 04:52 PM
Friend of Wrox
 
Join Date: Nov 2003
Posts: 1,348
Thanks: 0
Thanked 5 Times in 5 Posts
Default

Non relational database = VERY BAD!

 
Old February 20th, 2006, 08:40 PM
SQLScott's Avatar
Wrox Author
 
Join Date: Dec 2004
Posts: 338
Thanks: 0
Thanked 2 Times in 2 Posts
Default

The closest book that would cover this would be Professional XML Databases (yes, a Wrox book). However, like the others, I have to ask, WHY?

Is it doable? Sure. But it will also be slow and cumberson. I would highly recommend you talk your customer out of it. If they want to use XML, they can use the new XML data type that comes with SQL Server 2005. Very fast, powerful, and still allows for "relational xml data".

 
Old February 21st, 2006, 04:05 PM
Friend of Wrox
 
Join Date: Jul 2003
Posts: 599
Thanks: 6
Thanked 3 Times in 3 Posts
Default

Very bad idea. Maybe your customer doesn't know what a relational database is.

Its very easy to do. People do it every day. Just don't create any relationships between your tables. WROX has a very good book, which I own and refer to frequently:

Professional SQL Server 2000 Database Design

Has very good explanations of DB design and normalization which is the theoretical basis for relational database design. Maybe you could dazzle your customer with a few quotes from this book. Ultimately, it will cost everyone more money and usually when you talk of money to customers they are more likely to listen.

Good luck!






Similar Threads
Thread Thread Starter Forum Replies Last Post
applying Filters to a relational database ggiibboo Access 3 February 2nd, 2006 02:55 AM
Trouble sorting relational data arcuza Classic ASP Databases 0 May 11th, 2005 03:08 AM
Post/Get from 2 Tables in Relational Database TSEROOGY Classic ASP Databases 1 November 16th, 2004 03:28 AM
Converting Flat File Database to Relational DB rj_655@hotmail.com Access 5 June 12th, 2004 09:33 AM
Indexing XML in relational database - performance cooold XML 1 November 13th, 2003 03:49 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.