FairCom (c-tree) 数据库概要 - 1
来源:互联网 发布:mac版本的office 编辑:程序博客网 时间:2024/06/05 22:51
CSDN不能上传文件,只能慢慢贴了
Technique Research
FairCom & SQL Server Compare
Table of Contents
Distribution List
1. Scope
2. FairCom Overview
3. c-tree Server Features
3.1. c-tree Server system architecture
3.2. Data and Index Caching
3.3. Transaction Control
3.4. File Mirroring
3.5. Large file support
3.6. Memory Files
3.7. Partitioned Files
3.8. Backing up and Restoring
3.9. Platforms
3.10. c-tree server Access
3.10.1. Users
3.10.2. Files
3.10.3. Groups
3.10.4. File Permission Masks
4. c-tree isql utility
4.1. SQL-92 Standard support
4.1.1. iSQL supports SQL-92 standard
4.1.2. Transaction Processing
4.1.3. System Tables
4.1.4. iSQL statements
4.2. Other utilities
4.2.1. dbload utility
4.2.2. dbdump utility
5. c-tree server SQL Reference
5.1. Data Types
5.2. Database objects
5.3. SQL Functions
5.4. Unicode support
6. DEVELOP with c-tree
6.1. ISAM/Lower Level API
6.2. c-tree DB C API
6.3. c-tree DB C++ API
6.4. c-tree Plus for .NET
6.5. c-tree VCL/CLX
6.6. c-tree Driver and c-tree Driver Develop
1. Scope
This document is intended as a technique research document of Faircom and SQL Server database compare.
2. FairCom Overview
Faircom have eleven products:
l c-tree Plus
l c-tree Server
l c-tree Server SDK
l c-treeSQL
l c-tree Plus for .NET
l c-treeVCL/CLX
l c-treeDBX
l c-tree ODBC Drivers
l Crystal Reports Driver
l c-tree Plus Driver SDK
FairCom products mainly have three types:
l c-tree Server and c-treeSQL Server
l c-tree Plus
l c-tree Driver
3. c-tree Server Features
3.1. c-tree Server system architecture
1) Single c-tree Server Architecture
Graph
This is the classic C/S architecture and SQL Server supports this architecture well.
2) Multiple c-tree Server Architecture
Graph
This is the multiple c-tree server architecture. In this model, multiple c-tree Servers serve clients, and the architecture frequently includes load balancing and data synchronization components.
Today, similar architecture of RDBMS has gone to DDBS. Because we focus on moving
c-tree server to SQL Server and Oberon doesn’t need to use this architecture currently, we can ignore it.
3.2. Data and Index Caching
SQL Server has the caching ability in background.
3.3. Transaction Control
c-tree server supports the following transaction processing options:
l PREIMG (provides atomicity without recoverability)
l TRNLOG (provides atomicity with recoverability)
l TRNLOG with LOGIDX indexes (provides atomicity with recoverability, with logging of index reorganization operations to speed automaticrecovery).
We also can set do not use the c-tree server transaction capability.
SQL Server has the transaction control ability and temp data will be stored in *.ldf(by default) file.
One difference is, in c-tree server we can view the transaction log file and in SQL Server the transaction control capability is in background and we can’t see the transaction log directly.
3.4. File Mirroring
The c-tree Server's mirroring facility makes it possible to create and maintain copies of important files on different drive volumes, partitions or physical drives. If the primary storage location is lost due to some form of catastrophe (i.e., head crash) the mirroring logic can automatically detect the lost connection and switch to the secondary or "mirrored" storage area.
Graph
From SQL Server 2000, disk mirror capability was no longer supported. We can only use hard equipments to do the file mirroring, such as RAID.
3.5. Large file support
In SQL Server we can ignore it.
3.6. Memory Files
In SQL Server we don’t need memory files, SQL Server will maintain the memory automatically.
3.7. Partitioned Files
The c-tree Server supports a unique feature known as Partitioned Files. A partitioned
file logically appears to be one file (or more accurately one data file and its associated
index files), but is actually a set of files whose contents are partitioned by the value of
the partition key. Both the data files and index files are partitioned. This permits data
with a defined range of values for the partition key to be rapidly purged or archived
(instead of having to delete record-by-record each record within this range).
Graph
In SQL Server we don’t need to use this functionality.
3.8. Backing up and Restoring
c-tree server supports online backup and offline backup and others backup options.
SQL Server has the powerful backing up and restoring capabilities and we don’t need to be afraid of this functionality.
3.9. Platforms
c-tree server has different version for Windows, Unix, Linux, Solaris and other operating systems.
SQL Server can only run under Windows.
3.10.c-tree server Access
Access to the c-tree Server can be controlled in four basic ways:
l User access restrictions
l File access restrictions
l File operation permissions
l Group-based restrictions
3.10.1.Users
c-tree server has four types of users:
l Administrator
l Unique User ID
l Application-based User ID
l Guest Users
These types of users are different from SQL Server.
3.10.2.Files
Database files have several security features in addition to the file permission mask.
l File Password
l File Owner
l File Group
In SQL Server, the security strategy can cover the c-tree server file access features.
3.10.3.Groups
A Group is an arbitrary category of associated User IDs and files.
3.10.4.File Permission Masks
Once a user has access to a given file, which might need both user and file passwords to reach, there is one additional level of access control available.
Operations controlled:
l READ
l WRITE
l CHANGE THE DEFINITION
l DELETE
Generally a data file in c-tree server can be considered as a table, in SQL Server we can set the allowed actions on a table for users.
- FairCom (c-tree) 数据库概要 - 1
- FairCom (c-tree) 数据库概要 - 2
- How to connect to Faircom c-tree database
- 数据库概要
- c-tree数据库(c-treeACE)(1):安装配置篇
- 数据库系统实现概要
- 数据库认证技术概要
- 数据库实例概要图
- 数据库&SQL基础概要
- 【数据库】MySQL记录概要
- 数据库系统概要
- 数据库的学习--概要
- 数据库架构演变概要
- c-tree数据库大量数据bulk loading
- C语言复习概要
- C 指针概要
- Objective-C 2.0概要
- Objective-C基础概要
- 转:win2003的IIS设置方法
- jasperreport生成简单的报表
- OO设计模式和设计原则
- eclipse导出rcp时: 找不到应用程序标识。
- 累加会员登陆时间问题,望高手帮忙谢谢!(急!)
- FairCom (c-tree) 数据库概要 - 1
- SIP协议全方位概要介绍
- Java 中十进制十六进制相互转换
- 做鹰眼图
- java模式之单例模式
- “月光族”薪水节流八绝招
- FairCom (c-tree) 数据库概要 - 2
- visitor模式概念——visitor模式进一步
- hadoop