引述 :『萬一不小心把TABLE DROP了, 是否有辦法像WINDOWS一樣從資源回收桶找回來. 在ORACLE 10G版本,recyclebin預設是啟用的.可以透過 USER_RECYCLEBIN and DBA_RECYCLEBIN還有機會找回來被DROP的TABLE 』

引述 :『資料倉儲一詞，於1990年由資料倉儲之父Bill Inmon首次提出，是以分析與查詢為目的所建置的系統，這種系統能整合及運用資料，產生對決策者有用的情報。』

引述 :『Oracle Berkeley DB Java Edition is a open source, embeddable, transactional storage engine written entirely in Java. Like Oracle Berkeley DB, Oracle Berkeley DB Java Edition executes in the address space of the application, without the overhead of client/server communication, allowing developers to store and retrieve information quickly, simply and reliably. Oracle Berkeley DB Java Edition was designed from the ground up in Java. It takes full advantage of the Java environment to simplify development and deployment. The architecture of Oracle Berkeley DB Java Edition supports very high performance and concurrency for both read-intensive and write-intensive workloads.』

引述 :『RailsDB is a web application written in Ruby using the Ruby on Rails web framework. RailsDB provides a generic interface to popular open source databases such as MySQL, PostgreSQL, and SQLite. The RailsDB project is currently under heavy development.』

引述 :『SQLiteSpy is a fast and compact GUI database manager for SQLite. It reads SQLite3 files and executes SQL against them. Its graphical user interface makes it very easy to explore, analyze, and manipulate SQLite3 databases.』

引述 :『Get a head start for your products by leveraging db4o's cutting edge technology to achieve unprecedented levels of performance and flexibility. Simply embed db4o's open source object database engine into your application and store and retrieve even the most complex object structures with only one line of code. Download a free version of db4o under the GPL license and start your free evaluation now!』

引述 :『migrate4j is a database migration tool. Suppose you determine that you need a new database table for your project. If you develop alone, you could write an SQL script that adds a table and manually apply this to your development system. But if you work with other developers, or need to keep a test system in synch with your development system, this become tedious and error prone. Migration tools make it possible to add your new table (or make any other schema changes) in an automated fashion, ensuring all your systems are always in synch. Migration tools also make it possible to quickly and easily roll back previous changes. Unlike typing commands into an interactive SQL window or storing SQL scripts, migration tools keep a detailed history of how your database schema evolved (just in case you need to go back to a previous version). Finally, migration tools minimize or eliminate the problem of having to use vendor specific syntax – you may never switch database products, but if you do, using a migration tool will make your life much easier. The initial intent of migrate4j was to make a Java version of Ruby's db:migrate. If you've used db:migrate, you probably fell in love with it's simple syntax, easy configuration and ability to roll changes up and back effortlessly. The intent (and the challenge) of migrate4j is to bring the power and simplicity of db:migrate to Java programmers, using familiar type safety and syntax. Along the way, we're adding additional functionality that makes migrate4j more than just another Ruby tool rewritten for Java – it is a Java project intended to make other Java projects even better.』

引述 :『MonetDB is a open-source database system for high-performance applications in data mining, OLAP, GIS, XML Query, text and multimedia retrieval. MonetDB often achieves a 10-fold raw speed improvement for SQL and XQuery over competitor RDBMSs. Use the product strands as your roadmap for exploration.』

引述 :『Taffy DB is a free and opensource JavaScript library that acts as thin data layer inside Web 2.0 and Ajax applications. 』

引述 :『Hypertable is an open source project based on published best practices and our own experience in solving large-scale data-intensive tasks. Our goal is to bring the benefits of new levels of both performance and scale to many data-driven businesses who are currently limited by previous-generation platforms. Our goal is nothing less than that Hypertable become the world’s most massively parallel high performance database platform.』

引述 :『Are you using an Object Oriented Language to build your computer systems ? Are you using a relational Database to store you data ? If you answered yes to these two questions then you are at the right place! Productivity loss : Do you have any idea of how much time your team is wasting to convert objects to tables by implementing/using a mapping technology between Object World and Relational World ? Performance loss : Do you have any idea of how much time and memory your system is spending to do the conversion ? To avoid Impedance mismatch overhead between Object and Relational worlds, give a try to Neodatis ODB. NeoDatis ODB is a new generation Object Database: a real native and transparent persistence layer for Java and .Net.. Object because the basic pesistent unit is an object, not a table. Native & Transparent because it directly persists objects the way they exist in the programming language, without any conversion. Using NeoDatis ODB as your persistence layer will let you concentrate on your business logic allowing storing and retrieving native objects in a single line of code. No more relational to Object mapping is necessary, ODB just persist objects the way they are, no matter their complexity.』

引述 :『The DBacesslayer aka DBSlayer aka Släyer (as we like to call it when we're feeling ironically heavy metal) is a lightweight database abstraction layer suitable for high-load websites where you need the scalable advantages of connection pooling. Written in C for speed, DBSlayer talks to clients via JSON over HTTP, meaning it's simple to monitor and can swiftly interoperate with any web framework you choose. The DBSlayer originated as an internal tool at the New York Times. The typical LAMP strategy for scaling up data-driven applications is to replicate slave databases to every web server, but this approach can hit scaling limitations for high-volume websites, where processes can overwhelm their given backend DB's connection limits. Quite frankly, we wanted to scale the front-end webservers and backend database servers separately without having to coordinate them. We also needed a way to flexibly reconfigure where our backend databases were located and which applications used them without resorting to tricks of DNS or other such "load-balancing" hacks. Plus, it just seemed really cool to have a JSON-speaking DB layer that all our scriptable content could talk to. Thus, the DBSlayer was born.』

引述 :『隨服務的資料越來越多，有些 sql 會開始變慢，除了重新調整 sql 語法之外，漸漸地一些欄位要開始加 index 以維持一定的效能。這裡收集一些跟 index 相關的筆記』

引述 :『Welcome to H2, the free SQL database. The main feature of H2 are: * Very fast, free for everybody, source code is included * Written Java; can be compiled with GCJ (Linux) * Embedded, Server and Cluster modes * JDBC and (partial) ODBC API; Web Client application 』