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. | ||
| Lo trovi qui: Univ. del Salento | ||
| ||
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] | ||
| Lo trovi qui: Univ. di Salerno | ||
| ||
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] | ||
| Lo trovi qui: Univ. di Salerno | ||
| ||
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 | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
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 | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
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 | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
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 | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
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 | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
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 | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
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 | ||
| Lo trovi qui: Univ. Federico II | ||
| ||