對force.com資料庫的一些認識

acerow發表於2012-08-20
資料庫
不知大家對force.com平臺資料庫有沒有研究，做過一陣force.com的開發，原來以為salesforce用的是oracle資料庫，可是發現force.com官網上釋出的文件並非如此：

http://wiki.developerforce.com/page/An_Introduction_to_Force_Database

In a relational database, tables store the data. Each table comprises a number of columns of a particular data type. Information is stored in rows of the table. Finally, tables can be related to other tables, using primary and foreign keys to map the rows in one table to rows in another.

The database in Force.com, on the other hand, uses objects to store data. Objects contain the functionality you expect in a table and more, but you should be aware that the difference also points to a difference in functionality. The object comprises a number of fields. Objects can be related to other objects, with relationship fields mapping records in one object to records in another. All attributes of an object are described with metadata, outlined later. Information is stored in records of the object.

When an object is materialized in the Apex language, it is called an sObject, to differentiate them from instances of Apex classes. We’ll use this terminology throughout the article.

我最感興趣的是force.com資料庫中的查詢，主詳，公式，累計彙總等欄位型別，而且這些型別能夠很好的保持資料的一致性和實時性，不知道force.com是如何實現的？

相關文章