HLRnet.com:
Technologie:
Databases
Database-technologie
- Databases
- Relationele databanken
- SQL
- MySQL
- MySQL Software
- Management
-
Database tools
Ontwikkeltools
- Caspio:
platfom-as-a-service for creating web database applications and forms
- CodeCharge
Studio: Rapid Web Application Development and Visual
Web Reporting; DemoCharge Screen Recorder
- Tulip
is an information visualization framework dedicated to the analysis and
visualization of relational data. Tulip aims to provide the developer
with a complete library, supporting the design of interactive
information visualization applications for relational data that can be
tailored to the problems he or she is addressing.
Open Source
- BaseX is a
light-weight, high-performance, and scalable XML database system and
XPath/XQuery processor, including full support for the W3C Update and
Full Text extensions. An interactive and user-friendly GUI frontend
gives you great insight into large XML data instances. It is platform
independent and works out of the box.
- Cego
implements a
relational and transactional database system with support for the SQL
query language. The current release contains the most common database
features for basic table manipulation and data retrieval. Indexes,
foreign keys, views, and stored procedures are also implemented. Future
releases (2.0 and above) will support a multi-node database concept
with log file shipping for an automatic database application failover.
- Cego-DBD
implements a Perl DBD driver for the Cego database system.
- Chinook
is a
sample database available for SQL Server, Oracle and MySQL. It can be
created by running a single SQL script. Chinook database is an
alternative to the Northwind database, being ideal for demos and
testing ORM tools targeting single and multiple database servers.
- CoolSQL
is a cool tool used to view and manage database. It provides a nice
user interface which makes a wonderful experience to user.
- COOPY
is a set of tools for distributed data projects. It supports diffing,
patching, merging, and revision control of tables in a variety of
formats (CSV, Excel, MySQL, Sqlite, etc).
- CompareZilla
is a FREE utility application that can COMPARE DATABASE TABLE. The
databases DO NOT have to be of the same type and not even on the same
machine. Current release supports Oracle, SQL Server, MySQL and DB2...
- Database Deployment Manager (DDM)
is a desktop oriented multi-platform database design tool that allows
database administrators and programmers to create database structures
(using an object oriented methodology) and deploy them into an existing
database. The tool allows creation of diagrams to identify basic
relations between the defined structures. You can import tables from
various databases, either by fully reversing a database or just picking
tables from various databases and injecting them into your solution.
You can browse the databases and execute SQL queries on them. There is
a unique SELECT query builder that makes the building of queries very
easy without having to write a single SQL statement; just using point
and click with the mouse.
- DB2-JMIN
is a general-purpose database administration client, inspired by
phpMyAdmin. It was originally designed for DB2, but now also supports
MySQL, PostgreSQL, Firebird, Derby, and Oracle. It can be used as a Web
application or a desktop application. It runs on Tomcat 5.5 or Swing
with JDK 1.5. It features schema browsing, table browsing, table
structure, and an SQL query editor.
- DBeauty
is a relationship-oriented database browser. It provides insight into
both the data and the interrelation of the rows, and allows you to
navigate bidirectionally through the database by following
foreign-key-based or user-defined relationships.
- DB
Sanity
performs checks on a database for verifying data consistency and
correctness of aplication deployments. It is invoked by the command
line and creates an HTML report with a summary and listings of faulty
database entries.
- DocumentBurster
is a tool for report distribution: split, merge, email, and FTP your
reports. It has report delivery for Crystal Reports, SSRS Reporting
Services, MS Access, Cognos, PeopleSoft, and SAP. It has report
bursting for Pentaho, JasperReports, and BIRT. It can upload reports to
MS SharePoint.
- Entrance
is a program for browsing MySQL databases. It includes a "match box"
search facility that is simlar to the Mac's Spotlight. Entrance can
create charts based on query results, and these charts can be zoomed
and panned. Entrance also supports an innovative feature called "data
painting" that allows users to select and paint data points
interactively.
- GreenSQL
is a database firewall used to protect databases from SQL injection
attacks. GreenSQL works in a proxy mode and has built-in support for
MySQL. The logic is based on evaluation of SQL commands using a risk
scoring matrix, as well as blocking known DB administrative commands
(such as DROP and CREATE).
- HTSQL
a high-level query language and Web service gateway for relational
databases. It comes with source code and is royalty free for any use
with open source database systems such as MySQL, PostgreSQL, SQLite,
etc. It is licensed commercially for use with Microsoft SQL and Oracle.
- HyperSQL
is like the doxygen program with javadoc added - but for SQL. It
hypermaps SQL views, packages, procedures, and functions to HTML source
code listings, and it shows all the code locations where these are
used. The internal "where used" functionality also scans C++ and Java
source files. HyperSQL is written in Python for operating system
independence.
- Jailer
is a database subsetting tool. It is a tool for data exporting, schema
browsing, and rendering. It exports consistent, referentially intact
row-sets from relational databases. It removes obsolete data without
violating integrity. It is DBMS agnostic (by using JDBC), platform
independent, and generates DbUnit datasets, hierarchically structured
XML, and topologically sorted SQL-DML.
- MyJgui
is a GUI (graphical user interface) for MySQL. It aims to be easy to
use for new users as well as experts. You can store multiple
connections that can be used simultaneously. Stored passwords are
encrypted using symmetric encryption. Underlying databases and tables
are displayed in a tree structure with the connections being the first
level nodes. MyJgui is capable of easy data manipulation through a
grid. It has a unique feature of bookmarking parametrical queries
(sqlmarks). The documentation (user guide) is quite comprehensive and
kept up-to-date.
- myPhile
is a Web application that serves as a customizable generic front-end to
any MySQL table. It provides "view" control and user access privileges
for editing, deleting, adding records, and more. Field control allows
default strings or MySQL calculations on adds or edits. All functions
are provided in a single PHP file. Simple and complex searches are
possible and the most recent searches are stored. It supports the
creation of CSV files. Row views and detail views are configurable
through a simple Web interface.
- MySQL
Backup
is a Perl script that uses mysqlshow to grab the database names and
"show tables" to grab the table names for a user's account, and then
uses mysqldump to save the data in a subdirectory named in the script.
It then tars and gzips the files, using the date and time for the file
name. It can be run from cron on a daily basis. It removes old files
and has an option to email the gzip file to an admin, and/or FTP the
file to a remote server. It also has options to use "select data into
outfile" or a regular "select" for users who can't use mysqldump. It
supports LARGE sets of databases and tables.
- MySQL
Workbench
is a cross-platform, graphical database modeling tool for MySQL. It
allows you to create database models from scratch as well as by
importing existing databases from SQL or DBDesigner4 models. You can
then generate SQL code to CREATE databases, ALTER them, and export in
various image formats and PDF/PS. Its extension system allows writing
plugins and scripts in Lua, Python, and C++.
- ODABA: The
OODBMS/DBMS ODABA is an terminology-oriented database management system
(TODBMS) on a high conceptual level. This is an extension of the ODBMS
concept according to ODMG 3. It provides a number of enhanced features
based on natural language analysis. Beside the database kernel, a
number of tools are provided for database design, documentation, and
fast development. ODABA provides a powerful interface (C++, .NET) and
an ODABA Script Interface (OSI), a C++/JAVA like scripting language,
which provides easy access to the database.
- OrientDB
is a NoSQL DBMS which can store up to 200,000 records in 5 seconds on
common hardware. Even with a document-based database, the relationships
are managed as in graph databases, with direct connections among
records. You can travere entire or part of trees and graphs of records
in a few milliseconds. It supports schema-less, schema-full, and
schema-mixed modes, has a strong security profiling system based on
users and roles, and supports SQL between the query languages. Thank to
the SQL layer, it's straightforward to use for people skilled in the
Relational world.
- OstrivDB
is an embedded NoSQL object-oriented database engine. OstrivDB was
named after the Oster river (the little river in little town where
author lives).
- RazorSQL
is a database query tool, SQL editor, database browser, and database
administration tool with support for all major databases. Some of the
main features included in RazorSQL are visual tools for creating,
viewing, and altering database objects; tools for importing and
exporting data; and tools for editing stored procedures, triggers, and
functions.
- Reportico
is a reporting tool. It lets you design reports, create report menus,
and configure criteria. It supports graphs, grouping, drill-down,
expression handling, and data transformation. It can produce output in
HTML, PDF, and CSV formats. The look and feel can be changed through
CSS.
- Reverse
Snowflake Joins
is a tool that parses SQL Select statements and generates a diagram. In
addition to joins, the diagram shows parts of the underlying SQL
directly in the diagram. For example x=30, GROUP BY (year),
SUM(profit), HAVING MIN(age) > 18.
- SimpleDBM
is a multi-threaded transactional database engine. It has a very small
footprint and can be embedded in the address space of an application,
or used in network client server mode. It provides a simple programming
API that can be learned very quickly. SimpleDBM supports ACID
transactions, steal/no-force buffer management, lock-based concurrency,
row level locks, b-tree indexes, tables, write ahead log, crash
recovery, and deadlock detection.
- Smart
Publisher is a Web-based application which helps you to
publish a static or dynamic Web site on the Internet. It compares files
and databases (MySQL) between local and remote systems, and uploads
only the difference between the two systems.
- SMDB
is a small, portable database library that exports an API similar that
of GDBM and allows for the simple storage and retrieval of key/data
couples. The library is totally system independent due to the use of
externally supplied interface pointers. File locking is left to the
caller, allowing single instance users to not pay the the price (in
terms of performance and portability) of the locking framework. It
supports transactions, multiple tables inside the same DB file, and is
less than half the size of GDBM.
- SQL
Construction Kit
aims to provide a simple builder/factory pattern based approach to
generating DML SQL for all popular RDBMS systems. Included builders are
SelectBuilder, InsertBuilder, UpdateBuilder, and DeleteBuilder. It is
much lighter weight than any of the ORM tools available, and is 100%
Java. It is a complete re-factoring of code that has been in production
use since 2001 (updated to use features of Java 6). Also included is a
Facade patterned Database object that wraps a Datasource object. This
provides an execution framework for the results of the Builder objects,
which includes simplified transaction and batch management as well as
the ability to transparently handle SQL exceptions in a default manner.
The Database object also provides a simple object-oriented approach via
wrappers around the database metadata.
- SQL
Relay
is a persistent database connection pooling, proxying, and load
balancing system. It supports many database systems and programming
languages. There are drop-in replacement libraries for MySQL and
PostgreSQL, command line clients, a GUI configuration tool, and
extensive documentation. The APIs support advanced database operations
such as binding variables, multi-row fetches, client-side result set
caching, and suspended transactions. It can be used for speeding up
database-driven Web-based applications, accessing databases from
unsupported platforms, migrating between databases, distributing access
to replicated databases, and throttling database access.
- SQuirreL
SQL Client
is a graphical Java program that allows you to view the structure of a
JDBC compliant database, browse data in the tables, issue SQL commands,
etc.
- SymmetricDS
is Web-enabled, database independent, data synchronization/replication
software. It uses Web and database technologies to replicate tables
between relational databases in near real time. The software was
designed to scale for a large number of databases, work across
low-bandwidth connections, and withstand periods of network outage. It
includes support for Oracle, MySQL, PostgreSQL, H2, HSQLDB, Derby, MS
SQL Server, Firebird, IBM DB2, Informix, Interbase, and Greenplum
databases.
- Xataface
is a flexible and shapable skin that sits on top of MySQL, making it
accessible to every-day users. It automatically generates the
appropriate forms, lists, and menus for a user to interact with the
database without having to know any SQL. It is a full-featured Web
application framework, and gives developers the flexibility to
customize the features and behavior of their application via
configuration files (using the simple INI-file syntax), templates, and
plug-ins. A generic application with no customizations is completely
functional, but the developer is free to customize things at his
leisure.
- XMLToaster
is a database to XML mapping tool. It provides two-way mapping of XML
documents to database tables using a powerful mapping language with an
understandable SQL-like syntax. Generating XML documents from a
database is very straightforward. It scales to support large and
complex mappings and you can map either plain XML documents or XML
schemas.
- Zebra_Database
is an advanced, compact (one-file only), lightweight, object-oriented
MySQL database wrapper built upon PHP’s MySQL extension. It provides
methods for interacting with MySQL databases that are more intuitive
and fun to use than PHP’s default ones.
Conversie
- OLAP / Data warehousing
- Zie ook:
