Journal articles: 'Database Management System (DBMS)'

1

Van Aken, Dana, Dongsheng Yang, Sebastien Brillard, Ari Fiorino, Bohan Zhang, Christian Bilien, and Andrew Pavlo. "An inquiry into machine learning-based automatic configuration tuning services on real-world database management systems." Proceedings of the VLDB Endowment 14, no. 7 (March 2021): 1241–53. http://dx.doi.org/10.14778/3450980.3450992.

Full text

Abstract:

Modern database management systems (DBMS) expose dozens of configurable knobs that control their runtime behavior. Setting these knobs correctly for an application's workload can improve the performance and efficiency of the DBMS. But because of their complexity, tuning a DBMS often requires considerable effort from experienced database administrators (DBAs). Recent work on automated tuning methods using machine learning (ML) have shown to achieve better performance compared with expert DBAs. These ML-based methods, however, were evaluated on synthetic workloads with limited tuning opportunities, and thus it is unknown whether they provide the same benefit in a production environment. To better understand ML-based tuning, we conducted a thorough evaluation of ML-based DBMS knob tuning methods on an enterprise database application. We use the OtterTune tuning service to compare three state-of-the-art ML algorithms on an Oracle installation with a real workload trace. Our results with OtterTune show that these algorithms generate knob configurations that improve performance by 45% over enterprise-grade configurations. We also identify deployment and measurement issues that were overlooked by previous research in automated DBMS tuning services.

APA, Harvard, Vancouver, ISO, and other styles

2

Győrödi, Cornelia A., Diana V. Dumşe-Burescu, Doina R. Zmaranda, Robert Ş. Győrödi, Gianina A. Gabor, and George D. Pecherle. "Performance Analysis of NoSQL and Relational Databases with CouchDB and MySQL for Application’s Data Storage." Applied Sciences 10, no. 23 (November 28, 2020): 8524. http://dx.doi.org/10.3390/app10238524.

Full text

Abstract:

In the current context of emerging several types of database systems (relational and non-relational), choosing the type and database system for storing large amounts of data in today’s big data applications has become an important challenge. In this paper, we aimed to provide a comparative evaluation of two popular open-source database management systems (DBMSs): MySQL as a relational DBMS and, more recently, as a non-relational DBMS, and CouchDB as a non-relational DBMS. This comparison was based on performance evaluation of CRUD (CREATE, READ, UPDATE, DELETE) operations for different amounts of data to show how these two databases could be modeled and used in an application and highlight the differences in the response time and complexity. The main objective of the paper was to make a comparative analysis of the impact that each specific DBMS has on application performance when carrying out CRUD requests. To perform the analysis and to ensure the consistency of tests, two similar applications were developed in Java, one using MySQL and the other one using CouchDB database; these applications were further used to evaluate the time responses for each database technology on the same CRUD operations on the database. Finally, a comprehensive discussion based on the results of the analysis was performed that centered on the results obtained and several conclusions were revealed. Advantages and drawbacks for each DBMS are outlined to support a decision for choosing a specific type of DBMS that could be used in a big data application.

APA, Harvard, Vancouver, ISO, and other styles

3

Liu, Fan Ming, Xing Wei, and Fang Ming Li. "Structure Design of the Database in the INS/Database Matching Navigation System." Advanced Materials Research 760-762 (September 2013): 1930–35. http://dx.doi.org/10.4028/www.scientific.net/amr.760-762.1930.

Full text

Abstract:

Using the geophysical field data matching navigation could improve the concealment of the underwater vehicle, and it is also an important navigation technology in the future. Using the database to save the navigation data not only could overcome the drawbacks when using the files to storage the data but also integrated the different database together. The QNX Database is used to be the database management system (DBMS) of the INS/Database matching navigation system. According to the needs of the INS/Database matching navigation system and the relationship of the geophysical field data, the structure of geophysical field data database is designed and implemented. The result shows that the DBMS has well real-time performance, reliability and scalability. It meets the requirements of the DBMS.

APA, Harvard, Vancouver, ISO, and other styles

4

Ansari, Sakil Ahmad, and Jaychand Vishwakarma. "Survey on Database Concurrency Control in Multilevel Secure Database Management Systems." International Journal of Advanced Research in Computer Science and Software Engineering 8, no. 4 (April 30, 2018): 105. http://dx.doi.org/10.23956/ijarcsse.v8i4.645.

Full text

Abstract:

Transactions are vital for database management systems (DBMSs) because they provide transparency to concurrency and failure. Concurrent execution of transactions may lead to contention for access to data, which in a multilevel secure DBMS (MLSIDBMS) may lead to insecurity. In this paper we examine security issues involved in database concurrency control for MLS/DBMSs and show how a scheduler can affect security. We introduce Data Conflict Security; (DC-Security) a property that implies a system is free of convert channels due to contention for access to data. We present a definition of DC Security based on noninterference. Two properties that constitute a necessary condition for DC-Security are introduced along with two other simpler necessary conditions. We have identified a class of schedulers we call Output-State-Equivalent for which another criterion implies DC-Security. The criterion considers separately the behavior of the scheduler in response to those inputs that cause rollback and those that do not. We characterize the security properties of several existing scheduling protocols and find many to be insecure

APA, Harvard, Vancouver, ISO, and other styles

5

Mohd Yunus, Mohd Amin, Sonniaa K. V. Gopala Krishnan, Nazri Mohd Nawi, and Ely Salwana Mat Surin. "Study on Database Management System Security Issues." JOIV : International Journal on Informatics Visualization 1, no. 4-2 (November 30, 2017): 192. http://dx.doi.org/10.30630/joiv.1.4-2.76.

Full text

Abstract:

The study is about the security system of database management (DBMS) and proposed method. Information is an essential element in database management system where the users trust service providers will have a secure system to protect and prevent their information from malicious attack or stealing information. There are few types of technique applied to enhance the database security level.

APA, Harvard, Vancouver, ISO, and other styles

6

Vishwakarma, Jaychand, and Abhishek Shukla. "Survey on Security Issues and Their Techniques in DBMS." International Journal of Advanced Research in Computer Science and Software Engineering 8, no. 1 (January 30, 2018): 124. http://dx.doi.org/10.23956/ijarcsse.v8i1.544.

Full text

Abstract:

Nowadays a Database security has become an important issue in technical world. The main objective of database security is to forbid unnecessary information exposure and modification data while ensuring the availability of the needed services. A numbers of security methods have been created for protecting the databases. Many security models have been developed based on different security aspects of database. All of these security methods are useful only when the database management system is designed and developing for protecting the database. Recently the growth of web application with database at its backend Secure Database Management System is more essential than only a Secure Database. Therefore this paper highlight on the Threats, Security Methods and Vulnerabilities in Database Management System with the help of survey performed on the field of secure databases.

APA, Harvard, Vancouver, ISO, and other styles

7

TRIGANO, PHILIPPE, JEAN-PAUL BARTHES, CATHERINE GREBOVAL, and FRANÇOIS VALLERNAUD. "QUERYING AN OBJECT-ORIENTED DATABASE USING FREE LANGUAGE." International Journal of Pattern Recognition and Artificial Intelligence 04, no. 03 (September 1990): 429–45. http://dx.doi.org/10.1142/s0218001490000265.

Full text

Abstract:

A man-machine interface in natural language for a DataBase Management System (DBMS) called VORAS, based upon semantics, is presented. This DBMS can also be used for knowledge representation, and is well-suited to the design of queries in natural language. The system VORAS is an object-oriented DBMS developed from a specific model of representation called the Property Driven Model (PDM). A user may write a query in natural language. Most of the analysis is done at a semantic level. A syntactic level has been added, to improve the performance of the system. However, it is still possible to use a short-hand style.

APA, Harvard, Vancouver, ISO, and other styles

8

Anjard, Ronald P. "The Basics of Database Management Systems (DBMS)." Industrial Management & Data Systems 94, no. 5 (June 1994): 11–15. http://dx.doi.org/10.1108/02635579410063261.

Full text

APA, Harvard, Vancouver, ISO, and other styles

9

Koishibayev, Timur, and Zhanat Umarova. "Cryptanalysis of Password Protection of Oracle Database Management System (DBMS)." Journal of Physics: Conference Series 710 (April 2016): 012003. http://dx.doi.org/10.1088/1742-6596/710/1/012003.

Full text

APA, Harvard, Vancouver, ISO, and other styles

10

O., Orlunwo Placida, and Prince Oghenekaro A. "DISTRIBUTED DATABASE MANAGEMENT SYSTEM (DBMS) ARCHITECTURES AND DISTRIBUTED DATA INDEPENDENCE." International Journal of Computer Science and Mobile Computing 10, no. 1 (January 28, 2021): 23–48. http://dx.doi.org/10.47760/ijcsmc.2021.v10i01.004.

Full text

APA, Harvard, Vancouver, ISO, and other styles

11

Thüm, Thomas, Sandro Schulze, Mario Pukall, Gunter Saake, and Sebastian Günther. "Secure and Customizable Data Management for Automotive Systems: A Feasibility Study." ISRN Software Engineering 2012 (March 18, 2012): 1–7. http://dx.doi.org/10.5402/2012/424230.

Full text

Abstract:

Custom tailor-made database management systems (DBMS) are an essential asset, especially for embedded systems. The continuously increasing amount of data in automotive systems and the growing network of embedded devices can profit from DBMS. Restrictions in terms of processors, memory, and storage require customizable DBMS that contain only the needed functionality. We present AutoDaMa, a customizable DBMS designed for automotive systems. With AutoDaMa, it is possible to generate tailor-made DBMS for different scenarios, for example, by restricting the storage size of the DBMS or adding security-related features such as asymmetric and symmetric encryption. We demonstrate the feasibility of our approach through applying different tailor-made DBMS versions derived from AutoDaMa in an automotive testing environment. Our experience is that AutoDaMa can dramatically reduce the development effort and can increase reliability using efficient reuse mechanisms.

APA, Harvard, Vancouver, ISO, and other styles

12

Huda, M. Misbachul, Dian Rahma Latifa Hayun, and Zhin Martun. "Data Modeling for Big Data." Jurnal ULTIMA InfoSys 6, no. 1 (December 1, 2015): 1–11. http://dx.doi.org/10.31937/si.v6i1.273.

Full text

Abstract:

Today the rapid growth of the internet and the massive usage of the data have led to the increasing CPU requirement, velocity for recalling data, a schema for more complex data structure management, the reliability and the integrity of the available data. This kind of data is called as Large-scale Data or Big Data. Big Data demands high volume, high velocity, high veracity and high variety. Big Data has to deal with two key issues, the growing size of the datasets and the increasing of data complexity. To overcome these issues, today researches are devoted to kind of database management system that can be optimally used for big data management. There are two kinds of database management system, relational database management system and nonrelational system that can be optimally used for big data management. There are two kinds of database management, Relational Database Management and Non-relational Database Management. This paper will give reviews about these two database management system, including description, vantage, structure and the application of each DBMS. Index Terms - Big Data, DBMS, Large-scale Data, Non-relational Database, Relational Database.

APA, Harvard, Vancouver, ISO, and other styles

13

Glass, Alan J., and Neal M. Holtz. "A relational database for building structures." Canadian Journal of Civil Engineering 13, no. 5 (October 1, 1986): 528–34. http://dx.doi.org/10.1139/l86-080.

Full text

Abstract:

This paper looks at some of the requirements of a database for building structure data and the role of the building structure database in an integrated design system. A method of representing the necessary building structure data in a relational database is discussed. The basic data manipulation commands for relational databases are briefly explained. A demonstration database for a steel structure implemented on a microcomputer using a commercial relational database is presented. Key words: computer-aided design (CAD), database, database management system (DBMS), relational database, engineering database, building description.

APA, Harvard, Vancouver, ISO, and other styles

14

Neto, Afonso Araújo, and Marco Vieira. "Security Gaps in Databases." International Journal of Secure Software Engineering 2, no. 3 (July 2011): 42–62. http://dx.doi.org/10.4018/jsse.2011070103.

Full text

Abstract:

When deploying database-centric web applications, administrators should pay special attention to database security requirements. Acknowledging this, Database Management Systems (DBMS) implement several security mechanisms that help Database Administrators (DBAs) making their installations secure. However, different software products offer different sets of mechanisms, making the task of selecting the adequate package for a given installation quite hard. This paper proposes a methodology for detecting database security gaps. This methodology is based on a comprehensive list of security mechanisms (derived from widely accepted security best practices), which was used to perform a gap analysis of the security features of seven software packages composed by widely used products, including four DBMS engines and two Operating Systems (OS). The goal is to understand how much each software package helps developers and administrators to actually accomplish the security tasks that are expected from them. Results show that while there is a common set of security mechanisms that is implemented by most packages, there is another set of security tasks that have no support at all in any of the packages.

APA, Harvard, Vancouver, ISO, and other styles

15

Frost, R. D., and M. L. Gillenson. "Integrated Clinical Decision Support Using an Object-Oriented Database Management System." Methods of Information in Medicine 32, no. 02 (1993): 154–60. http://dx.doi.org/10.1055/s-0038-1634908.

Full text

Abstract:

Abstract:Clinical decision support systems assist in diagnosis, alert to abnormal conditions, and manage patient data. Such systems tend to emphasize one of these features at the expense of the others and tend to be developed on an ad hoc basis. In this work, a technique is developed for creating an integrated clinical decision support system wholly within a general-purpose object-oriented database management system. The diagnostic and alerting requirements are accomplished with encapsulated methods and a novel use of the object-oriented database management class-hierarchy structure. The patient data management requirement is satisfied by the normal data management capabilities of the object-oriented DBMS.

APA, Harvard, Vancouver, ISO, and other styles

16

Berski, Szymon, and Martyna Bilau. "Safety Mechanisms in Relational Database as Part of the IT System of the Enterprise." New Trends in Production Engineering 2, no. 2 (December 1, 2019): 12–23. http://dx.doi.org/10.2478/ntpe-2019-0068.

Full text

Abstract:

Abstract The work examines the effectiveness of the replication mechanism of the X production company database. In order to extend the functionality of the computer database of the enterprise, a model of its resource flow was created and an intensional and extensional part was created for a test database based on real enterprise resources. The model has been simplified to 3-rd normal form. The implementation was done in the MySQL database system. Two different operating systems were selected for testing: Windows and Linux. The database management system (DBMS) is working under the GPL license. MySQL DBMS offers many security mechanisms, and to secure the database, system of users permissions to objects have been selected and also an encryption of access passwords for users and connections to servers was used. A replication engine based on the binary log and the model “main server and backup server” was used to create a copy of the enterprise data.

APA, Harvard, Vancouver, ISO, and other styles

17

Hwang, Jongsu. "Moving-Object management method of combat system using main memory DBMS." Ciencia y tecnología de buques 9, no. 18 (January 29, 2016): 63. http://dx.doi.org/10.25043/19098642.129.

Full text

Abstract:

The naval combat management system conducts a comprehensive analysis of obtained information and integrates it with on-board sensors, weapons, and other equipment. Furthermore, it automatically performs all processes such as engagement plans, weapon assignments, and target detection using already pre-deployed database information. Thus, it is important to manage moving objects from many different kinds of sensors. In this paper, we will introduce the Moving-Object management method of combat systems using the In Moving Object DBMS. This is based on the main memory database technology provided by the high speed transaction processing performance.

APA, Harvard, Vancouver, ISO, and other styles

18

Warman, Indra, and Wildani Wildani. "ANALISA KINERJA QUERY STORED PROCEDURE PADA DATABASE MANAGEMENT SYSTEM (DBMS) MYSQL." Jurnal Sains dan Teknologi: Jurnal Keilmuan dan Aplikasi Teknologi Industri 21, no. 1 (June 30, 2021): 58. http://dx.doi.org/10.36275/stsp.v21i1.366.

Full text

APA, Harvard, Vancouver, ISO, and other styles

19

Popov, A. "Automated Workplace for Operational Duty Shift of Crisis Management Center (CMC) of EMERCOM of Russia." Safety in Technosphere 9, no. 2 (March 16, 2021): 37–42. http://dx.doi.org/10.12737/1998-071x-2021-9-2-37-42.

Full text

Abstract:

The process and expected results of implementation and development of automated workplace (AWP) for the administrator (AWP- Administrator) of the operational duty shift (ODS) for the Crisis Management Center (CMC) of EMERCOM of Russia have been considered. The structure, functions and basic operations of interaction with the "AWP- Administrator" of CMC ODS, which is an AWP in the database management system (DBMS) of ODS AWP - "ODS AWP DBMS" and provides the automation of CMC ODS AWP user technical support, database (DB) structure formation, enhancement of existing and development of new CMC ODS AWP. Have been justified the prospects of EMERCOM of Russia’s CMC ODS "ARM – Administrator" implementation for organization of the process of CMC ODS AWP user technical support, “ODS AWP DBMS” information updating, enhancement of existing and development of the new CMC ODS AWP.

APA, Harvard, Vancouver, ISO, and other styles

20

Frénot, S., and F. Laforest. "Medical Record Management Systems: Criticisms and New Perspectives." Methods of Information in Medicine 38, no. 02 (1999): 89–95. http://dx.doi.org/10.1055/s-0038-1634179.

Full text

Abstract:

AbstractThe first generation of computerized medical records stored the data as text, but these records did not bring any improvement in information manipulation. The use of a relational database management system (DBMS) has largely solved this problem as it allows for data requests by using SQL. However, this requires data structuring which is not very appropriate to medicine. Moreover, the use of templates and icon user interfaces has introduced a deviation from the paper-based record (still existing). The arrival of hypertext user interfaces has proven to be of interest to fill the gap between the paper-based medical record and its electronic version. We think that further improvement can be accomplished by using a fully document-based system. We present the architecture, advantages and disadvantages of classical DBMS-based and Web/DBMS-based solutions. We also present a document-based solution and explain its advantages, which include communication, security, flexibility and genericity.

APA, Harvard, Vancouver, ISO, and other styles

21

Diallo, B., J. M. Travere, and B. Mazoyer. "A Review of Database Management Systems Suitable for Neuroimaging." Methods of Information in Medicine 38, no. 02 (1999): 132–39. http://dx.doi.org/10.1055/s-0038-1634174.

Full text

Abstract:

AbstractThis study comprises a technical assessment of Database Management Systems (DBMS), which may be of use in the analysis of data obtained from human brain mapping procedures. Due to the large expansion of the neuroimaging field, the use of specialized database software to store and process neuroimages and their attached components is inevitable. The advent of multiple software products, a wealth of technical terms and a wide variety of other applications make the choice of a suitable program sometimes difficult. Through the inclusion of some basic and pertinent criteria (e.g., performance, ease of opening, standardization and portability), we present a descriptive comparison of 12 DBMSs currently available in the commercial and public domain. We have compared and tested three main architecture models which are currently available and assessed their potential applications for imaging purposes: relational, object-oriented, and hybrid. The findings of our study demonstrated that the Illustra™ software was the best suited for a neuroimaging environment because of its intrinsic ability to handle complex and large objects, such as 3D volumes or geometric structures.

APA, Harvard, Vancouver, ISO, and other styles

22

Ye, Qiong Wei, Guang Xing Song, Yu Hui Feng, and Qiu Yun Nie. "A Research of Principle and Application of Communication Interface between MBMS and DBMS in DDS." Key Engineering Materials 474-476 (April 2011): 478–83. http://dx.doi.org/10.4028/www.scientific.net/kem.474-476.478.

Full text

Abstract:

The communication interface technology of Model Base Management System (MBMS) and Database Management System (DBMS) is one of the key technologies for successful implementation of Decision Support System (DSS). This paper firstly introduces the concept model of communication interface between MBMS and BMS in DDS. Then it makes an analysis of the principle of communication interface between MBMS and BMS in DDS. Based on the analysis, three ways of its implementation are proposed: Standard Format Method, Function Method and Embedding Method, which finally realize the ODBC-based application of communication between MBMS and DBMS in DSS. This paper is of great reference significance for solving communication problems among database, model base, data warehouse, knowledge base, expert base and method base, and for accessing heterogeneous data or even extreme data in such emerging Decision Support Systems as Distributed DSS, Group DSS and Intelligent DSS.

APA, Harvard, Vancouver, ISO, and other styles

23

Widiono, Suyud. "Experiments and Descriptive Analysis in The MariaDB Database Cluster System to Prepare Data Availability." International Journal of Engineering Technology and Natural Sciences 1, no. 1 (July 12, 2019): 42–48. http://dx.doi.org/10.46923/ijets.v1i1.24.

Full text

Abstract:

A database server called the Database Management System (DBMS) that relates tables in a database is called the Relational Database Management System (RDBMS). DBMS/RDBMS is a computer program that provides data services for computers or other computer programs. One of the RDBMS type database server (hereinafter referred to as a database server) is MariaDB. The database server is in charge of managing and providing data, so data must always be ready, fast presented, accurate, and safe, it cannot be damaged or even lost. One way to provide this data is to install several database servers using the concept of replication in the Multiple Server Database system. Replication in a cluster server database is a method of installing several database server nodes that allow between node servers to copy each other and distribute data from one node to another database server node, which then synchronizes data between server nodes to maintain data consistency. This study looks for the most optimal number of minimal database server nodes to provide accurate, fast and safe data on the MariaDB Cluster RDBMS. From the results of the replication test from the cluster server database, it can be concluded that the number of 3 (three) node servers can be known to always synchronize and consistency of data between server nodes, so there are 3 (three) nodes of minimum database node with MariaDB RDBMS.

APA, Harvard, Vancouver, ISO, and other styles

24

FERREIRA, RENATO, TAHSIN KURC, MICHAEL BEYNON, CHIALIN CHANG, ALAN SUSSMAN, and JOEL SALTZ. "OBJECT-RELATIONAL QUERIES INTO MULTIDIMENSIONAL DATABASES WITH THE ACTIVE DATA REPOSITORY." Parallel Processing Letters 09, no. 02 (June 1999): 173–95. http://dx.doi.org/10.1142/s0129626499000190.

Full text

Abstract:

As computational power and storage capacity increase, processing and analyzing large volumes of multi-dimensional datasets play an increasingly important role in many domains of scientific research. Scientific applications that make use of very large scientific datasets have several important characteristics: datasets consist of complex data and are usually multi-dimensional; applications usually retrieve a subset of all the data available in the dataset; various application-specific operations are performed on the data items retrieved. Such applications can be supported by object-relational database management systems (OR-DBMSs). In addition to providing functionality to define new complex datatypes and user-defined functions, an OR-DBMS for scientific datasets should contain runtime support that will provide optimized storage for very large datasets and an execution environment for user-defined functions involving expensive operations. In this paper we describe an infrastructure, the Active Data Repository (ADR), which provides framework for building databases that enables integration of storage, retrieval and processing of multi-dimensional datasets on a parallel machine. The system architecture of ADR provides the functionality required from runtime support for an OR-DBMS that stores and processes scientific multi-dimensional datasets. We present the system architecture of the ADR, and experimental performance results for three applications implemented using ADR.

APA, Harvard, Vancouver, ISO, and other styles

25

Wang, Hui, and Lian Zhong Liu. "A Realization of Security Model on Unified Database Console." Advanced Materials Research 756-759 (September 2013): 3584–89. http://dx.doi.org/10.4028/www.scientific.net/amr.756-759.3584.

Full text

Abstract:

As an extremely important platform of data storage, database management system (DBMS) is widely used in all kinds of enterprises and departments. The availability and security is a critical performance index for database. How to help administrator keep database secure and effective is a key job of database administration. This paper proposes a secure model of database management for administrator and achieved a secure database console to implement this model.

APA, Harvard, Vancouver, ISO, and other styles

26

Tahat, Amani, and Wa el Sala. "Comprehensive online Atomic Database Management System (DBMS) with Highly Qualified Computing Capabilities." International Journal of Database Management Systems 3, no. 2 (May 31, 2011): 1–20. http://dx.doi.org/10.5121/ijdms.2011.3201.

Full text

APA, Harvard, Vancouver, ISO, and other styles

27

Pang, Cun Chen, Feng Xu, Dun Wen Zuo, and X. J. Wu. "The Establishment of an Optimized Parameters Database Management System for MPCB Milling." Key Engineering Materials 426-427 (January 2010): 555–58. http://dx.doi.org/10.4028/www.scientific.net/kem.426-427.555.

Full text

Abstract:

Microwave printed circuit board (MPCB) is a typical difficult-to-machine material because the ceramic particle bonded with polytetrafluoroethylene (PTFE) has high strength and hardness in its insulation layer. Research on MPCB milling parameter optimization is carried out in this paper. The maximum material removal rate is selected as the objective function, considering the constraints of machine tool, cutting tool and processing requirements. An optimization program is compiled by Matlab and the genetic algorithm (GA) toolbox (gatbx). A cutting database is set up by Access software. An optimal milling parameters database management system (DBMS) based on Browser/Server (B/S) structure is developed by ASP technique and Dreamweaver software.

APA, Harvard, Vancouver, ISO, and other styles

28

Kawai, Yusuke, Jing Zhao, Kento Sugiura, Yoshiharu Ishikawa, and Yukiko Wakita. "An Analysis Technique of Evacuation Simulation Using an Array DBMS." Journal of Disaster Research 13, no. 2 (March 19, 2018): 338–46. http://dx.doi.org/10.20965/jdr.2018.p0338.

Full text

Abstract:

Today, large-scale simulations are thriving because of the increase of computating performance and storage capacity. Understanding the results of these simulations is not easy, and hence, support for interactive and exploratory analysis is becoming more important. This study focuses on spatio-temporal simulations and attempts to develop an analysis technology to support them. It uses a database system for supporting interactive analysis of large-scale data. Since the data gained via spatio-temporal simulations is not suitable for management in a relational DBMS (RDBMS), this study uses an array DBMS, a type of DBMS that has been garnering increased attention in recent years. An array DBMS is designed for the management of large-scale array data; it provides a logical model for array data, yet it also supports efficient query processing. SciDB is used as our specific array DBMS in this paper. This study targets disaster evacuation simulation data and demonstrates via experimentation that the query-processing functions offered by an array DBMS provide effective analysis support.

APA, Harvard, Vancouver, ISO, and other styles

29

Basu, Aniruddha. "Post Boost Track Processing Using Conventional DBMS Software." Defence Science Journal 66, no. 2 (March 23, 2016): 130. http://dx.doi.org/10.14429/dsj.66.9244.

Full text

Abstract:

The design of air defence, traditional command control system is very challenging which has been used with basic methodologies. Traditional design is associated with unstructured and uncorrelated data and requires huge lines of code using hard disk drive (HDD) in the system. Hence an attempt was made for a better simplified database management system (DBMS) software data access methodology, which processed the incoming airborne data, message in RDBMS database to achieve full automation on real-time. The transaction is accomplished through SQL pass through method from the host decision making system into database. An algorithm of track identification during midcourse track separation was undertaken for prototype development on DBMS data access methodology. In this methodology Oracle C++ calls interface embedded query call was used from the host interface system. The purpose of this development was to find a comparison of online process timing between HDD and SSD using commercial database, and to evaluate performance of dynamic processing of RDBMS Database for identification of target vehicle and booster after separation. Produced experimentation results from improved performance of the proposed methodology on which futuristic command control system can rely.

APA, Harvard, Vancouver, ISO, and other styles

30

N, Sai Tanishq. "Machine Learning for Database Management Systems." International Journal of Engineering and Computer Science 9, no. 08 (August 19, 2020): 25132–47. http://dx.doi.org/10.18535/ijecs/v9i08.4520.

Full text

Abstract:

Machine Learning (ML) is transforming the world with research breakthroughs that are leading to the progress of every field. We are living in an era of data explosion. This further improves the output as data that can be fed to the models is more than it has ever been. Therefore, prediction algorithms are now capable of solving many of the complex problems that we face by leveraging the power of data. The models are capable of correlating a dataset and its features with an accuracy that humans fail to achieve. Bearing this in mind, this research takes an in-depth look into the of the problem- solving potential of ML in the area of Database Management Systems (DBMS). Although ML hallmarks significant scientific milestones, the field is still in its infancy. The limitations of ML models are also studied in this paper.

APA, Harvard, Vancouver, ISO, and other styles

31

Győrödi, Cornelia A., Diana V. Dumşe-Burescu, Robert Ş. Győrödi, Doina R. Zmaranda, Livia Bandici, and Daniela E. Popescu. "Performance Impact of Optimization Methods on MySQL Document-Based and Relational Databases." Applied Sciences 11, no. 15 (July 23, 2021): 6794. http://dx.doi.org/10.3390/app11156794.

Full text

Abstract:

Databases are an important part of today’s applications where large amounts of data need to be stored, processed, and accessed quickly. One of the important criteria when choosing to use a database technology is its data processing performance. In this paper, some methods for optimizing the database structure and queries were applied on two popular open-source database management systems: MySQL as a relational DBMS, and document-based MySQL as a non-relational DBMS. The main objective of this paper was to conduct a comparative analysis of the impact that the proposed optimization methods have on each specific DBMS when carrying out CRUD (CREATE, READ, UPDATE, DELETE) requests. To perform the analysis and performance evaluation of CRUD operations for different amounts of data, a case study testing architecture based on Java was developed and used to show how the databases’ proposed optimization methods can influence the performance of the application, and to highlight the differences in response time and complexity. The results obtained show the degree to which the proposed optimization methods contributed to the application’s performance improvement in the case of both databases; based on these, a detailed analysis and several conclusions are presented to support a decision for choosing a specific approach.

APA, Harvard, Vancouver, ISO, and other styles

32

Luo, Shi Yong, Wen Cai Xu, Li Xia Huo, Xin Lin Zhang, and Jia Yun Zhang. "A Computer Software on Diffusion in Solid." Advanced Materials Research 267 (June 2011): 410–13. http://dx.doi.org/10.4028/www.scientific.net/amr.267.410.

Full text

Abstract:

A computer software on solid/solid reaction kinetics, KinPreSSR, is one of subsystems in the software, Intellectualized Database Management System on Kinetics of Metallurgy (IDMSKM). KinPreSSR is a Windows application developed using Visual C++ and FoxPro, and includes two main modules, “DIFFUSION” and “REACTION”. The ‘DIFFUSION’ module includes two sub-modules of “database management system (DBMS)” and "Evaluation & prediction". The “DBMS” deals with the diffusion coefficients gathered from reported documents and the data evaluated according to some rules, besides, it can provide users with retrieval of diffusion coefficients. Based on the solutions to the Fick’s first law and the Fick’s second law in the four typical critical conditions, the "Evaluation & prediction" sub-module gives the predication of concentration distribution after diffusion process in solids or computation for diffusion coefficient.

APA, Harvard, Vancouver, ISO, and other styles

33

Menshikov, V. V. "Lesson on the theme "Database management systems. Sorting. Requests to select data"." Informatics in school 1, no. 1 (March 18, 2021): 9–19. http://dx.doi.org/10.32517/2221-1993-2021-20-1-9-19.

Full text

Abstract:

The article presents one of the lessons of the "Databases" section of the ninth grade informatics course. This lesson explores such concepts as "DBMS", "sorting", "filter", "selection", "request". Methods of sorting information in a database are considered, as well as methods of searching for information in a database using filters and requests. The content of the lesson corresponds to the teaching materials on informatics for the ninth grade of L. L. Bosova, A. Yu. Bosova. A feature of the presented lesson is that it is intended for students studying at a cadet school (cadets), therefore a military component has been added to it — the examples of databases considered in the lesson are related to aviation. The databases, on the example of which the educational material of the lesson is considered, is a database containing information about the characteristics of aircraft of the USSR and Russia, and a database containing information about flights that are operated from Moscow Domodedovo and Sheremetyevo airports.

APA, Harvard, Vancouver, ISO, and other styles

34

Kahn, M. G., L. M. Fagan, and S. Tu. "Extensions to the Time-Oriented Database Model to Support Temporal Reasoning in Medical Expert Systems." Methods of Information in Medicine 30, no. 01 (1991): 04–14. http://dx.doi.org/10.1055/s-0038-1634816.

Full text

Abstract:

Physicians faced with diagnostic and therapeutic decisions must reason about clinical features that change over time. Database-management systems (DBMS) can increase access to patient data, but most systems are limited in their ability to store and retrieve complex temporal information. The Time-Oriented Databank (TOD) model, the most widely used data model for medical database systems, associates a single time stamp with each observation. The proper analysis of most clinical data requires accounting for multiple concurrent clinical events that may alter the interpretation of the raw data. Most medical DBMSs cannot retrieve patient data indexed by multiple clinical events. We describe two logical extensions to TOD-based databases that solve a set of temporal reasoning problems we encountered in constructing medical expert systems. A key feature of both extensions is that stored data are partitioned into groupings, such as sequential clinical visits, clinical exacerbations, or other abstract events that have clinical decision-making relevance. The temporal network (TNET) is an object-oriented database that extends the temporal reasoning capabilities of ONCOCIN, a medical expert system that provides chemotherapy advice. TNET uses persistent objects to associate observations with intervals of time during which “an event of clinical interest” occurred. A second object-oriented system, called the extended temporal network (ETNET), is both an extension and a simplification of TNET. Like TNET, ETNET uses persistent objects to represent relevant intervals; unlike the first system, however, ETNET contains reasoning methods (rules) that can be executed when an event “begins”, and that are withdrawn when that event “concludes”. TNET and ETNET capture temporal relationships among recorded information that are not represented in TOD-based databases. Although they do not solve all temporal reasoning problems found in medical decision making, these new structures enable patient database systems to encode complex temporal relationships, to store and retrieve patient data based on multiple clinical contexts and, in ETNET, to modify the reasoning methods available to an expert system based on the onset or conclusion of specific clinical events.

APA, Harvard, Vancouver, ISO, and other styles

35

Vidakovic, Jovana, Sonja Ristic, Slavica Kordic, and Ivan Lukovic. "Extended tuple constraint type as a complex integrity constraint type in XML data model - definition and enforcement." Computer Science and Information Systems 15, no. 3 (2018): 821–43. http://dx.doi.org/10.2298/csis180324029v.

Full text

Abstract:

A database management system (DBMS) is based on a data model whose concepts are used to express a database schema. Each data model has a specific set of integrity constraint types. There are integrity constraint types, such as key constraint, unique constraint and foreign key constraint that are supported by most DBMSs. Other, more complex constraint types are difficult to express and enforce and are mostly completely disregarded by actual DBMSs. The users have to manage those using custom procedures or triggers. eXtended Markup Language (XML) has become the universal format for representing and exchanging data. Very often XML data are generated from relational databases and exported to a target application or another database. In this context, integrity constraints play the essential role in preserving the original semantics of data. Integrity constraints have been extensively studied in the relational data model. Mechanisms provided by XML schema languages rely on a simple form of constraints that is sufficient neither for expressing semantic constraints commonly found in databases nor for expressing more complex constraints induced by the business rules of the system under study. In this paper we present a classification of constraint types in relational data model, discuss possible declarative mechanisms for their specification and enforcement in the XML data model, and illustrate our approach to the definition and enforcement of complex constraint types in the XML data model on the example of extended tuple constraint type.

APA, Harvard, Vancouver, ISO, and other styles

36

Pei, Qiu Hong. "The B/S Structure Design of Firefighting Equipment Management System for Fire Brigade." Advanced Materials Research 490-495 (March 2012): 2843–47. http://dx.doi.org/10.4028/www.scientific.net/amr.490-495.2843.

Full text

Abstract:

This system based on the fire control safety management demand of Fire Brigade’s firefighting equipment. The system is composed of five modules, such as user management mo¬¬¬dule, firefighting equipment maintenance module, firefighting equipment query module, firefighting equipment browse module and message board module. realizing the category of users access point unit management mode, access for" administrator", " cadre", " soldier ", giving different users different permissions. Using Microsoft Visual Studio 2008 developing platform, Microsoft SQL Server 2005 DBMS and C# developing language, the firefighting equipment management system of Fire Brigade is designed. Using Silverlight as page maker and the production of database access all adopt storage process, improving the efficiency of database access. Also it can make the management of firefighting equipments more scientific and reasonable.

APA, Harvard, Vancouver, ISO, and other styles

37

Ajmar, A., E. Arco, and P. Boccardo. "A SPATIAL DATABASE MODEL FOR MOBILITY MANAGEMENT." ISPRS - International Archives of the Photogrammetry, Remote Sensing and Spatial Information Sciences XLII-2/W13 (June 5, 2019): 1495–502. http://dx.doi.org/10.5194/isprs-archives-xlii-2-w13-1495-2019.

Full text

Abstract:

Abstract. In urban and metropolitan context, Traffic Operations Centres (TOCs) use technologies as Geographic Information Systems (GIS) and Intelligent Transport Systems (ITS) to tackling urban mobility issue. Usually in TOCs, various isolated systems are maintained in parallel (stored in different databases), and data comes from different sources: a challenge in transport management is to transfer disparate data into a unified data management system that preserves access to legacy data, allowing multi-thematic analysis. This need of integration between systems is important for a wise policy decision.This study aims to design a comprehensive and general spatial data model that could allow the integration and visualization of traffic components and measures. The activity is focused on the case study of 5T Agency in Turin, a TOC that manages traffic regulation, public transit fleets and information to users, in the metropolitan area of Turin and Piedmont Region.The idea is not to replace the existing implemented and efficient system, but to built-up on these systems a GIS that overpass the different software and DBMS platforms and that can demonstrate how a spatial and horizontal vision in tackling urban mobility issues may be useful for policy and strategies decisions. The modelling activity take reference from a review of transport standards and results in database general schema, which can be reused by other TOCs in their activities, helping the integration and coordination between different TOCs. The final output of the research is an ArcGIS geodatabase, which enable the customised representation of private traffic elements and measures.

APA, Harvard, Vancouver, ISO, and other styles

38

Patil, Suraj Krishna, Sandipkumar Chandrakant Sagare, and Alankar Shantaram Shelar. "Use of Purpose and Role Based Access Control Mechanisms to Protect Data Within RDBMS." International Journal of Software Innovation 8, no. 1 (January 2020): 82–91. http://dx.doi.org/10.4018/ijsi.2020010105.

Full text

Abstract:

Privacy is the key factor to handle personal and sensitive data, which in large chunks, is stored by database management systems (DBMS). It provides tools and mechanisms to access and analyze data within it. Privacy preservation converts original data into some unknown form, thus protecting personal and sensitive information. Different access control mechanisms such as discretionary access control, mandatory access control is used in DBMS. However, they hardly consider purpose and role-based access control in DBMS, which incorporates policy specification and enforcement. The role based access control (RBAC) regulates the access to resources based on the roles of individual users. Purpose based access control (PuBAC) regulates the access to resources based on purpose for which data can be accessed. It regulates execution of queries based on purpose. The PuRBAC system uses the policies of both, i.e. PuBAC and RBAC, to enforce within RDBMS.

APA, Harvard, Vancouver, ISO, and other styles

39

Mailhot, Alain, Alain N. Rousseau, Serge Massicotte, Jacques Dupont, and Jean-Pierre Villeneuve. "A watershed-based system for the integrated management of surface water quality: the GIBSI system." Water Science and Technology 36, no. 5 (September 1, 1997): 381–87. http://dx.doi.org/10.2166/wst.1997.0236.

Full text

Abstract:

This paper presents a general description and the state of progress of the GIBSI system, a watershed-based software system for integrated management of surface water quality. This spatial support-decision system is designed to assist decision makers as well as water resources professionals. An integrated structure composed of mathematical models, a Geographical Information System (GIS) and a DataBase Management System (DBMS) characterizes the system. This means interactions between users and system components are made through a single user-friendly interface. A simple scenario approach is used to examine the impact of alternative urban, industrial, and agricultural management practices on surface water quality. Interpretation of results is based on comparing different management scenarios with a reference state or other previously defined scenarios.

APA, Harvard, Vancouver, ISO, and other styles

40

WARMAN, INDRA, and RIZKI RAMDANIANSYAH. "ANALISIS PERBANDINGAN KINERJA QUERY DATABASE MANAGEMENT SYSTEM (DBMS) ANTARA MySQL 5.7.16 DAN MARIADB 10.1." JURNAL TEKNOIF 6, no. 1 (April 30, 2018): 32–41. http://dx.doi.org/10.21063/jtif.2018.v6.1.32-41.

Full text

APA, Harvard, Vancouver, ISO, and other styles

41

Alvez, Carlos, Ernesto Miranda, Graciela Etchart, and Silvia Ruiz. "Efficient Iris Recognition Management in Object-Related Databases." Journal of Computer Science and Technology 18, no. 02 (October 4, 2018): e12. http://dx.doi.org/10.24215/16666038.18.e12.

Full text

Abstract:

Biometric applications have grown significantly in recent years, particularly iris-based systems. In the present work, an extension of an Object Relational Database Management System for the integral management of a biometric system based on the human iris was presented. Although at present, there are many database extensions for different domains, in no case for biometric applications. The proposed extension includes both the extension of the type system and the definition of domain indexes for performance improvement. The aim of this work is to provide a tool that facilitates the development of biometric applications based on the iris feature. Its development is based on a reference architecture that includes both the management of images of the iris trait, its associated metadata and the necessary methods for both manipulation and queries. An implementation of the extension is performed for PostgreSQL DBMS, and SP-GiST framework is used in the implementation of a domain index. Experiments were carried out to evaluate the performance of the proposed index, which shows improvements in query execution times.

APA, Harvard, Vancouver, ISO, and other styles

42

Hou, Zhi Hong, and Shi Yong Luo. "Simulation and Computation of Diffusion in Solids." Applied Mechanics and Materials 182-183 (June 2012): 933–36. http://dx.doi.org/10.4028/www.scientific.net/amm.182-183.933.

Full text

Abstract:

A computation software on diffusion computation in solids was developed. The software includes two sub-modules of “database management system (DBMS)” and "Evaluation & prediction". The “DBMS” deals with the diffusion coefficients gathered from reported documents and the data evaluated according to some rules, besides, it can provide users with retrieval of diffusion coefficients. Based on the solutions to the Fick’s first law and the Fick’s second law in the four typical critical conditions, the "Evaluation & prediction" sub-module gives the predication of concentration distribution after diffusion process in solids or computation for diffusion coefficient.

APA, Harvard, Vancouver, ISO, and other styles

43

Memon, Muhammad Qasim, Jingsha He, Aasma Memon, Khurram Gulzar Rana, and Muhammad Salman Pathan. "Query Processing for Time Efficient Data Retrieval." Indonesian Journal of Electrical Engineering and Computer Science 9, no. 3 (March 1, 2018): 784. http://dx.doi.org/10.11591/ijeecs.v9.i3.pp784-788.

Full text

Abstract:

In database management system (DBMS) retrieving data through structure query language is an essential aspect to find better execution plan for performance. In this paper, we incorporated database objects to optimize query execution time and its cost by vanishing poorly SQL statements. We proposed a method of evolving and inserting database constraints as database objects embedded with queries either to add them for the sake of transactions required by user to detect those queries for the betterment of performance. We took analysis on several databases while processing queries itself and assimilate real time database workload with the bunch of transactions are invoked in comparison with tuning approaches. These database objects are coded in procedural language environment pertaining rules to make it worth and are merged into queries offering improved execution plan.

APA, Harvard, Vancouver, ISO, and other styles

44

Gezgin, Deniz Mertkan. "The Effect of Mobile Learning Approach on University Students' Academic Success for Database Management Systems Course." International Journal of Distance Education Technologies 17, no. 1 (January 2019): 15–30. http://dx.doi.org/10.4018/ijdet.2019010102.

Full text

Abstract:

This article investigates the effect of mobile learning support on students' academic success on a database management systems (DBMS) course. The research was carried out with 36 students attending a state university in Turkey. In this study, a mixed method was used, which includes both quantitative and qualitative data collection techniques. For the quantitative data, the study was conducted in accordance with the pre-test and post-test-based two group quasi-experimental model. For the qualitative data, the descriptive analysis technique was used. The independent sample t-test and paired simple t-test were employed in the analysis phase. According to the findings, mobile learning positively affected students' academic achievement on the DBMS course, in that the students supported by mobile learning were more successful than students supported only by face-to-face training method. Finally, it is seen that the students have emphasized themes of motivation, 1-1 access, and an interest in terms of the effect of m-learning approach on academic success.

APA, Harvard, Vancouver, ISO, and other styles

45

Imai, N. N., M. H. Shimabukuro, A. F. C. Carmo, E. H. Alcântara, T. W. P. Rodrigues, and F. S. Y. Watanabe. "Bio-optical data integration based on a 4 D database system approach." ISPRS - International Archives of the Photogrammetry, Remote Sensing and Spatial Information Sciences XL-7/W3 (April 29, 2015): 635–41. http://dx.doi.org/10.5194/isprsarchives-xl-7-w3-635-2015.

Full text

Abstract:

Bio-optical characterization of water bodies requires spatio-temporal data about Inherent Optical Properties and Apparent Optical Properties which allow the comprehension of underwater light field aiming at the development of models for monitoring water quality. Measurements are taken to represent optical properties along a column of water, and then the spectral data must be related to depth. However, the spatial positions of measurement may differ since collecting instruments vary. In addition, the records should not refer to the same wavelengths. Additional difficulty is that distinct instruments store data in different formats. A data integration approach is needed to make these large and multi source data sets suitable for analysis. Thus, it becomes possible, even automatically, semi-empirical models evaluation, preceded by preliminary tasks of quality control. In this work it is presented a solution, in the stated scenario, based on spatial – geographic – database approach with the adoption of an object relational Database Management System – DBMS – due to the possibilities to represent all data collected in the field, in conjunction with data obtained by laboratory analysis and Remote Sensing images that have been taken at the time of field data collection. This data integration approach leads to a 4D representation since that its coordinate system includes 3D spatial coordinates – planimetric and depth – and the time when each data was taken. It was adopted PostgreSQL DBMS extended by PostGIS module to provide abilities to manage spatial/geospatial data. It was developed a prototype which has the mainly tools an analyst needs to prepare the data sets for analysis.

APA, Harvard, Vancouver, ISO, and other styles

46

Luo, Shi Yong, Wen Cai Xu, Zun Zhong Liu, and Jia Yun Zhang. "A Computation Software on Diffusion and Solid State Reactions Kinetics." Advanced Materials Research 148-149 (October 2010): 316–21. http://dx.doi.org/10.4028/www.scientific.net/amr.148-149.316.

Full text

Abstract:

A computer software on solid/solid reaction kinetics, KinPreSSR, is one of subsystems in the software, Intellectualized Database Management System on Kinetics of Metallurgy (IDMSKM). KinPreSSR is a Windows application developed using Visual C++ and FoxPro, and includes two main modules, “DIFFUSION” and “REACTION”. KinPreSSR deals with the kinetics on the diffusion in solid state as well as solid/solid reactions. In the ‘REACTION’ module, the system has organized the commonly recognized kinetic models, parameters and employed both numerical and graphical methods for data analyses. The proper combination between the kinetic contents and the analytical methods enables users to use KinPreSSR for the evaluation and prediction of solid/solid reactions interested. The ‘DIFFUSION’ module includes two sub-modules of “database management system (DBMS)” and "Evaluation & prediction". The “DBMS” deals with the diffusion coefficients gathered from reported documents and the data evaluated according to some rules, besides, it can provide users with retrieval of diffusion coefficients. Based on the solutions to the Fick’s first law and the Fick’s second law in the four typical critical conditions, the "Evaluation & prediction" sub-module gives the predication of concentration distribution after diffusion process in solids or computation for diffusion coefficient.

APA, Harvard, Vancouver, ISO, and other styles

47

Kovtun, O. P., A. N. Plaxina, V. A. Makutina, N. O. Ankudinov, N. A. Zilber, O. V. Limanovskay, and S. L. Sinotova. "Information-analytical assessment systems for perinatal outcomes and children’s health status born by assisted reproductive technologies." Rossiyskiy Vestnik Perinatologii i Pediatrii (Russian Bulletin of Perinatology and Pediatrics) 65, no. 1 (March 6, 2020): 45–50. http://dx.doi.org/10.21508/1027-4065-2020-65-1-45-50.

Full text

Abstract:

Purpose: To integrate clinical databases based on the information and analytical systems of medical organizations (MO) and to evaluate outcomes and health of children born by assisted reproductive technologies (ART).Research methods: To form database by integrating information and analytical systems of the medical organizations. To search and unify the data by means of freeware relational database management system (DBMS) – MySQL.Results. A prototype application for the management and support of a unified clinical database to analyze and evaluate the outcomes of ART. To compare information from individual databases of MO one need to match fields in the form of unique personal records, field validation, processing of missing data. Significant (p <0.001) differences in gestational age and anthropometric data in the databases of medical organizations (76% of full-term children from the Automated System “Regional obstetric monitoring” (AS ROM) database compared with 18% according to the IS “Register of Children requiring Early Care”) were determined by the introduction of the conception of ART, along with the presence of perinatal risk factors in children. The created software can be used to create registers of medical organizations, as well as to support clinical decision-making in forecasting, modeling outcomes and children’s health after ART, developing personalized treatment and rehabilitation programs.Conclusion. It is necessary to develop and implement information systems, to create ART registers on the basis of regional and national registers, to analyze the outcomes of the use of reproduction methods.

APA, Harvard, Vancouver, ISO, and other styles

48

Qi, Yuan Sheng, Yu Feng Ding, X. H. Wang, J. J. Li, and B. Zhang. "The Research and Implementation into Knowledge Reuse System of Product Design of Printing Press." Materials Science Forum 628-629 (August 2009): 43–48. http://dx.doi.org/10.4028/www.scientific.net/msf.628-629.43.

Full text

Abstract:

Aiming at the reuse of design knowledge, this paper proposes knowledge reuse technology for product design of printing press which is based on rule and case. An integrated software package with SQL Server which is Database Management System (DBMS) and VisualC++6.0 which is a kind of development tools has been developed. This software may be embedded in the environment of Solidworks to assist the designer to index correlative design knowledge and develop new product of printing press after modification.

APA, Harvard, Vancouver, ISO, and other styles

49

Giri, Shailendra, and Subarna Shakya. "E-government Use in Nepal: Issues of Database Management and Data Security." Journal of the Institute of Engineering 15, no. 2 (July 31, 2019): 218–24. http://dx.doi.org/10.3126/jie.v15i2.27669.

Full text

Abstract:

E-government uses information and communication technologies (ICTs) tools and systems to provide better public services. Database Management System (DBMS) is a very significant part in e-governance activities and process in the nation. Security of the data is a main concern of the organizations and private. Proper database management and data security are the major issues in present era. The aim of the paper is to try analyzing necessity of database management and data security. The author used survey methods during research to collect the data and analyze it. This paper concludes that the data backup is key profession while using computer in an institute or people. Hard disk, external hard disk, pen drive, memory card, server and open drive are the major storage Medias. People and employees don’t create backup of data due to lack of knowledge, device and don’t know about importance. The authors conclude that using Antivirus on computer, password on file and computer system, data and information backup, firewall, encryption and decryption technology are the data security tools. Data security protect against the unauthorized use, disclosure, access, destruction, modification and loss of data. Confidential password security and regular monitoring on password are very necessary to secure data. An online security system, as well as manual security systems, should be managed attentively.

APA, Harvard, Vancouver, ISO, and other styles

50

Coşkun, İ. B., S. Sertok, and B. Anbaroğlu. "K-NEAREST NEIGHBOUR QUERY PERFORMANCE ANALYSES ON A LARGE SCALE TAXI DATASET: POSTGRESQL VS. MONGODB." ISPRS - International Archives of the Photogrammetry, Remote Sensing and Spatial Information Sciences XLII-2/W13 (June 5, 2019): 1531–38. http://dx.doi.org/10.5194/isprs-archives-xlii-2-w13-1531-2019.

Full text

Abstract:

Abstract. The increasing volume of transport network data necessitates the use of a DataBase Management System (DBMS) to store, query and analyse data. There are two main types of DBMS: relational and non-relational. Many different DBMS are available on the market but only some of them could handle spatial data. Therefore, determining which DBMS to use for operational purposes is of interest to researchers and analysts working in spatial information science. One of the commonly used spatial queries in GIS is the k-Nearest Neighbour (kNN) of a given point. This paper analyses the performance of the kNN query in PostgreSQL and MongoDB, both being a representative of relational and NoSQL DBMS respectively. Two different metrics have been investigated to determine the performance: i) spatial accuracy and ii) run time. Haversine and Vincenty formulas are used to calculate the distance between the point and the determined neighbours, which are then used to determine the spatial accuracy of the DBMS. Sensitivity analysis have been carried out by varying the k value and the execution times are recorded. The experiments are carried out on New York City’s openly available taxi dataset consisting of millions of taxi pickup and dropoff points. The results indicate that MongoDB outperforms Postgres both in terms of execution time and spatial accuracy regardless the value of k. In order to facilitate reproducibility of the results, the developed software is shared on GitHub.

APA, Harvard, Vancouver, ISO, and other styles

Journal articles on the topic 'Database Management System (DBMS)'

Create a spot-on reference in APA, MLA, Chicago, Harvard, and other styles