May 2019
Beginner to intermediate
296 pages
6h 58m
Japanese
Content preview from IT用語図鑑 ビジネスで使える厳選キーワード256
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
253
関連用語
用語に関連する話
用語の使用例
6
I
T
「ストアドプロシージャならプログラムから呼び出すだけだね。」
アプリ側の保守性が向上
ストアドプロシージャを使うこ
とで、データベースの処理をまと
めてDBMS内に任せるため、アプ
リケーション側の保守性が向上
する。
互換性が低いため要注意
SQLは多くのDBMS で標準化さ
れているが、ストアドプロシージャ
はDBMS 独自の言語が使われる
ことが多く、互換性が低いことに
注意が必要である。
ビューとの使い分け
テーブルを結合し、必要な部分だ
けを見せるビューを定義するこ
ともでき、主に参照用に使われる。
ストアドプロシージャは複雑な
処理や更新処理に主に使われる。
ストアド プ ロ シ ー ジャ
一 連 の 処 理をまとめ て 実 行
データベースに対する複 数の処理を一 度に実 行するためにまとめた手 続きのことをストアド
プ ロシージャと言う。名 前 の 通り、データベースに 格 納される手 続きで 、データベース内 で
処理が完結するため、その手続きを呼び出すプログラミング言語には依存せずに実行で
きる。また 、コン パイル され た 状 態 で 格 納 され るた め 、高 速 に 実 行 できる。
Keyword
228
▶
すとあど ぷ ろしーじゃ
リレーショナ ル デ ータベースと S Q L
……P248
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access
More than 5,000 organizations count on O’Reilly
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.Julian F.
I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.Addison B.
I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.Amir M.
I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.