Ein weit verbreitetes Missverständnis steht hinter dem Mythos, dass dynamische SQL langsam ist. Für bedingte WHERE-Klauseln kann eben dieser Mythos zu Performanceproblemen fürhen.
Ibator will introspect a database table (or many tables) and will generate iBATIS artifacts that can be used to access the table(s). This lessens the initial nuisance of setting up objects and configuration files to interact with database tables. Ibator seeks to make a major impact on the large percentage of database operations that are simple CRUD (Create, Retrieve, Update, Delete). You will still need to hand code SQL and objects for join queries, or stored procedures.
The Doctrine Project is the home to several PHP libraries primarily focused on database storage and object mapping. The core projects are a Object Relational Mapper (ORM) and the Database Abstraction Layer (DBAL) it is built upon.
DIVA - is a viewer of database physical structure, it can show you any section of DB in several usable forms (2D, 2.5D, 3D). In this way user can easily understand dependency between tables.
Dataclips allow the results of SQL queries on a Heroku Postgres database to be easily shared. Simply create a query on dataclips.heroku.com, and then share the resulting URL with co-workers, colleagues, or the world. The recipients of a dataclip are able to view the data in their browser or download it in JSON, CSV, XML, or Microsoft Excel formats
Expose your database (or any fine grained subset of it) to executives or business analysts (or any other non-technical personnel) for quick browsing and ad-hoc reports.
Sick of ORM and schemas? select gets right to the point!
Supported databases:
MySQL MongoDB Planned: PostgreSQL, SQLite, CouchDB Researching: Riak, Redis, selector language
IndexedDB is a way for you to persistently store data inside a user's browser. Because it lets you create web applications with rich query abilities, your applications can work both online and offline.
The incremental database reverse engineering (DBRE) add-on allows you to create an application tier of JPA 2.0 entities based on the tables in your database. DBRE will also incrementally maintain your application tier if you add or remove tables and columns.
Egal, ob Ihre Daten in einer Datenbank, in Excel oder in Textdateien vorliegen – InfoZoom verarbeitet alle diese Datenquellen. Der Datenbankassistent hilft Ihne...
This section describes how to build and use the BDB JDBC driver for Android. Note that the BDB JDBC driver cannot currently be built on a Windows platform.
CREATE VIEW INFORMATION_SCHEMA_TABLES AS SELECT 'main' AS TABLE_CATALOG, 'sqlite' AS TABLE_SCHEMA, tbl_name AS TABLE_NAME, CASE WHEN type = 'table' THEN 'BASE TABLE' WHEN type = 'view' THEN 'VIEW' END AS TABLE_TYPE, sql AS TABLE_SOURCE FROM sqlite_master WHERE type IN ('table', 'view') AND tbl_name NOT LIKE 'INFORMATION_SCHEMA_%' ORDER BY TABLE_TYPE, TABLE_NAME;
Comprehensive information about the database as a whole.
This interface is implemented by driver vendors to let users know the capabilities of a Database Management System (DBMS)
One div aims to highlight the potential of CSS3 through a library of single element logos.All icons displayed on the website are realised in pure css with only one html div. The challenge is also to provide an alternative to SVG. Indeed icons allow precise borders preserved even resized (As vector format). Then we can see a clear interest in responsive design.
A web/XML interface and database schema for managing TV series information and user-submitted graphics. Will be interfaced by a number of HTPC plugins and software. Currently used by plugins for Meedio, Media Portal, and XBox Media Center.
Column, index, and stored routine names are not case sensitive on any platform, nor are column aliases. Trigger names are case sensitive, which differs from standard SQL.
SchemaSpy is a Java-based tool (requires Java 5 or higher) that analyzes the metadata of a schema in a database and generates a visual representation of it in a browser-displayable format. It lets you click through the hierarchy of database tables via child and parent table relationships as represented by both HTML links and entity-relationship diagrams. It's also designed to help resolve the obtuse errors that a database sometimes gives related to failures due to constraints.
On Amazon EC2 you can run many of the proven IBM platform technologies with which you’re already familiar, including IBM DB2, IBM Informix, IBM Lotus Forms Turbo, IBM Lotus Web Content Management, IBM Mashup Center, IBM WebSphere Application Server, IBM WebSphere sMash, and IBM WebSphere Portal Server, WebSphere eXtreme, and InfoSphere DataStage/QualityStage with its corresponding Windows client.
C. Batini, T. Catarci, M. Costabile, and S. Levialdi. Proceedings of the IFIP TC2/WG 2.6 Second Working Conference on Visual Database Systems II, page 153--168. Amsterdam, The Netherlands, The Netherlands, North-Holland Publishing Co., (1992)
M. Trzaska, and K. Subieta. AVI '06: Proceedings of the working conference on Advanced visual interfaces, page 500--503. New York, NY, USA, ACM, (2006)
M. Sampaio, J. Quesado, and S. Barros. Advances in Databases and Information Systems, volume 186 of Advances in Intelligent Systems and Computing, Springer Berlin Heidelberg, (2013)
E. Bakke, D. Karger, and R. Miller. Proceedings of the SIGCHI Conference on Human Factors in Computing Systems, page 2541--2550. New York, NY, USA, ACM, (2011)
X. Zhang, B. Pielech, and E. Rundesnteiner. Proceedings of the 4th international workshop on Web information and data management, page 15--22. New York, NY, USA, ACM, (2002)
X. Zhang, K. Liu, L. Zou, X. Du, and S. Wang. Proceedings of the 12th international conference on Web-age information management, page 578--589. Berlin, Heidelberg, Springer-Verlag, (2011)
K. Schmidt, S. Bächle, and T. Härder. Database Systems for Advanced Applications, volume 5667 of Lecture Notes in Computer Science, Springer, Berlin / Heidelberg, (2009)
Q. Chen, A. Therber, M. Hsu, H. Zeller, B. Zhang, and R. Wu. Proceedings of the 2009 International Database Engineering & Applications Symposium, page 43--53. New York, NY, USA, ACM, (2009)