Design Of Database Management System Research Articles

Penggunaan Metode System Development Life Cycle ( SDLC) dalam Analasis dan Perancangan Sistem Informasi Penerimaan Kas Sekolah

Implementation of Accounting Information System in educational institutions like school is important to do. With information system, delivery information accounting at school goes well on reach goals that determined before. School cash receipts with information accounting system should be support with information system for an effective administration process. Purpose of this research is give the solution about information system of school cash receipts to handle the problem in the system that has been applied. A plan with MYSQL and PHP application system passed through by DBMS (Database Management System),used for creating the management with accounting information system. With SDLC (System Development Life Cycle) method does for program school accounting of information system. Before used SDLC method,school used manual system that cause much trouble, one of them is data dissonance existence with cash receipts evidence. After the implementation of the SDLC method and a complete DBMS design can make it easier for programmers to implement into programming languages, can reduce errors and speed up work.

Energy-Aware Disk Storage Management : Online Approach with Application in DBMS

Energy consumption has become a first-class optimization goal in design and implementation of data-intensive computing systems. This is particularly true in the design of database management systems (DBMS), which was found to be the major consumer of energy in the software stack of modern data centers. Among all database components, the storage system is one of the most power-hungry elements. In previous work, dynamic power management (DPM) techniques that make real-time decisions to transition the disks to low-power modes are normally used to save energy in storage systems. In this paper, we tackle the limitations of DPM proposals in previous contributions. We introduced a DPM optimization model integrated with model predictive control (MPC) strategy to minimize power consumption of the disk-based storage system while satisfying given performance requirements. It dynamically determines the state of disks and plans for inter-disk data fragment migration to achieve desirable balance between power consumption and query response time. Via analyzing our optimization model to identify structural properties of optimal solutions, we propose a fast-solution heuristic DPM algorithm that can be integrated in large-scale disk storage systems for efficient state configuration and data migration. We evaluate our proposed ideas by running simulations using extensive set of synthetic workloads based on popular TPC benchmarks. Our results show that our solution significantly outperforms the best existing algorithm in both energy savings and response time.

Strategic planning and decision support in small-medium wood enterprises using database technology

As the enterprise management plays vital role in the overall performance of a company, it is recognized the need for application of quality improvement tools and techniques such as database technology. A DataBase Management System (DBMS) is an IT application, which contains information about the company in various levels. Enterprises can use DBMS to plan and standardize their practices and increase overall efficiency in the company. It is an essential management tool for Small and Medium-sized enterprises (SMEs) because in such companies the entrepreneur-owner is personally responsible for managing the activities of the company without being an expert. This modern information technology tool is the basis of the application of marketing principles and techniques via electronic media and more specifically the internet. The purpose of this paper is to explore how implementation of modern information technology tools, such as DBMS, simplifies SME management. That DBMS design approach can be a useful tool while designing similar applications in SME in wood sector and also in various issues in primary and secondary production sector.

Introduction to the Special Issue on Communication Issues in User–Database Interaction

Research on user–database interaction studies the communication issues among users with various roles, such as end-user, requirement analyst, database designer, query programmer, as well as between users and databases through various database management systems. Many topics are included. Common topics include the formal languages used in database models and queries, with focus on designer and user writing effectiveness and efficiency, as well as end-user comprehension and problem solving capabilities. Research results are generally applicable to the communication processes for users, user training, and the design of database management systems, such as query interfaces and choice of database models.

Content independence in multimedia databases

A database management system is a general-purpose software system that facilitates the processes of defining, constructing, and manipulating databases for various applications. This article investigates the role of data management in multimedia digital libraries, and its implications for the design of database management systems. The notions of content abstraction and content independence are introduced, which clearly expose the unique challenges (for database architecture) of applications involving multimedia search. A blueprint of a new class of database technology is proposed, which supports the basic functionality for the management of both content and structure of multimedia objects.

Content independence in multimedia databases

AbstractA database management system is a general‐purpose software system that facilitates the processes of defining, constructing, and manipulating databases for various applications. This article investigates the role of data management in multimedia digital libraries, and its implications for the design of database management systems. The notions of content abstraction and content independence are introduced, which clearly expose the unique challenges (for database architecture) of applications involving multimedia search. A blueprint of a new class of database technology is proposed, which supports the basic functionality for the management of both content and structure of multimedia objects.

Design of a multimedia object-oriented DBMS

The emerging multimedia information (such as video, image, voice, graphics) services have imposed many new requirements and research considerations on the design of database management systems (DBMSs). Conventionally, a multimedia DBMS is designed by developing a multimedia presentation layer on top of a pre-existing object-oriented DBMS (which can be truly object-oriented or relational-based), such that the core of the DBMS was developed earlier independent of the design of the multimedia presentation layer. Due to the fact that multimedia capabilities are not actually embedded in the DBMSs, such systems tend to provide only a rather limited set of functionalities in multimedia and are not satisfactory in supporting multimedia applications. This paper describes some key features of a multimedia object-oriented DBMS that is currently being developed. In this system the DBMS is carefully redesigned to provide special multimedia capabilities, such that the mismatch between the DBMS and the multimedia application layer can be eliminated. In particular, this paper will focus on unique multimedia capabilities including multimedia object modeling, video data management, and distributed collaboration.

Report on Workshop on Very Large Spatial Databases

On 19–22 July 1989, the National Center for Geographical Information and Analysis held the specialist Meeting of the Research Initiative on Very Large Spatial Databases (VLSBD) at Santa Barbara, CA. At this workshop, 42 participants from the U.S. and Europe discussed research issues related to the design of database management systems for geographic information systems and identified a long-term research agenda germane to the development of the next generation of geographic information system. This paper summarizes the discussions that took place.

An algebraic point of view of the data structures of database systems

We present a formalization of certain data structures involved in the design of database management systems starting from abstractizations of the notions of functional and multivalued dependencies in relational database systems (referred to as FD and MVD systems, respectively). The advantage of this abstract approach is a clarification of the essential properties of these data structures. Also, by identifying other objects which fit into the abstract concept we manage to transfer a number of intractable problems originating in graph theory and combinatorial set theory to the realm of relational databases.

Software features of DBMS kernel in large real-time EMS systems

Improvements made to a relational database management system (DBMS) developed for real-time energy management and control systems for electric utilities are described. The focus is on the software performance improvement features and the dual database concept for coordinated updates. The discussion covers task structuring, buffer usage, active restructuring, and presolving of access routes. Some of these features are applicable to other real-time systems with large databases shared by many application programs. The extension of the DBMS design for use in a hierarchical real-time system is described. >