יול 10

llagerlof/freezer: Freezer is a tool to help developers to discover which database’s records are inserted by other programs.

Freezer demo videoFreezer is a tool to help developers discover which database records are created by some application’s action and which tables received these new records because that action.

It makes much easier to spot these tables and its new records, understand how the third-party application interacts with the database and also how relationships are made.

Source: llagerlof/freezer: Freezer is a tool to help developers to discover which database’s records are inserted by other programs.

מרץ 27

(18) (PDF) Framework for Big Data Analytics of Moodle Data Using Hadoop in the Cloud

“Big Data includes huge volume, high velocity and extensible variety of data, both structured and unstructured. Analysis and examination of this data plays a big role in making a better decisions and lead to strategic business moves. In this research, we are focusing on analysis of Moodle e-learning platform database with aim of improving the educational process. Using the concept of learning analytics we are trying to better understand teaching and learning processes in order to get as much as possible from educators and learners which are the main actors in the mentioned activities. The standard procedures that are specific to the databases will take a lot more time to do this. To facilitate this process, big data processing tools are used. Here, we also present the possibility of analyzing big data in the cloud. For the purpose of this research, we developed a framework for big data analysis.”

Source: (18) (PDF) Framework for Big Data Analytics of Moodle Data Using Hadoop in the Cloud

פבר 24

PMM Query Analytics

The QAN is a special dashboard which enables database administrators and application developers to analyze database queries over periods of time and find performance problems. QAN helps you optimize database performance by making sure that queries are executed as expected and within the shortest time possible. In case of problems, you can see which queries may be the cause and get detailed metrics for them.

Source: PMM Query Analytics

מרץ 06

Moodle 3.3 Database schema / Zoola Analytics

Searching the Moodle database schema is no longer a challenge and table fields names and purposes are no longer a mystery 🙂

With the Zoola analytics DB schema explorer, we can now search and filter tables, table fields, and explorer 1st and 2nd level external key connections between tables.

Source: Moodle 3.3 Database schema / Zoola Analytics