# REST API for Datawarehouse Database scenario

**URL:** <https://community.dreamfactory.com/t/rest-api-for-datawarehouse-database-scenario/1114>\
**Category:** Miscellaneous\
**Created:** [May 19, 2015, 4:41am UTC](https://community.dreamfactory.com/t/rest-api-for-datawarehouse-database-scenario/1114 "2015-05-19T04:41:43Z")\
**Posts on this page:** 1\
**Showing post:** 2

<div class="post-metadata">

**Author:** ![jeffreystables](https://yyz1.discourse-cdn.com/flex035/user_avatar/community.dreamfactory.com/jeffreystables/32/173_2.png) [@jeffreystables](https://community.dreamfactory.com/u/jeffreystables)\
**Post date:** [August 14, 2015, 3:52pm UTC](https://community.dreamfactory.com/t/rest-api-for-datawarehouse-database-scenario/1114/2 "2015-08-14T15:52:00Z")

</div>

1. I’m not sure. I think API calls are limited by how your tables are named in the DB.

2. For joins and complex SQL operations, you will likely want to use [stored procedures](https://github.com/dreamfactorysoftware/dsp-core/wiki/SQL-Stored-Procedures) or [views](https://github.com/dreamfactorysoftware/dsp-core/wiki/SQL-Views). You may also want to check out these forum threads:

- [Advanced SQL queries](https://community.dreamfactory.com/t/can-i-do-advanced-queries-on-my-data/45?u=jeffreystables)
- [Complex SQL operations](https://community.dreamfactory.com/t/how-to-make-the-complex-sql-in-dreamfactory/1210?u=jeffreystables)
- [Inner join using a SQL view](https://community.dreamfactory.com/t/using-inner-join-and-group-by-to-help-filter-a-rest-get-request/190?u=jeffreystables)

1. Yes! Check out [our FAQs](https://github.com/dreamfactorysoftware/dsp-core/wiki/FAQs#how-do-i-scale-dreamfactory-to-handle-a-large-volume-of-api-calls-and-data) and [this paper on scalability](https://www.dreamfactory.com/publications/DreamFactory_Scalability.pdf) [PDF].

---

_[View the full topic](https://community.dreamfactory.com/t/rest-api-for-datawarehouse-database-scenario/1114)._