Database technologies : concepts, methodologies, tools, and applications

The expanding possibilities and promising current and future potential that lies within the advancing field of database technologies encompasses many aspects of life as its beneficial features and innovative functions are seen impacting society at countless diverse angles. Database Technologies: Concepts, Methodologies, Tools, and Applications expands the field of database technologies through four-volumes of in-depth, advanced research articles from nearly 300 of the world's leading professionals. This breakthrough publication contains over 200 chapters of important concepts, methods, and functions of database technologies, covering topics such as conceptual modeling, data warehousing, and Web-based information systems. Database Technologies: Concepts, Methodologies, Tools, and Applications is a paramount contribution to the technology field and a must-have for libraries. Title......Page 2 Editors ......Page 4 List of Contributors......Page 6 Contents......Page 14 Preface......Page 33 Database Technologies: Concepts, Methods, Tools and Applications......Page 37 About the Editor......Page 52 Philosophical Foundations of Information Modeling......Page 54 A Generalized Comparison ofOpen Source and Commercial Database Management Systems......Page 66 Highly Available Database Management Systems......Page 81 Mining in Music Databases......Page 88 Pattern Mining and Clustering on Image Databases......Page 113 Conceptual Modeling Solutions for the Data Warehouse......Page 139 A Literature Overview of Fuzzy Database Modeling......Page 158 Fuzzy and Probabilistic Object-Oriented Databases......Page 179 An Overview of Fuzzy Approaches to Flexible Database Querying......Page 188 Distributed Data Mining......Page 210 Histogram-Based Compression of Databases and Data Cubes......Page 218 Emergence Index in Image Databases......Page 232 Secure Knowledge Discovery in Databases......Page 239 Indexing Textual Information......Page 249 Database in Computing Systems......Page 258 Database Integrity Checking......Page 265 A Survey on Temporal Data Warehousing......Page 274 Discovering Quality Knowledge from Relational Databases......Page 291 Approaches to Semantics in Knowledge Management......Page 310 Theories of Meaning in Schema Matching: A Review......Page 335 Multi-Label Classification: An Overview......Page 362 Electronic Usage Statistics......Page 373 Databases Modeling of Engineering Information......Page 391 An Overview of Learning Object Repositories......Page 415 An Overview of IDS Using Anomaly Detection......Page 437 Towards Google Earth:A History of Earth Geography......Page 448 Design of a Data Model for Social Network Applications......Page 467 Database Design Based on B......Page 493 A Database Service Discovery Model for Mobile Agents......Page 510 A Database Project in a Small Company (or How the Real World Doesn’t Always Follow the Book)......Page 521 Integrating Mobile-Based Systems with Healthcare Databases......Page 537 A Framework for Efficient Association Rule Mining in XML Data......Page 558 Conceptual Modeling for XML: A Myth or a Reality......Page 580 Semantic Integrity Constraint Checking for Multiple XML Databases......Page 603 Goal-Oriented Requirement Engineering for XML Document Warehouses......Page 623 Mediating RDF/S Queries to Relational and XML Sources......Page 649 A Methodology Supporting the Design and Evaluating the Final Quality of Data Warehouses......Page 668 An MDA Compliant Approach for Designing Secure Data Warehouses......Page 690 Architecture for Symbolic Object Warehouse......Page 701 Efficient and Robust Node-Partitioned Data Warehouses......Page 711 Web Data Warehousing Convergence: From Schematic to Systematic......Page 731 Data Warehouse Design to Support Customer Relationship Management Analyses......Page 755 Aspects of Intelligence in an “SP” Database System......Page 778 Intelligent Search for Experts Using Fuzzy Abstraction Hierarchy in Knowledge Management Systems......Page 808 Building an Environmental GIS Knowledge Infrastructure......Page 831 Bug Fixing Practices within Free/Libre Open Source Software Development Teams......Page 850 OLAP with a Database Cluster......Page 882 Extraction, Transformation, and Loading Processes......Page 900 Designing Information Systems Capabilities to Create Business Value: A Theoretical Conceptualization of the Role of Flexibility and Integration......Page 919 Open Source Database Technologies......Page 940 Action Research with Internet Database Tools......Page 947 A Scalable Middleware for Web Databases......Page 956 Full-Text Search Engines for Databases......Page 984 Application of Decision Tree asa Data Mining Tool in a Manufacturing System......Page 993 Alliance Project: Digital Kinship Database and Genealogy......Page 1009 Constraint-Based Multi-Dimensional Databases......Page 1014 Toward a Visual Query System for Spatio-Temporal Databases......Page 1040 Visual Query Languages, Representation Techniques, and Data Models......Page 1056 A Formal Verification and Validation Approach for Real-Time Databases......Page 1073 Protoforms of Linguistic Database Summaries as a Human Consistent Tool for Using Natural Language in Data Mining......Page 1091 Rapid Privacy Preserving Algorithm for Large Databases......Page 1103 A Content-Based Approach to Medical Image Database Retrieval......Page 1115 High Speed Optical Higher Order Neural Networks for Discovering Data Trendsand Patterns in Very Large Databases......Page 1137 Mobile Information Processing Involving Multiple Non-Collaborative Sources......Page 1161 Rough Sets:A Versatile Theory for Approaches to Uncertainty Management in Databases......Page 1180 VRMiner:A Tool for Multimedia Database Mining with Virtual Reality......Page 1204 UB2SQL:A Tool for Building Database Applications Using UML andB Formal Method......Page 1221 MMIR:An Advanced Content-Based Image Retrieval System Using a Hierarchical Learning Framework......Page 1242 MILPRIT*:A Constraint-Based Algorithm for Mining Temporal Relational Patterns......Page 1258 Database Benchmarks......Page 1279 A Taxonomy of Database Operations on Mobile Devices......Page 1288 Transaction Management in Mobile Databases......Page 1310 Bioinformatics Web Portals......Page 1320 Large-Scale ASP Replication of Database-Driven Portals......Page 1329 A Case Study of an Integrated University Portal......Page 1338 Electronic Tools for Online Assessments: An Illustrative Case Study from Teacher Education......Page 1344 Assessment of Students by a Teacher with a Handheld Deviceand a Networkable Database......Page 1362 An XML-Based Database for Knowledge Discovery: Definition and Implementation......Page 1373 A Prehospital Database System for Emergency Medical Services......Page 1397 A Preliminary Study Toward Wireless Integration of Patient Information System......Page 1410 A Web-Based Application to Exchange Electronic Health Records and Medical Images in Ophthalmology......Page 1425 Implementation of a Computerized System in an Oncology Unit......Page 1438 Challenges in Data Mining on Medical Databases......Page 1446 Beyond OpenURL:Technologies for Linking Library Resources......Page 1458 Databases for Multiple Archaeological Excavationsand Internet Applications......Page 1473 Collaborative Information Management System for Science Domains......Page 1499 Computer Networking of Cybercafés in Delta State, Nigeria......Page 1507 Ara Irititja: Towards Culturally Appropriate IT Best Practice in Remote Indigenous Australia......Page 1515 Agreements Treaties and Negotiated Settlements Database......Page 1525 From ‘Flow’ to ‘Database’:A Comparative Study of the Uses of Traditional and Internet Television in Estonia......Page 1530 Innovative Technological Paradigms for Corporate Offshoring......Page 1543 Out of Control? The Real ID Act of 2005......Page 1564 Factors Influencing the Lifetime of Telecommunication and Information Technology Standards: Results of an Explorative Analysis of the PERINORM Database......Page 1582 Image Mining: A Case for Clustering Shoe Prints......Page 1605 A Data Visualization and Interpretation System for Sensor Networks......Page 1621 Enhancing UML Models:A Domain Analysis Approach......Page 1634 A Knowledge Integration Approach for Organizational Decision Support......Page 1657 The Knowledge Transfer Process: From Field Studies toTechnology Development......Page 1675 The Critical Role of Information Processing in Creating an Effective Knowledge Organization......Page 1691 Interesting Knowledge Patterns in Databases......Page 1705 Fine-Grained Data Security in Virtual Organizations......Page 1716 Knowledge Communication with Shared Databases......Page 1723 Economic Development: Government’s Cutting Edge in IT......Page 1735 A Comprehensive Framework Towards Information Sharing Between Government Agencies......Page 1776 A GIS-Based Interactive Database System for Planning Purposes......Page 1794 Categorizing Post-Deployment IT Changes: An Empirical Investigation......Page 1809 Customer Relationship Management and Knowledge Discovery in Database......Page 1831 Customer Investigation Processat Credit Suisse: Meeting the Rising Demands of Regulators......Page 1840 Metaphors and Models for Data Mining Ethics......Page 1861 Reconciling Information Privacy and Information Access in a Globalized Technology Society......Page 1876 Context-Aware Query Processing in Ad-Hoc Environments of Peers......Page 1897 Misuse of Online Databases for Literature Searches......Page 1920 Conflicts, Compromises,and Political Decisions: Methodological Challenges of Enterprise-Wide E-Business Architecture Creation......Page 1929 Database High Availability: An Extended Survey......Page 1952 Database Integration in the Grid Infrastructure......Page 1981 Empirical Assessment of Factors Influencing Success of Enterprise Resource Planning Implementations......Page 1989 Business Information Integration from XML and Relational Databases Sources......Page 2012 A Parallel Methodology for Reduction of Coupling in Distributed Business-to-Business E-Commerce Transactions......Page 2037 A Two-Stage Zone Regression Method for Global Characterization of a Project Database......Page 2053 NetCube: Fast, Approximate Database Queries Using Bayesian Networks......Page 2064 Approximate Range Querying over Sliding Windows......Page 2090 Consistent Queries over Databases with Integrity Constraints......Page 2104 A Deterministic Approach to XML Query Processing with Efficient Support for Pure and Negated Containments......Page 2112 Countermeasures for Protecting Legally Sensitive Web-Powered Databases and Web Portals......Page 2132 Compiling Medical Data into National Medical Databases: Legitimate Practice or Data Protection Concern?......Page 2138 Database Security and Statistical Database Security......Page 2153 Security Threats in Web-Powered Databases and Web Portals......Page 2162 SQL Code Poisoning:The Most Prevalent Technique for Attacking Web Powered Databases......Page 2171 Sanitization and Anonymization of Document Repositories......Page 2182 Information Quality: How Good are Off-the-Shelf DBMS?......Page 2193 Handling Fuzzy Similarity for Data Classification......Page 2210 Fabric Database and Fuzzy Logic Models for Evaluating Fabric Performance......Page 2219 Mining for Mutually Exclusive Items in Transaction Databases......Page 2245 Ensuring Correctness, Completeness, and Freshness for Outsourced Tree-Indexed Data......Page 2257 A Multiple-Bits Watermark for Relational Data......Page 2276 A Machine Learning Approach to Data Cleaning in Databases and Data Warehouses......Page 2298 A Roadmap on Updates......Page 2314 Association Rule Hiding Methods......Page 2321 Managing Uncertainties in Image Databases......Page 2328 Bitmap Join Indexes vs.Data Partitioning......Page 2345 Integrating Projects from Multiple Open Source Code Forges......Page 2354 Extended Action Rule Discovery Based on Single Classification Rules and Reducts......Page 2366 Optimization of Multidimensional Aggregates in Data Warehouses......Page 2377 Improving Storage Conceptsfor Semantic Models and Ontologies......Page 2401 From Databases to Ontologies......Page 2413 A Measurement Ontology Generalizable for Emerging Domain Applications on the Semantic Web......Page 2437 Enhancing the Process of Knowledge Discovery in Geographic Databases Using Geo-Ontologies......Page 2458 A Distributed Algorithm for Mining Fuzzy Association Rules in Traditional Databases......Page 2480 Looking for Information in Fuzzy Relational Databases Accessible Via Web......Page 2501 Integrating Heterogeneous Data Sources in the Web......Page 2525 Reverse Engineering from an XML Document into an Extended DTD Graph......Page 2542 Evaluating XML-Extended OLAP Queries Based on a Physical Algebra......Page 2563 Vertical Fragmentation in Databases Using Data-Mining Technique......Page 2596 Control-Based Database Tuning Under Dynamic Workloads......Page 2617 Adoption, Improvement and Disruption: Predicting the Impact of Open Source Applications in Enterprise Software Markets......Page 2625 3-D Virtual Worlds in Education: Applications, Benefits, Issues, and Opportunities......Page 2648 Legal Protection of the WebPage as a Database......Page 2669 Deterministic Motif Mining in Protein Databases......Page 2685 Mining Allocating Patterns in Investment Portfolios......Page 2710 Introducing Elasticity for SpatialKnowledge Management......Page 2738 Index......Page 2760 Get a detailed look at the internal architecture of T-SQL with this comprehensive programming reference. Database developers and administrators get best practices, expert techniques, and code samples to master the intricacies of this programming language—solving complex problems with real-world solutions. Discover how to: * Work with T-SQL and CLR user-defined functions, stored procedures, and triggers. * Handle transactions, concurrency, and error handling. * Efficiently use temporary objects, including temporary tables, table variables, and table expressions. * Evaluate when to use set-based programming techniques and when to use cursors. * Work with dynamic SQL in an efficient and secure manner. * Treat date- and time-related data in a robust manner. * Develop CLR user-defined types and learn about temporal support in the relational model. * Use XML and XQuery and implement a dynamic schema solution. * Work with spatial data using the new geometry and geography types and spatial indexes. * Track access and changes to data using extended events, SQL Server Audit, change tracking, and change data capture. * Use Service Broker for controlled asynchronous processing in database applications. Скриншоты