There are interesting approaches to store your model in OLAP model by using for example next databases Vertica ClickHouse GreenPlum Guys decided to create a basement of Vertical Database and separated “front end” and “backend end”. In this case, “front…
What does mean IOT structure? Actually, this is Index Organised Table. Some databases like Oracle has really good implementation this type of table for end user. To be shortest, IOT table stores whole data in BTree index. Please take a…
Do you need a fast research based on PostgreSQL data, without any additional layers and budgets? Actually, the solution is to make EXTENSION for particular algorithm and install it. Anna decided to make EXTENSION for Apriori algorithm and moreover… she…
Data Science and Data Structures are really tightly coupled. DataScience (DS) Team needs data (structured or semistructured), other words they want to know where is a data storage to run Machine Learning or Data Mining models. In collaboration between DS…
This is a Diploma Project provides a possibility to replicate data from PostgreSQL to MySQL database. But approach and IT architecture which Anastasiya selected is completely different like was described in another project. By the way , this project is…
What is a difference between production and stage/dev/sandbox relational databases? No difference actually. But … there is one detail, this is a SQL traffic … heavy SQL traffic, every second we have more than 1000 TPS (Transaction Per Second). That’s…
So, I am sure you know LogLog / HyperLogLog algorithms to get a good approximation of some interesting business metrics “on-the-fly” (or Streaming Data). From technical side, there are a good technical realization to get well good approximation like database…
New era of data integration between “databases-as-a-microservices” needs in methods and physical realization of data streaming replication between heterogeneous databases. Danis chosen the way “from MySQL to PostgreSQL”. Moreover, during his analysis and implementation, he extended a functionality of solution…
Common project can be presented in IT architecture paradigm below Each girl was working on her part of this huge project. Gulshat provided a common database EAV model to store system / user indicators and operational data. Also her python…
There are o lot of SQL Load Balancer in IT World. Just like below pg_pooler pg_bouncer etc. Actually Danel decided to reach another main goals. to balance OLAP / OLTP SQL traffic between PostgreSQL databases to gather statistics about usage…
