Results 221 to 230 of about 55,832 (275)

A Tool for Database Masking and Anonymization of PostgreSQL

2023 International Conference on Data Science, Agents & Artificial Intelligence (ICDSAAI), 2023
Managing and securing sensitive data in a production database can be a complex and challenging task, especially when creating a staging database for testing and development purposes.
Roehit Ranganathan, G. Kumar, T. Angel
semanticscholar   +1 more source

DW vs OLTP Performance Optimization in the Cloud on PostgreSQL (A Case Study)

2022 IEEE International Conference on Recent Advances in Systems Science and Engineering (RASSE), 2022
This case study shows the performance issues and solutions for a data warehouse (DW) performing well to serve industrial partners in improving customer data retrieval performance.
Dakota Joiner, Mathias Clement, Shek Chan, Keegan Pereira, Albert Wong, Y. Khmelevsky, Joe Mahony, Michael Ferri   +7 more
semanticscholar   +1 more source

Performance Analysis of PostgreSQL, MySQL, Microsoft SQL Server Systems Based on TPC-H Tests

2021 International Russian Automation Conference (RusAutoCon), 2021
The development of information technologies requires the processing of an increasing amount of information. A great number of tools and DBMSs for working with big data have been created. Examples of DBMS are: MS SQL Server, Oracle Database, SciDB, VoltDB,
I. Vershinin, A. R. Mustafina
semanticscholar   +1 more source

PostCENN: PostgreSQL with Machine Learning Models for Cardinality Estimation

Proceedings of the VLDB Endowment, 2021
In this demo, we present PostCENN , an enhanced PostgreSQL data-base system with an end-to-end integration of machine learning (ML) models for cardinality estimation.
Lucas Woltmann, Dominik Olwig, Claudio Hartmann, Dirk Habich, Wolfgang Lehner   +4 more
semanticscholar   +1 more source

Implementation of Data Warehouse in Making Business Intelligence Dashboard Development Using PostgreSQL Database and Kimball Lifecycle Method

2021 International Conference on Artificial Intelligence and Big Data Analytics, 2021
Competition in the business world is getting tighter, making companies will continue to look for ways so that the company can continue to compete and also have profits that continue to rise every year.
Paquita Putri Ramadhani, Setiawan Hadi, Rudi Rosadi   +2 more
semanticscholar   +1 more source

Freedom for the SQL-Lambda: Just-in-Time-Compiling User-Injected Functions in PostgreSQL

International Conference on Statistical and Scientific Database Management, 2020
As part of the code-generating database system HyPer, SQL lambda functions allow user-defined metrics to be injected into data mining operators during compile time.
Maximilian E. Schüle, Jakob Huber, A. Kemper, Thomas Neumann   +3 more
semanticscholar   +1 more source

Hippocratic PostgreSQL

2009 IEEE 25th International Conference on Data Engineering, 2009
Privacy preservation has become an important requirement in information systems that deal with personal data. In many cases this requirement is imposed by laws that recognize the right of data owners to control whom their information is shared with and the purposes for which it can be shared.
Padma, J, Silva, Yasin, Arshad, Mohamed, Aref, Walid G.   +3 more
openaire   +2 more sources

An Elephant Under the Microscope: Analyzing the Interaction of Optimizer Components in PostgreSQL

Proc. ACM Manag. Data
Despite an ever-growing corpus of novel query optimization strategies, the interaction of the core components of query optimizers is still not well understood.
Rico Bergmann, Claudio Hartmann, Dirk Habich, Wolfgang Lehner   +3 more
semanticscholar   +1 more source

Are There Fundamental Limitations in Supporting Vector Data Management in Relational Databases? A Case Study of PostgreSQL

IEEE International Conference on Data Engineering
High-dimensional vector data is gaining increasing importance in data science applications. Consequently, various database systems have recently been developed to manage vector data.
Yunan Zhang, Shige Liu, Jianguo Wang
semanticscholar   +1 more source

Securing Relational Databases against Security Vulnerabilities: A Case of Microsoft SQL Server and PostgreSQL

Journal of Applied Security Research, 2021
This study evaluates mechanisms to secure relational databases against security vulnerabilities and utilized PostgreSQL and Microsoft SQL Server due to data breach incidences reported across the world.
Hassan Kilavo, Salehe I. Mrutu, Robert G. Dudu   +2 more
semanticscholar   +1 more source