You are previewing Handbook of Research on Innovative Database Query Processing Techniques.
O'Reilly logo
Handbook of Research on Innovative Database Query Processing Techniques

Book Description

Research and development surrounding the use of data queries is receiving increased attention from computer scientists and data specialists alike. Through the use of query technology, large volumes of data in databases can be retrieved, and information systems built based on databases can support problem solving and decision making across industries. The Handbook of Research on Innovative Database Query Processing Techniques focuses on the growing topic of database query processing methods, technologies, and applications. Aimed at providing an all-inclusive reference source of technologies and practices in advanced database query systems, this book investigates various techniques, including database and XML queries, spatiotemporal data queries, big data queries, metadata queries, and applications of database query systems. This comprehensive handbook is a necessary resource for students, IT professionals, data analysts, and academicians interested in uncovering the latest methods for using queries as a means to extract information from databases. This all-inclusive handbook includes the latest research on topics pertaining to information retrieval, data extraction, data management, design and development of database queries, and database and XM queries.

Table of Contents

  1. Cover
  2. Title Page
  3. Copyright Page
  4. Book Series
    1. Mission
    2. Coverage
  5. Editorial Advisory Board and List of Reviewers
    1. Editorial Advisory Board
    2. List of Reviewers
  6. Preface
  7. Acknowledgment
  8. Section 1:
    1. Chapter 1: Top-k Relevant Term Suggestion Approach for Relational Keyword Search
      1. ABSTRACT
      2. 1. INTRODUCTION
      3. 2. RELATED WORK
      4. 3. PROBLEM DEFINITION AND SOLUTION
      5. 4. TERM COUPLING RELATIONSHIP ANALYSIS
      6. 5. TOP- SEMANTICALLY RELATED TERM SELECTION
      7. 6. EXPERIMENTS
      8. 7. CONCLUSION AND FURTHER WORK
      9. REFERENCES
      10. KEY TERMS AND DEFINITIONS
    2. Chapter 2: Set-Oriented Queries in SQL
      1. ABSTRACT
      2. 1. INTRODUCTION
      3. 2. MOTIVATION
      4. 3. EARLY PROPOSALS
      5. 4. GENERALIZED QUANTIFICATION
      6. 5. APPLICATION TO SQL
      7. 6. OPEN ISSUES AND FURTHER AREAS OF RESEARCH
      8. 7. CONCLUSION
      9. ACKNOWLEDGMENT
      10. REFERENCES
      11. KEY TERMS AND DEFINITIONS
      12. ENDNOTES
    3. Chapter 3: Evaluating Top-k Skyline Queries on R-Trees
      1. ABSTRACT
      2. INTRODUCTION
      3. BACKGROUND
      4. EVALUATING TOP-K SKYLINE QUERIES ON R-TREE
      5. EXPERIMENTAL STUDY
      6. FUTURE RESEARCH DIRECTIONS
      7. CONCLUSION
      8. REFERENCES
      9. ADDITIONAL READING
      10. KEY TERMS AND DEFINITIONS
    4. Chapter 4: Processing of Queries with Fuzzy Similarity Domains
      1. ABSTRACT
      2. INTRODUCTION
      3. BACKGROUND
      4. DATA DOMAINS WITH SIMILARITY RELATIONS
      5. SIMILARITY RELATIONSHIP BASES ORDERING
      6. ARCHITECTURE OF THE EXTENSION FOR A RDBMS
      7. FUTURE RESEARCH DIRECTIONS
      8. CONCLUSION
      9. ACKNOWLEDGMENT
      10. REFERENCES
      11. KEY TERMS AND DEFINITIONS
    5. Chapter 5: Modeling and Querying Fuzzy Data
      1. ABSTRACT
      2. INTRODUCTION
      3. PRELIMINARIES
      4. MODELING FUZZY DATA
      5. FUZZY QUERYING AND OPERATIONS
      6. SUMMARIES AND DISCUSSIONS
      7. ACKNOWLEDGMENT
      8. REFERENCES
      9. KEY TERMS AND DEFINITIONS
    6. Chapter 6: Fuzzy XQuery
      1. ABSTRACT
      2. INTRODUCTION
      3. BACKGROUND
      4. ARCHITECTURE AND ENVIRONMENT
      5. EXTENSION DEVELOPMENT
      6. PERFORMANCE ANALYSIS
      7. EXPERIMENTAL DESIGN
      8. RESULT ANALYSIS
      9. FUTURE RESEARCH DIRECTIONS
      10. CONCLUSION
      11. ACKNOWLEDGMENT
      12. REFERENCES
      13. KEY TERMS AND DEFINITIONS
      14. APPENDIX: FUZZY QUERIES USED IN EXPERIMENTS
    7. Chapter 7: Probabilistic Ranking Method of XML Fuzzy Query Results
      1. ABSTRACT
      2. INTRODUCTION
      3. BACKGROUND
      4. XML FUZZY QUERY MODEL
      5. ARCHITECTURE OF SYSTEM
      6. ATTRIBUTE WEIGHT ASSIGNMENT
      7. MEMBERSHIP DEGREE RANKING
      8. PROBABILISTIC RANKING
      9. TOP-K RANKING ALGORITHM OF FUZZY QUERY RESULTS
      10. EXPERIMENTS
      11. CONCLUSION
      12. REFERENCES
      13. KEY TERMS AND DEFINITIONS
  9. Section 2:
    1. Chapter 8: User Driven Query Framework of Social Networks for Geo-Temporal Analysis of Events of Interest
      1. ABSTRACT
      2. INTRODUCTION
      3. CONTEXT OF THE PROPOSAL: BACKGROUND AND FOREGROUND
      4. RELATED WORKS
      5. USER DRIVEN EXPLORATION OF EVENTS IN SOCIAL MEDIA
      6. MESSAGES COLLECTION AND REPRESENTATION
      7. USER QUERIES FORMULATION
      8. RETRIEVAL MECHANISM
      9. USER DRIVEN GEO-TEMPORAL ANALYSIS
      10. GEO-TEMPORAL DENSITY BASED CLUSTERING
      11. EXAMPLES OF EVENTS ANALYSIS
      12. CONCLUSION
      13. REFERENCES
      14. KEY TERMS AND DEFINITIONS
    2. Chapter 9: Complex Motion Pattern Queries in Spatio-Temporal Databases
      1. ABSTRACT
      2. INTRODUCTION
      3. BACKGROUND
      4. SOLUTIONS AND RECOMMENDATIONS
      5. EVALUATING COMPLEX PATTERN QUERIES
      6. FUTURE RESEARCH DIRECTIONS
      7. CONCLUSION
      8. REFERENCES
      9. KEY TERMS AND DEFINITIONS
    3. Chapter 10: Spatiotemporal Query Algebra Based on Native XML
      1. ABSTRACT
      2. INTRODUCTION
      3. SEMANTICS OF SPATIOTEMPORAL DATA
      4. CLASSIFICATIONS OF SPATIOTEMPORAL QUERY
      5. NATIVE XML DATA MANAGEMENT
      6. REPRESENTATION OF SPATIOTEMPORAL DATA IN XML
      7. NXD SPATIOTEMPORAL DATABASE SYSTEMS AND QUERY FRAMEWORK
      8. FORMAL REPRESENTATIONS OF SPATIOTEMPORAL QUERY ALGEBRA
      9. LOGICAL STRUCTURE OF SPATIOTEMPORAL DATABASE
      10. RELATED WORK
      11. CONCLUSION
      12. REFERENCES
      13. KEY TERMS AND DEFINITIONS
    4. Chapter 11: C2S
      1. ABSTRACT
      2. INTRODUCTION
      3. BACKGROUND
      4. SPATIAL SKYLINE QUERIES OVER CHANGING DATA
      5. NAIVE ALGORITHMS
      6. PROPOSED ALGORITHM
      7. EXPERIMENTAL STUDY
      8. FUTURE RESEARCH DIRECTIONS
      9. CONCLUSION
      10. REFERENCES
      11. ADDITIONAL READING
      12. KEY TERMS AND DEFINITIONS
    5. Chapter 12: Supporting Position Change through On-Line Location-Based Skyline Queries
      1. ABSTRACT
      2. INTRODUCTION
      3. BACKGROUND
      4. PROPOSED ALGORITHMS
      5. EXPERIMENTAL STUDY
      6. FUTURE RESEARCH DIRECTIONS
      7. CONCLUSION
      8. REFERENCES
      9. ADDITIONAL READING
      10. KEY TERMS AND DEFINITIONS
  10. Section 3:
    1. Chapter 13: Querying of Time Series for Big Data Analytics
      1. ABSTRACT
      2. INTRODUCTION
      3. TIME SERIES AS BIG DATA
      4. TIME SERIES REPRESENTATION
      5. DATA STRUCTURES
      6. DISTANCE FUNCTIONS
      7. QUERY TYPES AND QUERY LANGUAGES
      8. TIME SERIES MANAGEMENT SYSTEMS
      9. CONCLUSION
      10. REFERENCES
      11. KEY TERMS AND DEFINITIONS
      12. ENDNOTES
    2. Chapter 14: Parallel kNN Queries for Big Data Based on Voronoi Diagram Using MapReduce
      1. ABSTRACT
      2. INTRODUCTION
      3. BACKGROUND
      4. kNN QUERIES OF MULTI-DIMENSIONAL SPACE DATA
      5. PARTITIONED METHOD BASED ON VORONOI DIAGRAM
      6. INDEX THE VORONOI DIAGRAM USING R-TREE
      7. EXPERIMENTS
      8. CONCLUSION
      9. REFERENCES
      10. KEY TERMS AND DEFINITIONS
    3. Chapter 15: Query Languages in NoSQL Databases
      1. ABSTRACT
      2. INTRODUCTION
      3. BACKGROUND
      4. NOSQL QUERY LANGUAGES
      5. ANALYSIS OF QUERY AND RETRIEVAL DATA IN NOSQL DATABASES
      6. KEY-VALUE DATABASE MODEL
      7. COLUMN- FAMILY DATABASE MODEL
      8. DOCUMENT STORE DATABASE MODEL
      9. GRAPH DATABASE MODEL
      10. COMPARATIVE ANALYSIS OF NOSQL QUERY LANGUAGES
      11. SOLUTIONS AND RECOMMENDATIONS
      12. FUTURE RESEARCH DIRECTIONS
      13. CONCLUSION
      14. REFERENCES
      15. KEY TERMS AND DEFINITIONS
  11. Section 4:
    1. Chapter 16: Fuzzy Querying of RDF with Bipolar Preference Conditions
      1. ABSTRACT
      2. INTRODUCTION
      3. BIPOLAR INFORMATION AND PREFERENCE QUERY
      4. FUZZY QUERY WITH BIPOLAR PREFERENCES
      5. FUZZY SPARQL DESCRIPTION WITH BIPOLAR PREFERENCE CONDITIONS
      6. UNIVARIATE BIPOLAR PREFERENCE QUERY
      7. BIVARIATE BIPOLAR PREFERENCE QUERY
      8. SEQUENCING METHOD OF OPTIMIZATION RESULTS
      9. PERFORMANCE STUDIES
      10. MEASURES
      11. BIPOLAR PREFERENCE FUZZY QUERY VS. FP-SPARQL
      12. CONCLUSION
      13. ACKNOWLEDGMENT
      14. REFERENCES
      15. KEY TERMS AND DEFINITIONS
    2. Chapter 17: RDF Storage and Querying
      1. ABSTRACT
      2. INTRODUCTION
      3. PRELIMINARIES
      4. RELATIONAL RDF STORES
      5. NATIVE RDF STORES
      6. SPARQL EXTENSIONS
      7. CONCLUSION
      8. REFERENCES
      9. KEY TERMS AND DEFINITIONS
    3. Chapter 18: A Review of Answering Queries over Ontologies Based on Databases
      1. ABSTRACT
      2. INTRODUCTION
      3. BACKGROUND
      4. ANSWERING QUERIES OVER ONTOLOGIES BASED ON DATABASES
      5. FUTURE RESEARCH DIRECTIONS
      6. CONCLUSION
      7. ACKNOWLEDGMENT
      8. REFERENCES
      9. KEY TERMS AND DEFINITIONS
  12. Section 5:
    1. Chapter 19: Application of Fuzzy User's Profile for Mining Reusable E-Learning Repositories on Web through Lightweight Mobile Agent
      1. ABSTRACT
      2. INTRODUCTION
      3. FUZZY LOGIC AND AGENTS AS FACILITATORS
      4. WORK DONE SO FAR
      5. ARCHITECTURE OF THE SYSTEM
      6. LIGHTWEIGHT MOBILE AGENT
      7. CONCLUSION AND FUTURE ENHANCEMENT
      8. REFERENCES
      9. ADDITIONAL READING
      10. KEY TERMS AND DEFINITIONS
    2. Chapter 20: Adding Context into Classification Reasoning Based on Good Classification Tests
      1. ABSTRACT
      2. INTRODUCTION
      3. CLASSIFICATION REASONING AND SEARCHING FOR IMPLICATIVE AND FUNCTIONAL DEPENDENCIES
      4. CLASSIFICATION REASONING BASED ON GOOD CLASSIFICATION TESTS
      5. THE CONCEPT OF GOOD CLASSIFICATION TEST
      6. CONCLUSION
      7. REFERENCES
      8. KEY TERMS AND DEFINITIONS
    3. Chapter 21: Readable Diagrammatic Query Language ViziQuer
      1. ABSTRACT
      2. INTRODUCTION
      3. DESIGNED DIAGRAMMATIC QUERY LANGUAGE: VIZIQUER FULL
      4. IMPROVED DIAGRAMMATIC QUERY LANGUAGE: VIZIQUER LITE
      5. READABILITY ANALYSIS
      6. CONCLUSION
      7. ACKNOWLEDGMENT
      8. REFERENCES
      9. KEY TERMS AND DEFINITIONS
      10. ENDNOTES
  13. Compilation of References
  14. About the Contributors