介绍
NuoDB发布可扩展的云关系型数据库 http://www.infoq.com/cn/news/2013/03/nuodb
1.下载
wget http://www.nuodb.com/latest/nuodb-1.0.1.linux.x64.tar.gz
2.解压,安装
tar -zxvf nuodb-1.0.1.linux.x64.tar.gz cd nuodb-1.0.1.128.linux.x86_64/
[phoenix@ays1 nuodb-1.0.1.128.linux.x86_64]$ sudo ./run-quickstart [sudo] password for phoenix: [phoenix@ays1 nuodb-1.0.1.128.linux.x86_64]$ sudo ./run-quickstart [sudo] password for phoenix: Setting PATH to /home/phoenix/heming/nuodb-1.0.1.128.linux.x86_64/bin:/sbin:/bin:/usr/sbin:/usr/bin Unable to find the NuoDB demo-archives directory, check that /var/opt/nuodb/demo-archives exists and is writable Press [enter] to continue .... [phoenix@ays1 nuodb-1.0.1.128.linux.x86_64]$ sudo mkdir -p /var/opt/nuodb/demo-archives [phoenix@ays1 nuodb-1.0.1.128.linux.x86_64]$ sudo ./run-quickstart Setting PATH to /home/phoenix/heming/nuodb-1.0.1.128.linux.x86_64/bin:/sbin:/bin:/usr/sbin:/usr/bin This script sets up NuoDB processes and a sample database. Starting up a database named: test Checking for a valid version of java Found java at: /usr/bin/java Found compatible version of Java for NuoDB Starting a NuoDB Broker Waiting for NuoDB Broker to start... Starting a NuoDB Storage Manager Initializing a new archive: /var/opt/nuodb/demo-archives/test Started: [SM] ays1.phoenix/192.168.1.111:9574 [ pid = 4270 ] ACTIVE Starting a NuoDB Transaction Engine Started: [TE] ays1.phoenix/192.168.1.111:39067 [ pid = 4321 ] ACTIVE Creating Sample Quickstart Schema Importing Sample Quickstart Data Capturing Sample Quickstart Database to /tmp/quickstart_capture.txt Use the 'restart' command with this file to restart the database Starting NuoDB Web Console, access via: http://localhost:8080 Starting an interactive SQL session with nuosql Domain name: "domain" User: "quickstart", Password: "quickstart" Database name: "test" DBA Username: "dba", DBA Password: "goalie" Start executing SQL commands at the SQL prompt, such as: SQL> show hockey; SQL> select * from hockey; SQL>
登陆界面
http://192.168.1.111:8080
用户名:密码 domain:bird
管理首页
文档位置
http://www.nuodb.com/community/documentation.php
数据库操作
SQL> help
ALTER DOMAIN Change definition of a domain (not yet implemented)
ALTER SEQUENCE Change definition of a sequence
ALTER TABLE Change definition of a table
ALTER TRIGGER Change definition of a trigger
ALTER USER Change definition of a user
AUTOCOMMIT ON by default. If AUTOCOMMIT is specified as ON, the changes made by each statement are automatically committed as soon as the statement is run. To enable grouping of multiple data manipulation SQL commands into a single atomic transaction, specify AUTOCOMMIT OFF instead.
COMMIT Commit the current transaction
CREATE DATABASE Use NuoDB Console or NuoDB Manager to create and drop databases; you cannot use the NuoDB SQL client for this purpose.
CREATE DOMAIN Define a new domain
CREATE INDEX Define a new index
CREATE PROCEDURE Return the exact string to use to recreate a stored procedure (Not Yet Implemented)
CREATE ROLE Define a new database role
CREATE SCHEMA Define a new schema
CREATE SEQUENCE Define a new sequence
CREATE TABLE Define a new table
CREATE TRIGGER Define a new trigger
CREATE USER Define a new database user account
CREATE VIEW Define a new view. Note limitations with SELECT.
DELETE Remove table rows as specified by WHERE. See also TRUNCATE.
DROP DATABASE Use NuoDB Console to create and drop databases; you cannot use the NuoDB SQL client for this purpose.
DROP DOMAIN Remove a domain from the database
DROP INDEX Remove an index
DROP PROCEDURE Remove a specified procedure or function from storage
DROP ROLE Remove a role from the database
DROP SCHEMA Remove a schema
DROP SEQUENCE Remove a sequence
DROP TABLE Remove a table. See also TRUNCATE.
DROP TRIGGER Remove a trigger
DROP USER Remove a database user account
DROP VIEW Remove a view
EXPLAIN Determine whether or not an index is used in processing a SELECT statement.
GRANT Define access
INSERT Create new rows in a table
RELEASE Release a savepoint. See SAVEPOINT.
RENAME TABLE Rename one or more tables
REPLACE Replace values in a table with new values
REVOKE Remove access privileges
ROLLBACK Stop and end the current transaction.
SAVEPOINT Mark and name a point within a transaction to use with ROLLBACK and RELEASE.
SELECT Retrieve rows from a table or view
SET Set variables that define system behavior
SHOW Display information about schemas, tables, domains, and status of AUTOCOMMIT isolation level.
START TRANSACTION Start a transaction block
TRUNCATE Empty a table
UPDATE Update rows of a table
UPGRADE Change or create tables and indexes. (NuoDB extension)
USE Specify a schema as the default for the current connection to the NuoDB SQL client
SQL>
数据库管理界面
相关推荐
《NuoDB示例应用程序与演示详解》 NuoDB是一种分布式、弹性可扩展的关系型数据库管理系统(RDBMS),以其在云环境中的高可用性和弹性而受到关注。"nuodb-samples"项目则为开发者提供了丰富的示例应用程序和演示,...
Pentaho PDI NuoDB JDBC插件描述Pentaho PDI(ETL)的插件,用于在Pentaho中启用NuoDB JDBC支持。建造mvn clean install发行保持版本1.0与该项目... 搜索并选择PDI NuoDB插件单击“安装此插件”按钮重新启动Pentaho PDE
用于NuoDB的Zend Framework数据适配器 这是社区驱动的NuoDB ... 在使用NuoDB Zend Framework v1数据适配器之前,必须先安装和配置NuoDB PHP PDO驱动程序。 对于Zend Framework v2,不需要适配器。 现有的NuoDB PHP P
Perl DBD(Database Driver)模块是Perl编程语言中与数据库交互的核心组件,它遵循DBI(Database ...安装完成后,便可以在Perl程序中通过DBI接口调用`DBD::NuoDB`,从而与NuoDB数据库建立连接并进行数据操作。
NuoDB-Python 内容该软件包包含社区驱动的纯...最新的稳定版本可在PyPI上获得,并可与pip一起安装: $ pip install pynuodb或者(例如,如果没有pip ),可以从GitHub下载tarball并使用Setuptools进行安装: $ curl -L ...
LiquiBase NuoDB 扩展 支持 NuoDB 的 LiquiBase 扩展 描述 LiquiBase 的扩展,支持 NuoDB SQL 方言和类型转换。 依赖关系 此扩展的当前版本具有以下依赖项: - Liquibase 2.0.3 建造 mvn clean mvn install 测试 ...
第三个文件“探讨NuoDB数据库的架构—1.docx”可能对分布式数据库系统NuoDB进行了深度剖析。NuoDB是一种弹性、分布式的关系型数据库,特别适合云环境。文件可能详细介绍了NuoDB的分片技术、事务处理机制、容错性和...
当前支持的数据库:PostgreSQL, SQL Server, SQL Azure, LocalDB, MySQL, Oracle, IBM DB2, Informix, HP Vertica, NuoDB, Teradata, Sybase ASE, Firebird, SQLite, SQLCe, Access, dBase, FoxPro 等等。...
h2数据库驱动jar包, 更多其他数据库驱动jar包(包括db2,derby,exasol,h2,jtds,mimer,mysql,nuodb,oracle,postgresql,redshift,sqlite,vertica)请看楼主其他资源贴
derby 数据库驱动jar包, 更多其他数据库驱动jar包(包括db2,derby,exasol,h2,jtds,mimer,mysql,nuodb,oracle,postgresql,redshift,sqlite,vertica)请看楼主其他资源贴
MonetDB,MySQL,Neo4j,Netezza,NuoDB,Oracle,PostgreSQL,Presto,SQLite,SQL Server,Sybase,Teradata和Vertica 多种注入策略:正常,错误,堆叠,盲注和时间各种注入过程:默认,Zip,Dios 用于SQL和篡改...
NuoDB Oracle PostgreSQL Redshift SQLite SQL Server Sybase Vertica For other databases you need to obtain the JDBC driver jar file(s) and install in DbVisualizer. Check Installing a JDBC Driver...
在上述代码中,`Class.forName("com.nuodb.jdbc.Driver")`这行用于加载GBase的JDBC驱动,这里的类名可能会根据实际的驱动版本有所不同,请参照驱动文档进行调整。`DriverManager.getConnection(url, username, ...
Fix: (IBM DB2/NuoDB/Oracle) 修正插入物件後移除參數計數 /x 處理(7274) - SQL 編輯器(SQL Editor): Fix: 修正縮排(Increase/Decrease Indent)例外處理(7274) - 資料匯入(Data Import): Add: 新增支持 ...
java Beautifier ffc8d8=af7ac5 7799ee=3498db ee77aa=8e44ad 55aa55=2ecc71 module.html ### Benchmarker目前,这是硬编码的,尽管它可以毫无偏差地损害NuoDB Python,Ruby和JDBC驱动程序的性能。
包括ORACLE、MYSQL、SQLSERVER、DB2、POSTGRESQL、INFORMIX、SYBASE、GBASE、GREENPLUM、HADOOP、TERADATA、HBASE、KUDU、VERTICA、KINGBASE(金仓...FIREBIRD、NETEZZA、MARIADB、MAXDB、MONETDB、NUODB、MONGODB、CACHE等...
NewSQL数据库,如VoltDB和NuoDB,则是在保持ACID属性的同时,提高了大数据环境下的性能,适用于需要高性能事务处理的应用。 课程改革还应关注大数据处理平台,如Hadoop和Spark。Hadoop是分布式计算框架,能够处理和...
- `spring.datasource.driver-class-name`: 驱动类名,对于GBase,应设置为`com.nuodb.jdbc.Driver`(请根据实际版本确认)。 3. **依赖管理**: 在`pom.xml`(如果你的项目是Maven)或`build.gradle`(如果是...
NuoDB和Oracle等数据库产品已经在Docker上实现,这使得数据库层面的扩展变得更加灵活。 在电信行业,容器化正引领网络功能虚拟化(NFV)的趋势,帮助通信服务提供商(CSP)降低成本,提升网络扩展的灵活性。SDN-NFV...