SQLGEN: A framework for rapid client-server database application development
Open accessThe DOI matches its Crossref record; 10 of the 17 references it cites were found in a registry or an index.
Abstract
SQLGEN is a framework for rapid client-server relational database application development. It relies on an active data dictionary on the client machine that stores metadata on one or more database servers to which the client may be connected. The dictionary generates dynamic Structured Query Language (SQL) to perform common database operations; it also stores information about the access rights of the user at log-in time, which is used to partially self-configure the behavior of the client to disable inappropriate user actions. SQLGEN uses a microcomputer database as the client to store metadata in relational form, to transiently capture server data in tables, and to allow rapid application prototyping followed by porting to client-server mode with modest effort. SQLGEN is currently used in several production biomedical databases.
Overview
Integrity signals
Registry
Cites
Statistics
Verification
Claims the paper makes
Claims other papers make about this one
Each is checked against this paper’s own text: does it say what the citing paper says it does?
In the citing paper
“we realized early in the project that the critical factor for success would lie in creating a simple workflow methodology allowing research teams to autonomously develop study-related metadata in an efficient manner.(3–5)”
From Research electronic data capture (REDCap)—A metadata-driven methodology and workflow process for providing translational research informatics support (2009) · cites this paper as [3]
Citations
Cites
Introduction to Database Systems
(2006) · Foundations of Database Design · doi:10.1201/9781420003345.ch1 · Cited by 3,521
Kernighan, B. W., & Ritchie, D. M. (1978) · Cited by 1,857
Ritchie, D. M., Johnson, S. C., Lesk, M. E., & Kernighan, B. W. (1983) · Programming Languages · doi:10.1007/978-3-662-09507-2_22 · Cited by 860
Understanding the New SQL: A Complete Guide
Melton, J., & Simon, A. R. (1993) · Cited by 399
Introduction to Database Systems
Desai, B. C. (1990) · Spectrum Research Repository (Concordia University) · Cited by 127
Bretherton, F. P., & Singley, P. T. (2002) · International Conference on Scientific and Statistical Database Management · doi:10.1109/ssdm.1994.336950 · Cited by 28
Privacy and security requirements of distributed computer based patient records.
Moehr, J. R. (1994) · PubMed · Cited by 3
Intelligent User Interface for Very Large Relational Databases.
Reimers, P. E., & Chung, S. M. (1993) · International Conference on Human-Computer Interaction · Cited by 3
Using an extended er-model based data dictionary to automatically generate product modeling systems
Johansson, O. (1994) · Lecture notes in computer science · doi:10.1007/3-540-58183-9_40 · Cited by 2
Nadkarni, P. M., & Bray‐Ward, P. (1995) · Genomics · doi:10.1016/0888-7543(95)80147-e · Cited by 1
Self-citation
Cited by
Harris, P. A., Taylor, R., Thielke, R., Payne, J., Gonzalez, N., & Conde, J. G. (2009) · Journal of Biomedical Informatics · doi:10.1016/j.jbi.2008.08.010 · Cited by 51,384
Organization of Heterogeneous Scientific Data Using the EAV/CR Representation
Nadkarni, P. M., Marenco, L., Chen, R., Skoufos, E., Shepherd, G., & Miller, P. (1999) · Journal of the American Medical Informatics Association · doi:10.1136/jamia.1999.0060478 · Cited by 207
Self-citationData Extraction and Ad Hoc Query of an Entity--Attribute--Value Database
Nadkarni, P., & Brandt, C. (1998) · Journal of the American Medical Informatics Association · doi:10.1136/jamia.1998.0050511 · Cited by 109
Self-citationManaging Attribute-Value Clinical Trials Data Using the ACT/DB Client-Server Database System
Nadkarni, P., Brandt, C., Frawley, S. J., Sayward, F. G., Einbinder, R., Zelterman, D. A., Schacter, L., & Miller, P. L. (1998) · Journal of the American Medical Informatics Association · doi:10.1136/jamia.1998.0050139 · Cited by 100
Self-citationWebEAV: automatic metadata-driven generation of web interfaces to entity-attribute-value databases
Nadkarni, P. M., Brandt, C. M., & Marenco, L. (2000) · Journal of the American Medical Informatics Association · doi:10.1136/jamia.2000.0070343 · Cited by 56
Self-citation
Metadata
- Authors
- NADKARNI, P., & CHEUNG, K.
- Affiliations
- Yale University (US)
- Corresponding author
- NADKARNI, P
- ORCID
- Venue
- Computers and Biomedical Research
- Publisher
- Elsevier BV
- Published
- 1995-12
- Volume
- 28
- Issue
- 6
- Pages
- 479-499
- ISSN
- 0010-4809 (ISSN-L)
- OpenAlex
- W2002970802
- Cited by
- 13
- References
- 17
- Citations by year
- 2015: 2
- FWCI
- 12.28
- Type
- journal article
- Language
- en
- Open access
- hybrid
- doi.org
- Licence
- cc-by-nc-nd
- www.elsevier.com/tdm/userlicense/1.0/ (tdm)
- Locations
- Computers and Biomedical Research (publishedVersion, cc-by-nc-nd)
- PubMed (publishedVersion)
- Funders
- National Institutes of Health (5p01hg000965-03, 5r01hg000175-03, 5r37mh039239-13)
- National Institute of Mental Health (R37 MH39239, MH39 239, 4 R37 MH 39239-10)
- National Human Genome Research Institute (R01 HG00175, P01 HG00965)
- Topics
- Physical Sciences › Computer Science › Software › Engineering and Information Technology
- Physical Sciences › Computer Science › Information Systems › Advanced Database Systems and Queries
- Physical Sciences › Computer Science › Information Systems › Web Applications and Data Management
- Keywords
- rapid application development, database metadata, user access rights, microcomputer databases, application prototyping, biomedical databases, relational databases
- MeSH terms
- Computer Communication Networks, Computer Systems, Equipment Failure, Software, Computer Security
About these checks
Registry, retraction, Cites and statistics results are computed, not judged, with one exception: a printed reference that no index lists is read once by a model before it counts as a citation error. Claims are extracted by a model and kept only when their quote appears verbatim in the text; each cited source is then checked, with a model’s help, for whether it says what the claim relies on. Those verdicts can be wrong — read the claim’s quote and the cited source before relying on one.
Statistics and arithmetic are recomputed, not judged.
Confidence bands are shown only for fields calibrated on our annotated test set. None is calibrated yet, so no band is shown.
What counts as a claim ›How we measure confidence ›How we check this ›
Are you an author, or do you see a problem with this page? Request a review
How to cite
Cite CoChat for the checks on this page, and the paper for its own findings.
- This page
- CoChat. (2026). Citation check: SQLGEN: A framework for rapid client-server database application development. https://app.cochat.ai/papers/10.1016/s0010-4809(85)71030-0
- The paper
- NADKARNI, P., & CHEUNG, K. (1995). SQLGEN: A framework for rapid client-server database application development. Computers and Biomedical Research. https://doi.org/10.1016/s0010-4809(85)71030-0
Data sources
Bibliographic data: Semantic Scholar, OpenAlex, Crossref.
Contains information from the Semantic Scholar Academic Graph Datasets, made available under the ODC Attribution License (ODC-BY 1.0).
Semantic Scholar’s data is described in: Kinney, R., et al. (2023). The Semantic Scholar Open Data Platform. arXiv:2301.10140.