database-design

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

One account, multiple ways to login?

I want to build an application that allow users to log in via the following: my own authentication/authorization solution[详细]

2023-04-08 03:48 分类：问答
How can one check an identifier for unescaped validity in most RDBMSs?

I\'d like my application to work on several databases. While I\'m not going to explicitly support them right now, I\'d like to be able to define my schemata such that I\'m not using reserved identifie[详细]

2023-04-07 23:57 分类：问答
Partitioning by Year vs. separate tables named Data_2011, Data_2010, etc

We are designing a high volume SQL Server application that involves processing and reporting on data that is restricted within a specified year.[详细]

2023-04-07 22:25 分类：问答
Best sql practice for related records

Hi I need be able to link related applications and am trying to work out the best practice table structure for saving, updating and deleting.[详细]

2023-04-07 17:53 分类：问答
Real Time issues: Oracle Performance tuning (types / indexes / plsql / queries)

I am looking for a real time solution... Below are my DB columns. I am using Oracle10g. Please help me in defining table types / indexes and tuned PLSQL / query (both) for the updates and insertion[详细]

2023-04-07 15:02 分类：问答
Data constraints in US state/county/city/zip database?

I have a database of US zip codes and their corresponding states, cities and counties. It was supplied as a flat file and I\'m trying to normalize the data and figure out exactly which entities depend[详细]

2023-04-07 13:45 分类：问答
Need help designing table of rules to be used for SQL selections

I\'m refining a script that I have so that it could be automated & maintained by end users. Previously, I mentioned a portion of this script in this SO post.[详细]

2023-04-07 12:08 分类：问答
Pros/cons of MongoDB or MySQL for this purpose [closed]

Closed. This question needs to be more focused. It is not currently accepting answers. Want to improve this question? Update the question so it focuses on one problem only by editing this po[详细]

2023-04-07 08:48 分类：问答
What database is best suited, especially in terms of disk usage, to millions of very small rows with a high insert, query, and delete volume?

I\'m looking at a table struct开发者_如何学JAVAure that might look about like this: char(32) | char(32) | (boolean) |[详细]

2023-04-07 07:36 分类：问答
How to create record and assign to 1 of 3 sub-types, each sub-type with different properties

I\'m constructing a schema for a MySQL database. I have a table called \'entry\' (the supertype). An entry can be either a \'photo\', \'essay\', or \'video\' (subtype). Each subtype has different prop[详细]

2023-04-07 07:21 分类：问答