Matches in SemOpenAlex for { <https://semopenalex.org/work/W233107109> ?p ?o ?g. }
- W233107109 abstract "In the quest for database usability, several applications enable users to design custom forms using a graphical interface, and forward engineer the forms into new databases. The path-breaking aspect of such applications is that users are completely shielded from the technicalities of database creation. Despite this innovation, the process of automatically integrating a new form into an existing database remains unexplored. At large, databases continue to remain unusable. This dissertation focuses on investigating the problem of mapping multiple forms into an existing relational database. We seek a framework that automatically detects and merges the semantically matching elements between forms and databases. Upon encountering the unmatched form elements, the framework creates new database elements and integrates them with the underlying database. The technical goal is to ensure that the resultant database is compliant with high principles defined in terms of form semantics. The usability goal is to ensure minimalism in the user interventions required to discover correspondences. We introduce a model, the form tree, to represent the user's semantic intentions represented by a form. We design two anchor approaches to extract the form tree from an arbitrarily-designed form, and to further disambiguate the form semantics by annotating its terms using standard concepts. Thereon, we formulate the following mapping solution: (i) Leverage linguistics and semantics to discover and validate semantic correspondences between the form tree and the existing database. (ii) Devise mapping algorithms that create a new high-quality database for a given form tree, and merge it with the existing database while fusing the semantically equivalent elements. We evaluate the entire framework by developing a prototype, and experimenting in the healthcare domain. We collect 52 clinical forms from different medical institutions, and map them to 6 databases of varying scales. The anchor approaches generate form trees with 98% accuracy, and annotate the form terms with a precision of 0.89. The framework helps in producing up to 74% principle compliant databases in terms of compactness, and in reducing user interventions by 61%. The experiment results imply that the use of annotation helps in improving the quality of the evolved database." @default.
- W233107109 created "2016-06-24" @default.
- W233107109 creator A5077990968 @default.
- W233107109 date "2021-07-16" @default.
- W233107109 modified "2023-09-24" @default.
- W233107109 title "A framework for mapping user-designed forms to relational databases" @default.
- W233107109 cites W12515546 @default.
- W233107109 cites W128776805 @default.
- W233107109 cites W1486488535 @default.
- W233107109 cites W1501945960 @default.
- W233107109 cites W1516454970 @default.
- W233107109 cites W1523873824 @default.
- W233107109 cites W1524214323 @default.
- W233107109 cites W1527781663 @default.
- W233107109 cites W1536678384 @default.
- W233107109 cites W1556076816 @default.
- W233107109 cites W1559185158 @default.
- W233107109 cites W1564381193 @default.
- W233107109 cites W1567491469 @default.
- W233107109 cites W1569908913 @default.
- W233107109 cites W1584117873 @default.
- W233107109 cites W1592141906 @default.
- W233107109 cites W1592186521 @default.
- W233107109 cites W1700279323 @default.
- W233107109 cites W1739211641 @default.
- W233107109 cites W1787211267 @default.
- W233107109 cites W1809348896 @default.
- W233107109 cites W1882517313 @default.
- W233107109 cites W1897657357 @default.
- W233107109 cites W1974824230 @default.
- W233107109 cites W1975504213 @default.
- W233107109 cites W1975824482 @default.
- W233107109 cites W1984314602 @default.
- W233107109 cites W1989334056 @default.
- W233107109 cites W1989944922 @default.
- W233107109 cites W1994720930 @default.
- W233107109 cites W1999399258 @default.
- W233107109 cites W2008896880 @default.
- W233107109 cites W2019943268 @default.
- W233107109 cites W2029053609 @default.
- W233107109 cites W2057243780 @default.
- W233107109 cites W2071463681 @default.
- W233107109 cites W2073828820 @default.
- W233107109 cites W2087406717 @default.
- W233107109 cites W2087846792 @default.
- W233107109 cites W2092220252 @default.
- W233107109 cites W2093274439 @default.
- W233107109 cites W2097203724 @default.
- W233107109 cites W2098388305 @default.
- W233107109 cites W2105819430 @default.
- W233107109 cites W2108940246 @default.
- W233107109 cites W2113226793 @default.
- W233107109 cites W2115706760 @default.
- W233107109 cites W2116254887 @default.
- W233107109 cites W2116595366 @default.
- W233107109 cites W2116856471 @default.
- W233107109 cites W2117152225 @default.
- W233107109 cites W2117658379 @default.
- W233107109 cites W2121397688 @default.
- W233107109 cites W2123853152 @default.
- W233107109 cites W2125838338 @default.
- W233107109 cites W2126077692 @default.
- W233107109 cites W2134755874 @default.
- W233107109 cites W2136530502 @default.
- W233107109 cites W2139135093 @default.
- W233107109 cites W2139259611 @default.
- W233107109 cites W2140190241 @default.
- W233107109 cites W2147285089 @default.
- W233107109 cites W2148942721 @default.
- W233107109 cites W2155567100 @default.
- W233107109 cites W2156510574 @default.
- W233107109 cites W2159583324 @default.
- W233107109 cites W2159793945 @default.
- W233107109 cites W2159899187 @default.
- W233107109 cites W2160801510 @default.
- W233107109 cites W2167492639 @default.
- W233107109 cites W2170188121 @default.
- W233107109 cites W23463866 @default.
- W233107109 cites W2412009816 @default.
- W233107109 cites W2638313803 @default.
- W233107109 cites W2751199251 @default.
- W233107109 cites W2753710282 @default.
- W233107109 cites W3145128584 @default.
- W233107109 cites W3146821131 @default.
- W233107109 cites W35287564 @default.
- W233107109 cites W608653410 @default.
- W233107109 cites W71924057 @default.
- W233107109 cites W77974030 @default.
- W233107109 cites W95348284 @default.
- W233107109 doi "https://doi.org/10.17918/etd-4064" @default.
- W233107109 hasPublicationYear "2021" @default.
- W233107109 type Work @default.
- W233107109 sameAs 233107109 @default.
- W233107109 citedByCount "0" @default.
- W233107109 crossrefType "dissertation" @default.
- W233107109 hasAuthorship W233107109A5077990968 @default.
- W233107109 hasConcept C23123220 @default.
- W233107109 hasConcept C41008148 @default.
- W233107109 hasConcept C5655090 @default.
- W233107109 hasConcept C77088390 @default.