Results 1 to 13 of 13

Thread: DB

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    hmm BornToDrink's Avatar
    Join Date: Aug:2005
    Location: .
    Posts: 11,573

    DB

    ,

    , , .
    "", : , , ... "" : , , ..

    3-4 , 100+.
    , , select (.. etc.).

    100 . .. - , - .

    .

    ps - MySQL/MyISAM
    InnoDB, fulltext.
    Hey, mother, I come bearing a gift. I'll give you a hint. It's in my diaper and it's not a toaster.
    .

  2. #2
    Defender Kaspirtov's Avatar
    Join Date: Jun:2006
    Location: Sf
    Posts: 7,414
    Quote Originally Posted by BornToDrink View Post
    .. - , - .
    " ", ? ?

    , XML , ; .. , ID , : XML, ( XML-a)

    TEXT , XML

    XML-a , Upsert

    Quote Originally Posted by BornToDrink View Post
    InnoDB, fulltext.
    , Lucene
    http://lucene.apache.org/java/docs/index.html

    --------------
    2 , XML select- ; X

    , -

    , , , / 2 ;

    ..
    " , , , , ."

  3. #3
    hmm BornToDrink's Avatar
    Join Date: Aug:2005
    Location: .
    Posts: 11,573
    Quote Originally Posted by Kaspirtov View Post
    " ", ? ?
    :
    id, email, title, description, cat_id // ""

    :
    categories
    // :
    car_brands
    car_models
    cpu_brands
    cpu_models
    ...

    , 1.
    insert- , select-, , .
    Hey, mother, I come bearing a gift. I'll give you a hint. It's in my diaper and it's not a toaster.
    .

  4. #4
    Defender Kaspirtov's Avatar
    Join Date: Jun:2006
    Location: Sf
    Posts: 7,414
    Quote Originally Posted by BornToDrink View Post
    .
    , - .
    BornToDrink, ; ? ?

    Quote Originally Posted by BornToDrink View Post
    , 1.
    .. view ?
    , , : categories ( ) FK (id, email, title, description, cat_id)

    cat_id (), cat_id, ____; enum; hashtable; ... ,

    Quote Originally Posted by BornToDrink View Post
    :
    id, email, title, description, cat_id // ""
    .. N cat_id? Kak?

    ASP, php :
    1) ViewGrid, auto generate - select categories,

    2) ?! , , categories,

    MSSQL, :
    Code:
    select count(*) from information_schema.columns
    where table_name='your table'
    , ( , PK, FK ) ;

    , : id, email, title, description, cat_id?!, .. ?!: - "XML" , TEXT XML , : http://dev.mysql.com/doc/refman/5.1/...functions.html

    : id, ____, id___o___, FK , , ____, - XML fulltext
    " , , , , ."

  5. #5
    Eclipse Plugin Developer aphex's Avatar
    Join Date: Mar:2003
    Location: Karlsruhe
    Posts: 546
    We are drowning in information, but starving for knowledge and time!

  6. #6
    hmm BornToDrink's Avatar
    Join Date: Aug:2005
    Location: .
    Posts: 11,573
    .
    , - .
    Hey, mother, I come bearing a gift. I'll give you a hint. It's in my diaper and it's not a toaster.
    .

  7. #7
    ! vbTheKing's Avatar
    Join Date: Sep:2003
    Location:
    Posts: 4,138
    , - EAV model. . , , .
    ''? * *
    - !
    ...

  8. #8
    hmm BornToDrink's Avatar
    Join Date: Aug:2005
    Location: .
    Posts: 11,573
    .. N cat_id? Kak?
    , .
    XML- , .


    ps - :
    http://bazar.bg/new.php

    "" , :
    "", :
    , , , , ...
    Hey, mother, I come bearing a gift. I'll give you a hint. It's in my diaper and it's not a toaster.
    .

  9. #9
    Defender Kaspirtov's Avatar
    Join Date: Jun:2006
    Location: Sf
    Posts: 7,414
    Quote Originally Posted by BornToDrink View Post
    , .
    XML- , .

    ps - :
    http://bazar.bg/new.php
    XML -, fulltext -
    -flexible, ;
    http://ict.udlap.mx/people/carlos/is...ortInMySQL.pdf

    18-19 "XML" MySQL
    " , , , , ."

  10. #10
    hmm BornToDrink's Avatar
    Join Date: Aug:2005
    Location: .
    Posts: 11,573
    Quote Originally Posted by Kaspirtov View Post
    XML -, fulltext -
    -flexible, ;
    http://ict.udlap.mx/people/carlos/is...ortInMySQL.pdf

    18-19 "XML" MySQL
    , . .

    XML ( , -@ ), .
    - .

    , , :
    http://hardwarebg.com/forum/showthread.php/196597
    Hey, mother, I come bearing a gift. I'll give you a hint. It's in my diaper and it's not a toaster.
    .

  11. #11
    Defender Kaspirtov's Avatar
    Join Date: Jun:2006
    Location: Sf
    Posts: 7,414
    Quote Originally Posted by BornToDrink View Post
    ,

    , ; "" , ; XML , " " (, XML); ( XML) - : - -; MySQL fulltext , , , - Lucene, (, , ...), , ( , 500 , , ...);

    XML , , MySQL XPath; ! Update Insert - ; , " " (); XML

    XML , ; XML - "XML" , ( = ; No = XX xxxx; ...) / ;
    " , , , , ."

  12. #12
    hmm BornToDrink's Avatar
    Join Date: Aug:2005
    Location: .
    Posts: 11,573
    , -, .
    -, MySQL- @, -.

    , .
    . , .
    Hey, mother, I come bearing a gift. I'll give you a hint. It's in my diaper and it's not a toaster.
    .

  13. #13
    Registered User Annihilator's Avatar
    Join Date: Jun:2004
    Location: Sofia
    Posts: 1,316
    ? , . - , object-relational-mapping , , .
    , - , 3 :
    http://modeling.sourceforge.net/User...heritance.html - - -

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Copyright © 1999-2011 . .
iskamPC.com | mobility.BG | Bloody's Techblog | | 3D Vision Blog |