Path Expressions in SQL
| Autor: | Heidi Kari, Jaana Kekäläinen, Johanna Vainio, Kati Iltanen, Paavo Arvola, Marko Junkkari |
|---|---|
| Rok vydání: | 2016 |
| Předmět: |
SQL
Computer science Programming language 05 social sciences Data definition language InformationSystems_DATABASEMANAGEMENT 02 engineering and technology computer.software_genre Language Integrated Query Null (SQL) Hardware and Architecture SQL injection 020204 information systems 0202 electrical engineering electronic engineering information engineering Query by Example Stored procedure 0509 other social sciences SQL/PSM 050904 information & library sciences computer Software Information Systems computer.programming_language |
| Zdroj: | Journal of Database Management. 27:1-22 |
| ISSN: | 1533-8010 1063-8016 |
| Popis: | This article focuses on testing a path-oriented querying approach to hierarchical data in relational databases. The authors execute a user study to compare the path-oriented approach and traditional SQL from two perspectives: correctness of queries and time spent in querying. They also analyze what kinds of errors are typical in path-oriented SQL. Path-oriented query languages are popular in the context of object-orientation and XML. However, relational databases are the most common paradigm for storing data and SQL is most common for manipulating data. When querying hierarchical data in SQL, the user must specify join conditions explicitly between hierarchy levels. Path-oriented SQL is a new alternative for expressing hierarchical queries in relational databases. In the authors' study, the users spent significantly less time in writing path-oriented SQL queries and made fewer errors in query formulation. |
| Databáze: | OpenAIRE |
| Externí odkaz: |
|