Navicat Blog

Aug 14, 2018 by Robert Gravelle

The massive volumes data generated by modern interconnected systems and devices has spawned a new kind of database known as NoSQL. Perhaps the best known of this new breed of non-relational database is MongoDB. Unlike traditional relational databases (RDBMSes), MongoDB does not contain tables. Instead, it stores data as collections of documents.

Aug 10, 2018 by Robert Gravelle

The term "NoSQL" actually encompasses a wide variety of different database technologies that were developed in response to the demands dictated by modern applications and Internet of Things (IoT) devices. The massive volumes of new, rapidly changing data types created by the linking of numerous systems and devices have presented challenges for traditional DBMSes:

Jul 31, 2018 by Robert Gravelle

MongoDB is a different kind of database. Unlike traditional relational databases like SQL Server and MySQL, it stores data as JSON-like documents. While MongoDB's NoSQL approach does yield some advantages over its RDBMS competitors, it also makes it harder for makers of third-party database management tools to integrate support for MongoDB within their products, leaving users few options besides MongoDB's own Compass UI tool.

Jul 24, 2018 by Robert Gravelle

A database event is a task that runs according to a schedule. Also known as "scheduled events", an event is similar to a cron job in UNIX or a task scheduler task in Windows, except that scheduled events are configured using a database's syntax and/or command-line-interface (CLI). Database events have many uses, such as optimizing database tables, cleaning up logs, archiving data, or generating complex reports during off-peak time.

Jul 17, 2018 by Robert Gravelle

Since version 5.1.6, MySQL has supported events. They employ a natural language scheduling syntax, so that you can say: "I want the MySQL server to execute this SQL statement every day at 11:30am, until the end of the year". To help you write your event statements, MySQL provides excellent documentation on CREATE EVENT syntax. Despite all of this, getting a firm grasp of event scheduling can still take some trial and error.

Navicat Blogs
Feed Entries
Blog Archives