斑竹及各位大侠请注意:InterBase数据库讨论?

oldbone 2002-06-03 05:49:50
请各位大侠,能否用讨论一下用InterBase、sql server和db2等网络数据库做c/s数据库的优劣,
本人认为sql server和db2等尽管功能强大,但对于小公司以及小型应用他们好像又有点“杀鸡用了刀”,同时这些产品本身的价格就比较高,这样就无形中增加了产品的成本,这对于小公司的来说也就增加了开发成本。而这一点InterBase的优势显然是明显的,但是目前好像bcb自带的Interbase有用户的限制,并且InterBase的据说有时间的限制,所以,我非常迷茫,因此请斑竹及各位大侠能为小弟广进良言;
另外,不知斑竹及各位大侠是否知道目前国内有那些产品是用InterBase做的;
多谢^_^!!!
...全文
45 24 打赏 收藏 转发到动态 举报
写回复
用AI写文章
24 条回复
切换为时间正序
请发表友善的回复…
发表回复
oldbone 2002-06-19
  • 打赏
  • 举报
回复
to erickleung() :
duo xie
erickleung 2002-06-14
  • 打赏
  • 举报
回复
到http://www.hksoftware.net/download/ 下载个 ibexpert. 这是个很快用
的interbase/firebird管理工具, 只要数据库不大於50M, 这个工具是完全免费.

其他有ibadmin (http://www.sqlly.com)也很方便.

http://www.ibphoenix.com
http://www.ibobjects.com
都有许多interbase方便的资源,和叁考文件.
oldbone 2002-06-14
  • 打赏
  • 举报
回复
现在我已经用firebird 1.0做c/s数据库,目前感觉还可以,不知各位大侠在这方面有什么执教
oldbone 2002-06-13
  • 打赏
  • 举报
回复
gz
erickleung 2002-06-09
  • 打赏
  • 举报
回复
To: oldbone(程序阿Q)
要看你喜欢用那种开发工具, 用vb, vc开发为主的, 通常都用MS SQL会较好.
但随着企业收紧开发预算, 使用免费的数据库是大势所趋. 由於interbase
已有一定的使用历史, 便更有信心了.

我们公司使用interbase在公司报价资料系统和人事上班出勤纪录也有1年了,
不曾出过任何问题. 也不曾用reboot server一次.

我是使用ibobjects来开发的. 不用任BDE或ODBC, 完成後我只需把
1. MyMainProg.exe (主程式)
2. gds32.dll (interbase的engine)
放在server让所有用户使用, 他们便可以直接使用在另一linux server的
interbase database文件. 由於用户不可进入linux server, 所有数据
都是很安全的.


erickleung 2002-06-09
  • 打赏
  • 举报
回复
如 Yang_(扬帆破浪)兄所说. Windows XP 的System Restored 会把
interbase的数据库文件 .gdb 会不断的复制. 这是M$另一不正当打击
手段, 使用户觉得是interbase本身很慢. 所以在xp下, 你最好把.gdb
改为其他名字来避开不需要的复制.
oldbone 2002-06-09
  • 打赏
  • 举报
回复
如果用interbase开发c/s数据库,不知各位大侠有什么高见?望赐教!!!
oldbone 2002-06-05
  • 打赏
  • 举报
回复
gz
erickleung 2002-06-04
  • 打赏
  • 举报
回复
自己看;
New features in Interbase 6.5
http://community.borland.com/article/0,1410,28107,00.html

其中 firebird 是无 interbase 6.5 的 rows 项:

SELECT * FROM SALES
ORDER BY DISCOUNT DESC
ROWS 1 TO 5

The ORDER BY clause sorts the returned records in descending order by DISCOUNT and the ROWS clause limits the number of rows returned to the first five. Although you can use ROWS without ORDER BY it would be unusual to do so since limiting the number of rows infers that you want the first N rows based on some order. As long as the first row you want returned is the first row in the result set you can shorten the query to

SELECT * FROM SALES
ORDER BY DISCOUNT DESC
ROWS 5

If you want all of the rows that have the same values in the fields in the ORDER BY clause as the first five rows use the WITH TIES option shown below.

SELECT * FROM SALES
ORDER BY DISCOUNT DESC
ROWS 1 TO 5 WITH TIES

This query returns eight rows instead of five because some of the values that appear in the DISCOUNT field in the first five rows also appear in other rows. Note that you must use an ORDER BY clause when you use WITH TIES.

Instead of a fixed number of rows you can also request a percentage of the rows in the result set as shown in the following query which returns the top 10% of the rows in SALES by TOTAL_VALUE.

SELECT * FROM SALES
ORDER BY TOTAL_VALUE DESC
ROWS 10 PERCENT

Another interesting use of the PERCENT option is to select an evenly distributed subset of rows. This query returns five rows with each of those rows separated from its neighbor by 20% of the rows in the table. Although this query does not use an ORDER BY clause it could. For example, to obtain an even distribution of rows geographically you could order the table by state or zip code.

SELECT * FROM CUSTOMER
ROWS 100 BY 20 PERCENT

You can also use the ROWS clause in conjunction with aggregates. The following query returns the top three sales reps based on the total value of their orders while the second query returns the top 25% of sales reps based on the total value of their orders.

SELECT SALES_REP, SUM(TOTAL_VALUE) AS TOTAL
FROM SALES
GROUP BY SALES_REP
ORDER BY 2 DESC
ROWS 3

SELECT SALES_REP, SUM(TOTAL_VALUE) AS TOTAL
FROM SALES
GROUP BY SALES_REP
ORDER BY 2 DESC
ROWS 25 PERCENT

The ROWS clause can also be used with UPDATE to give the ten highest paid employees a raise.

UPDATE EMPLOYEE
SET SALARY = SALARY * 1.01
ORDER BY SALARY DESC
ROWS 10

You can also use ROWS with DELETE to delete the ten highest paid employees. If you want to delete everyone whose salary is equal to one of the ten highest paid employees just add the WITH TIES option.

DELETE FROM EMPLOYEE
ORDER BY SALARY DESC
ROWS 10

希望 firebird 2.0都加回这些功能便好了.
oldbone 2002-06-04
  • 打赏
  • 举报
回复
除了速达公司的产品,还有其它公司采用InterBase吗?
Yang_ 2002-06-04
  • 打赏
  • 举报
回复
速达都是用BCB+INTERBASE的!
Yang_ 2002-06-04
  • 打赏
  • 举报
回复

《速达3000》单机版 以业务为基础,财务为核心。包括进货管理、销售管理、仓库管理、帐务系统、工资管理等子系统。繁简版自选安装、使用大型数据库interbase5.0,数据安全性更高。
价格:880 元 【购 买】 详细信息>>

《速达3000》10用户版 以业务为基础,财务为核心。包括进货管理、销售管理、仓库管理、帐务系统、工资管理等子系统。繁简版自选安装、使用大型数据库interbase5.0,数据安全性更高。
价格:5880 元 【购 买】 详细信息>>

oldbone 2002-06-04
  • 打赏
  • 举报
回复
如果用interbase开发c/s数据库,不知各位大侠有什么高见?望赐教!!!
ozzzzzz 2002-06-04
  • 打赏
  • 举报
回复
其实interbase应该说是个很好的中型数据库 但是可惜没有一个好公司推
Yang_ 2002-06-04
  • 打赏
  • 举报
回复
听说微软有意修改一些接口,使得InterBase不好用。
ozzzzzz 2002-06-03
  • 打赏
  • 举报
回复
哦 是不是从 3asoft.com过来的
oldbone 2002-06-03
  • 打赏
  • 举报
回复
to erickleung:
不知大侠对InterBase6.5有何高见!!!
erickleung 2002-06-03
  • 打赏
  • 举报
回复
相信不多吧. 真正完全免费的firebird 1.0正式版也是在今年3月才发行.我替
公司写的程序, 是用firebird for linux(当时是beta版)做後端, 已用了1年
了, 不曾需要reboot过. 因为interbase原自unix环境, 我相信用linux/unix
会最稳定.

最流行interbase的地区, 相信是在东欧和俄国, 美国军部也用了不少.
最特别的是每部 M1A 主力坦克车都是由一个interbase数据库做支援系统的.
因为他是启动最快的数据库!

oldbone 2002-06-03
  • 打赏
  • 举报
回复
to erickleung:
国内有产品用的是InterBase吗?
erickleung 2002-06-03
  • 打赏
  • 举报
回复
# 1997, February 26: Borland ships BCB 1.
# 1997, April 29: Borland forms ISC subsidiary to expand market opportunity for its InterBase product.
# 1997, May 5: Borland announces Delphi 3 C/S Suite. Interbase 4.2 is included with Delphi 3.
# 1997, July 15: Corel licenses SQL Builder, Interbase, LIBS and SQL Links from Borland to include them in Corel Paradox 8.
# 1997, September 15: Interbase unveils InterClient ready to ship.
# 1997, December 1: Interbase 5.0 is released.
# 1998, February 10: Borland announces BCB 3. With BCB, Interbase 5 is included.
# 1998, June 8: Borland international stockholders approve name change to Inprise Corporation.
# 1998, August 5: Interbase 5.1.1 is included with Delphi 4.
# 1998, August 12: Inprise transfers Visual dBase to Interbase subsidiary.
# 1998, August 20: Interbase 5 for Linux is announced.
# 1999, January 27: Inprise creates two separate divisions: Inprise and borland.com. Jim Weil, president of Interbase, is named president of the Inprise division. John Floisland, senior VP of worldwide marketing, is named president of borland.com.
# 1999, February 2: Inprise launches borland.com. Interbase 5.5 is included with BCB4.
# 1999, March: FIBPlus version 1 by Serge Buzadzhy.
# 1999, March 12: Inprise licenses Visual dBase to Ksoft, Inc.
# 1999, March 31: Inprise announces the resignation of Delbert Yocam (CEO) and the CFO.
# 1999, April 13: Inprise names Dale Fuller interim President and CEO.
# 1999, mid: Interbase 6 - kinobi in private beta testing.
# 1999, June 8: MS and Borland deal. The total value of investment and payment from MS to Inprise is US$125 million. This includes the right to use Inprise-patented technology in MS products.
# 1999, August: FIBPlus version 2.
# 1999, September 7: Inprise announces an alliance with Dunstan Thomas Limited to provide professional services for Inprise technology in the UK, Nordic, Benelux and Eastern European regions. Dunstan Thomas is an Interbase partner, too.
# 1999, September 10: Inprise ships Delphi 5 with Interbase 5.5.
# 1999, October 25: Interbase 5.6 available on Novell Netware 4.2 and 5.0 and Windows platforms (32 bits). IB5.6 was offered as a free upgrade for IB5.X licensees on Windows; for the first time a free upgrade.
# 1999, December 14: The resignation of 3 key people at ISC (Bill Karwin, Paul Beach and Wayne Ostiguy) halts Interbase development.
# 1999, December 17: Greg Deatz discovers the facts and posts to Mers with "Bad rumors abound" subject. Steve Tendon coined the term "black Friday" to refer to the exact date when the bad news were known. (Ironically, this day was my birthday, so I couldn't receive a worst gift.) First fiasco. Tidal waves start flooding Borland newsgroups. The "SaveInterbase" emailing list is created by Helen Borrie to avoid losing IB forever. The IBDI Group (IB Developer's Initiative) is founded by Helen Borrie, Jason Wharton and Dalton Calford to safeguard the interests of Interbase users.
# 1999, December 21: Two other ISC engineers resign.
# 2000, January 3: Borland announces IB6 will be open sourced and challenges other vendors to open-source their database products. SaveInterbase is replaced by IBDI. Borland's shares soar for some weeks as a result of the announcement.
# 2000, February 7: Corel - Inprise/Borland announce a future merger to create a Linux powerhouse in the next months.
# 2000, February 14: A new company is being created. Ann Harrison accepts the challenge of being the new ISC President and Jim Starkey will be technical advisor. (Isn't that Apple brought back its former people, too?) A series of IB-*** emailing lists are created with specific purposes.
# 2000, February 29: Paul Beach named Interbase VP Sales & Marketing.
# 2000, March, 22: Borland announces availability of BCB5. It ships with Interbase 5.6.
# 2000, April 27: Due to lobby from some shareholders and users, Borland reevaluates the merger with Corel.
# 2000, May 16: Borland and Corel terminate proposed merger.
# 2000, May: FIBPlus version 3.
# 2000, June 30: Second fiasco. IB6 is not released in time as expected due to pending legal issues.
# 2000, July 14: Dale Fuller authorizes Cobalt Networks to distribute IB6 binaries with their platforms.
# 2000, July 25: Inprise and not ISC is the company releasing Interbase 6.0 as a free and open source database, but without the documents and without the basic test suites. Is this a decent and honest open source offering? No ISC exists as an independent or subsidiary company.
# 2000, July 28: Third fiasco. Ann Harrison resigns to her position of acting as General Manager for the Interbase part of Borland. The deal between ISC and Borland has died. Borland's Ted Shelton delivers an official press release to IB-Architect before the article is posted in the web site. Borland prefers to retain the product "in the interest of shareholders".
# 2000, July 31: A group of enthusiast people create the Firebird tree at Source Forge, because the Interbase tree doesn't admit external people as developers.
# 2000, August 23: The IBPhoenix group unveils the www.ibphoenix.com site, with Ann Harrison and Paul Beach among others. Ann states that IBPhoenix is not affiliated with Inprise(r) in any way.
# 2000, September 8: Inprise publishes an open letter to our InterBase® customers, signed by Frank Slootman VP - Software Products. The person that established the first contact after the ISC deal died, Ted Shelton, is not longer in charge of the engine, because it was transferred to the Business/Enterprise division, even thought the Inprise website doesn't reflect that change at that time.
# 2000, November 27: Inprise issues a press release, announcing Jon Arthur's promotion to Director of Interbase, reporting to Frank Slootman, VP of Software Products.
# 2000, December 18: Frank Schlottmann-Goedde spots an hard coded password plus a bizarre internal UDF in IB, while working on the Firebird Project. Those breaches were there since 1994. Inprise is alerted discretely.
# 2001, January: Inprise is Borland again.
# 2001, January: FIBPlus version 4.
# 2001, January 10: CERT advisory: compiled back door plus doomsday internal UDF in IB made public along with different patches from IBPhoenix and Borland.
# 2001, January 11: Slashdot devotes a large thread to the backdoor.
# 2001, January 14: The Register publishes an article about the same security breach.
# 2001, March 14: Borland comes back to the paid releases.
# 2001, July 19: IBO v4 is released.
# 2001, November: Yaffil development is initiated by Aleksey Karyakin and Oleg Loa, based on Firebird, with improved productivity.
# 2001, December 4: Borland announces IB 6.5. Do not get confused by that press release, however, since the open source version doesn't have the new features listed here. Bill Todd's explanation of the same features is here.
# 2002, January: IBDI founders announce the dissolution of the group. Technical content moved to the Firebird site.
# 2002, March 12: Firebird 1.0 Final Release

据http://www.cvalde.com/WhoUsesIB.htm所报导, 都有许多大机构是用
interbase的.
加载更多回复(4)
PostgreSQL是以加州大学伯克利分校计算机系开发的POSTGRES,现在已经更名为PostgreSQL. PostgreSQL支持大部分SQL标准并且提供了许多其它现代特性:复杂查询、外键、触发器、视图、事务完整性等。 PostgreSQL 是一个免费的对象-关系数据库服务器(数据库管理系统),它在灵活的 BSD-风格许可证下发行。它提供了相对其他开放源代码数据库系统(比如 MySQL 和 Firebird),和专有系统(比如 Oracle、Sybase、IBM 的 DB2 和 Microsoft SQL Server)之外的另一种选择。 事实上, PostgreSQL 的特性覆盖了 SQL-2/SQL-92 和 SQL-3/SQL-99,首先,它包括了可以说是目前世界上最丰富的数据类型的支持,其中有些数据类型可以说连商业数据库都不具备, 比如 IP 类型和几何类型等;其次,PostgreSQL 是全功能的自由软件数据库,很长时间以来,PostgreSQL 是唯一支持事务、子查询、多版本并行控制系统(MVCC)、数据完整性检查等特性的唯一的一种自由软件的数据库管理系统。 Inprise 的 InterBase 以及SAP等厂商将其原先专有软件开放为自由软件之后才打破了这个唯一。最后,PostgreSQL拥有一支非常活跃的开发队伍,而且在许多黑客的努力下,PostgreSQL 的质量日益提高。从技术角度来讲,PostgreSQL 采用的是比较经典的C/S(client/server)结构,也就是一个客户端对应一个服务器端守护进程的模式,这个守护进程分析客户端来的查询求,生成规划树,进行数据检索并最终把结果格式化输出后返回给客户端。为了便于客户端的程序的编写,由数据库服务器提供了统一的客户端 C 接口。而不同的客户端接口都是源自这个 C 接口,比如ODBC,JDBC,Python,Perl,Tcl,C/C++,ESQL等, 同时也要指出的是,PostgreSQL 对接口的支持也是非常丰富的,几乎支持所有类型的数据库客户端接口。这一点也可以说是 PostgreSQL 一大优点。 本课程作为PostgreSQL数据库管理二,主要讲解以下内容:1.     PostgreSQL中的子查询2.     PostgreSQL公共表表达式3.     PostgreSQL数据的修改4.     PostgreSQL中的事务5.     PostgreSQL数据导入和导出6.     PostgreSQL数据库的管理7.     PostgreSQL表的管理

2,209

社区成员

发帖
与我相关
我的任务
社区描述
其他数据库开发 其他数据库
社区管理员
  • 其他数据库社区
加入社区
  • 近7日
  • 近30日
  • 至今
社区公告
暂无公告

试试用AI创作助手写篇文章吧