top

  Info

  • Utilizzare la checkbox di selezione a fianco di ciascun documento per attivare le funzionalità di stampa, invio email, download nei formati disponibili del (i) record.

  Info

  • Utilizzare questo link per rimuovere la selezione effettuata.
Advanced SQL, 1999 [electronic resource] : understanding object-relational and other advanced features / Jim Melton
Advanced SQL, 1999 [electronic resource] : understanding object-relational and other advanced features / Jim Melton
Autore Melton, Jim, 1946-
Pubbl/distr/stampa Amsterdam ; Boston, Mass. : Morgan Kaufmann Pub., c2003.
Descrizione fisica xxviii, 563 p. : ill. ; 24 cm.
Disciplina 005.75/65
Collana The Morgan Kaufmann series in data management systems
Soggetto topico SQL (Computer program language)
Object-oriented programming (Computer science)
Relational databases
Soggetto genere / forma Electronic books.
ISBN 9781558606777
1558606777
Formato Risorse elettroniche
Livello bibliografico Monografia
Lingua di pubblicazione eng
Nota di contenuto Introduction to SQL:1999. User-Defined Types. Typed Tables. Routines and Routine Invocation. Foreign Servers and Foreign-Data Wrappers. Datalinks. OLAP. SQL/OLB and SQL/JRT. SQL/XML. SQL Multimedia and Application Package. A Look To The Future. Appendix: An SQL:1999 Example Using UDTs. The SQL:1999 Annexes. Relevant Standards Bodies. Status Codes. The SQL Standardization Process.
Record Nr. UNISALENTO-991003248429707536
Melton, Jim, 1946-  
Amsterdam ; Boston, Mass. : Morgan Kaufmann Pub., c2003.
Risorse elettroniche
Lo trovi qui: Univ. del Salento
Opac: Controlla la disponibilità qui
Advances in conceptual modeling - challenges and opportunities : ER 2008 workshops CMLSA, ECDM, FP-UML, M2AS, RIGiM, SeCoGIS, WISM, Barcelona, Spain, October 20-23, 2008, proceedings / / Il-Yeol Song [and nine others], editors
Advances in conceptual modeling - challenges and opportunities : ER 2008 workshops CMLSA, ECDM, FP-UML, M2AS, RIGiM, SeCoGIS, WISM, Barcelona, Spain, October 20-23, 2008, proceedings / / Il-Yeol Song [and nine others], editors
Edizione [1st ed. 2008.]
Pubbl/distr/stampa Berlin ; ; Heidelberg : , : Springer-Verlag, , [2008]
Descrizione fisica 1 online resource (XX, 468 p.)
Disciplina 005.74
Collana Lecture Notes in Computer Science
Soggetto topico Database design
Conceptual structures (Information theory)
Relational databases
ISBN 3-540-87991-9
Classificazione 54.60
Formato Materiale a stampa
Livello bibliografico Monografia
Lingua di pubblicazione eng
Nota di contenuto CLMSA 2008 – Second International Workshop on Conceptual Modeling for Life Sciences Applications -- Preface to CMLSA 2008 -- Models of the Human Metabolism -- Designing Privacy-Aware Personal Health Record Systems -- Linking Biological Databases Semantically for Knowledge Discovery -- Integration of Genomic, Proteomic and Biomedical Information on the Semantic Web -- Domain Knowledge Integration and Semantical Quality Management –A Biology Case Study– -- Towards a Scientific Model Management System -- ECDM 2008 – Fifth International Workshop on Evolution and Change in Data Management -- Preface to ECDM 2008 -- Time Versus Standards: A Tale of Temporal Databases -- Modeling Transformations between Versions of a Temporal Data Warehouse -- Managing the History of Metadata in Support for DB Archiving and Schema Evolution -- Towards a Dynamic Inconsistency-Tolerant Schema Maintenance -- FP-UML 2008 – Fourth International Workshop on Foundations and Practices of UML -- Preface to FP-UML 2008 -- Using Object Concepts and UML for Conceptual Modeling -- Towards Obtaining Analysis-Level Class and Use Case Diagrams from Business Process Models -- Improving Automatic UML2 Profile Generation for MDA Industrial Development -- A UML Profile for Modelling Measurable Requirements -- A Comprehensive Aspect-Oriented Use Case Method for Modeling Complex Business Requirements -- Exploiting the Complementary Relationship between Use Case Models and Activity Diagrams for Developing Quality Requirements Specifications -- M2AS 2008 – First International Workshop on Modeling Mobile Applications and Services -- Preface to M2AS 2008 -- A Dynamically Extensible, Service-Based Infrastructure for Mobile Applications -- The Situation Lens: Looking into Personal Service Composition -- A System for Dynamically Generating User Centric Interfaces for Mobile Applications and Services -- Multimodal Mobile Virtual Blackboard -- Personalized Mobile Multimodal Services: CHAT Project Experiences -- A General-Purpose Context Modeling Architecture for Adaptive Mobile Services -- Barcode Scanning from Mobile-Phone Camera Photos Delivered Via MMS: Case Study -- A Qualitative Study of the Applicability of Technology Acceptance Models to Senior Mobile Phone Users -- Visualising the Dynamics of Unfolding Interactions on Mobile Devices -- RIGiM 2008 – Second International Workshop on Requirements, Intentions and Goals in Conceptual Modeling -- Preface to RIGiM 2008 -- Reflective Analysis of the Syntax and Semantics of the i* Framework -- Modeling Strategic Alignment Using INSTAL -- Requirements Engineering for Distributed Development Using Software Agents -- Integrating Business Domain Ontologies with Early Requirements Modelling -- Goal-Oriented Authoring Approach and Design of Learning Systems -- Timing Nonfunctional Requirements -- SeCoGIS 2008 – Second International Workshop on Semantic and Conceptual Issues in Geographic Information Systems -- Preface to SeCoGIS 2008 -- Projective Relations on the Sphere -- Life and Motion Configurations: A Basis for Spatio-temporal Generalized Reasoning Model -- A Semantic and Language-Based Model of Landscape Scenes -- An Ontology-Based Approach for the Semantic Modelling and Reasoning on Trajectories -- Administrative Units, an Ontological Perspective -- A Modular Data Infrastructure for Location-Based Services -- A Method to Derivate SOAP Interfaces and WSDL Metadata from the OGC Web Processing Service Mandatory Interfaces -- Managing Sensor Data on Urban Traffic -- Retrieving Documents with Geographic References Using a Spatial Index Structure Based on Ontologies -- WISM 2008 – Fifth International Workshop on Web Information Systems Modeling -- Preface to WISM 2008 -- Abstract State Services -- A Meta-model Approach to the Management of Hypertexts in Web Information Systems -- An Approach to Creating Design Methods for the Implementation of Product Software: The Case of Web Information Systems -- Semantic Verification of Web System Contents -- Identifying Users Stereotypes with Semantic Web Mining -- On Temporal Cardinality in the Context of the TOWL Language.
Record Nr. UNISA-996465484203316
Berlin ; ; Heidelberg : , : Springer-Verlag, , [2008]
Materiale a stampa
Lo trovi qui: Univ. di Salerno
Opac: Controlla la disponibilità qui
Advances in conceptual modeling - foundations and applications : ER 2007 workshops CMLSA, FP-UML, ONISW, QoIS, RIGiM, SeCoGIS, Auckland, New Zealand, November 5-9, 2007 : proceedings / / Jean-Luc Hainaut [and nine others] (editors)
Advances in conceptual modeling - foundations and applications : ER 2007 workshops CMLSA, FP-UML, ONISW, QoIS, RIGiM, SeCoGIS, Auckland, New Zealand, November 5-9, 2007 : proceedings / / Jean-Luc Hainaut [and nine others] (editors)
Edizione [1st ed. 2007.]
Pubbl/distr/stampa Berlin, Heidelberg : , : Springer-Verlag, , [2007]
Descrizione fisica 1 online resource (XIX, 424 p.)
Disciplina 005.74
Collana Lecture Notes in Computer Science
Soggetto topico Database design
Relational databases
Conceptual structures (Information theory)
ISBN 3-540-76292-2
Formato Materiale a stampa
Livello bibliografico Monografia
Lingua di pubblicazione eng
Nota di contenuto CMLSA 2007 – International Workshop on Conceptual Modelling for Life Sciences Applications -- Preface to CMLSA 2007 -- Knowledge Discovery in Life Sciences -- Pattern Recognition of Single-Molecule Force Spectroscopy Data -- Massive Protein Structural Property Explorations Using New Indexing Mechanism -- Data Integration and Exchange in Health Informatics -- Data Access and Management in ACGT: Tools to Solve Syntactic and Semantic Heterogeneities Between Clinical and Image Databases -- Ontology-Based Data Integration in Data Logistics Workflows -- Model-Driven Development Based Transformation of Stereotyped Class Diagrams to XML Schemas in a Healthcare Context -- Conceptual Modelling for Biological Systems -- An Extendable System for Conceptual Modeling and Simulation of Signal Transduction Pathways -- Toward an Ontological Database for Subcellular Neuroanatomy -- Seed-Based Generation of Personalized Bio-ontologies for Information Extraction -- FP-UML 2007 – International Workshop on Foundations and Practices of UML -- Preface to FP-UML 2007 -- Improving the Use of UML Diagrams -- Developing State Diagrams Using a State Specialization Technique -- Quality Dependencies Among Use Case Models and Sequence Diagrams Developed by Novice Systems Analysts -- M-BPSec: A Method for Security Requirement Elicitation from a UML 2.0 Business Process Specification -- Model Transformations and Extensions -- Applying Model Transformation By-Example on Business Process Modeling Languages -- Extending OCL to Ensure Model Transformations -- A UML Profile for Modeling Data Warehouse Usage -- ONISW 2007 – InternationalWorkshop on Ontologies and Information Systems for the Semantic Web -- Preface to ONISW 2007 -- A Method for Semi-automatic Creation of Ontologies Based on Texts -- Enriching OWL with Instance Recognition Semantics for Automated Semantic Annotation -- Making Web Users’ Domain Models Explicit by Applying Ontologies -- Provability-Based Semantic Interoperability Via Translation Graphs -- QoIS 2007 – International Workshop on Quality of Information Systems -- Preface to QoIS 2007 -- PQM vs. BPQM: Studying the Tailoring of a General Quality Model to a Specific Domain -- An Ontological Approach for the Quality Assessment of Computer Science Conferences -- Using Practitioners for Assessing the Understandability of UML Statechart Diagrams with Composite States -- RIGiM 2007 – International Workshop on Requirements, Intentions and Goals in Conceptual Modelling -- Preface to RIGiM 2007 -- Keynote -- An Ontology for Requirements -- Requirements and Goals – Methods -- GOORE : Goal-Oriented and Ontology Driven Requirements Elicitation Method -- Early Prioritisation of Goals -- Goal-Aligned Requirements Generation -- A Model-Driven Goal-Oriented Requirement Engineering Approach for Data Warehouses -- Visually Effective Goal Models Using KAOS -- Agent Based Executable Conceptual Models Using i* and CASO -- Requirements and Goals – Concepts -- Achieving, Satisficing, and Excelling -- On the Adequacy of i* Models for Representing and Analyzing Software Architectures -- Extending Argumentation to Goal-Oriented Requirements Engineering -- SeCoGIS 2007 – International Workshop on Semantic and Conceptual Issues in Geographic Information Systems -- Preface to SeCoGIS 2007 -- Moving Objects -- Modeling Historical and Future Spatio-temporal Relationships of Moving Objects in Databases -- Towards a Semantic Spatial Model for Pedestrian Indoor Navigation -- Modeling Collaborative Semantics with a Geographic Recommender -- Dynamically Traveling Web Service Clustering Based on Spatial and Temporal Aspects -- Advances in Conceptual Modelling for GIS -- A Graph-Oriented Model and Query Language for Events -- PLR Partitions: A Conceptual Model of Maps -- A Conceptual Framework to Support Semantic Interoperability of Geospatial Datacubes -- Integrity Constraints and Approximate Reasoning -- On Languages for the Specification of Integrity Constraints in Spatial Conceptual Models -- Approximate Queries by Relaxing Structural Constraints in GIS -- Ensuring the Semantic Correctness of Complex Regions.
Record Nr. UNISA-996465481503316
Berlin, Heidelberg : , : Springer-Verlag, , [2007]
Materiale a stampa
Lo trovi qui: Univ. di Salerno
Opac: Controlla la disponibilità qui
Beginning Microsoft SQL Server 2008 programming [[electronic resource] /] / Robert Vieira
Beginning Microsoft SQL Server 2008 programming [[electronic resource] /] / Robert Vieira
Autore Vieira Robert
Edizione [1st edition]
Pubbl/distr/stampa Indianapolis, IN, : Wiley Pub., 2008
Descrizione fisica 1 online resource (724 p.)
Disciplina 005.75/85
Collana Wrox beginning guides.
Soggetto topico Database management
Relational databases
Soggetto genere / forma Electronic books.
ISBN 1-118-05960-3
1-282-68296-2
9786612682964
0-470-42394-3
Formato Materiale a stampa
Livello bibliografico Monografia
Lingua di pubblicazione eng
Nota di contenuto Beginning Microsoft SQL Server 2008 Programming; About the Author; Credits; Acknowledgments; Contents; Introduction; Chapter 1: RDBMS Basics: What Makes Up a SQL Server Database?; Chapter 2: Tools of the Trade; Chapter 3: The Foundation Statements of T-SQL; Chapter 4: JOINs; Chapter 5: Creating and Altering Tables; Chapter 6: Constraints; Chapter 7: Adding More to Our Queries; Chapter 8: Being Normal: Normalization and Other Basic Design Issues; Chapter 9: SQL Server Storage and Index Structures; Chapter 10: Views; Chapter 11: Writing Scripts and Batches; Chapter 12: Stored Procedures
Chapter 13: User-Defined FunctionsChapter 14: Transactions and Locks; Chapter 15: Triggers; Chapter 16: A Brief XML Primer; Chapter 17: Reporting for Duty, Sir! A Look At Reporting Services; Chapter 18: Getting Integrated with Integration Services; Chapter 19: Playing Administrator; Appendix A: System Functions; Appendix B: Very Simple Connectivity Examples; Index
Record Nr. UNINA-9910454130303321
Vieira Robert  
Indianapolis, IN, : Wiley Pub., 2008
Materiale a stampa
Lo trovi qui: Univ. Federico II
Opac: Controlla la disponibilità qui
Beginning Microsoft SQL Server 2008 programming [[electronic resource] /] / Robert Vieira
Beginning Microsoft SQL Server 2008 programming [[electronic resource] /] / Robert Vieira
Autore Vieira Robert
Edizione [1st edition]
Pubbl/distr/stampa Indianapolis, IN, : Wiley Pub., 2008
Descrizione fisica 1 online resource (724 p.)
Disciplina 005.75/85
Collana Wrox beginning guides.
Soggetto topico Database management
Relational databases
ISBN 1-118-05960-3
1-282-68296-2
9786612682964
0-470-42394-3
Formato Materiale a stampa
Livello bibliografico Monografia
Lingua di pubblicazione eng
Nota di contenuto Beginning Microsoft SQL Server 2008 Programming; About the Author; Credits; Acknowledgments; Contents; Introduction; Chapter 1: RDBMS Basics: What Makes Up a SQL Server Database?; Chapter 2: Tools of the Trade; Chapter 3: The Foundation Statements of T-SQL; Chapter 4: JOINs; Chapter 5: Creating and Altering Tables; Chapter 6: Constraints; Chapter 7: Adding More to Our Queries; Chapter 8: Being Normal: Normalization and Other Basic Design Issues; Chapter 9: SQL Server Storage and Index Structures; Chapter 10: Views; Chapter 11: Writing Scripts and Batches; Chapter 12: Stored Procedures
Chapter 13: User-Defined FunctionsChapter 14: Transactions and Locks; Chapter 15: Triggers; Chapter 16: A Brief XML Primer; Chapter 17: Reporting for Duty, Sir! A Look At Reporting Services; Chapter 18: Getting Integrated with Integration Services; Chapter 19: Playing Administrator; Appendix A: System Functions; Appendix B: Very Simple Connectivity Examples; Index
Record Nr. UNINA-9910782661103321
Vieira Robert  
Indianapolis, IN, : Wiley Pub., 2008
Materiale a stampa
Lo trovi qui: Univ. Federico II
Opac: Controlla la disponibilità qui
Beginning Microsoft SQL Server 2012 Programming [[electronic resource]]
Beginning Microsoft SQL Server 2012 Programming [[electronic resource]]
Autore Atkinson Paul (Software engineer)
Edizione [1st edition]
Pubbl/distr/stampa New York, : Wiley, 2012
Descrizione fisica 1 online resource (866 p.)
Disciplina 004.36
005.7585
Altri autori (Persone) VieiraRobert
Soggetto topico Client/server computing
Database management
Relational databases
SQL server
Engineering & Applied Sciences
Computer Science
Soggetto genere / forma Electronic books.
ISBN 1-283-94101-5
1-118-22388-8
Formato Materiale a stampa
Livello bibliografico Monografia
Lingua di pubblicazione eng
Nota di contenuto Beginning: Microsoft® SQL Server® 2012 Programming; Credits; About The Authors; About The Technical Editor; Acknowledgments; Contents; Introduction; Who This Book Is For; What This Book Covers; How This Book Is Structured; What You Need To Use This Book; Conventions; Source Code; Errata; P2P.wrox.com; Chapter 1: RDBMS Basics: What Makes Up a SQL Server Database?; An Overview of Database Objects; The Database Object; The Transaction Log; The Most Basic Database Object: Table; Filegroups; Diagrams; Views; Stored Procedures; User-Defined Functions; Sequences; Users and Roles; Rules; Defaults
User-Defined Data TypesFull-Text Catalogs; SQL Server Data Types; NULL Data; SQL Server Identifiers for Objects; What Gets Named?; Rules for Naming; Summary; Chapter 2: Learning the Tools of the Trade; Getting Help with Books Online; SQL Server Configuration Manager; Service Management; Network Configuration; The Protocols; On to the Client; SQL Server Management Studio; Getting Started with the Management Studio; Interacting Through the Query Window; SQL Server Data Tools (formerly BIDS); SQL Server Integration Services (SSIS); SQL Server Reporting Services (SSRS)
SQL Server Analysis Services (SSAS)Bulk Copy Program (BCP); SQL Server Profiler; sqlcmd; PowerShell; Summary; Chapter 3: The Foundation Statements of T-SQL; Getting Started with a Basic SELECT Statement; The SELECT Statement and FROM Clause; The WHERE Clause; ORDER BY; Aggregating Data Using the GROUP BY Clause; Placing Conditions on Groups with the HAVING Clause; Outputting XML Using the FOR XML Clause; Making Use of Hints Using the OPTION Clause; The DISTINCT and ALL Predicates; Adding Data with the INSERT Statement; Multirow Inserts; The INSERT INTO . . . SELECT Statement
Changing What You've Got with the UPDATE StatementThe DELETE Statement; Summary; Chapter 4: Joins; Combining Table Data with JOINs; Selecting Matching Rows with INNER JOIN; How an INNER JOIN Is Like a WHERE Clause; Retrieving More Data with OUTER JOIN; The Simple OUTER JOIN; Dealing with More Complex OUTER JOINs; Seeing Both Sides with FULL JOINs; Understanding CROSS JOINs; Exploring Alternative Syntax for Joins; An Alternative INNER JOIN; An Alternative OUTER JOIN; An Alternative CROSS JOIN; Stacking Results with UNION; Summary; Chapter 5: Creating and Altering Tables
Object Names in SQL ServerSchema Name (aka Ownership); The Database Name; Naming by Server; Reviewing the Defaults; The CREATE Statement; CREATE DATABASE; Building a Database; CREATE TABLE; The ALTER Statement; ALTER DATABASE; ALTER TABLE; The DROP Statement; Using the GUI Tool; Creating a Database Using the Management Studio; Backing into the Code: Creating Scripts with the Management Studio; Summary; Chapter 6: Keys and Constraints; Types of Constraints; Domain Constraints; Entity Constraints; Referential Integrity Constraints; Constraint Naming; Key Constraints; Primary Key Constraints
Foreign Key Constraints
Record Nr. UNINA-9910461589803321
Atkinson Paul (Software engineer)  
New York, : Wiley, 2012
Materiale a stampa
Lo trovi qui: Univ. Federico II
Opac: Controlla la disponibilità qui
Beginning Microsoft SQL Server 2012 Programming [[electronic resource]]
Beginning Microsoft SQL Server 2012 Programming [[electronic resource]]
Autore Atkinson Paul (Software engineer)
Edizione [1st edition]
Pubbl/distr/stampa New York, : Wiley, 2012
Descrizione fisica 1 online resource (866 p.)
Disciplina 004.36
005.7585
Altri autori (Persone) VieiraRobert
Soggetto topico Client/server computing
Database management
Relational databases
SQL server
Engineering & Applied Sciences
Computer Science
ISBN 1-283-94101-5
1-118-22388-8
Formato Materiale a stampa
Livello bibliografico Monografia
Lingua di pubblicazione eng
Nota di contenuto Beginning: Microsoft® SQL Server® 2012 Programming; Credits; About The Authors; About The Technical Editor; Acknowledgments; Contents; Introduction; Who This Book Is For; What This Book Covers; How This Book Is Structured; What You Need To Use This Book; Conventions; Source Code; Errata; P2P.wrox.com; Chapter 1: RDBMS Basics: What Makes Up a SQL Server Database?; An Overview of Database Objects; The Database Object; The Transaction Log; The Most Basic Database Object: Table; Filegroups; Diagrams; Views; Stored Procedures; User-Defined Functions; Sequences; Users and Roles; Rules; Defaults
User-Defined Data TypesFull-Text Catalogs; SQL Server Data Types; NULL Data; SQL Server Identifiers for Objects; What Gets Named?; Rules for Naming; Summary; Chapter 2: Learning the Tools of the Trade; Getting Help with Books Online; SQL Server Configuration Manager; Service Management; Network Configuration; The Protocols; On to the Client; SQL Server Management Studio; Getting Started with the Management Studio; Interacting Through the Query Window; SQL Server Data Tools (formerly BIDS); SQL Server Integration Services (SSIS); SQL Server Reporting Services (SSRS)
SQL Server Analysis Services (SSAS)Bulk Copy Program (BCP); SQL Server Profiler; sqlcmd; PowerShell; Summary; Chapter 3: The Foundation Statements of T-SQL; Getting Started with a Basic SELECT Statement; The SELECT Statement and FROM Clause; The WHERE Clause; ORDER BY; Aggregating Data Using the GROUP BY Clause; Placing Conditions on Groups with the HAVING Clause; Outputting XML Using the FOR XML Clause; Making Use of Hints Using the OPTION Clause; The DISTINCT and ALL Predicates; Adding Data with the INSERT Statement; Multirow Inserts; The INSERT INTO . . . SELECT Statement
Changing What You've Got with the UPDATE StatementThe DELETE Statement; Summary; Chapter 4: Joins; Combining Table Data with JOINs; Selecting Matching Rows with INNER JOIN; How an INNER JOIN Is Like a WHERE Clause; Retrieving More Data with OUTER JOIN; The Simple OUTER JOIN; Dealing with More Complex OUTER JOINs; Seeing Both Sides with FULL JOINs; Understanding CROSS JOINs; Exploring Alternative Syntax for Joins; An Alternative INNER JOIN; An Alternative OUTER JOIN; An Alternative CROSS JOIN; Stacking Results with UNION; Summary; Chapter 5: Creating and Altering Tables
Object Names in SQL ServerSchema Name (aka Ownership); The Database Name; Naming by Server; Reviewing the Defaults; The CREATE Statement; CREATE DATABASE; Building a Database; CREATE TABLE; The ALTER Statement; ALTER DATABASE; ALTER TABLE; The DROP Statement; Using the GUI Tool; Creating a Database Using the Management Studio; Backing into the Code: Creating Scripts with the Management Studio; Summary; Chapter 6: Keys and Constraints; Types of Constraints; Domain Constraints; Entity Constraints; Referential Integrity Constraints; Constraint Naming; Key Constraints; Primary Key Constraints
Foreign Key Constraints
Record Nr. UNINA-9910790275803321
Atkinson Paul (Software engineer)  
New York, : Wiley, 2012
Materiale a stampa
Lo trovi qui: Univ. Federico II
Opac: Controlla la disponibilità qui
Business intelligence cookbook [[electronic resource] ] : a project lifecycle approach using Oracle technology : over 80 quick and advanced recipes that focus on real-world techniques and solutions to manage, design, and build data warehouse and business intelligence projects / / John Heaton
Business intelligence cookbook [[electronic resource] ] : a project lifecycle approach using Oracle technology : over 80 quick and advanced recipes that focus on real-world techniques and solutions to manage, design, and build data warehouse and business intelligence projects / / John Heaton
Autore Heaton John
Edizione [1st edition]
Pubbl/distr/stampa Birmingham, : Packt Pub., 2012
Descrizione fisica 1 online resource (368 p.)
Disciplina 005.7565
Collana Enterprise : professional expertise distilled
Soggetto topico Relational databases
Open source software
Database management
Soggetto genere / forma Electronic books.
ISBN 1-283-51966-6
9786613832115
1-84968-549-5
Formato Materiale a stampa
Livello bibliografico Monografia
Lingua di pubblicazione eng
Nota di contenuto Cover; Copyright; Credits; About the Author; Acknowledgement; About the Reviewers; www.PacktPub.com; Table of Contents; Preface; Chapter 1: Defining a Program; Introduction; Program or a project; Mapping your business culture; Adapting your project delivery methodology; Assessing your project team; Organizing your project team; Chapter 2: Establishing the Project; Introduction; Creating Definition work practice; Creating Data Discovery work practice; Creating Development work practice; Creating Testing work practice; Creating Promote work practice; Creating Production work practice
Building a standard work breakdown structureIdentifying and quantifying the effort drivers; Creating your estimation tool; Chapter 3: Controlling the Project; Introduction; Requirements Traceability Matrix; Creating an effective risk register; Creating an effective issue management register; Creating a defect and enhancement register; Creating a cyclical build and test process; Setting up a collaborative environment; Installing client tools for a collaborative environment; Chapter 4: Wrapping Up the Project; Introduction; Creating OWB code artifacts; Creating OBIEE code artifacts
Creating APEX code artifactsCreating ODI code artifacts; Creating script artifacts; Building a continuous development capability for enhancements; Creating a constant feedback and communications loop; Chapter 5: The Blueprint; Introduction; Outlining your business processes; Categorizing your metrics, analysis, and reports within the business process; Decomposing your analysis and reports to define business entities; Developing your semantic data model; Identifying your source of record for your business entities; Building the blueprint; Chapter 6: Analyzing the Requirements; Introduction
Decomposing the reports and requirementsDefining the business rules; Categorizing the business requirements by business drivers; Prioritizing the business requirements; Adding hierarchies to your semantic data model; Adding metrics to your semantic data model; Defining your data dictionary; Defining your security requirements; Defining your data retention requirements; Chapter 7: Architecture and Design; Introduction; Choosing your database type; Defining your database layout; Selecting the Third Normal Form or a Dimensional model; Chapter 8: Analyzing the Sources; Introduction
Validating and enhancing a conceptual data modelCreating a business process matrix; Creating a report requirements matrix; Creating a source matrix; Developing the data lineage; Defining the detailed transformations; Chapter 9: Analyzing the Data; Introduction; Building high and low data profiling scripts; Building domain/distinct values profiling; Building record count profiling scripts; Building density data profiling scripts; Building hierarchy data profiling scripts; Building data lengths data profiling scripts; Building significant columns data profiling scripts
Building changing information data profiling scripts
Record Nr. UNINA-9910452700003321
Heaton John  
Birmingham, : Packt Pub., 2012
Materiale a stampa
Lo trovi qui: Univ. Federico II
Opac: Controlla la disponibilità qui
Business intelligence cookbook [[electronic resource] ] : a project lifecycle approach using Oracle technology : over 80 quick and advanced recipes that focus on real-world techniques and solutions to manage, design, and build data warehouse and business intelligence projects / / John Heaton
Business intelligence cookbook [[electronic resource] ] : a project lifecycle approach using Oracle technology : over 80 quick and advanced recipes that focus on real-world techniques and solutions to manage, design, and build data warehouse and business intelligence projects / / John Heaton
Autore Heaton John
Edizione [1st edition]
Pubbl/distr/stampa Birmingham, : Packt Pub., 2012
Descrizione fisica 1 online resource (368 p.)
Disciplina 005.7565
Collana Enterprise : professional expertise distilled
Soggetto topico Relational databases
Open source software
Database management
ISBN 1-283-51966-6
9786613832115
1-84968-549-5
Formato Materiale a stampa
Livello bibliografico Monografia
Lingua di pubblicazione eng
Nota di contenuto Cover; Copyright; Credits; About the Author; Acknowledgement; About the Reviewers; www.PacktPub.com; Table of Contents; Preface; Chapter 1: Defining a Program; Introduction; Program or a project; Mapping your business culture; Adapting your project delivery methodology; Assessing your project team; Organizing your project team; Chapter 2: Establishing the Project; Introduction; Creating Definition work practice; Creating Data Discovery work practice; Creating Development work practice; Creating Testing work practice; Creating Promote work practice; Creating Production work practice
Building a standard work breakdown structureIdentifying and quantifying the effort drivers; Creating your estimation tool; Chapter 3: Controlling the Project; Introduction; Requirements Traceability Matrix; Creating an effective risk register; Creating an effective issue management register; Creating a defect and enhancement register; Creating a cyclical build and test process; Setting up a collaborative environment; Installing client tools for a collaborative environment; Chapter 4: Wrapping Up the Project; Introduction; Creating OWB code artifacts; Creating OBIEE code artifacts
Creating APEX code artifactsCreating ODI code artifacts; Creating script artifacts; Building a continuous development capability for enhancements; Creating a constant feedback and communications loop; Chapter 5: The Blueprint; Introduction; Outlining your business processes; Categorizing your metrics, analysis, and reports within the business process; Decomposing your analysis and reports to define business entities; Developing your semantic data model; Identifying your source of record for your business entities; Building the blueprint; Chapter 6: Analyzing the Requirements; Introduction
Decomposing the reports and requirementsDefining the business rules; Categorizing the business requirements by business drivers; Prioritizing the business requirements; Adding hierarchies to your semantic data model; Adding metrics to your semantic data model; Defining your data dictionary; Defining your security requirements; Defining your data retention requirements; Chapter 7: Architecture and Design; Introduction; Choosing your database type; Defining your database layout; Selecting the Third Normal Form or a Dimensional model; Chapter 8: Analyzing the Sources; Introduction
Validating and enhancing a conceptual data modelCreating a business process matrix; Creating a report requirements matrix; Creating a source matrix; Developing the data lineage; Defining the detailed transformations; Chapter 9: Analyzing the Data; Introduction; Building high and low data profiling scripts; Building domain/distinct values profiling; Building record count profiling scripts; Building density data profiling scripts; Building hierarchy data profiling scripts; Building data lengths data profiling scripts; Building significant columns data profiling scripts
Building changing information data profiling scripts
Record Nr. UNINA-9910779354403321
Heaton John  
Birmingham, : Packt Pub., 2012
Materiale a stampa
Lo trovi qui: Univ. Federico II
Opac: Controlla la disponibilità qui
Business intelligence cookbook : a project lifecycle approach using Oracle technology : over 80 quick and advanced recipes that focus on real-world techniques and solutions to manage, design, and build data warehouse and business intelligence projects / / John Heaton
Business intelligence cookbook : a project lifecycle approach using Oracle technology : over 80 quick and advanced recipes that focus on real-world techniques and solutions to manage, design, and build data warehouse and business intelligence projects / / John Heaton
Autore Heaton John
Edizione [1st edition]
Pubbl/distr/stampa Birmingham, : Packt Pub., 2012
Descrizione fisica 1 online resource (368 p.)
Disciplina 005.7565
Collana Enterprise : professional expertise distilled
Soggetto topico Relational databases
Open source software
Database management
ISBN 9786613832115
9781283519663
1283519666
9781849685498
1849685495
Formato Materiale a stampa
Livello bibliografico Monografia
Lingua di pubblicazione eng
Nota di contenuto Cover; Copyright; Credits; About the Author; Acknowledgement; About the Reviewers; www.PacktPub.com; Table of Contents; Preface; Chapter 1: Defining a Program; Introduction; Program or a project; Mapping your business culture; Adapting your project delivery methodology; Assessing your project team; Organizing your project team; Chapter 2: Establishing the Project; Introduction; Creating Definition work practice; Creating Data Discovery work practice; Creating Development work practice; Creating Testing work practice; Creating Promote work practice; Creating Production work practice
Building a standard work breakdown structureIdentifying and quantifying the effort drivers; Creating your estimation tool; Chapter 3: Controlling the Project; Introduction; Requirements Traceability Matrix; Creating an effective risk register; Creating an effective issue management register; Creating a defect and enhancement register; Creating a cyclical build and test process; Setting up a collaborative environment; Installing client tools for a collaborative environment; Chapter 4: Wrapping Up the Project; Introduction; Creating OWB code artifacts; Creating OBIEE code artifacts
Creating APEX code artifactsCreating ODI code artifacts; Creating script artifacts; Building a continuous development capability for enhancements; Creating a constant feedback and communications loop; Chapter 5: The Blueprint; Introduction; Outlining your business processes; Categorizing your metrics, analysis, and reports within the business process; Decomposing your analysis and reports to define business entities; Developing your semantic data model; Identifying your source of record for your business entities; Building the blueprint; Chapter 6: Analyzing the Requirements; Introduction
Decomposing the reports and requirementsDefining the business rules; Categorizing the business requirements by business drivers; Prioritizing the business requirements; Adding hierarchies to your semantic data model; Adding metrics to your semantic data model; Defining your data dictionary; Defining your security requirements; Defining your data retention requirements; Chapter 7: Architecture and Design; Introduction; Choosing your database type; Defining your database layout; Selecting the Third Normal Form or a Dimensional model; Chapter 8: Analyzing the Sources; Introduction
Validating and enhancing a conceptual data modelCreating a business process matrix; Creating a report requirements matrix; Creating a source matrix; Developing the data lineage; Defining the detailed transformations; Chapter 9: Analyzing the Data; Introduction; Building high and low data profiling scripts; Building domain/distinct values profiling; Building record count profiling scripts; Building density data profiling scripts; Building hierarchy data profiling scripts; Building data lengths data profiling scripts; Building significant columns data profiling scripts
Building changing information data profiling scripts
Record Nr. UNINA-9910962951503321
Heaton John  
Birmingham, : Packt Pub., 2012
Materiale a stampa
Lo trovi qui: Univ. Federico II
Opac: Controlla la disponibilità qui