We have million and millions of records in a SQL table, and we run开发者_Python百科 really complex analytics on that data to generate reports.
We are currently using a summary table that aggregates information for our users on an hourly basis in UTC time.The problem we are having is that this table is becoming too large and slowing our syste
What is the difference between a database and a data warehouse? Aren\'t they the same 开发者_StackOverflow中文版thing, or at least written in the same thing (ie. Oracle RDBMS)?Check out this for more
I am in the process of designing a new customer fact and dimensions for my warehouse. In my search for good example models I noticed something odd. No one seems to have a customer-centric fact. Every
It's difficult to tell what is being asked here. This question is ambiguous, vague, incomplete, overly broad, or rhetorical andcannot be reasonably answered in its current form. For help clari
I have a website backed by a relational database comprised of the usual e-commerce related tables (Order, OrderItem, ShoppingCart, CreditCard, Payment, Customer, Address, etc...).
I am working on a data warehousing project where several systems are loading data into a staging area for subsequent processing.Each table has a \"loadId\" column which is a foreign key against the \"
My fact table holds a user score in a course he took. Some of the details of the course, which I have to show on the report, comes from more then one table (in the actual OLTP db).
So I am querying some extremely large tables.The reason they are so large is because PeopleSoft inserts new records every time a change is made to some data, rather than updating existing records.In e
Closed. This question is opinion-based. It is not currently accepting answers. Want to improve this question? Update the question so it can be answered with facts and citations by editing
加载中,请稍侯......