Joe Celko's Thinking in Sets: Auxiliary, Temporal, and Virtual Tables in SQL

Perfectly intelligent programmers often struggle when forced to work with SQL. Why? Joe Celko believes the problem lies with their procedural programming mindset, which keeps them from taking full advantage of the power of declarative languages. The result is overly complex and inefficient code, not...

Mô tả đầy đủ

Đã lưu trong:
Chi tiết về thư mục
Tác giả chính: Celko, Joe
Định dạng: Sách
Ngôn ngữ:English
Được phát hành: Elsevier 2011
Những chủ đề:
Truy cập trực tuyến:http://scholar.dlu.edu.vn/thuvienso/handle/DLU123456789/25910
Các nhãn: Thêm thẻ
Không có thẻ, Là người đầu tiên thẻ bản ghi này!
Thư viện lưu trữ: Thư viện Trường Đại học Đà Lạt
id oai:scholar.dlu.edu.vn:DLU123456789-25910
record_format dspace
spelling oai:scholar.dlu.edu.vn:DLU123456789-259102012-03-03T05:04:04Z Joe Celko's Thinking in Sets: Auxiliary, Temporal, and Virtual Tables in SQL Celko, Joe Tin học Database Perfectly intelligent programmers often struggle when forced to work with SQL. Why? Joe Celko believes the problem lies with their procedural programming mindset, which keeps them from taking full advantage of the power of declarative languages. The result is overly complex and inefficient code, not to mention lost productivity. This book will change the way you think about the problems you solve with SQL programs.. Focusing on three key table-based techniques, Celko reveals their power through detailed examples and clear explanations. As you master these techniques, you'll find you are able to conceptualize problems as rooted in sets and solvable through declarative programming. Before long, you'll be coding more quickly, writing more efficient code, and applying the full power of SQL . Filled with the insights of one of the world's leading SQL authorities - noted for his knowledge and his ability to teach what he knows. . Focuses on auxiliary tables (for computing functions and other values by joins), temporal tables (for temporal queries, historical data, and audit information), and virtual tables (for improved performance). . Presents clear guidance for selecting and correctly applying the right table technique. 2011-09-20T08:03:31Z 2011-09-20T08:03:31Z 2008 Book 978-0-12-374137-0 http://scholar.dlu.edu.vn/thuvienso/handle/DLU123456789/25910 en application/pdf Elsevier
institution Thư viện Trường Đại học Đà Lạt
collection Thư viện số
language English
topic Tin học
Database
spellingShingle Tin học
Database
Celko, Joe
Joe Celko's Thinking in Sets: Auxiliary, Temporal, and Virtual Tables in SQL
description Perfectly intelligent programmers often struggle when forced to work with SQL. Why? Joe Celko believes the problem lies with their procedural programming mindset, which keeps them from taking full advantage of the power of declarative languages. The result is overly complex and inefficient code, not to mention lost productivity. This book will change the way you think about the problems you solve with SQL programs.. Focusing on three key table-based techniques, Celko reveals their power through detailed examples and clear explanations. As you master these techniques, you'll find you are able to conceptualize problems as rooted in sets and solvable through declarative programming. Before long, you'll be coding more quickly, writing more efficient code, and applying the full power of SQL . Filled with the insights of one of the world's leading SQL authorities - noted for his knowledge and his ability to teach what he knows. . Focuses on auxiliary tables (for computing functions and other values by joins), temporal tables (for temporal queries, historical data, and audit information), and virtual tables (for improved performance). . Presents clear guidance for selecting and correctly applying the right table technique.
format Book
author Celko, Joe
author_facet Celko, Joe
author_sort Celko, Joe
title Joe Celko's Thinking in Sets: Auxiliary, Temporal, and Virtual Tables in SQL
title_short Joe Celko's Thinking in Sets: Auxiliary, Temporal, and Virtual Tables in SQL
title_full Joe Celko's Thinking in Sets: Auxiliary, Temporal, and Virtual Tables in SQL
title_fullStr Joe Celko's Thinking in Sets: Auxiliary, Temporal, and Virtual Tables in SQL
title_full_unstemmed Joe Celko's Thinking in Sets: Auxiliary, Temporal, and Virtual Tables in SQL
title_sort joe celko's thinking in sets: auxiliary, temporal, and virtual tables in sql
publisher Elsevier
publishDate 2011
url http://scholar.dlu.edu.vn/thuvienso/handle/DLU123456789/25910
_version_ 1757661106257526784