Typical applications of a microcomputer database manager to power system problems

Journal Article · Sat Aug 01 04:00:00 EDT 1987 · IEEE Trans. Power Syst.; (United States)

DOI:https://doi.org/10.1109/TPWRS.1987.4335213· OSTI ID:6256367

Rao, N D

This paper reports on the application of a popular DBMS (database management system) to the solution of selected problems in Power Systems with the IBM Personal Computer in the context of the Power Engineering Curriculum at the University of Calgary. The problems selected are inductance and capacitance calculations of overhead transmission lines and per unit calculations for large power networks. These examples illustrate how to structure, organize, manipulate and query a database and also use it to service one or more independent application program modules to perform specific tasks without unnecessary data duplication. The power and flexibility of command file programming involving multiple database file access as well as program demodulation are also shown. The application programs developed in the paper amply demonstrate not only the benefits of the built-in query language, but also the ability of the DBMS to interface these programs with one or several database files. Because of these versatile features, microcomputer database management systems hold considerable promise as important, cost effective supplementary tools to conventional programming for power utilities as well.

• Research Organization: Dept. of Electrical Engineering, The Univ. of Calgary, Calgary, Alberta T2N 1N4
• OSTI ID: 6256367
• Journal Information: IEEE Trans. Power Syst.; (United States), Journal Name: IEEE Trans. Power Syst.; (United States) Vol. PWRS-2:3; ISSN ITPSE
• Country of Publication: United States
• Language: English

Related Subjects

29 ENERGY PLANNING, POLICY, AND ECONOMY
296000* -- Energy Planning & Policy-- Electric Power
99 GENERAL AND MISCELLANEOUS
990220 -- Computers
Computerized Models
& Computer Programs-- (1987-1989)
COMPUTERS
DATA BASE MANAGEMENT
DIGITAL COMPUTERS
ELECTRIC UTILITIES
ELECTRONIC CIRCUITS
ENERGY SYSTEMS
IBM COMPUTERS
INFORMATION RETRIEVAL
LOAD MANAGEMENT
MANAGEMENT
MICROELECTRONIC CIRCUITS
MICROPROCESSORS
PERSONAL COMPUTERS
POWER SYSTEMS
PROGRAMMING
PROGRAMMING LANGUAGES
PUBLIC UTILITIES