Advanced query processing . Volume 1 Issues and trends / / Barbara Catania and Lakhmi C. Jain (eds.)
| Advanced query processing . Volume 1 Issues and trends / / Barbara Catania and Lakhmi C. Jain (eds.) |
| Edizione | [1st ed.] |
| Pubbl/distr/stampa | Berlin ; ; New York, : Springer, 2012, c2013 |
| Descrizione fisica | 1 online resource (354 p.) |
| Disciplina | 005.74 |
| Altri autori (Persone) |
CataniaBarbara
JainL. C |
| Collana | Intelligent systems reference library |
| Soggetto topico |
Querying (Computer science)
Database management |
| ISBN |
9783642283239
3642283233 |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Nota di contenuto | From the content: Advanced Query Processing: An Introduction -- On Skyline Queries and how to Choose from Pareto Sets -- Processing Framework for Ranking and Skyline Queries -- Preference-Based Query Personalization -- Approximate Queries for Spatial Data -- Approximate XML Query Processing -- Progressive and Approximate Join Algorithms on Data Streams. |
| Record Nr. | UNINA-9910438057603321 |
| Berlin ; ; New York, : Springer, 2012, c2013 | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
Beginning jOOQ : learn to write efficient and effective Java-based SQL database operations / / Tayo Koleoso
| Beginning jOOQ : learn to write efficient and effective Java-based SQL database operations / / Tayo Koleoso |
| Autore | Koleoso Tayo |
| Pubbl/distr/stampa | New York, New York : , : Apress, , [2022] |
| Descrizione fisica | 1 online resource (221 pages) |
| Disciplina | 005.75 |
| Soggetto topico |
Object-oriented databases
Querying (Computer science) Java (Computer program language) |
| ISBN | 1-4842-7431-8 |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Nota di contenuto |
Intro -- Table of Contents -- About the Author -- About the Technical Reviewer -- Chapter 1: Welcome to jOOQ -- Database Operations in Java: The Good Parts -- Database Operations in Java: The…Not So Good Parts -- You Have Got to Be jOOQing -- jOOQ Feature Tour -- Database Aware -- Code Generation -- Type Safety -- Domain-Specific Language -- Tooling Support -- JVM Languages -- Chapter 2: Getting Started with jOOQ -- Eden Auto Mart -- Setting Up jOOQ -- Install Dependencies for Commercial-Licensed jOOQ -- CRUD with jOOQ -- Your SQL Dialect and You -- Tools of CRUD in jOOQ -- Select Statements -- The SELECT DSL -- With the WHERE DSL -- Conditions -- Subqueries -- Conditional Logic in Queries -- With the… WITH Clause -- With the GROUP BY DSL -- With the HAVING DSL -- With the ORDER BY DSL -- ORDER BY CASE -- ORDER BY NULL -- Paginate Query Results -- Insert Statements -- With Multiple Rows -- With Sequences -- With Select -- Update Statements -- Delete Statements -- Tuple Syntax -- Alternative Data Access Modes -- Streaming Access -- Lazy Access -- Transactions -- With Locking -- Configuration -- Connection Management -- Schema, Catalog, and Multi-tenant Deployment -- Query Management -- Query Lifecycle Integration -- Chapter 3: Working with jOOQ -- Generating Code -- Tools of jOOQ Code Generation -- Configure jOOQ for Code Generation -- Generate Code with Maven -- Generate Code from the Command Line -- Generate Code Programmatically -- Results of Code Generation -- Tables -- Global Artifacts -- Add Custom Code to Generated Code -- Working with Generated Code -- CRUD with Generated Code -- Enhancements from UpdatableRecord -- Formatting -- Optimistic Locking -- Advanced Database Operations -- Joins -- Non-SQL Grouping -- Batch Operations -- Explicit Batching -- Batch Import -- Advanced Query Syntax -- Merge and Upsert -- Window Functions.
Chapter 4: Integrating with jOOQ -- Java Persistence API with jOOQ -- Generate JPA Entities -- Generate from JPA Entities -- Generate SQL Queries -- Spring Boot and jOOQ -- Configure jOOQ in Spring Boot -- With Custom SQL -- jOOQ Spring Boot Starter -- Quarkus and jOOQ -- Chapter 5: Packaging and Testing jOOQ -- Package Code with jOOQ -- When You Don't Need Code Generation -- When You Don't Have an Active Database Connection -- When Your Schema Needs to Incrementally Evolve -- Recipe for a Self-Sufficient Database Project -- Testing with jOOQ -- Tools of the (SQL) Testing Trade -- Unit Testing with jOOQ -- Using Mockito -- With SQL Parsing -- Integration Testing with Docker and TestContainers -- With Spring Boot -- Index. |
| Record Nr. | UNINA-9910522956803321 |
Koleoso Tayo
|
||
| New York, New York : , : Apress, , [2022] | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
Bio-inspired computing for information retrieval applications / / D. P. Acharjya and Anirban Mitra
| Bio-inspired computing for information retrieval applications / / D. P. Acharjya and Anirban Mitra |
| Autore | Acharjya D. P. |
| Pubbl/distr/stampa | Hershey, Pennsylvania : , : IGI Global, , 2017 |
| Descrizione fisica | 1 online resource (411 pages) |
| Disciplina | 005.74 |
| Collana | Advances in Knowledge Acquisition, Transfer, and Management (AKATM) Book Series |
| Soggetto topico |
Natural computation
Information storage and retrieval systems Querying (Computer science) Database searching |
| Soggetto genere / forma | Electronic books. |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Record Nr. | UNINA-9910164874403321 |
Acharjya D. P.
|
||
| Hershey, Pennsylvania : , : IGI Global, , 2017 | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
Computer search algorithms [[electronic resource] /] / Elisabeth C. Salander, editor
| Computer search algorithms [[electronic resource] /] / Elisabeth C. Salander, editor |
| Pubbl/distr/stampa | Hauppauge, N.Y., : Nova Science Publishers, c2011 |
| Descrizione fisica | 1 online resource (207 p.) |
| Disciplina | 005.74/1 |
| Altri autori (Persone) | SalanderElisabeth C |
| Collana | Computer Science, Technology and Applications |
| Soggetto topico |
Computer algorithms
Querying (Computer science) Database searching |
| Soggetto genere / forma | Electronic books. |
| ISBN | 1-61209-043-5 |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Record Nr. | UNINA-9910452423603321 |
| Hauppauge, N.Y., : Nova Science Publishers, c2011 | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
Computer search algorithms [[electronic resource] /] / Elisabeth C. Salander, editor
| Computer search algorithms [[electronic resource] /] / Elisabeth C. Salander, editor |
| Pubbl/distr/stampa | Hauppauge, N.Y., : Nova Science Publishers, c2011 |
| Descrizione fisica | 1 online resource (207 p.) |
| Disciplina | 005.74/1 |
| Altri autori (Persone) | SalanderElisabeth C |
| Collana | Computer Science, Technology and Applications |
| Soggetto topico |
Computer algorithms
Querying (Computer science) Database searching |
| ISBN | 1-61209-043-5 |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Record Nr. | UNINA-9910779634903321 |
| Hauppauge, N.Y., : Nova Science Publishers, c2011 | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
Data analysis using SQL and Excel / / Gordon S. Linoff
| Data analysis using SQL and Excel / / Gordon S. Linoff |
| Autore | Linoff Gordon S. |
| Edizione | [Second edition.] |
| Pubbl/distr/stampa | Indianapolis, Indiana : , : Wiley, , 2016 |
| Descrizione fisica | 1 online resource (795 p.) |
| Disciplina | 005.756 |
| Collana | THEi Wiley ebooks |
| Soggetto topico |
SQL (Computer program language)
Querying (Computer science) Data mining |
| ISBN |
1-119-02144-8
1-119-18341-3 1-119-02145-6 |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Nota di contenuto |
Data Analysis Using SQL and Excel®; About the Author; Credits; Acknowledgments; Contents at a Glance; Contents; Foreword; Introduction; Chapter 1 A Data Miner Looks at SQL; Databases, SQL, and Big Data; What Is Big Data?; Relational Databases; Hadoop and Hive; NoSQL and Other Types of Databases; SQL; Picturing the Structure of the Data; What Is a Data Model?; What Is a Table?; Allowing NULL Values; Column Types; What Is an Entity-Relationship Diagram?; The Zip Code Tables; Subscription Dataset; Purchases Dataset; Tips on Naming Things; Picturing Data Analysis Using Dataflows
What Is a Dataflow? READ: Reading a Database Table; OUTPUT: Outputting a Table (or Chart); SELECT: Selecting Various Columns in the Table; FILTER: Filtering Rows Based on a Condition; APPEND: Appending New Calculated Columns; UNION: Combining Multiple Datasets into One; AGGREGATE: Aggregating Values; LOOKUP: Looking Up Values in One Table in Another; CROSS JOIN: Generating the Cartesian Product of Two Tables; JOIN: Combining Two Tables Using a Key Column; SORT: Ordering the Results of a Dataset; Dataflows, SQL, and Relational Algebra; SQL Queries; What to Do, Not How to Do It The SELECT Statement A Basic SQL Query; A Basic Summary SQL Query; What It Means to Join Tables; Cross-Joins: The Most General Joins; Lookup: A Useful Join; Equijoins; Nonequijoins; Outer Joins; Other Important Capabilities in SQL; UNION ALL; CASE; IN; Window Functions; Subqueries and Common Table Expressions Are Our Friends; Subqueries for Naming Variables; Subqueries for Handling Summaries; Subqueries and IN; Rewriting the "IN" as a JOIN; Correlated Subqueries; NOT IN Operator; EXISTS and NOT EXISTS Operators; Subqueries for UNION ALL; Lessons Learned Chapter 2 What's in a Table? Getting Started with Data Exploration What Is Data Exploration?; Excel for Charting; A Basic Chart: Column Charts; Inserting the Data; Creating the Column Chart; Formatting the Column Chart; Bar Charts in Cells; Character-Based Bar Charts; Conditional Formatting-Based Bar Charts; Useful Variations on the Column Chart; A New Query; Side-by-Side Columns; Stacked Columns; Stacked and Normalized Columns; Number of Orders and Revenue; Other Types of Charts; Line Charts; Area Charts; X-Y Charts (Scatter Plots); Sparklines; What Values Are in the Columns?; Histograms Histograms of Counts Cumulative Histograms of Counts; Histograms (Frequencies) for Numeric Values; Ranges Based on the Number of Digits, Using Numeric Techniques; Ranges Based on the Number of Digits, Using String Techniques; More Refined Ranges: First Digit Plus Number of Digits; Breaking Numeric Values into Equal-Sized Groups; More Values to Explore-Min, Max, and Mode; Minimum and Maximum Values; The Most Common Value (Mode); Calculating Mode Using Basic SQL; Calculating Mode Using Window Functions; Exploring String Values; Histogram of Length; Strings Starting or Ending with Spaces Handling Upper- and Lowercase |
| Record Nr. | UNINA-9910137177903321 |
Linoff Gordon S.
|
||
| Indianapolis, Indiana : , : Wiley, , 2016 | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
Data analysis using SQL and Excel / / Gordon S. Linoff
| Data analysis using SQL and Excel / / Gordon S. Linoff |
| Autore | Linoff Gordon S. |
| Edizione | [Second edition.] |
| Pubbl/distr/stampa | Indianapolis, Indiana : , : Wiley, , 2016 |
| Descrizione fisica | 1 online resource (795 p.) |
| Disciplina | 005.756 |
| Collana | THEi Wiley ebooks |
| Soggetto topico |
SQL (Computer program language)
Querying (Computer science) Data mining |
| ISBN |
1-119-02144-8
1-119-18341-3 1-119-02145-6 |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Nota di contenuto |
Data Analysis Using SQL and Excel®; About the Author; Credits; Acknowledgments; Contents at a Glance; Contents; Foreword; Introduction; Chapter 1 A Data Miner Looks at SQL; Databases, SQL, and Big Data; What Is Big Data?; Relational Databases; Hadoop and Hive; NoSQL and Other Types of Databases; SQL; Picturing the Structure of the Data; What Is a Data Model?; What Is a Table?; Allowing NULL Values; Column Types; What Is an Entity-Relationship Diagram?; The Zip Code Tables; Subscription Dataset; Purchases Dataset; Tips on Naming Things; Picturing Data Analysis Using Dataflows
What Is a Dataflow? READ: Reading a Database Table; OUTPUT: Outputting a Table (or Chart); SELECT: Selecting Various Columns in the Table; FILTER: Filtering Rows Based on a Condition; APPEND: Appending New Calculated Columns; UNION: Combining Multiple Datasets into One; AGGREGATE: Aggregating Values; LOOKUP: Looking Up Values in One Table in Another; CROSS JOIN: Generating the Cartesian Product of Two Tables; JOIN: Combining Two Tables Using a Key Column; SORT: Ordering the Results of a Dataset; Dataflows, SQL, and Relational Algebra; SQL Queries; What to Do, Not How to Do It The SELECT Statement A Basic SQL Query; A Basic Summary SQL Query; What It Means to Join Tables; Cross-Joins: The Most General Joins; Lookup: A Useful Join; Equijoins; Nonequijoins; Outer Joins; Other Important Capabilities in SQL; UNION ALL; CASE; IN; Window Functions; Subqueries and Common Table Expressions Are Our Friends; Subqueries for Naming Variables; Subqueries for Handling Summaries; Subqueries and IN; Rewriting the "IN" as a JOIN; Correlated Subqueries; NOT IN Operator; EXISTS and NOT EXISTS Operators; Subqueries for UNION ALL; Lessons Learned Chapter 2 What's in a Table? Getting Started with Data Exploration What Is Data Exploration?; Excel for Charting; A Basic Chart: Column Charts; Inserting the Data; Creating the Column Chart; Formatting the Column Chart; Bar Charts in Cells; Character-Based Bar Charts; Conditional Formatting-Based Bar Charts; Useful Variations on the Column Chart; A New Query; Side-by-Side Columns; Stacked Columns; Stacked and Normalized Columns; Number of Orders and Revenue; Other Types of Charts; Line Charts; Area Charts; X-Y Charts (Scatter Plots); Sparklines; What Values Are in the Columns?; Histograms Histograms of Counts Cumulative Histograms of Counts; Histograms (Frequencies) for Numeric Values; Ranges Based on the Number of Digits, Using Numeric Techniques; Ranges Based on the Number of Digits, Using String Techniques; More Refined Ranges: First Digit Plus Number of Digits; Breaking Numeric Values into Equal-Sized Groups; More Values to Explore-Min, Max, and Mode; Minimum and Maximum Values; The Most Common Value (Mode); Calculating Mode Using Basic SQL; Calculating Mode Using Window Functions; Exploring String Values; Histogram of Length; Strings Starting or Ending with Spaces Handling Upper- and Lowercase |
| Record Nr. | UNINA-9910808119903321 |
Linoff Gordon S.
|
||
| Indianapolis, Indiana : , : Wiley, , 2016 | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
Elasticsearch : a complete guide : end-to-end search analytics : a course in three modules / / Bharvi Dixit [and three others]
| Elasticsearch : a complete guide : end-to-end search analytics : a course in three modules / / Bharvi Dixit [and three others] |
| Autore | Dixit Bharvi |
| Edizione | [1st edition] |
| Pubbl/distr/stampa | Birmingham : , : Packt, , 2017 |
| Descrizione fisica | 1 online resource (801 pages) : illustrations |
| Soggetto topico |
Search engines - Programming
Application software - Development Querying (Computer science) |
| ISBN | 1-78728-739-4 |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Record Nr. | UNINA-9910162761503321 |
Dixit Bharvi
|
||
| Birmingham : , : Packt, , 2017 | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
An introduction to XML query processing and keyword search / / Jiaheng Lu
| An introduction to XML query processing and keyword search / / Jiaheng Lu |
| Autore | Lu Jiaheng |
| Edizione | [1st ed. 2013.] |
| Pubbl/distr/stampa | Heidelberg, Germany : , : Springer, , 2013 |
| Descrizione fisica | 1 online resource (xii, 291 pages) : illustrations (some color) |
| Disciplina |
004
005.7 005.74 025.04 |
| Collana | Gale eBooks |
| Soggetto topico |
XML (Document markup language)
Querying (Computer science) Keyword searching |
| ISBN | 3-642-34555-7 |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Nota di contenuto | Introduction -- XML labeling scheme -- XML data indexing -- XML tree pattern processing -- Ordered and Generalized XML Tree Pattern Processing -- Effective XML Keyword Search -- XML Keyword Pattern Refinement -- LCRA: XML Keyword Search System and Lotusx: Graphical Query Processing System -- Summary and The Road Ahead. |
| Record Nr. | UNINA-9910437587103321 |
Lu Jiaheng
|
||
| Heidelberg, Germany : , : Springer, , 2013 | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
Managing time in relational databases [[electronic resource] ] : how to design, update and query temporal data / / Tom Johnston, Randall Weis
| Managing time in relational databases [[electronic resource] ] : how to design, update and query temporal data / / Tom Johnston, Randall Weis |
| Autore | Johnston Tom |
| Edizione | [1st edition] |
| Pubbl/distr/stampa | Amsterdam ; ; Boston, : Morgan Kaufmann/Elsevier, c2010 |
| Descrizione fisica | 1 online resource (502 p.) |
| Disciplina |
005.753
005.756 |
| Altri autori (Persone) | WeisRandall |
| Soggetto topico |
Temporal databases
Relational databases Database management Querying (Computer science) |
| ISBN |
1-282-69983-0
9786612699832 0-08-096337-4 |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Nota di contenuto | pt. 1. An introduction to temporal data management -- pt. 2. An introduction to asserted versioning -- pt. 3. Designing, maintaining and querying asserted version databases. |
| Record Nr. | UNINA-9910781166703321 |
Johnston Tom
|
||
| Amsterdam ; ; Boston, : Morgan Kaufmann/Elsevier, c2010 | ||
| Lo trovi qui: Univ. Federico II | ||
| ||