{"id":"https://openalex.org/W1504530645","doi":"https://doi.org/10.1007/978-3-642-16952-6_4","title":"Optimization of Investment Options Using SQL","display_name":"Optimization of Investment Options Using SQL","publication_year":2010,"publication_date":"2010-01-01","ids":{"openalex":"https://openalex.org/W1504530645","doi":"https://doi.org/10.1007/978-3-642-16952-6_4","mag":"1504530645"},"language":"en","primary_location":{"id":"doi:10.1007/978-3-642-16952-6_4","is_oa":false,"landing_page_url":"https://doi.org/10.1007/978-3-642-16952-6_4","pdf_url":null,"source":{"id":"https://openalex.org/S106296714","display_name":"Lecture notes in computer science","issn_l":"0302-9743","issn":["0302-9743","1611-3349"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319900","host_organization_name":"Springer Science+Business Media","host_organization_lineage":["https://openalex.org/P4310319900","https://openalex.org/P4310319965"],"host_organization_lineage_names":["Springer Science+Business Media","Springer Nature"],"type":"book series"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Lecture Notes in Computer Science","raw_type":"book-chapter"},"type":"book-chapter","indexed_in":["crossref"],"open_access":{"is_oa":false,"oa_status":"closed","oa_url":null,"any_repository_has_fulltext":false},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5079006360","display_name":"Jos\u00e9 Torres-Jim\u00e9nez","orcid":"https://orcid.org/0000-0002-5029-5340"},"institutions":[{"id":"https://openalex.org/I68368234","display_name":"Centro de Investigaci\u00f3n y de Estudios Avanzados del Instituto Polit\u00e9cnico Nacional","ror":"https://ror.org/009eqmr18","country_code":"MX","type":"facility","lineage":["https://openalex.org/I59361560","https://openalex.org/I68368234"]}],"countries":["MX"],"is_corresponding":false,"raw_author_name":"Jose Torres-Jimenez","raw_affiliation_strings":["Information Technology Laboratory, CINVESTAV-Tamaulipas, Km. 6 Carretera Victoria-Monterrey, 87276, Victoria Tamps, Mexico"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Information Technology Laboratory, CINVESTAV-Tamaulipas, Km. 6 Carretera Victoria-Monterrey, 87276, Victoria Tamps, Mexico","institution_ids":["https://openalex.org/I68368234"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5064239706","display_name":"Himer \u00c1vila-George","orcid":"https://orcid.org/0000-0001-8578-0170"},"institutions":[{"id":"https://openalex.org/I4210135990","display_name":"Instituto de Instrumentaci\u00f3n para Imagen Molecular","ror":"https://ror.org/03p80e845","country_code":"ES","type":"facility","lineage":["https://openalex.org/I134820265","https://openalex.org/I4210135990","https://openalex.org/I60053951"]},{"id":"https://openalex.org/I60053951","display_name":"Universitat Polit\u00e8cnica de Val\u00e8ncia","ror":"https://ror.org/01460j859","country_code":"ES","type":"education","lineage":["https://openalex.org/I60053951"]}],"countries":["ES"],"is_corresponding":false,"raw_author_name":"Himer Avila-George","raw_affiliation_strings":["Instituto de Instrumentaci\u00f3n para Imagen Molecular (I3M), Universidad Polit\u00e9cnica de Valencia, Camino de Vera s/n, 46022, Valencia, Spain"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Instituto de Instrumentaci\u00f3n para Imagen Molecular (I3M), Universidad Polit\u00e9cnica de Valencia, Camino de Vera s/n, 46022, Valencia, Spain","institution_ids":["https://openalex.org/I4210135990","https://openalex.org/I60053951"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5064414262","display_name":"Nelson Rangel-Valdez","orcid":"https://orcid.org/0000-0002-4745-2325"},"institutions":[{"id":"https://openalex.org/I68368234","display_name":"Centro de Investigaci\u00f3n y de Estudios Avanzados del Instituto Polit\u00e9cnico Nacional","ror":"https://ror.org/009eqmr18","country_code":"MX","type":"facility","lineage":["https://openalex.org/I59361560","https://openalex.org/I68368234"]}],"countries":["MX"],"is_corresponding":false,"raw_author_name":"Nelson Rangel-Valdez","raw_affiliation_strings":["Information Technology Laboratory, CINVESTAV-Tamaulipas, Km. 6 Carretera Victoria-Monterrey, 87276, Victoria Tamps, Mexico"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Information Technology Laboratory, CINVESTAV-Tamaulipas, Km. 6 Carretera Victoria-Monterrey, 87276, Victoria Tamps, Mexico","institution_ids":["https://openalex.org/I68368234"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5039030877","display_name":"Jorge Martinez-Pena","orcid":null},"institutions":[{"id":"https://openalex.org/I68368234","display_name":"Centro de Investigaci\u00f3n y de Estudios Avanzados del Instituto Polit\u00e9cnico Nacional","ror":"https://ror.org/009eqmr18","country_code":"MX","type":"facility","lineage":["https://openalex.org/I59361560","https://openalex.org/I68368234"]}],"countries":["MX"],"is_corresponding":false,"raw_author_name":"Jorge Martinez-Pena","raw_affiliation_strings":["Information Technology Laboratory, CINVESTAV-Tamaulipas, Km. 6 Carretera Victoria-Monterrey, 87276, Victoria Tamps, Mexico"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Information Technology Laboratory, CINVESTAV-Tamaulipas, Km. 6 Carretera Victoria-Monterrey, 87276, Victoria Tamps, Mexico","institution_ids":["https://openalex.org/I68368234"]}]}],"institutions":[],"countries_distinct_count":2,"institutions_distinct_count":4,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":{"value":5000,"currency":"EUR","value_usd":5392},"apc_paid":null,"fwci":0.8327,"has_fulltext":false,"cited_by_count":2,"citation_normalized_percentile":{"value":0.75991551,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":90,"max":94},"biblio":{"volume":null,"issue":null,"first_page":"30","last_page":"39"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11413","display_name":"Risk and Portfolio Optimization","score":0.9991000294685364,"subfield":{"id":"https://openalex.org/subfields/1803","display_name":"Management Science and Operations Research"},"field":{"id":"https://openalex.org/fields/18","display_name":"Decision Sciences"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}},"topics":[{"id":"https://openalex.org/T11413","display_name":"Risk and Portfolio Optimization","score":0.9991000294685364,"subfield":{"id":"https://openalex.org/subfields/1803","display_name":"Management Science and Operations Research"},"field":{"id":"https://openalex.org/fields/18","display_name":"Decision Sciences"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}},{"id":"https://openalex.org/T11801","display_name":"Reservoir Engineering and Simulation Methods","score":0.9969000220298767,"subfield":{"id":"https://openalex.org/subfields/2212","display_name":"Ocean Engineering"},"field":{"id":"https://openalex.org/fields/22","display_name":"Engineering"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T10067","display_name":"Stochastic processes and financial applications","score":0.9947999715805054,"subfield":{"id":"https://openalex.org/subfields/2003","display_name":"Finance"},"field":{"id":"https://openalex.org/fields/20","display_name":"Economics, Econometrics and Finance"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.8223699331283569},{"id":"https://openalex.org/keywords/cartesian-product","display_name":"Cartesian product","score":0.6410379409790039},{"id":"https://openalex.org/keywords/portfolio","display_name":"Portfolio","score":0.6115034222602844},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.5818108320236206},{"id":"https://openalex.org/keywords/profit","display_name":"Profit (economics)","score":0.5397070646286011},{"id":"https://openalex.org/keywords/portfolio-investment","display_name":"Portfolio investment","score":0.5048993229866028},{"id":"https://openalex.org/keywords/portfolio-optimization","display_name":"Portfolio optimization","score":0.4715442955493927},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.27614331245422363},{"id":"https://openalex.org/keywords/finance","display_name":"Finance","score":0.1784069836139679},{"id":"https://openalex.org/keywords/microeconomics","display_name":"Microeconomics","score":0.10728192329406738},{"id":"https://openalex.org/keywords/economics","display_name":"Economics","score":0.08188867568969727},{"id":"https://openalex.org/keywords/mathematics","display_name":"Mathematics","score":0.08117315173149109}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8223699331283569},{"id":"https://openalex.org/C65236422","wikidata":"https://www.wikidata.org/wiki/Q173740","display_name":"Cartesian product","level":2,"score":0.6410379409790039},{"id":"https://openalex.org/C2780821815","wikidata":"https://www.wikidata.org/wiki/Q5340806","display_name":"Portfolio","level":2,"score":0.6115034222602844},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.5818108320236206},{"id":"https://openalex.org/C181622380","wikidata":"https://www.wikidata.org/wiki/Q26911","display_name":"Profit (economics)","level":2,"score":0.5397070646286011},{"id":"https://openalex.org/C75956513","wikidata":"https://www.wikidata.org/wiki/Q609343","display_name":"Portfolio investment","level":3,"score":0.5048993229866028},{"id":"https://openalex.org/C202655437","wikidata":"https://www.wikidata.org/wiki/Q7231728","display_name":"Portfolio optimization","level":3,"score":0.4715442955493927},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.27614331245422363},{"id":"https://openalex.org/C10138342","wikidata":"https://www.wikidata.org/wiki/Q43015","display_name":"Finance","level":1,"score":0.1784069836139679},{"id":"https://openalex.org/C175444787","wikidata":"https://www.wikidata.org/wiki/Q39072","display_name":"Microeconomics","level":1,"score":0.10728192329406738},{"id":"https://openalex.org/C162324750","wikidata":"https://www.wikidata.org/wiki/Q8134","display_name":"Economics","level":0,"score":0.08188867568969727},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.08117315173149109},{"id":"https://openalex.org/C118615104","wikidata":"https://www.wikidata.org/wiki/Q121416","display_name":"Discrete mathematics","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1007/978-3-642-16952-6_4","is_oa":false,"landing_page_url":"https://doi.org/10.1007/978-3-642-16952-6_4","pdf_url":null,"source":{"id":"https://openalex.org/S106296714","display_name":"Lecture notes in computer science","issn_l":"0302-9743","issn":["0302-9743","1611-3349"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319900","host_organization_name":"Springer Science+Business Media","host_organization_lineage":["https://openalex.org/P4310319900","https://openalex.org/P4310319965"],"host_organization_lineage_names":["Springer Science+Business Media","Springer Nature"],"type":"book series"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Lecture Notes in Computer Science","raw_type":"book-chapter"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":20,"referenced_works":["https://openalex.org/W1505669352","https://openalex.org/W1516760870","https://openalex.org/W1572853913","https://openalex.org/W1710427750","https://openalex.org/W1967136603","https://openalex.org/W2010997253","https://openalex.org/W2029239567","https://openalex.org/W2038865108","https://openalex.org/W2039057778","https://openalex.org/W2117204836","https://openalex.org/W2121551638","https://openalex.org/W2144015438","https://openalex.org/W2151237529","https://openalex.org/W2166029977","https://openalex.org/W2185907055","https://openalex.org/W2232207765","https://openalex.org/W2950156543","https://openalex.org/W2988119170","https://openalex.org/W4285719527","https://openalex.org/W4300567850"],"related_works":["https://openalex.org/W1986311305","https://openalex.org/W4360613713","https://openalex.org/W3125148470","https://openalex.org/W2768197547","https://openalex.org/W2055959038","https://openalex.org/W4206877017","https://openalex.org/W4225528185","https://openalex.org/W4327779378","https://openalex.org/W2795635811","https://openalex.org/W2221832056"],"abstract_inverted_index":null,"counts_by_year":[{"year":2022,"cited_by_count":1},{"year":2012,"cited_by_count":1}],"updated_date":"2026-06-11T09:08:48.828518","created_date":"2025-10-10T00:00:00"}