まさぶんの部屋

copyright by えびぞう

目次

Blog 利用状況

ニュース

  • わんくま同盟
  • 書庫

    ギャラリ

    システム共通テーブルは嫌いですか?

    例えば、売上の地区分類、仕入の地区分類、年代といった

    各々5~10件程度で、メンテナンスもいらないようなマスター

    が10種類ぐらいあって、今まではシステム共通テーブルにしていた

    のですが、正規化して別々のテーブルの方がいいという意見がありました。

    皆さんはドウデショウか?

    #小さいテーブルはあまり作りたくない派ですが・・・

     

     

    投稿日時 : 2008年1月18日 16:30

    コメントを追加

    # re: システム共通テーブルは嫌いですか? 2008/01/18 16:45 黒龍

    大好きです。>小さいテーブル。
    ・制約が掛けれる
    ・プログラム側での範囲チェック不要
    ・サーバキャッシュを無駄に圧迫しない
    等のメリットがあるのでがんがんやります。
    逆にまとめた場合ってぜんぜんメリット無いんですよね

    # re: システム共通テーブルは嫌いですか? 2008/01/18 16:54 凪瀬

    小さいテーブルを作りますね。
    OOPでは小さいクラスとかも、がしがし作ります。

    面倒臭がってなんでも入るようなモノってのを作ると
    後になってもっと面倒なことになるのが世の常ですから。

    # re: システム共通テーブルは嫌いですか? 2008/01/18 17:11 まさぶん

    >面倒臭がってなんでも入るようなモノってのを作ると
    >後になってもっと面倒なことになるのが世の常

    確かにそうですね。


    # re: システム共通テーブルは嫌いですか? 2008/01/18 17:12 THREE-ONE

    まとめた時は表領域がどうのーってメリットを風のうわさで聞いた気がします。あんまり詳しくありません、すみません。
    ちなみに私も小さいテーブル作ります。
    用途の違うコードなどを一つにまとめてしまうと、どうしてもコーディング時に文字列の入り込む余地が増えるのが好きじゃないです。

    # re: システム共通テーブルは嫌いですか? 2008/01/18 17:41 Mr.T

    Mr.Tです、こんにちは。

    まとめた場合って、後から
    「あ、こういうの追加したいけど
    適当なフィールドがないや」
    ってことが、あったりしました。

    数値を入れたいのに、文字型のフィールド
    しかないとか。いちいちパースせんと
    あかんとか...

    # re: システム共通テーブルは嫌いですか? 2008/01/18 19:02 えムナウ

    >正規化して別々のテーブルの方がいい
    当然です。
    データベースの正規化をさぼるとろくなことがありません。

    同じ形式でテーブル数増やすのは無駄とか正規化をすると遅くなるとかの意見には耳を貸さないのが一番です。

    # re: システム共通テーブルは嫌いですか? 2008/01/18 19:52 Chuki

    >システム共通テーブルは嫌いですか?
    うん。嫌い
    #共通DBじゃないっすよね^^;

    小さいテーブルが山ほどあるのもスキではないですが、変にまとめられたときほど怒りは込み上げて来ません^^;

    # re: システム共通テーブルは嫌いですか? 2008/01/18 20:29 まさぶん

    >正規化をすると遅くなるとかの意見には耳を貸さない

    よく貸してしまいます・・・

    はるか昔の話ですが
    ファイル項目名が「項目1」・・「項目50」になって
    いて「拡張性を考えて何でもはいるように設計した」
    とか自慢した某メーカーSEがいました。

    # re: システム共通テーブルは嫌いですか? 2008/01/20 0:25 かつのり

    論理的に同じか違うかで別々にしますね。
    小さいテーブルでも意味があればどんどん作ります。

    # uriaGERiUByEcIFx 2012/09/08 12:48 patrik

    5ksot8 http://www.HyAkX1fLLA7FJn7pQJypwjpWJBQWQggb.com

    # If you wish for to get a good deal from this post then you have to apply such methods to your won blog. 2021/08/28 18:39 If you wish for to get a good deal from this post

    If you wish for to get a good deal from this post then you have to apply such
    methods to your won blog.

    # If you wish for to get a good deal from this post then you have to apply such methods to your won blog. 2021/08/28 18:40 If you wish for to get a good deal from this post

    If you wish for to get a good deal from this post then you have to apply such
    methods to your won blog.

    # If you wish for to get a good deal from this post then you have to apply such methods to your won blog. 2021/08/28 18:41 If you wish for to get a good deal from this post

    If you wish for to get a good deal from this post then you have to apply such
    methods to your won blog.

    # If you wish for to get a good deal from this post then you have to apply such methods to your won blog. 2021/08/28 18:42 If you wish for to get a good deal from this post

    If you wish for to get a good deal from this post then you have to apply such
    methods to your won blog.

    # Hi there everybody, here every person is sharing such knowledge, therefore it's pleasant to read this blog, and I used to pay a visit this webpage daily. 2021/08/31 22:29 Hi there everybody, here every person is sharing s

    Hi there everybody, here every person is sharing such knowledge, therefore it's
    pleasant to read this blog, and I used to pay a visit this webpage daily.

    # Hi there everybody, here every person is sharing such knowledge, therefore it's pleasant to read this blog, and I used to pay a visit this webpage daily. 2021/08/31 22:30 Hi there everybody, here every person is sharing s

    Hi there everybody, here every person is sharing such knowledge, therefore it's
    pleasant to read this blog, and I used to pay a visit this webpage daily.

    # Hi there everybody, here every person is sharing such knowledge, therefore it's pleasant to read this blog, and I used to pay a visit this webpage daily. 2021/08/31 22:31 Hi there everybody, here every person is sharing s

    Hi there everybody, here every person is sharing such knowledge, therefore it's
    pleasant to read this blog, and I used to pay a visit this webpage daily.

    # Hi there everybody, here every person is sharing such knowledge, therefore it's pleasant to read this blog, and I used to pay a visit this webpage daily. 2021/08/31 22:32 Hi there everybody, here every person is sharing s

    Hi there everybody, here every person is sharing such knowledge, therefore it's
    pleasant to read this blog, and I used to pay a visit this webpage daily.

    # I'm impressed, I must say. Seldom do I come across a blog that's both equally educative and entertaining, and let me tell you, you have hit the nail on the head. The problem is an issue that too few people are speaking intelligently about. I'm very happ 2021/09/02 6:08 I'm impressed, I must say. Seldom do I come across

    I'm impressed, I must say. Seldom do I come across
    a blog that's both equally educative and entertaining, and let me tell you, you have
    hit the nail on the head. The problem is an issue that too few
    people are speaking intelligently about. I'm very
    happy I found this in my search for something regarding this.

    # I'm impressed, I must say. Seldom do I come across a blog that's both equally educative and entertaining, and let me tell you, you have hit the nail on the head. The problem is an issue that too few people are speaking intelligently about. I'm very happ 2021/09/02 6:09 I'm impressed, I must say. Seldom do I come across

    I'm impressed, I must say. Seldom do I come across
    a blog that's both equally educative and entertaining, and let me tell you, you have
    hit the nail on the head. The problem is an issue that too few
    people are speaking intelligently about. I'm very
    happy I found this in my search for something regarding this.

    # I'm impressed, I must say. Seldom do I come across a blog that's both equally educative and entertaining, and let me tell you, you have hit the nail on the head. The problem is an issue that too few people are speaking intelligently about. I'm very happ 2021/09/02 6:10 I'm impressed, I must say. Seldom do I come across

    I'm impressed, I must say. Seldom do I come across
    a blog that's both equally educative and entertaining, and let me tell you, you have
    hit the nail on the head. The problem is an issue that too few
    people are speaking intelligently about. I'm very
    happy I found this in my search for something regarding this.

    # I'm impressed, I must say. Seldom do I come across a blog that's both equally educative and entertaining, and let me tell you, you have hit the nail on the head. The problem is an issue that too few people are speaking intelligently about. I'm very happ 2021/09/02 6:11 I'm impressed, I must say. Seldom do I come across

    I'm impressed, I must say. Seldom do I come across
    a blog that's both equally educative and entertaining, and let me tell you, you have
    hit the nail on the head. The problem is an issue that too few
    people are speaking intelligently about. I'm very
    happy I found this in my search for something regarding this.

    # My partner and I stumbled over here different website and thought I should check things out. I like what I see so i am just following you. Look forward to exploring your web page yet again. 2021/09/02 7:48 My partner and I stumbled over here different web

    My partner and I stumbled over here different website and thought
    I should check things out. I like what I see so i am just following you.
    Look forward to exploring your web page yet again.

    # My partner and I stumbled over here different website and thought I should check things out. I like what I see so i am just following you. Look forward to exploring your web page yet again. 2021/09/02 7:49 My partner and I stumbled over here different web

    My partner and I stumbled over here different website and thought
    I should check things out. I like what I see so i am just following you.
    Look forward to exploring your web page yet again.

    # My partner and I stumbled over here different website and thought I should check things out. I like what I see so i am just following you. Look forward to exploring your web page yet again. 2021/09/02 7:50 My partner and I stumbled over here different web

    My partner and I stumbled over here different website and thought
    I should check things out. I like what I see so i am just following you.
    Look forward to exploring your web page yet again.

    # My partner and I stumbled over here different website and thought I should check things out. I like what I see so i am just following you. Look forward to exploring your web page yet again. 2021/09/02 7:51 My partner and I stumbled over here different web

    My partner and I stumbled over here different website and thought
    I should check things out. I like what I see so i am just following you.
    Look forward to exploring your web page yet again.

    # This paragraph is genuinely a pleasant one it helps new internet visitors, who are wishing for blogging. 2021/09/03 18:30 This paragraph is genuinely a pleasant one it help

    This paragraph is genuinely a pleasant one it helps new internet visitors, who are wishing for
    blogging.

    # My spouse and I stumbled over here by a different web page and thought I may as well check things out. I like what I see so i am just following you. Look forward to looking at your web page for a second time. 2021/09/04 14:35 My spouse and I stumbled over here by a different

    My spouse and I stumbled over here by a different web page and thought I may as well check things out.
    I like what I see so i am just following you. Look forward to looking at your web page for a second time.

    # My spouse and I stumbled over here by a different web page and thought I may as well check things out. I like what I see so i am just following you. Look forward to looking at your web page for a second time. 2021/09/04 14:36 My spouse and I stumbled over here by a different

    My spouse and I stumbled over here by a different web page and thought I may as well check things out.
    I like what I see so i am just following you. Look forward to looking at your web page for a second time.

    # My spouse and I stumbled over here by a different web page and thought I may as well check things out. I like what I see so i am just following you. Look forward to looking at your web page for a second time. 2021/09/04 14:37 My spouse and I stumbled over here by a different

    My spouse and I stumbled over here by a different web page and thought I may as well check things out.
    I like what I see so i am just following you. Look forward to looking at your web page for a second time.

    # My spouse and I stumbled over here by a different web page and thought I may as well check things out. I like what I see so i am just following you. Look forward to looking at your web page for a second time. 2021/09/04 14:38 My spouse and I stumbled over here by a different

    My spouse and I stumbled over here by a different web page and thought I may as well check things out.
    I like what I see so i am just following you. Look forward to looking at your web page for a second time.

    # Hi there to all, it's actually a good for me to go to see this website, it includes precious Information. 2021/09/06 4:48 Hi there to all, it's actually a good for me to go

    Hi there to all, it's actually a good for me to go to see this website, it includes precious Information.

    # Hi there to all, it's actually a good for me to go to see this website, it includes precious Information. 2021/09/06 4:49 Hi there to all, it's actually a good for me to go

    Hi there to all, it's actually a good for me to go to see this website, it includes precious Information.

    # Hi there to all, it's actually a good for me to go to see this website, it includes precious Information. 2021/09/06 4:50 Hi there to all, it's actually a good for me to go

    Hi there to all, it's actually a good for me to go to see this website, it includes precious Information.

    # Hi there to all, it's actually a good for me to go to see this website, it includes precious Information. 2021/09/06 4:51 Hi there to all, it's actually a good for me to go

    Hi there to all, it's actually a good for me to go to see this website, it includes precious Information.

    # I am regular visitor, how are you everybody? This article posted at this website is genuinely pleasant. 2021/10/25 19:04 I am regular visitor, how are you everybody? This

    I am regular visitor, how are you everybody? This
    article posted at this website is genuinely pleasant.

    # I am regular visitor, how are you everybody? This article posted at this website is genuinely pleasant. 2021/10/25 19:05 I am regular visitor, how are you everybody? This

    I am regular visitor, how are you everybody? This
    article posted at this website is genuinely pleasant.

    # I am regular visitor, how are you everybody? This article posted at this website is genuinely pleasant. 2021/10/25 19:06 I am regular visitor, how are you everybody? This

    I am regular visitor, how are you everybody? This
    article posted at this website is genuinely pleasant.

    # I am regular visitor, how are you everybody? This article posted at this website is genuinely pleasant. 2021/10/25 19:07 I am regular visitor, how are you everybody? This

    I am regular visitor, how are you everybody? This
    article posted at this website is genuinely pleasant.

    # Great items from you, man. I have take into accout your stuff prior to and you are simply extremely magnificent. I actually like what you have bought right here, really like what you're saying and the way in which through which you assert it. You're ma 2021/10/27 5:52 Great items from you, man. I have take into accout

    Great items from you, man. I have take into accout your stuff prior to and you are simply extremely magnificent.
    I actually like what you have bought right here, really like what you're
    saying and the way in which through which you assert it.
    You're making it entertaining and you still take
    care of to keep it sensible. I can not wait to learn far
    more from you. This is really a wonderful site.

    # Great items from you, man. I have take into accout your stuff prior to and you are simply extremely magnificent. I actually like what you have bought right here, really like what you're saying and the way in which through which you assert it. You're ma 2021/10/27 5:53 Great items from you, man. I have take into accout

    Great items from you, man. I have take into accout your stuff prior to and you are simply extremely magnificent.
    I actually like what you have bought right here, really like what you're
    saying and the way in which through which you assert it.
    You're making it entertaining and you still take
    care of to keep it sensible. I can not wait to learn far
    more from you. This is really a wonderful site.

    # Great items from you, man. I have take into accout your stuff prior to and you are simply extremely magnificent. I actually like what you have bought right here, really like what you're saying and the way in which through which you assert it. You're ma 2021/10/27 5:54 Great items from you, man. I have take into accout

    Great items from you, man. I have take into accout your stuff prior to and you are simply extremely magnificent.
    I actually like what you have bought right here, really like what you're
    saying and the way in which through which you assert it.
    You're making it entertaining and you still take
    care of to keep it sensible. I can not wait to learn far
    more from you. This is really a wonderful site.

    # Great items from you, man. I have take into accout your stuff prior to and you are simply extremely magnificent. I actually like what you have bought right here, really like what you're saying and the way in which through which you assert it. You're ma 2021/10/27 5:55 Great items from you, man. I have take into accout

    Great items from you, man. I have take into accout your stuff prior to and you are simply extremely magnificent.
    I actually like what you have bought right here, really like what you're
    saying and the way in which through which you assert it.
    You're making it entertaining and you still take
    care of to keep it sensible. I can not wait to learn far
    more from you. This is really a wonderful site.

    # Your style is very unique compared to other folks I have read stuff from. Thanks for posting when you have the opportunity, Guess I will just book mark this blog. 2021/11/12 12:33 Your style is very unique compared to other folks

    Your style is very unique compared to other folks I have read stuff from.
    Thanks for posting when you have the opportunity, Guess I will just book mark this blog.

    # Your style is very unique compared to other folks I have read stuff from. Thanks for posting when you have the opportunity, Guess I will just book mark this blog. 2021/11/12 12:34 Your style is very unique compared to other folks

    Your style is very unique compared to other folks I have read stuff from.
    Thanks for posting when you have the opportunity, Guess I will just book mark this blog.

    # Your style is very unique compared to other folks I have read stuff from. Thanks for posting when you have the opportunity, Guess I will just book mark this blog. 2021/11/12 12:34 Your style is very unique compared to other folks

    Your style is very unique compared to other folks I have read stuff from.
    Thanks for posting when you have the opportunity, Guess I will just book mark this blog.

    # Your style is very unique compared to other folks I have read stuff from. Thanks for posting when you have the opportunity, Guess I will just book mark this blog. 2021/11/12 12:35 Your style is very unique compared to other folks

    Your style is very unique compared to other folks I have read stuff from.
    Thanks for posting when you have the opportunity, Guess I will just book mark this blog.

    # Amazing! Its actually awesome article, I have got much clear idea about from this article. 2022/11/27 19:42 Amazing! Its actually awesome article, I have got

    Amazing! Its actually awesome article, I have got much clear
    idea about from this article.

    タイトル
    名前
    URL
    コメント