1. Master Data Management Tools
2. Examples Of Data Management Tools

The following tables compare general and technical information for a number of available database administrator tools. Please see individual product articles for further information. This article is neither all-inclusive nor necessarily up to date.

Backlog is a project management and collaboration tool for teams that want higher productivity, greater visibility, and simple project tracking. Development teams can work together with Design, Marketing, IT, and more to release high-quality projects, faster. Big data – Most trends related to database software are associated with big data analytics and distribution. These tools can process the massive amounts of data existing in today’s digital world. Companies can use these tools to structure virtually any datapoint collected from social media, market intelligence, or internal business practices. Big Data and the ever-growing access we have to more information is the driving force behind artificial intelligence and the wave of technological change sweeping across all industries. Quantum GIS (QGIS) is open source GIS software, available for both Windows and Mac OS. This software is free and comes with surprisingly powerful and useful tools. Princeton University Library, Getting Started in Data Analysis. UCLA Institute for Digital Research and Education, Statistical Computing. Data crunching can be useful for a wide range of analyses; we look at 8 tools that can make it easier to sort your numbers and show them off to their best advantage. Integrating IPAM with a network management tool just makes sense as the same person quite frequently handles both functions. Automation is the key to managing large numbers of devices.

MAC Data Recovery Tool is a recovery software from a well-known Software company to repair corrupt MAC hard drives or volumes. This tool, help users to recover and restore inaccessible MAC data which they have lost through corruption of HFS and HFS+ drives.

Systems listed on a light purple background are no longer in active development.

Master Data Management Tools

General[edit]

Features[edit]

Legend

• Create/alter table:
  • Yes - can create table, alter its definition and data, and add new rows
  • Some - can only create/alter table definition, not data
• Browse table:
  • Yes - can browse table definition and data
  • Some - can only browse table definition
• Multi-server support:
  • Yes - can manage from the same window/session multiple servers
  • Some - can manage from a different window/session multiple servers
• Monitoring server:
  • Yes - includes a headless server, that runs checks and reports failures

Features (continued)[edit]

Legend:

• User manager:
  • Yes - user manager with support for database and schema permissions as well as for individual object (table, view, functions) permissions
  • Some - simple user manager with support for database and schema permissions
  • No - no user manager, or read-only user manager

Features - visual design and reverse engineering[edit]

Legend:

• Visual schema/E-R design: the ability to draw entity-relationship diagrams for the database. If missing, the following two features will also be missing
• Reverse engineering - the ability to produce an ER diagram from a database, complete with foreign key relationships
  • Yes - supports incremental reverse engineering, preserving user modifications to the diagram and importing only changes from the database
  • Some - can only reverse engineer the entire database at once and drops any user modifications to the diagram (can't 'refresh' the diagram to match the database)
• Forward engineering - the ability to update the database schema with changes made to its entities and relationships via the ER diagram visual designer
  • Yes - can update user-selected entities
  • Some - can only update the entire database at once

See also[edit]

Notes[edit]

1. ^create CRUD interfaces, so create table data, not table theriselves.
2. ^Browse table data, not table definitions.
3. ^Only incremental, by manually going through each table and clicking 'Add to graph'.
4. ^Generated SQL must be executed outside Toad Data Modeler.

References[edit]

1. ^'Database management in a single PHP file'. adminer.org. Retrieved 2019-07-24.
2. ^'Change log'. dadabik.com. Retrieved 2019-07-24.
3. ^'What's New in DatabaseSpy'. altova.com. Retrieved 2019-07-24.
4. ^'DBEdit 2 - Changelog'. dbedit2.sourceforge.net. Retrieved 2019-07-24.
5. ^'Releases - HeidiSQL/HeidiSQL'. github.com. Retrieved 2019-06-06.
6. ^'Download SQL Server Management Studio (SSMS)'. 11 Jun 2019. Archived from the original on 12 Jun 2019.
7. ^'An Overview of Database Diagram Tools Available for PostgreSQL'. Severalnines. 2019-07-05. Retrieved 2019-07-24.
8. ^'ModelRight Download full version trials'. www.modelright.com. Retrieved 2019-07-24.
9. ^'Releases - mysql/mysql-workbench'. github.com. Retrieved 2019-07-24.
10. ^'Orbada - Database manager - Browse /Orbada at SourceForge.net'. sourceforge.net. Retrieved 2019-07-24.
11. ^https://bitbucket.org/phpliteadmin/public/downloads
12. ^'Security fix: phpMyAdmin 4.9.0 is released'. phpmyadmin.net. Retrieved 2019-06-06.
13. ^'SQLyog MySQL GUI 13.1.5 Released'. sqlyog.com. Retrieved 2019-07-24.
14. ^'SQuirrel SQL Client - Browse/1-stable'. sourceforge.net. Retrieved 2019-07-24.
15. ^can manage its own users, which override the DBMS users
16. ^ ^abtitle= Navicat feature matrix
17. ^https://blogs.technet.microsoft.com/dataplatforminsider/2016/11/21/source-control-in-sql-server-management-studio-ssms/
18. ^SQLYog query builder
19. ^SQLYog schema designer

External links[edit]

Examples Of Data Management Tools