Results 1 to 5 of 5
  1. #1
    Join Date
    Dec 2007
    Location
    London, UK
    Posts
    741

    Database feature wishlist

    If you could have it tomorrow, what new feature(s) would you most like to see in a DBMS? (Try to keep it to physically possible and on-topic suggestions if you can )

    My list:

    A relational data model and language to replace SQL (no surprise there then!)

    Self-optimising storage engine

    Generalised constraint support (full referential integrity, multi-relvar constraints, dependency constraints, transition constraints and an optimiser)

    Support for multiple assignment

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  3. #3
    Join Date
    Dec 2007
    Location
    London, UK
    Posts
    741
    Thanks Rudy, the "NoSQL" initiative was what inspired me to ask the question. Their criticism is actually directed at SQL and SQL products even though they sometimes wrongly assume that it's the relational model at fault. I agree with most of their criticisms. Not to put too fine a point on it, SQL is a dog and was a technology for the 1980s, not the 21st century. Now is a great time to be reviewing what we actually want from our DBMSs.

    Quote Originally Posted by r937
    scalability, to stop relational databases from being regarded as "toys"
    Crucially, scale out rather than just scale up I think.
    Last edited by dportas; 07-03-09 at 16:55.

  4. #4
    Join Date
    Jun 2009
    Posts
    66
    Microsoft stupidity is just amazing.

    The relational model is all about "sets". Stored procedures need to work on "sets". So, Microsoft added table-valued parameters in SQL 2008. Great, now you can pass in "table sets" for the stored procedure to CRUD against...so far so good.

    Problem? Once you create the table-valued "type" and use it in 1000s of stored procedures, if you EVER decide to add an extra column etc......you must drop all the references manually. This is the same thing with user defined types.

    Anyone know of an IDE that allows altering of table-valued types and user-defined types? Toad?
    Last edited by sqlguru; 07-04-09 at 15:02.

  5. #5
    Join Date
    Jun 2007
    Location
    London
    Posts
    2,527
    There was this thread a short while ago

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •