This is a bit old my interview about Big Data / Databases and possibilities to find a structure in unstructured data. I was a participant of program for students about Data. Watch the video about it, use the subtitles if needed.
Artificial Intelligence (AI) has been permanently settled in our daily life. Unmanned airmail, robotic vacuum cleaners, virtual assistants – this is a modern reality. The operation of these gadgets is based on algorithms that simulate some action a human can…
Under the invitation of the company a series of lectures within 2 courses were held on introduction to the language of SQL and advanced techniques to use SQL for junior / middle data engineers and system analysts. “You are always…
Hi there, At this Saturday I was a participate on online conference “South Florida Data Geeks” with the main theme for the event “Back to the Future”. That was really interesting experience and discussion with other Data Geeks from all…
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…
