The SIRUP approach to personal semantic data integration:
Saved in:
| Main Author: | |
|---|---|
| Format: | Thesis Book |
| Language: | English |
| Published: |
2007
|
| Subjects: | |
| Online Access: | Inhaltsverzeichnis |
| Physical Description: | XXVI, 466 S. Ill., graph. Darst. |
Staff View
MARC
| LEADER | 00000nam a2200000 c 4500 | ||
|---|---|---|---|
| 001 | BV023170665 | ||
| 003 | DE-604 | ||
| 005 | 20080826 | ||
| 007 | t | ||
| 008 | 080218s2007 ad|| m||| 00||| eng d | ||
| 035 | |a (OCoLC)254551678 | ||
| 035 | |a (DE-599)HBZHT015431684 | ||
| 040 | |a DE-604 |b ger |e rakwb | ||
| 041 | 0 | |a eng | |
| 049 | |a DE-355 |a DE-19 |a DE-384 |a DE-188 | ||
| 084 | |a ST 270 |0 (DE-625)143638: |2 rvk | ||
| 100 | 1 | |a Ziegler, Patrick |e Verfasser |4 aut | |
| 245 | 1 | 0 | |a The SIRUP approach to personal semantic data integration |c by Patrick Ziegler |
| 264 | 1 | |c 2007 | |
| 300 | |a XXVI, 466 S. |b Ill., graph. Darst. | ||
| 336 | |b txt |2 rdacontent | ||
| 337 | |b n |2 rdamedia | ||
| 338 | |b nc |2 rdacarrier | ||
| 502 | |a Zürich, Univ., Diss., 2007 | ||
| 650 | 0 | 7 | |a Datenintegration |0 (DE-588)4197730-0 |2 gnd |9 rswk-swf |
| 655 | 7 | |0 (DE-588)4113937-9 |a Hochschulschrift |2 gnd-content | |
| 689 | 0 | 0 | |a Datenintegration |0 (DE-588)4197730-0 |D s |
| 689 | 0 | |5 DE-604 | |
| 856 | 4 | 2 | |m SWB Datenaustausch |q application/pdf |u http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=016357341&sequence=000001&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA |3 Inhaltsverzeichnis |
| 999 | |a oai:aleph.bib-bvb.de:BVB01-016357341 | ||
Record in the Search Index
| _version_ | 1804137432652709888 |
|---|---|
| adam_text | TABLE OF CONTENTS INTRODUCTION 1 1.1 FOUNDATIONS AND MOTIVATION 1 1.2
OBJECTIVES AND ASSUMPTIONS 9 1.3 MAIN CONTRIBUTIONS 10 1.4 ORGANIZATION
OF THE THESIS 12 DATA INTEGRATION: FUNDAMENTALS AND APPROACHES 13 2.1
FUNDAMENTAL ISSUES IN DATA INTEGRATION 13 2.1.1 DISTRIBUTION 14 2.1.2
AUTONOMY 14 2.1.3 HETEROGENEITY 15 2.1.3.1 CLASSIFICATION OF INTEGRATION
CONFLICTS 16 2.1.4 TRANSPARENCY 20 2.2 ARCHITECTURES AND SYSTEMS 21
2.2.1 ARCHITECTURAL ARCHETYPES 21 2.2.1.1 DISTRIBUTED DATABASE SYSTEMS
21 2.2.1.2 MULTIDATABASE SYSTEMS 22 2.2.1.3 FEDERATED DATABASE SYSTEMS
23 2.2.1.4 MEDIATOR SYSTEMS 24 2.2.1.5 DATA WAREHOUSE SYSTEMS 25 2.2.1.6
PEER DATA MANAGEMENT SYSTEMS 25 2.2.2 GENERAL CONSIDERATIONS IN BUILDING
INTEGRATED INFORMATION SYSTEMS 26 2.2.3 CLASSIFICATION OF INTEGRATION
APPROACHES 29 2.3 TECHNIQUES FOR DATA INTEGRATION 32 2.3.1 SCHEMA AND
METADATA MANAGEMENT 33 2.3.1.1 SCHEMA INTEGRATION 33 2.3.1.2 SCHEMA
MAPPING 36 2.3.1.3 SCHEMA MATCHING 37 2.3.1.4 MULTIDATABASE LANGUAGES 40
2.3.1.5 MODEL MANAGEMENT 41 2.3.2 QUERY PROCESSING 42 2.3.2.1 SHORT
INTRODUCTION TO DATALOG 45 2.3.2.2 QUERY PLANNING 48 2.3.2.3 QUERY
OPTIMIZATION 53 2.3.2.4 INCORPORATING LIMITED SOURCES THROUGH WRAPPERS
54 2.3.3 SEMANTIC INTEGRATION 54 2.3.4 RECORD-LEVEL INTEGRATION 59 XI
XII TABLE OF CONTENTS 2.3.4.1 COMPLETENESS 60 2.3.4.2 DATA ERRORS 60
2.3.4.3 DATA CLEANSING 61 2.3.4.4 DETECTION OF DUPLICATES 62 2.3.4.5
RECORD MERGING 63 2.3.4.6 DATA QUALITY 67 2.3.4.7 DATA PROVENANCE 68 2.4
LIMITATIONS OF CURRENT APPROACHES AND CONSEQUENCES 69 2.4.1 PERSPECTUAL
INTEGRATION MISTAKES . 69 2.4.2 THE ASME CRITERIA 73 3 AN ONTOLOGY
INFRASTRUCTURE FOR SIRUP 77 3.1 THE SIRUP ONTOLOGY QUERY API 77 3.1.1
THE SOQA ONTOLOGY META MODEL 78 3.1.2 SOFTWARE ARCHITECTURE OF SOQA , .
. . . 80 3.2 THE SOQA QUERY LANGUAGE 82 3.3 THE SOQA BROWSER 85 3.4 THE
SOQA-SIMPACK TOOLKIT 86 3.4.1 SOFTWARE ARCHITECTURE OF SST 88 3.4.2 SST
EXEMPLIFIED 90 3.5 THE SST BROWSER 91 4 THE SIRUP APPROACH 93 4.1
FUNDAMENTAL PRINCIPLES IN SIRUP 93 4.2 AN OVERVIEW OF SIRUP 95 4.3 USER
GROUPS, ROLES, AND ACCESS CONTROL IN SIRUP 99 4.4 THE SIRUP INTEGRATION
DATA MODEL 101 4.4.1 THE SIRUP DATA TYPE SYSTEM 101 4.4.2 CONCEPTS OF
SIDM 104 4.4.3 OPERATIONS IN SIDM 115 4.4.4 TRANSFORMING DATA BETWEEN
DATA MODELS 115 4.5 THE SIDM ALGEBRA , 116 4.5.1 UNARY OPERATIONS 117
4.5.2 OPERATIONS FROM SET THEORY 119 4.5.3 BINARY OPERATIONS 119 4.5.4
RECORD TRANSFORMATION . 121 4.5.5 GROUPING AND AGGREGATION 121 4.5.6
CONVERSION BETWEEN DATA AND METADATA (AND VICE VERSA) 122 4.5.7 NOTATION
FOR QUERY TREES 127 4.5.8 ANNOTATIONAL COMPLETENESS AND AUTOMATIC
PROPAGATION OF METADATA 127 4.6 A RUNNING EXAMPLE 129 4.7 THE SIRUP
INTEGRATION AND QUERY LANGUAGE 130 4.7.1 MANAGEMENT OF DATA SOURCES,
ONTOLOGIES, AND USERS 132 4.7.1.1 ADDING AND REMOVING DATA SOURCES 132
4.7.1.2 ADDING AND REMOVING ONTOLOGIES 133 4.7.1.3 USERS, ROLES, AND
ACCESS CONTROL IN SIQL 133 4.7.2 CREATING AND DELETING ICONCEPTS 134
TABLE OF CONTENTS XIII 4.7.3 ICONCEPTS AND ATTRIBUTE GROUPS 135 4.7.4
ADDING AND REMOVING FUNCTIONS 137 4.7.5 QUERIES IN SIQL 137 4.7.5.1
NAMING IN SIQL 139 4.7.5.2 RENAMING AND SORTING 139 4.7.5.3 OMITTED
WHERE CLAUSE AND USE OF THE ASTERISK 140 4.7.5.4 ATTRIBUTE
TRANSFORMATION AND VALUE CONSTRUCTION 140 4.7.5.5 COMPARISONS INVOLVING
NULL VALUES 141 4.7.5.6 NESTED QUERIES AND SET CONTAINMENT COMPARISONS
141 4.7.5.7 SET OPERATIONS 142 4.7.5.8 JOINS AND RECONCILIATION
FUNCTIONS 142 4.7.5.9 RECORD TRANSFORMATION 143 4.7.5.10 GROUPING AND
AGGREGATION 144 4.7.5.11 REALIZATION OF INTO, SHARP, AND AT IN SIQL 145
4.7.5.12 DATA AND METADATA EXPORT 147 4.7.6 USERCONCEPTS AND SEMANTIC
PERSPECTIVES 147 4.7.7 INTEGRITY CONSTRAINTS, PRIMARY KEYS, AND FOREIGN
KEYS 149 4.7.8 ATTRIBUTE MODIFICATIONS 151 4.7.9 FURTHER COMMANDS FOR
CONVENIENCE 151 4.8 DATA PROVISION 152 4.9 PERSONAL SEMANTIC DATA
INTEGRATION EXEMPLIFIED 157 4.9.1 SECRETARY CASE 157 4.9.1.1 ROOMS IN
ZURICH 158 4.9.1.2 SPECIALIZATIONS ACCORDING TO ROOM TYPES 158 4.9.1.3
ROOM QUERIES 159 4.9.2 STATISTICIAN CASE , 160 4.9.2.1 GENERALIZATION OF
ROOMS 160 4.9.2.2 AGGREGATION OF ROOM INFORMATION 161 4.9.3 STUDENT
TIMETABLE CASE 162 4.9.3.1 HISTORY COURSES 162 4.9.3.2 INFORMATICS
COURSES 163 4.9.3.3 PSYCHOLOGY COURSES 166 4.9.3.4 UNIFIED COURSES VIEW
167 4.9.3.5 TIMETABLE QUERIES 167 4.9.4 FACILITY MANAGEMENT CASE 168
4.9.5 SECURITY DEPARTMENT AND CATERING SERVICE CASE 170 4.9.5.1 COURSES
AND.BUILDINGS 171 4.9.5.2 GROUPING ACCORDING TO TIME INTERVALS 171
4.9.5.3 CONSIDERING OVERLAPS BETWEEN TIME INTERVALS 172 4.9.6 SUMMARY
173 4.10 ONTOLOGICAL ENGINEERING 175 4.11 QUERY PROCESSING 175 4.11.1
DISTINCTIVE FEATURES OF QUERY PROCESSING IN SIRUP 176 4.11.1.1 QUERY
PLANNING 176 4.11.1.2 QUERY TRANSLATION 178 4.11.1.3 QUERY OPTIMIZATION
180 4.11.1.4 QUERY EXECUTION 182 XIV TABLE OF CONTENTS 4.11.1.5 RESULT
INTEGRATION 182 4.11.2 QUERY PROCESSING STEPS IN SIRUP 183 4.12
DISCUSSION AND RATIONALE 189 4.12.1 USEOFLCONCEPTS 189 4.12.2
USERCONCEPTS 192 4.12.3 ACCURACY AND ANNOTATIONS 192 4.12.4
CHARACTERISTICS OF SIDM 194 4.12.5 SIQL AND THE SIDM ALGEBRA 197 5 THE
SIRUP PROTOTYPE 199 5.1 ARCHITECTURAL OVERVIEW 199 5.2 DATA PROVISION
TOOLS 202 5.3 SIRUPWRAPPERS 203 5.4 ATTRIBUTE VALUES AND DATA TYPES 207
5.5 METADATA REPRESENTATION 211 5.6 PERSISTENCE MECHANISMS 212 5.7
SEARCH AND BROWSING TOOLS 213 5.8 EXTENDING SIQL WITH CUSTOMIZED
FUNCTIONALITY 215 5.9 IMPLEMENTATION OF INTEGRITY CONSTRAINT ENFORCEMENT
218 5.10 THE SIQL QUERY PROCESSOR 220 5.11 DATAEXPORT 221 5.12 QUERY
PERFORMANCE OF THE SIRUP PROTOTYPE 222 6 RESULTS AND FUTURE WORK 225 6.1
SIRUP AND TRADITIONAL INTEGRATION APPROACHES 225 6.2 EVALUATION OF SIRUP
228 6.2.1 EXPERIMENTAL EVALUATION OF SIRUP 228 6.2.1.1 EVALUATION
ACCORDING TO THE SIRUP CONFLICT CLASSIFICATION . . . . 228 6.2.1.2
EVALUATION USING THE THALIA BENCHMARK 229 6.2.2 FULFILLMENT OF THE ASME
CRITERIA 231 6.2.2.1 ABSTRACTION 231 6.2.2.2 SELECTION 231 6.2.2.3
MODELING 232 6.2.2.4 EXPLICIT SEMANTICS 233 6.2.3 CONCLUSIONS 234 6.3
CONTRIBUTIONS 234 6.4 FUTURE RESEARCH DIRECTIONS 235 6.4.1 EMPIRICAL
STUDIES 235 6.4.2 DATA QUALITY 236 6.4.3 DATA PROVENANCE 236 6.4.4
UNSTRUCTURED DATA 237 6.4.5 QUERY PROCESSING AND OPTIMIZATION 237 6.4.6
DATA SOURCES AND QUERY CAPABILITIES 238 6.4.7 ANNOTATIONS 238 6.4.8
RELATING DATA ACROSS SIRUP DOMAINS 239 6.4.9 INTEGRATION AND QUERY TOOLS
239 TABLE OF CONTENTS XV 7 SUMMARY AND OUTLOOK 241 LIST OF ABBREVIATIONS
245 BIBLIOGRAPHY 249 APPENDIX 1: UML NOTATION ELEMENTS 285 APPENDIX 2:
REPRESENTATION OF WIDE TABLES 287 APPENDIX 3: COMPARISON OF INTEGRATION
CONFLICT CLASSIFICATIONS 289 APPENDIX 4: COMPARISON OF OLAP AND OLTP 299
APPENDIX 5: COMPARISON OF VIRTUAL AND MATERIALIZED DATA INTEGRATION 301
APPENDIX 6: COMPARISON OF POPULAR INTEGRATION APPROACHES 303 APPENDIX 7:
EVALUATION OF EXISTING APPROACHES WITH THE ASME CRITERIA 305 APPENDIX 8:
SOQA METHOD OVERVIEW 307 APPENDIX 9: EBNF GRAMMAR OF SOQA-QL 311
APPENDIX 10: SST METHOD OVERVIEW 313 APPENDIX 11: DIMENSIONS AND
MEASUREMENT UNITS 317 APPENDIX 12: APPLICABILITY OF ATTRIBUTE METADATA
321 APPENDIX 13: APPLICABILITY OF ICONCEPT AND USERCONCEPT METADATA 325
APPENDIX 14: NESTING OF FUNCTIONS IN THE SIDM ALGEBRA 327 APPENDIX 15:
PARAMETERS AND RESULTS OF THE SHARP OPERATION 329 APPENDIX 16:
PROPAGATION OF ATTRIBUTE METADATA IN THE SIDM ALGEBRA 339 APPENDIX 17:
PROPAGATION OF IC AND VC METADATA IN THE SIDM ALGEBRA 347 APPENDIX 18:
EBNF GRAMMAR OF S1QL 351 APPENDIX 19: REGISTRATION EXAMPLES 359 19.1
REGISTRATION OF DATA SOURCE HISTORYLECTUREDATASOURCE 359 19.2
REGISTRATION OF ONTOLOGIES 360 APPENDIX 20: DATA LISTINGS FROM THE
RUNNING EXAMPLE 361 20.1 SOURCE DATA 361 20.2 QUERY RESULTS 372 APPENDIX
21: COMMAND LINE TREE REPRESENTATIONS IN THE SIRUP PROTOTYPE 399 XVI
TABLE OF CONTENTS APPENDIX 22: ASSESSMENT OF SIDM 403 APPENDIX 23:
COMPUTATIONAL COMPLETENESS OF SIQL 405 APPENDIX 24: ADDITIONAL USER
TOOLS 407 APPENDIX 25: XML ANNOTATION FILE EXAMPLE 411 APPENDIX 26: UML
DIAGRAMS OF THE SIRUP PROTOTYPE 417 APPENDIX 27: DATA TYPES AND DATA
TYPE MAPPINGS IN THE SIRUP PROTOTYPE 429 APPENDIX 28: XML SERVER
PROPERTIES FILE EXAMPLE 435 APPENDIX 29: SIQL FUNCTIONS IN THE SIRUP
PROTOTYPE 437 APPENDIX 30: SIQL QUERY RESULT EXPORT EXAMPLE 441
APPENDIX 31: SIRUP PROTOTYPE PERFORMANCE ANALYSIS 445 APPENDIX 32;
EVALUATION OF SIRUP ACCORDING TO THE SIRUP CONFLICT CLASSIFICATION 459
APPENDIX 33: EVALUATION OF SIRUP USING THE THALIA BENCHMARK 463
CURRICULUM VITAE PATRICK ZLEGLER 465
|
| adam_txt |
TABLE OF CONTENTS INTRODUCTION 1 1.1 FOUNDATIONS AND MOTIVATION 1 1.2
OBJECTIVES AND ASSUMPTIONS 9 1.3 MAIN CONTRIBUTIONS 10 1.4 ORGANIZATION
OF THE THESIS 12 DATA INTEGRATION: FUNDAMENTALS AND APPROACHES 13 2.1
FUNDAMENTAL ISSUES IN DATA INTEGRATION 13 2.1.1 DISTRIBUTION 14 2.1.2
AUTONOMY 14 2.1.3 HETEROGENEITY 15 2.1.3.1 CLASSIFICATION OF INTEGRATION
CONFLICTS 16 2.1.4 TRANSPARENCY 20 2.2 ARCHITECTURES AND SYSTEMS 21
2.2.1 ARCHITECTURAL ARCHETYPES 21 2.2.1.1 DISTRIBUTED DATABASE SYSTEMS
21 2.2.1.2 MULTIDATABASE SYSTEMS 22 2.2.1.3 FEDERATED DATABASE SYSTEMS
23 2.2.1.4 MEDIATOR SYSTEMS 24 2.2.1.5 DATA WAREHOUSE SYSTEMS 25 2.2.1.6
PEER DATA MANAGEMENT SYSTEMS 25 2.2.2 GENERAL CONSIDERATIONS IN BUILDING
INTEGRATED INFORMATION SYSTEMS 26 2.2.3 CLASSIFICATION OF INTEGRATION
APPROACHES 29 2.3 TECHNIQUES FOR DATA INTEGRATION 32 2.3.1 SCHEMA AND
METADATA MANAGEMENT 33 2.3.1.1 SCHEMA INTEGRATION 33 2.3.1.2 SCHEMA
MAPPING 36 2.3.1.3 SCHEMA MATCHING 37 2.3.1.4 MULTIDATABASE LANGUAGES 40
2.3.1.5 MODEL MANAGEMENT 41 2.3.2 QUERY PROCESSING 42 2.3.2.1 SHORT
INTRODUCTION TO DATALOG 45 2.3.2.2 QUERY PLANNING 48 2.3.2.3 QUERY
OPTIMIZATION 53 2.3.2.4 INCORPORATING LIMITED SOURCES THROUGH WRAPPERS
54 2.3.3 SEMANTIC INTEGRATION 54 2.3.4 RECORD-LEVEL INTEGRATION 59 XI
XII TABLE OF CONTENTS 2.3.4.1 COMPLETENESS 60 2.3.4.2 DATA ERRORS 60
2.3.4.3 DATA CLEANSING 61 2.3.4.4 DETECTION OF DUPLICATES 62 2.3.4.5
RECORD MERGING 63 2.3.4.6 DATA QUALITY 67 2.3.4.7 DATA PROVENANCE 68 2.4
LIMITATIONS OF CURRENT APPROACHES AND CONSEQUENCES 69 2.4.1 PERSPECTUAL
INTEGRATION MISTAKES .' 69 2.4.2 THE ASME CRITERIA 73 3 AN ONTOLOGY
INFRASTRUCTURE FOR SIRUP 77 3.1 THE SIRUP ONTOLOGY QUERY API 77 3.1.1
THE SOQA ONTOLOGY META MODEL 78 3.1.2 SOFTWARE ARCHITECTURE OF SOQA , .
. . . 80 3.2 THE SOQA QUERY LANGUAGE 82 3.3 THE SOQA BROWSER 85 3.4 THE
SOQA-SIMPACK TOOLKIT 86 3.4.1 SOFTWARE ARCHITECTURE OF SST 88 3.4.2 SST
EXEMPLIFIED 90 3.5 THE SST BROWSER 91 4 THE SIRUP APPROACH 93 4.1
FUNDAMENTAL PRINCIPLES IN SIRUP 93 4.2 AN OVERVIEW OF SIRUP 95 4.3 USER
GROUPS, ROLES, AND ACCESS CONTROL IN SIRUP 99 4.4 THE SIRUP INTEGRATION
DATA MODEL 101 4.4.1 THE SIRUP DATA TYPE SYSTEM 101 4.4.2 CONCEPTS OF
SIDM 104 4.4.3 OPERATIONS IN SIDM 115 4.4.4 TRANSFORMING DATA BETWEEN
DATA MODELS 115 4.5 THE SIDM ALGEBRA , 116 4.5.1 UNARY OPERATIONS 117
4.5.2 OPERATIONS FROM SET THEORY 119 4.5.3 BINARY OPERATIONS 119 4.5.4
RECORD TRANSFORMATION . 121 4.5.5 GROUPING AND AGGREGATION 121 4.5.6
CONVERSION BETWEEN DATA AND METADATA (AND VICE VERSA) 122 4.5.7 NOTATION
FOR QUERY TREES 127 4.5.8 ANNOTATIONAL COMPLETENESS AND AUTOMATIC
PROPAGATION OF METADATA 127 4.6 A RUNNING EXAMPLE 129 4.7 THE SIRUP
INTEGRATION AND QUERY LANGUAGE 130 4.7.1 MANAGEMENT OF DATA SOURCES,
ONTOLOGIES, AND USERS 132 4.7.1.1 ADDING AND REMOVING DATA SOURCES 132
4.7.1.2 ADDING AND REMOVING ONTOLOGIES 133 4.7.1.3 USERS, ROLES, AND
ACCESS CONTROL IN SIQL 133 4.7.2 CREATING AND DELETING ICONCEPTS 134
TABLE OF CONTENTS XIII 4.7.3 ICONCEPTS AND ATTRIBUTE GROUPS 135 4.7.4
ADDING AND REMOVING FUNCTIONS 137 4.7.5 QUERIES IN SIQL 137 4.7.5.1
NAMING IN SIQL 139 4.7.5.2 RENAMING AND SORTING 139 4.7.5.3 OMITTED
WHERE CLAUSE AND USE OF THE ASTERISK 140 4.7.5.4 ATTRIBUTE
TRANSFORMATION AND VALUE CONSTRUCTION 140 4.7.5.5 COMPARISONS INVOLVING
NULL VALUES 141 4.7.5.6 NESTED QUERIES AND SET CONTAINMENT COMPARISONS
141 4.7.5.7 SET OPERATIONS 142 4.7.5.8 JOINS AND RECONCILIATION
FUNCTIONS 142 4.7.5.9 RECORD TRANSFORMATION 143 4.7.5.10 GROUPING AND
AGGREGATION 144 4.7.5.11 REALIZATION OF INTO, SHARP, AND AT IN SIQL 145
4.7.5.12 DATA AND METADATA EXPORT 147 4.7.6 USERCONCEPTS AND SEMANTIC
PERSPECTIVES 147 4.7.7 INTEGRITY CONSTRAINTS, PRIMARY KEYS, AND FOREIGN
KEYS 149 4.7.8 ATTRIBUTE MODIFICATIONS 151 4.7.9 FURTHER COMMANDS FOR
CONVENIENCE 151 4.8 DATA PROVISION 152 4.9 PERSONAL SEMANTIC DATA
INTEGRATION EXEMPLIFIED 157 4.9.1 SECRETARY CASE 157 4.9.1.1 ROOMS IN
ZURICH 158 4.9.1.2 SPECIALIZATIONS ACCORDING TO ROOM TYPES 158 4.9.1.3
ROOM QUERIES 159 4.9.2 STATISTICIAN CASE , 160 4.9.2.1 GENERALIZATION OF
ROOMS 160 4.9.2.2 AGGREGATION OF ROOM INFORMATION 161 4.9.3 STUDENT
TIMETABLE CASE 162 4.9.3.1 HISTORY COURSES 162 4.9.3.2 INFORMATICS
COURSES 163 4.9.3.3 PSYCHOLOGY COURSES 166 4.9.3.4 UNIFIED COURSES VIEW
167 4.9.3.5 TIMETABLE QUERIES 167 4.9.4 FACILITY MANAGEMENT CASE 168
4.9.5 SECURITY DEPARTMENT AND CATERING SERVICE CASE 170 4.9.5.1 COURSES
AND.BUILDINGS 171 4.9.5.2 GROUPING ACCORDING TO TIME INTERVALS 171
4.9.5.3 CONSIDERING OVERLAPS BETWEEN TIME INTERVALS 172 4.9.6 SUMMARY
173 4.10 ONTOLOGICAL ENGINEERING 175 4.11 QUERY PROCESSING 175 4.11.1
DISTINCTIVE FEATURES OF QUERY PROCESSING IN SIRUP 176 4.11.1.1 QUERY
PLANNING 176 4.11.1.2 QUERY TRANSLATION 178 4.11.1.3 QUERY OPTIMIZATION
180 4.11.1.4 QUERY EXECUTION 182 XIV TABLE OF CONTENTS 4.11.1.5 RESULT
INTEGRATION 182 4.11.2 QUERY PROCESSING STEPS IN SIRUP 183 4.12
DISCUSSION AND RATIONALE 189 4.12.1 USEOFLCONCEPTS 189 4.12.2
USERCONCEPTS 192 4.12.3 ACCURACY AND ANNOTATIONS 192 4.12.4
CHARACTERISTICS OF SIDM 194 4.12.5 SIQL AND THE SIDM ALGEBRA 197 5 THE
SIRUP PROTOTYPE 199 5.1 ARCHITECTURAL OVERVIEW 199 5.2 DATA PROVISION
TOOLS 202 5.3 SIRUPWRAPPERS 203 5.4 ATTRIBUTE VALUES AND DATA TYPES 207
5.5 METADATA REPRESENTATION 211 5.6 PERSISTENCE MECHANISMS 212 5.7
SEARCH AND BROWSING TOOLS 213 5.8 EXTENDING SIQL WITH CUSTOMIZED
FUNCTIONALITY 215 5.9 IMPLEMENTATION OF INTEGRITY CONSTRAINT ENFORCEMENT
218 5.10 THE SIQL QUERY PROCESSOR 220 5.11 DATAEXPORT 221 5.12 QUERY
PERFORMANCE OF THE SIRUP PROTOTYPE 222 6 RESULTS AND FUTURE WORK 225 6.1
SIRUP AND TRADITIONAL INTEGRATION APPROACHES 225 6.2 EVALUATION OF SIRUP
228 6.2.1 EXPERIMENTAL EVALUATION OF SIRUP 228 6.2.1.1 EVALUATION
ACCORDING TO THE SIRUP CONFLICT CLASSIFICATION . . . . 228 6.2.1.2
EVALUATION USING THE THALIA BENCHMARK 229 6.2.2 FULFILLMENT OF THE ASME
CRITERIA 231 6.2.2.1 ABSTRACTION 231 6.2.2.2 SELECTION 231 6.2.2.3
MODELING 232 6.2.2.4 EXPLICIT SEMANTICS 233 6.2.3 CONCLUSIONS 234 6.3
CONTRIBUTIONS 234 6.4 FUTURE RESEARCH DIRECTIONS 235 6.4.1 EMPIRICAL
STUDIES 235 6.4.2 DATA QUALITY 236 6.4.3 DATA PROVENANCE 236 6.4.4
UNSTRUCTURED DATA 237 6.4.5 QUERY PROCESSING AND OPTIMIZATION 237 6.4.6
DATA SOURCES AND QUERY CAPABILITIES 238 6.4.7 ANNOTATIONS 238 6.4.8
RELATING DATA ACROSS SIRUP DOMAINS 239 6.4.9 INTEGRATION AND QUERY TOOLS
239 TABLE OF CONTENTS XV 7 SUMMARY AND OUTLOOK 241 LIST OF ABBREVIATIONS
245 BIBLIOGRAPHY 249 APPENDIX 1: UML NOTATION ELEMENTS 285 APPENDIX 2:
REPRESENTATION OF WIDE TABLES 287 APPENDIX 3: COMPARISON OF INTEGRATION
CONFLICT CLASSIFICATIONS 289 APPENDIX 4: COMPARISON OF OLAP AND OLTP 299
APPENDIX 5: COMPARISON OF VIRTUAL AND MATERIALIZED DATA INTEGRATION 301
APPENDIX 6: COMPARISON OF POPULAR INTEGRATION APPROACHES 303 APPENDIX 7:
EVALUATION OF EXISTING APPROACHES WITH THE ASME CRITERIA 305 APPENDIX 8:
SOQA METHOD OVERVIEW 307 APPENDIX 9: EBNF GRAMMAR OF SOQA-QL 311
APPENDIX 10: SST METHOD OVERVIEW 313 APPENDIX 11: DIMENSIONS AND
MEASUREMENT UNITS 317 APPENDIX 12: APPLICABILITY OF ATTRIBUTE METADATA
321 APPENDIX 13: APPLICABILITY OF ICONCEPT AND USERCONCEPT METADATA 325
APPENDIX 14: NESTING OF FUNCTIONS IN THE SIDM ALGEBRA 327 APPENDIX 15:
PARAMETERS AND RESULTS OF THE SHARP OPERATION 329 APPENDIX 16:
PROPAGATION OF ATTRIBUTE METADATA IN THE SIDM ALGEBRA 339 APPENDIX 17:
PROPAGATION OF IC AND VC METADATA IN THE SIDM ALGEBRA 347 APPENDIX 18:
EBNF GRAMMAR OF S1QL 351 APPENDIX 19: REGISTRATION EXAMPLES 359 19.1
REGISTRATION OF DATA SOURCE HISTORYLECTUREDATASOURCE 359 19.2
REGISTRATION OF ONTOLOGIES 360 APPENDIX 20: DATA LISTINGS FROM THE
RUNNING EXAMPLE 361 20.1 SOURCE DATA 361 20.2 QUERY RESULTS 372 APPENDIX
21: COMMAND LINE TREE REPRESENTATIONS IN THE SIRUP PROTOTYPE 399 XVI
TABLE OF CONTENTS APPENDIX 22: ASSESSMENT OF SIDM 403 APPENDIX 23:
COMPUTATIONAL COMPLETENESS OF SIQL 405 APPENDIX 24: ADDITIONAL USER
TOOLS 407 APPENDIX 25: XML ANNOTATION FILE EXAMPLE 411 APPENDIX 26: UML
DIAGRAMS OF THE SIRUP PROTOTYPE 417 APPENDIX 27: DATA TYPES AND DATA
TYPE MAPPINGS IN THE SIRUP PROTOTYPE 429 APPENDIX 28: XML SERVER
PROPERTIES FILE EXAMPLE 435 APPENDIX 29: SIQL FUNCTIONS IN THE SIRUP
PROTOTYPE 437 APPENDIX 30: SIQL' QUERY RESULT EXPORT EXAMPLE 441
APPENDIX 31: SIRUP PROTOTYPE PERFORMANCE ANALYSIS 445 APPENDIX 32;
EVALUATION OF SIRUP ACCORDING TO THE SIRUP CONFLICT CLASSIFICATION 459
APPENDIX 33: EVALUATION OF SIRUP USING THE THALIA BENCHMARK 463
CURRICULUM VITAE PATRICK ZLEGLER 465 |
| any_adam_object | 1 |
| any_adam_object_boolean | 1 |
| author | Ziegler, Patrick |
| author_facet | Ziegler, Patrick |
| author_role | aut |
| author_sort | Ziegler, Patrick |
| author_variant | p z pz |
| building | Verbundindex |
| bvnumber | BV023170665 |
| classification_rvk | ST 270 |
| ctrlnum | (OCoLC)254551678 (DE-599)HBZHT015431684 |
| discipline | Informatik |
| discipline_str_mv | Informatik |
| format | Thesis Book |
| fullrecord | <?xml version="1.0" encoding="UTF-8"?><collection xmlns="http://www.loc.gov/MARC21/slim"><record><leader>01243nam a2200325 c 4500</leader><controlfield tag="001">BV023170665</controlfield><controlfield tag="003">DE-604</controlfield><controlfield tag="005">20080826 </controlfield><controlfield tag="007">t</controlfield><controlfield tag="008">080218s2007 ad|| m||| 00||| eng d</controlfield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(OCoLC)254551678</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(DE-599)HBZHT015431684</subfield></datafield><datafield tag="040" ind1=" " ind2=" "><subfield code="a">DE-604</subfield><subfield code="b">ger</subfield><subfield code="e">rakwb</subfield></datafield><datafield tag="041" ind1="0" ind2=" "><subfield code="a">eng</subfield></datafield><datafield tag="049" ind1=" " ind2=" "><subfield code="a">DE-355</subfield><subfield code="a">DE-19</subfield><subfield code="a">DE-384</subfield><subfield code="a">DE-188</subfield></datafield><datafield tag="084" ind1=" " ind2=" "><subfield code="a">ST 270</subfield><subfield code="0">(DE-625)143638:</subfield><subfield code="2">rvk</subfield></datafield><datafield tag="100" ind1="1" ind2=" "><subfield code="a">Ziegler, Patrick</subfield><subfield code="e">Verfasser</subfield><subfield code="4">aut</subfield></datafield><datafield tag="245" ind1="1" ind2="0"><subfield code="a">The SIRUP approach to personal semantic data integration</subfield><subfield code="c">by Patrick Ziegler</subfield></datafield><datafield tag="264" ind1=" " ind2="1"><subfield code="c">2007</subfield></datafield><datafield tag="300" ind1=" " ind2=" "><subfield code="a">XXVI, 466 S.</subfield><subfield code="b">Ill., graph. Darst.</subfield></datafield><datafield tag="336" ind1=" " ind2=" "><subfield code="b">txt</subfield><subfield code="2">rdacontent</subfield></datafield><datafield tag="337" ind1=" " ind2=" "><subfield code="b">n</subfield><subfield code="2">rdamedia</subfield></datafield><datafield tag="338" ind1=" " ind2=" "><subfield code="b">nc</subfield><subfield code="2">rdacarrier</subfield></datafield><datafield tag="502" ind1=" " ind2=" "><subfield code="a">Zürich, Univ., Diss., 2007</subfield></datafield><datafield tag="650" ind1="0" ind2="7"><subfield code="a">Datenintegration</subfield><subfield code="0">(DE-588)4197730-0</subfield><subfield code="2">gnd</subfield><subfield code="9">rswk-swf</subfield></datafield><datafield tag="655" ind1=" " ind2="7"><subfield code="0">(DE-588)4113937-9</subfield><subfield code="a">Hochschulschrift</subfield><subfield code="2">gnd-content</subfield></datafield><datafield tag="689" ind1="0" ind2="0"><subfield code="a">Datenintegration</subfield><subfield code="0">(DE-588)4197730-0</subfield><subfield code="D">s</subfield></datafield><datafield tag="689" ind1="0" ind2=" "><subfield code="5">DE-604</subfield></datafield><datafield tag="856" ind1="4" ind2="2"><subfield code="m">SWB Datenaustausch</subfield><subfield code="q">application/pdf</subfield><subfield code="u">http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=016357341&sequence=000001&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA</subfield><subfield code="3">Inhaltsverzeichnis</subfield></datafield><datafield tag="999" ind1=" " ind2=" "><subfield code="a">oai:aleph.bib-bvb.de:BVB01-016357341</subfield></datafield></record></collection> |
| genre | (DE-588)4113937-9 Hochschulschrift gnd-content |
| genre_facet | Hochschulschrift |
| id | DE-604.BV023170665 |
| illustrated | Illustrated |
| index_date | 2024-07-02T19:57:32Z |
| indexdate | 2024-07-09T21:12:12Z |
| institution | BVB |
| language | English |
| oai_aleph_id | oai:aleph.bib-bvb.de:BVB01-016357341 |
| oclc_num | 254551678 |
| open_access_boolean | |
| owner | DE-355 DE-BY-UBR DE-19 DE-BY-UBM DE-384 DE-188 |
| owner_facet | DE-355 DE-BY-UBR DE-19 DE-BY-UBM DE-384 DE-188 |
| physical | XXVI, 466 S. Ill., graph. Darst. |
| publishDate | 2007 |
| publishDateSearch | 2007 |
| publishDateSort | 2007 |
| record_format | marc |
| spelling | Ziegler, Patrick Verfasser aut The SIRUP approach to personal semantic data integration by Patrick Ziegler 2007 XXVI, 466 S. Ill., graph. Darst. txt rdacontent n rdamedia nc rdacarrier Zürich, Univ., Diss., 2007 Datenintegration (DE-588)4197730-0 gnd rswk-swf (DE-588)4113937-9 Hochschulschrift gnd-content Datenintegration (DE-588)4197730-0 s DE-604 SWB Datenaustausch application/pdf http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=016357341&sequence=000001&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA Inhaltsverzeichnis |
| spellingShingle | Ziegler, Patrick The SIRUP approach to personal semantic data integration Datenintegration (DE-588)4197730-0 gnd |
| subject_GND | (DE-588)4197730-0 (DE-588)4113937-9 |
| title | The SIRUP approach to personal semantic data integration |
| title_auth | The SIRUP approach to personal semantic data integration |
| title_exact_search | The SIRUP approach to personal semantic data integration |
| title_exact_search_txtP | The SIRUP approach to personal semantic data integration |
| title_full | The SIRUP approach to personal semantic data integration by Patrick Ziegler |
| title_fullStr | The SIRUP approach to personal semantic data integration by Patrick Ziegler |
| title_full_unstemmed | The SIRUP approach to personal semantic data integration by Patrick Ziegler |
| title_short | The SIRUP approach to personal semantic data integration |
| title_sort | the sirup approach to personal semantic data integration |
| topic | Datenintegration (DE-588)4197730-0 gnd |
| topic_facet | Datenintegration Hochschulschrift |
| url | http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=016357341&sequence=000001&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA |
| work_keys_str_mv | AT zieglerpatrick thesirupapproachtopersonalsemanticdataintegration |