Conceptual Modeling - ER 2002 [[electronic resource] ] : 21st International Conference on Conceptual Modeling Tampere, Finland, October 7-11, 2002 Proceedings / / edited by Stefano Spaccapietra, Salvatore March, Yahiko Kambayashi |
Edizione | [1st ed. 2003.] |
Pubbl/distr/stampa | Berlin, Heidelberg : , : Springer Berlin Heidelberg : , : Imprint : Springer, , 2003 |
Descrizione fisica | 1 online resource (XX, 484 p.) |
Disciplina | 005.75/6 |
Collana | Lecture Notes in Computer Science |
Soggetto topico |
Computer simulation
Artificial intelligence Database management Application software Mathematical logic Software engineering Simulation and Modeling Artificial Intelligence Database Management Information Systems Applications (incl. Internet) Mathematical Logic and Formal Languages Software Engineering |
ISBN | 3-540-45816-6 |
Formato | Materiale a stampa |
Livello bibliografico | Monografia |
Lingua di pubblicazione | eng |
Nota di contenuto | Keynote Addresses -- Conceptual Modelling and Ontology: Possibilities and Pitfalls -- An Ontology for m-Business Models -- Pre-Conference Tutorials -- Modeling Dynamics of Business Processes: Key for Building Next Generation of Business Information Systems -- Ontology-Driven Conceptual Modelling -- Conference Tutorials -- Advanced OO Modelling: Metamodels and Notations for the New Millennium -- Ontology-Driven Conceptual Modelling: Advanced Concepts -- Workflow Management in Electronic Commerce -- Panel -- Do We Need an Ontology of Ontologies? -- Demonstrations and Posters -- Development of a Conceptual Data Model for Digital Spatio-Temporal Geographical Information, with Application to Several Themes and GIS -- Using Semantic Rules Database to Dynamically Set up the ICSpace Virtual Building -- On the Transformation of Object Oriented Conceptual Models to Logical Theories: From EROOS to ID-Logic -- Semantics and Meta-models -- Component Construction of Database Schemes -- Multirelational Semantics for Extended Entity-Relationship Schemata With Applications -- A Meta-model for e-Contract Template Variable Dependencies Facilitating e-Negotiation -- Principles of Ontology -- On the General Ontological Foundations of Conceptual Modeling -- Finding and Characterizing Changes in Ontologies -- Superimposed Schematics: Introducing E-R Structure for In-Situ Information Selections -- Web Environments -- Web extensions to UML: Using the MVC Triad -- Wiccap Data Model: Mapping Physical Websites to Logical Views -- Representing and Querying Semistructured Web Data Using Nested Tables with Structural Variants -- Theory and Methods -- On the Transformation of Object-Oriented Conceptual Models to Logical Theories -- Reasoning with Goal Models -- Registering Scientific Information Sources for Semantic Mediation -- Methods and Tools -- Multidimensional Modeling with UML Package Diagrams -- Comparative Evaluation of Large Data Model Representation Methods: The Analyst’s Perspective -- Extracting Conceptual Relationships from Specialized Documents -- Applications for Practice -- A Transactional Model for Data Warehouse Maintenance -- The Account Data Model -- A Semantic Model for Hypertext Data Caching -- Applying Ontology in Conceptual Modeling -- Understanding and Simulating Narratives in the Context of Information Systems -- Global Schema Generation Using Formal Ontologies -- Automatically Extracting Ontologically Specified Data from HTML Tables of Unknown Structure -- System and Data Integration -- On the Expressive Power of Data Integration Systems -- Property-Based Semantic Reconciliation of Heterogeneous Information Sources -- Conceptual integration of multiple partial geometric models -- Quality Assessment -- Evaluating the Quality of Process Models: Empirical Testing of a Quality Framework -- Data Quality in Web Information Systems -- XML & Object Systems -- Conceptual Modeling Quality - From EER to UML Schemas Evaluation -- Conceptual Modeling for Customized XML Schemas -- A Flexible Cost Model for Abstract Object-Oriented Database Schemas -- Designing Valid XML Views. |
Record Nr. | UNISA-996465390303316 |
Berlin, Heidelberg : , : Springer Berlin Heidelberg : , : Imprint : Springer, , 2003 | ||
Materiale a stampa | ||
Lo trovi qui: Univ. di Salerno | ||
|
Conceptual Modeling - ER 2002 : 21st International Conference on Conceptual Modeling Tampere, Finland, October 7-11, 2002 Proceedings / / edited by Stefano Spaccapietra, Salvatore March, Yahiko Kambayashi |
Edizione | [1st ed. 2003.] |
Pubbl/distr/stampa | Berlin, Heidelberg : , : Springer Berlin Heidelberg : , : Imprint : Springer, , 2003 |
Descrizione fisica | 1 online resource (XX, 484 p.) |
Disciplina | 005.75/6 |
Collana | Lecture Notes in Computer Science |
Soggetto topico |
Computer simulation
Artificial intelligence Database management Application software Mathematical logic Software engineering Simulation and Modeling Artificial Intelligence Database Management Information Systems Applications (incl. Internet) Mathematical Logic and Formal Languages Software Engineering |
ISBN | 3-540-45816-6 |
Formato | Materiale a stampa |
Livello bibliografico | Monografia |
Lingua di pubblicazione | eng |
Nota di contenuto | Keynote Addresses -- Conceptual Modelling and Ontology: Possibilities and Pitfalls -- An Ontology for m-Business Models -- Pre-Conference Tutorials -- Modeling Dynamics of Business Processes: Key for Building Next Generation of Business Information Systems -- Ontology-Driven Conceptual Modelling -- Conference Tutorials -- Advanced OO Modelling: Metamodels and Notations for the New Millennium -- Ontology-Driven Conceptual Modelling: Advanced Concepts -- Workflow Management in Electronic Commerce -- Panel -- Do We Need an Ontology of Ontologies? -- Demonstrations and Posters -- Development of a Conceptual Data Model for Digital Spatio-Temporal Geographical Information, with Application to Several Themes and GIS -- Using Semantic Rules Database to Dynamically Set up the ICSpace Virtual Building -- On the Transformation of Object Oriented Conceptual Models to Logical Theories: From EROOS to ID-Logic -- Semantics and Meta-models -- Component Construction of Database Schemes -- Multirelational Semantics for Extended Entity-Relationship Schemata With Applications -- A Meta-model for e-Contract Template Variable Dependencies Facilitating e-Negotiation -- Principles of Ontology -- On the General Ontological Foundations of Conceptual Modeling -- Finding and Characterizing Changes in Ontologies -- Superimposed Schematics: Introducing E-R Structure for In-Situ Information Selections -- Web Environments -- Web extensions to UML: Using the MVC Triad -- Wiccap Data Model: Mapping Physical Websites to Logical Views -- Representing and Querying Semistructured Web Data Using Nested Tables with Structural Variants -- Theory and Methods -- On the Transformation of Object-Oriented Conceptual Models to Logical Theories -- Reasoning with Goal Models -- Registering Scientific Information Sources for Semantic Mediation -- Methods and Tools -- Multidimensional Modeling with UML Package Diagrams -- Comparative Evaluation of Large Data Model Representation Methods: The Analyst’s Perspective -- Extracting Conceptual Relationships from Specialized Documents -- Applications for Practice -- A Transactional Model for Data Warehouse Maintenance -- The Account Data Model -- A Semantic Model for Hypertext Data Caching -- Applying Ontology in Conceptual Modeling -- Understanding and Simulating Narratives in the Context of Information Systems -- Global Schema Generation Using Formal Ontologies -- Automatically Extracting Ontologically Specified Data from HTML Tables of Unknown Structure -- System and Data Integration -- On the Expressive Power of Data Integration Systems -- Property-Based Semantic Reconciliation of Heterogeneous Information Sources -- Conceptual integration of multiple partial geometric models -- Quality Assessment -- Evaluating the Quality of Process Models: Empirical Testing of a Quality Framework -- Data Quality in Web Information Systems -- XML & Object Systems -- Conceptual Modeling Quality - From EER to UML Schemas Evaluation -- Conceptual Modeling for Customized XML Schemas -- A Flexible Cost Model for Abstract Object-Oriented Database Schemas -- Designing Valid XML Views. |
Record Nr. | UNINA-9910143896903321 |
Berlin, Heidelberg : , : Springer Berlin Heidelberg : , : Imprint : Springer, , 2003 | ||
Materiale a stampa | ||
Lo trovi qui: Univ. Federico II | ||
|
Conceptual Modeling for Novel Application Domains [[electronic resource] ] : ER 2003 Workshops ECOMO, IWCMQ, AOIS, and XSDM, Chicago, IL, USA, October 13, 2003, Proceedings / / edited by Manfred A. Jeusfeld, Oscar Pastor |
Edizione | [1st ed. 2003.] |
Pubbl/distr/stampa | Berlin, Heidelberg : , : Springer Berlin Heidelberg : , : Imprint : Springer, , 2003 |
Descrizione fisica | 1 online resource (XVI, 414 p.) |
Disciplina | 005.75/6 |
Collana | Lecture Notes in Computer Science |
Soggetto topico |
Software engineering
Database management Information storage and retrieval Application software Computers and civilization E-commerce Software Engineering/Programming and Operating Systems Database Management Information Storage and Retrieval Information Systems Applications (incl. Internet) Computers and Society e-Commerce/e-business |
ISBN | 3-540-39597-0 |
Formato | Materiale a stampa |
Livello bibliografico | Monografia |
Lingua di pubblicazione | eng |
Nota di contenuto | Conceptual Modeling Approaches for E-Business at ER 2003 (eCOMO 2003) -- Preface to eCOMO 2003 -- Managing Evolving Business Workflows through the Capture of Descriptive Information -- The Benefits of Rapid Modelling for E-business System Development -- Prediction of Consumer Preference through Bayesian Classification and Generating Profile -- Developing Web Applications from Conceptual Models. A Web Services Approach -- A Framework for Business Rule Driven Web Service Composition -- Virtual Integration of the Tile Industry (VITI) -- Second International Workshop on Conceptual Modeling Quality at ER 2003 (IWCMQ 2003) -- Preface to IWCMQ 2003 -- Multiperspective Evaluation of Reference Models – Towards a Framework -- On the Acceptability of Conceptual Design Models for Web Applications -- Consistency by Construction: The Case of MERODE -- Defining Metrics for UML Statechart Diagrams in a Methodological Way -- Visual SQL – High-Quality ER-Based Query Treatment -- Multidimensional Schemas Quality: Assessing and Balancing Analyzability and Simplicity -- Conceptual Modeling of Accounting Information Systems: A Comparative Study of REA and ER Diagrams -- Agent-Oriented Information Systems at ER 2003 (AOIS 2003) -- Preface to AOIS 2003 -- Bringing Multi-agent Systems into Human Organizations: Application to a Multi-agent Information System -- Reconciling Physical, Communicative, and Social/Institutional Domains in Agent Oriented Information Systems – A Unified Framework -- An Agent-Based Active Portal Framework -- Agent-Oriented Modeling and Agent-Based Simulation -- REF: A Practical Agent-Based Requirement Engineering Framework -- Patterns for Motivating an Agent-Based Approach -- Using Scenarios for Contextual Design in Agent-Oriented Information Systems -- Dynamic Matchmaking between Messages and Services in Multi-agent Information Systems -- International Workshop on XSDM at ER 2003 (XSDM 2003) -- Preface to XSDM 2003 -- A Sufficient and Necessary Condition for the Consistency of XML DTDs -- Index Selection for Efficient XML Path Expression Processing -- CX-DIFF: A Change Detection Algorithm for XML Content and Change Presentation Issues for WebVigiL -- Storing and Querying XML Documents Using a Path Table in Relational Databases -- Improving Query Performance Using Materialized XML Views: A Learning-Based Approach -- A Framework for Management of Concurrent XML Markup -- Object Oriented XML Query by Example -- Automatic Generation of XML from Relations: The Nested Relation Approach -- Toward the Automatic Derivation of XML Transformations -- VACXENE: A User-Friendly Visual Synthetic XML Generator -- A New Inlining Algorithm for Mapping XML DTDs to Relational Schemas -- From XML DTDs to Entity-Relationship Schemas -- Extracting Relations from XML Documents -- Extending XML Schema with Nonmonotonic Inheritance. |
Record Nr. | UNISA-996465960003316 |
Berlin, Heidelberg : , : Springer Berlin Heidelberg : , : Imprint : Springer, , 2003 | ||
Materiale a stampa | ||
Lo trovi qui: Univ. di Salerno | ||
|
Conceptual Modeling for Novel Application Domains : ER 2003 Workshops ECOMO, IWCMQ, AOIS, and XSDM, Chicago, IL, USA, October 13, 2003, Proceedings / / edited by Manfred A. Jeusfeld, Oscar Pastor |
Edizione | [1st ed. 2003.] |
Pubbl/distr/stampa | Berlin, Heidelberg : , : Springer Berlin Heidelberg : , : Imprint : Springer, , 2003 |
Descrizione fisica | 1 online resource (XVI, 414 p.) |
Disciplina | 005.75/6 |
Collana | Lecture Notes in Computer Science |
Soggetto topico |
Software engineering
Database management Information storage and retrieval Application software Computers and civilization E-commerce Software Engineering/Programming and Operating Systems Database Management Information Storage and Retrieval Information Systems Applications (incl. Internet) Computers and Society e-Commerce/e-business |
ISBN | 3-540-39597-0 |
Formato | Materiale a stampa |
Livello bibliografico | Monografia |
Lingua di pubblicazione | eng |
Nota di contenuto | Conceptual Modeling Approaches for E-Business at ER 2003 (eCOMO 2003) -- Preface to eCOMO 2003 -- Managing Evolving Business Workflows through the Capture of Descriptive Information -- The Benefits of Rapid Modelling for E-business System Development -- Prediction of Consumer Preference through Bayesian Classification and Generating Profile -- Developing Web Applications from Conceptual Models. A Web Services Approach -- A Framework for Business Rule Driven Web Service Composition -- Virtual Integration of the Tile Industry (VITI) -- Second International Workshop on Conceptual Modeling Quality at ER 2003 (IWCMQ 2003) -- Preface to IWCMQ 2003 -- Multiperspective Evaluation of Reference Models – Towards a Framework -- On the Acceptability of Conceptual Design Models for Web Applications -- Consistency by Construction: The Case of MERODE -- Defining Metrics for UML Statechart Diagrams in a Methodological Way -- Visual SQL – High-Quality ER-Based Query Treatment -- Multidimensional Schemas Quality: Assessing and Balancing Analyzability and Simplicity -- Conceptual Modeling of Accounting Information Systems: A Comparative Study of REA and ER Diagrams -- Agent-Oriented Information Systems at ER 2003 (AOIS 2003) -- Preface to AOIS 2003 -- Bringing Multi-agent Systems into Human Organizations: Application to a Multi-agent Information System -- Reconciling Physical, Communicative, and Social/Institutional Domains in Agent Oriented Information Systems – A Unified Framework -- An Agent-Based Active Portal Framework -- Agent-Oriented Modeling and Agent-Based Simulation -- REF: A Practical Agent-Based Requirement Engineering Framework -- Patterns for Motivating an Agent-Based Approach -- Using Scenarios for Contextual Design in Agent-Oriented Information Systems -- Dynamic Matchmaking between Messages and Services in Multi-agent Information Systems -- International Workshop on XSDM at ER 2003 (XSDM 2003) -- Preface to XSDM 2003 -- A Sufficient and Necessary Condition for the Consistency of XML DTDs -- Index Selection for Efficient XML Path Expression Processing -- CX-DIFF: A Change Detection Algorithm for XML Content and Change Presentation Issues for WebVigiL -- Storing and Querying XML Documents Using a Path Table in Relational Databases -- Improving Query Performance Using Materialized XML Views: A Learning-Based Approach -- A Framework for Management of Concurrent XML Markup -- Object Oriented XML Query by Example -- Automatic Generation of XML from Relations: The Nested Relation Approach -- Toward the Automatic Derivation of XML Transformations -- VACXENE: A User-Friendly Visual Synthetic XML Generator -- A New Inlining Algorithm for Mapping XML DTDs to Relational Schemas -- From XML DTDs to Entity-Relationship Schemas -- Extracting Relations from XML Documents -- Extending XML Schema with Nonmonotonic Inheritance. |
Record Nr. | UNINA-9910768187303321 |
Berlin, Heidelberg : , : Springer Berlin Heidelberg : , : Imprint : Springer, , 2003 | ||
Materiale a stampa | ||
Lo trovi qui: Univ. Federico II | ||
|
Database design and SQL for DB2 [[electronic resource] /] / James Cooper |
Autore | Cooper James |
Edizione | [1st ed.] |
Pubbl/distr/stampa | Boise, ID, : MC Press, c2013 |
Descrizione fisica | 1 online resource (505 p.) |
Disciplina | 005.75/6 |
Soggetto topico |
Database design
SQL (Computer program language) |
Soggetto genere / forma | Electronic books. |
ISBN | 1-58347-719-5 |
Formato | Materiale a stampa |
Livello bibliografico | Monografia |
Lingua di pubblicazione | eng |
Nota di contenuto |
Cover; Copyright; Dedication; Acknowledgments; Contents At A Glance; Contents; Introduction; Intended Audience; Companion Website; Instructors; Students; Contributors; Chapter 1: Database Concepts; Chapter Objectives; Introduction to Database and Database Management System; Relational Database Model; The DB2 Database; Database Terminology; The Importance of Database Design; Database Development Process; Database Planning; Requirements Analysis; Database Design; DBMS Selection; Database Implementation; Testing and Evaluation; Database Maintenance; Operation; End-of-Chapter; Chapter Summary
Key Terms Chapter 2: Conceptual Design Using ER Diagrams; Introduction to Database Design; Developing Entity Relationship Diagrams; ERD Case Study; Step 1: Identify Entities; Step 2: Identify Attributes; Step 3: Identify Unique Identifier (UID); Step 4: Determine Relationships; Step 5: Determine Optionality and Cardinality; Step 6: Eliminate Many-to-Many Relationships; Step 7: Named Relationships; Step 8: Determine Data Types; Recursive Relationship; Entity Subtypes; End-of-Chapter; Chapter Summary; Key Terms; Chapter 3: Normalization; Normalization; Normal Forms; Representing Database Tables Functional Dependency First Normal Form (1NF); Second Normal Form (2NF); Third Normal Form (3NF); Boyce-Codd Normal Form (BCNF); Fourth Normal Form (4NF); Practical Example; First Normal Form (1NF); Second Normal Form (2NF); Third Normal Form (3NF); End-of-Chapter; Chapter Summary; Key Terms; Chapter 4: Physical Database Design: Creating Tables; Physical Database Design; Transforming Conceptual Design To Physical Design; Primary, Candidate, and Foreign Keys; Specify View Implementation; Specify Security Implementation; Specifying Additional Indexes for Performance; Hierarchy of Data; Variables Database, Tables, Rows, and Columns Internal Binary Representation of Data; Data Types; Character Data Type; Numeric Data Types; Simulating a Boolean Data Type; Date Format; Timestamp Fields; Sample Data from a Table; Introduction to SQL; Running SQL Commands; Editor Pane; SQL Results Pane; Creating a Schema; Changing the Default Schema; Creating a Table; CREATE TABLE Command; Verify Syntax of SQL Script; Run SQL Script; Constraints; Qualified Names; Comments; NULL Values; Default Values; VARCHAR Data Type; ALTER Table Command; DROP (Delete) Table Command; Saving SQL Scripts; Edit SQL Scripts Adding Data to a Table The INSERT Command; Displaying Data in a Table; Display Table Description Information; Rename a Database Object; End-of-Chapter; Chapter Summary; Key Terms; Chapter 5: Database Constraints; Introduction to Constraints; Data Integrity; Entity Integrity; Referential Integrity; Constraint Types; Primary Key Constraints; Unique Constraints; Foreign Key Constraints; Defining Foreign Key Constraints; Foreign Key Actions; Additional Foreign Key Constraint Considerations; Avoid Foreign Key Constraints for Read-Only Tables; Check Constraints; Check Constraint Guidelines Defining Check Constraints |
Record Nr. | UNINA-9910462898103321 |
Cooper James | ||
Boise, ID, : MC Press, c2013 | ||
Materiale a stampa | ||
Lo trovi qui: Univ. Federico II | ||
|
Database design and SQL for DB2 [[electronic resource] /] / James Cooper |
Autore | Cooper James |
Edizione | [1st ed.] |
Pubbl/distr/stampa | Boise, ID, : MC Press, c2013 |
Descrizione fisica | 1 online resource (505 p.) |
Disciplina | 005.75/6 |
Soggetto topico |
Database design
SQL (Computer program language) |
ISBN | 1-58347-719-5 |
Formato | Materiale a stampa |
Livello bibliografico | Monografia |
Lingua di pubblicazione | eng |
Nota di contenuto |
Cover; Copyright; Dedication; Acknowledgments; Contents At A Glance; Contents; Introduction; Intended Audience; Companion Website; Instructors; Students; Contributors; Chapter 1: Database Concepts; Chapter Objectives; Introduction to Database and Database Management System; Relational Database Model; The DB2 Database; Database Terminology; The Importance of Database Design; Database Development Process; Database Planning; Requirements Analysis; Database Design; DBMS Selection; Database Implementation; Testing and Evaluation; Database Maintenance; Operation; End-of-Chapter; Chapter Summary
Key Terms Chapter 2: Conceptual Design Using ER Diagrams; Introduction to Database Design; Developing Entity Relationship Diagrams; ERD Case Study; Step 1: Identify Entities; Step 2: Identify Attributes; Step 3: Identify Unique Identifier (UID); Step 4: Determine Relationships; Step 5: Determine Optionality and Cardinality; Step 6: Eliminate Many-to-Many Relationships; Step 7: Named Relationships; Step 8: Determine Data Types; Recursive Relationship; Entity Subtypes; End-of-Chapter; Chapter Summary; Key Terms; Chapter 3: Normalization; Normalization; Normal Forms; Representing Database Tables Functional Dependency First Normal Form (1NF); Second Normal Form (2NF); Third Normal Form (3NF); Boyce-Codd Normal Form (BCNF); Fourth Normal Form (4NF); Practical Example; First Normal Form (1NF); Second Normal Form (2NF); Third Normal Form (3NF); End-of-Chapter; Chapter Summary; Key Terms; Chapter 4: Physical Database Design: Creating Tables; Physical Database Design; Transforming Conceptual Design To Physical Design; Primary, Candidate, and Foreign Keys; Specify View Implementation; Specify Security Implementation; Specifying Additional Indexes for Performance; Hierarchy of Data; Variables Database, Tables, Rows, and Columns Internal Binary Representation of Data; Data Types; Character Data Type; Numeric Data Types; Simulating a Boolean Data Type; Date Format; Timestamp Fields; Sample Data from a Table; Introduction to SQL; Running SQL Commands; Editor Pane; SQL Results Pane; Creating a Schema; Changing the Default Schema; Creating a Table; CREATE TABLE Command; Verify Syntax of SQL Script; Run SQL Script; Constraints; Qualified Names; Comments; NULL Values; Default Values; VARCHAR Data Type; ALTER Table Command; DROP (Delete) Table Command; Saving SQL Scripts; Edit SQL Scripts Adding Data to a Table The INSERT Command; Displaying Data in a Table; Display Table Description Information; Rename a Database Object; End-of-Chapter; Chapter Summary; Key Terms; Chapter 5: Database Constraints; Introduction to Constraints; Data Integrity; Entity Integrity; Referential Integrity; Constraint Types; Primary Key Constraints; Unique Constraints; Foreign Key Constraints; Defining Foreign Key Constraints; Foreign Key Actions; Additional Foreign Key Constraint Considerations; Avoid Foreign Key Constraints for Read-Only Tables; Check Constraints; Check Constraint Guidelines Defining Check Constraints |
Record Nr. | UNINA-9910786222603321 |
Cooper James | ||
Boise, ID, : MC Press, c2013 | ||
Materiale a stampa | ||
Lo trovi qui: Univ. Federico II | ||
|
Database design and SQL for DB2 / / James Cooper |
Autore | Cooper James |
Edizione | [1st ed.] |
Pubbl/distr/stampa | Boise, ID, : MC Press, c2013 |
Descrizione fisica | 1 online resource (505 p.) |
Disciplina | 005.75/6 |
Soggetto topico |
Database design
SQL (Computer program language) |
ISBN | 1-58347-719-5 |
Formato | Materiale a stampa |
Livello bibliografico | Monografia |
Lingua di pubblicazione | eng |
Nota di contenuto |
Cover; Copyright; Dedication; Acknowledgments; Contents At A Glance; Contents; Introduction; Intended Audience; Companion Website; Instructors; Students; Contributors; Chapter 1: Database Concepts; Chapter Objectives; Introduction to Database and Database Management System; Relational Database Model; The DB2 Database; Database Terminology; The Importance of Database Design; Database Development Process; Database Planning; Requirements Analysis; Database Design; DBMS Selection; Database Implementation; Testing and Evaluation; Database Maintenance; Operation; End-of-Chapter; Chapter Summary
Key Terms Chapter 2: Conceptual Design Using ER Diagrams; Introduction to Database Design; Developing Entity Relationship Diagrams; ERD Case Study; Step 1: Identify Entities; Step 2: Identify Attributes; Step 3: Identify Unique Identifier (UID); Step 4: Determine Relationships; Step 5: Determine Optionality and Cardinality; Step 6: Eliminate Many-to-Many Relationships; Step 7: Named Relationships; Step 8: Determine Data Types; Recursive Relationship; Entity Subtypes; End-of-Chapter; Chapter Summary; Key Terms; Chapter 3: Normalization; Normalization; Normal Forms; Representing Database Tables Functional Dependency First Normal Form (1NF); Second Normal Form (2NF); Third Normal Form (3NF); Boyce-Codd Normal Form (BCNF); Fourth Normal Form (4NF); Practical Example; First Normal Form (1NF); Second Normal Form (2NF); Third Normal Form (3NF); End-of-Chapter; Chapter Summary; Key Terms; Chapter 4: Physical Database Design: Creating Tables; Physical Database Design; Transforming Conceptual Design To Physical Design; Primary, Candidate, and Foreign Keys; Specify View Implementation; Specify Security Implementation; Specifying Additional Indexes for Performance; Hierarchy of Data; Variables Database, Tables, Rows, and Columns Internal Binary Representation of Data; Data Types; Character Data Type; Numeric Data Types; Simulating a Boolean Data Type; Date Format; Timestamp Fields; Sample Data from a Table; Introduction to SQL; Running SQL Commands; Editor Pane; SQL Results Pane; Creating a Schema; Changing the Default Schema; Creating a Table; CREATE TABLE Command; Verify Syntax of SQL Script; Run SQL Script; Constraints; Qualified Names; Comments; NULL Values; Default Values; VARCHAR Data Type; ALTER Table Command; DROP (Delete) Table Command; Saving SQL Scripts; Edit SQL Scripts Adding Data to a Table The INSERT Command; Displaying Data in a Table; Display Table Description Information; Rename a Database Object; End-of-Chapter; Chapter Summary; Key Terms; Chapter 5: Database Constraints; Introduction to Constraints; Data Integrity; Entity Integrity; Referential Integrity; Constraint Types; Primary Key Constraints; Unique Constraints; Foreign Key Constraints; Defining Foreign Key Constraints; Foreign Key Actions; Additional Foreign Key Constraint Considerations; Avoid Foreign Key Constraints for Read-Only Tables; Check Constraints; Check Constraint Guidelines Defining Check Constraints |
Record Nr. | UNINA-9910827799703321 |
Cooper James | ||
Boise, ID, : MC Press, c2013 | ||
Materiale a stampa | ||
Lo trovi qui: Univ. Federico II | ||
|
Database modeling & design [[electronic resource] ] : logical design / / Tobey Teorey, Sam Lightstone, Tom Nadeau |
Autore | Teorey Toby J |
Edizione | [4th ed.] |
Pubbl/distr/stampa | Amsterdam, : Elsevier |
Descrizione fisica | 1 online resource (294 p.) |
Disciplina | 005.75/6 |
Altri autori (Persone) |
LightstoneSam
NadeauTom <1958-> |
Collana | The Morgan Kaufmann Series in Data Management Systems |
Soggetto topico |
Relational databases
Database design |
Soggetto genere / forma | Electronic books. |
ISBN |
1-280-96150-3
9786610961504 0-08-047077-7 |
Formato | Materiale a stampa |
Livello bibliografico | Monografia |
Lingua di pubblicazione | eng |
Nota di contenuto |
front cover; copyright; table of contents; front matter; Preface; Organization; Typographical Conventions; Acknowledgments; Solutions Manual; body; 1 Introduction; 1.1 Data and Database Management; 1.2 The Database Life Cycle; 1.3 Conceptual Data Modeling; 1.4 Summary; 1.5 Literature Summary; 2 The Entity-Relationship Model; 2.1 Fundamental ER Constructs; 2.1.1 Basic Objects: Entities, Relationships, Attributes; 2.1.2 Degree of a Relationship; 2.1.3 Connectivity of a Relationship; 2.1.4 Attributes of a Relationship; 2.1.5 Existence of an Entity in a Relationship
2.1.6 Alternative Conceptual Data Modeling Notations2.2 Advanced ER Constructs; 2.2.1 Generalization: Supertypes and Subtypes; 2.2.2 Aggregation; 2.2.3 Ternary Relationships; 2.2.4 General n-ary Relationships; 2.2.5 Exclusion Constraint; 2.2.6 Referential Integrity; 2.3 Summary; 2.4 Literature Summary; 3 The Unified Modeling Language (UML); 3.1 Class Diagrams; 3.1.1 Basic Class Diagram Notation; 3.1.2 Class Diagrams for Database Design; 3.1.3 Example from the Music Industry; 3.2 Activity Diagrams; 3.2.1 Activity Diagram Notation Description; 3.2.2 Activity Diagrams for Workflow 3.3 Rules of Thumb for UML Usage3.4 Summary; 3.5 Literature Summary; 4 Requirements Analysis and Conceptual Data Modeling; 4.1 Introduction; 4.2 Requirements Analysis; 4.3 Conceptual Data Modeling; 4.3.1 Classify Entities and Attributes; 4.3.2 Identify the Generalization Hierarchies; 4.3.3 Define Relationships; 4.3.4 Example of Data Modeling: Company Personnel and Project Database; 4.4 View Integration; 4.4.1 Preintegration Analysis; 4.4.2 Comparison of Schemas; 4.4.3 Conformation of Schemas; 4.4.4 Merging and Restructuring of Schemas; 4.4.5 Example of View Integration 4.5 Entity Clustering for ER Models4.5.1 Clustering Concepts; 4.5.2 Grouping Operations; 4.5.3 Clustering Technique; 4.6 Summary; 4.7 Literature Summary; 5 Transforming the Conceptual Data Model to SQL; 5.1 Transformation Rules and SQL Constructs; 5.1.1 Binary Relationships; 5.1.2 Binary Recursive Relationships; 5.1.3 Ternary and n-ary Relationships; 5.1.4 Generalization and Aggregation; 5.1.5 Multiple Relationships; 5.1.6 Weak Entities; 5.2 Transformation Steps; 5.2.1 Entity Transformation; 5.2.2 Many-to-Many Binary Relationship Transformation; 5.2.3 Ternary Relationship Transformation 5.2.4 Example of ER-to-SQL Transformation5.3 Summary; 5.4 Literature Summary; 6 Normalization; 6.1 Fundamentals of Normalization; 6.1.1 First Normal Form; 6.1.2 Superkeys, Candidate Keys, and Primary Keys; 6.1.3 Second Normal Form; 6.1.4 Third Normal Form; 6.1.5 Boyce-Codd Normal Form; 6.2 The Design of Normalized Tables: A Simple Example; 6.3 Normalization of Candidate Tables Derived from ER Diagrams; 6.4 Determining the Minimum Set of 3NF Tables; 6.5 Fourth and Fifth Normal Forms; 6.5.1 Multivalued Dependencies; 6.5.2 Fourth Normal Form; 6.5.3 Decomposing Tables to 4NF 6.5.4 Fifth Normal Form |
Record Nr. | UNINA-9910458109403321 |
Teorey Toby J | ||
Amsterdam, : Elsevier | ||
Materiale a stampa | ||
Lo trovi qui: Univ. Federico II | ||
|
Database modeling & design [[electronic resource] ] : logical design / / Tobey Teorey, Sam Lightstone, Tom Nadeau |
Autore | Teorey Toby J |
Edizione | [4th ed.] |
Pubbl/distr/stampa | Amsterdam, : Elsevier |
Descrizione fisica | 1 online resource (294 p.) |
Disciplina | 005.75/6 |
Altri autori (Persone) |
LightstoneSam
NadeauTom <1958-> |
Collana | The Morgan Kaufmann Series in Data Management Systems |
Soggetto topico |
Relational databases
Database design |
ISBN |
1-280-96150-3
9786610961504 0-08-047077-7 |
Formato | Materiale a stampa |
Livello bibliografico | Monografia |
Lingua di pubblicazione | eng |
Nota di contenuto |
front cover; copyright; table of contents; front matter; Preface; Organization; Typographical Conventions; Acknowledgments; Solutions Manual; body; 1 Introduction; 1.1 Data and Database Management; 1.2 The Database Life Cycle; 1.3 Conceptual Data Modeling; 1.4 Summary; 1.5 Literature Summary; 2 The Entity-Relationship Model; 2.1 Fundamental ER Constructs; 2.1.1 Basic Objects: Entities, Relationships, Attributes; 2.1.2 Degree of a Relationship; 2.1.3 Connectivity of a Relationship; 2.1.4 Attributes of a Relationship; 2.1.5 Existence of an Entity in a Relationship
2.1.6 Alternative Conceptual Data Modeling Notations2.2 Advanced ER Constructs; 2.2.1 Generalization: Supertypes and Subtypes; 2.2.2 Aggregation; 2.2.3 Ternary Relationships; 2.2.4 General n-ary Relationships; 2.2.5 Exclusion Constraint; 2.2.6 Referential Integrity; 2.3 Summary; 2.4 Literature Summary; 3 The Unified Modeling Language (UML); 3.1 Class Diagrams; 3.1.1 Basic Class Diagram Notation; 3.1.2 Class Diagrams for Database Design; 3.1.3 Example from the Music Industry; 3.2 Activity Diagrams; 3.2.1 Activity Diagram Notation Description; 3.2.2 Activity Diagrams for Workflow 3.3 Rules of Thumb for UML Usage3.4 Summary; 3.5 Literature Summary; 4 Requirements Analysis and Conceptual Data Modeling; 4.1 Introduction; 4.2 Requirements Analysis; 4.3 Conceptual Data Modeling; 4.3.1 Classify Entities and Attributes; 4.3.2 Identify the Generalization Hierarchies; 4.3.3 Define Relationships; 4.3.4 Example of Data Modeling: Company Personnel and Project Database; 4.4 View Integration; 4.4.1 Preintegration Analysis; 4.4.2 Comparison of Schemas; 4.4.3 Conformation of Schemas; 4.4.4 Merging and Restructuring of Schemas; 4.4.5 Example of View Integration 4.5 Entity Clustering for ER Models4.5.1 Clustering Concepts; 4.5.2 Grouping Operations; 4.5.3 Clustering Technique; 4.6 Summary; 4.7 Literature Summary; 5 Transforming the Conceptual Data Model to SQL; 5.1 Transformation Rules and SQL Constructs; 5.1.1 Binary Relationships; 5.1.2 Binary Recursive Relationships; 5.1.3 Ternary and n-ary Relationships; 5.1.4 Generalization and Aggregation; 5.1.5 Multiple Relationships; 5.1.6 Weak Entities; 5.2 Transformation Steps; 5.2.1 Entity Transformation; 5.2.2 Many-to-Many Binary Relationship Transformation; 5.2.3 Ternary Relationship Transformation 5.2.4 Example of ER-to-SQL Transformation5.3 Summary; 5.4 Literature Summary; 6 Normalization; 6.1 Fundamentals of Normalization; 6.1.1 First Normal Form; 6.1.2 Superkeys, Candidate Keys, and Primary Keys; 6.1.3 Second Normal Form; 6.1.4 Third Normal Form; 6.1.5 Boyce-Codd Normal Form; 6.2 The Design of Normalized Tables: A Simple Example; 6.3 Normalization of Candidate Tables Derived from ER Diagrams; 6.4 Determining the Minimum Set of 3NF Tables; 6.5 Fourth and Fifth Normal Forms; 6.5.1 Multivalued Dependencies; 6.5.2 Fourth Normal Form; 6.5.3 Decomposing Tables to 4NF 6.5.4 Fifth Normal Form |
Record Nr. | UNINA-9910784564903321 |
Teorey Toby J | ||
Amsterdam, : Elsevier | ||
Materiale a stampa | ||
Lo trovi qui: Univ. Federico II | ||
|
Database modeling & design : logical design / / Tobey Teorey, Sam Lightstone, Tom Nadeau |
Autore | Teorey Toby J |
Edizione | [4th ed.] |
Pubbl/distr/stampa | Amsterdam, : Elsevier |
Descrizione fisica | 1 online resource (294 p.) |
Disciplina | 005.75/6 |
Altri autori (Persone) |
LightstoneSam
NadeauTom <1958-> |
Collana | The Morgan Kaufmann Series in Data Management Systems |
Soggetto topico |
Relational databases
Database design |
ISBN |
1-280-96150-3
9786610961504 0-08-047077-7 |
Formato | Materiale a stampa |
Livello bibliografico | Monografia |
Lingua di pubblicazione | eng |
Nota di contenuto |
front cover; copyright; table of contents; front matter; Preface; Organization; Typographical Conventions; Acknowledgments; Solutions Manual; body; 1 Introduction; 1.1 Data and Database Management; 1.2 The Database Life Cycle; 1.3 Conceptual Data Modeling; 1.4 Summary; 1.5 Literature Summary; 2 The Entity-Relationship Model; 2.1 Fundamental ER Constructs; 2.1.1 Basic Objects: Entities, Relationships, Attributes; 2.1.2 Degree of a Relationship; 2.1.3 Connectivity of a Relationship; 2.1.4 Attributes of a Relationship; 2.1.5 Existence of an Entity in a Relationship
2.1.6 Alternative Conceptual Data Modeling Notations2.2 Advanced ER Constructs; 2.2.1 Generalization: Supertypes and Subtypes; 2.2.2 Aggregation; 2.2.3 Ternary Relationships; 2.2.4 General n-ary Relationships; 2.2.5 Exclusion Constraint; 2.2.6 Referential Integrity; 2.3 Summary; 2.4 Literature Summary; 3 The Unified Modeling Language (UML); 3.1 Class Diagrams; 3.1.1 Basic Class Diagram Notation; 3.1.2 Class Diagrams for Database Design; 3.1.3 Example from the Music Industry; 3.2 Activity Diagrams; 3.2.1 Activity Diagram Notation Description; 3.2.2 Activity Diagrams for Workflow 3.3 Rules of Thumb for UML Usage3.4 Summary; 3.5 Literature Summary; 4 Requirements Analysis and Conceptual Data Modeling; 4.1 Introduction; 4.2 Requirements Analysis; 4.3 Conceptual Data Modeling; 4.3.1 Classify Entities and Attributes; 4.3.2 Identify the Generalization Hierarchies; 4.3.3 Define Relationships; 4.3.4 Example of Data Modeling: Company Personnel and Project Database; 4.4 View Integration; 4.4.1 Preintegration Analysis; 4.4.2 Comparison of Schemas; 4.4.3 Conformation of Schemas; 4.4.4 Merging and Restructuring of Schemas; 4.4.5 Example of View Integration 4.5 Entity Clustering for ER Models4.5.1 Clustering Concepts; 4.5.2 Grouping Operations; 4.5.3 Clustering Technique; 4.6 Summary; 4.7 Literature Summary; 5 Transforming the Conceptual Data Model to SQL; 5.1 Transformation Rules and SQL Constructs; 5.1.1 Binary Relationships; 5.1.2 Binary Recursive Relationships; 5.1.3 Ternary and n-ary Relationships; 5.1.4 Generalization and Aggregation; 5.1.5 Multiple Relationships; 5.1.6 Weak Entities; 5.2 Transformation Steps; 5.2.1 Entity Transformation; 5.2.2 Many-to-Many Binary Relationship Transformation; 5.2.3 Ternary Relationship Transformation 5.2.4 Example of ER-to-SQL Transformation5.3 Summary; 5.4 Literature Summary; 6 Normalization; 6.1 Fundamentals of Normalization; 6.1.1 First Normal Form; 6.1.2 Superkeys, Candidate Keys, and Primary Keys; 6.1.3 Second Normal Form; 6.1.4 Third Normal Form; 6.1.5 Boyce-Codd Normal Form; 6.2 The Design of Normalized Tables: A Simple Example; 6.3 Normalization of Candidate Tables Derived from ER Diagrams; 6.4 Determining the Minimum Set of 3NF Tables; 6.5 Fourth and Fifth Normal Forms; 6.5.1 Multivalued Dependencies; 6.5.2 Fourth Normal Form; 6.5.3 Decomposing Tables to 4NF 6.5.4 Fifth Normal Form |
Altri titoli varianti | Database modeling and design |
Record Nr. | UNINA-9910825615203321 |
Teorey Toby J | ||
Amsterdam, : Elsevier | ||
Materiale a stampa | ||
Lo trovi qui: Univ. Federico II | ||
|