data-warehouse

相关标签：javascript jquery android 多少钱 iPhone

Data caching techniques / Tips / AppFabric

We have million and millions of records in a SQL table, and we run开发者_Python百科 really complex analytics on that data to generate reports.[详细]

2023-01-11 01:28 分类：问答
How Do I aggregate Data By Day and Still Respect Timezone?

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[详细]

2023-01-10 09:25 分类：问答
What is the difference between a database and a data warehouse?

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[详细]

2023-01-10 05:22 分类：问答
Doesn't anyone use a Customer Fact?

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[详细]

2023-01-07 06:50 分类：问答
How do I implement something like Digg Swarm in PHP or Python? [closed]

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[详细]

2023-01-06 16:00 分类：问答
Achieving better DB performance

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...).[详细]

2023-01-06 07:56 分类：问答
SQL Server: unique key for batch loads

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 \"[详细]

2023-01-06 02:24 分类：问答
How do I avoid complex joins in star schema?

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).[详细]

2023-01-05 14:50 分类：问答
How can I speed up queries against huge data warehouse tables with effective-dated data?

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[详细]

2023-01-04 20:58 分类：问答
Which is better, ETL or ELT? [closed]

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[详细]

2023-01-04 05:40 分类：问答