database-design

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

How to improve ESRI/ArcGIS database performance while maintaining normalization?

I work with databases containing spatial data.Most of these databases are in a proprietary format created by ESRI for use with their ArcGIS software.We store our data in a normalized data model within[详细]

2023-04-08 21:29 分类：问答
Setup for high volume of database writing

I am researching a project that would require hundreds of database writes per a minute. I have never dealt with this level of data writes before and I am looking for good scalable techniques and techn[详细]

2023-04-08 20:58 分类：问答
Create nested set model without top level item

I\'m creating a nested set model for a taxonomy database.Basically, I\'ve re-created the same type of setup that wordpress uses for taxonomy, however instead of using parent_id for the term_taxonomy,[详细]

2023-04-08 20:07 分类：问答
MySQL storing images in an enum column

A thought experiment: You have a CMS that allows users to upload an image, and each page is stored as a row in the database.When a user开发者_如何转开发[详细]

2023-04-08 18:55 分类：问答
How to create one to many in SQLITE3?

How to create one to many in SQLITE3? I have 2 tables: Mans: _idname 1antony 2fred and point _iddatepoint 1开发者_如何学运维2377[详细]

2023-04-08 17:37 分类：问答
Database schema of messaging application

In my messaging application, The features I want to provide are: Sending a message to multiple people Receiving message sent to a user[详细]

2023-04-08 13:17 分类：问答
schema and table design with auto_increment field that is not a key

I\'ve an invoice number, this number is associated to a spec开发者_如何学JAVAial document. This document has an id, formed by a progressive number and the current year, like this[详细]

2023-04-08 13:15 分类：问答
Storing "irregular" data in MySQL

Apologies in advance if this question has already been asked, but I really don\'t know how to search for the problem I have.[详细]

2023-04-08 12:07 分类：问答
MySQL & FK constraints

Is there any point in defining FK constraints in MyISAM? MyISAM doesn\'t enforce referential inte开发者_如何转开发grity, right? So maybe there is no point to FK constraints. Although MySQL parses and[详细]

2023-04-08 10:41 分类：问答
User-specific database records

This is more of a theoretical questions. Anyways, Assume that I have a database (50 tables) And Data in ALL of those tables should be hold specifically to one user.[详细]

2023-04-08 05:23 分类：问答