Database
Force.com is built around a relational database. It allows the definition of custom tables
containing up to 800 fields each. Fields contain strongly typed data using any of the standard
relational database data types, plus rich types such as currency values, picklists, formatted
text, and phone numbers. Fields can contain validation rules to ensure data is
clean before being committed, and formulas to derive values, like cells in a spreadsheet.
Field history tracking provides an audit log of changes to chosen fields.
containing up to 800 fields each. Fields contain strongly typed data using any of the standard
relational database data types, plus rich types such as currency values, picklists, formatted
text, and phone numbers. Fields can contain validation rules to ensure data is
clean before being committed, and formulas to derive values, like cells in a spreadsheet.
Field history tracking provides an audit log of changes to chosen fields.
Custom tables can be related to each other, allowing the definition of complex data
schemas.Tables, rows, and columns can be configured with security constraints. Data and
metadata is protected against accidental deletion through a “recycling bin” metaphor.The
database schema is often modifiable instantly, without manual migration. Data is imported
from files or other sources with free tools, and APIs are provided for custom data-loading
solutions.
Data is queried via a SQL-like language called SOQL (Salesforce Object Query Language).
Full-text search is available through SOSL (Salesforce Object Search Language).
www.it-
No comments:
Post a Comment