Flexible Security and Search Capability for a Relational Database with Externally Linked Multimedia Data Files

Recently, a prototype relational database system has been developed that has the capability of storing and querying analog and video information for interaction with data analysis applications [8]. The system provides for numerous querying categories via indexed meta-data using pre-filled, drop-own combo boxes. A shortcoming of the design is the growing number of categories that could in time become unmanageable. One purpose of this study was to explore a more flexible design that would reduce the number of categories for storing and querying the database. In this design, the user enters a compound, logical query statement with the desired keywords in addition to using the existing combo boxes. This proved to be a more efficient and flexible strategy for accommodating expanding search categories. Another purpose of this study was to add security features in accessing database information to restrict sharing of information about subject populations. This has become an important requirement in accessing subject information in research studies. To this end we have developed an easily reusable security hierarchy in which individual users and groups of users can be granted rights to objects of the system e.g., database tables or user interface tabs. The permissions granted to a user are dynamically updated by group permissions as the user joins or leaves these groups. The initial implementation of security features has proven to be efficiently handled by the interface. Thus, a prototype for a flexible and secure database querying capability has been implemented that can be scaled to meet the expanding needs of researchers

Relational Database Linkage of Scientific Applications and Their Data Files

Abstract- Research in computational neuroscience has been following a model-based approach where data is comprised of digitized streams of sampled analog data, images and voice. The data are generally contained in files and specialized programs are used to analyze the data. In this study we developed a prototype system for indexing and retrieving information for use by an application that analyzes data. The data in the files consist of channels derived from analog and event driven sources. It is also linked to video images associated with the data acquisition. In this research, we developed an indexing capability that threads into the data acquisition and analysis programs to give the system a broad data base capability. We designed tables and relations within the database for indexing the files and information contained within the file. The system has the potential of giving us retrieval capabilities that include analog, event, and video data types. I