relational-database
SQL Server: Can I create a 'synthetic' relation that has no indexing or constraint checking overhead?
What I wish to do is ensure that the foreign key relation is maintained in the database schema but for performance reasons, not enforce the constrain or incur any indexing overheads. It\'s purpose is[详细]
2023-04-01 13:05 分类:问答Pizza & Food - database design
I want to create a website that allow customer to order food from the website. There are two food type:[详细]
2023-04-01 08:48 分类:问答Database design structure for storing courses chapters topics subtopics
I\'m putting together a database structure that can hold data for courses. Each course - will have several chapters and each chapter MAY have topics and each topic MAY have sub topics and so on.[详细]
2023-04-01 07:25 分类:问答is it possible to represent SQL RDB in XML?
Is it possi开发者_Go百科ble to represent a SQL Relational Database in XML? That is, how would XML handle the primary key -> foriegn key relationships?[详细]
2023-04-01 02:05 分类:问答Ruby on rails application with multiple models
I have a few small ROR \"mostly static\" type sites and am working on something a little deeper that I don\'t have much experience with...[详细]
2023-03-31 20:53 分类:问答MySQL Create a function table?
I am trying to design the layout of the table to work best in the following situation. I have a product that is sold based on age. The age determines if that product exists for this person and the mi[详细]
2023-03-31 00:54 分类:问答EntityFramework 4.1 Code first TPT and data integrity
Reading this article, http://weblogs.asp.net/manavi/archive/2010/12/28/inheritance-mapping-strategies-with-entity-framework-code-first-ctp5-part-2-table-per-type-tpt.aspx[详细]
2023-03-30 20:39 分类:问答Large Join Tables and Scaling
The Problem We have a rapidly growing database with several large join tables (currently in the billions of rows), but as these tables have grown the query time has suffered.The concern is that as mo[详细]
2023-03-30 20:35 分类:问答MySql: Best way to run high number of search queries on a table
I have two tables, one is static database that i need to search in, the other is dynamic that i will be using to search the first database. Right now i have two separate queries. First on page load, v[详细]
2023-03-30 02:26 分类:问答How to avoid primary key clashes when merging two identical tables with a view
I have a central database and a unique database for a project I am working on.The central database allows me to provide users with default options and data.[详细]
2023-03-29 12:22 分类:问答