Data Abstract是最好的多層次框架,它提供端到端的解決方案,同時也可以很輕松地建立起可擴展的數(shù)據(jù)庫方案以滿足如今的分布式系統(tǒng)要求。
Data Abstract is the only multi-tier framework that provides an end-to-end solution for these demands and makes it easy to build scalable database solutions that live up to the requirements of today's distributed world.
概況特性
為.NET,Mono,32/64位的Windows以及Linux建立可擴展的、跨平臺的多層次數(shù)據(jù)庫解決方案。
使用一個通用的代碼庫處理不同的數(shù)據(jù)庫設計或數(shù)據(jù)庫系統(tǒng)。
使用RAD Schema Modeler模擬你的數(shù)據(jù)結(jié)構(gòu),以讓其在中間層以及客戶端層透明。
完全沒有部署授權(quán)費用。
完全支持C#、Oxygene、Visual Basic .NET (.NET版本) 以及 Object Pascal (Delphi 版本)。
支持Silverlight web客戶端。
庫特性
完全抽象不同的數(shù)據(jù)庫類型:只需編寫一組代碼即可訪問任何支持的后臺數(shù)據(jù)庫類型。
完全抽象不同的數(shù)據(jù)庫設計:使用一個單一的中間層服務器來處理不同的數(shù)據(jù)庫設計,比如一個傳統(tǒng)的數(shù)據(jù)庫和一個新的、精心設計的替代數(shù)據(jù)庫。
建立一個“無國籍”的、可擴展的、無縫集成的應用程序。
輕松建立自己的數(shù)據(jù)訪問驅(qū)動用于擴展支持的數(shù)據(jù)庫。
支持正則表達式的客戶端數(shù)據(jù)驗證。
Strongly Typed Data Tables通過面向?qū)ο蟮拇a允許你從代碼里訪問你的數(shù)據(jù)表。
Business Helper Classes允許你封裝業(yè)務邏輯和規(guī)則。
Let Data Abstract自動生成所有的SQL代碼或提供手寫SQL代碼以滿足特殊的需求。
使用Data Abstract的宏處理器可以最小化共享SQL代碼與SQL語句的差異。
完全可重用的Reconcile Dialog體系,允許你為你的終端用戶提供錯誤信息的反饋。
針對客戶端數(shù)據(jù)存儲的高性能的內(nèi)存數(shù)據(jù)表組件(僅限D(zhuǎn)elphi/FPC;.NET利用現(xiàn)有的DataSet類)。
Rich Business Rules Scripting使用RemObjects Pascal Script.(僅限D(zhuǎn)elphi)。
完全本地化以及具有特定平臺的實施,專為個人平臺設計。
提供完整的源碼,并且允許修改和再編譯。
數(shù)據(jù)訪問特性
在請求數(shù)據(jù)、分頁或合并數(shù)據(jù)時一次性的整合數(shù)據(jù)。
自動同步遠程數(shù)據(jù)源。
強大的業(yè)務處理器讓你對你的業(yè)務更新有更多的控制。
跨數(shù)據(jù)庫的AutoInc以及生成器支持基于整形的主鍵和外鍵。
完全支持無狀態(tài)的主/明細事務更新。
廣泛的跨數(shù)據(jù)庫數(shù)據(jù)類型包括:XML,GUID以及Decimal類型。
利用最新DynamicWhere和DynamicSelect功能,可以縱向或橫向過濾從客戶端得到的數(shù)據(jù)子集。
Reduced Delta模式可以在更新時只發(fā)送關(guān)鍵字段或改變字段以優(yōu)化網(wǎng)絡流量。
在你的架構(gòu)中定義聯(lián)合表然后以一個整體的數(shù)據(jù)表發(fā)送到你的客戶端。
使用DA SQL和DA LINQ從客戶端靈活地查詢數(shù)據(jù)(僅限.NET)。
Schema Modeler特性
利用Schema Modeler以一種創(chuàng)新的RAD方式設計你的數(shù)據(jù)訪問層。
使用數(shù)據(jù)瀏覽器可以查看數(shù)據(jù)庫系統(tǒng)的實時視圖。
通過拖拽創(chuàng)建和定義數(shù)據(jù)表以及命令。
使用更新規(guī)則無需一行代碼即可設計復雜的更新隊列。
Validation Wizard可以保證你的結(jié)構(gòu)100%的匹配數(shù)據(jù)庫。
為不同的數(shù)據(jù)庫設計定義列映射。
IDE整合特性
與支持的IDE完全整合。
項目模板和新建項目向?qū)椭銊?chuàng)建新的項目。
Schema Modeler項目與IDE整合,允許你在IDE項目系統(tǒng)(.NET)或窗體設計器(Delphi)中編輯你的服務定義。
第一次安裝后顯示新的歡迎頁面,以幫助新用戶熟悉產(chǎn)品。
RemObjects SDK特性
Data Abstract基于RemObjects SDK并包括了RemObjects SDK;請參考RemObjects SDK的特性以便對Data Abstract更加了解,這對你的DA項目很有好處。
支持的數(shù)據(jù)庫系統(tǒng)
支持的數(shù)據(jù)庫系統(tǒng)包括:
微軟SQL Server 2000 and 2005
Microsoft SQL Server Compact Edition
Oracle
DB2
InterBase/Firebird
Sybase
PostgreSQL
MySQL
SQLite
NexusDB(僅限D(zhuǎn)elphi)
Borland Database Engine for dBase, Paradox(僅限D(zhuǎn)elphi)
Data Abstract(Delphi)支持的第三方數(shù)據(jù)訪問組件
dbGo (ADO Express)
DBX
DBX4(Delphi2007及以后)
IBX
AnyDAC*
SDAC, ODAC, MyDAC 和 IBDAC by CoreLabs*
MySQLDAC 和 PostresDAC by microOLAP*
IBObjects*
DBISAM*
ZEOS
SQLite by Aducom (Data Abstract自帶)
General Features
- Build scalable cross-platform multi-tier database solutions for .NET, Mono, 32- and 64-bit Windows and Linux.
- Target different database layouts or systems using a common code base.
- Use the RAD Schema Modeler to model the structure of your data as it will be exposed to the middle- and client-tier.
- Absolutely no deployment license fees.
- Full support for C#, Oxygene, Visual Basic .NET (.NET Edition) and Object Pascal (Delphi Edition).
- Support for Silverlight web clients.
Library Features
- Complete abstraction of different databases types: write one set of code and target any supported database backend type.
- Complete abstraction of different database layouts: have a single middle-tier server target different database designs, for example a legacy database and a new, well-designed replacement database.
- Build your applications with a "stateless" focus for maximum scalability and seamless cluster integration.
- Easily create your own data access drivers to extend the list of databases supported out of the box.
- Support for regular expressions for client-side data-validation.
- Strongly Typed Data Tables allow you to access your tables from code using fully object-oriented code.
- Business Helper Classes allow you to encapsulate business logic and rules.
- Let Data Abstract auto-generate all SQL code on the fly - or provide manually written SQL code to cover special requirements.
- Minimize SQL dialect differences in shared SQL code using Data Abstract's macro processor.
- Fully reusable Reconcile Dialog architecture, allowing you to provide end-users with feedback about failed updates.
- High performance memory data table component for client-side data storage (Delphi/FPC only; .NET leverages the existing DataSet class).
- Rich Business Rules Scripting using RemObjects Pascal Script. (Delphi Only)
- 100% native and platform-specific implementations, designed from the ground up for the individual platforms.
- Full source code is provided, allowing you to make changes and rebuild the library, if needed.
Data Access Features
- Stream data all at once, on demand, paged or any combination of these.
- Re-synch fields with the remote data source automatically.
- Enhanced Business Processors give you more control on your business updates.
- Cross-database AutoInc and generator support for integer-based primary and foreign keys.
- Full support for stateless Master/Detail transactional updates.
- Extensive set of cross-database data types including new XML, GUID and Decimal types.
- Leverage new DynamicWhere and DynamicSelect features to vertically or horizontally filter the subsets of data retrieved by the client.
- Reduced Delta mode to optimize network traffic by only sending key and changed fields for updates.
- define Union Tabless in your schema and transparently publish them to clients as one coherent data table.
- leverage DA SQL and DA LINQ to flexibly query data from the client (.NET only)
Schema Modeler Features
- Design your data-access layer in an innovative RAD way using the Schema Modeler.
- Use the Data Explorer for a live view of the underlying database system.
- Create and define data tables and commands via drag and drop.
- Use update rules to design complex update sequences without a single line of code.
- Let the Validation Wizard ensure that your schema 100% matches the underlying database.
- Define Column Mappings to abstract differences in database layout.
IDE Integration Features
- Full integration with the supported IDEs.
- Project Templates and extensive New Project Wizard to help start new projects .
- Project integration of Schema Modeler with the IDE, allowing you to edit your service definitions within the IDE's project system (.NET) or form designer (Delphi).
- New Welcome Page displayed after first install to assist new users with getting acquainted with the product.
Features of RemObjects SDK
Data Abstract builds on top of and includes RemObjects SDK; please also refer to Features of RemObjects SDK to learn more about features provided by the RemObjects SDK that are not specific to Data Abstract, but will benefit your DA projects.
Supported Database Systems
Database systems supported by Data Abstract include:
- Microsoft SQL Server 2000 and 2005
- Microsoft SQL Server Compact Edition
- Oracle
- DB2
- InterBase/Firebird
- Sybase
- PostgreSQL
- MySQL
- SQLite
- NexusDB (Delphi only)
- Borland Database Engine for dBase, Paradox, etc. (Delphi only)
Supported Third Party Data Access Components in Data Abstract for Delphi
- dbGo (ADO Express)
- DBX
- DBX4 (Delphi 2007 and up)
- IBX
- AnyDAC*
- SDAC, ODAC, MyDAC and IBDAC by CoreLabs*
- MySQLDAC and PostresDAC by microOLAP*
- IBObjects*
- DBISAM*
- ZEOS
- SQLite by Aducom (included with Data Abstract)