CRIUS: User-Friendly Database Design

12 years 7 days ago
CRIUS: User-Friendly Database Design
Non-technical users are increasingly adding structures to their data. This gives rise to the need for database design. However, traditional database design is deliberate and heavy-weight, requiring technical expertise that everyday users may not possess. For this reason, we propose that users of personal data management applications should be able to create and refine data structures in an ad-hoc way over time, thereby “organically” growing their schemas. For this purpose, we develop a spreadsheet-like direct manipulation interface. We show how integrity constraints can still provide value, even in this scenario of frequent schema and data modifications. We also develop a back-end database implementation to support this interface, with a design that permits schema changes at a low cost. We have folded these ideas into a system, called CRIUS, which supports a nested data model and a graphical user interface. From the user’s perspective, the chief advantages of CRIUS are its sup...
Li Qian, Kristen LeFevre, H. V. Jagadish
Added 30 Jan 2011
Updated 30 Jan 2011
Type Journal
Year 2010
Authors Li Qian, Kristen LeFevre, H. V. Jagadish
Comments (0)