LEADER 05465nam 2200673Ia 450 001 9910459503703321 005 20200520144314.0 010 $a1-282-87957-X 010 $a9786612879579 010 $a0-12-382023-5 035 $a(CKB)2670000000048741 035 $a(EBL)610555 035 $a(OCoLC)677829483 035 $a(SSID)ssj0000438515 035 $a(PQKBManifestationID)11321748 035 $a(PQKBTitleCode)TC0000438515 035 $a(PQKBWorkID)10453047 035 $a(PQKB)10174476 035 $a(MiAaPQ)EBC610555 035 $a(CaSebORM)9780123820228 035 $a(Au-PeEL)EBL610555 035 $a(CaPaEBR)ebr10427795 035 $a(EXLCZ)992670000000048741 100 $a20100804d2010 uy 0 101 0 $aeng 135 $aur|n|---||||| 181 $ctxt 182 $cc 183 $acr 200 10$aJoe Celko's SQL for smarties$b[electronic resource] $eadvanced SQL programming /$fJoe Celko 205 $a4th ed. 210 $aAmsterdam ;$aBoston $cElsevier$d2010 215 $a1 online resource (817 p.) 225 1 $aThe Morgan Kaufmann series in data management systems 300 $aDescription based upon print version of record. 311 $a0-12-382022-7 320 $aIncludes bibliographical references and index. 327 $aFront Cover; Series page; Joe Celko's SQL for Smarties; Copyright; Dedication; Table of Contents; About the Author; Introduction to the Fourth Edition; Chapter 1. Databases versus File Systems; 1.1 Tables as Entities; 1.2 Tables as Relationships; 1.3 Rows versus Records; 1.4 Columns versus Fields; 1.5 Schema Objects; 1.6 CREATE SCHEMA Statement; Chapter 2. Transactions and Concurrency Control; 2.1 Sessions; 2.2 Transactions and ACID; 2.3 Concurrency Control; 2.4 Pessimistic Concurrency Control; 2.5 SNAPSHOT Isolation and Optimistic Concurrency; 2.6 Logical Concurrency Control 327 $a2.7 Deadlock and LivelocksChapter 3. Schema Level Objects; 3.1 CREATE SCHEMA Statement; 3.2 CREATE PROCEDURE, CREATE FUNCTION, and CREATE TRIGGER; 3.3 CREATE DOMAIN Statement; 3.4 CREATE SEQUENCE; 3.5 CREATE ASSERTION; 3.6 Character Set Related Constructs; Chapter 4. Locating Data and Special Numbers; 4.1 Exposed Physical Locators; 4.2 Generated Identifiers; 4.3 Sequence Generator Functions; 4.4 Preallocated Values; 4.5 Special Series; Chapter 5. Base Tables and Related Elements; 5.1 CREATE TABLE Statement; 5.2 Nested UNIQUE Constraints; 5.3 CREATE ASSERTION Constraints; 5.4 TEMPORARY Tables 327 $a5.5 Manipulating Tables5.6 Avoiding Attribute Splitting; 5.7 Modeling Class Hierarchies in DDL; 5.8 Exposed Physical Locators; 5.9 Auto-Incrementing Columns; 5.10 Generated Identifiers; 5.11 A Remark on Duplicate Rows; 5.12 Other Schema Objects; 5.13 Temporary Tables; 5.14 CREATE DOMAIN Statement; 5.15 CREATE TRIGGER Statement; 5.16 CREATE PROCEDURE Statement; 5.17 DECLARE CURSOR Statement; Chapter 6. Procedural, Semiprocedural, and Declarative Programming; 6.1 Basics of Software Engineering; 6.2 Cohesion; 6.3 Coupling; 6.4 The Big Leap; 6.5 Rewriting Tricks; 6.6 Functions for Predicates 327 $a6.7 Procedural versus Logical DecompositionChapter 7. Procedural Constructs; 7.1 CREATE PROCEDURE; 7.2 CREATE TRIGGER; 7.3 CURSORs; 7.4 SEQUENCEs; 7.5 Generated Columns; 7.6 Table Functions; Chapter 8. Auxiliary Tables; 8.1 The Series Table; 8.2 Lookup Auxiliary Tables; 8.3 Auxiliary Function Tables; 8.4 Global Constants Tables; 8.5 A Note on Converting Procedural Code to Tables; Chapter 9. Normalization; 9.1 Functional and Multivalued Dependencies; 9.2 First Normal Form (1NF); 9.3 Second Normal Form (2NF); 9.4 Third Normal Form (3NF); 9.5 Elementary Key Normal Form (EKNF) 327 $a9.6 Boyce-Codd Normal Form (BCNF)9.7 Fourth Normal Form (4NF); 9.8 Fifth Normal Form (5NF); 9.9 Domain-Key Normal Form (DKNF); 9.10 Practical Hints for Normalization; 9.11 Key Types; 9.12 Practical Hints for Denormalization; Chapter 10. Numeric Data Types; 10.1 Numeric Types; 10.2 Numeric Type Conversion; 10.3 Four Function Arithmetic; 10.4 Arithmetic and NULLs; 10.5 Converting Values to and from NULL; 10.6 Mathematical Functions; 10.7 Unique Value Generators; 10.8 IP Addresses; Chapter 11. Temporal Data Types; 11.1 Notes on Calendar Standards; 11.2 SQL Temporal Data Types 327 $a11.3 INTERVAL Data Types 330 $a SQL for Smarties was hailed as the first book devoted explicitly to the advanced techniques needed to transform an experienced SQL programmer into an expert. Now, 15 years later and in its fourth edition, this classic reference still reigns supreme as the only book written by a SQL master that teaches programmers and practitioners to become SQL masters themselves! These are not just tips and techniques; also offered are the best solutions to old and new challenges. Joe Celko conveys the way you need to think in order to get the most out of SQL programming efforts for both correctness and pe 410 0$aMorgan Kaufmann series in data management systems. 606 $aSQL (Computer program language) 606 $aDatabase design 608 $aElectronic books. 615 0$aSQL (Computer program language) 615 0$aDatabase design. 676 $a005.13/3 700 $aCelko$b Joe$0627493 801 0$bMiAaPQ 801 1$bMiAaPQ 801 2$bMiAaPQ 906 $aBOOK 912 $a9910459503703321 996 $aJoe Celko's sql for smarties$91950888 997 $aUNINA LEADER 06270oam 2200649I 450 001 9910452924303321 005 20200520144314.0 010 $a1-351-28163-1 010 $a1-351-28164-X 010 $a1-909493-35-X 024 7 $a10.4324/9781351281645 035 $a(CKB)2550000001040301 035 $a(EBL)1741653 035 $a(SSID)ssj0001101118 035 $a(PQKBManifestationID)11985888 035 $a(PQKBTitleCode)TC0001101118 035 $a(PQKBWorkID)11066938 035 $a(PQKB)11362644 035 $a(MiAaPQ)EBC1741653 035 $a(Au-PeEL)EBL1741653 035 $a(CaPaEBR)ebr10650054 035 $a(OCoLC)884015502 035 $a(OCoLC)1011117697 035 $a(EXLCZ)992550000001040301 100 $a20180706d2017 uy 0 101 0 $aeng 135 $aurcn||||||||| 181 $ctxt 182 $cc 183 $acr 200 10$aGreening Chinese Business $eBarriers, Trends and Opportunities for Environmental Management /$feditors, Fang Zhaoben, Ulrich Steger 205 $aFirst edition. 210 1$aLondon :$cTaylor and Francis,$d2017. 215 $a1 online resource (194 p.) 300 $aDescription based upon print version of record. 311 $a1-874719-58-6 327 $aFront cover; Copyright page; Contents; Front matter; Text; Back matter; Back cover 330 2 $aEnvironmental regulation in China is not really different from that in the rest of the world, except that environmental authorities are relatively new and less established. In order to understand why corporate environmental performance has hardly improved despite the existing regulatory framework, empirical research on high-level executives' perceptions of environmental protection is essential. This unique book analyses and interprets Chinese managers' perceptions of environmental management and regulatory enforcement practices in Chinese enterprises. Most importantly, it identifies the bottlenecks to environmental protection in Chinese firms. It includes a detailed analysis of the needs for management training (for example, CEO and executive development and MBA education) in China and presents a roadmap of how they can be met. Finally, it presents two case studies that illustrate how Chinese corporations currently react to a wide range of different environmental challenges, including hardening regulatory pressure, competition and lack of capital. Based on an innovative research project sponsored by the UNESCO/UNDP offices in Beijing and undertaken by the Institute for Management Development (IMD), Lausanne, Switzerland and the Business School of the Academy of Science and Technology (USTC), Hefei, China, Greening Chinese Business provides the first hard empirical evidence of how Chinese managers view environmental protection. Over 300 companies-both state-owned enterprises and SMEs-took part in the research. Key findings includeAround 70% of managers surveyed admit moderate or even heavy environmental impact (this is a subjective assessment without an external benchmark). Furthermore, they indicate that the lack of environmental performance is primarily due to insufficient managerial expertise, capital and employment-related protectionism. Managers hesitate to take necessary action to upgrade technical equipment, because, although decreasing pollution, upgrading would lead to lay-offs that, in turn, would diminish social stability. Since the latter is first priority in China, managers fear loss of their companies'-and, attached to that, their personal-image, which plays a very important role in Chinese culture. Regulative enforcement has been strong enough to put environmental management on the "to do" lists of Chinese managers. Nevertheless, managers criticise existing enforcement practices as being too lax and untransparent (due to local protectionism, bribery and lack of expertise in the enforcement institutions). Managers consider environmental functionaries-the Chinese equivalent of an environmental protection agency-and the government to be the most important environmental stakeholders. This is a clear sign for their predominantly reactive attitude towards environmental protection: few Chinese companies are going beyond compliance and pioneering integrated approaches to pollution prevention. The research shows similarities between current Chinese company approaches and the "state of the art" in industrial centres of OECD countries such as Germany in the 1960s. Apart from a lack of capital, managers cite a lack of expertise-managerial more than technical-as the main obstacle to "greening" their organisations. Environmental management programmes need to be developed: competence-building should start with CEOs and executives. Greening Chinese Business will aid readers to understand how: Chinese managers perceive and react to the increasing (more external than internal) pressure to improve environmental protection; understand the regulatory, public and business environment in which Chinese managers make decisions about environmental protection; understand the potential for improvement of this regulatory, public and business environment, either as a manager or an external stakeholder and develop strategies that lead to improved stakeholder relationships and, consequently, to competitive advantage; understand the urgent need to develop environmental management practices in Chinese companies in areas such as EMSs and supply chain management; and identify the resources available for management development in China. 606 $aIndustrial management$xEnvironmental aspects$zChina 606 $aEnvironmental responsibility$zChina 606 $aSocial responsibility of business$zChina 606 $aEnvironmental law$zChina 608 $aElectronic books. 615 0$aIndustrial management$xEnvironmental aspects 615 0$aEnvironmental responsibility 615 0$aSocial responsibility of business 615 0$aEnvironmental law 676 $a658.4/08/0951 700 $aWei$b Lu$0925858 702 $aSteger$b Ulrich 702 $aZhaoben$b Fang 801 0$bFlBoTFG 801 1$bFlBoTFG 906 $aBOOK 912 $a9910452924303321 996 $aGreening Chinese Business$92078813 997 $aUNINA