jquery实用插件

PostgreSQL is an object-relational database management system (ORDBMS) based on
POSTGRES, Version 4.2, developed at the University of California at Berkeley Computer
Science Department. POSTGRES pioneered many concepts that only became available in some
commercial database systems much later.
Features PostgreSQL is an open-source descendant of this original Berkeley code. It
supports SQL92 and SQL99 and offers many modern features:
complex queries
foreign keys
triggers
views
transactional integrity
multiversion concurrency control
Additionally, PostgreSQL can be extended by the user in many ways, for exampleby
adding new

data types
functions
operators
aggregate functions
index methods
procedural languages
And because of the liberal license, PostgreSQL can be used, modified, and distributed by
everyone free of charge for any purpose, be it private, commercial, or academic.

Advantages PostgreSQL offers many advantages for your company or business over other
database systems.
1) Immunity to over-deployment
Over-deployment is what some proprietary database vendors regard as their #1 licence
compliance problem. With PostgreSQL, no-one can sue you for breaking licensing agreements,
as there is no associated licensing cost for the software.
This has several additional advantages:
More profitable business models with wide-scale deployment.
No possibility of being audited for license compliance at any stage.
Flexibility to do concept research and trial deployments without needing to include
additional licensing costs.
2) Better support than the proprietary vendors
In addition to our strong support offerings, we have a vibrant community of PostgreSQL
professionals and enthusiasts that your staff can draw upon and contribute to.
3) Significant saving on staffing costs
Our software has been designed and created to have much lower maintenance and tuning
requirements than the leading proprietary databases, yet still retain all of the features, stability,
and performance.
In addition to this our training programs are generally regarded as being far more cost
effective, manageable, and practical in the real world than that of the leading proprietary database
vendors.
4) Legendary reliability and stability
Unlike many proprietary databases, it is extremely common for companies to report that
PostgreSQL has never, ever crashed for them in several years of high activity operation. Not
even once. It just works.
5) Extensible
The source code is available to all at no charge. If your staff have a need to customise or
extend PostgreSQL in any way then they are able to do so with a minimum of effort, and with no
attached costs. This is complemented by the community of PostgreSQL professionals and
enthusiasts around the globe that also actively extend PostgreSQL on a daily basis.
6) Cross platform
PostgreSQL is available for almost every brand of Unix (34 platforms with the latest stable
release), and Windows compatibility is available via the Cygwin framework. Native Windows
compatibility is also available with version 8.0 and above.
7) Designed for high volume environments
We use a multiple row data storage strategy called MVCC to make PostgreSQL extremely
responsive in high volume environments. The leading proprietary database vendor uses this
technology as well, for the same reasons.
8) GUI database design and administration tools

Several high quality GUI tools exist to both administer the database (pgAdmin, pgAccess)
and do database design (Tora, Data Architect).

1, teller ['telə]
n. （美）出纳员；讲述者；讲故事者；计票员

2, reservation [,rezə'veiʃən]
n. 预约，预订；保留
3, at will
随意；任意
4, pioneer [,paiə'niə]
n. 先锋；拓荒者
vt. 开辟；倡导；提倡
vi. 作先驱

5, proprietary [prə'praiətəri]
a. 专利的(所有的)
n. 所有权(所有人)

6, globe [gləub]
n. 地球,地球仪,球体

7, volume ['vɔlju:m; (US) -jəm]
n. 体积,容量,音量
n. 卷,册

Continue reading it-e-33 PostgreSQL

mongoDB 笔记

15 Jun 2011 in 数据库 on mongodb, nosql

官网

http://www.mongodb.org

java driver下载:

https://github.com/mongodb/mongo-java-driver/downloads

先看

http://www.mongodb.org/display/DOCS/Quickstart

要在windows下安装为service，见

http://www.mongodb.org/display/DOCS/Windows+Service

具体命令是

mongod --port 13668 --logpath D:/mongodb-win32-i386-1.8.1/log/mongo.log --logappend --dbpath D:/mongodb-win32-i386-1.8.1/data --directoryperdb --serviceName MongoDb_181 –install

注意建议不要使用参数 --bind_ip 127.0.0.1 ，这样的话只能通过127.0.0.1来连接，使用局域网ip和localhost则不能连上

对应的删除命令是:

mongod --serviceName MongoDb_181 --remove

如果不需要作为服务，去掉上面的命令中的—install 和 --serviceName 参数即可

即:

mongod --port 13668 --logpath D:/mongodb-win32-i386-1.8.1/log/mongo.log --logappend --dbpath D:/mongodb-win32-i386-1.8.1/data –directoryperdb

注意文档中有些问题：

--logpath 参数必须是个文件，不能是文件夹

--dbpath 所指向的文件夹必须已经存在，否则安装成功却启动不了，总是重复启动--失败

更多命令参数见 --help

突然看到这篇文章:
为什么我们放弃使用MongoDB
说的是比较实际的问题
32为系统文件大小限制，由于底层内存映射的实现造成的。
但是再看看
我为什么选择MongoDB
mongodb使用心得
想想，就当吃吃螃蟹吧。
具体我的体会等用过了再写。

对应的客户端命令则是mongo --port 13668

使用help查看帮助

使用db.help()查看db操作帮助

use 命令可切换到指定数据库，不存在的话就会创建一个，但不是马上创建，而是在插入数据时创建。

使用db.addUser添加用户到某个数据库，注意是指定的数据库，其他的数据库是不存在这个用户的.

关于权限管理可参见 http://blog.csdn.net/a9529lty/archive/2011/05/31/6457279.aspx

验证的顺序也是一样，先转到某个数据库，再验证用户。

参见这篇文章快速入门http://blog.sina.com.cn/s/blog_661b4cd50100h8zk.html

使用java 见http://www.mongodb.org/display/DOCS/Java+Tutorial

它的依赖很简单，只要添加驱动依赖包就可以say hello world!了:

>public class HelloWorls { public HelloWorls() { } public static void main(String[] args) { try { Mongo m = new Mongo( "192.168.666.666" , 13668 );

Continue reading mongoDB 笔记

it-e-32 Introduction to DBMS

14 Jun 2011 in 英语 on english, it

A database management system (DBMS) is an important type of programming system, used
today on the biggest and the smallest computers. [1]As for other major forms of system software,
such as compilers and operating systems, a well-understood set of principles for database
management systems has developed over the years, and these concepts are useful both for
understanding how to use these systems effectively and for designing and implementing DBMS's.
DBMS is a collection of programs that enables you to store, modify, and extract information
from a database. There are many different types of DBMS's, ranging from small systems that run
on personal computers to huge systems that run on mainframes. The following are the location of
database between application programs and end-users.

There are two qualities that distinguish database management systems from other sorts of
programming systems.
1) The ability to manage persistent data, and
2) The ability to access large amounts of data efficiently.

Point 1) merely states that there is a database which exists permanently; the contents of this
database is the data that a DBMS accesses and manages.

Point 2) distinguishes a DBMS from a
file system, which also manages persistent data. A DBMS's capabilities are needed most when
the amount of data is very large, because for small amounts of data, simple access techniques,
such as linear scans of the data, are usually adequate.
[2]While we regard the above two properties of a DBMS as fundamental, there are a number
of other capabilities that are almost universally found in commercial DBMS's. These are:
Support for at least one data model, or mathematical abstraction through which the user can
view the data.

Support for certain high-level languages that allow the user to define the structure of data,
access data, and manipulate data.
Transaction management, the capability to provide correct, concurrent access to the database
by many users at once.
Access control, the ability to limit access to data by unauthorized users, and the ability to
check the validity of data.
Resiliency, the ability to recover from system failures without losing data.
Data Models Each DBMS provides at least one abstract model of data that allows the user
to see information not as raw bits, but in more understandable terms. In fact, it is usually possible
to see data at several levels of abstraction. At a relatively low level, a DBMS commonly allows
us to visualize data as composed of files.
Efficient File Access The ability to store a file is not remarkable: the file system associated
with any operating system does that. The capability of a DBMS is seen when we access the data of
a file. For example, suppose we wish to find the manager of employee "Clark Kent". If the
company has thousands of employees, It is very expensive to search the entire file to find the one
with NAME="Clark Kent". A DBMS helps us to set up "index files," or "indices," that allow us to
access the record for "Clark Kent" in essentially one stroke no matter how large the file is. Likewise,
insertion of new records or deletion of old ones can be accomplished in time that is small and
essentially constant, independent of the file’s length. Another thing a DBMS helps us do is navigate
among files, that is, to combine values in two or more files to obtain the information we want.
Query Languages To make access to files easier, a DBMS provides a query language, or
data manipulation language, to express operations on files. Query languages differ in the level of
detail they require of the user, with systems based on the relational data model generally
requiring less detail than languages based on other models.

Transaction Management

Another important capability of a DBMS is the ability to
manage simultaneously large numbers of transactions, which are procedures operating on the
database. Some databases are so large that they can only be useful if they are operated upon
simultaneously by many computers: often these computers are dispersed around the country or
the world. The database systems used by banks, accessed almost instantaneously by hundreds or
thousands of automated teller machines (ATM), as well as by an equal or greater number of
employees in the bank branches, is typical of this sort of database. An airline reservation system
is another good example.
Sometimes, two accesses do not interfere with each other. For example, any number of
transactions can be reading your bank balance at the same time, without any inconsistency. [3]But
if you are in the bank depositing your salary check at the exact instant your spouse is extracting
money from an automatic teller, the result of the two transactions occurring simultaneously and
without coordination is unpredictable. Thus, transactions that modify a data item must “lock out”
other transactions trying to read or write that item at the same time. A DBMS must therefore
provide some form of concurrency control to prevent uncoordinated access to the same data item

by more than one transaction.
Even more complex problems occur when the database is distributed over many different
computer systems, perhaps with duplication of data to allow both faster local access and to
protect against the destruction of data if one computer crashes.
Security of Data A DBMS must not only protect against loss of data when crashes occur,
as we just mentioned, but it must prevent unauthorized access. For example, only users with a
certain clearance should have access to the salary field of an employee file, and the DBMS must
be able associate with the various users their privileges to see files, fields within files, or other
subsets of the data in the database. Thus a DBMS must maintain a table telling for each user
known to it, what access privileges the user has for each object. For example, one user may be
allowed to read a file, but not to insert or delete data; another may not be allowed to see the file at
all, while a third may be allowed to read or modify the file at will.

DBMS Types
Designers developed three different types of database structures: hierarchical, network, and
relational. Hierarchical and network were first developed but relational has become dominant.
While the relational design is dominant, the older databases have not been dropped. Companies
that installed a hierarchical system such as IMS in the 1970s will be using and maintaining these
databases for years to come even though new development is being done on relational systems.
These older systems are often referred to as legacy systems.

1, teller ['telə]
n. （美）出纳员；讲述者；讲故事者；计票员

2, reservation [,rezə'veiʃən]
n. 预约，预订；保留
3, at will
随意；任意

Continue reading it-e-32 Introduction to DBMS

word 标题自动编号

13 Jun 2011 in 默认分类 on word, 办公

2007开始/段落第三个按钮

一图抵千言

注意红框框里面的内容（1 标题这样的），不要选别的，选别的就不好排版了。这样之后只要在想要作为标题的行点击样式里面对应的标题级别，word会依据级别来整理。

要自定义的话，可参见

http://blog.sina.com.cn/s/blog_6238dcdb0100qz8j.html

不过比较复杂哦!

Continue reading word 标题自动编号

业务用例与系统用例的区别

13 Jun 2011 in 软件工程 on uml, 软件设计

一个业务用例描述的是业务过程——而不是软件系统过程。
一个业务用例为涉众创造价值。这些涉众要么是业务参与者要么是业务工作者。
一个业务用例可以超越组织的边界。有些构架师对于这一点有非常严密的态度。许多业务用例确实超越来组织的边界，但是有些业务用例仅仅关注于一个组织。

1．业务用例就是要完成的业务，系统用例是系统要做的事情，两者的域不同。
2．业务建模主要描述了该项目涉及的所有业务，需求模型主要是描述为了满足业务需求系统要做什么，因此，需求模型与业务模型相比，它描述的只是业务模型的一个子集。
3．比方说我们设计一个自动提款机系统，它可以满足用户的取款、改密、查询等需求，那么这些需求就是业务用例；但是用户又分为借记卡用户和信用卡用户，那么根据业务规则，不同的卡用户的取款、改密、查询的过程是不一样的，所以系统为了满足这种业务需求会包含到两个子用例里实现，这种子用例就是系统用例。也就是说系统用例就是系统为了满足这种业务需求要做什么。

为什么要区别这些？可能在你的用例图中就混杂了这两种用例。

参见：

http://www.uml.org.cn/requirementproject/200707024.asp

http://gaojiewyh.iteye.com/blog/408363

http://www.cnblogs.com/rhcad/archive/2010/06/11/1756173.html

Continue reading 业务用例与系统用例的区别

it-e-31 Steganography and Honeytokens

10 Jun 2011 in 英语 on english, it

Steganography is a method of embedding electronic messages into a media file (for example, an image or audio file) by altering nonessential lines of code; the changes are imperceptible. The message remains undetected until unencrypted. Honeytokens is any kind of tantalizing false data, including phony patient records at a hospital, lists of invalid social security numbersor even simply a word processing file named "HR-salaries," that's stored in a restricted part of the network. If anyone tries to access the files the security team is alerted to the trespassing before the intruder can do any real damage.

1, imperceptible [,impə'septəbl]
a. 不能感知的,不知不觉的,微细的

2, steganography [,stegə'nɔgrəfi]
n. 速记式加密
3, tantalizing ['tæntəlaiziŋ]
a. 诱人的
4, phony ['fəuni]
a. 假的,伪造的
5, trespassing
n. 擅自进入
v. 侵入；犯罪（trespass的ing形式）
6, intruder [in'tru:də]
n. 侵入者,干扰者,妨碍者

Continue reading it-e-31 Steganography and Honeytokens

ServiceMix环境配置

10 Jun 2011 in java on esb, j2ee, java

配置使用的ServiceMix版本是servicemix-3.3，在tomcat5.5以上运行。(因为依赖包大部分是需要jdk1.5)

ServiceMix有三种部署方式：单独程序方式，servlet方式，与Geronimo and JBoss.整合方式。这里主要介绍servlet方式，因为这样可以整合到任何servlet容器中。

Servlet部署需要在web.xml中配置spring加载文件，这种spring是和xbean整合的自定义配置文件。

配置文件说明:

Web.xml

<?xml version="1.0" encoding="UTF-8"?>

<!DOCTYPE web-app

PUBLIC "-//Sun Microsystems, Inc.//DTD Web Application 2.3//EN"

"http://java.sun.com/dtd/web-app_2_3.dtd">

<web-app>

<display-name>ServiceMix Web Application</display-name>

<description>Deploys ServiceMix inside a Web Application</description>

<context-param>

<param-name>contextConfigLocation</param-name>

<param-value>/WEB-INF/jmx.xml /WEB-INF/core.xml /WEB-INF/activemq.xml</param-value>

</context-param>

Spring配置文件

<context-param>

<param-name>contextClass</param-name>

<param-value>org.apache.xbean.spring.context.XmlWebApplicationContext</param-value>

</context-param>

<listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>

</listener>

Spring 监听器

<servlet-name>JMXServlet</servlet-name>

<servlet-class>org.apache.servicemix.web.jmx.JMXServlet</servlet-class>

<load-on-startup>1</load-on-startup>

</servlet>

<servlet-name>HttpManagedServlet</servlet-name>

<servlet-class>

org.apache.servicemix.http.HttpManagedServlet

</servlet-class>

<load-on-startup>1</load-on-startup>

</servlet>

http bean组件(BC)servlet

<servlet-mapping>

<servlet-name>HttpManagedServlet</servlet-name>

<url-pattern>/jbi/*</url-pattern>

</servlet-mapping>

<servlet-mapping>

<servlet-name>JMXServlet</servlet-name>

<url-pattern>/jmx/*</url-pattern>

</servlet-mapping>

</web-app>

demo主要功能的配置在core.xml中:

<?xml version="1.0" encoding="UTF-8"?>

<beans xmlns:sm="http://servicemix.apache.org/config/1.0"

xmlns:http="http://servicemix.apache.org/http/1.0"

xmlns:my="http://servicemix.apache.org/demo/"

xmlns:foo="http://servicemix.apache.org/demo/">

<sm:container id="jbi"

rootDir="#rootDir"

useMBeanServer="true"

createMBeanServer="false"

MBeanServer="#jmxServer"

installationDirPath="#installDir"

deploymentDirPath="#deployDir"

monitorInstallationDirectory="true"

transactionManager="#transactionManager"

depends-on="broker">

<sm:activationSpecs>

<sm:activationSpec componentName="servicemix-http" service="foo:httpBinding" destinationService="foo:echo">

<sm:component>

<http:component>

<http:configuration managed="true" />

<http:endpoints>

<http:endpoint service="foo:httpBinding"

endpoint="endpoint"

targetService="foo:echo"

role="consumer"

locationURI="http://localhost/exampleUri/

配置url，会被tomcat自动转换为serverapp/jbi/ exampleUri

defaultMep="http://www.w3.org/2004/08/wsdl/in-out

消息请求方式是in-out,即期望又返回消息

" />

</http:endpoints>

</http:component>

</sm:component>

</sm:activationSpec>

使用http BC,作为一个消费者(consumer)目标指向服务引擎(SE)foo:echo

<sm:activationSpec componentName="echo" service="foo:echo" >

<sm:component>

</bean>

</sm:component>

</sm:activationSpec>

SE foo:echo,这是一个简单的helloworld

</beans>

经过这样的配置和在web.xml中配置的servlet,那么uri pattern形如 /jbi/exampleUri会请求foo:httpBinding (BC)，在ESB内部foo:httpBinding通过消息路由(normalized message router)与foo:echo通信。

Web测试页面链接为http://localhost:(tomcat端口)/ESB-ServerMix-Web/examples/

需要在firefox下测试。

测试页面使用ajax请求/jbi/exampleUri经过foo:httpBinding, foo:echo处理返回信息。

Continue reading ServiceMix环境配置

为什么选用PostgreSQL，而不是Oracle？

Pagination