Results 1 to 10 of 10
  1. #1
    Join Date
    Sep 2003
    Posts
    20

    Question Unanswered: database clearing?

    Hello!

    I'd like to ask you what means the term "database clearing", if such a concept exists in the Database Theory.
    Maybe this is not directly related to SQL Server but any help would be very appreciated. So please anybody who have an idea of what this could mean is welcome to reply here

    Thank you very much in advance.
    With best regards,
    Sorin

  2. #2
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    It might mean truncating the production data tables (everything except lookup and reference values, for instance).
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  3. #3
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    "data cleansing" is a term used in data warehousing

    wikipedia is your friend

    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  4. #4
    Join Date
    Sep 2003
    Posts
    20
    Quote Originally Posted by blindman
    It might mean truncating the production data tables (everything except lookup and reference values, for instance).
    Could you please give a small example to illustrate the above definition?
    Thank you
    With best regards,
    Sorin

  5. #5
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    Lookup the TRUNCATE TABLE command in Books Online.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  6. #6
    Join Date
    Sep 2003
    Posts
    20
    Thank you all for answers. I still want to ask you if this term "database clearing" is used officially somewhere in the scientific literature or is just a folklore term? For example, in opposition, the terms "database cleaning" or "database cleansing" seems to have much more references in official contexts.


    With best regards,
    Sorin

  7. #7
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    sorin, in what context did you find the term "database clearing"? where did you see it? how did you find it? which folklore mentioned it?
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  8. #8
    Join Date
    Sep 2003
    Posts
    20

    Wink

    Quote Originally Posted by r937
    sorin, in what context did you find the term "database clearing"? where did you see it? how did you find it? which folklore mentioned it?
    I've heard this term from a person once and unfortunately then it was not an opportunity to ask him what he understood by it. From that time I did not hear again that term. I've searched for it on web but it was almost imposible to find it. That's why I was courious to find out if this term is just an invention of him or not

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

  10. #10
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    Sounds like you were asked a question at the interview. What company was it?
    "The data in a record depends on the Key to the record, the Whole Key, and
    nothing but the Key, so help me Codd."

Posting Permissions

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