Jove
Visualize
Contact Us
JoVE
x logofacebook logolinkedin logoyoutube logo
ABOUT JoVE
OverviewLeadershipBlogJoVE Help Center
AUTHORS
Publishing ProcessEditorial BoardScope & PoliciesPeer ReviewFAQSubmit
LIBRARIANS
TestimonialsSubscriptionsAccessResourcesLibrary Advisory BoardFAQ
RESEARCH
JoVE JournalMethods CollectionsJoVE Encyclopedia of ExperimentsArchive
EDUCATION
JoVE CoreJoVE BusinessJoVE Science EducationJoVE Lab ManualFaculty Resource CenterFaculty Site
Terms & Conditions of Use
Privacy Policy
Policies

Related Experiment Videos

SQLGEN: a framework for rapid client-server database application development

P M Nadkarni1, K H Cheung

  • 1Center for Medical Informatics, Yale University School of Medicine, New Haven, Connecticut 06510, USA.

Computers and Biomedical Research, an International Journal
|December 1, 1995
PubMed
Summary
This summary is machine-generated.

Related Concept Videos

You might also read

Related Articles

Articles linked to this work by shared authors, journal, and citation graph.

Sort by
Same author

Yuan-Hu Zhi Tong Prescription Mitigates Tau Pathology and Alleviates Memory Deficiency in the Preclinical Models of Alzheimer's Disease.

Frontiers in pharmacology·2020
Same author

Medical Informatics Training at Yale University School of Medicine.

Yearbook of medical informatics·2016
Same author

Relaxation effect of a novel Danshensu/tetramethylpyrazine derivative on rat mesenteric arteries.

European journal of pharmacology·2015
Same author

Adrenomedullin increases the short-circuit current in the mouse seminal vesicle: actions on chloride secretion.

Biology of reproduction·2014
Same author

Adrenomedullin increases the short-circuit current in the rat prostate: Receptors, chloride channels, the effects of cAMP and calcium ions and implications on fluid secretion.

Andrology·2014
Same author

Adrenomedullin increased the short-circuit current in the pig oviduct through chloride channels via the CGRP receptor: mediation by cAMP and calcium ions but not by nitric oxide.

Biology of reproduction·2013
Same journal

Wavelet domain nonlinear filtering for evoked potential signal enhancement.

Computers and biomedical research, an international journal·2001
Same journal

Time-frequency analysis of the RT and RR variability to stratify hypertrophic cardiomyopathy patients.

Computers and biomedical research, an international journal·2001
Same journal

Controlled auxotonic twitch in papillary muscle: a new computer-based control approach.

Computers and biomedical research, an international journal·2001
Same journal

Controlling for chance agreement in the validation of medical expert systems with no gold standard: PNEUMON-IA and RENOIR revisited.

Computers and biomedical research, an international journal·2001
Same journal

Artificial neural networks compared to factor analysis for low-dimensional classification of high-dimensional body fat topography data of healthy and diabetic subjects.

Computers and biomedical research, an international journal·2000
Same journal

On the parallelization of linkmap from the LINKAGE/FASTLINK package.

Computers and biomedical research, an international journal·2000
See all related articles

SQLGEN accelerates client-server relational database application development using an active data dictionary for dynamic SQL generation and user access control. This framework supports rapid prototyping and efficient deployment in biomedical databases.

Area of Science:

  • Computer Science
  • Database Management
  • Software Engineering

Background:

  • Client-server relational database applications require robust development frameworks.
  • Managing metadata and user access rights is crucial for efficient database operations.

Purpose of the Study:

  • To introduce SQLGEN, a framework designed for rapid client-server relational database application development.
  • To demonstrate SQLGEN's capability in generating dynamic SQL and managing user access control.

Main Methods:

  • Utilizing an active data dictionary on the client to store metadata from multiple database servers.
  • Generating dynamic Structured Query Language (SQL) for common database operations.
  • Implementing user access rights management for self-configuring client behavior.

Related Experiment Videos

Main Results:

  • SQLGEN enables rapid application prototyping and porting to client-server mode.
  • The framework dynamically generates SQL based on metadata and user permissions.
  • SQLGEN is successfully employed in several production biomedical databases.

Conclusions:

  • SQLGEN provides an efficient solution for developing client-server relational database applications.
  • The framework enhances development speed and user access control in database systems.
  • SQLGEN demonstrates practical utility in the biomedical domain.